web3pantherhashstack-supply-tvl-index-rate copy
Updated 2024-03-05
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
›
⌄
-- forked from hashstack-supply-tvl-index-rate @ https://flipsidecrypto.xyz/edit/queries/aa73f4d8-70e2-42e2-b42c-3cac1e09f4ca
-- SET market you want to generate data for (BTC/ETH/USDC/USDT/DAI/STRK)
with selectedMarket as (
SELECT
market
FROM
(
VALUES
('ETH') -- <---------- SET HERE
) AS t(market)
),
tokenList AS (
-- list of all tokens supported by Hashstack
SELECT
tokenSymbol,
l1Address,
starknetAddressWith0s,
starknetAddress,
rtokenAddressWith0s,
decimals
FROM
(
VALUES
(
'ETH',
'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2',
'0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7',
'0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7',
'0x00436d8d078de345c11493bd91512eae60cd2713e05bcaa0bb9f0cba90358c6e',
18
),
(
'BTC',
'0x2260fac5e5542a773aa44fbcfedf7c193bc2c599',
'0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac',
QueryRunArchived: QueryRun has been archived