tkvresearch2024-03-19 07:39 PM
Updated 2024-03-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
27
28
29
30
31
32
33
34
35
36
›
⌄
-- Rhino: 0xb80a582fa430645a043bb4f6135321ee01005fef
-- zkBridge: 0x51187757342914e7d94fffd95ccca4f440fe0e06
-- Native:
with deposit as (
select
date_trunc('day', block_timestamp) as day,
from_address as address,
case
when to_address = '0xb80a582fa430645a043bb4f6135321ee01005fef' then 'Rhino'
when to_address = '0x51187757342914e7d94fffd95ccca4f440fe0e06' then 'zkBridge'
end as bridge,
'deposit' as type,
amount,
amount_usd
from bsc.core.ez_native_transfers
where to_address IN ('0xb80a582fa430645a043bb4f6135321ee01005fef','0x51187757342914e7d94fffd95ccca4f440fe0e06' )
)
, withdraw as (
select
date_trunc('day', block_timestamp) as day,
to_address as address,
case
when from_address = '0xb80a582fa430645a043bb4f6135321ee01005fef' then 'Rhino'
when from_address = '0x51187757342914e7d94fffd95ccca4f440fe0e06' then 'zkBridge'
end as bridge,
'withdraw' as type,
amount,
amount_usd
from bsc.core.ez_native_transfers
where from_address IN ('0xb80a582fa430645a043bb4f6135321ee01005fef','0x51187757342914e7d94fffd95ccca4f440fe0e06' )
)
, stats as (
QueryRunArchived: QueryRun has been archived