CryptoIcicleHop-3.Hop Whales - Native Bridges
Updated 2022-06-20
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
›
⌄
-- Are whales choosing Hop to go to L2s? Or are they choosing the native bridges?
-- Compare Hop vs the native bridges for Polygon, Optimism, and Arbitrum over the following metrics:
-- unique users on each, frequency of use, and the average amount of assets moved on each?
-- Payout 150 USDC
-- Grand Prize 450 USDC
-- Level Intermediate
with whales as (
select
user_address,
amount_usd as balance_usd
from ethereum.erc20_balances
where contract_address = lower('0xc5102fE9359FD9a28f877a67E36B0F050d81a3CC') -- HOP Token
and balance_date::date = CURRENT_DATE - 1
and user_address not in (
'0xeea8422a08258e73c139fc32a25e10410c14bd7a',
'0x56a9a5676e0e7f30d5a3f6a82cebcded238ba3ff'
)
order by balance_usd desc
limit 100
),
transfer as (
(
select
case when eth_to_address = '0xa0c68c638235ee32657e8f720a23cec1bfc77c77' then 'polygon'
when eth_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' then 'optimism'
when eth_to_address = '0x011b6e24ffb0b5f5fcc564cf4183c5bbbc96d515' then 'arbitrum'
end as type,
block_timestamp,
tx_hash,
(IFF(amount_usd > pow(10,9), amount_usd/pow(10,18), amount_usd)) as amount_usd
from ethereum.core.ez_eth_transfers
WHERE eth_to_address IN (
'0x011b6e24ffb0b5f5fcc564cf4183c5bbbc96d515', -- Arbitrum
Run a query to Download Data