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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×ticker = DIA×

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

6d74c31e-6683-471a-aff9-046ccb22584c	2026-08-21 10:14	2026-08-21 10:14	2026-08-21 10:14	DIA	DIA260904C00533000	call	533.0000	2026-09-04	4.2000	4.1000	4.2000	530.7500	46620.00	46620.00	0.00	111	12	113	54	2.09259259259259	0.118261902444159	0.118040382174864	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	45734349245.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
de16ed4f-4552-4c1a-916b-f58363839dbe	2026-08-21 10:06	2026-08-21 10:06	2026-08-21 10:06	DIA	DIA260904P00511000	put	511.0000	2026-09-04	0.7500	0.6800	0.7500	530.6700	27673.00	27599.00	74.00	369	45	370	30	12.3333333333333	0.156721540245163	0.156069325823844	false	false	false	true
debf2e0f-13cd-4492-9f4a-a36ef872f603	2026-08-21 09:57	2026-08-21 09:57	2026-08-21 09:57	DIA	DIA281215C00700000	call	700.0000	2028-12-15	12.0000	10.0000	12.0000	530.4050	24000.00	24000.00	0.00	20	20	20	117	0.170940170940171	0.132990462846292	0.132990462846292	false	false	false	true
fc3d5038-7a1a-4da2-a9fc-c5736f3cffca	2026-08-21 09:47	2026-08-21 09:47	2026-08-21 09:47	DIA	DIA260904P00512000	put	512.0000	2026-09-04	0.8500	0.7600	0.8500	530.3200	15045.00	15045.00	0.00	177	31	177	424	0.417452830188679	0.153687595806192	0.153687595806192	false	false	false	true
1f7d27c1-5070-4c86-a1f8-5cc096a82ce7	2026-08-21 09:37	2026-08-21 09:37	2026-08-21 09:37	DIA	DIA260828C00527500	call	527.5000	2026-08-28	5.3000	5.2000	5.3000	529.8600	11130.00	11130.00	0.00	21	5	50	178	0.280898876404494	0.129122005264222	0.129122005264222	false	false	false	true
7f548952-95f1-4567-9b1e-392c83ccd58e	2026-08-21 09:34	2026-08-21 09:34	2026-08-21 09:34	DIA	DIA260828C00527000	call	527.0000	2026-08-28	5.4500	5.3000	5.4500	529.5700	35423.00	35423.00	0.00	65	13	66	72	0.916666666666667	0.129950651356543	0.129950651356543	false	false	false	true
0952d349-6317-4f40-b990-26ccdf26829d	2026-08-21 09:31	2026-08-21 09:31	2026-08-21 09:31	DIA	DIA260828C00530000	call	530.0000	2026-08-28	3.7000	3.6000	3.8500	529.8850	17760.00	0.00	12210.00	48	6	79	460	0.171739130434783	0.121734621020075	0.121734621020075	false	false	false	true
a74f0f11-79aa-454f-a608-32a56dbe2076	2026-08-21 09:31	2026-08-21 09:30	2026-08-21 09:30	DIA	DIA260828C00540000	call	540.0000	2026-08-28	0.4800	0.4800	0.5700	529.8100	16800.00	0.00	16800.00	350	7	352	2428	0.14497528830313	0.111767643248643	0.111767643248643	false	false	false	true
6895c1e5-04e0-490a-af0d-a9f286c93c4c	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	DIA	DIA260828C00529000	call	529.0000	2026-08-28	4.1500	4.1000	4.2500	529.7700	22825.00	415.00	22410.00	55	17	57	121	0.471074380165289	0.121163689733603	0.121163689733603	true	false	false	true
9e95e4e2-2d4c-4f7f-b5e2-040c62ac3238	2026-08-20 16:08	2026-08-20 16:07	2026-08-20 16:07	DIA	DIA260918P00510000	put	510.0000	2026-09-18	2.6500	2.5200	2.7100	527.4600	119250.00	119250.00	0.00	450	11	1295	5350	0.242056074766355	0.157735403497573	0.157735403497573	false	false	false	true
963be2ac-2a62-4fc1-9760-f363aa3670f2	2026-08-20 16:03	2026-08-20 16:02	2026-08-20 16:02	DIA	DIA260828P00525000	put	525.0000	2026-08-28	2.8700	2.7300	2.9200	527.5300	11480.00	11480.00	0.00	40	5	439	1485	0.295622895622896	0.134731006192936	0.134731006192936	false	false	false	true
20c49550-7af4-4d6a-81a8-898f4a1b8aab	2026-08-20 15:59	2026-08-20 15:59	2026-08-20 15:59	DIA	DIA260918P00510000	put	510.0000	2026-09-18	2.6800	2.4800	2.6800	527.6200	92996.00	92996.00	0.00	347	6	742	5350	0.138691588785047	0.159225567928411	0.159225567928411	false	false	false	true
6ba704c7-423e-470d-bf17-7b289a20f663	2026-08-20 15:50	2026-08-20 15:50	2026-08-20 15:50	DIA	DIA260925C00529000	call	529.0000	2026-09-25	8.1000	7.9500	8.1000	527.9000	12960.00	12960.00	0.00	16	9	101	0	0	0.115922552411564	0.115763348002099	false	false	false	true
1115b53a-f22b-4044-b374-aadd11142114	2026-08-20 15:49	2026-08-20 15:49	2026-08-20 15:49	DIA	DIA260828P00525000	put	525.0000	2026-08-28	2.6600	2.6600	2.7200	527.8100	11172.00	0.00	11172.00	42	6	396	1485	0.266666666666667	0.131354696990062	0.131228899083506	false	false	false	true
85cf071e-e85c-4f8d-8fb4-6fe28c94b970	2026-08-20 15:49	2026-08-20 15:49	2026-08-20 15:49	DIA	DIA260904C00530000	call	530.0000	2026-09-04	4.4500	4.3500	4.4500	527.7800	10235.00	10235.00	0.00	23	10	597	112	5.33035714285714	0.119780683233681	0.119780683233681	false	false	false	true
3d922960-523f-4ca4-ad70-db6991ce7ac1	2026-08-20 15:39	2026-08-20 15:39	2026-08-20 15:39	DIA	DIA260821P00533000	put	533.0000	2026-08-21	5.4100	5.3000	5.6500	527.8100	175775.00	550.00	37800.00	325	5	546	1136	0.480633802816901	0.175367723514928	0.167279860269098	false	false	false	true
a26c1337-a566-4dcc-adce-d58300f4736a	2026-08-20 15:39	2026-08-20 15:39	2026-08-20 15:39	DIA	DIA260930P00535000	put	535.0000	2026-09-30	12.0800	11.3500	12.7000	527.8510	12076.00	12076.00	0.00	10	5	27	109	0.247706422018349	0.13328345956393	0.13328345956393	false	false	false	true
845a4952-26c0-431a-aed6-ced9af2f04fd	2026-08-20 15:28	2026-08-20 15:28	2026-08-20 15:28	DIA	DIA260828C00530000	call	530.0000	2026-08-28	2.8900	2.8200	2.9500	527.9300	22573.00	15637.00	6936.00	78	7	343	90	3.81111111111111	0.116821772934956	0.117147129691226	false	false	false	true
5715002d-abe7-4632-abf5-83f40f64e538	2026-08-20 15:26	2026-08-20 15:26	2026-08-20 15:26	DIA	DIA260821C00530000	call	530.0000	2026-08-21	0.5200	0.4800	0.5200	528.0100	10556.00	10556.00	0.00	203	11	3432	1471	2.33310673011557	0.113875926533031	0.113875926533031	false	false	false	true
4b2ecea2-c4a7-492b-a8c2-9f4c0ed8316a	2026-08-20 15:16	2026-08-20 15:16	2026-08-20 15:16	DIA	DIA260828P00527000	put	527.0000	2026-08-28	3.2500	3.2500	3.3500	528.1500	30225.00	0.00	30225.00	93	15	154	551	0.279491833030853	0.128049350868715	0.1281902855503	false	false	false	true
16d287f4-6ba3-428f-9c73-6caae4039542	2026-08-20 15:14	2026-08-20 15:14	2026-08-20 15:14	DIA	DIA260828P00526000	put	526.0000	2026-08-28	2.9700	2.9700	3.0500	527.9350	12771.00	0.00	12771.00	43	8	108	173	0.624277456647399	0.130013343656856	0.130013343656856	false	false	false	true
126b71e5-f394-410a-a717-bab3ead67f09	2026-08-20 15:10	2026-08-20 15:09	2026-08-20 15:09	DIA	DIA261120C00525000	call	525.0000	2026-11-20	18.6800	18.4500	18.7500	527.9100	37354.00	37354.00	0.00	20	8	42	0	0	0.136151551010757	0.136151551010757	false	false	false	true
7ad595b1-772a-4f29-b3fb-8a747d1da098	2026-08-20 15:00	2026-08-20 15:00	2026-08-20 15:00	DIA	DIA261218P00528000	put	528.0000	2026-12-18	15.6500	15.4500	15.6500	527.7300	17215.00	17215.00	0.00	11	8	12	1	12	0.155792800121463	0.155792800121463	false	false	false	true
765e9b1b-13ae-45c4-bd2e-2a722430570b	2026-08-20 15:00	2026-08-20 14:59	2026-08-20 14:59	DIA	DIA261218P00529000	put	529.0000	2026-12-18	16.0500	15.8500	16.0500	527.7300	17655.00	17655.00	0.00	11	8	16	4	4	0.155276949002576	0.155276949002576	false	false	false	true	false
411296c5-d3db-42d0-a5de-26cdfd5648ad	2026-08-20 14:42	2026-08-20 14:42	2026-08-20 14:42	DIA	DIA270319P00515000	put	515.0000	2027-03-19	16.2600	14.2500	16.9000	528.0200	92705.00	91075.00	1630.00	57	11	57	31	1.83870967741935	0.172135801172609	0.171792905070495	false	false	false	true
8986126f-9076-4aed-ae34-1ba997b8c870	2026-08-20 14:21	2026-08-20 14:21	2026-08-20 14:21	DIA	DIA270630C00680000	call	680.0000	2027-06-30	1.2300	1.1100	1.5200	528.2347	12423.00	123.00	12300.00	101	8	101	434	0.232718894009217	0.1353207342259	0.1353207342259	false	false	false	true
46819eb3-bf2b-4167-b65a-c029e70bf62f	2026-08-20 14:16	2026-08-20 14:16	2026-08-20 14:16	DIA	DIA260930P00512000	put	512.0000	2026-09-30	3.9500	3.8500	3.9500	528.0550	10665.00	10665.00	0.00	27	5	29	4	7.25	0.154011374764415	0.154011374764415	false	false	false	true	false
040a2c04-c0f3-4c8a-a0b5-a2e8e735a1dc	2026-08-20 14:06	2026-08-20 14:06	2026-08-20 14:06	DIA	DIA260828P00525000	put	525.0000	2026-08-28	2.4600	2.4600	2.4900	528.3800	12300.00	0.00	12300.00	50	5	149	1485	0.1003367003367	0.131435464684679	0.131435464684679	false	false	false	true
37ab0095-6d54-490d-bb10-a48758064a18	2026-08-20 14:02	2026-08-20 14:02	2026-08-20 14:02	DIA	DIA270115C00530000	call	530.0000	2027-01-15	21.8600	21.3500	23.9500	528.6300	133329.00	2195.00	131134.00	61	16	61	1944	0.0313786008230453	0.132220455752225	0.136626002622307	false	false	false	true
cc3a6f05-a0d1-4cff-802e-9d3d07a5eb26	2026-08-20 14:00	2026-08-20 14:00	2026-08-20 14:00	DIA	DIA260911C00543000	call	543.0000	2026-09-11	1.2900	1.2900	1.3600	528.6400	16256.00	130.00	16126.00	126	25	140	2	70	0.105811197666413	0.105916068039412	false	false	false	true
6a29b6f7-3b2d-42cf-aeac-b5612743713b	2026-08-20 14:00	2026-08-20 14:00	2026-08-20 14:00	DIA	DIA260911C00544000	call	544.0000	2026-09-11	1.1200	1.1200	1.1900	528.6400	12096.00	0.00	12096.00	108	17	132	12	11	0.105507316297803	0.105608152200721	false	false	false	true
485a4c90-15fa-4acc-8ee2-6522d5633f21	2026-08-20 13:26	2026-08-20 13:25	2026-08-20 13:25	DIA	DIA260828P00538000	put	538.0000	2026-08-28	9.5000	8.0500	9.5000	529.2300	39900.00	39900.00	0.00	42	5	77	327	0.235474006116208	0.128415978426612	0.128415978426612	false	false	false	true
45041469-72e1-48a8-8539-4c02eee45b8b	2026-08-20 13:08	2026-08-20 13:08	2026-08-20 13:08	DIA	DIA260828C00540000	call	540.0000	2026-08-28	0.5000	0.4900	0.5500	529.7950	10100.00	0.00	10100.00	202	21	696	1433	0.48569434752268	0.105535199775353	0.105535199775353	false	false	false	true
b050ff58-1c51-4492-80cb-a463551a3e52	2026-08-20 13:01	2026-08-20 13:01	2026-08-20 13:01	DIA	DIA260828C00543000	call	543.0000	2026-08-28	0.2500	0.2400	0.2900	530.1100	29375.00	1050.00	28025.00	1175	27	1192	259	4.6023166023166	0.10513391220367	0.10513391220367	false	false	false	true
c5835701-0169-4a4a-90a4-183ad264446f	2026-08-20 12:37	2026-08-20 12:37	2026-08-20 12:37	DIA	DIA261218C00543000	call	543.0000	2026-12-18	12.9500	12.8000	12.9500	530.0900	10360.00	10360.00	0.00	8	7	34	3	11.3333333333333	0.129440096889102	0.129440096889102	false	false	false	true
e5d5ab23-969e-4ae3-98fe-2b641797e3a2	2026-08-20 12:20	2026-08-20 12:20	2026-08-20 12:20	DIA	DIA260821C00532000	call	532.0000	2026-08-21	0.4800	0.4600	0.5200	529.6900	54432.00	0.00	54432.00	1134	6	2680	178	15.0561797752809	0.11820910643825	0.11820910643825	false	false	false	true
b1578094-83cb-4ff7-bb6f-ae77debb474c	2026-08-20 12:02	2026-08-20 12:02	2026-08-20 12:02	DIA	DIA260821C00531000	call	531.0000	2026-08-21	0.7500	0.7500	0.8200	529.5400	82200.00	0.00	82200.00	1096	22	2766	61	45.344262295082	0.120727418655871	0.120727418655871	false	false	false	true
6ac9d96f-7d96-4721-be75-7d2053684677	2026-08-20 11:53	2026-08-20 11:53	2026-08-20 11:53	DIA	DIA260821P00530000	put	530.0000	2026-08-21	1.7100	1.7000	1.7600	529.8700	169290.00	0.00	169290.00	990	5	3021	2023	1.49332674246169	0.151112239370906	0.151112239370906	false	false	false	true
3ceefda3-d48c-4381-bc87-03f7538783a1	2026-08-20 11:50	2026-08-20 11:49	2026-08-20 11:49	DIA	DIA271217C00500000	call	500.0000	2027-12-17	72.2000	69.5000	74.5000	529.8200	209380.00	101080.00	28880.00	29	17	58	919	0.0631120783460283	0.161240618273354	0.161240618273354	false	false	false	true
f36de694-e57b-4832-9e56-62709d6e4016	2026-08-20 11:34	2026-08-20 11:34	2026-08-20 11:34	DIA	DIA261218P00533000	put	533.0000	2026-12-18	16.7000	16.5000	16.8000	530.3400	21710.00	21710.00	0.00	13	10	19	3	6.33333333333333	0.154600655156156	0.154600655156156	false	false	false	true
0b1ceccb-5bc0-4531-b9bf-4e81d3ceae3a	2026-08-20 11:28	2026-08-20 11:28	2026-08-20 11:28	DIA	DIA261218C00543000	call	543.0000	2026-12-18	13.4000	13.2000	13.5000	530.8050	22780.00	22780.00	0.00	17	8	25	3	8.33333333333333	0.130455516222809	0.130455516222809	false	false	false	true
4d526f66-7ffc-4557-8dd6-56c491c59161	2026-08-20 11:08	2026-08-20 11:08	2026-08-20 11:08	DIA	DIA261218P00537000	put	537.0000	2026-12-18	18.1500	17.9500	18.1500	531.2800	34485.00	34485.00	0.00	19	12	26	104	0.25	0.153984303215626	0.153984303215626	false	false	false	true
263a8fd8-ed89-4263-a591-11ded8850acc	2026-08-20 11:03	2026-08-20 11:03	2026-08-20 11:03	DIA	DIA260904P00532500	put	532.5000	2026-09-04	5.5500	5.3000	5.5500	531.5250	19425.00	19425.00	0.00	35	7	45	41	1.09756097560976	0.127335823160432	0.127335823160432	false	false	false	true
e0dfbc45-be8a-439c-90c9-123c0450b276	2026-08-20 10:51	2026-08-20 10:51	2026-08-20 10:51	DIA	DIA260918P00531000	put	531.0000	2026-09-18	7.2000	7.2000	7.3500	530.8600	38160.00	0.00	38160.00	53	14	65	54	1.2037037037037	0.132576271382948	0.132576271382948	false	false	false	true
46a73c27-e1f4-49fc-9257-bb4d337a71f8	2026-08-20 10:51	2026-08-20 10:51	2026-08-20 10:51	DIA	DIA260918P00532000	put	532.0000	2026-09-18	7.6500	7.6500	7.8000	530.8600	68850.00	0.00	68850.00	90	20	92	121	0.760330578512397	0.13195793139117	0.13195793139117	false	false	false	true
b0d9b2b3-a30e-4515-b573-15938b41a597	2026-08-20 10:21	2026-08-20 10:21	2026-08-20 10:21	DIA	DIA260911C00530000	call	530.0000	2026-09-11	6.8000	6.7000	6.9000	530.0400	10880.00	4080.00	2040.00	16	5	78	13	6	0.118773882255159	0.118773882255159	false	false	false	true
9fb6b1db-980a-4047-8901-f9a828da176b	2026-08-20 10:21	2026-08-20 10:21	2026-08-20 10:21	DIA	DIA271217C00500000	call	500.0000	2027-12-17	72.5000	70.0000	75.0000	530.0800	210250.00	0.00	130500.00	29	17	29	919	0.0315560391730141	0.161780464936985	0.161780464936985	false	false	false	true
a710c1ac-befb-4c0e-b7c0-8cf1f8dea8af	2026-08-20 10:07	2026-08-20 10:07	2026-08-20 10:07	DIA	DIA260828P00550000	put	550.0000	2026-08-28	19.9000	17.9000	19.9000	530.4800	35820.00	35820.00	0.00	18	6	50	108	0.462962962962963	0.195031939526022	0.195031939526022	false	false	false	true
f99bf5d2-5b8a-4cba-bea2-7b4b053d5b6e	2026-08-20 10:07	2026-08-20 10:07	2026-08-20 10:07	DIA	DIA260828P00550000	put	550.0000	2026-08-28	19.9000	17.9000	19.9000	530.3550	39800.00	39800.00	0.00	20	11	32	108	0.296296296296296	0.187377520885179	0.187377520885179	false	false	false	true
a1dc0a79-6f39-4862-94d6-15328f9568ae	2026-08-20 10:06	2026-08-20 10:06	2026-08-20 10:06	DIA	DIA260821P00530000	put	530.0000	2026-08-21	1.5400	1.5100	1.5700	530.5900	10010.00	0.00	4312.00	65	6	1385	2023	0.684626791893228	0.166576198012545	0.166576198012545	false	false	false	true