SocioAnalyticaFact Vote Escrow
    Updated 2025-02-25

    SELECT
    block_timestamp,
    block_number,
    tx_hash,
    sender,
    payload:arguments[1] as duration_locked_week,
    payload:arguments[0]/pow(10,b.decimals) as value_locked,
    payload:type_arguments[0] as token_address,
    b.symbol,
    payload_function as contract_address
    FROM aptos.core.fact_transactions a
    JOIN aptos.core.dim_tokens b ON a.payload:type_arguments[0] = b.token_address
    WHERE payload_function = '0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scripts::lock'
    ORDER BY block_timestamp DESC



    Last run: 2 months ago
    BLOCK_TIMESTAMP
    BLOCK_NUMBER
    TX_HASH
    SENDER
    DURATION_LOCKED_WEEK
    VALUE_LOCKED
    TOKEN_ADDRESS
    SYMBOL
    CONTRACT_ADDRESS
    1
    2025-02-23 19:08:25.378
    294674312
    0x61a0b541cee264e1de2b9df547f349d3e2b5f88d0db5530d33aa2ebd1ae298000x66f1a1fdcdffb788d5fdbc38f255f57f057747ecf7563a197847c7eee725c540
    4
    2420.93213512
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    2
    2025-02-23 14:39:11.782
    294593062
    0x9d0946b1ac0dd65854dc3d833ff68d2f94b902053a242f71fe65ffd7c17b52b20x50307cd48e5c8ee7dfbdafd39e5a4463acdf5f8a99447c3da351a07d6c2818a0
    4
    508.48895573
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    3
    2025-02-23 04:20:58.813
    294399026
    0xd9770a078b20519d478d1e32d473ad045d2dd1e23c45741f9e538a1a3f3c619a0xd498c46db1a796b70218621f0b7c8207f3cd24544d2f3dbc0a614310ef842316
    52
    1
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    4
    2025-02-21 12:35:25.333
    293652143
    0xf8301277467ce11eac1a96992c5049bb3e6b9820124e98c1357a9aa9ce7b69aa0x243dd44823bcec43a9126cf1b6e6431a339ba215b4f32c6deccf2d1344431a4
    52
    27.65121621
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    5
    2025-02-20 00:31:53.721
    292979926
    0x4b24d6fd7671a0d4fcc722af1981715b1ffcb896e396c5d899473d6e9305dc9c0x5ea44eed1643ece0ceec2d1c89f2d575ed45db40b4b873d29a4f31f4ad0b3b88
    27
    3845.58921127
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    6
    2025-02-19 15:10:49.730
    292803491
    0x6dd1a1e00778b38c74809f0684b6c3f14da0b970da63a43df591167d122275ac0x4247a871b1f0fd2266de338446b0d2bbbcf2ba8de22be4f6ad9f289df0308363
    52
    23.20242865
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    7
    2025-02-19 13:31:51.364
    292773031
    0x2bcc6a06f06509f63cb61ff894251709f81cadc03c8c2b4008113dd887011e0b0x1a9ce8f17d2a47d5c29c25b1bc0f380bf81f4c8a1029e1d4eb8b3471e9ef0543
    4
    152.48043174
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    8
    2025-02-19 11:47:35.298
    292740773
    0x36b10ef7c7e99031ea7a83cd014af2a32ebf2edd9b400f6454157e5af6517ad30xdd284fb30311654251f1bc7ee9293962e1f28177534a56185ad5a553a72ed911
    2
    1
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    9
    2025-02-18 01:08:35.825
    292098375
    0xcba74f893e406d1023e2411131481ef7af81c7035607913e98d271da26182db40x18d5e8149deea2498a73601da4943452699b72c3ebfdd1c3eeffb8b33ac9b59e
    2
    2
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    10
    2025-02-17 14:29:52.819
    291898185
    0x2642238fd654726708176bbbd71a307389fa484068800de01009cd8fdbc864970x92ea028d6378719f8439db3a1af9a0be285723f6ed6339725d188342363a9380
    16
    78.44667727
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    11
    2025-02-17 07:30:33.578
    291769129
    0xca894143b1ee4decc766eb610419ce14fd079933148737e7a2d9028f10e88afa0xc505c6201b7191abb742c82b72e02c59e5b9600383007a9f6b4225c0530ff064
    52
    161366.92932241
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    12
    2025-02-14 12:18:24.270
    290495044
    0x7552d846bb085ccfd025f4b15bbd76c5f7a9975c27d150b1d0d54cacf979daac0x4ab12f226319c002beac85e390aa7479fb0a6a0cb55bb37a74f647a0b41bd4bc
    2
    4000
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    13
    2025-02-13 16:32:35.914
    290118661
    0xad4c90418d382eb15929a569d18b01b60c1e3947888f1587b2886bb1e0c6c9f00xb956750fe9cb9055538225eb7db4c711f48b5c57002bbce37e9878c7d5931aed
    40
    10
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    14
    2025-02-13 10:24:20.334
    290004119
    0x2e240c1517897dac3e05d3d88e9920704b1f58495e979fbe714b137fa6e86d140xe5e0e715936a8be010064805eb53dfaa34dc611a6d9afe5bdd859e44476471c7
    52
    3.20522733
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    15
    2025-02-12 18:14:06.759
    289697562
    0x188b909439c1786d9626b36449021dda79fb9e3d39c6942281bc537ecb12ef3b0x98c1204cec461f2781c5558417cb7ee8a02ce9a78c3ba340c556bf82d05416d6
    5
    1000
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    16
    2025-02-12 01:35:50.757
    289387353
    0x40cc895e6ae67a23a5a7d6a881565ed8377a64ae0e3b588a69cdaeace27e5d1e0x44eb07a1720320336f38c672dc8e8e1d02558bdb4ea5cc8234a2a6f7c6523a9c
    52
    6.28
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    17
    2025-02-10 08:33:48.420
    288614473
    0x4031eb8951cb822041ffa669e95697a05748bdda0b1d5cabcd0945a82ef352140x28e3ec9d1397f0d8b42ca7c4f0c2a56ecb24daf410571801527f72ac234923ec
    4
    330.11262919
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    18
    2025-02-09 13:00:07.975
    288250231
    0x79469959e7def836b198e797f09f08699b5738aee315fb23d4fa824e8435e46c0x1cb7af6282656abae5dc21179b450442b4904a2a44a0df0c1db1e68a01cde481
    3
    6422.71020209
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    19
    2025-02-08 14:35:08.383
    287834176
    0x13da85b41c8f9ee98bce8507ad27893c3d8b77970ffa3eff3e5116cfde61f3980x6bc7deed9225617da1e42a562ed734b40042d4ef20235414d8aadde8609dff30
    52
    0.00426612
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    20
    2025-02-08 07:52:31.474
    287710488
    0x94cb68b9c764a679df226e811f98e6dcb14d10f77c8eef24527ea4ab5af5f0680x57690cb4df608e131d931248e68a5de8c31663e0e90f3d8cdd24e0f0795b0022
    2
    128.17910635
    0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL
    THL
    0x167f411fc5a678fb40d86e0af646fa8f62458b686ad8996215248447037af40c::scri...
    ...
    10603
    5MB
    91s