binhachonCurve Distribution Chart - Bridges
Updated 2021-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
--SELECT USER_ADDRESS, ADDRESS_NAME, LABEL_TYPE, LABEL_SUBTYPE, BALANCE FROM ethereum.erc20_balances
SELECT
USER_ADDRESS,
ADDRESS_NAME,
LABEL_TYPE,
LABEL_SUBTYPE,
CASE
WHEN USER_ADDRESS = '0xc564ee9f21ed8a2d8e7e76c085740d5e4c5fafbe' THEN 'ANYSWAP: Fantom Bridge'
WHEN USER_ADDRESS = '0xa929022c9107643515f5c777ce9a910f0d1e490c' THEN 'HECO Chain Bridge'
WHEN USER_ADDRESS = '0x40ec5b33f54e0e8a33a975908c5ba1c14e5bbbdf' THEN 'Polygon Bridge'
WHEN USER_ADDRESS = '0xa3a7b6f88361f48403514059f1f16c8e78d60eec' THEN 'Arbitrum Bridge'
WHEN USER_ADDRESS = '0xe78388b4ce79068e89Bf8aa7f218ef6b9ab0e9d0' THEN 'Avalance Bridge'
ELSE 'Other' END as MYLABEL,
BALANCE
FROM
ethereum.erc20_balances
--WHERE CONTRACT_ADDRESS = '0xd533a949740bb3306d119cc777fa900ba034cd52'
WHERE CONTRACT_LABEL = 'curve fi'
AND BALANCE_DATE >= getdate() - INTERVAL'1 day'
AND MYLABEL != 'Other'
ORDER BY BALANCE DESC
LIMIT 90000
Run a query to Download Data