Total trades | Total users | Total trading volume (USD) | Total trading volume (ETH) | TOTAL FEES (ETH) | TOTAL FEES (USD) | |
---|---|---|---|---|---|---|
1 | 8169 | 3409 | 21632813.7163263 | 6350.102715635 | 223.378187405 | 761163.880817944 |
Drsimononchain gaias t
Updated 2025-01-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
--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
1
76B
929s