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 |
|---|
| 5e568b8f-9b6f-43ff-9459-591c0554ea5a | 2026-09-23 13:01 | 2026-09-23 13:01 | 2026-09-23 13:01 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 20.4000 | 20.4000 | 20.7000 | 445.1550 | 83640.00 | 0.00 | 83640.00 | 41 | 5 | 480 | 12862 | 0.0373192349556834 | 0.350724423670442 | 0.350724423670442 | false | false | false | true | 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-23T17:03:13.598333Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 3acb7bef-f5ac-4e5a-99eb-8421a29c7856 | 2026-09-21 15:05 | 2026-09-21 15:05 | 2026-09-21 15:05 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 20.7500 | 20.7500 | 20.9500 | 443.0000 | 429576.00 | 0.00 | 429576.00 | 207 | 47 | 12133 | 1694 | 7.16233766233766 | 0.346987005179612 | 0.347168064733284 | false | false | false | true | ||||||||||||||||
| 4185c890-909c-4c8f-952c-4ecaf1e84797 | 2026-09-21 13:41 | 2026-09-21 13:41 | 2026-09-21 13:41 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.1300 | 21.1000 | 21.5000 | 442.2600 | 42265.00 | 27495.00 | 14770.00 | 20 | 10 | 11912 | 1694 | 7.0318772136954 | 0.345257491952943 | 0.345809273044052 | true | false | false | true | ||||||||||||||||
| 1fcc00c7-fda1-438b-adef-6bc2695de77d | 2026-09-21 13:08 | 2026-09-21 13:08 | 2026-09-21 13:08 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.1000 | 21.1000 | 21.5000 | 442.6575 | 2019294.00 | 2115.00 | 2017179.00 | 957 | 66 | 11884 | 1694 | 7.01534828807556 | 0.346138430631737 | 0.347267748121084 | false | false | false | true | ||||||||||||||||
| 192aff91-ed4c-4752-9561-ef7c72f31af8 | 2026-09-21 13:07 | 2026-09-21 13:07 | 2026-09-21 13:07 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.3000 | 21.1000 | 21.3500 | 442.8550 | 27687.00 | 25557.00 | 2130.00 | 13 | 6 | 10927 | 1694 | 6.4504132231405 | 0.349647065272971 | 0.349315844236403 | false | false | false | true | ||||||||||||||||
| 531eaa4b-7b60-40f7-9bd6-6e85a232e057 | 2026-09-21 12:50 | 2026-09-21 12:50 | 2026-09-21 12:50 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.4500 | 21.4500 | 21.6500 | 442.1700 | 1447911.00 | 0.00 | 1447911.00 | 675 | 34 | 10849 | 1694 | 6.40436835891381 | 0.348786717989979 | 0.348786717989979 | false | false | false | true | ||||||||||||||||
| 29c51c57-77ee-445d-a5f2-cb66cadc5335 | 2026-09-21 12:38 | 2026-09-21 12:37 | 2026-09-21 12:37 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.4000 | 21.1500 | 21.8500 | 442.8250 | 697720.00 | 402970.00 | 294750.00 | 326 | 25 | 3131 | 1694 | 1.8482880755608 | 0.34941243763318 | 0.347880901775416 | true | false | false | true | ||||||||||||||||
| 91fcfb57-6eca-4987-ac05-1a8fbd98477d | 2026-09-21 12:36 | 2026-09-21 12:36 | 2026-09-21 12:36 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.3500 | 21.3000 | 21.8500 | 442.3400 | 121715.00 | 8560.00 | 113155.00 | 57 | 23 | 2789 | 1694 | 1.64639905548996 | 0.348309707778838 | 0.348861116526122 | false | false | false | true | ||||||||||||||||
| d2a426ae-bb10-457d-a466-1251b53143ff | 2026-09-21 12:36 | 2026-09-21 12:36 | 2026-09-21 12:36 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.4500 | 21.2500 | 21.8500 | 442.3499 | 113685.00 | 2145.00 | 111540.00 | 53 | 21 | 2357 | 1694 | 1.3913813459268 | 0.349448849643127 | 0.349448849643127 | false | false | false | true | ||||||||||||||||
| b6916423-3434-48e6-96c5-4404d6046839 | 2026-09-21 12:36 | 2026-09-21 12:36 | 2026-09-21 12:36 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.4500 | 21.2500 | 21.8500 | 442.3499 | 270270.00 | 53625.00 | 216645.00 | 126 | 16 | 2483 | 1694 | 1.46576151121606 | 0.349448849643127 | 0.349448849643127 | false | false | false | true | ||||||||||||||||
| 3f1c4223-d13b-4cfd-86c5-566c5cfe7a74 | 2026-09-21 12:36 | 2026-09-21 12:36 | 2026-09-21 12:36 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.5000 | 21.5000 | 21.9500 | 442.2850 | 608450.00 | 0.00 | 608450.00 | 283 | 6 | 2300 | 1694 | 1.35773317591499 | 0.349761279686577 | 0.349761279686577 | false | false | false | true | ||||||||||||||||
| 0676c6d5-be5e-4ac5-a9b0-50e61fc6585f | 2026-09-21 12:36 | 2026-09-21 12:36 | 2026-09-21 12:36 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.3000 | 21.3000 | 21.8500 | 442.3499 | 398310.00 | 0.00 | 398310.00 | 187 | 23 | 2670 | 1694 | 1.57615112160567 | 0.347794596215144 | 0.347794596215144 | false | false | false | true | ||||||||||||||||
| c1401bcc-1976-4bfa-9c74-eff27b14e398 | 2026-09-21 12:36 | 2026-09-21 12:36 | 2026-09-21 12:36 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.5500 | 21.5000 | 21.9500 | 442.2950 | 34480.00 | 15085.00 | 19395.00 | 16 | 9 | 1827 | 1694 | 1.07851239669421 | 0.350349192415646 | 0.350349192415646 | false | false | false | true | ||||||||||||||||
| afb4b119-459a-46f3-9177-3fadef539c59 | 2026-09-21 12:36 | 2026-09-21 12:36 | 2026-09-21 12:36 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.5500 | 21.5000 | 21.5500 | 442.2800 | 71115.00 | 6465.00 | 0.00 | 33 | 10 | 1588 | 1694 | 0.937426210153483 | 0.35029396997762 | 0.35029396997762 | true | false | false | true | ||||||||||||||||
| 8c1c93e4-4783-44f8-9a0e-9d5bc469b2b8 | 2026-09-21 12:36 | 2026-09-21 12:36 | 2026-09-21 12:36 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.6000 | 21.5500 | 21.9500 | 442.2900 | 313200.00 | 6480.00 | 306720.00 | 145 | 18 | 1154 | 1694 | 0.681227863046045 | 0.35073448634236 | 0.350881802675706 | false | false | false | true | ||||||||||||||||
| 5aa73399-f629-42e3-acc9-5d2302c4a444 | 2026-09-21 12:36 | 2026-09-21 12:36 | 2026-09-21 12:36 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.6000 | 21.6000 | 22.0000 | 442.2500 | 244080.00 | 0.00 | 244080.00 | 113 | 6 | 1005 | 1694 | 0.593270365997639 | 0.35073448634236 | 0.35073448634236 | false | false | false | true | ||||||||||||||||
| f5eb92ae-e7f4-4463-9923-bab21b1ab6f6 | 2026-09-21 12:36 | 2026-09-21 12:36 | 2026-09-21 12:36 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.6500 | 21.6500 | 22.0000 | 442.2300 | 515270.00 | 0.00 | 515270.00 | 238 | 10 | 590 | 1694 | 0.348288075560803 | 0.351174837266888 | 0.351211688762235 | true | false | false | true | ||||||||||||||||
| c96722ce-a2e3-41dc-b2ab-7a23ccb60d52 | 2026-09-21 12:36 | 2026-09-21 12:36 | 2026-09-21 12:36 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.7000 | 21.6500 | 22.0000 | 442.2000 | 156240.00 | 0.00 | 156240.00 | 72 | 9 | 334 | 1694 | 0.197166469893743 | 0.35165189290106 | 0.35165189290106 | true | false | false | true | ||||||||||||||||
| 5a934b9d-7e32-43bf-b799-4cfc88bac17e | 2026-09-21 12:36 | 2026-09-21 12:36 | 2026-09-21 12:36 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.6500 | 21.6000 | 22.0000 | 442.2500 | 62785.00 | 2165.00 | 60620.00 | 29 | 7 | 619 | 1694 | 0.365407319952774 | 0.351285382668559 | 0.351285382668559 | false | false | false | true | ||||||||||||||||
| 8d7631cf-b167-4d67-ace7-0b4080447f16 | 2026-09-21 12:36 | 2026-09-21 12:36 | 2026-09-21 12:36 | TSM | TSM270115P00420000 | put | 420.0000 | 2027-01-15 | 21.7000 | 21.6500 | 22.0000 | 442.1500 | 325485.00 | 15260.00 | 310225.00 | 150 | 42 | 177 | 1694 | 0.104486422668241 | 0.350916791939741 | 0.352568712317684 | true | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Technology |
| 2308720792967.00 |
| 2026-10-15 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:06:05.917319Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Technology |
| 2308720792967.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:43:51.748700Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Technology |
| 2308720792967.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:12:05.796133Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T17:12:05.796133Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:51:16.040164Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 2308720792967.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Technology |
| 2308720792967.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |