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 |
|---|
| af927641-e371-4830-8246-46a1ba76d188 | 2026-08-25 09:58 | 2026-08-25 09:58 | 2026-08-25 09:58 | MRVL | MRVL261016P00240000 | put | 240.0000 | 2026-10-16 | 25.6000 | 25.3500 | 25.8000 | 245.0550 | 53760.00 | 40960.00 | 12800.00 | 21 | 6 | 51 | 2333 | 0.0218602657522503 | 0.789942953377574 | 0.789942953377574 | false | 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-25T14:12:03.649618Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d0d13f0d-25d9-4487-b8ef-c25d9d55508f | 2026-08-25 12:41 | 2026-08-25 12:41 | 2026-08-25 12:41 | MRVL | MRVL261016P00240000 | put | 240.0000 | 2026-10-16 | 26.4000 | 26.0500 | 26.8500 | 242.1550 | 588715.00 | 440880.00 | 147835.00 | 223 | 21 | 445 | 2333 | 0.190741534504929 | 0.778740547402869 | 0.778740547402869 | false | false | false | |||||||||||||||||
| 4e8db1e6-5c18-4f04-a8af-41bd9be189cc | 2026-08-28 09:52 | 2026-08-28 09:52 | 2026-08-28 09:52 | MRVL | MRVL261016P00240000 | put | 240.0000 | 2026-10-16 | 32.0000 | 31.4000 | 32.0000 | 220.9550 | 96000.00 | 96000.00 | 0.00 | 30 | 6 | 66 | 3225 | 0.0204651162790698 | 0.655124824078344 | 0.655124824078344 | false | false | false | |||||||||||||||||
| c92067e4-af19-436c-aa72-897ddb7113fc | 2026-09-21 13:43 | 2026-09-21 13:43 | 2026-09-21 13:43 | MRVL | MRVL261016P00240000 | put | 240.0000 | 2026-10-16 | 11.2500 | 11.2000 | 11.2500 | 254.7500 | 83250.00 | 83250.00 | 0.00 | 74 | 18 | 354 | 3838 | 0.092235539343408 | 0.695414301794132 | 0.695414301794132 | true | false | false | |||||||||||||||||
| 85db53a3-f5cd-410c-b2c1-a0f5774db7ac | 2026-09-21 14:23 | 2026-09-21 14:23 | 2026-09-21 14:23 | MRVL | MRVL261016P00240000 | put | 240.0000 | 2026-10-16 | 10.1000 | 10.1000 | 10.3500 | 258.9000 | 44440.00 | 0.00 | 44440.00 | 44 | 6 | 447 | 3838 | 0.11646690984888 | 0.702308684315576 | 0.702308684315576 | true | false | false | true | ||||||||||||||||
| 900c341a-9894-4ff2-a316-17e243a72c3f | 2026-09-21 15:41 | 2026-09-21 15:41 | 2026-09-21 15:41 | MRVL | MRVL261016P00240000 | put | 240.0000 | 2026-10-16 | 9.6000 | 9.5000 | 9.7500 | 260.3600 | 23040.00 | 5760.00 | 17280.00 | 24 | 8 | 627 | 3838 | 0.163366336633663 | 0.699438080627279 | 0.699438080627279 | false | false | false | |||||||||||||||||
| 76a2d732-7a46-4923-a92e-de7ebfef4a2e | 2026-09-21 15:41 | 2026-09-21 15:41 | 2026-09-21 15:41 | MRVL | MRVL261016P00240000 | put | 240.0000 | 2026-10-16 | 9.6000 | 9.6000 | 9.7500 | 260.3600 | 23040.00 | 0.00 | 23040.00 | 24 | 8 | 651 | 3838 | 0.169619593538301 | 0.699438080627279 | 0.699438080627279 | false | false | false | true | ||||||||||||||||
| 027567f8-ce7a-49bb-8484-7b1ef49ba582 | 2026-09-21 15:41 | 2026-09-21 15:41 | 2026-09-21 15:41 | MRVL | MRVL261016P00240000 | put | 240.0000 | 2026-10-16 | 9.6000 | 9.5500 | 9.7500 | 260.4200 | 17280.00 | 0.00 | 17280.00 | 18 | 6 | 669 | 3838 | 0.17430953621678 | 0.699438080627279 | 0.700184811804793 | false | false | false | true | ||||||||||||||||
| 0d73a977-e59a-458f-95c9-3cd2ea6c8e17 | 2026-09-23 10:10 | 2026-09-23 10:10 | 2026-09-23 10:10 | MRVL | MRVL261016P00240000 | put | 240.0000 | 2026-10-16 | 8.5500 | 8.1500 | 8.5500 | 259.6400 | 26505.00 | 26505.00 | 0.00 | 31 | 15 | 120 | 3882 | 0.0309119010819165 | 0.67195399957307 | 0.67195399957307 | true | false | false | true | ||||||||||||||||
| 1132bf44-af42-4602-8187-12a4d47350f2 | 2026-09-23 11:47 | 2026-09-23 11:47 | 2026-09-23 11:47 | MRVL | MRVL261016P00240000 | put | 240.0000 | 2026-10-16 | 8.6000 | 8.2000 | 8.6000 | 259.0000 | 12900.00 | 12900.00 | 0.00 | 15 | 7 | 205 | 3882 | 0.0528078310149407 | 0.673176062356259 | 0.672658920835274 | true | false | false | true | ||||||||||||||||
| 385c06cb-9075-4c40-85b5-c9c10e20b0d5 | 2026-09-24 09:44 | 2026-09-24 09:44 | 2026-09-24 09:44 | MRVL | MRVL261016P00240000 | put | 240.0000 | 2026-10-16 | 8.5000 | 8.2000 | 8.9000 | 259.1250 | 11900.00 | 850.00 | 11050.00 | 14 | 10 | 29 | 3895 | 0.00744544287548139 | 0.677566577765124 | 0.677566577765124 | false | false | false | |||||||||||||||||
| 47842a87-c326-4827-9838-af3c89736639 | 2026-09-29 10:12 | 2026-09-29 10:11 | 2026-09-29 10:11 | MRVL | MRVL261016P00240000 | put | 240.0000 | 2026-10-16 | 7.1500 | 7.1000 | 7.2000 | 259.0000 | 80080.00 | 77220.00 | 2860.00 | 112 | 19 | 167 | 4410 | 0.0378684807256236 | 0.698030203344561 | 0.698030203344561 | true | false | false |
| 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-25T16:59:46.608693Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-28T13:57:11.446067Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-21T17:43:51.748700Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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-21T18:23:56.707397Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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:43:03.886437Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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:43:03.886437Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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:43:03.886437Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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-23T14:10:43.742349Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-23T15:51:01.874824Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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-24T13:45:09.673618Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 230861463000.00 |
| 2026-12-01 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:13:29.737020Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |