BlockTrackerDFK bridge
Updated 2023-09-27
999
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
contract_address,
count(1)
FROM avalanche.core.ez_decoded_event_logs
WHERE decoded_log:chainId LIKE '53935'
GROUP BY 1
-- out_put : contract_address = '0xc05e61d0e7a63d27546389b7ad62fdff5a91aace'
SELECT
decoded_log:token,
count(1)
FROM avalanche.core.ez_decoded_event_logs
WHERE decoded_log:chainId LIKE '53935'
GROUP BY 1
--output : token1 = '0x997ddaa07d716995de90577c123db411584e5e46' count = 9901
-- token2 = '0x19e1ae0ee35c0404f835521146206595d37981ae' count = 596
-- token3 = '0xcfc37a6ab183dd4aed08c204d1c2773c0b1bdf46' count = 3461
-- token4 = '0x152b9d0fdc40c096757f570a51e494bd4b943e50' count = 502
-- token5 = '0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7' count = 39066
SELECT event_name,
count(1)
FROM avalanche.core.ez_decoded_event_logs
WHERE decoded_log:chainId LIKE '53935'
--AND contract_address ='0xc05e61d0e7a63d27546389b7ad62fdff5a91aace'
GROUP BY 1
--output : TokenRedeem , count = 13958
-- TokenDeposit , count = 39566
*/
-- add to table below new users and token price
Run a query to Download Data