DAY | TX_COUNT | SWAPERS | AMOUNT | USD_AMOUNT | SYMBOL | |
|---|---|---|---|---|---|---|
1 | 2024-01-29 00:00:00.000 | 2 | 2 | 2857.77670991 | 2293.834193728 | SYN |
2 | 2024-01-29 00:00:00.000 | 1 | 1 | 0.01 | 23.574618296 | swETH |
3 | 2024-01-29 00:00:00.000 | 2 | 1 | 1502 | 1502.261220908 | DAI |
4 | 2024-01-29 00:00:00.000 | 25 | 20 | 34.010928755 | 76967.49 | ETH |
5 | 2024-01-29 00:00:00.000 | 1 | 1 | 206.571677 | 206.562012357 | USDT |
6 | 2024-01-29 00:00:00.000 | 1 | 1 | 0.3428328928 | 668.342679373 | MKR |
7 | 2024-01-29 00:00:00.000 | 24 | 11 | 199723.885177 | 146177.241708271 | USDC |
8 | 2024-01-29 00:00:00.000 | 1 | 1 | 0.00009994176958 | 0.2598735863 | wstETH |
9 | 2024-01-28 00:00:00.000 | 7 | 5 | 522.711224 | 522.692405871 | USDT |
10 | 2024-01-28 00:00:00.000 | 26 | 4 | 46978.679290429 | 38500.863215876 | SYN |
11 | 2024-01-28 00:00:00.000 | 36 | 19 | 345698.753572 | 345902.124838907 | USDC |
12 | 2024-01-28 00:00:00.000 | 1 | 1 | 0.4885713037 | 965.729581682 | MKR |
13 | 2024-01-28 00:00:00.000 | 2 | 2 | 0.4087059581 | 969.638461205 | swETH |
14 | 2024-01-28 00:00:00.000 | 68 | 33 | 219.406302374 | 498490.22 | ETH |
15 | 2024-01-28 00:00:00.000 | 3 | 2 | 4140.946099708 | 4141.561046963 | DAI |
16 | 2024-01-28 00:00:00.000 | 1 | 1 | 31.523770433 | 915.135055684 | RPL |
17 | 2024-01-28 00:00:00.000 | 2 | 2 | 0.6757241 | 28342.79264776 | WBTC |
18 | 2024-01-27 00:00:00.000 | 79 | 46 | 113.118998535 | 256454.99 | ETH |
19 | 2024-01-27 00:00:00.000 | 28 | 19 | 167189.963885 | 167200.970598252 | USDC |
20 | 2024-01-27 00:00:00.000 | 3 | 3 | 0.0002967169881 | 0.7780240704 | wstETH |
freemartianDaily Swap From Assets
Updated 2024-01-29
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
›
⌄
-- forked from Daily Swap To Assets @ https://flipsidecrypto.xyz/edit/queries/6a1c1d8d-e0a1-4787-8f36-8c53cd43b3c5
-- ambient address: 0xaaaaaaaaa24eeeb8d57d431224f73832bc34f688
-- pool signature: 0xa15112f9
with
swap_from AS (
SELECT block_timestamp, tx_hash, origin_from_address AS swaper, 'ETH' AS symbol,
amount, amount_usd
FROM ethereum.core.ez_eth_transfers
WHERE eth_to_address = '0xaaaaaaaaa24eeeb8d57d431224f73832bc34f688'
AND origin_function_signature != '0xa15112f9'
UNION
SELECT block_timestamp, tx_hash, origin_from_address AS swaper,
(CASE
when contract_address = '0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2' THEN 'MKR'
ELSE symbol END) symbol,
amount, amount_usd
FROM ethereum.core.ez_token_transfers
WHERE to_address = '0xaaaaaaaaa24eeeb8d57d431224f73832bc34f688'
AND origin_function_signature != '0xa15112f9'
AND origin_function_signature NOT IN('0x729ad39e','0x60806040','0xece8c31c','0x616da87c','0x52efea6e')
),
swap_to AS (
SELECT block_timestamp, tx_hash, origin_from_address AS swaper, 'ETH' AS symbol,
amount, amount_usd
FROM ethereum.core.ez_eth_transfers
WHERE eth_from_address = '0xaaaaaaaaa24eeeb8d57d431224f73832bc34f688'
AND origin_function_signature != '0xa15112f9'
UNION
SELECT block_timestamp, tx_hash, origin_from_address AS swaper,
Last run: over 1 year agoAuto-refreshes every 3 hours
...
1260
80KB
56s