VOL | |
|---|---|
1 | 0x084e3bcd2ee33279ab9fccc4d95fb10276286afe13d809b4aa6db7e7ce56c91a |
2 | 0xcad5e4d8e4c742f00fd40b7d13821891be560dcc25e3fe2ee7d61a20c9d271e4 |
3 | 0x58a8f6a217a6e8b6912768122d7e4a48323e84b7c6d17b0168e6a0d6ff273411 |
4 | 0x6612e25d28617b73a2fb0c6fefd1dcd9971846ea71ed86585fe8d5816976dd6b |
5 | 0x6612e25d28617b73a2fb0c6fefd1dcd9971846ea71ed86585fe8d5816976dd6b |
6 | 0xf665a051acfa60243b223b5e5d3f921b4ae546b58fb2c7f660da6cb7d12646bc |
7 | 0xf665a051acfa60243b223b5e5d3f921b4ae546b58fb2c7f660da6cb7d12646bc |
8 | 0xcc9ed0fb40cddc6f4db4a2432a5229f8536895f0705b275f199bc069da6b037b |
9 | 0x56245bc17b6c429c306685740eb356c210c68fecf04576fb457b3ec85e1bde9f |
10 | 0xf5911509a7435867f3611a680c844cef5b29e1916632625bedad9e6f22f709e6 |
11 | 0xb3690710dfb1e2b53e86d90a9aece620cf1c2ae5f3e5fb493f9644e02a3679ec |
12 | 0xf60497dffa4fba7df98805fbd40f3b4cb22ec2720af16e3dd8d6837a767a26b4 |
13 | 0x61f8178fb9d2a462aef1795acc23c2082135cc6f9e3b51f7c562c043b99e5fc1 |
14 | 0x59110d0616f21b3ac74ebb7052dc3b28b38f85887e9694ef7a1820636953bd54 |
15 | 0xd7731a884d880be312af6b6aebde4c93fd8ebb13ac16125881a435b7b4be42c5 |
16 | 0x56f23095d417bb3fbb783a352196bfe413cc89a16694a5eb82b440bc80861f5b |
17 | 0x92a6c71131b08791ca465e0a8bc472e18076107ee2014a65248b4e2696bb4692 |
18 | 0xb430c8c31fed11b126258246e252bb3939679728298ba2116b2e6fcc5666ad3c |
19 | 0x9764b40d9780197c017e540c40abdff1a8d708d94353950e2d234a5735d40e07 |
20 | 0x35ecef6986a1812a7c650f3cfbb2bb033de467b36be7e714fba64555d5cbc8ae |
hrst79xxx
Updated 2025-02-06
999
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 tokens_tab as (
SELECT
*
from
values
('0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee','WETH',18),
('0xd642b49d10cc6e1bc1c6945725667c35e0875f22','PURPLE',18),
('0xbf0cafcbaaf0be8221ae8d630500984edc908861','SQUIDS',18),
('0x4200000000000000000000000000000000000006','WETH',18),
('0x0200c29006150606b650577bbe7b6248f58470c1','USDT0',6),
('0xca5f2ccbd9c40b32657df57c716de44237f80f05','KRAKEN',18),
('0xf1815bd50389c46847f0bda824ec8da914045d14','USDC.E',6),
('0x0c5e2d1c98cd265c751e02f8f3293bc5764f9111','SHROOMY',18)as a (token_address,symbol,decimal)
),
price_tab as(
select
hour,
token_address,
symbol,
price as price,
case when token_address = '0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' then 18
when token_address = '0xd642b49d10cc6e1bc1c6945725667c35e0875f22' then 18
when token_address = '0xbf0cafcbaaf0be8221ae8d630500984edc908861' then 18
when token_address = '0x4200000000000000000000000000000000000006' then 18
when token_address = '0x0200c29006150606b650577bbe7b6248f58470c1' then 6
when token_address = '0xca5f2ccbd9c40b32657df57c716de44237f80f05' then 18
when token_address = '0xf1815bd50389c46847f0bda824ec8da914045d14' then 6
when token_address = '0x0c5e2d1c98cd265c751e02f8f3293bc5764f9111' then 18
end as decimal
from
ink.price.ez_prices_hourly
)
,
Last run: 3 months ago
84
6KB
5s