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.

708,051 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts708,051 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 = SPXW×

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

7ee17a33-dcd7-478d-ad62-2d4036e6d311	2026-10-02 15:47	2026-10-02 15:47	2026-10-02 15:47	SPXW	SPXW261002C07730000	call	7730.0000	2026-10-02	2.2000	2.1500	2.2500	7705.0000	11220.00	2860.00	0.00	51	12	151286	2310	65.4917748917749	0.193582686227418	0.193582686227418	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T19:49:29.839373Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
63fb2e3f-f0cd-42ca-8ea9-895b99716aca	2026-10-02 15:47	2026-10-02 15:47	2026-10-02 15:47	SPXW	SPXW261002C07730000	call	7730.0000	2026-10-02	2.2300	2.1500	2.2500	7705.0000	16965.00	11700.00	1085.00	76	16	151203	2310	65.4558441558442	0.193325214081998	0.196716793000903	false	false	false
e1f8485c-d55b-40f7-9acd-556686877d20	2026-10-02 15:47	2026-10-02 15:47	2026-10-02 15:47	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	8.4000	8.3000	8.7000	7705.0000	35280.00	9240.00	26040.00	42	9	123620	2945	41.9762308998302	0.170275288886746	0.170275288886746	false	false	false
d0046777-062c-4d71-9579-4ba9a7e25a81	2026-10-02 15:47	2026-10-02 15:47	2026-10-02 15:47	SPXW	SPXW261002C07710000	call	7710.0000	2026-10-02	18.2000	18.1000	18.4000	7705.0000	18200.00	0.00	18200.00	10	5	32879	2735	12.0215722120658	0.159422416321527	0.159422416321527	false	false	false
888b9a35-fb5a-4d9b-9dcc-32ba44517619	2026-10-02 15:47	2026-10-02 15:47	2026-10-02 15:47	SPXW	SPXW261002C07730000	call	7730.0000	2026-10-02	2.1600	2.1000	2.2000	7705.0000	15745.00	15745.00	0.00	73	13	150622	2310	65.204329004329	0.19796866608828	0.201486044657465	false	false	false
f2d51914-923d-40c8-af07-68e45a6e3885	2026-10-02 15:47	2026-10-02 15:47	2026-10-02 15:47	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	4.2600	4.2000	4.4000	7705.0000	14470.00	7750.00	6720.00	34	9	163026	4450	36.6350561797753	0.187828027423804	0.175424050379914	false	false	false
8af31550-e83a-4347-8d11-d76eb07d8498	2026-10-02 15:47	2026-10-02 15:47	2026-10-02 15:47	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	4.5000	4.4000	4.5000	7705.0000	15740.00	15300.00	440.00	35	14	163070	4450	36.6449438202247	0.19641414584543	0.196541100385629	false	false	false
24016fe7-42e9-4c6f-a3d7-7fb812af4136	2026-10-02 15:47	2026-10-02 15:47	2026-10-02 15:47	SPXW	SPXW261002C07730000	call	7730.0000	2026-10-02	2.0000	1.9000	2.0500	7705.0000	14000.00	13415.00	385.00	70	42	150260	2310	65.0476190476191	0.19188302149826	0.196418416622657	false	false	false
8cc3fe33-9922-49fa-b9d2-d78ac3ba5071	2026-10-02 15:47	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261005C07725000	call	7725.0000	2026-10-05	21.4000	21.3000	21.6000	7705.0000	53500.00	0.00	53500.00	25	8	4952	734	6.74659400544959	0.068149183848255	0.068149183848255	false	false	false
fd2a6ef8-a08a-418b-a2d1-d1980ba537b5	2026-10-02 15:46	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261002C07730000	call	7730.0000	2026-10-02	1.6700	1.6000	1.7500	7705.0000	15530.00	1540.00	13990.00	93	27	149720	2310	64.8138528138528	0.184223529129478	0.187837638154666	false	false	false
e785a79e-7765-43e2-9597-0c4248b476bb	2026-10-02 15:46	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261002C07710000	call	7710.0000	2026-10-02	17.3000	17.0000	17.3000	7705.0000	17300.00	17300.00	0.00	10	6	32837	2735	12.0062157221207	0.226440462783038	0.226440462783038	false	false	false
affce9df-e7fe-4da2-b565-4756dad7c0cb	2026-10-02 15:46	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261002P07725000	put	7725.0000	2026-10-02	2.1400	2.0000	2.2000	7705.0000	10895.00	440.00	3830.00	51	13	99000	2308	42.894280762565	0.204610197950284	0.194519660482347	false	false	false
7f55bb56-e7e3-4b11-ad17-901e0e413ed9	2026-10-02 15:46	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	7.8000	7.7000	8.0000	7705.0000	22620.00	0.00	11700.00	29	7	123142	2945	41.813921901528	0.182343748908755	0.182343748908755	false	false	false
437d8a62-e187-4196-b4b4-345bc1ce604e	2026-10-02 15:46	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261007P07465000	put	7465.0000	2026-10-07	1.0000	0.9000	1.0500	7705.0000	10000.00	9500.00	500.00	100	8	200	292	0.684931506849315	0.147052924314189	0.147052924314189	false	false	false
348502ec-c07c-4d32-9eca-76d2b1726422	2026-10-02 15:46	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	4.1000	4.1000	4.2000	7705.0000	10250.00	0.00	10250.00	25	6	162683	4450	36.5579775280899	0.18375536706515	0.18375536706515	false	false	false
dba6f8c2-a98f-4944-93ca-776dfb647e21	2026-10-02 15:46	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261007P07475000	put	7475.0000	2026-10-07	1.1000	1.0000	1.1000	7705.0000	11000.00	11000.00	0.00	100	8	336	1373	0.244719592134013	0.144449953948964	0.144449953948964	false	false	false
5f09396e-605a-4f66-8913-c31e2c9ec7bb	2026-10-02 15:46	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261002P07725000	put	7725.0000	2026-10-02	2.0100	2.0000	2.1000	7705.0000	19070.00	0.00	19070.00	95	20	98815	2308	42.8141247833622	0.194326050737513	0.19096741323393	false	false	false
986b3048-b097-446a-a7f9-959d49b47cb7	2026-10-02 15:46	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261002C07730000	call	7730.0000	2026-10-02	1.8000	1.7500	1.8000	7705.0000	15120.00	15120.00	0.00	84	21	149361	2310	64.6584415584416	0.192241209490935	0.192241209490935	false	false	false
5c3678d0-6c1e-4300-862a-2d7ba6f647ba	2026-10-02 15:46	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261002P07735000	put	7735.0000	2026-10-02	8.6600	8.6000	8.9000	7705.0000	19050.00	0.00	19050.00	22	6	41698	711	58.6469760900141	0.2220430752686	0.2220430752686	false	false	false	true
2f3b45d5-b06c-401f-837e-2b553d6e3a24	2026-10-02 15:46	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	4.0000	3.9000	4.0000	7705.0000	12800.00	12800.00	0.00	32	11	162319	4450	36.4761797752809	0.200046823508331	0.200046823508331	false	false	false
b5d56098-cb1a-4184-a797-ff60e9e880ff	2026-10-02 15:46	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	7.2700	7.1000	7.4000	7705.0000	13080.00	4400.00	4300.00	18	11	122980	2945	41.7589134125637	0.202095641226613	0.210454355264412	false	false	false
f46d07e2-a720-4ee9-914c-b30ef447c3b7	2026-10-02 15:46	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	3.5000	3.4000	3.5000	7705.0000	12950.00	12950.00	0.00	37	14	162052	4450	36.4161797752809	0.190457970659471	0.190457970659471	false	false	false
e821e4fc-5c24-4fb7-a3fe-6d7174931902	2026-10-02 15:46	2026-10-02 15:46	2026-10-02 15:46	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	3.4000	3.3000	3.4000	7705.0000	23790.00	23460.00	330.00	70	17	162004	4450	36.405393258427	0.183186466165193	0.189525260479523	false	false	false
936fb180-7f3f-4e8b-8b51-515fa3d53e13	2026-10-02 15:46	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002P07725000	put	7725.0000	2026-10-02	2.5000	2.4500	2.5500	7705.0000	31750.00	0.00	30500.00	127	25	98132	2308	42.5181975736568	0.175888354637751	0.175888354637751	false	false	false
8e578dcd-0244-495d-8639-6f3d4a0c97b4	2026-10-02 15:46	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	3.3400	3.2000	3.5000	7705.0000	28020.00	27010.00	340.00	84	25	161817	4450	36.3633707865169	0.186050511130467	0.198622906878471	false	false	false
6526c202-bcb0-4afa-9c9e-f71e1db09355	2026-10-02 15:46	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	3.5000	3.4000	3.5000	7705.0000	15390.00	15050.00	340.00	44	10	161862	4450	36.3734831460674	0.192337416647805	0.198622906878471	false	false	false
7b333677-a3fa-443d-a2d6-d75efadeba88	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002P07735000	put	7735.0000	2026-10-02	10.1000	9.9000	10.2000	7705.0000	22220.00	22220.00	0.00	22	5	41656	711	58.5879043600563	0.205835157997998	0.205835157997998	true	false	false
fc027909-11de-4279-a100-a7e2ecdfac34	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261009C07910000	call	7910.0000	2026-10-09	1.3000	1.3000	1.3500	7705.0000	23010.00	0.00	23010.00	177	5	2648	1378	1.92162554426705	0.0900202337331866	0.0900202337331866	false	false	false
9b7bb067-3ecf-4b71-ba7e-9a338ef6ff8f	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261009C07910000	call	7910.0000	2026-10-09	1.3000	1.2000	1.3500	7705.0000	13650.00	13650.00	0.00	105	7	2238	1378	1.62409288824383	0.089952721638306	0.089952721638306	true	false	false
d2a89948-dc56-4df3-95f6-8e4b83b625e0	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002P07725000	put	7725.0000	2026-10-02	2.7500	2.6500	2.7500	7705.0000	11540.00	11000.00	0.00	42	18	97764	2308	42.3587521663778	0.186134395499389	0.183022240571811	false	false	false
3cec8959-d32b-48e5-885c-f0ce7119c452	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	2.9500	2.8500	2.9500	7705.0000	11800.00	11800.00	0.00	40	10	161500	4450	36.2921348314607	0.166633135558758	0.166633135558758	false	false	false
a78354b7-579b-4c53-a345-ae56acf8c0a5	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	3.0000	2.9000	3.1000	7705.0000	16800.00	15000.00	1500.00	56	15	161240	4450	36.2337078651685	0.157599196442356	0.161419257952926	false	false	false
b9af6b2c-51e6-411e-be90-5f1042df4c1e	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	3.1600	3.0000	3.2000	7705.0000	16450.00	14340.00	1800.00	52	11	161166	4450	36.2170786516854	0.158101526947475	0.151887376678915	false	false	false
c8c672ca-b4a6-42a0-aacb-713e7f37994b	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002P07735000	put	7735.0000	2026-10-02	9.8700	9.8000	10.2000	7705.0000	17770.00	0.00	17770.00	18	6	41602	711	58.5119549929677	0.268495759532496	0.268495759532496	false	false	false
31b73609-ccc6-419f-9771-59b539c15e73	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261005P07725000	put	7725.0000	2026-10-05	19.9000	19.8000	20.3000	7705.0000	33830.00	29850.00	3980.00	17	6	3468	279	12.4301075268817	0.0782770315960135	0.0782770315960135	false	false	false
aa2e258e-fe42-4029-b8e2-72a10062708d	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	4.1700	4.0000	4.5000	7705.0000	25880.00	5150.00	20300.00	62	35	160834	4450	36.1424719101124	0.173707360673675	0.168758512934693	true	false	false
5e74201c-190c-4e62-b286-373e6b55c4e7	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07730000	call	7730.0000	2026-10-02	1.7800	1.6500	2.0000	7705.0000	13015.00	3640.00	9375.00	73	35	147160	2310	63.7056277056277	0.17482814342783	0.174926345935174	false	false	false
70876899-cc23-4dfc-88ca-1740738a903c	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	4.8300	4.5000	5.2000	7705.0000	10620.00	3000.00	7620.00	22	7	160719	4450	36.1166292134831	0.180447565115111	0.152764129678925	false	false	false
130c1931-f6f9-428e-b0b2-67758189f996	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	4.6200	4.2000	4.9000	7705.0000	13860.00	4670.00	6430.00	30	15	160751	4450	36.1238202247191	0.152850139192961	0.152850139192961	false	false	false
ff53520c-5acd-4cd6-a1b0-58de3c58abce	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	4.5300	4.0000	5.1000	7705.0000	175150.00	172980.00	1260.00	387	80	160620	4450	36.0943820224719	0.16586202172488	0.223714000612632	false	false	false
e0ee20b6-b8c8-4be9-ba2c-155f2230e564	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	4.3000	4.0000	4.5000	7705.0000	11190.00	10770.00	420.00	26	9	160166	4450	35.9923595505618	0.16586202172488	0.185314524291073	false	false	false
dc46b484-3bec-44ab-9565-a866ceefb4f7	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07730000	call	7730.0000	2026-10-02	1.9900	1.7000	2.1500	7705.0000	17755.00	17230.00	525.00	89	50	146779	2310	63.5406926406926	0.176764579777588	0.192773380450689	false	false	false
c57005bc-4a1b-4239-8401-12556a5febcb	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	9.0000	8.1000	9.2000	7705.0000	43200.00	43200.00	0.00	48	8	122574	2945	41.6210526315789	0.237589257587306	0.269450470839014	false	false	false
8b001f77-cab4-4d64-acba-938c2df93e32	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	8.0100	7.8000	8.4000	7705.0000	36040.00	36040.00	0.00	45	7	122496	2945	41.5945670628183	0.16247386526355	0.203035404595267	false	false	false
7b864b5a-5d28-4f22-963e-1cb9349f282f	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07730000	call	7730.0000	2026-10-02	2.3600	2.1500	2.5500	7705.0000	14605.00	11370.00	3235.00	62	19	147013	2310	63.6419913419913	0.185637356792413	0.179443094800019	false	false	false
6373692c-b764-4a20-8462-290e11912280	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07730000	call	7730.0000	2026-10-02	2.4500	2.0000	2.6000	7705.0000	19090.00	19090.00	0.00	78	48	146912	2310	63.5982683982684	0.205489293396607	0.218262460176166	false	false	false
205639b8-1da9-441a-a971-20725762d75e	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	4.8300	4.8000	5.3000	7705.0000	10630.00	490.00	10140.00	22	5	160679	4450	36.1076404494382	0.166346705198741	0.166346705198741	true	false	false
ace49cd5-9e8d-4cff-8217-77377655f8a9	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002P07725000	put	7725.0000	2026-10-02	2.7000	2.7000	2.7500	7705.0000	12420.00	0.00	12420.00	46	5	96699	2308	41.8973136915078	0.162928962314788	0.162928962314788	false	false	false
ac48d3a8-1e64-43e1-910f-c232dbe080b3	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	3.6400	3.4000	4.0000	7705.0000	27670.00	25720.00	0.00	76	19	160068	4450	35.9703370786517	0.192226875529707	0.216637238898492	false	false	false
412d6acf-86b2-428b-8fa8-89e5b95746bd	2026-10-02 15:45	2026-10-02 15:45	2026-10-02 15:45	SPXW	SPXW261002C07730000	call	7730.0000	2026-10-02	1.3000	1.2500	1.3500	7705.0000	20285.00	20155.00	130.00	156	11	146341	2310	63.3510822510823	0.195157015347854	0.195265963647814	false	false	false