Simplify AnalyticsOptions flow alerts (market-wide)
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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c481716c-3c24-4fc6-b93a-8a838f1fb7e0 | 2026-09-21 15:58 | 2026-09-21 15:58 | 2026-09-21 15:58 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 16.0000 | 15.9000 | 16.0000 | 743.1250 | 24000.00 | 24000.00 | 0.00 | 15 | 11 | 1001 | 0 | 0 | 0.609066775780266 | 0.609066775780266 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 21775f1f-b499-4bef-9e2e-8c274ae77765 | 2026-09-21 15:54 | 2026-09-21 15:54 | 2026-09-21 15:54 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 14.0000 | 14.0000 | 14.1500 | 747.0000 | 12600.00 | 0.00 | 12600.00 | 9 | 9 | 942 | 0 | 0 | 0.606691215948723 | 0.606691215948723 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| d29d5fe7-a2fd-4270-8268-1934add95cd6 | 2026-09-21 15:41 | 2026-09-21 15:41 | 2026-09-21 15:41 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 13.6000 | 13.4500 | 13.6000 | 749.1200 | 23120.00 | 23120.00 | 0.00 | 17 | 8 | 885 | 0 | 0 | 0.612679792233893 | 0.611516933161516 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:43:03.886437Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 6fe45b3b-d0dd-4079-bcfa-8ef42101fd85 | 2026-09-21 15:40 | 2026-09-21 15:40 | 2026-09-21 15:40 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 13.8000 | 13.6500 | 13.8000 | 748.3900 | 17940.00 | 17940.00 | 0.00 | 13 | 7 | 811 | 0 | 0 | 0.608671201715271 | 0.608671201715271 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:43:03.886437Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| a3ebf788-97b3-4ea5-a90e-54249a5236ee | 2026-09-21 15:38 | 2026-09-21 15:38 | 2026-09-21 15:38 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 13.3500 | 13.2000 | 13.4500 | 749.4450 | 29370.00 | 29370.00 | 0.00 | 22 | 12 | 794 | 0 | 0 | 0.607379979962164 | 0.607379979962164 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 587a7d6f-651f-4a08-bc1b-5fe8358cbfdd | 2026-09-21 15:35 | 2026-09-21 15:35 | 2026-09-21 15:35 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 12.5000 | 12.5000 | 12.8500 | 752.5199 | 22500.00 | 0.00 | 22500.00 | 18 | 8 | 771 | 0 | 0 | 0.615103771161923 | 0.617453829521062 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:36:57.124687Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 352a7185-a3eb-44cc-9dad-48eefe6e392e | 2026-09-21 15:22 | 2026-09-21 15:22 | 2026-09-21 15:22 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 14.6500 | 14.6500 | 14.8500 | 745.1150 | 11720.00 | 0.00 | 11720.00 | 8 | 5 | 723 | 0 | 0 | 0.592792734924524 | 0.592792734924524 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | 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 |
| 2b29b0a8-ad4c-47d6-9661-c6017da37581 | 2026-09-21 15:14 | 2026-09-21 15:14 | 2026-09-21 15:14 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 14.8500 | 14.8500 | 14.9500 | 744.6500 | 17820.00 | 0.00 | 17820.00 | 12 | 5 | 695 | 0 | 0 | 0.592926765440835 | 0.592926765440835 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:15:34.344712Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 408b2135-3863-42d8-ba55-4f61abdf3cff | 2026-09-21 14:55 | 2026-09-21 14:55 | 2026-09-21 14:55 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 15.4500 | 15.3500 | 15.4500 | 744.7400 | 10815.00 | 10815.00 | 0.00 | 7 | 5 | 654 | 0 | 0 | 0.613827697028714 | 0.613827697028714 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:56:46.399450Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 759a85ff-f859-4d16-a02a-101c9e218ac9 | 2026-09-21 14:25 | 2026-09-21 14:25 | 2026-09-21 14:25 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 15.0500 | 14.9000 | 15.0500 | 746.5100 | 39130.00 | 39130.00 | 0.00 | 26 | 9 | 588 | 0 | 0 | 0.624957665610824 | 0.624957665610824 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:28:37.842583Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| ae91dce9-63c8-4bd6-b4f2-fd315a71b93a | 2026-09-21 14:21 | 2026-09-21 14:21 | 2026-09-21 14:21 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 15.7000 | 15.2000 | 15.7000 | 744.2600 | 28260.00 | 28260.00 | 0.00 | 18 | 7 | 550 | 0 | 0 | 0.615312259436406 | 0.615312259436406 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:23:56.707397Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| dd070710-c40d-4224-a2fb-7e6020af9946 | 2026-09-21 13:57 | 2026-09-21 13:56 | 2026-09-21 13:56 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 16.6500 | 16.5000 | 16.6500 | 741.8800 | 11655.00 | 11655.00 | 0.00 | 7 | 7 | 490 | 0 | 0 | 0.612294016894222 | 0.612294016894222 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | 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 |
| 0dc7f476-9e4a-40fd-94cc-c459a1f52613 | 2026-09-21 13:48 | 2026-09-21 13:47 | 2026-09-21 13:47 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 16.7000 | 16.4500 | 16.7000 | 742.1700 | 105210.00 | 105210.00 | 0.00 | 63 | 20 | 475 | 0 | 0 | 0.619952574622421 | 0.618140198943863 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:50:05.863152Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 38b85d06-0690-4c73-b9b2-c27e77c780eb | 2026-09-21 13:36 | 2026-09-21 13:36 | 2026-09-21 13:36 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 17.8000 | 17.7000 | 17.8000 | 738.0000 | 32038.00 | 32038.00 | 0.00 | 18 | 9 | 347 | 0 | 0 | 0.597774309761399 | 0.597774309761399 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:39:31.841992Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 4946457c-1f55-4d2e-a68f-738a69436ea6 | 2026-09-21 13:36 | 2026-09-21 13:36 | 2026-09-21 13:36 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 17.9000 | 17.7500 | 17.9000 | 738.0000 | 10740.00 | 10740.00 | 0.00 | 6 | 6 | 329 | 0 | 0 | 0.598152754407576 | 0.598152754407576 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:39:31.841992Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 187d586b-cc27-4547-b917-e0e1e37f2697 | 2026-09-21 13:31 | 2026-09-21 13:31 | 2026-09-21 13:31 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 18.0000 | 18.0000 | 18.2500 | 737.5650 | 21600.00 | 0.00 | 21600.00 | 12 | 6 | 289 | 0 | 0 | 0.592968668660016 | 0.590847241426077 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:34:20.106500Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| f16ea886-48d7-49b8-ae30-255c216f1132 | 2026-09-21 13:18 | 2026-09-21 13:18 | 2026-09-21 13:18 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 19.4000 | 19.4000 | 19.6000 | 733.0000 | 27160.00 | 0.00 | 27160.00 | 14 | 7 | 167 | 0 | 0 | 0.573041360233394 | 0.573041360233394 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:20:55.206028Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 64d96c3a-746c-4c77-a1c0-a2592a759a23 | 2026-09-21 13:08 | 2026-09-21 13:08 | 2026-09-21 13:08 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 20.0000 | 20.0000 | 20.1500 | 733.4300 | 18000.00 | 0.00 | 18000.00 | 9 | 9 | 126 | 0 | 0 | 0.588316092564252 | 0.588316092564252 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:12:05.796133Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| e7e26962-921b-45c1-b95a-47ed83af2983 | 2026-09-21 11:39 | 2026-09-21 11:39 | 2026-09-21 11:39 | META | META260925P00737500 | put | 737.5000 | 2026-09-25 | 28.7000 | 28.7000 | 28.9500 | 716.3300 | 40180.00 | 0.00 | 40180.00 | 14 | 6 | 48 | 0 | 0 | 0.533317439649628 | 0.533317439649628 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:43:39.846801Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |