Pmisha-bmlMdxsushi.gas
    Updated 2022-06-06
    select
    date(BLOCK_TIMESTAMP) as dt,
    sum(gas_used) as gas
    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%'
    group by dt
    Run a query to Download Data