Drsimon2024-07-18 05:28 PM
    Updated 2024-10-30
    --https://warpcast.com/~/channel/ogs
    --https://warpcast.com/hony
    --https://warpcast.com/ciniz

    select
    PLATFORM_NAME,
    DATE_TRUNC('{{Time_frame}}', block_timestamp) AS DATE,

    avg(price_usd) as "Total trading volume (USD)",

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

    from base.nft.ez_nft_sales
    where nft_address = lower('0xA449b4f43D9A33FcdCF397b9cC7Aa909012709fD')
    and price <= '10'
    and price <> '0'
    group by 1,2
    order by 1 desc
    QueryRunArchived: QueryRun has been archived