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_alerts708,051 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 |
|---|
| 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 |
|---|
| f45d51fb-072f-4e15-b663-7a11baa492b2 | 2026-08-17 12:43 | 2026-08-17 12:43 | 2026-08-17 12:43 | ORCL | ORCL260918C00160000 | call | 160.0000 | 2026-09-18 | 7.6800 | 7.6000 | 8.0500 | 147.9600 | 65310.00 | 770.00 | 64540.00 | 85 | 6 | 1050 | 19428 | 0.0540457072266831 | 0.695854262542238 | 0.697037941830755 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| da77b05e-c507-4178-8f46-5838af53979a | 2026-08-18 12:33 | 2026-08-18 12:32 | 2026-08-18 12:32 | ORCL | ORCL260918C00160000 | call | 160.0000 | 2026-09-18 | 5.8700 | 5.8000 | 6.1500 | 143.5700 | 374065.00 | 156395.00 | 217670.00 | 637 | 41 | 3280 | 19945 | 0.164452243670093 | 0.69306287494939 | 0.696993442830867 | true | false | false | |||||||||||||||||
| debb1450-334e-4e06-aa78-ac5528396a06 | 2026-08-18 12:33 | 2026-08-18 12:32 | 2026-08-18 12:32 | ORCL | ORCL260918C00160000 | call | 160.0000 | 2026-09-18 | 5.8200 | 5.7500 | 6.0500 | 143.5950 | 159385.00 | 54405.00 | 104980.00 | 274 | 12 | 4642 | 19945 | 0.232740035096515 | 0.689902362324566 | 0.689902362324566 | false | false | false | |||||||||||||||||
| 37635e84-7d4b-41c0-8c89-6647c029dc6a | 2026-09-04 11:01 | 2026-09-04 11:01 | 2026-09-04 11:01 | ORCL | ORCL260918C00160000 | call | 160.0000 | 2026-09-18 | 9.3600 | 9.3500 | 9.4500 | 158.3350 | 70175.00 | 9400.00 | 60775.00 | 75 | 6 | 2812 | 21144 | 0.132992811199395 | 0.809603875025494 | 0.813646637295853 | false | false | false | |||||||||||||||||
| e5dca6ef-a6ea-4103-910d-2a6f15ffbd43 | 2026-09-04 11:01 | 2026-09-04 11:01 | 2026-09-04 11:01 | ORCL | ORCL260918C00160000 | call | 160.0000 | 2026-09-18 | 9.3800 | 9.3500 | 9.5000 | 158.4000 | 116300.00 | 15040.00 | 48620.00 | 124 | 28 | 2936 | 21144 | 0.138857359061672 | 0.806927271093027 | 0.810968580819682 | false | false | false | |||||||||||||||||
| 01348c9b-3be7-4829-9afc-d9476a5ae477 | 2026-09-04 11:02 | 2026-09-04 11:02 | 2026-09-04 11:02 | ORCL | ORCL260918C00160000 | call | 160.0000 | 2026-09-18 | 9.1700 | 9.1000 | 9.2000 | 158.0400 | 137515.00 | 57910.00 | 0.00 | 150 | 34 | 3357 | 21144 | 0.158768444948922 | 0.805509861126728 | 0.809559333314973 | false | false | false | |||||||||||||||||
| 8c20cccc-d69c-4258-b6e0-c100bb4cfa3f | 2026-09-04 11:04 | 2026-09-04 11:04 | 2026-09-04 11:04 | ORCL | ORCL260918C00160000 | call | 160.0000 | 2026-09-18 | 9.1000 | 9.0500 | 9.2000 | 157.8980 | 93715.00 | 4550.00 | 7265.00 | 103 | 20 | 3896 | 21144 | 0.1842603102535 | 0.803191716296428 | 0.80724465034599 | false | false | false | |||||||||||||||||
| 2b86095e-8678-4c23-baee-6c120e8974f4 | 2026-09-09 09:33 | 2026-09-09 09:33 | 2026-09-09 09:33 | ORCL | ORCL260918C00160000 | call | 160.0000 | 2026-09-18 | 11.7700 | 11.5500 | 11.8000 | 162.3300 | 529755.00 | 503795.00 | 0.00 | 450 | 33 | 601 | 19168 | 0.0313543405676127 | 1.04765301194014 | 1.04299388485882 | false | false | false | |||||||||||||||||
| 6e4df626-6ec9-44df-a071-77bcb035475a | 2026-09-09 09:34 | 2026-09-09 09:33 | 2026-09-09 09:33 | ORCL | ORCL260918C00160000 | call | 160.0000 | 2026-09-18 | 11.7200 | 11.4500 | 11.7500 | 162.2900 | 686550.00 | 686550.00 | 0.00 | 586 | 30 | 1421 | 19168 | 0.0741339732888147 | 1.03985930269471 | 1.04027553606394 | false | false | false | |||||||||||||||||
| 0fbf5e02-b5fd-456f-8871-ba506956ab20 | 2026-09-09 09:34 | 2026-09-09 09:34 | 2026-09-09 09:34 | ORCL | ORCL260918C00160000 | call | 160.0000 | 2026-09-18 | 11.7500 | 11.6500 | 11.8000 | 162.2900 | 415965.00 | 70515.00 | 0.00 | 354 | 21 | 2024 | 19168 | 0.10559265442404 | 1.04027553606394 | 1.04526895257868 | false | false | false | |||||||||||||||||
| ffe9bad3-9ac1-4183-bc9f-d1ce73522bba | 2026-09-09 09:51 | 2026-09-09 09:51 | 2026-09-09 09:51 | ORCL | ORCL260918C00160000 | call | 160.0000 | 2026-09-18 | 12.5000 | 12.5000 | 12.7500 | 163.3850 | 3607593.00 | 12550.00 | 3595043.00 | 2886 | 70 | 5003 | 19168 | 0.261007929883139 | 1.05410588520579 | 1.05205926730795 | false | false | false | |||||||||||||||||
| 4d3a2be3-28a0-4c17-868b-dfe7ee903e2c | 2026-09-10 15:20 | 2026-09-10 15:19 | 2026-09-10 15:19 | ORCL | ORCL260918C00160000 | call | 160.0000 | 2026-09-18 | 8.5100 | 8.5000 | 8.7000 | 154.8200 | 161749.00 | 0.00 | 161749.00 | 190 | 23 | 6164 | 19150 | 0.321879895561358 | 1.16771530896564 | 1.17320997426929 | false | false | false | |||||||||||||||||
| f770abe2-d7e4-4e84-a39a-58ea32fefec9 | 2026-09-11 15:51 | 2026-09-11 15:50 | 2026-09-11 15:50 | ORCL | ORCL260918C00160000 | call | 160.0000 | 2026-09-18 | 1.5900 | 1.5900 | 1.6200 | 150.4200 | 83684.00 | 0.00 | 83684.00 | 526 | 27 | 40745 | 20718 | 1.96664735978376 | 0.577506827199889 | 0.579068313912401 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:23:10.886670Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:23:10.886670Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:23:10.886670Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:23:10.886670Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:25:57.950009Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:55:36.907305Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |