mahdir007Untitled Query
Updated 2022-09-03
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
›
⌄
-- SELECT count(*)
-- FROM ethereum.uniswapv3.ez_pool_stats
-- ORDER BY 'BLOCK_TIMESTAMP'
-- -- limit 2
SELECT t1.* FROM ethereum.uniswapv3.ez_pool_stats t1
JOIN (SELECT DATE(ethereum.uniswapv3.ez_pool_stats.BLOCK_TIMESTAMP) date_date, userid, MAX(date) max_date
FROM ethereum.uniswapv3.ez_pool_stats
GROUP BY date_date, userid
) t2
ON t1.date = t2.max_date AND t1.userid = t2.userid;
-- SELECT count(*)
-- FROM ethereum.uniswapv3.ez_pool_stats t
-- JOIN (SELECT MAX(t.BLOCK_TIMESTAMP) 'maxtimestamp'
-- FROM ethereum.uniswapv3.ez_pool_stats tt
-- GROUP BY date(tt.timestamp)) m ON m.maxtimestamp = t.BLOCK_TIMESTAMP
-- SELECT count(ethereum.uniswapv3.ez_pool_stats.*)
-- FROM ethereum.uniswapv3.ez_pool_stats t1
-- INNER JOIN
-- (
-- SELECT DATE(BLOCK_TIMESTAMP) AS trade_date, MAX(BLOCK_TIMESTAMP) AS max_trade_time
-- FROM ethereum.uniswapv3.ez_pool_stats
-- GROUP BY DATE(BLOCK_TIMESTAMP)
-- ) t2
-- ON t2.trade_date = DATE(t1.BLOCK_TIMESTAMP) AND
-- t2.max_trade_time = t1.BLOCK_TIMESTAMP
-- ORDER BY
-- t1.BLOCK_TIMESTAMP;
Run a query to Download Data