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 |
|---|
| 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 |
|---|
| 2899dccd-68b9-4d44-bd8e-23159968291c | 2026-09-24 14:29 | 2026-09-24 14:29 | 2026-09-24 14:29 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 11.7000 | 11.7000 | 11.8000 | 337.9700 | 19890.00 | 0.00 | 19890.00 | 17 | 6 | 71 | 1749 | 0.0405946255002859 | 0.34784990259268 | 0.34784990259268 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1879382770000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T18:32:33.635262Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| a7907d76-5e71-46e0-8239-8f11ad5522ee | 2026-09-23 15:55 | 2026-09-23 15:55 | 2026-09-23 15:55 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 13.0000 | 12.8000 | 13.0000 | 334.8200 | 10400.00 | 10400.00 | 0.00 | 8 | 8 | 177 | 1596 | 0.110902255639098 | 0.354908813923776 | 0.354908813923776 | true | false | false | true | false | |||||||||||||||
| e13f8f07-6ff5-4d2a-abf8-629bb942c158 | 2026-09-23 15:55 | 2026-09-23 15:55 | 2026-09-23 15:55 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 12.9000 | 12.4500 | 12.9500 | 334.9000 | 10320.00 | 5160.00 | 0.00 | 8 | 7 | 137 | 1596 | 0.0858395989974937 | 0.35377770889465 | 0.35377770889465 | true | false | false | true | false | |||||||||||||||
| f56801c9-7adb-4aae-883d-be772cc3b3b3 | 2026-09-23 15:50 | 2026-09-23 15:50 | 2026-09-23 15:50 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 12.8000 | 12.8000 | 13.4000 | 334.9500 | 10240.00 | 0.00 | 10240.00 | 8 | 8 | 93 | 1596 | 0.0582706766917293 | 0.352611236233303 | 0.352545736978588 | false | false | false | true | false | |||||||||||||||
| d7d1837f-ed38-4161-b65b-2d7e3054b06a | 2026-09-23 15:50 | 2026-09-23 15:50 | 2026-09-23 15:50 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 12.9000 | 12.9000 | 13.4000 | 334.8300 | 11613.00 | 0.00 | 11613.00 | 9 | 9 | 85 | 1596 | 0.0532581453634085 | 0.353548044866579 | 0.353548044866579 | false | false | false | true | false | |||||||||||||||
| 8af3172a-bfd6-4631-b3e4-27733bc2787f | 2026-09-23 15:48 | 2026-09-23 15:48 | 2026-09-23 15:48 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 12.8000 | 12.7500 | 12.9500 | 334.8500 | 12800.00 | 0.00 | 11520.00 | 10 | 9 | 75 | 1596 | 0.0469924812030075 | 0.352218093316624 | 0.352218093316624 | false | false | false | true | false | |||||||||||||||
| 44650c57-22c6-45ec-88ae-a8b4025fd7c3 | 2026-09-23 15:48 | 2026-09-23 15:48 | 2026-09-23 15:48 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 12.8500 | 12.7000 | 12.8500 | 334.7600 | 10277.00 | 10277.00 | 0.00 | 8 | 8 | 58 | 1596 | 0.0363408521303258 | 0.352620869153077 | 0.352620869153077 | true | false | false | true | false | |||||||||||||||
| aea38f1f-c9a1-4d2f-b3c9-da67f900e9f0 | 2026-09-23 15:48 | 2026-09-23 15:48 | 2026-09-23 15:48 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 12.8500 | 12.7000 | 13.0000 | 334.7300 | 10280.00 | 1285.00 | 8995.00 | 8 | 8 | 34 | 1596 | 0.0213032581453634 | 0.3525224071675 | 0.3525224071675 | false | false | false | true | false | |||||||||||||||
| 54e734e7-5dd5-45ad-a4b8-6a8662a9e24c | 2026-09-21 15:54 | 2026-09-21 15:54 | 2026-09-21 15:54 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 9.8500 | 9.4000 | 9.9000 | 351.0000 | 32505.00 | 5910.00 | 26595.00 | 33 | 6 | 259 | 1303 | 0.198772064466615 | 0.358217790694454 | 0.358217790694454 | false | false | false | true | false | |||||||||||||||
| f0b77ad5-8a0c-4993-8308-16f14268b78d | 2026-09-21 15:54 | 2026-09-21 15:54 | 2026-09-21 15:54 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 9.8100 | 9.6500 | 9.9000 | 351.0000 | 36283.00 | 980.00 | 35303.00 | 37 | 14 | 180 | 1303 | 0.138142747505756 | 0.357657560251932 | 0.357657560251932 | false | false | false | true | false | |||||||||||||||
| 6e2a5f7a-0207-4de9-9994-63dc952f49df | 2026-09-21 15:53 | 2026-09-21 15:53 | 2026-09-21 15:53 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 9.8000 | 9.6500 | 9.9000 | 351.0000 | 12740.00 | 980.00 | 10780.00 | 13 | 13 | 139 | 1303 | 0.106676899462778 | 0.357727347330531 | 0.357727347330531 | false | false | false | true | false | |||||||||||||||
| 5ece4965-a1ed-4379-b475-1953ba9c7401 | 2026-09-21 15:38 | 2026-09-21 15:38 | 2026-09-21 15:38 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 9.6200 | 9.6000 | 9.8000 | 352.4800 | 60617.00 | 0.00 | 60617.00 | 63 | 7 | 108 | 1303 | 0.0828856485034536 | 0.356442807419857 | 0.357356809298918 | false | false | false | true | false | |||||||||||||||
| ca7842e7-c38e-4423-b4b0-52defe2921c9 | 2026-09-21 15:30 | 2026-09-21 15:30 | 2026-09-21 15:30 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 9.6700 | 9.5500 | 9.8000 | 352.0000 | 12565.00 | 0.00 | 9655.00 | 13 | 13 | 39 | 1303 | 0.0299309286262471 | 0.356857443381457 | 0.357631471561697 | false | false | false | true | false | |||||||||||||||
| c2632d92-dc0d-425d-b168-fe10f5751b58 | 2026-09-21 15:30 | 2026-09-21 15:30 | 2026-09-21 15:30 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 9.6600 | 9.6500 | 9.8500 | 352.2200 | 21242.00 | 0.00 | 21242.00 | 22 | 11 | 25 | 1303 | 0.0191864927091328 | 0.356635324815686 | 0.356635324815686 | false | false | false | true | false | |||||||||||||||
| bb5a3bef-e5c8-45eb-b96e-e2eae78a6cf2 | 2026-09-09 12:47 | 2026-09-09 12:47 | 2026-09-09 12:47 | GOOG | GOOG270319P00295000 | put | 295.0000 | 2027-03-19 | 15.0500 | 15.0000 | 15.3000 | 327.0000 | 535797.00 | 4520.00 | 531277.00 | 356 | 34 | 356 | 856 | 0.41588785046729 | 0.345850953644393 | 0.345987411621459 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:51:14.662813Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:51:14.662813Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:51:14.662813Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:51:14.662813Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:51:14.662813Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |