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 | expirydate | price |
|---|
| 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 |
|---|
| ac5f41bf-1066-4fa1-b3f6-f3dffa948787 | 2026-08-18 13:45 | 2026-08-18 13:45 | 2026-08-18 13:45 | SITM | SITM271217P00330000 | put | 330.0000 | 2027-12-17 | 43.8000 | 40.1000 | 43.8000 | 678.7950 | 78840.00 | 78840.00 | 0.00 | 18 | 8 | 130 | 2 | 65 | 0.794725932625313 | 0.794725932625313 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 16790162951.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6e2c10fc-5663-4c85-ba19-d1c92d243bb9 | 2026-08-18 11:21 | 2026-08-18 11:20 | 2026-08-18 11:20 | SITM | SITM260918P00590000 | put | 590.0000 | 2026-09-18 | 23.4000 | 20.7000 | 23.4000 | 673.3000 | 152100.00 | 152100.00 | 0.00 | 65 | 22 | 72 | 3 | 24 | 0.766344377689581 | 0.766344377689581 | false | false | false | true | false | |||||||||||||||
| f45ae3ef-0e66-4de8-9c34-1073ff0477ab | 2026-08-18 09:56 | 2026-08-18 09:55 | 2026-08-18 09:55 | SITM | SITM271217P00320000 | put | 320.0000 | 2027-12-17 | 41.3000 | 37.0000 | 41.3000 | 693.8900 | 74340.00 | 74340.00 | 0.00 | 18 | 5 | 92 | 0 | 0 | 0.811060497603166 | 0.811060497603166 | false | false | false | true | false | |||||||||||||||
| 3313bde0-92c9-4c89-8b4d-05f5208b23cb | 2026-08-18 09:30 | 2026-08-18 09:30 | 2026-08-18 09:30 | SITM | SITM261120C00680000 | call | 680.0000 | 2026-11-20 | 135.1000 | 130.3000 | 146.1000 | 711.6900 | 135100.00 | 0.00 | 135100.00 | 10 | 5 | 10 | 241 | 0.04149377593361 | 0.825388168939214 | 0.825388168939214 | false | false | false | true | false | |||||||||||||||
| 4f97b027-4c3d-47fc-b55f-202411950827 | 2026-08-17 12:01 | 2026-08-17 12:01 | 2026-08-17 12:01 | SITM | SITM260821P00700000 | put | 700.0000 | 2026-08-21 | 7.5000 | 7.5000 | 8.4000 | 751.0100 | 22500.00 | 0.00 | 7500.00 | 30 | 15 | 39 | 112 | 0.348214285714286 | 0.835599883825182 | 0.835599883825182 | false | false | false | true | false | |||||||||||||||
| f0f77969-701d-4950-9409-5906bb619bc3 | 2026-08-17 10:05 | 2026-08-17 10:04 | 2026-08-17 10:04 | SITM | SITM260821C00760000 | call | 760.0000 | 2026-08-21 | 21.2000 | 20.9000 | 21.2000 | 745.9700 | 23319.00 | 23319.00 | 0.00 | 11 | 7 | 11 | 72 | 0.152777777777778 | 0.875477250724407 | 0.875152486609155 | false | false | false | true | false | |||||||||||||||
| e556b162-6eea-4fb3-b5f2-ad3caf44dec0 | 2026-08-17 10:05 | 2026-08-17 10:04 | 2026-08-17 10:04 | SITM | SITM260821C00770000 | call | 770.0000 | 2026-08-21 | 17.2000 | 17.0000 | 17.3000 | 745.9700 | 80858.00 | 55358.00 | 25500.00 | 47 | 10 | 48 | 23 | 2.08695652173913 | 0.870754229013983 | 0.870754229013983 | false | false | false | true | false | |||||||||||||||
| 2abe3f66-415d-447d-901b-9bb768eb284c | 2026-08-17 10:05 | 2026-08-17 10:04 | 2026-08-17 10:04 | SITM | SITM260821C00780000 | call | 780.0000 | 2026-08-21 | 14.0100 | 13.8000 | 14.1000 | 745.9700 | 49050.00 | 35250.00 | 13800.00 | 35 | 9 | 35 | 59 | 0.593220338983051 | 0.871759844456974 | 0.871759844456974 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 16790162951.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:23:23.944279Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 16790162951.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 16790162951.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 16790162951.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 16790162951.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 16790162951.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 16790162951.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |