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 |
|---|
| 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 |
|---|
| f64d3f5f-ebbb-406f-9cb3-948f51509056 | 2026-08-17 13:45 | 2026-08-17 13:44 | 2026-08-17 13:44 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 1.6500 | 1.6000 | 1.6500 | 38.0000 | 11220.00 | 11220.00 | 0.00 | 68 | 11 | 140 | 1032 | 0.135658914728682 | 0.352991837112434 | 0.352991837112434 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bd86f034-7c8b-4bad-ae27-cd636ad58cdf | 2026-08-19 11:55 | 2026-08-19 11:55 | 2026-08-19 11:55 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 1.3000 | 1.2500 | 1.4000 | 39.1700 | 190954.00 | 27040.00 | 163914.00 | 1468 | 65 | 1488 | 1245 | 1.19518072289157 | 0.34966742588881 | 0.348220479934189 | false | false | false | |||||||||||||||||
| 8605bd60-849e-4bcb-bcac-11000e9a19ba | 2026-08-20 09:54 | 2026-08-20 09:54 | 2026-08-20 09:54 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 1.0600 | 0.9500 | 1.3500 | 39.8250 | 21135.00 | 0.00 | 21135.00 | 200 | 6 | 200 | 5706 | 0.0350508236943568 | 0.350088147155426 | 0.350088147155426 | false | false | false | |||||||||||||||||
| a3c6a662-37ab-48a0-96bc-a846f929f82d | 2026-08-20 09:55 | 2026-08-20 09:55 | 2026-08-20 09:55 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 1.0300 | 1.0000 | 1.3500 | 39.8800 | 341377.00 | 0.00 | 341377.00 | 3313 | 8 | 3813 | 5706 | 0.668243953732913 | 0.35119782722068 | 0.35119782722068 | false | false | false | |||||||||||||||||
| b6a49111-6d70-4dcd-8dcd-cf33f8a9f17a | 2026-08-21 09:53 | 2026-08-21 09:53 | 2026-08-21 09:53 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 1.0500 | 0.9500 | 1.2500 | 39.5750 | 113155.00 | 4900.00 | 106055.00 | 1076 | 43 | 1577 | 9544 | 0.165234702430847 | 0.340912909868278 | 0.331662491168138 | false | false | false | |||||||||||||||||
| d07b7a7d-1100-454e-8511-f010bba8bc26 | 2026-09-04 14:43 | 2026-09-04 14:42 | 2026-09-04 14:42 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 1.4500 | 1.3500 | 1.4500 | 38.4400 | 13775.00 | 13775.00 | 0.00 | 95 | 11 | 194 | 14377 | 0.0134937747791612 | 0.381482174946451 | 0.381482174946451 | false | false | false | |||||||||||||||||
| bfccdad0-ca58-4490-981a-791786f6ed1a | 2026-09-08 14:08 | 2026-09-08 14:07 | 2026-09-08 14:07 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 2.1500 | 2.0500 | 2.2000 | 37.0100 | 41495.00 | 41065.00 | 215.00 | 193 | 41 | 330 | 14459 | 0.0228231551282938 | 0.413276665396852 | 0.413276665396852 | false | false | false | |||||||||||||||||
| d83f1591-4488-4e7a-a01a-7cb10628f3d7 | 2026-09-09 10:31 | 2026-09-09 10:31 | 2026-09-09 10:31 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 1.8500 | 1.8000 | 1.9000 | 37.0000 | 36253.00 | 36068.00 | 0.00 | 196 | 41 | 202 | 14521 | 0.0139108876799119 | 0.409707873106686 | 0.409707873106686 | false | false | false | |||||||||||||||||
| 522e7bd0-8ed7-401b-86b6-2ef2bfe90f11 | 2026-09-18 12:44 | 2026-09-18 12:44 | 2026-09-18 12:44 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 2.0000 | 1.9500 | 2.0500 | 36.8800 | 48800.00 | 45200.00 | 0.00 | 244 | 22 | 13669 | 14669 | 0.931829027200218 | 0.423179492167592 | 0.423179492167592 | false | false | false | |||||||||||||||||
| 93746721-2644-4d45-b48c-6ce28d5e1f74 | 2026-09-18 14:26 | 2026-09-18 14:26 | 2026-09-18 14:26 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 2.1000 | 2.0000 | 2.1000 | 36.7650 | 45764.00 | 45764.00 | 0.00 | 218 | 34 | 13985 | 14669 | 0.953371054604949 | 0.432873197318137 | 0.432873197318137 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 19464345202.00 |
| 2026-09-23 |
| premarket |
| — |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 19464345202.00 |
| 2026-09-23 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 19464345202.00 |
| 2026-09-23 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 19464345202.00 |
| 2026-09-23 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 19464345202.00 |
| 2026-09-23 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:05:15.166096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 19464345202.00 |
| 2026-09-23 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:15:47.972880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 19464345202.00 |
| 2026-09-23 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 19384288943.00 |
| 2026-09-23 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:45:45.480252Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 19384288943.00 |
| 2026-09-23 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |