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_alerts609,118 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 |
|---|
| b2c89eb0-0a78-4af0-9736-b5cd82a61f10 | 2026-09-30 11:48 | 2026-09-30 11:48 | 2026-09-30 11:48 | MP | MP261218P00050000 | put | 50.0000 | 2026-12-18 | 6.4000 | 6.2500 | 6.4000 | 47.8350 | 78080.00 | 78080.00 | 0.00 | 122 | 19 | 142 | 4368 | 0.0325091575091575 | 0.611231689953058 | 0.611231689953058 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 8091155143.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T15:49:50.007553Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| bc97b1bd-7c2e-48b0-b499-ac43c9b7fd41 | 2026-09-08 15:07 | 2026-09-08 15:07 | 2026-09-08 15:07 | MP | MP261218P00050000 | put | 50.0000 | 2026-12-18 | 4.6000 | 4.5500 | 4.8000 | 55.3700 | 27600.00 | 17940.00 | 2760.00 | 60 | 18 | 330 | 1635 | 0.201834862385321 | 0.656287391032445 | 0.656287391032445 | false | false | false | |||||||||||||||||
| b667d6f2-73db-431b-8bfa-2078889270c1 | 2026-09-08 15:07 | 2026-09-08 15:07 | 2026-09-08 15:07 | MP | MP261218P00050000 | put | 50.0000 | 2026-12-18 | 4.6000 | 4.6000 | 4.6500 | 55.3900 | 25300.00 | 0.00 | 25300.00 | 55 | 7 | 270 | 1635 | 0.165137614678899 | 0.656888804490756 | 0.656888804490756 | false | false | false | |||||||||||||||||
| 944b655d-e405-4f9f-9160-b66572ae474c | 2026-09-08 12:48 | 2026-09-08 12:48 | 2026-09-08 12:48 | MP | MP261218P00050000 | put | 50.0000 | 2026-12-18 | 4.2500 | 4.2000 | 4.4000 | 56.6550 | 25500.00 | 16575.00 | 2550.00 | 60 | 17 | 130 | 1635 | 0.0795107033639144 | 0.659394751691579 | 0.659394751691579 | false | false | false | |||||||||||||||||
| d06bbc19-9110-4377-9639-70d60014c580 | 2026-09-04 11:01 | 2026-09-04 11:01 | 2026-09-04 11:01 | MP | MP261218P00050000 | put | 50.0000 | 2026-12-18 | 4.8000 | 4.8000 | 4.9500 | 54.6450 | 38400.00 | 0.00 | 38400.00 | 80 | 16 | 84 | 1643 | 0.0511259890444309 | 0.641822114548619 | 0.641822114548619 | false | false | false | |||||||||||||||||
| 2855f25f-f91b-47db-9beb-5ff116867b21 | 2026-09-02 09:31 | 2026-09-02 09:31 | 2026-09-02 09:31 | MP | MP261218P00050000 | put | 50.0000 | 2026-12-18 | 5.2500 | 5.1000 | 5.2500 | 53.7527 | 25725.00 | 21525.00 | 0.00 | 49 | 17 | 54 | 1588 | 0.0340050377833753 | 0.650740366223558 | 0.650740366223558 | false | false | false | |||||||||||||||||
| 2b9cc700-7125-4804-8c2d-6fdc1201a0d0 | 2026-08-17 15:02 | 2026-08-17 15:02 | 2026-08-17 15:02 | MP | MP261218P00050000 | put | 50.0000 | 2026-12-18 | 4.4500 | 4.4500 | 4.5500 | 58.0571 | 16465.00 | 0.00 | 2670.00 | 37 | 14 | 184 | 1356 | 0.135693215339233 | 0.654364452181673 | 0.654364452181673 | false | false | false | |||||||||||||||||
| c7542351-f2f1-4aed-b325-28d8f8467788 | 2026-08-17 13:15 | 2026-08-17 13:15 | 2026-08-17 13:15 | MP | MP261218P00050000 | put | 50.0000 | 2026-12-18 | 4.4000 | 4.2500 | 4.4500 | 58.3250 | 18480.00 | 880.00 | 11440.00 | 42 | 17 | 139 | 1356 | 0.102507374631268 | 0.656288932113126 | 0.656288932113126 | false | false | false | |||||||||||||||||
| 10fc4802-2e99-4d50-aba9-2211733b6422 | 2026-08-17 10:45 | 2026-08-17 10:44 | 2026-08-17 10:44 | MP | MP261218P00050000 | put | 50.0000 | 2026-12-18 | 4.7000 | 4.7000 | 4.8500 | 57.3300 | 18800.00 | 0.00 | 5640.00 | 40 | 13 | 42 | 1356 | 0.0309734513274336 | 0.65892121058979 | 0.65892121058979 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 9026188480.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:30:09.198364Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 9026188480.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:30:09.198364Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 9026188480.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:11:09.796111Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 9026188480.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:23:10.886670Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 9026188480.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T13:31:29.863287Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 9026188480.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 9026188480.00 |
| 2026-11-05 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 9026188480.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |