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_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 | expiry |
|---|
| 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 |
|---|
| 8c321f10-667b-47c5-9f5b-746b9d298cad | 2026-08-17 14:42 | 2026-08-17 14:42 | 2026-08-17 14:42 | BKNG | BKNG270115C00224000 | call | 224.0000 | 2027-01-15 | 11.4000 | 11.4000 | 11.9000 | 205.2000 | 76382.00 | 0.00 | 76382.00 | 67 | 15 | 139 | 1257 | 0.110580747812251 | 0.329979431271332 | 0.329979431271332 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 131754570675.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e48bc35a-8e29-484e-bb43-87a099800829 | 2026-08-18 09:47 | 2026-08-18 09:47 | 2026-08-18 09:47 | BKNG | BKNG270115C00212000 | call | 212.0000 | 2027-01-15 | 17.6000 | 17.6000 | 18.3000 | 208.0000 | 70403.00 | 0.00 | 70403.00 | 40 | 9 | 50 | 2543 | 0.0196618167518679 | 0.33407777419189 | 0.334266473395139 | false | false | false | true | ||||||||||||||||
| 49f3bb5c-16c3-417c-ab3e-5e79d3d11ab4 | 2026-08-19 13:11 | 2026-08-19 13:11 | 2026-08-19 13:11 | BKNG | BKNG261016C00220000 | call | 220.0000 | 2026-10-16 | 9.1000 | 9.1000 | 9.9000 | 214.7400 | 863610.00 | 0.00 | 863610.00 | 949 | 66 | 954 | 537 | 1.77653631284916 | 0.316099746590712 | 0.31802781749494 | false | false | false | true | ||||||||||||||||
| e5a86c2b-d3a4-4ab4-810d-a25d2fa3b697 | 2026-08-19 13:58 | 2026-08-19 13:58 | 2026-08-19 13:58 | BKNG | BKNG281215P00215200 | put | 215.2000 | 2028-12-15 | 38.6600 | 38.3000 | 47.8000 | 214.6400 | 69591.00 | 27090.00 | 42501.00 | 18 | 5 | 23 | 15 | 1.53333333333333 | 0.388316374168619 | 0.388401347630292 | false | false | false | true | ||||||||||||||||
| 010db74d-81b5-4e27-afbe-55548b80bd49 | 2026-08-21 10:32 | 2026-08-21 10:32 | 2026-08-21 10:32 | BKNG | BKNG260821C00185000 | call | 185.0000 | 2026-08-21 | 24.6000 | 23.0000 | 25.5000 | 209.5800 | 61499.00 | 61499.00 | 0.00 | 25 | 17 | 26 | 1086 | 0.0239410681399632 | 3.91082245767027 | 3.91082245767027 | false | false | false | true | ||||||||||||||||
| 96b826fe-2f71-4fba-81c5-3fcf39a19f9f | 2026-08-24 14:48 | 2026-08-24 14:48 | 2026-08-24 14:48 | BKNG | BKNG280121P00240000 | put | 240.0000 | 2028-01-21 | 45.4000 | 45.3000 | 48.1000 | 213.5100 | 272370.00 | 9200.00 | 263170.00 | 60 | 14 | 60 | 19 | 3.15789473684211 | 0.374742307687556 | 0.381693766570477 | false | false | false | true | ||||||||||||||||
| f2c45f87-35d6-48e9-b56d-679cfd06fdef | 2026-08-26 13:20 | 2026-08-26 13:20 | 2026-08-26 13:20 | BKNG | BKNG260828P00210000 | put | 210.0000 | 2026-08-28 | 3.2300 | 2.0000 | 3.3000 | 209.3400 | 161335.00 | 148170.00 | 12900.00 | 500 | 17 | 585 | 1044 | 0.560344827586207 | 0.376168849447133 | 0.364796086085645 | false | false | false | |||||||||||||||||
| 86af839f-dfa0-4d26-9494-678c8b2a4745 | 2026-08-28 13:12 | 2026-08-28 13:12 | 2026-08-28 13:12 | BKNG | BKNG280121P00236000 | put | 236.0000 | 2028-01-21 | 47.9000 | 44.3000 | 47.9000 | 205.9500 | 134113.00 | 134113.00 | 0.00 | 28 | 9 | 85 | 0 | 0 | 0.389714625946066 | 0.389817692902532 | false | false | false | true | ||||||||||||||||
| 67266112-9ee8-4fcc-a225-1ab01d640aef | 2026-09-03 11:59 | 2026-09-03 11:58 | 2026-09-03 11:58 | BKNG | BKNG260918P00200000 | put | 200.0000 | 2026-09-18 | 5.7000 | 5.6000 | 5.8000 | 199.0000 | 64932.00 | 0.00 | 15912.00 | 114 | 5 | 118 | 1506 | 0.0783532536520584 | 0.330689587705435 | 0.330689587705435 | false | false | false | true | ||||||||||||||||
| a732a757-a906-4f5a-8902-ecd3a126926f | 2026-09-04 10:43 | 2026-09-04 10:43 | 2026-09-04 10:43 | BKNG | BKNG260925C00190000 | call | 190.0000 | 2026-09-25 | 7.5000 | 7.5000 | 7.9000 | 193.1400 | 57774.00 | 1520.00 | 56254.00 | 77 | 23 | 77 | 5 | 15.4 | 0.302616464385622 | 0.302616464385622 | true | false | false | true | ||||||||||||||||
| 04cb7148-14e8-4663-b8fa-52ddcdf2b33b | 2026-09-08 09:50 | 2026-09-08 09:50 | 2026-09-08 09:50 | BKNG | BKNG281215P00120000 | put | 120.0000 | 2028-12-15 | 9.0400 | 9.0000 | 12.0000 | 185.3700 | 99416.00 | 0.00 | 99416.00 | 110 | 10 | 110 | 418 | 0.263157894736842 | 0.407678117979877 | 0.409110596107109 | false | false | false | true | ||||||||||||||||
| 2c698ff3-7b03-4710-9062-005ceeee46b7 | 2026-09-08 11:45 | 2026-09-08 11:45 | 2026-09-08 11:45 | BKNG | BKNG260918P00187500 | put | 187.5000 | 2026-09-18 | 7.8900 | 7.0000 | 8.2000 | 182.0800 | 78878.00 | 78878.00 | 0.00 | 100 | 6 | 107 | 203 | 0.527093596059113 | 0.395617767610106 | 0.395617767610106 | false | false | false | true | ||||||||||||||||
| 70e6ad78-4a37-45df-ab24-68fe9ce9e0e4 | 2026-09-09 09:36 | 2026-09-09 09:36 | 2026-09-09 09:36 | BKNG | BKNG270319P00154400 | put | 154.4000 | 2027-03-19 | 10.8100 | 7.0000 | 10.8000 | 170.9700 | 230237.00 | 230237.00 | 0.00 | 213 | 10 | 422 | 595 | 0.709243697478992 | 0.410429861813952 | 0.410429861813952 | false | false | false | true | ||||||||||||||||
| 5dd0e7ac-d30a-49cd-8b24-9f816a33b8bf | 2026-09-11 11:08 | 2026-09-11 11:08 | 2026-09-11 11:08 | BKNG | BKNG270115C00222000 | call | 222.0000 | 2027-01-15 | 3.3000 | 3.3000 | 3.8000 | 173.7200 | 174263.00 | 0.00 | 174263.00 | 528 | 33 | 528 | 526 | 1.00380228136882 | 0.377147353841895 | 0.377147353841895 | false | false | false | true | ||||||||||||||||
| 89fdd78a-3b92-4304-a945-27a8364072af | 2026-09-18 14:34 | 2026-09-18 14:34 | 2026-09-18 14:34 | BKNG | BKNG261016P00150000 | put | 150.0000 | 2026-10-16 | 1.2400 | 0.9500 | 1.3000 | 167.8800 | 81005.00 | 79755.00 | 1250.00 | 651 | 19 | 1105 | 679 | 1.62739322533137 | 0.389225936401375 | 0.390729157883602 | true | false | false | true | ||||||||||||||||
| 9b99b40f-7814-4828-8b91-a7bce9978534 | 2026-09-18 14:37 | 2026-09-18 14:37 | 2026-09-18 14:37 | BKNG | BKNG261016P00150000 | put | 150.0000 | 2026-10-16 | 1.3200 | 1.0000 | 1.4000 | 167.9500 | 131591.00 | 116041.00 | 13795.00 | 1000 | 100 | 2105 | 679 | 3.10014727540501 | 0.397153613580233 | 0.401650251847323 | true | false | false | |||||||||||||||||
| 6f970c9b-da99-40f3-b1c5-b5cd085d4ed5 | 2026-09-21 15:01 | 2026-09-21 15:01 | 2026-09-21 15:01 | BKNG | BKNG261120P00150000 | put | 150.0000 | 2026-11-20 | 3.5700 | 3.2000 | 3.7000 | 169.0000 | 34304.00 | 34304.00 | 0.00 | 96 | 5 | 165 | 182 | 0.906593406593407 | 0.423448222815458 | 0.423448222815458 | false | false | false | true | ||||||||||||||||
| ed14d0bd-9aab-42e8-ba64-affe295b2314 | 2026-09-22 10:10 | 2026-09-22 10:10 | 2026-09-22 10:10 | BKNG | BKNG270319P00154000 | put | 154.0000 | 2027-03-19 | 10.8000 | 9.1000 | 10.9000 | 167.6730 | 100428.00 | 100428.00 | 0.00 | 93 | 5 | 93 | 508 | 0.183070866141732 | 0.406314856990512 | 0.406314856990512 | false | false | false | true | ||||||||||||||||
| c37d2276-6eae-45dd-85fd-06b7f8fee945 | 2026-09-22 12:03 | 2026-09-22 12:02 | 2026-09-22 12:02 | BKNG | BKNG261218C00180000 | call | 180.0000 | 2026-12-18 | 6.4700 | 6.1000 | 6.5000 | 161.5700 | 64729.00 | 64729.00 | 0.00 | 100 | 8 | 136 | 477 | 0.285115303983228 | 0.397721713974079 | 0.397721713974079 | false | false | false | true | ||||||||||||||||
| 9b6f35aa-4221-4161-9f41-ee4a0b018b4a | 2026-09-22 15:52 | 2026-09-22 15:52 | 2026-09-22 15:52 | BKNG | BKNG260925C00170000 | call | 170.0000 | 2026-09-25 | 1.3000 | 0.9000 | 1.4000 | 165.1600 | 32797.00 | 7832.00 | 24965.00 | 252 | 10 | 929 | 1288 | 0.721273291925466 | 0.50943803370652 | 0.531944235159956 | false | false | false | |||||||||||||||||
| e6b5bbcc-3a02-485d-8785-41f989535cb9 | 2026-09-22 15:53 | 2026-09-22 15:53 | 2026-09-22 15:53 | BKNG | BKNG261120C00170000 | call | 170.0000 | 2026-11-20 | 9.7500 | 9.1000 | 9.9000 | 165.0000 | 28262.00 | 28262.00 | 0.00 | 29 | 8 | 963 | 106 | 9.08490566037736 | 0.425367888676144 | 0.425367888676144 | false | false | false | true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 131754570675.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 131754570675.00 |
| 2026-10-27 |
| unknown |
| — |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 131754570675.00 |
| 2026-10-27 |
| unknown |
| — |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 131754570675.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 131754570675.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:49:58.488781Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 131754570675.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T17:27:57.423992Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 131754570675.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T17:15:24.821907Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 131754570675.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:03:37.205690Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 131754570675.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:44:26.340635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 131754570675.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 131754570675.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 131754570675.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:46:31.810255Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 131754570675.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:28:46.184785Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 126156785950.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 126156785950.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 126622641860.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:06:05.917319Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 123391705710.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:11:50.316445Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 123391705710.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:07:35.242191Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 123391705710.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 123391705710.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |