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.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8baf7ace-7deb-4ab2-a1ba-08e2018c1552 | 2026-08-20 09:31 | 2026-08-20 09:31 | 2026-08-20 09:31 | SPCX | SPCX260821C00145000 | call | 145.0000 | 2026-08-21 | 0.6300 | 0.6300 | 0.6900 | 137.5900 | 103257.00 | 0.00 | 103257.00 | 1639 | 53 | 2053 | 19123 | 0.107357632170685 | 1.00803308785041 | 1.00803308785041 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 1140205907062.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7f5dfc6c-519d-4b75-a7ea-2a1248930b62 | 2026-08-18 10:30 | 2026-08-18 10:30 | 2026-08-18 10:30 | SPCX | SPCX260821C00145000 | call | 145.0000 | 2026-08-21 | 3.1000 | 3.0000 | 3.1000 | 142.5300 | 106630.00 | 106630.00 | 0.00 | 344 | 13 | 14104 | 18359 | 0.768233563919604 | 0.808364431841051 | 0.806387774502677 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 1140205907062.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e3e5825a-6ca3-4631-a526-c74e9921b36f | 2026-08-18 10:29 | 2026-08-18 10:29 | 2026-08-18 10:29 | SPCX | SPCX260821C00145000 | call | 145.0000 | 2026-08-21 | 2.9900 | 2.9500 | 2.9900 | 142.3800 | 149499.00 | 149201.00 | 298.00 | 500 | 10 | 13638 | 18359 | 0.742850917805981 | 0.796236097911695 | 0.799048469752385 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 1140205907062.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 48b4a45e-ebfb-46a9-8196-8fb416bfedd1 | 2026-08-18 10:10 | 2026-08-18 10:10 | 2026-08-18 10:10 | SPCX | SPCX260821C00145000 | call | 145.0000 | 2026-08-21 | 2.2000 | 2.2000 | 2.2100 | 140.3510 | 208340.00 | 0.00 | 208340.00 | 947 | 9 | 11051 | 18359 | 0.601939103437006 | 0.790736672938364 | 0.794313241929357 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 1140205907062.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c55fa234-3d3c-481a-bbaf-9dde3de930d2 | 2026-08-18 09:36 | 2026-08-18 09:36 | 2026-08-18 09:36 | SPCX | SPCX260821C00145000 | call | 145.0000 | 2026-08-21 | 2.6000 | 2.5200 | 2.6100 | 140.9299 | 520636.00 | 101788.00 | 418848.00 | 2004 | 45 | 6353 | 18359 | 0.346042812789368 | 0.833249565963049 | 0.835324322804045 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 1140205907062.00 | 2026-11-03 | 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 |
| 7f3d19ff-7b44-4c9c-8697-eddc54d9f6b8 | 2026-08-18 09:36 | 2026-08-18 09:36 | 2026-08-18 09:36 | SPCX | SPCX260821C00145000 | call | 145.0000 | 2026-08-21 | 2.5500 | 2.4800 | 2.5800 | 140.7000 | 382399.00 | 40192.00 | 341952.00 | 1501 | 16 | 4348 | 18359 | 0.236832071463587 | 0.830223046176829 | 0.842425690677486 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 1140205907062.00 | 2026-11-03 | 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 |
| 95316ea7-a821-45a6-b2a1-24629737ab78 | 2026-08-18 09:36 | 2026-08-18 09:36 | 2026-08-18 09:36 | SPCX | SPCX260821C00145000 | call | 145.0000 | 2026-08-21 | 2.4800 | 2.4000 | 2.5200 | 140.7693 | 404937.00 | 375569.00 | 25648.00 | 1630 | 66 | 2846 | 18359 | 0.155019336565172 | 0.825675292005496 | 0.81835589183414 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 1140205907062.00 | 2026-11-03 | 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 |
| f0d94d6f-95d0-4d0b-946a-6a26cc1d8397 | 2026-08-17 09:57 | 2026-08-17 09:57 | 2026-08-17 09:57 | SPCX | SPCX260821C00145000 | call | 145.0000 | 2026-08-21 | 6.5000 | 6.4500 | 6.6000 | 147.8150 | 2423425.00 | 28825.00 | 2394600.00 | 3728 | 8 | 19443 | 22279 | 0.872705238116612 | 0.829447724049305 | 0.823457423079904 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 1140205907062.00 | 2026-11-03 | 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 |
| 41d96ed7-113a-4073-a9d5-9bfe3e50f3fd | 2026-08-17 09:57 | 2026-08-17 09:57 | 2026-08-17 09:57 | SPCX | SPCX260821C00145000 | call | 145.0000 | 2026-08-21 | 6.4000 | 6.2500 | 6.5000 | 147.5700 | 780774.00 | 780774.00 | 0.00 | 1220 | 62 | 15715 | 22279 | 0.705372772566094 | 0.828701593434101 | 0.831454176426827 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 1140205907062.00 | 2026-11-03 | 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 |
| 8c9f00bd-2aac-454c-a004-06aa632d9d03 | 2026-08-17 09:49 | 2026-08-17 09:49 | 2026-08-17 09:49 | SPCX | SPCX260821C00145000 | call | 145.0000 | 2026-08-21 | 6.0000 | 5.9500 | 6.0500 | 146.8000 | 112195.00 | 97200.00 | 595.00 | 187 | 35 | 12822 | 22279 | 0.575519547555994 | 0.823492061684865 | 0.823492061684865 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 1140205907062.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 49d3693e-f8c5-4b17-a73f-59a6dc375cb2 | 2026-08-17 09:44 | 2026-08-17 09:44 | 2026-08-17 09:44 | SPCX | SPCX260821C00145000 | call | 145.0000 | 2026-08-21 | 5.5000 | 5.4500 | 5.5500 | 145.7700 | 581930.00 | 581930.00 | 0.00 | 1058 | 6 | 10800 | 22279 | 0.484761434534764 | 0.836131379523862 | 0.844393358705139 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 1140205907062.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 90e1f8cd-12bd-414e-b7b3-35e191af8006 | 2026-08-14 15:56 | 2026-08-14 15:55 | 2026-08-14 15:55 | SPCX | SPCX260821C00145000 | call | 145.0000 | 2026-08-21 | 2.9700 | 2.9400 | 2.9800 | 139.9650 | 103166.00 | 92177.00 | 8910.00 | 347 | 35 | 18618 | 21557 | 0.863663775107854 | 0.642955735940029 | 0.644327660430519 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 1140205907062.00 | 2026-11-03 | 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 |