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 | 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 |
|---|
| 1d3e5286-4d06-42a1-8ea2-e0ec679b9b7a | 2026-09-16 14:38 | 2026-09-16 14:38 | 2026-09-16 14:38 | MSFT | MSFT270115C00600000 | call | 600.0000 | 2027-01-15 | 5.5300 | 5.3000 | 5.5500 | 491.5800 | 276500.00 | 276500.00 | 0.00 | 500 | 6 | 772 | 22995 | 0.0335725157642966 | 0.282300582554269 | 0.282300582554269 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 3640744954237.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T18:44:45.237115Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 25ea7b2d-206e-4f0f-b6bd-7e186b7fc7a6 | 2026-09-16 14:38 | 2026-09-16 14:38 | 2026-09-16 14:38 | MSFT | MSFT270115C00600000 | call | 600.0000 | 2027-01-15 | 5.5000 | 5.3000 | 5.5000 | 491.7500 | 275000.00 | 275000.00 | 0.00 | 500 | 10 | 1272 | 22995 | 0.0553163731245923 | 0.281452823375809 | 0.281452823375809 | false | false | false | true | ||||||||||||||||
| 0c29f512-cf78-4443-9fe0-853e0bf0bb3a | 2026-09-21 13:46 | 2026-09-21 13:46 | 2026-09-21 13:46 | MSFT | MSFT270115C00600000 | call | 600.0000 | 2027-01-15 | 6.0000 | 5.8500 | 6.0500 | 498.0000 | 10200.00 | 10200.00 | 0.00 | 17 | 6 | 295 | 21666 | 0.0136158035631866 | 0.280388633035388 | 0.280388633035388 | false | false | false | true | ||||||||||||||||
| c5d0ae72-f60b-4d53-b5eb-303cd95c9a0e | 2026-09-22 14:48 | 2026-09-22 14:47 | 2026-09-22 14:47 | MSFT | MSFT270115C00600000 | call | 600.0000 | 2027-01-15 | 6.3300 | 6.1500 | 6.3500 | 499.0880 | 24070.00 | 24070.00 | 0.00 | 38 | 6 | 540 | 21676 | 0.0249123454511903 | 0.284697368438552 | 0.284988873361836 | false | false | false | true | ||||||||||||||||
| 56d9f29f-e89a-446e-97cd-128ef7cbc93e | 2026-09-23 14:29 | 2026-09-23 14:28 | 2026-09-23 14:28 | MSFT | MSFT270115C00600000 | call | 600.0000 | 2027-01-15 | 6.5500 | 6.4500 | 6.5500 | 500.3850 | 258064.00 | 258064.00 | 0.00 | 394 | 37 | 1063 | 21840 | 0.0486721611721612 | 0.286186078189103 | 0.286186078189103 | false | false | false | true | ||||||||||||||||
| 63806c2d-2255-4cfb-a6e4-be2cb0c26176 | 2026-09-24 12:19 | 2026-09-24 12:19 | 2026-09-24 12:19 | MSFT | MSFT270115C00600000 | call | 600.0000 | 2027-01-15 | 5.4000 | 5.2000 | 5.6500 | 495.8250 | 10800.00 | 5400.00 | 5400.00 | 20 | 7 | 259 | 21489 | 0.0120526781143841 | 0.280756847588428 | 0.280756847588428 | false | false | false | true | ||||||||||||||||
| 020fde18-a198-4e69-925c-34b39bca50f2 | 2026-09-25 09:34 | 2026-09-25 09:34 | 2026-09-25 09:34 | MSFT | MSFT270115C00600000 | call | 600.0000 | 2027-01-15 | 7.0000 | 5.3000 | 7.1000 | 507.0000 | 25905.00 | 25205.00 | 0.00 | 37 | 7 | 40 | 21472 | 0.0018628912071535 | 0.277447279002323 | 0.277788777925564 | true | false | false | true | ||||||||||||||||
| eb1b42b6-5cb2-4ab7-8c57-d5803f849ee1 | 2026-09-25 09:58 | 2026-09-25 09:58 | 2026-09-25 09:58 | MSFT | MSFT270115C00600000 | call | 600.0000 | 2027-01-15 | 9.6500 | 9.3500 | 9.8500 | 516.7600 | 53075.00 | 965.00 | 52110.00 | 55 | 7 | 389 | 21472 | 0.0181166169895678 | 0.288167968778382 | 0.288167968778382 | false | false | false | true | ||||||||||||||||
| 8d7b8e39-9061-4daf-a546-dd2777a92ebb | 2026-09-25 10:18 | 2026-09-25 10:18 | 2026-09-25 10:18 | MSFT | MSFT270115C00600000 | call | 600.0000 | 2027-01-15 | 8.6000 | 8.5000 | 8.6500 | 511.4000 | 20640.00 | 2580.00 | 860.00 | 24 | 18 | 466 | 21472 | 0.0217026825633383 | 0.289143838918416 | 0.289143838918416 | false | false | false | true | ||||||||||||||||
| 9d25d7ee-a7e3-40a0-8aa2-8e790a414bde | 2026-09-25 10:22 | 2026-09-25 10:21 | 2026-09-25 10:21 | MSFT | MSFT270115C00600000 | call | 600.0000 | 2027-01-15 | 8.8000 | 8.7500 | 8.9500 | 512.4650 | 13200.00 | 0.00 | 13200.00 | 15 | 15 | 492 | 21472 | 0.0229135618479881 | 0.288932443884212 | 0.288932443884212 | false | false | false | true | ||||||||||||||||
| 38b63e97-5dc0-4ec8-9277-6609c90256fb | 2026-09-25 12:52 | 2026-09-25 12:52 | 2026-09-25 12:52 | MSFT | MSFT270115C00600000 | call | 600.0000 | 2027-01-15 | 9.9000 | 9.7500 | 10.0000 | 517.9450 | 79200.00 | 7920.00 | 16830.00 | 80 | 19 | 756 | 21472 | 0.0352086438152012 | 0.288015449725775 | 0.288015449725775 | false | false | false | true | ||||||||||||||||
| 5a20d139-281d-4567-a561-11b4c548dc79 | 2026-09-25 12:53 | 2026-09-25 12:53 | 2026-09-25 12:53 | MSFT | MSFT270115C00600000 | call | 600.0000 | 2027-01-15 | 10.0000 | 9.8000 | 10.0000 | 518.2200 | 49000.00 | 49000.00 | 0.00 | 49 | 23 | 806 | 21472 | 0.0375372578241431 | 0.288799618634586 | 0.288459595239416 | false | false | false | true | ||||||||||||||||
| 1049ba3a-f385-4b12-9707-c73f2ec7fa78 | 2026-09-28 09:30 | 2026-09-28 09:30 | 2026-09-28 09:30 | MSFT | MSFT270115C00600000 | call | 600.0000 | 2027-01-15 | 7.1500 | 6.8000 | 8.0000 | 505.0000 | 11440.00 | 0.00 | 11440.00 | 16 | 6 | 33 | 21828 | 0.00151181968114349 | 0.290402389702827 | 0.290402389702827 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3640744954237.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:44:45.237115Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 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-21T17:46:19.788598Z"} |
| 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-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 |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:35:00.755474Z"} |
| 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-24T16:21:04.578939Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:34:45.543817Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:58:47.547545Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:19:54.895833Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:22:54.159476Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:59:29.985705Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:59:29.985705Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3781236274927.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:30:57.841770Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |