{"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\"}"]]}
["2026-01-27_100001","2026-01-27","10:00:01","07:00:01","HIGH","BOTH_BULL",85,4,4.75,335,3,"near_high","POSITIVE",6975.4,0.7899999999999636,-2.7100000000000364,9.819999999999709,"WINNER",1742,2380,5408,1725,3329,5164,0.9902411021814007,1.3987394957983192,0.9548816568047337,89.61687951138256,37.146029983342586,949,793,1053,672,1.1967213114754098,1.5669642857142858,0.370242974238876,1206,1174,1885,1444,1.0272572402044293,1.3054016620498614,0.2781444218454321,1153,92.0599666851749,1464,3110,1.2697311361665222,2.6973113616652213,true,"/Users/lutherbot/.openclaw/workspace/data/spxw_trades/spxw_trades_2026-01-27.dbn.zst","/Users/lutherbot/.openclaw/workspace/data/cbbo_1s_data/spxw_cbbo_1s_2026-01-27.dbn.zst","/Users/lutherbot/.openclaw/workspace/data/es_trades/es_trades_2026-01-27.dbn.zst"]
["2026-01-27_130212","2026-01-27","13:02:12","10:02:12","MEDIUM","BOTH_BULL",65,3,4.0,6901,8,"inside","POSITIVE",6974.2,2.4600000000000364,9.420000000000073,8.75,"WINNER",2375,4549,10448,4307,9664,14008,1.8134736842105263,2.1244229500989227,1.3407350689127107,98.24850769714106,94.87904492617028,1437,938,3299,1008,1.5319829424307037,3.2728174603174605,1.7408345178867568,2570,1979,5367,4297,1.2986356745831227,1.2490109378636258,-0.049624736719496854,1535,99.29311969839773,782,1287,0.5094462540716612,0.8384364820846906,true,"/Users/lutherbot/.openclaw/workspace/data/spxw_trades/spxw_trades_2026-01-27.dbn.zst","/Users/lutherbot/.openclaw/workspace/data/cbbo_1s_data/spxw_cbbo_1s_2026-01-27.dbn.zst","/Users/lutherbot/.openclaw/workspace/data/es_trades/es_trades_2026-01-27.dbn.zst"]