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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0b869a39-f94a-4e01-8154-595fccbe3ab8 | 2026-08-14 15:58 | 2026-08-14 15:58 | 2026-08-14 15:58 | BBWI | BBWI270617C00022500 | call | 22.5000 | 2027-06-17 | 2.6000 | 2.4500 | 2.8500 | 19.3450 | 69905.00 | 3605.00 | 66300.00 | 269 | 23 | 500 | 18 | 27.7777777777778 | 0.487420795920477 | 0.494489743459451 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 3611467556.00 | 2026-11-19 | 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 |
| 0fdff218-bab7-487b-a1f3-f1ef6a271c96 | 2026-08-17 10:00 | 2026-08-17 10:00 | 2026-08-17 10:00 | BBWI | BBWI260828C00020000 | call | 20.0000 | 2026-08-28 | 0.5400 | 0.4500 | 0.5500 | 18.4350 | 27189.00 | 27189.00 | 0.00 | 500 | 9 | 502 | 165 | 3.04242424242424 | 0.866132664832172 | 0.866132664832172 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 3611467556.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 15dc2efa-d0a0-4f14-9c84-18e0145a3ca4 | 2026-08-18 09:33 | 2026-08-18 09:33 | 2026-08-18 09:33 | BBWI | BBWI260821C00020000 | call | 20.0000 | 2026-08-21 | 0.4000 | 0.2500 | 0.4000 | 19.7200 | 29990.00 | 29990.00 | 0.00 | 750 | 6 | 751 | 883 | 0.850509626274066 | 0.717719557169568 | 0.731961497093907 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 3611467556.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3d236932-fb45-4f26-86f3-f88d183cf829 | 2026-08-25 11:29 | 2026-08-25 11:29 | 2026-08-25 11:29 | BBWI | BBWI260828P00017000 | put | 17.0000 | 2026-08-28 | 0.5000 | 0.3500 | 0.5000 | 18.5750 | 43223.00 | 42755.00 | 468.00 | 870 | 6 | 981 | 403 | 2.43424317617866 | 1.55264919110989 | 1.73911025025286 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 3611467556.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 757650f6-b417-4c54-82f3-d90d33fdafe8 | 2026-08-25 13:37 | 2026-08-25 13:37 | 2026-08-25 13:37 | BBWI | BBWI260828C00019000 | call | 19.0000 | 2026-08-28 | 0.7900 | 0.6500 | 0.8000 | 18.0350 | 39410.00 | 39410.00 | 0.00 | 500 | 7 | 1211 | 843 | 1.43653618030842 | 1.79291075996388 | 1.79291075996388 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 3611467556.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 43c85b09-5e1e-44a7-8517-d6e85e211fd3 | 2026-08-28 10:18 | 2026-08-28 10:18 | 2026-08-28 10:18 | BBWI | BBWI260828C00019000 | call | 19.0000 | 2026-08-28 | 0.8500 | 0.8000 | 0.9500 | 19.8700 | 31825.00 | 2465.00 | 27660.00 | 374 | 44 | 520 | 2047 | 0.254030288226673 | 0 | 1.06524563848503 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 3611467556.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3342a111-8894-462f-9626-010e6d2336de | 2026-09-04 14:01 | 2026-09-04 14:00 | 2026-09-04 14:00 | BBWI | BBWI270917P00020000 | put | 20.0000 | 2027-09-17 | 4.2100 | 4.2000 | 4.4000 | 19.9050 | 13050.00 | 0.00 | 13050.00 | 31 | 6 | 31 | 123 | 0.252032520325203 | 0.575498646794793 | 0.575498646794793 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 3611467556.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T18:01:17.201510Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 99509dca-25a8-4f47-a81d-252d26dbbbc3 | 2026-09-04 15:02 | 2026-09-04 15:02 | 2026-09-04 15:02 | BBWI | BBWI261120C00020000 | call | 20.0000 | 2026-11-20 | 1.8000 | 1.7000 | 1.9500 | 19.6300 | 18016.00 | 2880.00 | 15136.00 | 100 | 6 | 112 | 344 | 0.325581395348837 | 0.527391770215641 | 0.530919904561178 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 3611467556.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T19:05:15.166096Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c5fa535a-bd88-44f0-9d32-dcd2cf957de6 | 2026-09-11 10:47 | 2026-09-11 10:47 | 2026-09-11 10:47 | BBWI | BBWI260925C00018000 | call | 18.0000 | 2026-09-25 | 0.8700 | 0.7000 | 0.9000 | 18.1950 | 86465.00 | 86465.00 | 0.00 | 995 | 5 | 1000 | 34 | 29.4117647058824 | 0.526779458940534 | 0.526779458940534 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 3611467556.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7fba2210-6f33-42d1-aff3-c0a44a362f2a | 2026-09-15 13:46 | 2026-09-15 13:46 | 2026-09-15 13:46 | BBWI | BBWI261016P00015000 | put | 15.0000 | 2026-10-16 | 0.3500 | 0.3000 | 0.4000 | 16.7142 | 14075.00 | 0.00 | 14075.00 | 403 | 21 | 433 | 681 | 0.63582966226138 | 0.525864832563513 | 0.540620811818177 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 3611467556.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |