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_alerts728,802 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 |
|---|
| 7d927deb-e2e6-4f90-8422-62aaae7eb8c5 | 2026-09-25 15:15 | 2026-09-25 15:15 | 2026-09-25 15:15 | VXX | VXX260925C00015500 | call | 15.5000 | 2026-09-25 | 1.8000 | 1.8000 | 1.9500 | 17.3450 | 16225.00 | 0.00 | 16225.00 | 90 | 12 | 180 | 2 | 90 | 10.7859450116755 | 10.7859450116755 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Structured Product | — | 0.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:17:13.698421Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| b67cdc44-fceb-4c38-9f60-894d9ce0cceb | 2026-09-25 11:54 | 2026-09-25 11:54 | 2026-09-25 11:54 | VXX | VXX260925C00015500 | call | 15.5000 | 2026-09-25 | 2.0000 | 1.9700 | 2.5500 | 17.0000 | 14400.00 | 0.00 | 14400.00 | 72 | 11 | 90 | 2 | 45 | 9.14613820187431 | 9.14644925985493 | false | false | false | true | false | |||||||||||||||
| c33a076e-5a34-4537-9ee3-5cefd6eedf6d | 2026-09-24 14:24 | 2026-09-24 14:24 | 2026-09-24 14:24 | VXX | VXX261218C00019000 | call | 19.0000 | 2026-12-18 | 1.8000 | 1.6500 | 1.9100 | 17.5700 | 18720.00 | 18360.00 | 0.00 | 104 | 6 | 104 | 187 | 0.556149732620321 | 0.680225971414559 | 0.680225971414559 | true | false | false | true | ||||||||||||||||
| eec266f2-7bdb-4c16-8d7d-86e4f1001548 | 2026-09-24 13:43 | 2026-09-24 13:42 | 2026-09-24 13:42 | VXX | VXX261002C00019500 | call | 19.5000 | 2026-10-02 | 0.1100 | 0.1000 | 0.1800 | 17.6300 | 22891.00 | 220.00 | 22671.00 | 2000 | 38 | 3847 | 2714 | 1.4174649963154 | 0.604441380032801 | 0.604441380032801 | true | false | false | true | ||||||||||||||||
| 365e025e-41c2-4033-85c5-7ea2bb4a2748 | 2026-09-24 13:42 | 2026-09-24 13:42 | 2026-09-24 13:42 | VXX | VXX261002C00019000 | call | 19.0000 | 2026-10-02 | 0.1500 | 0.1500 | 0.2100 | 17.6300 | 30000.00 | 0.00 | 30000.00 | 2000 | 7 | 3414 | 1181 | 2.89077053344623 | 0.553830227000286 | 0.553830227000286 | false | false | false | true | ||||||||||||||||
| 13c6345c-2ff6-405f-93c2-e89903292518 | 2026-09-24 12:16 | 2026-09-24 12:16 | 2026-09-24 12:16 | VXX | VXX261218P00017000 | put | 17.0000 | 2026-12-18 | 1.7300 | 1.6900 | 2.0300 | 17.0000 | 23182.00 | 0.00 | 23182.00 | 134 | 31 | 154 | 347 | 0.443804034582133 | 0.629620560251155 | 0.629620560251155 | true | false | false | true | ||||||||||||||||
| d77a60be-30f6-4a5d-8bb4-36da95836ec4 | 2026-09-24 12:15 | 2026-09-24 12:15 | 2026-09-24 12:15 | VXX | VXX261030P00017000 | put | 17.0000 | 2026-10-30 | 0.9100 | 0.7100 | 0.9400 | 17.6400 | 19747.00 | 19110.00 | 637.00 | 217 | 24 | 259 | 624 | 0.415064102564103 | 0.570600807576512 | 0.569708782494487 | true | false | false | true | ||||||||||||||||
| d4bf2c6d-d95c-41f9-8c45-e40180308bb0 | 2026-09-24 10:37 | 2026-09-24 10:36 | 2026-09-24 10:36 | VXX | VXX261002C00017500 | call | 17.5000 | 2026-10-02 | 0.4500 | 0.4500 | 0.5000 | 17.5600 | 17235.00 | 0.00 | 17235.00 | 383 | 46 | 4011 | 386 | 10.3911917098446 | 0.397441463010513 | 0.397441463010513 | true | false | false | true | ||||||||||||||||
| b9db5d66-6c15-4fde-a0ec-d5435e45c9b9 | 2026-09-24 10:09 | 2026-09-24 10:09 | 2026-09-24 10:09 | VXX | VXX261002P00017500 | put | 17.5000 | 2026-10-02 | 0.4000 | 0.4000 | 0.4500 | 17.5300 | 74520.00 | 0.00 | 74520.00 | 1863 | 49 | 4004 | 375 | 10.6773333333333 | 0.408431675395813 | 0.408431675395813 | true | false | false | true | ||||||||||||||||
| b5854fb8-8df5-4624-ab36-47bfc055e1e4 | 2026-09-24 10:05 | 2026-09-24 10:05 | 2026-09-24 10:05 | VXX | VXX261002C00017500 | call | 17.5000 | 2026-10-02 | 0.4600 | 0.4600 | 0.5000 | 17.5505 | 35604.00 | 0.00 | 35604.00 | 774 | 22 | 1995 | 386 | 5.16839378238342 | 0.412091052697515 | 0.412091052697515 | true | false | false | true | ||||||||||||||||
| c97e9d99-17e0-4778-8fe8-8ebffc193cc6 | 2026-09-24 09:50 | 2026-09-24 09:50 | 2026-09-24 09:50 | VXX | VXX261016C00020000 | call | 20.0000 | 2026-10-16 | 0.4100 | 0.4100 | 0.5000 | 17.5950 | 46412.00 | 0.00 | 2214.00 | 1132 | 11 | 1132 | 13520 | 0.0837278106508876 | 0.681938002450015 | 0.681938002450015 | true | false | false | true | ||||||||||||||||
| 0611e4a9-db88-4b7f-a5a5-61f9bce4cbaf | 2026-09-23 11:30 | 2026-09-23 11:30 | 2026-09-23 11:30 | VXX | VXX261002C00020000 | call | 20.0000 | 2026-10-02 | 0.1100 | 0.1100 | 0.1500 | 17.0000 | 15565.00 | 0.00 | 15565.00 | 1415 | 10 | 2784 | 6625 | 0.42022641509434 | 0.739324163122146 | 0.739324163122146 | true | false | false | true | ||||||||||||||||
| cf5d40d1-e06d-438d-b3ed-2fe3bf435dbd | 2026-09-23 11:30 | 2026-09-23 11:29 | 2026-09-23 11:29 | VXX | VXX261002C00019500 | call | 19.5000 | 2026-10-02 | 0.1200 | 0.1200 | 0.2200 | 17.0000 | 24000.00 | 0.00 | 24000.00 | 2000 | 50 | 2011 | 209 | 9.62200956937799 | 0.663812036495488 | 0.663812036495488 | true | false | false | true | ||||||||||||||||
| e9cb2d46-dc2b-4db9-a977-19e9ba06c98d | 2026-09-23 10:46 | 2026-09-23 10:46 | 2026-09-23 10:46 | VXX | VXX261218C00020000 | call | 20.0000 | 2026-12-18 | 1.7000 | 1.3400 | 1.7000 | 17.3450 | 17000.00 | 17000.00 | 0.00 | 100 | 15 | 120 | 1087 | 0.110395584176633 | 0.772125589446742 | 0.772125589446742 | false | false | false | true | ||||||||||||||||
| 285bc2cc-dd3e-471d-8064-c3af2134903d | 2026-09-23 09:47 | 2026-09-23 09:47 | 2026-09-23 09:47 | VXX | VXX261016C00017000 | call | 17.0000 | 2026-10-16 | 1.0000 | 0.8700 | 1.0000 | 17.0000 | 74900.00 | 74900.00 | 0.00 | 749 | 23 | 750 | 1094 | 0.685557586837294 | 0.509342500035075 | 0.509342500035075 | true | false | false | true | ||||||||||||||||
| 7e90fe93-e42b-494b-a485-aad1c6a8d693 | 2026-09-22 15:53 | 2026-09-22 15:53 | 2026-09-22 15:53 | VXX | VXX261016C00020000 | call | 20.0000 | 2026-10-16 | 0.3200 | 0.3100 | 0.3700 | 17.0000 | 31136.00 | 1568.00 | 29568.00 | 973 | 47 | 1446 | 15202 | 0.0951190632811472 | 0.655983039508838 | 0.656811773774036 | false | false | false | true | ||||||||||||||||
| 74618acf-1733-4849-b6a9-d635e4ffa55a | 2026-09-22 09:37 | 2026-09-22 09:37 | 2026-09-22 09:37 | VXX | VXX261002C00020000 | call | 20.0000 | 2026-10-02 | 0.1700 | 0.1200 | 0.2000 | 17.5150 | 13498.00 | 13498.00 | 0.00 | 794 | 5 | 799 | 4193 | 0.190555688051514 | 0.746941725118268 | 0.746941725118268 | false | false | false | true | ||||||||||||||||
| 9acdc382-6a98-4086-b976-0b5e0cc752c3 | 2026-09-09 15:12 | 2026-09-09 15:12 | 2026-09-09 15:12 | VXX | VXX270115C00020000 | call | 20.0000 | 2027-01-15 | 2.6000 | 2.6000 | 2.8800 | 18.2200 | 260000.00 | 0.00 | 161980.00 | 1000 | 6 | 1000 | 656 | 1.52439024390244 | 0.743981553047751 | 0.743981553047751 | false | false | false | true | ||||||||||||||||
| c715ab1c-5919-4053-a72a-ae32145258cb | 2026-08-31 09:56 | 2026-08-31 09:56 | 2026-08-31 09:56 | VXX | VXX261016C00018000 | call | 18.0000 | 2026-10-16 | 1.8000 | 1.6500 | 1.9300 | 18.3900 | 180000.00 | 69480.00 | 24840.00 | 1000 | 10 | 1002 | 3241 | 0.309163838321506 | 0.603998255432727 | 0.603998255432727 | false | false | false | true | ||||||||||||||||
| 237dc12a-8b34-45ac-a7c0-64ecee6aece9 | 2026-08-20 11:18 | 2026-08-20 11:18 | 2026-08-20 11:18 | VXX | VXX261120C00023000 | call | 23.0000 | 2026-11-20 | 1.9000 | 0.2600 | 3.5500 | 19.2450 | 189500.00 | 94500.00 | 95000.00 | 1000 | 15 | 1000 | 0 | 0 | 0.809642158613321 | 0.806988751196518 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:56:11.622901Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:26:21.590036Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:43:31.900788Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:43:31.900788Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:16:49.777231Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:16:21.801502Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:39:59.397883Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:10:55.671270Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:06:35.686187Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:51:23.785124Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:31:00.015856Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:31:00.015856Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:47:19.358930Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:49:25.662048Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Structured Product |
| — |
| 0.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |