i_dan2024-07-03 05:15 PM
    Updated 2024-08-13
    SELECT
    COUNT(tx_hash) AS total_sales
    , SUM(price_usd) AS volume

    FROM base.nft.ez_nft_sales
    WHERE nft_address = lower('0x217Ec1aC929a17481446A76Ff9B95B9a64F298cF')










    --SELECT
    -- MIN(LAST_ACTIVITY_BLOCK_TIMESTAMP) as date,
    -- USER_ADDRESS,
    -- MAX(current_bal) as max
    --
    --FROM ethereum.core.ez_current_balances
    --
    --WHERE contract_address = lower('0x217Ec1aC929a17481446A76Ff9B95B9a64F298cF')
    --GROUP BY 2
    --
    --ORDER BY 3 DESC
    QueryRunArchived: QueryRun has been archived