BLOCK_TIMESTAMP | TX_HASH | CONTRACT_ADDRESS | |
|---|---|---|---|
1 | 2020-05-26 16:15:06.000 | 0x2895e4eacb1f81d0ef77e297deeb1910070bba4d574daf326b65c405f526e523 | 0x9b9647431632af44be02ddd22477ed94d14aacaa |
2 | 2020-05-26 16:13:58.000 | 0x47e36ae7461340b9c5df64e8901120dcfc785de7649285c519fe3569212a9d24 | 0x9b9647431632af44be02ddd22477ed94d14aacaa |
3 | 2020-05-26 16:16:39.000 | 0x260ab435c8d7295f92b15af22813214aebb3f292a519387eb0392060adff6d2b | 0x9b9647431632af44be02ddd22477ed94d14aacaa |
4 | 2020-06-07 04:06:28.000 | 0xc560c2c95094a2485d96bb8626656b2894e6af2bd826aac8aeb8fcf7ae7e544c | 0xdac17f958d2ee523a2206206994597c13d831ec7 |
5 | 2020-06-07 04:03:15.000 | 0x12439d78a48fcb141fb052bd9da5847588a79610065030cb50a552c05e2a249a | 0xdac17f958d2ee523a2206206994597c13d831ec7 |
6 | 2020-06-07 04:49:42.000 | 0xb107e0b628e3ad3e114fa5e89e94301447073ecdcd6d6c854b9e2ab37084401f | 0xdac17f958d2ee523a2206206994597c13d831ec7 |
7 | 2020-06-07 21:53:29.000 | 0xc886f18988ee20d75cd8150d5f82de8025d4bd9dadd0fa5fc893d62e94c6cc8a | 0xe62e6e6c3b808faad3a54b226379466544d76ea4 |
8 | 2020-06-07 21:39:35.000 | 0x7da2a6645ef5ab91dde06f7eec877f20e1e64b6988dac91d18eafd9ed59efa61 | 0xe62e6e6c3b808faad3a54b226379466544d76ea4 |
9 | 2020-06-07 21:43:20.000 | 0x25e9b7b77f92a317c80374f19fcef16601d941a724fbdab137197abd7982a5e9 | 0xe62e6e6c3b808faad3a54b226379466544d76ea4 |
10 | 2020-05-10 18:41:51.000 | 0x327a410655fbf5b44d49f3022162129ad72491c49fcae3e02576b66e9ad20831 | 0x0cf0ee63788a0849fe5297f3407f701e122cc023 |
dannyamah2024-02-05 07:38 PM
Updated 2024-02-14
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
SELECT
*
FROM ethereum.core.ez_token_transfers AS t
LEFT JOIN ethereum.core.dim_labels AS l
on t.contract_address = l.address
LIMIT 10
-- SELECT
-- tf.block_timestamp,
-- tf.tx_hash,
-- tf.origin_from_address,
-- lb.label,
-- tf.amount_usd,
-- tf.symbol
-- FROM ethereum.core.ez_token_transfers AS tf
-- JOIN ethereum.core.dim_labels AS lb
-- ON tf.contract_address = lb.address
-- WHERE tf.amount_usd IS NOT NULL
-- ORDER BY 5 DESC
-- LIMIT 1000
-- SELECT
-- swaps.event_name,
-- swaps.contract_address,
-- labels.address_name,
-- labels.label,
-- swaps.block_timestamp,
-- swaps.tx_hash,
-- swaps.origin_from_address,
-- swaps.amount_in_usd,
-- swaps.symbol_in
-- FROM
-- ethereum.defi.ez_dex_swaps AS swaps
-- JOIN ethereum.core.dim_labels AS labels
-- ON swaps.contract_address = labels.address
Last run: over 1 year ago
10
1KB
3s