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:alert_rule = RepeatedHits×ticker = SPOT×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

44fa47ce-fba0-4b68-a76e-faec16fb5025	2026-08-17 14:21	2026-08-17 14:21	2026-08-17 14:21	SPOT	SPOT261016P00480000	put	480.0000	2026-10-16	22.5000	21.5000	23.8500	494.0400	51755.00	49495.00	2260.00	23	15	23	158	0.145569620253165	0.386602792105768	0.387039772159101	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Communication Services	114506693095.00	2026-11-03	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
90936e86-142d-4a8a-bf44-5b506d2ab0ba	2026-08-17 15:13	2026-08-17 15:12	2026-08-17 15:12	SPOT	SPOT261016P00400000	put	400.0000	2026-10-16	3.1000	2.6500	3.1000	495.9500	56420.00	56420.00	0.00	182	47	184	302	0.609271523178808	0.408760575285017	0.408760575285017	true	false	false	true
10fffe9b-e5fa-4006-9351-8418d1268e35	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	SPOT	SPOT260918P00520000	put	520.0000	2026-09-18	23.2500	22.1500	23.4000	518.1400	355715.00	353385.00	2330.00	153	41	156	165	0.945454545454545	0.384626692327159	0.387120222054036	false	false	false	true
b3c7bd92-6aec-49e9-913f-6a4e90de7cdd	2026-08-18 12:19	2026-08-18 12:19	2026-08-18 12:19	SPOT	SPOT260821C00520000	call	520.0000	2026-08-21	11.5000	11.0000	11.9000	524.8900	57500.00	57500.00	0.00	50	6	127	2233	0.0568741603224362	0.462791257712942	0.462791257712942	false	false	false	true
e3ed6988-5089-42ca-a674-773983717734	2026-08-19 12:59	2026-08-19 12:59	2026-08-19 12:59	SPOT	SPOT261016P00460000	put	460.0000	2026-10-16	6.7500	6.7500	7.1000	540.5750	96525.00	0.00	96525.00	143	33	150	279	0.537634408602151	0.416528442526253	0.416528442526253	false	false	false	true
6cff7e4d-93dc-4e95-b17d-d4cefbcbacde	2026-08-19 14:39	2026-08-19 14:39	2026-08-19 14:39	SPOT	SPOT260918P00490000	put	490.0000	2026-09-18	6.3500	6.3000	6.9000	538.3100	88261.00	0.00	88261.00	139	51	168	1282	0.131045241809672	0.399511549990395	0.395214781458079	true	false	false	true
e2e1ae67-c48e-46f6-a09c-e3a8779a7ebe	2026-08-20 09:48	2026-08-20 09:48	2026-08-20 09:48	SPOT	SPOT260918C00580000	call	580.0000	2026-09-18	9.5000	9.3000	10.1500	539.7000	66500.00	8550.00	8550.00	70	18	375	1621	0.231338679827267	0.382411381192953	0.382411381192953	false	false	false	true
c1c7e530-e4a0-4373-9052-456f6ba33c4a	2026-08-20 10:47	2026-08-20 10:47	2026-08-20 10:47	SPOT	SPOT260918C00530000	call	530.0000	2026-09-18	25.0800	24.4000	26.0000	532.4100	60190.00	0.00	60190.00	24	23	37	115	0.321739130434783	0.386599466532744	0.382391683860963	false	false	false	true
b7be56bb-4282-4700-9dc8-a45cca951940	2026-08-20 10:50	2026-08-20 10:50	2026-08-20 10:50	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	23.4000	22.9500	23.4000	532.1257	121680.00	121680.00	0.00	52	16	96	1296	0.0740740740740741	0.426699736677459	0.426699736677459	false	false	false	true
46721389-6ffa-4fcc-a7f3-0eace0f2e84d	2026-08-20 10:50	2026-08-20 10:50	2026-08-20 10:50	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	23.2000	23.1000	23.2000	531.9700	102080.00	102080.00	0.00	44	9	150	1296	0.115740740740741	0.425376176538309	0.425376176538309	false	false	false	true
c1cd393a-812c-4a99-a3d8-3b902892fee9	2026-08-20 10:50	2026-08-20 10:50	2026-08-20 10:50	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	23.0500	22.9000	23.0500	531.9700	53015.00	53015.00	0.00	23	6	227	1296	0.175154320987654	0.424087362043627	0.424087362043627	false	false	false	true
84ac700a-0e83-4cac-85ea-b051dc86070a	2026-08-20 10:50	2026-08-20 10:50	2026-08-20 10:50	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	23.1000	22.8500	23.1000	531.9700	200970.00	200970.00	0.00	87	18	314	1296	0.242283950617284	0.4245171610806	0.4245171610806	false	false	false	true
10221171-613e-4701-9f65-f68ada851a5d	2026-08-20 14:54	2026-08-20 14:53	2026-08-20 14:53	SPOT	SPOT270917C00590000	call	590.0000	2027-09-17	92.0000	90.4500	92.0000	535.9100	625600.00	625600.00	0.00	68	5	123	0	0	0.467802279345641	0.467802279345641	false	false	false	true
25f190f2-ced0-4d68-97a3-53a7a0942c0f	2026-08-20 15:44	2026-08-20 15:43	2026-08-20 15:43	SPOT	SPOT260918C00520000	call	520.0000	2026-09-18	31.5000	31.5000	32.6500	535.1750	81905.00	0.00	81905.00	26	11	34	189	0.17989417989418	0.37387311143098	0.37387311143098	true	false	false	true
cf59f00a-54ba-40c4-a37b-c2b6f25e42dd	2026-08-20 15:54	2026-08-20 15:54	2026-08-20 15:54	SPOT	SPOT260821C00470000	call	470.0000	2026-08-21	64.7000	64.7000	68.2000	534.7200	109990.00	0.00	84110.00	17	17	17	504	0.0337301587301587	2.13378155495856	2.12442177272829	false	false	false	true
fabe49e6-81c0-4ca4-80a1-acf0d291e947	2026-08-20 15:54	2026-08-20 15:54	2026-08-20 15:54	SPOT	SPOT260821C00470000	call	470.0000	2026-08-21	64.7000	64.3500	67.7500	534.6200	213510.00	0.00	213510.00	33	16	183	504	0.363095238095238	0.932816461622682	0.932816461622682	false	false	false	true
900ddc9f-f68e-454e-8edf-8666a9fe43d3	2026-08-21 09:31	2026-08-21 09:31	2026-08-21 09:31	SPOT	SPOT270115C00640000	call	640.0000	2027-01-15	23.6300	23.6000	28.3500	532.7750	70880.00	0.00	33040.00	30	6	30	237	0.126582278481013	0.410391791228595	0.410391791228595	false	false	false	true
92dc3189-aca8-4f37-92c3-d34a9840cfb9	2026-08-21 10:18	2026-08-21 10:18	2026-08-21 10:18	SPOT	SPOT261016C00540000	call	540.0000	2026-10-16	30.2500	30.2500	31.6500	533.2050	163350.00	0.00	163350.00	54	33	57	138	0.41304347826087	0.383689207869558	0.383689207869558	true	false	false	true
96a219d9-8ea3-41c3-b061-efc8139a301f	2026-08-21 12:45	2026-08-21 12:44	2026-08-21 12:44	SPOT	SPOT260911P00550000	put	550.0000	2026-09-11	23.9000	22.7500	23.9000	538.8500	88430.00	88430.00	0.00	37	16	37	1	37	0.355646199470568	0.355646199470568	false	false	false	true
c59ddd94-5b75-4650-b317-050e3aff7d64	2026-08-25 09:50	2026-08-25 09:50	2026-08-25 09:50	SPOT	SPOT260911P00575000	put	575.0000	2026-09-11	34.9000	31.0500	34.9000	548.4500	432760.00	432760.00	0.00	124	38	124	1	124	0.404473164629796	0.404473164629796	false	false	false	true
1a9da378-7e95-47ef-96dc-138098dbe0ab	2026-08-25 14:05	2026-08-25 14:05	2026-08-25 14:05	SPOT	SPOT260904C00570000	call	570.0000	2026-09-04	6.6000	5.5500	6.6000	549.0000	65992.00	65992.00	0.00	100	28	114	24	4.75	0.388748315712452	0.388748315712452	false	false	false	true
155d4978-b407-4d8a-b4e3-4353b8a2d505	2026-08-26 10:46	2026-08-26 10:46	2026-08-26 10:46	SPOT	SPOT270617P00470000	put	470.0000	2027-06-17	44.3500	41.2000	44.4500	546.9100	62085.00	57660.00	4425.00	14	6	15	46	0.326086956521739	0.462202706867388	0.462761208998483	true	false	false	true
b0883fd7-6c01-4b82-a658-592b9b9ca23f	2026-08-26 12:31	2026-08-26 12:31	2026-08-26 12:31	SPOT	SPOT261218C00800000	call	800.0000	2026-12-18	4.0500	4.0500	4.7500	544.9400	74520.00	0.00	74520.00	184	42	184	248	0.741935483870968	0.428260358748693	0.428260358748693	false	false	false	true
96ca730b-885e-4c5a-97b3-d1b5f00dfe36	2026-08-26 15:44	2026-08-26 15:44	2026-08-26 15:44	SPOT	SPOT260828P00542500	put	542.5000	2026-08-28	3.3000	3.3000	4.2000	551.6800	54452.00	0.00	54452.00	165	45	170	4	42.5	0.432416428731187	0.432416428731187	false	false	false	true
ffd712a0-d3d0-48f5-87b2-5627715b6177	2026-08-27 11:09	2026-08-27 11:09	2026-08-27 11:09	SPOT	SPOT270319P00480000	put	480.0000	2027-03-19	39.9900	39.7000	41.8000	528.2500	399850.00	200100.00	199750.00	100	5	207	164	1.26219512195122	0.436927169405255	0.435476012930434	false	false	false	true
d561e6e4-50e9-4b16-b980-77bb379dbc43	2026-08-27 11:24	2026-08-27 11:24	2026-08-27 11:24	SPOT	SPOT261016P00480000	put	480.0000	2026-10-16	10.0500	9.4000	10.0500	528.7600	101505.00	101505.00	0.00	101	27	112	194	0.577319587628866	0.386740120472025	0.386740120472025	false	false	false	true
357a42ec-82e7-4925-9f89-83baa6051a89	2026-08-28 11:32	2026-08-28 11:31	2026-08-28 11:31	SPOT	SPOT260918C00580000	call	580.0000	2026-09-18	8.7000	8.5500	9.9500	550.9600	56550.00	55680.00	870.00	65	22	106	2164	0.0489833641404806	0.361390220239538	0.361390220239538	false	false	false	true
d92532e3-2d95-4d8a-85ca-f5a2f5d806b4	2026-08-28 11:33	2026-08-28 11:33	2026-08-28 11:33	SPOT	SPOT260925C00585000	call	585.0000	2026-09-25	10.6400	8.3500	11.3000	552.8900	76595.00	53150.00	23445.00	72	11	72	13	5.53846153846154	0.359767993423434	0.367120175843072	true	false	false	true
c75fcad4-7010-44ff-b153-fe2a551d9f5c	2026-08-28 12:21	2026-08-28 12:21	2026-08-28 12:21	SPOT	SPOT261016C00680000	call	680.0000	2026-10-16	2.7200	2.2300	2.7200	549.9200	94928.00	94928.00	0.00	349	42	376	25	15.04	0.38562460858246	0.38562460858246	true	false	false	true
1d147c18-1bad-4da6-b1e0-a4b5e6386e50	2026-08-28 12:21	2026-08-28 12:21	2026-08-28 12:21	SPOT	SPOT261016C00570000	call	570.0000	2026-10-16	23.0000	22.3000	23.6000	549.9200	85100.00	85100.00	0.00	37	9	122	566	0.215547703180212	0.377951540824621	0.377951540824621	false	false	false	true
7affbe0a-06c4-4323-b529-a255d5f0730a	2026-08-28 12:34	2026-08-28 12:33	2026-08-28 12:33	SPOT	SPOT261016C00560000	call	560.0000	2026-10-16	26.3000	25.8500	26.3000	548.5500	73640.00	73640.00	0.00	28	7	92	794	0.115869017632242	0.376538757261315	0.376538757261315	false	false	false	true
adc074e4-e0c8-41ed-a5ca-373a8e0ec07d	2026-09-01 11:00	2026-09-01 11:00	2026-09-01 11:00	SPOT	SPOT270319P00450000	put	450.0000	2027-03-19	25.1500	23.3500	26.4000	546.3000	120720.00	20120.00	100600.00	48	9	48	85	0.564705882352941	0.4509729515976	0.4509729515976	false	false	false	true
c90de888-c4c2-4729-9c8f-49b683fa5689	2026-09-01 12:09	2026-09-01 12:09	2026-09-01 12:09	SPOT	SPOT260904P00537500	put	537.5000	2026-09-04	5.4500	4.9000	5.7500	544.0000	101374.00	100274.00	560.00	186	52	186	12	15.5	0.438733705978757	0.435885772520045	false	false	false	true
85b31101-8693-456e-9858-de4934a9972e	2026-09-01 14:00	2026-09-01 14:00	2026-09-01 14:00	SPOT	SPOT280121P00320000	put	320.0000	2028-01-21	18.1000	18.1000	19.5000	542.8150	65160.00	0.00	65160.00	36	12	44	323	0.136222910216718	0.488561060718453	0.488561060718453	false	false	false	true
14b34826-ee2d-46b4-8ddc-b7a4d8b95b3d	2026-09-02 09:45	2026-09-02 09:45	2026-09-02 09:45	SPOT	SPOT260918P00570000	put	570.0000	2026-09-18	22.5000	22.5000	24.2500	560.7950	51750.00	0.00	51750.00	23	5	26	17	1.52941176470588	0.383273722477535	0.383273722477535	false	false	false	true
97a8fc7c-7ead-43b9-a739-bec5e7279543	2026-09-03 10:54	2026-09-03 10:54	2026-09-03 10:54	SPOT	SPOT261016C00560000	call	560.0000	2026-10-16	32.4000	31.9500	32.4000	565.5900	200880.00	200880.00	0.00	62	6	81	726	0.111570247933884	0.36695854287847	0.36695854287847	false	false	false	true
a0f42386-51eb-479c-882a-4ed79e1a7c79	2026-09-03 10:57	2026-09-03 10:57	2026-09-03 10:57	SPOT	SPOT261016C00570000	call	570.0000	2026-10-16	26.5500	26.0500	26.5500	564.3400	220365.00	220365.00	0.00	83	9	94	549	0.171220400728597	0.362923207560827	0.362923207560827	true	false	false	true
ad84e203-aa1c-4853-92a7-6b1696b5cfda	2026-09-03 10:58	2026-09-03 10:58	2026-09-03 10:58	SPOT	SPOT261016P00570000	put	570.0000	2026-10-16	30.0000	28.6500	30.4000	563.8901	504005.00	495000.00	9005.00	168	46	170	8	21.25	0.3652390191708	0.364997198069286	true	false	false	true
e096b58f-4bb8-4bf0-92ef-ed0ee26a65b5	2026-09-03 11:12	2026-09-03 11:12	2026-09-03 11:12	SPOT	SPOT270115C00590000	call	590.0000	2027-01-15	49.9500	47.3000	49.9500	567.2700	129870.00	129870.00	0.00	26	7	26	283	0.0918727915194346	0.412231236833382	0.412231236833382	false	false	false	true
49392dad-54e3-4a8d-abe1-7cf63b607414	2026-09-03 12:10	2026-09-03 12:10	2026-09-03 12:10	SPOT	SPOT261016C00560000	call	560.0000	2026-10-16	30.6500	30.4000	30.6500	563.4250	217615.00	217615.00	0.00	71	8	311	726	0.428374655647383	0.360031921990113	0.360031921990113	false	false	false	true
dbb33f8f-bd0d-45fe-bd47-370820ee8167	2026-09-03 12:54	2026-09-03 12:54	2026-09-03 12:54	SPOT	SPOT261016C00560000	call	560.0000	2026-10-16	29.7500	29.0000	29.7500	561.0000	895470.00	892500.00	2970.00	301	48	625	726	0.860881542699725	0.365757626098754	0.365757626098754	false	false	false	true
8825b0ed-bdea-4265-bce0-622a490dd3b3	2026-09-03 14:55	2026-09-03 14:55	2026-09-03 14:55	SPOT	SPOT261002P00580000	put	580.0000	2026-10-02	31.6000	30.4000	31.6000	562.6000	221200.00	221200.00	0.00	70	19	110	10	11	0.357541411053757	0.357541411053757	false	false	false	true
48882c70-50eb-42f2-b54a-17d541f386e5	2026-09-03 15:37	2026-09-03 15:37	2026-09-03 15:37	SPOT	SPOT260918C00590000	call	590.0000	2026-09-18	5.9000	5.3500	5.9000	560.6450	56637.00	56637.00	0.00	96	36	102	264	0.386363636363636	0.35137850268884	0.35137850268884	false	false	false	true
ba45ad56-df47-44a1-9507-44ce62ca4092	2026-09-04 11:07	2026-09-04 11:07	2026-09-04 11:07	SPOT	SPOT261016P00520000	put	520.0000	2026-10-16	15.2500	14.3000	15.2500	545.1500	269923.00	269923.00	0.00	177	50	206	252	0.817460317460317	0.37269288403108	0.37269288403108	false	false	false	true
9f516a41-0584-4f3f-a085-8196dcde041b	2026-09-04 11:40	2026-09-04 11:40	2026-09-04 11:40	SPOT	SPOT270115P00540000	put	540.0000	2027-01-15	48.1500	48.1500	49.1000	542.7400	120375.00	0.00	120375.00	25	12	35	1263	0.0277117973079968	0.412181598777929	0.412181598777929	false	false	false	true
e642f87e-522f-4d8e-ad04-47a9cc773491	2026-09-04 15:02	2026-09-04 15:02	2026-09-04 15:02	SPOT	SPOT261009C00465000	call	465.0000	2026-10-09	86.3600	81.9000	89.1500	546.3100	172720.00	121000.00	51720.00	20	5	20	1	20	0.425925493122088	0.427681476646955	false	false	false	true
0dd44f66-ad76-4c5a-8ebb-5e7721f78f00	2026-09-04 15:14	2026-09-04 15:14	2026-09-04 15:14	SPOT	SPOT260925P00555000	put	555.0000	2026-09-25	23.9500	22.8500	23.9500	545.0800	270635.00	270635.00	0.00	113	33	113	0	0	0.367016557426562	0.367016557426562	false	false	false	true
7c416bb3-c2b6-455f-958f-747062fbc07c	2026-09-08 13:42	2026-09-08 13:42	2026-09-08 13:42	SPOT	SPOT261009C00485000	call	485.0000	2026-10-09	54.4000	52.7500	56.0000	530.2100	81600.00	76160.00	5440.00	15	6	15	11	1.36363636363636	0.40950253658889	0.40950253658889	false	false	false	true
53382c87-89f8-4283-a14c-b855ed73ba4a	2026-09-09 09:37	2026-09-09 09:37	2026-09-09 09:37	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	18.0000	15.3500	18.0000	527.0400	100800.00	57600.00	0.00	56	7	56	955	0.0586387434554974	0.422922654838936	0.422922654838936	false	false	false	true
ddf9a191-ab28-4c29-9904-fd85cbfa1b36	2026-09-09 09:37	2026-09-09 09:37	2026-09-09 09:37	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	17.3000	15.4500	18.1500	527.0400	266420.00	31140.00	15570.00	154	17	210	955	0.219895287958115	0.41591584738146	0.41591584738146	false	false	false	true