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 | 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 |
|---|
| b7f2fe2f-be31-4c62-9608-7c0ef62da77d | 2026-09-29 13:54 | 2026-09-29 13:54 | 2026-09-29 13:54 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 3.3300 | 3.2500 | 3.3500 | 116.0500 | 21978.00 | 21978.00 | 0.00 | 66 | 5 | 639 | 10382 | 0.0615488345212868 | 0.65363651100547 | 0.65363651100547 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 584750920000.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T17:58:05.042752Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 55032307-9cb1-40b8-a717-c6ece61de665 | 2026-09-29 13:51 | 2026-09-29 13:51 | 2026-09-29 13:51 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 3.3500 | 3.3000 | 3.3500 | 116.3800 | 24790.00 | 24790.00 | 0.00 | 74 | 11 | 366 | 10382 | 0.0352533230591408 | 0.659362512368283 | 0.659124088992495 | false | false | false | true | false | |||||||||||||||
| 505e4a88-94ef-4ab5-bc37-5e99304f086b | 2026-09-29 13:51 | 2026-09-29 13:51 | 2026-09-29 13:51 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 3.3500 | 3.3000 | 3.3500 | 116.4000 | 22110.00 | 22110.00 | 0.00 | 66 | 10 | 432 | 10382 | 0.0416104796763629 | 0.659124088992495 | 0.659362512368283 | false | false | false | true | false | |||||||||||||||
| 09149032-f433-4636-aff2-01b16dc0bc88 | 2026-09-29 13:51 | 2026-09-29 13:51 | 2026-09-29 13:51 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 3.3500 | 3.3000 | 3.3500 | 116.4000 | 36850.00 | 36850.00 | 0.00 | 110 | 13 | 242 | 10382 | 0.0233095742631478 | 0.659243310469259 | 0.659362512368283 | false | false | false | true | false | |||||||||||||||
| ec6c7614-6bcd-441e-b850-c151d82f603e | 2026-09-25 11:39 | 2026-09-25 11:39 | 2026-09-25 11:39 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 2.8900 | 2.7800 | 2.8900 | 123.0000 | 30633.00 | 30345.00 | 288.00 | 106 | 16 | 5591 | 10445 | 0.535280038295835 | 0.683769553995226 | 0.682943743533597 | false | false | false | true | ||||||||||||||||
| a6b81db5-1912-4b73-99d8-2304de410ee7 | 2026-09-25 09:30 | 2026-09-25 09:30 | 2026-09-25 09:30 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 2.7500 | 2.5900 | 2.8300 | 126.8800 | 13750.00 | 4675.00 | 9075.00 | 50 | 5 | 50 | 10445 | 0.00478697941598851 | 0.706985822427122 | 0.706985822427122 | false | false | false | true | false | |||||||||||||||
| 1278908c-20e4-4efe-b582-c49f918b431a | 2026-09-24 11:20 | 2026-09-24 11:20 | 2026-09-24 11:20 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 3.0000 | 2.9000 | 3.0000 | 122.9500 | 44400.00 | 44400.00 | 0.00 | 148 | 10 | 281 | 10620 | 0.0264595103578154 | 0.684445962258859 | 0.684445962258859 | false | false | false | true | false | |||||||||||||||
| 43601f3e-2a25-43ea-9c68-2073486b5001 | 2026-09-23 11:42 | 2026-09-23 11:42 | 2026-09-23 11:42 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 3.2000 | 3.2000 | 3.2500 | 120.0000 | 21120.00 | 0.00 | 21120.00 | 66 | 13 | 233 | 10532 | 0.0221230535510824 | 0.674621037960995 | 0.674621037960995 | false | false | false | true | false | |||||||||||||||
| 587b8fd3-542c-48dd-ab85-29d81b85f1cb | 2026-09-23 10:11 | 2026-09-23 10:11 | 2026-09-23 10:11 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 3.3500 | 3.2500 | 3.4000 | 120.0000 | 12730.00 | 11055.00 | 0.00 | 38 | 5 | 47 | 10532 | 0.0044625902012913 | 0.680282726652423 | 0.680282726652423 | false | false | false | true | false | |||||||||||||||
| 2cbd7ad6-57c5-4bb7-8947-477a9b0a5d77 | 2026-09-22 09:31 | 2026-09-22 09:31 | 2026-09-22 09:31 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 3.4500 | 3.4000 | 3.6000 | 121.1700 | 17250.00 | 345.00 | 345.00 | 50 | 19 | 53 | 10534 | 0.00503132713119423 | 0.693249674563028 | 0.693249674563028 | false | false | false | true | false | |||||||||||||||
| a0b612ae-c508-4cb0-badd-9de3c6b53a75 | 2026-09-21 13:45 | 2026-09-21 13:45 | 2026-09-21 13:45 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 3.4500 | 3.4500 | 3.5000 | 121.0000 | 10352.00 | 0.00 | 10352.00 | 30 | 6 | 613 | 10395 | 0.058970658970659 | 0.697261397586193 | 0.69801700042309 | false | false | false | true | false | |||||||||||||||
| aab056e8-8454-44f6-a458-3d7ad9b7d69f | 2026-09-18 10:17 | 2026-09-18 10:17 | 2026-09-18 10:17 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 5.2800 | 5.2500 | 5.4000 | 108.0800 | 105600.00 | 0.00 | 105600.00 | 200 | 2 | 500 | 10229 | 0.0488806334930101 | 0.64609186533688 | 0.64609186533688 | false | true | false | true | false | |||||||||||||||
| f2202403-6ace-443c-bbfd-d58adc29744e | 2026-09-16 10:05 | 2026-09-16 10:05 | 2026-09-16 10:05 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 7.0000 | 6.9000 | 7.1000 | 101.6000 | 80500.00 | 3500.00 | 77000.00 | 115 | 35 | 2931 | 11027 | 0.265802122064025 | 0.641933372002187 | 0.642915814130043 | false | false | false | true | ||||||||||||||||
| 3958ad63-859c-40b5-8068-dfbb5cfdf174 | 2026-09-16 10:01 | 2026-09-16 10:00 | 2026-09-16 10:00 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 7.0000 | 7.0000 | 7.1000 | 101.5450 | 66500.00 | 0.00 | 66500.00 | 95 | 19 | 2696 | 11027 | 0.244490795320577 | 0.642015298258279 | 0.642015298258279 | false | false | false | true | false | |||||||||||||||
| 53cdc742-47c5-430f-8beb-b92054dc8407 | 2026-09-16 09:48 | 2026-09-16 09:48 | 2026-09-16 09:48 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 7.0000 | 6.9000 | 7.0000 | 102.1600 | 175000.00 | 175000.00 | 0.00 | 250 | 24 | 2368 | 11027 | 0.21474562437653 | 0.652015385113592 | 0.652015385113592 | true | false | false | true | false | |||||||||||||||
| d31fcca1-7b05-43cc-ab81-b7b2a4341b92 | 2026-09-16 09:42 | 2026-09-16 09:42 | 2026-09-16 09:42 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 6.4500 | 6.4500 | 6.5000 | 104.1900 | 116745.00 | 0.00 | 116745.00 | 181 | 11 | 1860 | 11027 | 0.168676884011971 | 0.651937809793413 | 0.651937809793413 | false | false | false | true | ||||||||||||||||
| 27568ea1-7650-42bd-8418-5440cfacd225 | 2026-08-19 13:42 | 2026-08-19 13:42 | 2026-08-19 13:42 | INTC | INTC261218P00090000 | put | 90.0000 | 2026-12-18 | 11.8000 | 11.6500 | 11.9500 | 93.0200 | 53100.00 | 38940.00 | 14160.00 | 45 | 17 | 1066 | 11308 | 0.0942695436858861 | 0.664386123859741 | 0.664553132134137 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 584750920000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:52:12.020508Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 584750920000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:52:12.020508Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 584750920000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:52:12.020508Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 620412000000.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:42:35.066388Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 620412000000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:30:25.838480Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 618394400000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:21:44.336640Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 618394400000.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:47:22.680410Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 618394400000.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:11:43.770446Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 624749840000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:32:27.895939Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:46:19.788598Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 547778400000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 509696200000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:14:36.942021Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 509696200000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:14:36.942021Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 509696200000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 509696200000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 490226360000.00 |
| 2026-10-22 |
| 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 |