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_alerts326,449 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 |
|---|
| 86ea9a3a-1b76-4bc2-90cf-4b38ce1c3364 | 2026-09-22 14:56 | 2026-09-22 14:56 | 2026-09-22 14:56 | AAL | AAL261016P00013000 | put | 13.0000 | 2026-10-16 | 0.4000 | 0.3900 | 0.4000 | 13.6050 | 64838.00 | 64760.00 | 78.00 | 1621 | 5 | 10279 | 13372 | 0.768695782231529 | 0.48666258777947 | 0.48666258777947 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 9009411033.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 8a0261a9-9d7a-4bf1-a676-34aed4463279 | 2026-09-22 09:53 | 2026-09-22 09:53 | 2026-09-22 09:53 | AAL | AAL261016C00014000 | call | 14.0000 | 2026-10-16 | 0.7500 | 0.7100 | 0.7500 | 13.9800 | 10075.00 | 10075.00 | 0.00 | 135 | 13 | 2782 | 39120 | 0.0711145194274029 | 0.512346704588783 | 0.519358763482969 | false | false | false | true | ||||||||||||||||
| 0891740d-468c-42de-867b-78cf1268f4a6 | 2026-09-22 09:52 | 2026-09-22 09:52 | 2026-09-22 09:52 | AAL | AAL260925C00014500 | call | 14.5000 | 2026-09-25 | 0.1100 | 0.0800 | 0.1200 | 13.9600 | 79106.00 | 67049.00 | 0.00 | 7080 | 92 | 9270 | 3798 | 2.44075829383886 | 0.55006371117426 | 0.619386403735559 | true | false | false | true | ||||||||||||||||
| d0d056a2-1681-45b8-af15-84da8ab2c595 | 2026-09-21 10:32 | 2026-09-21 10:32 | 2026-09-21 10:32 | AAL | AAL270617C00012000 | call | 12.0000 | 2027-06-17 | 2.9700 | 2.9700 | 3.0500 | 13.2250 | 33319.00 | 10430.00 | 19313.00 | 112 | 22 | 464 | 0 | 0 | 0.489780498157486 | 0.49230660395738 | false | false | false | true | ||||||||||||||||
| af1ff2ed-ff05-44ba-b508-33cf6933e73e | 2026-09-17 10:08 | 2026-09-17 10:08 | 2026-09-17 10:08 | AAL | AAL261016P00013000 | put | 13.0000 | 2026-10-16 | 0.6800 | 0.6700 | 0.6800 | 13.0481 | 24472.00 | 23936.00 | 536.00 | 360 | 23 | 502 | 5537 | 0.0906628137980856 | 0.488387020536135 | 0.495250544515205 | true | false | false | true | ||||||||||||||||
| 92f3ea34-b79d-447c-80b3-e95c32c549ff | 2026-09-16 13:05 | 2026-09-16 13:05 | 2026-09-16 13:05 | AAL | AAL260918P00014000 | put | 14.0000 | 2026-09-18 | 1.2500 | 1.1800 | 1.2700 | 12.7800 | 12484.00 | 12484.00 | 0.00 | 100 | 9 | 639 | 13055 | 0.048946763692072 | 0.813332508951162 | 0.813332508951162 | false | false | false | true | ||||||||||||||||
| c37fdbb8-03df-4873-8280-fe0ab34088e6 | 2026-09-16 11:07 | 2026-09-16 11:07 | 2026-09-16 11:07 | AAL | AAL261030C00015000 | call | 15.0000 | 2026-10-30 | 0.3600 | 0.3100 | 0.3600 | 13.1350 | 17844.00 | 17844.00 | 0.00 | 500 | 7 | 1111 | 26 | 42.7307692307692 | 0.516439033870529 | 0.516439033870529 | false | false | false | true | ||||||||||||||||
| 4f903f42-8e6e-4983-9ddc-7659f5c2ed09 | 2026-09-16 10:55 | 2026-09-16 10:55 | 2026-09-16 10:55 | AAL | AAL261218C00013000 | call | 13.0000 | 2026-12-18 | 1.3500 | 1.3300 | 1.3900 | 13.0250 | 73041.00 | 67776.00 | 5265.00 | 542 | 22 | 752 | 1624 | 0.463054187192118 | 0.483381117737914 | 0.487251774694625 | true | false | false | true | ||||||||||||||||
| a95d1085-eacc-4629-aeb2-2f4f9049c064 | 2026-09-16 10:55 | 2026-09-16 10:55 | 2026-09-16 10:55 | AAL | AAL261002C00014000 | call | 14.0000 | 2026-10-02 | 0.2100 | 0.1900 | 0.2100 | 13.0100 | 19907.00 | 11907.00 | 0.00 | 967 | 13 | 7492 | 1829 | 4.09622744669218 | 0.492093154108195 | 0.503352364283884 | false | false | false | true | ||||||||||||||||
| d895234d-5a7e-4127-8650-c3aa03baa4df | 2026-09-16 10:54 | 2026-09-16 10:54 | 2026-09-16 10:54 | AAL | AAL261002C00013500 | call | 13.5000 | 2026-10-02 | 0.3400 | 0.2900 | 0.3400 | 13.0099 | 10199.00 | 10199.00 | 0.00 | 300 | 7 | 618 | 1215 | 0.508641975308642 | 0.480382107640707 | 0.480382107640707 | false | false | false | true | ||||||||||||||||
| ea399e65-ec16-4705-863a-a89c50dfdcf3 | 2026-09-11 15:27 | 2026-09-11 15:27 | 2026-09-11 15:27 | AAL | AAL261016C00014000 | call | 14.0000 | 2026-10-16 | 0.4400 | 0.4200 | 0.4400 | 13.1150 | 12911.00 | 10503.00 | 0.00 | 296 | 8 | 18729 | 8461 | 2.21356813615412 | 0.465467466915047 | 0.472035741130132 | true | false | false | true | ||||||||||||||||
| bf83a74d-b9aa-447a-b538-de2397a7407d | 2026-09-08 14:01 | 2026-09-08 14:01 | 2026-09-08 14:01 | AAL | AAL270617C00015000 | call | 15.0000 | 2027-06-17 | 1.6000 | 1.6000 | 1.6300 | 13.0601 | 224486.00 | 326.00 | 224160.00 | 1403 | 51 | 1438 | 2796 | 0.514306151645207 | 0.469185845762235 | 0.477306771533582 | false | false | false | true | ||||||||||||||||
| 42d8dfa9-4c17-4cfb-9859-37108fc66466 | 2026-09-02 15:22 | 2026-09-02 15:21 | 2026-09-02 15:21 | AAL | AAL270617C00015000 | call | 15.0000 | 2027-06-17 | 1.6800 | 1.6700 | 1.7200 | 13.1200 | 11244.00 | 0.00 | 11244.00 | 67 | 20 | 634 | 2157 | 0.293926750115902 | 0.473578074350727 | 0.475729783821426 | false | false | false | true | ||||||||||||||||
| 8d47d302-db93-4f29-ae1d-4aa369c97af0 | 2026-08-31 10:15 | 2026-08-31 10:15 | 2026-08-31 10:15 | AAL | AAL270319P00012000 | put | 12.0000 | 2027-03-19 | 1.1000 | 1.0900 | 1.1800 | 13.3750 | 22015.00 | 1665.00 | 20350.00 | 200 | 9 | 534 | 2624 | 0.203506097560976 | 0.485117839572833 | 0.488039133332331 | false | false | false | true | ||||||||||||||||
| b9ba278e-7345-4c97-bea2-1226efaa2fdb | 2026-08-26 10:32 | 2026-08-26 10:32 | 2026-08-26 10:32 | AAL | AAL281215C00015000 | call | 15.0000 | 2028-12-15 | 4.3500 | 4.3000 | 4.4000 | 13.9500 | 108761.00 | 0.00 | 95711.00 | 250 | 6 | 254 | 12619 | 0.0201283778429353 | 0.513737280253779 | 0.513737280253779 | false | false | false | true | ||||||||||||||||
| 7e13994a-b4fc-4ed0-9b3f-d92c82db33ab | 2026-08-25 15:58 | 2026-08-25 15:58 | 2026-08-25 15:58 | AAL | AAL260828C00014000 | call | 14.0000 | 2026-08-28 | 0.2200 | 0.2000 | 0.2200 | 13.9250 | 21554.00 | 21554.00 | 0.00 | 1000 | 20 | 7767 | 3430 | 2.26443148688047 | 0.482677963698857 | 0.502615815567956 | false | false | false | true | ||||||||||||||||
| d22f6833-07a4-4a27-a3a2-5d4801ac7bc3 | 2026-08-25 09:41 | 2026-08-25 09:41 | 2026-08-25 09:41 | AAL | AAL260828C00014000 | call | 14.0000 | 2026-08-28 | 0.2000 | 0.1700 | 0.2000 | 13.8300 | 19997.00 | 19980.00 | 17.00 | 1001 | 18 | 3316 | 3430 | 0.966763848396501 | 0.525914688628426 | 0.546399331110943 | false | false | false | true | ||||||||||||||||
| 50631a1b-7f03-495d-8555-3ef9a0a92e07 | 2026-08-21 14:39 | 2026-08-21 14:38 | 2026-08-21 14:38 | AAL | AAL280121C00025000 | call | 25.0000 | 2028-01-21 | 0.9900 | 0.9300 | 1.0000 | 13.7950 | 99446.00 | 47174.00 | 0.00 | 1005 | 15 | 2009 | 5166 | 0.388888888888889 | 0.486589850734026 | 0.48845108598009 | true | false | false | true | ||||||||||||||||
| cca3cc85-92fd-453b-b824-a2e5b47dc2b5 | 2026-08-17 13:41 | 2026-08-17 13:41 | 2026-08-17 13:41 | AAL | AAL270319P00011000 | put | 11.0000 | 2027-03-19 | 0.6700 | 0.5900 | 0.6800 | 14.4550 | 13440.00 | 13440.00 | 0.00 | 200 | 14 | 200 | 2 | 100 | 0.527206577480995 | 0.530711282376084 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 9009411033.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:54:31.756724Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 9009411033.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:52:22.219586Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8982932235.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:34:41.643622Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8565891166.00 |
| 2026-10-22 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8407018378.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8407018378.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8407018378.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8407018378.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8407018378.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8671806358.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8671806358.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:15:47.972880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8671806358.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:37:03.508091Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8671806358.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8671806358.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8671806358.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8671806358.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:41:46.514863Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8671806358.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8671806358.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |