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×

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

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	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-09-01T14:20:18.853903Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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