Drsimonkem 4 t
    Updated 2024-12-31
    --https://warpcast.com/hony


    select
    ---block_timestamp::date AS day,
    count (DISTINCT tx_hash) as "Total trades",
    count(DISTINCT ORIGIN_FROM_ADDRESS) as "Total users",

    min(price_usd) as "Min trading volume (USD)",
    avg(price_usd) as "Avg trading volume (USD)",
    max(price_usd) as "Max trading volume (USD)",
    sum(price_usd) as "Total trading volume (USD)",

    min(price) as "Min trading volume (ETH)",
    avg(price) as "Avg trading volume (ETH)",
    max(price) as "Max trading volume (ETH)",

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

    sum(TOTAL_FEES) as "TOTAL FEES (ETH)",
    sum(TOTAL_FEES_USD) as "TOTAL FEES (USD)"


    from base.nft.ez_nft_sales
    where nft_address = lower('0xEe7D1B184be8185Adc7052635329152a4d0cdEfA')
    and price <= '100'
    and price <> '0'
    Last run: about 2 months agoAuto-refreshes every 12 hours
    Total trades
    Total users
    Min trading volume (USD)
    Avg trading volume (USD)
    Max trading volume (USD)
    Total trading volume (USD)
    Min trading volume (ETH)
    Avg trading volume (ETH)
    Max trading volume (ETH)
    Total trading volume (ETH)
    TOTAL FEES (ETH)
    TOTAL FEES (USD)
    1
    737429120.304394257.0480390045671.91042819559.939834480.00010.0810510214138889.0486538430.31943365399831.239836817
    1
    129B
    4s