hbd1994Buyers Distribution | Purchases Volume (USD)
    Updated 2022-12-05
    with maintable as (with table1 as ((
    select
    tx_id,
    block_timestamp,
    MARKETPLACE,
    NFT_COLLECTION,
    NFT_ID,
    buyer,
    seller,
    currency,
    price,
    (price*1) as usd_amount,
    date(block_timestamp) as date0,
    hour(block_timestamp) as hour0,
    minute(block_timestamp) as min0
    from flow.core.ez_nft_sales
    where TX_SUCCEEDED = true
    and currency != 'A.1654653399040a61.FlowToken')
    union
    (with tab1 as (select
    tx_id,
    block_timestamp,
    MARKETPLACE,
    NFT_COLLECTION,
    NFT_ID,
    buyer,
    seller,
    currency,
    price,
    date(block_timestamp) as date0,
    hour(block_timestamp) as hour0,
    minute(block_timestamp) as min0
    from flow.core.ez_nft_sales
    where TX_SUCCEEDED = true
    and currency = 'A.1654653399040a61.FlowToken'),
    price as (select