DrsimonCity 1
Updated 2024-07-06
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
27
›
⌄
--https://warpcast.com/~/channel/ogs
--https://warpcast.com/hony
--https://warpcast.com/ciniz
select
PLATFORM_NAME,
DATE_TRUNC('{{Time_frame}}', block_timestamp) AS DATE,
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)"
from base.nft.ez_nft_sales
where nft_address = lower('0x5470da6d5b35c4a0be5243822db7cf6f861f13e6')
and price <= '10'
and price <> '0'
group by 1,2
order by 1 desc
QueryRunArchived: QueryRun has been archived