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 | strike |
|---|
| expirydate |
|---|
| 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 |
|---|
| cb6a0879-15a0-4901-aabc-eeb45d425201 | 2026-09-30 10:09 | 2026-09-30 10:09 | 2026-09-30 10:09 | HL | HL280121P00017000 | put | 17.0000 | 2028-01-21 | 4.0700 | 4.0000 | 4.1000 | 17.2650 | 32585.00 | 15170.00 | 810.00 | 80 | 20 | 285 | 1055 | 0.270142180094787 | 0.638235728655515 | 0.631142703959884 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 11520828592.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T14:11:55.859186Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| 529d4951-e136-4059-b07a-59339e05a5c1 | 2026-09-30 10:09 | 2026-09-30 10:09 | 2026-09-30 10:09 | HL | HL280121P00017000 | put | 17.0000 | 2028-01-21 | 4.0800 | 3.9500 | 4.1000 | 17.2600 | 35050.00 | 18040.00 | 810.00 | 86 | 21 | 205 | 1055 | 0.194312796208531 | 0.638010139911562 | 0.630916699757233 | false | false | ||||||||||||||||||
| 9eb0bb61-5fcb-4233-bf78-525f0730d9d1 | 2026-09-30 10:09 | 2026-09-30 10:09 | 2026-09-30 10:09 | HL | HL280121P00017000 | put | 17.0000 | 2028-01-21 | 4.0800 | 4.0500 | 4.5500 | 17.2450 | 44050.00 | 0.00 | 23550.00 | 108 | 34 | 108 | 1055 | 0.102369668246445 | 0.637332552873138 | 0.630237860999802 | false | false | ||||||||||||||||||
| 29bc9571-053c-4d28-844a-580c0f17434f | 2026-09-28 11:10 | 2026-09-28 11:10 | 2026-09-28 11:10 | HL | HL270319C00030000 | call | 30.0000 | 2027-03-19 | 0.6300 | 0.3800 | 0.6300 | 17.2750 | 15811.00 | 15687.00 | 62.00 | 251 | 7 | 604 | 10253 | 0.0589095874378231 | 0.671545632531175 | 0.66830072380664 | false | false | ||||||||||||||||||
| ffd04ba5-af4c-4170-aa2a-d4c7b5fa560f | 2026-09-17 11:50 | 2026-09-17 11:50 | 2026-09-17 11:50 | HL | HL270319C00021000 | call | 21.0000 | 2027-03-19 | 2.9900 | 2.9400 | 3.0500 | 19.1095 | 22687.00 | 2990.00 | 14333.00 | 76 | 8 | 187 | 864 | 0.216435185185185 | 0.659733828287524 | 0.657875547951187 | false | false | ||||||||||||||||||
| ce23ecb2-b793-4661-bcac-be61dbd63bec | 2026-09-15 11:55 | 2026-09-15 11:55 | 2026-09-15 11:55 | HL | HL270115P00021000 | put | 21.0000 | 2027-01-15 | 4.1300 | 3.8500 | 4.4000 | 18.4600 | 237599.00 | 237599.00 | 0.00 | 575 | 7 | 575 | 581 | 0.989672977624785 | 0.634802444855324 | 0.634802444855324 | false | false | ||||||||||||||||||
| b07cc8a1-5660-491a-a10f-0a06a3dcf973 | 2026-09-03 11:03 | 2026-09-03 11:03 | 2026-09-03 11:03 | HL | HL260918C00019000 | call | 19.0000 | 2026-09-18 | 2.3000 | 2.0900 | 2.3000 | 20.8850 | 11494.00 | 11494.00 | 0.00 | 50 | 8 | 145 | 7216 | 0.0200942350332594 | 0.673646335259198 | 0.657593067719527 | false | false | ||||||||||||||||||
| 4d3fae08-bc28-4165-a706-1906c0ee91ac | 2026-08-31 11:23 | 2026-08-31 11:23 | 2026-08-31 11:23 | HL | HL261218C00020000 | call | 20.0000 | 2026-12-18 | 2.8800 | 2.8100 | 2.9500 | 19.7150 | 11508.00 | 578.00 | 4018.00 | 40 | 6 | 96 | 2781 | 0.0345199568500539 | 0.681356359896199 | 0.681356359896199 | false | false | ||||||||||||||||||
| a3313efd-0e45-4bc9-bcc9-207da617fe89 | 2026-08-31 09:47 | 2026-08-31 09:47 | 2026-08-31 09:47 | HL | HL261218C00022000 | call | 22.0000 | 2026-12-18 | 2.1400 | 2.1300 | 2.3200 | 19.6101 | 23069.00 | 1290.00 | 20704.00 | 108 | 37 | 163 | 8835 | 0.0184493491794001 | 0.701886095028599 | 0.694846565385568 | true | false | ||||||||||||||||||
| c2a6cc8f-685d-4623-85b0-d10b5a607551 | 2026-08-27 10:14 | 2026-08-27 10:14 | 2026-08-27 10:14 | HL | HL261218C00022000 | call | 22.0000 | 2026-12-18 | 3.0700 | 3.0500 | 3.1000 | 21.0700 | 30708.00 | 8370.00 | 22338.00 | 100 | 7 | 8205 | 1642 | 4.99695493300853 | 0.726085476844427 | 0.72667702959847 | true | false | ||||||||||||||||||
| aa2b18af-0929-4139-8a68-f026209df6c7 | 2026-08-27 10:05 | 2026-08-27 10:05 | 2026-08-27 10:05 | HL | HL261218C00022000 | call | 22.0000 | 2026-12-18 | 3.0500 | 2.9200 | 3.0500 | 21.0200 | 1998340.00 | 1998340.00 | 0.00 | 6552 | 74 | 7053 | 1642 | 4.29537149817296 | 0.721799883025668 | 0.721799883025668 | false | false | ||||||||||||||||||
| a53c6e09-72a0-4ea8-a112-8fd008345542 | 2026-08-21 14:23 | 2026-08-21 14:23 | 2026-08-21 14:23 | HL | HL270115C00020000 | call | 20.0000 | 2027-01-15 | 3.9500 | 3.9500 | 4.0000 | 20.0000 | 39505.00 | 0.00 | 39505.00 | 100 | 13 | 737 | 11693 | 0.0630291627469426 | 0.672791827425568 | 0.670776740459292 | false | false | ||||||||||||||||||
| a9bcca62-7891-4667-90e3-b3882eab5574 | 2026-08-20 11:39 | 2026-08-20 11:39 | 2026-08-20 11:39 | HL | HL270115C00020000 | call | 20.0000 | 2027-01-15 | 4.0200 | 4.0000 | 4.1500 | 20.7902 | 40180.00 | 0.00 | 40180.00 | 100 | 6 | 517 | 12581 | 0.0410937127414355 | 0.676093668055892 | 0.676093668055892 | false | false | ||||||||||||||||||
| 548af54d-717a-4a4f-90c6-d27ec68925de | 2026-08-19 12:05 | 2026-08-19 12:05 | 2026-08-19 12:05 | HL | HL270115C00020000 | call | 20.0000 | 2027-01-15 | 3.8500 | 3.8500 | 3.9500 | 20.4700 | 151698.00 | 0.00 | 151698.00 | 394 | 19 | 1432 | 13320 | 0.107507507507508 | 0.677949256717307 | 0.677811705943732 | false | false | ||||||||||||||||||
| a8c1fa5d-485b-41f3-b916-05f175f92a6f | 2026-08-19 11:43 | 2026-08-19 11:43 | 2026-08-19 11:43 | HL | HL261218C00020000 | call | 20.0000 | 2026-12-18 | 3.4500 | 3.4500 | 3.5500 | 20.3866 | 210295.00 | 0.00 | 210295.00 | 609 | 10 | 735 | 2033 | 0.361534677816035 | 0.685024025511229 | 0.685024025511229 | false | false | ||||||||||||||||||
| 8eea0aed-81d1-46aa-9374-e803da6aa0b1 | 2026-08-19 11:25 | 2026-08-19 11:25 | 2026-08-19 11:25 | HL | HL261218C00027000 | call | 27.0000 | 2026-12-18 | 1.4300 | 1.3700 | 1.4300 | 20.2000 | 290418.00 | 288288.00 | 2130.00 | 2031 | 55 | 2074 | 410 | 5.05853658536585 | 0.721050830129938 | 0.719505582399475 | false | false | ||||||||||||||||||
| 39c68bbe-6fb7-4823-897e-7389b564e777 | 2026-08-19 09:43 | 2026-08-19 09:43 | 2026-08-19 09:43 | HL | HL270115C00022000 | call | 22.0000 | 2027-01-15 | 2.5000 | 2.1700 | 2.7500 | 19.5000 | 29960.00 | 29960.00 | 0.00 | 120 | 5 | 241 | 2982 | 0.0808182427900738 | 0.667118055714306 | 0.667118055714306 | false | false | ||||||||||||||||||
| d824b15a-5459-4045-879e-e80c3e2e47cd | 2026-08-18 10:14 | 2026-08-18 10:14 | 2026-08-18 10:14 | HL | HL260918C00018000 | call | 18.0000 | 2026-09-18 | 1.4300 | 1.4100 | 1.5100 | 18.2200 | 14308.00 | 0.00 | 14308.00 | 100 | 5 | 119 | 6039 | 0.0197052492134459 | 0.617401613831366 | 0.617401613831366 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 11520828592.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:11:55.859186Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 11520828592.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:11:55.859186Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 11426781011.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:13:28.016528Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 12736729452.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:59:42.981722Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 12642681871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 12642681871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:12:38.137640Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 12642681871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 12642681871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 12642681871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 12642681871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 12642681871.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 12642681871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 12642681871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 12642681871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 12642681871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 12642681871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 12642681871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |