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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| e5419a55-7daf-4799-95f2-0261ce8fc23e | 2026-09-11 11:06 | 2026-09-11 11:06 | 2026-09-11 11:06 | STUB | STUB280121C00010000 | call | 10.0000 | 2028-01-21 | 1.0500 | 0.9000 | 1.1000 | 6.0950 | 23940.00 | 23940.00 | 0.00 | 228 | 5 | 433 | 1604 | 0.269950124688279 | 0.676094307554821 | 0.676094307554821 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:28:46.184785Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7b5ea42c-3852-42c3-8a69-f49626a84712 | 2026-09-10 15:59 | 2026-09-10 15:59 | 2026-09-10 15:59 | STUB | STUB270115C00007500 | call | 7.5000 | 2027-01-15 | 0.4500 | 0.4000 | 0.5000 | 5.9400 | 10800.00 | 10440.00 | 0.00 | 240 | 6 | 291 | 2205 | 0.131972789115646 | 0.654386324000375 | 0.654386324000375 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:30:31.573730Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| eae1daa1-e491-4ab1-9fad-74f9af00e173 | 2026-09-08 09:56 | 2026-09-08 09:56 | 2026-09-08 09:56 | STUB | STUB260911C00006000 | call | 6.0000 | 2026-09-11 | 0.4300 | 0.3000 | 0.5500 | 6.3200 | 215000.00 | 0.00 | 0.00 | 5000 | 7 | 5000 | 5001 | 0.999800039992002 | 1.05470554943367 | 1.05470554943367 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9e576ee5-f9a0-47c7-a706-8beb70aeb565 | 2026-09-08 09:43 | 2026-09-08 09:43 | 2026-09-08 09:43 | STUB | STUB260911C00006500 | call | 6.5000 | 2026-09-11 | 0.1500 | 0.0500 | 0.2000 | 6.3300 | 150000.00 | 150000.00 | 0.00 | 10000 | 1 | 10008 | 10171 | 0.983974043850162 | 0.966131710082115 | 0.966131710082115 | false | true | false | true | false | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T13:49:15.511852Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 49f585b8-8472-442d-b85b-ec86fd834137 | 2026-09-03 10:55 | 2026-09-03 10:54 | 2026-09-03 10:54 | STUB | STUB261218C00007500 | call | 7.5000 | 2026-12-18 | 0.4500 | 0.4500 | 0.6500 | 6.4700 | 11250.00 | 0.00 | 11250.00 | 250 | 9 | 250 | 717 | 0.348675034867504 | 0.564891704546867 | 0.564891704546867 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T14:57:35.447301Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9ab6ca1e-a150-4b01-80a4-95be5908a17e | 2026-09-02 15:58 | 2026-09-02 15:58 | 2026-09-02 15:58 | STUB | STUB260904C00006000 | call | 6.0000 | 2026-09-04 | 0.2000 | 0.1500 | 0.2000 | 6.1650 | 10000.00 | 10000.00 | 0.00 | 500 | 8 | 3061 | 5012 | 0.61073423782921 | 0.526216305735809 | 0.526216305735809 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 95542cc6-6b33-4051-9d21-6832575b3f12 | 2026-09-02 15:49 | 2026-09-02 15:49 | 2026-09-02 15:49 | STUB | STUB260904C00006000 | call | 6.0000 | 2026-09-04 | 0.2000 | 0.1500 | 0.2500 | 6.1750 | 27720.00 | 0.00 | 20880.00 | 1386 | 13 | 2389 | 5012 | 0.476656025538707 | 0.434274932809536 | 0.467676121616209 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 784398bf-276f-46a1-a958-fd0bea0113ad | 2026-08-31 14:14 | 2026-08-31 14:13 | 2026-08-31 14:13 | STUB | STUB260911C00006000 | call | 6.0000 | 2026-09-11 | 0.3400 | 0.3000 | 0.6000 | 6.0000 | 170526.00 | 0.00 | 170526.00 | 5000 | 9 | 5000 | 2 | 2500 | 0.557427770317869 | 0.557427770317869 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T18:25:38.432903Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ff9c5c75-f72d-4996-b112-75ba0188843e | 2026-08-26 10:31 | 2026-08-26 10:30 | 2026-08-26 10:30 | STUB | STUB261120C00007500 | call | 7.5000 | 2026-11-20 | 0.6500 | 0.6000 | 0.6500 | 6.8600 | 11115.00 | 11115.00 | 0.00 | 171 | 6 | 301 | 1909 | 0.157674174960712 | 0.658942582896747 | 0.658942582896747 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e2f54911-1cbb-4b19-8bb2-9e9773b86a13 | 2026-08-25 14:35 | 2026-08-25 14:34 | 2026-08-25 14:34 | STUB | STUB260828C00006500 | call | 6.5000 | 2026-08-28 | 0.3000 | 0.2500 | 0.3500 | 6.7600 | 28050.00 | 4350.00 | 23700.00 | 935 | 7 | 5119 | 214 | 23.9205607476636 | 0.559598579147047 | 0.537058269794788 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T18:54:14.733334Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0a0642e5-1c34-46f8-bdf9-c45b37d05c0a | 2026-08-25 14:34 | 2026-08-25 14:34 | 2026-08-25 14:34 | STUB | STUB260828C00006500 | call | 6.5000 | 2026-08-28 | 0.3000 | 0.2500 | 0.3500 | 6.7500 | 56730.00 | 16770.00 | 36570.00 | 1891 | 25 | 4178 | 214 | 19.5233644859813 | 0.621285256829598 | 0.581037835864979 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T18:54:14.733334Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e06927d6-71db-4484-aef3-0b981fd21730 | 2026-08-24 11:39 | 2026-08-24 11:38 | 2026-08-24 11:38 | STUB | STUB260904C00006500 | call | 6.5000 | 2026-09-04 | 0.4500 | 0.4500 | 0.4500 | 6.7750 | 17595.00 | 0.00 | 0.00 | 391 | 7 | 1320 | 5379 | 0.245398773006135 | 0.624947413781015 | 0.624947413781015 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T15:49:37.820281Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8a6a4bb2-3a69-4b45-ad70-ac412e2a87f7 | 2026-08-24 11:08 | 2026-08-24 11:08 | 2026-08-24 11:08 | STUB | STUB260904C00006500 | call | 6.5000 | 2026-09-04 | 0.4500 | 0.4000 | 0.5500 | 6.7750 | 26550.00 | 0.00 | 23040.00 | 590 | 13 | 590 | 5379 | 0.109685815207288 | 0.624947413781015 | 0.624947413781015 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T15:09:19.758040Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3b5d7c04-9988-45c2-8b11-d3c0f7006c15 | 2026-08-17 11:41 | 2026-08-17 11:41 | 2026-08-17 11:41 | STUB | STUB260828C00007000 | call | 7.0000 | 2026-08-28 | 0.4500 | 0.4500 | 0.5500 | 7.2400 | 67584.00 | 0.00 | 67584.00 | 1500 | 5 | 2050 | 339 | 6.04719764011799 | 0.651495324618919 | 0.651495324618919 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 878a8db4-5b76-433c-b9e3-2175f9e3e41d | 2026-08-17 11:41 | 2026-08-17 11:40 | 2026-08-17 11:40 | STUB | STUB260828C00007000 | call | 7.0000 | 2026-08-28 | 0.4500 | 0.3500 | 0.4500 | 7.2500 | 10890.00 | 3150.00 | 0.00 | 242 | 28 | 542 | 339 | 1.59882005899705 | 0.616229588591018 | 0.616229588591018 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9cdf00b5-ad22-4a3a-ab39-a0336bd64e5b | 2026-08-14 15:57 | 2026-08-14 15:57 | 2026-08-14 15:57 | STUB | STUB260814P00009000 | put | 9.0000 | 2026-08-14 | 1.0000 | 0.9500 | 1.0500 | 8.0050 | 10000.00 | 0.00 | 8000.00 | 100 | 5 | 246 | 975 | 0.252307692307692 | 25.3370916622147 | 25.3370916622147 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2135685663.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |