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_alerts658,639 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 |
|---|
| 752e2dd4-0099-4aaa-a607-1b2b53b11a42 | 2026-10-01 15:58 | 2026-10-01 15:58 | 2026-10-01 15:58 | NKE | NKE261120C00045000 | call | 45.0000 | 2026-11-20 | 0.3300 | 0.3200 | 0.3600 | 35.1250 | 10461.00 | 0.00 | 7029.00 | 317 | 19 | 867 | 7435 | 0.116610625420309 | 0.501039099104993 | 0.501039099104993 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 42254199928.00 | 2026-10-01 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-01T19:58:45.768472Z"} | 2026-10-01 | 2026-10-01 21:15 | 2026-10-01 21:15 |
| 2b841503-5bd6-49b1-a0f7-0acbc26f0441 | 2026-09-21 15:38 | 2026-09-21 15:37 | 2026-09-21 15:37 | NKE | NKE261120C00045000 | call | 45.0000 | 2026-11-20 | 0.4800 | 0.4800 | 0.5000 | 36.2550 | 12000.00 | 0.00 | 12000.00 | 250 | 21 | 1628 | 7285 | 0.22347288949897 | 0.45671533186308 | 0.45671533186308 | true | false | false | true | ||||||||||||||||
| a0ff4b8d-77e1-4959-afab-96892fdac490 | 2026-09-08 12:16 | 2026-09-08 12:16 | 2026-09-08 12:16 | NKE | NKE261120C00045000 | call | 45.0000 | 2026-11-20 | 0.9700 | 0.9700 | 0.9800 | 38.1400 | 16005.00 | 0.00 | 16005.00 | 165 | 7 | 420 | 5141 | 0.0816961680606886 | 0.439636812529023 | 0.439636812529023 | true | false | false | true | ||||||||||||||||
| eb0c0bc2-0c8a-444c-b8ba-e948243897c2 | 2026-08-25 15:57 | 2026-08-25 15:57 | 2026-08-25 15:57 | NKE | NKE261120C00045000 | call | 45.0000 | 2026-11-20 | 1.3300 | 1.3300 | 1.3600 | 39.4350 | 13300.00 | 0.00 | 13300.00 | 100 | 11 | 308 | 4283 | 0.0719122110670091 | 0.402340342044601 | 0.402340342044601 | false | false | false | true | ||||||||||||||||
| 863be218-4ad5-4445-94c1-530b45af3634 | 2026-08-21 14:31 | 2026-08-21 14:30 | 2026-08-21 14:30 | NKE | NKE261120C00045000 | call | 45.0000 | 2026-11-20 | 1.7700 | 1.7400 | 1.7700 | 40.7079 | 13275.00 | 531.00 | 0.00 | 75 | 17 | 447 | 4140 | 0.107971014492754 | 0.39557946172985 | 0.39557946172985 | false | false | false | true | ||||||||||||||||
| 6e789d16-c33f-43c4-b8e0-55486abbbc2c | 2026-08-21 12:43 | 2026-08-21 12:43 | 2026-08-21 12:43 | NKE | NKE261120C00045000 | call | 45.0000 | 2026-11-20 | 1.8100 | 1.8000 | 1.8500 | 40.7350 | 13575.00 | 6154.00 | 3077.00 | 75 | 16 | 266 | 4140 | 0.0642512077294686 | 0.399546696406222 | 0.399546696406222 | false | false | false | true | ||||||||||||||||
| e999b541-2b8c-475d-b87e-357166a9fda5 | 2026-08-21 10:49 | 2026-08-21 10:49 | 2026-08-21 10:49 | NKE | NKE261120C00045000 | call | 45.0000 | 2026-11-20 | 1.8800 | 1.8700 | 1.9000 | 40.8550 | 13348.00 | 11656.00 | 1692.00 | 71 | 17 | 169 | 4140 | 0.0408212560386473 | 0.402941112755212 | 0.402941112755212 | false | false | false | true | ||||||||||||||||
| d51c0c2c-aec8-4616-82fa-a9a134c05dac | 2026-08-20 15:32 | 2026-08-20 15:32 | 2026-08-20 15:32 | NKE | NKE261120C00045000 | call | 45.0000 | 2026-11-20 | 1.7700 | 1.7300 | 1.7700 | 40.4550 | 14868.00 | 14868.00 | 0.00 | 84 | 20 | 235 | 3969 | 0.0592088687326783 | 0.405122942430733 | 0.405122942430733 | false | false | false | true | ||||||||||||||||
| caa03dcb-2b3a-47a0-89a8-d349536cd22d | 2026-08-19 15:35 | 2026-08-19 15:35 | 2026-08-19 15:35 | NKE | NKE261120C00045000 | call | 45.0000 | 2026-11-20 | 1.9900 | 1.9500 | 2.0000 | 41.0650 | 23661.00 | 23661.00 | 0.00 | 119 | 8 | 539 | 3889 | 0.13859604011314 | 0.402176153018995 | 0.402176153018995 | false | false | false | true | ||||||||||||||||
| 6887d8d4-398e-4345-b00f-dcd149db6afe | 2026-08-19 11:12 | 2026-08-19 11:12 | 2026-08-19 11:12 | NKE | NKE261120C00045000 | call | 45.0000 | 2026-11-20 | 1.9500 | 1.9500 | 2.0000 | 40.9750 | 16575.00 | 0.00 | 16575.00 | 85 | 7 | 254 | 3889 | 0.065312419645153 | 0.401436157000712 | 0.401436157000712 | false | false | false | true | ||||||||||||||||
| 879d591e-b581-4fef-8653-032967dd34c9 | 2026-08-17 10:42 | 2026-08-17 10:42 | 2026-08-17 10:42 | NKE | NKE261120C00045000 | call | 45.0000 | 2026-11-20 | 1.4800 | 1.4500 | 1.4800 | 39.4600 | 59200.00 | 59200.00 | 0.00 | 400 | 9 | 507 | 4222 | 0.120085267645666 | 0.403855303768352 | 0.403855303768352 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 43396205331.00 |
| 2026-10-01 |
| postmarket |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 44538210735.00 |
| 2026-10-01 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 44538210735.00 |
| 2026-10-01 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 44538210735.00 |
| 2026-10-01 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 44538210735.00 |
| 2026-10-01 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:43:46.028086Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 44538210735.00 |
| 2026-10-01 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:50:41.871179Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 44538210735.00 |
| 2026-10-01 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 44538210735.00 |
| 2026-10-01 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 44538210735.00 |
| 2026-10-01 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 44538210735.00 |
| 2026-10-01 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |