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.
uw_flow_alerts609,118 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 | expiry |
|---|
| 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 |
|---|
| 49defc79-34b3-410e-ac6a-6a40fd24b94d | 2026-09-10 14:50 | 2026-09-10 14:50 | 2026-09-10 14:50 | NFLX | NFLX261016C00080000 | call | 80.0000 | 2026-10-16 | 1.9900 | 1.9900 | 2.0200 | 75.9550 | 184672.00 | 0.00 | 184672.00 | 928 | 39 | 5128 | 17474 | 0.293464575941399 | 0.364297738157201 | 0.364297738157201 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 334447634776.00 | 2026-10-20 | 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 |
| 88d5a870-8b63-4d49-87fb-a1d3bcbe1a67 | 2026-09-08 15:40 | 2026-09-08 15:40 | 2026-09-08 15:40 | NFLX | NFLX261016C00080000 | call | 80.0000 | 2026-10-16 | 2.3900 | 2.3800 | 2.4300 | 76.7350 | 57838.00 | 0.00 | 57838.00 | 242 | 23 | 3293 | 16088 | 0.204686723023371 | 0.365285768877666 | 0.365285768877666 | false | false | false | true | ||||||||||||||||
| 3d0a312e-4b70-4196-9495-92a5abf931d9 | 2026-08-25 10:41 | 2026-08-25 10:41 | 2026-08-25 10:41 | NFLX | NFLX261016C00080000 | call | 80.0000 | 2026-10-16 | 5.3500 | 5.3500 | 5.4500 | 81.4865 | 321000.00 | 0.00 | 321000.00 | 600 | 12 | 1716 | 14652 | 0.117117117117117 | 0.356818657772049 | 0.356818657772049 | false | false | false | true | ||||||||||||||||
| 447be5e2-9319-4920-888f-9aaef52e2c0f | 2026-08-25 10:39 | 2026-08-25 10:39 | 2026-08-25 10:39 | NFLX | NFLX261016C00080000 | call | 80.0000 | 2026-10-16 | 5.3500 | 5.3000 | 5.4500 | 81.3850 | 226305.00 | 12840.00 | 192600.00 | 423 | 28 | 1086 | 14652 | 0.0741195741195741 | 0.360638057120476 | 0.361881111545292 | true | false | false | true | ||||||||||||||||
| 01d9d20d-ae86-44c8-8087-2155cb37b9e2 | 2026-08-25 10:20 | 2026-08-25 10:20 | 2026-08-25 10:20 | NFLX | NFLX261016C00080000 | call | 80.0000 | 2026-10-16 | 5.3000 | 5.2500 | 5.3000 | 81.2550 | 82680.00 | 82680.00 | 0.00 | 156 | 5 | 517 | 14652 | 0.0352852852852853 | 0.364118404044366 | 0.364118404044366 | false | false | false | true | ||||||||||||||||
| 4fe5c20b-3596-47e2-bca9-d9d31fad621c | 2026-08-21 10:02 | 2026-08-21 10:02 | 2026-08-21 10:02 | NFLX | NFLX261016C00080000 | call | 80.0000 | 2026-10-16 | 4.2500 | 4.2500 | 4.3500 | 79.3750 | 59500.00 | 0.00 | 59500.00 | 140 | 28 | 241 | 14422 | 0.0167105810567189 | 0.349023515237631 | 0.349023515237631 | false | false | false | true | ||||||||||||||||
| 8abe62d4-48c9-40d4-807b-cc8dc267fae9 | 2026-08-20 13:20 | 2026-08-20 13:20 | 2026-08-20 13:20 | NFLX | NFLX261016C00080000 | call | 80.0000 | 2026-10-16 | 5.2000 | 5.1500 | 5.2000 | 80.6900 | 50960.00 | 50960.00 | 0.00 | 98 | 7 | 1523 | 13607 | 0.11192768428015 | 0.364099835257189 | 0.364099835257189 | false | false | false | true | ||||||||||||||||
| 7d7b76f1-9970-4625-a420-2a751e3baa31 | 2026-08-20 13:17 | 2026-08-20 13:17 | 2026-08-20 13:17 | NFLX | NFLX261016C00080000 | call | 80.0000 | 2026-10-16 | 5.1500 | 5.1000 | 5.1500 | 80.5850 | 256985.00 | 256985.00 | 0.00 | 499 | 13 | 1370 | 13607 | 0.100683471742485 | 0.364859571742359 | 0.364859571742359 | false | false | false | true | ||||||||||||||||
| a69d3507-b8b8-4765-9c51-fe52449c2dd4 | 2026-08-19 13:33 | 2026-08-19 13:33 | 2026-08-19 13:33 | NFLX | NFLX261016C00080000 | call | 80.0000 | 2026-10-16 | 5.1000 | 5.0500 | 5.1500 | 80.4600 | 71419.00 | 7140.00 | 64279.00 | 140 | 9 | 2127 | 14291 | 0.148834931075502 | 0.362930594004291 | 0.363721430180265 | false | false | false | true | ||||||||||||||||
| 22dfd60b-5351-40a4-935c-607b1d095661 | 2026-08-19 11:00 | 2026-08-19 11:00 | 2026-08-19 11:00 | NFLX | NFLX261016C00080000 | call | 80.0000 | 2026-10-16 | 5.5400 | 5.5000 | 5.6000 | 81.1300 | 138615.00 | 0.00 | 14850.00 | 250 | 6 | 1285 | 14291 | 0.0899167308096004 | 0.364235321491958 | 0.364235321491958 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 334447634776.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 334447634776.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:42:01.576369Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 334447634776.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:42:01.576369Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 334447634776.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:28:24.156188Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 334447634776.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 334447634776.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 334447634776.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 334447634776.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 334447634776.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |