Options flow alerts (market-wide)

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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = unknown×sector = Consumer Cyclical×ticker = SHAK×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

4efafcf1-3187-43f7-b057-1737c7c49bf6	2026-09-25 13:48	2026-09-25 13:48	2026-09-25 13:48	SHAK	SHAK261218C00065000	call	65.0000	2026-12-18	3.5000	3.4000	3.5000	57.5150	19600.00	19600.00	0.00	56	20	56	283	0.197879858657244	0.546312140764863	0.546312140764863	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	2244672677.00	2026-10-29	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
2ed7041e-4b44-4b06-b4e9-26398735d83a	2026-09-24 11:52	2026-09-24 11:52	2026-09-24 11:52	SHAK	SHAK270319P00055000	put	55.0000	2027-03-19	6.2000	6.2000	6.6000	58.5950	31000.00	0.00	31000.00	50	27	50	105	0.476190476190476	0.540009773593509	0.539553671136993	false	false	false	true
57f06305-0cfc-4447-b62e-417a86eb2727	2026-09-23 13:32	2026-09-23 13:32	2026-09-23 13:32	SHAK	SHAK280121C00075000	call	75.0000	2028-01-21	10.0000	9.8000	10.0000	57.6700	22000.00	22000.00	0.00	22	5	304	192	1.58333333333333	0.53854662844395	0.53854662844395	false	false	false	true
51ccd5bb-4316-40e4-be5d-023596ec6657	2026-09-23 13:08	2026-09-23 13:08	2026-09-23 13:08	SHAK	SHAK261120C00070000	call	70.0000	2026-11-20	1.6500	1.5500	1.7500	57.4200	85805.00	165.00	85640.00	520	41	527	409	1.28850855745721	0.579577095434733	0.578235479906538	false	false	false	true
8784e8f8-bda0-4335-9d1c-4246586c8940	2026-09-23 12:06	2026-09-23 12:06	2026-09-23 12:06	SHAK	SHAK261120P00055000	put	55.0000	2026-11-20	3.8000	3.8000	4.0000	57.5850	17480.00	0.00	17480.00	46	16	71	409	0.17359413202934	0.576015281728968	0.577075288468801	false	false	false	true
693f1606-1654-454f-9b47-848073c143c6	2026-09-23 12:06	2026-09-23 12:06	2026-09-23 12:06	SHAK	SHAK261120P00055000	put	55.0000	2026-11-20	3.8000	3.8000	4.0000	57.5900	10640.00	0.00	10640.00	28	8	99	409	0.242053789731051	0.577075288468801	0.577287088040519	false	false	false	true
b830b97e-d2a7-436f-9430-c64c90d31a0c	2026-09-22 12:04	2026-09-22 12:04	2026-09-22 12:04	SHAK	SHAK270115P00050000	put	50.0000	2027-01-15	2.9000	2.9000	3.0000	58.5913	17690.00	0.00	17690.00	61	15	61	335	0.182089552238806	0.541999958154985	0.541999958154985	false	false	false	true
1f82cfeb-161f-47e4-aa7b-9101cfa41c08	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SHAK	SHAK280121C00055000	call	55.0000	2028-01-21	17.5000	17.0000	17.8000	58.3900	99750.00	19250.00	7000.00	57	5	57	685	0.0832116788321168	0.557259158688537	0.557259158688537	false	false	false	true
e1aa61af-8f5c-4206-aaa6-3ee3334712bf	2026-09-21 12:49	2026-09-21 12:49	2026-09-21 12:49	SHAK	SHAK261120C00055000	call	55.0000	2026-11-20	6.5000	6.4000	6.6000	56.9250	52652.00	650.00	52002.00	81	34	99	12	8.25	0.585980787022554	0.585980787022554	false	false	false	true
07625670-4224-46b4-9d36-ad26114a2eca	2026-09-21 11:49	2026-09-21 11:49	2026-09-21 11:49	SHAK	SHAK261120C00065000	call	65.0000	2026-11-20	2.6000	2.6000	2.7000	56.7475	11180.00	0.00	11180.00	43	16	97	97	1	0.580249737118963	0.580249737118963	false	false	false	true
624f97a5-b715-4236-abc8-fcf4d6f37793	2026-09-18 13:49	2026-09-18 13:49	2026-09-18 13:49	SHAK	SHAK280121C00070000	call	70.0000	2028-01-21	10.0000	9.6000	10.1000	55.1700	35000.00	26000.00	7000.00	35	8	61	279	0.218637992831541	0.535325799927186	0.535325799927186	false	false	false	true
9860659b-0bcd-4c1c-b862-9f5c79a9c75c	2026-09-17 12:53	2026-09-17 12:52	2026-09-17 12:52	SHAK	SHAK280121P00040000	put	40.0000	2028-01-21	4.5000	4.5000	5.0000	56.7050	49500.00	0.00	49500.00	110	13	2221	198	11.2171717171717	0.547419564768312	0.547368629759852	false	false	false	true
711bd0e5-6118-4c83-8e41-e9a836df9e23	2026-09-17 12:53	2026-09-17 12:52	2026-09-17 12:52	SHAK	SHAK280121P00040000	put	40.0000	2028-01-21	4.5000	4.4000	5.0000	56.6600	130500.00	5400.00	125100.00	290	46	2511	198	12.6818181818182	0.547368629759852	0.546909879375963	true	false	false	true
672281c5-35c5-47c7-9a8d-b242ea4866e2	2026-09-17 12:52	2026-09-17 12:52	2026-09-17 12:52	SHAK	SHAK280121P00040000	put	40.0000	2028-01-21	4.5000	4.4000	5.0000	56.7100	27000.00	0.00	27000.00	60	16	2111	198	10.6616161616162	0.547419564768312	0.547419564768312	false	false	false	true
5a0090b4-047d-45e3-9100-b011654315c3	2026-09-17 12:52	2026-09-17 12:52	2026-09-17 12:52	SHAK	SHAK280121P00040000	put	40.0000	2028-01-21	4.5000	4.5000	5.0000	56.7100	20250.00	0.00	20250.00	45	10	2051	198	10.3585858585859	0.547419564768312	0.547419564768312	false	false	false	true
0933e116-0d93-4e7b-baca-a703a0dcf702	2026-09-17 12:27	2026-09-17 12:27	2026-09-17 12:27	SHAK	SHAK261218P00065000	put	65.0000	2026-12-18	11.1000	11.0000	11.1000	56.7950	44400.00	44400.00	0.00	40	13	48	255	0.188235294117647	0.553410052469494	0.553410052469494	false	false	false	true
234c5da3-a344-48e0-8c1c-bac0d3d310d4	2026-09-16 10:14	2026-09-16 10:13	2026-09-16 10:13	SHAK	SHAK270115P00055000	put	55.0000	2027-01-15	5.0000	4.7000	5.0000	58.5000	28500.00	28500.00	0.00	57	5	67	439	0.152619589977221	0.536832657669229	0.536832657669229	false	false	false	true
f1d3a555-6c0f-421e-ad26-48082e89ce7a	2026-09-16 10:10	2026-09-16 10:10	2026-09-16 10:10	SHAK	SHAK270617P00065000	put	65.0000	2027-06-17	13.2000	12.9000	13.2000	58.6900	26400.00	26400.00	0.00	20	20	20	3092	0.00646830530401035	0.526846073276486	0.526846073276486	false	false	false	true
be288096-4d50-4449-bfeb-e19fa561e2b7	2026-09-15 15:59	2026-09-15 15:59	2026-09-15 15:59	SHAK	SHAK260925C00057000	call	57.0000	2026-09-25	2.6500	2.3500	2.6500	58.0000	34715.00	34715.00	0.00	131	8	131	0	0	0.534313673142389	0.534313673142389	false	false	false	true
b69a40d3-05b2-4402-af05-688ec8b1e5b8	2026-09-15 15:03	2026-09-15 15:03	2026-09-15 15:03	SHAK	SHAK280121P00050000	put	50.0000	2028-01-21	7.4500	7.4000	8.5000	58.8636	80460.00	0.00	80460.00	108	2	108	141	0.765957446808511	0.522339827451278	0.522339827451278	false	true	false	true
288262d4-d106-48f6-9108-72a2ca394067	2026-09-15 13:50	2026-09-15 13:50	2026-09-15 13:50	SHAK	SHAK261218P00050000	put	50.0000	2026-12-18	2.5000	2.4500	2.5000	58.8700	34500.00	34500.00	0.00	138	24	144	171	0.842105263157895	0.557703434545431	0.557703434545431	false	false	false	true
f7eed6aa-26bc-4579-9c32-aebeeae8a27a	2026-09-15 13:04	2026-09-15 13:04	2026-09-15 13:04	SHAK	SHAK260918C00060000	call	60.0000	2026-09-18	1.1000	1.0000	1.1000	59.6200	20900.00	20900.00	0.00	190	18	190	587	0.323679727427598	0.588257991709527	0.588257991709527	false	false	false	true
7e99c861-723e-4f68-8f2c-541869b31c00	2026-09-15 09:42	2026-09-15 09:42	2026-09-15 09:42	SHAK	SHAK261120P00055000	put	55.0000	2026-11-20	2.7500	2.2000	2.9500	61.5200	13750.00	9625.00	4125.00	50	6	50	314	0.159235668789809	0.564323304890181	0.564323304890181	false	false	false	true
8eca8af5-3ffc-40d9-b9d7-65c2edef9c36	2026-09-14 15:26	2026-09-14 15:26	2026-09-14 15:26	SHAK	SHAK261218C00075000	call	75.0000	2026-12-18	3.1000	2.9000	3.1000	63.3600	11160.00	11160.00	0.00	36	9	36	583	0.0617495711835334	0.522609643554196	0.522609643554196	false	false	false	true
05a4fbaa-a93a-484e-bb00-81ffeecab590	2026-09-14 11:08	2026-09-14 11:08	2026-09-14 11:08	SHAK	SHAK270115C00080000	call	80.0000	2027-01-15	3.0000	2.8000	3.0000	63.8700	26100.00	26100.00	0.00	87	18	87	158	0.550632911392405	0.51667652826391	0.51667652826391	false	false	false	true
5ee650f2-49c4-41d0-aee0-65a0d45e8d87	2026-09-11 15:14	2026-09-11 15:13	2026-09-11 15:13	SHAK	SHAK280121C00055000	call	55.0000	2028-01-21	21.7000	21.0000	22.4000	63.8150	423150.00	0.00	245210.00	195	5	195	197	0.989847715736041	0.569238722434861	0.56785811182054	false	false	false	true
7bc7d821-0349-425d-9cf7-3aa24e72edb4	2026-09-11 09:41	2026-09-11 09:40	2026-09-11 09:40	SHAK	SHAK260918C00053000	call	53.0000	2026-09-18	9.2000	9.2000	10.4000	62.2100	27600.00	0.00	27600.00	30	5	30	0	0	1.34836029632061	1.34836029632061	false	false	false	true
88bb5faf-a351-4f15-9095-1c1bac1bc912	2026-09-10 11:42	2026-09-10 11:42	2026-09-10 11:42	SHAK	SHAK261016P00060000	put	60.0000	2026-10-16	2.1500	2.0000	2.2500	63.3450	131345.00	130270.00	1075.00	611	52	617	462	1.33549783549784	0.47567172837416	0.47567172837416	false	false	false	true
bc4487d5-64f9-44a7-8d82-4ebf0af9b033	2026-09-10 10:19	2026-09-10 10:19	2026-09-10 10:19	SHAK	SHAK270115C00060000	call	60.0000	2027-01-15	9.8000	9.4000	9.8000	63.0400	194040.00	194040.00	0.00	198	19	198	167	1.18562874251497	0.538635206046761	0.538635206046761	false	false	false	true
1e073311-ab53-4bb2-bcc1-368d6520153c	2026-09-09 15:17	2026-09-09 15:16	2026-09-09 15:16	SHAK	SHAK261218C00070000	call	70.0000	2026-12-18	5.1000	5.0000	5.1000	64.4300	42330.00	42330.00	0.00	83	21	90	250	0.36	0.521334611537777	0.521334611537777	false	false	false	true
c1eed68b-99b9-4747-8f82-901007783ed2	2026-09-09 11:55	2026-09-09 11:55	2026-09-09 11:55	SHAK	SHAK261016P00060000	put	60.0000	2026-10-16	1.7500	1.6000	1.8000	64.4300	73480.00	73305.00	175.00	420	47	438	18	24.3333333333333	0.458875464651854	0.458875464651854	false	false	false	true
39dc259f-54c6-43ba-83f4-6e406477ba40	2026-09-08 13:47	2026-09-08 13:47	2026-09-08 13:47	SHAK	SHAK260918P00068000	put	68.0000	2026-09-18	2.2500	2.2500	2.3000	67.5700	10350.00	0.00	10350.00	46	5	346	144	2.40277777777778	0.461764861756765	0.461764861756765	false	false	false	true
c8388821-5a06-4cb1-9662-0f0e92f9dfea	2026-09-08 12:12	2026-09-08 12:11	2026-09-08 12:11	SHAK	SHAK280121P00035000	put	35.0000	2028-01-21	2.4000	1.7000	2.4000	68.2800	62400.00	62400.00	0.00	260	17	260	51	5.09803921568627	0.585899989013776	0.585899989013776	false	false	false	true
fa0245e4-6b6b-42c6-a4af-3bb51bd25644	2026-09-08 12:11	2026-09-08 12:11	2026-09-08 12:11	SHAK	SHAK260918P00068000	put	68.0000	2026-09-18	1.8400	1.5000	1.8500	68.3400	42030.00	41850.00	0.00	228	30	235	144	1.63194444444444	0.44431208345146	0.455469485826993	false	false	false	true
d2fed5e7-f704-47a8-8b5a-4f7fc603f287	2026-09-04 12:33	2026-09-04 12:33	2026-09-04 12:33	SHAK	SHAK261016P00070000	put	70.0000	2026-10-16	3.6000	3.5000	3.7000	70.4580	161280.00	160920.00	360.00	448	19	449	76	5.90789473684211	0.419455957534353	0.419455957534353	true	false	false	true
99920f60-ee18-401e-a7a0-70836f6b767b	2026-09-02 13:21	2026-09-02 13:20	2026-09-02 13:20	SHAK	SHAK261218C00065000	call	65.0000	2026-12-18	9.8000	9.7000	10.2000	69.0150	12740.00	3920.00	8820.00	13	9	21	197	0.106598984771574	0.499600051540011	0.499600051540011	false	false	false	true
90a3de44-7e9d-448b-9547-738c6157027a	2026-09-02 10:52	2026-09-02 10:52	2026-09-02 10:52	SHAK	SHAK260911C00073000	call	73.0000	2026-09-11	0.9000	0.7500	1.1500	70.5684	91690.00	91600.00	90.00	1019	52	1021	49	20.8367346938776	0.41073211593816	0.41073211593816	false	false	false	true
f2f85b38-9d8f-48dd-bdac-291a06d697c6	2026-08-31 12:23	2026-08-31 12:22	2026-08-31 12:22	SHAK	SHAK260904P00069000	put	69.0000	2026-09-04	0.8600	0.6500	0.9500	69.7200	11570.00	3570.00	8000.00	134	6	216	37	5.83783783783784	0.429940942956606	0.417060171256989	false	false	false	true
5b576327-98ae-42cb-8ba0-025d5d169d19	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SHAK	SHAK260904C00069000	call	69.0000	2026-09-04	1.9000	1.7000	1.9000	69.0000	37810.00	37810.00	0.00	199	29	199	14	14.2142857142857	0.385632957022958	0.385632957022958	false	false	false	true
88ca16b8-d66f-4ab0-aa87-9fdd6b0bf6af	2026-08-27 13:18	2026-08-27 13:18	2026-08-27 13:18	SHAK	SHAK280121C00090000	call	90.0000	2028-01-21	12.2100	12.2000	13.0000	70.8800	65920.00	1240.00	64680.00	54	19	64	142	0.450704225352113	0.507608287424083	0.510594217978652	false	false	false	true
5da8d733-1b0e-424a-a1a4-82bf1a315bdb	2026-08-27 11:41	2026-08-27 11:41	2026-08-27 11:41	SHAK	SHAK260918C00071000	call	71.0000	2026-09-18	3.4000	3.4000	3.6000	72.1100	41835.00	0.00	41835.00	123	25	123	0	0	0.388206108928187	0.388206108928187	false	false	false	true
e3192b1d-f614-4552-a8c7-835f78f224e3	2026-08-25 14:46	2026-08-25 14:46	2026-08-25 14:46	SHAK	SHAK260911C00073000	call	73.0000	2026-09-11	3.4000	3.0000	3.5000	74.1550	14960.00	14960.00	0.00	44	13	44	2	22	0.428313713426974	0.428313713426974	true	false	false	true
b14e006c-1add-41b0-be94-09fb68a0b49f	2026-08-25 10:49	2026-08-25 10:49	2026-08-25 10:49	SHAK	SHAK261218C00075000	call	75.0000	2026-12-18	8.5000	8.5000	8.9000	74.7500	315350.00	0.00	315350.00	371	23	371	253	1.46640316205534	0.491391044295947	0.491391044295947	false	false	false	true
e5638930-3984-4242-bc9d-db018b564660	2026-08-24 12:20	2026-08-24 12:20	2026-08-24 12:20	SHAK	SHAK260918C00070000	call	70.0000	2026-09-18	6.9000	6.9000	7.1000	75.4000	17250.00	0.00	17250.00	25	6	27	2526	0.0106888361045131	0.449749592568957	0.449749592568957	false	false	false	true
fbe458a2-9d63-4d6c-8783-b773e52661c6	2026-08-21 09:57	2026-08-21 09:57	2026-08-21 09:57	SHAK	SHAK261120P00060000	put	60.0000	2026-11-20	1.8500	1.8500	2.2000	74.7400	28490.00	0.00	28490.00	154	12	154	137	1.12408759124088	0.527540326287589	0.527540326287589	false	false	false	true
88f95040-6e3e-4eee-b950-b391c0adde93	2026-08-18 15:47	2026-08-18 15:47	2026-08-18 15:47	SHAK	SHAK260918P00070000	put	70.0000	2026-09-18	2.6500	2.5500	2.6500	71.0000	59095.00	59095.00	0.00	223	28	264	1235	0.213765182186235	0.409260851595803	0.409260851595803	false	false	false	true
e52fd0e4-6951-4d5e-bc72-1e9b2dad37eb	2026-08-18 11:23	2026-08-18 11:23	2026-08-18 11:23	SHAK	SHAK270617P00065000	put	65.0000	2027-06-17	8.6000	8.5000	9.3000	72.3500	222742.00	860.00	221882.00	259	39	403	2696	0.149480712166172	0.525925309656282	0.525925309656282	false	false	false	true
2a9c8585-90b3-4224-939c-be8c0fa21377	2026-08-18 10:49	2026-08-18 10:49	2026-08-18 10:49	SHAK	SHAK261120P00065000	put	65.0000	2026-11-20	3.9000	3.9000	4.2000	72.3800	98670.00	0.00	74490.00	253	5	253	1711	0.147866744593805	0.52337816332224	0.52337816332224	false	false	false	true