adriaparcerisassquid gas
Updated 2023-05-12
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
squid_arb as (
SELECT
x.block_timestamp,x.tx_hash,
source_chain,sender,destination_chain,
token_symbol,amount, tx_fee as usd_fee, gas_used, 'WETH' as symbol
from axelar.defi.ez_bridge_squid x
join arbitrum.core.fact_transactions y on x.tx_hash=y.tx_hash
where source_chain='arbitrum' and y.block_timestamp>='2023-02-01'
),
squid_binance as (
SELECT
x.block_timestamp,x.tx_hash,
source_chain,sender,destination_chain,
token_symbol,amount, tx_fee as usd_fee, gas_used, 'WBNB' as symbol
from axelar.defi.ez_bridge_squid x
join bsc.core.fact_transactions y on x.tx_hash=y.tx_hash
where source_chain='binance' and y.block_timestamp>='2023-02-01'
),
squid_avalanche as (
SELECT
x.block_timestamp,x.tx_hash,
source_chain,sender,destination_chain,
token_symbol,amount, tx_fee as usd_fee, gas_used, 'WAVAX' as symbol
from axelar.defi.ez_bridge_squid x
join avalanche.core.fact_transactions y on x.tx_hash=y.tx_hash
where source_chain='avalanche' and y.block_timestamp>='2023-02-01'
),
squid_polygon as (
SELECT
x.block_timestamp,x.tx_hash,
source_chain,sender,destination_chain,
token_symbol,amount, tx_fee as usd_fee, gas_used, 'WMATIC' as symbol
from axelar.defi.ez_bridge_squid x
Run a query to Download Data