uw_flow_alerts728,802 rows| iduuid | created_at ↑timestamp with time zone | start_timetimestamp with time zone | end_timetimestamp with time zone | tickertext | option_symboltext | option_typetext | strikenumeric |
|---|
| 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 |
|---|
| 9eb0f322-ab2e-435c-82a1-e0ffdf5c7799 | 2026-09-18 13:23 | 2026-09-18 13:23 | 2026-09-18 13:23 | USO | USO261002P00145000 | put | 145.0000 | 2026-10-02 | 2.1500 | 2.1200 | 2.3500 | 153.8307 | 19999.00 | 218.00 | 19781.00 | 93 | 17 | 641 | 4370 | 0.146681922196796 | 0.47509727546157 | 0.478277907539524 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | Financial Services | 1228364647.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 9546c62a-7d03-4534-8141-bfb937180532 | 2026-09-28 10:48 | 2026-09-28 10:48 | 2026-09-28 10:48 | USO | USO261002P00145000 | put | 145.0000 | 2026-10-02 | 1.3700 | 1.2800 | 1.3700 | 152.0000 | 53933.00 | 53933.00 | 0.00 | 395 | 6 | 1714 | 4146 | 0.413410516160154 | 0.67536058320162 | 0.67536058320162 | false | false | false | |||||||||||||||||
| 1490f76a-711d-4682-b446-5b6f06772772 | 2026-09-28 11:00 | 2026-09-28 11:00 | 2026-09-28 11:00 | USO | USO261002P00145000 | put | 145.0000 | 2026-10-02 | 1.1700 | 1.1200 | 1.2400 | 153.7900 | 13749.00 | 4176.00 | 5946.00 | 118 | 11 | 2130 | 4146 | 0.513748191027496 | 0.669851845255594 | 0.672143586963228 | true | false | false | |||||||||||||||||
| 18ec1b84-b23c-4185-8add-8effaf2e8153 | 2026-09-28 14:02 | 2026-09-28 14:02 | 2026-09-28 14:02 | USO | USO261002P00145000 | put | 145.0000 | 2026-10-02 | 2.4100 | 2.3100 | 2.5600 | 149.0000 | 14948.00 | 241.00 | 14465.00 | 62 | 11 | 7304 | 4146 | 1.76169802219006 | 0.680893899386041 | 0.680893899386041 | true | false | false | |||||||||||||||||
| fe7c699d-2e58-44d2-9347-c3acf24517f2 | 2026-10-01 09:31 | 2026-10-01 09:31 | 2026-10-01 09:31 | USO | USO261002P00145000 | put | 145.0000 | 2026-10-02 | 1.6800 | 1.6300 | 1.8300 | 145.7600 | 49912.00 | 169.00 | 49743.00 | 297 | 15 | 310 | 3767 | 0.0822936023360765 | 0.656906737273442 | 0.676907800740659 | true | false | false | |||||||||||||||||
| a7351c98-8d98-482d-b8a9-449a7bf458bf | 2026-10-02 09:57 | 2026-10-02 09:57 | 2026-10-02 09:57 | USO | USO261002P00145000 | put | 145.0000 | 2026-10-02 | 1.2800 | 1.2500 | 1.4300 | 144.3601 | 16201.00 | 9726.00 | 5579.00 | 127 | 32 | 619 | 3724 | 0.166219119226638 | 0.591576019150937 | 0.612169270827901 | true | false | false | |||||||||||||||||
| 1d3d8423-6264-44dc-8017-7c2cf30eb637 | 2026-10-02 11:26 | 2026-10-02 11:26 | 2026-10-02 11:26 | USO | USO261002P00145000 | put | 145.0000 | 2026-10-02 | 0.7200 | 0.6900 | 0.7800 | 145.1000 | 32563.00 | 3844.00 | 28719.00 | 454 | 23 | 2301 | 3724 | 0.617883995703545 | 0.583502364748448 | 0.583897124530268 | true | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:50:19.857671Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:01:52.060675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:10:39.755253Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:32:07.640103Z"} |
| 2026-10-02 |
| 2026-10-02 23:43 |
| 2026-10-02 23:43 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T13:58:29.709555Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T15:27:57.874589Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |