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 |
|---|
| 0fdb04ae-e2c3-4e5f-826f-3e42e0cca1f9 | 2026-08-20 10:47 | 2026-08-20 10:46 | 2026-08-20 10:46 | CDE | CDE270115C00040000 | call | 40.0000 | 2027-01-15 | 0.4500 | 0.4500 | 0.5500 | 21.0950 | 16875.00 | 0.00 | 16875.00 | 375 | 9 | 550 | 10652 | 0.0516334960570785 | 0.695048108850247 | 0.695048108850247 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 20435347760.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ccb3beea-cad9-4a0c-bcfc-38c061f1a438 | 2026-08-20 09:56 | 2026-08-20 09:56 | 2026-08-20 09:56 | CDE | CDE261120P00020000 | put | 20.0000 | 2026-11-20 | 2.2000 | 2.2000 | 2.2500 | 20.9200 | 10780.00 | 0.00 | 10780.00 | 49 | 11 | 54 | 2643 | 0.0204313280363224 | 0.670504678775097 | 0.670504678775097 | false | false | false | true | ||||||||||||||||
| b32f3392-1cd0-4c34-bbee-4d6b9a20ba32 | 2026-08-19 14:03 | 2026-08-19 14:03 | 2026-08-19 14:03 | CDE | CDE260828C00023000 | call | 23.0000 | 2026-08-28 | 0.2500 | 0.2000 | 0.2500 | 20.7750 | 11250.00 | 11250.00 | 0.00 | 450 | 9 | 625 | 461 | 1.35574837310195 | 0.718197512220397 | 0.718197512220397 | false | false | false | true | ||||||||||||||||
| cd739a71-742c-4a83-9803-d78e248e16fc | 2026-08-19 12:52 | 2026-08-19 12:52 | 2026-08-19 12:52 | CDE | CDE260918C00022500 | call | 22.5000 | 2026-09-18 | 0.9000 | 0.9000 | 0.9500 | 20.8650 | 19440.00 | 0.00 | 19440.00 | 216 | 8 | 2809 | 11123 | 0.252539782432797 | 0.630888186666715 | 0.630888186666715 | false | false | false | true | ||||||||||||||||
| dcf0296a-2f63-479b-990e-6fc2e1ae06d8 | 2026-08-19 12:37 | 2026-08-19 12:37 | 2026-08-19 12:37 | CDE | CDE270115C00020000 | call | 20.0000 | 2027-01-15 | 4.1000 | 4.0000 | 4.1000 | 20.9950 | 22960.00 | 22960.00 | 0.00 | 56 | 5 | 246 | 18663 | 0.0131811605851149 | 0.661494299605202 | 0.661494299605202 | false | false | false | true | ||||||||||||||||
| 20b00945-4f6d-473e-87be-dca79d80b9b0 | 2026-08-19 12:19 | 2026-08-19 12:19 | 2026-08-19 12:19 | CDE | CDE260918C00022500 | call | 22.5000 | 2026-09-18 | 1.0500 | 1.0000 | 1.0500 | 21.1750 | 12180.00 | 12180.00 | 0.00 | 116 | 9 | 2300 | 11123 | 0.206778746740987 | 0.642666427171032 | 0.642666427171032 | false | false | false | true | ||||||||||||||||
| 051600b3-657a-4ae6-be97-d36af9fe1c3b | 2026-08-19 12:06 | 2026-08-19 12:06 | 2026-08-19 12:06 | CDE | CDE261120C00030000 | call | 30.0000 | 2026-11-20 | 0.8000 | 0.8000 | 0.8500 | 21.1650 | 10400.00 | 0.00 | 10400.00 | 130 | 9 | 351 | 4394 | 0.0798816568047337 | 0.70337297548155 | 0.70337297548155 | false | false | false | true | ||||||||||||||||
| 8eca17b3-6a6b-4e7f-b2a7-90e903442826 | 2026-08-19 11:53 | 2026-08-19 11:53 | 2026-08-19 11:53 | CDE | CDE261120C00020000 | call | 20.0000 | 2026-11-20 | 3.5000 | 3.5000 | 3.6000 | 21.1600 | 222600.00 | 0.00 | 222600.00 | 636 | 5 | 1002 | 9663 | 0.10369450481217 | 0.674824379609883 | 0.674824379609883 | true | false | false | true | ||||||||||||||||
| 70121f97-d3c5-4822-aead-0f40ab70d6ed | 2026-08-19 11:53 | 2026-08-19 11:53 | 2026-08-19 11:53 | CDE | CDE261120C00020000 | call | 20.0000 | 2026-11-20 | 3.5000 | 3.5000 | 3.7000 | 21.1750 | 92400.00 | 0.00 | 92400.00 | 264 | 8 | 366 | 9663 | 0.0378764358894753 | 0.672405752864407 | 0.672405752864407 | false | false | false | true | ||||||||||||||||
| bbbf0faf-c310-4ad4-bf91-33e2491d2a48 | 2026-08-19 10:52 | 2026-08-19 10:52 | 2026-08-19 10:52 | CDE | CDE280121P00017500 | put | 17.5000 | 2028-01-21 | 3.7000 | 3.7000 | 4.3000 | 20.8750 | 12950.00 | 0.00 | 12950.00 | 35 | 5 | 45 | 526 | 0.0855513307984791 | 0.651226154145669 | 0.651226154145669 | false | false | false | true | ||||||||||||||||
| bc5b2623-7b6c-468b-af0f-758c11644708 | 2026-08-18 12:53 | 2026-08-18 12:53 | 2026-08-18 12:53 | CDE | CDE261120C00020000 | call | 20.0000 | 2026-11-20 | 2.1500 | 2.1000 | 2.2000 | 18.8300 | 16125.00 | 0.00 | 11180.00 | 75 | 8 | 204 | 9570 | 0.0213166144200627 | 0.669923729414264 | 0.669923729414264 | false | false | false | true | ||||||||||||||||
| ce3af83c-fb69-4cf0-b2bf-3defa246286d | 2026-08-18 11:00 | 2026-08-18 10:59 | 2026-08-18 10:59 | CDE | CDE270115P00020000 | put | 20.0000 | 2027-01-15 | 3.8000 | 3.7000 | 3.9000 | 18.6200 | 14820.00 | 0.00 | 7600.00 | 39 | 5 | 49 | 4781 | 0.0102489019033675 | 0.667553643522271 | 0.667553643522271 | false | false | false | true | ||||||||||||||||
| 323f0697-ce26-481a-bbbc-3fb023f26f3c | 2026-08-18 09:32 | 2026-08-18 09:32 | 2026-08-18 09:32 | CDE | CDE270617C00020000 | call | 20.0000 | 2027-06-17 | 4.4000 | 4.1000 | 4.6000 | 18.9410 | 10560.00 | 440.00 | 440.00 | 24 | 24 | 24 | 112 | 0.214285714285714 | 0.671418311525516 | 0.671418311525516 | true | false | false | true | ||||||||||||||||
| b82285c8-f263-47ac-8287-df2d15bd0040 | 2026-08-17 14:30 | 2026-08-17 14:30 | 2026-08-17 14:30 | CDE | CDE260821C00019000 | call | 19.0000 | 2026-08-21 | 0.7500 | 0.7000 | 0.7500 | 19.4409 | 37500.00 | 4575.00 | 0.00 | 500 | 20 | 2089 | 5013 | 0.41671653700379 | 0.615026509187055 | 0.615026509187055 | false | false | false | true | ||||||||||||||||
| 44d46902-2522-4666-a7f1-f7986543167e | 2026-08-17 13:45 | 2026-08-17 13:44 | 2026-08-17 13:44 | CDE | CDE261120C00020000 | call | 20.0000 | 2026-11-20 | 2.5000 | 2.4500 | 2.5500 | 19.0000 | 21250.00 | 0.00 | 20750.00 | 85 | 7 | 922 | 9388 | 0.0982104814657009 | 0.662230255267464 | 0.662230255267464 | false | false | false | true | ||||||||||||||||
| d8b34ed8-33cf-4d6f-b6f0-b934d80da7c5 | 2026-08-17 13:22 | 2026-08-17 13:22 | 2026-08-17 13:22 | CDE | CDE260911C00019000 | call | 19.0000 | 2026-09-11 | 1.5000 | 1.4500 | 1.5000 | 19.5100 | 10500.00 | 10500.00 | 0.00 | 70 | 20 | 81 | 2634 | 0.030751708428246 | 0.598162869006252 | 0.598162869006252 | false | false | false | true | ||||||||||||||||
| da5cef3b-a11c-4f1a-ac6d-4f8c0c9fff1b | 2026-08-17 11:43 | 2026-08-17 11:43 | 2026-08-17 11:43 | CDE | CDE261120C00020000 | call | 20.0000 | 2026-11-20 | 2.5000 | 2.4500 | 2.5000 | 19.4703 | 26000.00 | 26000.00 | 0.00 | 104 | 5 | 768 | 9388 | 0.0818065615679591 | 0.669165885877809 | 0.669165885877809 | false | false | false | true | ||||||||||||||||
| 76a24375-d1ec-4e59-9d95-403f3582add8 | 2026-08-17 10:46 | 2026-08-17 10:46 | 2026-08-17 10:46 | CDE | CDE270917C00025000 | call | 25.0000 | 2027-09-17 | 3.8000 | 3.5000 | 4.0000 | 19.3750 | 14820.00 | 3800.00 | 11020.00 | 39 | 6 | 249 | 880 | 0.282954545454545 | 0.658018882981046 | 0.658018882981046 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| 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 |