mattkstewFlow During Market Downturn 2
    Updated 2022-06-24
    with tab1 as (
    select
    date_trunc('day', block_timestamp) as date1,
    count(*) as Flow_sales
    from flow.core.fact_nft_sales
    group by 1 )

    , tab2 as (
    select
    date_trunc('day', block_timestamp) as date2,
    count(*) as Solana_sales
    from solana.core.fact_nft_sales
    group by 1 )

    select
    date1,
    Flow_sales,
    Solana_sales
    from tab1 left outer join tab2 on date1 = date2
    where date1 > '2022-04-01'
    Run a query to Download Data