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:er_time = unknown×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

27f335c2-b2fd-4b46-a84c-13c8fba3317c	2026-09-16 09:50	2026-09-16 09:50	2026-09-16 09:50	SPOT	SPOT261016P00600000	put	600.0000	2026-10-16	48.5200	46.4500	50.6000	559.1600	97045.00	48645.00	48400.00	20	6	22	4	5.5	0.36476129396906	0.367549864513906	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Communication Services	112678900256.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
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
10d2f8bb-24df-48de-9f1a-95f9431de6a9	2026-09-15 10:02	2026-09-15 10:02	2026-09-15 10:02	SPOT	SPOT261016C00560000	call	560.0000	2026-10-16	22.3400	22.0500	23.3500	553.6450	67015.00	15715.00	51300.00	30	16	33	742	0.0444743935309973	0.377744614720964	0.377744614720964	true	false	false	true
bfc5bd73-c5ff-4888-899b-ee4c8370cbea	2026-09-15 09:51	2026-09-15 09:51	2026-09-15 09:51	SPOT	SPOT261218C00580000	call	580.0000	2026-12-18	39.6100	38.0000	40.3000	554.4500	71305.00	35690.00	35615.00	18	8	30	106	0.283018867924528	0.426041296666749	0.42916313442036	true	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	false
a07a8b9d-5b57-48f0-b915-eb7791207ec2	2026-09-15 09:36	2026-09-15 09:36	2026-09-15 09:36	SPOT	SPOT261023C00595000	call	595.0000	2026-10-23	12.3600	11.0500	16.0000	550.2850	88980.00	14880.00	74100.00	72	8	74	7	10.5714285714286	0.393078195726028	0.393885657665119	true	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
6a55902d-8bde-4712-a7b4-fb2271d6dedd	2026-09-11 12:36	2026-09-11 12:35	2026-09-11 12:35	SPOT	SPOT261218C00620000	call	620.0000	2026-12-18	17.3100	17.3000	18.1500	526.1175	67505.00	1755.00	64015.00	39	10	41	206	0.199029126213592	0.417908337440063	0.420654366686644	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	false
7dbed918-b1cf-49f5-af7d-e844c68532ea	2026-09-09 15:39	2026-09-09 15:39	2026-09-09 15:39	SPOT	SPOT270617P00350000	put	350.0000	2027-06-17	13.1900	11.7000	13.5000	523.6800	277090.00	275815.00	1275.00	210	18	211	95	2.22105263157895	0.473542552579844	0.474739156242027	true	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
8770aac5-fd35-4b14-a59e-745db9aacda6	2026-09-09 13:35	2026-09-09 13:35	2026-09-09 13:35	SPOT	SPOT270115C00640000	call	640.0000	2027-01-15	19.2500	18.7500	19.3000	527.4600	59670.00	30805.00	28865.00	31	5	33	241	0.136929460580913	0.416242860965047	0.415761053934175	false	false	false	true
737e501f-a31e-40f8-9e93-03e47d295682	2026-09-09 12:23	2026-09-09 12:23	2026-09-09 12:23	SPOT	SPOT261016P00520000	put	520.0000	2026-10-16	21.9000	20.9000	22.6500	526.7200	396398.00	394213.00	2185.00	181	53	182	414	0.439613526570048	0.394117287458457	0.39219905833732	false	false	false	true
9bd8e5ef-dc75-44b2-b279-941f6ac92f3f	2026-09-09 11:13	2026-09-09 11:13	2026-09-09 11:13	SPOT	SPOT270115C00570000	call	570.0000	2027-01-15	40.8700	37.2000	40.9500	533.0600	232950.00	126655.00	8135.00	57	9	57	16	3.5625	0.419925338453936	0.417932213413792	true	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
4155e4a9-3a65-4d8f-b43f-f8fd4c2415c7	2026-09-09 09:37	2026-09-09 09:37	2026-09-09 09:37	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	17.0400	16.5000	17.5000	525.8100	294740.00	264070.00	0.00	173	26	725	955	0.759162303664921	0.416564928114548	0.416493110283446	false	false	false	true
3566ae5b-a0d1-4d53-89c8-411a0c0f75c4	2026-09-09 09:37	2026-09-09 09:37	2026-09-09 09:37	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	16.9400	16.4500	17.5000	525.8600	382860.00	142420.00	79650.00	226	53	552	955	0.578010471204188	0.414336270897241	0.415860024906346	true	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
8004d486-e4ad-44d7-a4f2-3340e7a6b682	2026-09-09 09:37	2026-09-09 09:37	2026-09-09 09:37	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	17.3400	16.7000	18.1500	527.2600	72825.00	57255.00	15570.00	42	5	252	955	0.263874345549738	0.415360275172861	0.415862767308847	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	false
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	false
88a01995-ac98-4390-baef-a6999b4beaa5	2026-09-04 14:43	2026-09-04 14:43	2026-09-04 14:43	SPOT	SPOT270416P00500000	put	500.0000	2027-04-16	44.2500	44.1500	45.4500	544.9650	194700.00	44250.00	150450.00	44	9	52	0	0	0.431732088357038	0.431399700921125	false	false	false	true	false
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
68bc127a-3696-4ae4-bcd5-ea65d1342078	2026-09-04 10:06	2026-09-04 10:06	2026-09-04 10:06	SPOT	SPOT270115C00690000	call	690.0000	2027-01-15	16.4300	16.3500	17.1000	554.2200	164280.00	49650.00	114630.00	100	6	109	46	2.3695652173913	0.400564152719939	0.400564152719939	true	false	false	true
7ef7e95b-6838-434b-9104-19c8da464dc0	2026-09-04 10:06	2026-09-04 10:06	2026-09-04 10:06	SPOT	SPOT261218C00690000	call	690.0000	2026-12-18	12.6400	12.1000	15.2500	554.2200	85980.00	44575.00	41405.00	68	7	68	62	1.09677419354839	0.411015798906373	0.413393255820296	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	false
00fef4d4-91f3-4d13-96bc-3be8708315b5	2026-09-03 13:48	2026-09-03 13:48	2026-09-03 13:48	SPOT	SPOT270115C00480000	call	480.0000	2027-01-15	111.8700	109.0500	113.2500	564.5400	134248.00	134248.00	0.00	12	9	12	177	0.0677966101694915	0.453591597862685	0.434012748957055	false	false	false	true
5fe059c5-504c-4137-8ce3-a091d8b192d7	2026-09-03 13:34	2026-09-03 13:34	2026-09-03 13:34	SPOT	SPOT261009C00520000	call	520.0000	2026-10-09	55.8900	51.4000	56.0000	565.2650	340925.00	184560.00	156365.00	61	5	68	1	68	0.377560833812652	0.378527888598435	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
0fc09a87-4346-411b-a084-8d14cb3522f3	2026-09-03 11:24	2026-09-03 11:24	2026-09-03 11:24	SPOT	SPOT261016C00570000	call	570.0000	2026-10-16	27.3000	27.1500	27.8500	566.7300	51870.00	27300.00	16350.00	19	6	197	549	0.358834244080146	0.356114154375519	0.357404391280897	true	false	false	true
62bc20c2-0342-4c14-b0ee-912ea942687a	2026-09-03 11:16	2026-09-03 11:16	2026-09-03 11:16	SPOT	SPOT261009C00510000	call	510.0000	2026-10-09	66.1400	62.5000	67.8500	567.5650	231475.00	231475.00	0.00	35	7	47	0	0	0.394598353160087	0.394598353160087	false	false	false	true	false
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	false
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
14418161-01c1-4bf0-b079-9a9e730dccda	2026-09-03 10:23	2026-09-03 10:23	2026-09-03 10:23	SPOT	SPOT261016C00550000	call	550.0000	2026-10-16	41.3500	40.7500	42.2500	569.6100	1116454.00	8270.00	1108184.00	270	64	289	172	1.68023255813953	0.37203200605323	0.379764957069898	true	false	false	true
30deb5fc-59f0-4dbf-8c0d-60a2b404bb37	2026-09-02 14:14	2026-09-02 14:14	2026-09-02 14:14	SPOT	SPOT261009P00510000	put	510.0000	2026-10-09	8.3100	7.5500	9.9500	560.6500	77310.00	37510.00	39800.00	93	9	118	1	118	0.394304269930955	0.39530975468913	false	false	false	true	false
1fc59430-f842-46b2-8f15-49352134f6d7	2026-09-02 13:38	2026-09-02 13:38	2026-09-02 13:38	SPOT	SPOT261218C00550000	call	550.0000	2026-12-18	58.2500	57.7000	59.5500	558.6300	1095097.00	11640.00	1083457.00	188	51	194	75	2.58666666666667	0.423607103824468	0.423461843525051	false	false	false	true