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:endpoint = /api/option-trades/flow-alerts×ticker = TMO×sorted by created_at ↑×

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

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	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Healthcare	226884329635.00	2026-10-28	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
37995fe5-5d84-49b0-bcba-6a65e8c79f2f	2026-09-01 13:03	2026-09-01 13:03	2026-09-01 13:03	TMO	TMO260918C00600000	call	600.0000	2026-09-18	15.3000	13.7000	15.3000	601.9200	78030.00	78030.00	0.00	51	22	173	868	0.199308755760369	0.266035160981332	0.266035160981332	false	false	false
9a0b6b2c-b1cc-4ded-b6ad-66a912eb23be	2026-09-03 11:26	2026-09-03 11:26	2026-09-03 11:26	TMO	TMO261120P00610000	put	610.0000	2026-11-20	32.9000	32.0000	32.9000	611.3850	151340.00	151340.00	0.00	46	19	46	9	5.11111111111111	0.321677477109634	0.321677477109634	false	false	false
6d3cd27e-7bfe-48d9-afaf-454b06d2f81b	2026-09-03 15:01	2026-09-03 15:01	2026-09-03 15:01	TMO	TMO270319P00570000	put	570.0000	2027-03-19	31.7500	30.9000	35.5000	615.4450	57150.00	3170.00	53980.00	18	5	24	11	2.18181818181818	0.325523890248939	0.322983851874899	false	false	false
054dd630-1b66-4a84-a5a3-1daec0742ab5	2026-09-03 15:25	2026-09-03 15:25	2026-09-03 15:25	TMO	TMO270115C00600000	call	600.0000	2027-01-15	58.3400	57.3000	59.4000	615.2300	58343.00	29168.00	17505.00	10	5	27	851	0.0317273795534665	0.314799442432086	0.314658921877951	false	false	false
5a67f4f0-d8b2-4367-ac37-236dd26940f6	2026-09-04 13:50	2026-09-04 13:50	2026-09-04 13:50	TMO	TMO260918C00600000	call	600.0000	2026-09-18	22.9000	18.1000	22.9000	613.1900	50380.00	50380.00	0.00	22	6	23	922	0.0249457700650759	0.312850330147333	0.312850330147333	false	false	false
2a2eda0c-a9f5-419d-bf82-9832d6d02266	2026-09-08 12:25	2026-09-08 12:24	2026-09-08 12:24	TMO	TMO261218P00640000	put	640.0000	2026-12-18	56.7000	55.0000	56.7000	606.4550	102060.00	102060.00	0.00	18	12	18	6	3	0.324398234674662	0.324398234674662	false	false	false	true
635cde52-1ca2-4e41-83c5-fbf0ebc70a45	2026-09-08 15:18	2026-09-08 15:18	2026-09-08 15:18	TMO	TMO260911P00602500	put	602.5000	2026-09-11	6.2400	5.0000	6.6000	604.9700	89276.00	89276.00	0.00	143	15	201	6	33.5	0.343724787071839	0.343724787071839	true	false	false	true
c465652c-8d11-4821-8689-4b5f7ceee2d6	2026-09-10 09:39	2026-09-10 09:39	2026-09-10 09:39	TMO	TMO261120C00560000	call	560.0000	2026-11-20	60.0000	60.0000	63.3000	599.4100	114000.00	0.00	114000.00	19	7	39	1	39	0.334575345110993	0.334575345110993	false	false	false
bc2d3a41-fcaf-4fba-9a17-5ba9add6bc47	2026-09-10 12:10	2026-09-10 12:10	2026-09-10 12:10	TMO	TMO270319P00610000	put	610.0000	2027-03-19	54.4600	53.3000	55.2000	601.3500	65350.00	49030.00	16320.00	12	5	16	6	2.66666666666667	0.329550282365889	0.328966003358239	false	false	false
74966192-740e-4729-be22-75608a13e1bb	2026-09-11 09:46	2026-09-11 09:46	2026-09-11 09:46	TMO	TMO261016C00620000	call	620.0000	2026-10-16	17.0000	14.6000	19.8000	608.6850	136000.00	13600.00	108800.00	80	6	80	90	0.888888888888889	0.279552548948617	0.279552548948617	false	false	false
5aab9298-38bf-449b-9594-70e39c69d58b	2026-09-15 10:53	2026-09-15 10:53	2026-09-15 10:53	TMO	TMO260925P00630000	put	630.0000	2026-09-25	11.3000	10.1000	11.3000	632.0000	57630.00	57630.00	0.00	51	19	52	1	52	0.31052865859135	0.31052865859135	false	false	false	true
7010b7b8-62c0-446c-8d0d-49187115498e	2026-09-16 10:01	2026-09-16 10:01	2026-09-16 10:01	TMO	TMO260925C00632500	call	632.5000	2026-09-25	18.7000	18.7000	19.9000	641.1200	93500.00	0.00	93500.00	50	8	50	2	25	0.332951648714187	0.34081051315284	false	false	false	true
9d8c191d-8f2e-4fa8-b8f2-435b5835d0b0	2026-09-16 11:24	2026-09-16 11:24	2026-09-16 11:24	TMO	TMO261016P00600000	put	600.0000	2026-10-16	5.6000	5.6000	6.4000	645.4550	66640.00	0.00	66640.00	119	26	122	44	2.77272727272727	0.302153664617093	0.302153664617093	false	false	false
f59ca346-f4ff-408a-9c32-dd412ea80ee6	2026-09-18 09:56	2026-09-18 09:56	2026-09-18 09:56	TMO	TMO260918C00645000	call	645.0000	2026-09-18	12.5000	11.4000	15.6000	656.5600	91250.00	1250.00	83750.00	73	10	74	184	0.402173913043478	0.666588104866741	0.666588104866741	false	false	false
581ee434-81bb-4e1c-a86a-702e018563bf	2026-09-18 12:02	2026-09-18 12:02	2026-09-18 12:02	TMO	TMO261120C00700000	call	700.0000	2026-11-20	17.8000	17.1000	18.4000	651.0000	55181.00	26700.00	28481.00	31	8	33	162	0.203703703703704	0.316999921822046	0.316999921822046	true	false	false
45396349-c3ce-4aa8-9389-a2dacd4a031e	2026-09-18 12:02	2026-09-18 12:02	2026-09-18 12:02	TMO	TMO261120C00700000	call	700.0000	2026-11-20	17.2900	17.2000	18.2000	651.0000	209250.00	38280.00	170970.00	121	47	236	162	1.45679012345679	0.314025580880183	0.311989487165004	false	false	false
bf827c3d-b122-4959-8772-705894c2e5be	2026-09-18 12:02	2026-09-18 12:02	2026-09-18 12:02	TMO	TMO261120C00700000	call	700.0000	2026-11-20	17.2000	17.1000	18.2000	651.0000	101480.00	27520.00	73960.00	59	20	295	162	1.82098765432099	0.311989487165004	0.312613800824468	false	false	false
0c70550b-5fd2-4a52-bd55-3851cee0de63	2026-09-18 12:37	2026-09-18 12:36	2026-09-18 12:36	TMO	TMO260918C00570000	call	570.0000	2026-09-18	82.5400	79.4000	85.6000	652.1650	231114.00	231114.00	0.00	28	10	28	194	0.144329896907216	3.42149786126455	3.42149786126455	false	false	false
7b7b9a94-e4f8-4466-8216-6451fb436a1a	2026-09-18 15:26	2026-09-18 15:26	2026-09-18 15:26	TMO	TMO260918C00630000	call	630.0000	2026-09-18	18.7000	18.7000	19.8000	648.5700	130900.00	0.00	127160.00	70	17	179	604	0.29635761589404	1.96123701027371	1.96123701027371	false	false	false
fb9d0501-1da3-4198-9620-eda7ee8bfcdd	2026-09-18 15:26	2026-09-18 15:26	2026-09-18 15:26	TMO	TMO260918C00630000	call	630.0000	2026-09-18	18.8000	18.8000	19.8000	648.5700	82720.00	0.00	18800.00	44	14	223	604	0.369205298013245	2.18610753772483	2.18610753772483	false	false	false
27c01b61-cbdc-4a47-a18c-beba4136774a	2026-09-21 10:04	2026-09-21 10:03	2026-09-21 10:03	TMO	TMO270115P00640000	put	640.0000	2027-01-15	34.7000	33.2000	36.4000	653.9300	38170.00	0.00	38170.00	11	5	12	110	0.109090909090909	0.312162192118024	0.312162192118024	false	false	false