ramishoow2023-02-16 04:11 PM
    Updated 2023-02-16
    select sum(raw_amount/pow(10,8)) as "Total volume of transfers ", avg(raw_amount/pow(10,8)) as "Average volume of transfers " ,
    median(raw_amount/pow(10,8)) as "Median volume of transfers " , count(distinct tx_hash)as "Total number of transfers" ,
    block_timestamp::date from avalanche.core.fact_token_transfers
    where block_timestamp::date >= '2023-01-01' and contract_address in ('0x152b9d0fdc40c096757f570a51e494bd4b943e50','0x50b7545627a5162f82a992c33b87adc75187b218')
    --'0x152b9d0fdc40c096757f570a51e494bd4b943e50','0x50b7545627a5162f82a992c33b87adc75187b218'
    group by 5
    Run a query to Download Data