mohamadreza221166cTokens transaction types since last 30 days
Updated 2022-08-04
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 solend_trans AS(
SELECT DISTINCT tx_id, VALUE:mint AS mint
-- VALUE:owner AS wallet,
-- VALUE:uiTokenAmount:uiAmount AS amount
FROM solana.core.fact_transactions , table (flatten (input => POST_TOKEN_BALANCES)) AS tbl
WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 30
AND mint IN(
'5h6ssFpeDeRbzsEHDbTQNH7nVGgsKrZydxdSTnLm6QdV',
'993dVFL2uXWYeoXuEBFXR4BijeXdTv4s6BzsCjJZuwqk',
'AppJPZka33cu4DyUenFe9Dc1ZmZ3oQju6mBn9k37bNAa',
'Gqu3TFmJXfnfSX84kqbZ5u9JjSBVoesaHjfTsaPjRSnZ',
'4CxGuD2NMr6zM8f18gr6kRhgd748pnmkAhkY1YJtkup1',
'BTsbZDV7aCMRJ3VNy9ygV4Q2UeEo9GpR8D6VvmMZzNr8',
'A38TjtcYrfutXT6nfRxhqwoGiXyzwJsGPmekoZYYmfgP',
'E9LAZYxBVhJr9Cdfi9Tn4GSiJHDWSZDsew5tfgJja6Cu',
'2d95ZC8L5XP6xCnaKx8D5U5eX6rKbboBBAwuBLxaFmmJ',
'4GAGuewTRMfBJukgu3HSzpT48iqP4bYVCq3tygnjqmxL',
'BsWLxf6hRJnyytKR52kKBiz7qU7BB3SH77mrBxNnYU1G',
'3JFC4cB56Er45nWVe29Bhnn5GnwQzSmHVf6eUq9ac91h',
'FbKvdbx5h6F86h1pZuEqv7FxwmsVhJ88cDuSqHvLm6Xf',
'D3Cu5urZJhkKyNZQQq2ne6xSfzbXLU4RrywVErMA2vf8',
'AFq1sSdevxfqWGcmcz7XpPbfjHevcJY7baZf9RkyrzoR',
'QQ6WK86aUCBvNPkGeYBKikk15sUg6aMUEi5PTL6eB4i',
'nZtL8HKX3aQtk3VpdvtdwPpXF2uMia522Pnan2meqdf',
'DiMx1n2dJmxqFtENRPhYWsqi8Mhg2p39MpTzsm6phzMP',
'6XrbsKScacEwpEW5DVNko9t5vW3cim9wktAeT9mmiYHS',
'4icXEpFVMrcqob6fnd3jZ6KjKrc6cqre6do1f8kKAC1u'
)
),
solend_events AS (
SELECT BLOCK_TIMESTAMP,
VALUE:instructions:parsed:type AS type,
VALUE:instructions:parsed:amount AS amount
FROM solana.core.fact_events , table (flatten (input=> INNER_INSTRUCTION)) AS tbl
WHERE tx_id IN(SELECT distinct tx_id FROM solend_trans )
)
Run a query to Download Data