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 |
|---|
| b07a2d39-7648-491f-9f84-e62c5b000296 | 2026-09-18 14:10 | 2026-09-18 14:09 | 2026-09-18 14:09 | WIX | WIX261016P00060000 | put | 60.0000 | 2026-10-16 | 0.4100 | 0.2000 | 0.4500 | 80.9600 | 16350.00 | 16350.00 | 0.00 | 398 | 21 | 409 | 1537 | 0.266102797657775 | 0.724444110223433 | 0.744222378371768 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 4316127660.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 89bfa9b5-9fa5-4c5f-a36d-866dde1383ff | 2026-09-18 14:21 | 2026-09-18 14:21 | 2026-09-18 14:21 | WIX | WIX261016P00060000 | put | 60.0000 | 2026-10-16 | 0.4400 | 0.2500 | 0.5000 | 80.7300 | 19248.00 | 8555.00 | 5383.00 | 433 | 18 | 846 | 1537 | 0.550422901756669 | 0.739080603069291 | 0.735232684315717 | false | false | false | |||||||||||||||||
| dd56d81a-7904-444d-924d-cf451c0df271 | 2026-09-18 15:24 | 2026-09-18 15:24 | 2026-09-18 15:24 | WIX | WIX261016P00060000 | put | 60.0000 | 2026-10-16 | 0.6000 | 0.3500 | 0.6500 | 80.5700 | 15188.00 | 14638.00 | 550.00 | 254 | 44 | 1614 | 1537 | 1.05009759271308 | 0.792222664625532 | 0.771770955261902 | false | false | false | |||||||||||||||||
| ec4134ec-769b-4d5d-a8fc-e016e96e2ee7 | 2026-09-18 15:25 | 2026-09-18 15:25 | 2026-09-18 15:25 | WIX | WIX261016P00060000 | put | 60.0000 | 2026-10-16 | 0.6000 | 0.0500 | 0.8000 | 80.5750 | 16858.00 | 16738.00 | 0.00 | 281 | 30 | 2007 | 1537 | 1.30579050097593 | 0.788835817839862 | 0.788835817839862 | false | false | false | |||||||||||||||||
| 1ae7627e-75f8-4a62-a2de-45724070f8d1 | 2026-09-18 15:26 | 2026-09-18 15:26 | 2026-09-18 15:26 | WIX | WIX261016P00060000 | put | 60.0000 | 2026-10-16 | 0.6000 | 0.4000 | 0.8000 | 80.4400 | 12720.00 | 11880.00 | 0.00 | 212 | 7 | 2911 | 1537 | 1.8939492517892 | 0.785673221748229 | 0.785673221748229 | false | false | false | |||||||||||||||||
| 55cc01c8-f4fc-420d-a823-927f6e6d37ec | 2026-09-18 15:26 | 2026-09-18 15:26 | 2026-09-18 15:26 | WIX | WIX261016P00060000 | put | 60.0000 | 2026-10-16 | 0.6000 | 0.3500 | 0.7500 | 80.3200 | 13345.00 | 8485.00 | 3600.00 | 222 | 9 | 3133 | 1537 | 2.03838646714379 | 0.782854425963096 | 0.799088116599904 | false | false | false | |||||||||||||||||
| f52e26f8-387b-47f7-b0df-bd642bf332fe | 2026-09-18 15:29 | 2026-09-18 15:29 | 2026-09-18 15:29 | WIX | WIX261016P00060000 | put | 60.0000 | 2026-10-16 | 0.6000 | 0.4000 | 0.6500 | 80.1900 | 14098.00 | 14098.00 | 0.00 | 235 | 8 | 3415 | 1537 | 2.22186076772934 | 0.779792607166874 | 0.776478858039508 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4316127660.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4316127660.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4316127660.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4316127660.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4316127660.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4316127660.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |