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_alerts658,639 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 |
|---|
| 3d2db707-1cb5-4eb3-a897-005d41b1bf76 | 2026-09-28 10:59 | 2026-09-28 10:59 | 2026-09-28 10:59 | SNXX | SNXX280121C00027000 | call | 27.0000 | 2028-01-21 | 7.5000 | 6.9000 | 7.5000 | 15.5850 | 14997.00 | 14997.00 | 0.00 | 20 | 5 | 28 | 656 | 0.0426829268292683 | 1.41784625448865 | 1.42104931816211 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 13229825.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T15:01:52.060675Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 8633c6d2-4bb2-436d-83a9-18b49977ddb9 | 2026-09-24 15:01 | 2026-09-24 15:01 | 2026-09-24 15:01 | SNXX | SNXX270319P00017000 | put | 17.0000 | 2027-03-19 | 6.5000 | 6.1000 | 6.5000 | 16.9503 | 617379.00 | 617379.00 | 0.00 | 950 | 19 | 1007 | 75 | 13.4266666666667 | 1.49011275946991 | 1.49288056300117 | true | false | false | true | ||||||||||||||||
| 2f63720b-8635-4b5f-85d4-4254820df9c7 | 2026-09-22 10:45 | 2026-09-22 10:45 | 2026-09-22 10:45 | SNXX | SNXX261002C00020000 | call | 20.0000 | 2026-10-02 | 1.8300 | 1.7500 | 2.1500 | 19.5700 | 17595.00 | 0.00 | 17595.00 | 96 | 7 | 645 | 1872 | 0.344551282051282 | 1.49521814875404 | 1.6501864660261 | false | false | false | true | ||||||||||||||||
| ed2e40c1-67c0-4b13-83db-ab67177b98ca | 2026-09-21 15:51 | 2026-09-21 15:51 | 2026-09-21 15:51 | SNXX | SNXX260925C00018000 | call | 18.0000 | 2026-09-25 | 0.8000 | 0.8000 | 0.8500 | 17.3350 | 12031.00 | 0.00 | 12031.00 | 150 | 12 | 2387 | 1669 | 1.43019772318754 | 1.48932292134576 | 1.50331195902395 | false | false | false | true | ||||||||||||||||
| 0faf9dd4-ac4b-41d4-bf15-7820154f2d51 | 2026-09-17 09:44 | 2026-09-17 09:44 | 2026-09-17 09:44 | SNXX | SNXX260925C00017000 | call | 17.0000 | 2026-09-25 | 0.4500 | 0.4000 | 0.5000 | 14.6101 | 11280.00 | 1260.00 | 10020.00 | 250 | 6 | 394 | 1335 | 0.295131086142322 | 1.396033662434 | 1.42191792564616 | false | false | false | true | ||||||||||||||||
| 5f57e8ee-5721-4bd3-9a9d-69130694c8ca | 2026-09-17 09:42 | 2026-09-17 09:41 | 2026-09-17 09:41 | SNXX | SNXX261016P00015000 | put | 15.0000 | 2026-10-16 | 2.4900 | 2.3500 | 2.5000 | 14.5450 | 22453.00 | 22453.00 | 0.00 | 90 | 6 | 213 | 191 | 1.1151832460733 | 1.38367348171804 | 1.38367348171804 | false | false | false | true | ||||||||||||||||
| e16589fb-7aa6-4d20-b624-cf0cee5a70fa | 2026-09-11 11:05 | 2026-09-11 11:05 | 2026-09-11 11:05 | SNXX | SNXX261009C00020000 | call | 20.0000 | 2026-10-09 | 1.0200 | 1.0000 | 1.2000 | 15.3801 | 16500.00 | 0.00 | 16500.00 | 162 | 5 | 265 | 184 | 1.44021739130435 | 1.39309603043962 | 1.41284741186298 | false | false | false | true | ||||||||||||||||
| d7623cd2-7c41-4dc9-b758-27f43d4aed6e | 2026-09-04 15:41 | 2026-09-04 15:41 | 2026-09-04 15:41 | SNXX | SNXX260911C00016000 | call | 16.0000 | 2026-09-11 | 1.8500 | 1.7500 | 1.8500 | 17.0500 | 15341.00 | 15341.00 | 0.00 | 83 | 7 | 1814 | 3184 | 0.569723618090452 | 1.35822922037685 | 1.35822922037685 | false | false | false | true | ||||||||||||||||
| eea7847e-dbfd-41fe-a9f4-a4be522f13e8 | 2026-08-31 09:58 | 2026-08-31 09:58 | 2026-08-31 09:58 | SNXX | SNXX260911C00016000 | call | 16.0000 | 2026-09-11 | 0.5100 | 0.5000 | 0.5500 | 13.5700 | 50796.00 | 0.00 | 50796.00 | 1000 | 9 | 1044 | 191 | 5.46596858638743 | 1.35897236208201 | 1.37150208157771 | false | false | false | true | ||||||||||||||||
| 8da7e5ac-3826-48e4-aa3b-aef8935128cc | 2026-08-24 10:34 | 2026-08-24 10:34 | 2026-08-24 10:34 | SNXX | SNXX260828P00012000 | put | 12.0000 | 2026-08-28 | 0.8100 | 0.8000 | 0.9000 | 12.2050 | 16142.00 | 0.00 | 16142.00 | 200 | 16 | 878 | 702 | 1.25071225071225 | 1.7818281746861 | 1.8057918527702 | false | false | false | true | ||||||||||||||||
| fdcd5a24-2d59-461a-bb43-dca9e41aaccd | 2026-08-24 09:34 | 2026-08-24 09:34 | 2026-08-24 09:34 | SNXX | SNXX260828P00011000 | put | 11.0000 | 2026-08-28 | 0.4500 | 0.3500 | 0.4500 | 12.4086 | 13473.00 | 13473.00 | 0.00 | 300 | 7 | 670 | 792 | 0.845959595959596 | 2.00838546300194 | 2.0326586343434 | false | false | false | true | ||||||||||||||||
| 450af390-d6b0-4a5c-8e74-5f9013046725 | 2026-08-21 14:02 | 2026-08-21 14:02 | 2026-08-21 14:02 | SNXX | SNXX260828C00017000 | call | 17.0000 | 2026-08-28 | 0.6100 | 0.6000 | 0.6500 | 15.1500 | 10918.00 | 0.00 | 10918.00 | 180 | 5 | 2445 | 1394 | 1.75394548063128 | 1.49156168088475 | 1.50477070375229 | false | false | false | true | ||||||||||||||||
| 96ab256e-da6c-47dc-ab39-a2f3f560c076 | 2026-08-17 11:26 | 2026-08-17 11:26 | 2026-08-17 11:26 | SNXX | SNXX260821P00018000 | put | 18.0000 | 2026-08-21 | 1.0000 | 0.9000 | 1.0000 | 19.4650 | 33454.00 | 33454.00 | 0.00 | 335 | 9 | 3202 | 674 | 4.75074183976261 | 2.0637697310596 | 2.0912511462537 | false | false | false | true | ||||||||||||||||
| 28803790-9460-4aa1-9886-2fb8a3bbda8b | 2026-08-17 11:19 | 2026-08-17 11:19 | 2026-08-17 11:19 | SNXX | SNXX261218C00021880 | call | 21.8800 | 2026-12-18 | 7.1900 | 5.8000 | 8.0000 | 19.4104 | 143832.00 | 143832.00 | 0.00 | 200 | 16 | 219 | 116 | 1.88793103448276 | 1.80950106183304 | 1.80950106183304 | false | false | false | true | ||||||||||||||||
| 6d4c7107-bfdb-4dde-9fae-12f1dcabf9f5 | 2026-08-17 10:09 | 2026-08-17 10:09 | 2026-08-17 10:09 | SNXX | SNXX260821C00017000 | call | 17.0000 | 2026-08-21 | 2.3500 | 2.3500 | 2.4000 | 18.5400 | 13399.00 | 0.00 | 13399.00 | 57 | 17 | 657 | 1567 | 0.419272495213784 | 1.95452664652567 | 1.95452664652567 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:02:51.984196Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:45:53.881330Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:52:57.186278Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:47:44.789077Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:47:44.789077Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:47:04.296573Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:02:22.723941Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:35:34.147296Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:38:06.174043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |