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 | 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 |
|---|
| c6c9b06e-e3f5-4a59-b350-a80899c1e84c | 2026-08-19 13:36 | 2026-08-19 13:36 | 2026-08-19 13:36 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 2.9500 | 2.9500 | 3.0500 | 59.3350 | 12981.00 | 296.00 | 12685.00 | 44 | 19 | 294 | 37631 | 0.00781270760808908 | 0.489635282299897 | 0.490400438346596 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 38529495748.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b5e75689-701d-4724-a7ff-90e57ce70eb7 | 2026-08-20 10:59 | 2026-08-20 10:59 | 2026-08-20 10:59 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 3.7500 | 3.6500 | 3.7500 | 61.7200 | 22500.00 | 22500.00 | 0.00 | 60 | 6 | 299 | 37883 | 0.00789272232927698 | 0.494543324771943 | 0.494543324771943 | false | false | false | true | ||||||||||||||||
| 78666f4d-d362-46f8-a2d0-86177901712c | 2026-08-21 12:44 | 2026-08-21 12:44 | 2026-08-21 12:44 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 4.2000 | 4.2000 | 4.3000 | 63.0300 | 168001.00 | 0.00 | 168001.00 | 400 | 7 | 854 | 37730 | 0.0226345083487941 | 0.495527358604877 | 0.496192392854657 | false | false | false | true | ||||||||||||||||
| ff6cf5ee-7001-49a0-9d86-620e79e4689b | 2026-08-21 13:38 | 2026-08-21 13:38 | 2026-08-21 13:38 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 4.2400 | 4.1500 | 4.2500 | 62.9550 | 127250.00 | 127250.00 | 0.00 | 300 | 14 | 1379 | 37730 | 0.0365491651205937 | 0.50067687992647 | 0.500011550622353 | false | false | false | true | ||||||||||||||||
| b16538a1-c1a6-40dd-988f-c6bfbc775b75 | 2026-08-26 09:47 | 2026-08-26 09:47 | 2026-08-26 09:47 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 3.8000 | 3.7000 | 3.8000 | 61.8400 | 11400.00 | 11400.00 | 0.00 | 30 | 5 | 47 | 38207 | 0.00123014107362525 | 0.506264509200959 | 0.506264509200959 | false | false | false | true | ||||||||||||||||
| 5d848fc2-b303-4ca9-a0c2-9aaa1465c914 | 2026-08-27 15:14 | 2026-08-27 15:14 | 2026-08-27 15:14 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 4.0500 | 4.0500 | 4.1500 | 62.0000 | 12150.00 | 0.00 | 12150.00 | 30 | 5 | 344 | 38206 | 0.00900382138931058 | 0.502958953272232 | 0.502958953272232 | false | false | false | true | ||||||||||||||||
| cb6180c2-3afe-4fbb-9690-d6f897934ec4 | 2026-08-28 14:42 | 2026-08-28 14:42 | 2026-08-28 14:42 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 3.0000 | 3.0000 | 3.1000 | 59.7600 | 15600.00 | 0.00 | 15600.00 | 52 | 5 | 1598 | 38256 | 0.0417712254286909 | 0.500243756664948 | 0.50029255791765 | false | false | false | true | ||||||||||||||||
| 141f6a05-b62f-4eb7-9e66-3a4984e55ab8 | 2026-08-31 15:57 | 2026-08-31 15:57 | 2026-08-31 15:57 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 2.9400 | 2.8800 | 2.9400 | 60.1150 | 29400.00 | 29400.00 | 0.00 | 100 | 8 | 440 | 38286 | 0.011492451548869 | 0.494545444415214 | 0.494545444415214 | false | false | false | true | ||||||||||||||||
| ab56f1d0-a2d6-469e-a916-45edb82d23f4 | 2026-09-03 11:35 | 2026-09-03 11:35 | 2026-09-03 11:35 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 3.3000 | 3.2000 | 3.3000 | 60.7700 | 13198.00 | 13198.00 | 0.00 | 40 | 5 | 103 | 38704 | 0.00266122364613477 | 0.511064920301664 | 0.509538360168511 | false | false | false | true | ||||||||||||||||
| 552e0401-dcaf-47e2-a18b-a58241405c81 | 2026-09-03 15:59 | 2026-09-03 15:59 | 2026-09-03 15:59 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 3.3000 | 3.2000 | 3.3000 | 60.5350 | 66000.00 | 66000.00 | 0.00 | 200 | 15 | 779 | 38704 | 0.0201271186440678 | 0.516745061409753 | 0.516745061409753 | false | false | false | true | ||||||||||||||||
| 9f819280-4735-4b8f-a5d9-f4ea63d74ddc | 2026-09-09 09:39 | 2026-09-09 09:39 | 2026-09-09 09:39 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 3.2000 | 3.1000 | 3.2000 | 61.0400 | 64000.00 | 64000.00 | 0.00 | 200 | 6 | 306 | 37891 | 0.00807579636325249 | 0.509280573704832 | 0.509280573704832 | false | false | false | true | ||||||||||||||||
| d8eb681c-bd1f-49c0-a5a8-4494b1ceecc0 | 2026-09-10 15:02 | 2026-09-10 15:02 | 2026-09-10 15:02 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 2.1500 | 2.0800 | 2.1900 | 57.4600 | 10750.00 | 2150.00 | 8600.00 | 50 | 5 | 578 | 38136 | 0.0151562827774282 | 0.506098584261197 | 0.506786382486493 | false | false | false | true | ||||||||||||||||
| 8b8c0ba7-08e9-4abf-99ed-38f64b697455 | 2026-09-15 14:30 | 2026-09-15 14:30 | 2026-09-15 14:30 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 2.0000 | 1.9700 | 2.0100 | 57.5899 | 80000.00 | 27600.00 | 52400.00 | 400 | 8 | 525 | 38444 | 0.0136562272396213 | 0.499504288771193 | 0.499504288771193 | false | false | false | true | ||||||||||||||||
| d6255448-9812-408e-85db-66ea54f1c71e | 2026-09-21 11:46 | 2026-09-21 11:46 | 2026-09-21 11:46 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 1.9000 | 1.8800 | 1.9000 | 59.7400 | 38000.00 | 37240.00 | 0.00 | 200 | 13 | 254 | 38892 | 0.00653090609894066 | 0.453145295448627 | 0.453145295448627 | true | false | false | true | ||||||||||||||||
| 1bc84efb-a838-46be-b62b-a7fac4c27d23 | 2026-09-23 15:58 | 2026-09-23 15:58 | 2026-09-23 15:58 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 1.4300 | 1.4300 | 1.4800 | 58.0000 | 107250.00 | 0.00 | 107250.00 | 750 | 9 | 848 | 38960 | 0.0217659137577002 | 0.445043970704865 | 0.445043970704865 | false | false | false | true | ||||||||||||||||
| af822fd9-6c6d-4ece-971b-f8207cebfd48 | 2026-09-25 15:40 | 2026-09-25 15:40 | 2026-09-25 15:40 | SLV | SLV270115C00075000 | call | 75.0000 | 2027-01-15 | 1.1800 | 1.1800 | 1.2100 | 58.0000 | 70800.00 | 0.00 | 70800.00 | 600 | 35 | 800 | 38645 | 0.0207012550135852 | 0.418272802479341 | 0.418272802479341 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:02:58.462752Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T18:46:22.896033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| 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 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:46:31.810255Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:42:39.046957Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:49:21.879731Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:44:21.808017Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |