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 | 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 |
|---|
| 69563ede-ad17-422b-9f7b-3057c164c55f | 2026-09-29 10:41 | 2026-09-29 10:41 | 2026-09-29 10:41 | BRKB | BRKB270115C00520000 | call | 520.0000 | 2027-01-15 | 11.6700 | 11.5500 | 11.7000 | 500.7800 | 46680.00 | 37440.00 | 9240.00 | 40 | 14 | 156 | 7668 | 0.0203442879499218 | 0.15703296412802 | 0.15560896069992 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 592100194133.00 | — | — | — | 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 |
| 997d31c4-d5ad-4c4e-8c1d-9e1487c0e609 | 2026-09-28 14:54 | 2026-09-28 14:54 | 2026-09-28 14:54 | BRKB | BRKB261120P00530000 | put | 530.0000 | 2026-11-20 | 28.2500 | 26.7500 | 28.2500 | 503.0700 | 152538.00 | 149718.00 | 2820.00 | 54 | 29 | 60 | 48 | 1.25 | 0.169094047689147 | 0.167788250821842 | true | false | ||||||||||||||||||
| 92be9e72-f07f-4655-9ca7-7ff5a3d3fca0 | 2026-09-28 13:36 | 2026-09-28 13:36 | 2026-09-28 13:36 | BRKB | BRKB261218P00540000 | put | 540.0000 | 2026-12-18 | 37.4000 | 35.1500 | 37.4000 | 503.0000 | 112196.00 | 112196.00 | 0.00 | 30 | 11 | 30 | 329 | 0.0911854103343465 | 0.177967091545782 | 0.177967091545782 | false | false | ||||||||||||||||||
| bd7c4da3-5cfa-463e-ad60-67c53b2d2fbf | 2026-09-28 10:53 | 2026-09-28 10:52 | 2026-09-28 10:52 | BRKB | BRKB261002C00507500 | call | 507.5000 | 2026-10-02 | 2.5900 | 2.3800 | 2.6200 | 505.7500 | 25937.00 | 25937.00 | 0.00 | 100 | 7 | 320 | 281 | 1.13879003558719 | 0.158115984973436 | 0.153922679523029 | false | false | ||||||||||||||||||
| a876b5ad-53cf-4c62-9f36-8cb6a58631a9 | 2026-09-25 15:14 | 2026-09-25 15:14 | 2026-09-25 15:14 | BRKB | BRKB270617C00550000 | call | 550.0000 | 2027-06-17 | 19.0800 | 19.0000 | 19.3500 | 504.7700 | 36253.00 | 9575.00 | 26678.00 | 19 | 7 | 20 | 1230 | 0.016260162601626 | 0.175979847922931 | 0.175434415003839 | false | false | ||||||||||||||||||
| 278a048a-eebf-4195-9818-57e0280552b0 | 2026-09-25 10:17 | 2026-09-25 10:17 | 2026-09-25 10:17 | BRKB | BRKB270617C00510000 | call | 510.0000 | 2027-06-17 | 36.9400 | 35.6000 | 36.9500 | 503.6836 | 66500.00 | 62810.00 | 3690.00 | 18 | 6 | 19 | 282 | 0.0673758865248227 | 0.186854760281813 | 0.18655640560472 | false | false | ||||||||||||||||||
| 6eca2d33-55d2-43e8-b1f7-1ab1e4545aea | 2026-09-25 10:05 | 2026-09-25 10:05 | 2026-09-25 10:05 | BRKB | BRKB261120P00480000 | put | 480.0000 | 2026-11-20 | 4.6700 | 3.8500 | 4.8000 | 502.0000 | 14955.00 | 7520.00 | 7435.00 | 32 | 8 | 37 | 845 | 0.0437869822485207 | 0.182566147043267 | 0.182566147043267 | false | false | ||||||||||||||||||
| 420e4c33-ad06-431e-a28c-2610150c2037 | 2026-09-25 10:04 | 2026-09-25 10:04 | 2026-09-25 10:04 | BRKB | BRKB270115P00460000 | put | 460.0000 | 2027-01-15 | 4.1700 | 3.5500 | 4.5500 | 503.0000 | 12510.00 | 6345.00 | 6165.00 | 30 | 6 | 30 | 2699 | 0.0111152278621712 | 0.1881414371083 | 0.187368310393976 | false | false | ||||||||||||||||||
| 185616c9-40f9-4cc1-9aa3-8fa6691685b9 | 2026-09-24 09:39 | 2026-09-24 09:39 | 2026-09-24 09:39 | BRKB | BRKB270319C00530000 | call | 530.0000 | 2027-03-19 | 18.8200 | 18.4500 | 19.7500 | 507.0735 | 58336.00 | 0.00 | 58336.00 | 31 | 12 | 31 | 1067 | 0.0290534208059981 | 0.171936220494804 | 0.171936220494804 | false | false | ||||||||||||||||||
| 60ddd80d-1bac-4536-81ee-86fbf627bef8 | 2026-09-23 14:30 | 2026-09-23 14:30 | 2026-09-23 14:30 | BRKB | BRKB270319C00535000 | call | 535.0000 | 2027-03-19 | 17.9600 | 17.8000 | 18.0000 | 509.5800 | 12570.00 | 3595.00 | 8975.00 | 7 | 5 | 17 | 162 | 0.104938271604938 | 0.171199184825763 | 0.170840498863598 | false | false | ||||||||||||||||||
| b7c77f93-57b5-4d85-b6fb-10f632a344c8 | 2026-09-22 09:57 | 2026-09-22 09:57 | 2026-09-22 09:57 | BRKB | BRKB261218C00560000 | call | 560.0000 | 2026-12-18 | 1.9900 | 1.7300 | 2.3200 | 503.5850 | 15907.00 | 0.00 | 15907.00 | 80 | 11 | 80 | 1299 | 0.0615858352578907 | 0.156916893702452 | 0.156916893702452 | false | false | ||||||||||||||||||
| 9f755bcc-3877-4840-98aa-fb5a148310be | 2026-09-21 15:21 | 2026-09-21 15:21 | 2026-09-21 15:21 | BRKB | BRKB261218P00530000 | put | 530.0000 | 2026-12-18 | 28.7000 | 26.3000 | 28.8000 | 504.6450 | 157840.00 | 152110.00 | 5730.00 | 55 | 23 | 55 | 630 | 0.0873015873015873 | 0.166453067318169 | 0.165896426111489 | true | false | ||||||||||||||||||
| 07cac729-41e1-496a-bb33-b6b4702577d1 | 2026-09-16 12:23 | 2026-09-16 12:23 | 2026-09-16 12:23 | BRKB | BRKB261016C00525000 | call | 525.0000 | 2026-10-16 | 6.4500 | 6.3500 | 6.5000 | 519.5100 | 129035.00 | 129035.00 | 0.00 | 200 | 10 | 689 | 2047 | 0.336590131900342 | 0.138517852708599 | 0.137664943961395 | false | false | ||||||||||||||||||
| 88cc720f-ff22-4518-aae6-df15c22076db | 2026-09-14 09:55 | 2026-09-14 09:55 | 2026-09-14 09:55 | BRKB | BRKB270917C00500000 | call | 500.0000 | 2027-09-17 | 63.4600 | 59.0000 | 63.5000 | 516.0150 | 1269290.00 | 425405.00 | 0.00 | 200 | 9 | 400 | 269 | 1.48698884758364 | 0.207664052733173 | 0.207392691364042 | false | false | ||||||||||||||||||
| cdfc26d9-2640-434c-a30c-6c32da67e886 | 2026-09-01 12:57 | 2026-09-01 12:57 | 2026-09-01 12:57 | BRKB | BRKB280121C00460000 | call | 460.0000 | 2028-01-21 | 90.3300 | 90.3000 | 92.3500 | 503.3550 | 135495.00 | 0.00 | 90320.00 | 15 | 15 | 215 | 643 | 0.334370139968896 | 0.21498987647704 | 0.214716025267144 | false | false | ||||||||||||||||||
| fbc98257-b1b2-473a-a34d-1ec2f4c8f600 | 2026-09-01 10:28 | 2026-09-01 10:28 | 2026-09-01 10:28 | BRKB | BRKB281215C00550000 | call | 550.0000 | 2028-12-15 | 66.8900 | 63.5000 | 67.7000 | 505.6401 | 173904.00 | 154104.00 | 19800.00 | 26 | 5 | 26 | 1135 | 0.0229074889867841 | 0.211436741870165 | 0.206551238371581 | false | false | ||||||||||||||||||
| 85b14092-732d-4b69-b4e9-60474d622993 | 2026-08-31 12:56 | 2026-08-31 12:56 | 2026-08-31 12:56 | BRKB | BRKB270115C00530000 | call | 530.0000 | 2027-01-15 | 10.9000 | 10.9000 | 11.4000 | 503.2800 | 930948.00 | 0.00 | 930948.00 | 854 | 6 | 2019 | 2607 | 0.774453394706559 | 0.152158635225112 | 0.150257680054488 | false | false | ||||||||||||||||||
| b73f3466-adef-41d6-9b51-a883f3ac9807 | 2026-08-28 15:24 | 2026-08-28 15:23 | 2026-08-28 15:23 | BRKB | BRKB280121C00460000 | call | 460.0000 | 2028-01-21 | 92.2200 | 91.8000 | 92.9000 | 505.1600 | 202885.00 | 0.00 | 92220.00 | 22 | 22 | 151 | 487 | 0.31006160164271 | 0.21935456292076 | 0.219083335899375 | false | false | ||||||||||||||||||
| 3e7acf3a-32b1-4542-bc4d-109037a30c46 | 2026-08-27 12:28 | 2026-08-27 12:28 | 2026-08-27 12:28 | BRKB | BRKB270617C00490000 | call | 490.0000 | 2027-06-17 | 48.0500 | 48.0500 | 52.3500 | 503.0700 | 961027.00 | 0.00 | 961027.00 | 200 | 5 | 402 | 699 | 0.575107296137339 | 0.180642837167075 | 0.181199693585959 | false | false | ||||||||||||||||||
| 2f1845ff-25fb-4d1b-8e37-b770a3e4f856 | 2026-08-26 15:55 | 2026-08-26 15:55 | 2026-08-26 15:55 | BRKB | BRKB261120P00500000 | put | 500.0000 | 2026-11-20 | 11.1500 | 11.1500 | 11.5500 | 504.9200 | 202936.00 | 0.00 | 202936.00 | 182 | 26 | 1424 | 337 | 4.22551928783383 | 0.159294392603303 | 0.159187940452717 | true | false | ||||||||||||||||||
| 9a6fcca9-8190-450b-97dc-678e9208c88d | 2026-08-26 12:42 | 2026-08-26 12:42 | 2026-08-26 12:42 | BRKB | BRKB261120P00520000 | put | 520.0000 | 2026-11-20 | 21.2500 | 20.8000 | 21.6500 | 504.8201 | 135995.00 | 133870.00 | 2125.00 | 64 | 28 | 84 | 51 | 1.64705882352941 | 0.156491864012376 | 0.156491864012376 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 592100194133.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:00:50.307488Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 592100194133.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:41:35.586557Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 592100194133.00 |
| — |
| — |
| — |
| 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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 592100194133.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:17:13.698421Z"} |
| 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 |
| 592100194133.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:17:27.635758Z"} |
| 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 |
| 592100194133.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:05:23.720155Z"} |
| 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 |
| 592100194133.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:05:23.720155Z"} |
| 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 |
| 592100194133.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:40:59.800251Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 592100194133.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:35:00.755474Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 592100194133.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:58:41.675080Z"} |
| 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 |
| 592100194133.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:25:50.208697Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 592100194133.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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 592100194133.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} |
| 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 |
| 592100194133.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T17:20:15.685951Z"} |
| 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 |
| 592100194133.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 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 |
| 592100194133.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:08:52.274087Z"} |
| 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 |
| 592100194133.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T19:36:54.231390Z"} |
| 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 |
| 592100194133.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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 592100194133.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:59:46.397035Z"} |
| 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 |
| 592100194133.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 |