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_alerts326,449 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 |
|---|
| b72719c9-53cf-449b-92a3-cc0baad159cc | 2026-08-17 11:54 | 2026-08-17 11:54 | 2026-08-17 11:54 | RGTI | RGTI280121P00015000 | put | 15.0000 | 2028-01-21 | 4.6500 | 4.6500 | 4.8000 | 18.8900 | 24182.00 | 0.00 | 24182.00 | 52 | 11 | 63 | 526 | 0.119771863117871 | 0.907371594390366 | 0.908912321249954 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 5096648767.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f999ac98-2434-4924-a801-d815d959960c | 2026-08-19 12:09 | 2026-08-19 12:09 | 2026-08-19 12:09 | RGTI | RGTI261016C00017000 | call | 17.0000 | 2026-10-16 | 2.3200 | 2.2700 | 2.3200 | 17.2950 | 136878.00 | 136878.00 | 0.00 | 590 | 18 | 654 | 516 | 1.26744186046512 | 0.77367532728349 | 0.781141948251144 | false | false | false | true | ||||||||||||||||
| d50f1ace-682e-4d4e-8c22-daecbfb1e0a5 | 2026-08-20 09:54 | 2026-08-20 09:54 | 2026-08-20 09:54 | RGTI | RGTI260821P00018000 | put | 18.0000 | 2026-08-21 | 1.4200 | 1.4100 | 1.5400 | 16.5699 | 17048.00 | 0.00 | 16907.00 | 120 | 5 | 238 | 4413 | 0.0539315658282348 | 0.705851986751688 | 1.54660396363613 | false | false | false | true | ||||||||||||||||
| ebba61d9-f22b-4620-be0d-f50e6be23289 | 2026-08-26 15:45 | 2026-08-26 15:45 | 2026-08-26 15:45 | RGTI | RGTI280121P00015000 | put | 15.0000 | 2028-01-21 | 5.0500 | 5.0500 | 5.1500 | 16.0650 | 20202.00 | 0.00 | 20202.00 | 40 | 11 | 141 | 1512 | 0.0932539682539683 | 0.872823965918458 | 0.872823965918458 | false | false | false | true | ||||||||||||||||
| 76e21928-1b6a-4b77-88e1-e2bd4b69ca21 | 2026-08-27 12:49 | 2026-08-27 12:49 | 2026-08-27 12:49 | RGTI | RGTI260918C00016000 | call | 16.0000 | 2026-09-18 | 1.5300 | 1.4400 | 1.5400 | 16.5950 | 30560.00 | 30560.00 | 0.00 | 200 | 7 | 1178 | 2528 | 0.465981012658228 | 0.739576656290757 | 0.739576656290757 | false | false | false | true | ||||||||||||||||
| ab9e4123-952c-4886-96a7-19aeaced609f | 2026-08-28 11:55 | 2026-08-28 11:55 | 2026-08-28 11:55 | RGTI | RGTI261218C00018000 | call | 18.0000 | 2026-12-18 | 2.0800 | 2.0800 | 2.1800 | 15.0000 | 20182.00 | 837.00 | 19345.00 | 97 | 21 | 115 | 868 | 0.132488479262673 | 0.825469996307208 | 0.831251791472437 | false | false | false | true | ||||||||||||||||
| f1721884-5375-4399-9392-c426d9f0ff32 | 2026-08-31 15:24 | 2026-08-31 15:24 | 2026-08-31 15:24 | RGTI | RGTI261218C00020000 | call | 20.0000 | 2026-12-18 | 1.5000 | 1.3600 | 1.6000 | 15.6350 | 10511.00 | 1050.00 | 9461.00 | 70 | 19 | 99 | 1904 | 0.0519957983193277 | 0.825167804104624 | 0.82823032157909 | false | false | false | true | ||||||||||||||||
| aecf55ba-f4e9-4d6e-bcb1-a8e3abe5f202 | 2026-09-01 13:22 | 2026-09-01 13:22 | 2026-09-01 13:22 | RGTI | RGTI261016P00015000 | put | 15.0000 | 2026-10-16 | 1.4700 | 1.4700 | 1.5400 | 14.9399 | 57380.00 | 0.00 | 57380.00 | 390 | 31 | 428 | 12836 | 0.0333437207852914 | 0.704016170693654 | 0.712066285889767 | false | false | false | true | ||||||||||||||||
| 57769a4c-eeb8-4c00-9904-62904b40b805 | 2026-09-03 11:28 | 2026-09-03 11:27 | 2026-09-03 11:27 | RGTI | RGTI260911C00015500 | call | 15.5000 | 2026-09-11 | 0.5100 | 0.5000 | 0.5200 | 15.2900 | 16908.00 | 10607.00 | 6301.00 | 330 | 19 | 556 | 231 | 2.40692640692641 | 0.655636523868595 | 0.675266540409632 | false | false | false | true | ||||||||||||||||
| 72995448-1edc-4109-9d54-5d3d2ec3bd7a | 2026-09-08 09:34 | 2026-09-08 09:34 | 2026-09-08 09:34 | RGTI | RGTI261016C00023000 | call | 23.0000 | 2026-10-16 | 0.3600 | 0.1400 | 0.3800 | 16.6022 | 29652.00 | 26479.00 | 2945.00 | 821 | 59 | 835 | 535 | 1.5607476635514 | 0.886860049470072 | 0.885353738471447 | true | false | false | true | ||||||||||||||||
| f2e33734-4d19-45c5-891a-c17e279b7b83 | 2026-09-08 09:35 | 2026-09-08 09:34 | 2026-09-08 09:34 | RGTI | RGTI261016C00023000 | call | 23.0000 | 2026-10-16 | 0.3700 | 0.3300 | 0.3900 | 16.6000 | 37257.00 | 37185.00 | 72.00 | 1007 | 18 | 2120 | 535 | 3.96261682242991 | 0.886872399503761 | 0.893180101288421 | true | false | false | true | ||||||||||||||||
| 50df08d1-bf4b-4e41-9fd2-3f2517c54760 | 2026-09-08 09:52 | 2026-09-08 09:52 | 2026-09-08 09:52 | RGTI | RGTI260911P00016500 | put | 16.5000 | 2026-09-11 | 0.6500 | 0.6500 | 0.6700 | 16.4100 | 11745.00 | 0.00 | 11745.00 | 180 | 7 | 367 | 255 | 1.43921568627451 | 1.01981564877831 | 1.01981564877831 | true | false | false | true | ||||||||||||||||
| 064508e3-9494-4bb5-b238-6ba47cbddd78 | 2026-09-08 09:52 | 2026-09-08 09:52 | 2026-09-08 09:52 | RGTI | RGTI260911P00016000 | put | 16.0000 | 2026-09-11 | 0.4300 | 0.4200 | 0.4300 | 16.4100 | 13750.00 | 13330.00 | 420.00 | 320 | 7 | 673 | 889 | 0.7570303712036 | 1.03280112243482 | 1.050526212239 | true | false | false | true | ||||||||||||||||
| 09b3e064-8516-4417-bde6-cbc9715a2051 | 2026-09-08 11:58 | 2026-09-08 11:58 | 2026-09-08 11:58 | RGTI | RGTI260911C00017500 | call | 17.5000 | 2026-09-11 | 0.2000 | 0.1800 | 0.2100 | 16.3000 | 22452.00 | 11812.00 | 10640.00 | 1132 | 82 | 4463 | 852 | 5.23826291079812 | 1.00155300458797 | 1.02107280422692 | true | false | false | true | ||||||||||||||||
| 14ecb70c-e49f-49bb-a49a-97091d4f8730 | 2026-09-15 12:42 | 2026-09-15 12:42 | 2026-09-15 12:42 | RGTI | RGTI261016P00015000 | put | 15.0000 | 2026-10-16 | 1.1400 | 1.1200 | 1.1400 | 15.0000 | 12994.00 | 12768.00 | 226.00 | 114 | 21 | 350 | 13380 | 0.0261584454409567 | 0.714338827107008 | 0.720094698668016 | false | false | false | true | ||||||||||||||||
| 5c90e0c5-19f9-4bc0-adb7-af316717e2d1 | 2026-09-17 13:02 | 2026-09-17 13:01 | 2026-09-17 13:01 | RGTI | RGTI261016C00018000 | call | 18.0000 | 2026-10-16 | 0.6800 | 0.6700 | 0.6800 | 16.1200 | 10062.00 | 9928.00 | 0.00 | 148 | 5 | 485 | 12171 | 0.0398488209678745 | 0.731101277318778 | 0.737112583860466 | false | false | false | true | ||||||||||||||||
| 811d2e83-c425-4efa-a411-ab1082496dc1 | 2026-09-21 10:44 | 2026-09-21 10:44 | 2026-09-21 10:44 | RGTI | RGTI261120P00016000 | put | 16.0000 | 2026-11-20 | 1.7600 | 1.7500 | 1.8100 | 16.0000 | 129916.00 | 8124.00 | 121792.00 | 738 | 68 | 773 | 986 | 0.783975659229209 | 0.756127623151486 | 0.757013741836792 | false | false | false | true | ||||||||||||||||
| fec0bcd2-ce27-48e6-8d3c-7a4d3901ea1b | 2026-09-22 09:48 | 2026-09-22 09:48 | 2026-09-22 09:48 | RGTI | RGTI261016C00016000 | call | 16.0000 | 2026-10-16 | 1.2300 | 1.2300 | 1.3400 | 16.2000 | 12344.00 | 0.00 | 12344.00 | 100 | 7 | 102 | 6510 | 0.015668202764977 | 0.670881796269543 | 0.697127123788736 | false | false | false | true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5096648767.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5096648767.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5096648767.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:59:46.397035Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5096648767.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:57:23.365599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5096648767.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5096648767.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5096648767.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T17:48:11.364966Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5096648767.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5096648767.00 |
| 2026-11-09 |
| unknown |
| — |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5096648767.00 |
| 2026-11-09 |
| unknown |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5096648767.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5096648767.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5096648767.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5096648767.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:48:10.363261Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5336962265.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5517197388.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:45:07.990945Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 5513859700.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:48:39.949749Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |