Drsimon2024-07-18 05:28 PM
Updated 2024-10-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
--https://warpcast.com/~/channel/ogs
--https://warpcast.com/hony
--https://warpcast.com/ciniz
select
PLATFORM_NAME,
DATE_TRUNC('{{Time_frame}}', block_timestamp) AS DATE,
avg(price_usd) as "Total trading volume (USD)",
avg(price) as "Total trading volume (ETH)"
from base.nft.ez_nft_sales
where nft_address = lower('0xA449b4f43D9A33FcdCF397b9cC7Aa909012709fD')
and price <= '10'
and price <> '0'
group by 1,2
order by 1 desc
QueryRunArchived: QueryRun has been archived