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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 58ebce9e-b242-4236-b6ed-b0046ccd9cd1 | 2026-08-17 12:56 | 2026-08-17 12:55 | 2026-08-17 12:55 | FRPT | FRPT260918C00075000 | call | 75.0000 | 2026-09-18 | 3.1000 | 3.1000 | 3.4000 | 72.6100 | 64791.00 | 0.00 | 64791.00 | 209 | 34 | 221 | 157 | 1.40764331210191 | 0.469306403038659 | 0.469306403038659 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 3064663379.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 134483dc-87e6-4c6b-8fad-33a372732904 | 2026-08-18 13:51 | 2026-08-18 13:51 | 2026-08-18 13:51 | FRPT | FRPT261120P00072500 | put | 72.5000 | 2026-11-20 | 7.6000 | 7.6000 | 7.9000 | 72.7200 | 53200.00 | 0.00 | 53200.00 | 70 | 18 | 88 | 3 | 29.3333333333333 | 0.553026432387835 | 0.553026432387835 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 3064663379.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fc19ddba-2c67-40fb-aae6-7134a8ac8d5e | 2026-08-19 12:07 | 2026-08-19 12:07 | 2026-08-19 12:07 | FRPT | FRPT260821C00075000 | call | 75.0000 | 2026-08-21 | 1.2500 | 1.2500 | 1.4000 | 75.0000 | 19260.00 | 0.00 | 19260.00 | 154 | 28 | 249 | 551 | 0.451905626134301 | 0.560962950035379 | 0.560962950035379 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 3064663379.00 | 2026-11-02 | unknown | — | 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 |
| dda07c03-cda3-4dbe-b5a5-9145343ac938 | 2026-08-20 11:51 | 2026-08-20 11:51 | 2026-08-20 11:51 | FRPT | FRPT261016P00072500 | put | 72.5000 | 2026-10-16 | 4.3000 | 4.3000 | 4.8000 | 75.0500 | 18923.00 | 0.00 | 18923.00 | 44 | 9 | 44 | 0 | 0 | 0.489386091347861 | 0.489386091347861 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 3064663379.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c57c5b3c-98b0-46ab-91a1-cd4f7e1383ba | 2026-08-20 12:59 | 2026-08-20 12:58 | 2026-08-20 12:58 | FRPT | FRPT261016P00072500 | put | 72.5000 | 2026-10-16 | 4.2000 | 4.2000 | 4.7000 | 74.8800 | 15540.00 | 0.00 | 15540.00 | 37 | 8 | 82 | 0 | 0 | 0.47478881108944 | 0.47478881108944 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 3064663379.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 74d275b7-5e15-49fd-85e4-1ff2b38ae9e9 | 2026-08-21 11:16 | 2026-08-21 11:16 | 2026-08-21 11:16 | FRPT | FRPT270115P00082500 | put | 82.5000 | 2027-01-15 | 14.3000 | 13.3000 | 15.8000 | 73.6700 | 30030.00 | 8580.00 | 21450.00 | 21 | 7 | 21 | 5 | 4.2 | 0.517407913123061 | 0.517407913123061 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 3064663379.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 89a72e86-63fe-4869-a7ae-6e6b6b240c28 | 2026-08-21 14:56 | 2026-08-21 14:56 | 2026-08-21 14:56 | FRPT | FRPT260918C00072500 | call | 72.5000 | 2026-09-18 | 4.7000 | 4.2000 | 4.8000 | 73.6900 | 86010.00 | 3290.00 | 470.00 | 183 | 31 | 183 | 309 | 0.592233009708738 | 0.491419189989149 | 0.491419189989149 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 3064663379.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3272ccd1-5038-4292-80e2-8522a1053d71 | 2026-08-21 14:56 | 2026-08-21 14:56 | 2026-08-21 14:56 | FRPT | FRPT260918P00072500 | put | 72.5000 | 2026-09-18 | 3.1000 | 3.1000 | 3.4000 | 73.9100 | 32550.00 | 0.00 | 21700.00 | 105 | 19 | 110 | 51 | 2.15686274509804 | 0.477817478869884 | 0.477817478869884 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 3064663379.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| df5dce94-aeaa-4720-9ad9-5e7ed6f17f43 | 2026-08-21 14:56 | 2026-08-21 14:56 | 2026-08-21 14:56 | FRPT | FRPT260918P00072500 | put | 72.5000 | 2026-09-18 | 3.2000 | 3.0750 | 3.3000 | 73.8650 | 24960.00 | 6400.00 | 1920.00 | 78 | 18 | 188 | 51 | 3.68627450980392 | 0.48808122690783 | 0.48808122690783 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 3064663379.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c74f1118-181d-4717-951c-3a72b2f12519 | 2026-08-24 11:06 | 2026-08-24 11:06 | 2026-08-24 11:06 | FRPT | FRPT261218C00085000 | call | 85.0000 | 2026-12-18 | 5.7500 | 5.4000 | 6.9000 | 75.7100 | 360530.00 | 0.00 | 360530.00 | 627 | 2 | 627 | 9 | 69.6666666666667 | 0.523066308372874 | 0.523066308372874 | false | true | false | true | false | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 3064663379.00 | 2026-11-02 | 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 |
| fc19058c-3677-4dd1-8af0-53de8a4ffeab | 2026-08-24 14:20 | 2026-08-24 14:19 | 2026-08-24 14:19 | FRPT | FRPT261016P00077500 | put | 77.5000 | 2026-10-16 | 6.0000 | 6.0000 | 6.1000 | 76.1600 | 22201.00 | 0.00 | 22201.00 | 37 | 16 | 37 | 0 | 0 | 0.475548516482508 | 0.475548516482508 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 3064663379.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T18:49:58.488781Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2144c47c-5b19-48a4-8e97-d23ad2f277ab | 2026-09-03 15:21 | 2026-09-03 15:21 | 2026-09-03 15:21 | FRPT | FRPT261016P00055000 | put | 55.0000 | 2026-10-16 | 0.3900 | 0.1500 | 0.4000 | 69.4500 | 17375.00 | 13000.00 | 4375.00 | 450 | 24 | 1156 | 14 | 82.5714285714286 | 0.501145617031843 | 0.500269421383535 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 3064663379.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c1545d91-6e87-4afd-a6b0-24a89f7c2a0e | 2026-09-03 15:22 | 2026-09-03 15:22 | 2026-09-03 15:22 | FRPT | FRPT261016P00067500 | put | 67.5000 | 2026-10-16 | 3.2900 | 3.2000 | 3.6000 | 69.3000 | 34540.00 | 14960.00 | 18560.00 | 105 | 20 | 237 | 251 | 0.944223107569721 | 0.468570171044406 | 0.468570171044406 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 3064663379.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f9e659fc-0493-4871-a9c0-967ab9ba5a4a | 2026-09-17 10:14 | 2026-09-17 10:14 | 2026-09-17 10:14 | FRPT | FRPT260918P00062500 | put | 62.5000 | 2026-09-18 | 1.0300 | 0.0500 | 2.4000 | 62.9100 | 82400.00 | 0.00 | 82400.00 | 800 | 2 | 800 | 13 | 61.5384615384615 | 0.914205455634129 | 0.914205455634129 | false | true | false | true | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 2958935616.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 12e9c1a4-b6ea-47de-960f-68e8002ff605 | 2026-09-17 10:14 | 2026-09-17 10:14 | 2026-09-17 10:14 | FRPT | FRPT260918P00062500 | put | 62.5000 | 2026-09-18 | 1.0300 | 0.0500 | 2.4000 | 62.9100 | 82400.00 | 0.00 | 82400.00 | 800 | 2 | 800 | 13 | 61.5384615384615 | 0.914205455634129 | 0.914205455634129 | false | true | false | true | true | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 2958935616.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 349ce881-ce7f-4bbf-9ba1-9d8b8e934704 | 2026-09-18 15:44 | 2026-09-18 15:44 | 2026-09-18 15:44 | FRPT | FRPT261016P00055000 | put | 55.0000 | 2026-10-16 | 0.8000 | 0.7500 | 0.8500 | 61.5000 | 11840.00 | 0.00 | 11760.00 | 148 | 17 | 189 | 1027 | 0.184031158714703 | 0.473609928470033 | 0.473609928470033 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 2952688067.00 | 2026-11-02 | unknown | — | 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 |