KaskoazulAlgorand NFT Marketplaces (2)
    Updated 2022-11-10
    with nft_sales_timeframe as (
    select s.*,
    datediff('hour', s.block_timestamp, current_timestamp) as hour_diff,
    total_sales_amount*p.price_usd as total_sales_amount_usd
    from algorand.nft.ez_nft_sales s
    left join algorand.defi.ez_price_pool_balances p
    on date_trunc('hour', s.block_timestamp) = p.block_hour
    where s.block_timestamp > CURRENT_DATE - 1 - {{Last_number_of_days}}
    )

    select nft_marketplace,
    count(distinct tx_group_id) as sales,
    count(distinct purchaser) as purchasers,
    round(sum(total_sales_amount)) as volume,
    round(sum(total_sales_amount_usd)) as volume_usd,
    round(avg(total_sales_amount)) as average_price
    from nft_sales_timeframe
    group by 1
    order by 1
    Run a query to Download Data