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.
uw_flow_alerts566,287 rowsrestricted — hover for the licence| iduuid | created_at ↓timestamp with time zone | start_timetimestamp with time zone | end_timetimestamp with time zone | tickertext | option_symboltext | option_typetext | strikenumeric |
|---|
| expirydate |
|---|
| pricenumeric |
|---|
| bidnumeric |
|---|
| asknumeric |
|---|
| underlying_pricenumeric |
|---|
| total_premiumnumeric |
|---|
| total_ask_side_premnumeric |
|---|
| total_bid_side_premnumeric |
|---|
| total_sizebigint |
|---|
| trade_countinteger |
|---|
| volumebigint |
|---|
| open_interestbigint |
|---|
| volume_oi_rationumeric |
|---|
| iv_startnumeric |
|---|
| iv_endnumeric |
|---|
| has_sweepboolean |
|---|
| has_floorboolean |
|---|
| has_multilegboolean |
|---|
| has_singlelegboolean |
|---|
| all_opening_tradesboolean |
|---|
| alert_ruletext |
|---|
| rule_iduuid |
|---|
| expiry_countinteger |
|---|
| issue_typetext |
|---|
| sectortext |
|---|
| marketcapnumeric |
|---|
| next_earnings_datedate |
|---|
| er_timetext |
|---|
| missing_periscopeboolean |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 82120b2b-154b-487b-ac7b-541f42afd8c8 | 2026-09-29 14:54 | 2026-09-29 14:54 | 2026-09-29 14:54 | PACS | PACS261218P00035000 | put | 35.0000 | 2026-12-18 | 1.8600 | 1.8500 | 2.1000 | 41.4100 | 18207.00 | 0.00 | 18207.00 | 98 | 6 | 3139 | 3586 | 0.875348577802566 | 0.630340892296786 | 0.626913905271471 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 6689679607.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T19:01:46.856083Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 4bd505cd-4f2d-4ed5-bfc3-64ab7818985d | 2026-09-29 14:41 | 2026-09-29 14:41 | 2026-09-29 14:41 | PACS | PACS261218P00035000 | put | 35.0000 | 2026-12-18 | 1.9000 | 1.8750 | 1.9500 | 41.2950 | 38000.00 | 0.00 | 38000.00 | 200 | 14 | 3041 | 3586 | 0.848020078081428 | 0.630979584822626 | 0.630979584822626 | false | false | false | |||||||||||||||||
| 9a32b7b7-54bf-4ae9-bba9-087319cefa89 | 2026-09-29 12:50 | 2026-09-29 12:50 | 2026-09-29 12:50 | PACS | PACS261218P00035000 | put | 35.0000 | 2026-12-18 | 1.9500 | 1.9500 | 2.2500 | 41.1900 | 38025.00 | 0.00 | 38025.00 | 195 | 21 | 2467 | 3586 | 0.687953151143335 | 0.635342616985319 | 0.635342616985319 | false | false | false | |||||||||||||||||
| 68ca14d4-5841-444f-aabc-263a83b6e5cd | 2026-09-29 12:14 | 2026-09-29 12:14 | 2026-09-29 12:14 | PACS | PACS261218P00035000 | put | 35.0000 | 2026-12-18 | 2.0000 | 1.8500 | 2.3000 | 41.0000 | 39200.00 | 6000.00 | 33200.00 | 196 | 16 | 2264 | 3586 | 0.631344116006693 | 0.643199846474026 | 0.643199846474026 | false | false | false | |||||||||||||||||
| 5a1d2c6f-c7bb-4507-b8cc-4be38f330556 | 2026-09-29 12:08 | 2026-09-29 12:08 | 2026-09-29 12:08 | PACS | PACS261218P00035000 | put | 35.0000 | 2026-12-18 | 2.0000 | 1.8500 | 2.3000 | 40.0000 | 34600.00 | 7200.00 | 27400.00 | 173 | 14 | 2041 | 3586 | 0.569157836029002 | 0.63541580529134 | 0.63541580529134 | true | false | false | |||||||||||||||||
| 68915bef-5c9e-4096-bc1e-8ee416a8f3f0 | 2026-09-29 10:42 | 2026-09-29 10:42 | 2026-09-29 10:42 | PACS | PACS261218P00035000 | put | 35.0000 | 2026-12-18 | 1.8500 | 1.7500 | 1.8500 | 41.6250 | 27750.00 | 27750.00 | 0.00 | 150 | 8 | 1179 | 3586 | 0.32877858337981 | 0.635202614954309 | 0.635202614954309 | false | false | false | |||||||||||||||||
| 9035567b-23f4-4a40-b061-b5caaea62d9f | 2026-09-29 10:24 | 2026-09-29 10:23 | 2026-09-29 10:23 | PACS | PACS261218P00035000 | put | 35.0000 | 2026-12-18 | 1.8000 | 1.7500 | 1.8000 | 41.9500 | 27540.00 | 27540.00 | 0.00 | 153 | 9 | 907 | 3586 | 0.25292805354155 | 0.638877755622334 | 0.638877755622334 | false | false | false | |||||||||||||||||
| 7bb93805-9b27-4077-85ef-d4ddabe61e25 | 2026-09-29 10:18 | 2026-09-29 10:18 | 2026-09-29 10:18 | PACS | PACS261218P00035000 | put | 35.0000 | 2026-12-18 | 1.8000 | 1.7500 | 1.8500 | 42.3000 | 36000.00 | 3960.00 | 23040.00 | 200 | 9 | 707 | 3586 | 0.197155605131065 | 0.64112562743407 | 0.651891252822317 | false | false | false | |||||||||||||||||
| b2f8d433-c721-4421-807a-e8387d966ba8 | 2026-09-28 11:24 | 2026-09-28 11:24 | 2026-09-28 11:24 | PACS | PACS261218C00050000 | call | 50.0000 | 2026-12-18 | 3.3000 | 3.0000 | 3.3000 | 43.0000 | 10890.00 | 10890.00 | 0.00 | 33 | 7 | 3003 | 3150 | 0.953333333333333 | 0.693387091821916 | 0.693387091821916 | false | false | false | |||||||||||||||||
| 929ee8e2-f918-4b7f-ae29-c9c3935c8098 | 2026-09-28 11:10 | 2026-09-28 11:10 | 2026-09-28 11:10 | PACS | PACS261218C00050000 | call | 50.0000 | 2026-12-18 | 3.4000 | 3.1000 | 3.5000 | 43.1600 | 29876.00 | 29876.00 | 0.00 | 88 | 5 | 2742 | 3150 | 0.870476190476191 | 0.698791523860353 | 0.698791523860353 | false | false | false | |||||||||||||||||
| 13d8a805-f7ed-417e-91e3-8e982cbb3eb1 | 2026-09-28 11:10 | 2026-09-28 11:10 | 2026-09-28 11:10 | PACS | PACS261218C00050000 | call | 50.0000 | 2026-12-18 | 3.3900 | 3.1000 | 3.5000 | 43.1700 | 37628.00 | 37628.00 | 0.00 | 111 | 5 | 2654 | 3150 | 0.842539682539683 | 0.697009471567816 | 0.697009471567816 | false | false | false | |||||||||||||||||
| fff1ce8a-dea6-4a91-b597-179849c00afa | 2026-09-28 11:07 | 2026-09-28 11:07 | 2026-09-28 11:07 | PACS | PACS261218C00050000 | call | 50.0000 | 2026-12-18 | 3.4000 | 3.1000 | 3.5000 | 43.3300 | 68000.00 | 13600.00 | 29580.00 | 200 | 5 | 2542 | 3150 | 0.806984126984127 | 0.691405651438365 | 0.691405651438365 | false | false | false | |||||||||||||||||
| e4a15f9b-90b1-43ed-8097-7a72edf6b205 | 2026-09-28 11:03 | 2026-09-28 11:03 | 2026-09-28 11:03 | PACS | PACS261218C00050000 | call | 50.0000 | 2026-12-18 | 3.3000 | 3.1000 | 3.5000 | 43.2500 | 66000.00 | 54780.00 | 11220.00 | 200 | 10 | 2342 | 3150 | 0.743492063492064 | 0.682768888295311 | 0.682768888295311 | false | false | false | |||||||||||||||||
| cb3a3d2f-813f-497e-830a-3a36663f6f0d | 2026-09-28 10:52 | 2026-09-28 10:52 | 2026-09-28 10:52 | PACS | PACS261218C00050000 | call | 50.0000 | 2026-12-18 | 3.3000 | 3.3000 | 3.4000 | 43.3400 | 11550.00 | 0.00 | 330.00 | 35 | 19 | 2013 | 3150 | 0.639047619047619 | 0.67822017459905 | 0.67822017459905 | false | false | false | |||||||||||||||||
| f365410b-9c09-4d79-a33a-1fc4c9a3f744 | 2026-09-28 10:52 | 2026-09-28 10:52 | 2026-09-28 10:52 | PACS | PACS261218C00050000 | call | 50.0000 | 2026-12-18 | 3.3000 | 3.1000 | 3.4000 | 43.3400 | 11880.00 | 330.00 | 2640.00 | 36 | 19 | 1978 | 3150 | 0.627936507936508 | 0.67822017459905 | 0.67822017459905 | false | false | false | |||||||||||||||||
| a4564c44-8201-4b8d-980a-502348140d6f | 2026-09-28 10:43 | 2026-09-28 10:43 | 2026-09-28 10:43 | PACS | PACS261218C00050000 | call | 50.0000 | 2026-12-18 | 3.1000 | 3.0000 | 3.2000 | 42.8150 | 11470.00 | 0.00 | 10230.00 | 37 | 19 | 1659 | 3150 | 0.526666666666667 | 0.678891570548639 | 0.678891570548639 | false | false | false | |||||||||||||||||
| 31e901e9-fe99-40a3-a4de-2104b73202bb | 2026-09-28 10:43 | 2026-09-28 10:42 | 2026-09-28 10:42 | PACS | PACS261218C00050000 | call | 50.0000 | 2026-12-18 | 3.1000 | 2.9500 | 3.1000 | 42.8700 | 35650.00 | 35650.00 | 0.00 | 115 | 33 | 1589 | 3150 | 0.504444444444444 | 0.678891570548639 | 0.676151812478485 | false | false | false | |||||||||||||||||
| a2630df6-9770-4823-a09c-3e4a8e614410 | 2026-09-28 10:35 | 2026-09-28 10:35 | 2026-09-28 10:35 | PACS | PACS261218C00050000 | call | 50.0000 | 2026-12-18 | 2.9500 | 2.6500 | 2.9500 | 42.6900 | 55149.00 | 55149.00 | 0.00 | 187 | 28 | 1316 | 3150 | 0.417777777777778 | 0.662891602509835 | 0.665514274374933 | false | false | false | |||||||||||||||||
| 5f5005fe-e4f6-4870-a5df-81e5c6dbee3b | 2026-09-28 10:21 | 2026-09-28 10:21 | 2026-09-28 10:21 | PACS | PACS261218C00050000 | call | 50.0000 | 2026-12-18 | 2.5000 | 2.4500 | 2.6500 | 42.1500 | 35500.00 | 0.00 | 35500.00 | 142 | 19 | 521 | 3150 | 0.165396825396825 | 0.631459430390013 | 0.631459430390013 | false | false | false | |||||||||||||||||
| 5a824df8-d8e7-47a1-b527-41abe824b42d | 2026-09-28 10:11 | 2026-09-28 10:10 | 2026-09-28 10:10 | PACS | PACS270115C00060000 | call | 60.0000 | 2027-01-15 | 1.4400 | 1.4000 | 1.5000 | 41.5101 | 28750.00 | 17110.00 | 11640.00 | 200 | 13 | 419 | 1554 | 0.26962676962677 | 0.649926620089025 | 0.642126289965936 | false | false | false | |||||||||||||||||
| 95706222-645e-4975-90a8-b090ef6bd29d | 2026-09-17 15:06 | 2026-09-17 15:06 | 2026-09-17 15:06 | PACS | PACS261016C00040000 | call | 40.0000 | 2026-10-16 | 4.2000 | 3.9000 | 4.4000 | 42.8500 | 29820.00 | 5880.00 | 23940.00 | 71 | 9 | 76 | 86 | 0.883720930232558 | 0.524348908579459 | 0.52261824266537 | false | false | false | |||||||||||||||||
| 1a5fc658-7967-4e76-b3ee-2095f848bf6c | 2026-09-03 13:34 | 2026-09-03 13:34 | 2026-09-03 13:34 | PACS | PACS260918C00045000 | call | 45.0000 | 2026-09-18 | 0.8200 | 0.5000 | 1.2000 | 42.4400 | 82000.00 | 0.00 | 82000.00 | 1000 | 3 | 1003 | 844 | 1.18838862559242 | 0.509002245609774 | 0.509002245609774 | false | true | true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6689679607.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:44:56.074296Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6689679607.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:54:42.907148Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6689679607.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:14:29.710858Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6689679607.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:14:29.710858Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6689679607.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:43:57.970888Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6689679607.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:27:05.819137Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6689679607.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:20:45.817132Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6817931453.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:26:10.967927Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 6817931453.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:13:28.016528Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 6817931453.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:13:28.016528Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6817931453.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:07:49.778831Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6817931453.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:04:58.148934Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6817931453.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:55:24.203019Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6817931453.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:55:24.203019Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6817931453.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:43:59.804397Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6817931453.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:43:59.804397Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 6817931453.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:35:37.335936Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6817931453.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:22:37.821840Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 6817931453.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:11:27.545413Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 6659595841.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| FloorTradeMidCap |
| d9769fb4-003b-49e4-9181-c78c9cc101f5 |
| 1 |
| Common Stock |
| Healthcare |
| 7053851515.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T17:55:09.170571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |