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 |
|---|
| bf63dd12-04ed-4dc2-b165-15f8cc38d0a3 | 2026-08-17 12:06 | 2026-08-17 12:06 | 2026-08-17 12:06 | LCID | LCID280121P00003000 | put | 3.0000 | 2028-01-21 | 1.1700 | 1.1700 | 1.3300 | 6.2000 | 80964.00 | 0.00 | 80964.00 | 692 | 12 | 725 | 6325 | 0.114624505928854 | 1.35639327949198 | 1.35639327949198 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1639331932.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1b86781d-cd3e-4990-91ed-9aba2a5929e0 | 2026-08-24 13:49 | 2026-08-24 13:48 | 2026-08-24 13:48 | LCID | LCID280121P00003000 | put | 3.0000 | 2028-01-21 | 1.2600 | 1.0800 | 1.2600 | 5.1850 | 12600.00 | 12600.00 | 0.00 | 100 | 7 | 103 | 6835 | 0.0150694952450622 | 1.3504163321862 | 1.3504163321862 | false | false | false | true | ||||||||||||||||
| 587a3c4d-414d-42b1-8d84-9368f35a3fa0 | 2026-09-04 10:44 | 2026-09-04 10:44 | 2026-09-04 10:44 | LCID | LCID280121P00003000 | put | 3.0000 | 2028-01-21 | 1.2100 | 1.2100 | 1.2500 | 4.4950 | 148830.00 | 0.00 | 148830.00 | 1230 | 46 | 1259 | 8620 | 0.146055684454756 | 1.24892420805831 | 1.24892420805831 | true | false | false | true | ||||||||||||||||
| b29caadc-f2f1-4af7-b5ab-ffb3a2dc8e77 | 2026-09-15 12:16 | 2026-09-15 12:16 | 2026-09-15 12:16 | LCID | LCID280121P00003000 | put | 3.0000 | 2028-01-21 | 1.3300 | 1.2700 | 1.3800 | 4.0450 | 168644.00 | 12369.00 | 141379.00 | 1268 | 17 | 2404 | 9622 | 0.249844107254209 | 1.28685065255223 | 1.28685065255223 | true | false | false | |||||||||||||||||
| f7547f04-a496-4832-946c-b1302cefa2b8 | 2026-09-15 14:00 | 2026-09-15 14:00 | 2026-09-15 14:00 | LCID | LCID280121P00003000 | put | 3.0000 | 2028-01-21 | 1.3000 | 1.2500 | 1.3400 | 4.0850 | 30030.00 | 8190.00 | 21840.00 | 231 | 5 | 3629 | 9622 | 0.377156516316774 | 1.26674747836753 | 1.26674747836753 | true | false | false | true | ||||||||||||||||
| 91f15009-7f38-44e1-8d7d-561774a0772a | 2026-09-15 14:00 | 2026-09-15 14:00 | 2026-09-15 14:00 | LCID | LCID280121P00003000 | put | 3.0000 | 2028-01-21 | 1.3000 | 1.3000 | 1.3400 | 4.0800 | 28470.00 | 0.00 | 28470.00 | 219 | 5 | 3848 | 9622 | 0.399916857202245 | 1.26604854630086 | 1.26604854630086 | true | false | false | true | ||||||||||||||||
| d975a8ec-6947-4aa8-8114-c2c2dc368ef9 | 2026-09-15 15:51 | 2026-09-15 15:51 | 2026-09-15 15:51 | LCID | LCID280121P00003000 | put | 3.0000 | 2028-01-21 | 1.3200 | 1.2600 | 1.3500 | 4.0000 | 15840.00 | 3828.00 | 12012.00 | 120 | 6 | 3970 | 9622 | 0.412596133859904 | 1.28300260815098 | 1.28300260815098 | false | false | false | true | ||||||||||||||||
| 84104142-ac11-446c-8b98-88c9cb65b622 | 2026-09-15 15:51 | 2026-09-15 15:51 | 2026-09-15 15:51 | LCID | LCID280121P00003000 | put | 3.0000 | 2028-01-21 | 1.3200 | 1.2600 | 1.3500 | 4.0000 | 21780.00 | 4488.00 | 17292.00 | 165 | 5 | 4135 | 9622 | 0.429744335896903 | 1.28300260815098 | 1.28300260815098 | false | false | false | true | ||||||||||||||||
| 123b3b51-267f-497f-baa0-309a54aa1874 | 2026-09-16 11:28 | 2026-09-16 11:28 | 2026-09-16 11:28 | LCID | LCID280121P00003000 | put | 3.0000 | 2028-01-21 | 1.3200 | 1.3200 | 1.3500 | 4.0550 | 37752.00 | 0.00 | 37752.00 | 286 | 5 | 608 | 14282 | 0.0425710684778042 | 1.30550413769139 | 1.30550413769139 | true | false | false | true | ||||||||||||||||
| ac6b6833-69c9-4a72-8a95-fc3ee1987f28 | 2026-09-16 11:28 | 2026-09-16 11:28 | 2026-09-16 11:28 | LCID | LCID280121P00003000 | put | 3.0000 | 2028-01-21 | 1.3200 | 1.3200 | 1.3400 | 4.0550 | 35376.00 | 0.00 | 35376.00 | 268 | 9 | 876 | 14282 | 0.06133594734631 | 1.30550413769139 | 1.30550413769139 | true | false | false | true | ||||||||||||||||
| dc4fe86e-bc54-459f-a3f0-e080b3b85004 | 2026-09-16 12:20 | 2026-09-16 12:20 | 2026-09-16 12:20 | LCID | LCID280121P00003000 | put | 3.0000 | 2028-01-21 | 1.3400 | 1.3400 | 1.3500 | 4.0750 | 13266.00 | 0.00 | 13266.00 | 99 | 18 | 6717 | 14282 | 0.47031228119311 | 1.32585841286009 | 1.32585841286009 | false | false | false | true | ||||||||||||||||
| 7619aa48-8179-4888-99ad-f9911ef723c3 | 2026-09-16 12:20 | 2026-09-16 12:20 | 2026-09-16 12:20 | LCID | LCID280121P00003000 | put | 3.0000 | 2028-01-21 | 1.3400 | 1.3200 | 1.3500 | 4.0750 | 15678.00 | 13936.00 | 1742.00 | 117 | 8 | 6618 | 14282 | 0.46338047892452 | 1.32585841286009 | 1.32585841286009 | true | false | false | true | ||||||||||||||||
| 821d5d48-4783-43a3-9c86-6ffe1b0b33c2 | 2026-09-25 13:49 | 2026-09-25 13:49 | 2026-09-25 13:49 | LCID | LCID280121P00003000 | put | 3.0000 | 2028-01-21 | 1.3900 | 1.3300 | 1.4400 | 4.0750 | 14595.00 | 11954.00 | 973.00 | 105 | 14 | 2159 | 21239 | 0.101652620179858 | 1.38579132744912 | 1.38579132744912 | true | false | false | true | ||||||||||||||||
| 22026da3-fbf4-424b-b5f5-f681d8dd1525 | 2026-09-25 14:06 | 2026-09-25 14:06 | 2026-09-25 14:06 | LCID | LCID280121P00003000 | put | 3.0000 | 2028-01-21 | 1.4300 | 1.3000 | 1.4300 | 4.0000 | 134134.00 | 134134.00 | 0.00 | 938 | 62 | 3353 | 21239 | 0.157869956212628 | 1.42105983158708 | 1.42035981325144 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1639331932.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1639331932.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1639331932.00 |
| 2026-11-04 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1639331932.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1639331932.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1639331932.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1639331932.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1592043511.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1592043511.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1592043511.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1592043511.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1603865616.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:50:01.932714Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1603865616.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:10:19.042064Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |