mo115NFT sales past 60 days
    Updated 2022-07-19
    ( select date_trunc('day',BLOCK_TIMESTAMP) as date,
    count(TX_ID) as NFTs,
    count(distinct BUYER) as buyers,
    count(distinct SELLER) as SELLERs,
    (NFTs/buyers) as average_buy,
    (NFTs/SELLERs)*-1 as average_sell,
    'FLOW' as network
    from flow.core.fact_nft_sales
    where date > CURRENT_DATE - 60
    group by 1)
    UNION
    (select date_trunc('day',BLOCK_TIMESTAMP) as date,
    count(TX_ID) as NFTs,
    count(distinct PURCHASER) as buyers,
    count(distinct SELLER) as SELLERs,
    (NFTs/buyers) as average_buy,
    (NFTs/SELLERs)*-1 as average_sell,
    'SOLANA' as network
    from solana.core.fact_nft_sales
    where date > CURRENT_DATE - 60
    group by 1)
    UNION
    ( select date_trunc('day',BLOCK_TIMESTAMP) as date,
    count(TX_HASH) as NFTs,
    count(distinct BUYER_ADDRESS) as buyers,
    count(distinct SELLER_ADDRESS) as SELLERs,
    (NFTs/buyers) as average_buy,
    (NFTs/SELLERs)*-1 as average_sell,
    'ETHEREUM' as network
    from ethereum.core.ez_nft_sales
    where date > CURRENT_DATE - 60
    group by 1)
    Run a query to Download Data