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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| e85049b6-7e36-4100-b0e0-7305fbfdb618 | 2026-09-18 11:36 | 2026-09-18 11:36 | 2026-09-18 11:36 | SKM | SKM261016C00035000 | call | 35.0000 | 2026-10-16 | 2.6800 | 2.5000 | 2.7000 | 35.7600 | 82425.00 | 43470.00 | 38955.00 | 308 | 49 | 761 | 339 | 2.24483775811209 | 0.574531928019484 | 0.561524898969873 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Communication Services | 13762914611.00 | 2026-10-29 | 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 |
| ff5a9505-3369-4a6f-99b1-09347dbfeae1 | 2026-09-17 11:45 | 2026-09-17 11:45 | 2026-09-17 11:45 | SKM | SKM270115C00035000 | call | 35.0000 | 2027-01-15 | 5.2000 | 4.8000 | 5.2000 | 35.7650 | 51992.00 | 47312.00 | 0.00 | 100 | 17 | 100 | 3030 | 0.033003300330033 | 0.570282963276962 | 0.570282963276962 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Communication Services | 13624902096.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:59:42.981722Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 7aa45443-5dc2-4d3c-8cdc-b0d42c3fd068 | 2026-09-14 14:58 | 2026-09-14 14:58 | 2026-09-14 14:58 | SKM | SKM261218C00035000 | call | 35.0000 | 2026-12-18 | 5.5000 | 5.3000 | 5.6000 | 36.4200 | 66021.00 | 3320.00 | 62701.00 | 120 | 31 | 471 | 7740 | 0.0608527131782946 | 0.646991462823824 | 0.632807271102696 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 38938348-0f33-4ddd-92cb-9495ba5d4c7f | 2026-09-11 12:58 | 2026-09-11 12:58 | 2026-09-11 12:58 | SKM | SKM270115P00035000 | put | 35.0000 | 2027-01-15 | 3.9100 | 3.8000 | 4.0000 | 37.8400 | 78144.00 | 18084.00 | 0.00 | 200 | 10 | 201 | 3623 | 0.0554788849020149 | 0.645652895285952 | 0.645652895285952 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T17:27:08.545704Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d0392975-1f49-464f-babd-0c847775f583 | 2026-09-11 12:14 | 2026-09-11 12:14 | 2026-09-11 12:14 | SKM | SKM260918C00040000 | call | 40.0000 | 2026-09-18 | 0.4100 | 0.4000 | 0.5000 | 37.9100 | 20258.00 | 0.00 | 20258.00 | 500 | 9 | 671 | 9268 | 0.0723996547259387 | 0.551629313229135 | 0.533742076790555 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T16:20:29.379987Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1a683cac-95a3-4756-b718-ecd1e28c5034 | 2026-09-10 14:51 | 2026-09-10 14:51 | 2026-09-10 14:51 | SKM | SKM270319C00035000 | call | 35.0000 | 2027-03-19 | 7.7000 | 7.7000 | 8.1000 | 37.2250 | 12322.00 | 0.00 | 12322.00 | 16 | 6 | 54 | 83 | 0.650602409638554 | 0.598635810872039 | 0.598635810872039 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | 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 |
| 19c930a4-d638-469e-bcd9-46199383cabb | 2026-09-04 10:42 | 2026-09-04 10:42 | 2026-09-04 10:42 | SKM | SKM261016P00035000 | put | 35.0000 | 2026-10-16 | 1.7200 | 1.5000 | 1.8000 | 38.5200 | 13276.00 | 6646.00 | 6630.00 | 77 | 8 | 429 | 1126 | 0.380994671403197 | 0.659531296125289 | 0.657286183743958 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T14:44:26.340635Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 18b4dc67-f8d3-4063-a41e-0846fac32e6f | 2026-08-24 09:54 | 2026-08-24 09:54 | 2026-08-24 09:54 | SKM | SKM261218C00050000 | call | 50.0000 | 2026-12-18 | 3.3700 | 1.9000 | 3.5000 | 40.1200 | 50475.00 | 50475.00 | 0.00 | 150 | 19 | 151 | 5513 | 0.0273898059132958 | 0.723344083722343 | 0.670630976728743 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |