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_alerts566,287 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 | expirydate |
|---|
| 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 |
|---|
| d80fa8e6-0cc9-4d44-8951-5d637bb732a9 | 2026-09-17 10:59 | 2026-09-17 10:59 | 2026-09-17 10:59 | SLV | SLV260918C00061000 | call | 61.0000 | 2026-09-18 | 0.1200 | 0.1200 | 0.1300 | 59.1700 | 15516.00 | 0.00 | 15516.00 | 1293 | 18 | 3169 | 6542 | 0.48440843778661 | 0.536191336083724 | 0.536191336083724 | 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-09-17T15:02:25.509626Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 0a3dbc45-f982-4d74-b7a8-c6e63a8b53b5 | 2026-09-16 14:45 | 2026-09-16 14:45 | 2026-09-16 14:45 | SLV | SLV260918C00061000 | call | 61.0000 | 2026-09-18 | 0.1600 | 0.1400 | 0.1600 | 57.8700 | 16000.00 | 16000.00 | 0.00 | 1000 | 5 | 3471 | 6283 | 0.552443100429731 | 0.607021534590648 | 0.607021534590648 | false | false | false | true | false | |||||||||||||||
| 8166898b-6a25-42ee-8a60-ba2c6d438066 | 2026-09-16 13:12 | 2026-09-16 13:12 | 2026-09-16 13:12 | SLV | SLV260918C00061000 | call | 61.0000 | 2026-09-18 | 0.2100 | 0.2100 | 0.2200 | 58.1100 | 10500.00 | 0.00 | 10500.00 | 500 | 18 | 1255 | 6283 | 0.199745344580614 | 0.624354249559292 | 0.624354249559292 | false | false | false | true | false | |||||||||||||||
| 3fcff485-127d-466c-af9e-da8cab740f13 | 2026-09-15 10:26 | 2026-09-15 10:26 | 2026-09-15 10:26 | SLV | SLV260918C00061000 | call | 61.0000 | 2026-09-18 | 0.2200 | 0.2100 | 0.2200 | 57.3100 | 10934.00 | 10934.00 | 0.00 | 497 | 21 | 1781 | 5162 | 0.345021309569934 | 0.614809161912645 | 0.614809161912645 | false | false | false | true | false | |||||||||||||||
| 222a5a04-e519-4f7e-a4b2-d0f3ea66f220 | 2026-09-15 10:26 | 2026-09-15 10:26 | 2026-09-15 10:26 | SLV | SLV260918C00061000 | call | 61.0000 | 2026-09-18 | 0.2200 | 0.2100 | 0.2200 | 57.2900 | 11000.00 | 11000.00 | 0.00 | 500 | 24 | 1281 | 5162 | 0.248159628051143 | 0.617222949738527 | 0.617222949738527 | false | false | false | true | false | |||||||||||||||
| b3ef6356-1ef9-4b07-b7d3-73d35940b76d | 2026-09-15 09:41 | 2026-09-15 09:41 | 2026-09-15 09:41 | SLV | SLV260918C00061000 | call | 61.0000 | 2026-09-18 | 0.2200 | 0.2100 | 0.2200 | 57.4850 | 11000.00 | 11000.00 | 0.00 | 500 | 15 | 716 | 5162 | 0.138705927934909 | 0.59362965896833 | 0.59362965896833 | false | false | false | true | false | |||||||||||||||
| 244fa783-d271-482a-aa46-57b1cd5d0801 | 2026-09-10 09:35 | 2026-09-10 09:35 | 2026-09-10 09:35 | SLV | SLV260918C00061000 | call | 61.0000 | 2026-09-18 | 0.7700 | 0.7600 | 0.7800 | 58.3950 | 15450.00 | 4439.00 | 0.00 | 200 | 6 | 254 | 3995 | 0.0635794743429287 | 0.499593211746964 | 0.50294730894718 | false | false | false | true | false | |||||||||||||||
| daa05278-812c-4db6-92c0-2450ed06892c | 2026-09-08 15:56 | 2026-09-08 15:56 | 2026-09-08 15:56 | SLV | SLV260918C00061000 | call | 61.0000 | 2026-09-18 | 1.0000 | 1.0000 | 1.0500 | 59.4000 | 20000.00 | 0.00 | 20000.00 | 200 | 5 | 599 | 3878 | 0.154461062403301 | 0.416946419633794 | 0.416946419633794 | false | false | false | true | false | |||||||||||||||
| 547701e2-50b3-4f47-b911-a7e17d0afb5b | 2026-09-03 12:34 | 2026-09-03 12:34 | 2026-09-03 12:34 | SLV | SLV260918C00061000 | call | 61.0000 | 2026-09-18 | 1.9400 | 1.9400 | 1.9700 | 60.6050 | 17460.00 | 0.00 | 17460.00 | 90 | 6 | 2164 | 3364 | 0.643281807372176 | 0.424704150510489 | 0.424704150510489 | true | false | false | true | false | |||||||||||||||
| 029bd695-b359-4075-9d3e-5c3d0eb1e4d1 | 2026-09-03 11:57 | 2026-09-03 11:56 | 2026-09-03 11:56 | SLV | SLV260918C00061000 | call | 61.0000 | 2026-09-18 | 1.9200 | 1.9100 | 1.9400 | 60.5650 | 19392.00 | 2496.00 | 16896.00 | 101 | 5 | 1941 | 3364 | 0.576991676575505 | 0.424645628927393 | 0.424645628927393 | false | false | false | true | false | |||||||||||||||
| 0da0787b-9b44-4a69-8650-907b009e95a2 | 2026-09-03 09:46 | 2026-09-03 09:46 | 2026-09-03 09:46 | SLV | SLV260918C00061000 | call | 61.0000 | 2026-09-18 | 1.5000 | 1.4500 | 1.5600 | 59.7600 | 30000.00 | 0.00 | 30000.00 | 200 | 8 | 613 | 3364 | 0.182223543400713 | 0.414272617098354 | 0.414272617098354 | false | false | false | true | false | |||||||||||||||
| 7bca20be-f47c-4115-9c59-272a6ea372d2 | 2026-08-20 10:12 | 2026-08-20 10:12 | 2026-08-20 10:12 | SLV | SLV260918C00061000 | call | 61.0000 | 2026-09-18 | 3.1500 | 3.0500 | 3.1500 | 60.9950 | 31495.00 | 31495.00 | 0.00 | 100 | 6 | 561 | 3143 | 0.178491886732421 | 0.439829727700683 | 0.447146374075921 | false | false | false | true | false | |||||||||||||||
| e8d1a213-dddc-4c02-9c82-006fe2e86f75 | 2026-08-17 10:49 | 2026-08-17 10:49 | 2026-08-17 10:49 | SLV | SLV260918C00061000 | call | 61.0000 | 2026-09-18 | 2.6000 | 2.5400 | 2.6000 | 59.8299 | 10400.00 | 10400.00 | 0.00 | 40 | 5 | 467 | 2382 | 0.196053736356003 | 0.429674386038235 | 0.429674386038235 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:36:37.058930Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:36:37.058930Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:42:34.192825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:30:57.501605Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} |
| 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-03T16:03:37.205690Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |