ramishoow2023-02-16 04:11 PM
Updated 2023-02-16
9
1
2
3
4
5
6
›
⌄
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