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 rows| 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 |
|---|
| f74f6384-1d91-473b-ba97-30f840e73946 | 2026-09-28 10:42 | 2026-09-28 10:42 | 2026-09-28 10:42 | INTC | INTC261218C00110000 | call | 110.0000 | 2026-12-18 | 18.0500 | 18.0500 | 18.4500 | 116.5800 | 19855.00 | 0.00 | 19855.00 | 11 | 10 | 50 | 9190 | 0.00544069640914037 | 0.659437182512036 | 0.659437182512036 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 585255320000.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T14:42:23.543990Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| dfc5a64c-3d02-4d73-a2e0-400cd85b2fa3 | 2026-09-25 10:15 | 2026-09-25 10:15 | 2026-09-25 10:15 | INTC | INTC261218C00110000 | call | 110.0000 | 2026-12-18 | 24.2000 | 23.8500 | 24.5500 | 124.4128 | 135520.00 | 99220.00 | 0.00 | 56 | 5 | 93 | 9319 | 0.00997961154630325 | 0.685870553708751 | 0.685870553708751 | false | false | false | true | ||||||||||||||||
| 4474ed04-4728-469d-92a4-3365b51e21b5 | 2026-09-23 12:26 | 2026-09-23 12:25 | 2026-09-23 12:25 | INTC | INTC261218C00110000 | call | 110.0000 | 2026-12-18 | 21.3000 | 21.1000 | 21.3500 | 120.2600 | 25560.00 | 25560.00 | 0.00 | 12 | 8 | 101 | 9369 | 0.01078023268225 | 0.677532081238703 | 0.677532081238703 | false | false | false | true | ||||||||||||||||
| 09a4c9dc-fc38-4a7f-ad33-51dbd5e57482 | 2026-09-22 14:55 | 2026-09-22 14:55 | 2026-09-22 14:55 | INTC | INTC261218C00110000 | call | 110.0000 | 2026-12-18 | 23.6000 | 23.3500 | 23.6000 | 122.9500 | 70800.00 | 70800.00 | 0.00 | 30 | 5 | 160 | 9439 | 0.0169509481936646 | 0.694394342589383 | 0.694394342589383 | false | false | false | true | ||||||||||||||||
| 16780cc8-8f87-49eb-bd56-d262be2e2125 | 2026-09-21 15:35 | 2026-09-21 15:35 | 2026-09-21 15:35 | INTC | INTC261218C00110000 | call | 110.0000 | 2026-12-18 | 23.2000 | 23.0500 | 23.2000 | 121.8799 | 64960.00 | 64960.00 | 0.00 | 28 | 6 | 1005 | 9894 | 0.101576713159491 | 0.706699849113256 | 0.706699849113256 | false | false | false | true | ||||||||||||||||
| 6b31284d-624c-42ad-82f0-491ca6c7165f | 2026-09-21 14:19 | 2026-09-21 14:19 | 2026-09-21 14:19 | INTC | INTC261218C00110000 | call | 110.0000 | 2026-12-18 | 22.8400 | 22.7500 | 23.0000 | 121.5000 | 27408.00 | 0.00 | 27408.00 | 12 | 5 | 912 | 9894 | 0.0921770770163736 | 0.702048756735384 | 0.702048756735384 | false | false | false | true | ||||||||||||||||
| 558a07f0-8b46-4588-941f-ada87b9c6b03 | 2026-09-21 10:10 | 2026-09-21 10:10 | 2026-09-21 10:10 | INTC | INTC261218C00110000 | call | 110.0000 | 2026-12-18 | 21.1000 | 20.9000 | 21.1000 | 118.9100 | 18990.00 | 18990.00 | 0.00 | 9 | 9 | 501 | 9894 | 0.0506367495451789 | 0.702646412208235 | 0.702646412208235 | false | false | false | true | ||||||||||||||||
| eee55c50-e210-406c-be2a-9e42f6e7e1e7 | 2026-09-21 10:00 | 2026-09-21 10:00 | 2026-09-21 10:00 | INTC | INTC261218C00110000 | call | 110.0000 | 2026-12-18 | 21.0000 | 20.7500 | 21.0000 | 118.8500 | 115500.00 | 115500.00 | 0.00 | 55 | 6 | 423 | 9894 | 0.0427531837477259 | 0.699820178967911 | 0.699820178967911 | false | false | false | true | ||||||||||||||||
| 4cb7622b-65f2-47bf-a49e-c31798c3cca4 | 2026-09-21 09:51 | 2026-09-21 09:50 | 2026-09-21 09:50 | INTC | INTC261218C00110000 | call | 110.0000 | 2026-12-18 | 19.9000 | 19.7000 | 20.0000 | 117.2450 | 19900.00 | 19900.00 | 0.00 | 10 | 5 | 340 | 9894 | 0.0343642611683849 | 0.697282099185786 | 0.697739965054695 | false | false | false | true | ||||||||||||||||
| f98e6fbc-467f-4a15-8523-c76b7bb1d2f5 | 2026-09-21 09:30 | 2026-09-21 09:30 | 2026-09-21 09:30 | INTC | INTC261218C00110000 | call | 110.0000 | 2026-12-18 | 20.5000 | 19.8000 | 20.6000 | 118.5000 | 131175.00 | 116905.00 | 14270.00 | 64 | 10 | 71 | 9894 | 0.00717606630280978 | 0.685811644892439 | 0.691931288296273 | true | false | false | true | ||||||||||||||||
| 1bf9349c-7b54-4b9e-9dd5-0c6e12fe3f2c | 2026-09-08 12:24 | 2026-09-08 12:24 | 2026-09-08 12:24 | INTC | INTC261218C00110000 | call | 110.0000 | 2026-12-18 | 13.9500 | 13.9500 | 14.1500 | 105.0400 | 411525.00 | 0.00 | 397575.00 | 295 | 7 | 1102 | 9733 | 0.113223055584095 | 0.706245815576163 | 0.706245815576163 | false | false | false | true | ||||||||||||||||
| 78033ebf-6937-4a52-9fa6-1b4bc40f1f72 | 2026-09-04 13:44 | 2026-09-04 13:44 | 2026-09-04 13:44 | INTC | INTC261218C00110000 | call | 110.0000 | 2026-12-18 | 8.3500 | 8.2500 | 8.3500 | 94.6000 | 231293.00 | 231293.00 | 0.00 | 277 | 47 | 860 | 9659 | 0.0890361321047727 | 0.663010108808027 | 0.663010108808027 | true | false | false | true | ||||||||||||||||
| ca9ec97f-4f19-4174-a0b9-eeeb1d0db830 | 2026-09-03 11:30 | 2026-09-03 11:30 | 2026-09-03 11:30 | INTC | INTC261218C00110000 | call | 110.0000 | 2026-12-18 | 6.2000 | 6.1000 | 6.2000 | 90.6000 | 65100.00 | 65100.00 | 0.00 | 105 | 14 | 448 | 9216 | 0.0486111111111111 | 0.629243463902943 | 0.629243463902943 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 620412000000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:17:27.635758Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 618394400000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:31:43.812748Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 624749840000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:36:57.124687Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:20:26.028708Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 614258320000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:10:29.738922Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 601900520000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:00:39.945029Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 601900520000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T13:52:25.430758Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 601900520000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T13:30:27.578300Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 490226360000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:42:24.738421Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 490226360000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T18:01:17.201510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 490226360000.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |