freemartianLVN Pools New
Updated 2024-03-22
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
›
⌄
WITH datas AS(
SELECT
block_timestamp,
tx_id,
(CASE
WHEN msg:pool_id = '1325' THEN 'LVN-OSMO'
WHEN msg:pool_id = '1337' THEN 'LVN-USDC'
WHEN msg:pool_id = '1389' THEN 'LVN-ATOM'
WHEN msg:pool_id = '1415' THEN 'LVN-WOSMO'
END
) AS pool_name,
msg:sender AS wallet
FROM osmosis.core.fact_tx_body_msgs
WHERE
-- tx_id = '61F03AEC932667D0703B2E6ECBF57A4FAAF36E67B8F6AED5B79375984933A0CA'
msg:pool_id IN ('1325','1337','1389','1415')
AND block_timestamp::date >= '2023-01-10'
)
SELECT
block_timestamp::date AS day,
count(tx_id) AS transactions,
count(DISTINCT wallet) AS wallets,
pool_name
FROM datas
GROUP BY 1,4
QueryRunArchived: QueryRun has been archived