TX_HASH | BLOCK_TIMESTAMP | STAKER | STAKE_AMOUNT | |
|---|---|---|---|---|
1 | 0x3dbd064eaaa83b395edceb7812d2cdb36d1cdfe27a03a80bfdd42f54668764d3 | 2022-04-07 23:58:20.000 | 0x439a20037421812895a65e4b6789d71807212084 | 161017.127381 |
2 | 0x9aebe1ee7dc99d59a2c0e85547ddcc8e3044a26734c87ac7dbbbb97a3eac6c08 | 2022-04-07 12:47:41.000 | 0xff0fa1ea333d66a38a03ece567bf821fe43d678c | 20000 |
3 | 0xa1c38b703ef1b52c166f84f180d2a997a8cc84136659586f9c17879267f43d56 | 2022-04-07 10:44:31.000 | 0x9ed3b8751b7bdced67f953f018a6527f8d9820e2 | 33694.04 |
4 | 0xda1d537a1a889970c3028e23281b3018c4a7481a9dfc324fa8ef8d502b0fa6e4 | 2022-04-07 10:41:13.000 | 0x9ed3b8751b7bdced67f953f018a6527f8d9820e2 | 50345 |
5 | 0x231cae32e92d9d0dadc0238608bb4e811a7d678ca2423f02b086f05454819947 | 2022-04-07 10:14:02.000 | 0x6020efa75bd1ecd50c248edb3688a50c7f0683d5 | 5435 |
6 | 0x36bb65fe26d12c518a77f3679e6a579a03e1983ce9dd454336bd08d83917e928 | 2022-04-08 07:43:11.000 | 0xb44c96c62ae43ae1c2ab7ac8fb8fdd49896f47aa | 12800 |
7 | 0xd8fac10ca9f1e02e4123c6da0d3210ce66e73e0805be7f63fd59badfd361b0e1 | 2022-06-07 20:40:05.000 | 0x6f545118f41bf4389d95f1ebf9e3b251d94adf58 | 3470 |
8 | 0x8fc0d825b6f293921889e8d21916b099fe51434af7cfa77365243f1d721c4d5a | 2022-06-07 03:59:53.000 | 0xb44c96c62ae43ae1c2ab7ac8fb8fdd49896f47aa | 21406 |
9 | 0x098840c1e4a8cf65a7d3ac857bcb60752c3f5d2849bb2bba114d434332accbfb | 2022-06-07 14:40:52.000 | 0x00f52a1bb69418e0375e047cf029bc24b8e222b1 | 9237 |
10 | 0xef144cead6e1b3539d3f206c343122a3718736cb7307ad93742dd39f79bff6c8 | 2022-06-08 17:19:52.000 | 0xffcbc80a027b66e4d27fd0d439ff2a5f6fc53fc2 | 2000 |
11 | 0x6240360cec9cf955faa3fa01d7cdd6076e3ecb37a246291c09636c59286c630a | 2022-06-08 17:00:17.000 | 0x7bfee91193d9df2ac0bfe90191d40f23c773c060 | 10896.30872 |
12 | 0xe48d4a09bdb730be27a1a765a2c77c4023b89ee7b39586b6bff32a1ee8174d15 | 2022-06-08 13:53:45.000 | 0xba3d99f94b6d5ce18f6616bfa438c955ec865e7d | 10000 |
13 | 0x503d3f7f1849f5b133674e69a7a8dd5b28a16f048e771d2cdb9b12c955e75711 | 2022-06-09 00:25:53.000 | 0xae749df800f5b08840eb18d53352fc8cf1d3178f | 7040 |
14 | 0x28af649cc67b788837b650467eef102a672e5b7b1600f0eba7645f43d2015d15 | 2022-06-09 15:14:42.000 | 0x1dacae18bafb8df6970bab6d3fa1a930767be484 | 19852 |
15 | 0xd00580069c5279761056baaf372cbab82c0265f6200ed3b7659c441a1a627d53 | 2022-06-09 06:02:30.000 | 0x62d4feb1ed24f0345135c44ac209c98eb1da3346 | 12000 |
16 | 0x96890eec30abe455ea939ebd69c5cfafa84b71c6e537b6696598f95b0ca60b20 | 2022-06-10 00:43:25.000 | 0x596c3b8a30d9bc31dd066e83ee7130836adace07 | 16550 |
17 | 0xd21b30a2725603b10a268bd32d46867385f3a8fa27eb38edfc991be26d0905dc | 2024-07-29 17:30:09.000 | 0x81654daa2e297a140ca01f12367a4d9c9fc2bf51 | 0.5 |
18 | 0x03989217ef998cb0502504401ec8452787f99f4fe30be6b951990a541dbdd658 | 2024-08-01 02:37:39.000 | 0xaa0ab699559f41119a29247059f6f93edd5743e2 | 145930.68498 |
19 | 0x84ce7fa4312c340a442ea765197bc332f38cdfad6a8485d6aca662f005eafa76 | 2024-10-03 02:33:15.000 | 0xaa0ab699559f41119a29247059f6f93edd5743e2 | 72200.882889 |
20 | 0x4541b3fe7da1aeab4d0abf1084d87321924f34eedf4bbf04463ddeef8289e6be | 2021-12-20 16:49:52.000 | 0xeda6b8db5517b1b55d3c99dfed9b671a143f8d05 | 292.8 |
LittlerDatachanging-indigo copy
Updated 2025-03-01
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
32
33
34
35
36
›
⌄
⌄
with stakes as (
select
tx_hash
,block_timestamp
,utils.udf_hex_to_int(SUBSTRING(data, 1, 66)) AS stake_id
,concat('0x',SUBSTRING(data, 91, 40)) AS staker
,utils.udf_hex_to_int(SUBSTRING(data, 131))::int / 1e18 AS stake_Amount
from boba.core.fact_event_logs
where 1=1
--and block_timestamp > current_date - 5
and contract_address = '0x9fb3051148ff6efcd0b5ba0afa22eb0b9fc67a69'
and topic_0 = '0x0060a8caba85df807229fc2c649864fb5a7e4fe0f0582fb20615506e1a691cf9'
and tx_succeeded = 'TRUE'
--and tx_hash = '0x31ab09b3c70f229726a9592592b1a12141ed1c4950148e29a3e9243a91e42c8e'
)
select
tx_hash
,block_timestamp
,staker
,stake_amount
from stakes
/*
select
min(block_timestamp) as first_tx
,max(block_timestamp) as last_tx
,current_timestamp
,timediff('minute', last_tx, current_timestamp)
from boba.core.fact_transactions
*/
Last run: 19 days ago
...
1674
244KB
9s