Eman-RazToken Transfers
    Updated 2023-03-19
    select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", count(distinct tx_from) as "Sender", count(distinct tx_to) as "Receiver", count(distinct tx_id) as "Transfer", case
    when mint='poLisWXnNRwC6oBu1vHiuKQzFjGL4XDSu4g9qjz9qVk' then 'POLIS'
    when mint='ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then 'ATLAS'
    end as "Symbol"
    from solana.core.fact_transfers
    where mint in ('poLisWXnNRwC6oBu1vHiuKQzFjGL4XDSu4g9qjz9qVk','ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx')
    group by 1,5
    order by 1

    Run a query to Download Data