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 |
|---|
| cd0a6ed3-0ec9-4069-a8bc-113cf3df467b | 2026-09-18 15:40 | 2026-09-18 15:40 | 2026-09-18 15:40 | ENPH | ENPH261218C00055000 | call | 55.0000 | 2026-12-18 | 0.9200 | 0.9200 | 1.0300 | 34.8400 | 18450.00 | 0.00 | 18450.00 | 200 | 14 | 372 | 1997 | 0.186279419128693 | 0.751116960877277 | 0.753687524783274 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 4577490607.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 76d51ea7-4383-43a2-9922-49c89008cdaa | 2026-09-14 12:58 | 2026-09-14 12:58 | 2026-09-14 12:58 | ENPH | ENPH261009P00032000 | put | 32.0000 | 2026-10-09 | 0.5800 | 0.5600 | 0.7900 | 36.9950 | 20129.00 | 0.00 | 20011.00 | 347 | 15 | 1138 | 73 | 15.5890410958904 | 0.633082844552787 | 0.637232117587066 | false | false | false | true | ||||||||||||||||
| faccca1b-109f-46f1-b89f-3ce65f39aea7 | 2026-09-10 10:58 | 2026-09-10 10:58 | 2026-09-10 10:58 | ENPH | ENPH260911C00037500 | call | 37.5000 | 2026-09-11 | 1.2500 | 0.8400 | 1.2600 | 38.1500 | 27583.00 | 27583.00 | 0.00 | 221 | 9 | 1003 | 120 | 8.35833333333333 | 1.06751306803815 | 1.13376838727073 | true | false | false | true | ||||||||||||||||
| e030c0b9-f8c5-4aea-9e17-4746612bc459 | 2026-09-09 10:24 | 2026-09-09 10:24 | 2026-09-09 10:24 | ENPH | ENPH281215C00050000 | call | 50.0000 | 2028-12-15 | 14.3400 | 13.8500 | 15.7000 | 37.0000 | 31550.00 | 0.00 | 27260.00 | 22 | 22 | 22 | 358 | 0.0614525139664804 | 0.755812619129158 | 0.758212781783764 | true | false | false | true | ||||||||||||||||
| 5ed4b120-16f4-4dc0-8f6b-43a9e5fc731f | 2026-09-08 12:02 | 2026-09-08 12:02 | 2026-09-08 12:02 | ENPH | ENPH260918C00040000 | call | 40.0000 | 2026-09-18 | 1.4100 | 1.4100 | 1.4600 | 38.9150 | 195017.00 | 1988.00 | 193029.00 | 1383 | 41 | 4536 | 3169 | 1.43136636162827 | 0.724701792451773 | 0.724701792451773 | true | false | false | true | ||||||||||||||||
| 1f0e2d42-a57c-4ed3-95cb-63c35f6d1f28 | 2026-09-08 12:00 | 2026-09-08 12:00 | 2026-09-08 12:00 | ENPH | ENPH260918C00040000 | call | 40.0000 | 2026-09-18 | 1.3900 | 1.3900 | 1.4000 | 38.8950 | 100986.00 | 10080.00 | 90906.00 | 726 | 34 | 1719 | 3169 | 0.542442410855159 | 0.720244019291673 | 0.724191482134525 | false | false | false | true | ||||||||||||||||
| 40aa0417-b687-41b3-866c-229360676fa9 | 2026-09-08 11:59 | 2026-09-08 11:59 | 2026-09-08 11:59 | ENPH | ENPH260918C00040000 | call | 40.0000 | 2026-09-18 | 1.3600 | 1.3100 | 1.4000 | 38.8600 | 20402.00 | 545.00 | 19857.00 | 150 | 9 | 801 | 3169 | 0.252761123382771 | 0.714359922075112 | 0.718317649930552 | false | false | false | true | ||||||||||||||||
| 958a274e-584b-445d-8ea9-bae83225b81d | 2026-09-04 13:11 | 2026-09-04 13:11 | 2026-09-04 13:11 | ENPH | ENPH260918C00038000 | call | 38.0000 | 2026-09-18 | 0.9800 | 0.9700 | 1.0500 | 36.2000 | 43122.00 | 99.00 | 42924.00 | 440 | 10 | 453 | 850 | 0.532941176470588 | 0.583851747664224 | 0.595480107932589 | false | false | false | true | ||||||||||||||||
| 05bd4a54-d9ec-40eb-b583-4a680a0d5255 | 2026-09-03 14:05 | 2026-09-03 14:05 | 2026-09-03 14:05 | ENPH | ENPH261016C00040000 | call | 40.0000 | 2026-10-16 | 1.7700 | 1.7500 | 1.7700 | 36.0100 | 55535.00 | 53423.00 | 1936.00 | 314 | 22 | 532 | 3869 | 0.137503230808995 | 0.642178424710699 | 0.64178586408696 | true | false | false | true | ||||||||||||||||
| 715fe7e3-75a5-4926-8c6a-c8d8ed5d1e62 | 2026-09-03 14:02 | 2026-09-03 14:02 | 2026-09-03 14:02 | ENPH | ENPH261016C00045000 | call | 45.0000 | 2026-10-16 | 0.8800 | 0.8500 | 0.8800 | 36.0200 | 35282.00 | 35024.00 | 258.00 | 401 | 6 | 423 | 1371 | 0.308533916849015 | 0.673880846738673 | 0.674172221061764 | false | false | false | true | ||||||||||||||||
| b0a0ba69-3087-4d21-9c35-2194aea077fb | 2026-09-03 10:25 | 2026-09-03 10:25 | 2026-09-03 10:25 | ENPH | ENPH270219C00050000 | call | 50.0000 | 2027-02-19 | 3.0300 | 2.9200 | 3.1500 | 35.2150 | 21540.00 | 1505.00 | 10675.00 | 71 | 39 | 558 | 70 | 7.97142857142857 | 0.725093511180124 | 0.730821423987759 | false | false | false | true | ||||||||||||||||
| 3031f9d7-325d-446b-9805-7d5f578d38e0 | 2026-09-03 10:25 | 2026-09-03 10:25 | 2026-09-03 10:25 | ENPH | ENPH270219C00050000 | call | 50.0000 | 2027-02-19 | 3.0300 | 3.0000 | 3.1500 | 35.2150 | 14245.00 | 1220.00 | 6010.00 | 47 | 23 | 609 | 70 | 8.7 | 0.725093511180124 | 0.730821423987759 | false | false | false | true | ||||||||||||||||
| 2ea6a49d-4888-4a05-a204-88c935ff1be0 | 2026-09-01 12:02 | 2026-09-01 12:02 | 2026-09-01 12:02 | ENPH | ENPH270219P00035000 | put | 35.0000 | 2027-02-19 | 6.0600 | 6.0500 | 6.1000 | 35.6650 | 19380.00 | 2440.00 | 16940.00 | 32 | 17 | 107 | 47 | 2.27659574468085 | 0.706318930010494 | 0.711722681648205 | false | false | false | true | ||||||||||||||||
| e0279aab-7e06-4607-8f03-960d9c481b1f | 2026-08-28 13:14 | 2026-08-28 13:14 | 2026-08-28 13:14 | ENPH | ENPH260918C00035000 | call | 35.0000 | 2026-09-18 | 3.2000 | 2.9500 | 3.4500 | 36.8100 | 63914.00 | 0.00 | 16554.00 | 200 | 9 | 216 | 1726 | 0.125144843568946 | 0.613560843692847 | 0.613560843692847 | false | false | false | true | ||||||||||||||||
| c38a9b57-e462-4132-ada1-b8e0ca640f84 | 2026-08-26 15:46 | 2026-08-26 15:46 | 2026-08-26 15:46 | ENPH | ENPH260904C00042000 | call | 42.0000 | 2026-09-04 | 0.5500 | 0.4300 | 0.5600 | 38.6057 | 144936.00 | 144936.00 | 0.00 | 2635 | 49 | 2655 | 58 | 45.7758620689655 | 0.705622645505667 | 0.693810148295516 | true | false | false | true | ||||||||||||||||
| e8f0a795-eb22-485d-968b-7f886040f52e | 2026-08-26 11:45 | 2026-08-26 11:45 | 2026-08-26 11:45 | ENPH | ENPH261218C00045000 | call | 45.0000 | 2026-12-18 | 3.8000 | 3.8000 | 3.9000 | 37.2875 | 140620.00 | 0.00 | 140620.00 | 370 | 31 | 414 | 1187 | 0.348778433024431 | 0.752665344301976 | 0.752665344301976 | false | false | false | true | ||||||||||||||||
| 9baf56b2-b6d4-4654-ae47-6d22d88a3fde | 2026-08-24 09:38 | 2026-08-24 09:38 | 2026-08-24 09:38 | ENPH | ENPH261120C00050000 | call | 50.0000 | 2026-11-20 | 2.3200 | 2.3000 | 2.5100 | 37.9500 | 12757.00 | 232.00 | 12525.00 | 55 | 16 | 56 | 3085 | 0.0181523500810373 | 0.769914505494006 | 0.772984641877061 | true | false | false | true | ||||||||||||||||
| 242f6d9b-fdbc-46f2-bb51-3a2268eeedf8 | 2026-08-24 09:32 | 2026-08-24 09:32 | 2026-08-24 09:32 | ENPH | ENPH270617C00060000 | call | 60.0000 | 2027-06-17 | 5.3300 | 4.6500 | 5.5000 | 38.3200 | 10664.00 | 10664.00 | 0.00 | 20 | 5 | 20 | 623 | 0.0321027287319422 | 0.767368008417144 | 0.767368008417144 | false | false | false | true | ||||||||||||||||
| 65914f1a-6299-4f0d-b287-1e4198ddbab1 | 2026-08-18 15:58 | 2026-08-18 15:58 | 2026-08-18 15:58 | ENPH | ENPH260904P00035000 | put | 35.0000 | 2026-09-04 | 0.7900 | 0.7600 | 0.9800 | 37.0000 | 33180.00 | 17115.00 | 16065.00 | 420 | 7 | 692 | 170 | 4.07058823529412 | 0.57675560525141 | 0.595859355261193 | true | false | false | true | ||||||||||||||||
| 5c7a69aa-511b-4794-b29e-12e2e6e65e2f | 2026-08-18 13:27 | 2026-08-18 13:27 | 2026-08-18 13:27 | ENPH | ENPH281215C00100000 | call | 100.0000 | 2028-12-15 | 8.3000 | 8.3000 | 8.9000 | 37.5800 | 39022.00 | 835.00 | 38187.00 | 47 | 16 | 48 | 348 | 0.137931034482759 | 0.776472808772499 | 0.776472808772499 | true | false | false | true | ||||||||||||||||
| 9b51da8b-3ce1-43de-9728-f29a4820f7c0 | 2026-08-18 13:27 | 2026-08-18 13:27 | 2026-08-18 13:27 | ENPH | ENPH281215C00070000 | call | 70.0000 | 2028-12-15 | 11.6500 | 11.6500 | 12.1000 | 37.5800 | 31465.00 | 1170.00 | 30295.00 | 27 | 13 | 698 | 636 | 1.09748427672956 | 0.784040605942916 | 0.783808613221312 | true | false | false | true | ||||||||||||||||
| afeb2847-a595-4e9d-a773-5482811ad392 | 2026-08-17 10:30 | 2026-08-17 10:30 | 2026-08-17 10:30 | ENPH | ENPH261218C00110000 | call | 110.0000 | 2026-12-18 | 0.3200 | 0.1500 | 0.5500 | 39.1600 | 28274.00 | 0.00 | 28274.00 | 887 | 9 | 887 | 57 | 15.5614035087719 | 0.802458498238576 | 0.802458498238576 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:17:14.116635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T15:21:12.723015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T18:16:35.526734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T18:16:35.526734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:40:26.963433Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:40:26.963433Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T16:07:53.122506Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T17:15:24.821907Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:59:46.397035Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:46:45.098903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:38:06.174043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:30:09.852702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4844422796.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |