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_alerts566,287 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 |
|---|
| a1714006-709b-4e87-9308-1bda8af5cf08 | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | MRVL | MRVL260821C00235000 | call | 235.0000 | 2026-08-21 | 5.9500 | 5.3500 | 6.0000 | 229.9700 | 53540.00 | 51765.00 | 1185.00 | 90 | 29 | 96 | 4889 | 0.0196359173655144 | 0.842598803706583 | 0.843042491895073 | false | false | false | true | false | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 33ba4ae6-306d-4f64-a3d1-7c33353b5cf7 | 2026-08-17 09:43 | 2026-08-17 09:43 | 2026-08-17 09:43 | MRVL | MRVL260821C00235000 | call | 235.0000 | 2026-08-21 | 9.1600 | 9.0000 | 9.2000 | 235.8000 | 91590.00 | 91590.00 | 0.00 | 100 | 7 | 1189 | 4889 | 0.243199018204132 | 0.889921079321843 | 0.88482430726675 | false | false | false | true | ||||||||||||||||
| 48d63f0f-34f4-4c77-b523-0cc18823b90c | 2026-08-19 09:54 | 2026-08-19 09:54 | 2026-08-19 09:54 | MRVL | MRVL260821C00235000 | call | 235.0000 | 2026-08-21 | 6.1200 | 5.9500 | 6.1500 | 232.3650 | 67920.00 | 46740.00 | 21180.00 | 111 | 13 | 1423 | 5338 | 0.266579243162233 | 1.06227687563037 | 1.06853429171844 | true | false | false | true | ||||||||||||||||
| 64b09cce-cfe8-4761-93d5-b6c38685430a | 2026-08-20 09:59 | 2026-08-20 09:59 | 2026-08-20 09:59 | MRVL | MRVL260821C00235000 | call | 235.0000 | 2026-08-21 | 5.9000 | 5.5000 | 6.2000 | 235.7900 | 141600.00 | 67260.00 | 74340.00 | 240 | 10 | 3383 | 6243 | 0.541886913342944 | 1.12118426372508 | 1.11573559093726 | false | false | false | true | ||||||||||||||||
| 0f1cb094-32ee-4464-a272-82b579516db7 | 2026-08-20 10:00 | 2026-08-20 10:00 | 2026-08-20 10:00 | MRVL | MRVL260821C00235000 | call | 235.0000 | 2026-08-21 | 6.4000 | 6.4000 | 6.6000 | 236.7600 | 100480.00 | 0.00 | 100480.00 | 157 | 9 | 3544 | 6243 | 0.56767579689252 | 1.10903686379368 | 1.10903686379368 | false | false | false | true | ||||||||||||||||
| 9afccc0a-8fe0-4dc3-b76c-a0cbd75b56dc | 2026-08-20 10:45 | 2026-08-20 10:45 | 2026-08-20 10:45 | MRVL | MRVL260821C00235000 | call | 235.0000 | 2026-08-21 | 11.6000 | 11.6000 | 12.0500 | 244.7231 | 112520.00 | 0.00 | 112520.00 | 97 | 6 | 4478 | 6243 | 0.717283357360244 | 1.07424310273506 | 1.07424310273506 | false | false | false | true | ||||||||||||||||
| 3385c2bf-7446-4ac8-a334-f11311f391b2 | 2026-08-20 11:01 | 2026-08-20 11:01 | 2026-08-20 11:01 | MRVL | MRVL260821C00235000 | call | 235.0000 | 2026-08-21 | 12.7500 | 12.7500 | 13.2500 | 246.4700 | 303485.00 | 0.00 | 303485.00 | 238 | 23 | 4999 | 6243 | 0.800736825244274 | 1.00585546252615 | 1.00585546252615 | false | false | false | true | ||||||||||||||||
| f622f571-27bf-4357-a44f-c910fb81c674 | 2026-08-20 11:13 | 2026-08-20 11:13 | 2026-08-20 11:13 | MRVL | MRVL260821C00235000 | call | 235.0000 | 2026-08-21 | 10.3500 | 9.6500 | 10.3500 | 243.4900 | 68310.00 | 68310.00 | 0.00 | 66 | 7 | 5147 | 6243 | 0.824443376581772 | 0.996439477335489 | 0.996439477335489 | true | false | false | true | ||||||||||||||||
| 0cbaadbc-5fda-4793-b836-540610563a4f | 2026-08-21 14:52 | 2026-08-21 14:51 | 2026-08-21 14:51 | MRVL | MRVL260821C00235000 | call | 235.0000 | 2026-08-21 | 2.7600 | 2.7600 | 3.1000 | 237.7800 | 55752.00 | 0.00 | 55752.00 | 202 | 7 | 7351 | 4178 | 1.75945428434658 | 1.16056228716487 | 1.16056228716487 | 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-17T13:54:20.333138Z"} |
| 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-19T14:00:52.208142Z"} |
| 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-20T14:05:52.049536Z"} |
| 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-20T14:05:52.049536Z"} |
| 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-20T14:48:30.894899Z"} |
| 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-20T15:02:58.462752Z"} |
| 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-20T15:16:49.821442Z"} |
| 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-21T19:11:44.414359Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |