Lordking/./
Updated 2022-11-03
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 block_timestamp::date as date,'optimism' as title ,
count (distinct tx_hash) as Swaps_Count,
count (distinct origin_from_address) as Swappers_Count
from optimism.core.fact_event_logs t1
where t1.origin_to_address = lower('0x6352a56caadc4f1e25cd6c75970fa768a3304e64')
and event_name = 'Swap'
group by 1,2
union
select block_timestamp::date as date,'arbitrum' as title ,
count (distinct tx_hash) as Swaps_Count,
count (distinct origin_from_address) as Swappers_Count
from arbitrum.core.fact_event_logs t1
where t1.origin_to_address = lower('0x6352a56caadc4f1e25cd6c75970fa768a3304e64')
and event_name = 'Swap'
group by 1,2
union
select block_timestamp::date as date,'bsc' as title ,
count (distinct tx_hash) as Swaps_Count,
count (distinct origin_from_address) as Swappers_Count
from bsc.core.fact_event_logs t1
where t1.origin_to_address in ('0x6352a56caadc4f1e25cd6c75970fa768a3304e64','0x6679800c37e2f7eb072a7af3fb3b81b17a0af153')
and event_name = 'Swap'
group by 1,2
union
select block_timestamp::date as date,'ethereum' as title ,
count (distinct tx_hash) as Swaps_Count,
count (distinct origin_from_address) as Swappers_Count
Run a query to Download Data