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_alerts523,327 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 |
|---|
| 741f36be-b3e4-426e-8c29-494b11dfe3f8 | 2026-08-31 15:57 | 2026-08-31 15:57 | 2026-08-31 15:57 | LITE | LITE260904C00970000 | call | 970.0000 | 2026-09-04 | 10.0000 | 9.8000 | 10.0000 | 913.3900 | 111000.00 | 108000.00 | 0.00 | 111 | 21 | 2878 | 563 | 5.11190053285968 | 0.766487612490286 | 0.766487612490286 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T13:34:32.417809Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c05cd85f-fe9f-434e-b88b-a67cb56291a0 | 2026-08-31 15:57 | 2026-08-31 15:57 | 2026-08-31 15:57 | LITE | LITE260904C00970000 | call | 970.0000 | 2026-09-04 | 10.4000 | 10.2000 | 10.7000 | 913.6650 | 159121.00 | 5200.00 | 128961.00 | 153 | 33 | 2718 | 563 | 4.82770870337478 | 0.777617764114307 | 0.777617764114307 | false | false | false | true | ||||||||||||||||
| 7e39366a-35a5-4324-8d8b-4964cdeff459 | 2026-08-31 14:11 | 2026-08-31 14:11 | 2026-08-31 14:11 | LITE | LITE260904C00970000 | call | 970.0000 | 2026-09-04 | 9.7000 | 9.5000 | 10.3000 | 909.0000 | 63050.00 | 62080.00 | 970.00 | 65 | 7 | 2343 | 563 | 4.16163410301954 | 0.786153215521197 | 0.786153215521197 | false | false | false | true | ||||||||||||||||
| 8181955e-0827-459d-b5a3-a11f2f423e74 | 2026-08-31 13:51 | 2026-08-31 13:51 | 2026-08-31 13:51 | LITE | LITE260904C00970000 | call | 970.0000 | 2026-09-04 | 9.7000 | 9.6000 | 9.7000 | 910.0000 | 142590.00 | 142590.00 | 0.00 | 147 | 6 | 2209 | 563 | 3.92362344582593 | 0.779926964436549 | 0.779926964436549 | false | false | false | true | ||||||||||||||||
| 9bf21cc9-dd3c-48d9-9cd1-eca7ba944582 | 2026-08-31 13:44 | 2026-08-31 13:43 | 2026-08-31 13:43 | LITE | LITE260904C00970000 | call | 970.0000 | 2026-09-04 | 9.4000 | 9.3000 | 9.7000 | 909.4600 | 109990.00 | 48890.00 | 61100.00 | 117 | 14 | 1989 | 563 | 3.53285968028419 | 0.783455285829668 | 0.77743797009352 | false | false | false | true | ||||||||||||||||
| 85c59ea1-92ff-4681-9214-6b37428265ed | 2026-08-31 13:43 | 2026-08-31 13:43 | 2026-08-31 13:43 | LITE | LITE260904C00970000 | call | 970.0000 | 2026-09-04 | 9.4000 | 9.3000 | 9.6000 | 908.0300 | 62980.00 | 10340.00 | 52640.00 | 67 | 5 | 1848 | 563 | 3.28241563055062 | 0.788753181931603 | 0.788753181931603 | false | false | false | true | ||||||||||||||||
| b70cc2db-a0f7-45af-8aff-121ff4fdc9c8 | 2026-08-31 11:32 | 2026-08-31 11:32 | 2026-08-31 11:32 | LITE | LITE260904C00970000 | call | 970.0000 | 2026-09-04 | 9.7000 | 9.5000 | 10.6000 | 905.5600 | 133860.00 | 129980.00 | 3880.00 | 138 | 5 | 1545 | 563 | 2.74422735346359 | 0.818816911798537 | 0.818816911798537 | false | false | false | true | ||||||||||||||||
| b6707909-7f6f-4d76-a08a-d23c6547a707 | 2026-08-31 10:05 | 2026-08-31 10:05 | 2026-08-31 10:05 | LITE | LITE260904C00970000 | call | 970.0000 | 2026-09-04 | 10.0000 | 9.5000 | 10.5000 | 908.8500 | 102000.00 | 101000.00 | 1000.00 | 102 | 13 | 1108 | 563 | 1.96802841918295 | 0.816949804663294 | 0.803027386179894 | false | false | false | true | ||||||||||||||||
| 6309e8fa-652c-48b0-968b-3f1a3a1c7fcf | 2026-08-31 10:05 | 2026-08-31 10:05 | 2026-08-31 10:05 | LITE | LITE260904C00970000 | call | 970.0000 | 2026-09-04 | 10.0000 | 9.5000 | 10.0000 | 906.9800 | 108000.00 | 108000.00 | 0.00 | 108 | 8 | 1006 | 563 | 1.78685612788632 | 0.817988283665943 | 0.817988283665943 | false | false | false | true | ||||||||||||||||
| 3230d464-5536-4c2a-919b-d2405cf46708 | 2026-08-31 10:05 | 2026-08-31 10:05 | 2026-08-31 10:05 | LITE | LITE260904C00970000 | call | 970.0000 | 2026-09-04 | 10.0000 | 8.8000 | 10.1000 | 906.2000 | 190000.00 | 190000.00 | 0.00 | 190 | 18 | 898 | 563 | 1.59502664298401 | 0.822020185033112 | 0.824214323579758 | false | false | false | true | ||||||||||||||||
| 25412e52-7344-422a-bd09-a6cdebfc2f2f | 2026-08-31 10:00 | 2026-08-31 10:00 | 2026-08-31 10:00 | LITE | LITE260904C00970000 | call | 970.0000 | 2026-09-04 | 10.0000 | 9.6000 | 10.1000 | 905.3000 | 322000.00 | 321000.00 | 0.00 | 322 | 18 | 532 | 563 | 0.9449378330373 | 0.831388108325192 | 0.831388108325192 | false | false | false | true | ||||||||||||||||
| e5869969-9029-45f7-ad13-7475808852b9 | 2026-08-31 09:59 | 2026-08-31 09:59 | 2026-08-31 09:59 | LITE | LITE260904C00970000 | call | 970.0000 | 2026-09-04 | 10.0000 | 9.3000 | 10.0000 | 904.9200 | 179000.00 | 179000.00 | 0.00 | 179 | 8 | 210 | 563 | 0.373001776198934 | 0.834413856517288 | 0.834413856517288 | false | false | false | true | ||||||||||||||||
| 6b668e3f-ec9b-4017-89c4-81d00d16d0af | 2026-08-28 09:37 | 2026-08-28 09:37 | 2026-08-28 09:37 | LITE | LITE260904C00970000 | call | 970.0000 | 2026-09-04 | 23.0300 | 22.1000 | 24.0000 | 930.4700 | 50660.00 | 6960.00 | 43700.00 | 22 | 6 | 403 | 45 | 8.95555555555556 | 0.751337342509972 | 0.763691918978554 | false | false | false | true | ||||||||||||||||
| 077a0837-b827-4d0d-8398-9e96a9c85277 | 2026-08-28 09:37 | 2026-08-28 09:36 | 2026-08-28 09:36 | LITE | LITE260904C00970000 | call | 970.0000 | 2026-09-04 | 22.2000 | 21.1000 | 24.1000 | 930.0000 | 843581.00 | 479671.00 | 363910.00 | 380 | 30 | 380 | 45 | 8.44444444444444 | 0.742483750345643 | 0.734196447557688 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:34:32.417809Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| 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 |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| 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 |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:02:22.723941Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:02:22.723941Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |