StangFASTusd volume
Updated 2023-09-07
999
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
›
⌄
-- forked from transactions @ https://flipsidecrypto.xyz/edit/queries/bf80d1a1-23f7-495a-8fbd-19c2ac3108a5
-- forked from age @ https://flipsidecrypto.xyz/edit/queries/fde3395d-e379-47ad-9044-792174c8482a
-- forked from 04 - token used @ https://flipsidecrypto.xyz/edit/queries/84c11d31-61ee-4dee-a9b5-8c39f29bb8e3
-- forked from 04 - sale number @ https://flipsidecrypto.xyz/edit/queries/372421dc-d7c5-43b2-9887-58692bf649f9
-- forked from 03 - sale over view @ https://flipsidecrypto.xyz/edit/queries/0d8d18b5-5645-4ff6-9e89-de549a8dc2e9
with
price_token AS
(
SELECT
date_trunc( 'day' , a.recorded_hour ) AS day
, avg( a.close ) AS price
, a.id AS id_token
, a.token AS token
FROM
flow.core.fact_hourly_prices a
GROUP BY 1 , 3 , 4
ORDER BY 1
)
,
min1 AS
(
SELECT
a.buyer AS new_user
, min( a.block_timestamp ) AS min_date
FROM
flow.core.ez_nft_sales a
JOIN
price_token b
ON a.block_timestamp::date = b.day
AND a.currency = b.id_token
Run a query to Download Data