kakamoraBridge Transactions by Amount of Money Transferred
Updated 2022-06-21
999
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
›
⌄
with hop_bridges as (
select
address,
address_name
from ethereum.core.DIM_LABELS
where LABEL = 'hop protocol'
and address_name like '%bridge%'
UNION
select
lower('0x3666f603cc164936c1b87e207f36beba4ac5f18a'),
'hop protocol: usdc bridge'
),
hop_transfers as (
SELECT
tfr.tx_hash,
tfr.block_timestamp,
to_date(tfr.block_timestamp) as date,
tfr.origin_from_address as wallet,
tfr.symbol as token,
tfr.amount as token_amount,
tfr.amount_usd as token_amount_usd,
case logs.event_inputs:chainId::string
when 10 then 'Optimism'
when 137 then 'Polygon'
when 42161 then 'Arbitrum'
end as destination,
case
when token_amount_usd > 1 * 1e6 then '$1 Million+'
when token_amount_usd > 0.5 * 1e6 then '$500K - $1 Million'
when token_amount_usd > 0.25 * 1e6 then '$250K - $500K'
when token_amount_usd > 0.1 * 1e6 then '$100K - $250K'
when token_amount_usd > 50000 then '$50K - $100K'
when token_amount_usd > 10000 then '$10K - $50K'
when token_amount_usd > 5000 then '$5K - $10K'
when token_amount_usd > 1000 then '$1K - $5K'
else 'Less than $1K'
Run a query to Download Data