mohamadreza221166Untitled Query
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
›
⌄
-- WITH swims AS(
-- SELECT
-- INNER_INSTRUCTION:instructions[0]:parsed:info:source AS wallet,
-- INNER_INSTRUCTION:instructions[1]:parsed:info:amount AS amount,
-- amount / 1e6 AS amount_USD
-- FROM solana.core.fact_events
-- WHERE PROGRAM_ID = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'
-- AND SUCCEEDED = 'TRUE'
-- )
-- SELECT wallet, sum(amount_USD) AS amount_USD
-- FROM swims
-- WHERE wallet IS NOT NULL
-- -- AND mint IS NOT NULL
-- GROUP BY 1
-- ORDER BY 2 DESC
-- LIMIT 50
-- select pre_token_balances from solana.core.fact_transactions where tx_id = '5ii8QJxoUiBvRQEtTxbDCNqmH97GxhDT2W6YQe8Mu8kKKG3wR7QdCavAAcmHLVtQYNSCgQ8NMM6z4nYCteLwzfk8'
WITH trans as(
select value:mint as mint_ --, value:owner, value:uiTokenAmount:amount, value:uiTokenAmount:uiAmountString
from solana.core.fact_transactions, table (flatten (input=> pre_token_balances))
where tx_id = '5ii8QJxoUiBvRQEtTxbDCNqmH97GxhDT2W6YQe8Mu8kKKG3wR7QdCavAAcmHLVtQYNSCgQ8NMM6z4nYCteLwzfk8'
)
select t1.*, label
from trans t1
left join solana.core.dim_labels t2 on t2.address = t1.mint_
Run a query to Download Data