kaibladeTop 10 Token Transactions (Arbitrum)
Updated 2022-07-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
›
⌄
WITH top10_raw AS
(SELECT contract_address,
COUNT(tx_hash) as transactions
FROM arbitrum.core.fact_token_transfers
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '1 week'
GROUP BY contract_address
ORDER BY transactions DESC
LIMIT 10)
SELECT tokens.contract_address, labels.address_name,
(CASE
WHEN labels.address_name = 'hop protocol: eth l2canonicaltoken' THEN 'Wrapped Ether (WETH)'
WHEN labels.address_name = 'hop protocol: eth l2hopbridgetoken' THEN 'ETH Hop Token (hETH)'
WHEN labels.address_name = 'hop protocol: usdc l2canonicaltoken' THEN 'USD Coin (Arb1) (USDC)'
WHEN labels.address_name = 'treasure dao: magic token' THEN 'Magic Token (MAGIC)'
WHEN labels.address_name = 'hop protocol: usdt l2canonicaltoken' THEN 'Tether USD (USDT)'
WHEN labels.address_name = 'hop protocol: dai l2canonicaltoken' THEN 'Dai Stablecoin (DAI)'
WHEN labels.address_name = 'hop protocol: usdc l2hopbridgetoken' THEN 'USD Coin Hop Token (hUSDC)'
WHEN tokens.contract_address = '0x4e971a87900b931ff39d1aad67697f49835400b6' THEN 'Fee GLP (fGLP)'
WHEN tokens.contract_address = '0x4277f8f2c384827b5273592ff7cebd9f2c1ac258' THEN 'GMX LP (GLP)'
WHEN tokens.contract_address = '0x45096e7aa921f27590f8f19e457794eb09678141' THEN 'USD Gambit (USDG)'
END
) AS token_name,
labels.project_name,
tokens.transactions
FROM top10_raw tokens
LEFT JOIN arbitrum.core.dim_labels labels
ON tokens.contract_address = labels.address
ORDER BY tokens.transactions DESC
Run a query to Download Data