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.
Simplify Analyticsuw_flow_alerts474,253 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 |
|---|
| 8d103f5e-7a2d-4714-af15-4c9124e6adb9 | 2026-08-27 10:48 | 2026-08-27 10:48 | 2026-08-27 10:48 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 29.1500 | 29.0500 | 29.7500 | 244.5600 | 131196.00 | 43800.00 | 87396.00 | 45 | 7 | 618 | 1582 | 0.390644753476612 | 0.735690012800442 | 0.733777615342495 | true | false | false | true | false | 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-27T14:49:52.356548Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4cfa9e07-2591-4173-94c0-7236ce154b4e | 2026-08-27 10:48 | 2026-08-27 10:48 | 2026-08-27 10:48 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 29.1400 | 29.0000 | 29.9500 | 244.4800 | 1558915.00 | 323725.00 | 1235190.00 | 535 | 14 | 570 | 1582 | 0.360303413400759 | 0.735062650506241 | 0.739748922489135 | true | false | false | true | ||||||||||||||||
| fb7e492d-40c3-4afd-bc6b-075fa0901b70 | 2026-09-14 15:31 | 2026-09-14 15:30 | 2026-09-14 15:30 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 11.9100 | 11.9000 | 12.7500 | 220.8200 | 154789.00 | 0.00 | 154789.00 | 130 | 8 | 242 | 2163 | 0.111881645862228 | 0.651065642822193 | 0.651355211844756 | false | false | false | true | ||||||||||||||||
| 8d9d8931-31a8-48cd-bde7-439cdc97d782 | 2026-09-17 10:06 | 2026-09-17 10:06 | 2026-09-17 10:06 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 20.7200 | 20.6000 | 21.0500 | 243.0600 | 178186.00 | 0.00 | 178186.00 | 86 | 5 | 131 | 2230 | 0.0587443946188341 | 0.661335930328716 | 0.661582973329437 | false | false | false | true | ||||||||||||||||
| 65277fce-68f5-4a92-a24c-b3eff5ea9471 | 2026-09-17 10:08 | 2026-09-17 10:08 | 2026-09-17 10:08 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 19.7500 | 19.7000 | 20.2500 | 241.0500 | 69115.00 | 1975.00 | 67140.00 | 35 | 7 | 168 | 2230 | 0.0753363228699552 | 0.661837266973723 | 0.659339103590062 | true | false | false | true | ||||||||||||||||
| 1b53b8c8-d7f8-4d18-954c-580bdc2c492f | 2026-09-17 11:12 | 2026-09-17 11:12 | 2026-09-17 11:12 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 19.4500 | 19.4000 | 19.8500 | 240.7100 | 56405.00 | 46680.00 | 9725.00 | 29 | 6 | 220 | 2230 | 0.0986547085201794 | 0.656955662189648 | 0.656955662189648 | true | false | false | true | ||||||||||||||||
| 134823d3-5a1a-4ac5-b9a0-b42d9b492d55 | 2026-09-17 15:53 | 2026-09-17 15:53 | 2026-09-17 15:53 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 19.2000 | 19.2000 | 19.9500 | 241.0000 | 485800.00 | 5790.00 | 480010.00 | 253 | 45 | 584 | 2230 | 0.261883408071749 | 0.645141399692025 | 0.647639719058437 | false | false | false | true | ||||||||||||||||
| 5edbd1bf-abd5-4e2c-9381-0a3926389fa5 | 2026-09-21 11:03 | 2026-09-21 11:02 | 2026-09-21 11:02 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 26.0000 | 25.7500 | 26.1000 | 253.7500 | 129997.00 | 111797.00 | 18200.00 | 50 | 9 | 417 | 2485 | 0.167806841046278 | 0.683093960166158 | 0.683093960166158 | false | false | false | true | ||||||||||||||||
| 52740b7a-b468-4fc2-aa4f-601abbbfe676 | 2026-09-21 12:54 | 2026-09-21 12:54 | 2026-09-21 12:54 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 26.3600 | 26.0500 | 26.7500 | 254.0000 | 73811.00 | 0.00 | 71171.00 | 28 | 7 | 887 | 2485 | 0.356941649899396 | 0.676556212619687 | 0.678380609704313 | false | false | false | true | ||||||||||||||||
| 46ea75d5-b4e6-464f-9cf1-492ef18eb2ba | 2026-09-21 15:30 | 2026-09-21 15:30 | 2026-09-21 15:30 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 29.2100 | 29.1500 | 29.7500 | 259.2100 | 35050.00 | 5850.00 | 29200.00 | 12 | 6 | 1148 | 2485 | 0.461971830985915 | 0.68848211987684 | 0.689688702646178 | false | false | false | true | ||||||||||||||||
| 4afd1f62-b782-489f-9ba1-fdc1e37a1859 | 2026-09-21 15:46 | 2026-09-21 15:46 | 2026-09-21 15:46 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 29.4900 | 29.3000 | 29.7000 | 259.8050 | 14745.00 | 2950.00 | 8845.00 | 5 | 5 | 1184 | 2485 | 0.476458752515091 | 0.687648119652074 | 0.686442815736689 | true | false | false | true | ||||||||||||||||
| 657d122e-6b6e-4e98-be0a-1cdbbbd34ca8 | 2026-09-23 09:42 | 2026-09-23 09:42 | 2026-09-23 09:42 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 30.4800 | 29.8500 | 30.6500 | 263.3100 | 45720.00 | 24395.00 | 21325.00 | 15 | 9 | 38 | 2759 | 0.0137731061978978 | 0.676620211442351 | 0.675485816187382 | true | false | false | true | ||||||||||||||||
| e30041f3-4eae-40de-8f83-960f470802fd | 2026-09-23 12:09 | 2026-09-23 12:09 | 2026-09-23 12:09 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 27.6400 | 27.1500 | 27.6500 | 259.1350 | 16585.00 | 16585.00 | 0.00 | 6 | 6 | 669 | 2759 | 0.242479159115622 | 0.663943620656311 | 0.662717648050458 | true | false | false | true | ||||||||||||||||
| 988b7511-ee39-4d2d-8f63-b75b5c8926cd | 2026-09-24 09:33 | 2026-09-24 09:32 | 2026-09-24 09:32 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 24.4000 | 24.1500 | 25.2000 | 253.6501 | 129305.00 | 44085.00 | 85220.00 | 53 | 10 | 55 | 2979 | 0.018462571332662 | 0.660473924795476 | 0.661726571053558 | true | false | false | true | ||||||||||||||||
| d8323330-cac1-4ade-96b9-6dbc339fbd0a | 2026-09-24 09:39 | 2026-09-24 09:39 | 2026-09-24 09:39 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 27.0800 | 26.3500 | 27.2500 | 258.1200 | 37910.00 | 21690.00 | 16220.00 | 14 | 7 | 87 | 2979 | 0.0292044310171198 | 0.671572930783237 | 0.670333904565016 | true | false | false | true | ||||||||||||||||
| 6dda6674-f065-4874-ba46-1d00bc4493d8 | 2026-09-24 09:39 | 2026-09-24 09:39 | 2026-09-24 09:39 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 27.0600 | 26.4000 | 27.1500 | 258.1200 | 21645.00 | 18940.00 | 2705.00 | 8 | 5 | 95 | 2979 | 0.0318898959382343 | 0.667855972506308 | 0.670333904565016 | true | false | false | true | ||||||||||||||||
| 5a198363-6550-455e-b89a-8b328ef26b69 | 2026-09-25 11:04 | 2026-09-25 11:04 | 2026-09-25 11:04 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 28.3000 | 28.2000 | 28.4500 | 262.4598 | 104710.00 | 101880.00 | 2830.00 | 37 | 6 | 144 | 2991 | 0.0481444332998997 | 0.645298047772275 | 0.645298047772275 | false | false | false | true | ||||||||||||||||
| 9f2508b9-9341-4691-a2d3-68214d767b32 | 2026-09-25 14:07 | 2026-09-25 14:07 | 2026-09-25 14:07 | MRVL | MRVL261120C00260000 | call | 260.0000 | 2026-11-20 | 29.9500 | 29.8000 | 30.3500 | 264.0000 | 23960.00 | 5990.00 | 17970.00 | 8 | 5 | 254 | 2991 | 0.0849214309595453 | 0.653831027167817 | 0.653831027167817 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 191883258000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:49:52.356548Z"} |
| 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-14T19:44:36.941159Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 211122444000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:07:38.635762Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 211122444000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 211122444000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 211122444000.00 |
| 2026-12-01 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 225696522000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:05:23.809831Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 225696522000.00 |
| 2026-12-01 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 225696522000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 225696522000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:46:53.809312Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 228783210000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 228783210000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:13:15.432740Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 228783210000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:34:09.637313Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 228783210000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:40:59.800251Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 228783210000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:40:59.800251Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 229690801500.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:05:27.463808Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 229690801500.00 |
| 2026-12-01 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:10:19.042064Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |