kasadeghUntitled Query
    Updated 2022-11-22

    SELECT
    'polygon' as chain,
    sum(raw_amount/power(10,6)) as total_volume,
    avg(raw_amount/power(10,6)) as avg_volume,
    median(raw_amount/power(10,6)) as median_volume,
    count(distinct TX_HASH) as tx_count,
    count(DISTINCT FROM_ADDRESS) as senders_cnt,
    count(DISTINCT TO_ADDRESS) as receivers_cnt

    FROM polygon.core.fact_token_transfers
    where contract_address =lower('0x2791Bca1f2de4661ED88A30C99A7a9449Aa84174')
    AND block_timestamp::date >='{{start_time}}' and block_timestamp::date <='{{end_date}}'
    and raw_amount/power(10,6)!=0
    GROUP BY 1

    Run a query to Download Data