shahdadi-9ptm8Ynumber of nft sales in flow - solana - ethereum over time
    Updated 2022-06-12
    with a as(select
    date_trunc('day',block_timestamp) date,
    count(tx_id) flow_sales
    from flow.core.fact_nft_sales
    where date >='2022-01-01'
    group by DATE
    ),b as(
    select
    date_trunc('day',block_timestamp) date,
    count(tx_id) solana_sales
    from solana.core.fact_nft_sales
    where date>='2022-01-01'
    group by date
    ),c as(
    select
    date_trunc('day',block_timestamp) date,
    count(tx_hash) ethereum_sale
    from ethereum.core.ez_nft_sales
    where date>='2022-01-01'
    group by date
    )
    select a.date,flow_sales,solana_sales,ethereum_sale
    from a
    join b on a.date=b.date
    join c on a.date=c.date
    Run a query to Download Data