DAY | TX_COUNT | USERS_COUNT | FIRST_ASSET_AMOUNT | FIRST_ASSET_AMOUNT_USD | SECOND_ASSET_AMOUNT | SECOND_ASSET_AMOUNT_USD | POOL_NAME | LABEL | |
|---|---|---|---|---|---|---|---|---|---|
1 | 2024-01-29 00:00:00.000 | 3 | 3 | -407.119599 | -94.772362518 | -0.06129678605 | -135.6 | USDC-ETH | remove |
2 | 2024-01-29 00:00:00.000 | 2 | 2 | 0.1817766316 | 425.617258445 | 0.196454807 | 442.22 | swETH-ETH | add |
3 | 2024-01-29 00:00:00.000 | 5 | 4 | 68.163192 | 48.171993773 | 0.03155350855 | 51.01 | USDC-ETH | add |
4 | 2024-01-29 00:00:00.000 | 1 | 1 | -4.01812764 | -12.737464619 | -2.029428534 | -4568.26 | LDO-ETH | remove |
5 | 2024-01-29 00:00:00.000 | 1 | 1 | 0.009862976141 | 23.251589779 | 20 | 20.001875776 | swETH-USDC | add |
6 | 2024-01-28 00:00:00.000 | 7 | 7 | 938.829489 | 938.672990811 | 0.4177237654 | 950.37 | USDC-ETH | add |
7 | 2024-01-28 00:00:00.000 | 1 | 1 | -0.0001902 | -7.945450408 | -0.5816326979 | -1311.3 | WBTC-ETH | remove |
8 | 2024-01-28 00:00:00.000 | 9 | 9 | -1027.994682 | -1027.226486931 | -0.7151270495 | -1630.44 | USDC-ETH | remove |
9 | 2024-01-27 00:00:00.000 | 1 | 1 | -1.111202121 | -2232.216157713 | -1.865409114 | -4233.08 | MKR-ETH | remove |
10 | 2024-01-27 00:00:00.000 | 6 | 6 | -713.585658 | -713.533850377 | -0.06075434926 | -137.83 | USDC-ETH | remove |
11 | 2024-01-27 00:00:00.000 | 1 | 1 | 0.00543021 | 226.53750078 | 0.1029171755 | 233.63 | WBTC-ETH | add |
12 | 2024-01-27 00:00:00.000 | 12 | 12 | 1446.807193 | 1446.275606195 | 0.6448245241 | 1463.03 | USDC-ETH | add |
13 | 2024-01-27 00:00:00.000 | 1 | 1 | 0.03236499158 | 76.311148095 | 55.841388 | 55.841388 | swETH-USDC | add |
14 | 2024-01-26 00:00:00.000 | 1 | 1 | -1555.502109 | -1555.040124874 | -1571.055113 | -1570.624643899 | USDT-USDC | remove |
15 | 2024-01-26 00:00:00.000 | 8 | 8 | -716.57005 | -717.192721496 | -2.430995558 | -5494.96 | USDC-ETH | remove |
16 | 2024-01-26 00:00:00.000 | 1 | 1 | 559.348034 | 558.757362476 | 564.940833 | 564.940833 | USDT-USDC | add |
17 | 2024-01-26 00:00:00.000 | 2 | 2 | 0.11886362 | 4764.43745478 | 2.164759433 | 4817.07 | WBTC-ETH | add |
18 | 2024-01-26 00:00:00.000 | 7 | 7 | 1790.160874 | 1789.909341859 | 0.8368899264 | 1889.4 | USDC-ETH | add |
19 | 2024-01-25 00:00:00.000 | 1 | 1 | 1963.172005 | 1962.683175171 | 0.8875614843 | 1969.45 | USDT-ETH | add |
20 | 2024-01-25 00:00:00.000 | 6 | 6 | 8842.081727 | 8834.601946912 | 3.973940951 | 8731.9 | USDC-ETH | add |
freemartianDaily Pools on Ambient Finance
Updated 2024-01-29
999
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
›
⌄
-- ambient address: 0xaaaaaaaaa24eeeb8d57d431224f73832bc34f688
-- pool signature: 0xa15112f9
with
-- eth AS(
-- SELECT block_timestamp, tx_hash, origin_from_address, 'ETH' AS symbol,
-- amount, amount_usd, 2 AS mark
-- FROM ethereum.core.ez_eth_transfers
-- WHERE eth_to_address = '0xaaaaaaaaa24eeeb8d57d431224f73832bc34f688'
-- AND origin_function_signature = '0xa15112f9'
-- ),
-- tokens AS(
-- SELECT block_timestamp, tx_hash, origin_from_address, symbol,
-- amount, amount_usd, RANK() OVER(PARTITION BY tx_hash ORDER BY _log_id) AS mark
-- FROM ethereum.core.ez_token_transfers
-- WHERE to_address = '0xaaaaaaaaa24eeeb8d57d431224f73832bc34f688'
-- AND origin_function_signature = '0xa15112f9'
-- ),
datas_add AS (
SELECT block_timestamp, tx_hash, origin_from_address, 'ETH' AS symbol,
amount, amount_usd, 2 AS mark
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,
(CASE
when contract_address = '0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2' THEN 'MKR'
ELSE symbol END) symbol,
amount, amount_usd, RANK() OVER(PARTITION BY tx_hash ORDER BY _log_id DESC) AS mark
FROM ethereum.core.ez_token_transfers
WHERE to_address = '0xaaaaaaaaa24eeeb8d57d431224f73832bc34f688'
AND origin_function_signature = '0xa15112f9'
Last run: about 1 year agoAuto-refreshes every 3 hours
...
1646
159KB
108s