LoriYagami-3606Sol USDC 5
    Updated 2022-10-08
    SELECT
    date_trunc('day',block_timestamp) as day,
    address_name as platform,
    count(tx_id) as tx_count,
    sum(amount) as sales_volume,
    sum (sales_volume) over (order by day) as cum_sales_volume
    from solana.core.fact_transfers a
    join solana.core.dim_labels b
    on a.tx_to= b.address
    where label_type not in ('nft','token')
    and mint ='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    and day >= CURRENT_DATE - 90
    group by 1,2

    Run a query to Download Data