TX_HASH | BLOCK_NUMBER | BLOCK_TIMESTAMP | FROM_ADDRESS | TO_ADDRESS | |
|---|---|---|---|---|---|
1 | 0x570b760dacfdccf4e009201cbd2b5f78849f6d028728692888004f714bbc124c | 20661205 | 2024-09-02 06:50:47.000 | 0xa46196997f220d3fd3705be776415870e9897f9d |
ghostcrabFind token genesis block - ETH
Updated 2025-03-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
tx_hash,
block_number,
block_timestamp,
from_address,
to_address
FROM ethereum.core.fact_transactions
WHERE
LOWER(to_address) IS NULL
AND tx_hash IN (
SELECT tx_hash
FROM ethereum.core.fact_event_logs
WHERE LOWER(contract_address) = '0xb33d999469a7e6b9ebc25a3a05248287b855ed46'
ORDER BY block_number ASC
LIMIT 1
)
Last run: about 1 month ago
1
157B
30s