freemartianETHERFI Stake Transactions
Updated 2024-07-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
›
⌄
with prices AS (
SELECT hour, price
FROM ethereum.price.ez_prices_hourly
WHERE token_address = '0xfe0c30065b384f05761f15d0cc899d4f9f9cc0eb'
AND hour::date >= '2024-07-18'
)
SELECT
block_timestamp,
tx_hash,
origin_from_address AS user,
symbol,
amount
FROM ethereum.core.ez_token_transfers
WHERE contract_address = '0x86b5780b606940eb59a062aa85a07959518c0161'
AND origin_to_address = '0xe2acf9f80a2756e51d1e53f9f41583c84279fb1f'
AND block_timestamp::date >= '2024-07-18'
ORDER BY 1 ASC
QueryRunArchived: QueryRun has been archived