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 |
|---|
| 0a958da3-3e18-48ff-97c1-b39e6e967c25 | 2026-09-15 10:23 | 2026-09-15 10:22 | 2026-09-15 10:22 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 1.2000 | 1.1900 | 1.2000 | 80.6050 | 30840.00 | 30840.00 | 0.00 | 257 | 13 | 258 | 1393 | 0.185211773151472 | 0.154276998409346 | 0.154276998409346 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47711923102.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:36:37.058930Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 519afefa-b652-47b6-acde-1eda34b57efc | 2026-09-16 09:34 | 2026-09-16 09:34 | 2026-09-16 09:34 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 0.9300 | 0.9200 | 0.9400 | 81.0200 | 29946.00 | 29295.00 | 0.00 | 322 | 10 | 322 | 1672 | 0.192583732057416 | 0.149060510105697 | 0.149060510105697 | true | false | false | |||||||||||||||||
| fd6d2c4a-75d3-4875-8da7-2ff9c4069ae1 | 2026-09-18 11:01 | 2026-09-18 11:00 | 2026-09-18 11:00 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 0.7500 | 0.7400 | 0.7600 | 81.1199 | 15900.00 | 15600.00 | 0.00 | 212 | 11 | 1170 | 2020 | 0.579207920792079 | 0.136867935081262 | 0.136867935081262 | true | false | false | |||||||||||||||||
| ffa95243-30a2-4fbf-a67b-2781a6c96c80 | 2026-09-18 15:00 | 2026-09-18 14:59 | 2026-09-18 14:59 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 0.6600 | 0.6500 | 0.6700 | 81.2544 | 23496.00 | 0.00 | 23298.00 | 356 | 10 | 1886 | 2020 | 0.933663366336634 | 0.131879521170109 | 0.131879521170109 | true | false | false | |||||||||||||||||
| 50cc441a-7def-4cd7-a271-0e3963d9f360 | 2026-09-23 09:46 | 2026-09-23 09:46 | 2026-09-23 09:46 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 0.5800 | 0.5500 | 0.5800 | 81.0000 | 32944.00 | 32944.00 | 0.00 | 568 | 11 | 693 | 4781 | 0.144948755490483 | 0.142332176753233 | 0.142332176753233 | false | false | false | |||||||||||||||||
| de6ede64-3cce-43b4-8664-fee41d68e4be | 2026-09-23 09:46 | 2026-09-23 09:46 | 2026-09-23 09:46 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 0.5800 | 0.5500 | 0.5800 | 81.0000 | 23200.00 | 23200.00 | 0.00 | 400 | 10 | 1093 | 4781 | 0.228613260824095 | 0.14215238156154 | 0.14215238156154 | false | false | false | |||||||||||||||||
| 08409d39-421c-4763-a3f9-4f14343cc0ae | 2026-09-23 10:17 | 2026-09-23 10:17 | 2026-09-23 10:17 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 0.7100 | 0.7000 | 0.7100 | 80.9950 | 22720.00 | 22720.00 | 0.00 | 320 | 7 | 1668 | 4781 | 0.348880987241163 | 0.1472034468095 | 0.1472034468095 | true | false | false | |||||||||||||||||
| 536970b8-ffba-4809-873e-221dfc8274b1 | 2026-09-23 12:59 | 2026-09-23 12:58 | 2026-09-23 12:58 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 1.0200 | 1.0200 | 1.0400 | 80.5750 | 51000.00 | 0.00 | 51000.00 | 500 | 18 | 2766 | 4781 | 0.578540054381928 | 0.165227977892692 | 0.165227977892692 | false | false | false | |||||||||||||||||
| 49fbb7e7-e376-4ebe-b705-0b9d3b262c39 | 2026-09-23 12:59 | 2026-09-23 12:59 | 2026-09-23 12:59 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 1.0200 | 1.0200 | 1.0300 | 80.5859 | 20808.00 | 0.00 | 20808.00 | 204 | 20 | 2970 | 4781 | 0.621208952102071 | 0.16644878953852 | 0.16644878953852 | false | false | false | |||||||||||||||||
| ceca5f24-5e5f-478e-a511-e400da6c416e | 2026-09-23 12:59 | 2026-09-23 12:59 | 2026-09-23 12:59 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 1.0200 | 1.0100 | 1.0300 | 80.5859 | 24888.00 | 102.00 | 24786.00 | 244 | 24 | 3214 | 4781 | 0.672244300355574 | 0.16644878953852 | 0.16644878953852 | false | false | false | |||||||||||||||||
| 0ea0d900-655c-405c-81cf-4fec7152c1f8 | 2026-09-24 11:01 | 2026-09-24 11:01 | 2026-09-24 11:01 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 1.4500 | 1.4500 | 1.4700 | 79.9900 | 14500.00 | 0.00 | 14500.00 | 100 | 6 | 2151 | 6506 | 0.330617891177375 | 0.190204621536191 | 0.190204621536191 | false | false | false | |||||||||||||||||
| d752aefe-9183-4de3-bf63-ad87afcfeb51 | 2026-09-24 11:07 | 2026-09-24 11:07 | 2026-09-24 11:07 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 1.5000 | 1.5000 | 1.5200 | 79.9350 | 46500.00 | 0.00 | 44100.00 | 310 | 35 | 2870 | 6506 | 0.441131263449124 | 0.193374665865981 | 0.193374665865981 | true | false | false | |||||||||||||||||
| 807c520a-5711-4895-a418-4f0670d60c19 | 2026-09-24 11:07 | 2026-09-24 11:07 | 2026-09-24 11:07 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 1.5000 | 1.4900 | 1.5200 | 79.9350 | 31050.00 | 0.00 | 31050.00 | 207 | 11 | 3281 | 6506 | 0.504303719643406 | 0.193374665865981 | 0.193374665865981 | true | false | false | |||||||||||||||||
| 63f77fdc-78de-4445-8b38-ecf4138fa0fd | 2026-09-24 11:07 | 2026-09-24 11:07 | 2026-09-24 11:07 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 1.5000 | 1.4900 | 1.5200 | 79.9350 | 30600.00 | 0.00 | 26400.00 | 204 | 19 | 3074 | 6506 | 0.472486935136797 | 0.193374665865981 | 0.193374665865981 | true | false | false | |||||||||||||||||
| 36039be4-53e9-4b78-b316-85337fa08782 | 2026-09-24 11:07 | 2026-09-24 11:07 | 2026-09-24 11:07 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 1.5000 | 1.4800 | 1.5200 | 79.9400 | 15000.00 | 13650.00 | 0.00 | 100 | 8 | 2257 | 6506 | 0.346910544113126 | 0.194137918200216 | 0.194137918200216 | false | false | false | |||||||||||||||||
| 0bc722a3-f979-4227-bf04-d577af3b0f25 | 2026-09-24 11:07 | 2026-09-24 11:07 | 2026-09-24 11:07 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 1.5000 | 1.5000 | 1.5200 | 79.9350 | 45450.00 | 0.00 | 45450.00 | 303 | 38 | 2560 | 6506 | 0.393482938825699 | 0.193374665865981 | 0.193374665865981 | true | false | false | |||||||||||||||||
| 9f16f40b-adac-4b6b-82c7-1687c44f13a8 | 2026-09-24 11:08 | 2026-09-24 11:08 | 2026-09-24 11:08 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 1.5000 | 1.5000 | 1.5200 | 79.9300 | 36450.00 | 0.00 | 36450.00 | 243 | 16 | 3625 | 6506 | 0.557177989548109 | 0.19260843642368 | 0.19260843642368 | true | false | false | |||||||||||||||||
| ba2dbd20-932c-4e4c-9827-99f5e88a8e4e | 2026-09-24 11:08 | 2026-09-24 11:08 | 2026-09-24 11:08 | TLT | TLT261002P00081000 | put | 81.0000 | 2026-10-02 | 1.5000 | 1.4900 | 1.5200 | 79.0000 | 31350.00 | 0.00 | 31350.00 | 209 | 15 | 3834 | 6506 | 0.589302182600676 | 0.193374665865981 | 0.193374665865981 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47037961165.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47736791502.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47736791502.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 45874461719.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:46:41.730175Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 45874461719.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:46:41.730175Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 45874461719.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:18:11.787457Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 45874461719.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:01:20.516262Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 45874461719.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:01:20.516262Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 45874461719.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:01:20.516262Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 44885332021.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:05:25.664270Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 44885332021.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:08:24.285262Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 44885332021.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:08:24.285262Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 44885332021.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:08:24.285262Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 44885332021.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:08:24.285262Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 44885332021.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:08:24.285262Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 44885332021.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:08:24.285262Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 44885332021.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:12:31.706500Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |