mz0111redux 9
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
"NAME",
case
when "USD bridge amount" between 0 and 10 then '0-10 USD'
when "USD bridge amount" between 10 and 100 then '10-100 USD'
when "USD bridge amount" between 100 and 1000 then '100-1000 USD'
when "USD bridge amount" between 1000 and 10000 then '1000-10000 USD'
when "USD bridge amount" > 10000 then 'MORE THAN 10000 USD'
END AS "USD amount distribution",
count("op bridge")
from
( select
DISTINCT TX_HASH as "op bridge",
'USDC BRIDGE' AS "NAME",
SUM(AMOUNT_USD) AS "USD bridge amount",
avg(AMOUNT_USD) as "Average USD bridge amount"
from ethereum.core.ez_token_transfers
where to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
and SYMBOL LIKE 'USDC'
group by 1
union ALL
select
DISTINCT TX_HASH as "op bridge",
'USDT BRIDGE' AS "NAME",
SUM(AMOUNT_USD) AS "USD bridge amount",
avg(AMOUNT_USD) as "Average USD bridge amount"
from ethereum.core.ez_token_transfers
where to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
and SYMBOL LIKE 'USDT'
group by 1
union ALL
Run a query to Download Data