scottincryptoPolygon Token Transfers for data platform
    Updated 2023-03-03
    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