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:alert_rule = RepeatedHits×ticker = SPOT×

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

b95bd3e7-79d5-4a20-9d03-624d5191e498	2026-09-17 11:04	2026-09-17 11:04	2026-09-17 11:04	SPOT	SPOT260925P00525000	put	525.0000	2026-09-25	6.7500	6.0000	7.0000	538.2089	60075.00	14850.00	45225.00	89	5	189	38	4.97368421052632	0.395281998240628	0.395281998240628	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Communication Services	108852473579.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
085a0c70-6ce9-4548-bbfc-85e5d1adbf21	2026-09-17 09:59	2026-09-17 09:59	2026-09-17 09:59	SPOT	SPOT261016C00540000	call	540.0000	2026-10-16	26.1000	24.1000	26.9000	543.3750	57420.00	54810.00	2610.00	22	6	22	208	0.105769230769231	0.386218652390209	0.386218652390209	false	false	false	true
38a5a0c3-2f10-408f-95e6-4f64c7c8daf9	2026-09-17 09:43	2026-09-17 09:43	2026-09-17 09:43	SPOT	SPOT270617C00720000	call	720.0000	2027-06-17	35.2100	35.2000	40.4000	541.4600	80985.00	0.00	80985.00	23	6	23	42	0.547619047619048	0.439604639179936	0.439604639179936	true	false	false	true
e59df356-9aeb-4832-bc85-f43b3be6cc21	2026-09-16 13:28	2026-09-16 13:28	2026-09-16 13:28	SPOT	SPOT270416P00420000	put	420.0000	2027-04-16	16.9000	15.3000	17.1500	553.1400	76050.00	76050.00	0.00	45	5	45	17	2.64705882352941	0.449650399847072	0.449650399847072	false	false	false	true
605b3606-8837-4a93-aac8-ed32ac128e66	2026-09-16 10:19	2026-09-16 10:19	2026-09-16 10:19	SPOT	SPOT270416C00630000	call	630.0000	2027-04-16	51.8300	51.1000	52.3500	559.0000	82935.00	72590.00	10345.00	16	6	16	6	2.66666666666667	0.429515452965292	0.428033576429764	true	false	false	true
813c7970-a7d9-479d-8623-02d3bfbea1ba	2026-09-16 09:30	2026-09-16 09:30	2026-09-16 09:30	SPOT	SPOT261218C00610000	call	610.0000	2026-12-18	29.0000	28.1500	29.0000	560.5050	52200.00	2900.00	0.00	18	6	18	308	0.0584415584415584	0.405641923963342	0.405641923963342	false	false	false	true
0ee7fd73-fd85-474c-b04c-0d129675c1fd	2026-09-15 13:23	2026-09-15 13:22	2026-09-15 13:22	SPOT	SPOT270319P00460000	put	460.0000	2027-03-19	23.6000	22.8000	23.6000	558.6200	73160.00	73160.00	0.00	31	6	31	105	0.295238095238095	0.448685751416374	0.448685751416374	false	false	false	true
b8861c3c-6eef-45e4-97df-3f973e6db502	2026-09-15 09:39	2026-09-15 09:39	2026-09-15 09:39	SPOT	SPOT261016C00610000	call	610.0000	2026-10-16	7.0500	7.0500	7.2500	554.0300	92368.00	0.00	91663.00	131	48	546	678	0.805309734513274	0.37648490200753	0.37648490200753	false	false	false	true
3b3ab3c5-7d19-414a-81b5-84a30284103d	2026-09-15 09:37	2026-09-15 09:36	2026-09-15 09:36	SPOT	SPOT261009C00490000	call	490.0000	2026-10-09	65.8000	62.9500	69.4500	550.4400	59220.00	6580.00	52640.00	9	9	9	1	9	0.430038153787263	0.430038153787263	false	false	false	true
5277438b-64ff-4a4b-b4b0-ba17cfeedf1f	2026-09-14 13:12	2026-09-14 13:12	2026-09-14 13:12	SPOT	SPOT261218P00580000	put	580.0000	2026-12-18	57.8000	57.8000	61.7000	557.6850	121380.00	0.00	121380.00	21	6	21	44	0.477272727272727	0.429414078338382	0.429414078338382	false	false	false	true
c903f840-1c07-44f9-88d8-6eaf6a6ca109	2026-09-14 11:49	2026-09-14 11:49	2026-09-14 11:49	SPOT	SPOT270115C00640000	call	640.0000	2027-01-15	25.6400	21.6500	25.6500	552.0800	58980.00	58980.00	0.00	23	9	38	264	0.143939393939394	0.414909724372964	0.41447969707927	false	false	false	true
6307b039-3bfc-4352-9b4d-6fbe271c31f6	2026-09-11 14:13	2026-09-11 14:13	2026-09-11 14:13	SPOT	SPOT270319C00520000	call	520.0000	2027-03-19	72.5500	70.9500	73.1500	523.5550	159610.00	152355.00	7255.00	22	13	22	60	0.366666666666667	0.439233210226655	0.439233210226655	false	false	false	true
9942eee7-15cf-4af1-9340-f78055a9b38e	2026-09-10 12:28	2026-09-10 12:28	2026-09-10 12:28	SPOT	SPOT261002P00530000	put	530.0000	2026-10-02	21.3000	20.4000	21.3000	526.9200	238560.00	238560.00	0.00	112	37	112	43	2.6046511627907	0.393856406712999	0.393856406712999	false	false	false	true
66f6656f-317f-4dc3-b738-6e4ac188705e	2026-09-10 10:36	2026-09-10 10:36	2026-09-10 10:36	SPOT	SPOT260925C00527500	call	527.5000	2026-09-25	16.7500	16.7500	18.3000	526.8700	97150.00	0.00	97150.00	58	18	58	0	0	0.390978032860803	0.390978032860803	false	false	false	true
7d0e9fcc-0b79-496d-afa9-503cb34e3c3a	2026-09-09 14:05	2026-09-09 14:04	2026-09-09 14:04	SPOT	SPOT270115C00520000	call	520.0000	2027-01-15	59.5000	57.5500	59.5000	526.6700	148750.00	148750.00	0.00	25	10	25	111	0.225225225225225	0.426701141382922	0.426701141382922	false	false	false	true
fbcbece2-36e0-41ef-890f-b4a37c8dc1bb	2026-09-09 13:55	2026-09-09 13:55	2026-09-09 13:55	SPOT	SPOT270319P00560000	put	560.0000	2027-03-19	79.2500	79.0500	81.0500	526.3100	182275.00	15850.00	166425.00	23	8	26	22	1.18181818181818	0.439745670447915	0.439745670447915	false	false	false	true
3c911e11-1e57-4842-b23f-d77e53ac40e2	2026-09-09 10:06	2026-09-09 10:06	2026-09-09 10:06	SPOT	SPOT261218C00760000	call	760.0000	2026-12-18	3.6500	3.6000	4.5000	531.9200	70812.00	0.00	70812.00	194	43	194	162	1.19753086419753	0.425764528347215	0.425764528347215	false	false	false	true
1d716088-ed7e-4083-8308-76b52c8c0305	2026-09-09 09:37	2026-09-09 09:37	2026-09-09 09:37	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	16.8500	16.0000	16.8500	525.8600	124690.00	37070.00	0.00	74	18	326	955	0.341361256544503	0.414336270897241	0.414336270897241	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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