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 |
|---|
| c982b553-b319-4643-abb3-0d5bdcca6056 | 2026-09-21 13:07 | 2026-09-21 13:07 | 2026-09-21 13:07 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 0.4200 | 0.4200 | 0.4300 | 62.6650 | 22134.00 | 0.00 | 22134.00 | 527 | 9 | 838 | 22648 | 0.0370010596962204 | 0.262705304705471 | 0.262705304705471 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 41312140321.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:12:05.796133Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| d7784d4c-83df-49ef-a57c-8241e8b1b3a7 | 2026-09-18 15:53 | 2026-09-18 15:53 | 2026-09-18 15:53 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 0.8400 | 0.8400 | 0.8500 | 64.0000 | 19068.00 | 0.00 | 19068.00 | 227 | 12 | 430 | 22131 | 0.0194297591613574 | 0.250509857316664 | 0.250509857316664 | false | false | false | true | ||||||||||||||||
| a266a097-c176-4e23-8519-657ea635530c | 2026-09-17 10:51 | 2026-09-17 10:50 | 2026-09-17 10:50 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 0.7400 | 0.7400 | 0.7800 | 64.0000 | 14800.00 | 0.00 | 14800.00 | 200 | 10 | 296 | 21733 | 0.0136198407951042 | 0.24507493291107 | 0.24507493291107 | false | false | false | true | ||||||||||||||||
| 08b426e7-d140-48c5-a770-4daed06da1f7 | 2026-09-15 14:18 | 2026-09-15 14:18 | 2026-09-15 14:18 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.6100 | 1.6100 | 1.6200 | 66.0000 | 16261.00 | 0.00 | 16261.00 | 101 | 5 | 1261 | 6140 | 0.205374592833876 | 0.255412516207934 | 0.255412516207934 | true | false | false | true | ||||||||||||||||
| 9804b34b-00c4-4fdb-bdc1-447446b83405 | 2026-09-15 11:01 | 2026-09-15 11:01 | 2026-09-15 11:01 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.2600 | 1.2200 | 1.2700 | 65.0000 | 39438.00 | 39312.00 | 0.00 | 313 | 22 | 508 | 6140 | 0.0827361563517915 | 0.250633624856465 | 0.250633624856465 | false | false | false | true | ||||||||||||||||
| 21d7e5fa-728c-4f49-99af-5dcd44878946 | 2026-09-14 12:49 | 2026-09-14 12:48 | 2026-09-14 12:48 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.0600 | 1.0600 | 1.1600 | 64.6300 | 43036.00 | 0.00 | 43036.00 | 406 | 15 | 5016 | 2791 | 1.79720530275887 | 0.249956808367159 | 0.250445676273861 | false | false | false | true | ||||||||||||||||
| c81d8813-37f8-45d9-ab7e-8d628fffc1b4 | 2026-09-14 11:46 | 2026-09-14 11:45 | 2026-09-14 11:45 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.1100 | 1.0700 | 1.1300 | 64.8200 | 17094.00 | 9102.00 | 5328.00 | 154 | 6 | 4322 | 2791 | 1.54854890720172 | 0.248100091748755 | 0.248100091748755 | false | false | false | true | ||||||||||||||||
| 606410bd-711e-4be7-8540-720e9aed9039 | 2026-09-14 11:06 | 2026-09-14 11:06 | 2026-09-14 11:06 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.1800 | 1.1700 | 1.1800 | 65.0550 | 124018.00 | 124018.00 | 0.00 | 1051 | 5 | 4091 | 2791 | 1.46578287352204 | 0.245885549273266 | 0.245885549273266 | true | false | false | true | ||||||||||||||||
| fdc8ea1e-6824-45c8-8545-e43d154bc208 | 2026-09-14 09:52 | 2026-09-14 09:52 | 2026-09-14 09:52 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.4400 | 1.4300 | 1.4500 | 65.6900 | 95904.00 | 432.00 | 95472.00 | 666 | 32 | 2995 | 2791 | 1.07309208169115 | 0.246643644093625 | 0.246643644093625 | false | false | false | true | ||||||||||||||||
| a23ab801-08ee-49d6-aa2a-72d5726d56a1 | 2026-09-14 09:51 | 2026-09-14 09:51 | 2026-09-14 09:51 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.5000 | 1.4800 | 1.5500 | 65.7900 | 336450.00 | 336300.00 | 150.00 | 2243 | 19 | 2329 | 2791 | 0.834467932640631 | 0.248852617879305 | 0.248852617879305 | false | false | false | true | ||||||||||||||||
| 5ca3a955-e2be-4924-9c08-c830d3df048c | 2026-09-10 09:56 | 2026-09-10 09:56 | 2026-09-10 09:56 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.3700 | 1.3700 | 1.3800 | 64.9800 | 65212.00 | 0.00 | 65212.00 | 476 | 15 | 939 | 4416 | 0.212635869565217 | 0.256952307233419 | 0.25893508968754 | false | false | false | true | ||||||||||||||||
| 29d66a0d-c2a8-44f3-a114-a17952cf6664 | 2026-09-10 09:56 | 2026-09-10 09:56 | 2026-09-10 09:56 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.3700 | 1.3400 | 1.3800 | 64.9850 | 51649.00 | 9316.00 | 274.00 | 377 | 13 | 1316 | 4416 | 0.298007246376812 | 0.258687538244412 | 0.258687538244412 | true | false | false | true | ||||||||||||||||
| d5b7acd0-2f0d-4cd6-a22e-341190a686ac | 2026-09-10 09:32 | 2026-09-10 09:32 | 2026-09-10 09:32 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.6100 | 1.6000 | 1.6200 | 65.6700 | 14007.00 | 0.00 | 13846.00 | 87 | 6 | 97 | 4416 | 0.0219655797101449 | 0.253500100798578 | 0.253500100798578 | false | false | false | true | ||||||||||||||||
| d51b12d2-2e86-451b-9b78-8ed7911a549c | 2026-09-09 13:45 | 2026-09-09 13:45 | 2026-09-09 13:45 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.4600 | 1.4600 | 1.5000 | 65.3850 | 27010.00 | 0.00 | 27010.00 | 185 | 13 | 977 | 4020 | 0.243034825870647 | 0.246193166716553 | 0.246193166716553 | false | false | false | true | ||||||||||||||||
| 1e27ea35-909a-4507-860e-7de1012cd049 | 2026-09-09 09:55 | 2026-09-09 09:55 | 2026-09-09 09:55 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.5800 | 1.5800 | 1.6400 | 65.6550 | 75050.00 | 0.00 | 75050.00 | 475 | 5 | 545 | 4020 | 0.135572139303483 | 0.246909914185416 | 0.246909914185416 | false | false | false | true | ||||||||||||||||
| efad0eb6-708e-4183-92f7-557f322b1af0 | 2026-09-08 09:36 | 2026-09-08 09:36 | 2026-09-08 09:36 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.3300 | 1.2100 | 1.3300 | 65.0700 | 30189.00 | 30189.00 | 0.00 | 227 | 11 | 230 | 3839 | 0.0599114352696015 | 0.242163617434505 | 0.242163617434505 | true | false | false | true | ||||||||||||||||
| 5453a489-07e2-491c-b103-bfc88b5f5964 | 2026-08-26 14:51 | 2026-08-26 14:51 | 2026-08-26 14:51 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 0.7800 | 0.7800 | 0.8000 | 62.3650 | 14898.00 | 0.00 | 14898.00 | 191 | 6 | 382 | 2485 | 0.153722334004024 | 0.241162889431689 | 0.241162889431689 | false | false | false | true | ||||||||||||||||
| c69a1650-3b19-4c3f-8d3e-b8bc3fca37f3 | 2026-08-17 15:19 | 2026-08-17 15:19 | 2026-08-17 15:19 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.0200 | 0.9800 | 1.0100 | 62.5650 | 15300.00 | 15300.00 | 0.00 | 150 | 6 | 309 | 644 | 0.479813664596273 | 0.243247377236192 | 0.243247377236192 | true | false | false | true | ||||||||||||||||
| 28f0e17a-08ad-4636-bf6a-2dcd1363a823 | 2026-08-17 15:09 | 2026-08-17 15:09 | 2026-08-17 15:09 | XLE | XLE261016C00067000 | call | 67.0000 | 2026-10-16 | 1.0200 | 0.9800 | 1.0200 | 62.5899 | 10200.00 | 10200.00 | 0.00 | 100 | 20 | 159 | 644 | 0.246894409937888 | 0.242429981176489 | 0.242429981176489 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41804540014.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 41841409082.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42266645050.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 |
| — |
| 42266645050.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:09:54.469160Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42699711298.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:49:37.903150Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42699711298.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:02:31.142849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42699711298.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42699711298.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42699711298.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42699711298.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:06:33.692120Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42699711298.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:06:33.692120Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42699711298.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:32:54.294551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42699711298.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:50:47.676652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42699711298.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 42266645050.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:39:51.680537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42266645050.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:11:05.103195Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42266645050.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 42266645050.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |