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 |
|---|
| be4b73c6-e68c-4850-b44e-6df775448e0d | 2026-09-15 10:15 | 2026-09-15 10:14 | 2026-09-15 10:14 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 31.5000 | 31.5000 | 32.7500 | 499.7000 | 472500.00 | 0.00 | 472500.00 | 150 | 11 | 198 | 11005 | 0.0179918218991368 | 0.287405387776075 | 0.287405387776075 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 3752944946606.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 297dbf1e-5467-423d-82a1-1380325a4217 | 2026-09-18 10:09 | 2026-09-18 10:09 | 2026-09-18 10:09 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 27.1000 | 26.8000 | 27.1000 | 492.8850 | 176150.00 | 176150.00 | 0.00 | 65 | 28 | 98 | 10940 | 0.00895795246800731 | 0.285140384416569 | 0.285140384416569 | true | false | false | true | ||||||||||||||||
| 603e5115-9330-4898-80d4-e717ea975edb | 2026-09-21 13:51 | 2026-09-21 13:51 | 2026-09-21 13:51 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 30.0000 | 29.3500 | 30.2500 | 498.6300 | 15000.00 | 9000.00 | 6000.00 | 5 | 5 | 718 | 11008 | 0.0652252906976744 | 0.289648553954139 | 0.289648553954139 | true | false | false | true | ||||||||||||||||
| 754a9c16-e932-4435-91c9-c7d3079be8b2 | 2026-09-21 14:22 | 2026-09-21 14:22 | 2026-09-21 14:22 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 30.2000 | 30.0000 | 30.2000 | 498.4400 | 42280.00 | 42280.00 | 0.00 | 14 | 11 | 772 | 11008 | 0.0701308139534884 | 0.292898632848411 | 0.292785671035341 | true | false | false | true | ||||||||||||||||
| ffc189b9-d00c-435f-b083-abdb950d3ee0 | 2026-09-21 14:46 | 2026-09-21 14:46 | 2026-09-21 14:46 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 30.3000 | 29.9000 | 30.7000 | 498.0000 | 57579.00 | 9099.00 | 48480.00 | 19 | 5 | 807 | 11008 | 0.0733103197674419 | 0.293872419504165 | 0.293562958729915 | false | false | false | true | ||||||||||||||||
| 5a3a3483-381e-4d9e-bc42-7d2e60bd228f | 2026-09-22 09:41 | 2026-09-22 09:41 | 2026-09-22 09:41 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 31.2200 | 30.8000 | 31.6000 | 499.8700 | 90530.00 | 65625.00 | 24905.00 | 29 | 5 | 76 | 10880 | 0.00698529411764706 | 0.292613780700613 | 0.297280814494531 | false | false | false | true | ||||||||||||||||
| 7cd84e2b-15ff-4919-bebc-57b59886e218 | 2026-09-22 11:09 | 2026-09-22 11:09 | 2026-09-22 11:09 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 28.7400 | 28.5000 | 28.8000 | 495.0000 | 28745.00 | 14375.00 | 14370.00 | 10 | 5 | 317 | 10880 | 0.0291360294117647 | 0.294347646521795 | 0.294347646521795 | false | false | false | true | ||||||||||||||||
| 48dcb470-ba55-4546-a865-95fe869932f4 | 2026-09-23 13:15 | 2026-09-23 13:14 | 2026-09-23 13:14 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 31.1000 | 30.9000 | 31.1000 | 499.0000 | 52870.00 | 52870.00 | 0.00 | 17 | 7 | 351 | 11680 | 0.0300513698630137 | 0.298043135395566 | 0.297967332240069 | true | false | false | true | ||||||||||||||||
| ee72e453-0c94-4674-a888-f7ea878d420e | 2026-09-24 09:32 | 2026-09-24 09:32 | 2026-09-24 09:32 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 28.0000 | 26.0000 | 28.6500 | 493.3600 | 69990.00 | 69990.00 | 0.00 | 25 | 5 | 28 | 11668 | 0.00239972574562907 | 0.309851451686645 | 0.299184873858833 | false | false | false | true | ||||||||||||||||
| 4b8aab21-9e22-4fce-a16a-35d215ae0db4 | 2026-09-24 10:53 | 2026-09-24 10:53 | 2026-09-24 10:53 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 27.7200 | 27.3500 | 27.8000 | 494.7750 | 27716.00 | 27716.00 | 0.00 | 10 | 5 | 178 | 11668 | 0.0152553993829277 | 0.293927166016443 | 0.291402191428034 | false | false | false | true | ||||||||||||||||
| 78d07eac-fa3f-4559-a112-d5ab9000f5a1 | 2026-09-24 11:03 | 2026-09-24 11:03 | 2026-09-24 11:03 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 27.3000 | 26.6000 | 27.3000 | 494.4300 | 27300.00 | 27300.00 | 0.00 | 10 | 5 | 200 | 11668 | 0.0171408981830648 | 0.290571795432601 | 0.290571795432601 | false | false | false | true | ||||||||||||||||
| 32d9425a-daed-4ac7-ae9b-2eab89ac33ba | 2026-09-24 12:52 | 2026-09-24 12:52 | 2026-09-24 12:52 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 28.5600 | 27.7500 | 28.6000 | 496.0000 | 17135.00 | 11430.00 | 5705.00 | 6 | 6 | 412 | 11668 | 0.0353102502571135 | 0.290904115159596 | 0.290379035726851 | true | false | false | true | ||||||||||||||||
| b5de9a3c-b4e1-4358-a528-f9b4db355bdb | 2026-09-25 09:43 | 2026-09-25 09:43 | 2026-09-25 09:43 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 37.6800 | 37.3000 | 38.9000 | 512.6400 | 41450.00 | 18830.00 | 22620.00 | 11 | 5 | 144 | 11769 | 0.012235534030079 | 0.291543843214155 | 0.290471542800412 | false | false | false | true | ||||||||||||||||
| c1d7f87b-4083-425b-9fb4-5f61407b18c9 | 2026-09-25 09:43 | 2026-09-25 09:43 | 2026-09-25 09:43 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 37.9500 | 37.4000 | 37.9500 | 512.8850 | 83490.00 | 37950.00 | 0.00 | 22 | 10 | 167 | 11769 | 0.0141898207154389 | 0.292581790382881 | 0.292581790382881 | true | false | false | true | ||||||||||||||||
| bedd49d6-4d3a-48fe-8317-67e6fac914db | 2026-09-25 09:44 | 2026-09-25 09:44 | 2026-09-25 09:44 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 38.2000 | 37.3000 | 38.2000 | 512.8300 | 53475.00 | 49660.00 | 3815.00 | 14 | 9 | 191 | 11769 | 0.0162290763871187 | 0.297235907336114 | 0.295631181962429 | false | false | false | true | ||||||||||||||||
| 78fa4b64-8111-4f5b-9c3b-d4486e16f327 | 2026-09-25 09:58 | 2026-09-25 09:58 | 2026-09-25 09:58 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 40.4500 | 39.7000 | 40.7000 | 516.0500 | 56630.00 | 56630.00 | 0.00 | 14 | 5 | 348 | 11769 | 0.0295692072393576 | 0.297911913964245 | 0.297911913964245 | false | false | false | true | ||||||||||||||||
| 31e3be7b-badc-4a09-8f13-fa4683f3e8f4 | 2026-09-25 13:24 | 2026-09-25 13:24 | 2026-09-25 13:24 | MSFT | MSFT261218C00500000 | call | 500.0000 | 2026-12-18 | 40.8000 | 40.1000 | 41.4000 | 516.6700 | 69360.00 | 8160.00 | 61200.00 | 17 | 14 | 549 | 11769 | 0.0466479734896763 | 0.297179459461143 | 0.297388760134979 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3666585852546.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 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-21T17:55:32.885478Z"} |
| 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:23:56.707397Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-21T18:50:33.734980Z"} |
| 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:41:44.035284Z"} |
| 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-22T15:10:39.659738Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:17:19.986908Z"} |
| 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-24T13:34:09.637313Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T14:56:01.849843Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T15:05:25.664270Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T16:56:09.107072Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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:43:32.172352Z"} |
| 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:43:32.172352Z"} |
| 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:45:37.818098Z"} |
| 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-25T17:33:28.969909Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |