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_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 | 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 |
|---|
| 007c2ec9-2967-489b-be2d-064e388b8091 | 2026-09-10 16:01 | 2026-09-10 16:01 | 2026-09-10 16:01 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.7600 | 0.7400 | 0.7600 | 57.4899 | 11400.00 | 11400.00 | 0.00 | 150 | 7 | 11988 | 37869 | 0.316565000396102 | 0.495239221004722 | 0.495239221004722 | 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-11T13:30:31.573730Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a41f402b-e9a9-4a5f-aac4-8f807ab81a85 | 2026-09-11 09:31 | 2026-09-11 09:30 | 2026-09-11 09:30 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.9100 | 0.9000 | 0.9400 | 58.0000 | 58968.00 | 910.00 | 58058.00 | 648 | 10 | 775 | 40868 | 0.0189634922188509 | 0.449177493898748 | 0.449177493898748 | true | false | false | true | ||||||||||||||||
| 3a3b0383-55f8-4c8c-b89b-0ffa4671f9ac | 2026-09-11 09:36 | 2026-09-11 09:36 | 2026-09-11 09:36 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.9200 | 0.9000 | 0.9200 | 58.0000 | 45996.00 | 45723.00 | 273.00 | 500 | 47 | 1668 | 40868 | 0.0408143290594108 | 0.443701200862053 | 0.446940411351399 | true | false | false | true | ||||||||||||||||
| a288a504-a4f6-4995-8c1b-eb947cf86eb1 | 2026-09-11 11:19 | 2026-09-11 11:19 | 2026-09-11 11:19 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.6400 | 0.6300 | 0.6500 | 58.0950 | 19200.00 | 15744.00 | 0.00 | 300 | 6 | 4826 | 40868 | 0.118087501223451 | 0.421571317314254 | 0.421571317314254 | false | false | false | true | ||||||||||||||||
| f94aed2c-96b0-4647-aaa7-7961f5801701 | 2026-09-11 11:32 | 2026-09-11 11:32 | 2026-09-11 11:32 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.6700 | 0.6600 | 0.6700 | 58.2400 | 33701.00 | 33701.00 | 0.00 | 503 | 5 | 5526 | 40868 | 0.135215816775962 | 0.416813622172341 | 0.41626149490594 | false | false | false | true | ||||||||||||||||
| 726da82b-c7e6-42c8-84c4-f07456f32c23 | 2026-09-11 11:53 | 2026-09-11 11:53 | 2026-09-11 11:53 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.6400 | 0.6400 | 0.6500 | 58.1850 | 12416.00 | 0.00 | 12416.00 | 194 | 16 | 5990 | 40868 | 0.146569443085054 | 0.411799322516038 | 0.411799322516038 | false | false | false | true | ||||||||||||||||
| 5af200a5-13e6-448a-8e71-ec3523919ca6 | 2026-09-11 14:54 | 2026-09-11 14:54 | 2026-09-11 14:54 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.5400 | 0.5300 | 0.5500 | 58.0050 | 13392.00 | 0.00 | 11934.00 | 248 | 6 | 8678 | 40868 | 0.212342174806695 | 0.394977619649459 | 0.394977619649459 | false | false | false | true | ||||||||||||||||
| 5e56c1a7-5619-41a6-86b7-f091cb8c6e8f | 2026-09-14 15:29 | 2026-09-14 15:29 | 2026-09-14 15:29 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.3600 | 0.3600 | 0.3700 | 57.2400 | 18000.00 | 0.00 | 18000.00 | 500 | 14 | 2748 | 41700 | 0.0658992805755396 | 0.528172482714544 | 0.528172482714544 | false | false | false | true | ||||||||||||||||
| cc7d12a9-07e3-43ac-8935-9a0f44fc61ab | 2026-09-15 09:41 | 2026-09-15 09:41 | 2026-09-15 09:41 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.3600 | 0.3500 | 0.3600 | 57.5000 | 18000.00 | 18000.00 | 0.00 | 500 | 14 | 814 | 42310 | 0.0192389506026944 | 0.574114257040826 | 0.574114257040826 | false | false | false | true | ||||||||||||||||
| 5cea1f76-452f-4e65-b930-4d54c0ddaed8 | 2026-09-15 09:42 | 2026-09-15 09:42 | 2026-09-15 09:42 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.3600 | 0.3600 | 0.3700 | 57.5350 | 14832.00 | 0.00 | 14832.00 | 412 | 8 | 1295 | 42310 | 0.0306074214133775 | 0.569158458754574 | 0.569158458754574 | false | false | false | true | ||||||||||||||||
| 3d11f185-39cd-443b-8d37-2081bce38f0c | 2026-09-15 13:42 | 2026-09-15 13:42 | 2026-09-15 13:42 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.3100 | 0.2900 | 0.3100 | 57.2601 | 15500.00 | 15500.00 | 0.00 | 500 | 13 | 3505 | 42310 | 0.0828409359489482 | 0.57346794596187 | 0.57346794596187 | false | false | false | true | ||||||||||||||||
| f1692a46-9ff6-4fb4-9ec6-c84dd7b45ce0 | 2026-09-16 10:22 | 2026-09-16 10:21 | 2026-09-16 10:21 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.3500 | 0.3500 | 0.3600 | 58.0000 | 17500.00 | 0.00 | 17500.00 | 500 | 13 | 1617 | 43538 | 0.0371399696816574 | 0.597115540484802 | 0.597115540484802 | false | false | false | true | ||||||||||||||||
| 91420340-fa42-4d00-85f5-45b1003738c3 | 2026-09-17 13:48 | 2026-09-17 13:48 | 2026-09-17 13:48 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.2400 | 0.2300 | 0.2400 | 59.2150 | 12864.00 | 12864.00 | 0.00 | 536 | 17 | 7631 | 43770 | 0.174343157413754 | 0.436074019771331 | 0.436074019771331 | false | false | false | true | ||||||||||||||||
| fc8a68a1-0884-492d-99ee-f6410f61297f | 2026-09-18 11:08 | 2026-09-18 11:08 | 2026-09-18 11:08 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.1900 | 0.1800 | 0.2200 | 59.9101 | 19361.00 | 19.00 | 18981.00 | 1019 | 38 | 10285 | 43509 | 0.236387873773242 | 0.388510933672217 | 0.410951708315157 | false | false | false | true | ||||||||||||||||
| c1970aaa-1393-4d87-b38a-1d4c60661f5d | 2026-09-18 12:13 | 2026-09-18 12:12 | 2026-09-18 12:12 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.1700 | 0.1500 | 0.1700 | 59.0000 | 17000.00 | 17000.00 | 0.00 | 1000 | 48 | 14899 | 43509 | 0.342434898526742 | 0.420921735570691 | 0.420921735570691 | false | false | false | true | ||||||||||||||||
| cd082bdc-6d61-418d-9d75-4b3dfb83089c | 2026-09-18 12:32 | 2026-09-18 12:32 | 2026-09-18 12:32 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.3300 | 0.3200 | 0.3300 | 60.1999 | 16500.00 | 16500.00 | 0.00 | 500 | 5 | 16724 | 43509 | 0.38438024316808 | 0.451146310032727 | 0.451146310032727 | true | false | false | true | ||||||||||||||||
| d69bd616-4014-4802-85e4-511f88dcc269 | 2026-09-18 15:01 | 2026-09-18 15:01 | 2026-09-18 15:01 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.1400 | 0.1200 | 0.1400 | 60.0350 | 14000.00 | 14000.00 | 0.00 | 1000 | 49 | 25099 | 43509 | 0.576869153508469 | 0.479431665552047 | 0.479431665552047 | false | false | false | true | ||||||||||||||||
| c60aa778-af24-4c49-8a43-3ab98bedb137 | 2026-09-18 15:04 | 2026-09-18 15:03 | 2026-09-18 15:03 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.1000 | 0.1000 | 0.1300 | 59.9999 | 25553.00 | 0.00 | 25553.00 | 2496 | 165 | 27717 | 43509 | 0.637040612287113 | 0.444635342862472 | 0.404185541451442 | false | false | false | true | ||||||||||||||||
| 2d21664e-a416-4733-b983-88c4325b82fe | 2026-09-18 15:45 | 2026-09-18 15:45 | 2026-09-18 15:45 | SLV | SLV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.0500 | 0.0500 | 0.0600 | 59.9917 | 10131.00 | 6.00 | 10125.00 | 2026 | 54 | 33909 | 43509 | 0.779355995311315 | 0.505869288382045 | 0.426986348846339 | false | false | false | true |
| 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-11T13:37:33.609039Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:37:33.609039Z"} |
| 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-11T15:28:46.184785Z"} |
| 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-11T15:53:19.427541Z"} |
| 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-11T16:20:29.379987Z"} |
| 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:04:54.864587Z"} |
| 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-14T19:44:36.941159Z"} |
| 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-15T13:48:14.023311Z"} |
| 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-15T13:48:14.023311Z"} |
| 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-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 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 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-17T18:13:15.605683Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 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-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 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-18T16:25:30.671610Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 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-18T16:45:45.480252Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 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-18T19:03:43.854590Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |