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:er_time = unknown×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
33986195-9bff-4b29-896d-27c8fd058afd	2026-08-18 12:05	2026-08-18 12:05	2026-08-18 12:05	IOT	IOT270115C00040000	call	40.0000	2027-01-15	7.1800	7.0000	7.3000	40.0300	534096.00	519114.00	14982.00	744	6	754	1375	0.548363636363636	0.662767975484619	0.662767975484619	false	false	false	true
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
c8237002-8c8f-45a0-a191-26e211c3933a	2026-08-21 15:52	2026-08-21 15:52	2026-08-21 15:52	IOT	IOT260918C00041000	call	41.0000	2026-09-18	3.0700	3.0000	3.2000	39.9100	10748.00	0.00	10748.00	35	5	41	1302	0.0314900153609831	0.795688022572658	0.795688022572658	false	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
61a5a54d-f737-4b55-b753-968c2166a3b6	2026-08-24 11:53	2026-08-24 11:53	2026-08-24 11:53	IOT	IOT260904C00045000	call	45.0000	2026-09-04	1.2700	1.1000	1.4000	40.2850	15220.00	15220.00	0.00	120	7	739	223	3.31390134529148	1.04042715683615	1.04042715683615	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
53b87aa5-2028-4dba-978b-5a6a018e50bc	2026-08-24 13:37	2026-08-24 13:37	2026-08-24 13:37	IOT	IOT261016C00055000	call	55.0000	2026-10-16	0.5100	0.5000	0.7500	39.8050	11650.00	0.00	11650.00	228	17	718	1230	0.583739837398374	0.634646926293736	0.652440664057378	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
d11239d8-f710-4ee9-b8a4-df06d37bbd84	2026-09-01 12:12	2026-09-01 12:12	2026-09-01 12:12	IOT	IOT280121C00055000	call	55.0000	2028-01-21	7.5000	7.5000	7.9000	39.0224	18003.00	0.00	18003.00	24	13	30	205	0.146341463414634	0.621320693087281	0.621320693087281	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
9134edd7-3a26-4a82-aa9c-d998ba245095	2026-09-03 13:59	2026-09-03 13:59	2026-09-03 13:59	IOT	IOT260911C00036000	call	36.0000	2026-09-11	4.1100	3.8000	4.5000	38.8000	41066.00	0.00	41066.00	100	5	202	3	67.3333333333333	1.10605239249246	1.10605239249246	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
9c882fa4-b46a-42e6-aeb6-7e219b32bbce	2026-09-03 15:08	2026-09-03 15:08	2026-09-03 15:08	IOT	IOT260904C00043000	call	43.0000	2026-09-04	0.8000	0.7500	0.9500	38.5500	19162.00	0.00	19162.00	241	12	363	146	2.48630136986301	2.83314285721152	2.83314285721152	false	false	false	true
3fe99155-adf8-40f3-a4e0-3559e5332dd3	2026-09-03 15:28	2026-09-03 15:28	2026-09-03 15:28	IOT	IOT260904C00042000	call	42.0000	2026-09-04	1.1500	1.0000	1.1500	38.5750	114885.00	114885.00	0.00	999	1	1234	218	5.6605504587156	2.97228637799817	2.97228637799817	false	true	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
5c23df04-26ea-471c-8ed1-894264ce7ebb	2026-09-03 15:41	2026-09-03 15:41	2026-09-03 15:41	IOT	IOT260918C00038500	call	38.5000	2026-09-18	2.7000	2.6000	2.8500	38.1750	66514.00	9450.00	57064.00	246	11	469	25	18.76	0.912329240674949	0.914871275678288	false	false	false	true
472601e4-d00d-46cc-aeaf-5cf923ad6a0d	2026-09-03 15:45	2026-09-03 15:44	2026-09-03 15:44	IOT	IOT260904C00042000	call	42.0000	2026-09-04	1.1300	1.0000	1.1500	38.4400	31165.00	31165.00	0.00	276	9	1674	218	7.67889908256881	2.96192198220906	3.0320060074986	false	false	false	true
eada9310-cfda-4b74-bb39-f839710cae8d	2026-09-03 15:52	2026-09-03 15:52	2026-09-03 15:52	IOT	IOT260904C00040000	call	40.0000	2026-09-04	1.9700	1.8500	2.0000	38.6700	14795.00	10200.00	4595.00	75	6	2303	94	24.5	3.05628690023428	3.18109792285459	true	false	false	true
2c16d88f-1b07-433f-8240-c278b209f03e	2026-09-03 15:53	2026-09-03 15:53	2026-09-03 15:53	IOT	IOT260911C00040000	call	40.0000	2026-09-11	2.2600	2.1000	2.3000	38.6800	22580.00	22580.00	0.00	100	5	3281	81	40.5061728395062	1.24970790307245	1.22773889794874	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
5b4f02a3-1e82-4fc8-8a86-6b55dc866a5a	2026-09-04 09:31	2026-09-04 09:31	2026-09-04 09:31	IOT	IOT260904C00040000	call	40.0000	2026-09-04	4.0900	3.6000	4.1000	43.8475	28660.00	28660.00	0.00	70	24	106	2265	0.0467991169977925	2.68184611407575	3.11697232779823	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
c230f234-1a4b-4cda-9e1a-a19d99bc2996	2026-09-04 09:37	2026-09-04 09:37	2026-09-04 09:37	IOT	IOT260904C00043000	call	43.0000	2026-09-04	0.7700	0.4000	0.8500	42.2700	57677.00	57677.00	0.00	750	5	812	504	1.61111111111111	2.54079477413723	2.23168165424719	false	false	false	true
abc003e9-474f-427a-a517-027340c4d8b1	2026-09-04 09:43	2026-09-04 09:43	2026-09-04 09:43	IOT	IOT260904C00043000	call	43.0000	2026-09-04	0.3000	0.2500	0.7500	41.4800	22517.00	150.00	22367.00	750	26	1597	504	3.16865079365079	1.890956911339	1.890956911339	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
90c5b2bd-14d9-4c04-970f-d3ce2364d7f6	2026-09-04 11:13	2026-09-04 11:13	2026-09-04 11:13	IOT	IOT261016C00043000	call	43.0000	2026-10-16	1.9400	1.7500	2.1000	40.4631	58180.00	58180.00	0.00	300	6	315	283	1.113074204947	0.529076385623426	0.529076385623426	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