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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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 = TTD×

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

1d3a9fa2-8a4d-4ed8-938e-c89cb32c2d2d	2026-08-31 13:35	2026-08-31 13:35	2026-08-31 13:35	TTD	TTD261120C00025000	call	25.0000	2026-11-20	0.1600	0.1600	0.1800	13.7250	17456.00	0.00	17456.00	1091	31	1099	5053	0.217494557688502	0.787920105437563	0.787920105437563	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	6388770328.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
bd7f62f7-5d03-4ca8-9291-3b12390af6a5	2026-08-31 13:09	2026-08-31 13:08	2026-08-31 13:08	TTD	TTD260918P00013500	put	13.5000	2026-09-18	0.5000	0.4900	0.5000	13.6950	11550.00	11550.00	0.00	231	53	2196	872	2.51834862385321	0.502028713573679	0.502028713573679	false	false	false	true
04d2180f-a2ed-4a17-b0f7-986fefbe32ed	2026-08-31 12:17	2026-08-31 12:17	2026-08-31 12:17	TTD	TTD270319C00020000	call	20.0000	2027-03-19	1.2900	1.2400	1.3000	13.7900	27150.00	27150.00	0.00	210	8	342	9190	0.0372143634385201	0.714051930510812	0.706067438561655	false	false	false	true
023faea4-ff94-4549-8ff0-68d21a69b413	2026-08-31 12:12	2026-08-31 12:12	2026-08-31 12:12	TTD	TTD270917P00012500	put	12.5000	2027-09-17	2.7000	2.6900	2.7000	13.7950	172530.00	172530.00	0.00	639	13	946	1241	0.76228847703465	0.690860875024048	0.690860875024048	false	false	false	true
20d3408f-e24f-4b2a-9df1-e6438223562d	2026-08-31 12:11	2026-08-31 12:10	2026-08-31 12:10	TTD	TTD270319P00012500	put	12.5000	2027-03-19	1.9100	1.9000	1.9400	13.8300	41829.00	6685.00	35144.00	219	6	252	2956	0.0852503382949932	0.694194345345613	0.694194345345613	true	false	false	true
d9c571c2-ba54-4543-9534-2f919f9a4efe	2026-08-28 15:55	2026-08-28 15:55	2026-08-28 15:55	TTD	TTD270319P00012500	put	12.5000	2027-03-19	2.0100	1.9800	2.1500	13.5050	40803.00	36582.00	4221.00	203	10	950	2143	0.443303779748017	0.687694188561104	0.687694188561104	false	false	false	true
f83618c0-67c2-4368-882a-e3e47465d5f4	2026-08-28 12:26	2026-08-28 12:26	2026-08-28 12:26	TTD	TTD280121C00040000	call	40.0000	2028-01-21	0.9100	0.8500	0.9700	13.5650	24752.00	4368.00	20384.00	272	7	289	7811	0.036999103827935	0.697095592601567	0.697095592601567	false	false	false	true
c57726b0-367d-42bb-bade-37158ccd4f1a	2026-08-28 12:14	2026-08-28 12:14	2026-08-28 12:14	TTD	TTD270319P00012500	put	12.5000	2027-03-19	1.9600	1.9500	2.0000	13.6700	65072.00	5684.00	59388.00	332	15	340	2143	0.158656089594027	0.68854313868645	0.68854313868645	false	false	false	true
10963dcd-5753-45ee-8084-ce41f10ce73f	2026-08-28 12:14	2026-08-28 12:14	2026-08-28 12:14	TTD	TTD270319C00025000	call	25.0000	2027-03-19	0.6500	0.6300	0.7000	13.6650	27755.00	2730.00	25025.00	427	15	432	2290	0.188646288209607	0.709606289408127	0.709606289408127	false	false	false	true
562979d7-d366-4a64-ba49-0e9d99e27b34	2026-08-28 12:12	2026-08-28 12:12	2026-08-28 12:12	TTD	TTD260918C00014500	call	14.5000	2026-09-18	0.3700	0.3500	0.3800	13.6700	12099.00	8399.00	1850.00	327	9	596	511	1.16634050880626	0.518696823649933	0.518696823649933	false	false	false	true
4c22a9b7-515d-4bd5-b750-6d6ebdb90f06	2026-08-28 12:12	2026-08-28 12:12	2026-08-28 12:12	TTD	TTD260918P00013500	put	13.5000	2026-09-18	0.5600	0.5400	0.5700	13.6850	23296.00	4928.00	18088.00	416	16	440	312	1.41025641025641	0.509652863027613	0.509652863027613	false	false	false	true
093b33ae-b588-495d-881b-fd81c1f71a5e	2026-08-28 12:12	2026-08-28 12:12	2026-08-28 12:12	TTD	TTD260904P00013500	put	13.5000	2026-09-04	0.2800	0.2600	0.2900	13.6850	14448.00	14392.00	28.00	516	41	1050	429	2.44755244755245	0.492028614802291	0.492028614802291	true	false	false	true
040db3c5-ed2d-4a2b-b5e0-e0715fca6769	2026-08-28 12:01	2026-08-28 12:01	2026-08-28 12:01	TTD	TTD281215P00012500	put	12.5000	2028-12-15	4.0000	3.9000	4.0000	13.0000	84000.00	74400.00	0.00	210	9	210	1481	0.141796083727211	0.705575849709346	0.705575849709346	false	false	false	true
f724b5cd-ff72-42d2-9fa3-d1a00008a189	2026-08-28 11:18	2026-08-28 11:18	2026-08-28 11:18	TTD	TTD280121C00050000	call	50.0000	2028-01-21	0.6400	0.6200	0.6400	13.7050	12863.00	12863.00	0.00	201	6	298	11056	0.0269536903039074	0.713233003332574	0.713233003332574	false	false	false	true
9054ff35-64b0-47cd-9edf-b194f3797b7b	2026-08-28 11:04	2026-08-28 11:04	2026-08-28 11:04	TTD	TTD270617P00010000	put	10.0000	2027-06-17	1.2500	1.2500	1.3400	13.7900	26200.00	0.00	26074.00	209	13	559	1340	0.417164179104478	0.6993843087413	0.696400265749577	false	false	false	true
a655d9f5-5c50-4e24-bc20-3ede32f2e95c	2026-08-28 11:04	2026-08-28 11:04	2026-08-28 11:04	TTD	TTD270617P00010000	put	10.0000	2027-06-17	1.2600	1.2600	1.3400	13.7950	15753.00	127.00	15626.00	125	17	246	1340	0.183582089552239	0.6993843087413	0.699667564492369	false	false	false	true
e0774fa6-4d34-4744-95db-cce3d3850790	2026-08-28 10:34	2026-08-28 10:34	2026-08-28 10:34	TTD	TTD260828C00013500	call	13.5000	2026-08-28	0.2000	0.1700	0.2200	13.6500	10760.00	10760.00	0.00	538	6	4229	12042	0.351187510380335	0.806426223874573	0.806426223874573	false	false	false	true
e08fd7cc-22a5-4b82-b367-50577d0a23db	2026-08-27 14:20	2026-08-27 14:20	2026-08-27 14:20	TTD	TTD260904C00013500	call	13.5000	2026-09-04	0.3800	0.3500	0.3800	13.4300	12008.00	12008.00	0.00	316	15	1143	1158	0.987046632124352	0.514297537913565	0.514297537913565	false	false	false	true
21c34e37-be3f-4760-ab78-0a916efb904a	2026-08-27 14:20	2026-08-27 14:19	2026-08-27 14:19	TTD	TTD270319C00025000	call	25.0000	2027-03-19	0.6100	0.6100	0.6400	13.4150	17568.00	0.00	17568.00	288	19	306	2193	0.13953488372093	0.711246284514282	0.711246284514282	false	false	false	true
1d93463c-afc7-4b6c-8620-da396e4ea8e2	2026-08-27 12:06	2026-08-27 12:06	2026-08-27 12:06	TTD	TTD270115C00015000	call	15.0000	2027-01-15	1.8600	1.8200	1.8600	13.5800	19530.00	19530.00	0.00	105	5	487	5724	0.0850803633822502	0.691232904020523	0.691232904020523	false	false	false	true
79c797b2-3728-4e1d-8538-d91fe677a0fd	2026-08-27 12:05	2026-08-27 12:05	2026-08-27 12:05	TTD	TTD261120P00012500	put	12.5000	2026-11-20	1.2100	1.1800	1.2150	13.6150	21417.00	21417.00	0.00	177	27	233	3421	0.0681087401344636	0.704422974150969	0.704422974150969	true	false	false	true
276c0143-0dd6-443b-aa62-94264f6d61ff	2026-08-27 12:05	2026-08-27 12:05	2026-08-27 12:05	TTD	TTD261120C00015000	call	15.0000	2026-11-20	1.3800	1.3500	1.4200	13.6150	76176.00	74934.00	1242.00	552	48	926	3437	0.269421006691882	0.712874839031593	0.712874839031593	true	false	false	true
3aa052e1-c263-418f-a04e-19daf44c4f92	2026-08-27 12:04	2026-08-27 12:04	2026-08-27 12:04	TTD	TTD260828C00013500	call	13.5000	2026-08-28	0.2200	0.1800	0.2200	13.5800	11044.00	11044.00	0.00	502	15	20279	3005	6.74841930116473	0.623677477954329	0.623677477954329	true	false	false	true
282d715a-2594-4237-8bd8-ccaf5e93bbea	2026-08-27 10:28	2026-08-27 10:28	2026-08-27 10:28	TTD	TTD260828C00013500	call	13.5000	2026-08-28	0.1900	0.1800	0.2000	13.4650	20425.00	0.00	1558.00	1075	15	10979	3005	3.65357737104825	0.733082665473646	0.733082665473646	false	false	false	true
780a1045-d8df-4150-b0a3-f80d3372cf46	2026-08-27 10:16	2026-08-27 10:16	2026-08-27 10:16	TTD	TTD260828C00013500	call	13.5000	2026-08-28	0.2300	0.2300	0.2400	13.5400	11477.00	0.00	11477.00	499	6	5492	3005	1.82762063227953	0.739133959205203	0.739133959205203	false	false	false	true
aa04895c-aa37-49fa-b2b1-ae894d843b19	2026-08-27 10:16	2026-08-27 10:16	2026-08-27 10:16	TTD	TTD260918C00014000	call	14.0000	2026-09-18	0.5000	0.4700	0.5000	13.5450	50000.00	50000.00	0.00	1000	7	1176	2300	0.511304347826087	0.513272673953267	0.513272673953267	true	false	false	true
36958e9c-1cec-4b6c-adca-6e29869c7757	2026-08-27 10:14	2026-08-27 10:14	2026-08-27 10:14	TTD	TTD260828C00013500	call	13.5000	2026-08-28	0.1900	0.1400	0.2100	13.4579	22798.00	22798.00	0.00	1200	24	2332	3005	0.77603993344426	0.76696456830609	0.709556522277646	true	false	false	true
8e1f5031-4d94-40c4-8daf-12083585699f	2026-08-27 09:45	2026-08-27 09:45	2026-08-27 09:45	TTD	TTD260911C00013500	call	13.5000	2026-09-11	0.5400	0.4400	0.5700	13.5250	20574.00	4212.00	8964.00	381	15	526	1144	0.45979020979021	0.473313585877347	0.473313585877347	false	false	false	true
46f3519a-3f59-4317-adc3-c104677f526b	2026-08-26 15:59	2026-08-26 15:59	2026-08-26 15:59	TTD	TTD260918C00013500	call	13.5000	2026-09-18	0.4900	0.4700	0.4900	13.0250	14700.00	14700.00	0.00	300	5	450	358	1.25698324022346	0.519735586680088	0.519735586680088	false	false	false	true
a8f37920-b89b-4f49-8d90-ec076abc2261	2026-08-26 15:34	2026-08-26 15:34	2026-08-26 15:34	TTD	TTD270115C00015000	call	15.0000	2027-01-15	1.6200	1.5900	1.6300	13.0700	16242.00	11573.00	0.00	100	15	587	5385	0.109006499535747	0.6954240279154	0.688530187248435	false	false	false	true
9bd03eb6-6364-48c9-bcb9-c2ed319137da	2026-08-26 15:02	2026-08-26 15:02	2026-08-26 15:02	TTD	TTD270917P00012500	put	12.5000	2027-09-17	2.9400	2.9300	2.9400	13.0850	88200.00	88200.00	0.00	300	6	414	778	0.532133676092545	0.690017053572388	0.690017053572388	false	false	false	true
e0851f18-7a05-46ee-9301-241e7ecea8d8	2026-08-26 15:01	2026-08-26 15:01	2026-08-26 15:01	TTD	TTD260918P00012500	put	12.5000	2026-09-18	0.4000	0.3700	0.4000	13.0950	16880.00	16880.00	0.00	422	7	510	17867	0.0285442435775452	0.520968824564462	0.520968824564462	false	false	false	true
755859b9-a4f1-4d46-b9e8-96d018876530	2026-08-26 14:59	2026-08-26 14:59	2026-08-26 14:59	TTD	TTD261120C00025000	call	25.0000	2026-11-20	0.1400	0.1400	0.1500	13.0950	30058.00	0.00	30058.00	2147	14	2179	2846	0.765635980323261	0.794496018712152	0.794496018712152	false	false	false	true
41eb2312-02df-41ff-a346-0187eeea55c4	2026-08-26 11:15	2026-08-26 11:15	2026-08-26 11:15	TTD	TTD270115C00015000	call	15.0000	2027-01-15	1.6200	1.6000	1.6200	13.1050	20250.00	20250.00	0.00	125	16	208	5385	0.0386258124419684	0.686513049353993	0.686513049353993	false	false	false	true
14af922d-e103-436b-b2dd-aa2cd9111302	2026-08-25 15:53	2026-08-25 15:53	2026-08-25 15:53	TTD	TTD280121C00042500	call	42.5000	2028-01-21	0.7000	0.6300	0.7600	13.2050	28000.00	12040.00	15960.00	400	6	400	3074	0.130123617436565	0.68567162813788	0.685243491452939	false	false	false	true
68bb64bb-03d9-419a-9179-c3f55b7e17df	2026-08-25 15:32	2026-08-25 15:32	2026-08-25 15:32	TTD	TTD261218C00015000	call	15.0000	2026-12-18	1.4400	1.4200	1.4400	13.2150	17424.00	17424.00	0.00	121	11	537	1918	0.279979144942649	0.688914326411803	0.688914326411803	false	false	false	true
7bc52e92-2a10-4732-a64c-fb1ff3647514	2026-08-25 15:32	2026-08-25 15:32	2026-08-25 15:32	TTD	TTD261218P00012500	put	12.5000	2026-12-18	1.5400	1.5200	1.5400	13.2250	39116.00	39116.00	0.00	254	35	350	2453	0.142682429677945	0.684615033945153	0.684615033945153	false	false	false	true
e45bf401-1315-4b82-b592-ce5add563ce0	2026-08-25 15:29	2026-08-25 15:29	2026-08-25 15:29	TTD	TTD261016C00015000	call	15.0000	2026-10-16	0.5200	0.5200	0.5400	13.2250	20800.00	0.00	20800.00	400	33	755	7716	0.0978486262312079	0.55780220224479	0.55780220224479	true	false	false	true
74b45b05-f3c4-4db0-b3e5-12db92716c41	2026-08-25 15:08	2026-08-25 15:07	2026-08-25 15:07	TTD	TTD261120C00025000	call	25.0000	2026-11-20	0.1400	0.1400	0.1500	13.1799	10192.00	0.00	10192.00	728	16	750	2187	0.342935528120713	0.782506267703017	0.782506267703017	false	false	false	true
a78c2591-6523-40da-bbd0-a9560dc084bf	2026-08-25 12:22	2026-08-25 12:21	2026-08-25 12:21	TTD	TTD270115C00020000	call	20.0000	2027-01-15	0.6700	0.6400	0.6700	13.1300	10050.00	10050.00	0.00	150	8	270	8452	0.0319451017510648	0.701685390104797	0.701685390104797	false	false	false	true
7d4faff3-815e-43df-bf9d-5a4d33761ee3	2026-08-25 10:30	2026-08-25 10:30	2026-08-25 10:30	TTD	TTD270115P00010000	put	10.0000	2027-01-15	0.7100	0.7100	0.7200	13.3200	10579.00	0.00	10579.00	149	12	300	1849	0.162249864791779	0.695574737762913	0.695574737762913	false	false	false	true
788042d7-b439-4377-bd5e-6c750aba38a7	2026-08-24 15:32	2026-08-24 15:32	2026-08-24 15:32	TTD	TTD261120P00012500	put	12.5000	2026-11-20	1.3200	1.2900	1.3200	13.3450	19404.00	19404.00	0.00	147	18	425	3127	0.135913015669971	0.701830934412088	0.701830934412088	false	false	false	true
f5924685-364a-4a76-b6b8-4a4ae00b197d	2026-08-24 15:32	2026-08-24 15:32	2026-08-24 15:32	TTD	TTD261120C00015000	call	15.0000	2026-11-20	1.2700	1.2400	1.2700	13.3301	24384.00	24384.00	0.00	192	28	926	2343	0.395219803670508	0.706792501707838	0.706792501707838	false	false	false	true
66752ed5-f5df-4f72-8f07-a6f22013594a	2026-08-24 14:10	2026-08-24 14:10	2026-08-24 14:10	TTD	TTD261218C00020000	call	20.0000	2026-12-18	0.5200	0.5100	0.5400	13.2500	14092.00	2652.00	11440.00	271	29	444	2273	0.195336559612846	0.703031734749356	0.703031734749356	false	false	false	true
85795f68-e080-463a-95b6-e2938a425d30	2026-08-24 14:08	2026-08-24 14:08	2026-08-24 14:08	TTD	TTD261218C00017500	call	17.5000	2026-12-18	0.8500	0.8500	0.8800	13.2550	18700.00	0.00	18700.00	220	30	248	1659	0.149487643158529	0.687160654748584	0.687160654748584	false	false	false	true
aac4c687-3873-4367-894a-cb4ffbbb065a	2026-08-24 12:56	2026-08-24 12:55	2026-08-24 12:55	TTD	TTD260918P00012500	put	12.5000	2026-09-18	0.3500	0.3400	0.3600	13.3700	14665.00	12915.00	1750.00	419	12	512	16937	0.0302296746767432	0.527397049842406	0.528592765499549	false	false	false	true
f877423c-7a12-4121-8479-7fbf93e858bf	2026-08-24 10:12	2026-08-24 10:12	2026-08-24 10:12	TTD	TTD260828C00013000	call	13.0000	2026-08-28	0.4900	0.4900	0.5300	13.3100	10633.00	0.00	10633.00	217	6	429	1024	0.4189453125	0.55874338189012	0.55874338189012	false	false	false	true
3e5f38c2-7dfb-4db8-a643-f1fe4df94468	2026-08-24 09:44	2026-08-24 09:44	2026-08-24 09:44	TTD	TTD261120C00015000	call	15.0000	2026-11-20	1.2200	1.2200	1.2600	13.2304	15128.00	0.00	15128.00	124	11	134	2343	0.0571916346564234	0.704403779670163	0.704403779670163	true	false	false	true
41dd004a-7a85-4b42-998f-bd20783caf68	2026-08-21 15:34	2026-08-21 15:33	2026-08-21 15:33	TTD	TTD270115C00015000	call	15.0000	2027-01-15	1.6800	1.6800	1.7000	13.1450	31796.00	3740.00	28056.00	189	13	546	5221	0.10457766711358	0.686371921755376	0.686371921755376	false	false	false	true
5b1e4e2e-30bf-476b-9344-af310ed12228	2026-08-21 15:30	2026-08-21 15:30	2026-08-21 15:30	TTD	TTD280121C00020000	call	20.0000	2028-01-21	2.6500	2.6400	2.6700	13.1750	13250.00	9805.00	3445.00	50	6	333	11250	0.0296	0.679565396818584	0.679565396818584	false	false	false	true