Options 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| b3dfbd93-3548-4cf6-825a-391d0928ff6c | 2026-08-17 10:16 | 2026-08-17 10:16 | 2026-08-17 10:16 | SAN | SAN260821P00015000 | put | 15.0000 | 2026-08-21 | 0.3500 | 0.1500 | 0.4000 | 14.7563 | 70700.00 | 70630.00 | 70.00 | 2020 | 7 | 2021 | 5009 | 0.403473747254941 | 0.338510366838968 | 0.338510366838968 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Financial Services | 216520569459.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 92539033-49c3-4528-aa39-2ff6cee91cae | 2026-08-18 10:45 | 2026-08-18 10:45 | 2026-08-18 10:45 | SAN | SAN270319C00015000 | call | 15.0000 | 2027-03-19 | 1.2500 | 1.2000 | 1.2500 | 14.4300 | 70375.00 | 69125.00 | 0.00 | 563 | 19 | 568 | 22 | 25.8181818181818 | 0.307366205214415 | 0.307366205214415 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Financial Services | 216520569459.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 36792796-83c3-4015-8732-e137aba8f137 | 2026-08-18 11:00 | 2026-08-18 11:00 | 2026-08-18 11:00 | SAN | SAN270319C00015000 | call | 15.0000 | 2027-03-19 | 1.2400 | 0.8500 | 1.4500 | 14.3800 | 119134.00 | 118409.00 | 600.00 | 960 | 23 | 1528 | 22 | 69.4545454545455 | 0.301860321745359 | 0.313277492033268 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Financial Services | 216520569459.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 355df07c-13cf-4906-b69b-2eb0ecdae622 | 2026-08-18 11:01 | 2026-08-18 11:01 | 2026-08-18 11:01 | SAN | SAN270319C00015000 | call | 15.0000 | 2027-03-19 | 1.2500 | 1.0500 | 1.3000 | 14.3700 | 70500.00 | 70000.00 | 0.00 | 564 | 20 | 2249 | 22 | 102.227272727273 | 0.314455920119266 | 0.314455920119266 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Financial Services | 216520569459.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2164330b-0ed7-4c2b-ba88-9de509fc68a3 | 2026-08-19 15:49 | 2026-08-19 15:48 | 2026-08-19 15:48 | SAN | SAN260918C00014000 | call | 14.0000 | 2026-09-18 | 0.7000 | 0.6500 | 0.7500 | 14.2199 | 128841.00 | 128701.00 | 140.00 | 1841 | 34 | 2309 | 1590 | 1.45220125786164 | 0.350460651299137 | 0.346754134346823 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Financial Services | 216520569459.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ce8b8439-7472-424c-b917-525ab21523ce | 2026-08-21 15:36 | 2026-08-21 15:36 | 2026-08-21 15:36 | SAN | SAN260821C00014000 | call | 14.0000 | 2026-08-21 | 0.6400 | 0.5500 | 0.6500 | 14.5950 | 61202.00 | 61202.00 | 0.00 | 958 | 10 | 5301 | 7779 | 0.681450057848052 | 5.50280495367854 | 5.50280495367854 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Financial Services | 216520569459.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3765e6a2-6d26-4c8e-9388-e3322bc7c729 | 2026-08-21 15:39 | 2026-08-21 15:39 | 2026-08-21 15:39 | SAN | SAN260821C00014000 | call | 14.0000 | 2026-08-21 | 0.6500 | 0.5500 | 0.6500 | 14.6100 | 90772.00 | 90772.00 | 0.00 | 1400 | 19 | 6701 | 7779 | 0.861421776577966 | 5.79114476298002 | 5.79114476298002 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Financial Services | 216520569459.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cd950a91-a043-46ad-999d-abfaf219d681 | 2026-08-21 15:46 | 2026-08-21 15:46 | 2026-08-21 15:46 | SAN | SAN260821C00014000 | call | 14.0000 | 2026-08-21 | 0.6000 | 0.6000 | 0.6500 | 14.6150 | 84001.00 | 0.00 | 84001.00 | 1400 | 18 | 8183 | 7779 | 1.05193469597635 | 7.57923741533218 | 7.57923741533218 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Financial Services | 216520569459.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 28eb072b-5e86-4200-9e2d-0fcf576a726a | 2026-08-21 15:52 | 2026-08-21 15:52 | 2026-08-21 15:52 | SAN | SAN270319C00014000 | call | 14.0000 | 2027-03-19 | 1.9000 | 1.6000 | 1.9500 | 14.6200 | 99940.00 | 88540.00 | 0.00 | 526 | 9 | 526 | 73 | 7.20547945205479 | 0.323371890191078 | 0.323371890191078 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Financial Services | 216520569459.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9078e7e2-42d2-4d0f-944b-c3d1c4a03bfb | 2026-08-25 14:48 | 2026-08-25 14:48 | 2026-08-25 14:48 | SAN | SAN261218C00013000 | call | 13.0000 | 2026-12-18 | 2.1000 | 1.9500 | 2.1000 | 14.6550 | 102898.00 | 102898.00 | 0.00 | 490 | 24 | 681 | 3600 | 0.189166666666667 | 0.304234780220575 | 0.300677774456542 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Financial Services | 216520569459.00 | 2026-11-04 | 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 |
| 449dba2a-1288-4d94-aa77-b86b1b724e77 | 2026-09-01 11:24 | 2026-09-01 11:23 | 2026-09-01 11:23 | SAN | SAN280121P00015000 | put | 15.0000 | 2028-01-21 | 2.4000 | 2.3500 | 3.1000 | 14.5050 | 274560.00 | 0.00 | 274560.00 | 1144 | 15 | 1144 | 51 | 22.4313725490196 | 0.387730153387873 | 0.387730153387873 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Financial Services | 216520569459.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T15:45:30.323966Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 30158804-a742-429a-9921-b0871086ec52 | 2026-09-03 10:18 | 2026-09-03 10:17 | 2026-09-03 10:17 | SAN | SAN270319P00015000 | put | 15.0000 | 2027-03-19 | 1.4000 | 1.2500 | 1.7000 | 14.8900 | 58380.00 | 280.00 | 58100.00 | 417 | 15 | 417 | 2 | 208.5 | 0.349326323534587 | 0.349326323534587 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Financial Services | 216520569459.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T14:24:32.358904Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fe50e275-dd0f-4317-a8b3-6634e27a0951 | 2026-09-14 10:24 | 2026-09-14 10:24 | 2026-09-14 10:24 | SAN | SAN261016C00014000 | call | 14.0000 | 2026-10-16 | 0.9000 | 0.6500 | 0.9000 | 14.0000 | 80100.00 | 80100.00 | 0.00 | 890 | 7 | 890 | 198 | 4.49494949494949 | 0.307845580878181 | 0.307845580878181 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Financial Services | 216520569459.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 54024199-dea3-40ff-97e4-9a8952502350 | 2026-09-17 11:16 | 2026-09-17 11:16 | 2026-09-17 11:16 | SAN | SAN261218C00016000 | call | 16.0000 | 2026-12-18 | 0.4500 | 0.4000 | 0.5000 | 14.8350 | 50400.00 | 405.00 | 49905.00 | 1120 | 12 | 1120 | 814 | 1.37592137592138 | 0.279451213048717 | 0.279451213048717 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Financial Services | 217695715020.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |