{"columns":[{"name":"alert_id","type":"string"},{"name":"date","type":"string"},{"name":"time_et","type":"string"},{"name":"time_pt","type":"string"},{"name":"tier","type":"string"},{"name":"signal","type":"string"},{"name":"score","type":"int64"},{"name":"cluster_size","type":"int64"},{"name":"max_ratio","type":"double"},{"name":"vol_while_wide","type":"int64"},{"name":"spread_duration","type":"int64"},{"name":"orb_context","type":"string"},{"name":"gex_regime","type":"string"},{"name":"spx_at_spike","type":"double"},{"name":"f10_spx_pts","type":"double"},{"name":"f30_spx_pts","type":"double"},{"name":"f60_spx_pts","type":"double"},{"name":"winner_loser_10m","type":"string"},{"name":"options_pre_10s","type":"int64"},{"name":"options_pre_30s","type":"int64"},{"name":"options_pre_60s","type":"int64"},{"name":"options_post_10s","type":"int64"},{"name":"options_post_30s","type":"int64"},{"name":"options_post_60s","type":"int64"},{"name":"options_post_pre_ratio_10s","type":"double"},{"name":"options_post_pre_ratio_30s","type":"double"},{"name":"options_post_pre_ratio_60s","type":"double"},{"name":"options_pre_10s_percentile_day","type":"double"},{"name":"options_pre_30s_percentile_day","type":"double"},{"name":"put_pre_10s","type":"int64"},{"name":"call_pre_10s","type":"int64"},{"name":"put_post_10s","type":"int64"},{"name":"call_post_10s","type":"int64"},{"name":"put_call_ratio_pre_10s","type":"double"},{"name":"put_call_ratio_post_10s","type":"double"},{"name":"delta_put_call_ratio_10s","type":"double"},{"name":"put_pre_30s","type":"int64"},{"name":"call_pre_30s","type":"int64"},{"name":"put_post_30s","type":"int64"},{"name":"call_post_30s","type":"int64"},{"name":"put_call_ratio_pre_30s","type":"double"},{"name":"put_call_ratio_post_30s","type":"double"},{"name":"delta_put_call_ratio_30s","type":"double"},{"name":"es_pre_10s_volume","type":"int64"},{"name":"es_pre_10s_percentile_day","type":"double"},{"name":"es_post_10s_volume","type":"int64"},{"name":"es_post_30s_volume","type":"int64"},{"name":"es_post_pre_ratio_10s","type":"double"},{"name":"es_post_pre_ratio_30s_vs_pre10s","type":"double"},{"name":"es_data_present","type":"bool"},{"name":"options_trades_file","type":"string"},{"name":"cbbo_file","type":"string"},{"name":"es_file","type":"string"}],"n_rows":2,"rows_kept":2,"cut":false,"text_format":"parquet-jsonl-2026-10-02","bounds":{"document_bytes":16777216,"package_text_limit_bytes":33554432,"package_text_slack_bytes":1024,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096,"vector_min":64,"vector_head_fixed":16,"vector_head_variable":64,"kv_value_chars":1048576,"nesting_max":64,"binary_text":true},"cells_cut":0,"cells_bad_utf8":0,"cells_raw":0,"cells_binary":0,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"parquet-cpp-arrow version 21.0.0","schema":{"fields":[{"name":"alert_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"date","type":"string","nullable":true,"metadata":null,"children":null},{"name":"time_et","type":"string","nullable":true,"metadata":null,"children":null},{"name":"time_pt","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tier","type":"string","nullable":true,"metadata":null,"children":null},{"name":"signal","type":"string","nullable":true,"metadata":null,"children":null},{"name":"score","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"cluster_size","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"max_ratio","type":"double","nullable":true,"metadata":null,"children":null},{"name":"vol_while_wide","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"spread_duration","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"orb_context","type":"string","nullable":true,"metadata":null,"children":null},{"name":"gex_regime","type":"string","nullable":true,"metadata":null,"children":null},{"name":"spx_at_spike","type":"double","nullable":true,"metadata":null,"children":null},{"name":"f10_spx_pts","type":"double","nullable":true,"metadata":null,"children":null},{"name":"f30_spx_pts","type":"double","nullable":true,"metadata":null,"children":null},{"name":"f60_spx_pts","type":"double","nullable":true,"metadata":null,"children":null},{"name":"winner_loser_10m","type":"string","nullable":true,"metadata":null,"children":null},{"name":"options_pre_10s","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"options_pre_30s","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"options_pre_60s","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"options_post_10s","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"options_post_30s","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"options_post_60s","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"options_post_pre_ratio_10s","type":"double","nullable":true,"metadata":null,"children":null},{"name":"options_post_pre_ratio_30s","type":"double","nullable":true,"metadata":null,"children":null},{"name":"options_post_pre_ratio_60s","type":"double","nullable":true,"metadata":null,"children":null},{"name":"options_pre_10s_percentile_day","type":"double","nullable":true,"metadata":null,"children":null},{"name":"options_pre_30s_percentile_day","type":"double","nullable":true,"metadata":null,"children":null},{"name":"put_pre_10s","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"call_pre_10s","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"put_post_10s","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"call_post_10s","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"put_call_ratio_pre_10s","type":"double","nullable":true,"metadata":null,"children":null},{"name":"put_call_ratio_post_10s","type":"double","nullable":true,"metadata":null,"children":null},{"name":"delta_put_call_ratio_10s","type":"double","nullable":true,"metadata":null,"children":null},{"name":"put_pre_30s","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"call_pre_30s","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"put_post_30s","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"call_post_30s","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"put_call_ratio_pre_30s","type":"double","nullable":true,"metadata":null,"children":null},{"name":"put_call_ratio_post_30s","type":"double","nullable":true,"metadata":null,"children":null},{"name":"delta_put_call_ratio_30s","type":"double","nullable":true,"metadata":null,"children":null},{"name":"es_pre_10s_volume","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"es_pre_10s_percentile_day","type":"double","nullable":true,"metadata":null,"children":null},{"name":"es_post_10s_volume","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"es_post_30s_volume","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"es_post_pre_ratio_10s","type":"double","nullable":true,"metadata":null,"children":null},{"name":"es_post_pre_ratio_30s_vs_pre10s","type":"double","nullable":true,"metadata":null,"children":null},{"name":"es_data_present","type":"bool","nullable":true,"metadata":null,"children":null},{"name":"options_trades_file","type":"string","nullable":true,"metadata":null,"children":null},{"name":"cbbo_file","type":"string","nullable":true,"metadata":null,"children":null},{"name":"es_file","type":"string","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 schema {\n  optional binary field_id=-1 alert_id (String);\n  optional binary field_id=-1 date (String);\n  optional binary field_id=-1 time_et (String);\n  optional binary field_id=-1 time_pt (String);\n  optional binary field_id=-1 tier (String);\n  optional binary field_id=-1 signal (String);\n  optional int64 field_id=-1 score;\n  optional int64 field_id=-1 cluster_size;\n  optional double field_id=-1 max_ratio;\n  optional int64 field_id=-1 vol_while_wide;\n  optional int64 field_id=-1 spread_duration;\n  optional binary field_id=-1 orb_context (String);\n  optional binary field_id=-1 gex_regime (String);\n  optional double field_id=-1 spx_at_spike;\n  optional double field_id=-1 f10_spx_pts;\n  optional double field_id=-1 f30_spx_pts;\n  optional double field_id=-1 f60_spx_pts;\n  optional binary field_id=-1 winner_loser_10m (String);\n  optional int64 field_id=-1 options_pre_10s;\n  optional int64 field_id=-1 options_pre_30s;\n  optional int64 field_id=-1 options_pre_60s;\n  optional int64 field_id=-1 options_post_10s;\n  optional int64 field_id=-1 options_post_30s;\n  optional int64 field_id=-1 options_post_60s;\n  optional double field_id=-1 options_post_pre_ratio_10s;\n  optional double field_id=-1 options_post_pre_ratio_30s;\n  optional double field_id=-1 options_post_pre_ratio_60s;\n  optional double field_id=-1 options_pre_10s_percentile_day;\n  optional double field_id=-1 options_pre_30s_percentile_day;\n  optional int64 field_id=-1 put_pre_10s;\n  optional int64 field_id=-1 call_pre_10s;\n  optional int64 field_id=-1 put_post_10s;\n  optional int64 field_id=-1 call_post_10s;\n  optional double field_id=-1 put_call_ratio_pre_10s;\n  optional double field_id=-1 put_call_ratio_post_10s;\n  optional double field_id=-1 delta_put_call_ratio_10s;\n  optional int64 field_id=-1 put_pre_30s;\n  optional int64 field_id=-1 call_pre_30s;\n  optional int64 field_id=-1 put_post_30s;\n  optional int64 field_id=-1 call_post_30s;\n  optional double field_id=-1 put_call_ratio_pre_30s;\n  optional double field_id=-1 put_call_ratio_post_30s;\n  optional double field_id=-1 delta_put_call_ratio_30s;\n  optional int64 field_id=-1 es_pre_10s_volume;\n  optional double field_id=-1 es_pre_10s_percentile_day;\n  optional int64 field_id=-1 es_post_10s_volume;\n  optional int64 field_id=-1 es_post_30s_volume;\n  optional double field_id=-1 es_post_pre_ratio_10s;\n  optional double field_id=-1 es_post_pre_ratio_30s_vs_pre10s;\n  optional boolean field_id=-1 es_data_present;\n  optional binary field_id=-1 options_trades_file (String);\n  optional binary field_id=-1 cbbo_file (String);\n  optional binary field_id=-1 es_file (String);\n}\n"},"kv_metadata":[["ARROW:schema",{"$cut":{"chars":13688,"head":""}}],["pandas","{\"index_columns\": [], \"column_indexes\": [], \"columns\": [{\"name\": \"alert_id\", \"field_name\": \"alert_id\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"date\", \"field_name\": \"date\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"time_et\", \"field_name\": \"time_et\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"time_pt\", \"field_name\": \"time_pt\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"tier\", \"field_name\": \"tier\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"signal\", \"field_name\": \"signal\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"score\", \"field_name\": \"score\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"cluster_size\", \"field_name\": \"cluster_size\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"max_ratio\", \"field_name\": \"max_ratio\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"vol_while_wide\", \"field_name\": \"vol_while_wide\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"spread_duration\", \"field_name\": \"spread_duration\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"orb_context\", \"field_name\": \"orb_context\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"gex_regime\", \"field_name\": \"gex_regime\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"spx_at_spike\", \"field_name\": \"spx_at_spike\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"f10_spx_pts\", \"field_name\": \"f10_spx_pts\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"f30_spx_pts\", \"field_name\": \"f30_spx_pts\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"f60_spx_pts\", \"field_name\": \"f60_spx_pts\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"winner_loser_10m\", \"field_name\": \"winner_loser_10m\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"options_pre_10s\", \"field_name\": \"options_pre_10s\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"options_pre_30s\", \"field_name\": \"options_pre_30s\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"options_pre_60s\", \"field_name\": \"options_pre_60s\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"options_post_10s\", \"field_name\": \"options_post_10s\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"options_post_30s\", \"field_name\": \"options_post_30s\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"options_post_60s\", \"field_name\": \"options_post_60s\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"options_post_pre_ratio_10s\", \"field_name\": \"options_post_pre_ratio_10s\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"options_post_pre_ratio_30s\", \"field_name\": \"options_post_pre_ratio_30s\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"options_post_pre_ratio_60s\", \"field_name\": \"options_post_pre_ratio_60s\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"options_pre_10s_percentile_day\", \"field_name\": \"options_pre_10s_percentile_day\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"options_pre_30s_percentile_day\", \"field_name\": \"options_pre_30s_percentile_day\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"put_pre_10s\", \"field_name\": \"put_pre_10s\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"call_pre_10s\", \"field_name\": \"call_pre_10s\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"put_post_10s\", \"field_name\": \"put_post_10s\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"call_post_10s\", \"field_name\": \"call_post_10s\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"put_call_ratio_pre_10s\", \"field_name\": \"put_call_ratio_pre_10s\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"put_call_ratio_post_10s\", \"field_name\": \"put_call_ratio_post_10s\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"delta_put_call_ratio_10s\", \"field_name\": \"delta_put_call_ratio_10s\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"put_pre_30s\", \"field_name\": \"put_pre_30s\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"call_pre_30s\", \"field_name\": \"call_pre_30s\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"put_post_30s\", \"field_name\": \"put_post_30s\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"call_post_30s\", \"field_name\": \"call_post_30s\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"put_call_ratio_pre_30s\", \"field_name\": \"put_call_ratio_pre_30s\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"put_call_ratio_post_30s\", \"field_name\": \"put_call_ratio_post_30s\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"delta_put_call_ratio_30s\", \"field_name\": \"delta_put_call_ratio_30s\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"es_pre_10s_volume\", \"field_name\": \"es_pre_10s_volume\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"es_pre_10s_percentile_day\", \"field_name\": \"es_pre_10s_percentile_day\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"es_post_10s_volume\", \"field_name\": \"es_post_10s_volume\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"es_post_30s_volume\", \"field_name\": \"es_post_30s_volume\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"es_post_pre_ratio_10s\", \"field_name\": \"es_post_pre_ratio_10s\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"es_post_pre_ratio_30s_vs_pre10s\", \"field_name\": \"es_post_pre_ratio_30s_vs_pre10s\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"es_data_present\", \"field_name\": \"es_data_present\", \"pandas_type\": \"bool\", \"numpy_type\": \"bool\", \"metadata\": null}, {\"name\": \"options_trades_file\", \"field_name\": \"options_trades_file\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"cbbo_file\", \"field_name\": \"cbbo_file\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"es_file\", \"field_name\": \"es_file\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}], \"creator\": {\"library\": \"pyarrow\", \"version\": \"21.0.0\"}, \"pandas_version\": \"2.3.3\"}"]]}
["2025-11-26_130915","2025-11-26","13:09:15","10:09:15","HIGH","BOTH_BULL",85,26,31.33,16432,24,"above","POSITIVE",6818.5,0.9700000000002547,-0.049999999999272404,0.5,"WINNER",1124,1397,2001,3044,16688,21877,2.7081850533807827,11.945597709377237,10.93303348325837,95.7126567844926,59.38426453819841,1056,68,2775,269,15.529411764705882,10.315985130111525,-5.213426634594358,1294,103,15332,1356,12.563106796116505,11.306784660766962,-1.256322135349544,2620,99.83276320790574,6094,16700,2.3259541984732826,6.374045801526718,true,"/Users/lutherbot/.openclaw/workspace/data/spxw_trades/spxw_trades_2025-11-26.dbn.zst","/Users/lutherbot/.openclaw/workspace/data/cbbo_1s_data/spxw_cbbo_1s_2025-11-26.dbn.zst","/Users/lutherbot/.openclaw/workspace/data/es_trades/es_trades_2025-11-26.dbn.zst"]
["2025-11-26_143529","2025-11-26","14:35:29","11:35:29","HIGH","BOTH_BULL",100,4,7.75,1668,5,"above","POSITIVE",6823.2,1.1500000000005457,1.4400000000005093,3.0,"WINNER",1943,3430,4448,2101,3062,5189,1.0813175501801338,0.8927113702623907,1.1665917266187051,99.54170985869388,97.5121392329096,1791,152,1968,133,11.782894736842104,14.796992481203008,3.014097744360903,3132,298,2862,200,10.51006711409396,14.31,3.79993288590604,2239,99.49260734355393,1040,2384,0.4644930772666369,1.064761054041983,true,"/Users/lutherbot/.openclaw/workspace/data/spxw_trades/spxw_trades_2025-11-26.dbn.zst","/Users/lutherbot/.openclaw/workspace/data/cbbo_1s_data/spxw_cbbo_1s_2025-11-26.dbn.zst","/Users/lutherbot/.openclaw/workspace/data/es_trades/es_trades_2025-11-26.dbn.zst"]