Sajjadiiiavalanche gold
Updated 2022-12-08Copy 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
›
⌄
--SELECT * FROM avalanche.core.fact_event_logs WHERE tx_hash = '0x1041e31e6ae612992d595731a70399458fd2ddd00f47f3df96ba39b6a83a8801'
--SELECT DISTINCT EVENT_INPUTS:sender from avalanche.core.dim_labels WHERE EVENT_NAME = 'Swap'
-- Sushiswap 0x1b02da8cb0d097eb8d57a175b88c7d8b47997506
--select * from avalanche.core.dim_labels
-- where label_subtype = 'swap_contract'
WITH contracts AS (
SELECT '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e' AS TOKEN_ADDRESS , '6' AS decimals , 'USDC' AS symbol FROM ethereum.core.fact_hourly_token_prices
union all
SELECT '0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664' AS TOKEN_ADDRESS , '6' AS decimals , 'USDC.e' AS symbol FROM ethereum.core.fact_hourly_token_prices
UNION all
SELECT '0xc25ff1af397b76252d6975b4d7649b35c0e60f69' AS TOKEN_ADDRESS , '6' AS decimals , 'bUSDC' AS symbol FROM ethereum.core.fact_hourly_token_prices
UNION all
SELECT '0xfab550568c688d5d8a52c7d794cb93edc26ec0ec' AS TOKEN_ADDRESS , '6' AS decimals , 'axlUSDC' AS symbol FROM ethereum.core.fact_hourly_token_prices
UNION all
SELECT '0xe28965073c49a02923882b8329d3e8c1d805e832' AS TOKEN_ADDRESS , '6' AS decimals , 'iUSDC.E' AS symbol FROM ethereum.core.fact_hourly_token_prices
UNION all
SELECT '0x543672e9cbec728cbba9c3ccd99ed80ac3607fa8' AS TOKEN_ADDRESS , '6' AS decimals , 'USDC Wormhole' AS symbol FROM ethereum.core.fact_hourly_token_prices
UNION all
SELECT '0x0950fc1ad509358daead5eb8020a3c7d8b43b9da' AS TOKEN_ADDRESS , '6' AS decimals , 'USDC Wormhole' AS symbol FROM ethereum.core.fact_hourly_token_prices
UNION all
SELECT '0x6145e8a910ae937913426bf32de2b26039728acf' AS TOKEN_ADDRESS , '18' AS decimals , 'USDC Wormhole' AS symbol FROM ethereum.core.fact_hourly_token_prices
UNION all
SELECT '0xb24ca28d4e2742907115fecda335b40dbda07a4c' AS TOKEN_ADDRESS , '6' AS decimals , 'USDC Wormhole' AS symbol FROM ethereum.core.fact_hourly_token_prices
UNION all
SELECT lower('0xB2280fd71b64791B0B145b289A72473bCd81a073') AS TOKEN_ADDRESS , '18' AS decimals , 'weUSDC' AS symbol FROM ethereum.core.fact_hourly_token_prices
UNION all
SELECT lower('0x0c90447b662C2FcB62DC104DFC4563D0dd4be49e') AS TOKEN_ADDRESS , '18' AS decimals , 'weUSDC' AS symbol FROM ethereum.core.fact_hourly_token_prices
UNION all
SELECT lower('0x305F06749B98D5AA5AE48B08395615ae9466DE4D') AS TOKEN_ADDRESS , '18' AS decimals , 'weUSDC' AS symbol FROM ethereum.core.fact_hourly_token_prices
UNION all
SELECT '0xad92430a77854d72fcbbc5f4ec1e9f89d7585b90' AS TOKEN_ADDRESS , '18' AS decimals , 'UVIC' AS symbol FROM ethereum.core.fact_hourly_token_prices
Run a query to Download Data