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_alerts425,429 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 |
|---|
| 5cb73514-47ca-42f7-afd0-a000645d0f14 | 2026-08-21 15:17 | 2026-08-21 15:17 | 2026-08-21 15:17 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 11.3400 | 11.1500 | 11.3500 | 345.2500 | 139525.00 | 121445.00 | 18080.00 | 123 | 20 | 132 | 300 | 0.44 | 0.284076152575887 | 0.284076152575887 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2050220520000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:32:44.160800Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 79ea05a5-7709-4375-83ae-1e4f4dbc9721 | 2026-09-22 12:22 | 2026-09-22 12:22 | 2026-09-22 12:22 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 1.6900 | 1.6000 | 1.6900 | 352.9400 | 73853.00 | 73853.00 | 0.00 | 437 | 36 | 1566 | 4622 | 0.338814366075292 | 0.369095411801371 | 0.368372497912893 | false | false | false | |||||||||||||||||
| 1aab56d4-58b1-41e6-8e68-21c94b29659a | 2026-09-22 12:43 | 2026-09-22 12:43 | 2026-09-22 12:43 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 2.2700 | 2.2700 | 2.3900 | 351.2000 | 74684.00 | 228.00 | 74456.00 | 329 | 33 | 2526 | 4622 | 0.546516659454781 | 0.377671662240514 | 0.380459693499071 | true | false | false | |||||||||||||||||
| 13fe17dc-1c37-46c7-823d-abead20c4938 | 2026-09-22 13:14 | 2026-09-22 13:14 | 2026-09-22 13:14 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 2.2300 | 2.2200 | 2.3300 | 351.0500 | 46830.00 | 0.00 | 44600.00 | 210 | 17 | 3413 | 4622 | 0.738424924275206 | 0.371878868639442 | 0.371878868639442 | true | false | false | |||||||||||||||||
| add1e639-d68d-4895-9e1c-abc151f196ca | 2026-09-22 15:56 | 2026-09-22 15:56 | 2026-09-22 15:56 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 2.1000 | 2.1000 | 2.1400 | 351.1200 | 18060.00 | 0.00 | 18060.00 | 86 | 7 | 4011 | 4622 | 0.867806144526179 | 0.361819680481593 | 0.361819680481593 | false | false | false | |||||||||||||||||
| 35e06582-af97-4d4d-ab83-587a7210aa26 | 2026-09-22 15:56 | 2026-09-22 15:56 | 2026-09-22 15:56 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 2.1400 | 2.1400 | 2.1500 | 351.0000 | 13054.00 | 0.00 | 13054.00 | 61 | 7 | 4093 | 4622 | 0.885547382085677 | 0.362310792692376 | 0.362310792692376 | false | false | false | |||||||||||||||||
| c861026b-c41d-40f3-a86e-96cffa06be85 | 2026-09-23 09:56 | 2026-09-23 09:56 | 2026-09-23 09:56 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 4.2000 | 4.2000 | 4.4500 | 344.3699 | 22260.00 | 0.00 | 22260.00 | 53 | 8 | 1595 | 5727 | 0.278505325650428 | 0.384793100673778 | 0.384793100673778 | false | false | false | |||||||||||||||||
| 6854fb50-a8e9-4e3a-88cd-06b5a78fcc46 | 2026-09-23 10:02 | 2026-09-23 10:02 | 2026-09-23 10:02 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 5.1500 | 4.9500 | 5.1500 | 342.0000 | 99894.00 | 99894.00 | 0.00 | 194 | 25 | 2084 | 5727 | 0.363890343984634 | 0.397763020014631 | 0.392559362327138 | false | false | false | |||||||||||||||||
| 505172f2-fdba-40be-9f32-e88e6e99ac78 | 2026-09-23 15:57 | 2026-09-23 15:57 | 2026-09-23 15:57 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 8.3100 | 8.2000 | 8.4000 | 337.9000 | 34888.00 | 23268.00 | 0.00 | 42 | 5 | 5686 | 5727 | 0.992840928933124 | 0.378027503329553 | 0.378027503329553 | false | false | false | |||||||||||||||||
| 4a38151b-5f91-4cab-b1f5-c5fa78c826bd | 2026-09-24 12:29 | 2026-09-24 12:29 | 2026-09-24 12:29 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 5.2000 | 5.1500 | 5.3000 | 340.8900 | 103520.00 | 3640.00 | 32800.00 | 199 | 26 | 954 | 4295 | 0.222118742724098 | 0.375271420235491 | 0.375271420235491 | false | false | false | |||||||||||||||||
| 83a1db9b-f313-4831-9f01-aba7711a63e9 | 2026-09-24 12:29 | 2026-09-24 12:29 | 2026-09-24 12:29 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 5.2000 | 5.1000 | 5.2500 | 340.9100 | 76440.00 | 72280.00 | 0.00 | 147 | 18 | 1109 | 4295 | 0.258207217694994 | 0.377690210451637 | 0.377690210451637 | false | false | false | |||||||||||||||||
| 28574aab-928c-484d-8b6f-5384bb100e72 | 2026-09-24 12:29 | 2026-09-24 12:29 | 2026-09-24 12:29 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 5.1500 | 5.1000 | 5.1500 | 340.9300 | 21630.00 | 18025.00 | 0.00 | 42 | 6 | 1151 | 4295 | 0.267986030267753 | 0.371743980839178 | 0.371743980839178 | false | false | false | |||||||||||||||||
| a5044fb9-018f-4035-ade0-df81b61f8f23 | 2026-09-24 12:29 | 2026-09-24 12:29 | 2026-09-24 12:29 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 5.1500 | 5.1000 | 5.1500 | 340.9200 | 126175.00 | 40170.00 | 0.00 | 245 | 20 | 1396 | 4295 | 0.325029103608848 | 0.370528248702866 | 0.370528248702866 | false | false | false | |||||||||||||||||
| d4f75249-08df-46bb-b8b0-b964bc40544d | 2026-09-24 12:29 | 2026-09-24 12:29 | 2026-09-24 12:29 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 5.1500 | 5.1000 | 5.1500 | 340.9300 | 19055.00 | 9785.00 | 0.00 | 37 | 5 | 1446 | 4295 | 0.336670547147846 | 0.371743980839178 | 0.371743980839178 | false | false | false | |||||||||||||||||
| bd5670af-6526-4ada-925d-1b58dd431154 | 2026-09-24 12:29 | 2026-09-24 12:29 | 2026-09-24 12:29 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 5.1500 | 5.1000 | 5.1500 | 340.9600 | 90640.00 | 90640.00 | 0.00 | 176 | 35 | 1622 | 4295 | 0.377648428405122 | 0.375364204138582 | 0.375364204138582 | false | false | false | |||||||||||||||||
| 3659f17d-d499-4571-8d95-73e897aa2070 | 2026-09-24 12:29 | 2026-09-24 12:29 | 2026-09-24 12:29 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 5.1500 | 5.1000 | 5.1500 | 340.9500 | 100425.00 | 50985.00 | 0.00 | 195 | 20 | 1817 | 4295 | 0.423050058207218 | 0.369918661241664 | 0.374161896583619 | false | false | false | |||||||||||||||||
| 0b4fd60e-3be4-4264-8b7f-84831936a97c | 2026-09-24 12:30 | 2026-09-24 12:29 | 2026-09-24 12:29 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 5.1500 | 5.0000 | 5.1500 | 341.0100 | 89610.00 | 89610.00 | 0.00 | 174 | 17 | 1997 | 4295 | 0.464959254947614 | 0.381311594771819 | 0.381311594771819 | false | false | false | |||||||||||||||||
| c38b8947-1e5e-4739-8e6f-94b6a9b2d9b3 | 2026-09-24 12:30 | 2026-09-24 12:29 | 2026-09-24 12:29 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 5.1500 | 5.1000 | 5.1500 | 340.9000 | 10300.00 | 515.00 | 0.00 | 20 | 19 | 2017 | 4295 | 0.469615832363213 | 0.368082915052689 | 0.368082915052689 | false | false | false | |||||||||||||||||
| 6c85d2e8-5a8e-43af-a1a5-e4ee24fa79f5 | 2026-09-24 12:35 | 2026-09-24 12:34 | 2026-09-24 12:34 | GOOGL | GOOGL260925P00345000 | put | 345.0000 | 2026-09-25 | 4.8000 | 4.7500 | 4.9000 | 341.3500 | 19680.00 | 17280.00 | 2400.00 | 41 | 5 | 2368 | 4295 | 0.551338766006985 | 0.363566753289386 | 0.363566753289386 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:27:20.551854Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:48:50.097062Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:14:46.677665Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:57:01.829367Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:02:33.967509Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:57:58.068578Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:36:42.025876Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |