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_alerts658,639 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 |
|---|
| 21a1e406-8be4-472a-a66e-7b31b9fc6c48 | 2026-09-08 09:34 | 2026-09-08 09:34 | 2026-09-08 09:34 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 20.5500 | 20.3500 | 20.7000 | 1017.0400 | 106885.00 | 53515.00 | 53370.00 | 52 | 10 | 303 | 1051 | 0.288296860133206 | 0.782522474932974 | 0.778504427212127 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1043593153319.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T13:39:51.680537Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cbc56f4c-0e65-4428-91e4-18b62aa4777b | 2026-09-08 09:35 | 2026-09-08 09:35 | 2026-09-08 09:35 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 18.0000 | 18.0000 | 18.5000 | 1021.2799 | 145800.00 | 0.00 | 145800.00 | 81 | 15 | 629 | 1051 | 0.598477640342531 | 0.751406997561901 | 0.751406997561901 | false | false | false | true | ||||||||||||||||
| 2fbaa2db-346b-4273-9c01-c033f92b1d1a | 2026-09-08 10:27 | 2026-09-08 10:27 | 2026-09-08 10:27 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 18.2900 | 18.2500 | 18.6500 | 1015.8799 | 279912.00 | 1840.00 | 274412.00 | 153 | 31 | 3068 | 1051 | 2.91912464319696 | 0.702602309654628 | 0.70063439580339 | false | false | false | true | ||||||||||||||||
| 831b535d-4448-4a73-8a6e-ff942ea310ad | 2026-09-08 10:27 | 2026-09-08 10:27 | 2026-09-08 10:27 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 17.7500 | 17.7500 | 18.0500 | 1016.9899 | 181050.00 | 0.00 | 181050.00 | 102 | 16 | 3321 | 1051 | 3.15984776403425 | 0.698555853120928 | 0.698555853120928 | false | false | false | true | ||||||||||||||||
| a6c13e0b-ca85-40c8-b9d6-3726d7daabb8 | 2026-09-08 10:28 | 2026-09-08 10:27 | 2026-09-08 10:27 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 17.4500 | 17.4500 | 17.7500 | 1017.9169 | 767801.00 | 0.00 | 767801.00 | 440 | 43 | 4027 | 1051 | 3.83158896289248 | 0.698212318372022 | 0.700004905957576 | false | false | false | true | ||||||||||||||||
| 2a4bd0c2-40aa-41b1-ae3e-c4c50617f91d | 2026-09-08 11:45 | 2026-09-08 11:45 | 2026-09-08 11:45 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 15.0000 | 14.9000 | 15.0000 | 1024.5000 | 201000.00 | 201000.00 | 0.00 | 134 | 9 | 4949 | 1051 | 4.70884871550904 | 0.696558409130959 | 0.697015890073326 | false | false | false | true | ||||||||||||||||
| 20190fdd-2c3a-4e7e-b550-23e02decf7ce | 2026-09-08 11:58 | 2026-09-08 11:58 | 2026-09-08 11:58 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 15.0000 | 14.8000 | 15.0000 | 1024.2400 | 609000.00 | 609000.00 | 0.00 | 406 | 19 | 5460 | 1051 | 5.19505233111323 | 0.694427949599213 | 0.694427949599213 | false | false | false | true | ||||||||||||||||
| 0c127661-eaee-4841-a8bf-4552682a41ab | 2026-09-08 11:58 | 2026-09-08 11:58 | 2026-09-08 11:58 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 15.0000 | 14.8500 | 15.0500 | 1023.8300 | 274505.00 | 274505.00 | 0.00 | 183 | 10 | 5643 | 1051 | 5.36917221693625 | 0.692034358652123 | 0.691806114276964 | false | false | false | true | ||||||||||||||||
| 9b62e2b9-4fb6-4850-b140-617386d3f406 | 2026-09-08 14:33 | 2026-09-08 14:33 | 2026-09-08 14:33 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 16.3500 | 16.3500 | 16.5000 | 1017.7200 | 379320.00 | 0.00 | 379320.00 | 232 | 35 | 6754 | 1051 | 6.42626070409134 | 0.664407569093345 | 0.666435381147784 | false | false | false | true | ||||||||||||||||
| e190f180-63d4-458a-8f11-86afb83bea17 | 2026-09-08 15:55 | 2026-09-08 15:55 | 2026-09-08 15:55 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 25.0800 | 24.9500 | 25.4000 | 998.3063 | 190625.00 | 42730.00 | 147895.00 | 76 | 25 | 8869 | 1051 | 8.43862987630828 | 0.679927842693091 | 0.675485876169188 | true | false | false | true | ||||||||||||||||
| fcab7d0b-5755-4059-a5d8-bf2d817ced94 | 2026-09-09 10:16 | 2026-09-09 10:16 | 2026-09-09 10:16 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 8.7000 | 8.5000 | 8.7000 | 1036.0000 | 173997.00 | 173997.00 | 0.00 | 200 | 23 | 3542 | 4843 | 0.731364856493909 | 0.741326663925006 | 0.741326663925006 | true | false | false | true | ||||||||||||||||
| e3ac3e83-fc5f-40c4-a0fb-a7b99c16fbeb | 2026-09-09 11:03 | 2026-09-09 11:03 | 2026-09-09 11:03 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 9.0000 | 8.8500 | 9.0500 | 1032.3000 | 449973.00 | 350973.00 | 92700.00 | 500 | 15 | 5554 | 4843 | 1.14680982861862 | 0.716726473156861 | 0.714983718584101 | false | false | false | true | ||||||||||||||||
| 6c66c40b-49a0-4f4b-baa8-23c2f8819acd | 2026-09-09 11:11 | 2026-09-09 11:11 | 2026-09-09 11:11 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 12.0000 | 11.6000 | 12.0000 | 1021.6899 | 123600.00 | 123600.00 | 0.00 | 103 | 6 | 6901 | 4843 | 1.42494321701425 | 0.709432208428183 | 0.709432208428183 | true | false | false | true | ||||||||||||||||
| 1c27e0f0-7b95-42db-8874-caf73ddc74ad | 2026-09-09 11:22 | 2026-09-09 11:22 | 2026-09-09 11:22 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 11.8000 | 11.8000 | 11.8500 | 1023.2800 | 109740.00 | 0.00 | 109740.00 | 93 | 11 | 7477 | 4843 | 1.54387776171794 | 0.72111518429306 | 0.72111518429306 | true | false | false | true | ||||||||||||||||
| 9486806a-6195-4679-8f5a-821b78ab310b | 2026-09-10 09:32 | 2026-09-10 09:32 | 2026-09-10 09:32 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 25.0000 | 24.5500 | 25.2000 | 986.8000 | 560000.00 | 560000.00 | 0.00 | 224 | 8 | 1165 | 5728 | 0.20338687150838 | 0.855782617217008 | 0.852726847823139 | false | false | false | true | ||||||||||||||||
| eac78c07-9908-47d6-9259-3fdd20858462 | 2026-09-11 15:53 | 2026-09-11 15:53 | 2026-09-11 15:53 | MU | MU260911P01000000 | put | 1000.0000 | 2026-09-11 | 24.0000 | 24.0000 | 24.2500 | 976.0700 | 424800.00 | 0.00 | 424800.00 | 177 | 20 | 2440 | 5880 | 0.414965986394558 | 3.7668761777533 | 3.25832467199987 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:39:51.680537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:43:21.019108Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:30:57.501605Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| 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 |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:29:26.424015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:32:54.294551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:55:36.907305Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |