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_alerts658,639 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 |
|---|
| e3676b88-d3e5-4a18-863c-d0149e1ed49f | 2026-09-23 09:55 | 2026-09-23 09:54 | 2026-09-23 09:54 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 2.4300 | 2.3000 | 2.4300 | 503.0300 | 24300.00 | 24300.00 | 0.00 | 100 | 9 | 143 | 149 | 0.959731543624161 | 0.27617989829069 | 0.27617989829069 | false | false | false | true | false | 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-23T13:55:29.867504Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 42d50fdf-5238-4036-9736-970e5360d374 | 2026-09-25 12:34 | 2026-09-25 12:34 | 2026-09-25 12:34 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 5.7000 | 5.7000 | 6.2000 | 517.3400 | 18815.00 | 0.00 | 18815.00 | 33 | 5 | 684 | 286 | 2.39160839160839 | 0.273438782139887 | 0.273438782139887 | true | false | false | true | ||||||||||||||||
| a514bc42-1e21-4f1d-b765-37af2d6551c9 | 2026-09-25 12:43 | 2026-09-25 12:43 | 2026-09-25 12:43 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 5.2500 | 5.0000 | 5.2500 | 516.3900 | 17325.00 | 17325.00 | 0.00 | 33 | 18 | 740 | 286 | 2.58741258741259 | 0.270975801818218 | 0.270975801818218 | false | false | false | |||||||||||||||||
| 6906167f-bf86-4ace-ac2b-981f15065e64 | 2026-09-25 14:21 | 2026-09-25 14:21 | 2026-09-25 14:21 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 6.2000 | 5.9000 | 6.2500 | 518.8700 | 179180.00 | 165540.00 | 13640.00 | 289 | 27 | 1204 | 286 | 4.20979020979021 | 0.268494440851185 | 0.268028050451651 | false | false | false | |||||||||||||||||
| 10a7450b-4252-45ea-a062-33bde677dc16 | 2026-09-25 15:53 | 2026-09-25 15:53 | 2026-09-25 15:53 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 5.1000 | 5.1000 | 5.2500 | 516.5950 | 12240.00 | 0.00 | 5100.00 | 24 | 6 | 1314 | 286 | 4.59440559440559 | 0.262593606630231 | 0.262593606630231 | false | false | false | true | ||||||||||||||||
| 5bb4d704-1dc6-4d75-9e97-de9c60885fc2 | 2026-09-25 15:53 | 2026-09-25 15:53 | 2026-09-25 15:53 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 5.1000 | 5.1000 | 5.2500 | 516.4700 | 15810.00 | 0.00 | 15810.00 | 31 | 11 | 1345 | 286 | 4.7027972027972 | 0.264374678555241 | 0.264374678555241 | false | false | false | |||||||||||||||||
| 0ce000e9-1824-4923-a3f4-27cd66615854 | 2026-09-29 11:42 | 2026-09-29 11:42 | 2026-09-29 11:42 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 1.8000 | 1.7000 | 1.8000 | 508.9300 | 16380.00 | 16380.00 | 0.00 | 91 | 13 | 753 | 896 | 0.840401785714286 | 0.342293514226158 | 0.342293514226158 | false | false | false | |||||||||||||||||
| ae719bff-796c-48bd-aa49-754c58e3cec5 | 2026-09-30 09:50 | 2026-09-30 09:50 | 2026-09-30 09:50 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 2.4900 | 2.4900 | 2.6300 | 514.0000 | 14941.00 | 250.00 | 14691.00 | 60 | 7 | 640 | 1325 | 0.483018867924528 | 0.354647971457092 | 0.35890719555963 | true | false | false | |||||||||||||||||
| eb09915f-82ee-4c79-af74-f8cbfffcc5b9 | 2026-09-30 13:01 | 2026-09-30 13:01 | 2026-09-30 13:01 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 3.0000 | 2.9900 | 3.1000 | 518.0100 | 33000.00 | 0.00 | 33000.00 | 110 | 14 | 2525 | 1325 | 1.90566037735849 | 0.317567787735624 | 0.317567787735624 | true | false | false | |||||||||||||||||
| e2f02458-754d-4fdc-8058-4c1bc98c2bc6 | 2026-09-30 14:41 | 2026-09-30 14:41 | 2026-09-30 14:41 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 2.8700 | 2.8700 | 2.9100 | 517.7601 | 38745.00 | 0.00 | 38745.00 | 135 | 13 | 2902 | 1325 | 2.19018867924528 | 0.313411399191265 | 0.314780319156033 | true | false | false | |||||||||||||||||
| 0764fbe2-bc34-4c28-8dd7-fb416ca1dffc | 2026-09-30 14:45 | 2026-09-30 14:44 | 2026-09-30 14:44 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 2.9900 | 2.9900 | 3.0500 | 518.1850 | 10166.00 | 0.00 | 10166.00 | 34 | 11 | 2948 | 1325 | 2.22490566037736 | 0.312433488514633 | 0.312433488514633 | false | false | false | |||||||||||||||||
| 06cb5240-cac5-4a12-9304-ee12a7a20cb9 | 2026-10-01 09:52 | 2026-10-01 09:52 | 2026-10-01 09:52 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 2.5700 | 2.4800 | 2.6000 | 517.9400 | 10283.00 | 10283.00 | 0.00 | 40 | 5 | 9418 | 1712 | 5.50116822429907 | 0.414151993872288 | 0.414026085346172 | false | false | false | |||||||||||||||||
| cbee7b4c-e76b-4f6e-b0be-adccd8e81bc2 | 2026-10-01 09:58 | 2026-10-01 09:58 | 2026-10-01 09:58 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 2.4600 | 2.4600 | 2.6000 | 518.3900 | 24600.00 | 0.00 | 24600.00 | 100 | 10 | 10088 | 1712 | 5.89252336448598 | 0.384399466672411 | 0.384399466672411 | false | false | false | |||||||||||||||||
| 5c2e7f87-5136-4ac0-a177-883b3f8e858b | 2026-10-01 10:10 | 2026-10-01 10:10 | 2026-10-01 10:10 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 2.6400 | 2.6400 | 2.7400 | 518.0000 | 16104.00 | 0.00 | 15840.00 | 61 | 5 | 10947 | 1712 | 6.39427570093458 | 0.393648207532364 | 0.393648207532364 | false | false | false | |||||||||||||||||
| eb171864-511f-4109-91d9-95b5679a0027 | 2026-10-01 10:26 | 2026-10-01 10:26 | 2026-10-01 10:26 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 2.4600 | 2.4000 | 2.4600 | 518.3600 | 10578.00 | 10578.00 | 0.00 | 43 | 14 | 12286 | 1712 | 7.17640186915888 | 0.385449510979018 | 0.385449510979018 | false | false | false | |||||||||||||||||
| 434dcc1c-b10f-4fd6-92f7-626c9ce3b258 | 2026-10-01 10:38 | 2026-10-01 10:38 | 2026-10-01 10:38 | MSFT | MSFT261002C00522500 | call | 522.5000 | 2026-10-02 | 1.5400 | 1.5400 | 1.6400 | 516.1300 | 23100.00 | 0.00 | 23100.00 | 150 | 17 | 12893 | 1712 | 7.53095794392523 | 0.360838938290252 | 0.360838938290252 | false | false | false |
| false |
| 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:34:19.672703Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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:45:32.616673Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T18:27:02.000981Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T19:54:56.567521Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T19:54:56.567521Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3779305633099.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:47:25.537370Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3779305633099.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:52:36.034936Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3779305633099.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:09:03.599351Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3779305633099.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T18:48:14.075772Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3779305633099.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T18:48:14.075772Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3807819727785.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:54:23.923373Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3807819727785.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:59:25.903362Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3807819727785.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T14:10:48.155850Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3807819727785.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T14:30:01.775472Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3807819727785.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T14:39:17.807457Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |