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_alerts425,429 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 | price |
|---|
| 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 |
|---|
| 258b6352-09f6-4a0a-b8d0-433ed0ee238b | 2026-09-18 11:56 | 2026-09-18 11:56 | 2026-09-18 11:56 | SNXX | SNXX260925P00016500 | put | 16.5000 | 2026-09-25 | 1.0500 | 1.0500 | 1.1000 | 16.7300 | 57435.00 | 0.00 | 57435.00 | 547 | 18 | 620 | 67 | 9.25373134328358 | 1.27377601044799 | 1.27377601044799 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 13229825.00 | — | — | — | 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 |
| 63a43ff2-ac24-4d47-8f10-63253d6aafd4 | 2026-09-18 12:09 | 2026-09-18 12:09 | 2026-09-18 12:09 | SNXX | SNXX260925C00017000 | call | 17.0000 | 2026-09-25 | 1.1200 | 1.1000 | 1.2000 | 16.0000 | 11153.00 | 0.00 | 11153.00 | 100 | 9 | 1054 | 1533 | 0.687540769732551 | 1.23367401243795 | 1.23367401243795 | false | false | false | true | false | |||||||||||||||
| a61f1b1f-a575-4788-bc4b-2ff2d21e4784 | 2026-09-18 12:44 | 2026-09-18 12:44 | 2026-09-18 12:44 | SNXX | SNXX260925P00017000 | put | 17.0000 | 2026-09-25 | 1.1500 | 1.1500 | 1.2000 | 17.0950 | 15755.00 | 0.00 | 15755.00 | 137 | 5 | 396 | 511 | 0.774951076320939 | 1.27967089276683 | 1.27967089276683 | false | false | false | true | false | |||||||||||||||
| 2f7d9e7b-44bf-4b82-ac22-85be235e574f | 2026-09-18 12:59 | 2026-09-18 12:59 | 2026-09-18 12:59 | SNXX | SNXX260918C00016500 | call | 16.5000 | 2026-09-18 | 0.6000 | 0.5000 | 0.6500 | 17.0200 | 30000.00 | 27000.00 | 3000.00 | 500 | 9 | 1337 | 879 | 1.52104664391354 | 2.11212760584801 | 2.11212760584801 | false | false | false | true | false | |||||||||||||||
| e1dfbe84-2d2d-4b6c-8770-8fed16e19200 | 2026-09-18 15:55 | 2026-09-18 15:55 | 2026-09-18 15:55 | SNXX | SNXX261016C00018000 | call | 18.0000 | 2026-10-16 | 2.6500 | 1.7000 | 2.6500 | 17.0000 | 19610.00 | 19610.00 | 0.00 | 74 | 10 | 1096 | 689 | 1.59071117561684 | 1.36336853284198 | 1.36336853284198 | false | false | false | true | false | |||||||||||||||
| 15338f50-b781-411f-9036-e9d10172c4c2 | 2026-09-18 15:55 | 2026-09-18 15:55 | 2026-09-18 15:55 | SNXX | SNXX261016C00018000 | call | 18.0000 | 2026-10-16 | 2.6500 | 2.0500 | 2.6500 | 17.0000 | 59890.00 | 59890.00 | 0.00 | 226 | 5 | 1322 | 689 | 1.91872278664731 | 1.35896122116442 | 1.35896122116442 | false | false | false | true | false | |||||||||||||||
| 0fa3af3e-11ce-4408-93ad-2febd4d531fd | 2026-09-21 14:06 | 2026-09-21 14:06 | 2026-09-21 14:06 | SNXX | SNXX260925P00017000 | put | 17.0000 | 2026-09-25 | 1.0000 | 1.0000 | 1.1000 | 17.0000 | 17500.00 | 0.00 | 17500.00 | 175 | 5 | 1137 | 1508 | 0.753978779840849 | 1.41861612695974 | 1.41861612695974 | false | false | false | true | false | |||||||||||||||
| 6f5769b2-8d0c-4e5a-b4b7-0118b652b8a2 | 2026-09-21 14:10 | 2026-09-21 14:10 | 2026-09-21 14:10 | SNXX | SNXX261120C00020000 | call | 20.0000 | 2026-11-20 | 3.1000 | 3.0000 | 3.2000 | 17.0485 | 73780.00 | 31310.00 | 4650.00 | 238 | 5 | 278 | 1091 | 0.254812098991751 | 1.48707231865896 | 1.48707231865896 | false | false | false | true | false | |||||||||||||||
| f4797eff-e338-450f-9b95-522b82fa94b3 | 2026-09-21 14:34 | 2026-09-21 14:34 | 2026-09-21 14:34 | SNXX | SNXX261120P00017000 | put | 17.0000 | 2026-11-20 | 4.0000 | 3.9000 | 4.0000 | 17.0801 | 12000.00 | 12000.00 | 0.00 | 30 | 11 | 59 | 0 | 0 | 1.5147401002589 | 1.5147401002589 | false | false | false | true | false | |||||||||||||||
| 74935d64-146c-4525-9df6-8e9a4871c214 | 2026-09-21 14:38 | 2026-09-21 14:38 | 2026-09-21 14:38 | SNXX | SNXX260925P00017000 | put | 17.0000 | 2026-09-25 | 0.9000 | 0.9000 | 0.9500 | 17.2650 | 13500.00 | 0.00 | 13500.00 | 150 | 8 | 1839 | 1508 | 1.21949602122016 | 1.44190657961166 | 1.44190657961166 | false | false | false | true | false | |||||||||||||||
| 76b3d27b-b915-4d3d-b69d-64d486c7dc20 | 2026-09-21 15:12 | 2026-09-21 15:12 | 2026-09-21 15:12 | SNXX | SNXX270319C00017000 | call | 17.0000 | 2027-03-19 | 6.7300 | 6.2000 | 6.8000 | 17.3018 | 13465.00 | 13465.00 | 0.00 | 20 | 7 | 54 | 156 | 0.346153846153846 | 1.40869435772114 | 1.39678900563981 | false | false | false | true | false | |||||||||||||||
| ed2e40c1-67c0-4b13-83db-ab67177b98ca | 2026-09-21 15:51 | 2026-09-21 15:51 | 2026-09-21 15:51 | SNXX | SNXX260925C00018000 | call | 18.0000 | 2026-09-25 | 0.8000 | 0.8000 | 0.8500 | 17.3350 | 12031.00 | 0.00 | 12031.00 | 150 | 12 | 2387 | 1669 | 1.43019772318754 | 1.48932292134576 | 1.50331195902395 | false | false | false | true | false | |||||||||||||||
| 7b361502-ebd2-4c45-9f3c-f9422952cd33 | 2026-09-22 09:46 | 2026-09-22 09:46 | 2026-09-22 09:46 | SNXX | SNXX260925C00019000 | call | 19.0000 | 2026-09-25 | 1.8900 | 1.8000 | 2.0000 | 20.0010 | 12498.00 | 10788.00 | 1710.00 | 66 | 5 | 968 | 1776 | 0.545045045045045 | 1.89795546760401 | 1.88305591350714 | false | false | false | true | false | |||||||||||||||
| 25079a06-6631-427b-ad8b-fe570ac92dd7 | 2026-09-22 09:54 | 2026-09-22 09:54 | 2026-09-22 09:54 | SNXX | SNXX261002P00016000 | put | 16.0000 | 2026-10-02 | 0.5600 | 0.5000 | 0.6500 | 20.1800 | 27770.00 | 0.00 | 27770.00 | 500 | 5 | 516 | 341 | 1.51319648093842 | 1.6832316526357 | 1.6832316526357 | false | false | false | true | false | |||||||||||||||
| 57213e7b-517c-4821-8ea6-a107668d44aa | 2026-09-22 10:41 | 2026-09-22 10:41 | 2026-09-22 10:41 | SNXX | SNXX261002C00019000 | call | 19.0000 | 2026-10-02 | 2.3500 | 2.3000 | 2.5000 | 19.5200 | 15275.00 | 11515.00 | 3525.00 | 65 | 6 | 208 | 817 | 0.254589963280294 | 1.63233249866167 | 1.63233249866167 | true | false | false | true | false | |||||||||||||||
| 2f63720b-8635-4b5f-85d4-4254820df9c7 | 2026-09-22 10:45 | 2026-09-22 10:45 | 2026-09-22 10:45 | SNXX | SNXX261002C00020000 | call | 20.0000 | 2026-10-02 | 1.8300 | 1.7500 | 2.1500 | 19.5700 | 17595.00 | 0.00 | 17595.00 | 96 | 7 | 645 | 1872 | 0.344551282051282 | 1.49521814875404 | 1.6501864660261 | false | false | false | true | false | |||||||||||||||
| 7f43c7fd-4433-4e15-b640-af55c3656962 | 2026-09-22 11:31 | 2026-09-22 11:31 | 2026-09-22 11:31 | SNXX | SNXX260925C00019000 | call | 19.0000 | 2026-09-25 | 1.2500 | 1.2000 | 1.2500 | 19.0000 | 11625.00 | 11625.00 | 0.00 | 93 | 6 | 1907 | 1776 | 1.07376126126126 | 1.67402400931688 | 1.67402400931688 | false | false | false | true | false | |||||||||||||||
| 03864434-1ff2-454c-b9f7-177e3bf504d7 | 2026-09-22 11:41 | 2026-09-22 11:40 | 2026-09-22 11:40 | SNXX | SNXX261120C00020000 | call | 20.0000 | 2026-11-20 | 4.5200 | 4.3000 | 4.6000 | 19.2550 | 14012.00 | 14012.00 | 0.00 | 31 | 5 | 366 | 1355 | 0.270110701107011 | 1.56171335271286 | 1.56171335271286 | false | false | false | true | false | |||||||||||||||
| 7dc39e5b-0362-4846-90ef-7b1464fd72fd | 2026-09-23 14:56 | 2026-09-23 14:56 | 2026-09-23 14:56 | SNXX | SNXX270319C00018000 | call | 18.0000 | 2027-03-19 | 7.1000 | 6.9000 | 7.5000 | 18.3350 | 29110.00 | 22010.00 | 7100.00 | 41 | 5 | 54 | 562 | 0.096085409252669 | 1.40371574572919 | 1.40371574572919 | false | false | false | true | false | |||||||||||||||
| abbfc983-aef7-412d-ae22-e675eea0c841 | 2026-09-23 15:07 | 2026-09-23 15:07 | 2026-09-23 15:07 | SNXX | SNXX261002P00017500 | put | 17.5000 | 2026-10-02 | 1.3500 | 1.2500 | 1.3500 | 18.3550 | 13500.00 | 13500.00 | 0.00 | 100 | 5 | 273 | 85 | 3.21176470588235 | 1.56465885968963 | 1.56465885968963 | false | false | false | true | false | |||||||||||||||
| e2c25a3c-ac1b-4357-aaaf-5d98e1e45c2a | 2026-09-24 09:54 | 2026-09-24 09:54 | 2026-09-24 09:54 | SNXX | SNXX261030P00013000 | put | 13.0000 | 2026-10-30 | 1.0000 | 0.7500 | 1.1500 | 17.6300 | 10000.00 | 100.00 | 9900.00 | 100 | 5 | 103 | 161 | 0.639751552795031 | 1.44611791874047 | 1.44611791874047 | false | false | false | true | false | |||||||||||||||
| b53c5d32-9104-40ef-86a1-4f9d510bdff1 | 2026-09-24 10:52 | 2026-09-24 10:52 | 2026-09-24 10:52 | SNXX | SNXX260925C00015000 | call | 15.0000 | 2026-09-25 | 2.5500 | 2.5500 | 3.1000 | 17.5805 | 33660.00 | 0.00 | 33660.00 | 132 | 12 | 135 | 682 | 0.197947214076246 | 4.30991388651699 | 4.30991388651699 | false | false | false | true | false | |||||||||||||||
| a316713e-e261-4dfd-a357-c24bba3443d3 | 2026-09-24 14:59 | 2026-09-24 14:59 | 2026-09-24 14:59 | SNXX | SNXX270319C00017000 | call | 17.0000 | 2027-03-19 | 6.2000 | 5.7000 | 6.5000 | 16.9600 | 620000.00 | 60140.00 | 559860.00 | 1000 | 26 | 1038 | 227 | 4.5726872246696 | 1.34567280644515 | 1.34567280644515 | true | false | false | true | false | |||||||||||||||
| 8633c6d2-4bb2-436d-83a9-18b49977ddb9 | 2026-09-24 15:01 | 2026-09-24 15:01 | 2026-09-24 15:01 | SNXX | SNXX270319P00017000 | put | 17.0000 | 2027-03-19 | 6.5000 | 6.1000 | 6.5000 | 16.9503 | 617379.00 | 617379.00 | 0.00 | 950 | 19 | 1007 | 75 | 13.4266666666667 | 1.49011275946991 | 1.49288056300117 | true | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:25:30.671610Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:45:45.480252Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:09:57.736377Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:15:35.599753Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:37:54.025147Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:42:48.011261Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:15:34.344712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:52:57.186278Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:48:39.949749Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:56:25.927111Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:42:44.065275Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:45:53.881330Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:34:09.835499Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:42:55.952799Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:58:18.142602Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:12:23.721983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:56:38.298983Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:53:28.868411Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:02:51.984196Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 13229825.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:02:51.984196Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |