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 = TER×

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

50272f07-65b2-47df-bd2a-fc859e8b054c	2026-09-22 15:27	2026-09-22 15:27	2026-09-22 15:27	TER	TER261023P00390000	put	390.0000	2026-10-23	26.4400	25.2000	29.8000	395.9000	264396.00	0.00	264396.00	100	5	101	0	0	0.664760369276904	0.664760369276904	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Technology	62331493618.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:27:59.988967Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
9b044163-5436-4977-9ad7-5b8aeeaeb5b3	2026-09-22 14:53	2026-09-22 14:53	2026-09-22 14:53	TER	TER261120P00390000	put	390.0000	2026-11-20	42.9000	42.4000	42.9000	394.6600	214500.00	214500.00	0.00	50	24	807	107	7.54205607476636	0.743010747558895	0.743010747558895	false	false	false	true	false
708cdbfb-4d57-4ba2-b9b6-d3ce70aec11e	2026-09-22 14:45	2026-09-22 14:45	2026-09-22 14:45	TER	TER261120P00390000	put	390.0000	2026-11-20	42.6100	42.5000	43.2000	395.6300	191750.00	0.00	191750.00	45	7	679	107	6.34579439252336	0.74627626215009	0.744661862265258	true	false	false	true	false
15cf6fce-2bf6-4f39-b2e8-193d66f279bb	2026-09-22 14:42	2026-09-22 14:42	2026-09-22 14:42	TER	TER261120P00390000	put	390.0000	2026-11-20	42.4000	42.4000	42.6000	395.6400	55120.00	0.00	55120.00	13	5	400	107	3.73831775700935	0.741499941188258	0.741499941188258	false	false	false	true	false
c25f52c3-8628-4d7a-ba84-748c5078eb03	2026-09-22 14:42	2026-09-22 14:42	2026-09-22 14:42	TER	TER261120P00310000	put	310.0000	2026-11-20	11.3800	10.8000	11.5000	395.7800	26170.00	13740.00	12430.00	23	9	27	612	0.0441176470588235	0.740438329677605	0.735274205834869	true	false	false	true	false
2e621f05-2cb0-402b-8c25-56ed1aa1b0fe	2026-09-22 14:42	2026-09-22 14:42	2026-09-22 14:42	TER	TER261120P00390000	put	390.0000	2026-11-20	42.2000	42.2000	42.8000	395.6700	130820.00	0.00	130820.00	31	10	356	107	3.32710280373832	0.738471682297458	0.738471682297458	false	false	false	true	false
40f75aee-c2f9-4806-b957-c2467f5a9305	2026-09-22 14:41	2026-09-22 14:41	2026-09-22 14:41	TER	TER261120P00390000	put	390.0000	2026-11-20	42.0600	42.0000	42.6000	396.1200	46270.00	0.00	46270.00	11	5	262	107	2.44859813084112	0.73985285322014	0.738239205994437	false	false	false	true	false
6eb837a5-331d-4947-852e-f40b8f2f815a	2026-09-22 14:41	2026-09-22 14:41	2026-09-22 14:41	TER	TER261120P00390000	put	390.0000	2026-11-20	42.0000	41.9000	42.7000	396.2900	117600.00	4200.00	113400.00	28	8	212	107	1.98130841121495	0.739102302654958	0.737754205277731	false	false	false	true	false
d8b930c1-079d-4d58-a44b-d916700f86ec	2026-09-22 13:34	2026-09-22 13:34	2026-09-22 13:34	TER	TER261002C00400000	call	400.0000	2026-10-02	14.3000	13.3000	14.3000	393.0000	286000.00	286000.00	0.00	200	5	434	461	0.941431670281996	0.65570246030643	0.65570246030643	false	false	false	true	false
461783bc-0a7e-4f75-82ff-6c376c3f2fb9	2026-09-22 12:20	2026-09-22 12:20	2026-09-22 12:20	TER	TER260925C00397500	call	397.5000	2026-09-25	7.7400	5.5000	8.1000	391.8100	36388.00	36388.00	0.00	47	6	47	3	15.6666666666667	0.702640251355742	0.702640251355742	false	false	false	true	false
b7fe5d48-789f-41db-b2a3-c29b63007329	2026-09-22 11:33	2026-09-22 11:33	2026-09-22 11:33	TER	TER261120P00360000	put	360.0000	2026-11-20	30.0000	29.4000	31.1000	387.0000	60000.00	48000.00	12000.00	20	5	22	202	0.108910891089109	0.730569228730126	0.730569228730126	false	false	false	true	false
70c5fce6-1fba-476c-b584-8a12d7429074	2026-09-21 15:37	2026-09-21 15:37	2026-09-21 15:37	TER	TER261120C00440000	call	440.0000	2026-11-20	26.0000	23.3000	27.1000	384.0000	13000.00	10400.00	2600.00	5	5	9	68	0.132352941176471	0.72425548215639	0.725354816771037	true	false	false	true	false
3009b82a-13c6-453d-b434-db3707698b18	2026-09-21 15:14	2026-09-21 15:14	2026-09-21 15:14	TER	TER261002C00345000	call	345.0000	2026-10-02	42.0000	37.5000	42.0000	382.3300	42000.00	42000.00	0.00	10	5	10	12	0.833333333333333	0.668332979963163	0.668332979963163	false	false	false	true	false
fc7c2856-b417-42b3-8170-a0de728469cb	2026-09-21 12:59	2026-09-21 12:59	2026-09-21 12:59	TER	TER280121C00500000	call	500.0000	2028-01-21	88.6600	85.0000	89.3000	379.8600	177320.00	177320.00	0.00	20	10	20	80	0.25	0.673989188912297	0.673989188912297	false	false	false	true	false
a8ce0921-edc8-4885-94c1-24094a1b665f	2026-09-21 11:51	2026-09-21 11:51	2026-09-21 11:51	TER	TER261016P00350000	put	350.0000	2026-10-16	12.5000	11.7000	12.5000	380.3300	282498.00	282498.00	0.00	226	34	285	440	0.647727272727273	0.660437212086662	0.660437212086662	false	false	false	true	false
9ec8652f-d101-4279-98f6-e98f0e3fc9a1	2026-09-21 11:51	2026-09-21 11:51	2026-09-21 11:51	TER	TER261016P00360000	put	360.0000	2026-10-16	16.2000	15.2000	16.2000	380.3300	301294.00	299684.00	1610.00	186	31	188	507	0.370808678500986	0.660302510639331	0.660302510639331	false	false	false	true	false
8190bbbc-6b14-4995-81c2-8047e7c8872c	2026-09-21 11:50	2026-09-21 11:50	2026-09-21 11:50	TER	TER270416P00320000	put	320.0000	2027-04-16	40.8700	40.4000	42.9000	381.4200	98092.00	0.00	98092.00	24	10	25	131	0.190839694656489	0.685807658335707	0.685807658335707	false	false	false	true	false
b76bb390-7f0a-4612-b9e6-86c4482d4c5a	2026-09-21 11:13	2026-09-21 11:12	2026-09-21 11:12	TER	TER270115C00400000	call	400.0000	2027-01-15	50.0000	48.9000	51.3000	378.0000	25000.00	20000.00	5000.00	5	5	5	244	0.0204918032786885	0.670476295490301	0.670476295490301	false	false	false	true	false
49a27c45-5615-4913-9f40-46d703e9dd2f	2026-09-21 11:04	2026-09-21 11:04	2026-09-21 11:04	TER	TER261016P00350000	put	350.0000	2026-10-16	13.2000	12.7000	13.2000	375.7700	66000.00	5280.00	0.00	50	6	52	440	0.118181818181818	0.642051323382721	0.642051323382721	false	false	false	true	false
208d5a7c-0a7c-4479-bf1b-f0e499624d6b	2026-09-21 10:41	2026-09-21 10:41	2026-09-21 10:41	TER	TER261120C00380000	call	380.0000	2026-11-20	42.5000	42.5000	44.0000	375.1000	21250.00	0.00	21250.00	5	5	6	97	0.0618556701030928	0.718059364723409	0.719977051216117	false	false	false	true	false
e7ad227d-9e81-4c29-addf-10664f2c0baf	2026-09-21 10:35	2026-09-21 10:35	2026-09-21 10:35	TER	TER270416P00310000	put	310.0000	2027-04-16	37.4200	36.8000	40.2000	375.3753	93540.00	0.00	93540.00	25	5	27	132	0.204545454545455	0.676050837911028	0.676050837911028	false	false	false	true	false
23a30e84-dee9-4fbb-90a6-906067398131	2026-09-21 10:08	2026-09-21 10:08	2026-09-21 10:08	TER	TER261016P00320000	put	320.0000	2026-10-16	6.1000	5.2000	6.2000	372.3400	43300.00	32330.00	600.00	71	18	92	524	0.175572519083969	0.662246279680185	0.662246279680185	false	false	false	true	false
60bf8bf9-b711-4292-803e-df0a79bf077c	2026-09-18 10:20	2026-09-18 10:20	2026-09-18 10:20	TER	TER260925C00372500	call	372.5000	2026-09-25	8.1000	6.7000	8.1000	361.4100	258390.00	258390.00	0.00	319	30	320	829	0.386007237635706	0.631026165249974	0.631026165249974	false	false	false	true	false
5f4c8212-20bb-4e7e-b9b1-373f6ef3495a	2026-09-17 15:49	2026-09-17 15:49	2026-09-17 15:49	TER	TER270115P00240000	put	240.0000	2027-01-15	8.7000	8.4000	9.0000	353.6900	140930.00	140070.00	860.00	162	35	165	111	1.48648648648649	0.678395909940374	0.675765975477417	false	false	false	true	false
a7c42ac8-08b5-4949-924e-97dfffdc4ae2	2026-09-17 09:36	2026-09-17 09:36	2026-09-17 09:36	TER	TER260918P00360000	put	360.0000	2026-09-18	9.4100	7.9000	10.0000	354.3500	79960.00	22560.00	57400.00	85	10	174	677	0.257016248153619	0.830659887409533	0.873473595743692	false	false	false	true	false
224bb78f-4eb5-4ea1-ab11-4c7a6030a917	2026-09-16 13:58	2026-09-16 13:58	2026-09-16 13:58	TER	TER260918C00360000	call	360.0000	2026-09-18	2.7000	1.9500	3.1000	344.0000	58571.00	58041.00	530.00	217	28	247	108	2.28703703703704	0.793809628164071	0.782624477198115	true	false	false	true	false
9a56bb67-9d3e-4b3e-b147-fe7d9fac0bf5	2026-09-16 13:03	2026-09-16 13:03	2026-09-16 13:03	TER	TER270115P00370000	put	370.0000	2027-01-15	64.2000	64.2000	65.2000	346.1500	179760.00	0.00	179760.00	28	7	33	72	0.458333333333333	0.669168656617151	0.669168656617151	false	false	false	true	false
902d0731-6b96-4d82-bd05-59bc94bef940	2026-09-16 11:11	2026-09-16 11:11	2026-09-16 11:11	TER	TER260925P00342500	put	342.5000	2026-09-25	12.5000	11.6000	12.5000	345.9800	105000.00	105000.00	0.00	84	22	84	1	84	0.664915469627135	0.664915469627135	false	false	false	true	false
8f819fa3-cd76-484c-aca1-94d58d3c60a1	2026-09-15 14:39	2026-09-15 14:39	2026-09-15 14:39	TER	TER270115C00390000	call	390.0000	2027-01-15	30.3000	30.3000	31.3000	327.4100	172710.00	0.00	172710.00	57	20	95	46	2.06521739130435	0.665043853531051	0.665043853531051	false	false	false	true	false
21b64f67-907d-49da-aae9-9680419a23ea	2026-09-15 13:39	2026-09-15 13:38	2026-09-15 13:38	TER	TER261030C00295000	call	295.0000	2026-10-30	51.0000	46.4000	51.0000	327.0800	153000.00	153000.00	0.00	30	8	33	0	0	0.72537683698763	0.72537683698763	false	false	false	true	false
5d145266-58c8-46d2-b0e9-e856e2dbac91	2026-09-15 12:34	2026-09-15 12:34	2026-09-15 12:34	TER	TER270115P00340000	put	340.0000	2027-01-15	54.4000	54.4000	55.8000	328.0000	701760.00	0.00	701760.00	129	28	129	100	1.29	0.669180554456892	0.669180554456892	false	false	false	true	false
c3732891-c141-4406-8a64-1888f0bbb33e	2026-09-15 11:41	2026-09-15 11:41	2026-09-15 11:41	TER	TER270115C00390000	call	390.0000	2027-01-15	31.6000	31.6000	33.0000	328.9200	113760.00	0.00	113760.00	36	16	36	46	0.782608695652174	0.674163430580498	0.674163430580498	false	false	false	true	false
f7bca2a8-c5a1-4bb6-a4bd-1ddb0616fcb6	2026-09-14 15:11	2026-09-14 15:11	2026-09-14 15:11	TER	TER261120C00410000	call	410.0000	2026-11-20	18.4000	18.4000	19.7000	335.9250	114080.00	0.00	114080.00	62	18	62	65	0.953846153846154	0.719095046578999	0.719095046578999	false	false	false	true	false
1521d041-1229-46cd-b255-9e5c88e0ac14	2026-09-14 14:00	2026-09-14 14:00	2026-09-14 14:00	TER	TER270115P00350000	put	350.0000	2027-01-15	58.4000	58.4000	59.8000	335.1500	338720.00	0.00	338720.00	58	12	361	381	0.94750656167979	0.675558290883621	0.675558290883621	false	false	false	true	false
20faf662-2d4e-4a20-bc86-bd1b642d0419	2026-09-14 12:58	2026-09-14 12:58	2026-09-14 12:58	TER	TER261023C00400000	call	400.0000	2026-10-23	9.5000	9.5000	11.9000	334.5000	133950.00	0.00	133950.00	141	31	144	16	9	0.666969537829681	0.666969537829681	false	false	false	true	false
efefb227-dfc6-4c1b-9c56-2e19eae84a4d	2026-09-14 10:50	2026-09-14 10:50	2026-09-14 10:50	TER	TER260918C00355000	call	355.0000	2026-09-18	4.7100	4.5000	6.0000	338.0000	64002.00	1960.00	62042.00	136	34	148	15	9.86666666666667	0.771628205223585	0.796374071652686	true	false	false	true	false
a2886d77-37b3-472c-92be-78f114181b7b	2026-09-14 09:53	2026-09-14 09:53	2026-09-14 09:53	TER	TER261016C00390000	call	390.0000	2026-10-16	11.0000	11.0000	13.2000	341.2400	151800.00	0.00	151800.00	138	26	138	311	0.443729903536977	0.666746312092342	0.667247561292339	false	false	false	true	false
054a297e-5933-41bb-bf05-84e494e566de	2026-09-10 14:31	2026-09-10 14:31	2026-09-10 14:31	TER	TER280121P00410000	put	410.0000	2028-01-21	129.5000	127.0000	129.5000	372.5600	116550.00	90650.00	0.00	9	7	9	6	1.5	0.714963034027182	0.714482291485348	true	false	false	true	false
e34d40f9-e881-4922-a777-1a2a1be2d9cc	2026-09-09 14:58	2026-09-09 14:58	2026-09-09 14:58	TER	TER261016C00390000	call	390.0000	2026-10-16	28.9000	28.9000	30.1000	380.8400	83810.00	0.00	83810.00	29	5	33	333	0.0990990990990991	0.667852043028879	0.667852043028879	false	false	false	true	false
22ba2c29-2f6d-422c-892b-a3c9ffb1722b	2026-09-09 13:53	2026-09-09 13:53	2026-09-09 13:53	TER	TER261120P00360000	put	360.0000	2026-11-20	37.1000	37.1000	38.2000	380.8100	356170.00	3720.00	352450.00	96	29	165	117	1.41025641025641	0.73732156687285	0.73732156687285	false	false	false	true	false
fe7173ac-1ff9-4016-927d-23564d2bd62d	2026-09-09 13:13	2026-09-09 13:13	2026-09-09 13:13	TER	TER261016P00340000	put	340.0000	2026-10-16	13.9700	13.8000	14.2000	380.0000	75423.00	43450.00	30583.00	54	22	58	211	0.274881516587678	0.667989424715321	0.667989424715321	false	false	false	true	false
e5486ad5-ba41-49af-aebd-6b925d7bc4d1	2026-09-09 13:13	2026-09-09 13:13	2026-09-09 13:13	TER	TER261120P00310000	put	310.0000	2026-11-20	17.5000	17.3000	17.8000	380.0000	75250.00	3500.00	71750.00	43	12	43	611	0.0703764320785597	0.7426494739285	0.7426494739285	false	false	false	true	false
545f5977-c4f0-4014-a5fa-a33f9233c1c5	2026-09-09 13:13	2026-09-09 13:13	2026-09-09 13:13	TER	TER261120P00320000	put	320.0000	2026-11-20	21.0000	21.0000	21.3000	380.0000	81904.00	0.00	81904.00	39	18	48	77	0.623376623376623	0.746512041541237	0.746512041541237	false	false	false	true	false
53fad7a2-2f65-4b27-8a1e-2d3ddb5a810f	2026-09-09 13:13	2026-09-09 13:13	2026-09-09 13:13	TER	TER261016P00350000	put	350.0000	2026-10-16	17.5100	17.4000	17.8000	380.0000	92815.00	5310.00	87505.00	53	14	57	256	0.22265625	0.66984950058653	0.66984950058653	false	false	false	true	false
c8cd888b-126e-4ab7-b83b-9388cf05f52e	2026-09-09 12:45	2026-09-09 12:45	2026-09-09 12:45	TER	TER270115C00420000	call	420.0000	2027-01-15	50.6800	50.6000	51.1000	380.6100	60810.00	0.00	60810.00	12	6	15	124	0.120967741935484	0.711031115934323	0.708806781571777	false	false	false	true	false
597f18f2-d7cd-4a15-bb42-2ab2407ddbb0	2026-09-08 13:00	2026-09-08 13:00	2026-09-08 13:00	TER	TER261120P00350000	put	350.0000	2026-11-20	36.0000	36.0000	37.6000	373.3050	176400.00	0.00	176400.00	49	15	55	51	1.07843137254902	0.748895010223113	0.748895010223113	false	false	false	true	false
37e53cf9-5967-4daf-a6fc-5c353d03677b	2026-09-08 12:28	2026-09-08 12:28	2026-09-08 12:28	TER	TER280121C00400000	call	400.0000	2028-01-21	119.8600	117.0000	120.0000	372.9300	167810.00	167810.00	0.00	14	6	15	54	0.277777777777778	0.715189095649295	0.715189095649295	false	false	false	true	false
b93c1002-5159-4257-a55f-95989756a399	2026-09-08 11:18	2026-09-08 11:18	2026-09-08 11:18	TER	TER261120C00600000	call	600.0000	2026-11-20	7.3000	5.9000	7.3000	375.9400	286890.00	286890.00	0.00	393	50	393	252	1.55952380952381	0.784066601582392	0.784066601582392	false	false	false	true	false
668c072f-ce35-48e5-ac06-a9c053a1442f	2026-09-08 11:12	2026-09-08 11:12	2026-09-08 11:12	TER	TER270115C00460000	call	460.0000	2027-01-15	36.8600	36.6000	36.9000	375.8699	51600.00	44280.00	7320.00	14	6	14	122	0.114754098360656	0.70766727953187	0.704205349544413	false	false	false	true	false
65065c79-aa7f-4363-8f2b-546099880c74	2026-09-08 11:12	2026-09-08 11:12	2026-09-08 11:12	TER	TER270115C00520000	call	520.0000	2027-01-15	24.5000	24.2000	24.5000	375.8699	88196.00	88196.00	0.00	36	14	37	247	0.149797570850202	0.708757202479425	0.708757202479425	false	false	false	true	false