scottincryptoPolygon Token Transfers for data platform
Updated 2023-03-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
date_trunc('day', block_timestamp) as block_day
-- , event_name
-- , count(tx_hash)
, *
from polygon.core.fact_event_logs
where contract_address = lower('0x1a13f4ca1d028320a707d99520abfefca3998b7f')
-- and block_timestamp > '2023-03-01'
and block_number between 38448179 and 38487931
and topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and (topics[1] = lower('0x0000000000000000000000007734280a4337f37fbf4651073db7c28c80b339e9')
or topics[2] = lower('0x0000000000000000000000007734280a4337f37fbf4651073db7c28c80b339e9'))
-- group by block_day, event_name
order by block_number, event_index
Run a query to Download Data