Drsimonkem 6 daily
    Updated 2024-12-30
    --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 2 months 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
    2024-12-30 00:00:00.0000.22030.238760350.254.2976863
    1
    62B
    8s