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_alerts425,429 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 |
|---|
| c793e987-452e-49ea-bc01-b53c77467064 | 2026-08-24 09:55 | 2026-08-24 09:55 | 2026-08-24 09:55 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 3.8000 | 3.7000 | 4.0000 | 53.5150 | 18240.00 | 380.00 | 17860.00 | 48 | 5 | 127 | 12478 | 0.0101779131271037 | 0.709603317769383 | 0.709603317769383 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 286480.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e8110d42-66ea-4b92-b0b9-4feed2a205ef | 2026-08-24 11:42 | 2026-08-24 11:42 | 2026-08-24 11:42 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 4.0000 | 4.0000 | 4.1000 | 54.3450 | 21202.00 | 0.00 | 21202.00 | 53 | 29 | 262 | 12478 | 0.0209969546401667 | 0.702529836972753 | 0.702529836972753 | false | false | false | true | ||||||||||||||||
| 41ef8698-1c65-4665-8665-2ef1a08c1e40 | 2026-08-27 12:21 | 2026-08-27 12:21 | 2026-08-27 12:21 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 3.9000 | 3.9000 | 4.3000 | 55.9499 | 75308.00 | 0.00 | 75308.00 | 193 | 25 | 255 | 12543 | 0.0203300645778522 | 0.654808462842182 | 0.654661180938237 | false | false | false | true | ||||||||||||||||
| a99c8b4b-9005-4569-bf78-f4694e697ce7 | 2026-08-31 10:10 | 2026-08-31 10:09 | 2026-08-31 10:09 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 3.4700 | 3.4000 | 3.6500 | 56.4750 | 11801.00 | 0.00 | 11801.00 | 34 | 6 | 58 | 12757 | 0.00454652347730658 | 0.614584080139817 | 0.614584080139817 | false | false | false | true | ||||||||||||||||
| 0c5c7e50-c9a8-4201-9871-b5107e648eff | 2026-08-31 10:52 | 2026-08-31 10:51 | 2026-08-31 10:51 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 3.5500 | 3.4500 | 3.6500 | 56.5900 | 35486.00 | 0.00 | 4956.00 | 100 | 5 | 316 | 12757 | 0.0247707141177393 | 0.615630593385224 | 0.615630593385224 | false | false | false | true | ||||||||||||||||
| 7648a87c-4a88-4ec1-b124-6944d378345e | 2026-08-31 10:55 | 2026-08-31 10:55 | 2026-08-31 10:55 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 3.5000 | 3.4500 | 3.6000 | 56.7100 | 35017.00 | 0.00 | 35017.00 | 100 | 5 | 416 | 12757 | 0.0326095476993023 | 0.61029760863004 | 0.61029760863004 | false | false | false | true | ||||||||||||||||
| 89f4ae02-dc7e-4046-b675-08e036f5ca30 | 2026-08-31 11:10 | 2026-08-31 11:10 | 2026-08-31 11:10 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 3.3500 | 3.3000 | 3.6500 | 56.3100 | 119925.00 | 3350.00 | 116575.00 | 358 | 27 | 778 | 12757 | 0.0609861252645606 | 0.606868906886352 | 0.60234587921792 | false | false | false | true | ||||||||||||||||
| 7e8d4c27-512c-4db6-8a80-69882ddc4036 | 2026-09-01 11:46 | 2026-09-01 11:45 | 2026-09-01 11:45 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 3.2000 | 3.0500 | 3.2000 | 56.6050 | 32000.00 | 32000.00 | 0.00 | 100 | 6 | 369 | 13765 | 0.0268071195059935 | 0.587488621784508 | 0.587488621784508 | false | false | false | true | ||||||||||||||||
| 8b0fafeb-f674-4e00-8be1-d98c281a8b55 | 2026-09-04 12:32 | 2026-09-04 12:32 | 2026-09-04 12:32 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 4.1000 | 3.8500 | 4.1000 | 59.1800 | 177113.00 | 177113.00 | 0.00 | 432 | 21 | 1329 | 13779 | 0.0964511212715001 | 0.596905135045618 | 0.597059869464423 | false | false | false | true | ||||||||||||||||
| 2d7de4d9-235f-4465-b23a-6755f8a57ff0 | 2026-09-04 12:35 | 2026-09-04 12:35 | 2026-09-04 12:35 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 4.1000 | 4.1000 | 4.3500 | 59.1950 | 13940.00 | 0.00 | 13940.00 | 34 | 13 | 1405 | 13779 | 0.101966761013136 | 0.596595674751165 | 0.596595674751165 | false | false | false | true | ||||||||||||||||
| df56a319-2c62-4a81-93e3-057760579a21 | 2026-09-04 14:51 | 2026-09-04 14:51 | 2026-09-04 14:51 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 4.5000 | 4.3000 | 4.5000 | 59.1750 | 14850.00 | 14850.00 | 0.00 | 33 | 20 | 1450 | 13779 | 0.105232600333841 | 0.630371887889379 | 0.630371887889379 | false | false | false | true | ||||||||||||||||
| 690c080a-f480-4298-bb6b-0d068118b23c | 2026-09-04 14:53 | 2026-09-04 14:53 | 2026-09-04 14:53 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 4.6000 | 4.3000 | 4.6000 | 59.1650 | 183939.00 | 183939.00 | 0.00 | 400 | 48 | 1851 | 13779 | 0.134334857391683 | 0.638927156827341 | 0.638927156827341 | false | false | false | true | ||||||||||||||||
| e354fc5f-a317-41dc-84d7-8eb98e82ba92 | 2026-09-09 11:07 | 2026-09-09 11:06 | 2026-09-09 11:06 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 6.2000 | 6.2000 | 6.3000 | 61.9500 | 24800.00 | 0.00 | 24800.00 | 40 | 18 | 704 | 17252 | 0.040806862972409 | 0.690449450587683 | 0.690449450587683 | false | false | false | true | ||||||||||||||||
| c82d9a9e-b3d3-4ab1-8087-fcca895fa508 | 2026-09-11 09:58 | 2026-09-11 09:58 | 2026-09-11 09:58 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 4.2000 | 4.2000 | 4.2500 | 58.0000 | 23100.00 | 0.00 | 9240.00 | 55 | 17 | 60 | 17789 | 0.00337287087525999 | 0.63473155935376 | 0.63473155935376 | false | false | false | true | ||||||||||||||||
| 96e67557-75af-40cd-999f-1af1c3ea381e | 2026-09-17 10:36 | 2026-09-17 10:36 | 2026-09-17 10:36 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 3.2500 | 3.1000 | 3.3500 | 57.6100 | 21450.00 | 7150.00 | 14300.00 | 66 | 6 | 128 | 17798 | 0.00719181930553995 | 0.611329666779708 | 0.611329666779708 | false | false | false | true | ||||||||||||||||
| f72c96c0-61d4-4541-bd55-bd7a5a4d5068 | 2026-09-22 10:21 | 2026-09-22 10:21 | 2026-09-22 10:21 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 5.1000 | 5.0000 | 5.1000 | 63.1200 | 153000.00 | 153000.00 | 0.00 | 300 | 5 | 567 | 18680 | 0.0303533190578158 | 0.608006837936025 | 0.608006837936025 | false | false | false | true | ||||||||||||||||
| 30c30e03-ffe9-4b5c-ba54-bba8b7edd9e9 | 2026-09-22 15:16 | 2026-09-22 15:16 | 2026-09-22 15:16 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 5.2900 | 5.2000 | 5.3000 | 63.5550 | 26470.00 | 26470.00 | 0.00 | 50 | 6 | 1552 | 18680 | 0.0830835117773019 | 0.607133331933685 | 0.607133331933685 | false | false | false | true | ||||||||||||||||
| eddfbaeb-2ce8-42f3-9db1-cf19fbf85600 | 2026-09-22 15:21 | 2026-09-22 15:21 | 2026-09-22 15:21 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 5.3000 | 5.2000 | 5.3000 | 63.5350 | 106000.00 | 86920.00 | 0.00 | 200 | 10 | 1754 | 18680 | 0.0938972162740899 | 0.609489089628896 | 0.609489089628896 | false | false | false | true | ||||||||||||||||
| 7c03fb8b-04f0-4c24-ac9a-875dd02804c9 | 2026-09-23 10:25 | 2026-09-23 10:24 | 2026-09-23 10:24 | DRAM | DRAM261218C00070000 | call | 70.0000 | 2026-12-18 | 4.4000 | 4.4000 | 4.5000 | 61.0000 | 59411.00 | 0.00 | 59411.00 | 135 | 23 | 1067 | 19477 | 0.054782564049905 | 0.600560551157208 | 0.600560551157208 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:49:37.820281Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:30:57.923324Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T15:07:09.972110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T15:07:09.972110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| 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 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:05:15.166096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:05:15.166096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:48:09.438351Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:23:46.275389Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:17:07.798020Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:23:17.824277Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 286480.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:26:39.791719Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |