amelia-leeUntitled Query
Updated 2022-07-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
date_trunc('day', block_timestamp) as day,
COUNT(tx_hash) as total_trasnactions,
sum(total_trasnactions) over (ORDER BY DAY) as cum_tx
FROM polygon.core.fact_event_logs
WHERE origin_to_address IN (
'0xf715beb51ec8f63317d66f491e37e7bb048fcc2d', '0xfede379e48c873c75f3cc0c81f7c784ad730a8f7'
)
AND event_name IN (
'TransferBatch' , 'TransferSingle'
)
AND tx_status = 'SUCCESS'
GROUP BY 1
--Second
Run a query to Download Data