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 = Consumer Cyclical×ticker = TOL×

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

5bf272c8-94be-4607-b8bf-096f4aacf7b7	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	TOL	TOL261218P00140000	put	140.0000	2026-12-18	10.7000	10.7000	11.3000	135.6350	82393.00	0.00	82393.00	77	8	513	245	2.09387755102041	0.341282687605772	0.341282687605772	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Cyclical	12485918500.00	2026-12-14	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
207a8d2e-ac14-477f-b7c1-91673d0f1396	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	TOL	TOL261218P00140000	put	140.0000	2026-12-18	10.6700	10.6000	11.3000	135.6000	69380.00	0.00	69380.00	65	11	436	245	1.77959183673469	0.336075549770543	0.339844874113177	false	false	false	true
5fb0461a-0296-43e3-8ecf-c36ffd828259	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	TOL	TOL261218P00145000	put	145.0000	2026-12-18	13.7900	13.7000	14.5000	135.6400	81387.00	0.00	81387.00	59	9	146	19	7.68421052631579	0.339738057049627	0.340904772249043	false	false	false	true
01ec10bc-0b9d-4e20-a9f3-c252c8725f74	2026-09-21 15:40	2026-09-21 15:40	2026-09-21 15:40	TOL	TOL261218P00140000	put	140.0000	2026-12-18	11.0000	10.6000	11.0000	136.1100	34100.00	34100.00	0.00	31	5	219	245	0.893877551020408	0.360946366471697	0.360946366471697	false	false	false	true
6bdec604-ed5e-4156-8b11-51b9d127feb0	2026-09-21 15:39	2026-09-21 15:39	2026-09-21 15:39	TOL	TOL261218P00140000	put	140.0000	2026-12-18	11.1000	10.6000	11.1000	136.2050	45510.00	45510.00	0.00	41	7	157	245	0.640816326530612	0.366492088064247	0.366492088064247	false	false	false	true
7febe85a-f9a2-43da-bcbb-8b674deddcb5	2026-09-21 15:39	2026-09-21 15:38	2026-09-21 15:38	TOL	TOL261218P00140000	put	140.0000	2026-12-18	10.9000	10.6000	10.9000	136.1700	27250.00	27250.00	0.00	25	5	97	245	0.395918367346939	0.35833338477005	0.35833338477005	false	false	false	true
8ad7b60e-2f2a-46c1-9e2b-6cfab816cbbf	2026-09-21 15:09	2026-09-21 15:09	2026-09-21 15:09	TOL	TOL261218P00150000	put	150.0000	2026-12-18	16.8300	16.8000	17.5000	136.5300	45454.00	0.00	45454.00	27	5	446	38	11.7368421052632	0.349118608544813	0.347087928880988	false	false	false	true
16b4269d-152f-4133-a720-9a2df3963753	2026-09-21 15:08	2026-09-21 15:08	2026-09-21 15:08	TOL	TOL261218P00150000	put	150.0000	2026-12-18	16.8000	16.8000	17.5000	136.4700	48722.00	0.00	48722.00	29	7	361	38	9.5	0.345477779703754	0.345477779703754	false	false	false	true
24e3bd0c-f888-4bdb-93b0-37b89b8f9bf1	2026-09-21 10:54	2026-09-21 10:54	2026-09-21 10:54	TOL	TOL261218P00150000	put	150.0000	2026-12-18	19.1000	18.6000	19.1000	133.9600	59210.00	59210.00	0.00	31	6	215	38	5.65789473684211	0.370213642069739	0.370213642069739	false	false	false	true
b4463161-b3cb-42da-b9b5-46b8e798a946	2026-09-21 10:54	2026-09-21 10:54	2026-09-21 10:54	TOL	TOL261218P00150000	put	150.0000	2026-12-18	19.1000	18.6000	19.1000	133.9600	59210.00	59210.00	0.00	31	5	184	38	4.84210526315789	0.370213642069739	0.370213642069739	false	false	false	true
1082438c-3017-4234-a668-d96a75c73050	2026-09-21 10:53	2026-09-21 10:53	2026-09-21 10:53	TOL	TOL261218P00150000	put	150.0000	2026-12-18	19.0000	18.6000	19.0000	134.0950	39897.00	39897.00	0.00	21	5	136	38	3.57894736842105	0.369025704744294	0.369025704744294	false	false	false	true
067c9a8f-9318-4c65-9b23-68ebcfeb2fb2	2026-09-09 12:51	2026-09-09 12:51	2026-09-09 12:51	TOL	TOL260918P00130000	put	130.0000	2026-09-18	1.4200	1.4000	1.6500	133.0000	14100.00	3950.00	10150.00	99	6	115	554	0.207581227436823	0.367402924787834	0.367402924787834	false	false	false	true
636bd2a9-caf1-4ab7-8774-1935179a3ff3	2026-09-03 14:45	2026-09-03 14:45	2026-09-03 14:45	TOL	TOL261016C00160000	call	160.0000	2026-10-16	1.2100	0.9500	1.2500	141.8500	12115.00	12115.00	0.00	100	6	212	43	4.93023255813953	0.321075527063684	0.316817464884469	false	false	false	true
90d8222c-63ba-4ea9-ba8e-b43ca45ae6c1	2026-09-03 14:44	2026-09-03 14:44	2026-09-03 14:44	TOL	TOL261016C00160000	call	160.0000	2026-10-16	1.1800	0.9500	1.2500	141.8500	10629.00	10629.00	0.00	90	8	112	43	2.6046511627907	0.321075527063684	0.313363886205141	false	false	false	true
2823f9b6-85b1-4ada-bf46-012fdac12148	2026-09-02 15:28	2026-09-02 15:28	2026-09-02 15:28	TOL	TOL270115C00155000	call	155.0000	2027-01-15	6.6000	6.6000	7.2000	140.9500	251460.00	0.00	251460.00	381	22	384	71	5.40845070422535	0.324742886534293	0.324742886534293	false	false	false	true
6c4c4bd9-307d-4512-818f-17ccfeb9ba8d	2026-08-26 13:06	2026-08-26 13:06	2026-08-26 13:06	TOL	TOL260918C00145000	call	145.0000	2026-09-18	8.3000	7.3000	8.3000	149.7700	10790.00	10790.00	0.00	13	5	14	110	0.127272727272727	0.363600600617036	0.363600600617036	false	false	false	true
d06d13b5-8615-49e3-b8a3-5d752c820610	2026-08-25 15:18	2026-08-25 15:18	2026-08-25 15:18	TOL	TOL260918P00145000	put	145.0000	2026-09-18	2.5000	2.3000	2.5000	150.0100	32750.00	32750.00	0.00	131	25	142	300	0.473333333333333	0.312365496990216	0.312365496990216	false	false	false	true
c33b24d8-9977-4e86-902f-2504c1db5c3c	2026-08-25 11:58	2026-08-25 11:58	2026-08-25 11:58	TOL	TOL260918P00150000	put	150.0000	2026-09-18	4.8000	4.5000	4.8000	149.6600	47520.00	47520.00	0.00	99	9	100	126	0.793650793650794	0.314728881731722	0.314728881731722	false	false	false	true
1fed4e4d-0713-4850-9e2f-6db1b5bc7bfe	2026-08-24 12:05	2026-08-24 12:04	2026-08-24 12:04	TOL	TOL260918C00150000	call	150.0000	2026-09-18	3.8400	3.8000	4.0000	147.3850	28005.00	10140.00	17865.00	73	14	94	886	0.106094808126411	0.318260250165516	0.318260250165516	false	false	false	true
6221b26a-8544-412a-8544-b6cade659085	2026-08-21 12:13	2026-08-21 12:13	2026-08-21 12:13	TOL	TOL260918C00150000	call	150.0000	2026-09-18	3.5000	3.5000	3.8000	146.0700	61610.00	0.00	61610.00	176	26	199	785	0.253503184713376	0.309654994769972	0.310291526979421	false	false	false	true
1cd9c7e1-d7e8-4c45-b0ce-b214ba819830	2026-08-20 11:18	2026-08-20 11:18	2026-08-20 11:18	TOL	TOL260918P00140000	put	140.0000	2026-09-18	2.7500	2.7500	3.1000	145.8900	38775.00	0.00	38775.00	141	27	150	196	0.76530612244898	0.331615577069328	0.331615577069328	false	false	false	true
d02aa49d-e9af-486b-b42c-7800fbd251a9	2026-08-19 14:53	2026-08-19 14:53	2026-08-19 14:53	TOL	TOL261218P00140000	put	140.0000	2026-12-18	7.1000	6.6000	7.6000	148.6000	12780.00	1420.00	11360.00	18	6	26	26	1	0.352034942834225	0.352034942834225	false	false	false	true
1667ac85-7415-4a78-b2cd-587ee3acdcbc	2026-08-19 14:32	2026-08-19 14:31	2026-08-19 14:31	TOL	TOL260918C00170000	call	170.0000	2026-09-18	1.0500	0.6000	1.0500	150.4700	21000.00	21000.00	0.00	200	23	218	362	0.602209944751381	0.363396551789595	0.363396551789595	false	false	false	true
4752d770-e3a6-4b1e-8c6f-f773257cbe1f	2026-08-19 10:48	2026-08-19 10:48	2026-08-19 10:48	TOL	TOL260918C00165000	call	165.0000	2026-09-18	1.8500	1.8000	2.1500	153.7900	11100.00	10915.00	185.00	60	5	375	700	0.535714285714286	0.311339372663684	0.311339372663684	false	false	false	true
31f9a6eb-6f35-4298-866f-275d2baae2b4	2026-08-19 10:39	2026-08-19 10:39	2026-08-19 10:39	TOL	TOL260918C00165000	call	165.0000	2026-09-18	1.8500	1.8000	1.9500	153.1700	10545.00	10360.00	185.00	57	7	202	700	0.288571428571429	0.322147192387694	0.322147192387694	false	false	false	true
1845da76-2528-4fc9-bbab-ced9f1db87ea	2026-08-19 10:38	2026-08-19 10:38	2026-08-19 10:38	TOL	TOL260918C00165000	call	165.0000	2026-09-18	1.8500	1.8000	1.9500	153.0400	11655.00	10175.00	1480.00	63	7	145	700	0.207142857142857	0.324405501484188	0.324405501484188	false	false	false	true
12630226-fb01-4ef7-b0dd-b65a3e9e6c6a	2026-08-18 15:40	2026-08-18 15:40	2026-08-18 15:40	TOL	TOL260821C00150000	call	150.0000	2026-08-21	1.1500	1.1000	1.2500	142.5900	69000.00	0.00	69000.00	600	2	975	227	4.29515418502203	0.705636950205895	0.705636950205895	false	true	true	false
e72f37f2-c06d-4225-8a84-12ee83e9b5d9	2026-08-18 14:54	2026-08-18 14:54	2026-08-18 14:54	TOL	TOL260821C00145000	call	145.0000	2026-08-21	2.7500	2.6000	2.7500	142.4950	17050.00	17050.00	0.00	62	5	236	59	4	0.741891116958625	0.741891116958625	false	false	false	true
b651b068-e4d1-439f-a13c-66f27b3eef0c	2026-08-18 13:50	2026-08-18 13:50	2026-08-18 13:50	TOL	TOL260821P00140000	put	140.0000	2026-08-21	2.9500	2.6500	3.1000	141.7850	11815.00	2950.00	8865.00	40	8	643	222	2.8963963963964	0.744878854723255	0.754878908991504	false	false	false	true
4f301615-ca06-4e12-b4b5-1ddcc624a80b	2026-08-18 13:48	2026-08-18 13:48	2026-08-18 13:48	TOL	TOL260821P00140000	put	140.0000	2026-08-21	2.8000	2.6000	2.8500	142.1400	12039.00	9239.00	2800.00	43	21	455	222	2.04954954954955	0.743512566770553	0.743512566770553	false	false	false	true
24e70530-868b-488e-a9a1-5e064debcdcb	2026-08-18 13:44	2026-08-18 13:44	2026-08-18 13:44	TOL	TOL260821P00140000	put	140.0000	2026-08-21	2.6500	2.4000	2.7000	142.3175	45315.00	45050.00	265.00	171	33	338	222	1.52252252252252	0.727265101931286	0.727265101931286	true	false	false	true