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 | 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 |
|---|
| c3c2cb03-6013-4761-b6b8-fb7850d6d728 | 2026-09-15 12:10 | 2026-09-15 12:10 | 2026-09-15 12:10 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.7700 | 1.7300 | 1.7700 | 22.0310 | 73101.00 | 73101.00 | 0.00 | 413 | 44 | 3368 | 1400 | 2.40571428571429 | 0.483126457892558 | 0.483126457892558 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 31fafe7a-bcbb-4fec-b615-f13fd87db487 | 2026-09-15 12:00 | 2026-09-15 12:00 | 2026-09-15 12:00 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.7600 | 1.7300 | 1.7700 | 22.0250 | 21120.00 | 21120.00 | 0.00 | 120 | 10 | 2924 | 1400 | 2.08857142857143 | 0.480573109611527 | 0.480573109611527 | true | false | false | true | ||||||||||||||||
| c98540bd-fd8e-491f-84f8-ac1514dc901c | 2026-09-15 12:00 | 2026-09-15 12:00 | 2026-09-15 12:00 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.7600 | 1.7100 | 1.7700 | 22.0250 | 23056.00 | 23056.00 | 0.00 | 131 | 12 | 2804 | 1400 | 2.00285714285714 | 0.480573109611527 | 0.480573109611527 | true | false | false | true | ||||||||||||||||
| c5e0057a-d627-4561-b659-93be7dc5c88a | 2026-09-15 12:00 | 2026-09-15 12:00 | 2026-09-15 12:00 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.7600 | 1.7100 | 1.7700 | 22.0250 | 18832.00 | 15840.00 | 2992.00 | 107 | 11 | 2673 | 1400 | 1.90928571428571 | 0.480573109611527 | 0.480573109611527 | true | false | false | true | ||||||||||||||||
| c58f9a55-053e-42dc-9273-0e198ae453c5 | 2026-09-15 12:00 | 2026-09-15 12:00 | 2026-09-15 12:00 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.7600 | 1.7000 | 1.7600 | 22.0250 | 28160.00 | 28160.00 | 0.00 | 160 | 21 | 2545 | 1400 | 1.81785714285714 | 0.480573109611527 | 0.480573109611527 | true | false | false | true | ||||||||||||||||
| 9f1f1525-1b50-4ed2-a2de-92ed915d2bf4 | 2026-09-15 12:00 | 2026-09-15 12:00 | 2026-09-15 12:00 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.7600 | 1.6900 | 1.7700 | 22.0250 | 89211.00 | 87285.00 | 1750.00 | 507 | 41 | 2270 | 1400 | 1.62142857142857 | 0.480950233313789 | 0.480573109611527 | true | false | false | true | ||||||||||||||||
| f149a2e5-409f-4a4e-8da3-437212134564 | 2026-09-15 11:44 | 2026-09-15 11:44 | 2026-09-15 11:44 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.7300 | 1.7200 | 1.7700 | 22.0500 | 21625.00 | 1211.00 | 20414.00 | 125 | 12 | 1763 | 1400 | 1.25928571428571 | 0.476150651191732 | 0.476150651191732 | true | false | false | true | ||||||||||||||||
| a0bd5c84-5cf9-48f2-b530-d63017abab3e | 2026-09-15 10:08 | 2026-09-15 10:07 | 2026-09-15 10:07 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.6400 | 1.5800 | 1.6700 | 22.2750 | 41000.00 | 4920.00 | 36080.00 | 250 | 15 | 1143 | 1400 | 0.816428571428571 | 0.473797660382711 | 0.473797660382711 | false | false | false | true | ||||||||||||||||
| dedce01f-80cd-4008-9724-4ac5cce88583 | 2026-09-15 10:07 | 2026-09-15 10:07 | 2026-09-15 10:07 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.6400 | 1.5800 | 1.6500 | 22.2800 | 42311.00 | 37720.00 | 163.00 | 258 | 9 | 893 | 1400 | 0.637857142857143 | 0.474522180933612 | 0.474160048321016 | true | false | false | true | ||||||||||||||||
| f87eca5f-703a-489d-9eb5-dbf399fce67a | 2026-09-15 10:07 | 2026-09-15 10:07 | 2026-09-15 10:07 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.6200 | 1.5700 | 1.6500 | 22.2786 | 16849.00 | 13122.00 | 3727.00 | 104 | 6 | 368 | 1400 | 0.262857142857143 | 0.46983499098433 | 0.471947049193547 | true | false | false | true | ||||||||||||||||
| 16f9f37f-b88e-42e0-9826-dd4af34167c5 | 2026-09-15 10:07 | 2026-09-15 10:07 | 2026-09-15 10:07 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.6300 | 1.5400 | 1.6600 | 22.2786 | 26184.00 | 21150.00 | 3088.00 | 161 | 26 | 262 | 1400 | 0.187142857142857 | 0.471947049193547 | 0.471947049193547 | true | false | false | true | ||||||||||||||||
| 0a48eb12-ee5a-419a-83a9-494d5305765b | 2026-09-15 10:07 | 2026-09-15 10:07 | 2026-09-15 10:07 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.6300 | 1.5700 | 1.6300 | 22.2786 | 16463.00 | 15485.00 | 0.00 | 101 | 6 | 101 | 1400 | 0.0721428571428571 | 0.471947049193547 | 0.471947049193547 | true | false | false | true | ||||||||||||||||
| 7a0c9be7-915f-410d-9ed0-aae97f9f8053 | 2026-09-11 13:52 | 2026-09-11 13:51 | 2026-09-11 13:51 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.4600 | 1.4500 | 1.4900 | 22.8750 | 24382.00 | 0.00 | 24382.00 | 167 | 7 | 188 | 1244 | 0.15112540192926 | 0.466757901499099 | 0.466757901499099 | false | false | false | true | ||||||||||||||||
| 77e174b2-9ae4-4621-967a-003d9500edc3 | 2026-08-31 10:31 | 2026-08-31 10:31 | 2026-08-31 10:31 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.1300 | 1.1300 | 1.1900 | 24.1350 | 11752.00 | 0.00 | 11752.00 | 104 | 5 | 209 | 693 | 0.301587301587302 | 0.455665360854993 | 0.455665360854993 | false | false | false | true | ||||||||||||||||
| 687e9bdd-409f-4f64-b47c-7f6e76ea17fe | 2026-08-31 10:31 | 2026-08-31 10:31 | 2026-08-31 10:31 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.1300 | 1.1300 | 1.1900 | 24.1400 | 23504.00 | 0.00 | 23504.00 | 208 | 19 | 417 | 693 | 0.601731601731602 | 0.456454557633398 | 0.455928559286223 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:54:17.138635Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:41:39.850499Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 30899284125.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:41:39.850499Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |