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_alerts566,287 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 |
|---|
| e99b7f4b-2873-4740-bdda-0a29ce63324b | 2026-08-20 09:33 | 2026-08-20 09:33 | 2026-08-20 09:33 | RDDT | RDDT260918P00155000 | put | 155.0000 | 2026-09-18 | 13.1000 | 12.3500 | 13.4000 | 148.5400 | 10480.00 | 9170.00 | 1310.00 | 8 | 8 | 9 | 1069 | 0.00841908325537886 | 0.576486548853173 | 0.576486548853173 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 23724237616.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d9b6e954-f622-42da-906b-e3788a4ee0d7 | 2026-08-26 10:58 | 2026-08-26 10:58 | 2026-08-26 10:58 | RDDT | RDDT260918P00155000 | put | 155.0000 | 2026-09-18 | 7.1500 | 7.1000 | 7.3500 | 158.2750 | 25741.00 | 0.00 | 25741.00 | 36 | 22 | 92 | 1103 | 0.0834088848594742 | 0.565555897096045 | 0.565555897096045 | true | false | false | true | ||||||||||||||||
| a9a83b56-24f8-4394-a9d0-7bf5dad480b6 | 2026-09-14 10:15 | 2026-09-14 10:15 | 2026-09-14 10:15 | RDDT | RDDT260918P00155000 | put | 155.0000 | 2026-09-18 | 2.9400 | 2.6800 | 2.9500 | 158.0000 | 76756.00 | 6490.00 | 70266.00 | 261 | 8 | 661 | 1607 | 0.411325451151213 | 0.677074170864569 | 0.677074170864569 | false | false | false | true | ||||||||||||||||
| 46d7969d-f1b7-408e-8ae7-04a016b1b17c | 2026-09-17 11:26 | 2026-09-17 11:26 | 2026-09-17 11:26 | RDDT | RDDT260918P00155000 | put | 155.0000 | 2026-09-18 | 4.2000 | 4.1000 | 4.2000 | 151.8700 | 60900.00 | 60900.00 | 0.00 | 145 | 8 | 612 | 1661 | 0.368452739313666 | 0.723736815583747 | 0.723736815583747 | true | false | false | true | ||||||||||||||||
| 57236bda-fa7e-497d-bed4-b67b4f748e44 | 2026-09-17 11:26 | 2026-09-17 11:26 | 2026-09-17 11:26 | RDDT | RDDT260918P00155000 | put | 155.0000 | 2026-09-18 | 4.0600 | 3.8500 | 4.1000 | 151.9900 | 61775.00 | 59750.00 | 405.00 | 152 | 7 | 764 | 1661 | 0.45996387718242 | 0.669046684223957 | 0.717758784924025 | true | false | false | true | ||||||||||||||||
| e39a75db-7bce-4169-a1ee-87962377c382 | 2026-09-18 10:19 | 2026-09-18 10:19 | 2026-09-18 10:19 | RDDT | RDDT260918P00155000 | put | 155.0000 | 2026-09-18 | 3.0000 | 2.9000 | 3.0000 | 152.3950 | 34500.00 | 34500.00 | 0.00 | 115 | 68 | 140 | 1479 | 0.094658553076403 | 0.728425848717901 | 0.838270020735591 | false | false | false | true | ||||||||||||||||
| 3df3bdc0-bae1-45a3-8dbf-e8817146e7f2 | 2026-09-18 10:26 | 2026-09-18 10:26 | 2026-09-18 10:26 | RDDT | RDDT260918P00155000 | put | 155.0000 | 2026-09-18 | 2.5500 | 2.5500 | 2.8500 | 152.8500 | 34170.00 | 0.00 | 34170.00 | 134 | 64 | 282 | 1479 | 0.190669371196755 | 0.761933213189583 | 0.761933213189583 | true | false | false | true | ||||||||||||||||
| ff1b9361-df76-42b7-8ef3-3e72e514c75c | 2026-09-18 10:39 | 2026-09-18 10:39 | 2026-09-18 10:39 | RDDT | RDDT260918P00155000 | put | 155.0000 | 2026-09-18 | 2.0000 | 1.9900 | 2.0000 | 153.5800 | 18400.00 | 18400.00 | 0.00 | 92 | 40 | 416 | 1479 | 0.281271129141312 | 0.76049675317097 | 0.76049675317097 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:02:19.815281Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 23724237616.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 22328952056.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:37:51.418712Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 22328952056.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:37:51.418712Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 22039667720.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 22039667720.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 22039667720.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |