Time Frame | Gas Usage for LP TXNs in Ξ | Total Gas Usage for LP TXNs in Ξ | |
|---|---|---|---|
1 | 2023-05-22 00:00:00.000 | 11.363151196 | 149.280870922 |
2 | 2023-11-27 00:00:00.000 | 11.059278715 | 431.916160569 |
3 | 2023-09-04 00:00:00.000 | 16.86380992 | 317.616070336 |
4 | 2023-10-16 00:00:00.000 | 7.234608067 | 377.333888742 |
5 | 2023-05-15 00:00:00.000 | 25.631055495 | 137.917719726 |
6 | 2023-02-13 00:00:00.000 | 0.8353809597 | 8.058531388 |
7 | 2023-03-06 00:00:00.000 | 1.614674609 | 12.056263279 |
8 | 2024-01-22 00:00:00.000 | 1.360458698 | 452.545592266 |
9 | 2023-11-20 00:00:00.000 | 10.385655876 | 420.856881854 |
10 | 2023-04-10 00:00:00.000 | 12.847512423 | 54.421506171 |
11 | 2023-03-20 00:00:00.000 | 6.363918585 | 21.344244553 |
12 | 2023-05-29 00:00:00.000 | 8.390105631 | 157.670976554 |
13 | 2023-10-09 00:00:00.000 | 6.774258888 | 370.099280675 |
14 | 2023-06-26 00:00:00.000 | 7.360116578 | 190.816300366 |
15 | 2022-11-28 00:00:00.000 | 0.4007421388 | 0.4032686637 |
16 | 2023-03-13 00:00:00.000 | 2.92406269 | 14.980325968 |
17 | 2022-12-12 00:00:00.000 | 0.5415981594 | 1.798158903 |
18 | 2024-01-01 00:00:00.000 | 2.479265807 | 447.66040955 |
19 | 2023-04-24 00:00:00.000 | 16.944779827 | 86.738027679 |
20 | 2023-01-02 00:00:00.000 | 1.000416396 | 3.772666651 |
JediSwapLP Gas Usage
Updated 2024-02-15
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
tokenList AS (
SELECT tokenSymbol, l1Address, starknetAddressWith0s,starknetAddress, decimals
FROM (
VALUES('ETH', '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2', '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7','0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7', 18)
, ('BTC', '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599', '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac', '0x3fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac', 8)
, ('DAI', '0x6b175474e89094c44da98b954eedeac495271d0f', '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3', '0xda114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3', 18)
, ('USDT', '0xdac17f958d2ee523a2206206994597c13d831ec7', '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8', '0x68f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8', 6)
, ('USDC', '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8', '0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8', 6)
, ('wstETH', '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0', '0x042b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2', '0x42b8f0484674ca266ac5d08e4ac6a3fe65bd3129795def2dca5c34ecc5f96d2', 18)
-- , ('LORDS', '0x686f2404e77Ab0d9070a46cdfb0B7feCDD2318b0', '0x0124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49', '0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49', 18)
) AS t(tokenSymbol, l1Address, starknetAddressWith0s, starknetAddress, decimals)
)
, prices AS (
SELECT
DATE_TRUNC('HOUR', HOUR) AS HOUR
, TOKEN_ADDRESS
, AVG(price) AS price
FROM crosschain.price.fact_hourly_token_prices
WHERE BLOCKCHAIN = 'ethereum'
AND HOUR > '2022-11-07'
AND TOKEN_ADDRESS IN (
'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' --WETH18DECIMALS
, '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' --USDC6DECIMALS
, '0x6b175474e89094c44da98b954eedeac495271d0f' --DAI18DECIMALS
, '0xdac17f958d2ee523a2206206994597c13d831ec7' --USDT6DECIMALS
, '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' --WBTC8DECIMALS
, '0x686f2404e77ab0d9070a46cdfb0b7fecdd2318b0' --LORDS18DECIMALS
, '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0' --wstETH18DECIMALS
)
GROUP BY 1,2
)
, pairList AS (
Last run: over 1 year ago
63
3KB
23s