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.
Simplify Analyticsuw_flow_alerts474,253 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 | strike |
|---|
| 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 |
|---|
| f3daf615-85bb-4062-8b7a-da11ea60e3d9 | 2026-09-25 12:13 | 2026-09-25 12:13 | 2026-09-25 12:13 | C | C270617P00130000 | put | 130.0000 | 2027-06-17 | 10.5300 | 10.5000 | 10.9500 | 134.0000 | 526556.00 | 0.00 | 526556.00 | 500 | 7 | 500 | 6220 | 0.0803858520900322 | 0.328410801967868 | 0.328410801967868 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 225246211221.00 | 2026-10-13 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T16:14:10.282260Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 5fc14953-dad7-4a3e-b2f9-8ef8bc4097ab | 2026-09-25 12:07 | 2026-09-25 12:07 | 2026-09-25 12:07 | C | C270617C00140000 | call | 140.0000 | 2027-06-17 | 12.5300 | 12.3500 | 12.8000 | 134.2600 | 313360.00 | 62900.00 | 250460.00 | 250 | 5 | 501 | 2791 | 0.17950555356503 | 0.288327685837657 | 0.288327685837657 | false | false | ||||||||||||||||||
| cd3e256a-a3dc-4066-9460-9a2a386c0121 | 2026-09-25 12:01 | 2026-09-25 12:01 | 2026-09-25 12:01 | C | C261002C00138000 | call | 138.0000 | 2026-10-02 | 0.6100 | 0.6100 | 0.7100 | 133.9700 | 12332.00 | 0.00 | 12200.00 | 202 | 13 | 354 | 914 | 0.387308533916849 | 0.273311491539372 | 0.264314989856587 | false | false | ||||||||||||||||||
| ff110b06-3d2a-4dd3-aecb-22de9105ea0a | 2026-09-25 10:09 | 2026-09-25 10:09 | 2026-09-25 10:09 | C | C260925C00131000 | call | 131.0000 | 2026-09-25 | 1.6300 | 1.4100 | 1.6500 | 132.5000 | 32695.00 | 32695.00 | 0.00 | 200 | 13 | 200 | 544 | 0.367647058823529 | 0.46707643933842 | 0.405422256068933 | true | false | false | |||||||||||||||||
| 25e57c9e-f596-4c5c-87e7-8bf7fea1f07b | 2026-09-22 13:49 | 2026-09-22 13:49 | 2026-09-22 13:49 | C | C290119P00110000 | put | 110.0000 | 2029-01-19 | 11.3500 | 10.7500 | 12.5500 | 132.7034 | 22696.00 | 0.00 | 22696.00 | 20 | 6 | 259 | 0 | 0 | 0.360067063249558 | 0.359375104485445 | false | false | false | |||||||||||||||||
| dd5c29ac-8493-4723-b95f-25efe16fa37e | 2026-09-22 10:21 | 2026-09-22 10:21 | 2026-09-22 10:21 | C | C261023C00139000 | call | 139.0000 | 2026-10-23 | 2.6500 | 2.3700 | 2.6700 | 131.9300 | 264524.00 | 264524.00 | 0.00 | 1000 | 8 | 1000 | 28 | 35.7142857142857 | 0.339591252741936 | 0.327560079405408 | false | false | ||||||||||||||||||
| 03435358-e96d-488c-88c6-cc0c0d3b5480 | 2026-09-22 10:15 | 2026-09-22 10:15 | 2026-09-22 10:15 | C | C261009P00130000 | put | 130.0000 | 2026-10-09 | 2.3900 | 2.1700 | 2.4600 | 131.9950 | 32516.00 | 22277.00 | 10239.00 | 136 | 10 | 162 | 61 | 2.65573770491803 | 0.301893817416659 | 0.306486382073714 | true | false | false | |||||||||||||||||
| c9cf0bb7-4ec6-4806-b1de-f1b54050f309 | 2026-09-18 11:48 | 2026-09-18 11:48 | 2026-09-18 11:48 | C | C261016P00130000 | put | 130.0000 | 2026-10-16 | 3.5000 | 3.3000 | 3.6000 | 132.0800 | 260383.00 | 242533.00 | 17850.00 | 744 | 53 | 881 | 5538 | 0.159082701336222 | 0.32168700035622 | 0.320559540196828 | false | false | ||||||||||||||||||
| 2f0897a7-85d7-4c96-8c33-3a56631637e5 | 2026-09-17 14:48 | 2026-09-17 14:48 | 2026-09-17 14:48 | C | C261120C00135000 | call | 135.0000 | 2026-11-20 | 6.0500 | 6.0000 | 6.2000 | 133.0100 | 59935.00 | 16940.00 | 42995.00 | 99 | 30 | 380 | 2323 | 0.163581575548859 | 0.29449513555111 | 0.293595032806561 | true | false | ||||||||||||||||||
| f13e3a39-b836-4063-b0b1-81d224258512 | 2026-09-17 10:45 | 2026-09-17 10:45 | 2026-09-17 10:45 | C | C261016P00120000 | put | 120.0000 | 2026-10-16 | 1.0700 | 1.0500 | 1.1500 | 131.9000 | 58760.00 | 15622.00 | 43138.00 | 549 | 40 | 1231 | 26680 | 0.0461394302848576 | 0.352922438448879 | 0.352207885846049 | true | false | ||||||||||||||||||
| 12c519dd-3a1c-440d-8d5a-2c7e73f6b0e1 | 2026-09-16 15:24 | 2026-09-16 15:24 | 2026-09-16 15:24 | C | C261016P00120000 | put | 120.0000 | 2026-10-16 | 1.2400 | 1.2200 | 1.3000 | 131.2010 | 63518.00 | 59768.00 | 3750.00 | 512 | 21 | 8644 | 19142 | 0.45157245846829 | 0.353995373459186 | 0.352935665975061 | true | false | ||||||||||||||||||
| c870ab60-6ca6-40b6-804b-12c66f94883a | 2026-09-16 14:52 | 2026-09-16 14:51 | 2026-09-16 14:51 | C | C261218C00140000 | call | 140.0000 | 2026-12-18 | 5.7000 | 5.6000 | 5.8500 | 133.3100 | 1793612.00 | 865260.00 | 95582.00 | 3146 | 34 | 3264 | 4900 | 0.666122448979592 | 0.294749699976213 | 0.293883521436283 | false | false | ||||||||||||||||||
| c8666472-6121-423f-85ce-112d45820b58 | 2026-09-10 12:08 | 2026-09-10 12:08 | 2026-09-10 12:08 | C | C260918C00140000 | call | 140.0000 | 2026-09-18 | 1.4100 | 1.4000 | 1.4700 | 137.5700 | 57135.00 | 0.00 | 57135.00 | 405 | 5 | 1102 | 10859 | 0.101482641127176 | 0.293118068012548 | 0.293118068012548 | false | false | ||||||||||||||||||
| 6344a624-b87e-41a5-8c0e-1537fb96d6fa | 2026-09-04 13:25 | 2026-09-04 13:25 | 2026-09-04 13:25 | C | C260918C00142000 | call | 142.0000 | 2026-09-18 | 1.2900 | 1.2100 | 1.2900 | 137.7700 | 59526.00 | 33798.00 | 0.00 | 463 | 25 | 481 | 301 | 1.59800664451827 | 0.262157425956028 | 0.262157425956028 | false | false | ||||||||||||||||||
| 804ab667-63e3-4973-905e-e5121a40fdd6 | 2026-09-04 12:58 | 2026-09-04 12:58 | 2026-09-04 12:58 | C | C261009C00148000 | call | 148.0000 | 2026-10-09 | 1.2100 | 1.2100 | 1.2300 | 137.5461 | 59084.00 | 2214.00 | 56870.00 | 488 | 7 | 488 | 2 | 244 | 0.259958432788442 | 0.259958432788442 | false | false | false | |||||||||||||||||
| 38213487-b96f-425f-83af-9d1c0cc27980 | 2026-09-03 10:03 | 2026-09-03 10:03 | 2026-09-03 10:03 | C | C260918C00140000 | call | 140.0000 | 2026-09-18 | 1.5000 | 1.4800 | 1.5600 | 136.2100 | 152102.00 | 0.00 | 151950.00 | 1014 | 5 | 3069 | 8739 | 0.351184346035015 | 0.26615658131907 | 0.26615658131907 | false | false | ||||||||||||||||||
| 9b65608e-625a-488a-be2f-13047a3e4af3 | 2026-08-28 09:43 | 2026-08-28 09:43 | 2026-08-28 09:43 | C | C261016P00120000 | put | 120.0000 | 2026-10-16 | 1.3800 | 1.3500 | 1.5100 | 132.5900 | 954287.00 | 0.00 | 954001.00 | 6915 | 10 | 6916 | 2676 | 2.58445440956652 | 0.313876866906177 | 0.313876866906177 | false | false | ||||||||||||||||||
| ad3e6c97-db94-4d5e-8331-07c548636510 | 2026-08-21 11:44 | 2026-08-21 11:43 | 2026-08-21 11:43 | C | C270115P00130000 | put | 130.0000 | 2027-01-15 | 8.8100 | 8.8000 | 9.0500 | 131.0400 | 70484.00 | 0.00 | 70484.00 | 80 | 7 | 271 | 7665 | 0.0353555120678408 | 0.314693489981068 | 0.313767231312585 | false | false | false | |||||||||||||||||
| 4507feec-9070-4e3e-8f49-ad6ee3041da4 | 2026-08-20 13:02 | 2026-08-20 13:02 | 2026-08-20 13:02 | C | C270115P00125000 | put | 125.0000 | 2027-01-15 | 6.4500 | 6.3500 | 6.4500 | 131.6875 | 190871.00 | 190871.00 | 0.00 | 296 | 32 | 342 | 10330 | 0.033107454017425 | 0.316051921038421 | 0.316051921038421 | false | false | ||||||||||||||||||
| 714e5020-a0ad-4473-ba62-fa9c49170bbe | 2026-08-19 12:57 | 2026-08-19 12:57 | 2026-08-19 12:57 | C | C260918C00135000 | call | 135.0000 | 2026-09-18 | 3.8000 | 3.7000 | 3.8500 | 133.7500 | 334380.00 | 323740.00 | 10640.00 | 880 | 62 | 1055 | 6694 | 0.157603824320287 | 0.273942248062419 | 0.273942248062419 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 225246211221.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:07:40.588274Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 225246211221.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:02:23.613765Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 225246211221.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:11:57.153448Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 222210050644.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:52:53.749956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 222210050644.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:23:46.275389Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 222210050644.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:17:46.082263Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 221035844896.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 222595861104.00 |
| 2026-10-13 |
| premarket |
| — |
| 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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 222595861104.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:48:09.438351Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 223015220300.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:29:08.379560Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 223015220300.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 228433341109.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T16:13:08.333814Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 228433341109.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:34:11.817020Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 228433341109.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:07:55.847311Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 228433341109.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:10:05.195539Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 228433341109.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 228433341109.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 228433341109.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 228433341109.00 |
| 2026-10-13 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:16:43.855599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |