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.
Simplify Analyticsuw_flow_alerts474,253 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 |
|---|
| 4b4f560f-3099-46b8-aeb8-98ce286fa012 | 2026-08-19 09:53 | 2026-08-19 09:52 | 2026-08-19 09:52 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 0.6200 | 0.6100 | 0.6200 | 14.5599 | 66960.00 | 66960.00 | 0.00 | 1080 | 36 | 1095 | 36465 | 0.0300287947346771 | 0.484549421770028 | 0.484549421770028 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 6944643005.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3ede0340-477e-4004-99ad-c99dea02a44c | 2026-08-19 09:53 | 2026-08-19 09:52 | 2026-08-19 09:52 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 0.6200 | 0.6100 | 0.6300 | 14.5599 | 68200.00 | 40238.00 | 14880.00 | 1100 | 15 | 4143 | 36465 | 0.113615795968737 | 0.484549421770028 | 0.484549421770028 | false | false | false | true | ||||||||||||||||
| 1a1fc945-00bd-4cad-9e15-a80f541dd811 | 2026-08-19 09:53 | 2026-08-19 09:52 | 2026-08-19 09:52 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 0.6200 | 0.6100 | 0.6200 | 14.5599 | 52762.00 | 52762.00 | 0.00 | 851 | 14 | 3043 | 36465 | 0.0834498834498835 | 0.484549421770028 | 0.484549421770028 | false | false | false | true | ||||||||||||||||
| 1875e372-8020-4412-b3b5-8363cddf64df | 2026-08-19 09:53 | 2026-08-19 09:52 | 2026-08-19 09:52 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 0.6200 | 0.6100 | 0.6200 | 14.5599 | 68014.00 | 68014.00 | 0.00 | 1097 | 6 | 2192 | 36465 | 0.0601124365830248 | 0.484549421770028 | 0.484549421770028 | false | false | false | true | ||||||||||||||||
| 173f0c61-811e-4e01-9230-d04bbc87da0c | 2026-08-19 09:53 | 2026-08-19 09:53 | 2026-08-19 09:53 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 0.6200 | 0.6200 | 0.6300 | 14.5550 | 10540.00 | 0.00 | 10540.00 | 170 | 6 | 4337 | 36465 | 0.11893596599479 | 0.485360707925387 | 0.485360707925387 | false | false | false | true | ||||||||||||||||
| efd6341a-724e-4216-b0ee-a457e9473eb2 | 2026-08-19 09:54 | 2026-08-19 09:54 | 2026-08-19 09:54 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 0.6300 | 0.6100 | 0.6300 | 14.5600 | 42777.00 | 42777.00 | 0.00 | 679 | 42 | 5016 | 36465 | 0.137556561085973 | 0.489136909390244 | 0.489136909390244 | false | false | false | true | ||||||||||||||||
| 348990e2-407d-434f-9e92-195b26d66429 | 2026-08-19 13:43 | 2026-08-19 13:43 | 2026-08-19 13:43 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 1.2000 | 1.1800 | 1.2000 | 15.7499 | 24000.00 | 24000.00 | 0.00 | 200 | 6 | 8160 | 36465 | 0.223776223776224 | 0.507514188861694 | 0.507514188861694 | false | false | false | true | ||||||||||||||||
| ce9f5c7d-cc95-4eeb-a29b-8bb77d80929b | 2026-08-20 09:40 | 2026-08-20 09:40 | 2026-08-20 09:40 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 2.0500 | 2.0400 | 2.0500 | 17.0650 | 71955.00 | 71955.00 | 0.00 | 351 | 8 | 856 | 42049 | 0.0203572023115889 | 0.537583703997055 | 0.537583703997055 | false | false | false | true | ||||||||||||||||
| 6c1ae4cf-5ea2-4638-a5ba-14a635b55827 | 2026-08-20 09:40 | 2026-08-20 09:40 | 2026-08-20 09:40 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 2.0500 | 2.0400 | 2.0500 | 17.0650 | 126280.00 | 126280.00 | 0.00 | 616 | 8 | 1472 | 42049 | 0.0350067778068444 | 0.537583703997055 | 0.537583703997055 | false | false | false | true | ||||||||||||||||
| 6b4ac9c1-cbb9-4506-a28d-de0a3c79d6d9 | 2026-08-20 09:40 | 2026-08-20 09:40 | 2026-08-20 09:40 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 2.0500 | 2.0400 | 2.0500 | 17.0750 | 196595.00 | 196595.00 | 0.00 | 959 | 15 | 2442 | 42049 | 0.0580751028561916 | 0.534842143024765 | 0.534842143024765 | false | false | false | true | ||||||||||||||||
| 354148da-b51d-45bd-8b9b-15245c9de4ae | 2026-08-20 09:41 | 2026-08-20 09:41 | 2026-08-20 09:41 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 2.0500 | 2.0400 | 2.0700 | 17.0901 | 441365.00 | 171995.00 | 84255.00 | 2153 | 28 | 5647 | 42049 | 0.134295702632643 | 0.530685192457196 | 0.530685192457196 | true | false | false | true | ||||||||||||||||
| 76255ff0-286b-433f-8d4c-5c6fda00a6fd | 2026-08-20 12:18 | 2026-08-20 12:18 | 2026-08-20 12:18 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 2.4100 | 2.4000 | 2.4400 | 17.5000 | 1204759.00 | 250640.00 | 954119.00 | 4999 | 29 | 16499 | 42049 | 0.392375561844515 | 0.562737122896705 | 0.562737122896705 | true | false | false | true | ||||||||||||||||
| 7c6579aa-4f14-4454-a08e-af92434d1551 | 2026-08-21 09:35 | 2026-08-21 09:35 | 2026-08-21 09:35 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 2.7000 | 2.6800 | 2.7000 | 17.9150 | 1349730.00 | 797580.00 | 0.00 | 4999 | 14 | 5017 | 26783 | 0.187320315125266 | 0.563835693572721 | 0.563835693572721 | false | false | false | true | ||||||||||||||||
| 4bea77f0-6e34-4bbe-be72-4b23db1bdf19 | 2026-08-21 09:54 | 2026-08-21 09:54 | 2026-08-21 09:54 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 2.8500 | 2.8500 | 2.9400 | 18.0490 | 63556.00 | 0.00 | 63556.00 | 223 | 19 | 5286 | 26783 | 0.197363999551955 | 0.586026705508746 | 0.586026705508746 | true | false | false | true | ||||||||||||||||
| 3c95f011-247c-4757-adce-4df6ac21290a | 2026-08-21 14:44 | 2026-08-21 14:44 | 2026-08-21 14:44 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 2.9000 | 2.9000 | 2.9500 | 18.1800 | 14494.00 | 0.00 | 12174.00 | 50 | 7 | 10468 | 26783 | 0.390844938953814 | 0.564123404885367 | 0.564123404885367 | false | false | false | true | ||||||||||||||||
| ab6542fc-3b83-4c67-938a-29b3be2c763b | 2026-08-21 14:57 | 2026-08-21 14:57 | 2026-08-21 14:57 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 2.9600 | 2.9200 | 2.9600 | 18.2250 | 23680.00 | 23680.00 | 0.00 | 80 | 13 | 10588 | 26783 | 0.395325392973155 | 0.575781395041801 | 0.575781395041801 | false | false | false | true | ||||||||||||||||
| 71dddf9f-9022-4eb6-aa9b-4585d51d43e3 | 2026-08-26 12:51 | 2026-08-26 12:51 | 2026-08-26 12:51 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 3.0900 | 3.0000 | 3.1500 | 18.4950 | 37040.00 | 37040.00 | 0.00 | 120 | 8 | 616 | 21670 | 0.0284263959390863 | 0.561951437430735 | 0.561951437430735 | false | false | false | true | ||||||||||||||||
| 7f98f60a-cab8-4bc0-bc0e-27bd44abb8eb | 2026-08-28 10:15 | 2026-08-28 10:15 | 2026-08-28 10:15 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 3.1000 | 3.1000 | 3.3000 | 18.6605 | 37200.00 | 0.00 | 37200.00 | 120 | 8 | 393 | 19352 | 0.0203079785035138 | 0.512842878150753 | 0.512842878150753 | false | false | false | true | ||||||||||||||||
| 39d3291c-d8b8-447f-8cb5-59ef2c4739c3 | 2026-08-28 11:52 | 2026-08-28 11:52 | 2026-08-28 11:52 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 3.1500 | 3.1500 | 3.3000 | 18.0000 | 42525.00 | 0.00 | 42525.00 | 135 | 9 | 695 | 19352 | 0.0359136006614303 | 0.513249561333511 | 0.513249561333511 | false | false | false | true | ||||||||||||||||
| 33bece51-13a9-4fa0-9620-efbc770b2c68 | 2026-09-01 15:49 | 2026-09-01 15:49 | 2026-09-01 15:49 | ETHA | ETHA261016C00016000 | call | 16.0000 | 2026-10-16 | 2.7000 | 2.6400 | 2.7500 | 18.2200 | 108056.00 | 17550.00 | 90506.00 | 400 | 22 | 479 | 19122 | 0.0250496809957117 | 0.513381200415558 | 0.513381200415558 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 6944643005.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T13:31:29.863287Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |