rackhaelPYTH - USAGE ON EVM CHAINS
Updated 2024-06-29
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
›
⌄
SELECT --'BASE' AS chain,
count(*) --(distinct from_address) AS unique_contract_addresses
FROM base.core.fact_traces
WHERE to_address = lower('0x8250f4aF4B972684F7b336503E2D6dFeDeB1487a')
AND trace_status = 'success'
-- UNION ALL
-- SELECT 'BNB' AS chain, count(distinct "from") AS unique_contract_addresses
-- FROM bnb.traces t
-- WHERE t."to" = '0x4D7E825f80bDf85e913E0DD2A2D54927e9dE1594' AND t.success
-- UNION ALL
-- SELECT 'FANTOM' AS chain, count(distinct "from") AS unique_contract_addresses
-- FROM fantom.traces t
-- WHERE t."to" = '0xff1a0f4744e8582DF1aE09D5611b887B6a12925C' AND t.success
-- UNION ALL
-- SELECT 'zkSYNC' AS chain, count(distinct "from") AS unique_contract_addresses
-- FROM zksync.traces t
-- WHERE t."to" = '0xf087c864AEccFb6A2Bf1Af6A0382B0d0f6c5D834' AND t.success
-- UNION ALL
-- SELECT 'SCROLL' AS chain, count(distinct "from") AS unique_contract_addresses
-- FROM scroll.traces t
-- WHERE t."to" = '0xA2aa501b19aff244D90cc15a4Cf739D2725B5729' AND t.success
-- UNION ALL
-- SELECT 'LINEA' AS chain, count(distinct "from") AS unique_contract_addresses
-- FROM linea.traces t
-- WHERE t."to" = '0xA2aa501b19aff244D90cc15a4Cf739D2725B5729' AND t.success
QueryRunArchived: QueryRun has been archived