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 | 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 |
|---|
| 71777534-41b9-4758-9eba-fc5b55976e8f | 2026-09-21 12:54 | 2026-09-21 12:54 | 2026-09-21 12:54 | HONA | HONA261218P00140000 | put | 140.0000 | 2026-12-18 | 3.9000 | 3.2000 | 5.5000 | 168.0000 | 39000.00 | 22620.00 | 8190.00 | 100 | 23 | 100 | 915 | 0.109289617486339 | 0.470085552761978 | 0.470085552761978 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 53574519107.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| dda01b05-df39-4296-a62e-b9f02083821a | 2026-09-21 12:37 | 2026-09-21 12:37 | 2026-09-21 12:37 | HONA | HONA261218C00175000 | call | 175.0000 | 2026-12-18 | 12.2000 | 12.2000 | 12.8000 | 168.4400 | 527040.00 | 0.00 | 527040.00 | 432 | 16 | 438 | 10246 | 0.0427483896154597 | 0.433607609181107 | 0.433607609181107 | false | false | false | true | ||||||||||||||||
| ca92c877-647a-4aa5-be19-212a1bb6a94e | 2026-09-21 12:37 | 2026-09-21 12:37 | 2026-09-21 12:37 | HONA | HONA261218C00195000 | call | 195.0000 | 2026-12-18 | 5.6000 | 5.6000 | 6.2000 | 168.4400 | 30800.00 | 0.00 | 30800.00 | 55 | 9 | 60 | 122 | 0.491803278688525 | 0.418188799445852 | 0.418188799445852 | false | false | false | true | ||||||||||||||||
| 829ef3d6-3940-4414-9403-6a8f5dda0820 | 2026-09-18 15:52 | 2026-09-18 15:52 | 2026-09-18 15:52 | HONA | HONA261016P00155000 | put | 155.0000 | 2026-10-16 | 4.0000 | 1.5000 | 4.0000 | 163.0000 | 102800.00 | 102800.00 | 0.00 | 257 | 36 | 263 | 190 | 1.38421052631579 | 0.432189089201858 | 0.432189089201858 | true | false | false | true | ||||||||||||||||
| 8fc90598-406f-4914-8f54-f8b41553ae43 | 2026-09-18 11:00 | 2026-09-18 11:00 | 2026-09-18 11:00 | HONA | HONA261120P00150000 | put | 150.0000 | 2026-11-20 | 6.7000 | 6.7000 | 7.1000 | 163.2200 | 53600.00 | 0.00 | 53600.00 | 80 | 5 | 136 | 79 | 1.72151898734177 | 0.487152494501715 | 0.487152494501715 | false | false | false | true | ||||||||||||||||
| 89becd5d-b9bc-41ec-95e2-6ff58dd15fa8 | 2026-09-16 12:30 | 2026-09-16 12:30 | 2026-09-16 12:30 | HONA | HONA260918P00170000 | put | 170.0000 | 2026-09-18 | 5.7000 | 5.1000 | 5.7000 | 165.7500 | 91200.00 | 91200.00 | 0.00 | 160 | 27 | 203 | 229 | 0.88646288209607 | 0.636761426927528 | 0.636761426927528 | false | false | false | true | ||||||||||||||||
| 8512aea9-81ba-4ad3-854e-854255b508d9 | 2026-09-09 10:52 | 2026-09-09 10:52 | 2026-09-09 10:52 | HONA | HONA271217P00125000 | put | 125.0000 | 2027-12-17 | 15.0000 | 14.6000 | 15.0000 | 154.1400 | 25500.00 | 25500.00 | 0.00 | 17 | 12 | 65 | 32 | 2.03125 | 0.49152991525497 | 0.49152991525497 | false | false | false | true | ||||||||||||||||
| 5d19a6db-4093-4c72-bd8e-ffb29a23c0bb | 2026-09-09 10:51 | 2026-09-09 10:51 | 2026-09-09 10:51 | HONA | HONA271217P00125000 | put | 125.0000 | 2027-12-17 | 14.8000 | 14.7000 | 15.7000 | 153.6100 | 13321.00 | 2960.00 | 7401.00 | 9 | 8 | 48 | 32 | 1.5 | 0.485396460260706 | 0.485588508380018 | false | false | false | true | ||||||||||||||||
| ec2be8a6-0ab0-45a7-b209-be1238b89da2 | 2026-09-09 10:51 | 2026-09-09 10:51 | 2026-09-09 10:51 | HONA | HONA271217P00125000 | put | 125.0000 | 2027-12-17 | 14.9000 | 14.7000 | 15.3000 | 153.6100 | 16390.00 | 7450.00 | 2980.00 | 11 | 11 | 39 | 32 | 1.21875 | 0.487316418341627 | 0.487316418341627 | false | false | false | true | ||||||||||||||||
| 20f11cfa-3d60-4490-ad93-e882fce0118b | 2026-09-09 10:51 | 2026-09-09 10:51 | 2026-09-09 10:51 | HONA | HONA271217P00125000 | put | 125.0000 | 2027-12-17 | 14.7000 | 13.7000 | 15.0000 | 153.6100 | 35280.00 | 2940.00 | 29400.00 | 24 | 9 | 28 | 32 | 0.875 | 0.48347533078802 | 0.48347533078802 | false | false | false | true | ||||||||||||||||
| 168732d6-36da-4116-8f7e-70c316fa89bf | 2026-09-04 14:43 | 2026-09-04 14:42 | 2026-09-04 14:42 | HONA | HONA260918C00175000 | call | 175.0000 | 2026-09-18 | 1.0000 | 0.8000 | 1.0000 | 160.5000 | 18600.00 | 18600.00 | 0.00 | 186 | 31 | 193 | 500 | 0.386 | 0.410023856050797 | 0.410023856050797 | false | false | false | true | ||||||||||||||||
| 3859c15c-7e57-455b-882d-fdb32c651a7c | 2026-09-04 13:09 | 2026-09-04 13:09 | 2026-09-04 13:09 | HONA | HONA261016C00170000 | call | 170.0000 | 2026-10-16 | 5.2000 | 5.0000 | 5.4000 | 160.1200 | 39000.00 | 37440.00 | 1560.00 | 75 | 6 | 107 | 95 | 1.12631578947368 | 0.405895034386502 | 0.405895034386502 | false | false | false | true | ||||||||||||||||
| 2f4e2052-2df0-4cf9-9180-454dab9a1de1 | 2026-09-04 12:42 | 2026-09-04 12:42 | 2026-09-04 12:42 | HONA | HONA261016P00120000 | put | 120.0000 | 2026-10-16 | 0.2500 | 0.2000 | 0.4500 | 159.7400 | 10775.00 | 525.00 | 10250.00 | 431 | 30 | 527 | 21 | 25.0952380952381 | 0.456242077341949 | 0.456242077341949 | false | false | false | true | ||||||||||||||||
| 8df0dcd5-5133-4919-bcdc-16f3342b607c | 2026-09-04 10:12 | 2026-09-04 10:12 | 2026-09-04 10:12 | HONA | HONA261016C00160000 | call | 160.0000 | 2026-10-16 | 7.8000 | 7.6000 | 8.0000 | 156.9100 | 52260.00 | 27300.00 | 21840.00 | 67 | 11 | 240 | 76 | 3.15789473684211 | 0.422133509403914 | 0.418020685028497 | false | false | false | true | ||||||||||||||||
| 4a38b70c-9b65-44c7-be3c-7d7400fe972c | 2026-09-04 10:09 | 2026-09-04 10:09 | 2026-09-04 10:09 | HONA | HONA261016C00160000 | call | 160.0000 | 2026-10-16 | 7.8000 | 7.5000 | 8.5000 | 156.7450 | 67860.00 | 58500.00 | 9360.00 | 87 | 13 | 124 | 76 | 1.63157894736842 | 0.42179345748311 | 0.42179345748311 | false | false | false | true | ||||||||||||||||
| cbdf4d3c-f8df-4b4f-8926-a3b662677b5d | 2026-09-04 10:08 | 2026-09-04 10:08 | 2026-09-04 10:08 | HONA | HONA261016C00160000 | call | 160.0000 | 2026-10-16 | 7.8000 | 7.3000 | 8.1000 | 156.9900 | 28860.00 | 8580.00 | 4680.00 | 37 | 8 | 37 | 76 | 0.486842105263158 | 0.416186700988402 | 0.416186700988402 | false | false | false | true | ||||||||||||||||
| 469cc5fc-5f9f-4445-8853-4f5320aba53f | 2026-09-01 15:30 | 2026-09-01 15:30 | 2026-09-01 15:30 | HONA | HONA261016P00140000 | put | 140.0000 | 2026-10-16 | 3.4000 | 3.2000 | 3.4000 | 153.8300 | 52020.00 | 52020.00 | 0.00 | 153 | 28 | 322 | 43 | 7.48837209302326 | 0.4301798972313 | 0.4301798972313 | false | false | false | true | ||||||||||||||||
| 1543f6fd-b110-4033-aa6e-1d039c16a844 | 2026-08-31 14:02 | 2026-08-31 14:02 | 2026-08-31 14:02 | HONA | HONA270319P00160000 | put | 160.0000 | 2027-03-19 | 19.8000 | 19.7000 | 21.2000 | 158.0000 | 73260.00 | 0.00 | 73260.00 | 37 | 7 | 80 | 189 | 0.423280423280423 | 0.454282787239721 | 0.453649802201104 | false | false | false | true | ||||||||||||||||
| bc50ee0d-eb3b-4141-b063-41153c4729b0 | 2026-08-31 09:36 | 2026-08-31 09:35 | 2026-08-31 09:35 | HONA | HONA260918P00160000 | put | 160.0000 | 2026-09-18 | 6.0000 | 6.0000 | 6.7000 | 159.6399 | 80400.00 | 0.00 | 67800.00 | 134 | 6 | 139 | 826 | 0.168280871670702 | 0.422284947912744 | 0.422284947912744 | false | false | false | true | ||||||||||||||||
| 0f842e6a-1952-46fe-94bb-89010f01c9ae | 2026-08-25 11:08 | 2026-08-25 11:08 | 2026-08-25 11:08 | HONA | HONA260918C00165000 | call | 165.0000 | 2026-09-18 | 6.1000 | 6.1000 | 6.5000 | 161.5100 | 108580.00 | 0.00 | 108580.00 | 178 | 39 | 181 | 262 | 0.690839694656489 | 0.452300593091837 | 0.452300593091837 | false | false | false | true | ||||||||||||||||
| c98d6610-3bf5-409b-93c9-58b97aafcca3 | 2026-08-21 14:06 | 2026-08-21 14:06 | 2026-08-21 14:06 | HONA | HONA261016C00190000 | call | 190.0000 | 2026-10-16 | 4.7000 | 4.7000 | 5.1000 | 165.0000 | 81310.00 | 0.00 | 81310.00 | 173 | 7 | 281 | 7 | 40.1428571428571 | 0.474055704622187 | 0.474055704622187 | false | false | false | true | ||||||||||||||||
| ccca6899-bfab-4862-8087-4794f7a76867 | 2026-08-20 15:17 | 2026-08-20 15:17 | 2026-08-20 15:17 | HONA | HONA261218C00165000 | call | 165.0000 | 2026-12-18 | 19.5600 | 19.3000 | 19.6000 | 165.6650 | 76280.00 | 76280.00 | 0.00 | 39 | 13 | 79 | 152 | 0.519736842105263 | 0.485570940930766 | 0.485570940930766 | false | false | false | true | ||||||||||||||||
| 78218cb3-96b0-40c9-a71f-8eb719299072 | 2026-08-20 15:17 | 2026-08-20 15:17 | 2026-08-20 15:17 | HONA | HONA261218P00165000 | put | 165.0000 | 2026-12-18 | 17.1000 | 17.1000 | 17.4000 | 165.6650 | 294120.00 | 0.00 | 294120.00 | 172 | 5 | 190 | 86 | 2.2093023255814 | 0.492473681489634 | 0.492473681489634 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 53574519107.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 53574519107.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 51853465810.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 51853465810.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52037298391.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:59:53.339088Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:59:53.339088Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:59:53.339088Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:59:53.339088Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:05:15.166096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:34:11.817020Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:26:05.443569Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:26:05.443569Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T19:44:53.190071Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T18:25:38.432903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 52005603118.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |