sunslingerMetamask v1
Updated 2021-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
⌄
SELECT MAX(block_timestamp) AS latest_tx_time, (CURRENT_DATE - 2) AS cutoff, sum(fee_usd) as dolla_bills
FROM ethereum.transactions
WHERE
block_timestamp >= CURRENT_DATE - 2
AND
from_address = '0x5970c498244ce30248711497b7886feca0077423'
/* Select a specific transaction
SELECT *
FROM ethereum.transactions
WHERE
block_timestamp >= CURRENT_DATE - 7
AND
tx_id = '0xb37a660265798cc8c9866f55e22ef8a011d364053bb021e3f86e32f6a37a676b'
*/
Run a query to Download Data