Pmisha-bmlMdxsushi.gas.1
Updated 2022-06-06
99
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
›
⌄
select
'DEX gas' as type,
date(BLOCK_TIMESTAMP) as dt,
sum(gas_used) as gas_dex
from ethereum.core.fact_transactions s left outer join ethereum.core.dim_labels b on s.TO_ADDRESS =b.ADDRESS
where BLOCK_TIMESTAMP>='2022-01-01'
and b.ADDRESS_NAME ilike '%sushiswap%'
and b.LABEL_TYPE ilike '%dex%'
group by dt
union all
select
'Kashi gas' as type,
date(BLOCK_TIMESTAMP) as dt,
sum(gas_used) as gas_dex
from ethereum.core.fact_transactions s left outer join ethereum.core.dim_labels b on s.TO_ADDRESS =b.ADDRESS
where BLOCK_TIMESTAMP>='2022-01-01'
and b.ADDRESS_NAME ilike '%sushiswap: kashi%'
--and b.ADDRESS_NAME ilike '%kashi%'
group by dt
union all
select
'Bentobox gas' as type,
date(BLOCK_TIMESTAMP) as dt,
sum(gas_used) as gas_dex
from ethereum.core.fact_transactions s left outer join ethereum.core.dim_labels b on s.TO_ADDRESS =b.ADDRESS
where BLOCK_TIMESTAMP>='2022-01-01'
and b.ADDRESS_NAME ilike '%sushiswap: bentobox%'
--and b.ADDRESS_NAME ilike '%bentobox%'
group by dt
Run a query to Download Data