search

MetricsDAO / harmony_dbt

DBT Project for the Harmony Blockchain
12 stars 8 forks source link

Ingest Staking Transactions #81

Open antonyip opened 2 years ago

antonyip commented 2 years ago

As a analyst, I'd like to be able to extract staking transactions from the blockchain. The current chainwalker does not have this information.

This new ingestion mechanism ingests blocks differently.

select * from ingest.public.blocks
where ingest_timestamp = '2022-03-13T14:19:21.744Z'
{ "type" : "hmy_getBlockByNumber", subtype:"0x16D662B", "data":{"jsonrpc":"2.0","id":"mdao_hmy_getBlockByNumber","result":{"number":"0x16d662b","viewID":"0x16d6ec8","epoch":"0x387","hash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","parentHash":"0xdb50b708a984747128917a4a43f67187e5925e1ccfe4f8ad7549d50881649be3","nonce":0,"mixHash":"0x0000000000000000000000000000000000000000000000000000000000000000","logsBloom":"0x00000000010000111008000204000200000000000800000000200000000002000020102000008000000012000000000000002000000004000800080000000000000008000400000800000008000008000000000200010000000000000000000000000002a300000000004001020008200000000000000010040c00102000022020000130000010911c000014004300000000000000004000180000000000000000000100000020004011000240000000011800c0000000000100020088028080200201020080000000000000e00000000081800000000000040c0480000020004004000000000000000400000800000000008201100008010000000000800200","stateRoot":"0xef9249a65f2b3d276992ef23443608fdf8ccd98cf94fd8d72ec1265deef9592c","miner":"one1w4ekumvg88ex5txjrzk9qgfx3xheua4djrphld","difficulty":0,"extraData":"0x","size":"0x26d2","gasLimit":"0x4c4b400","gasUsed":"0x599099","vrf":"0x9c296459a1541b864ce376fd2669e2d999ee7a7c50c3075037cb99c794708f8b","vrfProof":"0x89a8b06795b2ae741c52f5fbaa43538b3230420993f28a14e33b6a1a787f715258be92162a27bcca2f163becfbc611101db98e0d907efe075e5d25b771f90c1668734e63e0c0b3ca901de962f2d5de7de80d12d8cd0d44c698ff952e1725b18d","timestamp":"0x622bb554","transactionsRoot":"0xc47b34639265e06c80d4a109a7734d2f5b68212811c2393cc9a1a45da481aa64","receiptsRoot":"0x74a5b41d0ef751c6306cdbeab13cdec01021879c8641fe3ee0683374a362859c","uncles":[],"transactions":[{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one1wuhrarh6f520zzgnar9w2jvphg53qx9ry307k7","timestamp":"0x622bb554","gas":"0xab669","gasPrice":"0xd5fc69533","hash":"0xac8bdd45e18e328304d8faa396a748d48f1890a843e2e567d5e16e8cd0518fc5","ethHash":"0xcf265eb54756f6a0b6e3330613ae2212d2addf0ba03276054bf295b88d71ebc4","input":"0x2bbffd060000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000622bb7aa00000000000000000000000000000000000000000000000000000000000000050000000000000000000000006983d1e6def3690c4d616b13597a09e6193ea013000000000000000000000000cf664087a5bb0237a0bad6742852ec6c8d69a27a0000000000000000000000000dc78c79b4eb080ead5c1d16559225a46b580694000000000000000000000000224e64ec1bdce3870a6a6c777edd450454068fec0000000000000000000000006983d1e6def3690c4d616b13597a09e6193ea0130000000000000000000000000000000000000000000000000000000000000004000000000000000000000000bc132b3a5a345069846c5e6f49fe28fec01e7c4700000000000000000000000029c1e9fc7a4c19c8fcaf2d2b2de213ef0f323f0c000000000000000000000000d7e332b4c9f97ea6d05db8c38f133307ad8847f30000000000000000000000009293dfdd719ee2163f2e158e66ef75722ed712b4000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f2","nonce":"0x1f54","to":"one1d8ldfcv5mj7djqwjd5nxrahq68s3m2dly2cj4r","transactionIndex":"0x0","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a3","r":"0xe4c1d4da35f9dc022ac4ed1baf7570e5ae4588ecdd4540d9389e197b13668089","s":"0x1f64c021b487d746ddbc5ea5f6161832e90d662019aad1cc7e0841e84d4856ba"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one1ksunwtqt03kqhv7kmqsx0kqdg3q80e54vgdfhn","timestamp":"0x622bb554","gas":"0xd881c","gasPrice":"0xc56a4abf5","hash":"0x23d2c340959b410bb52c8550a92647ec647c04c702a9390e16ff475dbabd0a19","ethHash":"0x7ee525435e8f036f9c771ab2e15ccd98ac9f7ad4d5460242493a2778106f7073","input":"0x2bbffd060000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000622bb7aa0000000000000000000000000000000000000000000000000000000000000005000000000000000000000000224e64ec1bdce3870a6a6c777edd450454068fec000000000000000000000000985458e523db3d53125813ed68c274899e9dfab4000000000000000000000000cf664087a5bb0237a0bad6742852ec6c8d69a27a0000000000000000000000000dc78c79b4eb080ead5c1d16559225a46b580694000000000000000000000000224e64ec1bdce3870a6a6c777edd450454068fec000000000000000000000000000000000000000000000000000000000000000400000000000000000000000059b1455a5f4e841225c88197b94eee92eda883a800000000000000000000000027f0bcb74822df54f36151434999cbc8db07d4d900000000000000000000000029c1e9fc7a4c19c8fcaf2d2b2de213ef0f323f0c000000000000000000000000d7e332b4c9f97ea6d05db8c38f133307ad8847f3000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f2","nonce":"0x3908","to":"one1d8ldfcv5mj7djqwjd5nxrahq68s3m2dly2cj4r","transactionIndex":"0x1","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a3","r":"0x8e47dae547c67072f9d7add780e7eadd5eb395d5104617591363b68dc4bd9f06","s":"0x1e7498cf51e94e30482c4232f4cbe5eaf90d7ab732cfd6ce920b30676bc68b4b"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one16atgjzecew09jndlckmh0rlrc6fehjjf2qadpf","timestamp":"0x622bb554","gas":"0x8110f","gasPrice":"0xc34c540e3","hash":"0xb97016982749a76bb01280ab391b2dc1f1e9fc732eb92e719e678c55a87db56c","ethHash":"0x8f244e82844e394545e1a0b81756b5c4732387e8714d2b135ee15b8db5add74c","input":"0x2bbffd060000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000012000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000622bb7aa00000000000000000000000000000000000000000000000000000000000000040000000000000000000000002a719af848bf365489e548be5edbec1d65858e59000000000000000000000000cf1709ad76a79d5a60210f23e81ce2460542a836000000000000000000000000cf664087a5bb0237a0bad6742852ec6c8d69a27a0000000000000000000000002a719af848bf365489e548be5edbec1d65858e5900000000000000000000000000000000000000000000000000000000000000030000000000000000000000005208345c1539348ceb0ba20d6f7cb23c1091ab05000000000000000000000000643f94fc0a804ea13adb88b9e17244bf94022a2500000000000000000000000008de72c31ecf51dda637624d1e767578d1914dca000000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f2","nonce":"0x1ebf","to":"one1d8ldfcv5mj7djqwjd5nxrahq68s3m2dly2cj4r","transactionIndex":"0x2","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a4","r":"0x81e4fa9aad6a91bcde50d3f284e22824ed31c650bc474af400ee012245e62433","s":"0x31fe2827d9440cf46a9c246b6e126f19b759e8ff38d1f3e4ddf43ce90c733730"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one1xqfyu7qgl0r7mr7kcxxhgdgpj8s20en692hmq2","timestamp":"0x622bb554","gas":"0xac9f7","gasPrice":"0xbce0592c2","hash":"0x0e1dbba7ba835c88e3513c918342948e711c761b92b9b8d3c8ffcc2f5575ec44","ethHash":"0xf3427a744e0d110b9bd08a1871ece83ce051e0b84004376c3634c1d4edd431a4","input":"0x2bbffd060000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000622bb7aa000000000000000000000000000000000000000000000000000000000000000500000000000000000000000072cb10c6bfa5624dd07ef608027e366bd690048f000000000000000000000000cf664087a5bb0237a0bad6742852ec6c8d69a27a0000000000000000000000000dc78c79b4eb080ead5c1d16559225a46b580694000000000000000000000000224e64ec1bdce3870a6a6c777edd450454068fec00000000000000000000000072cb10c6bfa5624dd07ef608027e366bd690048f0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000eb579ddcd49a7beb3f205c9ff6006bb6390f138f00000000000000000000000029c1e9fc7a4c19c8fcaf2d2b2de213ef0f323f0c000000000000000000000000d7e332b4c9f97ea6d05db8c38f133307ad8847f3000000000000000000000000b91a0dfa0178500fedc526f26a89803c387772e8000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f2","nonce":"0x1f67","to":"one1d8ldfcv5mj7djqwjd5nxrahq68s3m2dly2cj4r","transactionIndex":"0x3","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a4","r":"0xf5adeabb59d1f3c83b738a16bb79dd7b8a0e61763be1cc84ea049bf476715d90","s":"0xda8519255032a9510c9a0b403bb8f23cfde107a469a4562d2703ee555fb98d2"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one1z75jucgfke953k5y4vlkl0vx5d2e7m82p48fxa","timestamp":"0x622bb554","gas":"0xa3f01","gasPrice":"0x9259f3942","hash":"0x1ee7250345328862c94a599fc91f79060397090fa926fab7d38dba1d7f8e0e40","ethHash":"0xc918606b5d9f1af319da0ea3ed581c01f5da5c6675c6b49c538b3dfd8e905d7a","input":"0x2bbffd060000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000622bb7aa000000000000000000000000000000000000000000000000000000000000000500000000000000000000000095ce547d730519a90def30d647f37d9e5359b6ae000000000000000000000000cf664087a5bb0237a0bad6742852ec6c8d69a27a000000000000000000000000985458e523db3d53125813ed68c274899e9dfab400000000000000000000000072cb10c6bfa5624dd07ef608027e366bd690048f00000000000000000000000095ce547d730519a90def30d647f37d9e5359b6ae0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000902737d2643fb1445b3b4188ec15e6dd6c3f8ce700000000000000000000000027f0bcb74822df54f36151434999cbc8db07d4d9000000000000000000000000a1221a5bbea699f507cc00bdedea05b5d2e32eba000000000000000000000000b6e9754b90b338ccb2a74fa31de48ad89f65ec5e000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f2","nonce":"0x3766","to":"one1d8ldfcv5mj7djqwjd5nxrahq68s3m2dly2cj4r","transactionIndex":"0x4","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a4","r":"0xf3e8055cde5b7fe118aad1998bf940e87f16c37ddbc15f3ade753240585272ab","s":"0x4380f639ab04aa678b7067f394eedde17a23c4191a90f9816ff1c419ee9f4479"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one1ydjypxq62yrmaw3kpwk77tn0rw8ja7gvzsnfss","timestamp":"0x622bb554","gas":"0x7a120","gasPrice":"0x8f8dab952","hash":"0xa7834f3df3a56b62967e6966ba082df422b1b80eb5e773a95cb3708d88cf1057","ethHash":"0x02242a8929b92b421fbaedb2a3b23e1b9df29b7025f506429a7dcf2df5965d95","input":"0x8ea709f3","nonce":"0x28983e","to":"one1ld7httx6t2sxef5zwx25qq5wu2zecevaake6dd","transactionIndex":"0x5","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a3","r":"0x94e34787b006a9d2d8dd179999a1fe0c5066ca2af548a02f5e467ea6b32532ad","s":"0x3340084830d617234ad1fbe55b27ff843ac38e4101cb91db5bc3e6f61219ad06"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one1ra0ych2xtrymd27yktktlwyrcsmced2fexeqyy","timestamp":"0x622bb554","gas":"0x190332","gasPrice":"0x861c46800","hash":"0xca8d74f8224ea76aa1211dae922431abe959b9181586aac9f9d2044ee1b7a7c0","ethHash":"0xc5388bcb1e38608297e7f3af65c0aef123eb329446639a3de45d417819233eb9","input":"0xe5546f370000000000000000000000000000000000000000000010f0dce7048939640000000000000000000000000000985458e523db3d53125813ed68c274899e9dfab4000000000000000000000000cf664087a5bb0237a0bad6742852ec6c8d69a27a000000000000000000000000c35dadb65012ec5796536bd9864ed8773abc74c40000000000000000000000001b02da8cb0d097eb8d57a175b88c7d8b4799750600000000000000000000000024ad62502d1c652cc7684081169d04896ac20f300000000000000000000000001123b11e72e527e44ce379cf84696e34d37f46ab000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000010000000000000000000000001f5e4c5d4658c9b6abc4b2ecbfb883c4378cb5490000000000000000000000000000000000000000000000000000000000000003000000000000000000000000985458e523db3d53125813ed68c274899e9dfab400000000000000000000000072cb10c6bfa5624dd07ef608027e366bd690048f000000000000000000000000cf664087a5bb0237a0bad6742852ec6c8d69a27a","nonce":"0x264d3","to":"one1f729putnqlr7u7c98zaxyfu35f8kr4r5tfmpzt","transactionIndex":"0x6","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a3","r":"0xbf5ae52fd305b69671fa0ed4e973bf61557088bc7358785116b8d8d92852ca0a","s":"0x594659a0c410924910ff37662c7778e661e497f3ccea1d8752db7b36a96b72c3"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one13yhttxdwuze2z36up6s6pzqcspvu69tvdpexk4","timestamp":"0x622bb554","gas":"0x190332","gasPrice":"0x861c46800","hash":"0xa0f46a3c45e4803ff45a2a14eee3a8ed30ef722c837a1a942991d9abfc4dd969","ethHash":"0x7b15b538c28b9254edcf86aa0edd7bc5c7c22d9656d35567dba3f2ac75d0eb4a","input":"0xe5546f370000000000000000000000000000000000000000000010f0eac7bb3ce0c8000000000000000000000000000072cb10c6bfa5624dd07ef608027e366bd690048f000000000000000000000000cf664087a5bb0237a0bad6742852ec6c8d69a27a0000000000000000000000009014b937069918bd319f80e8b3bb4a2cf6faa5f700000000000000000000000024ad62502d1c652cc7684081169d04896ac20f300000000000000000000000001b02da8cb0d097eb8d57a175b88c7d8b479975060000000000000000000000001123b11e72e527e44ce379cf84696e34d37f46ab000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000000200000000000000000000000072cb10c6bfa5624dd07ef608027e366bd690048f000000000000000000000000985458e523db3d53125813ed68c274899e9dfab40000000000000000000000000000000000000000000000000000000000000002000000000000000000000000985458e523db3d53125813ed68c274899e9dfab4000000000000000000000000cf664087a5bb0237a0bad6742852ec6c8d69a27a","nonce":"0x2648e","to":"one1f729putnqlr7u7c98zaxyfu35f8kr4r5tfmpzt","transactionIndex":"0x7","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a3","r":"0x9f32f85c43724d2995faf1f6a164af63d245cc964878e221f461d7fbf9f65eca","s":"0x1d727c0474ced160caea9faf93b927046abb5b7036802aa77a71ec62d2cc784"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one1k8mg2mjnnhgynp4u7awspy33h253e60e66x0zm","timestamp":"0x622bb554","gas":"0xaadec","gasPrice":"0x7bdc6aa25","hash":"0x362cb756175407298668431eec968d318ce6a4bd78845e0fcb4bf2c5d1536b90","ethHash":"0x9f008bda318b2ad79b13142626097f8658984c1398f444dc12a900c01cb8903b","input":"0x2bbffd060000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000622bb7aa0000000000000000000000000000000000000000000000000000000000000005000000000000000000000000985458e523db3d53125813ed68c274899e9dfab4000000000000000000000000cf664087a5bb0237a0bad6742852ec6c8d69a27a0000000000000000000000000dc78c79b4eb080ead5c1d16559225a46b580694000000000000000000000000224e64ec1bdce3870a6a6c777edd450454068fec000000000000000000000000985458e523db3d53125813ed68c274899e9dfab4000000000000000000000000000000000000000000000000000000000000000400000000000000000000000027f0bcb74822df54f36151434999cbc8db07d4d900000000000000000000000029c1e9fc7a4c19c8fcaf2d2b2de213ef0f323f0c000000000000000000000000d7e332b4c9f97ea6d05db8c38f133307ad8847f300000000000000000000000059b1455a5f4e841225c88197b94eee92eda883a8000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f2","nonce":"0x38fa","to":"one1d8ldfcv5mj7djqwjd5nxrahq68s3m2dly2cj4r","transactionIndex":"0x8","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a3","r":"0x2bbe7b7d7f4ce1d303894a6e8024b05a5d937437b922b7afb0756525df6d526b","s":"0x4305963934d534bb369131d8fd1411bde8ffe24e1616dde5835ee09f98eda88c"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one1fzk9v8qwrm0fuc3j2ay76rcle6r868g2n8579f","timestamp":"0x622bb554","gas":"0x2ab980","gasPrice":"0x737be7600","hash":"0xb316075bdafd5500d96220590c39950f584a3208a422f9c28e7b06288a7c6c4c","ethHash":"0xbc838d80c2562f5d428fbdc50393b3737c2d00d30ad5f4749024cd172ddf84ab","input":"0xf51333f50000000000000000000000000000000000000000000000000000000000000080000000000000000000000000e4154b6e5d240507f9699c730a496790a722df19000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000030cd000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000","nonce":"0x8ff3","to":"one12yqt6vdcygm3zz9q7c7uldjefwv3n6h5trltq4","transactionIndex":"0x9","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a3","r":"0xffe0639d57f4e06943ebdccd3043128068360d1cf9659fa901526f95d4554539","s":"0xc7f07a4cb7360159bd0dad16241c21d8725d4d64b6a3c02cc6749f5d1c3f3a1"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one1eef8j7qqyj5edw8j6hlaylg4mtqazvchypk5yd","timestamp":"0x622bb554","gas":"0x43481","gasPrice":"0x737be7600","hash":"0x1b6bebfc2faf9e9428360401b452ecf0261fce11f592c8055f8ed053df583e7a","ethHash":"0xf368a09a8afa9eb4709608dfff28aa9ebf4645298e518a7a7dedfb00ed3b3cb6","input":"0xe2bbb158000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000024a2be03b88cf077e","nonce":"0x38de","to":"one1ugxc88n34aq5j2am8ef0ktp2s7nx6pm2xaf9kp","transactionIndex":"0xa","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a4","r":"0x2529869391ccc1029c4fb89ccfc787e9c1a24eb33d09b13dbf7b7cdc28a7c5c2","s":"0x7be1bb00a7c5c06bbd8c8b901215cc39c899acbcfed09b0a4c2b246ee57693f7"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one1p5rs093e2te0hfva6phjksj6eeqtfyh7kashr4","timestamp":"0x622bb554","gas":"0x5208","gasPrice":"0x737be7600","hash":"0xf34d61285f302f147332728b00ef35b25308dabd729e7330bbadbe8e64bbf75b","ethHash":"0x388b3004d247c6bfd1ab74efcfde62738abea89b16fbb59df9b23df43acfd274","input":"0x","nonce":"0x8b47","to":"one1t78v9wxfta30dvegh2568vyfazkazfv65k0t9u","transactionIndex":"0xb","value":"0xd9f8679236177d4000","shardID":0,"toShardID":0,"v":"0x25","r":"0x1457273c01d66c6ad40afa59886e617124a261e0b4b08ed0aaff20ef7d4b52b4","s":"0x1dea6d56d2bca2e3583dbf5f05554907c857a4c5f5cbbab7e4f74292d6fc0cb5"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one1q24gemnpvetrn6znmnxsukt374wan7perlee34","timestamp":"0x622bb554","gas":"0x124f80","gasPrice":"0x737be7600","hash":"0x55e164892931c0cb83a1df2bcb7adfd8bd4cf2d2c18b7dd75bf8efd1818630f9","ethHash":"0x15d6983cc4758b38c887d654b0dec0f1bf63fcd537485ec4dd2fa43001bab962","input":"0xf34563580000000000000000000000000000000000000000000000000000000000000000","nonce":"0x21b905","to":"one1ykrkn6055etrl02wcx37njcta8vv8mfxewt9k0","transactionIndex":"0xc","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a3","r":"0x74013f34251098e0da0ffc39f3ed2590442cc06604675012ff4240b6c691c3b4","s":"0x5e580262a68d0147274ed3e0c99d3bba72722acec4800fece6a17eed3b51a1ca"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one183my3c6jdaj25yam9qsxahktjgqdl06dqhfydl","timestamp":"0x622bb554","gas":"0x2fe9a","gasPrice":"0x737be7600","hash":"0x4eec9484ae895e771423a40cefeb11216d5826d66f54c7b523cdf4ede7f6e69d","ethHash":"0xf10c0f4b1b46df8f5eac664a762adde0af1df4538ee004c839462068078433ee","input":"0x8ea709f3","nonce":"0x3f428","to":"one1ld7httx6t2sxef5zwx25qq5wu2zecevaake6dd","transactionIndex":"0xd","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a4","r":"0xc78ada57dd9a11a4c1bd24e124a88b48f8dadae5c4e851689e8d05246bcd9968","s":"0x6d9dcb49ef813d6a3628babb005911a1c33c8ce3c44fe89c3ef6699d718627e3"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one1tyqn8tdnwdz3qegrlqmxs7jmdw0e0k90e95hk6","timestamp":"0x622bb554","gas":"0xbf740","gasPrice":"0x719306357","hash":"0x1368bdd9f716f27850c179f0adbf2adf3481b82ba9b477b96b3a71200c02c9c8","ethHash":"0x74cc6d104cdfdba0fd2fbc2f199fb2056dbde9af228f13c06bbb2b91fda6b9fb","input":"0x2bbffd0600000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000622bb7aa0000000000000000000000000000000000000000000000000000000000000003000000000000000000000000cf664087a5bb0237a0bad6742852ec6c8d69a27a000000000000000000000000985458e523db3d53125813ed68c274899e9dfab4000000000000000000000000cf664087a5bb0237a0bad6742852ec6c8d69a27a000000000000000000000000000000000000000000000000000000000000000200000000000000000000000027f0bcb74822df54f36151434999cbc8db07d4d900000000000000000000000066c17f5381d7821385974783be34c9b31f75eb78000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000026f200000000000000000000000000000000000000000000000000000000000026f2","nonce":"0x1f52","to":"one1d8ldfcv5mj7djqwjd5nxrahq68s3m2dly2cj4r","transactionIndex":"0xe","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a3","r":"0x556d865ad9500f3dedb679e20a37054b5aca9d5eb8783ca5718a17d4ec021cde","s":"0x5aeb91b0b1ade9968e8776f43dc52cbda27db3dc88267611a9616b06d00e0177"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one10ezkjrq8hfzlks4st0k93ly7tl3lw9mf8vcw9l","timestamp":"0x622bb554","gas":"0x1d437f","gasPrice":"0x6fc23ac00","hash":"0xeb09719b998fd838997242059ae3c95eedcff1646b295dc623ab7d0999d8ddb6","ethHash":"0x29388afd3b0857583b5ecfcf096354463f033b5a94980181f2417512354bcafa","input":"0x528be0a90000000000000000000000000000000000000000000000000000000000010b85","nonce":"0x208","to":"one12yqt6vdcygm3zz9q7c7uldjefwv3n6h5trltq4","transactionIndex":"0xf","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a4","r":"0x696994315c6bf41fcaae03f7eb7af84602f5e716fa6291f992afa5dd5a434150","s":"0x168dfa0e56defcc674c2f963bad076998ecbac6fbf4039aa6ff7dc4ffb1807e1"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one18zawx4lujlgnqpl9c56d5wnsmqphfed74z0np5","timestamp":"0x622bb554","gas":"0x144cce","gasPrice":"0x6fc23ac00","hash":"0xb0ecbfae16f2f0efb9ee1e5ff15ec18eaaec2c26d5e791efd16354af9c421b78","ethHash":"0x0a686721e38237fcb68f9ca3df21a2b7d64c9879522846bbc33af8e7bca46538","input":"0x528be0a90000000000000000000000000000000000000000000000000000000000015928","nonce":"0x5b1","to":"one12yqt6vdcygm3zz9q7c7uldjefwv3n6h5trltq4","transactionIndex":"0x10","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a3","r":"0xf1e884fbf73551e642591d1c9a84b265589e9374d67bbaab9e340356c05f7b1f","s":"0x1aecaa9f49c24fd5badad00f931b8d317c1c26cf0a1a2b2310dd8e0eafe3d09f"},{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one1q2x2rcanq35wevzg25age87c9fkgn0w7ywdjpv","timestamp":"0x622bb554","gas":"0x12c15e","gasPrice":"0x6fc23ac00","hash":"0xe638c72d89316730c38822945847b53778444ce6f9c2a99f9716e9273e97cde5","ethHash":"0x5544f8f310d677eb940df37838d2cb8f774fe6f4bea2e59ec515c30227521489","input":"0xc855dea300000000000000000000000000000000000000000000000000000000000000600000000000000000000000003132c76acf2217646fb8391918d28a16bd8a8ef400000000000000000000000000000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000001e7eb000000000000000000000000000000000000000000000000000000000001b274","nonce":"0x2ab","to":"one12yqt6vdcygm3zz9q7c7uldjefwv3n6h5trltq4","transactionIndex":"0x11","value":"0x0","shardID":0,"toShardID":0,"v":"0xc6ac98a4","r":"0x21eb689e56fcc3c6dd63e3ba3c6f4868578cfbf8062816f86cc6bbd9f0b70821","s":"0x5ed5b7b15b9738d9f4bfb6af81c9645e89e5dc3b454e44f8f8de7410c7f6c42c"}],"stakingTransactions":[{"blockHash":"0x99563ee0afba7f9d9e45ea028c2b3619b45183759da4ff8e8d981f3989c954d2","blockNumber":"0x16d662b","from":"one14l4lst4qnm9fecv38450upfjym00s4ejz9mgdc","timestamp":"0x622bb554","gas":"0x61a8","gasPrice":"0x6fc23ac00","hash":"0x454679b09374b2ead77787b8fcd6ad048e5e25d38dd03675ba0c70a50e30a21a","nonce":"0x3994","transactionIndex":"0x0","v":"0x25","r":"0xa4c9344ddfccda18ef7de92c095bb6602d3a0dbfd459725af83d702c6ddbfbe6","s":"0x4195ca4ed10f3a8ed513c2cddab4b897e5c8052d3001d8234d9bae52e45aca1e","type":"CollectRewards","msg":{"delegatorAddress":"one14l4lst4qnm9fecv38450upfjym00s4ejz9mgdc"}}]}}}
antonyip commented 2 years ago

These staking transactions can be seen in the block explorer here. https://explorer.harmony.one/staking-tx/0x454679b09374b2ead77787b8fcd6ad048e5e25d38dd03675ba0c70a50e30a21a

eevui commented 2 years ago

Look interesting, but I'm not sure what's asked for here.

Is it for a new table containing staking_txs?