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:ticker = TMO×

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

90c80c64-1954-445c-928e-6a6d63f44010	2026-08-28 12:01	2026-08-28 12:01	2026-08-28 12:01	TMO	TMO260904C00635000	call	635.0000	2026-09-04	3.7700	2.9500	7.0000	620.0000	57330.00	55480.00	1850.00	152	8	152	3	50.6666666666667	0.263541878340777	0.260058289113929	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Healthcare	226884329635.00	2026-10-28	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
878a58eb-448d-4154-827c-49a6fae1b278	2026-08-27 15:41	2026-08-27 15:41	2026-08-27 15:41	TMO	TMO260828P00630000	put	630.0000	2026-08-28	5.0000	1.3000	7.0000	631.2500	50000.00	30500.00	19500.00	100	13	100	269	0.371747211895911	0.430789535436526	0.42782348407296	false	false	false	true	false
ff1761ba-b06b-40a6-bb37-52f66d43c9af	2026-08-27 12:22	2026-08-27 12:22	2026-08-27 12:22	TMO	TMO261016C00650000	call	650.0000	2026-10-16	20.2000	19.3000	20.2000	634.0300	68680.00	68680.00	0.00	34	5	99	21	4.71428571428571	0.275267702748723	0.275267702748723	false	false	false	true	false
f62a4377-082d-4cbf-b4a4-1a49dfdbe259	2026-08-26 13:13	2026-08-26 13:13	2026-08-26 13:13	TMO	TMO261120P00670000	put	670.0000	2026-11-20	56.5000	55.1000	56.5000	634.0600	50850.00	50850.00	0.00	9	9	9	0	0	0.316984570187699	0.316984570187699	false	false	false	true	false
01139420-30a5-4816-bfc5-17d477fd75a0	2026-08-25 12:01	2026-08-25 12:01	2026-08-25 12:01	TMO	TMO260828C00640000	call	640.0000	2026-08-28	2.7500	1.9500	2.9500	626.1450	95420.00	48400.00	41245.00	347	37	347	30	11.5666666666667	0.342759181374416	0.337891730400732	false	false	false	true	false
55a6c5b0-b90c-455e-ab33-3db0377ff26c	2026-08-24 15:22	2026-08-24 15:22	2026-08-24 15:22	TMO	TMO260918C00630000	call	630.0000	2026-09-18	15.8000	15.5000	15.8000	625.2199	83740.00	83740.00	0.00	53	8	198	455	0.435164835164835	0.264805811685857	0.264805811685857	false	false	false	true	false
dd92c0a6-9a89-4717-b3da-744287bab158	2026-08-24 15:21	2026-08-24 15:21	2026-08-24 15:21	TMO	TMO260918C00630000	call	630.0000	2026-09-18	16.3000	16.0000	16.3000	625.8460	94540.00	94540.00	0.00	58	9	92	455	0.202197802197802	0.267784078745307	0.267784078745307	false	false	false	true	false
9c28c243-656c-47fd-a1a5-facf27204a73	2026-08-24 15:12	2026-08-24 15:12	2026-08-24 15:12	TMO	TMO260918C00650000	call	650.0000	2026-09-18	8.8000	8.1000	8.8000	625.3400	60720.00	60720.00	0.00	69	24	76	244	0.311475409836066	0.270832962736074	0.270832962736074	false	false	false	true	false
d383849f-6440-4cbb-aac2-1a99fff70abf	2026-08-21 14:18	2026-08-21 14:18	2026-08-21 14:18	TMO	TMO260821C00540000	call	540.0000	2026-08-21	86.0500	86.0000	86.9000	625.0000	68840.00	0.00	68840.00	8	8	432	571	0.756567425569177	5.81497501294091	5.96930373877854	false	false	false	true	false
e6fc645a-8bc1-4d64-aba0-d1c681ad2908	2026-08-21 14:18	2026-08-21 14:18	2026-08-21 14:18	TMO	TMO260821C00540000	call	540.0000	2026-08-21	85.9000	85.9000	86.9000	625.0000	498220.00	0.00	498220.00	58	10	421	571	0.737302977232925	6.08754730955037	6.08754730955037	false	false	false	true	false
3b49c7a9-e76b-4698-bd48-b8bf24348336	2026-08-21 14:18	2026-08-21 14:18	2026-08-21 14:18	TMO	TMO260821C00540000	call	540.0000	2026-08-21	85.8000	84.5000	86.9000	625.0000	77220.00	8580.00	68640.00	9	9	362	571	0.633975481611208	5.94309279166248	5.94358043621539	false	false	false	true	false
7f78238a-90bf-41d7-a87f-51fa7056a272	2026-08-21 14:18	2026-08-21 14:18	2026-08-21 14:18	TMO	TMO260821C00540000	call	540.0000	2026-08-21	85.7000	85.7000	86.9000	625.0000	51420.00	0.00	51420.00	6	6	353	571	0.618213660245184	5.78800078105769	5.78800078105769	false	false	false	true	false
a3584d3c-6559-40d0-945c-961fd3aee2d9	2026-08-21 14:18	2026-08-21 14:18	2026-08-21 14:18	TMO	TMO260821C00540000	call	540.0000	2026-08-21	85.5000	85.5000	86.9000	625.0000	153900.00	0.00	8550.00	18	18	230	571	0.402802101576182	5.42690818884584	5.42735354892034	false	false	false	true	false
3704297d-c476-4ea9-bd1b-f7f8f99fe743	2026-08-21 14:18	2026-08-21 14:18	2026-08-21 14:18	TMO	TMO260821C00540000	call	540.0000	2026-08-21	85.6000	85.6000	86.9000	625.0000	975840.00	0.00	8560.00	114	18	345	571	0.604203152364273	5.61748949049714	5.61748949049714	false	false	false	true	false
72cce3c0-0e91-408d-9bf7-10a270c241b2	2026-08-21 14:18	2026-08-21 14:18	2026-08-21 14:18	TMO	TMO260821C00540000	call	540.0000	2026-08-21	85.4000	84.3000	86.9000	624.0000	68320.00	0.00	68320.00	8	8	210	571	0.367775831873905	5.66508105271725	5.66508105271725	false	false	false	true	false
2f1c4284-21eb-4a94-bc20-42ea8d208662	2026-08-21 14:18	2026-08-21 14:18	2026-08-21 14:18	TMO	TMO260821C00540000	call	540.0000	2026-08-21	85.3000	85.3000	86.9000	624.0000	102360.00	0.00	17060.00	12	12	199	571	0.348511383537653	5.48306740932214	5.48306740932214	false	false	false	true	false
18f98e63-88b7-4fdf-bf07-9068256846de	2026-08-21 14:18	2026-08-21 14:18	2026-08-21 14:18	TMO	TMO260821C00540000	call	540.0000	2026-08-21	85.2000	85.2000	86.9000	624.0000	110760.00	0.00	8520.00	13	13	181	571	0.316987740805604	5.27594859192119	5.27594859192119	false	false	false	true	false
f8d667dc-f43a-4b9b-97d1-ff8f3563876b	2026-08-21 14:18	2026-08-21 14:18	2026-08-21 14:18	TMO	TMO260821C00540000	call	540.0000	2026-08-21	85.1000	85.1000	86.9000	624.0000	153180.00	0.00	8510.00	18	18	168	571	0.294220665499124	5.69715089291919	5.69715089291919	false	false	false	true	false
f7dc9a29-a73d-468b-939c-2bdc722bea23	2026-08-21 14:17	2026-08-21 14:17	2026-08-21 14:17	TMO	TMO260821C00540000	call	540.0000	2026-08-21	85.0000	85.0000	89.0000	624.0000	450500.00	0.00	8500.00	53	27	138	571	0.241681260945709	6.17918672378511	5.66521842764105	false	false	false	true	false
1f7023c5-9e51-4806-8bee-63303f00a5e6	2026-08-21 10:06	2026-08-21 10:06	2026-08-21 10:06	TMO	TMO260821C00540000	call	540.0000	2026-08-21	81.4000	79.8000	83.4000	621.8450	643060.00	0.00	643060.00	79	11	80	571	0.140105078809107	3.59777973289984	3.59777973289984	true	false	false	true	false
32ba4c67-3d4d-495c-9e80-abaf2e70b9cc	2026-08-20 14:21	2026-08-20 14:20	2026-08-20 14:20	TMO	TMO261016P00640000	put	640.0000	2026-10-16	32.9000	32.3000	33.0000	628.1126	62510.00	62510.00	0.00	19	18	157	63	2.49206349206349	0.287864616545766	0.287864616545766	true	false	false	true	false
e198afa4-2163-4baf-86c6-03712b2c8fc6	2026-08-20 13:14	2026-08-20 13:14	2026-08-20 13:14	TMO	TMO270917C00700000	call	700.0000	2027-09-17	65.0000	63.1000	67.4000	629.8700	988045.00	110500.00	877545.00	152	47	167	12	13.9166666666667	0.310079382338714	0.310717982509843	true	false	false	true	false
4c213a91-ce3b-44ab-a1b9-7ee6050574ec	2026-08-20 13:06	2026-08-20 13:06	2026-08-20 13:06	TMO	TMO280121C00690000	call	690.0000	2028-01-21	86.4000	85.5000	88.0000	631.0500	164160.00	25920.00	138240.00	19	11	70	12	5.83333333333333	0.315660602516637	0.315660602516637	false	false	false	true	false
984484a9-dc45-4ba7-81c5-c91f2df70e89	2026-08-20 11:57	2026-08-20 11:57	2026-08-20 11:57	TMO	TMO261120C00650000	call	650.0000	2026-11-20	34.5000	33.7000	34.5000	633.2350	138000.00	138000.00	0.00	40	7	46	12	3.83333333333333	0.309617867197692	0.309213020485466	true	false	false	true	false
1f59db7b-e497-417f-b73f-eeae9298d997	2026-08-20 11:56	2026-08-20 11:56	2026-08-20 11:56	TMO	TMO261016P00640000	put	640.0000	2026-10-16	30.0000	29.5000	30.0000	632.8875	54000.00	54000.00	0.00	18	18	45	63	0.714285714285714	0.28315307314508	0.28315307314508	false	false	false	true	false
66a70c9b-d41f-46d7-a868-6ec9fc7b1a26	2026-08-20 11:36	2026-08-20 11:36	2026-08-20 11:36	TMO	TMO261218C00680000	call	680.0000	2026-12-18	29.1000	28.1000	29.1000	632.6800	96030.00	96030.00	0.00	33	10	82	41	2	0.308078811122098	0.308078811122098	false	false	false	true	false
7a9163cc-7a81-4107-8fbe-394176571088	2026-08-20 11:22	2026-08-20 11:21	2026-08-20 11:21	TMO	TMO261016P00640000	put	640.0000	2026-10-16	30.6800	29.1000	31.2000	630.8900	61360.00	12270.00	0.00	20	20	21	63	0.333333333333333	0.279104147177093	0.280109776542032	false	false	false	true	false
d69f3c43-9f0e-49fa-b50f-7150f9a4f02f	2026-08-19 15:39	2026-08-19 15:39	2026-08-19 15:39	TMO	TMO261016P00640000	put	640.0000	2026-10-16	40.2100	38.1000	40.4000	612.5850	136700.00	52410.00	0.00	34	34	37	1	37	0.267930322359523	0.272220747319485	false	false	false	true	false
8670bfff-3df6-4522-b47f-0c8c964ba84a	2026-08-19 15:39	2026-08-19 15:39	2026-08-19 15:39	TMO	TMO261016P00640000	put	640.0000	2026-10-16	40.4900	40.3000	40.5000	612.6700	64790.00	12140.00	0.00	16	16	53	1	53	0.272780653061195	0.273851197716513	false	false	false	true	false