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 |
|---|
| 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 |
|---|
| d40337c4-2dd9-4056-be36-57f1ff730e22 | 2026-08-17 09:43 | 2026-08-17 09:42 | 2026-08-17 09:42 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 3.6500 | 3.6000 | 3.8000 | 235.2146 | 54755.00 | 3650.00 | 51105.00 | 150 | 37 | 2382 | 15548 | 0.153202984306663 | 0.907232874243463 | 0.907232874243463 | 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-17T13:54:20.333138Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2944e431-1530-47c4-a0b2-349f8555652d | 2026-08-17 11:37 | 2026-08-17 11:37 | 2026-08-17 11:37 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 4.4000 | 4.2000 | 4.4000 | 239.5000 | 51465.00 | 51465.00 | 0.00 | 117 | 65 | 8213 | 15548 | 0.528235142783638 | 0.854424850433668 | 0.843802056826908 | true | false | false | true | ||||||||||||||||
| 41d22507-8154-4709-8a0f-02535e6a2b33 | 2026-08-17 14:10 | 2026-08-17 14:10 | 2026-08-17 14:10 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 3.2000 | 3.2000 | 3.3000 | 235.0000 | 116490.00 | 0.00 | 116490.00 | 364 | 54 | 9968 | 15548 | 0.64111139696424 | 0.847233730788465 | 0.847233730788465 | false | false | false | true | ||||||||||||||||
| a687aa83-812a-49d8-9a85-f2d02c0af95b | 2026-08-19 09:32 | 2026-08-19 09:32 | 2026-08-19 09:32 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 4.6700 | 4.4000 | 4.7500 | 241.0400 | 93450.00 | 93450.00 | 0.00 | 200 | 5 | 2613 | 15199 | 0.171919205210869 | 1.16485989310274 | 1.1521030293213 | false | false | false | true | ||||||||||||||||
| d3b8f0f0-0e38-48f8-b81b-b90ddc87fe59 | 2026-08-19 09:34 | 2026-08-19 09:34 | 2026-08-19 09:34 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 4.7600 | 4.7000 | 5.0500 | 242.0450 | 57120.00 | 0.00 | 57120.00 | 120 | 6 | 4275 | 15199 | 0.281268504506875 | 1.11773770584823 | 1.11476547493305 | false | false | false | true | ||||||||||||||||
| ba947097-a257-4c7a-83bd-005590ac7a18 | 2026-08-19 09:38 | 2026-08-19 09:38 | 2026-08-19 09:38 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 3.1000 | 2.8800 | 3.1000 | 236.0050 | 154990.00 | 154990.00 | 0.00 | 500 | 11 | 5935 | 15199 | 0.390486216198434 | 1.13537594347378 | 1.1529338757813 | false | false | false | true | ||||||||||||||||
| 5a65780d-4327-47ad-a1b8-3d4957aa94ad | 2026-08-19 09:48 | 2026-08-19 09:48 | 2026-08-19 09:48 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 3.1000 | 3.1000 | 3.4000 | 238.5300 | 128960.00 | 0.00 | 128960.00 | 416 | 21 | 7831 | 15199 | 0.515231265214817 | 1.02191676286584 | 1.03474055372101 | false | false | false | true | ||||||||||||||||
| 5a144bc4-077d-4805-bee7-fb4694dc257c | 2026-08-19 10:09 | 2026-08-19 10:09 | 2026-08-19 10:09 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 1.0800 | 1.0800 | 1.2000 | 229.0000 | 64810.00 | 0.00 | 64810.00 | 600 | 10 | 9762 | 15199 | 0.642279097309034 | 1.02815188227585 | 1.01430644764243 | false | false | false | true | ||||||||||||||||
| e7cb8af8-0568-47ec-b3a8-44991968ac46 | 2026-08-19 10:43 | 2026-08-19 10:43 | 2026-08-19 10:43 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 2.0000 | 1.9100 | 2.0200 | 234.7700 | 94870.00 | 52000.00 | 42870.00 | 475 | 5 | 12245 | 15199 | 0.805645108230805 | 1.00315700953953 | 0.9991577652312 | false | false | false | true | ||||||||||||||||
| d22b9ea3-38d1-4a6a-92b4-20ac34145040 | 2026-08-19 11:04 | 2026-08-19 11:04 | 2026-08-19 11:04 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 1.2100 | 1.1800 | 1.2700 | 230.9450 | 71351.00 | 0.00 | 19926.00 | 591 | 9 | 13223 | 15199 | 0.869991446805711 | 0.975079561659331 | 0.977645586279516 | true | false | false | true | ||||||||||||||||
| ad9c71fb-e302-4a51-93f3-975b87f1455e | 2026-08-20 09:32 | 2026-08-20 09:32 | 2026-08-20 09:32 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 4.4000 | 4.1500 | 4.8000 | 245.3300 | 227110.00 | 115065.00 | 112045.00 | 516 | 34 | 2144 | 16703 | 0.128360174818895 | 1.23339631215505 | 1.23899906925753 | true | false | false | true | ||||||||||||||||
| 4e370344-3f75-4c8b-a490-100a00f63b6d | 2026-08-20 09:37 | 2026-08-20 09:37 | 2026-08-20 09:37 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 3.6900 | 3.5000 | 3.8500 | 244.5450 | 73765.00 | 47922.00 | 25843.00 | 200 | 7 | 4161 | 16703 | 0.249116925103275 | 1.18047186837625 | 1.17632240983009 | false | false | false | true | ||||||||||||||||
| 81706caf-978f-400c-9ad1-996d535671a3 | 2026-08-20 09:38 | 2026-08-20 09:38 | 2026-08-20 09:38 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 4.0400 | 3.7500 | 4.1000 | 245.2300 | 80750.00 | 80750.00 | 0.00 | 200 | 5 | 4544 | 16703 | 0.272046937675867 | 1.18227484134201 | 1.18222691297858 | false | false | false | true | ||||||||||||||||
| 7460041a-073f-46f9-ab9d-9444b9993e69 | 2026-08-20 09:39 | 2026-08-20 09:39 | 2026-08-20 09:39 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 3.6700 | 3.5000 | 3.9000 | 244.0100 | 73470.00 | 0.00 | 73470.00 | 200 | 7 | 4856 | 16703 | 0.290726216847273 | 1.18985214594774 | 1.20049981382157 | false | false | false | true | ||||||||||||||||
| bb80fda1-43b5-4123-b95f-297172cd0f1f | 2026-08-20 10:27 | 2026-08-20 10:27 | 2026-08-20 10:27 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 3.8200 | 3.6000 | 3.9000 | 245.5200 | 76444.00 | 76444.00 | 0.00 | 200 | 7 | 8989 | 16703 | 0.538166796383883 | 1.11462901471535 | 1.11868417407797 | false | false | false | true | ||||||||||||||||
| 484f43fe-ad11-4f36-be9d-97d6246a83ec | 2026-08-20 10:27 | 2026-08-20 10:27 | 2026-08-20 10:27 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 3.2800 | 3.0000 | 3.5500 | 244.4550 | 65885.00 | 49535.00 | 16350.00 | 201 | 7 | 9204 | 16703 | 0.551038735556487 | 1.08754997917554 | 1.08545667503367 | false | false | false | true | ||||||||||||||||
| 2da65b2a-9443-4377-9c2a-2f7717b59d45 | 2026-08-20 10:28 | 2026-08-20 10:28 | 2026-08-20 10:28 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 3.8800 | 3.7000 | 3.9500 | 245.6550 | 77500.00 | 77500.00 | 0.00 | 200 | 7 | 9440 | 16703 | 0.565167933904089 | 1.11606203473943 | 1.11606203473943 | false | false | false | true | ||||||||||||||||
| a8e33947-9c50-46e7-86a8-8e315e2d6aa2 | 2026-08-20 10:29 | 2026-08-20 10:28 | 2026-08-20 10:28 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 3.4700 | 3.4000 | 3.7000 | 244.8750 | 69330.00 | 0.00 | 69330.00 | 200 | 8 | 9694 | 16703 | 0.580374782973119 | 1.10350800574994 | 1.09318339506849 | false | false | false | true | ||||||||||||||||
| d123739d-75b0-46ef-b342-e0ff32310336 | 2026-08-20 14:48 | 2026-08-20 14:47 | 2026-08-20 14:47 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 2.3000 | 2.2200 | 2.3200 | 244.5250 | 108099.00 | 229.00 | 46230.00 | 470 | 9 | 16622 | 16703 | 0.995150571753577 | 0.873764532065301 | 0.871587845733617 | true | false | false | true | ||||||||||||||||
| 16294da5-e68c-488a-992b-3af94f75a1f7 | 2026-08-20 15:03 | 2026-08-20 15:03 | 2026-08-20 15:03 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 3.3000 | 3.1500 | 3.3500 | 247.0700 | 80900.00 | 80900.00 | 0.00 | 245 | 14 | 17385 | 16703 | 1.04083098844519 | 0.889860119778037 | 0.887870840677264 | true | false | false | true | ||||||||||||||||
| 4f799f5c-b3f4-4ec0-9476-1d093be84ff1 | 2026-08-20 15:04 | 2026-08-20 15:04 | 2026-08-20 15:04 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 3.1800 | 3.0500 | 3.3500 | 246.9000 | 63550.00 | 0.00 | 63550.00 | 200 | 6 | 17802 | 16703 | 1.06579656349159 | 0.878324758072843 | 0.877711514536766 | false | false | false | true | ||||||||||||||||
| fdf5f0e9-4d97-442e-9c2b-122831b11f6a | 2026-08-21 09:31 | 2026-08-21 09:30 | 2026-08-21 09:30 | MRVL | MRVL260821C00250000 | call | 250.0000 | 2026-08-21 | 4.1400 | 4.0500 | 4.6500 | 251.6800 | 64245.00 | 26160.00 | 36445.00 | 155 | 50 | 419 | 14654 | 0.0285928756653473 | 1.18887720544336 | 1.17010253427882 | true | false | false | true |
| 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-17T15:40:30.458422Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} |
| 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-19T13:32:56.078945Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-19T13:40:44.275238Z"} |
| 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-19T13:40:44.275238Z"} |
| 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-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-19T14:11:54.267551Z"} |
| 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-19T14:50:22.027850Z"} |
| 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-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-20T13:35:56.061771Z"} |
| 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-20T13:45:25.718532Z"} |
| 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-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-20T13:45:25.718532Z"} |
| 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-20T14:33:56.503993Z"} |
| 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:33:56.503993Z"} |
| 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-20T14:33:56.503993Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-20T14:33:56.503993Z"} |
| 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-20T19:16:26.699237Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-20T19:16:26.699237Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-20T19:16:26.699237Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-21T13:35:10.222979Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |