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 |
|---|
| expirydate |
|---|
| 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 |
|---|
| 8528ac5e-ea51-48c2-ba5e-5168842bb9b6 | 2026-09-04 15:36 | 2026-09-04 15:36 | 2026-09-04 15:36 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 8.9500 | 8.6500 | 9.0500 | 1008.5250 | 116315.00 | 110085.00 | 6230.00 | 130 | 20 | 124945 | 20793 | 6.00899341124417 | 1.20136795773668 | 1.04553258736841 | 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-04T19:47:04.296573Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d8c1e5e2-7ae9-4e1f-8f6c-c266234a3ebf | 2026-09-04 14:36 | 2026-09-04 14:35 | 2026-09-04 14:35 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 4.3500 | 4.2000 | 4.6000 | 1001.9000 | 189660.00 | 435.00 | 3480.00 | 436 | 8 | 116862 | 20793 | 5.6202568171981 | 0.618100726933466 | 0.655029828738131 | true | false | false | |||||||||||||||||
| 58c97d03-7351-4c45-bbfa-9240a0179571 | 2026-09-04 14:24 | 2026-09-04 14:24 | 2026-09-04 14:24 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 4.0000 | 3.9000 | 4.0000 | 1000.9300 | 108800.00 | 108800.00 | 0.00 | 272 | 15 | 113099 | 20793 | 5.4392824508248 | 0.651015362342207 | 0.651015362342207 | false | false | false | |||||||||||||||||
| fcd99952-ce26-4ef6-a842-78f85bea72d7 | 2026-09-04 14:00 | 2026-09-04 13:59 | 2026-09-04 13:59 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 3.7000 | 3.6500 | 3.7000 | 999.3800 | 111000.00 | 111000.00 | 0.00 | 300 | 5 | 108644 | 20793 | 5.22502765353725 | 0.663435909400372 | 0.663435909400372 | false | false | false | |||||||||||||||||
| fb500081-3100-441b-b5e3-c55d3782bb8d | 2026-09-04 13:47 | 2026-09-04 13:47 | 2026-09-04 13:47 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 3.7500 | 3.5500 | 3.8000 | 998.5300 | 187500.00 | 1125.00 | 0.00 | 500 | 5 | 105430 | 20793 | 5.07045640359736 | 0.701315278722881 | 0.701315278722881 | true | false | false | |||||||||||||||||
| b4edd596-6fa7-4ad1-9ed9-9ffadfbbe907 | 2026-09-04 12:47 | 2026-09-04 12:47 | 2026-09-04 12:47 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 6.9000 | 6.7000 | 6.9000 | 1003.1400 | 108330.00 | 108330.00 | 0.00 | 157 | 23 | 94701 | 20793 | 4.55446544510172 | 0.692847090433872 | 0.676076697746154 | true | false | false | |||||||||||||||||
| 26ec52e1-bcbc-4dcd-b3f4-a3a0783b9fc1 | 2026-09-04 12:24 | 2026-09-04 12:24 | 2026-09-04 12:24 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 7.2000 | 7.1000 | 7.2000 | 1003.1600 | 150480.00 | 150480.00 | 0.00 | 209 | 10 | 89696 | 20793 | 4.3137594382725 | 0.687527959500423 | 0.675537627200912 | false | false | false | |||||||||||||||||
| 1e5c1532-9570-41b4-99f5-d493be590732 | 2026-09-04 09:56 | 2026-09-04 09:56 | 2026-09-04 09:56 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 9.0000 | 8.9000 | 9.1000 | 998.5750 | 163817.00 | 135900.00 | 27917.00 | 182 | 44 | 41635 | 20793 | 2.00235656230462 | 0.931814524347149 | 0.923548877607175 | true | false | false | |||||||||||||||||
| 4e4e0a7a-3231-4246-a164-7bb2afeafe41 | 2026-09-01 15:06 | 2026-09-01 15:05 | 2026-09-01 15:05 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 2.7000 | 2.6200 | 2.7100 | 931.7800 | 135270.00 | 133380.00 | 270.00 | 501 | 16 | 27574 | 5381 | 5.12432633339528 | 0.617778311565135 | 0.617778311565135 | true | false | false | |||||||||||||||||
| 82e2a7f4-d3c9-4d18-b286-34d66ae9c085 | 2026-08-28 14:55 | 2026-08-28 14:55 | 2026-08-28 14:55 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 5.6000 | 5.6000 | 6.0000 | 927.5100 | 224000.00 | 0.00 | 224000.00 | 400 | 8 | 6330 | 2090 | 3.02870813397129 | 0.526364311009963 | 0.526364311009963 | false | false | false | |||||||||||||||||
| dc13884b-5fac-4c94-a776-338fd69f5330 | 2026-08-28 11:22 | 2026-08-28 11:22 | 2026-08-28 11:22 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 9.0000 | 8.9500 | 9.4500 | 938.7500 | 182700.00 | 28800.00 | 153900.00 | 203 | 12 | 3459 | 2090 | 1.65502392344498 | 0.561647917658798 | 0.561647917658798 | false | false | false | |||||||||||||||||
| c1215cc6-24ab-493b-ac97-08e09e5b3427 | 2026-08-28 11:02 | 2026-08-28 11:02 | 2026-08-28 11:02 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 9.0000 | 8.8500 | 9.0000 | 938.0000 | 180000.00 | 180000.00 | 0.00 | 200 | 10 | 2607 | 2090 | 1.24736842105263 | 0.565950804048597 | 0.565950804048597 | false | false | false |
| 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-04T19:05:15.166096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-04T18:34:11.376593Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-04T18:01:17.201510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-04T18:01:17.201510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-04T16:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-04T16:32:28.507822Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-01T19:21:20.162349Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-08-28T19:10:32.565799Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-08-28T15:36:02.227679Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-08-28T15:11:58.135920Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |