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 |
|---|
| cb8b3204-01fb-4b8c-97de-6608b40bf8cb | 2026-08-31 12:02 | 2026-08-31 12:02 | 2026-08-31 12:02 | MSTR | MSTR261218C00190000 | call | 190.0000 | 2026-12-18 | 7.0000 | 6.8500 | 7.1000 | 129.9500 | 14000.00 | 14000.00 | 0.00 | 20 | 6 | 45 | 544 | 0.0827205882352941 | 0.777918866004342 | 0.777918866004342 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a505d862-e8df-43e2-9699-ac2c46659665 | 2026-09-18 13:09 | 2026-09-18 13:09 | 2026-09-18 13:09 | MSTR | MSTR261218C00190000 | call | 190.0000 | 2026-12-18 | 10.3500 | 10.3500 | 10.6000 | 149.9474 | 50715.00 | 0.00 | 50715.00 | 49 | 8 | 156 | 620 | 0.251612903225806 | 0.746800823013875 | 0.746800823013875 | true | false | false | |||||||||||||||||
| 9c3ae4f4-41df-49a7-b9ee-805bfe2c5aa4 | 2026-09-18 13:57 | 2026-09-18 13:57 | 2026-09-18 13:57 | MSTR | MSTR261218C00190000 | call | 190.0000 | 2026-12-18 | 10.8500 | 10.7500 | 10.8500 | 151.3700 | 884275.00 | 884275.00 | 0.00 | 815 | 30 | 976 | 620 | 1.5741935483871 | 0.74729218524811 | 0.74729218524811 | false | false | false | |||||||||||||||||
| dffe57c0-e22c-49a8-afaf-8d4ea405760c | 2026-09-21 10:35 | 2026-09-21 10:35 | 2026-09-21 10:35 | MSTR | MSTR261218C00190000 | call | 190.0000 | 2026-12-18 | 17.3000 | 17.0500 | 17.3500 | 166.5400 | 41520.00 | 36330.00 | 5190.00 | 24 | 16 | 208 | 1295 | 0.160617760617761 | 0.774593375050936 | 0.774593375050936 | true | false | false | |||||||||||||||||
| d9afe133-78cb-46f9-9e83-542926b2c269 | 2026-09-21 12:54 | 2026-09-21 12:54 | 2026-09-21 12:54 | MSTR | MSTR261218C00190000 | call | 190.0000 | 2026-12-18 | 17.7000 | 17.5000 | 17.7500 | 167.0000 | 120358.00 | 115048.00 | 3540.00 | 68 | 29 | 310 | 1295 | 0.239382239382239 | 0.776848638288746 | 0.776848638288746 | false | false | false | |||||||||||||||||
| c32d347c-714a-4114-8f7d-d8755167e1e0 | 2026-09-21 15:19 | 2026-09-21 15:19 | 2026-09-21 15:19 | MSTR | MSTR261218C00190000 | call | 190.0000 | 2026-12-18 | 17.6000 | 17.5500 | 17.6000 | 167.5000 | 10560.00 | 10560.00 | 0.00 | 6 | 5 | 360 | 1295 | 0.277992277992278 | 0.770506500980004 | 0.770506500980004 | false | false | false | |||||||||||||||||
| dc8598b9-5f51-4150-a607-3567d5fe5684 | 2026-09-21 15:30 | 2026-09-21 15:30 | 2026-09-21 15:30 | MSTR | MSTR261218C00190000 | call | 190.0000 | 2026-12-18 | 17.7500 | 17.7500 | 18.0000 | 167.0000 | 23075.00 | 0.00 | 23075.00 | 13 | 12 | 374 | 1295 | 0.288803088803089 | 0.77023105414405 | 0.77023105414405 | false | false | false | |||||||||||||||||
| 9e5bc1e8-49ac-4b45-ac95-9cea545de803 | 2026-09-22 09:35 | 2026-09-22 09:35 | 2026-09-22 09:35 | MSTR | MSTR261218C00190000 | call | 190.0000 | 2026-12-18 | 18.3500 | 18.0000 | 18.6500 | 170.2100 | 115620.00 | 111935.00 | 3685.00 | 63 | 23 | 64 | 1419 | 0.0451021846370684 | 0.76388831020413 | 0.765891987271344 | true | false | false | |||||||||||||||||
| f9fef156-4999-49e5-b104-1a9ba515938c | 2026-09-22 10:28 | 2026-09-22 10:27 | 2026-09-22 10:27 | MSTR | MSTR261218C00190000 | call | 190.0000 | 2026-12-18 | 18.4000 | 18.3000 | 18.5000 | 170.3700 | 25760.00 | 23920.00 | 0.00 | 14 | 14 | 109 | 1419 | 0.076814658210007 | 0.760151128706547 | 0.759091434971944 | false | false | false | |||||||||||||||||
| 9dfc6060-dd65-4f68-bf09-13baa0022c57 | 2026-09-22 11:00 | 2026-09-22 11:00 | 2026-09-22 11:00 | MSTR | MSTR261218C00190000 | call | 190.0000 | 2026-12-18 | 17.8000 | 17.5000 | 17.8500 | 169.2800 | 80100.00 | 76540.00 | 3560.00 | 45 | 9 | 204 | 1419 | 0.143763213530655 | 0.756213140508811 | 0.756213140508811 | true | false | false | |||||||||||||||||
| 1d29bfe0-f329-453d-9a95-ecbeaaac60b5 | 2026-09-24 10:25 | 2026-09-24 10:25 | 2026-09-24 10:25 | MSTR | MSTR261218C00190000 | call | 190.0000 | 2026-12-18 | 14.1000 | 14.0000 | 14.2500 | 163.4400 | 59220.00 | 54990.00 | 2820.00 | 42 | 21 | 55 | 1493 | 0.0368385800401875 | 0.728832812325761 | 0.728832812325761 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56117000314.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56117000314.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:59:53.998874Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:37:14.719915Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:36:05.660724Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:31:31.654153Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:00:53.883267Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:28:24.219175Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |