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_alerts375,978 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 |
|---|
| eb818a1c-31ce-4945-85ef-e3b746b2d91e | 2026-08-18 10:58 | 2026-08-18 10:57 | 2026-08-18 10:57 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 1.6400 | 1.6300 | 1.6800 | 58.0582 | 12263.00 | 0.00 | 12263.00 | 75 | 5 | 267 | 2252 | 0.118561278863233 | 0.403438560455809 | 0.403438560455809 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 38529495748.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d71bd542-a859-4287-915f-a7904aa867b1 | 2026-09-01 09:49 | 2026-09-01 09:49 | 2026-09-01 09:49 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 1.0500 | 0.9900 | 1.0500 | 58.5000 | 10500.00 | 10500.00 | 0.00 | 100 | 10 | 622 | 2560 | 0.24296875 | 0.42754885577403 | 0.42754885577403 | false | false | false | true | ||||||||||||||||
| dd6691d2-f00e-40b6-80a3-dd1740d701ec | 2026-09-01 11:16 | 2026-09-01 11:16 | 2026-09-01 11:16 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 0.9700 | 0.9500 | 0.9700 | 58.4950 | 48500.00 | 48500.00 | 0.00 | 500 | 8 | 2699 | 2560 | 1.054296875 | 0.406274363462218 | 0.406274363462218 | false | false | false | true | ||||||||||||||||
| 3006ef9a-27df-45c2-b9a3-9f54427157cd | 2026-09-01 11:16 | 2026-09-01 11:16 | 2026-09-01 11:16 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 0.9700 | 0.9500 | 0.9700 | 58.4950 | 48500.00 | 48500.00 | 0.00 | 500 | 36 | 3199 | 2560 | 1.249609375 | 0.406274363462218 | 0.406274363462218 | false | false | false | true | ||||||||||||||||
| 2dad07d1-e528-442a-aebf-d375340357ce | 2026-09-01 11:16 | 2026-09-01 11:16 | 2026-09-01 11:16 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 0.9700 | 0.9500 | 0.9700 | 58.4950 | 48500.00 | 48500.00 | 0.00 | 500 | 6 | 2199 | 2560 | 0.858984375 | 0.406274363462218 | 0.406274363462218 | false | false | false | true | ||||||||||||||||
| 9777486a-08f4-4138-a4ff-3d5de5167cee | 2026-09-01 12:30 | 2026-09-01 12:30 | 2026-09-01 12:30 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 1.0000 | 0.9800 | 1.0000 | 58.6400 | 50000.00 | 40100.00 | 0.00 | 500 | 7 | 4801 | 2560 | 1.875390625 | 0.399575915985407 | 0.399575915985407 | false | false | false | true | ||||||||||||||||
| 299b4e4e-44fa-4d42-bd39-cb3a83b67837 | 2026-09-01 12:30 | 2026-09-01 12:30 | 2026-09-01 12:30 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 1.0000 | 0.9800 | 1.0300 | 58.6400 | 50000.00 | 0.00 | 50000.00 | 500 | 6 | 4301 | 2560 | 1.680078125 | 0.399575915985407 | 0.399575915985407 | false | false | false | true | ||||||||||||||||
| dce89de6-2abd-44c5-9857-991d106679db | 2026-09-01 14:31 | 2026-09-01 14:30 | 2026-09-01 14:30 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 0.8600 | 0.8500 | 0.8600 | 58.2000 | 14190.00 | 14190.00 | 0.00 | 165 | 5 | 6226 | 2560 | 2.43203125 | 0.40495992497701 | 0.40495992497701 | false | false | false | true | ||||||||||||||||
| f3815070-9469-437e-9a88-b58c570609a2 | 2026-09-01 14:31 | 2026-09-01 14:30 | 2026-09-01 14:30 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 0.8600 | 0.8400 | 0.8600 | 58.1900 | 15222.00 | 15222.00 | 0.00 | 177 | 13 | 7142 | 2560 | 2.78984375 | 0.405927296927574 | 0.405927296927574 | false | false | false | true | ||||||||||||||||
| c65f9f2b-5616-4eb3-8693-2aa2930123dc | 2026-09-03 11:15 | 2026-09-03 11:15 | 2026-09-03 11:15 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 1.9900 | 1.9000 | 1.9900 | 60.8650 | 13333.00 | 13333.00 | 0.00 | 67 | 5 | 1168 | 10068 | 0.11601112435439 | 0.417065690304455 | 0.417065690304455 | false | false | false | true | ||||||||||||||||
| 94e99a78-48a7-44dc-b110-ca89e4e10110 | 2026-09-03 11:31 | 2026-09-03 11:30 | 2026-09-03 11:30 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 2.0200 | 1.9900 | 2.0300 | 60.9450 | 309868.00 | 1010.00 | 307848.00 | 1534 | 12 | 3059 | 10068 | 0.30383392928089 | 0.411536085715567 | 0.411536085715567 | false | false | false | true | ||||||||||||||||
| ae3cb7b2-0c78-4175-9a44-597191c9826d | 2026-09-08 15:27 | 2026-09-08 15:27 | 2026-09-08 15:27 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 0.7800 | 0.7800 | 0.8000 | 59.5850 | 20597.00 | 0.00 | 20202.00 | 264 | 5 | 2648 | 11315 | 0.234025629695095 | 0.451136135349637 | 0.446448487383974 | false | false | false | true | ||||||||||||||||
| a2a39a64-2a2b-49cc-9ed6-5ab8e6e127e8 | 2026-09-08 15:27 | 2026-09-08 15:27 | 2026-09-08 15:27 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 0.7800 | 0.7800 | 0.7900 | 59.5850 | 15288.00 | 0.00 | 15288.00 | 196 | 7 | 2844 | 11315 | 0.251347768448962 | 0.446448487383974 | 0.446448487383974 | false | false | false | true | ||||||||||||||||
| 7f36f11a-bc99-45d0-8e34-705e51956fdc | 2026-09-08 15:29 | 2026-09-08 15:29 | 2026-09-08 15:29 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 0.7800 | 0.7800 | 0.8000 | 59.5900 | 13338.00 | 0.00 | 13338.00 | 171 | 5 | 3666 | 11315 | 0.323994697304463 | 0.445409620121486 | 0.445409620121486 | false | false | false | true | ||||||||||||||||
| 0acfad85-18bf-4eea-bacc-60e9149a415c | 2026-09-08 15:29 | 2026-09-08 15:29 | 2026-09-08 15:29 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 0.7800 | 0.7800 | 0.8000 | 59.5900 | 25194.00 | 0.00 | 25194.00 | 323 | 6 | 3989 | 11315 | 0.352540874944764 | 0.445409620121486 | 0.445409620121486 | false | false | false | true | ||||||||||||||||
| 7f99d8cc-b03d-4a3b-9661-9acadb40a202 | 2026-09-08 15:29 | 2026-09-08 15:29 | 2026-09-08 15:29 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 0.7800 | 0.7700 | 0.7900 | 59.6050 | 18954.00 | 0.00 | 18876.00 | 243 | 6 | 4232 | 11315 | 0.3740167918692 | 0.442285795804217 | 0.442285795804217 | false | false | false | true | ||||||||||||||||
| e5f0d637-1224-4b63-8f31-9e00bb20acca | 2026-09-09 09:42 | 2026-09-09 09:42 | 2026-09-09 09:42 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 1.3600 | 1.3600 | 1.4400 | 60.7899 | 10881.00 | 0.00 | 10744.00 | 80 | 8 | 253 | 10663 | 0.0237269061239801 | 0.506170291202784 | 0.506170291202784 | false | false | false | true | ||||||||||||||||
| 56ed84e2-6dd0-4ef6-a448-c91db76fa06d | 2026-09-09 11:01 | 2026-09-09 11:00 | 2026-09-09 11:00 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 2.0500 | 2.0500 | 2.1100 | 61.6900 | 51865.00 | 0.00 | 51865.00 | 253 | 9 | 3063 | 10663 | 0.287254993904155 | 0.540113616284687 | 0.540113616284687 | false | false | false | true | ||||||||||||||||
| a43ee4d4-480c-4101-bb90-ff6280e074bf | 2026-09-10 09:50 | 2026-09-10 09:50 | 2026-09-10 09:50 | SLV | SLV260911C00060000 | call | 60.0000 | 2026-09-11 | 0.3500 | 0.3500 | 0.3600 | 58.6300 | 17500.00 | 0.00 | 17500.00 | 500 | 42 | 1554 | 7951 | 0.19544711357062 | 0.699660232955283 | 0.699660232955283 | true | 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-09-01T14:00:27.391289Z"} |
| 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-01T15:18:08.991662Z"} |
| 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-01T15:18:08.991662Z"} |
| 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-01T15:18:08.991662Z"} |
| 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-01T16:48:42.201804Z"} |
| 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-01T16:48:42.201804Z"} |
| 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-01T18:40:09.958238Z"} |
| 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-01T18:40:09.958238Z"} |
| 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:27:44.291947Z"} |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:30:09.198364Z"} |
| 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-08T19:30:09.198364Z"} |
| 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-08T19:30:09.198364Z"} |
| 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-08T19:30:09.198364Z"} |
| 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-08T19:30:09.198364Z"} |
| 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-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 |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:52:43.061304Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |