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 |
|---|
| 4d895a5d-beea-42cd-9556-e1c407e6fbf5 | 2026-09-21 11:35 | 2026-09-21 11:35 | 2026-09-21 11:35 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 1.1000 | 1.0500 | 1.1500 | 7705.0000 | 11000.00 | 8250.00 | 0.00 | 100 | 9 | 2976 | 2310 | 1.28831168831169 | 0.181910680773501 | 0.181910680773501 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:36:47.844885Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 06bd5a41-7cfa-4cc1-a176-d3c7c005fc22 | 2026-09-21 10:44 | 2026-09-21 10:43 | 2026-09-21 10:43 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 1.2000 | 1.1500 | 1.2000 | 7700.0000 | 12000.00 | 12000.00 | 0.00 | 100 | 6 | 2474 | 2310 | 1.07099567099567 | 0.174402081660961 | 0.174402081660961 | false | false | false | true | ||||||||||||||||
| 1b68e579-b747-4c71-8b9e-45872b9cb031 | 2026-09-21 10:23 | 2026-09-21 10:23 | 2026-09-21 10:23 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 1.1500 | 1.1000 | 1.2000 | 7700.0000 | 34500.00 | 26910.00 | 7590.00 | 300 | 13 | 1971 | 2310 | 0.853246753246753 | 0.17330979386964 | 0.17330979386964 | false | false | false | true | ||||||||||||||||
| a31fa973-0f31-4ae8-b3fd-fdd902056f6e | 2026-09-21 10:02 | 2026-09-21 10:01 | 2026-09-21 10:01 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 1.6500 | 1.5500 | 1.7000 | 7707.0900 | 49500.00 | 30360.00 | 19140.00 | 300 | 18 | 1268 | 2310 | 0.548917748917749 | 0.170206170831991 | 0.170206170831991 | false | false | false | true | ||||||||||||||||
| c294f024-1d94-4722-ba23-23c3d52812f0 | 2026-09-18 16:13 | 2026-09-18 16:13 | 2026-09-18 16:13 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 9.3000 | 9.2000 | 9.5000 | 7630.0000 | 465000.00 | 426870.00 | 38130.00 | 500 | 13 | 4455 | 1083 | 4.11357340720222 | 0.0894347878847731 | 0.0894347878847731 | false | false | false | true | ||||||||||||||||
| 071ed6db-ef9a-49df-84fb-63f57aa3dac6 | 2026-09-18 15:47 | 2026-09-18 15:47 | 2026-09-18 15:47 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 11.7000 | 11.6000 | 11.9000 | 7645.3900 | 153270.00 | 85410.00 | 67860.00 | 131 | 16 | 3712 | 1083 | 3.4275161588181 | 0.0941367040399471 | 0.0941367040399471 | false | false | false | true | ||||||||||||||||
| 0221ebce-aed5-4e53-8e55-cf1de122a24f | 2026-09-18 15:47 | 2026-09-18 15:47 | 2026-09-18 15:47 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 11.8000 | 11.7000 | 12.0000 | 7644.5500 | 106200.00 | 31860.00 | 74340.00 | 90 | 12 | 3579 | 1083 | 3.30470914127424 | 0.0936850862505849 | 0.0936850862505849 | false | false | false | true | ||||||||||||||||
| 33a7cdeb-471a-4813-a4b4-cd0ce2967469 | 2026-09-18 15:46 | 2026-09-18 15:46 | 2026-09-18 15:46 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 12.1000 | 12.0000 | 12.3000 | 7643.8200 | 114950.00 | 81070.00 | 33880.00 | 95 | 10 | 3372 | 1083 | 3.11357340720222 | 0.0941044315181986 | 0.0941044315181986 | false | false | false | true | ||||||||||||||||
| 125b431f-ef55-454a-a0d7-58d6ce15423b | 2026-09-18 14:43 | 2026-09-18 14:43 | 2026-09-18 14:43 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 14.8000 | 14.7000 | 15.1000 | 7634.2100 | 370000.00 | 251600.00 | 118400.00 | 250 | 16 | 3008 | 1083 | 2.77746999076639 | 0.0939708165152941 | 0.0939708165152941 | false | false | false | true | ||||||||||||||||
| 10f69b4f-41bb-4b38-b7cb-9f124955d088 | 2026-09-18 14:29 | 2026-09-18 14:29 | 2026-09-18 14:29 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 15.0000 | 14.9000 | 15.2000 | 7634.3900 | 375000.00 | 303000.00 | 72000.00 | 250 | 17 | 2477 | 1083 | 2.28716528162512 | 0.09488004857328 | 0.09488004857328 | false | false | false | true | ||||||||||||||||
| 2c080c74-e7a4-4c31-aac0-d9383f68310f | 2026-09-18 14:23 | 2026-09-18 14:23 | 2026-09-18 14:23 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 15.4000 | 15.2000 | 15.5000 | 7634.9000 | 154000.00 | 137060.00 | 16940.00 | 100 | 10 | 1761 | 1083 | 1.62603878116343 | 0.0968613760365217 | 0.0968613760365217 | false | false | false | true | ||||||||||||||||
| d4ce755a-55ec-453d-a928-a72a30921815 | 2026-09-18 14:22 | 2026-09-18 14:22 | 2026-09-18 14:22 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 15.2000 | 15.1000 | 15.4000 | 7634.1300 | 228000.00 | 193040.00 | 34960.00 | 150 | 9 | 1539 | 1083 | 1.42105263157895 | 0.0953060271117061 | 0.0953060271117061 | false | false | false | true | ||||||||||||||||
| 11ea0847-43c8-4101-a278-62a2cf8f5552 | 2026-09-18 13:34 | 2026-09-18 13:34 | 2026-09-18 13:34 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 18.7100 | 18.6000 | 19.0000 | 7623.9800 | 280670.00 | 160820.00 | 119850.00 | 150 | 16 | 646 | 1083 | 0.596491228070175 | 0.0960327463182903 | 0.095697375799718 | false | false | false | true | ||||||||||||||||
| cb6d790b-4033-4984-803e-4fe003881eef | 2026-09-18 13:11 | 2026-09-18 13:11 | 2026-09-18 13:11 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 20.0000 | 19.8000 | 20.1000 | 7622.7800 | 100000.00 | 100000.00 | 0.00 | 50 | 7 | 424 | 1083 | 0.391505078485688 | 0.0985832258347302 | 0.0985832258347302 | false | false | false | true | ||||||||||||||||
| a3b18c15-03f0-465a-a04e-d85d960f5d86 | 2026-09-18 13:11 | 2026-09-18 13:11 | 2026-09-18 13:11 | SPXW | SPXW260922P07600000 | put | 7600.0000 | 2026-09-22 | 20.0000 | 19.8000 | 20.1000 | 7622.9600 | 100000.00 | 98000.00 | 2000.00 | 50 | 9 | 374 | 1083 | 0.34533702677747 | 0.0988033210637772 | 0.0988033210637772 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:45:07.990945Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:24:21.810098Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:02:45.816631Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |