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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| b816c4ed-5694-4994-ba87-c3014a44892c | 2026-08-18 11:57 | 2026-08-18 11:57 | 2026-08-18 11:57 | TE | TE260828P00005000 | put | 5.0000 | 2026-08-28 | 0.5800 | 0.5000 | 0.7000 | 4.5875 | 11674.00 | 0.00 | 11674.00 | 200 | 5 | 336 | 1033 | 0.325266214908035 | 1.10597659007644 | 1.10597659007644 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d069b82b-cd6f-4448-a495-0c92fb726413 | 2026-08-21 09:41 | 2026-08-21 09:41 | 2026-08-21 09:41 | TE | TE270115C00005000 | call | 5.0000 | 2027-01-15 | 1.2500 | 1.2000 | 1.2500 | 4.4450 | 46200.00 | 39700.00 | 0.00 | 370 | 6 | 799 | 4351 | 0.183635945759595 | 1.2802469738728 | 1.27100823685805 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e4733720-5805-4781-af1c-0fd8289761ee | 2026-08-21 10:21 | 2026-08-21 10:21 | 2026-08-21 10:21 | TE | TE260925C00004500 | call | 4.5000 | 2026-09-25 | 0.5500 | 0.5000 | 0.5500 | 4.3450 | 10950.00 | 10950.00 | 0.00 | 200 | 7 | 200 | 50 | 4 | 1.13709576658048 | 1.11839890680776 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 39ab7209-e3c8-41cf-ba23-fe8d86780088 | 2026-08-21 11:16 | 2026-08-21 11:15 | 2026-08-21 11:15 | TE | TE270115P00004000 | put | 4.0000 | 2027-01-15 | 1.0100 | 1.0000 | 1.1000 | 4.4650 | 43770.00 | 0.00 | 43770.00 | 435 | 9 | 1000 | 3252 | 0.30750307503075 | 1.21203004855716 | 1.2017548302616 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | 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 |
| 51919f7c-8239-4202-b113-bd1c093b07bd | 2026-08-27 11:31 | 2026-08-27 11:31 | 2026-08-27 11:31 | TE | TE261016C00005000 | call | 5.0000 | 2026-10-16 | 0.7400 | 0.7000 | 0.8500 | 4.8900 | 125604.00 | 0.00 | 125604.00 | 1700 | 8 | 1846 | 6248 | 0.295454545454545 | 1.09406388781461 | 1.09406388781461 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T15:44:11.413260Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 09e69282-7ee3-46d5-9129-21eea476584a | 2026-08-31 09:47 | 2026-08-31 09:47 | 2026-08-31 09:47 | TE | TE270115C00006000 | call | 6.0000 | 2027-01-15 | 0.9100 | 0.9000 | 1.0000 | 4.6350 | 18135.00 | 0.00 | 18135.00 | 200 | 6 | 202 | 4216 | 0.0479127134724858 | 1.18012552206128 | 1.15363939701998 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0e21ff6e-9119-40cc-8340-751d0ff38695 | 2026-08-31 15:50 | 2026-08-31 15:50 | 2026-08-31 15:50 | TE | TE261002C00006000 | call | 6.0000 | 2026-10-02 | 0.2000 | 0.1500 | 0.2000 | 4.3803 | 19993.00 | 19959.00 | 34.00 | 1000 | 43 | 1046 | 608 | 1.72039473684211 | 1.22696509923373 | 1.22696509923373 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 96e9acef-de08-41c9-af16-01a7b5425330 | 2026-09-04 12:38 | 2026-09-04 12:37 | 2026-09-04 12:37 | TE | TE261016C00006000 | call | 6.0000 | 2026-10-16 | 0.3000 | 0.2500 | 0.3500 | 4.6200 | 74277.00 | 59217.00 | 15060.00 | 2488 | 69 | 2522 | 5790 | 0.435578583765112 | 1.13095186832668 | 1.13095186832668 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d3dc3137-8991-43d1-b6bd-5e4770a1d843 | 2026-09-04 13:44 | 2026-09-04 13:44 | 2026-09-04 13:44 | TE | TE260918C00006000 | call | 6.0000 | 2026-09-18 | 0.1000 | 0.0500 | 0.1000 | 4.5650 | 97238.00 | 97238.00 | 0.00 | 9780 | 64 | 9898 | 14452 | 0.684887904788265 | 1.31379982938702 | 1.31379982938702 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | 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 |
| c97f0147-5259-42b9-98e2-75651c4f4515 | 2026-09-04 13:50 | 2026-09-04 13:50 | 2026-09-04 13:50 | TE | TE261009C00005000 | call | 5.0000 | 2026-10-09 | 0.5000 | 0.4500 | 0.5000 | 4.6050 | 16518.00 | 15598.00 | 920.00 | 332 | 28 | 394 | 68 | 5.79411764705882 | 1.14040515238372 | 1.14040515238372 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | 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 |
| 50d74a9f-7bd2-4c8b-ae88-014df873d399 | 2026-09-08 10:46 | 2026-09-08 10:46 | 2026-09-08 10:46 | TE | TE260918C00007000 | call | 7.0000 | 2026-09-18 | 0.0500 | 0.0500 | 0.1000 | 5.1901 | 10202.00 | 0.00 | 10202.00 | 1999 | 6 | 2026 | 4651 | 0.435605246183616 | 1.36991808745121 | 1.30737649107085 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T14:47:12.085652Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 52ecc36f-185f-4bee-bcf4-6e7761916571 | 2026-09-14 09:31 | 2026-09-14 09:31 | 2026-09-14 09:31 | TE | TE260918P00004500 | put | 4.5000 | 2026-09-18 | 0.3000 | 0.1500 | 0.3500 | 4.3350 | 15142.00 | 15142.00 | 0.00 | 500 | 5 | 503 | 2056 | 0.244649805447471 | 1.18752910720107 | 1.18752910720107 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | 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 |
| b4e5891c-0926-4d38-9d18-1e3b97e49427 | 2026-09-18 11:24 | 2026-09-18 11:23 | 2026-09-18 11:23 | TE | TE261016P00004000 | put | 4.0000 | 2026-10-16 | 0.3600 | 0.3500 | 0.4500 | 4.1050 | 23282.00 | 9310.00 | 13932.00 | 644 | 7 | 1096 | 6942 | 0.157879573609911 | 0.9737844814492 | 0.910286073879955 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1228177865.00 | 2026-11-13 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |