Mrfti2024-04-05 06:55 PM
Updated 2024-04-18Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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