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 | 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 |
|---|
| f2198661-3823-4d1a-b08e-4ff01884c391 | 2026-09-28 15:07 | 2026-09-28 15:07 | 2026-09-28 15:07 | TSM | TSM270617C00500000 | call | 500.0000 | 2027-06-17 | 45.1900 | 44.7500 | 45.9000 | 453.4300 | 67785.00 | 4505.00 | 63280.00 | 15 | 7 | 29 | 2490 | 0.0116465863453815 | 0.375855431101827 | 0.374875618130107 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Technology | 2348864340924.00 | 2026-10-15 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T19:11:33.715590Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 5a47e21f-25f6-4759-ad84-f3bd8a4585be | 2026-09-25 14:34 | 2026-09-25 14:34 | 2026-09-25 14:34 | TSM | TSM270617C00500000 | call | 500.0000 | 2027-06-17 | 44.4000 | 43.9000 | 45.2000 | 451.0950 | 35520.00 | 17760.00 | 17760.00 | 8 | 5 | 44 | 2526 | 0.0174188440221694 | 0.375299305463976 | 0.375299305463976 | false | false | false | true | ||||||||||||||||
| 802e210b-e107-4a1d-bfa6-a13454e032d0 | 2026-09-23 11:12 | 2026-09-23 11:11 | 2026-09-23 11:11 | TSM | TSM270617C00500000 | call | 500.0000 | 2027-06-17 | 43.8000 | 42.8000 | 44.1500 | 449.3250 | 87600.00 | 4380.00 | 4380.00 | 20 | 19 | 293 | 2547 | 0.115037298782882 | 0.37582326636785 | 0.37582326636785 | false | false | false | true | ||||||||||||||||
| feeda716-a304-4f52-bc9d-3f46cc7d199b | 2026-09-23 10:29 | 2026-09-23 10:29 | 2026-09-23 10:29 | TSM | TSM270617C00500000 | call | 500.0000 | 2027-06-17 | 40.5500 | 40.5000 | 41.0500 | 445.0650 | 389305.00 | 336565.00 | 52740.00 | 96 | 26 | 120 | 2547 | 0.0471142520612485 | 0.367443651119437 | 0.367443651119437 | false | false | false | true | ||||||||||||||||
| 905b005a-4a41-4893-a72b-12d10c7b622c | 2026-09-08 13:44 | 2026-09-08 13:43 | 2026-09-08 13:43 | TSM | TSM270617C00500000 | call | 500.0000 | 2027-06-17 | 44.2000 | 44.2000 | 44.5500 | 440.4600 | 132600.00 | 0.00 | 4420.00 | 30 | 18 | 814 | 2212 | 0.367992766726944 | 0.395360729765485 | 0.395360729765485 | false | false | false | true | ||||||||||||||||
| d14108fa-713d-4ff4-9e44-1acf187f7a0f | 2026-08-19 11:33 | 2026-08-19 11:33 | 2026-08-19 11:33 | TSM | TSM270617C00500000 | call | 500.0000 | 2027-06-17 | 36.8500 | 36.6000 | 37.2000 | 412.1700 | 272690.00 | 165825.00 | 55275.00 | 74 | 5 | 526 | 1775 | 0.296338028169014 | 0.41308487891788 | 0.41308487891788 | false | false | false | true | ||||||||||||||||
| 454f2278-5169-4f89-a752-fcac21626fa5 | 2026-08-19 11:33 | 2026-08-19 11:33 | 2026-08-19 11:33 | TSM | TSM270617C00500000 | call | 500.0000 | 2027-06-17 | 36.8500 | 36.6000 | 37.3000 | 412.1400 | 1098130.00 | 346390.00 | 33165.00 | 298 | 8 | 303 | 1775 | 0.170704225352113 | 0.413168618534009 | 0.413168618534009 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2337090974791.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:38:37.498256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2316137494979.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:14:40.062093Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2316137494979.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:31:12.586989Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2168010914921.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:15:47.972880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2168010914921.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2168010914921.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |