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 = FRO×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	price

65273dac-80e8-4416-b593-602dd9555054	2026-08-17 11:33	2026-08-17 11:33	2026-08-17 11:33	FRO	FRO261120P00029000	put	29.0000	2026-11-20	0.6000	0.3500	0.6000	42.3100	30540.00	30540.00	0.00	509	41	509	3041	0.16737915159487	0.625678154903676	0.625678154903676	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	11246908352.00	2026-11-20	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
7923edcd-6e34-4e57-b955-91ccad87a14b	2026-08-17 11:39	2026-08-17 11:38	2026-08-17 11:38	FRO	FRO260918P00036000	put	36.0000	2026-09-18	0.7500	0.5500	0.9000	42.1700	11246.00	10721.00	375.00	150	37	317	598	0.530100334448161	0.62361950059442	0.622552213787009	false	false	false	true	false
a752ac91-2abb-4640-81b0-c07efa192c2c	2026-08-17 13:27	2026-08-17 13:27	2026-08-17 13:27	FRO	FRO270115C00050000	call	50.0000	2027-01-15	1.7500	1.6000	1.8000	42.3900	19250.00	16800.00	0.00	110	21	151	1204	0.125415282392027	0.369744567701174	0.369744567701174	false	false	false	true	false
db6912d2-c8ae-4310-82a4-7d44edc95af0	2026-08-17 13:27	2026-08-17 13:27	2026-08-17 13:27	FRO	FRO270115C00050000	call	50.0000	2027-01-15	1.7500	1.7000	1.8000	42.3900	10150.00	9975.00	0.00	58	14	291	1204	0.241694352159468	0.369744567701174	0.369744567701174	false	false	false	true	false
477700a2-4ae1-4ed2-bf27-31f950a6ff1e	2026-08-17 14:40	2026-08-17 14:40	2026-08-17 14:40	FRO	FRO261120C00055000	call	55.0000	2026-11-20	0.7000	0.6000	0.7500	42.4250	16310.00	630.00	15680.00	233	16	1054	9607	0.109711668574997	0.43602986258812	0.43602986258812	false	false	false	true	false
758626da-0bc8-4cf4-99a8-86aec091fad4	2026-08-17 15:28	2026-08-17 15:28	2026-08-17 15:28	FRO	FRO261120C00042000	call	42.0000	2026-11-20	3.4000	3.4000	3.7000	42.4100	10200.00	0.00	10200.00	30	5	36	506	0.0711462450592885	0.347423170579002	0.347423170579002	false	false	false	true	false
ba9b8249-60e0-4b9b-9cd8-77f66c5a1f1a	2026-08-18 09:42	2026-08-18 09:42	2026-08-18 09:42	FRO	FRO261120C00055000	call	55.0000	2026-11-20	0.7000	0.7000	0.8000	42.0000	38991.00	0.00	38991.00	557	23	580	8567	0.067701645850356	0.440102025161315	0.440102025161315	false	false	false	true	false
3e64f340-64ef-40f3-9ba3-e2df02922062	2026-08-18 10:45	2026-08-18 10:44	2026-08-18 10:44	FRO	FRO270115C00045000	call	45.0000	2027-01-15	3.4000	2.7500	3.4000	42.7599	10200.00	10200.00	0.00	30	12	60	1218	0.0492610837438424	0.370501908554132	0.370501908554132	false	false	false	true	false
3de5fc2d-fd81-468e-acfd-ab1ad0eb40c4	2026-08-18 11:15	2026-08-18 11:15	2026-08-18 11:15	FRO	FRO261120C00045000	call	45.0000	2026-11-20	2.2500	2.2000	2.6000	42.5000	13725.00	9225.00	4500.00	61	5	64	1443	0.0443520443520444	0.360382829171036	0.360382829171036	false	false	false	true	false
e905a73d-1a6d-47f7-8bcb-3029edc8de72	2026-08-18 11:30	2026-08-18 11:29	2026-08-18 11:29	FRO	FRO280121P00015000	put	15.0000	2028-01-21	1.0500	1.0500	2.9500	42.5500	26250.00	0.00	26250.00	250	21	484	39	12.4102564102564	0.743549140446977	0.743549140446977	false	false	false	true	false
7a5f588a-5149-45e1-92cb-1b2d6b04b656	2026-08-18 11:38	2026-08-18 11:38	2026-08-18 11:38	FRO	FRO260918P00040000	put	40.0000	2026-09-18	1.9500	1.9500	2.1000	42.6100	41730.00	0.00	41730.00	214	39	238	116	2.05172413793103	0.65422401231021	0.65422401231021	false	false	false	true	false
16e6bf89-0b27-4df6-a2d3-2db873182c86	2026-08-18 12:51	2026-08-18 12:51	2026-08-18 12:51	FRO	FRO260821C00040000	call	40.0000	2026-08-21	2.9500	2.8000	3.0000	42.8000	56050.00	56050.00	0.00	190	12	407	8145	0.0499693063228975	0.633093231273034	0.633093231273034	false	false	false	true	false
cc1a1b54-05d6-49fb-a8d0-a7b0f56ed5ec	2026-08-18 12:53	2026-08-18 12:52	2026-08-18 12:52	FRO	FRO260821C00040000	call	40.0000	2026-08-21	2.9500	2.9500	3.0000	42.8350	14160.00	0.00	13570.00	48	7	455	8145	0.0558624923265807	0.588076125762511	0.588076125762511	false	false	false	true	false
a25093c3-6568-4dd1-ae8a-78f16f54a0d5	2026-08-18 12:55	2026-08-18 12:55	2026-08-18 12:55	FRO	FRO260821C00040000	call	40.0000	2026-08-21	2.9500	2.9500	3.0000	42.8100	10620.00	0.00	10620.00	36	10	507	8145	0.0622467771639042	0.620901435417301	0.620901435417301	false	false	false	true	false
82fe15ed-297e-4698-a5d3-5c4cec812573	2026-08-18 13:45	2026-08-18 13:45	2026-08-18 13:45	FRO	FRO260918C00043000	call	43.0000	2026-09-18	2.3500	2.2500	2.3500	42.9550	139120.00	139120.00	0.00	592	42	658	1424	0.462078651685393	0.4619085799325	0.4619085799325	false	false	false	true	false
f3e87087-753c-4fcc-a9cb-c42be9d5d8f5	2026-08-19 09:32	2026-08-19 09:32	2026-08-19 09:32	FRO	FRO261120C00055000	call	55.0000	2026-11-20	0.9800	0.9500	1.1000	45.0700	41950.00	3870.00	38080.00	427	12	599	8015	0.0747348721147848	0.410056148456565	0.414626820137593	false	false	false	true	false
6fa9201d-6f2d-4b03-b0e1-e2213c7cd9c8	2026-08-19 09:33	2026-08-19 09:33	2026-08-19 09:33	FRO	FRO260821C00040000	call	40.0000	2026-08-21	5.1000	4.9000	5.2000	45.0300	12750.00	8160.00	4080.00	25	5	102	7548	0.0135135135135135	0.967633840619025	0.967633840619025	false	false	false	true	false
b20e70d3-3c13-495b-8399-18f8e9ffcf74	2026-08-19 09:34	2026-08-19 09:34	2026-08-19 09:34	FRO	FRO260821C00040000	call	40.0000	2026-08-21	5.1000	5.1000	5.2000	45.0112	37230.00	0.00	37230.00	73	13	196	7548	0.0259671436142024	1.01980053752541	1.01980053752541	false	false	false	true	false
e45e1cb2-a7be-4ce8-a979-7c0283b8743b	2026-08-19 09:34	2026-08-19 09:34	2026-08-19 09:34	FRO	FRO260821C00040000	call	40.0000	2026-08-21	5.1000	4.9000	5.2000	45.0600	32640.00	4080.00	28560.00	64	13	267	7548	0.0353736089030207	0.859107180200085	0.859107180200085	false	false	false	true	false
d67ad212-1d91-4ecc-b13f-9c7e59cbb2d6	2026-08-19 11:09	2026-08-19 11:09	2026-08-19 11:09	FRO	FRO280121P00015000	put	15.0000	2028-01-21	0.9000	0.9000	2.6500	44.3500	22500.00	0.00	22500.00	250	22	256	878	0.291571753986333	0.728856236880587	0.728856236880587	false	false	false	true	false
7e431ee2-0cbc-451f-b85d-52a6d3dfdcfa	2026-08-19 15:09	2026-08-19 15:09	2026-08-19 15:09	FRO	FRO280121P00020000	put	20.0000	2028-01-21	1.6500	1.6500	3.2000	44.1500	15015.00	495.00	14520.00	91	24	91	65	1.4	0.675468858789786	0.675468858789786	false	false	false	true	false
e2ebca6b-cba1-4de9-93bf-856b09182a63	2026-08-20 10:53	2026-08-20 10:52	2026-08-20 10:52	FRO	FRO260918C00040000	call	40.0000	2026-09-18	4.7000	4.7000	4.9000	44.0000	15510.00	0.00	15510.00	33	8	64	1281	0.0499609679937549	0.42481117042089	0.42481117042089	false	false	false	true	false
ed17ba66-98d9-453e-b520-3627c6d55c51	2026-08-21 09:41	2026-08-21 09:41	2026-08-21 09:41	FRO	FRO260918C00040000	call	40.0000	2026-09-18	5.0000	4.4000	5.1000	44.3550	24997.00	21997.00	3000.00	50	6	90	1283	0.0701480904130943	0.436009597710293	0.432825831601019	false	false	false	true	false
c5c15aee-e118-4473-8eaf-e35e189c0c72	2026-08-21 10:14	2026-08-21 10:14	2026-08-21 10:14	FRO	FRO261016C00049000	call	49.0000	2026-10-16	1.1000	0.9000	1.1000	44.4050	25520.00	25520.00	0.00	232	28	233	0	0	0.375992690817959	0.375992690817959	false	false	false	true	false
d7bba6e7-5f79-4698-8ddf-10eab2d24ac8	2026-08-21 12:38	2026-08-21 12:38	2026-08-21 12:38	FRO	FRO260918C00048000	call	48.0000	2026-09-18	1.0000	0.6500	1.0000	43.7200	110995.00	110995.00	0.00	1110	62	1219	20	60.95	0.505516877021085	0.505516877021085	false	false	false	true	false
f5fd426d-5924-416d-96ff-5cd289eb043c	2026-08-21 13:41	2026-08-21 13:41	2026-08-21 13:41	FRO	FRO260918P00040000	put	40.0000	2026-09-18	1.5000	1.5000	1.6000	43.5800	104400.00	0.00	104400.00	696	41	712	657	1.08371385083714	0.650161179766396	0.650161179766396	false	false	false	true	false
2e08e5f4-f6ee-4e0a-a6c7-055b3dbdd8f9	2026-08-24 09:45	2026-08-24 09:45	2026-08-24 09:45	FRO	FRO260918P00040000	put	40.0000	2026-09-18	1.3500	1.3500	1.5500	43.6850	23090.00	140.00	22950.00	171	34	174	1337	0.130142109199701	0.655161680485689	0.668369478806747	false	false	false	true	false
8da6a9e9-3140-479d-ba0b-c69c5888cf92	2026-08-24 10:43	2026-08-24 10:43	2026-08-24 10:43	FRO	FRO270115P00035000	put	35.0000	2027-01-15	2.3000	2.0000	2.3000	44.0400	11500.00	11500.00	0.00	50	14	51	2481	0.0205562273276904	0.6057742544484	0.6057742544484	false	false	false	true	false
d5178814-f46e-4949-a64f-678b4cce6b65	2026-08-24 12:15	2026-08-24 12:15	2026-08-24 12:15	FRO	FRO260918C00044000	call	44.0000	2026-09-18	2.0000	1.8000	2.0500	43.6000	27400.00	27400.00	0.00	137	22	236	2053	0.114953726254262	0.468816429667654	0.468816429667654	false	false	false	true	false
debaa1aa-11c4-410d-863c-57b088399678	2026-08-24 12:44	2026-08-24 12:44	2026-08-24 12:44	FRO	FRO260918P00040000	put	40.0000	2026-09-18	1.5500	1.4000	1.6000	43.5500	12707.00	12707.00	0.00	82	38	409	1337	0.305908750934929	0.697730118316595	0.697730118316595	false	false	false	true	false
51873580-fdb7-4152-8067-5c9e9a456064	2026-08-24 12:52	2026-08-24 12:52	2026-08-24 12:52	FRO	FRO261016C00049000	call	49.0000	2026-10-16	1.0500	0.7500	1.0500	43.5900	21100.00	21000.00	100.00	201	14	202	233	0.866952789699571	0.418499308356609	0.409309415387676	false	false	false	true	false
220a029d-ce89-4805-9a9c-0804c2622905	2026-08-24 12:52	2026-08-24 12:52	2026-08-24 12:52	FRO	FRO261016C00049000	call	49.0000	2026-10-16	1.0500	0.8000	1.2000	43.6700	12600.00	12600.00	0.00	120	8	790	233	3.39055793991416	0.414580450498259	0.414580450498259	false	false	false	true	false
165353cc-b7f3-42b9-bcfa-4f8bdca68190	2026-08-24 12:52	2026-08-24 12:52	2026-08-24 12:52	FRO	FRO261016C00049000	call	49.0000	2026-10-16	1.0400	0.9000	1.0500	43.6200	32790.00	30690.00	2100.00	314	20	617	233	2.6480686695279	0.41703008627322	0.41703008627322	false	false	false	true	false
c51fe160-bd71-40da-80cb-d8639a9cac64	2026-08-24 12:52	2026-08-24 12:52	2026-08-24 12:52	FRO	FRO261016C00049000	call	49.0000	2026-10-16	1.0500	0.9000	1.0500	43.7050	18690.00	18690.00	0.00	178	17	980	233	4.20600858369099	0.412864990295604	0.412864990295604	false	false	false	true	false
e88ef6c2-ccd0-4217-9bc2-c67ac13487cd	2026-08-24 12:58	2026-08-24 12:58	2026-08-24 12:58	FRO	FRO260918C00046000	call	46.0000	2026-09-18	1.3500	1.1000	1.3500	43.5800	31725.00	31725.00	0.00	235	18	444	667	0.665667166416792	0.497466241690469	0.497466241690469	false	false	false	true	false
e1e28fa4-ed4a-496f-9f8e-675c60ad34bd	2026-08-24 13:50	2026-08-24 13:50	2026-08-24 13:50	FRO	FRO260918P00044000	put	44.0000	2026-09-18	3.6000	3.6000	4.2000	43.8379	19820.00	0.00	19820.00	55	12	122	109	1.11926605504587	0.804205491754621	0.782250866682226	false	false	false	true	false
32340fb8-d7b7-4fc6-82f1-1e3a941ac99a	2026-08-24 13:51	2026-08-24 13:51	2026-08-24 13:51	FRO	FRO260918P00044000	put	44.0000	2026-09-18	3.6100	3.6000	4.1000	43.8500	10100.00	0.00	10100.00	28	7	150	109	1.37614678899083	0.805427200647862	0.783475374017299	false	false	false	true	false
c022b6c4-47a8-4a68-99fa-097cc072f5ca	2026-08-24 13:54	2026-08-24 13:54	2026-08-24 13:54	FRO	FRO261016C00049000	call	49.0000	2026-10-16	1.1000	0.8500	1.3000	43.7550	15925.00	15815.00	110.00	145	17	1212	233	5.20171673819743	0.419424272085757	0.419424272085757	false	false	false	true	false
0a5c4e86-085b-4ae9-ba8b-0b4eb7f7d363	2026-08-24 14:07	2026-08-24 14:06	2026-08-24 14:06	FRO	FRO261016C00050000	call	50.0000	2026-10-16	1.0000	0.8500	1.1500	43.8550	10100.00	10000.00	100.00	101	17	181	2	90.5	0.435060601146136	0.435060601146136	false	false	false	true	false
13631670-bbff-41f7-a6ee-fa2f1284f35d	2026-08-24 14:39	2026-08-24 14:39	2026-08-24 14:39	FRO	FRO260918C00045000	call	45.0000	2026-09-18	1.6500	1.6000	1.9500	43.9400	10559.00	0.00	10559.00	64	13	153	1057	0.144749290444655	0.439531106640047	0.463683533124457	false	false	false	true	false
6aeda1e2-bffd-49f6-a1ff-d145dd919eac	2026-08-24 14:41	2026-08-24 14:41	2026-08-24 14:41	FRO	FRO261016C00045000	call	45.0000	2026-10-16	2.0900	2.0500	2.3500	43.9500	18599.00	0.00	18599.00	89	9	91	50	1.82	0.368223849017641	0.368223849017641	false	false	false	true	false
21db6618-9542-4ef6-a64a-3049610fed9d	2026-08-24 14:47	2026-08-24 14:47	2026-08-24 14:47	FRO	FRO270219P00043000	put	43.0000	2027-02-19	6.6000	6.6000	7.0000	43.9000	23100.00	0.00	23100.00	35	13	82	22	3.72727272727273	0.622987996088375	0.622987996088375	false	false	false	true	false
5c7f037e-dc2a-4066-8585-22d71cfbd44f	2026-08-24 15:21	2026-08-24 15:21	2026-08-24 15:21	FRO	FRO261016C00049000	call	49.0000	2026-10-16	1.1500	0.9500	1.3500	43.8600	12535.00	12305.00	230.00	109	20	1428	233	6.12875536480687	0.425096188564171	0.423093098030455	false	false	false	true	false
695292ce-767e-4d05-8e21-c4d8ac740add	2026-08-24 15:23	2026-08-24 15:23	2026-08-24 15:23	FRO	FRO260918P00044000	put	44.0000	2026-09-18	3.8000	1.9000	4.9000	43.8235	33060.00	32680.00	380.00	87	11	263	109	2.41284403669725	0.824713930698307	0.824713930698307	false	false	false	true	false
71eba5c9-8c26-4dc9-a071-8714c3b38a6f	2026-08-24 15:37	2026-08-24 15:37	2026-08-24 15:37	FRO	FRO261016C00049000	call	49.0000	2026-10-16	1.1500	0.9500	1.3000	43.8000	23230.00	23000.00	230.00	202	17	1659	233	7.12017167381974	0.426097407429411	0.426097407429411	false	false	false	true	false
831fe0a4-2de2-4433-9f53-f61e9f0dd73e	2026-08-25 10:12	2026-08-25 10:12	2026-08-25 10:12	FRO	FRO261120C00045000	call	45.0000	2026-11-20	2.5000	2.2000	2.5000	42.9800	22500.00	22500.00	0.00	90	26	94	1973	0.0476431829700963	0.38055064072772	0.38055064072772	false	false	false	true	false
c64f6af2-8533-4e12-a3a0-2479827b62c5	2026-08-25 10:17	2026-08-25 10:17	2026-08-25 10:17	FRO	FRO260918C00043000	call	43.0000	2026-09-18	2.0000	2.0000	2.2000	42.9900	10000.00	0.00	10000.00	50	19	107	2115	0.0505910165484634	0.444394936404006	0.444394936404006	false	false	false	true	false
0ae1b278-e96d-46d6-b151-eb8c82aa5d92	2026-08-25 11:18	2026-08-25 11:18	2026-08-25 11:18	FRO	FRO260918P00040000	put	40.0000	2026-09-18	1.6000	1.6000	1.7500	42.9602	21760.00	0.00	21760.00	136	35	190	1707	0.111306385471588	0.679399511838928	0.679399511838928	false	false	false	true	false
26cf7bae-dd18-423f-88b8-a8fb8605cffd	2026-08-25 12:15	2026-08-25 12:15	2026-08-25 12:15	FRO	FRO261016P00042000	put	42.0000	2026-10-16	3.2000	2.2000	3.3000	43.4800	15350.00	630.00	14720.00	48	14	48	70	0.685714285714286	0.623644973204163	0.608079428551349	false	false	false	true	false
87e91775-b452-439b-9415-a191fd289d7b	2026-08-25 12:35	2026-08-25 12:35	2026-08-25 12:35	FRO	FRO261016P00042000	put	42.0000	2026-10-16	3.3000	2.6500	3.4000	43.2700	27060.00	3630.00	23430.00	82	18	131	70	1.87142857142857	0.626857898458604	0.626857898458604	false	false	false	true	false