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 |
|---|
| 3d7c5a18-2ddd-4ff9-8e74-2b657bf33f76 | 2026-08-31 10:04 | 2026-08-31 10:04 | 2026-08-31 10:04 | CLS | CLS260911C00330000 | call | 330.0000 | 2026-09-11 | 3.5000 | 3.0000 | 3.8000 | 299.1400 | 11200.00 | 1050.00 | 0.00 | 32 | 6 | 36 | 65 | 0.553846153846154 | 0.62808938403158 | 0.62808938403158 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 36343537743.00 | 2026-10-26 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 07acb76a-7f27-4f44-8820-53f869bea0aa | 2026-08-31 10:04 | 2026-08-31 10:04 | 2026-08-31 10:04 | CLS | CLS260911C00330000 | call | 330.0000 | 2026-09-11 | 3.4000 | 2.8500 | 3.8000 | 298.9550 | 14280.00 | 340.00 | 11900.00 | 42 | 22 | 78 | 65 | 1.2 | 0.623756136603696 | 0.623756136603696 | false | false | false | |||||||||||||||||
| facb394e-4141-4a94-841c-92457f2a24f4 | 2026-08-31 10:04 | 2026-08-31 10:04 | 2026-08-31 10:04 | CLS | CLS260911C00330000 | call | 330.0000 | 2026-09-11 | 3.3000 | 3.0000 | 4.0000 | 299.2300 | 16500.00 | 330.00 | 14850.00 | 50 | 9 | 132 | 65 | 2.03076923076923 | 0.613055872138446 | 0.613055872138446 | false | false | false | |||||||||||||||||
| d6c2d4eb-82b9-48ca-a78d-6b19c6d9d670 | 2026-08-31 10:04 | 2026-08-31 10:04 | 2026-08-31 10:04 | CLS | CLS260911C00330000 | call | 330.0000 | 2026-09-11 | 3.3000 | 3.0000 | 3.6000 | 299.2300 | 12870.00 | 660.00 | 10560.00 | 39 | 5 | 171 | 65 | 2.63076923076923 | 0.613055872138446 | 0.613055872138446 | false | false | false | |||||||||||||||||
| 7f9062ea-680e-4420-b651-fc32cba71f24 | 2026-08-31 10:05 | 2026-08-31 10:05 | 2026-08-31 10:05 | CLS | CLS260911C00330000 | call | 330.0000 | 2026-09-11 | 3.3000 | 3.1000 | 4.0000 | 299.2300 | 19800.00 | 990.00 | 17490.00 | 60 | 13 | 231 | 65 | 3.55384615384615 | 0.613055872138446 | 0.613055872138446 | false | false | false | |||||||||||||||||
| 5b293cc7-2148-4d5d-81ca-5e38a223de30 | 2026-08-31 10:05 | 2026-08-31 10:05 | 2026-08-31 10:05 | CLS | CLS260911C00330000 | call | 330.0000 | 2026-09-11 | 3.3000 | 3.2000 | 4.0000 | 298.8900 | 24750.00 | 9570.00 | 15180.00 | 75 | 8 | 306 | 65 | 4.70769230769231 | 0.617693675972243 | 0.617693675972243 | false | false | false | |||||||||||||||||
| e0bb96c3-b937-4ea0-ba65-de60ba18f41e | 2026-08-31 10:05 | 2026-08-31 10:05 | 2026-08-31 10:05 | CLS | CLS260911C00330000 | call | 330.0000 | 2026-09-11 | 3.3000 | 2.9000 | 3.7000 | 299.3800 | 21120.00 | 2640.00 | 9900.00 | 64 | 14 | 437 | 65 | 6.72307692307692 | 0.611008684839726 | 0.611008684839726 | false | false | false | |||||||||||||||||
| 33ff0950-2196-49c8-9b6d-ed3d082592f4 | 2026-08-31 10:05 | 2026-08-31 10:05 | 2026-08-31 10:05 | CLS | CLS260911C00330000 | call | 330.0000 | 2026-09-11 | 3.3000 | 3.1000 | 3.8000 | 299.3800 | 21780.00 | 11880.00 | 9240.00 | 66 | 9 | 510 | 65 | 7.84615384615385 | 0.611008684839726 | 0.611008684839726 | true | false | false | |||||||||||||||||
| aec28a94-7c60-46e9-8422-f0da356cfb46 | 2026-08-31 10:07 | 2026-08-31 10:07 | 2026-08-31 10:07 | CLS | CLS260911C00330000 | call | 330.0000 | 2026-09-11 | 3.3000 | 2.9000 | 3.3000 | 299.2100 | 12540.00 | 12540.00 | 0.00 | 38 | 6 | 690 | 65 | 10.6153846153846 | 0.613328779116716 | 0.613328779116716 | false | false | false | |||||||||||||||||
| c8fb3d10-82e1-475c-8a3e-4b497a251968 | 2026-09-03 10:38 | 2026-09-03 10:38 | 2026-09-03 10:38 | CLS | CLS260911C00330000 | call | 330.0000 | 2026-09-11 | 1.3400 | 0.0500 | 1.3500 | 294.8400 | 13350.00 | 11325.00 | 0.00 | 100 | 9 | 101 | 1075 | 0.093953488372093 | 0.597052846559671 | 0.59095312140986 | false | false | false | |||||||||||||||||
| 5dd79b08-0e48-4a0a-b0b6-4570fbc8f70d | 2026-09-04 13:02 | 2026-09-04 13:02 | 2026-09-04 13:02 | CLS | CLS260911C00330000 | call | 330.0000 | 2026-09-11 | 4.0100 | 3.8000 | 4.3000 | 313.4900 | 48528.00 | 34438.00 | 14090.00 | 121 | 17 | 210 | 1134 | 0.185185185185185 | 0.581365353931921 | 0.576801177773427 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 36343537743.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 36343537743.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 36343537743.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 36343537743.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 36343537743.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 36343537743.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 36343537743.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 36343537743.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 36343537743.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:40:26.963433Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 36343537743.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:07:55.847311Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |