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 |
|---|
| 931ce614-711e-4e8e-8813-86f72aee681e | 2026-09-21 14:22 | 2026-09-21 14:22 | 2026-09-21 14:22 | TSM | TSM261016P00447500 | put | 447.5000 | 2026-10-16 | 17.3000 | 17.3000 | 17.5000 | 442.9400 | 12110.00 | 0.00 | 12110.00 | 7 | 7 | 29 | 0 | 0 | 0.33552693718404 | 0.33552693718404 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Technology | 2308720792967.00 | 2026-10-15 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:23:56.707397Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| b37487da-b000-4c15-9cc3-18ac6beffdfe | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | TSM | TSM261016P00447500 | put | 447.5000 | 2026-10-16 | 16.0500 | 15.7500 | 16.1500 | 444.5750 | 62605.00 | 59385.00 | 3220.00 | 39 | 18 | 45 | 80 | 0.5625 | 0.33262805012215 | 0.333727457052918 | true | false | false | |||||||||||||||||
| 7d535dfe-a7f6-46f6-9f76-b1b2c65ef503 | 2026-09-23 11:26 | 2026-09-23 11:26 | 2026-09-23 11:26 | TSM | TSM261016P00447500 | put | 447.5000 | 2026-10-16 | 13.0600 | 12.6500 | 13.1000 | 450.2400 | 11750.00 | 11750.00 | 0.00 | 9 | 5 | 57 | 131 | 0.435114503816794 | 0.331968196600168 | 0.333088803961475 | false | false | false | |||||||||||||||||
| e3af1596-0c1d-4038-b187-0084f2a6257b | 2026-09-25 10:14 | 2026-09-25 10:14 | 2026-09-25 10:14 | TSM | TSM261016P00447500 | put | 447.5000 | 2026-10-16 | 12.2000 | 11.9500 | 12.2500 | 451.5850 | 52460.00 | 52460.00 | 0.00 | 43 | 15 | 51 | 151 | 0.337748344370861 | 0.34025404162612 | 0.34025404162612 | true | false | false | |||||||||||||||||
| c959db8d-ffa1-4826-b879-9053beeb000a | 2026-09-25 11:29 | 2026-09-25 11:29 | 2026-09-25 11:29 | TSM | TSM261016P00447500 | put | 447.5000 | 2026-10-16 | 12.3500 | 12.3500 | 12.6000 | 450.0000 | 14820.00 | 0.00 | 14820.00 | 12 | 5 | 63 | 151 | 0.417218543046358 | 0.337030750136863 | 0.337030750136863 | false | false | false | |||||||||||||||||
| d6e3fc11-8a77-47fa-b01f-4b7ab77ccd2f | 2026-09-28 12:31 | 2026-09-28 12:31 | 2026-09-28 12:31 | TSM | TSM261016P00447500 | put | 447.5000 | 2026-10-16 | 10.9500 | 10.6500 | 11.3000 | 453.8550 | 25190.00 | 2195.00 | 22995.00 | 23 | 11 | 37 | 190 | 0.194736842105263 | 0.358141863904939 | 0.358141863904939 | false | false | false | |||||||||||||||||
| 41233101-3684-4ad2-9d57-23f89d813be5 | 2026-09-28 15:19 | 2026-09-28 15:19 | 2026-09-28 15:19 | TSM | TSM261016P00447500 | put | 447.5000 | 2026-10-16 | 11.0000 | 11.0000 | 11.2000 | 453.4100 | 11000.00 | 0.00 | 11000.00 | 10 | 6 | 57 | 190 | 0.3 | 0.35479292104724 | 0.35479292104724 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2344300216608.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:28:13.578365Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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-25T14:15:34.282180Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2337090974791.00 |
| 2026-10-15 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:30:17.746556Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-28T16:34:48.281149Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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:23:02.177643Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |