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_alerts425,429 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 | price |
|---|
| 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 |
|---|
| c1bc5c9c-e57d-4ccb-889d-6e85e7da0b36 | 2026-09-21 12:51 | 2026-09-21 12:51 | 2026-09-21 12:51 | LEN | LEN270115P00080000 | put | 80.0000 | 2027-01-15 | 7.6000 | 7.5000 | 7.9000 | 77.0000 | 17480.00 | 16720.00 | 760.00 | 23 | 11 | 34 | 1309 | 0.025974025974026 | 0.400860980118116 | 0.399489049543474 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 16436308714.00 | 2026-12-15 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 26527fb3-d92a-4b3e-a4e3-b6f84a6eb616 | 2026-09-21 13:47 | 2026-09-21 13:47 | 2026-09-21 13:47 | LEN | LEN261120P00070000 | put | 70.0000 | 2026-11-20 | 1.7000 | 1.6000 | 1.7000 | 77.8200 | 13940.00 | 13940.00 | 0.00 | 82 | 6 | 465 | 1391 | 0.334291876347951 | 0.398171128726687 | 0.398171128726687 | false | false | false | true | false | |||||||||||||||
| 07e5c12f-66e0-4b2a-905c-c66436e420e8 | 2026-09-21 14:49 | 2026-09-21 14:48 | 2026-09-21 14:48 | LEN | LEN261009C00077000 | call | 77.0000 | 2026-10-09 | 3.0000 | 2.9000 | 3.0000 | 77.0000 | 22500.00 | 22500.00 | 0.00 | 75 | 17 | 88 | 25 | 3.52 | 0.358458719359182 | 0.358458719359182 | false | false | false | true | false | |||||||||||||||
| 1e56d35a-b229-46ba-94b2-8d1065f158f3 | 2026-09-22 09:35 | 2026-09-22 09:35 | 2026-09-22 09:35 | LEN | LEN261016C00080000 | call | 80.0000 | 2026-10-16 | 3.2500 | 3.2000 | 3.8000 | 80.9900 | 32500.00 | 0.00 | 32500.00 | 100 | 2 | 214 | 844 | 0.253554502369668 | 0.323319428998104 | 0.323319428998104 | false | true | false | true | false | |||||||||||||||
| b65fc9a8-6f91-4331-a089-b22948da34e1 | 2026-09-22 10:03 | 2026-09-22 10:03 | 2026-09-22 10:03 | LEN | LEN260925P00082000 | put | 82.0000 | 2026-09-25 | 1.2000 | 1.2000 | 1.4000 | 82.4400 | 11520.00 | 0.00 | 11520.00 | 96 | 8 | 103 | 3101 | 0.0332150919058368 | 0.478022426936624 | 0.478022426936624 | false | false | false | true | false | |||||||||||||||
| 9216b270-73c7-41e2-aec4-3f3176b972ff | 2026-09-22 10:03 | 2026-09-22 10:03 | 2026-09-22 10:03 | LEN | LEN260925P00082000 | put | 82.0000 | 2026-09-25 | 1.2500 | 1.2500 | 1.3500 | 82.3800 | 12000.00 | 0.00 | 12000.00 | 96 | 8 | 199 | 3101 | 0.0641728474685585 | 0.485962014881319 | 0.485962014881319 | true | false | false | true | false | |||||||||||||||
| 0e68d1f1-dab8-4837-b743-56a28bc0ddaa | 2026-09-22 10:31 | 2026-09-22 10:31 | 2026-09-22 10:31 | LEN | LEN270115C00100000 | call | 100.0000 | 2027-01-15 | 2.0500 | 2.0000 | 2.2000 | 82.2500 | 77490.00 | 77285.00 | 205.00 | 378 | 23 | 394 | 1122 | 0.351158645276292 | 0.37684802219427 | 0.37684802219427 | false | false | false | true | false | |||||||||||||||
| 1f1eb65c-748f-47a1-beee-82da7ddf89bc | 2026-09-22 13:28 | 2026-09-22 13:28 | 2026-09-22 13:28 | LEN | LEN261218C00095000 | call | 95.0000 | 2026-12-18 | 2.3500 | 2.2000 | 2.5000 | 82.6000 | 83190.00 | 82955.00 | 235.00 | 354 | 34 | 518 | 184 | 2.81521739130435 | 0.381532789534439 | 0.381532789534439 | false | false | false | true | false | |||||||||||||||
| bc1dc666-d9fb-4e57-9344-605ddf8babd4 | 2026-09-23 10:32 | 2026-09-23 10:32 | 2026-09-23 10:32 | LEN | LEN270115C00090000 | call | 90.0000 | 2027-01-15 | 4.5000 | 4.3000 | 4.7000 | 82.4600 | 11700.00 | 9900.00 | 1800.00 | 26 | 8 | 30 | 335 | 0.0895522388059701 | 0.379889070016938 | 0.379889070016938 | false | false | false | true | false | |||||||||||||||
| f7a3fec7-e1e5-4aee-a0e6-e604e58c973b | 2026-09-23 12:18 | 2026-09-23 12:18 | 2026-09-23 12:18 | LEN | LEN280121P00075000 | put | 75.0000 | 2028-01-21 | 10.3000 | 9.9000 | 10.3000 | 82.1600 | 10300.00 | 10300.00 | 0.00 | 10 | 7 | 14 | 119 | 0.117647058823529 | 0.446147989103684 | 0.446147989103684 | false | false | false | true | false | |||||||||||||||
| 78aa4156-2ebd-4220-9d67-7f029d3ab673 | 2026-09-23 12:28 | 2026-09-23 12:28 | 2026-09-23 12:28 | LEN | LEN261009P00083000 | put | 83.0000 | 2026-10-09 | 3.1000 | 2.9500 | 3.2000 | 82.1600 | 20770.00 | 2480.00 | 18290.00 | 67 | 6 | 88 | 26 | 3.38461538461538 | 0.397428560300411 | 0.397428560300411 | false | false | false | true | false | |||||||||||||||
| e1c6b206-a870-4cef-8f16-e95a8976f6f3 | 2026-09-23 12:39 | 2026-09-23 12:39 | 2026-09-23 12:39 | LEN | LEN270115C00100000 | call | 100.0000 | 2027-01-15 | 2.1000 | 1.8000 | 2.2000 | 82.0000 | 12180.00 | 9450.00 | 2730.00 | 58 | 18 | 59 | 1521 | 0.0387902695595003 | 0.382249276651787 | 0.382249276651787 | false | false | false | true | false | |||||||||||||||
| 43993bbe-56db-4c1c-8462-8caa86a606e0 | 2026-09-24 11:49 | 2026-09-24 11:49 | 2026-09-24 11:49 | LEN | LEN261023P00078000 | put | 78.0000 | 2026-10-23 | 2.3000 | 2.3000 | 2.3500 | 80.2100 | 34105.00 | 3055.00 | 31050.00 | 148 | 6 | 148 | 67 | 2.2089552238806 | 0.38751346667009 | 0.38751346667009 | false | false | false | true | false | |||||||||||||||
| a069a63f-ebec-4bf0-a275-a6a11d2ff110 | 2026-09-24 15:12 | 2026-09-24 15:12 | 2026-09-24 15:12 | LEN | LEN260925P00082000 | put | 82.0000 | 2026-09-25 | 1.3900 | 1.1500 | 1.4500 | 81.0600 | 13928.00 | 13928.00 | 0.00 | 100 | 9 | 745 | 3029 | 0.24595576097722 | 0.502288462843194 | 0.502288462843194 | false | false | false | true | false | |||||||||||||||
| 74eae788-039f-4d6f-874c-335aca7949b1 | 2026-09-24 15:48 | 2026-09-24 15:48 | 2026-09-24 15:48 | LEN | LEN261120C00090000 | call | 90.0000 | 2026-11-20 | 1.9000 | 1.7500 | 1.9000 | 81.3600 | 42939.00 | 42939.00 | 0.00 | 226 | 35 | 234 | 530 | 0.441509433962264 | 0.36573563783566 | 0.36573563783566 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 16436308714.00 |
| 2026-12-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:50:05.863152Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 16436308714.00 |
| 2026-12-15 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:50:33.734980Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17484628609.00 |
| 2026-12-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:36:05.660724Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17484628609.00 |
| 2026-12-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:04:08.107942Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17484628609.00 |
| 2026-12-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:04:08.107942Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17484628609.00 |
| 2026-12-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:31:31.654153Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17484628609.00 |
| 2026-12-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:30:55.056187Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17160449365.00 |
| 2026-12-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:33:43.718875Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17160449365.00 |
| 2026-12-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:19:07.705108Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17160449365.00 |
| 2026-12-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:31:43.812748Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17160449365.00 |
| 2026-12-15 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:43:49.845741Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17160449365.00 |
| 2026-12-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:50:02.461499Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17160449365.00 |
| 2026-12-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:15:33.602136Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17160449365.00 |
| 2026-12-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:50:03.728318Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |