Nige7777Untitled Query
Updated 2021-10-19
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
›
⌄
-- 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 from_address = '0x2d097c1535988216499722df726617a3607b0f08'--'0x1d20a51f088492a0f1c57f047a9e30c9ab5c07ea' loomlock
-- 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
select * from ethereum.transactions t where tx_id = '0x6c643bdefd7bc5b39765e47548e5a8bff3c5b9b1ba0cb7ede83551fa5772a3af'
and date_trunc('hour',block_timestamp ) > '2021-09-22T09:55:55Z'
Run a query to Download Data