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 = IOT×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

79f0c1f8-919b-48c3-9cb9-e2ac2bd79e60	2026-08-17 10:04	2026-08-17 10:04	2026-08-17 10:04	IOT	IOT260918C00045000	call	45.0000	2026-09-18	1.3000	1.3000	1.4500	38.3800	26000.00	0.00	26000.00	200	6	266	1141	0.233128834355828	0.747774422393533	0.747774422393533	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	16317515975.00	2026-12-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
b413fb54-e043-47db-b1db-844ec780f607	2026-08-18 15:36	2026-08-18 15:36	2026-08-18 15:36	IOT	IOT280121C00050000	call	50.0000	2028-01-21	9.9000	9.7000	10.3000	40.0400	461341.00	164340.00	297001.00	466	42	486	288	1.6875	0.64858272602378	0.649494406217498	true	false	false	true
a312348c-6904-428a-93b0-a1bddc2ae960	2026-08-18 15:36	2026-08-18 15:36	2026-08-18 15:36	IOT	IOT280121C00050000	call	50.0000	2028-01-21	9.9000	9.7000	10.3000	40.0250	269281.00	30690.00	238591.00	272	25	758	288	2.63194444444444	0.649950464769547	0.649950464769547	true	false	false	true
0c8fa781-817c-4ae3-b227-9f5c477a0608	2026-08-18 15:40	2026-08-18 15:40	2026-08-18 15:40	IOT	IOT270115C00045000	call	45.0000	2027-01-15	5.0000	5.0000	5.3000	39.9700	495000.00	0.00	495000.00	990	42	1011	862	1.17285382830626	0.64956203557217	0.64956203557217	false	false	false	true
a9fd14b1-bf1a-441b-803c-d02fcc59a7de	2026-08-19 14:26	2026-08-19 14:26	2026-08-19 14:26	IOT	IOT270115C00045000	call	45.0000	2027-01-15	4.9000	4.9000	5.3000	40.0500	56840.00	0.00	56840.00	116	13	863	1791	0.481853713009492	0.638335182835642	0.638335182835642	false	false	false	true
f3dd986c-3437-4aa7-a8ed-87e1fa131234	2026-08-19 15:48	2026-08-19 15:47	2026-08-19 15:47	IOT	IOT260821C00040000	call	40.0000	2026-08-21	0.4000	0.3000	0.4500	39.2950	20000.00	3720.00	16280.00	500	5	1574	3527	0.446271618939609	0.592338438839338	0.592338438839338	true	false	false	true
bf881faa-6968-48be-9c74-fae098acde3f	2026-08-24 09:45	2026-08-24 09:45	2026-08-24 09:45	IOT	IOT260904C00045000	call	45.0000	2026-09-04	1.4500	1.3000	1.4500	40.5400	16675.00	16675.00	0.00	115	6	372	223	1.66816143497758	1.07670246825806	1.07670246825806	false	false	false	true
9ea40885-d80b-4789-afd7-449f3f7e74c8	2026-08-24 13:37	2026-08-24 13:37	2026-08-24 13:37	IOT	IOT261120C00060000	call	60.0000	2026-11-20	0.6000	0.6000	0.6500	39.7650	18180.00	0.00	11700.00	303	12	911	0	0	0.609738560282675	0.609738560282675	true	false	false	true
57f1098e-a57f-4d36-a61c-c9afda4e2742	2026-08-24 13:37	2026-08-24 13:37	2026-08-24 13:37	IOT	IOT261016C00047000	call	47.0000	2026-10-16	1.6400	1.6000	2.1000	39.8900	37600.00	31680.00	5920.00	229	15	746	256	2.9140625	0.634369192920206	0.634369192920206	false	false	false	true
4bbe2564-08ec-4f89-a93e-54835e1eda6e	2026-08-24 14:06	2026-08-24 14:06	2026-08-24 14:06	IOT	IOT270115C00050000	call	50.0000	2027-01-15	3.4000	3.1000	3.4000	39.8250	14280.00	14280.00	0.00	42	10	45	2122	0.0212064090480679	0.646520144230721	0.646520144230721	false	false	false	true
2ff5b2fc-37a3-4a8c-ac13-95413ba20e46	2026-08-24 14:25	2026-08-24 14:25	2026-08-24 14:25	IOT	IOT270115C00050000	call	50.0000	2027-01-15	3.4000	3.3000	3.4000	40.0589	15980.00	15980.00	0.00	47	10	137	2122	0.0645617342130066	0.637288336216161	0.637288336216161	false	false	false	true
0c236691-fab3-4a85-838a-7b0af3cc9202	2026-08-24 14:25	2026-08-24 14:25	2026-08-24 14:25	IOT	IOT270115C00050000	call	50.0000	2027-01-15	3.4000	3.3000	3.4000	40.0589	49640.00	49640.00	0.00	146	24	283	2122	0.133364750235627	0.637288336216161	0.637288336216161	false	false	false	true
f6a21fb1-0d79-4516-9cdf-18dee98f9477	2026-08-26 11:52	2026-08-26 11:52	2026-08-26 11:52	IOT	IOT261218P00033000	put	33.0000	2026-12-18	2.6000	2.6000	2.7000	39.7600	15860.00	0.00	15860.00	61	17	62	11	5.63636363636364	0.68039802512073	0.68039802512073	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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