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 | 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 |
|---|
| d13d564f-d153-4d48-8e8d-b09bcf8ab3ff | 2026-09-25 15:37 | 2026-09-25 15:37 | 2026-09-25 15:37 | AGQ | AGQ260925P00080000 | put | 80.0000 | 2026-09-25 | 3.4000 | 3.4000 | 3.5000 | 76.0000 | 30945.00 | 0.00 | 30945.00 | 91 | 23 | 200 | 239 | 0.836820083682008 | 1.40195955693079 | 1.40195955693079 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1353316412.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:39:29.889694Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 396c8eb3-ad61-4e33-a3b4-a52f0dd0c32b | 2026-09-24 13:02 | 2026-09-24 13:02 | 2026-09-24 13:02 | AGQ | AGQ261016C00090000 | call | 90.0000 | 2026-10-16 | 1.4300 | 1.2000 | 1.6000 | 74.7100 | 14334.00 | 14334.00 | 0.00 | 100 | 7 | 102 | 309 | 0.330097087378641 | 0.784773294741609 | 0.784773294741609 | false | false | false | |||||||||||||||||
| cb7f4b36-4988-4d99-9340-39a669607982 | 2026-09-23 15:19 | 2026-09-23 15:18 | 2026-09-23 15:18 | AGQ | AGQ261002P00075000 | put | 75.0000 | 2026-10-02 | 2.4500 | 2.2000 | 2.6500 | 76.7408 | 24508.00 | 243.00 | 24265.00 | 100 | 12 | 112 | 93 | 1.20430107526882 | 0.685965051670415 | 0.690286137339442 | true | false | false | |||||||||||||||||
| 3afdb417-d15f-4f7c-b28f-c89e14b46dc0 | 2026-09-17 12:11 | 2026-09-17 12:10 | 2026-09-17 12:10 | AGQ | AGQ270115C00645000 | call | 645.0000 | 2027-01-15 | 0.8500 | 0.6500 | 0.8500 | 80.2258 | 59460.00 | 59460.00 | 0.00 | 701 | 5 | 875 | 2545 | 0.343811394891945 | 1.60543236557685 | 1.61605922532222 | false | false | false | |||||||||||||||||
| 9784a51e-361d-4021-86fd-d82be8b1e877 | 2026-09-17 10:00 | 2026-09-17 10:00 | 2026-09-17 10:00 | AGQ | AGQ261030C00078000 | call | 78.0000 | 2026-10-30 | 10.2900 | 10.3000 | 11.7000 | 79.9200 | 111136.00 | 0.00 | 111136.00 | 108 | 5 | 108 | 800 | 0.135 | 0.845505604637058 | 0.847389083628539 | false | false | false | |||||||||||||||||
| 526f8fdc-a86e-498d-ab8c-20c414382a30 | 2026-09-14 11:18 | 2026-09-14 11:18 | 2026-09-14 11:18 | AGQ | AGQ260925C00076000 | call | 76.0000 | 2026-09-25 | 3.4700 | 3.2000 | 3.9000 | 73.5200 | 10407.00 | 0.00 | 2242.00 | 30 | 5 | 38 | 10 | 3.8 | 0.829753782085439 | 0.8991543330446 | false | false | false | |||||||||||||||||
| 148e726e-4358-4b39-93c3-60bb28d8e989 | 2026-09-14 11:11 | 2026-09-14 11:10 | 2026-09-14 11:10 | AGQ | AGQ261002C00080000 | call | 80.0000 | 2026-10-02 | 3.5600 | 3.2000 | 3.6000 | 73.6800 | 10678.00 | 10678.00 | 0.00 | 30 | 10 | 31 | 31 | 1 | 0.904582018280572 | 0.904582018280572 | false | false | false | |||||||||||||||||
| 7f1be39c-3236-4109-a0a7-ee3a305a9506 | 2026-09-14 09:30 | 2026-09-14 09:30 | 2026-09-14 09:30 | AGQ | AGQ270617C00100000 | call | 100.0000 | 2027-06-17 | 16.4000 | 15.0000 | 17.0000 | 73.3275 | 41000.00 | 33500.00 | 7500.00 | 25 | 5 | 25 | 417 | 0.0599520383693046 | 0.931937424037647 | 0.872920520748053 | false | false | false | |||||||||||||||||
| b1df54fd-8945-4111-a41d-3204ee06e101 | 2026-09-10 13:46 | 2026-09-10 13:46 | 2026-09-10 13:46 | AGQ | AGQ261218C00070000 | call | 70.0000 | 2026-12-18 | 17.0200 | 16.4000 | 18.0000 | 76.5100 | 17021.00 | 3400.00 | 13621.00 | 10 | 6 | 11 | 188 | 0.0585106382978723 | 0.871874359006853 | 0.876735810333265 | false | false | false | |||||||||||||||||
| a48d6eae-924a-4678-a8b4-17a6e3c574f4 | 2026-09-08 13:05 | 2026-09-08 13:05 | 2026-09-08 13:05 | AGQ | AGQ270115C00100000 | call | 100.0000 | 2027-01-15 | 13.1300 | 12.2000 | 13.5000 | 82.6450 | 26252.00 | 26252.00 | 0.00 | 20 | 7 | 60 | 566 | 0.106007067137809 | 0.949020103834672 | 0.949020103834672 | false | false | false | |||||||||||||||||
| 996fce46-5a35-4267-bb6c-38572ea50df9 | 2026-09-04 12:24 | 2026-09-04 12:24 | 2026-09-04 12:24 | AGQ | AGQ260904C00078000 | call | 78.0000 | 2026-09-04 | 3.6500 | 2.6500 | 3.9000 | 81.3300 | 548198.00 | 548198.00 | 0.00 | 1500 | 18 | 2002 | 91 | 22 | 1.90890246194167 | 1.90890246194167 | false | false | false | |||||||||||||||||
| 192c98b0-003b-4d15-9d85-1ff7fbde11ff | 2026-09-04 09:30 | 2026-09-04 09:30 | 2026-09-04 09:30 | AGQ | AGQ270115C00100000 | call | 100.0000 | 2027-01-15 | 11.4800 | 10.8000 | 14.2000 | 79.8400 | 28694.00 | 0.00 | 28694.00 | 25 | 8 | 25 | 637 | 0.0392464678178964 | 0.885051335921992 | 0.965797603218771 | false | false | false | |||||||||||||||||
| 84930976-d280-42a4-9d76-3fdf2d3deb72 | 2026-09-02 12:56 | 2026-09-02 12:56 | 2026-09-02 12:56 | AGQ | AGQ261218C00125000 | call | 125.0000 | 2026-12-18 | 5.3300 | 5.2000 | 7.1000 | 78.7200 | 203564.00 | 68720.00 | 134844.00 | 382 | 20 | 382 | 91 | 4.1978021978022 | 0.949060716868957 | 0.970283525164312 | false | false | false | |||||||||||||||||
| 139e91ac-0f7f-4836-84c1-f81630995b73 | 2026-08-28 12:25 | 2026-08-28 12:25 | 2026-08-28 12:25 | AGQ | AGQ260918C00100000 | call | 100.0000 | 2026-09-18 | 2.2000 | 1.9500 | 2.7000 | 83.2500 | 88012.00 | 8800.00 | 79212.00 | 400 | 12 | 1191 | 3568 | 0.333800448430493 | 0.900215710998175 | 0.903490998415977 | false | false | false | |||||||||||||||||
| 6752b557-8b69-4dc9-9363-ed0e02b7eee4 | 2026-08-27 12:09 | 2026-08-27 12:09 | 2026-08-27 12:09 | AGQ | AGQ260911C00100000 | call | 100.0000 | 2026-09-11 | 3.3900 | 3.2000 | 3.4000 | 90.2000 | 101319.00 | 101319.00 | 0.00 | 299 | 6 | 306 | 48 | 6.375 | 0.938804988623489 | 0.938804988623489 | false | false | false | |||||||||||||||||
| 984eb3fe-6c07-4dbb-ae96-9f50874c578d | 2026-08-21 13:15 | 2026-08-21 13:15 | 2026-08-21 13:15 | AGQ | AGQ261218C00090000 | call | 90.0000 | 2026-12-18 | 20.2600 | 19.5000 | 20.7000 | 91.3400 | 50657.00 | 50657.00 | 0.00 | 25 | 13 | 48 | 130 | 0.369230769230769 | 0.933712798955933 | 0.933712798955933 | false | false | false | |||||||||||||||||
| 8cd8e6b7-083c-4d73-9029-1ccee02a8ac8 | 2026-08-20 09:34 | 2026-08-20 09:34 | 2026-08-20 09:34 | AGQ | AGQ270115C00100000 | call | 100.0000 | 2027-01-15 | 14.7300 | 13.0000 | 15.6000 | 84.3750 | 29464.00 | 29464.00 | 0.00 | 20 | 7 | 149 | 535 | 0.278504672897196 | 0.917239632943074 | 0.917239632943074 | false | false | false | |||||||||||||||||
| e8ee4059-dd6e-401b-ab93-8dec972c5542 | 2026-08-20 09:33 | 2026-08-20 09:33 | 2026-08-20 09:33 | AGQ | AGQ270115C00100000 | call | 100.0000 | 2027-01-15 | 14.5400 | 13.0000 | 15.7000 | 84.1301 | 43628.00 | 43628.00 | 0.00 | 30 | 10 | 129 | 535 | 0.241121495327103 | 0.914665110501703 | 0.914665110501703 | false | false | false | |||||||||||||||||
| 597ce507-85fe-4431-99d6-951b8ecf89b0 | 2026-08-20 09:32 | 2026-08-20 09:32 | 2026-08-20 09:32 | AGQ | AGQ270115C00100000 | call | 100.0000 | 2027-01-15 | 14.5800 | 13.0000 | 14.9000 | 84.3300 | 42278.00 | 42278.00 | 0.00 | 29 | 10 | 99 | 535 | 0.185046728971963 | 0.911776487735387 | 0.911776487735387 | false | false | false | |||||||||||||||||
| 000309af-3547-4aa0-b574-674d6aeef98c | 2026-08-19 09:31 | 2026-08-19 09:31 | 2026-08-19 09:31 | AGQ | AGQ270115C00100000 | call | 100.0000 | 2027-01-15 | 12.8400 | 10.9000 | 13.2000 | 80.4900 | 64218.00 | 64218.00 | 0.00 | 50 | 6 | 100 | 577 | 0.173310225303293 | 0.917174725099062 | 0.917174725099062 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1394498101.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:03:43.722265Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1451301514.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:19:13.860823Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1393893480.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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1393893480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:07:38.635762Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1448393626.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1448393626.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1448393626.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1448393626.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:09:00.187388Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1448393626.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:11:09.796111Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1390718619.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1390718619.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1390718619.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T17:36:40.694178Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1390718619.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1390718619.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:30:57.923324Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1390718619.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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1390718619.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1390718619.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1390718619.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1390718619.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |