headitmanagerDaily Transactions on Flow
    Updated 2022-06-25
    with nft_sales as (select count(*),sum(price),block_timestamp::date from flow.core.fact_nft_sales
    where block_timestamp::date >= '2022-04-16'
    group by block_timestamp::date)
    ,nft_sales1 as (select count(*),sum(price),monthname(block_timestamp::date) from flow.core.fact_nft_sales
    where block_timestamp::date >= '2022-04-16'
    group by monthname(block_timestamp::date))
    , flow_transactions as (select count(*),block_timestamp::date from flow.core.fact_transactions
    where block_timestamp::date >= '2022-04-16'
    group by block_timestamp::date)
    , flow_swap as (select count(*),block_timestamp::date from flow.core.fact_swaps
    where block_timestamp::date >'2022-04-16'
    group by block_timestamp::date)
    ,shot as (select count(*),block_timestamp::date from flow.core.fact_nft_sales where nft_collection='A.0b2a3299cc857e29.TopShot'
    and block_timestamp::date >'2022-04-16'
    group by block_timestamp::date)
    ,shot1 as (select count(*),monthname(block_timestamp::date) from flow.core.fact_nft_sales where nft_collection='A.0b2a3299cc857e29.TopShot'
    and block_timestamp::date >'2022-04-16'
    group by monthname(block_timestamp::date))
    select * from flow_transactions
    Run a query to Download Data