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:endpoint = /api/option-trades/flow-alerts×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	expiry

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
18255f74-baff-4ad4-a578-306b6c031592	2026-08-17 13:14	2026-08-17 13:14	2026-08-17 13:14	TER	TER260911C00480000	call	480.0000	2026-09-11	16.8400	14.1000	16.9000	435.6850	52190.00	43890.00	8300.00	31	8	36	3	12	0.718181213035956	0.711006254560401	true	false	false
3862ba76-dad0-4de0-b3b5-23b1cf68ec7b	2026-08-17 13:18	2026-08-17 13:18	2026-08-17 13:18	TER	TER271217P00160000	put	160.0000	2027-12-17	15.2500	15.2000	18.4000	436.1100	65560.00	7750.00	57810.00	43	8	44	16	2.75	0.82372625118879	0.828977281158489	false	false	false
257fd362-7a1c-48ac-9bc9-36294390192a	2026-08-17 13:19	2026-08-17 13:19	2026-08-17 13:19	TER	TER270115C00600000	call	600.0000	2027-01-15	41.0000	38.2000	41.0000	436.7450	418189.00	418189.00	0.00	102	7	203	220	0.922727272727273	0.768454190299637	0.768358902568825	false	false	false
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
c15bf518-61c1-4971-af9b-bfe1f07c6875	2026-08-17 13:46	2026-08-17 13:46	2026-08-17 13:46	TER	TER261016C00450000	call	450.0000	2026-10-16	48.9200	44.0000	49.6000	440.0000	58700.00	29360.00	29340.00	12	6	18	142	0.126760563380282	0.73531086904854	0.733064678730189	true	false	false
5fba1237-baa8-4323-9703-4abfec3224a4	2026-08-18 09:44	2026-08-18 09:44	2026-08-18 09:44	TER	TER261016P00390000	put	390.0000	2026-10-16	36.3700	31.0000	37.3000	412.0000	83660.00	76400.00	7260.00	23	8	23	271	0.0848708487084871	0.745787414256779	0.745437775649247	true	false	false
05fba9e5-9297-4a4d-b133-7457935fdc0e	2026-08-18 09:57	2026-08-18 09:57	2026-08-18 09:57	TER	TER261120C00380000	call	380.0000	2026-11-20	82.6300	77.6000	82.8000	409.2000	289200.00	240060.00	49140.00	35	7	39	45	0.866666666666667	0.82371833266826	0.811901851113408	false	false	false
ea92db13-4cb4-459e-967f-3ad8081d1410	2026-08-18 09:58	2026-08-18 09:58	2026-08-18 09:58	TER	TER261120C00380000	call	380.0000	2026-11-20	80.8100	78.2000	82.0000	408.7900	226260.00	48720.00	177540.00	28	12	68	45	1.51111111111111	0.806256877976385	0.806256877976385	false	false	false
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
babf7091-7be2-4bf6-891b-69a8e09ae3a1	2026-08-18 10:57	2026-08-18 10:57	2026-08-18 10:57	TER	TER260821C00400000	call	400.0000	2026-08-21	13.9600	10.7000	16.0000	400.2900	138162.00	138162.00	0.00	99	7	113	413	0.273607748184019	1.09178229989073	0.854494625886021	false	false	false
cddefcd9-b40d-444e-9f2d-3b4fe9955333	2026-08-18 11:56	2026-08-18 11:56	2026-08-18 11:56	TER	TER261016C00460000	call	460.0000	2026-10-16	28.9000	26.0000	29.1000	403.1800	89580.00	66620.00	22960.00	31	8	47	104	0.451923076923077	0.752237337678329	0.74628984479595	false	false	false
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
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
6feab431-d160-47c3-9cca-461a6dc56163	2026-08-19 09:51	2026-08-19 09:51	2026-08-19 09:51	TER	TER261016P00350000	put	350.0000	2026-10-16	28.0400	23.0000	28.3000	381.5400	98150.00	70150.00	28000.00	35	5	35	210	0.166666666666667	0.745237338920209	0.740042158584109	false	false	false
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
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
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
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
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
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
a47e49b5-8f30-4da7-bea2-47c54515d122	2026-08-21 12:09	2026-08-21 12:09	2026-08-21 12:09	TER	TER261016C00560000	call	560.0000	2026-10-16	4.6000	3.9000	7.0000	368.8250	51510.00	50140.00	1370.00	112	7	114	300	0.38	0.7366969788388	0.741309299799776	false	false	false
88a085cb-6787-4b33-a153-063760c470a0	2026-08-21 12:17	2026-08-21 12:17	2026-08-21 12:17	TER	TER260918P00300000	put	300.0000	2026-09-18	4.7100	4.4000	5.0000	370.4950	61250.00	10810.00	50440.00	130	8	157	239	0.656903765690377	0.715679477293091	0.717145388343918	false	false	false
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
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
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
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
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
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
ecf6acba-233f-4a8e-928c-b05419def7ec	2026-08-24 09:59	2026-08-24 09:59	2026-08-24 09:59	TER	TER270115C00450000	call	450.0000	2027-01-15	38.9200	37.1000	42.3000	353.6750	73947.00	0.00	73947.00	19	10	23	253	0.0909090909090909	0.767813283338418	0.767813283338418	false	false	false
e74cbeaf-0e18-43a6-8495-b999016b595e	2026-08-24 12:14	2026-08-24 12:14	2026-08-24 12:14	TER	TER271217P00260000	put	260.0000	2027-12-17	56.5300	56.3000	61.8000	363.5900	130030.00	0.00	130030.00	23	9	23	43	0.534883720930233	0.787449111281695	0.790704442396705	false	false	false
14d30bb5-3a36-4d95-9184-e74bf622312e	2026-08-25 10:23	2026-08-25 10:23	2026-08-25 10:23	TER	TER260918P00300000	put	300.0000	2026-09-18	4.9000	4.4000	5.1000	361.6200	75939.00	75939.00	0.00	155	28	156	389	0.401028277634961	0.724651593789333	0.724651593789333	false	false	false
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
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
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
453c3357-3c96-43c2-9c30-92000ea986fb	2026-08-28 12:49	2026-08-28 12:49	2026-08-28 12:49	TER	TER261016P00330000	put	330.0000	2026-10-16	19.1400	18.9000	20.7000	358.6300	72721.00	21150.00	51571.00	38	9	286	228	1.25438596491228	0.639214501602879	0.639214501602879	true	false	false
bed80300-b713-4355-97ed-2e3c0ea0d5c7	2026-08-31 09:59	2026-08-31 09:59	2026-08-31 09:59	TER	TER280121C00360000	call	360.0000	2028-01-21	125.3900	123.6000	126.1000	357.1000	263310.00	238270.00	25040.00	21	5	40	32	1.25	0.732214060368946	0.728856935747534	false	false	false
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
7d82c8e8-769f-45ca-8ac7-f2de1ec11ecc	2026-08-31 11:12	2026-08-31 11:12	2026-08-31 11:12	TER	TER270416C00520000	call	520.0000	2027-04-16	35.7300	35.2000	41.0000	352.0400	135760.00	32230.00	103530.00	38	7	38	0	0	0.706173855323654	0.703273926267176	true	false	false
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
75d5dcff-5870-4604-8457-630d0eeee7be	2026-08-31 11:56	2026-08-31 11:55	2026-08-31 11:55	TER	TER270416C00540000	call	540.0000	2027-04-16	31.5300	31.5000	35.1000	351.0000	69360.00	3200.00	66160.00	22	13	22	0	0	0.700171172111704	0.705173417174711	false	false	false
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
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
8376316a-8627-4e23-9344-0f50c74465c1	2026-09-01 13:01	2026-09-01 13:01	2026-09-01 13:01	TER	TER260918P00280000	put	280.0000	2026-09-18	2.1000	1.5000	2.1000	333.2700	85675.00	85675.00	0.00	408	47	420	206	2.03883495145631	0.646411387224918	0.646411387224918	false	false	false
5bf9c56e-421f-461a-b2ca-16702183c01a	2026-09-02 11:06	2026-09-02 11:06	2026-09-02 11:06	TER	TER270416C00520000	call	520.0000	2027-04-16	30.1400	26.2000	30.5000	342.3100	87400.00	87400.00	0.00	29	9	29	21	1.38095238095238	0.684386376937259	0.684386376937259	false	false	false
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
fdfa341f-abf3-4fb0-88d3-dd2bb1057bd2	2026-09-02 11:38	2026-09-02 11:38	2026-09-02 11:38	TER	TER270416C00520000	call	520.0000	2027-04-16	31.5700	30.5000	31.7000	344.8550	63139.00	9419.00	28440.00	20	5	70	21	3.33333333333333	0.691017124518431	0.693148847196843	true	false	false
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
0e67682d-d7f9-403f-8384-f090b7ca2e73	2026-09-04 09:58	2026-09-04 09:58	2026-09-04 09:58	TER	TER261016C00380000	call	380.0000	2026-10-16	21.6100	18.8000	22.2000	358.3450	64822.00	64822.00	0.00	30	8	250	167	1.49700598802395	0.613205604172929	0.613205604172929	false	false	false