We’ve built a way to pull exact parts of on-chain data you need with @quicknode Streams and Filters. Here's how you'd build a pipeline to get all ERC transfers paying less than $1 a day, streamed right to your database or webhooks:
1 reply
4 recasts
5 reactions
Just released PostgreSQL and Snowflake support in QuickNode Streams for quicker and faster way to filter, aggregate, and analyze on-chain data. Check out supported datasets here: https://www.quicknode.com/docs/streams/data-sources#evm-dataset-schema
0 replies
1 recast
2 reactions
Top casts
Just released PostgreSQL and Snowflake support in QuickNode Streams for quicker and faster way to filter, aggregate, and analyze on-chain data. Check out supported datasets here: https://www.quicknode.com/docs/streams/data-sources#evm-dataset-schema
0 replies
1 recast
2 reactions
We’ve built a way to pull exact parts of on-chain data you need with @quicknode Streams and Filters. Here's how you'd build a pipeline to get all ERC transfers paying less than $1 a day, streamed right to your database or webhooks:
1 reply
4 recasts
5 reactions
You will need:
1. Streams (Block with receipts dataset): https://dashboard.quicknode.com/streams/new?dataset=block_with_receipts
2. Filter code matching ERC ABIs: https://pastebin.com/ex882XNp
3. A destination ready to ingest Streams data: PostgreSQL, Webhooks, S3, Snowflake
1 reply
0 recasts
1 reaction
Streams loads this filtered data into your destination, ensuring exactly once unduplicated ordered delivery.
With this filtered data, you can:
- Track token transfers across different ERC standards (ERC20, ERC721, ERC1155)
- Analyze transaction patterns and volumes
- Monitor specific addresses and contract
