octavionotpunkgas-fee-computation-jumper-hours
Updated 2024-04-01
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 gas-fee-computation-jumper @ https://flipsidecrypto.xyz/edit/queries/c586f40b-26c0-4ec9-b3e9-1f6fc40d371d
-- forked from jumper-samechain-swap @ https://flipsidecrypto.xyz/edit/queries/e8b15b3d-417d-4695-91d4-e42a28f57928
with prices as (
select
*,
'arbitrum' as chain
from
arbitrum.price.ez_hourly_token_prices
union
all
select
*,
'optimism' as chain
from
optimism.price.ez_hourly_token_prices
union
all
select
*,
'bnb' as chain
from
bsc.price.ez_hourly_token_prices
union
all
select
*,
'base' as chain
from
base.price.ez_hourly_token_prices
union
all
select
*,
'ethereum' as chain
from
QueryRunArchived: QueryRun has been archived