Nige7777Time pieces Drop
Updated 2021-09-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- select * from ethereum.transactions where tx_id = '0x8c58141a64ef5177fc1ef01be429e71313cceb3b157423f275655f7decdcd99a'
-- and date_trunc('hour',block_timestamp ) > '2021-09-22T09:55:55Z'
select case Success when 'TRUE' THEN 'YES' WHEN 'FALSE' THEN 'NO' END AS Tran_Success,
count(*) Transactions,
sum(TX_FEE) ETH_GAS_FEES,
min(tx_fee) Lowest_gas_fee,
MAX(tx_fee) Highest_Gas_fee,
min(gas_price) Lowest_gas_price,
MAX(gas_price) Highest_Gas_price
from ethereum.transactions t
where 1=1
AND To_address = '0xdd69da9a83cedc730bc4d3c56e96d29acc05ecde'
--and function_name = 'mint'
and function_signature = '0x877a294a'
and date_trunc('hour',block_timestamp ) > '2021-09-22T09:55:55Z'
--where contract_address = lower('0x7afeda4c714e1c0a2a1248332c100924506ac8e6')
group by success
order by 1 desc
Run a query to Download Data