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×er_time = unknown×ticker = IOT×

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

c475916d-8b57-4035-bd0b-6b5ec953b378	2026-09-22 12:09	2026-09-22 12:09	2026-09-22 12:09	IOT	IOT261002C00041000	call	41.0000	2026-10-02	0.4000	0.3500	0.4000	38.0600	15960.00	15960.00	0.00	399	22	406	1050	0.386666666666667	0.535170101491374	0.535170101491374	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	14549246357.00	2026-12-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T16:12:44.237245Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
eaaf8408-ac01-4af0-8b7a-dec368854aca	2026-09-21 13:52	2026-09-21 13:52	2026-09-21 13:52	IOT	IOT261120C00047000	call	47.0000	2026-11-20	0.7500	0.7500	1.3000	38.3500	14325.00	0.00	14325.00	191	11	218	1693	0.128765505020673	0.499085769665093	0.499085769665093	false	false	false	true
49629ffe-cd1e-4fc8-9c20-2c6028b6b4b1	2026-09-18 15:49	2026-09-18 15:49	2026-09-18 15:49	IOT	IOT261120P00033000	put	33.0000	2026-11-20	0.9000	0.8500	1.0000	39.7050	20520.00	0.00	20250.00	228	26	237	15	15.8	0.545635721527649	0.545635721527649	false	false	false	true
9d972757-a22b-4b20-9bc5-58068d67af5f	2026-09-18 15:10	2026-09-18 15:10	2026-09-18 15:10	IOT	IOT270115P00035000	put	35.0000	2027-01-15	2.7600	2.6000	2.9000	39.4250	13813.00	1375.00	12438.00	50	5	441	893	0.493840985442329	0.574476423161667	0.583630755897184	false	false	false	true
1a3d5335-7ff2-4ad6-8962-434289de01c3	2026-09-18 09:58	2026-09-18 09:58	2026-09-18 09:58	IOT	IOT270115C00045000	call	45.0000	2027-01-15	3.1000	3.1000	4.2000	39.1900	465000.00	0.00	465000.00	1500	17	1500	3838	0.390828556539865	0.559537662417785	0.559537662417785	false	false	false	true
1f6760bb-bd4b-4c12-8af2-47b70afe2599	2026-09-18 09:33	2026-09-18 09:33	2026-09-18 09:33	IOT	IOT270115P00035000	put	35.0000	2027-01-15	2.9000	2.8500	2.9000	39.4900	21460.00	21460.00	0.00	74	7	180	893	0.201567749160134	0.596499169050051	0.596499169050051	false	false	false	true
54b150a8-1e72-44ac-a882-36d2c3055e01	2026-09-17 13:22	2026-09-17 13:21	2026-09-17 13:21	IOT	IOT261218C00037000	call	37.0000	2026-12-18	6.4000	6.4000	7.5000	39.8400	128000.00	0.00	128000.00	200	5	200	250	0.8	0.604020532594313	0.604020532594313	false	false	false	true
8c71e5ad-989e-4c58-bbd6-b53761948ca7	2026-09-17 13:07	2026-09-17 13:07	2026-09-17 13:07	IOT	IOT261016C00041000	call	41.0000	2026-10-16	2.0000	1.9000	2.0000	39.7700	10000.00	10000.00	0.00	50	6	73	593	0.123102866779089	0.554688390109627	0.554688390109627	false	false	false	true
5beb4948-8b1e-4d91-b118-44c52999297d	2026-09-15 12:00	2026-09-15 11:59	2026-09-15 11:59	IOT	IOT261218P00038000	put	38.0000	2026-12-18	2.9000	2.8000	2.9000	42.7100	12470.00	12470.00	0.00	43	18	44	318	0.138364779874214	0.624878703805185	0.624878703805185	false	false	false	true
5bac5272-53b8-4992-bc10-25bd1087a175	2026-09-15 10:13	2026-09-15 10:13	2026-09-15 10:13	IOT	IOT270115P00043000	put	43.0000	2027-01-15	6.0000	5.4000	6.1000	41.8800	19800.00	4200.00	15600.00	33	5	33	47	0.702127659574468	0.592880589353581	0.592880589353581	false	false	false	true
74d29276-0d77-4b03-96d4-97fe8155f9ef	2026-09-14 13:23	2026-09-14 13:23	2026-09-14 13:23	IOT	IOT261120C00040000	call	40.0000	2026-11-20	5.4000	5.3000	5.5000	42.3300	14043.00	0.00	10803.00	26	6	88	139	0.633093525179856	0.567877081251263	0.566912502459846	false	false	false	true
e7fa9f2c-aa84-435f-8b25-ef18cb3a4e73	2026-09-11 10:36	2026-09-11 10:36	2026-09-11 10:36	IOT	IOT261218C00039000	call	39.0000	2026-12-18	5.0000	4.7000	5.1000	38.7300	10500.00	2500.00	8000.00	21	6	24	29	0.827586206896552	0.618495084118338	0.618495084118338	false	false	false	true
bc7111e9-bdf2-45dd-ad5a-9452b96b644f	2026-09-11 10:30	2026-09-11 10:30	2026-09-11 10:30	IOT	IOT261218P00035000	put	35.0000	2026-12-18	2.9500	2.5500	3.1000	38.5300	39825.00	1770.00	38055.00	135	10	135	835	0.161676646706587	0.61789799480892	0.61789799480892	false	false	false	true
c8797e1f-675f-4014-ad14-141940226383	2026-09-09 14:44	2026-09-09 14:44	2026-09-09 14:44	IOT	IOT261002C00039000	call	39.0000	2026-10-02	2.0900	2.0000	2.1000	38.6200	12540.00	12540.00	0.00	60	5	104	114	0.912280701754386	0.575038588615079	0.575038588615079	false	false	false	true
f0edb64d-96e4-430b-9fe8-662705845864	2026-09-09 11:17	2026-09-09 11:17	2026-09-09 11:17	IOT	IOT261218P00038000	put	38.0000	2026-12-18	4.7000	4.4000	4.8000	38.1000	125485.00	84595.00	40890.00	267	37	267	82	3.25609756097561	0.630831965151362	0.629758762968188	false	false	false	true
6e79683b-2e7e-4111-a9f0-0b83591dfd31	2026-09-09 10:57	2026-09-09 10:57	2026-09-09 10:57	IOT	IOT261009P00039000	put	39.0000	2026-10-09	3.0000	3.0000	3.2000	37.9700	12000.00	0.00	12000.00	40	11	41	2	20.5	0.574088895644696	0.574088895644696	true	false	false	true
83758625-598a-4a7f-8e66-45747fc8fe76	2026-09-09 10:50	2026-09-09 10:50	2026-09-09 10:50	IOT	IOT261218P00034000	put	34.0000	2026-12-18	2.7000	2.6000	2.7000	38.1800	41580.00	41580.00	0.00	154	19	159	29	5.48275862068965	0.620307206424024	0.620307206424024	false	false	false	true
0bd6f8d9-06b7-432b-b329-131fae7b4e1c	2026-09-08 13:27	2026-09-08 13:27	2026-09-08 13:27	IOT	IOT261120C00047000	call	47.0000	2026-11-20	1.6000	1.5500	1.6000	39.5900	29920.00	29920.00	0.00	187	27	207	1550	0.133548387096774	0.551165393996765	0.551165393996765	false	false	false	true
26f5327a-5db0-4774-b887-7542e2d1b946	2026-09-08 10:41	2026-09-08 10:41	2026-09-08 10:41	IOT	IOT260911C00040000	call	40.0000	2026-09-11	1.0500	1.0500	1.2500	40.1200	34970.00	110.00	34860.00	333	19	522	2088	0.25	0.678214910958531	0.712794233908778	false	false	false	true
2086ced9-b966-4a1c-aecd-d95735b41cac	2026-09-08 09:50	2026-09-08 09:50	2026-09-08 09:50	IOT	IOT261218C00047000	call	47.0000	2026-12-18	2.9000	2.1000	3.1000	40.3600	16525.00	580.00	15945.00	57	9	57	218	0.261467889908257	0.600155861627119	0.592091794316337	false	false	false	true
1a23d2bb-abe5-47b1-8723-c2a4c319c204	2026-09-04 13:20	2026-09-04 13:20	2026-09-04 13:20	IOT	IOT270416C00045000	call	45.0000	2027-04-16	5.6000	5.6000	6.5000	39.6150	892080.00	0.00	892080.00	1593	34	2407	6	401.166666666667	0.583528026134424	0.583528026134424	false	false	false	true
455847e1-bb3b-4894-a235-a149fe32e0c4	2026-09-04 12:53	2026-09-04 12:53	2026-09-04 12:53	IOT	IOT270115P00040000	put	40.0000	2027-01-15	5.3000	5.1000	5.4000	40.0000	11130.00	3710.00	7420.00	21	6	41	131	0.312977099236641	0.586623912495622	0.586623912495622	false	false	false	true
dcf0ca91-b794-4f0d-a889-b67873df0985	2026-09-04 12:20	2026-09-04 12:20	2026-09-04 12:20	IOT	IOT260904C00041000	call	41.0000	2026-09-04	0.3000	0.3000	0.5500	40.6125	22530.00	0.00	22530.00	751	39	2989	207	14.43961352657	1.40704970895696	1.40704970895696	false	false	false	true
6c61da31-3b37-4e19-8024-1bf09e3635f1	2026-09-04 12:05	2026-09-04 12:05	2026-09-04 12:05	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.4000	6.5000	41.1050	40300.00	40300.00	0.00	62	12	764	6	127.333333333333	0.593526241944574	0.593526241944574	false	false	false	true
549f840a-9166-48b4-b45c-83ecb72874c0	2026-09-04 12:05	2026-09-04 12:05	2026-09-04 12:05	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.4000	6.5000	41.1000	29900.00	29900.00	0.00	46	8	690	6	115	0.593736004152921	0.593736004152921	false	false	false	true
0bde0c62-5648-4d02-baa9-f92ad2725399	2026-09-04 12:05	2026-09-04 12:05	2026-09-04 12:05	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.4000	6.5000	41.0450	27950.00	27950.00	0.00	43	7	628	6	104.666666666667	0.596043584048211	0.596043584048211	false	false	false	true
1f03cb46-3b18-4da7-96ab-1dae5a6604ae	2026-09-04 12:05	2026-09-04 12:04	2026-09-04 12:04	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.4000	6.5000	41.0600	37050.00	37050.00	0.00	57	11	585	6	97.5	0.59541420760196	0.59541420760196	false	false	false	true
6c9d8527-b42d-4760-bbfd-02b71f20ac45	2026-09-04 12:04	2026-09-04 12:04	2026-09-04 12:04	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.4000	6.5000	41.0300	33150.00	33150.00	0.00	51	9	490	6	81.6666666666667	0.599085982972688	0.596672988909449	false	false	false	true
be7e76de-306c-46c9-884c-62eb6257c700	2026-09-04 12:04	2026-09-04 12:04	2026-09-04 12:04	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.4000	6.5000	40.9950	33150.00	33150.00	0.00	51	9	363	6	60.5	0.597931886588112	0.59814171456169	false	false	false	true
aebe2327-bd4d-4684-9ad7-31c31e08426b	2026-09-04 12:04	2026-09-04 12:04	2026-09-04 12:04	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.3000	6.5000	41.0000	26000.00	26000.00	0.00	40	8	312	6	52	0.597931886588112	0.597931886588112	false	false	false	true
adf83ed2-a1ae-487a-9d4f-67679891a007	2026-09-04 12:04	2026-09-04 12:04	2026-09-04 12:04	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.3000	6.5000	40.9100	33150.00	33150.00	0.00	51	9	272	6	45.3333333333333	0.601709331767837	0.601709331767837	false	false	false	true
ba15fa3a-1d99-4046-b0cb-3209dd83e1e7	2026-09-04 12:04	2026-09-04 12:04	2026-09-04 12:04	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	6.3000	6.5000	40.9050	33150.00	33150.00	0.00	51	9	221	6	36.8333333333333	0.601919224877095	0.601919224877095	false	false	false	true
254c1585-6dc5-444b-8bb8-53f8d6d3aa3b	2026-09-04 12:03	2026-09-04 12:03	2026-09-04 12:03	IOT	IOT270416C00045000	call	45.0000	2027-04-16	6.5000	5.8000	6.5000	40.8500	109850.00	109850.00	0.00	169	36	170	6	28.3333333333333	0.604560017409903	0.604228308786983	false	false	false	true
929e2ff2-ea19-4971-a72a-51e6986106a5	2026-09-04 10:42	2026-09-04 10:42	2026-09-04 10:42	IOT	IOT260911C00037000	call	37.0000	2026-09-11	4.0000	3.6000	4.6000	40.7500	24000.00	0.00	24000.00	60	6	70	38	1.84210526315789	0.627710968477083	0.627710968477083	false	false	false	true
72a995d1-2241-49ef-badd-d9539b3bab39	2026-09-04 09:36	2026-09-04 09:36	2026-09-04 09:36	IOT	IOT260918C00038500	call	38.5000	2026-09-18	3.2000	3.2000	4.0000	41.5900	20800.00	0.00	20800.00	65	5	72	431	0.167053364269142	0.259663432408461	0.259663432408461	false	false	false	true
bda1a010-c8da-4c8d-80ec-d7966e9aded3	2026-09-03 15:57	2026-09-03 15:57	2026-09-03 15:57	IOT	IOT260904C00042000	call	42.0000	2026-09-04	1.3000	1.2000	1.4500	38.7200	26260.00	20670.00	5590.00	202	14	2050	218	9.40366972477064	3.11205292592676	3.11205292592676	false	false	false	true
be3df293-f644-48cd-8d56-b05d44f37921	2026-09-03 15:40	2026-09-03 15:40	2026-09-03 15:40	IOT	IOT260918C00041000	call	41.0000	2026-09-18	1.8500	1.6500	1.9500	38.3150	83250.00	69005.00	14245.00	450	6	466	1316	0.354103343465046	0.931198152706994	0.931198152706994	false	false	false	true
e6d8efcc-3a11-412a-96f3-2597c9f2678d	2026-09-03 15:02	2026-09-03 15:02	2026-09-03 15:02	IOT	IOT260904C00046000	call	46.0000	2026-09-04	0.3000	0.2500	0.5000	38.4700	22440.00	2700.00	19740.00	748	16	1254	128	9.796875	2.71862174359249	2.72158917459482	false	false	false	true
435daf5d-29ad-4d23-ad9e-86dd59d0ebc6	2026-09-03 15:01	2026-09-03 15:01	2026-09-03 15:01	IOT	IOT260904C00046000	call	46.0000	2026-09-04	0.3000	0.2500	0.5000	38.4900	13800.00	2070.00	11730.00	460	13	506	128	3.953125	2.71565453012102	2.71565453012102	false	false	false	true
e00b1369-29aa-4aaa-b7bf-44a66a36c3da	2026-09-03 14:26	2026-09-03 14:26	2026-09-03 14:26	IOT	IOT261218C00050000	call	50.0000	2026-12-18	2.2000	2.2000	2.3500	38.4900	96580.00	0.00	96580.00	439	23	439	615	0.713821138211382	0.661881036910576	0.661881036910576	false	false	false	true
1536d950-7fdc-4bd7-8ffa-89d39bc62cf5	2026-09-03 14:12	2026-09-03 14:12	2026-09-03 14:12	IOT	IOT260918P00035000	put	35.0000	2026-09-18	1.3000	1.3000	1.4500	38.4400	12870.00	0.00	12870.00	99	5	152	254	0.598425196850394	0.910028603405411	0.910028603405411	false	false	false	true
df842425-7f06-4df1-96e3-b7e398fc43d6	2026-09-03 11:15	2026-09-03 11:15	2026-09-03 11:15	IOT	IOT260904C00038000	call	38.0000	2026-09-04	2.0000	1.9000	2.1500	37.6000	100000.00	400.00	22400.00	500	20	638	27	23.6296296296296	2.78008262319078	2.78008262319078	false	false	false	true
a1511723-40a9-4e06-9fb9-9cbbca34a992	2026-09-03 09:46	2026-09-03 09:46	2026-09-03 09:46	IOT	IOT260904P00036000	put	36.0000	2026-09-04	1.1500	1.1500	1.2500	38.0700	28635.00	0.00	17020.00	249	14	250	234	1.06837606837607	2.61458472878547	2.61458472878547	false	false	false	true
34383c69-b53e-4c91-a980-038036dd2fc3	2026-09-01 15:00	2026-09-01 15:00	2026-09-01 15:00	IOT	IOT261016C00042000	call	42.0000	2026-10-16	2.5000	2.4000	2.5000	39.0450	60250.00	60250.00	0.00	241	30	241	140	1.72142857142857	0.658504571976434	0.658504571976434	false	false	false	true
d5f032f3-be95-4c5a-a805-feda73d0af1d	2026-08-28 15:24	2026-08-28 15:24	2026-08-28 15:24	IOT	IOT260904P00039500	put	39.5000	2026-09-04	1.5000	1.3500	1.5500	41.3100	47700.00	750.00	46950.00	318	20	318	17	18.7058823529412	1.03255309958706	1.03337674695931	false	false	false	true
1b39682a-046a-439b-ad10-d4ec86805f9f	2026-08-28 10:38	2026-08-28 10:38	2026-08-28 10:38	IOT	IOT261218P00032000	put	32.0000	2026-12-18	1.8500	1.8500	1.9000	41.6550	21460.00	0.00	21460.00	116	7	118	7	16.8571428571429	0.682972882201394	0.682972882201394	false	false	false	true
e7bcee97-2bae-4c92-8626-57d4e280cdd3	2026-08-28 10:05	2026-08-28 10:05	2026-08-28 10:05	IOT	IOT260904C00045000	call	45.0000	2026-09-04	1.5500	1.5500	1.8000	42.2600	26350.00	0.00	26350.00	170	8	205	1001	0.204795204795205	1.11770354184693	1.11770354184693	false	false	false	true
442e19e6-dfee-45d4-9b70-c151222e081f	2026-08-27 10:04	2026-08-27 10:04	2026-08-27 10:04	IOT	IOT261016C00047000	call	47.0000	2026-10-16	2.5000	2.1000	2.5000	42.2800	15500.00	15500.00	0.00	62	17	64	975	0.0656410256410256	0.668420824194375	0.668420824194375	false	false	false	true
a1954348-40f0-41ac-9d2d-50d84a592d92	2026-08-27 09:42	2026-08-27 09:42	2026-08-27 09:42	IOT	IOT260904P00043000	put	43.0000	2026-09-04	3.8000	3.3000	4.0000	41.1198	11020.00	1520.00	9500.00	29	10	29	0	0	1.12145198359785	1.12145198359785	false	false	false	true
8b2951f9-762e-4648-811c-6da7a282aa08	2026-08-26 13:35	2026-08-26 13:35	2026-08-26 13:35	IOT	IOT260918P00040500	put	40.5000	2026-09-18	3.6000	3.6000	3.7000	39.6500	22320.00	0.00	22320.00	62	14	67	8	8.375	0.801956013343305	0.801956013343305	false	false	false	true