TX_HASH | BLOCK_TIMESTAMP | TWITTER_ID | USERNAME | YAP_POINTS | TIMESTAMP | POSITION | |
|---|---|---|---|---|---|---|---|
1 | 0xe851e9c895e9966347383c199eed114094ed5a7721c053c8a150d8612167fdf6 | 2025-03-11 09:26:31.000 | 1099790079294287872 | lokithebird | 999 | 2025-03-01 00:00:00.000 | 1 |
2 | 0xe851e9c895e9966347383c199eed114094ed5a7721c053c8a150d8612167fdf6 | 2025-03-11 09:26:31.000 | 1482640180855160832 | banditxbt | 997 | 2025-03-01 00:00:00.000 | 2 |
3 | 0xe851e9c895e9966347383c199eed114094ed5a7721c053c8a150d8612167fdf6 | 2025-03-11 09:26:31.000 | 1056015925667942400 | ChartFuMonkey | 996 | 2025-03-01 00:00:00.000 | 3 |
4 | 0xe851e9c895e9966347383c199eed114094ed5a7721c053c8a150d8612167fdf6 | 2025-03-11 09:26:31.000 | 1068950834 | IAmNickDodson | 996 | 2025-03-01 00:00:00.000 | 4 |
5 | 0xe851e9c895e9966347383c199eed114094ed5a7721c053c8a150d8612167fdf6 | 2025-03-11 09:26:31.000 | 2650025562 | The__Solstice | 996 | 2025-03-01 00:00:00.000 | 5 |
6 | 0xe851e9c895e9966347383c199eed114094ed5a7721c053c8a150d8612167fdf6 | 2025-03-11 09:26:31.000 | 958495164686917632 | Justin_Bons | 995 | 2025-03-01 00:00:00.000 | 6 |
7 | 0xe851e9c895e9966347383c199eed114094ed5a7721c053c8a150d8612167fdf6 | 2025-03-11 09:26:31.000 | 80722677 | TimBeiko | 994 | 2025-03-01 00:00:00.000 | 7 |
8 | 0x87cd916b25c959a7a4c9a2fc0ad4b7d1a297a3c227d4ae357a2ccd9608ee3ac6 | 2025-03-11 09:25:39.000 | 1499585375534206980 | beast_ico | 9934 | 2025-03-01 00:00:00.000 | 8 |
9 | 0xe851e9c895e9966347383c199eed114094ed5a7721c053c8a150d8612167fdf6 | 2025-03-11 09:26:31.000 | 1435408360023670786 | 0xDesigner | 991 | 2025-03-01 00:00:00.000 | 9 |
10 | 0xe851e9c895e9966347383c199eed114094ed5a7721c053c8a150d8612167fdf6 | 2025-03-11 09:26:31.000 | 787634466 | CryptoJelleNL | 990 | 2025-03-01 00:00:00.000 | 10 |
11 | 0x0414ac2cf49d3f9557bc64471ed6f6190207389c67f1a48d5fd69c4f8df82841 | 2025-01-05 09:34:07.000 | 1354329758755147776 | iamTiwaa | 99 | 2025-01-01 00:00:00.000 | 11 |
12 | 0x0414ac2cf49d3f9557bc64471ed6f6190207389c67f1a48d5fd69c4f8df82841 | 2025-01-05 09:34:07.000 | 1477305214046810117 | Trim_Bot | 99 | 2025-01-01 00:00:00.000 | 12 |
13 | 0x0414ac2cf49d3f9557bc64471ed6f6190207389c67f1a48d5fd69c4f8df82841 | 2025-01-05 09:34:07.000 | 1537512051337306112 | heather11666 | 99 | 2025-01-01 00:00:00.000 | 13 |
14 | 0x0414ac2cf49d3f9557bc64471ed6f6190207389c67f1a48d5fd69c4f8df82841 | 2025-01-05 09:34:07.000 | 2241233808 | byteboro | 99 | 2025-01-01 00:00:00.000 | 14 |
15 | 0x8cd5d1d139d3f734a2e2c54a251384eb184e1deb5f406a97c159015ef7770461 | 2025-03-11 09:26:37.000 | 298491091 | MetamateDaz | 987 | 2025-03-01 00:00:00.000 | 15 |
16 | 0x8cd5d1d139d3f734a2e2c54a251384eb184e1deb5f406a97c159015ef7770461 | 2025-03-11 09:26:37.000 | 1319287761048723458 | MarioNawfal | 984 | 2025-03-01 00:00:00.000 | 16 |
17 | 0x8cd5d1d139d3f734a2e2c54a251384eb184e1deb5f406a97c159015ef7770461 | 2025-03-11 09:26:37.000 | 943869911293726720 | Pickle_cRypto | 983 | 2025-03-01 00:00:00.000 | 17 |
18 | 0x0414ac2cf49d3f9557bc64471ed6f6190207389c67f1a48d5fd69c4f8df82841 | 2025-01-05 09:34:07.000 | 11922492 | jmj | 98 | 2025-01-01 00:00:00.000 | 18 |
19 | 0x0414ac2cf49d3f9557bc64471ed6f6190207389c67f1a48d5fd69c4f8df82841 | 2025-01-05 09:34:07.000 | 1371024834545717251 | MuddyRC | 98 | 2025-01-01 00:00:00.000 | 19 |
20 | 0x0414ac2cf49d3f9557bc64471ed6f6190207389c67f1a48d5fd69c4f8df82841 | 2025-01-05 09:34:07.000 | 1484177021596889092 | 0xkaiserkarel | 98 | 2025-01-01 00:00:00.000 | 20 |
Sandeshkaito yap leaderboard
Updated 2025-03-17
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
›
⌄
-- credits to 0xdatawolf for suggesting we use schema id to be sure only kaito attestaions are included.
-- and sam for suggesting to use traces table, this will allow us to identify the attestation irrespective of who signs it.
WITH kaito_write_txn as
(
select tx_hash from base.core.fact_traces
where 1=1
and block_timestamp >= '2025-01-05'
and to_address='0xbeb5fc579115071764c7423a4f12edde41f106ed'
and substr(input,0,10)='0x44adc90e'
and type='DELEGATECALL'
and trace_status='SUCCESS'
and tx_status='SUCCESS'
)
,temp AS (
SELECT
tx_hash, block_timestamp,
regexp_substr_all(SUBSTR(input, 11), '.{64}') AS segmented,
concat('0x', segmented[3]) AS schema,
utils.udf_hex_to_int(segmented[5]) AS records,
ARRAY_SLICE(segmented, 6 + utils.udf_hex_to_int(segmented[5]), 1000) AS data_array
FROM base.core.fact_traces
WHERE tx_hash in (select tx_hash from kaito_write_txn)
and block_timestamp >= '2025-01-05'
and to_address='0xbeb5fc579115071764c7423a4f12edde41f106ed'
and substr(input,0,10)='0x44adc90e'
and type='DELEGATECALL'
and trace_status='SUCCESS'
and tx_status='SUCCESS'
AND schema='0xcb66276cf243e78fad68dd5e633f7bb56814b49ac9a91256615340591577a0e8'
),
exploded AS (
SELECT
tx_hash,
block_timestamp,
value,
Last run: about 1 month ago
...
1402
226KB
156s