headitmanagerMNDE volume over time
    Updated 2022-05-17
    with deposited as (select swap_program , sum(swap_from_amount)from solana.fact_swaps where
    SWAP_FROM_MINT='MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and succeeded=1
    group by swap_program)

    , deposited_overtime as (select sum(swap_from_amount),block_timestamp::date,swap_program from solana.fact_swaps where
    SWAP_FROM_MINT='MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and succeeded=1
    group by block_timestamp::date,swap_program)

    , pools as (select sum(swap_from_amount) as amount,concat('MNDE','/', ADDRESS_NAME) as pool
    from solana.fact_swaps inner join solana.dim_labels on solana.dim_labels.address=solana.fact_swaps.swap_to_mint
    where
    SWAP_FROM_MINT='MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and succeeded=1
    group by pool
    order by amount desc
    limit 10)

    , pools_overtime as (select sum(swap_from_amount) as amount,block_timestamp::date,concat('MNDE','/', ADDRESS_NAME) as pool
    from solana.fact_swaps inner join solana.dim_labels on solana.dim_labels.address=solana.fact_swaps.swap_to_mint
    where
    SWAP_FROM_MINT='MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and succeeded=1
    group by block_timestamp::date,pool)

    , MNDE_volume as (select sum(swap_from_amount) as amount,block_timestamp::date
    from solana.fact_swaps
    where SWAP_FROM_MINT='MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and succeeded=1
    group by block_timestamp::date)

    , MNDE_count as (select count(1) as amount,block_timestamp::date
    from solana.fact_swaps
    where SWAP_FROM_MINT='MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and succeeded=1
    group by block_timestamp::date)
    select * from MNDE_volume
    Run a query to Download Data