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_alerts523,327 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 |
|---|
| 36a48813-69b9-4cf6-9027-a4ab92a3a8a3 | 2026-09-08 10:32 | 2026-09-08 10:32 | 2026-09-08 10:32 | MSFT | MSFT260918P00480000 | put | 480.0000 | 2026-09-18 | 4.2400 | 4.0500 | 4.2500 | 490.4200 | 130270.00 | 113050.00 | 17220.00 | 307 | 29 | 1780 | 11683 | 0.152358127193358 | 0.270039897953386 | 0.267840247323134 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3752944946606.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T14:47:12.085652Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8ca210b0-0897-40e6-a123-02994c010da3 | 2026-09-08 09:45 | 2026-09-08 09:45 | 2026-09-08 09:45 | MSFT | MSFT260918P00480000 | put | 480.0000 | 2026-09-18 | 3.7000 | 3.5000 | 3.7500 | 493.0500 | 182238.00 | 128313.00 | 53185.00 | 493 | 39 | 1333 | 11683 | 0.11409740648806 | 0.274486809908723 | 0.276517996478884 | false | false | false | true | ||||||||||||||||
| bc0ccb1d-2eb8-44c9-9cf2-eec32a096a58 | 2026-09-08 09:42 | 2026-09-08 09:42 | 2026-09-08 09:42 | MSFT | MSFT260918P00480000 | put | 480.0000 | 2026-09-18 | 3.8000 | 3.6000 | 3.8500 | 492.2200 | 274740.00 | 272840.00 | 1900.00 | 723 | 51 | 836 | 11683 | 0.0715569631087905 | 0.271952499713027 | 0.271952499713027 | false | false | false | true | ||||||||||||||||
| d984bccd-9c29-43fa-969f-77cd58b5ea26 | 2026-08-20 09:32 | 2026-08-20 09:32 | 2026-08-20 09:32 | MSFT | MSFT260918P00480000 | put | 480.0000 | 2026-09-18 | 12.8500 | 12.8500 | 13.1500 | 481.2921 | 514000.00 | 0.00 | 514000.00 | 400 | 5 | 405 | 4152 | 0.0975433526011561 | 0.262660988154662 | 0.262660988154662 | true | false | false | true | ||||||||||||||||
| eed5d333-b3e6-477d-8dcb-250a90353b5f | 2026-08-18 15:32 | 2026-08-18 15:32 | 2026-08-18 15:32 | MSFT | MSFT260918P00480000 | put | 480.0000 | 2026-09-18 | 12.6500 | 12.5000 | 12.6500 | 483.6600 | 158125.00 | 158125.00 | 0.00 | 125 | 6 | 426 | 4359 | 0.0977288368891948 | 0.270315871692844 | 0.270315871692844 | false | false | false | true | ||||||||||||||||
| c66259a5-b011-4c06-b2f7-f45305c1154c | 2026-08-17 15:29 | 2026-08-17 15:29 | 2026-08-17 15:29 | MSFT | MSFT260918P00480000 | put | 480.0000 | 2026-09-18 | 14.2000 | 14.1500 | 14.3500 | 480.8350 | 142000.00 | 71000.00 | 42600.00 | 100 | 5 | 1798 | 4447 | 0.404317517427479 | 0.271670870881135 | 0.271670870881135 | false | false | false | true | ||||||||||||||||
| 06cc9c95-9ba9-44c4-b6fa-993429f9b888 | 2026-08-17 13:02 | 2026-08-17 13:02 | 2026-08-17 13:02 | MSFT | MSFT260918P00480000 | put | 480.0000 | 2026-09-18 | 14.7500 | 14.5000 | 14.7500 | 479.8150 | 169625.00 | 169625.00 | 0.00 | 115 | 7 | 874 | 4447 | 0.196536991230043 | 0.273027019603321 | 0.273027019603321 | false | false | false | true | ||||||||||||||||
| a0c52989-738b-4d8a-a65d-12b8bf765679 | 2026-08-17 10:59 | 2026-08-17 10:59 | 2026-08-17 10:59 | MSFT | MSFT260918P00480000 | put | 480.0000 | 2026-09-18 | 12.8000 | 12.7500 | 12.8000 | 483.3950 | 102400.00 | 102400.00 | 0.00 | 80 | 5 | 417 | 4447 | 0.0937710816280639 | 0.267071823817533 | 0.267071823817533 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3752944946606.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:49:15.511852Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3752944946606.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:49:15.511852Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3752944946606.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3752944946606.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3752944946606.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3752944946606.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3752944946606.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |