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 | strike |
|---|
| 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 |
|---|
| 3dc10bed-df21-4010-89b8-6ddb262d6aad | 2026-09-28 15:45 | 2026-09-28 15:45 | 2026-09-28 15:45 | NEM | NEM270917C00155000 | call | 155.0000 | 2027-09-17 | 10.0300 | 10.0000 | 10.5000 | 116.2700 | 44130.00 | 0.00 | 44130.00 | 44 | 15 | 56 | 17 | 3.29411764705882 | 0.440260372385929 | 0.440260372385929 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 122280988050.00 | 2026-10-22 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T19:47:15.620459Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| f9995edf-3aea-4f82-8ba5-9812aca03eef | 2026-09-28 11:27 | 2026-09-28 11:27 | 2026-09-28 11:27 | NEM | NEM261016C00124000 | call | 124.0000 | 2026-10-16 | 1.5000 | 1.4900 | 1.6500 | 116.1050 | 16067.00 | 301.00 | 15766.00 | 107 | 19 | 109 | 52 | 2.09615384615385 | 0.407984870981759 | 0.403139253876581 | false | false | ||||||||||||||||||
| c5f542b5-7644-4f99-b740-d67a7163461e | 2026-09-25 10:41 | 2026-09-25 10:41 | 2026-09-25 10:41 | NEM | NEM261023C00130000 | call | 130.0000 | 2026-10-23 | 2.6100 | 2.6700 | 3.1000 | 120.7600 | 14353.00 | 0.00 | 14353.00 | 55 | 9 | 70 | 76 | 0.921052631578947 | 0.448154252459774 | 0.448154252459774 | true | false | ||||||||||||||||||
| f3131416-32fe-4b0f-b995-6fd3ecd797dc | 2026-09-24 11:21 | 2026-09-24 11:21 | 2026-09-24 11:21 | NEM | NEM270617P00110000 | put | 110.0000 | 2027-06-17 | 10.9000 | 10.9000 | 11.1500 | 120.0000 | 143885.00 | 0.00 | 143885.00 | 132 | 7 | 133 | 360 | 0.369444444444444 | 0.44613464327391 | 0.4447420780319 | false | false | ||||||||||||||||||
| 29eee094-cad9-4f7e-9464-3ee2c39991ad | 2026-09-23 15:25 | 2026-09-23 15:25 | 2026-09-23 15:25 | NEM | NEM270319P00100000 | put | 100.0000 | 2027-03-19 | 4.3000 | 4.1000 | 4.3000 | 123.4800 | 230027.00 | 229602.00 | 425.00 | 535 | 46 | 1037 | 497 | 2.08651911468813 | 0.437942907324831 | 0.437501027376939 | false | false | ||||||||||||||||||
| d4f36c40-a1a6-42ff-8dca-110c8147b1e2 | 2026-09-22 15:33 | 2026-09-22 15:33 | 2026-09-22 15:33 | NEM | NEM270115C00170000 | call | 170.0000 | 2027-01-15 | 2.6900 | 2.3400 | 2.6900 | 127.5800 | 416668.00 | 416408.00 | 260.00 | 1549 | 70 | 1549 | 960 | 1.61354166666667 | 0.455053413268478 | 0.449628614338202 | false | false | ||||||||||||||||||
| 4eafcd2f-1425-4137-80a2-7dbe8ea3b3ab | 2026-09-22 15:30 | 2026-09-22 15:30 | 2026-09-22 15:30 | NEM | NEM261023C00127000 | call | 127.0000 | 2026-10-23 | 6.8300 | 5.6000 | 7.0000 | 127.0000 | 11605.00 | 10235.00 | 1370.00 | 17 | 6 | 68 | 58 | 1.17241379310345 | 0.441296575500328 | 0.441296575500328 | true | false | ||||||||||||||||||
| 1b0ff4d6-8754-4204-a427-6245a2597c72 | 2026-09-22 10:10 | 2026-09-22 10:10 | 2026-09-22 10:10 | NEM | NEM261016C00130000 | call | 130.0000 | 2026-10-16 | 2.8000 | 2.7400 | 3.0000 | 123.8950 | 16514.00 | 279.00 | 16235.00 | 59 | 18 | 64 | 2645 | 0.0241965973534972 | 0.399717286909629 | 0.398864889757397 | false | false | ||||||||||||||||||
| 1da38be9-b03f-4427-9efe-b4ebf27426a3 | 2026-09-22 09:52 | 2026-09-22 09:52 | 2026-09-22 09:52 | NEM | NEM261016C00125000 | call | 125.0000 | 2026-10-16 | 5.1800 | 5.1000 | 5.4500 | 124.6300 | 31090.00 | 0.00 | 31090.00 | 60 | 7 | 143 | 5202 | 0.0274894271434064 | 0.409735063573633 | 0.409735063573633 | true | false | ||||||||||||||||||
| 74f74575-d522-4ba4-84f2-4accb42e4fcb | 2026-09-22 09:36 | 2026-09-22 09:36 | 2026-09-22 09:36 | NEM | NEM270115P00140000 | put | 140.0000 | 2027-01-15 | 20.9600 | 20.4000 | 22.1000 | 124.2600 | 419272.00 | 0.00 | 419272.00 | 200 | 17 | 200 | 278 | 0.719424460431655 | 0.440011310082796 | 0.440011310082796 | false | false | ||||||||||||||||||
| 684f7d01-f34a-405c-b105-bdb4572f0331 | 2026-09-18 10:36 | 2026-09-18 10:36 | 2026-09-18 10:36 | NEM | NEM270319P00135000 | put | 135.0000 | 2027-03-19 | 21.7300 | 21.4000 | 21.8000 | 122.4300 | 82560.00 | 45675.00 | 36885.00 | 38 | 6 | 54 | 112 | 0.482142857142857 | 0.462075767167857 | 0.460622518215803 | false | false | ||||||||||||||||||
| 4f4dfe5b-f0d5-419f-9a35-486195ddbfa3 | 2026-09-09 11:43 | 2026-09-09 11:42 | 2026-09-09 11:42 | NEM | NEM270617C00130000 | call | 130.0000 | 2027-06-17 | 21.3500 | 20.8500 | 21.8500 | 128.7000 | 55500.00 | 40560.00 | 14940.00 | 26 | 6 | 62 | 1212 | 0.0511551155115512 | 0.450055372357423 | 0.448909481643841 | false | false | ||||||||||||||||||
| ad51547d-b60f-4a9b-b503-fe42ed6045b8 | 2026-08-28 15:18 | 2026-08-28 15:17 | 2026-08-28 15:17 | NEM | NEM261016P00115000 | put | 115.0000 | 2026-10-16 | 2.6500 | 2.5000 | 2.6900 | 127.8750 | 1326402.00 | 682201.00 | 246701.00 | 5006 | 40 | 10229 | 2512 | 4.07205414012739 | 0.428358018953555 | 0.423863067661939 | true | false | ||||||||||||||||||
| 11e29369-0126-45c6-9a1d-a67daec89aca | 2026-08-28 12:44 | 2026-08-28 12:44 | 2026-08-28 12:44 | NEM | NEM261016P00105000 | put | 105.0000 | 2026-10-16 | 0.8900 | 0.5900 | 0.9300 | 127.4300 | 184677.00 | 182634.00 | 2043.00 | 2066 | 63 | 5007 | 641 | 7.81123244929797 | 0.430298961772971 | 0.434229836554585 | true | false | ||||||||||||||||||
| 57522418-17f3-45fe-89d2-f03c5fa7e46c | 2026-08-28 12:10 | 2026-08-28 12:10 | 2026-08-28 12:10 | NEM | NEM261016C00140000 | call | 140.0000 | 2026-10-16 | 4.0000 | 3.9500 | 4.4000 | 128.6400 | 244735.00 | 239600.00 | 5135.00 | 612 | 6 | 663 | 17273 | 0.0383836044694031 | 0.420481325245427 | 0.422418913803611 | true | false | ||||||||||||||||||
| c561eeec-e475-417e-89ec-7f0e1d6f2e98 | 2026-08-27 13:56 | 2026-08-27 13:56 | 2026-08-27 13:56 | NEM | NEM260828P00131000 | put | 131.0000 | 2026-08-28 | 0.8600 | 0.5500 | 1.0200 | 132.6900 | 86253.00 | 86253.00 | 0.00 | 1000 | 13 | 2055 | 122 | 16.844262295082 | 0.58104704382633 | 0.58104704382633 | false | false | ||||||||||||||||||
| 8601e479-2534-4b87-afa2-8a86255ab5b6 | 2026-08-27 13:51 | 2026-08-27 13:51 | 2026-08-27 13:51 | NEM | NEM260828P00131000 | put | 131.0000 | 2026-08-28 | 0.8000 | 0.5000 | 1.0200 | 133.0300 | 80050.00 | 80050.00 | 0.00 | 1000 | 10 | 1055 | 122 | 8.64754098360656 | 0.592197444012788 | 0.579834023869795 | false | false | ||||||||||||||||||
| ecb60878-31a5-411b-958e-98f25d7195aa | 2026-08-24 12:01 | 2026-08-24 12:01 | 2026-08-24 12:01 | NEM | NEM261120C00145000 | call | 145.0000 | 2026-11-20 | 7.7000 | 7.2500 | 7.7000 | 129.9500 | 265630.00 | 265630.00 | 0.00 | 345 | 19 | 350 | 0 | 0 | 0.504755979253633 | 0.499712008011199 | false | false | ||||||||||||||||||
| 2c1ff604-cc60-4f35-9a67-3f9700440067 | 2026-08-21 11:21 | 2026-08-21 11:20 | 2026-08-21 11:20 | NEM | NEM261218C00165000 | call | 165.0000 | 2026-12-18 | 5.4000 | 5.1500 | 5.4000 | 131.4000 | 513444.00 | 513444.00 | 0.00 | 951 | 45 | 1390 | 2144 | 0.648320895522388 | 0.499338866497879 | 0.499338866497879 | false | false | ||||||||||||||||||
| a5233ff3-ce66-4665-84f5-244979be146d | 2026-08-20 13:08 | 2026-08-20 13:08 | 2026-08-20 13:08 | NEM | NEM270617P00135000 | put | 135.0000 | 2027-06-17 | 23.4200 | 22.7500 | 24.0500 | 127.6800 | 63230.00 | 4690.00 | 58540.00 | 27 | 19 | 33 | 0 | 0 | 0.472733464366842 | 0.471638371355041 | false | false | ||||||||||||||||||
| fcd80f5c-5dcf-48ce-a8ed-a421631b6000 | 2026-08-17 11:34 | 2026-08-17 11:33 | 2026-08-17 11:33 | NEM | NEM270115P00115000 | put | 115.0000 | 2027-01-15 | 10.0000 | 9.5500 | 10.0000 | 120.7950 | 499988.00 | 499988.00 | 0.00 | 500 | 47 | 518 | 2570 | 0.201556420233463 | 0.451034762014669 | 0.451034762014669 | true | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 122280988050.00 |
| 2026-10-22 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:32:36.194150Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 127949852468.00 |
| 2026-10-22 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:43:48.295772Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 130183680082.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:25:28.380196Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 130183680082.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:25:57.460829Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 134092878407.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 134092878407.00 |
| 2026-10-22 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:33:11.786837Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 134092878407.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:11:50.316445Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 134092878407.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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 134092878407.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:37:27.552956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 130036163164.00 |
| 2026-10-22 |
| 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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 129677907792.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 129677907792.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T19:36:54.231390Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 129677907792.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 129677907792.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:25:17.992358Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 129677907792.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 129677907792.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 129677907792.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T16:14:40.561585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 129677907792.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 129677907792.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 129677907792.00 |
| 2026-10-22 |
| 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 |