BLOCK_TIMESTAMP | TX_HASH | ORIGIN_FROM_ADDRESS | CONTRACT_ADDRESS | EVENT_NAME | AMOUNT_IN_USD | PLATFORM | SYMBOL_IN | |
|---|---|---|---|---|---|---|---|---|
1 | 2021-07-16 20:08:17.000 | 0xc54e77c2d756e4e40f56e1f876e73f8f96ed6c45ea0275fd8c43810a51e68263 | 0x8d528ad7ba677335819b9b3d11d808fd70d6b021 | 0xc4d9102e36c5063b98010a03c1f7c8bd44c32a00 | Swap | 711.58 | uniswap-v2 | ATRI |
2 | 2021-07-16 02:14:57.000 | 0xd010636f43c2bd6decc9d3156874df663eb0ae17b44066c9272391b480c82475 | 0xb28bdc7157fe6397d2fa46a18a7022bd23ccb20b | 0x3c4adc4dc1a50bf6ec59af196a204415bc708429 | Swap | 3329.99 | uniswap-v2 | RAY |
3 | 2021-07-16 12:09:06.000 | 0x160fa9f177d5342dbd95a2e38cf42384ff31d4aa7b036745702255f1e240b1b6 | 0xf849b3679d5d02255006e846a561329d1d404c41 | 0x6591c4bcd6d7a1eb4e537da8b78676c1576ba244 | Swap | 8558.81 | uniswap-v2 | BOND |
4 | 2021-07-16 12:05:40.000 | 0xed74bdc3988d1cf24194828a4ec6c737fc251a5ade2350acf9716330ccde2db9 | 0x1fe9c534018e9e100b64d47093198255133cd3bd | 0xae461ca67b15dc8dc81ce7615e0320da1a9ab8d5 | Swap | 1105.14 | uniswap-v2 | DAI |
5 | 2021-07-16 17:38:30.000 | 0xe3fbbf2bd5146f9882b9dee4aeb2b5f8ce1fd90c56d03d4ee6cf780e2a4e76ac | 0x965449210cbf78fe904a1407306fc395f5ee4ee8 | 0xb6ca52c7916ad7960c12dc489fd93e5af7ca257f | Swap | 32.09 | uniswap-v2 | WETH |
6 | 2021-07-16 17:31:43.000 | 0xf4164b765368a80b58948c9a665efe7b886d5469049b2f816aeefebdf19e0a13 | 0xd331219cb8874d831b5d1120fcf2e4ee68b7eab9 | 0xb6ca52c7916ad7960c12dc489fd93e5af7ca257f | Swap | 39.77 | uniswap-v2 | WETH |
7 | 2021-07-16 17:31:43.000 | 0x2581d181ef206dc1bfaa310ad2a4d7f1e24a9803c337a34508da2b1712c46743 | 0xbe3178f11b55787a0827e9f28d8759761f21e3c9 | 0xb6ca52c7916ad7960c12dc489fd93e5af7ca257f | Swap | 2901.59 | uniswap-v2 | WETH |
8 | 2021-07-16 17:10:57.000 | 0xa9bfd2f86830610600ddd4cacaa20b07fbce700e17638d4d3d446c37095df93f | 0xbc009036d8ca3b9d317d23283f41c58956a5875d | 0xb6ca52c7916ad7960c12dc489fd93e5af7ca257f | Swap | 98.54 | uniswap-v2 | WETH |
9 | 2021-07-16 05:26:55.000 | 0x179cecb795b2fb3c369de8fb2e780ee91cdee1153085a7f9d4e49799bfdbc1ab | 0xfba23c7f2209e79c60546057d6d06c2cae5f3126 | 0xebee0cf6ab1bf5b9e9be1a9348632c79089d3b6a | Swap | 5.15 | uniswap-v2 | WETH |
10 | 2021-07-16 07:10:14.000 | 0xf914a607b44dc2bd68c6f304cfabe120dd337595e80cf97a9d46e050715739bf | 0x4fddfec716e7e55c28bf2e0438c57540d3b919f1 | 0xbb2b8038a1640196fbe3e38816f3e67cba72d940 | Swap | 1 | uniswap-v2 | WETH |
somkeneSQL 1st assignment
Updated 2024-02-02
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
block_timestamp,
tx_hash,
origin_from_address,
contract_address,
event_name,
amount_in_usd,
platform,
symbol_in
FROM ethereum.defi.ez_dex_swaps
WHERE amount_in_usd IS NOT NULL
LIMIT 10
Last run: about 1 year ago
10
2KB
4s