LittlerDataUntitled Query
    Updated 2022-09-18
    with ethereum as (
    select
    date_trunc('day',block_timestamp) as DAY
    ,count(*) as sales
    ,'Ethereum' as blockchain
    from ethereum.core.ez_nft_sales
    group by 1, 3
    ),

    algorand as (
    select
    date_trunc('day',block_timestamp) as DAY
    ,count(*) as sales
    ,'Algorand' as blockchain
    from flipside_prod_db.algorand.nft_sales
    group by 1, 3
    ),

    flow as (
    select
    date_trunc('day',block_timestamp) as DAY
    ,count(*) as sales
    ,'Flow' as blockchain
    from flow.core.ez_nft_sales
    group by 1, 3)

    select
    *
    from ethereum

    union all

    select
    *
    from algorand

    Run a query to Download Data