mohamadreza221166Most popular stablecoins and non-stablecoins on swimming protocol
Updated 2022-07-27
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
›
⌄
WITH
swims AS(
SELECT DISTINCT TX_ID
FROM solana.core.fact_events
WHERE PROGRAM_ID = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'
AND SUCCEEDED = 'TRUE'
AND BLOCK_TIMESTAMP::DATE > '2022-06-01'
),
trans AS(
SELECT value:mint AS mint
FROM solana.core.fact_transactions, table (flatten (input=> pre_token_balances))
WHERE TX_ID IN(SELECT TX_ID FROM swims)
)
SELECT label AS coin, COUNT(*) AS number_of_usage
FROM trans t1
JOIN solana.core.dim_labels t2 on t2.address = t1.mint
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10
SELECT CURRENT_DATE
-- WITH swims AS(
-- SELECT BLOCK_TIMESTAMP,
-- INNER_INSTRUCTION:instructions[0]:parsed:info:source AS wallet,
-- INNER_INSTRUCTION:instructions[1]:parsed:info:amount AS amount,
-- INNER_INSTRUCTION:instructions[1]:parsed:info:authority AS authority,
-- amount / 1e6 AS amount_USD
-- FROM solana.core.fact_events
-- WHERE PROGRAM_ID = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'
-- AND SUCCEEDED = 'TRUE'
Run a query to Download Data