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_alerts609,118 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 | strike |
|---|
| 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 |
|---|
| cb17f36a-5e48-46b6-925a-92807e92e744 | 2026-08-31 12:24 | 2026-08-31 12:24 | 2026-08-31 12:24 | META | META260918P00550000 | put | 550.0000 | 2026-09-18 | 7.6000 | 7.4500 | 7.7000 | 570.8000 | 114760.00 | 114000.00 | 760.00 | 151 | 19 | 1032 | 12764 | 0.0808523973675964 | 0.327462253036654 | 0.327462253036654 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1467733535590.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T16:39:59.140702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 36211593-5512-410d-a593-db3956e65079 | 2026-08-28 11:07 | 2026-08-28 11:07 | 2026-08-28 11:07 | META | META260918P00550000 | put | 550.0000 | 2026-09-18 | 5.3500 | 5.2000 | 5.5000 | 587.0501 | 267500.00 | 69015.00 | 0.00 | 500 | 7 | 1484 | 12454 | 0.119158503292115 | 0.34106576847493 | 0.34106576847493 | false | false | false | |||||||||||||||||
| a0bbd3c2-222f-4dc6-8703-9236f28492e4 | 2026-08-27 15:59 | 2026-08-27 15:59 | 2026-08-27 15:59 | META | META260918P00550000 | put | 550.0000 | 2026-09-18 | 9.6000 | 9.2000 | 9.6500 | 571.0124 | 378212.00 | 373412.00 | 4800.00 | 394 | 38 | 1369 | 13159 | 0.104035261038073 | 0.340523157452502 | 0.340414387467009 | false | false | false | |||||||||||||||||
| 298efa7c-dc13-496b-9ca7-255d5f5ff6c9 | 2026-08-27 11:16 | 2026-08-27 11:16 | 2026-08-27 11:16 | META | META260918P00550000 | put | 550.0000 | 2026-09-18 | 9.6000 | 9.6000 | 9.7500 | 572.4300 | 128640.00 | 0.00 | 128640.00 | 134 | 22 | 576 | 13159 | 0.0437723231248575 | 0.349114727195931 | 0.349114727195931 | true | false | false | |||||||||||||||||
| a6591399-f429-4e60-a007-d1c4420fd4d0 | 2026-08-26 10:25 | 2026-08-26 10:25 | 2026-08-26 10:25 | META | META260918P00550000 | put | 550.0000 | 2026-09-18 | 11.2000 | 11.1000 | 11.2000 | 569.8000 | 133280.00 | 133280.00 | 0.00 | 119 | 9 | 2759 | 12254 | 0.225150971111474 | 0.357409339612064 | 0.357409339612064 | false | false | false | |||||||||||||||||
| db037ade-e9d6-4d8e-bc4e-7eef4ef8499e | 2026-08-26 10:19 | 2026-08-26 10:19 | 2026-08-26 10:19 | META | META260918P00550000 | put | 550.0000 | 2026-09-18 | 13.1000 | 12.8500 | 13.1000 | 564.7100 | 119210.00 | 119210.00 | 0.00 | 91 | 29 | 2509 | 12254 | 0.20474946956096 | 0.361680871094572 | 0.360717381823355 | false | false | false | |||||||||||||||||
| 0d2ccfb5-110a-4018-8de9-22d3d2959245 | 2026-08-26 10:15 | 2026-08-26 10:15 | 2026-08-26 10:15 | META | META260918P00550000 | put | 550.0000 | 2026-09-18 | 12.3500 | 12.2500 | 12.3500 | 567.2550 | 124735.00 | 91390.00 | 0.00 | 101 | 13 | 2302 | 12254 | 0.187857026277134 | 0.363367868572334 | 0.363367868572334 | false | false | false | |||||||||||||||||
| efb671d3-0c6e-4760-93f2-af4863d633e9 | 2026-08-26 10:12 | 2026-08-26 10:12 | 2026-08-26 10:12 | META | META260918P00550000 | put | 550.0000 | 2026-09-18 | 12.0000 | 11.9000 | 12.0000 | 568.5600 | 121200.00 | 99600.00 | 0.00 | 101 | 13 | 2181 | 12254 | 0.177982699526685 | 0.365079858705393 | 0.365079858705393 | false | false | false | |||||||||||||||||
| 04c90925-5b9b-4852-be74-bee82f7bbaf4 | 2026-08-26 10:12 | 2026-08-26 10:12 | 2026-08-26 10:12 | META | META260918P00550000 | put | 550.0000 | 2026-09-18 | 11.9500 | 11.9000 | 11.9500 | 568.5132 | 119500.00 | 57360.00 | 0.00 | 100 | 20 | 2080 | 12254 | 0.169740492900277 | 0.363814953184643 | 0.363814953184643 | false | false | false | |||||||||||||||||
| 78485797-fd56-4f7e-9c55-fd4f5213ff7e | 2026-08-26 09:45 | 2026-08-26 09:45 | 2026-08-26 09:45 | META | META260918P00550000 | put | 550.0000 | 2026-09-18 | 13.3000 | 13.3000 | 13.8500 | 564.4100 | 106426.00 | 1345.00 | 105081.00 | 80 | 27 | 1776 | 12254 | 0.144932267014852 | 0.361520548810785 | 0.362455418311095 | true | false | false | |||||||||||||||||
| dbdb0540-29b7-41d3-9180-6a89e1057b55 | 2026-08-26 09:36 | 2026-08-26 09:36 | 2026-08-26 09:36 | META | META260918P00550000 | put | 550.0000 | 2026-09-18 | 10.8000 | 10.5000 | 10.8000 | 572.9100 | 124200.00 | 124200.00 | 0.00 | 115 | 8 | 1130 | 12254 | 0.0922147870083238 | 0.368550611874513 | 0.368661213252721 | false | false | false | |||||||||||||||||
| 7b980bb3-afd8-4d2e-aafa-44140464e5dd | 2026-08-18 10:36 | 2026-08-18 10:36 | 2026-08-18 10:36 | META | META260918P00550000 | put | 550.0000 | 2026-09-18 | 22.8000 | 22.7000 | 23.1500 | 547.4700 | 232560.00 | 0.00 | 232560.00 | 102 | 14 | 949 | 12011 | 0.0790109066688869 | 0.352282281483021 | 0.352206823418917 | false | false | false | |||||||||||||||||
| c65467cf-bfa2-41fd-a4ef-31eeb0b5569d | 2026-08-18 09:47 | 2026-08-18 09:47 | 2026-08-18 09:47 | META | META260918P00550000 | put | 550.0000 | 2026-09-18 | 23.3000 | 23.3000 | 23.4500 | 547.0000 | 186400.00 | 0.00 | 186400.00 | 80 | 6 | 449 | 12011 | 0.0373823994671551 | 0.358007638332964 | 0.358007638332964 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:32:48.312014Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |