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_alerts326,449 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 |
|---|
| 0ae12970-673b-430b-8746-ba871196a1cc | 2026-09-18 10:28 | 2026-09-18 10:28 | 2026-09-18 10:28 | VG | VG261002C00015000 | call | 15.0000 | 2026-10-02 | 0.4500 | 0.3500 | 0.4500 | 14.3950 | 32563.00 | 32563.00 | 0.00 | 726 | 46 | 1159 | 1769 | 0.655172413793103 | 0.613173536513425 | 0.613173536513425 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 7451467270.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 64e48cf9-2247-436b-a167-586bab7543c1 | 2026-09-16 15:35 | 2026-09-16 15:35 | 2026-09-16 15:35 | VG | VG260918P00015000 | put | 15.0000 | 2026-09-18 | 0.5000 | 0.5000 | 0.6500 | 14.6250 | 12528.00 | 0.00 | 12528.00 | 250 | 9 | 2184 | 3486 | 0.626506024096386 | 0.655291468982495 | 0.655291468982495 | false | false | false | true | ||||||||||||||||
| 1a64a484-0974-4b06-9d90-83812cf6ce08 | 2026-09-15 11:28 | 2026-09-15 11:28 | 2026-09-15 11:28 | VG | VG270219C00020000 | call | 20.0000 | 2027-02-19 | 1.0500 | 1.0500 | 1.1500 | 15.2900 | 13792.00 | 0.00 | 13792.00 | 131 | 10 | 165 | 532 | 0.31015037593985 | 0.599069407046505 | 0.594005136326826 | true | false | false | true | ||||||||||||||||
| c3b39dda-f58f-435c-9ddf-f8a3d5bae5c8 | 2026-09-11 10:59 | 2026-09-11 10:59 | 2026-09-11 10:59 | VG | VG261002C00015000 | call | 15.0000 | 2026-10-02 | 1.3500 | 1.1500 | 1.4000 | 15.8800 | 188575.00 | 188575.00 | 0.00 | 1399 | 30 | 1414 | 380 | 3.72105263157895 | 0.676629400033981 | 0.551255423810735 | true | false | false | true | ||||||||||||||||
| 4865bd84-bd4d-4793-b8bb-70c1cefe92c2 | 2026-09-11 10:59 | 2026-09-11 10:59 | 2026-09-11 10:59 | VG | VG261002C00015500 | call | 15.5000 | 2026-10-02 | 1.0900 | 0.6500 | 1.0500 | 15.8800 | 31650.00 | 31650.00 | 0.00 | 290 | 16 | 290 | 64 | 4.53125 | 0.687074176300112 | 0.585296708504741 | true | false | false | true | ||||||||||||||||
| 3baae247-65ab-4f38-9759-092be2c69d30 | 2026-09-10 12:42 | 2026-09-10 12:42 | 2026-09-10 12:42 | VG | VG270115C00022500 | call | 22.5000 | 2027-01-15 | 0.6500 | 0.6500 | 0.7500 | 15.0000 | 13002.00 | 0.00 | 13002.00 | 200 | 5 | 404 | 5041 | 0.0801428288038088 | 0.627299895495758 | 0.620252684933179 | false | false | false | true | ||||||||||||||||
| ccae3d0a-bb7e-47ac-a50d-64b72a5479b3 | 2026-09-10 11:41 | 2026-09-10 11:41 | 2026-09-10 11:41 | VG | VG270115C00020000 | call | 20.0000 | 2027-01-15 | 1.0500 | 0.9500 | 1.1000 | 15.7050 | 118530.00 | 118425.00 | 105.00 | 1129 | 51 | 1175 | 13688 | 0.0858416130917592 | 0.626037173646123 | 0.62406257609152 | false | false | false | true | ||||||||||||||||
| 9628afbe-64cd-47e7-90b1-bbb841290259 | 2026-09-04 13:55 | 2026-09-04 13:55 | 2026-09-04 13:55 | VG | VG261218C00017500 | call | 17.5000 | 2026-12-18 | 0.8600 | 0.8500 | 0.9500 | 14.3400 | 12943.00 | 0.00 | 12943.00 | 150 | 8 | 179 | 7181 | 0.024926890405236 | 0.599091625093118 | 0.595523589618424 | false | false | false | true | ||||||||||||||||
| e89d6bd4-7cc4-4ca4-ace2-9550496c8128 | 2026-09-02 12:25 | 2026-09-02 12:25 | 2026-09-02 12:25 | VG | VG260904C00015000 | call | 15.0000 | 2026-09-04 | 0.2400 | 0.2000 | 0.2500 | 14.8250 | 12778.00 | 12778.00 | 0.00 | 530 | 44 | 2372 | 2977 | 0.796775277124622 | 0.751765976729664 | 0.746801778647822 | false | false | false | true | ||||||||||||||||
| e94aca01-37cc-4e83-8e43-f7ac3733259c | 2026-08-31 15:18 | 2026-08-31 15:17 | 2026-08-31 15:17 | VG | VG261016C00015000 | call | 15.0000 | 2026-10-16 | 1.0600 | 1.0500 | 1.1500 | 14.6600 | 12814.00 | 0.00 | 12814.00 | 121 | 11 | 3556 | 2827 | 1.25787053413513 | 0.575590733003114 | 0.573211980468362 | false | false | false | true | ||||||||||||||||
| 592ce478-286e-4587-88fa-b3a4e55453a2 | 2026-08-31 14:20 | 2026-08-31 14:20 | 2026-08-31 14:20 | VG | VG261016C00017500 | call | 17.5000 | 2026-10-16 | 0.4000 | 0.4000 | 0.4500 | 14.0000 | 40142.00 | 0.00 | 40142.00 | 1000 | 21 | 3462 | 23056 | 0.150156141568355 | 0.599971272498844 | 0.587834851664765 | false | false | false | true | ||||||||||||||||
| b27016c7-fec3-48e0-9994-79c961ec8243 | 2026-08-27 13:46 | 2026-08-27 13:46 | 2026-08-27 13:46 | VG | VG260904C00015000 | call | 15.0000 | 2026-09-04 | 0.3000 | 0.2500 | 0.3000 | 14.4600 | 14980.00 | 14980.00 | 0.00 | 500 | 38 | 1039 | 1640 | 0.633536585365854 | 0.600429320166309 | 0.600429320166309 | false | false | false | true | ||||||||||||||||
| b64fc70b-93ae-415e-8896-231e2eb38a4a | 2026-08-26 15:41 | 2026-08-26 15:41 | 2026-08-26 15:41 | VG | VG270115P00015000 | put | 15.0000 | 2027-01-15 | 2.5700 | 2.5000 | 2.6000 | 14.3250 | 30560.00 | 30560.00 | 0.00 | 119 | 7 | 541 | 5080 | 0.106496062992126 | 0.659408685106574 | 0.648093754579492 | false | false | false | true | ||||||||||||||||
| 6cd71e41-05ac-443d-ac63-3098aae1eb9a | 2026-08-24 14:12 | 2026-08-24 14:11 | 2026-08-24 14:11 | VG | VG261016C00017500 | call | 17.5000 | 2026-10-16 | 0.4100 | 0.4000 | 0.5000 | 14.3650 | 34715.00 | 0.00 | 34715.00 | 837 | 6 | 935 | 14307 | 0.0653526245893618 | 0.609659629159258 | 0.609659629159258 | false | false | false | true | ||||||||||||||||
| a8418abc-55ef-451c-b475-33445a1d2b05 | 2026-08-18 11:33 | 2026-08-18 11:33 | 2026-08-18 11:33 | VG | VG260821C00014000 | call | 14.0000 | 2026-08-21 | 0.3200 | 0.3000 | 0.4000 | 14.0000 | 65000.00 | 0.00 | 64335.00 | 2001 | 29 | 2167 | 37058 | 0.0584759026391063 | 0.65622811255645 | 0.58831912637319 | true | false | false | true | ||||||||||||||||
| 1695549b-b0bc-4e6c-b255-a0cc37607246 | 2026-08-17 15:03 | 2026-08-17 15:03 | 2026-08-17 15:03 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.5300 | 0.5000 | 0.6000 | 13.7700 | 72880.00 | 0.00 | 72825.00 | 1374 | 20 | 6183 | 45616 | 0.135544545773413 | 0.609999111001594 | 0.578145039259559 | false | false | false | true | ||||||||||||||||
| 0e7a4eeb-9764-4f1d-8f05-fa1847728190 | 2026-08-17 09:45 | 2026-08-17 09:44 | 2026-08-17 09:44 | VG | VG260918C00015000 | call | 15.0000 | 2026-09-18 | 0.5600 | 0.5500 | 0.6500 | 13.8650 | 19460.00 | 0.00 | 17780.00 | 345 | 23 | 1111 | 45616 | 0.0243554893019993 | 0.621022138287425 | 0.588771099130824 | true | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 7786304957.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:45:47.974261Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:29:06.202071Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T17:02:16.286608Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T18:01:17.201510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T18:25:38.432903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T17:46:53.178792Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:59:46.397035Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 8115827761.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |