MoeGMX Protocol Overview 6
Updated 2022-09-18Copy Reference Fork
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
›
⌄
with tab1 as (
SELECT
*,
CASE WHEN ADDRESS_NAME LIKE 'hop protocol: wbtc l2canonicaltoken' THEN 'WBTC'
WHEN ADDRESS_NAME LIKE 'chainlink' THEN 'LINK'
WHEN ADDRESS_NAME LIKE 'hop protocol: dai l2canonicaltoken' THEN 'DAI'
WHEN ADDRESS_NAME LIKE 'uniswap' THEN 'UNI'
WHEN ADDRESS_NAME LIKE 'frax finance: frax token' THEN 'FARX'
WHEN ADDRESS_NAME LIKE 'hop protocol: eth l2canonicaltoken' THEN 'WETH'
WHEN ADDRESS_NAME LIKE 'hop protocol: usdt l2canonicaltoken' THEN 'USDT'
WHEN ADDRESS_NAME LIKE 'hop protocol: usdc l2canonicaltoken' THEN 'USDC' END as symbol_1,
CASE WHEN ADDRESS_NAME LIKE 'hop protocol: wbtc l2canonicaltoken' THEN 8
WHEN ADDRESS_NAME LIKE 'chainlink' THEN 18
WHEN ADDRESS_NAME LIKE 'hop protocol: dai l2canonicaltoken' THEN 18
WHEN ADDRESS_NAME LIKE 'uniswap' THEN 18
WHEN ADDRESS_NAME LIKE 'frax finance: frax token' THEN 18
WHEN ADDRESS_NAME LIKE 'hop protocol: eth l2canonicaltoken' THEN 18
WHEN ADDRESS_NAME LIKE 'hop protocol: usdt l2canonicaltoken' THEN 6
WHEN ADDRESS_NAME LIKE 'hop protocol: usdc l2canonicaltoken' THEN 6 END as decimal_1
FROM arbitrum.core.fact_token_transfers
LEFT outer JOIN arbitrum.core.dim_labels
ON contract_address LIKE address
WHERE to_address LIKE lower('0x09f77E8A13De9a35a7231028187e9fD5DB8a2ACB')
)
SELECT
symbol_1,
COUNT(DISTINCT tx_hash) as events,
COUNT(DISTINCT origin_from_address) as users,
sum((raw_amount / power(10, decimal_1)) * price) as volume
FROM tab1
LEFT outer join ethereum.core.fact_hourly_token_prices
ON symbol = symbol_1
AND date_trunc('day', block_timestamp) = hour
Run a query to Download Data