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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = SPX×

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

45993d16-eb4a-47d1-8364-e45a42ae820d	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPX	SPX270917C08800000	call	8800.0000	2027-09-17	148.6000	148.5000	148.6000	7669.7600	237760.00	237760.00	0.00	16	5	419	6594	0.0635426144980285	0.133633544561509	0.133633544561509	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T19:57:26.018295Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
8cbad09c-6a58-42b5-989d-9f5e7883744e	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	SPX	SPX270917C08800000	call	8800.0000	2027-09-17	148.9000	148.7000	149.1000	7670.1500	327580.00	148900.00	134010.00	22	7	402	6594	0.0609645131938126	0.133714588166809	0.133714588166809	false	false	false
3624a560-a453-4c05-a25a-a6ad26971209	2026-09-29 15:55	2026-09-29 15:55	2026-09-29 15:55	SPX	SPX270617C08625000	call	8625.0000	2027-06-17	107.6000	107.6000	108.4000	7670.1900	204440.00	0.00	204440.00	19	5	110	958	0.11482254697286	0.127999585163573	0.127999585163573	false	false	false	true
0bcdc295-1e38-4242-9e61-57da831ec354	2026-09-29 15:51	2026-09-29 15:51	2026-09-29 15:51	SPX	SPX261218P07400000	put	7400.0000	2026-12-18	104.1000	103.5000	104.1000	7673.4500	770340.00	770340.00	0.00	74	5	2970	33034	0.0899073681661319	0.169241408110865	0.169241408110865	false	false	false
5eefc119-ec42-4c1f-aac6-ab313b3abb0c	2026-09-29 15:40	2026-09-29 15:40	2026-09-29 15:40	SPX	SPX261218P06300000	put	6300.0000	2026-12-18	20.7000	20.6000	20.9000	7650.0000	22770.00	0.00	22770.00	11	9	558	27856	0.0200315910396324	0.275713508216619	0.275713508216619	false	false	false	true
4dcd76a0-6063-4676-a045-c64184a347e9	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPX	SPX261218C07735000	call	7735.0000	2026-12-18	198.0000	197.5000	198.1000	7655.0000	2376000.00	0.00	0.00	120	22	1287	1695	0.75929203539823	0.133777673935399	0.133777673935399	false	false	false	true
23de4281-638b-4df1-b940-384e8fa96de2	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPX	SPX261218P07735000	put	7735.0000	2026-12-18	198.0000	197.5000	198.2000	7655.0000	2376000.00	0.00	0.00	120	22	1282	1609	0.796768178993163	0.142645642394481	0.142645642394481	false	false	false	true
a944873b-b5b3-47b7-a47e-0c584c836b7a	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPX	SPX261218P07735000	put	7735.0000	2026-12-18	198.1000	198.4000	199.0000	7655.0000	336770.00	0.00	0.00	17	6	1162	1609	0.722187694220012	0.142348698197749	0.142348698197749	false	false	false	true
a385d46d-708e-4cfc-8f8a-593ce94cc0fc	2026-09-29 15:37	2026-09-29 15:37	2026-09-29 15:37	SPX	SPX261218C07735000	call	7735.0000	2026-12-18	198.1000	197.3000	198.0000	7655.0000	336770.00	0.00	0.00	17	5	1167	1695	0.688495575221239	0.134249200232937	0.134249200232937	false	false	false	true
72b9e9ee-42c3-48df-92c5-b818b8781617	2026-09-29 15:36	2026-09-29 15:36	2026-09-29 15:36	SPX	SPX270319P06525000	put	6525.0000	2027-03-19	71.2900	71.2000	71.3000	7674.3800	114070.00	106950.00	7120.00	16	8	16	2544	0.00628930817610063	0.234658582124976	0.234658582124976	false	false	false	true
7a684bff-ffc1-44fc-87cf-5145f24aa30e	2026-09-29 15:29	2026-09-29 15:29	2026-09-29 15:29	SPX	SPX261218P06375000	put	6375.0000	2026-12-18	22.5000	22.5000	22.9000	7673.7900	13500.00	0.00	13500.00	6	5	7	4159	0.00168309689829286	0.267622933658008	0.267622933658008	false	false	false	true
5ff40745-0f73-4439-beb3-c6b04f96316e	2026-09-29 15:29	2026-09-29 15:29	2026-09-29 15:29	SPX	SPX261218P06300000	put	6300.0000	2026-12-18	20.7000	20.6000	20.9000	7673.8700	18630.00	2070.00	16560.00	9	9	534	27856	0.0191700172314762	0.275761678796232	0.275761678796232	false	false	false	true
ef38e89c-9438-47b8-a703-a098641461bb	2026-09-29 15:26	2026-09-29 15:26	2026-09-29 15:26	SPX	SPX261218P07735000	put	7735.0000	2026-12-18	197.7000	197.6000	198.3000	7655.0000	118620.00	0.00	0.00	6	6	945	1609	0.587321317588564	0.142262693757975	0.142262693757975	false	false	false	true
d652b811-c964-45e2-9a2a-6d536fc062eb	2026-09-29 15:26	2026-09-29 15:26	2026-09-29 15:26	SPX	SPX261218C07735000	call	7735.0000	2026-12-18	197.7000	197.3000	197.9000	7655.0000	138390.00	0.00	0.00	7	5	951	1695	0.561061946902655	0.133758010859255	0.133758010859255	false	false	false	true
01fcdb58-b5b1-4066-968e-37da71a2e2e1	2026-09-29 15:03	2026-09-29 15:03	2026-09-29 15:03	SPX	SPX261218P06810000	put	6810.0000	2026-12-18	39.6000	39.6000	40.0000	7678.6400	31680.00	0.00	31680.00	8	5	133	73	1.82191780821918	0.22428494435112	0.22428494435112	true	false	false	true
6967362b-4c36-4c82-bd99-e6db17ea43e8	2026-09-29 15:02	2026-09-29 15:02	2026-09-29 15:02	SPX	SPX270319P07250000	put	7250.0000	2027-03-19	152.5000	152.5000	153.3000	7678.1300	76250.00	0.00	76250.00	5	5	566	3934	0.143873919674631	0.18444668010212	0.18444668010212	true	false	false	true
b20afa38-3467-4535-972b-6e1e9cb234c6	2026-09-29 15:00	2026-09-29 15:00	2026-09-29 15:00	SPX	SPX270319P07250000	put	7250.0000	2027-03-19	152.6000	152.6000	153.2000	7678.0900	76300.00	0.00	76300.00	5	5	511	3934	0.129893238434164	0.184500864846369	0.184500864846369	true	false	false	true
14bb9d27-5776-497a-9d39-eeaa92e10f2f	2026-09-29 14:56	2026-09-29 14:56	2026-09-29 14:56	SPX	SPX270917P07800000	put	7800.0000	2027-09-17	412.1000	412.1000	413.3000	7676.2400	824200.00	0.00	824200.00	20	5	32	1651	0.0193821926105391	0.172776632187007	0.172776632187007	false	false	false	true
50bd7973-148a-4944-83f8-24072e178a4e	2026-09-29 14:31	2026-09-29 14:31	2026-09-29 14:31	SPX	SPX261120P06510000	put	6510.0000	2026-11-20	14.0000	13.7000	14.0000	7645.0000	70000.00	70000.00	0.00	50	6	50	6	8.33333333333333	0.268859314381537	0.268859314381537	false	false	false	true
adeb67b4-7f9e-4a1d-94d3-8d6a64b4c61f	2026-09-29 14:13	2026-09-29 14:13	2026-09-29 14:13	SPX	SPX271217P07000000	put	7000.0000	2027-12-17	260.0000	258.6000	260.9000	7662.9500	572000.00	26000.00	546000.00	22	7	84	108906	0.000771307365985345	0.211888568922251	0.211888568922251	false	false	false
ef6b76aa-860b-46ec-934b-3c246a207cfc	2026-09-29 14:12	2026-09-29 14:12	2026-09-29 14:12	SPX	SPX270115P06625000	put	6625.0000	2027-01-15	46.5000	46.4000	46.9000	7660.0800	65100.00	0.00	65100.00	14	5	14	1490	0.00939597315436242	0.234197442789725	0.234197442789725	false	false	false	true
9f0227b2-3a38-411a-a69f-3b8de7af3bdc	2026-09-29 14:12	2026-09-29 14:12	2026-09-29 14:12	SPX	SPX261218P06800000	put	6800.0000	2026-12-18	41.1000	41.1000	41.5000	7660.0600	102750.00	0.00	102750.00	25	6	576	25793	0.0223316403675416	0.225583396692506	0.225583396692506	false	false	false	true
9fc75406-408c-4e1b-ac7c-c198bc089029	2026-09-29 14:06	2026-09-29 14:06	2026-09-29 14:06	SPX	SPX261016P07250000	put	7250.0000	2026-10-16	10.7000	10.7000	11.0000	7666.9800	321000.00	0.00	321000.00	300	6	742	10837	0.068469133524038	0.188893035826922	0.188893035826922	false	false	false	true
759bdb62-f950-46f2-a8a2-36f915b2083b	2026-09-29 14:05	2026-09-29 14:05	2026-09-29 14:05	SPX	SPX261218C08600000	call	8600.0000	2026-12-18	4.6000	4.2000	4.6000	7665.6000	690000.00	690000.00	0.00	1500	7	1860	18646	0.0997532982945404	0.11725304337226	0.11725304337226	false	false	false	true
c9b72f20-c631-4186-bb6c-e71b055c500d	2026-09-29 13:59	2026-09-29 13:59	2026-09-29 13:59	SPX	SPX270917C07975000	call	7975.0000	2027-09-17	480.4300	478.3000	479.4000	7656.0200	32669240.00	0.00	0.00	680	11	700	90	7.77777777777778	0.155790899588517	0.155790899588517	false	false	false	true
b65a36f0-7cf4-4baf-afbf-3aa8eb7c8cf1	2026-09-29 13:59	2026-09-29 13:59	2026-09-29 13:59	SPX	SPX261218P07720000	put	7720.0000	2026-12-18	198.9000	200.3000	201.0000	7656.0200	815490.00	0.00	0.00	41	11	3233	1640	1.97134146341463	0.142014788925924	0.142014788925924	false	false	false	true
6307badb-bc04-489c-9382-4026561e6750	2026-09-29 13:59	2026-09-29 13:59	2026-09-29 13:59	SPX	SPX270917P07975000	put	7975.0000	2027-09-17	480.5100	481.2000	482.5000	7656.0200	32674680.00	0.00	0.00	680	11	680	123	5.52845528455285	0.16495188856006	0.16495188856006	false	false	false	true
0fc3f530-3c76-48d6-9957-8257e7521891	2026-09-29 13:59	2026-09-29 13:59	2026-09-29 13:59	SPX	SPX261218C07720000	call	7720.0000	2026-12-18	197.9000	195.9000	196.5000	7656.0200	811390.00	0.00	0.00	41	11	3236	1740	1.85977011494253	0.135642288456126	0.135642288456126	false	false	false	true
dd2a4745-bf2e-4a1d-a115-493af01cbede	2026-09-29 13:41	2026-09-29 13:41	2026-09-29 13:41	SPX	SPX270521P04600000	put	4600.0000	2027-05-21	22.5000	22.4000	22.9000	7661.2600	191250.00	0.00	191250.00	85	4	85	350	0.242857142857143	0.367842959993439	0.367842959993439	false	true	false	true
5964fd9d-11fa-4786-a2d9-fad1c7837fd2	2026-09-29 13:39	2026-09-29 13:39	2026-09-29 13:39	SPX	SPX261016C07740000	call	7740.0000	2026-10-16	50.4000	49.9000	50.4000	7660.8900	25200.00	25200.00	0.00	5	5	54	680	0.0794117647058823	0.11850731203799	0.11850731203799	false	false	false	true
9052b25b-2755-4ebd-885b-6b9074cd7eb0	2026-09-29 13:33	2026-09-29 13:33	2026-09-29 13:33	SPX	SPX261016P06600000	put	6600.0000	2026-10-16	2.5500	2.4000	2.5500	7659.7400	34680.00	34680.00	0.00	136	9	519	20473	0.0253504615835491	0.320680682332895	0.320680682332895	false	false	false	true
90d432c9-63ed-40e2-9dc7-9c5b7b5e8125	2026-09-29 13:23	2026-09-29 13:23	2026-09-29 13:23	SPX	SPX261016P07500000	put	7500.0000	2026-10-16	36.4600	36.0000	36.6000	7656.4700	1093850.00	418600.00	675250.00	300	13	1058	35889	0.0294797848923068	0.152231958801142	0.152426011983321	false	false	false
f1ef38b9-9aa3-4f56-887f-01fd2b6cc646	2026-09-29 13:11	2026-09-29 13:11	2026-09-29 13:11	SPX	SPX270617P06500000	put	6500.0000	2027-06-17	112.0000	111.7000	112.1000	7656.5800	112000.00	67200.00	44800.00	10	5	222	11616	0.0191115702479339	0.231541885529196	0.231541885529196	false	false	false
cb0326d3-5c03-4a9f-9eb1-1cbf5b1bf289	2026-09-29 13:09	2026-09-29 13:09	2026-09-29 13:09	SPX	SPX270617P07750000	put	7750.0000	2027-06-17	350.7000	350.2000	351.1000	7656.1400	350700.00	70140.00	210420.00	10	5	73	2440	0.0299180327868852	0.166119762019469	0.166119762019469	false	false	false
27c8a5c8-371c-40fa-b7d0-772ff5464ff7	2026-09-29 13:08	2026-09-29 13:08	2026-09-29 13:08	SPX	SPX270617P07750000	put	7750.0000	2027-06-17	350.6000	350.0000	351.2000	7655.9900	350600.00	70120.00	280480.00	10	5	53	2440	0.0217213114754098	0.166055499905532	0.166055499905532	false	false	false
07544871-ad86-4601-91b3-d2b1c08bd7b3	2026-09-29 13:01	2026-09-29 13:01	2026-09-29 13:01	SPX	SPX261120C08070000	call	8070.0000	2026-11-20	25.0000	24.8000	25.2000	7656.5400	17500.00	10000.00	5000.00	7	7	14	248	0.0564516129032258	0.115640709548453	0.115640709548453	false	false	false	true
53e0229a-8790-4778-b448-89b20077e38e	2026-09-29 12:35	2026-09-29 12:35	2026-09-29 12:35	SPX	SPX261120P06025000	put	6025.0000	2026-11-20	7.6000	7.4000	7.6000	7640.0000	228000.00	228000.00	0.00	300	6	600	278	2.15827338129496	0.330358464050982	0.330358464050982	false	false	false	true
c2337aa6-54c9-425f-8060-eadf2d231488	2026-09-29 12:21	2026-09-29 12:20	2026-09-29 12:20	SPX	SPX270319P05500000	put	5500.0000	2027-03-19	28.8000	28.5000	29.0000	7662.0100	80640.00	80640.00	0.00	28	5	59	10203	0.00578261295697344	0.313219406389369	0.313219406389369	false	false	false	true
5d5452bc-70dd-408c-869b-a9915a6cfc08	2026-09-29 12:17	2026-09-29 12:17	2026-09-29 12:17	SPX	SPX270617P04550000	put	4550.0000	2027-06-17	25.1000	24.8000	25.1000	7660.3700	45180.00	45180.00	0.00	18	5	261	429	0.608391608391608	0.363344930490179	0.363344930490179	false	false	false	true
54f0102d-ef4f-477d-a234-7bdd98679bed	2026-09-29 12:15	2026-09-29 12:14	2026-09-29 12:14	SPX	SPX270617P04550000	put	4550.0000	2027-06-17	25.1000	24.9000	25.1000	7659.8900	35140.00	35140.00	0.00	14	5	178	429	0.414918414918415	0.363313184183206	0.363313184183206	false	false	false	true
8be353c9-eaf0-4d11-9efe-f75057f2d987	2026-09-29 12:08	2026-09-29 12:08	2026-09-29 12:08	SPX	SPX270617P02200000	put	2200.0000	2027-06-17	3.3500	3.1000	3.5000	7640.0000	418750.00	0.00	0.00	1250	8	1250	865	1.44508670520231	0.593029670857429	0.593029670857429	false	false	false	true
681c914d-4f7b-426b-9120-2e1a79831c0b	2026-09-29 12:08	2026-09-29 12:08	2026-09-29 12:08	SPX	SPX270617P03000000	put	3000.0000	2027-06-17	7.5600	7.4000	7.7000	7640.0000	453600.00	0.00	0.00	600	8	750	1659	0.452079566003617	0.502428961643982	0.502428961643982	false	false	false	true
5fe48f2f-5ed9-48c4-954a-89f8a4fc6d37	2026-09-29 12:08	2026-09-29 12:08	2026-09-29 12:08	SPX	SPX261016P06510000	put	6510.0000	2026-10-16	2.2400	2.1000	2.3000	7640.0000	16800.00	0.00	0.00	75	8	75	607	0.123558484349259	0.339887183969139	0.339887183969139	false	false	false	true
5303b957-afd8-4426-bce5-365a36199567	2026-09-29 12:08	2026-09-29 12:08	2026-09-29 12:08	SPX	SPX270617P01200000	put	1200.0000	2027-06-17	0.7500	0.7000	0.8000	7640.0000	348750.00	0.00	0.00	4650	8	4650	7773	0.598224623697414	0.749362718819637	0.749362718819637	false	false	false	true
2bcecba9-d98b-4921-8c88-99c38ab656b0	2026-09-29 12:08	2026-09-29 12:08	2026-09-29 12:08	SPX	SPX270617P03800000	put	3800.0000	2027-06-17	14.6200	14.4000	14.8000	7640.0000	511700.00	0.00	0.00	350	8	369	26213	0.014076984702247	0.426494575235316	0.426494575235316	false	false	false	true
5627edf6-1876-4cad-a571-36a78aa7ba20	2026-09-29 11:48	2026-09-29 11:48	2026-09-29 11:48	SPX	SPX261120P07250000	put	7250.0000	2026-11-20	51.8000	51.2000	51.8000	7666.1300	31080.00	31080.00	0.00	6	5	8	7323	0.00109244845008876	0.182661719071906	0.182661719071906	false	false	false	true
f5f5adcc-748f-4d03-9581-a7df1b086afd	2026-09-29 11:41	2026-09-29 11:41	2026-09-29 11:41	SPX	SPX270319P06250000	put	6250.0000	2027-03-19	54.7100	54.6000	55.2000	7665.3200	93010.00	32820.00	60190.00	17	12	17	2105	0.00807600950118765	0.253744443786462	0.253755850084282	false	false	false
b7c5a72f-f79f-4292-8311-3cd78e30c0f6	2026-09-29 11:41	2026-09-29 11:41	2026-09-29 11:41	SPX	SPX270917P07475000	put	7475.0000	2027-09-17	321.6000	320.2000	321.6000	7665.2100	2637120.00	2637120.00	0.00	82	6	165	1189	0.138772077375946	0.186286002354634	0.186286002354634	false	false	false
42ac0c0c-aca0-48ea-bfd9-0c65b730826d	2026-09-29 11:41	2026-09-29 11:41	2026-09-29 11:41	SPX	SPX270917P07475000	put	7475.0000	2027-09-17	321.2000	320.0000	321.6000	7665.2100	2633840.00	1991440.00	642400.00	82	6	83	1189	0.0698065601345669	0.186137376160859	0.186137376160859	false	false	false
7e97e788-f590-430b-9524-7d32febf477e	2026-09-29 11:39	2026-09-29 11:39	2026-09-29 11:39	SPX	SPX261218P07725000	put	7725.0000	2026-12-18	196.6000	195.8000	196.6000	7668.7400	1867700.00	0.00	0.00	95	8	244	1745	0.139828080229226	0.142907635963718	0.142907635963718	false	false	false	true