core.flow_alerts
Every UW flow alert, on every ticker - untracked ones included, which is the point. Keyed on the vendor's alert id. `ticker` is verbatim (SPX weeklies arrive as SPXW). Not exportable: each alert carries the contract's bid and ask.
uw_flow_alerts566,287 rowsrestricted — hover for the licence| iduuid | created_at ↓timestamp with time zone | start_timetimestamp with time zone | end_timetimestamp with time zone | tickertext | option_symboltext | option_typetext | strikenumeric | expiry |
|---|
| pricenumeric |
|---|
| bidnumeric |
|---|
| asknumeric |
|---|
| underlying_pricenumeric |
|---|
| total_premiumnumeric |
|---|
| total_ask_side_premnumeric |
|---|
| total_bid_side_premnumeric |
|---|
| total_sizebigint |
|---|
| trade_countinteger |
|---|
| volumebigint |
|---|
| open_interestbigint |
|---|
| volume_oi_rationumeric |
|---|
| iv_startnumeric |
|---|
| iv_endnumeric |
|---|
| has_sweepboolean |
|---|
| has_floorboolean |
|---|
| has_multilegboolean |
|---|
| has_singlelegboolean |
|---|
| all_opening_tradesboolean |
|---|
| alert_ruletext |
|---|
| rule_iduuid |
|---|
| expiry_countinteger |
|---|
| issue_typetext |
|---|
| sectortext |
|---|
| marketcapnumeric |
|---|
| next_earnings_datedate |
|---|
| er_timetext |
|---|
| missing_periscopeboolean |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 5260641f-507a-4617-843f-0ce52e05ba62 | 2026-09-29 15:58 | 2026-09-29 15:58 | 2026-09-29 15:58 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 2.3900 | 2.3500 | 2.3900 | 149.0000 | 11233.00 | 11233.00 | 0.00 | 47 | 9 | 1279 | 28063 | 0.0455760253714856 | 0.510041828334341 | 0.510041828334341 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 1148594867162.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 3819cbc9-a97d-4ec3-b543-bf97e7592575 | 2026-09-28 15:50 | 2026-09-28 15:50 | 2026-09-28 15:50 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 2.0000 | 2.0000 | 2.0500 | 145.8000 | 10200.00 | 0.00 | 10200.00 | 51 | 5 | 1607 | 27659 | 0.0581004374706244 | 0.513935545428592 | 0.513935545428592 | false | false | false | true | ||||||||||||||||
| ab477027-adbd-4cea-be10-44fb88938271 | 2026-09-28 11:16 | 2026-09-28 11:15 | 2026-09-28 11:15 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 2.3700 | 2.3400 | 2.3700 | 148.0000 | 23700.00 | 20619.00 | 0.00 | 100 | 8 | 491 | 27659 | 0.0177519071549948 | 0.51806542269267 | 0.51806542269267 | false | false | false | true | ||||||||||||||||
| a4c7ca7e-4905-489e-8df3-628c2898c222 | 2026-09-28 11:10 | 2026-09-28 11:10 | 2026-09-28 11:10 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 2.3700 | 2.3600 | 2.4100 | 148.1700 | 28440.00 | 23937.00 | 1185.00 | 120 | 8 | 380 | 27659 | 0.013738746881666 | 0.517431230265048 | 0.517431230265048 | false | false | false | true | ||||||||||||||||
| a20646f8-ed94-4edd-a5ff-119baa5b31c3 | 2026-09-25 09:46 | 2026-09-25 09:46 | 2026-09-25 09:46 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 2.5800 | 2.5800 | 2.6300 | 147.9500 | 10836.00 | 0.00 | 10836.00 | 42 | 9 | 55 | 27554 | 0.0019960804238949 | 0.522587370196607 | 0.522587370196607 | false | false | false | true | ||||||||||||||||
| 3d4a9109-faa6-42a7-bd82-50bf14a83164 | 2026-09-24 13:43 | 2026-09-24 13:43 | 2026-09-24 13:43 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 2.5900 | 2.5700 | 2.6500 | 147.6915 | 15541.00 | 260.00 | 15281.00 | 60 | 12 | 481 | 27495 | 0.0174940898345154 | 0.52290078992681 | 0.522436209298959 | false | false | false | true | ||||||||||||||||
| d577e6b5-a7f4-40f4-b69c-9ad283249aad | 2026-09-22 12:32 | 2026-09-22 12:32 | 2026-09-22 12:32 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 3.8500 | 3.8500 | 3.9500 | 153.0000 | 33110.00 | 0.00 | 33110.00 | 86 | 7 | 2965 | 27208 | 0.108975301381946 | 0.534621676788861 | 0.534621676788861 | false | false | false | true | ||||||||||||||||
| c955efd3-eb8b-4bee-893a-ea143d61d5a9 | 2026-09-21 14:15 | 2026-09-21 14:14 | 2026-09-21 14:14 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 4.0000 | 4.0000 | 4.0500 | 152.4200 | 18400.00 | 0.00 | 18400.00 | 46 | 7 | 6025 | 24146 | 0.249523730638615 | 0.544224236835564 | 0.544224236835564 | false | false | false | true | ||||||||||||||||
| 923a56bd-6418-44ca-8ef9-285ab436cc58 | 2026-09-21 12:11 | 2026-09-21 12:11 | 2026-09-21 12:11 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 4.6000 | 4.5500 | 4.6000 | 155.4409 | 44160.00 | 44160.00 | 0.00 | 96 | 7 | 5711 | 24146 | 0.236519506336453 | 0.542788059761863 | 0.542788059761863 | false | false | false | true | ||||||||||||||||
| 68d682d3-0ca9-4e8d-ab02-c48ab6f7d41b | 2026-09-21 10:29 | 2026-09-21 10:29 | 2026-09-21 10:29 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 5.4000 | 5.3500 | 5.4500 | 158.0000 | 298080.00 | 230040.00 | 68040.00 | 552 | 9 | 4998 | 24146 | 0.206990805930589 | 0.551271767427224 | 0.551721785021651 | true | false | false | true | ||||||||||||||||
| 54d2f388-e0fc-4675-bd14-4c64e10dc6b0 | 2026-09-14 13:38 | 2026-09-14 13:38 | 2026-09-14 13:38 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 4.5000 | 4.5000 | 4.6000 | 151.6150 | 108000.00 | 0.00 | 108000.00 | 240 | 7 | 476 | 22648 | 0.0210173083716001 | 0.554504348736792 | 0.554504348736792 | false | false | false | true | ||||||||||||||||
| 3791a392-eaca-4d70-89f1-e2be522a4de0 | 2026-09-08 11:38 | 2026-09-08 11:38 | 2026-09-08 11:38 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 6.0000 | 5.8500 | 6.0000 | 152.8700 | 223800.00 | 223800.00 | 0.00 | 373 | 5 | 926 | 21695 | 0.042682645770915 | 0.585874358950826 | 0.585874358950826 | true | false | false | true | ||||||||||||||||
| c25cdf80-1cdf-4da9-a66d-f00f43f01232 | 2026-08-31 11:21 | 2026-08-31 11:20 | 2026-08-31 11:20 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 4.0000 | 3.8500 | 4.0000 | 143.3600 | 161600.00 | 161600.00 | 0.00 | 404 | 7 | 1042 | 19072 | 0.054635067114094 | 0.56605966892009 | 0.56605966892009 | false | false | false | true | ||||||||||||||||
| 4d026a85-44b5-4cf1-8f21-89057c5ef75f | 2026-08-21 12:23 | 2026-08-21 12:23 | 2026-08-21 12:23 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 5.3000 | 5.2000 | 5.3000 | 135.9450 | 106000.00 | 106000.00 | 0.00 | 200 | 11 | 4612 | 15466 | 0.298202508728825 | 0.665502698188141 | 0.665502698188141 | false | false | false | true | ||||||||||||||||
| a45ecb63-9144-456b-91f1-7299a07cf6f4 | 2026-08-21 12:09 | 2026-08-21 12:09 | 2026-08-21 12:09 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 5.4000 | 5.3000 | 5.4500 | 136.5750 | 399060.00 | 73980.00 | 325080.00 | 739 | 17 | 4195 | 15466 | 0.271240139661192 | 0.663934967560738 | 0.663934967560738 | false | false | false | true | ||||||||||||||||
| d141f460-60a2-4fe4-9e68-a8cda33fd4c5 | 2026-08-21 12:09 | 2026-08-21 12:09 | 2026-08-21 12:09 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 5.4000 | 5.2500 | 5.4500 | 136.6200 | 164700.00 | 80460.00 | 84240.00 | 305 | 10 | 3456 | 15466 | 0.223457907668434 | 0.663508978141822 | 0.663508978141822 | false | false | false | true | ||||||||||||||||
| 2c0e65e0-95a5-4ab2-a2b2-12dc5e591802 | 2026-08-21 12:08 | 2026-08-21 12:08 | 2026-08-21 12:08 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 5.4000 | 5.3000 | 5.4500 | 136.7500 | 379620.00 | 122040.00 | 257580.00 | 703 | 16 | 2900 | 15466 | 0.187508082244924 | 0.662278960912308 | 0.662278960912308 | false | false | false | true | ||||||||||||||||
| bff719ff-994d-498a-89e9-775497683c6e | 2026-08-21 11:57 | 2026-08-21 11:57 | 2026-08-21 11:57 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 5.4000 | 5.3000 | 5.4500 | 136.8000 | 795420.00 | 329400.00 | 320220.00 | 1473 | 16 | 1665 | 15466 | 0.107655502392345 | 0.661806121708571 | 0.661806121708571 | true | false | false | true | ||||||||||||||||
| dc1b7db9-317c-427f-a33e-9329763a044f | 2026-08-17 15:59 | 2026-08-17 15:59 | 2026-08-17 15:59 | SPCX | SPCX261218C00200000 | call | 200.0000 | 2026-12-18 | 8.8000 | 8.6000 | 8.8000 | 146.5100 | 300960.00 | 300960.00 | 0.00 | 342 | 11 | 7135 | 15030 | 0.474717232202262 | 0.685658555751575 | 0.685658555751575 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1119579840029.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:53:15.788869Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1119579840029.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:17:18.738051Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1119579840029.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:13:28.016528Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1144284942707.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:47:32.064714Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1141822128733.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:43:31.900788Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1190770556468.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:35:05.886735Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1168682193638.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:15:35.599753Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1168682193638.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:13:06.153982Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1168682193638.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:43:32.720264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:43:46.028086Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |