mohamadreza221166solend cTokens transfers programs
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_events AS (
SELECT TX_ID
FROM solana.core.fact_transfers
WHERE BLOCK_TIMESTAMP::DATE >= '2022-01-01'
AND mint IN(
'5h6ssFpeDeRbzsEHDbTQNH7nVGgsKrZydxdSTnLm6QdV',
'993dVFL2uXWYeoXuEBFXR4BijeXdTv4s6BzsCjJZuwqk',
'AppJPZka33cu4DyUenFe9Dc1ZmZ3oQju6mBn9k37bNAa',
'Gqu3TFmJXfnfSX84kqbZ5u9JjSBVoesaHjfTsaPjRSnZ',
'4CxGuD2NMr6zM8f18gr6kRhgd748pnmkAhkY1YJtkup1',
'BTsbZDV7aCMRJ3VNy9ygV4Q2UeEo9GpR8D6VvmMZzNr8',
'A38TjtcYrfutXT6nfRxhqwoGiXyzwJsGPmekoZYYmfgP',
'E9LAZYxBVhJr9Cdfi9Tn4GSiJHDWSZDsew5tfgJja6Cu',
'2d95ZC8L5XP6xCnaKx8D5U5eX6rKbboBBAwuBLxaFmmJ',
'4GAGuewTRMfBJukgu3HSzpT48iqP4bYVCq3tygnjqmxL',
'BsWLxf6hRJnyytKR52kKBiz7qU7BB3SH77mrBxNnYU1G',
'3JFC4cB56Er45nWVe29Bhnn5GnwQzSmHVf6eUq9ac91h',
'FbKvdbx5h6F86h1pZuEqv7FxwmsVhJ88cDuSqHvLm6Xf',
'D3Cu5urZJhkKyNZQQq2ne6xSfzbXLU4RrywVErMA2vf8',
'AFq1sSdevxfqWGcmcz7XpPbfjHevcJY7baZf9RkyrzoR',
'QQ6WK86aUCBvNPkGeYBKikk15sUg6aMUEi5PTL6eB4i',
'nZtL8HKX3aQtk3VpdvtdwPpXF2uMia522Pnan2meqdf',
'DiMx1n2dJmxqFtENRPhYWsqi8Mhg2p39MpTzsm6phzMP',
'6XrbsKScacEwpEW5DVNko9t5vW3cim9wktAeT9mmiYHS',
'4icXEpFVMrcqob6fnd3jZ6KjKrc6cqre6do1f8kKAC1u'
)
)
SELECT t2.label || ' : ' || PROGRAM_ID, COUNT(*) as number
FROM solana.core.fact_events t1
left JOIN solana.core.dim_labels t2 on t2.address = t1.PROGRAM_ID
WHERE t1.tx_id IN(SELECT TX_ID FROM solend_events)
GROUP BY 1
ORDER BY 2 DESC
Run a query to Download Data