Nige7777FVCK_CRYSTAL Drop
Updated 2021-08-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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 = '0xdfc243bb46dbdbc5923a52cb46dd237b3648f20c'
and function_name = 'purchase'
and date_trunc('hour',block_timestamp ) > '2021-08-07T09:55:55Z'
--where contract_address = lower('0x7afeda4c714e1c0a2a1248332c100924506ac8e6')
group by success
order by 1 desc
Run a query to Download Data