amelia-leeUntitled Query
    Updated 2022-07-30
    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