bachiUntitled Query
Updated 2022-05-07
99
1
2
3
4
5
6
7
8
9
10
›
⌄
⌄
/*select date(block_timestamp) as date, sum(gas_price)/pow(10,9) as gas_fee,
case when symbol = 'UNI' then 'Uniswap gas fees'
when symbol != 'UNI' then 'Ethereum gas fees' end as platform
from ethereum.transactions
where block_timestamp >= dateadd(month, -12, getdate())
and symbol is not null group by date, platform*/
select date(block_timestamp) as date, sum(gas_used)/pow(10,9) as gas_fee, 'Uniswap Gas Fees' as category from ethereum.transactions
where from_address = '0x1f9840a85d5aF5bf1D1762F925BDADdC4201F984' or to_address='0x1f9840a85d5aF5bf1D1762F925BDADdC4201F984' and
block_timestamp >= dateadd(month, -12, getdate()) group by date
Run a query to Download Data