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 |
|---|
| af6c1eb0-e4b5-4e56-81ab-4d19690b5d68 | 2026-09-18 09:43 | 2026-09-18 09:43 | 2026-09-18 09:43 | MSTR | MSTR260918C00147000 | call | 147.0000 | 2026-09-18 | 0.4200 | 0.4200 | 0.4700 | 141.5200 | 10584.00 | 0.00 | 10584.00 | 252 | 12 | 457 | 437 | 1.04576659038902 | 1.37902179576679 | 1.37902179576679 | false | false | false | true | 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-18T13:50:28.178058Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 89c7fbed-0859-4b5f-b283-e29c1249c63f | 2026-09-18 09:52 | 2026-09-18 09:52 | 2026-09-18 09:52 | MSTR | MSTR260918C00147000 | call | 147.0000 | 2026-09-18 | 0.9200 | 0.9000 | 0.9600 | 144.1000 | 16560.00 | 2208.00 | 14168.00 | 180 | 7 | 1072 | 437 | 2.45308924485126 | 1.34210898867713 | 1.33541398996149 | false | false | false | |||||||||||||||||
| 75b1cf07-e877-4fef-b747-7595372d84d7 | 2026-09-18 09:53 | 2026-09-18 09:53 | 2026-09-18 09:53 | MSTR | MSTR260918C00147000 | call | 147.0000 | 2026-09-18 | 1.0900 | 1.0100 | 1.0900 | 144.4300 | 47851.00 | 47851.00 | 0.00 | 439 | 30 | 1567 | 437 | 3.5858123569794 | 1.38332186407665 | 1.38803232487762 | false | false | false | |||||||||||||||||
| 0110c9a2-8e10-4209-b9be-628af7331c15 | 2026-09-18 10:24 | 2026-09-18 10:24 | 2026-09-18 10:24 | MSTR | MSTR260918C00147000 | call | 147.0000 | 2026-09-18 | 2.0000 | 1.9400 | 2.0200 | 147.0000 | 10400.00 | 10400.00 | 0.00 | 52 | 6 | 3824 | 437 | 8.75057208237986 | 1.34856954214293 | 1.34856954214293 | false | false | false | |||||||||||||||||
| 6b8284d8-518c-4af8-afa0-5d5f19a4b20d | 2026-09-18 10:42 | 2026-09-18 10:42 | 2026-09-18 10:42 | MSTR | MSTR260918C00147000 | call | 147.0000 | 2026-09-18 | 1.6500 | 1.5800 | 1.6500 | 146.6400 | 13018.00 | 12538.00 | 480.00 | 79 | 9 | 6497 | 437 | 14.8672768878719 | 1.21691873375167 | 1.25875207357963 | false | false | false | |||||||||||||||||
| 6f6cfd85-7736-4cfd-96e5-5c4891d6aa91 | 2026-09-18 10:48 | 2026-09-18 10:48 | 2026-09-18 10:48 | MSTR | MSTR260918C00147000 | call | 147.0000 | 2026-09-18 | 1.8900 | 1.8800 | 1.9400 | 147.3200 | 18900.00 | 0.00 | 18900.00 | 100 | 7 | 7626 | 437 | 17.4508009153318 | 1.20643164540389 | 1.20643164540389 | false | false | false | |||||||||||||||||
| 8ab2dae4-efa8-43f7-8a4a-292699b17a1f | 2026-09-18 10:49 | 2026-09-18 10:49 | 2026-09-18 10:49 | MSTR | MSTR260918C00147000 | call | 147.0000 | 2026-09-18 | 2.0000 | 1.9700 | 2.0000 | 147.4600 | 32000.00 | 32000.00 | 0.00 | 160 | 11 | 7817 | 437 | 17.8878718535469 | 1.23132399112824 | 1.23132399112824 | false | false | false | |||||||||||||||||
| c230af0b-6eca-43d4-8d74-1792b5824028 | 2026-09-18 11:02 | 2026-09-18 11:02 | 2026-09-18 11:02 | MSTR | MSTR260918C00147000 | call | 147.0000 | 2026-09-18 | 2.1200 | 2.1000 | 2.1900 | 147.9000 | 21168.00 | 0.00 | 21168.00 | 100 | 7 | 9225 | 437 | 21.1098398169336 | 1.1492042639437 | 1.17849934090757 | false | false | false | |||||||||||||||||
| 3c6c18a8-f74c-4ee6-8313-6c1a60354bb6 | 2026-09-18 11:11 | 2026-09-18 11:11 | 2026-09-18 11:11 | MSTR | MSTR260918C00147000 | call | 147.0000 | 2026-09-18 | 1.6900 | 1.6200 | 1.6900 | 147.3200 | 34645.00 | 34645.00 | 0.00 | 205 | 9 | 10301 | 437 | 23.5720823798627 | 1.1080136354842 | 1.1080136354842 | true | false | false | |||||||||||||||||
| aa95679d-a3e2-47af-a1b0-8bf8fe921e76 | 2026-09-18 15:52 | 2026-09-18 15:52 | 2026-09-18 15:52 | MSTR | MSTR260918C00147000 | call | 147.0000 | 2026-09-18 | 6.5000 | 6.2500 | 6.5000 | 153.0000 | 15600.00 | 15600.00 | 0.00 | 24 | 11 | 12980 | 437 | 29.7025171624714 | 7.45079530797899 | 7.45079530797899 | true | false | false | |||||||||||||||||
| abcf2355-150d-4a2c-928a-d6277c4d8c89 | 2026-09-18 15:53 | 2026-09-18 15:53 | 2026-09-18 15:53 | MSTR | MSTR260918C00147000 | call | 147.0000 | 2026-09-18 | 6.5000 | 6.2500 | 7.0500 | 153.0000 | 13000.00 | 10400.00 | 2600.00 | 20 | 6 | 13001 | 437 | 29.7505720823799 | 8.33207994259467 | 8.33207994259467 | false | 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-18T13:59:27.968934Z"} |
| 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-18T13:59:27.968934Z"} |
| 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-18T14:32:18.430939Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 56117000314.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} |
| 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-18T15:02:00.544193Z"} |
| 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-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 56117000314.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 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-18T15:20:59.279522Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |