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_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 |
|---|
| 0755f988-9693-408a-ae3d-c54f11f76ba1 | 2026-08-18 10:51 | 2026-08-18 10:51 | 2026-08-18 10:51 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 1.5100 | 1.5100 | 1.5600 | 58.3219 | 30200.00 | 0.00 | 30200.00 | 200 | 8 | 336 | 14783 | 0.0227288101197321 | 0.419373861081534 | 0.419373861081534 | 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-18T15:04:03.259366Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e48ee315-0b1f-4010-baba-3f9709a0d886 | 2026-08-20 11:01 | 2026-08-20 11:01 | 2026-08-20 11:01 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 3.2500 | 3.1500 | 3.3000 | 61.9899 | 20475.00 | 20475.00 | 0.00 | 63 | 11 | 1912 | 11202 | 0.170683806463132 | 0.45449552757999 | 0.45449552757999 | true | false | false | true | ||||||||||||||||
| 45c3dbde-a9f9-4eb1-bdab-8bb8057c37a1 | 2026-08-20 12:44 | 2026-08-20 12:44 | 2026-08-20 12:44 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 2.9800 | 2.9300 | 2.9800 | 61.5100 | 99192.00 | 99192.00 | 0.00 | 333 | 16 | 3129 | 11202 | 0.279325120514194 | 0.451695605356204 | 0.450249419386425 | false | false | false | true | ||||||||||||||||
| 1f0eef1a-e21c-4b12-aa2d-d9c388d8d67e | 2026-08-24 09:32 | 2026-08-24 09:31 | 2026-08-24 09:31 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 3.5000 | 3.5000 | 3.6000 | 62.8805 | 116900.00 | 0.00 | 116900.00 | 334 | 11 | 398 | 10603 | 0.0375365462604923 | 0.453358422524533 | 0.453358422524533 | false | false | false | true | ||||||||||||||||
| ce7bb7be-46eb-44db-9169-8a5f0ef25843 | 2026-08-24 13:13 | 2026-08-24 13:13 | 2026-08-24 13:13 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 3.1000 | 3.1000 | 3.2000 | 62.2250 | 335110.00 | 0.00 | 335110.00 | 1081 | 14 | 2322 | 10603 | 0.218994624162973 | 0.44846009678904 | 0.44846009678904 | false | false | false | true | ||||||||||||||||
| becfb5b1-a83a-4063-abd3-e72af30d891c | 2026-08-25 13:33 | 2026-08-25 13:32 | 2026-08-25 13:32 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 2.9000 | 2.8700 | 2.9300 | 62.1301 | 364530.00 | 2610.00 | 361920.00 | 1257 | 11 | 2156 | 11042 | 0.195254482883536 | 0.436038099776601 | 0.434753480555744 | false | false | false | true | ||||||||||||||||
| ae7313be-2b90-4ccb-a82d-ac4428c7c1b5 | 2026-08-27 10:41 | 2026-08-27 10:41 | 2026-08-27 10:41 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 2.7000 | 2.6500 | 2.7000 | 61.9500 | 102330.00 | 102330.00 | 0.00 | 379 | 10 | 3140 | 11893 | 0.264020852602371 | 0.437912495363247 | 0.437912495363247 | false | false | false | true | ||||||||||||||||
| 82f3508e-d4c1-417a-8541-2e3c39f48a3a | 2026-08-27 10:41 | 2026-08-27 10:41 | 2026-08-27 10:41 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 2.7000 | 2.6500 | 2.7000 | 61.9500 | 135000.00 | 135000.00 | 0.00 | 500 | 5 | 2761 | 11893 | 0.232153367527117 | 0.437912495363247 | 0.437912495363247 | false | false | false | true | ||||||||||||||||
| bb11f8bb-820d-45d3-894d-2616a9f334b0 | 2026-08-27 10:53 | 2026-08-27 10:53 | 2026-08-27 10:53 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 2.7400 | 2.7100 | 2.7400 | 62.0100 | 68500.00 | 68500.00 | 0.00 | 250 | 12 | 3687 | 11893 | 0.310014294122593 | 0.439279259587844 | 0.439279259587844 | false | false | false | true | ||||||||||||||||
| 3c8b096b-4427-4162-8b38-47ca7aa0c0b3 | 2026-08-28 12:38 | 2026-08-28 12:38 | 2026-08-28 12:38 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 1.7800 | 1.7800 | 1.8500 | 60.3701 | 12132.00 | 0.00 | 12132.00 | 68 | 7 | 3424 | 14311 | 0.239256515966739 | 0.419982489906156 | 0.419982489906156 | false | false | false | true | ||||||||||||||||
| 3e8e6039-6677-429c-824b-26b26ffc299f | 2026-08-28 15:02 | 2026-08-28 15:02 | 2026-08-28 15:02 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 1.6000 | 1.5700 | 1.6000 | 59.9100 | 124320.00 | 124320.00 | 0.00 | 777 | 7 | 5951 | 14311 | 0.415833973866257 | 0.421459160282837 | 0.421459160282837 | false | false | false | true | ||||||||||||||||
| 4508d1b7-d6db-4f58-9fdd-37b4e2f40258 | 2026-08-28 15:29 | 2026-08-28 15:29 | 2026-08-28 15:29 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 1.6600 | 1.6000 | 1.6600 | 60.0700 | 49634.00 | 49634.00 | 0.00 | 299 | 5 | 6266 | 14311 | 0.437845014324645 | 0.420747478301521 | 0.420747478301521 | false | false | false | true | ||||||||||||||||
| cd648626-249c-49e3-b583-868d822ec37d | 2026-08-31 12:58 | 2026-08-31 12:58 | 2026-08-31 12:58 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 1.4000 | 1.3700 | 1.4000 | 59.8700 | 70000.00 | 70000.00 | 0.00 | 500 | 11 | 2386 | 14724 | 0.162048356424885 | 0.420260463609489 | 0.420260463609489 | false | false | false | true | ||||||||||||||||
| 0461de6a-aa8d-4099-b3ae-34ff591182d5 | 2026-08-31 12:58 | 2026-08-31 12:58 | 2026-08-31 12:58 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 1.4000 | 1.3700 | 1.4000 | 59.8600 | 70000.00 | 70000.00 | 0.00 | 500 | 9 | 2886 | 14724 | 0.1960065199674 | 0.42100977600192 | 0.42100977600192 | false | false | false | true | ||||||||||||||||
| 28032177-3bc4-4832-93a3-88d750200650 | 2026-09-03 09:41 | 2026-09-03 09:41 | 2026-09-03 09:41 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 1.1700 | 1.1700 | 1.2300 | 59.7700 | 35100.00 | 0.00 | 35100.00 | 300 | 16 | 380 | 15126 | 0.0251223059632421 | 0.419532839831692 | 0.419532839831692 | false | false | false | true | ||||||||||||||||
| 7ed26f0e-8d9e-47a3-b3af-003661bd5ed3 | 2026-09-03 13:56 | 2026-09-03 13:56 | 2026-09-03 13:56 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 1.5600 | 1.5400 | 1.6000 | 60.6200 | 124020.00 | 122460.00 | 1560.00 | 795 | 6 | 1677 | 15126 | 0.110868702895676 | 0.4321666045886 | 0.4321666045886 | false | false | false | true | ||||||||||||||||
| 885d6075-3e59-409b-80de-361c2fef44e8 | 2026-09-11 10:19 | 2026-09-11 10:19 | 2026-09-11 10:19 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 0.3900 | 0.3900 | 0.4000 | 58.5650 | 27690.00 | 0.00 | 27690.00 | 710 | 31 | 1114 | 15092 | 0.0738139411608799 | 0.456690419928926 | 0.456690419928926 | false | false | false | true | ||||||||||||||||
| 78a10a8f-a5d1-486a-a3d3-e3ebc982a8b6 | 2026-09-11 10:19 | 2026-09-11 10:19 | 2026-09-11 10:19 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 0.3900 | 0.3900 | 0.4000 | 58.5500 | 76362.00 | 0.00 | 76362.00 | 1958 | 19 | 3072 | 15092 | 0.203551550490326 | 0.457999521751281 | 0.457999521751281 | false | false | false | true | ||||||||||||||||
| 466cc58e-ba2b-472a-ae4e-0f8e24cdbf27 | 2026-09-11 10:22 | 2026-09-11 10:22 | 2026-09-11 10:22 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 0.3900 | 0.3900 | 0.4000 | 58.6450 | 26871.00 | 0.00 | 26871.00 | 689 | 11 | 4096 | 15092 | 0.271402067320435 | 0.44969678706873 | 0.44969678706873 | false | false | false | true | ||||||||||||||||
| 90f07859-70c7-4729-b766-cf03ef59c9aa | 2026-09-11 15:10 | 2026-09-11 15:10 | 2026-09-11 15:10 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 0.2300 | 0.2300 | 0.2400 | 58.0901 | 11500.00 | 0.00 | 11500.00 | 500 | 14 | 5748 | 15092 | 0.380864033925258 | 0.415058945730547 | 0.41660985995077 | false | false | false | true | ||||||||||||||||
| a4cad44a-0a27-401b-8302-1c6721858b02 | 2026-09-15 13:42 | 2026-09-15 13:42 | 2026-09-15 13:42 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 0.1400 | 0.1300 | 0.1500 | 57.2600 | 14000.00 | 13972.00 | 0.00 | 1000 | 12 | 3386 | 17985 | 0.188268001112038 | 0.643802301654823 | 0.643802301654823 | false | false | false | true | ||||||||||||||||
| 0bca71ba-6084-4b4e-9d20-9cdf3f2e1f58 | 2026-09-15 14:15 | 2026-09-15 14:15 | 2026-09-15 14:15 | SLV | SLV260918C00062000 | call | 62.0000 | 2026-09-18 | 0.1400 | 0.1300 | 0.1400 | 57.5388 | 10906.00 | 10906.00 | 0.00 | 779 | 10 | 4575 | 17985 | 0.254378648874062 | 0.613796010145193 | 0.613796010145193 | 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"} |
| 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-24T13:38:06.174043Z"} |
| 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-24T17:17:38.633077Z"} |
| 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-25T17:59:30.582778Z"} |
| 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-27T14:49:52.356548Z"} |
| 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-27T14:49:52.356548Z"} |
| 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-27T15:06:04.251678Z"} |
| 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-28T16:48:38.038469Z"} |
| 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-28T19:10:32.565799Z"} |
| 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-28T19:36:54.231390Z"} |
| 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-31T17:08:52.274087Z"} |
| 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-31T17:08:52.274087Z"} |
| 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-03T13:45:03.310585Z"} |
| 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-03T18:16:35.526734Z"} |
| 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-11T14:26:53.669819Z"} |
| 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-11T14:26:53.669819Z"} |
| 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-11T14:26:53.669819Z"} |
| 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-11T19:33:39.972411Z"} |
| 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-15T17:45:33.615815Z"} |
| 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-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |