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_alerts375,978 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 |
|---|
| 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 |
|---|
| 7b95c21c-c86f-41d5-ab0e-da7be6e076ec | 2026-09-23 15:01 | 2026-09-23 15:01 | 2026-09-23 15:01 | DINO | DINO270115P00097500 | put | 97.5000 | 2027-01-15 | 8.4000 | 8.4000 | 8.6000 | 106.0100 | 21010.00 | 0.00 | 20160.00 | 25 | 13 | 54 | 51 | 1.05882352941176 | 0.570986350841287 | 0.566274345433544 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 18869977733.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T19:05:07.702473Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 54bf81b5-9086-4e77-88ac-cd7f750704cf | 2026-09-23 15:01 | 2026-09-23 15:00 | 2026-09-23 15:00 | DINO | DINO270115P00097500 | put | 97.5000 | 2027-01-15 | 8.4100 | 8.3000 | 8.7000 | 106.0200 | 20191.00 | 1700.00 | 18491.00 | 24 | 9 | 29 | 51 | 0.568627450980392 | 0.571137783553481 | 0.566425658657126 | false | false | false | |||||||||||||||||
| 46e50ba3-b8d0-4dc7-b2a8-7afdef05dc0f | 2026-09-23 12:46 | 2026-09-23 12:46 | 2026-09-23 12:46 | DINO | DINO261120C00095000 | call | 95.0000 | 2026-11-20 | 16.0000 | 15.7000 | 16.8000 | 105.8200 | 124808.00 | 25600.00 | 99208.00 | 78 | 13 | 80 | 24 | 3.33333333333333 | 0.567015535439884 | 0.577959061810412 | false | false | false | |||||||||||||||||
| 1bab18e3-e28e-464f-8795-a7cfb4dbc3fa | 2026-09-21 15:30 | 2026-09-21 15:29 | 2026-09-21 15:29 | DINO | DINO261016P00100000 | put | 100.0000 | 2026-10-16 | 2.7900 | 2.7500 | 2.8500 | 108.9200 | 37604.00 | 26874.00 | 10730.00 | 135 | 32 | 240 | 494 | 0.48582995951417 | 0.585612502958093 | 0.585612502958093 | false | false | false | |||||||||||||||||
| 6b885d23-6766-4ce2-a3fd-9677db5a4e4e | 2026-09-21 15:23 | 2026-09-21 15:23 | 2026-09-21 15:23 | DINO | DINO261016P00105000 | put | 105.0000 | 2026-10-16 | 4.3000 | 3.9000 | 4.4000 | 109.5100 | 136729.00 | 135879.00 | 850.00 | 318 | 43 | 436 | 741 | 0.588394062078273 | 0.578180060068989 | 0.574200735431626 | false | false | false | |||||||||||||||||
| 63f48117-797c-435b-84d3-3d7dc9988c77 | 2026-09-16 14:32 | 2026-09-16 14:32 | 2026-09-16 14:32 | DINO | DINO261218P00120000 | put | 120.0000 | 2026-12-18 | 16.0600 | 16.0000 | 17.2000 | 114.2200 | 22486.00 | 6436.00 | 16050.00 | 14 | 5 | 15 | 3 | 5 | 0.58758841854314 | 0.583240171037704 | false | false | false | |||||||||||||||||
| 2f7c0f50-64d9-4841-9e7a-d94b7aeb27a5 | 2026-09-16 10:30 | 2026-09-16 10:30 | 2026-09-16 10:30 | DINO | DINO270115P00110000 | put | 110.0000 | 2027-01-15 | 13.0700 | 13.0000 | 13.4000 | 110.0000 | 13070.00 | 1310.00 | 11760.00 | 10 | 7 | 10 | 329 | 0.0303951367781155 | 0.569586135597863 | 0.565555047476288 | false | false | false | |||||||||||||||||
| 273623f3-3766-48c3-b07b-9ab6673aa985 | 2026-09-15 10:29 | 2026-09-15 10:29 | 2026-09-15 10:29 | DINO | DINO260918P00110000 | put | 110.0000 | 2026-09-18 | 2.9000 | 2.4500 | 2.9000 | 110.0350 | 62584.00 | 62584.00 | 0.00 | 216 | 12 | 226 | 51 | 4.43137254901961 | 0.737902444669794 | 0.732872355063675 | true | false | false | |||||||||||||||||
| e79f7451-a538-462d-8fb6-c4232daab47d | 2026-09-14 10:44 | 2026-09-14 10:44 | 2026-09-14 10:44 | DINO | DINO270115C00110000 | call | 110.0000 | 2027-01-15 | 14.0000 | 13.5000 | 15.1000 | 110.4900 | 700023.00 | 0.00 | 700023.00 | 500 | 6 | 500 | 2431 | 0.205676676264912 | 0.522698408043917 | 0.522698408043917 | false | false | false | |||||||||||||||||
| 29fe27e5-182b-4bac-8ee7-15a7c6cbc197 | 2026-08-31 13:17 | 2026-08-31 13:16 | 2026-08-31 13:16 | DINO | DINO260918C00100000 | call | 100.0000 | 2026-09-18 | 4.3300 | 4.3000 | 4.5000 | 99.8800 | 125026.00 | 7920.00 | 116666.00 | 289 | 38 | 2123 | 5186 | 0.409371384496722 | 0.49017927798191 | 0.493748039562914 | false | false | false | |||||||||||||||||
| 11e0b18c-a7e6-43e1-9151-7d5d27b9e91e | 2026-08-28 11:54 | 2026-08-28 11:54 | 2026-08-28 11:54 | DINO | DINO260918C00100000 | call | 100.0000 | 2026-09-18 | 4.4300 | 4.4000 | 4.6000 | 99.0000 | 199806.00 | 37800.00 | 161556.00 | 451 | 52 | 2533 | 7359 | 0.34420437559451 | 0.467756630109747 | 0.467756630109747 | false | false | false | |||||||||||||||||
| 99a3765e-62ad-4347-ae0d-ca59e892f008 | 2026-08-28 11:54 | 2026-08-28 11:54 | 2026-08-28 11:54 | DINO | DINO260918C00100000 | call | 100.0000 | 2026-09-18 | 4.6000 | 4.5000 | 4.7000 | 100.0000 | 132826.00 | 20240.00 | 94186.00 | 289 | 21 | 1590 | 7359 | 0.216061964940889 | 0.46799770374772 | 0.468276086695235 | true | false | false | |||||||||||||||||
| 1573d706-a8d3-4644-b224-1f85affae75d | 2026-08-28 11:29 | 2026-08-28 11:29 | 2026-08-28 11:29 | DINO | DINO260918C00100000 | call | 100.0000 | 2026-09-18 | 4.5000 | 4.5000 | 4.7000 | 99.9300 | 104410.00 | 0.00 | 103950.00 | 232 | 18 | 733 | 7359 | 0.0996059247180323 | 0.473826345882022 | 0.463343508197861 | false | false | false | |||||||||||||||||
| bf755c34-f142-4a7f-9c5a-1483cb4a6963 | 2026-08-21 10:59 | 2026-08-21 10:59 | 2026-08-21 10:59 | DINO | DINO260821C00095000 | call | 95.0000 | 2026-08-21 | 1.0600 | 0.6500 | 1.5000 | 95.7350 | 10582.00 | 0.00 | 10582.00 | 100 | 6 | 1757 | 2854 | 0.6156271899089 | 0.684765237123384 | 0.69701902249624 | false | false | false | |||||||||||||||||
| 8c4b6f6e-f44c-45cd-908a-2b93a45922dd | 2026-08-20 13:56 | 2026-08-20 13:56 | 2026-08-20 13:56 | DINO | DINO260821P00100000 | put | 100.0000 | 2026-08-21 | 6.2100 | 5.5000 | 6.9000 | 93.7800 | 24852.00 | 18652.00 | 0.00 | 40 | 9 | 80 | 0 | 0 | 0.535627112614413 | 0.535627112614413 | false | false | false | |||||||||||||||||
| 7d9c2ef6-52a9-4f2b-a37a-50d9e258f6ad | 2026-08-17 11:39 | 2026-08-17 11:39 | 2026-08-17 11:39 | DINO | DINO260821C00095000 | call | 95.0000 | 2026-08-21 | 1.6700 | 1.6500 | 1.9000 | 94.5900 | 51480.00 | 0.00 | 48080.00 | 309 | 26 | 2046 | 7358 | 0.278064691492253 | 0.474887512648008 | 0.462211206698462 | true | false | false | |||||||||||||||||
| 742eda3a-35f8-4ff9-be9e-90ebc8bd4628 | 2026-08-17 11:39 | 2026-08-17 11:39 | 2026-08-17 11:39 | DINO | DINO260821C00095000 | call | 95.0000 | 2026-08-21 | 1.8000 | 1.7000 | 2.0000 | 94.6600 | 79747.00 | 42125.00 | 37622.00 | 443 | 37 | 1075 | 7358 | 0.146099483555314 | 0.504323751327378 | 0.491668461668488 | true | false | false | |||||||||||||||||
| e2f62ab0-5537-47b5-8d0d-7bf739c0ba36 | 2026-08-17 11:39 | 2026-08-17 11:39 | 2026-08-17 11:39 | DINO | DINO260918C00100000 | call | 100.0000 | 2026-09-18 | 3.2000 | 3.0000 | 3.3000 | 94.6400 | 109411.00 | 98851.00 | 10560.00 | 342 | 51 | 915 | 1600 | 0.571875 | 0.465889850011819 | 0.465889850011819 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 18869977733.00 |
| 2026-10-28 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:05:07.702473Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 18869977733.00 |
| 2026-10-28 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:47:02.093743Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19429996857.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19429996857.00 |
| 2026-10-29 |
| unknown |
| — |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 20262025271.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:44:45.237115Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 20262025271.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19006871297.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:36:37.058930Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19006871297.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19006871297.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19006871297.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19006871297.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19006871297.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19006871297.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19006871297.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:14:08.178572Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19006871297.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19006871297.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19006871297.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |