flipside

    LVN Pool - Daily Activities
    freemartianLVN Pool - Daily Activities
    Updated 2024-02-06
    WITH tbl AS (
    SELECT *
    FROM osmosis.core.fact_msg_attributes
    WHERE msg_type IN ('withdraw_position','create_position')
    AND attribute_key = 'pool_id'
    AND attribute_value IN ('1325','1337')
    AND block_timestamp::date >= '2023-01-10'
    ORDER BY tx_id ASC, attribute_index ASC
    ),

    tbl2 AS(
    SELECT
    block_timestamp, tx_id, msg_type,attribute_index, attribute_key, attribute_value
    FROM osmosis.core.fact_msg_attributes
    WHERE tx_id IN (SELECT tx_id FROM tbl)
    AND msg_type IN ('withdraw_position','create_position','add_to_position')
    ORDER BY tx_id ASC, attribute_index ASC
    ),

    datas AS(
    SELECT
    block_timestamp,
    tx_id,
    msg_type,
    object_agg(CAST(ATTRIBUTE_KEY AS VARCHAR), CAST(ATTRIBUTE_VALUE AS VARIANT)) AS obj
    FROM tbl2
    WHERE tx_id IN (SELECT tx_id FROM tbl)
    GROUP BY 1,2,3;
    ),

    ranked AS (
    SELECT
    block_timestamp,
    tx_id,
    msg_type,
    obj,
    Last run: about 1 year agoAuto-refreshes every 12 hours
    POOL_NAME
    DAY
    TX_COUNT
    SENDER_COUNT
    1
    		LVN-OSMO2023-12-18 00:00:00.000457286
    2
    		LVN-USDC2024-01-12 00:00:00.0009616
    3
    		LVN-USDC2024-01-29 00:00:00.0003518
    4
    		LVN-USDC2024-01-05 00:00:00.0006715
    5
    		LVN-OSMO2024-01-10 00:00:00.0003226
    6
    		LVN-OSMO2024-01-24 00:00:00.0007619
    7
    		LVN-USDC2024-01-27 00:00:00.0006115
    8
    		LVN-USDC2024-01-28 00:00:00.000587
    9
    		LVN-USDC2024-02-04 00:00:00.000377
    10
    		LVN-USDC2024-02-06 00:00:00.000125
    11
    		LVN-USDC2024-01-20 00:00:00.0001211
    12
    		LVN-USDC2024-01-16 00:00:00.0006326
    13
    		LVN-OSMO2024-02-05 00:00:00.0004015
    14
    		LVN-USDC2024-02-05 00:00:00.000295
    15
    		LVN-USDC2024-01-30 00:00:00.0002214
    16
    		LVN-OSMO2024-01-28 00:00:00.0005317
    17
    		LVN-OSMO2023-12-09 00:00:00.00063
    18
    		LVN-OSMO2023-12-19 00:00:00.000715238
    19
    		LVN-USDC2023-12-19 00:00:00.0008649
    20
    		LVN-USDC2024-01-14 00:00:00.0008123
    ...
    108
    5KB
    555s