Drsimonkem 6 daily
    Updated 2025-03-21
    --https://warpcast.com/hony


    select
    block_timestamp::date AS day,

    min(price) as "Lowest selling price (floor price (ETH))",
    avg(price) as "Average selling price (ETH)",
    max(price) as "Highest selling price ETH)",

    sum(price) as "Total trading volume (ETH)"


    from base.nft.ez_nft_sales
    where nft_address = lower('0xee7d1b184be8185adc7052635329152a4d0cdefa')
    and price <= '100'
    and price <> '0'
    group by 1
    order by 1 desc
    limit 1
    Last run: about 1 month agoAuto-refreshes every 12 hours
    DAY
    Lowest selling price (floor price (ETH))
    Average selling price (ETH)
    Highest selling price ETH)
    Total trading volume (ETH)
    1
    2025-03-21 00:00:00.0000.082559980.088373323330.10.26511997
    1
    69B
    2s