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 |
|---|
| 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 |
|---|
| 74faf434-d00c-40ee-9658-4546d56c14e9 | 2026-08-17 09:58 | 2026-08-17 09:58 | 2026-08-17 09:58 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 1.0400 | 0.8500 | 1.0400 | 275.7900 | 52000.00 | 52000.00 | 0.00 | 500 | 40 | 784 | 1255 | 0.624701195219123 | 1.3132809196733 | 1.3132809196733 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 46568297023.00 | — | 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 |
| a630b754-e08a-4801-98d4-b8360c888bf3 | 2026-08-19 09:38 | 2026-08-19 09:38 | 2026-08-19 09:38 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 7.2600 | 7.1500 | 7.5000 | 227.9700 | 105325.00 | 29127.00 | 76198.00 | 145 | 27 | 364 | 3005 | 0.121131447587354 | 1.29767912835743 | 1.29767912835743 | false | false | false | true | ||||||||||||||||
| 91117ac6-99d4-42d4-b122-af97a4169ce3 | 2026-08-19 09:41 | 2026-08-19 09:41 | 2026-08-19 09:41 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 8.3000 | 7.9500 | 8.5000 | 225.2100 | 120350.00 | 120350.00 | 0.00 | 145 | 35 | 723 | 3005 | 0.240599001663894 | 1.26837775354936 | 1.26837775354936 | true | false | false | true | ||||||||||||||||
| a63946e2-33b9-48f8-b4ac-d04bd9529fdf | 2026-08-19 09:53 | 2026-08-19 09:53 | 2026-08-19 09:53 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 11.5700 | 11.5500 | 11.9500 | 218.6700 | 116870.00 | 1180.00 | 115690.00 | 101 | 22 | 1455 | 3005 | 0.484193011647255 | 1.23305165463299 | 1.26488088594758 | false | false | false | true | ||||||||||||||||
| ccd7e6aa-e4f0-4d69-8376-3945ed7c8363 | 2026-08-19 09:54 | 2026-08-19 09:54 | 2026-08-19 09:54 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 12.1500 | 11.7000 | 12.1500 | 218.1800 | 115425.00 | 115425.00 | 0.00 | 95 | 18 | 1582 | 3005 | 0.526455906821963 | 1.27347775149739 | 1.27347775149739 | true | false | false | true | ||||||||||||||||
| b9362932-1c5d-4a1f-bfb3-f378dae69db6 | 2026-08-19 10:11 | 2026-08-19 10:10 | 2026-08-19 10:10 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 14.0000 | 13.5000 | 14.0000 | 214.8150 | 95200.00 | 91000.00 | 0.00 | 68 | 25 | 1880 | 3005 | 0.625623960066556 | 1.20650444401191 | 1.22031225861497 | false | false | false | true | ||||||||||||||||
| 5c8d5c90-607c-4f5c-b22a-821a3cd5eff8 | 2026-08-19 11:29 | 2026-08-19 11:29 | 2026-08-19 11:29 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 6.8500 | 6.8500 | 7.2500 | 226.5297 | 50005.00 | 0.00 | 50005.00 | 73 | 9 | 3051 | 3005 | 1.0153078202995 | 1.14222199141969 | 1.14222199141969 | false | false | false | true | ||||||||||||||||
| 4cef52b4-7f2d-4b91-93ee-83c294d95b84 | 2026-08-20 09:47 | 2026-08-20 09:47 | 2026-08-20 09:47 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 11.8000 | 11.6000 | 11.8000 | 216.1700 | 50740.00 | 50740.00 | 0.00 | 43 | 22 | 172 | 2432 | 0.0707236842105263 | 1.39706154834601 | 1.40407108996848 | false | false | false | true | ||||||||||||||||
| 4c065d97-2373-49e7-adc7-e079133f3711 | 2026-08-20 09:53 | 2026-08-20 09:52 | 2026-08-20 09:52 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 13.5000 | 13.1000 | 14.0000 | 213.5002 | 135000.00 | 130950.00 | 4050.00 | 100 | 33 | 319 | 2432 | 0.131167763157895 | 1.35833602629731 | 1.33875563779676 | true | false | false | true | ||||||||||||||||
| f6303fe0-9671-4727-9d4f-6dcb46752e33 | 2026-08-20 11:31 | 2026-08-20 11:31 | 2026-08-20 11:31 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 11.7500 | 11.1500 | 11.7500 | 215.3500 | 44645.00 | 44645.00 | 0.00 | 38 | 7 | 647 | 2432 | 0.266036184210526 | 1.23741626306436 | 1.23741626306436 | false | false | false | true | ||||||||||||||||
| 81e8b38f-fe47-402d-8c07-c9756dd41ffc | 2026-08-21 09:43 | 2026-08-21 09:43 | 2026-08-21 09:43 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 2.3100 | 2.3100 | 2.3400 | 227.9000 | 28408.00 | 0.00 | 28408.00 | 123 | 29 | 494 | 2130 | 0.231924882629108 | 1.49301366285499 | 1.47950272650697 | true | false | false | true | ||||||||||||||||
| aeba734e-b9ab-4ad9-8bab-0336e856801e | 2026-08-21 10:00 | 2026-08-21 10:00 | 2026-08-21 10:00 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 2.6600 | 2.6200 | 2.7100 | 226.2506 | 26582.00 | 0.00 | 26582.00 | 100 | 9 | 964 | 2130 | 0.452582159624413 | 1.40925057027522 | 1.38005224134266 | false | false | false | true | ||||||||||||||||
| d5dc79a9-fe15-4d01-8bf3-295f941fb6a9 | 2026-08-21 10:08 | 2026-08-21 10:08 | 2026-08-21 10:08 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 3.0600 | 3.0000 | 3.3000 | 225.0700 | 30629.00 | 0.00 | 26129.00 | 100 | 5 | 1453 | 2130 | 0.682159624413146 | 1.27651479170158 | 1.34766710979358 | false | false | false | true | ||||||||||||||||
| 82403885-f9e8-43e1-a88e-d4eb4878a6dd | 2026-08-21 10:11 | 2026-08-21 10:10 | 2026-08-21 10:10 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 3.1700 | 2.7400 | 3.3500 | 225.4420 | 31700.00 | 31700.00 | 0.00 | 100 | 5 | 1561 | 2130 | 0.732863849765258 | 1.54155780339004 | 1.4334283747148 | false | false | false | true | ||||||||||||||||
| 58e0feef-5581-472e-9070-13ce447e73ef | 2026-08-21 11:20 | 2026-08-21 11:20 | 2026-08-21 11:20 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 3.4900 | 3.0000 | 3.6500 | 223.1900 | 17441.00 | 17441.00 | 0.00 | 50 | 6 | 2703 | 2130 | 1.26901408450704 | 1.19938182632751 | 1.20444101167009 | false | false | false | true | ||||||||||||||||
| 488b20f0-0cbf-4c82-90ac-713127c7933b | 2026-08-21 11:42 | 2026-08-21 11:42 | 2026-08-21 11:42 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 2.5100 | 2.3200 | 2.5100 | 224.6150 | 96133.00 | 96133.00 | 0.00 | 383 | 37 | 3125 | 2130 | 1.46713615023474 | 1.16532198400041 | 1.16532198400041 | false | false | false | true | ||||||||||||||||
| 38609eaa-cfc2-47f8-aec2-5aab6001296d | 2026-08-21 13:23 | 2026-08-21 13:23 | 2026-08-21 13:23 | NBIS | NBIS260821P00225000 | put | 225.0000 | 2026-08-21 | 5.0500 | 5.0500 | 5.6500 | 219.9000 | 208570.00 | 0.00 | 208570.00 | 413 | 27 | 3967 | 2130 | 1.86244131455399 | 1.46009881338422 | 1.46009881338422 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |