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_alerts523,327 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 | expirydate |
|---|
| 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 |
|---|
| 525f7fcb-8226-447a-9cf8-d5490bcc37ad | 2026-09-02 15:52 | 2026-09-02 15:52 | 2026-09-02 15:52 | MU | MU260904P00952500 | put | 952.5000 | 2026-09-04 | 14.7500 | 14.0500 | 14.7500 | 955.2120 | 221228.00 | 221228.00 | 0.00 | 150 | 6 | 1114 | 72 | 15.4722222222222 | 0.573252477412839 | 0.573964569497988 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1043593153319.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c8611255-b5d9-4c0b-b759-b141e7093628 | 2026-09-02 15:54 | 2026-09-02 15:54 | 2026-09-02 15:54 | MU | MU260904P00952500 | put | 952.5000 | 2026-09-04 | 14.0400 | 13.8000 | 14.2500 | 956.6900 | 367930.00 | 210467.00 | 157463.00 | 262 | 15 | 1486 | 72 | 20.6388888888889 | 0.576304220718679 | 0.565165125082238 | false | false | false | true | ||||||||||||||||
| 841846fb-8a48-4ee8-9ef4-85b2be31b0e9 | 2026-09-02 15:59 | 2026-09-02 15:59 | 2026-09-02 15:59 | MU | MU260904P00952500 | put | 952.5000 | 2026-09-04 | 13.3000 | 13.3000 | 13.6500 | 956.8250 | 266000.00 | 0.00 | 266000.00 | 200 | 5 | 1749 | 72 | 24.2916666666667 | 0.548391361260879 | 0.548391361260879 | false | false | false | true | ||||||||||||||||
| a43ae524-913b-4233-8f0d-809c752eb38e | 2026-09-02 15:59 | 2026-09-02 15:59 | 2026-09-02 15:59 | MU | MU260904P00952500 | put | 952.5000 | 2026-09-04 | 13.4500 | 13.4500 | 14.0500 | 956.4555 | 361805.00 | 0.00 | 361805.00 | 269 | 7 | 2022 | 72 | 28.0833333333333 | 0.547845290411541 | 0.547845290411541 | false | false | false | true | ||||||||||||||||
| 9867e09e-c519-4017-ba5e-0bf1d0034c3a | 2026-09-03 09:32 | 2026-09-03 09:32 | 2026-09-03 09:32 | MU | MU260904P00952500 | put | 952.5000 | 2026-09-04 | 22.4500 | 22.4500 | 23.8000 | 937.6850 | 224544.00 | 0.00 | 224544.00 | 100 | 7 | 160 | 266 | 0.601503759398496 | 0.702762417569361 | 0.702762417569361 | false | false | false | true | ||||||||||||||||
| 97db8095-0322-424a-8f4c-ba916dac35e5 | 2026-09-03 15:07 | 2026-09-03 15:06 | 2026-09-03 15:06 | MU | MU260904P00952500 | put | 952.5000 | 2026-09-04 | 11.2000 | 10.8000 | 11.3000 | 954.0000 | 710068.00 | 707828.00 | 0.00 | 634 | 61 | 2869 | 266 | 10.7857142857143 | 0.61547664592605 | 0.604537505634583 | false | false | false | true | ||||||||||||||||
| e0fb8828-85ca-4920-ac37-45b54daefd2b | 2026-09-03 15:11 | 2026-09-03 15:10 | 2026-09-03 15:10 | MU | MU260904P00952500 | put | 952.5000 | 2026-09-04 | 12.0000 | 11.6500 | 12.0000 | 952.8050 | 469196.00 | 469196.00 | 0.00 | 391 | 37 | 3628 | 266 | 13.6390977443609 | 0.613380183992392 | 0.613380183992392 | false | false | false | true | ||||||||||||||||
| 1122ff1a-9c5e-4b29-860a-36227ed99fbd | 2026-09-03 15:55 | 2026-09-03 15:55 | 2026-09-03 15:55 | MU | MU260904P00952500 | put | 952.5000 | 2026-09-04 | 10.8500 | 10.1500 | 10.8500 | 957.0200 | 194215.00 | 194215.00 | 0.00 | 179 | 5 | 4494 | 266 | 16.8947368421053 | 0.65359090346488 | 0.65359090346488 | false | false | false | true | ||||||||||||||||
| d4a8f8f2-bcbe-449f-8611-6cf595448e09 | 2026-09-03 15:57 | 2026-09-03 15:57 | 2026-09-03 15:57 | MU | MU260904P00952500 | put | 952.5000 | 2026-09-04 | 10.7500 | 10.2000 | 10.7500 | 956.3600 | 107500.00 | 107500.00 | 0.00 | 100 | 21 | 4740 | 266 | 17.8195488721805 | 0.63381605863071 | 0.63381605863071 | false | false | false | true | ||||||||||||||||
| a84f4b67-8931-4574-8df3-0b8e0c48fe68 | 2026-09-03 15:59 | 2026-09-03 15:59 | 2026-09-03 15:59 | MU | MU260904P00952500 | put | 952.5000 | 2026-09-04 | 9.7000 | 9.7000 | 10.4500 | 957.6500 | 291000.00 | 0.00 | 291000.00 | 300 | 12 | 5040 | 266 | 18.9473684210526 | 0.608991862313314 | 0.608991862313314 | false | false | false | true | ||||||||||||||||
| 76016f2e-e520-4f98-aa90-5f13ef2bb7d9 | 2026-09-03 15:59 | 2026-09-03 15:59 | 2026-09-03 15:59 | MU | MU260904P00952500 | put | 952.5000 | 2026-09-04 | 9.7500 | 9.7500 | 10.4500 | 957.8800 | 288600.00 | 0.00 | 288600.00 | 296 | 15 | 5336 | 266 | 20.0601503759398 | 0.617368324718203 | 0.616506446632855 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:35:49.066709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:35:49.066709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:35:49.066709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |