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_alerts474,253 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 |
|---|
| 22d591de-310d-4baf-b94b-ae608827ccff | 2026-09-21 11:52 | 2026-09-21 11:52 | 2026-09-21 11:52 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 1.0900 | 1.0900 | 1.1500 | 493.8300 | 15696.00 | 0.00 | 15696.00 | 144 | 23 | 581 | 184 | 3.15760869565217 | 0.27032576535698 | 0.271439976527592 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 3724727873741.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:56:02.019393Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| ca2601e5-df82-4097-8a98-20b8b004533a | 2026-09-21 12:29 | 2026-09-21 12:29 | 2026-09-21 12:29 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 1.1900 | 1.1900 | 1.2200 | 494.0000 | 17850.00 | 0.00 | 17850.00 | 150 | 11 | 873 | 184 | 4.7445652173913 | 0.271153548932553 | 0.271153548932553 | true | false | false | true | ||||||||||||||||
| ecea10ba-5c90-4b49-b18f-ff01fca28d8c | 2026-09-21 14:37 | 2026-09-21 14:36 | 2026-09-21 14:36 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 2.0800 | 2.0800 | 2.0900 | 497.5900 | 22880.00 | 0.00 | 22880.00 | 110 | 14 | 1790 | 184 | 9.72826086956522 | 0.275165858639075 | 0.273221139155802 | false | false | false | true | ||||||||||||||||
| 6fd36e9c-3c52-4a92-9aaf-537e46a162af | 2026-09-21 15:14 | 2026-09-21 15:14 | 2026-09-21 15:14 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 2.7700 | 2.7700 | 2.8500 | 499.4900 | 13019.00 | 0.00 | 13019.00 | 47 | 7 | 2023 | 184 | 10.9945652173913 | 0.274210656231629 | 0.274210656231629 | false | false | false | true | ||||||||||||||||
| 281b9ecd-dba4-4208-b84f-74f1e9c4c2a1 | 2026-09-21 15:44 | 2026-09-21 15:44 | 2026-09-21 15:44 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 2.8200 | 2.7300 | 2.9300 | 499.7101 | 21185.00 | 0.00 | 21185.00 | 75 | 6 | 2649 | 184 | 14.3967391304348 | 0.264751848962748 | 0.272312967964219 | false | false | false | true | ||||||||||||||||
| db5d7ead-c2e6-4cd1-bc61-2f64b2abfdfa | 2026-09-21 15:47 | 2026-09-21 15:47 | 2026-09-21 15:47 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 3.1200 | 3.1000 | 3.3500 | 500.0000 | 23430.00 | 0.00 | 12090.00 | 75 | 6 | 2777 | 184 | 15.0923913043478 | 0.265116236018448 | 0.265116236018448 | false | false | false | true | ||||||||||||||||
| bd6d8cee-1058-4c93-a14e-1bdee876dfe9 | 2026-09-21 15:54 | 2026-09-21 15:54 | 2026-09-21 15:54 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 3.3000 | 3.3000 | 3.5500 | 500.0000 | 12210.00 | 0.00 | 12210.00 | 37 | 5 | 2959 | 184 | 16.0815217391304 | 0.273128677322938 | 0.273128677322938 | true | false | false | true | ||||||||||||||||
| 9445dcbe-ac2d-47de-addf-3c07f167d63d | 2026-09-21 15:56 | 2026-09-21 15:56 | 2026-09-21 15:56 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 3.5000 | 3.4500 | 3.5500 | 501.0000 | 46200.00 | 42700.00 | 3150.00 | 132 | 20 | 3144 | 184 | 17.0869565217391 | 0.280528695015822 | 0.280682305695491 | false | false | false | true | ||||||||||||||||
| 2c5e4131-c46e-4c74-abe9-4b776878eea1 | 2026-09-22 09:36 | 2026-09-22 09:36 | 2026-09-22 09:36 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 3.5900 | 3.5000 | 3.7500 | 501.9050 | 49220.00 | 14430.00 | 34790.00 | 137 | 8 | 750 | 854 | 0.878220140515222 | 0.363960440047153 | 0.378062404498596 | false | false | false | true | ||||||||||||||||
| 656d84b0-fa62-4275-bbf7-3141f41f1e75 | 2026-09-22 10:00 | 2026-09-22 10:00 | 2026-09-22 10:00 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 1.3800 | 1.3400 | 1.4100 | 496.0000 | 22080.00 | 22080.00 | 0.00 | 160 | 5 | 4946 | 854 | 5.79156908665105 | 0.345591002077825 | 0.345591002077825 | false | false | false | true | ||||||||||||||||
| 5463107a-5dcc-45b4-83d3-75e9e6336840 | 2026-09-22 14:44 | 2026-09-22 14:44 | 2026-09-22 14:44 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 1.4100 | 1.3900 | 1.4200 | 498.6755 | 25033.00 | 16638.00 | 3775.00 | 178 | 43 | 17714 | 854 | 20.7423887587822 | 0.278925625576847 | 0.278925625576847 | true | false | false | true | ||||||||||||||||
| aa01aca2-46e7-495f-b058-65957bce3756 | 2026-09-22 14:47 | 2026-09-22 14:47 | 2026-09-22 14:47 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 1.5000 | 1.4500 | 1.5100 | 499.0400 | 10051.00 | 10051.00 | 0.00 | 67 | 12 | 18435 | 854 | 21.5866510538642 | 0.279897060190332 | 0.277369556319091 | false | false | false | true | ||||||||||||||||
| 41e9a968-c700-45f5-93b5-13842aab7ce3 | 2026-09-23 09:42 | 2026-09-23 09:42 | 2026-09-23 09:42 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 6.6100 | 6.5000 | 6.8000 | 508.5000 | 19836.00 | 0.00 | 19836.00 | 30 | 7 | 4565 | 2829 | 1.61364439731354 | 0.477446478399727 | 0.477446478399727 | false | false | false | true | ||||||||||||||||
| 67e825a9-ce08-4311-821e-415ce156c339 | 2026-09-23 09:42 | 2026-09-23 09:42 | 2026-09-23 09:42 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 5.7100 | 5.6000 | 6.1500 | 507.6300 | 12563.00 | 0.00 | 12563.00 | 22 | 5 | 4621 | 2829 | 1.63343937787204 | 0.388212655547557 | 0.417131740629766 | false | false | false | true | ||||||||||||||||
| 0fada1e9-051e-4ecf-8ff9-a9e514e3074d | 2026-09-23 09:43 | 2026-09-23 09:43 | 2026-09-23 09:43 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 6.4300 | 6.3500 | 6.7000 | 508.3200 | 11573.00 | 0.00 | 11573.00 | 18 | 9 | 4803 | 2829 | 1.69777306468717 | 0.472006469351534 | 0.469187676325589 | false | false | false | true | ||||||||||||||||
| 7aa0e93c-334d-4ca3-a7c7-dde292b67470 | 2026-09-23 09:45 | 2026-09-23 09:45 | 2026-09-23 09:45 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 4.7500 | 4.7500 | 5.3500 | 506.0000 | 24703.00 | 0.00 | 24703.00 | 52 | 5 | 5001 | 2829 | 1.7677624602333 | 0.397884102586733 | 0.397884102586733 | false | false | false | true | ||||||||||||||||
| 5dc630f8-371c-44bd-968c-b88abbff2ecd | 2026-09-23 11:02 | 2026-09-23 11:02 | 2026-09-23 11:02 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 0.7900 | 0.7700 | 0.8000 | 499.4400 | 16346.00 | 11455.00 | 4891.00 | 208 | 6 | 15733 | 2829 | 5.56132909155179 | 0.394498160098743 | 0.404430988879066 | false | false | false | true | ||||||||||||||||
| b68dafce-7999-4466-82aa-a0503267437e | 2026-09-23 11:05 | 2026-09-23 11:05 | 2026-09-23 11:05 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 0.6900 | 0.6800 | 0.6900 | 499.5400 | 13795.00 | 13455.00 | 340.00 | 200 | 9 | 16427 | 2829 | 5.80664545775893 | 0.378441484388591 | 0.375816720543375 | false | false | false | true | ||||||||||||||||
| 10c9eb43-5c43-43c5-8f37-53ca9b4820a3 | 2026-09-23 11:06 | 2026-09-23 11:06 | 2026-09-23 11:06 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 0.7300 | 0.6500 | 0.7500 | 499.6700 | 21754.00 | 21681.00 | 73.00 | 298 | 7 | 16878 | 2829 | 5.966065747614 | 0.3805134380994 | 0.3805134380994 | false | false | false | true | ||||||||||||||||
| 905e5ecc-0c86-41b1-b9b1-4e551845f028 | 2026-09-23 12:34 | 2026-09-23 12:34 | 2026-09-23 12:34 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 0.3000 | 0.2700 | 0.3000 | 498.7050 | 10500.00 | 10500.00 | 0.00 | 350 | 17 | 25310 | 2829 | 8.94662424885118 | 0.375729971328998 | 0.375729971328998 | true | false | false | true | ||||||||||||||||
| 860333fc-b494-4910-8fca-8745ead7f12f | 2026-09-23 13:01 | 2026-09-23 13:01 | 2026-09-23 13:01 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 0.4400 | 0.4000 | 0.4400 | 499.7400 | 21800.00 | 21800.00 | 0.00 | 500 | 11 | 28160 | 2829 | 9.95404736656062 | 0.379127813323871 | 0.382564486596324 | false | false | false | true | ||||||||||||||||
| f75c4773-8176-47d0-b051-c1f9f20fe07f | 2026-09-23 14:46 | 2026-09-23 14:46 | 2026-09-23 14:46 | MSFT | MSFT260923C00502500 | call | 502.5000 | 2026-09-23 | 0.2400 | 0.2400 | 0.2700 | 500.7200 | 12720.00 | 0.00 | 12720.00 | 530 | 12 | 40773 | 2829 | 14.4125132555673 | 0.358919413090076 | 0.358919413090076 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:32:17.927421Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:37:54.025147Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:15:34.344712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:46:53.809312Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:50:07.722851Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:37:27.552956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:01:27.900775Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:55:20.077577Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:55:20.077577Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:45:53.710169Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:04:15.950179Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:09:03.866421Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:09:03.866421Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:39:09.093031Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:03:13.598333Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:50:04.558688Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |