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 |
|---|
| 92bb7c3d-f5ea-4858-9f56-18011623a18c | 2026-09-29 14:21 | 2026-09-29 14:21 | 2026-09-29 14:21 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 9.4400 | 9.4000 | 9.5500 | 262.0000 | 36804.00 | 0.00 | 36804.00 | 39 | 10 | 145 | 6060 | 0.0239273927392739 | 0.672583359514737 | 0.670730397617906 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 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-29T18:25:38.236356Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 7fbb7965-fdb8-4bce-a8e8-4d3517c64760 | 2026-09-25 15:59 | 2026-09-25 15:59 | 2026-09-25 15:59 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 9.9000 | 9.9000 | 10.2000 | 261.0000 | 33662.00 | 0.00 | 33662.00 | 34 | 11 | 251 | 6092 | 0.0412015758371635 | 0.664898283342621 | 0.664898283342621 | false | false | false | true | ||||||||||||||||
| 78bdb950-26c8-4ee6-8dac-4cf11b7cfc7b | 2026-09-25 11:03 | 2026-09-25 11:03 | 2026-09-25 11:03 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 10.0000 | 9.7000 | 10.0000 | 262.1800 | 24000.00 | 24000.00 | 0.00 | 24 | 11 | 112 | 6092 | 0.0183847669074196 | 0.665614523669956 | 0.665614523669956 | true | false | false | true | ||||||||||||||||
| dd85552b-ff49-44cc-b4b3-320008c3fcbe | 2026-09-25 09:37 | 2026-09-25 09:37 | 2026-09-25 09:37 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 10.6600 | 10.6000 | 11.1000 | 263.0000 | 20245.00 | 1065.00 | 19180.00 | 19 | 10 | 58 | 6092 | 0.00952068286277085 | 0.674718267443237 | 0.674718267443237 | true | false | false | true | ||||||||||||||||
| 72b3583b-9894-4360-a43d-71f5828455d9 | 2026-09-24 09:39 | 2026-09-24 09:39 | 2026-09-24 09:39 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 10.0000 | 9.4500 | 10.0500 | 258.1200 | 16000.00 | 14000.00 | 2000.00 | 16 | 11 | 31 | 6059 | 0.00511635583429609 | 0.69192059325091 | 0.69192059325091 | true | false | false | true | ||||||||||||||||
| d8698cdc-6229-447d-b82f-b9c473f05eab | 2026-09-23 10:13 | 2026-09-23 10:13 | 2026-09-23 10:13 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 9.8500 | 9.8500 | 10.2000 | 258.0000 | 985000.00 | 0.00 | 985000.00 | 1000 | 6 | 2529 | 7155 | 0.353459119496855 | 0.678014886589477 | 0.678014886589477 | false | false | false | true | ||||||||||||||||
| 7c7e40fb-7620-4c55-9c4f-daf7a844b4fc | 2026-09-23 10:10 | 2026-09-23 10:10 | 2026-09-23 10:10 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 10.1500 | 10.1500 | 10.7000 | 259.0000 | 1525166.00 | 4118.00 | 1521048.00 | 1502 | 86 | 1528 | 7155 | 0.213556953179595 | 0.680369796143999 | 0.69056460966644 | true | false | false | true | ||||||||||||||||
| b7c02e41-158b-43e3-ad0c-aac619ade7d8 | 2026-09-21 15:30 | 2026-09-21 15:30 | 2026-09-21 15:30 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 11.7000 | 11.6500 | 12.0500 | 259.1300 | 15215.00 | 2345.00 | 12870.00 | 13 | 7 | 3445 | 6067 | 0.567825943629471 | 0.713653148392825 | 0.714295357067461 | true | false | false | true | ||||||||||||||||
| 19b9dbbd-a217-4432-b926-ebd1ca0a5344 | 2026-09-21 15:00 | 2026-09-21 15:00 | 2026-09-21 15:00 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 11.7000 | 11.6500 | 11.8000 | 259.2325 | 44460.00 | 43290.00 | 1170.00 | 38 | 14 | 3412 | 6067 | 0.562386682050437 | 0.713412339969209 | 0.713472541062815 | true | false | false | true | ||||||||||||||||
| a92505df-5a34-4282-ab11-f85f2ec89f91 | 2026-09-21 12:21 | 2026-09-21 12:21 | 2026-09-21 12:21 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 9.9500 | 9.9500 | 10.3000 | 254.2700 | 49750.00 | 0.00 | 49750.00 | 50 | 9 | 3116 | 6067 | 0.513598153947585 | 0.70223809935614 | 0.70223809935614 | false | false | false | true | ||||||||||||||||
| de1b222b-6cab-4304-824f-86400bbd20c4 | 2026-09-09 15:37 | 2026-09-09 15:36 | 2026-09-09 15:36 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 7.5500 | 7.5000 | 7.8000 | 234.8400 | 1699568.00 | 1515.00 | 612363.00 | 2251 | 28 | 7811 | 3761 | 2.07684126562085 | 0.7039784404236 | 0.704118016973351 | false | false | false | true | ||||||||||||||||
| e8deaca0-b081-41e0-be09-ef841d145fb0 | 2026-09-09 13:41 | 2026-09-09 13:41 | 2026-09-09 13:41 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 7.8500 | 7.8500 | 8.2000 | 235.9100 | 166420.00 | 0.00 | 166420.00 | 212 | 10 | 5226 | 3761 | 1.38952406274927 | 0.706526962479121 | 0.706526962479121 | false | false | false | true | ||||||||||||||||
| eeecb126-62c5-42e6-8a60-5044557372bc | 2026-09-09 13:41 | 2026-09-09 13:41 | 2026-09-09 13:41 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 8.0000 | 7.9500 | 8.2000 | 235.9800 | 632808.00 | 133600.00 | 499208.00 | 791 | 29 | 4914 | 3761 | 1.30656740228663 | 0.712985081401132 | 0.710921099658012 | false | false | false | true | ||||||||||||||||
| e09002a9-8716-460b-8f89-c1089dc804cd | 2026-09-09 13:41 | 2026-09-09 13:41 | 2026-09-09 13:41 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 8.0100 | 8.0000 | 8.2000 | 236.0550 | 56905.00 | 0.00 | 56905.00 | 71 | 22 | 4121 | 3761 | 1.09571922361074 | 0.71201380005032 | 0.710716994777693 | false | false | false | true | ||||||||||||||||
| 0e453fe2-a86b-41e0-9be0-27092f7cf184 | 2026-09-09 10:20 | 2026-09-09 10:19 | 2026-09-09 10:19 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 8.9500 | 8.9000 | 8.9500 | 236.6450 | 52788.00 | 52788.00 | 0.00 | 59 | 15 | 2702 | 3761 | 0.718425950545068 | 0.736426396216926 | 0.736426396216926 | false | false | false | true | ||||||||||||||||
| 559b3fe3-1a2f-4efe-820c-3d84d5355fa4 | 2026-09-09 10:19 | 2026-09-09 10:19 | 2026-09-09 10:19 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 8.8000 | 8.5500 | 8.8500 | 236.3000 | 53680.00 | 880.00 | 52800.00 | 61 | 15 | 1640 | 3761 | 0.436054240893379 | 0.734209648220527 | 0.734209648220527 | false | false | false | true | ||||||||||||||||
| c6d7f36c-fcc5-4e4b-8a3b-bfd215b455a3 | 2026-08-31 10:06 | 2026-08-31 10:06 | 2026-08-31 10:06 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 4.4000 | 4.2500 | 4.9000 | 212.0000 | 704168.00 | 130780.00 | 573388.00 | 1600 | 51 | 2300 | 2004 | 1.14770459081836 | 0.693817622519966 | 0.698685264885761 | false | false | false | true | ||||||||||||||||
| 72d5701a-bfe4-40a9-82fc-635b4f4e6185 | 2026-08-31 09:42 | 2026-08-31 09:42 | 2026-08-31 09:42 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 4.6500 | 4.6500 | 5.0000 | 212.6100 | 319030.00 | 0.00 | 319030.00 | 686 | 49 | 699 | 2004 | 0.348802395209581 | 0.700907711181286 | 0.700907711181286 | false | false | false | true | ||||||||||||||||
| dcaf7e23-7c28-48f6-a2b1-36fe3c959869 | 2026-08-18 13:17 | 2026-08-18 13:17 | 2026-08-18 13:17 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 9.3000 | 9.3000 | 9.7500 | 213.9700 | 352475.00 | 0.00 | 352475.00 | 379 | 33 | 457 | 1015 | 0.450246305418719 | 0.801271372328869 | 0.801271372328869 | false | false | false | true | ||||||||||||||||
| c9e98847-2d07-4bc9-b5e6-a8287c0dd024 | 2026-08-17 09:36 | 2026-08-17 09:35 | 2026-08-17 09:35 | MRVL | MRVL261120C00320000 | call | 320.0000 | 2026-11-20 | 16.0500 | 16.0000 | 16.0500 | 236.2600 | 176550.00 | 176550.00 | 0.00 | 110 | 16 | 111 | 1017 | 0.109144542772861 | 0.818311453508715 | 0.818311453508715 | false | false | false | true |
| 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} |
| 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 |
| — |
| 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-25T13:39:47.971768Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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-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 |
| 228783210000.00 |
| 2026-12-01 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:14:46.490149Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:11:43.770446Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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:00:53.952817Z"} |
| 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-21T16:25:44.384112Z"} |
| 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-09T19:53:17.072904Z"} |
| 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-09T17:50:47.676652Z"} |
| 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-09-09T17:50:47.676652Z"} |
| 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-09-09T17:50:47.676652Z"} |
| 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-09-09T14:24:00.331334Z"} |
| 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-09T14:24:00.331334Z"} |
| 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-31T14:21:00.001261Z"} |
| 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-31T13:47:44.562652Z"} |
| 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-18T17:20:11.917066Z"} |
| 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-17T13:42:20.529509Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |