Drsimononchain gaias t
    Updated 2025-01-17
    --https://warpcast.com/~/channel/ogs
    --https://warpcast.com/hony
    --https://warpcast.com/ciniz

    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('0xA449b4f43D9A33FcdCF397b9cC7Aa909012709fD')
    and price <= '100'
    and price <> '0'

    Last run: about 1 month agoAuto-refreshes every 12 hours
    Total trades
    Total users
    Total trading volume (USD)
    Total trading volume (ETH)
    TOTAL FEES (ETH)
    TOTAL FEES (USD)
    1
    8169340921632813.71632636350.102715635223.378187405761163.880817944
    1
    76B
    929s