andreafiandroWallet analysis - tot wallets
Updated 2024-01-19
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
›
⌄
with sender_tb as (
SELECT sender as address, destination_chain
FROM ethereum.defi.ez_bridge_activity
WHERE block_timestamp > '2023-10-01' AND Destination_chain in ('near', 'solana', 'sui', 'osmosis', 'aptos', 'fantom', 'telos','sei','injective')
),
origin_tb as (
SELECT origin_from_address as address, destination_chain
FROM ethereum.defi.ez_bridge_activity
WHERE block_timestamp > '2023-10-01' AND Destination_chain in ('near', 'solana', 'sui', 'osmosis', 'aptos', 'fantom', 'telos','sei','injective')
),
full_tb as (
SELECT * FROM sender_tb
UNION ALL
SELECT * FROM origin_tb
)
SELECT count(DISTINCT address)
FROM full_tb
QueryRunArchived: QueryRun has been archived