Mitygmt transfer
Updated 2023-03-15
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select BLOCK_TIMESTAMP::date as date,sum(AMOUNT)as gmt_transfer_volume, count(distinct TX_FROM)as unique_user_Transmitter
,count(distinct TX_TO)as gmt_unique_user_recevier
,sum(gmt_transfer_volume) over (order by date asc)as gmt_total_transfer_volume
,sum(unique_user_Transmitter) over (order by date asc)as gmt_total_unique_Transmitter
,sum(gmt_unique_user_recevier) over (order by date asc)as gmt_total_unique_user_recevier
from solana.core.fact_transfers
where MINT ='7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
and date>=current_date-60
group by 1
Run a query to Download Data