Options flow alerts (market-wide)
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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 rowsrestricted — hover for the licence
active:ticker = OWL×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125d665e-e067-46f0-b6a7-ef4c71b8058b | 2026-08-24 09:39 | 2026-08-24 09:39 | 2026-08-24 09:39 | OWL | OWL270115P00009000 | put | 9.0000 | 2027-01-15 | 0.3500 | 0.3000 | 0.4500 | 11.6200 | 21522.00 | 0.00 | 21522.00 | 610 | 6 | 610 | 6229 | 0.0979290415797078 | 0.511646490068468 | 0.511646490068468 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:46:45.098903Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c6fb0a57-f8aa-4a76-8931-07dd8fff7fa8 | 2026-08-21 15:59 | 2026-08-21 15:59 | 2026-08-21 15:59 | OWL | OWL270115P00009000 | put | 9.0000 | 2027-01-15 | 0.4000 | 0.3500 | 0.4000 | 11.6700 | 20000.00 | 20000.00 | 0.00 | 500 | 16 | 512 | 6704 | 0.0763723150357995 | 0.53343225893627 | 0.53343225893627 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ffaa33e4-169d-49f8-94f1-e52ddcfb34c0 | 2026-08-21 11:57 | 2026-08-21 11:56 | 2026-08-21 11:56 | OWL | OWL260821C00011000 | call | 11.0000 | 2026-08-21 | 0.6000 | 0.6000 | 0.6500 | 11.6150 | 12000.00 | 0.00 | 12000.00 | 200 | 5 | 2225 | 2913 | 0.763817370408514 | 2.23153931445598 | 2.23153931445598 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 299ac8e5-d3b7-4c75-9c41-42ddfea914fc | 2026-08-21 11:53 | 2026-08-21 11:53 | 2026-08-21 11:53 | OWL | OWL260821C00011000 | call | 11.0000 | 2026-08-21 | 0.6000 | 0.6000 | 0.6500 | 11.6250 | 15000.00 | 0.00 | 15000.00 | 250 | 12 | 1274 | 2913 | 0.437349811191212 | 2.02994563596673 | 2.02994563596673 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ef8241f2-8e83-4f65-824d-d79231265151 | 2026-08-21 11:53 | 2026-08-21 11:53 | 2026-08-21 11:53 | OWL | OWL260821C00011000 | call | 11.0000 | 2026-08-21 | 0.6000 | 0.6000 | 0.6500 | 11.6250 | 15000.00 | 0.00 | 15000.00 | 250 | 14 | 1024 | 2913 | 0.351527634740817 | 2.02967043893487 | 2.02967043893487 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b87f8b7e-54f7-4eba-a829-e99475db34ed | 2026-08-20 14:27 | 2026-08-20 14:26 | 2026-08-20 14:26 | OWL | OWL260828C00012000 | call | 12.0000 | 2026-08-28 | 0.1000 | 0.1000 | 0.1500 | 11.5311 | 153750.00 | 11250.00 | 142500.00 | 15000 | 2 | 15007 | 730 | 20.5575342465753 | 0.475175824768874 | 0.475175824768874 | false | true | false | true | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ab90a77b-21fc-4130-a04a-d3a2a1e8783a | 2026-08-20 12:09 | 2026-08-20 12:09 | 2026-08-20 12:09 | OWL | OWL261120P00011000 | put | 11.0000 | 2026-11-20 | 0.8700 | 0.8000 | 0.9000 | 11.6037 | 17400.00 | 17400.00 | 0.00 | 200 | 5 | 50258 | 315 | 159.549206349206 | 0.530746741914347 | 0.530746741914347 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1858ec38-96ae-4058-8751-ef13aef5d924 | 2026-08-19 14:56 | 2026-08-19 14:56 | 2026-08-19 14:56 | OWL | OWL270115P00009000 | put | 9.0000 | 2027-01-15 | 0.4000 | 0.3500 | 0.4000 | 11.7600 | 41600.00 | 41600.00 | 0.00 | 1040 | 7 | 1043 | 5045 | 0.206739345887017 | 0.538034835752955 | 0.538034835752955 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e8d370c9-063d-4679-b8f9-62ff006468f4 | 2026-08-19 11:53 | 2026-08-19 11:53 | 2026-08-19 11:53 | OWL | OWL260918C00013000 | call | 13.0000 | 2026-09-18 | 0.2500 | 0.1500 | 0.3000 | 11.8700 | 90973.00 | 90673.00 | 300.00 | 3639 | 70 | 4867 | 3425 | 1.42102189781022 | 0.466131745909871 | 0.462497160775363 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9673779b-0251-4be3-8443-0572323c0eff | 2026-08-19 11:22 | 2026-08-19 11:22 | 2026-08-19 11:22 | OWL | OWL261016C00013000 | call | 13.0000 | 2026-10-16 | 0.4500 | 0.4500 | 0.5000 | 11.9150 | 15750.00 | 0.00 | 15750.00 | 350 | 8 | 514 | 978 | 0.525562372188139 | 0.436899279026223 | 0.436899279026223 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 84263d86-df17-4510-9f43-4707852031df | 2026-08-19 11:09 | 2026-08-19 11:09 | 2026-08-19 11:09 | OWL | OWL260918C00013000 | call | 13.0000 | 2026-09-18 | 0.2500 | 0.2000 | 0.3000 | 11.8700 | 26038.00 | 25988.00 | 50.00 | 1042 | 62 | 1062 | 3425 | 0.31007299270073 | 0.462521404171984 | 0.462497160775363 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0d89d22a-57e7-4561-809e-12f7a594a992 | 2026-08-18 13:49 | 2026-08-18 13:49 | 2026-08-18 13:49 | OWL | OWL261120P00012000 | put | 12.0000 | 2026-11-20 | 1.3500 | 1.3000 | 1.3500 | 11.6350 | 13463.00 | 13463.00 | 0.00 | 100 | 10 | 500 | 238 | 2.10084033613445 | 0.51117867531857 | 0.515429289314297 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d07c8845-ef77-4b06-9bff-c858e2c5c468 | 2026-08-18 13:49 | 2026-08-18 13:48 | 2026-08-18 13:48 | OWL | OWL261120P00012000 | put | 12.0000 | 2026-11-20 | 1.3500 | 1.3000 | 1.3500 | 11.6250 | 53998.00 | 53998.00 | 0.00 | 400 | 37 | 400 | 238 | 1.68067226890756 | 0.513386161232946 | 0.513386161232946 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aa8c5b01-9377-447b-8960-85b1544f2770 | 2026-08-18 13:12 | 2026-08-18 13:11 | 2026-08-18 13:11 | OWL | OWL280121C00013000 | call | 13.0000 | 2028-01-21 | 2.0300 | 1.9500 | 2.0500 | 11.6150 | 20330.00 | 20330.00 | 0.00 | 100 | 5 | 146 | 26965 | 0.00541442610791767 | 0.417975938499867 | 0.414326499179054 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 62a3a21d-8536-48e4-a56b-bdb8074d04fd | 2026-08-18 10:37 | 2026-08-18 10:37 | 2026-08-18 10:37 | OWL | OWL270115C00011000 | call | 11.0000 | 2027-01-15 | 1.7000 | 1.6000 | 1.7500 | 11.6650 | 16320.00 | 7140.00 | 9180.00 | 96 | 8 | 96 | 1853 | 0.0518078791149487 | 0.430506706067956 | 0.430506706067956 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9d91613b-a3d9-4eb0-b99f-9028d0c67fc2 | 2026-08-17 15:32 | 2026-08-17 15:32 | 2026-08-17 15:32 | OWL | OWL270219P00010000 | put | 10.0000 | 2027-02-19 | 0.8500 | 0.7500 | 0.8500 | 11.6800 | 12835.00 | 12835.00 | 0.00 | 151 | 5 | 162 | 7360 | 0.0220108695652174 | 0.53412711397685 | 0.53412711397685 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 427fd542-b40d-4940-a3ce-edac04be1889 | 2026-08-17 14:33 | 2026-08-17 14:33 | 2026-08-17 14:33 | OWL | OWL260918C00010000 | call | 10.0000 | 2026-09-18 | 1.8000 | 1.8000 | 2.0500 | 11.7050 | 18000.00 | 0.00 | 18000.00 | 100 | 10 | 207 | 3773 | 0.0548635038430957 | 0.419348090752926 | 0.419348090752926 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |