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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = TER×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	expirydate

ddfa7c11-466f-4fcf-a477-52192292e96a	2026-08-17 12:09	2026-08-17 12:09	2026-08-17 12:09	TER	TER261016C00440000	call	440.0000	2026-10-16	50.0000	50.0000	51.6000	435.1650	160000.00	0.00	160000.00	32	8	42	53	0.792452830188679	0.725970286159379	0.725970286159379	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	51467374900.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
aec01f03-3b86-4970-9a50-1300275c6199	2026-08-17 13:46	2026-08-17 13:46	2026-08-17 13:46	TER	TER280121P00420000	put	420.0000	2028-01-21	134.2000	133.0000	139.8000	439.0000	295240.00	0.00	295240.00	22	8	203	8	25.375	0.81012174293498	0.81012174293498	false	false	false	true
89c7b1ea-b5ad-464a-a9a0-48473d11e410	2026-08-18 10:52	2026-08-18 10:52	2026-08-18 10:52	TER	TER270115C00600000	call	600.0000	2027-01-15	30.0100	30.0000	33.9000	400.2000	63020.00	0.00	63020.00	21	8	22	368	0.0597826086956522	0.781719944737003	0.782841009577301	false	false	false	true
2721d21f-ef07-46ba-af10-bab8efddee24	2026-08-18 11:57	2026-08-18 11:57	2026-08-18 11:57	TER	TER261002C00400000	call	400.0000	2026-10-02	43.7000	41.1000	43.7000	402.7700	52440.00	52440.00	0.00	12	12	14	0	0	0.738946090612259	0.738946090612259	false	false	false	true
ec10bb04-5d08-4caa-9122-d5fcd488d7a5	2026-08-18 14:42	2026-08-18 14:42	2026-08-18 14:42	TER	TER270115C00500000	call	500.0000	2027-01-15	49.0600	45.7000	49.2000	398.6132	142270.00	78440.00	63830.00	29	5	46	371	0.123989218328841	0.783817719552116	0.783817719552116	true	false	false	true
a9b4f878-8b8a-486d-aa1f-001071173ef5	2026-08-19 10:10	2026-08-19 10:10	2026-08-19 10:10	TER	TER260918C00440000	call	440.0000	2026-09-18	12.0100	11.7000	12.8000	377.4950	140480.00	6080.00	134400.00	117	31	130	181	0.718232044198895	0.736149986468184	0.747239328272119	true	false	false	true
ed24a69a-ced8-484d-80db-f38c4f4f5f0e	2026-08-19 13:42	2026-08-19 13:42	2026-08-19 13:42	TER	TER261120P00340000	put	340.0000	2026-11-20	39.0000	39.0000	40.7000	377.9700	74100.00	0.00	74100.00	19	15	26	282	0.0921985815602837	0.802734994774479	0.802734994774479	false	false	false	true
22d63f37-6fc0-41d1-9580-fc2fdd61ca16	2026-08-19 14:27	2026-08-19 14:26	2026-08-19 14:26	TER	TER270115P00330000	put	330.0000	2027-01-15	45.8000	42.9000	47.5000	375.9700	192360.00	9160.00	183200.00	42	15	54	277	0.194945848375451	0.774989158471315	0.774989158471315	false	false	false	true
029fdafc-7d64-48b5-9e85-2990af3fbe40	2026-08-19 15:41	2026-08-19 15:41	2026-08-19 15:41	TER	TER261120P00370000	put	370.0000	2026-11-20	52.8000	52.8000	54.1000	378.7100	137280.00	0.00	137280.00	26	10	27	92	0.293478260869565	0.788627730386134	0.788627730386134	false	false	false	true
7c192472-d1a9-4691-b216-2ca6f7ef0f6e	2026-08-20 10:38	2026-08-20 10:38	2026-08-20 10:38	TER	TER280121P00250000	put	250.0000	2028-01-21	53.2000	52.0000	56.7000	381.9600	69160.00	63840.00	5320.00	13	5	13	72	0.180555555555556	0.803064949791627	0.803064949791627	false	false	false	true
6a1c1d9f-6d1c-437a-aa06-7986b79c1b80	2026-08-20 15:17	2026-08-20 15:17	2026-08-20 15:17	TER	TER260918P00420000	put	420.0000	2026-09-18	54.3000	54.3000	57.7000	381.7300	65160.00	0.00	54300.00	12	12	12	91	0.131868131868132	0.723757017254038	0.723757017254038	false	false	false	true
ead97580-f326-4b9c-8369-ee1ea0af8f09	2026-08-21 14:28	2026-08-21 14:28	2026-08-21 14:28	TER	TER260904P00362500	put	362.5000	2026-09-04	13.8000	13.8000	15.0000	376.2100	56580.00	0.00	56580.00	41	8	63	0	0	0.698417218614283	0.698417218614283	false	false	false	true
c2e246d4-7a80-462a-bc14-0860f0f9a9fd	2026-08-21 14:44	2026-08-21 14:44	2026-08-21 14:44	TER	TER260918P00420000	put	420.0000	2026-09-18	56.8000	54.4000	58.6000	375.5600	85200.00	5680.00	5680.00	15	15	16	106	0.150943396226415	0.695252757070282	0.695252757070282	false	false	false	true
68a52960-c222-4491-b90b-5bc435a58919	2026-08-21 14:45	2026-08-21 14:45	2026-08-21 14:45	TER	TER260821P00420000	put	420.0000	2026-08-21	44.5000	42.0000	45.2000	375.5900	80100.00	80100.00	0.00	18	18	38	113	0.336283185840708	4.23095078514152	4.23095078514152	false	false	false	true
37ff4280-dde6-4a72-8416-7c72d46967b6	2026-08-21 14:45	2026-08-21 14:45	2026-08-21 14:45	TER	TER260821P00420000	put	420.0000	2026-08-21	44.2000	42.3000	44.7000	375.5500	57460.00	8840.00	17680.00	13	13	60	113	0.530973451327434	0.654164230829304	4.93058391858474	false	false	false	true
c089205b-7413-4bdd-bda7-b9e1f526c96a	2026-08-21 14:45	2026-08-21 14:45	2026-08-21 14:45	TER	TER260821P00420000	put	420.0000	2026-08-21	44.2000	42.6000	44.2000	375.6600	57460.00	57460.00	0.00	13	13	73	113	0.646017699115044	0.654164230829304	0.654164230829304	false	false	false	true
cae292c6-b410-4301-9a5c-ab62d6abb862	2026-08-21 14:45	2026-08-21 14:45	2026-08-21 14:45	TER	TER260821P00420000	put	420.0000	2026-08-21	44.1000	42.8000	44.6000	375.6600	61740.00	8820.00	4410.00	14	14	88	113	0.778761061946903	0.654164230829304	4.95535524883766	false	false	false	true
7f91b3c8-5558-450e-894c-efd55e8ba57f	2026-08-21 14:46	2026-08-21 14:45	2026-08-21 14:45	TER	TER260821P00420000	put	420.0000	2026-08-21	44.2000	43.0000	48.2000	375.7250	57460.00	53040.00	4420.00	13	13	101	113	0.893805309734513	0.654164230829304	0.654164230829304	false	false	false	true
9113ceb0-9f61-4a52-b375-3793d64db44e	2026-08-25 10:53	2026-08-25 10:53	2026-08-25 10:53	TER	TER260925C00420000	call	420.0000	2026-09-25	13.3000	12.0000	13.3000	367.2600	131670.00	131670.00	0.00	99	10	99	3	33	0.721449299108421	0.719953066509727	false	false	false	true
cf1e58e8-5aa4-4c32-9024-f829c28e0c8b	2026-08-25 13:38	2026-08-25 13:38	2026-08-25 13:38	TER	TER270115P00310000	put	310.0000	2027-01-15	36.3000	36.2000	36.5000	367.0300	58080.00	21780.00	18150.00	16	16	35	142	0.246478873239437	0.752344047152331	0.752344047152331	false	false	false	true
3b432333-d31f-43bb-8aea-b477a051d436	2026-08-28 11:28	2026-08-28 11:28	2026-08-28 11:28	TER	TER261120C00360000	call	360.0000	2026-11-20	53.6000	52.5000	55.0000	363.0800	69680.00	64320.00	5360.00	13	13	19	113	0.168141592920354	0.735637849989246	0.735637849989246	false	false	false	true
81ee44d5-93cd-4814-866a-31d061b0dcde	2026-08-31 11:12	2026-08-31 11:11	2026-08-31 11:11	TER	TER270416C00510000	call	510.0000	2027-04-16	37.7100	37.7000	43.0000	351.8500	75410.00	0.00	75410.00	20	10	20	0	0	0.709158145296233	0.710111620712216	false	false	false	true
211331fe-1012-4c08-b451-5ff196466c46	2026-08-31 11:12	2026-08-31 11:12	2026-08-31 11:12	TER	TER280121C00640000	call	640.0000	2028-01-21	59.9000	59.9000	65.0000	352.0600	83860.00	0.00	83860.00	14	5	17	47	0.361702127659574	0.722051457767042	0.722051457767042	false	false	false	true
e8fe559e-517d-4c1a-90f4-81cf0bf476c9	2026-08-31 11:59	2026-08-31 11:59	2026-08-31 11:59	TER	TER280121C00580000	call	580.0000	2028-01-21	66.8100	66.8000	73.0000	350.8350	106890.00	0.00	106890.00	16	8	16	8	2	0.712899300570123	0.713508269559797	false	false	false	true
14c7a247-94af-48db-82a6-2cd4aa24d0d6	2026-09-01 10:12	2026-09-01 10:11	2026-09-01 10:11	TER	TER260911C00355000	call	355.0000	2026-09-11	4.8000	4.4000	5.7000	330.0600	120950.00	14390.00	106560.00	252	43	255	5	51	0.605064053608387	0.596182962334476	false	false	false	true
5bb49b15-84af-478e-99f7-2f4dcc20fc74	2026-09-02 11:15	2026-09-02 11:15	2026-09-02 11:15	TER	TER261120P00260000	put	260.0000	2026-11-20	11.0000	9.9000	11.0000	342.6200	124300.00	124300.00	0.00	113	28	115	198	0.580808080808081	0.723337011383504	0.723337011383504	false	false	false	true
3053c1c5-1408-4ed8-8e47-e3976eea1759	2026-09-04 09:43	2026-09-04 09:43	2026-09-04 09:43	TER	TER261016C00380000	call	380.0000	2026-10-16	19.4000	18.5000	19.8000	353.0400	337600.00	333680.00	3920.00	174	34	176	167	1.05389221556886	0.615102134294473	0.619395906043731	true	false	false	true
c4c28ae9-a4fd-4621-bec3-eb9ad72138ba	2026-09-04 11:59	2026-09-04 11:58	2026-09-04 11:58	TER	TER261120C00500000	call	500.0000	2026-11-20	11.0000	11.0000	12.0000	355.0700	220000.00	0.00	220000.00	200	8	202	315	0.641269841269841	0.714720908132844	0.714720908132844	true	false	false	true
f94b6aab-0536-46d3-b552-6444c9527599	2026-09-04 15:44	2026-09-04 15:44	2026-09-04 15:44	TER	TER261120C00600000	call	600.0000	2026-11-20	4.6000	3.6000	4.6000	357.4050	94300.00	94300.00	0.00	205	33	206	357	0.57703081232493	0.742018546813148	0.742018546813148	false	false	false	true
9f948a80-db83-487c-a753-ff06997e44e6	2026-09-08 09:37	2026-09-08 09:36	2026-09-08 09:36	TER	TER260918C00405000	call	405.0000	2026-09-18	7.0000	4.2000	7.0000	373.9600	81900.00	81900.00	0.00	117	32	117	4	29.25	0.716492759764869	0.716492759764869	false	false	false	true
d28ae7e1-5e44-46a0-87c5-9032ab4bf590	2026-09-08 11:12	2026-09-08 11:12	2026-09-08 11:12	TER	TER260918P00360000	put	360.0000	2026-09-18	9.8000	9.1000	9.8000	375.4600	58800.00	11760.00	0.00	60	6	61	654	0.0932721712538226	0.681300641165792	0.681300641165792	false	false	false	true
3793768f-c867-46df-ad59-4fdbe1c676f8	2026-09-08 11:12	2026-09-08 11:12	2026-09-08 11:12	TER	TER270115C00540000	call	540.0000	2027-01-15	21.4000	21.1000	21.4000	375.8699	201130.00	199020.00	2110.00	94	25	94	250	0.376	0.709642791310652	0.70557052853733	false	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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