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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 89c5801b-26be-4bc1-89c7-2faaadf7fc89 | 2026-08-17 14:39 | 2026-08-17 14:39 | 2026-08-17 14:39 | TSN | TSN270115C00067500 | call | 67.5000 | 2027-01-15 | 1.0400 | 1.0000 | 1.4000 | 58.3500 | 14934.00 | 0.00 | 14934.00 | 144 | 5 | 145 | 219 | 0.662100456621005 | 0.240162556964656 | 0.240162556964656 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 14980089672.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1e4b55e4-1ec7-4a70-813f-0737d08184f5 | 2026-08-20 11:28 | 2026-08-20 11:27 | 2026-08-20 11:27 | TSN | TSN280121C00065000 | call | 65.0000 | 2028-01-21 | 5.0000 | 5.0000 | 5.5000 | 58.5900 | 25501.00 | 0.00 | 25501.00 | 51 | 5 | 52 | 32 | 1.625 | 0.219440698049941 | 0.219440698049941 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14980089672.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e3a14160-65ad-4275-a632-230784f55798 | 2026-08-20 15:04 | 2026-08-20 15:04 | 2026-08-20 15:04 | TSN | TSN270115C00060000 | call | 60.0000 | 2027-01-15 | 3.2000 | 3.0000 | 3.4000 | 58.5050 | 10880.00 | 6080.00 | 4800.00 | 34 | 7 | 34 | 765 | 0.0444444444444444 | 0.232289486577455 | 0.232289486577455 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14980089672.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6d706978-2355-4989-bac0-67c5266d4af9 | 2026-08-24 15:17 | 2026-08-24 15:17 | 2026-08-24 15:17 | TSN | TSN260918C00060000 | call | 60.0000 | 2026-09-18 | 0.5500 | 0.4000 | 0.5500 | 58.0000 | 15290.00 | 15290.00 | 0.00 | 278 | 8 | 324 | 1067 | 0.303655107778819 | 0.205463272556843 | 0.205463272556843 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14980089672.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b7849287-c323-4f07-8e04-30199af1d756 | 2026-08-27 09:31 | 2026-08-27 09:31 | 2026-08-27 09:31 | TSN | TSN270917P00055000 | put | 55.0000 | 2027-09-17 | 5.5000 | 5.0000 | 5.6000 | 56.1300 | 29150.00 | 29150.00 | 0.00 | 53 | 7 | 53 | 15 | 3.53333333333333 | 0.32071296341772 | 0.32071296341772 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14980089672.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T13:38:22.111482Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| facea2cc-5944-41ff-b91f-b2e9f70607b7 | 2026-08-27 11:10 | 2026-08-27 11:09 | 2026-08-27 11:09 | TSN | TSN270416C00060000 | call | 60.0000 | 2027-04-16 | 2.6000 | 2.6000 | 2.8500 | 55.3300 | 10920.00 | 0.00 | 10920.00 | 42 | 7 | 43 | 2 | 21.5 | 0.223891718563036 | 0.223891718563036 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14980089672.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 38b0cb76-da87-4d57-b985-6ccad617d6cc | 2026-08-27 11:47 | 2026-08-27 11:47 | 2026-08-27 11:47 | TSN | TSN270416P00052500 | put | 52.5000 | 2027-04-16 | 3.1000 | 3.1000 | 4.2000 | 55.6300 | 16430.00 | 0.00 | 16430.00 | 53 | 27 | 103 | 0 | 0 | 0.291027028244527 | 0.292047468491696 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14980089672.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T16:07:33.804891Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 707c425e-8a08-488d-b0b1-abc4b98e2ece | 2026-08-31 12:09 | 2026-08-31 12:09 | 2026-08-31 12:09 | TSN | TSN270115C00060000 | call | 60.0000 | 2027-01-15 | 1.8000 | 1.6000 | 1.9500 | 55.4900 | 11160.00 | 2340.00 | 8820.00 | 62 | 6 | 65 | 800 | 0.08125 | 0.235627758804845 | 0.235627758804845 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14980089672.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T16:39:59.140702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3295c61f-6fef-4f4a-b91a-c212edcc2be9 | 2026-09-02 13:56 | 2026-09-02 13:56 | 2026-09-02 13:56 | TSN | TSN270917P00055000 | put | 55.0000 | 2027-09-17 | 4.8000 | 4.8000 | 5.1000 | 56.4600 | 10080.00 | 0.00 | 10080.00 | 21 | 6 | 34 | 104 | 0.326923076923077 | 0.2975768016553 | 0.2975768016553 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14980089672.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T18:05:44.095975Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cd8f7e1e-94a1-46f8-8caf-1c7a04d3a8bb | 2026-09-03 10:32 | 2026-09-03 10:32 | 2026-09-03 10:32 | TSN | TSN260918P00052500 | put | 52.5000 | 2026-09-18 | 1.4900 | 1.4500 | 1.7500 | 51.8000 | 20440.00 | 0.00 | 20440.00 | 137 | 23 | 235 | 638 | 0.36833855799373 | 0.273616425303171 | 0.264259210874678 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 14980089672.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T14:40:26.963433Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5856f499-015d-4fe6-b0fa-a98ff77a296e | 2026-09-10 14:45 | 2026-09-10 14:44 | 2026-09-10 14:44 | TSN | TSN270416C00055000 | call | 55.0000 | 2027-04-16 | 3.5000 | 3.2000 | 3.5000 | 52.5000 | 44800.00 | 44800.00 | 0.00 | 128 | 17 | 130 | 133 | 0.977443609022556 | 0.247753119153113 | 0.247753119153113 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14980089672.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 14395a6b-5925-4d72-a113-46201750247c | 2026-09-11 14:32 | 2026-09-11 14:31 | 2026-09-11 14:31 | TSN | TSN261016C00052500 | call | 52.5000 | 2026-10-16 | 1.7000 | 1.5500 | 1.7500 | 52.5600 | 30260.00 | 30090.00 | 0.00 | 178 | 28 | 261 | 225 | 1.16 | 0.241803557532385 | 0.241803557532385 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14980089672.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T18:33:12.425630Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c88faad8-28fb-4c39-82b6-02103c064f70 | 2026-09-14 09:30 | 2026-09-14 09:30 | 2026-09-14 09:30 | TSN | TSN280121C00047500 | call | 47.5000 | 2028-01-21 | 10.6000 | 10.1000 | 12.1000 | 53.8200 | 10600.00 | 0.00 | 10600.00 | 10 | 5 | 10 | 16 | 0.625 | 0.202720394196379 | 0.202720394196379 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14980089672.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d256a837-e394-4ea0-b2fb-32ddabcc17c5 | 2026-09-18 10:50 | 2026-09-18 10:50 | 2026-09-18 10:50 | TSN | TSN270319C00055000 | call | 55.0000 | 2027-03-19 | 3.4000 | 3.0000 | 3.6000 | 53.1800 | 61190.00 | 26860.00 | 34330.00 | 180 | 6 | 180 | 105 | 1.71428571428571 | 0.246160439002728 | 0.239484403663803 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14870190594.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| d05a3bfb-2948-4ef4-8707-3a1177bf057b | 2026-09-18 11:49 | 2026-09-18 11:49 | 2026-09-18 11:49 | TSN | TSN261218P00052500 | put | 52.5000 | 2026-12-18 | 2.5000 | 2.4000 | 2.6000 | 53.0500 | 12500.00 | 1000.00 | 1250.00 | 50 | 18 | 60 | 246 | 0.24390243902439 | 0.288896136992635 | 0.288896136992635 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14870190594.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 06b05425-fca6-459a-8fc6-bdea2c0b8851 | 2026-09-18 15:33 | 2026-09-18 15:33 | 2026-09-18 15:33 | TSN | TSN280121P00050000 | put | 50.0000 | 2028-01-21 | 5.0000 | 4.8000 | 5.2000 | 52.9200 | 34000.00 | 22000.00 | 11000.00 | 68 | 12 | 75 | 643 | 0.116640746500778 | 0.332419100416122 | 0.332133896738891 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14870190594.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 9f105e31-8eaa-4587-95e4-baf776093776 | 2026-09-18 15:34 | 2026-09-18 15:34 | 2026-09-18 15:34 | TSN | TSN280121P00045000 | put | 45.0000 | 2028-01-21 | 3.3000 | 3.0000 | 3.4000 | 52.9000 | 11880.00 | 9570.00 | 2310.00 | 36 | 14 | 60 | 107 | 0.560747663551402 | 0.341997501195718 | 0.341875774680803 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 14870190594.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |