Mitygmt transfer
    Updated 2023-03-15
    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