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_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 | 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 |
|---|
| 3d2c6913-9055-4e88-ad4a-3a967d75237a | 2026-08-21 11:17 | 2026-08-21 11:17 | 2026-08-21 11:17 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 4.6000 | 4.3500 | 4.6000 | 196.9250 | 117300.00 | 117300.00 | 0.00 | 255 | 35 | 311 | 2911 | 0.106836138783923 | 0.88009668838027 | 0.88009668838027 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 75708254289.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0aeab449-8709-49c3-9eb5-16e6670e1c9b | 2026-09-08 10:14 | 2026-09-08 10:14 | 2026-09-08 10:14 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 22.0000 | 22.0000 | 22.5000 | 274.2100 | 118800.00 | 0.00 | 118800.00 | 54 | 5 | 720 | 3602 | 0.199888950583009 | 0.89396928352785 | 0.89396928352785 | false | false | false | true | ||||||||||||||||
| c8900070-7d3e-4e4b-8dda-2964eb2d7985 | 2026-09-08 12:20 | 2026-09-08 12:19 | 2026-09-08 12:19 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 25.1500 | 24.3500 | 25.4000 | 279.4700 | 150900.00 | 75600.00 | 75300.00 | 60 | 8 | 1098 | 3602 | 0.304830649639089 | 0.916890654612525 | 0.914102295775751 | true | false | false | true | ||||||||||||||||
| 8647ad7a-14c6-44d8-9d30-b0dbdc813b34 | 2026-09-08 12:51 | 2026-09-08 12:51 | 2026-09-08 12:51 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 25.4700 | 25.1500 | 25.7000 | 280.7200 | 152800.00 | 94265.00 | 58535.00 | 60 | 7 | 2513 | 3602 | 0.697667962243198 | 0.90746415265565 | 0.90746415265565 | false | false | false | true | ||||||||||||||||
| abd518a8-038b-4096-af15-0206091856fe | 2026-09-08 12:51 | 2026-09-08 12:51 | 2026-09-08 12:51 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 25.7500 | 25.7500 | 26.0000 | 281.3150 | 128750.00 | 0.00 | 128750.00 | 50 | 5 | 2761 | 3602 | 0.766518600777346 | 0.907946560595141 | 0.907946560595141 | false | false | false | true | ||||||||||||||||
| 1a95c358-0ff8-4ba5-b348-0b62b6a896cb | 2026-09-08 14:25 | 2026-09-08 14:25 | 2026-09-08 14:25 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 26.1000 | 26.1000 | 26.5000 | 282.1280 | 261000.00 | 0.00 | 261000.00 | 100 | 5 | 4090 | 3602 | 1.13548028872848 | 0.90687368543531 | 0.90687368543531 | false | false | false | true | ||||||||||||||||
| 23be4be2-760c-4411-949c-b7cda3e168fe | 2026-09-08 14:28 | 2026-09-08 14:28 | 2026-09-08 14:28 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 26.0000 | 26.0000 | 26.3500 | 282.2600 | 200215.00 | 0.00 | 200215.00 | 77 | 13 | 4172 | 3602 | 1.15824541921155 | 0.904608509510322 | 0.902370359626782 | false | false | false | true | ||||||||||||||||
| 5ec64515-a219-4802-88a7-fc3bc47475a3 | 2026-09-14 10:01 | 2026-09-14 10:01 | 2026-09-14 10:01 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 11.0300 | 10.6500 | 11.1000 | 256.8750 | 80552.00 | 80552.00 | 0.00 | 73 | 8 | 609 | 3599 | 0.169213670464018 | 0.829024119096547 | 0.825295803939479 | false | false | false | true | ||||||||||||||||
| 34401cfa-1018-4a4f-a941-3c8bc49038f6 | 2026-09-15 10:42 | 2026-09-15 10:42 | 2026-09-15 10:42 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 13.1000 | 13.0500 | 13.1000 | 265.3700 | 52400.00 | 52400.00 | 0.00 | 40 | 12 | 430 | 4458 | 0.0964558097801705 | 0.813390808358761 | 0.813390808358761 | true | false | false | true | ||||||||||||||||
| 879e81f5-c887-44d0-9bb5-4f1b42634d01 | 2026-09-17 10:14 | 2026-09-17 10:14 | 2026-09-17 10:14 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 17.1100 | 17.1000 | 17.4000 | 278.4000 | 102660.00 | 5145.00 | 97515.00 | 60 | 20 | 284 | 4029 | 0.0704889550757012 | 0.809293657805955 | 0.809293657805955 | true | false | false | true | ||||||||||||||||
| f62dd35a-0c70-43d1-a10c-931462b98fea | 2026-09-21 10:11 | 2026-09-21 10:11 | 2026-09-21 10:11 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 10.7500 | 10.7000 | 10.7500 | 267.0000 | 108575.00 | 108575.00 | 0.00 | 101 | 21 | 226 | 4034 | 0.0560237977193852 | 0.782477789701825 | 0.782477789701825 | false | false | false | true | ||||||||||||||||
| 225ebf8c-b288-4b0f-881d-fd4bf903ea7e | 2026-09-21 10:11 | 2026-09-21 10:11 | 2026-09-21 10:11 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 10.7400 | 10.6000 | 10.8000 | 267.0000 | 61241.00 | 61241.00 | 0.00 | 57 | 5 | 525 | 4034 | 0.130143777887952 | 0.787290843824041 | 0.783738144670107 | false | false | false | true | ||||||||||||||||
| 013c02ca-4d4d-4570-8154-e43bb50b3b1f | 2026-09-21 10:58 | 2026-09-21 10:58 | 2026-09-21 10:58 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 13.0400 | 12.7500 | 13.0500 | 273.8500 | 14345.00 | 14345.00 | 0.00 | 11 | 5 | 657 | 4034 | 0.162865642042638 | 0.788465497613272 | 0.790309069144463 | false | false | false | true | ||||||||||||||||
| 803c1c99-7cda-43aa-bfc0-8503de3b153b | 2026-09-21 12:09 | 2026-09-21 12:09 | 2026-09-21 12:09 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 14.8000 | 14.4000 | 14.8000 | 277.4650 | 914335.00 | 904010.00 | 10325.00 | 618 | 13 | 1544 | 4034 | 0.382746653445711 | 0.801317162866986 | 0.801317162866986 | false | false | false | true | ||||||||||||||||
| 6f2b67d9-be3d-4df5-93cc-fa933afe5495 | 2026-09-21 15:07 | 2026-09-21 15:07 | 2026-09-21 15:07 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 13.1500 | 13.1000 | 13.3000 | 273.8800 | 65750.00 | 0.00 | 65750.00 | 50 | 13 | 1811 | 4034 | 0.44893406048587 | 0.793580964432757 | 0.793580964432757 | false | false | false | true | ||||||||||||||||
| 53829a77-1e1f-4d77-b572-e801c96f74e0 | 2026-09-21 15:09 | 2026-09-21 15:09 | 2026-09-21 15:09 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 12.8000 | 12.7500 | 13.0000 | 273.1250 | 320000.00 | 0.00 | 320000.00 | 250 | 9 | 2096 | 4034 | 0.519583539910759 | 0.79099729990119 | 0.79099729990119 | false | false | false | true | ||||||||||||||||
| 450d1e59-2bb8-4d30-8538-81fd817b6a01 | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 15.3000 | 14.2000 | 15.5000 | 279.8700 | 15300.00 | 15300.00 | 0.00 | 10 | 5 | 422 | 4499 | 0.0937986219159813 | 0.802726032382319 | 0.802872131440621 | false | false | false | true | ||||||||||||||||
| d684860b-8881-4c6d-950a-8dff16b39bc3 | 2026-09-22 09:45 | 2026-09-22 09:45 | 2026-09-22 09:45 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 13.1600 | 13.1500 | 15.1000 | 276.0000 | 52620.00 | 0.00 | 52620.00 | 40 | 7 | 478 | 4499 | 0.106245832407202 | 0.774116730479026 | 0.774116730479026 | false | false | false | true | ||||||||||||||||
| c9904ac1-1991-4a6a-8690-dfe3ac227898 | 2026-09-22 10:26 | 2026-09-22 10:26 | 2026-09-22 10:26 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 16.9800 | 16.1000 | 17.1000 | 283.0000 | 10190.00 | 6805.00 | 3385.00 | 6 | 6 | 646 | 4499 | 0.143587463880862 | 0.807585058961075 | 0.804751925090273 | false | false | false | true | ||||||||||||||||
| 90f28708-ae2b-4e6d-80d1-7db1738201c0 | 2026-09-25 10:04 | 2026-09-25 10:04 | 2026-09-25 10:04 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 16.4500 | 16.2500 | 16.7000 | 286.0000 | 36186.00 | 1640.00 | 32901.00 | 22 | 16 | 564 | 5090 | 0.110805500982318 | 0.791299169999265 | 0.789461529820685 | true | false | false | true | ||||||||||||||||
| 36782d70-65ce-433f-ba61-2e7b7ede340d | 2026-09-25 12:02 | 2026-09-25 12:02 | 2026-09-25 12:02 | BE | BE261016C00300000 | call | 300.0000 | 2026-10-16 | 18.4200 | 18.3500 | 18.5000 | 291.5600 | 771909.00 | 566389.00 | 205520.00 | 419 | 44 | 1650 | 5090 | 0.324165029469548 | 0.783230446560218 | 0.783230446560218 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:43:21.019108Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:43:21.019108Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:14:09.812180Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 82691497663.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 80373567450.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:12:42.136586Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 80373567450.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:12:42.136586Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 80373567450.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:59:04.068372Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 80373567450.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:10:34.961716Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 80373567450.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 80373567450.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 81445646989.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 81445646989.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:45:11.876123Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 81445646989.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:27:42.600893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 85030044790.00 |
| 2026-10-27 |
| unknown |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 85030044790.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:03:52.208373Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |