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_alerts425,429 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 |
|---|
| dad2b6e9-b539-4abf-9a86-a59b20449ad7 | 2026-08-19 11:53 | 2026-08-19 11:53 | 2026-08-19 11:53 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 0.4900 | 0.4700 | 0.5000 | 18.1650 | 12593.00 | 12348.00 | 245.00 | 257 | 13 | 1463 | 9131 | 0.160223414740992 | 0.537295925501083 | 0.537295925501083 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 10907311404.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8fa34ab3-0d80-4666-aa3b-f19ce6db58c0 | 2026-08-20 11:02 | 2026-08-20 11:02 | 2026-08-20 11:02 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 0.4200 | 0.4100 | 0.4200 | 17.9150 | 12600.00 | 12600.00 | 0.00 | 300 | 11 | 453 | 10430 | 0.0434324065196548 | 0.547312112283365 | 0.547312112283365 | true | false | false | true | ||||||||||||||||
| f51e3395-b4d0-4633-8945-0531b053253b | 2026-08-25 11:23 | 2026-08-25 11:23 | 2026-08-25 11:23 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 0.3900 | 0.3700 | 0.3900 | 18.0050 | 11349.00 | 11349.00 | 0.00 | 291 | 36 | 1174 | 12549 | 0.0935532711769862 | 0.567395436572909 | 0.567395436572909 | false | false | false | true | ||||||||||||||||
| 53acc20e-f0eb-4613-a76b-6f0ac5295ff0 | 2026-08-27 14:36 | 2026-08-27 14:36 | 2026-08-27 14:36 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 0.5400 | 0.5300 | 0.5400 | 18.1500 | 20952.00 | 20952.00 | 0.00 | 388 | 25 | 2824 | 12870 | 0.219425019425019 | 0.665041026173947 | 0.665041026173947 | true | false | false | true | ||||||||||||||||
| 0ce95ecc-c473-46bd-a957-deafb1d3f077 | 2026-08-28 09:56 | 2026-08-28 09:56 | 2026-08-28 09:56 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 0.4800 | 0.4800 | 0.5000 | 18.1800 | 19200.00 | 0.00 | 19200.00 | 400 | 22 | 957 | 15060 | 0.0635458167330677 | 0.635595122747998 | 0.635595122747998 | false | false | false | true | ||||||||||||||||
| 1cb4a242-a16d-4612-a460-8311769a5ce0 | 2026-09-01 12:44 | 2026-09-01 12:44 | 2026-09-01 12:44 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 0.4100 | 0.4000 | 0.4200 | 18.4100 | 16441.00 | 15867.00 | 0.00 | 401 | 11 | 1810 | 16129 | 0.112220224440449 | 0.60669550558034 | 0.60669550558034 | false | false | false | true | ||||||||||||||||
| fc1df887-3a3f-4ccd-b84f-ffe17a0acb58 | 2026-09-02 11:13 | 2026-09-02 11:12 | 2026-09-02 11:12 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 0.5700 | 0.5500 | 0.5900 | 18.7800 | 28500.00 | 0.00 | 24510.00 | 500 | 13 | 2103 | 17550 | 0.11982905982906 | 0.655241540326547 | 0.655241540326547 | false | false | false | true | ||||||||||||||||
| e405bc11-df11-4b64-9ceb-8193b9ecdbd1 | 2026-09-02 15:04 | 2026-09-02 15:04 | 2026-09-02 15:04 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 0.6000 | 0.5800 | 0.6000 | 18.9500 | 21120.00 | 21120.00 | 0.00 | 352 | 40 | 2994 | 17550 | 0.170598290598291 | 0.635161918553814 | 0.633923328215231 | true | false | false | true | ||||||||||||||||
| 6d905373-70c9-489e-aac0-e30008575f5a | 2026-09-04 09:34 | 2026-09-04 09:33 | 2026-09-04 09:33 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 0.7200 | 0.7200 | 0.7900 | 19.4740 | 72130.00 | 0.00 | 72130.00 | 1000 | 6 | 2454 | 17737 | 0.138354851440492 | 0.615408712009635 | 0.622052635366416 | false | false | false | true | ||||||||||||||||
| b853aea0-d78e-432a-a2bc-53f0819445fc | 2026-09-08 09:47 | 2026-09-08 09:47 | 2026-09-08 09:47 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 0.4500 | 0.4500 | 0.5300 | 19.3400 | 45321.00 | 0.00 | 45321.00 | 1000 | 56 | 1765 | 17347 | 0.10174669971753 | 0.558903091756745 | 0.558903091756745 | true | false | false | true | ||||||||||||||||
| 9cb317cf-382a-4b0b-9985-0a14a596619e | 2026-09-09 10:15 | 2026-09-09 10:15 | 2026-09-09 10:15 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 0.5400 | 0.5100 | 0.5400 | 19.7650 | 11934.00 | 11934.00 | 0.00 | 221 | 26 | 2433 | 18391 | 0.1322929693872 | 0.519840356959563 | 0.5160934157576 | false | false | false | true | ||||||||||||||||
| a69f8c8d-7c77-4efe-b3cd-ca6cf124af52 | 2026-09-09 10:47 | 2026-09-09 10:47 | 2026-09-09 10:47 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 0.5000 | 0.5000 | 0.5300 | 19.8050 | 57150.00 | 0.00 | 57150.00 | 1143 | 17 | 4603 | 18391 | 0.250285465716927 | 0.46637203803702 | 0.468639487267168 | false | false | false | true | ||||||||||||||||
| dc23b2a4-7c50-484b-98da-3fb0ee25acd2 | 2026-09-10 14:21 | 2026-09-10 14:21 | 2026-09-10 14:21 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 0.6900 | 0.6800 | 0.7300 | 20.3350 | 11247.00 | 0.00 | 11247.00 | 163 | 7 | 5666 | 17398 | 0.325669617197379 | 0.415293974506803 | 0.415293974506803 | false | false | false | true | ||||||||||||||||
| 6aa40501-536e-443f-a478-0b882af5a0dd | 2026-09-11 09:34 | 2026-09-11 09:34 | 2026-09-11 09:34 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 1.2600 | 1.1800 | 1.2800 | 21.0000 | 13869.00 | 13869.00 | 0.00 | 110 | 7 | 315 | 16230 | 0.0194085027726433 | 0.456875404677277 | 0.456545343642496 | false | false | false | true | ||||||||||||||||
| ee5e905f-1335-4bdb-94e7-c7c41e9d5a16 | 2026-09-11 10:28 | 2026-09-11 10:28 | 2026-09-11 10:28 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 1.2400 | 1.2000 | 1.2500 | 21.1162 | 35712.00 | 16988.00 | 18104.00 | 288 | 33 | 3409 | 16230 | 0.210043130006161 | 0.418268023857727 | 0.418268023857727 | true | false | false | true | ||||||||||||||||
| c15d2522-7d53-4907-bb95-313d12565cec | 2026-09-11 10:31 | 2026-09-11 10:31 | 2026-09-11 10:31 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 1.2700 | 1.2600 | 1.3000 | 21.1450 | 38862.00 | 0.00 | 38862.00 | 306 | 14 | 3994 | 16230 | 0.246087492298213 | 0.426447052667999 | 0.426447052667999 | true | false | false | true | ||||||||||||||||
| f5bcfea5-0535-4024-b685-f72fcbc0a4bb | 2026-09-11 14:17 | 2026-09-11 14:17 | 2026-09-11 14:17 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 1.1300 | 1.0800 | 1.1500 | 21.0199 | 12769.00 | 6780.00 | 5311.00 | 113 | 16 | 6048 | 16230 | 0.37264325323475 | 0.405201163487631 | 0.377330842541853 | true | false | false | true | ||||||||||||||||
| 5e590277-cf7f-4493-ab39-d9e1217ba749 | 2026-09-11 14:17 | 2026-09-11 14:17 | 2026-09-11 14:17 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 1.1300 | 1.1100 | 1.1500 | 21.0101 | 14238.00 | 678.00 | 13560.00 | 126 | 10 | 6208 | 16230 | 0.382501540357363 | 0.388657723952219 | 0.388657723952219 | true | false | false | true | ||||||||||||||||
| d6f21fb3-b652-46e0-9a39-c33c32c33ed6 | 2026-09-14 11:51 | 2026-09-14 11:51 | 2026-09-14 11:51 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 1.7100 | 1.6700 | 1.7100 | 21.6850 | 19323.00 | 19323.00 | 0.00 | 113 | 8 | 1841 | 16602 | 0.110890254186243 | 0.480170522124203 | 0.447785697192274 | true | false | false | true | ||||||||||||||||
| 406e356e-a7d1-407b-b53e-36134ab6fbb9 | 2026-09-15 12:14 | 2026-09-15 12:13 | 2026-09-15 12:13 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 1.2000 | 1.2000 | 1.2200 | 21.1623 | 10800.00 | 0.00 | 10800.00 | 90 | 5 | 1445 | 15370 | 0.094014313597918 | 0.450679859392646 | 0.450679859392646 | false | false | false | true | ||||||||||||||||
| 0f42fcac-5577-493d-a044-07a9f841f807 | 2026-09-17 15:55 | 2026-09-17 15:55 | 2026-09-17 15:55 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 2.7500 | 2.6600 | 2.7500 | 22.0000 | 27225.00 | 27225.00 | 0.00 | 99 | 7 | 1728 | 13783 | 0.125371834869042 | 1.01307136305275 | 1.01307136305275 | false | false | false | true | ||||||||||||||||
| 1a0fe091-7c33-47ed-9268-46dd0471a4cc | 2026-09-18 15:58 | 2026-09-18 15:58 | 2026-09-18 15:58 | GME | GME260918C00020000 | call | 20.0000 | 2026-09-18 | 2.6000 | 2.5600 | 2.6900 | 22.0000 | 26000.00 | 7800.00 | 9620.00 | 100 | 10 | 5644 | 12827 | 0.440009355266235 | 49.5002353446674 | 49.5002353446674 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:57:11.446067Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| 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 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:25:17.297093Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:08:56.003529Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:37:16.307537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:49:15.511852Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:24:00.331334Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:59:53.339088Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:37:18.479310Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| 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 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T18:33:12.425630Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T18:33:12.425630Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| 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 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 11487487542.00 |
| 2026-12-08 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 11421902414.00 |
| 2026-12-08 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |