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 |
|---|
| fc7b936c-32db-4c26-a5b4-0423fc55fe84 | 2026-09-29 10:52 | 2026-09-29 10:52 | 2026-09-29 10:52 | MRVL | MRVL261218P00220000 | put | 220.0000 | 2026-12-18 | 13.0500 | 12.7500 | 13.5500 | 261.6500 | 41760.00 | 40455.00 | 1305.00 | 32 | 7 | 40 | 3390 | 0.0117994100294985 | 0.673775276102636 | 0.673775276102636 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 230861463000.00 | 2026-12-01 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T14:54:53.700318Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 75f8c773-e270-4d74-b1bb-998c80dae13c | 2026-09-28 10:09 | 2026-09-28 10:09 | 2026-09-28 10:09 | MRVL | MRVL261218P00220000 | put | 220.0000 | 2026-12-18 | 14.6600 | 14.5500 | 15.0500 | 254.2350 | 38124.00 | 23520.00 | 14604.00 | 26 | 11 | 92 | 3327 | 0.0276525398256688 | 0.663884725237977 | 0.662851174120133 | true | false | false | true | ||||||||||||||||
| 3755a375-4f9d-49fc-b51f-141c6836679a | 2026-09-28 09:45 | 2026-09-28 09:45 | 2026-09-28 09:45 | MRVL | MRVL261218P00220000 | put | 220.0000 | 2026-12-18 | 15.0900 | 13.6500 | 15.2000 | 252.9650 | 36205.00 | 4510.00 | 31695.00 | 24 | 6 | 50 | 3327 | 0.0150285542530809 | 0.664624685971519 | 0.667193006446579 | false | false | false | true | ||||||||||||||||
| 395a4710-533f-4589-bf28-5faed20fc3c4 | 2026-09-23 10:01 | 2026-09-23 10:01 | 2026-09-23 10:01 | MRVL | MRVL261218P00220000 | put | 220.0000 | 2026-12-18 | 13.8700 | 13.7500 | 14.6500 | 263.0000 | 23585.00 | 8320.00 | 15265.00 | 17 | 9 | 18 | 3318 | 0.0054249547920434 | 0.679168477742161 | 0.679643893729912 | false | false | false | true | ||||||||||||||||
| b9fbded5-2c87-4015-b701-38c3b12cfde7 | 2026-09-22 14:15 | 2026-09-22 14:15 | 2026-09-22 14:15 | MRVL | MRVL261218P00220000 | put | 220.0000 | 2026-12-18 | 14.0000 | 14.0000 | 14.4000 | 263.5300 | 35000.00 | 0.00 | 35000.00 | 25 | 8 | 157 | 3263 | 0.0481152313821637 | 0.68265933856887 | 0.68265933856887 | false | false | false | true | false | |||||||||||||||
| 6769cfc8-20c3-438a-b061-5b1ecb4d2df4 | 2026-09-21 13:54 | 2026-09-21 13:54 | 2026-09-21 13:54 | MRVL | MRVL261218P00220000 | put | 220.0000 | 2026-12-18 | 16.3000 | 16.1000 | 16.3500 | 256.1800 | 42387.00 | 40757.00 | 1630.00 | 26 | 11 | 39 | 3296 | 0.0118325242718447 | 0.691944981993736 | 0.691453489083856 | true | false | false | true | ||||||||||||||||
| 10f304d5-2252-4840-86d1-b7c06f26fb82 | 2026-09-08 14:37 | 2026-09-08 14:37 | 2026-09-08 14:37 | MRVL | MRVL261218P00220000 | put | 220.0000 | 2026-12-18 | 26.0500 | 26.0500 | 26.4500 | 228.7900 | 377741.00 | 0.00 | 377741.00 | 145 | 36 | 450 | 2127 | 0.211565585331453 | 0.672704611072689 | 0.672704611072689 | false | false | false | true | ||||||||||||||||
| 0347fb5b-9b1e-407f-b006-5e62bb104a51 | 2026-09-08 13:40 | 2026-09-08 13:40 | 2026-09-08 13:40 | MRVL | MRVL261218P00220000 | put | 220.0000 | 2026-12-18 | 26.1500 | 26.1500 | 26.4500 | 229.1900 | 311190.00 | 0.00 | 311190.00 | 119 | 23 | 135 | 2127 | 0.0634696755994358 | 0.678173355228754 | 0.678173355228754 | false | false | false | true | ||||||||||||||||
| a0b90d45-26b9-4007-b3ad-e0e562b87d4f | 2026-09-04 15:34 | 2026-09-04 15:33 | 2026-09-04 15:33 | MRVL | MRVL261218P00220000 | put | 220.0000 | 2026-12-18 | 27.8500 | 27.8500 | 28.3000 | 222.2550 | 150390.00 | 0.00 | 150390.00 | 54 | 9 | 342 | 2222 | 0.153915391539154 | 0.644562875983575 | 0.644562875983575 | false | false | false | true | ||||||||||||||||
| 76c4ecfb-3312-445e-8c69-c95c4d1b2683 | 2026-09-04 11:40 | 2026-09-04 11:40 | 2026-09-04 11:40 | MRVL | MRVL261218P00220000 | put | 220.0000 | 2026-12-18 | 27.9500 | 27.9500 | 28.4000 | 220.1750 | 668015.00 | 0.00 | 668015.00 | 239 | 36 | 252 | 2222 | 0.113411341134113 | 0.628141189001329 | 0.628141189001329 | false | false | false | true | ||||||||||||||||
| 45d25344-5c58-43f1-a326-27dd421c418e | 2026-08-19 12:51 | 2026-08-19 12:50 | 2026-08-19 12:50 | MRVL | MRVL261218P00220000 | put | 220.0000 | 2026-12-18 | 31.8000 | 31.8000 | 32.5500 | 235.7710 | 979440.00 | 0.00 | 979440.00 | 308 | 11 | 387 | 2109 | 0.183499288762447 | 0.784339277511453 | 0.784339277511453 | false | false | false | true | ||||||||||||||||
| 202dc68b-0577-4735-a38e-0354295b23b7 | 2026-08-19 12:33 | 2026-08-19 12:33 | 2026-08-19 12:33 | MRVL | MRVL261218P00220000 | put | 220.0000 | 2026-12-18 | 31.7300 | 31.6750 | 32.6000 | 236.3400 | 82485.00 | 0.00 | 50785.00 | 26 | 7 | 67 | 2109 | 0.0317686107159791 | 0.786221850390951 | 0.786221850390951 | true | false | false | true | false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 220891110000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:11:27.545413Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 220891110000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:45:28.249714Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 228783210000.00 |
| 2026-12-01 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:02:33.967509Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 230063484000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 225696522000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:55:32.885478Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 191883258000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:43:21.019108Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 191883258000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:42:35.153326Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 191883258000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:47:04.296573Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 191883258000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:46:11.944585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 191883258000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 191883258000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |