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_alerts609,118 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 |
|---|
| 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 |
|---|
| e9b7e660-9fde-4c21-9381-dc8ca76456cd | 2026-09-23 15:50 | 2026-09-23 15:50 | 2026-09-23 15:50 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 5.5300 | 5.4700 | 5.6000 | 767.4200 | 12719.00 | 11060.00 | 1659.00 | 23 | 7 | 6067 | 8620 | 0.703828306264501 | 0.10524805930752 | 0.105112213498803 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 806184418262.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T19:51:14.662813Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| c6c8688e-9feb-43b9-95e4-bcf9dae010c6 | 2026-09-23 15:42 | 2026-09-23 15:42 | 2026-09-23 15:42 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 5.3400 | 5.3400 | 5.3900 | 767.6800 | 11748.00 | 0.00 | 11748.00 | 22 | 5 | 5902 | 8620 | 0.684686774941995 | 0.104074207866491 | 0.104074207866491 | false | false | false | true | false | |||||||||||||||
| 42e00e0d-4d05-4d7b-8650-171742d79382 | 2026-09-23 13:06 | 2026-09-23 13:06 | 2026-09-23 13:06 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 5.9800 | 5.9400 | 6.0000 | 766.7500 | 18540.00 | 18540.00 | 0.00 | 31 | 7 | 5009 | 8620 | 0.581090487238979 | 0.107673902916958 | 0.107090675714587 | false | false | false | true | false | |||||||||||||||
| 9a4243aa-c7d4-4c8c-9a9e-fe555bb6e0d0 | 2026-09-23 10:24 | 2026-09-23 10:24 | 2026-09-23 10:24 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 4.8700 | 4.8600 | 4.8800 | 768.7300 | 30194.00 | 2435.00 | 27759.00 | 62 | 5 | 2816 | 8620 | 0.326682134570766 | 0.106375540542574 | 0.106375540542574 | false | false | false | true | false | |||||||||||||||
| 12b072a9-44e5-4eac-a765-c89937d1ade6 | 2026-09-23 10:01 | 2026-09-23 10:01 | 2026-09-23 10:01 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 3.6000 | 3.6000 | 3.6300 | 770.0000 | 72000.00 | 0.00 | 72000.00 | 200 | 10 | 1497 | 8620 | 0.173665893271462 | 0.101112723551716 | 0.101112723551716 | false | false | false | true | false | |||||||||||||||
| 1551338d-6728-40ae-8b01-76dd24e92743 | 2026-09-22 11:38 | 2026-09-22 11:37 | 2026-09-22 11:37 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 3.0100 | 3.0000 | 3.0100 | 772.8550 | 46655.00 | 46655.00 | 0.00 | 155 | 8 | 1548 | 7950 | 0.194716981132075 | 0.100049631716091 | 0.100049631716091 | false | false | false | true | false | |||||||||||||||
| 45c8de9c-0c07-465a-a93a-31376faf8780 | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 2.7400 | 2.7400 | 2.7600 | 775.0450 | 13710.00 | 0.00 | 13710.00 | 50 | 6 | 227 | 7950 | 0.0285534591194969 | 0.111961027579327 | 0.111718733717438 | false | false | false | true | false | |||||||||||||||
| 088c079a-2573-473d-aba5-f523ae6837d0 | 2026-09-21 15:52 | 2026-09-21 15:52 | 2026-09-21 15:52 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 3.2800 | 3.2700 | 3.2800 | 773.9200 | 27880.00 | 27880.00 | 0.00 | 85 | 7 | 4512 | 5923 | 0.761776126962688 | 0.109477814698242 | 0.109477814698242 | false | false | false | true | false | |||||||||||||||
| 278b6f94-fae4-40aa-9104-ccd155af0966 | 2026-09-21 15:24 | 2026-09-21 15:24 | 2026-09-21 15:24 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 3.2700 | 3.2700 | 3.2800 | 774.2100 | 23544.00 | 0.00 | 4251.00 | 72 | 6 | 3774 | 5923 | 0.637177106196184 | 0.111537361334748 | 0.111537361334748 | false | false | false | true | false | |||||||||||||||
| 89fae4b9-f06a-4c44-a5ef-1f54682166c7 | 2026-09-21 14:59 | 2026-09-21 14:59 | 2026-09-21 14:59 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 3.2500 | 3.2500 | 3.2700 | 774.2200 | 28600.00 | 0.00 | 28600.00 | 88 | 6 | 3565 | 5923 | 0.601890933648489 | 0.111172801756152 | 0.111172801756152 | false | false | false | true | false | |||||||||||||||
| 649f9e94-9dd2-49af-bb92-e36c9addbbeb | 2026-09-21 14:36 | 2026-09-21 14:36 | 2026-09-21 14:36 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 3.4000 | 3.3900 | 3.4100 | 773.7950 | 10200.00 | 8160.00 | 0.00 | 30 | 5 | 3251 | 5923 | 0.54887725814621 | 0.111119921709589 | 0.111119921709589 | false | false | false | true | false | |||||||||||||||
| d4ac9b5f-bfa5-4df7-ba35-51c67dd19820 | 2026-09-21 14:00 | 2026-09-21 14:00 | 2026-09-21 14:00 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 3.7500 | 3.7300 | 3.7500 | 772.9200 | 18750.00 | 18750.00 | 0.00 | 50 | 6 | 2961 | 5923 | 0.499915583319264 | 0.111557685658257 | 0.111557685658257 | false | false | false | true | false | |||||||||||||||
| 2fae1eac-c67a-40f6-97a1-d4aac53b791e | 2026-09-17 11:02 | 2026-09-17 11:01 | 2026-09-17 11:01 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 12.5500 | 12.3800 | 12.6700 | 760.7700 | 111695.00 | 72790.00 | 38905.00 | 89 | 12 | 179 | 5930 | 0.030185497470489 | 0.135655673914299 | 0.135655673914299 | true | false | false | true | false | |||||||||||||||
| 2de94fb4-91de-4182-ab40-ea6945cb002d | 2026-09-03 15:54 | 2026-09-03 15:54 | 2026-09-03 15:54 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 8.2100 | 8.1800 | 8.2100 | 773.2100 | 196219.00 | 196219.00 | 0.00 | 239 | 14 | 4334 | 3363 | 1.28873030032709 | 0.12785705151662 | 0.12785705151662 | false | false | false | true | false | |||||||||||||||
| e1500549-1fcb-4b6a-a664-e5829cd6d19a | 2026-09-03 12:25 | 2026-09-03 12:25 | 2026-09-03 12:25 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 8.7400 | 8.7200 | 8.7400 | 772.3300 | 218500.00 | 218500.00 | 0.00 | 250 | 10 | 2874 | 3363 | 0.854594112399643 | 0.129804924807852 | 0.129804924807852 | false | false | false | true | false | |||||||||||||||
| 9a7c52d3-497a-49ab-9d91-365511daae2a | 2026-09-03 12:00 | 2026-09-03 12:00 | 2026-09-03 12:00 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 8.4400 | 8.4300 | 8.4400 | 773.2511 | 190729.00 | 178084.00 | 12645.00 | 226 | 7 | 2577 | 3363 | 0.766280107047279 | 0.130642786677457 | 0.130871515211389 | false | false | false | true | false | |||||||||||||||
| 60ff4ab8-8778-4061-9300-9591304c66b5 | 2026-09-03 11:29 | 2026-09-03 11:29 | 2026-09-03 11:29 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 8.7900 | 8.7900 | 8.8100 | 772.9000 | 123939.00 | 0.00 | 123939.00 | 141 | 15 | 1959 | 3363 | 0.582515611061552 | 0.133348629975277 | 0.133348629975277 | false | false | false | true | false | |||||||||||||||
| 40488a2c-c899-4998-b016-5188a40141bf | 2026-09-03 11:14 | 2026-09-03 11:14 | 2026-09-03 11:14 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 9.3000 | 9.2700 | 9.3000 | 771.3100 | 138570.00 | 138570.00 | 0.00 | 149 | 9 | 976 | 3363 | 0.290217068093964 | 0.131214700649687 | 0.131214700649687 | false | false | false | true | false | |||||||||||||||
| 3aa2b60e-1f63-4538-a383-18999c1fcbe3 | 2026-09-03 11:13 | 2026-09-03 11:13 | 2026-09-03 11:13 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 9.2700 | 9.2400 | 9.2700 | 771.3900 | 150174.00 | 150174.00 | 0.00 | 162 | 5 | 668 | 3363 | 0.198632173654475 | 0.131279284093504 | 0.131279284093504 | false | false | false | true | false | |||||||||||||||
| a3fe913d-603f-42cf-a54a-9ff65deb1b79 | 2026-08-28 11:26 | 2026-08-28 11:26 | 2026-08-28 11:26 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 8.5000 | 8.4900 | 8.5200 | 775.1101 | 113900.00 | 110500.00 | 3400.00 | 134 | 6 | 2545 | 1347 | 1.88938381588716 | 0.129519382565176 | 0.129519382565176 | true | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:42:45.926021Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:11:20.356460Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:02:33.967509Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:38:41.762966Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:52:57.186278Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:25:50.208697Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:00:53.952817Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:37:54.025147Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:00:14.697100Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 783069852881.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:02:25.509626Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:03:37.205690Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |