Mrfti2024-04-05 06:55 PM
    Updated 2024-04-18
    SELECT
    --date_trunc (day, block_timestamp) as date,
    count (DISTINCT tx_hash) as "Total trades",
    sum (platform_fee) as "Total platform fee (ETH)",
    sum (creator_fee) as "Total creator fee (ETH)",
    sum (total_fees) as "Total fees (ETH)",
    sum (tx_fee) as "Total transaction fee (ETH)",
    sum (platform_fee_usd) as "Total platform fee (USD)",
    sum (creator_fee_usd) as "Total creator fee (USD)",
    sum (total_fees_usd) as "Total fees (USD)",
    sum (tx_fee_usd) as "Total transaction fee (USD)",
    count (DISTINCT ORIGIN_FROM_ADDRESS) as "Total users",
    sum (price_usd) as "Total trading volume (USD)",
    sum (price) as "Total trading volume (ETH)"

    from base.nft.ez_nft_sales
    where nft_address = lower ('0xA449b4f43D9A33FcdCF397b9cC7Aa909012709fD')
    QueryRunArchived: QueryRun has been archived