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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:sector = Communication Services×ticker = SPHR×

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

3bd9b30c-fe3c-4ef3-881a-36837b2636a2	2026-09-15 09:44	2026-09-15 09:43	2026-09-15 09:43	SPHR	SPHR261016C00135000	call	135.0000	2026-10-16	17.9000	17.3000	18.6000	149.6400	26850.00	3580.00	8950.00	15	10	15	277	0.0541516245487365	0.49951014127453	0.49951014127453	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Communication Services	4281506132.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"}	2026-09-15	2026-09-15 21:15	2026-09-15 21:15
f87565cc-6c6e-469b-bb5d-684252153433	2026-09-14 14:47	2026-09-14 14:47	2026-09-14 14:47	SPHR	SPHR261016C00135000	call	135.0000	2026-10-16	15.6000	15.3000	15.6000	146.5400	20280.00	4680.00	0.00	13	5	53	303	0.174917491749175	0.496694742978172	0.496694742978172	false	false	false	true
a2fadf10-4055-4d4e-bed6-11f6a42b1f30	2026-09-14 10:56	2026-09-14 10:55	2026-09-14 10:55	SPHR	SPHR261016C00135000	call	135.0000	2026-10-16	15.5000	14.2000	16.2000	146.3100	31000.00	6200.00	10850.00	20	6	20	303	0.066006600660066	0.501722441929564	0.501722441929564	false	false	false	true
2688b6c3-68bd-461c-80a5-3defd32765ea	2026-09-11 09:54	2026-09-11 09:54	2026-09-11 09:54	SPHR	SPHR261016C00135000	call	135.0000	2026-10-16	14.3000	13.2000	14.5000	144.0000	12870.00	12870.00	0.00	9	5	17	303	0.0561056105610561	0.494133183457405	0.494133183457405	false	false	false	true
7a804063-58f2-49e6-9d44-2abc28a73fe3	2026-09-08 11:14	2026-09-08 11:14	2026-09-08 11:14	SPHR	SPHR261120C00150000	call	150.0000	2026-11-20	11.0000	11.0000	11.3000	142.8400	53901.00	0.00	53901.00	49	19	49	1993	0.0245860511791269	0.531287242238826	0.531287242238826	false	false	false	true
5a020f22-4743-4961-aeb6-9fc672d911a6	2026-09-04 14:38	2026-09-04 14:38	2026-09-04 14:38	SPHR	SPHR261016C00140000	call	140.0000	2026-10-16	10.8000	10.8000	11.5000	142.6800	28080.00	0.00	28080.00	26	17	26	48	0.541666666666667	0.474717869939869	0.474717869939869	false	false	false	true
4a6ece69-ccbd-4f60-aa91-386362d12ae6	2026-09-04 12:10	2026-09-04 12:10	2026-09-04 12:10	SPHR	SPHR261120C00150000	call	150.0000	2026-11-20	11.3000	11.2000	12.0000	142.6000	11300.00	0.00	11300.00	10	5	15	1991	0.00753390256152687	0.532346997515225	0.532346997515225	false	false	false	true
851aab55-62ad-4c40-9675-4d2abc376f8e	2026-09-04 09:47	2026-09-04 09:47	2026-09-04 09:47	SPHR	SPHR270219C00180000	call	180.0000	2027-02-19	9.9000	8.3000	11.0000	144.2075	100980.00	6930.00	94050.00	102	13	102	9144	0.0111548556430446	0.523301913394549	0.523301913394549	true	false	false	true
34775d39-6517-4a34-9a99-e2a626c94cd9	2026-09-03 15:50	2026-09-03 15:50	2026-09-03 15:50	SPHR	SPHR260918C00140000	call	140.0000	2026-09-18	6.9000	6.8000	7.3000	143.2850	11730.00	8280.00	3450.00	17	10	227	312	0.727564102564103	0.432878799547595	0.432878799547595	false	false	false	true
b186d0b4-8342-43f0-9271-a4dca96fd829	2026-09-03 13:31	2026-09-03 13:30	2026-09-03 13:30	SPHR	SPHR260918P00125000	put	125.0000	2026-09-18	0.7000	0.5000	1.1500	141.1800	13860.00	1680.00	12180.00	198	45	198	7	28.2857142857143	0.494193812587103	0.494193812587103	false	false	false	true
0a421b24-34e3-45cc-ae27-e6121bdd5eb7	2026-09-03 12:30	2026-09-03 12:30	2026-09-03 12:30	SPHR	SPHR260918C00140000	call	140.0000	2026-09-18	6.0000	5.9000	6.0000	141.2200	10800.00	10800.00	0.00	18	6	75	312	0.240384615384615	0.462207911688199	0.462207911688199	true	false	false	true
70d6dc4a-d311-4a56-949b-ed710c93beb6	2026-09-03 11:30	2026-09-03 11:30	2026-09-03 11:30	SPHR	SPHR260918C00140000	call	140.0000	2026-09-18	5.6000	5.3000	5.6000	140.1300	10640.00	10640.00	0.00	19	7	19	312	0.0608974358974359	0.479440832123648	0.479440832123648	false	false	false	true
d574c7f7-61c3-4afb-9b46-e3b6f1b4213a	2026-09-03 10:44	2026-09-03 10:44	2026-09-03 10:44	SPHR	SPHR261016C00140000	call	140.0000	2026-10-16	9.2000	9.2000	10.5000	138.8600	43240.00	0.00	43240.00	47	25	47	1	47	0.497267828136324	0.497267828136324	false	false	false	true
41f7e838-94cb-4d6a-905a-2449ce157632	2026-09-02 15:49	2026-09-02 15:49	2026-09-02 15:49	SPHR	SPHR270219C00200000	call	200.0000	2027-02-19	6.4000	4.2000	6.6000	141.7350	16640.00	14080.00	2560.00	26	6	26	2	13	0.543529950121395	0.543529950121395	false	false	false	true
d689e56b-9139-4a75-b801-9026a1b3338d	2026-09-01 15:17	2026-09-01 15:16	2026-09-01 15:16	SPHR	SPHR261016C00135000	call	135.0000	2026-10-16	9.5000	9.1000	9.6000	134.2300	30400.00	30400.00	0.00	32	15	44	253	0.173913043478261	0.513713014654878	0.509023292001236	false	false	false	true
60bf7375-dc93-4490-9d76-88788a355086	2026-09-01 13:49	2026-09-01 13:49	2026-09-01 13:49	SPHR	SPHR261120C00160000	call	160.0000	2026-11-20	5.3000	5.3000	5.7000	134.0050	23850.00	0.00	23850.00	45	15	50	306	0.163398692810458	0.528912346971282	0.528912346971282	false	false	false	true
3a04d5e1-ba0f-4390-94ee-4017f30194b6	2026-09-01 11:25	2026-09-01 11:25	2026-09-01 11:25	SPHR	SPHR261016P00110000	put	110.0000	2026-10-16	1.7000	1.4500	1.9000	136.4100	13260.00	13090.00	170.00	78	33	79	0	0	0.57258567973357	0.57258567973357	false	false	false	true
ef548bc5-c3dd-45fa-991f-5558ae6eed19	2026-08-31 10:35	2026-08-31 10:35	2026-08-31 10:35	SPHR	SPHR260918C00135000	call	135.0000	2026-09-18	6.5000	5.7000	6.5000	134.9300	154700.00	154700.00	0.00	238	32	337	565	0.59646017699115	0.536652251321037	0.536652251321037	false	false	false	true
d65b651b-678a-48ad-b5d2-ca12b34ca2c2	2026-08-27 12:00	2026-08-27 12:00	2026-08-27 12:00	SPHR	SPHR260918P00155000	put	155.0000	2026-09-18	8.9500	8.6000	9.7000	151.5550	17894.00	0.00	17894.00	20	8	20	42	0.476190476190476	0.48854989736516	0.48854989736516	false	false	false	true
252e7939-757f-4003-b4af-3943eb893397	2026-08-27 11:50	2026-08-27 11:50	2026-08-27 11:50	SPHR	SPHR260918C00175000	call	175.0000	2026-09-18	1.3000	0.8000	1.5000	151.1900	26252.00	26252.00	0.00	202	36	203	117	1.73504273504274	0.514559791473062	0.514559791473062	false	false	false	true
da946dbd-dc88-4826-81db-9055abd6cc02	2026-08-26 14:55	2026-08-26 14:55	2026-08-26 14:55	SPHR	SPHR261016P00145000	put	145.0000	2026-10-16	6.1000	6.1000	6.9000	157.7500	67710.00	0.00	67710.00	111	34	112	10	11.2	0.517689024452489	0.517689024452489	false	false	false	true
0a2aae87-ac18-4b17-a609-a068ce42038d	2026-08-26 13:57	2026-08-26 13:57	2026-08-26 13:57	SPHR	SPHR260918P00165000	put	165.0000	2026-09-18	12.1000	11.4000	12.1000	157.0900	137940.00	137940.00	0.00	114	27	115	14	8.21428571428571	0.482766578549546	0.482766578549546	false	false	false	true
2c7bac6c-1660-40d6-ac5a-55ff9df1fd2f	2026-08-25 15:35	2026-08-25 15:35	2026-08-25 15:35	SPHR	SPHR261120C00260000	call	260.0000	2026-11-20	1.1000	0.0500	1.1000	161.7000	10010.00	10010.00	0.00	91	22	290	1	290	0.570038099954715	0.570038099954715	false	false	false	true
8ebbd7c8-864b-4d7f-9a46-b6b4a351ac9d	2026-08-25 14:35	2026-08-25 14:35	2026-08-25 14:35	SPHR	SPHR261120C00260000	call	260.0000	2026-11-20	1.1500	0.3500	1.1500	160.1200	18284.00	18284.00	0.00	159	37	173	1	173	0.585411880611308	0.585411880611308	false	false	false	true
b69a2338-1f57-4bb0-b718-a1a94c3119d8	2026-08-25 13:32	2026-08-25 13:32	2026-08-25 13:32	SPHR	SPHR261016C00195000	call	195.0000	2026-10-16	2.5500	2.2500	2.5500	159.0700	24476.00	24476.00	0.00	96	23	106	76	1.39473684210526	0.503326983731724	0.503326983731724	false	false	false	true
95b8c74a-00c4-4bb7-80a8-6656f78e552c	2026-08-25 12:23	2026-08-25 12:23	2026-08-25 12:23	SPHR	SPHR260918C00175000	call	175.0000	2026-09-18	3.0000	2.5000	3.0000	159.6900	16800.00	16800.00	0.00	56	17	60	57	1.05263157894737	0.493790071102533	0.493790071102533	false	false	false	true
09d5695c-f633-4a48-b635-9b46517a0ca4	2026-08-25 11:04	2026-08-25 11:04	2026-08-25 11:04	SPHR	SPHR261016P00140000	put	140.0000	2026-10-16	4.4000	4.4000	5.1000	159.0700	14960.00	0.00	14960.00	34	21	34	0	0	0.524614482016416	0.524614482016416	false	false	false	true
d5a66694-70ce-4300-8420-1e9433d76f74	2026-08-24 11:06	2026-08-24 11:06	2026-08-24 11:06	SPHR	SPHR260918C00190000	call	190.0000	2026-09-18	0.9500	0.3000	0.9500	157.8450	23750.00	23750.00	0.00	250	36	256	114	2.24561403508772	0.516543555690302	0.516543555690302	false	false	false	true
004e15f0-2dac-45b2-9bdc-3006f626be0f	2026-08-21 15:41	2026-08-21 15:41	2026-08-21 15:41	SPHR	SPHR261016C00165000	call	165.0000	2026-10-16	10.5300	10.1000	11.6000	159.8450	11582.00	0.00	11582.00	11	7	30	40	0.75	0.495842194337217	0.495842194337217	false	false	false	true
dcb6a219-ddd0-413b-a8fb-2be5b48862e7	2026-08-21 15:40	2026-08-21 15:40	2026-08-21 15:40	SPHR	SPHR261016C00165000	call	165.0000	2026-10-16	10.8400	10.5000	11.8000	160.2450	10844.00	0.00	10844.00	10	8	19	40	0.475	0.50641857043431	0.50641857043431	false	false	false	true
e9b01ab3-42d2-4fa6-87eb-3f26611cef8e	2026-08-21 15:16	2026-08-21 15:16	2026-08-21 15:16	SPHR	SPHR260918C00155000	call	155.0000	2026-09-18	12.1000	12.1000	12.6000	160.6600	35090.00	0.00	35090.00	29	21	29	27	1.07407407407407	0.500346617432588	0.500346617432588	false	false	false	true
095ecfc2-f5b7-429b-bb92-08a521c67d3f	2026-08-21 13:52	2026-08-21 13:52	2026-08-21 13:52	SPHR	SPHR261016C00195000	call	195.0000	2026-10-16	3.0000	2.5000	3.0000	159.8000	21300.00	21300.00	0.00	71	23	71	0	0	0.503788686371498	0.503788686371498	false	false	false	true
eb7a579c-641f-4d30-8f9e-e43be2c9b06f	2026-08-21 12:21	2026-08-21 12:21	2026-08-21 12:21	SPHR	SPHR261016C00160000	call	160.0000	2026-10-16	12.5000	12.0000	12.6000	158.8500	13750.00	13750.00	0.00	11	5	21	0	0	0.508526243324081	0.508526243324081	false	false	false	true
678f3013-449c-48e8-811a-c1b6242845ac	2026-08-21 12:15	2026-08-21 12:15	2026-08-21 12:15	SPHR	SPHR261120C00185000	call	185.0000	2026-11-20	8.6000	7.7000	8.6000	158.6700	102340.00	102340.00	0.00	119	21	119	14	8.5	0.540477259967199	0.540477259967199	false	false	false	true
bff3ac41-65f2-4c12-aa62-068cb5216e01	2026-08-21 11:04	2026-08-21 11:04	2026-08-21 11:04	SPHR	SPHR261120C00180000	call	180.0000	2026-11-20	8.9000	7.8000	9.2000	155.7100	133495.00	133495.00	0.00	150	37	150	158	0.949367088607595	0.542750694633527	0.542750694633527	false	false	false	true
6005c8e7-f18a-4ae7-8ce5-b551f2d88986	2026-08-20 14:12	2026-08-20 14:12	2026-08-20 14:12	SPHR	SPHR261016P00160000	put	160.0000	2026-10-16	12.4000	12.4000	13.3000	158.3200	23560.00	0.00	23560.00	19	16	19	0	0	0.481638382741624	0.481638382741624	false	false	false	true
9ef22f87-0607-4101-86f6-9cfd02e3e4a7	2026-08-20 10:56	2026-08-20 10:56	2026-08-20 10:56	SPHR	SPHR261016C00165000	call	165.0000	2026-10-16	11.3000	11.3000	12.3000	162.0300	45200.00	0.00	45200.00	40	21	40	0	0	0.478117636542641	0.478117636542641	false	false	false	true
33b22b8b-c260-4cb6-a8e6-20f91fbcda02	2026-08-19 11:57	2026-08-19 11:57	2026-08-19 11:57	SPHR	SPHR260918P00170000	put	170.0000	2026-09-18	12.6000	12.1500	12.6000	164.4750	109620.00	109620.00	0.00	87	27	87	9	9.66666666666667	0.518971948203753	0.518971948203753	false	false	false	true
357b8b29-5279-4880-839c-bb9b7f73d245	2026-08-18 11:54	2026-08-18 11:54	2026-08-18 11:54	SPHR	SPHR270219C00180000	call	180.0000	2027-02-19	21.6000	20.0000	21.6000	167.2650	64800.00	64800.00	0.00	30	5	37	9101	0.00406548730908691	0.534163466635285	0.534163466635285	false	false	false	true
e41b0312-c591-45f7-85e4-c427586d5646	2026-08-17 15:43	2026-08-17 15:43	2026-08-17 15:43	SPHR	SPHR261120P00145000	put	145.0000	2026-11-20	7.6000	7.4000	8.6000	168.9200	86640.00	0.00	86640.00	114	35	114	3	38	0.551109347992096	0.551109347992096	false	false	false	true
03fba6c2-d283-4d4c-bf93-651f4d0f9ee0	2026-08-17 10:52	2026-08-17 10:52	2026-08-17 10:52	SPHR	SPHR260918C00190000	call	190.0000	2026-09-18	3.3000	2.6500	3.3000	170.4801	18480.00	18480.00	0.00	56	15	67	59	1.13559322033898	0.473316787444733	0.473316787444733	false	false	false	true