Pine AnalyticsPyth Entropy
Updated 2024-06-30
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
›
⌄
-- forked from Pyth en @ https://flipsidecrypto.xyz/edit/queries/2f42bb89-8018-4012-92ef-1d58c74051d0
SELECT
*
FROM (
SELECT
from_address as wallet,
'Arbitrum' as chain,
count(DISTINCT tx_hash) as transactions
FROM arbitrum.core.fact_transactions
WHERE TO_ADDRESS LIKE lower('0x7698E925FfC29655576D0b361D75Af579e20AdAc')
GROUP BY 1,2
UNION all
SELECT *
--from_address as wallet,
--'Blast' as chain,
--count(DISTINCT tx_hash) as transactions
FROM blast.core.fact_transactions
WHERE to_address LIKE lower('0x5744Cbf430D99456a0A8771208b674F27f8EF0Fb')
--GROUP BY 1,2
LIMIT 100
UNION all
SELECT
from_address as wallet,
'Optimism' as chain,
count(DISTINCT tx_hash) as transactions
FROM optimism.core.fact_transactions
WHERE to_address LIKE lower('0xdF21D137Aadc95588205586636710ca2890538d5')
GROUP BY 1,2
QueryRunArchived: QueryRun has been archived