BLOCK_NUMBER | BLOCK_TIMESTAMP | TX_HASH | ORIGIN_FUNCTION_SIGNATURE | ORIGIN_FROM_ADDRESS | ORIGIN_TO_ADDRESS | CONTRACT_ADDRESS | POOL_NAME | EVENT_NAME | AMOUNT_IN_UNADJ | AMOUNT_IN | AMOUNT_IN_USD | AMOUNT_OUT_UNADJ | AMOUNT_OUT | AMOUNT_OUT_USD | SENDER | TX_TO | EVENT_INDEX | PLATFORM | TOKEN_IN | TOKEN_OUT | SYMBOL_IN | SYMBOL_OUT | _LOG_ID | EZ_DEX_SWAPS_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 19020556 | 2024-01-16 16:10:11.000 | 0x497f6715de22066c5a46da297030e2f9350d47d68fbf9ac24c3319579194b2ac | 0x791ac947 | 0xeda614d4f7ec885b914712ade5bc6fa770e9a08f | 0x80a64c6d7f12c47b7c66c5b4e20e72bc1fcd5d9e | 0xf1b0bcf0cfb8d5156bc394425cec79bcaf787e55 | WETH-QWIK UNI-V2 LP | Swap | 1.10398756890903e+21 | 1103.987568909 | 795934831838452000 | 0.7959348318 | 0x7a250d5630b4cf539739df2c5dacb4c659f2488d | 0x7a250d5630b4cf539739df2c5dacb4c659f2488d | 101 | uniswap-v2 | 0xd7db52daa32b738ed55b23a487afd4daa0ad7e72 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | QWIK | WETH | 0x497f6715de22066c5a46da297030e2f9350d47d68fbf9ac24c3319579194b2ac-101 | 94fa10b7330d273b0b246c1a8560dd88 | 2024-01-18 04:54:21.867 | 2024-01-18 04:54:21.867 | ||
2 | 19020511 | 2024-01-16 16:01:11.000 | 0x470d0ef432aa3abcb4069adbbc8fd45f1f5b622f827be256443cfdb2684dce48 | 0xb6f9de95 | 0xeda614d4f7ec885b914712ade5bc6fa770e9a08f | 0x80a64c6d7f12c47b7c66c5b4e20e72bc1fcd5d9e | 0xf1b0bcf0cfb8d5156bc394425cec79bcaf787e55 | WETH-QWIK UNI-V2 LP | Swap | 50000000000000000 | 0.05 | 132285304384426000000 | 132.285304384 | 0x80a64c6d7f12c47b7c66c5b4e20e72bc1fcd5d9e | 0xeda614d4f7ec885b914712ade5bc6fa770e9a08f | 103 | uniswap-v2 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0xd7db52daa32b738ed55b23a487afd4daa0ad7e72 | WETH | QWIK | 0x470d0ef432aa3abcb4069adbbc8fd45f1f5b622f827be256443cfdb2684dce48-103 | 2e6bc69432882fd56b2ee8720ac25ea6 | 2024-01-18 04:23:11.814 | 2024-01-18 04:23:11.814 | ||
3 | 19020556 | 2024-01-16 16:10:11.000 | 0x497f6715de22066c5a46da297030e2f9350d47d68fbf9ac24c3319579194b2ac | 0x791ac947 | 0xeda614d4f7ec885b914712ade5bc6fa770e9a08f | 0x80a64c6d7f12c47b7c66c5b4e20e72bc1fcd5d9e | 0xf1b0bcf0cfb8d5156bc394425cec79bcaf787e55 | WETH-QWIK UNI-V2 LP | Swap | 80000000000000000000 | 80 | 57188901598440700 | 0.0571889016 | 0x80a64c6d7f12c47b7c66c5b4e20e72bc1fcd5d9e | 0x80a64c6d7f12c47b7c66c5b4e20e72bc1fcd5d9e | 116 | uniswap-v2 | 0xd7db52daa32b738ed55b23a487afd4daa0ad7e72 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | QWIK | WETH | 0x497f6715de22066c5a46da297030e2f9350d47d68fbf9ac24c3319579194b2ac-116 | a6c4ad127b7aad7226c3769b52ffe90c | 2024-01-18 04:54:21.867 | 2024-01-18 04:54:21.867 |
toming2024-02-12 05:15 PM
Updated 2024-02-15
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
›
⌄
-- SELECT *
-- -- count(token_out)
-- FROM
-- ethereum.defi.ez_dex_swaps
-- WHERE
-- token_out = '0x49b59284d6f1227304ef1039ebf3ea04fbdac60b'
-- AND
-- block_timestamp ::date >= current_date() - 30
-- ORDER BY
-- block_timestamp
-- LIMIT
-- 1000
select
*
-- count(distinct(tx_hash))
from ethereum.defi.ez_dex_swaps
where
-- block_number = '19041367'
origin_from_address = '0xeda614d4f7ec885b914712ade5bc6fa770e9a08f'
AND
(token_out = '0xd7db52daa32b738ed55b23a487afd4daa0ad7e72'
OR
token_in = '0xd7db52daa32b738ed55b23a487afd4daa0ad7e72')
Last run: over 1 year ago
3
2KB
5s