datavortexwillowy-green
Updated 2024-09-18
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
›
⌄
⌄
⌄
⌄
/*
SELECT
DISTINCT
SPLIT_PART(currency, '.', 3) AS currency,
sum(price)
FROM
flow.nft.ez_nft_sales
GROUP BY currency
*/
/*
SELECT DISTINCT
SPLIT_PART(marketplace, '.', 3) AS market place
FROM
flow.nft.ez_nft_sales;
*/
/*
SELECT COUNT(DISTINCT symbol),
--price
FROM
flow.price.ez_prices_hourly
*/
WITH token_amounts AS (
SELECT
tx_id,
-- Extract amounts from tokenflow
SUM(CASE
WHEN tokenflow = 'TokensWithdrawn' THEN amount
WHEN tokenflow = 'TokensDeposited' THEN amount
WHEN tokenflow = 'ForwardedDeposit' THEN amount
ELSE 0
END) AS total_amount
FROM flow.nft.ez_nft_sales
GROUP BY tx_id
),
QueryRunArchived: QueryRun has been archived