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_alerts326,449 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 |
|---|
| d9d9ecf8-e7b7-4c90-b9fc-d1f6165708b1 | 2026-09-21 12:56 | 2026-09-21 12:55 | 2026-09-21 12:55 | BUG | BUG270319C00045000 | call | 45.0000 | 2027-03-19 | 5.5900 | 5.5000 | 5.6000 | 45.0000 | 55852.00 | 50252.00 | 0.00 | 100 | 5 | 136 | 57 | 2.3859649122807 | 0.384501504401535 | 0.381252874997867 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 792741600.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| f8fce3f9-06e4-460d-9480-eb53710635b1 | 2026-09-21 12:25 | 2026-09-21 12:25 | 2026-09-21 12:25 | BUG | BUG270319C00046000 | call | 46.0000 | 2027-03-19 | 5.2000 | 5.1000 | 5.3000 | 45.6500 | 17160.00 | 0.00 | 10400.00 | 33 | 5 | 871 | 933 | 0.933547695605573 | 0.387603057777841 | 0.387603057777841 | false | false | false | true | false | |||||||||||||||
| a9354b2a-9b74-418a-bac1-f6522d848d4e | 2026-09-21 10:14 | 2026-09-21 10:14 | 2026-09-21 10:14 | BUG | BUG270319C00046000 | call | 46.0000 | 2027-03-19 | 5.0000 | 4.9000 | 5.2000 | 45.4800 | 10005.00 | 0.00 | 10005.00 | 20 | 10 | 573 | 933 | 0.614147909967846 | 0.383368215768562 | 0.383368215768562 | false | false | false | true | false | |||||||||||||||
| e17da19a-a294-4017-956b-95d33dfdc829 | 2026-09-17 12:07 | 2026-09-17 12:06 | 2026-09-17 12:06 | BUG | BUG261218C00050000 | call | 50.0000 | 2026-12-18 | 1.9000 | 1.7500 | 2.0500 | 45.3200 | 57950.00 | 57760.00 | 0.00 | 305 | 13 | 305 | 236 | 1.29237288135593 | 0.380107669892714 | 0.380107669892714 | false | false | false | true | false | |||||||||||||||
| 03c648ad-c111-4bec-ab79-d0228d8e141e | 2026-09-16 12:11 | 2026-09-16 12:11 | 2026-09-16 12:11 | BUG | BUG261218C00045000 | call | 45.0000 | 2026-12-18 | 3.8000 | 3.7000 | 3.9000 | 45.0800 | 145540.00 | 145160.00 | 0.00 | 383 | 11 | 389 | 1899 | 0.204844655081622 | 0.388246900191532 | 0.390138027554816 | false | false | false | true | false | |||||||||||||||
| 8b742bbc-7feb-4701-834d-b90f6e6005a7 | 2026-09-14 15:56 | 2026-09-14 15:56 | 2026-09-14 15:56 | BUG | BUG261016P00042000 | put | 42.0000 | 2026-10-16 | 1.0000 | 0.9000 | 1.0000 | 44.0000 | 21099.00 | 21099.00 | 0.00 | 211 | 18 | 236 | 20 | 11.8 | 0.394254305931617 | 0.392027084193747 | false | false | false | true | false | |||||||||||||||
| 3b6d5db8-639c-4253-90ec-d75f0c9b3b8c | 2026-09-14 15:55 | 2026-09-14 15:55 | 2026-09-14 15:55 | BUG | BUG261016P00040000 | put | 40.0000 | 2026-10-16 | 0.5500 | 0.4500 | 0.5500 | 44.0000 | 23100.00 | 23100.00 | 0.00 | 420 | 9 | 498 | 123 | 4.04878048780488 | 0.413472771224891 | 0.413472771224891 | false | false | false | true | false | |||||||||||||||
| 33165ec8-67d4-4b7b-8219-4c0f8308377d | 2026-09-14 11:21 | 2026-09-14 11:21 | 2026-09-14 11:21 | BUG | BUG261016C00045000 | call | 45.0000 | 2026-10-16 | 1.7000 | 1.5000 | 1.7000 | 44.1399 | 34000.00 | 34000.00 | 0.00 | 200 | 12 | 231 | 367 | 0.629427792915531 | 0.387754805443712 | 0.387754805443712 | false | false | false | true | false | |||||||||||||||
| 53ed636a-3309-49d3-8aab-0841985f1728 | 2026-09-14 10:26 | 2026-09-14 10:26 | 2026-09-14 10:26 | BUG | BUG261016C00042000 | call | 42.0000 | 2026-10-16 | 2.4600 | 2.3500 | 2.7000 | 43.0000 | 14276.00 | 9310.00 | 4966.00 | 58 | 5 | 149 | 997 | 0.149448345035105 | 0.361759329838902 | 0.353474583357348 | false | false | false | true | false | |||||||||||||||
| a64bef17-c94b-4b41-aa35-5e1ed32c3fed | 2026-09-02 14:34 | 2026-09-02 14:34 | 2026-09-02 14:34 | BUG | BUG261218C00035000 | call | 35.0000 | 2026-12-18 | 6.6800 | 6.3000 | 6.9000 | 39.9200 | 11356.00 | 6850.00 | 4506.00 | 17 | 5 | 21 | 75 | 0.28 | 0.453420353118809 | 0.365206014150878 | false | false | false | true | false | |||||||||||||||
| 70bacc1e-2676-4386-836a-a1e53e0e695d | 2026-09-02 14:28 | 2026-09-02 14:28 | 2026-09-02 14:28 | BUG | BUG261218C00040000 | call | 40.0000 | 2026-12-18 | 3.2200 | 3.1000 | 3.9000 | 39.9850 | 12880.00 | 5440.00 | 7440.00 | 40 | 8 | 47 | 148 | 0.317567567567568 | 0.369845104980409 | 0.334693111420359 | false | false | false | true | false | |||||||||||||||
| c8de6170-bc2a-4c3b-9f89-4b2f82610d1f | 2026-09-02 09:36 | 2026-09-02 09:36 | 2026-09-02 09:36 | BUG | BUG261016C00035000 | call | 35.0000 | 2026-10-16 | 6.1000 | 5.8000 | 7.4000 | 40.5020 | 12200.00 | 1830.00 | 7320.00 | 20 | 5 | 20 | 30 | 0.666666666666667 | 0.42226479028412 | 0.42226479028412 | false | false | false | true | false | |||||||||||||||
| 689908cb-eddb-42f2-80d4-eca8680e8d92 | 2026-09-01 11:51 | 2026-09-01 11:51 | 2026-09-01 11:51 | BUG | BUG280121C00050000 | call | 50.0000 | 2028-01-21 | 5.3500 | 4.2000 | 5.4000 | 41.7100 | 53540.00 | 53540.00 | 0.00 | 100 | 5 | 109 | 32 | 3.40625 | 0.376755989962516 | 0.371649498460904 | false | false | false | true | false | |||||||||||||||
| 42272201-53a4-472e-9721-b858cbb0df91 | 2026-08-27 13:44 | 2026-08-27 13:44 | 2026-08-27 13:44 | BUG | BUG261218C00039000 | call | 39.0000 | 2026-12-18 | 7.1000 | 6.7000 | 7.2000 | 44.2200 | 10650.00 | 8520.00 | 2130.00 | 15 | 5 | 35 | 78 | 0.448717948717949 | 0.388709048798012 | 0.388709048798012 | false | false | false | true | false | |||||||||||||||
| 0711ae94-6657-4dbc-ab9d-134810c58ea4 | 2026-08-26 12:25 | 2026-08-26 12:25 | 2026-08-26 12:25 | BUG | BUG261016C00035000 | call | 35.0000 | 2026-10-16 | 5.5000 | 5.2000 | 5.5000 | 39.6150 | 22000.00 | 22000.00 | 0.00 | 40 | 8 | 40 | 0 | 0 | 0.427001474681248 | 0.427001474681248 | false | false | false | true | false | |||||||||||||||
| b584c3bb-6cc4-4bcd-9393-bc5c2db9baf5 | 2026-08-26 10:21 | 2026-08-26 10:21 | 2026-08-26 10:21 | BUG | BUG260918P00039000 | put | 39.0000 | 2026-09-18 | 1.4000 | 1.0000 | 1.8500 | 39.5525 | 14000.00 | 3500.00 | 10500.00 | 100 | 5 | 102 | 32 | 3.1875 | 0.433791588175607 | 0.433791588175607 | false | false | false | true | false | |||||||||||||||
| 420200e8-9f1d-44a1-9b20-832fcd03c8a9 | 2026-08-21 15:46 | 2026-08-21 15:46 | 2026-08-21 15:46 | BUG | BUG260821P00041000 | put | 41.0000 | 2026-08-21 | 0.3500 | 0.3000 | 0.5000 | 40.6500 | 33855.00 | 4235.00 | 28745.00 | 967 | 38 | 1276 | 1864 | 0.684549356223176 | 1.18463368180343 | 0.550259697820957 | true | false | false | true | false | |||||||||||||||
| 594cdc3c-95cf-4ce5-803e-c1f0c83a9303 | 2026-08-21 13:21 | 2026-08-21 13:21 | 2026-08-21 13:21 | BUG | BUG260918C00038000 | call | 38.0000 | 2026-09-18 | 3.1000 | 2.4000 | 3.4000 | 40.4000 | 202740.00 | 202740.00 | 0.00 | 654 | 2 | 664 | 193 | 3.44041450777202 | 0.353445919903327 | 0.353445919903327 | false | true | true | false | true | |||||||||||||||
| ecad3d60-1826-4b60-b7a5-a88c2e8fe990 | 2026-08-21 10:07 | 2026-08-21 10:07 | 2026-08-21 10:07 | BUG | BUG260821P00041000 | put | 41.0000 | 2026-08-21 | 1.1500 | 1.1500 | 1.7000 | 39.8550 | 24150.00 | 0.00 | 24035.00 | 210 | 25 | 211 | 1864 | 0.113197424892704 | 0.566064015126119 | 0.566076659244328 | true | false | false | true | false | |||||||||||||||
| f11fb985-cdd7-4149-ac8a-6ff80c1735bb | 2026-08-19 13:52 | 2026-08-19 13:52 | 2026-08-19 13:52 | BUG | BUG270115C00035000 | call | 35.0000 | 2027-01-15 | 8.0100 | 8.0000 | 8.2000 | 41.1600 | 161100.00 | 0.00 | 161100.00 | 201 | 7 | 401 | 163 | 2.4601226993865 | 0.385770945870829 | 0.391479750251774 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:14:40.112451Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:22:15.429007Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:39:52.032222Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T13:42:51.501101Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T16:07:53.122506Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T17:46:53.178792Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 2 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 792741600.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |