KingTigerMafia-7mwRZbUntitled Query
Updated 2022-09-15
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
28
29
30
31
32
33
34
35
36
›
⌄
-- flow metrics
with flow_price as (
select timestamp::date as date, avg(price_usd) as price
from flow.core.fact_prices
where token_contract = 'A.1654653399040a61.FlowToken' and date >= '2022-04-20'
group by 1
order by 1 asc
)
select block_timestamp::date as date, count(DISTINCT BUYER) as num_buyer, sum(price) as total_sales_price_per_day, avg(price) as avg_sales_price_per_day, count(nft_collection) as num_nft_sell_per_day
from flow.core.ez_nft_sales
where date >= '2022-04-20' and tx_succeeded = 'TRUE'
group by 1
order by 1 asc
-- NUM SELLER
select block_timestamp::date as date, count(distinct seller) as num_seller
from flow.core.ez_nft_sales
where date >= '2022-04-20' and tx_succeeded = 'TRUE'
group by 1
order by 1 asc
select block_timestamp::date as date, count(distinct seller_address) as num_seller
from ethereum.core.ez_nft_sales
where date >= '2022-04-20' and event_type = 'sale'
group by 1
order by 1
select block_timestamp::date as date, count(distinct seller) as num_seller
from solana.core.fact_nft_sales
where date >= '2022-04-20' and succeeded = 'TRUE'
group by 1
order by 1 asc
Run a query to Download Data