aPrioriaPriori_TVL_Trend
    Updated 2 days ago
    with token_transfer_raw_dwd as
    (
    select
    BLOCK_TIMESTAMP
    ,TX_HASH
    ,from_address
    ,to_address
    ,transfer_value/1e18 as transfer_value
    ,EVENT_INDEX
    ,CONTRACT_ADDRESS
    from
    (
    select
    BLOCK_NUMBER
    ,BLOCK_TIMESTAMP
    ,TX_HASH
    ,EVENT_INDEX
    ,CONTRACT_ADDRESS
    ,TOPICS
    ,'0x' || RIGHT(TOPICS[1], 40) as from_address
    ,'0x' || RIGHT(TOPICS[2], 40) as to_address
    ,TOPIC_0
    ,TOPIC_1
    ,TOPIC_2
    ,TOPIC_3
    ,DATA as block_data
    ,ORIGIN_FROM_ADDRESS
    ,ORIGIN_TO_ADDRESS
    ,ORIGIN_FUNCTION_SIGNATURE
    ,TX_SUCCEEDED
    ,TRY_TO_NUMBER(utils.udf_hex_to_int(SUBSTR(DATA, 3))) AS transfer_value
    from monad.testnet.fact_event_logs
    where CONTRACT_ADDRESS in (lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A'),lower('0x08c49b39B1e369f924F6A579Fcbf45765E882454'))
    -- where CONTRACT_ADDRESS in (lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A'))
    and TX_SUCCEEDED
    -- and TX_HASH='0x11376bfba87753d01faa55b94da60c098cb8353dc050e7474f3f1c8061282d6d'
    Last run: 2 days ago
    STAT_DATE
    TVL_DELTA
    TVL
    1
    2025-02-18 00:00:00.0003.644322105.436885
    2
    2025-02-19 00:00:00.00029246.05163529351.48852
    3
    2025-02-20 00:00:00.000108240.029652137591.518172
    4
    2025-02-21 00:00:00.000125866.555755263458.073927
    5
    2025-02-22 00:00:00.00055547.872121319005.946048
    6
    2025-02-23 00:00:00.0001543.833796320549.779844
    7
    2025-02-24 00:00:00.00056180.543611376730.323455
    8
    2025-02-25 00:00:00.00053641.379092430371.702547
    9
    2025-02-26 00:00:00.00084011.672809514383.375356
    10
    2025-02-27 00:00:00.00025400.802819539784.178175
    11
    2025-02-28 00:00:00.000-4305.935785535478.24239
    12
    2025-03-01 00:00:00.00017590.316084553068.558474
    13
    2025-03-02 00:00:00.0008575.609307561644.167781
    14
    2025-03-03 00:00:00.00017731.444054579375.611835
    15
    2025-03-04 00:00:00.0001083.699152580459.310987
    16
    2025-03-05 00:00:00.0009567.267151590026.578138
    17
    2025-03-06 00:00:00.0006619.204487596645.782625
    18
    2025-03-07 00:00:00.0009611.45727606257.239895
    19
    2025-03-08 00:00:00.000-9718.666356596538.573539
    20
    2025-03-09 00:00:00.000-7224.536095589314.037444
    28
    1KB
    36s