ramishoowRealms vs Snapshot
Updated 2022-08-31
9
1
2
3
4
›
⌄
--from ethereum.core.ez_snapshot WHERE VOTE_TIMESTAMP >= '2022-01-01' GROUP BY weekly ORDER BY weekly
SELECT date_trunc('day', VOTE_TIMESTAMP) as weekly, COUNT (DISTINCT ID) as transaction_number, SUM (transaction_number) over (ORDER BY weekly) as transaction_number_growth
from ethereum.core.ez_snapshot WHERE VOTE_TIMESTAMP >= '2022-01-01' GROUP BY weekly ORDER BY weekly
--(daily transaction snapshot)
Run a query to Download Data