Skip to content

Instantly share code, notes, and snippets.

@anusha-ctrl
anusha-ctrl / gist:f7f40b6afc68c7e3bfb84605d5a5eb2e
Created May 1, 2025 16:40
incident 215 - 4 flows on 1 tx from a previous wallet
amount created_at custom_wallet_id flow_direction flow_metadata id is_ignored is_manual operation_id operation_purpose operation_type snapshot source_metadata transaction_id uaid updated_at user_id wallet_id imported_in_monolith_at imported_in_data_tools_at
10.00000000000000000000000000000000000000000000000000 2024-06-22 00:21:54.862109 OUTFLOW {} 01903d52-302f-73b9-aca6-008a354095e6 false true 01903d52-302e-762b-ab5b-03f9f60f41b9 FEE/EXCHANGE_FEE SEND EDITED {} 01903a85-c343-71eb-ae1a-e58347a58e5b crypto_2444 2024-06-22 00:21:54.862109 2742028 125535626 2025-05-01 02:22:01.74763 2025-05-01 09:00:08.014126
0.00028458566518200000000000000000000000000000000000 2024-06-21 11:19:23.145553 OUTFLOW "{""info"": ""{\""contract_execution\"": true, \""contract_interaction\"": {\""function_name\"": \""approve(address spender, uint256 amount)\"", \""interacting_contract_address\"": \""0xaf88d065e77c8cc2239327c5edb3a432268e5831\"", \""method_id\"": \""0x095ea7b3\""}, \""destination_address\"": \""0xaf88d065e77c8cc223932
@anusha-ctrl
anusha-ctrl / gist:f857dc68b557160d3919d5582a55338d
Last active May 1, 2025 16:04
incident 215 transactions from 31616 - 42544 (not inclusive) but minus 1 real tx on the wallet.
018dbb9f-32f8-70de-8d63-010fb91c1d72 99080
018dc2e6-e76c-7177-8726-1526604cab8e 95312
018d9faa-c69c-74d3-8047-641903671897 107509
018dcf8f-dcb6-70bb-874a-eaf783efcdf4 107487
018dc2e6-9040-7806-a7f8-0c6769b83d33 95312
01903aa2-9978-7eba-86ee-1b8ba14c569f 109350
018d9f52-0272-7837-aa2f-0f7bc259dfd9 103411
018dcf8f-991c-73e0-8fd4-1f6aba2b2641 107487
019039aa-1604-7062-88cc-225a4af955f6 50910
018d9f8c-3899-73e8-9fd5-ffa0bc9390c6 101322
@anusha-ctrl
anusha-ctrl / user_ids.txt
Last active April 17, 2025 20:52
incident 215 133 user_ids that have transactions w deleted uaids
251769, 259408, 228235, 616578, 242193, 239745, 190995, 269707, 258044, 3284187, 193992, 174874, 3284472, 126200, 215597, 269000, 31372, 6450, 196087, 267224, 237237, 259523, 192359, 104425, 191480, 259482, 219385, 219931, 234039, 186574, 233016, 3146556, 199799, 198861, 227878, 194549, 2677836, 246372, 247291, 202638, 241473, 142216, 187663, 41578, 252130, 245031, 191756, 224714, 221626, 46800, 27845, 222951, 3284526, 221057, 244549, 236685, 260545, 209069, 239679, 22500, 91846, 207967, 202557, 192842, 195709, 199350, 257424, 259670, 235096, 266937, 266518, 266728, 268350, 254857, 268303, 202390, 206032, 235696, 224470, 224865, 230648, 17347, 253312, 193359, 15774, 270832, 249555, 215751, 199973, 213815, 168816, 237087, 191950, 268498, 255067, 266812, 148091, 203476, 244531, 242617, 3284601, 239265, 212724, 252008, 248614, 203836, 195828, 248290, 245104, 191908, 224771, 160390, 189961, 246485, 199847, 225018, 96089, 51044, 191774, 208076, 231301, 214211, 209921, 196184, 199735, 250934, 153725, 266268, 214128
@anusha-ctrl
anusha-ctrl / transactions_that_reference_a_deleted_uaid.txt
Last active April 17, 2025 18:02
Transactions that reference a deleted uaid incident 215
019045bb-9c5d-7795-bb2a-53b5ab126e86 258044
01903df2-5f58-7599-9542-89952ac606df 189961
01903e51-8747-7ead-9378-14a9ea4f05aa 148091
0190471e-a2ab-7c5f-a626-47ba93dd3342 267224
0190460b-f94d-79df-8c2d-af55580ebf5a 259523
0190441a-8fdd-7a99-a81b-10616bb25974 3284526
019042be-29b4-789f-b057-32c80854a2cd 233016
0190471e-a179-7511-a465-e9cd2ba8c049 267224
01903df2-5f88-7918-807d-5477cb342c7f 189961
01904029-a482-7c77-ab60-1037c7bf84e1 207967
NFO adapter: raw_transfers transfers=[SubscanTransfer(from_='0xdb7472f23cda9278a9f29fe9913dc0635b14033b', to='0x3c245a333c3a173c81b302a8fcbf87a8e7ed1ecb', extrinsic_index='5796711-9', success=True, hash='0x203e2441d55f5ba8c0cdf8f31e3368a7a591289fe9bde608e1add2ef7f7fe2f0', block_num=5796711, block_timestamp=1711325826, module='assets', amount=Decimal('3.5'), fee=Decimal('0'), nonce=0, asset_symbol='xcDOT', asset_unique_id='standard_assets/42259045809535163221576417993425387648', asset_type='assets', transfer_id=579671100058, event_idx=58), SubscanTransfer(from_='0x3c245a333c3a173c81b302a8fcbf87a8e7ed1ecb', to='0xdb7472f23cda9278a9f29fe9913dc0635b14033b', extrinsic_index='5796711-9', success=True, hash='0x203e2441d55f5ba8c0cdf8f31e3368a7a591289fe9bde608e1add2ef7f7fe2f0', block_num=5796711, block_timestamp=1711325826, module='balances', amount=Decimal('58.558669780895686645'), fee=Decimal('0'), nonce=0, asset_symbol='GLMR', asset_unique_id='GLMR', asset_type='', transfer_id=579671100064, event_idx=64), SubscanTr
transfer hash='0x7b44508f8edc1b61ce3fbb2cf92cc56da40ecc252c8d83903287e58e93c2ec53' type=<EntryType.CREDIT: 2> meta_type=None date_time=datetime.datetime(2023, 4, 20, 2, 57, 30, tzinfo=datetime.timezone.utc) amount=Decimal('19.6997') contract_address=None counterparty_address=None counterparty_network=None symbol='DOT' virtual_token_data=None fee=Decimal('0.0163142196') fee_symbol='DOT' fee_contract_address=None info={'contract_interaction': {'interacting_contract_address': 'nominationpools', 'method_id': 'withdraw_unbonded'}, 'source_address': '13UVJyLnbVp8c4FQeiGDV9fT5nXpwC3iQCqhL86AwDwY43Sg', 'destination_address': '13VHfWs1u7ptp3AkRv7rmB8kFo5V2S78QyoEgLHKQGs4CjF4'} comment='' is_intra_wallet_transaction=False operation_group_id=None persist_batch_id=None
BlockchainContractAddress(address='nominationpools', network='polkadot'), method_id='withdraw_unbonded')
@anusha-ctrl
anusha-ctrl / stacks_wallet_ids.txt
Last active March 12, 2025 20:48
all stacks wallet ids as of 3/12/25
136878036
135947227
137160006
136446889
135951375
135949205
136588209
136510960
136991276
136150523
@anusha-ctrl
anusha-ctrl / accounts.txt
Created March 7, 2025 01:56
~1.5 k accounts who have generated tax reports but havent synced yet kraken
568934
1165251
4069746
4080429
4196446
1176043
3122566
3956337
1010812
3778526
@anusha-ctrl
anusha-ctrl / mark_account_with_banner.py
Created March 7, 2025 00:48
mark_account_with_banner.py kraken staking 11.5k users about
from app.models.accounts import Account
account = db.session.query(Account).filter(Account.id == account_id).first()
account.needs_hard_resync_for_staking = True
db.session.commit()
@anusha-ctrl
anusha-ctrl / invalid_api_keys.txt
Created March 6, 2025 23:58
8902 accounts kraken accounts with invalid api keys
3921385
3334827
3990497
2830586
4007322
3915882
2859101
3930805
3612470
3966744