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_alerts566,287 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 |
|---|
| cb1fa7a5-b6a0-49a5-86b7-ab6e3b2811d6 | 2026-08-17 10:56 | 2026-08-17 10:56 | 2026-08-17 10:56 | RKLB | RKLB270115C00100000 | call | 100.0000 | 2027-01-15 | 12.7000 | 12.3500 | 13.0000 | 83.8450 | 10160.00 | 1270.00 | 2540.00 | 8 | 8 | 71 | 9587 | 0.00740586210493376 | 0.828106989198196 | 0.828106989198196 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 37426822649.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5fe3a653-7646-43c1-a007-631837bfbba6 | 2026-08-25 15:11 | 2026-08-25 15:11 | 2026-08-25 15:11 | RKLB | RKLB270115C00100000 | call | 100.0000 | 2027-01-15 | 5.0000 | 5.0000 | 5.2000 | 66.7200 | 11500.00 | 0.00 | 11500.00 | 23 | 10 | 399 | 10053 | 0.0396896448821247 | 0.800953462073382 | 0.800953462073382 | false | false | false | true | ||||||||||||||||
| 86de715d-7ceb-4036-b1d0-bb9022b6a827 | 2026-08-28 12:33 | 2026-08-28 12:32 | 2026-08-28 12:32 | RKLB | RKLB270115C00100000 | call | 100.0000 | 2027-01-15 | 3.8000 | 3.7500 | 3.8500 | 63.9200 | 46740.00 | 45220.00 | 1140.00 | 123 | 12 | 548 | 10641 | 0.0514989192745043 | 0.778802437703654 | 0.778802437703654 | false | false | false | true | ||||||||||||||||
| a64df952-3158-4845-a1bf-1bdadb564df4 | 2026-08-28 15:10 | 2026-08-28 15:10 | 2026-08-28 15:10 | RKLB | RKLB270115C00100000 | call | 100.0000 | 2027-01-15 | 3.7500 | 3.7000 | 3.8000 | 64.0000 | 220125.00 | 81375.00 | 0.00 | 587 | 9 | 1400 | 10641 | 0.13156658208815 | 0.773268906182758 | 0.773268906182758 | false | false | false | true | ||||||||||||||||
| 45a1a10f-d9a2-4022-9e64-f1d49ba2829c | 2026-09-01 11:12 | 2026-09-01 11:12 | 2026-09-01 11:12 | RKLB | RKLB270115C00100000 | call | 100.0000 | 2027-01-15 | 3.1000 | 3.0500 | 3.1500 | 62.2200 | 15500.00 | 13640.00 | 0.00 | 50 | 6 | 299 | 11404 | 0.0262188705717292 | 0.76632198099417 | 0.76632198099417 | false | false | false | true | ||||||||||||||||
| a582954c-96d8-4c90-bd15-ad36f83e16a3 | 2026-09-04 13:20 | 2026-09-04 13:20 | 2026-09-04 13:20 | RKLB | RKLB270115C00100000 | call | 100.0000 | 2027-01-15 | 3.5000 | 3.4000 | 3.5000 | 64.0817 | 34629.00 | 34629.00 | 0.00 | 99 | 14 | 697 | 12154 | 0.0573473753496791 | 0.772050376608382 | 0.772050376608382 | false | false | false | true | ||||||||||||||||
| 1837f3b2-81ca-4d03-87b4-3e44c34d71e3 | 2026-09-08 15:27 | 2026-09-08 15:27 | 2026-09-08 15:27 | RKLB | RKLB270115C00100000 | call | 100.0000 | 2027-01-15 | 4.1500 | 4.0000 | 4.3500 | 65.8850 | 19090.00 | 16600.00 | 2490.00 | 46 | 11 | 935 | 12619 | 0.0740946192249782 | 0.799127659127024 | 0.799127659127024 | false | false | false | true | ||||||||||||||||
| 0826eae5-6322-4425-8bf8-68ec21efc07e | 2026-09-09 10:48 | 2026-09-09 10:48 | 2026-09-09 10:48 | RKLB | RKLB270115C00100000 | call | 100.0000 | 2027-01-15 | 3.8000 | 3.7000 | 3.8500 | 63.9600 | 19000.00 | 19000.00 | 0.00 | 50 | 8 | 415 | 12465 | 0.0332932210188528 | 0.814769877475766 | 0.814769877475766 | false | false | false | true | ||||||||||||||||
| 064eee62-c09d-4e4a-bbbf-ac991ca4d8bc | 2026-09-09 13:54 | 2026-09-09 13:54 | 2026-09-09 13:54 | RKLB | RKLB270115C00100000 | call | 100.0000 | 2027-01-15 | 3.8000 | 3.6000 | 3.8000 | 64.1000 | 19000.00 | 19000.00 | 0.00 | 50 | 25 | 672 | 12465 | 0.0539109506618532 | 0.811832313119203 | 0.811832313119203 | false | false | false | true | ||||||||||||||||
| bd88c309-02b7-4c43-887f-6c5d7134f2be | 2026-09-15 12:56 | 2026-09-15 12:56 | 2026-09-15 12:56 | RKLB | RKLB270115C00100000 | call | 100.0000 | 2027-01-15 | 3.5000 | 3.3500 | 3.5500 | 64.7600 | 28700.00 | 28700.00 | 0.00 | 82 | 5 | 501 | 13741 | 0.0364602285132086 | 0.7923506340645 | 0.7923506340645 | false | false | false | true | ||||||||||||||||
| 935429fd-eda8-49ac-8634-718c15ff1128 | 2026-09-17 10:46 | 2026-09-17 10:46 | 2026-09-17 10:46 | RKLB | RKLB270115C00100000 | call | 100.0000 | 2027-01-15 | 4.0000 | 3.9000 | 4.0000 | 67.7601 | 27600.00 | 27600.00 | 0.00 | 69 | 9 | 595 | 14198 | 0.0419073108888576 | 0.776931163392596 | 0.776931163392596 | false | false | false | true | ||||||||||||||||
| ad0d3284-8530-48bf-9495-b72bc1141d12 | 2026-09-22 12:48 | 2026-09-22 12:48 | 2026-09-22 12:48 | RKLB | RKLB270115C00100000 | call | 100.0000 | 2027-01-15 | 5.0000 | 4.8500 | 5.0000 | 71.9700 | 13000.00 | 13000.00 | 0.00 | 26 | 12 | 588 | 14153 | 0.0415459619868579 | 0.778964329081733 | 0.778531377256733 | false | false | false | true | ||||||||||||||||
| 3073b77a-e876-4a76-96e0-70a3bd8ee633 | 2026-09-28 11:20 | 2026-09-28 11:20 | 2026-09-28 11:20 | RKLB | RKLB270115C00100000 | call | 100.0000 | 2027-01-15 | 4.5000 | 4.4500 | 4.7000 | 72.0000 | 11250.00 | 0.00 | 11250.00 | 25 | 7 | 202 | 13661 | 0.0147866188419589 | 0.760050887396731 | 0.760050887396731 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T19:21:53.483381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| unknown |
| — |
| 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 |
| Common Stock |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| unknown |
| — |
| 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 |
| Common Stock |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T15:18:08.991662Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:34:11.817020Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:30:09.198364Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| 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 |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T17:17:02.017770Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 40580129689.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:48:09.438351Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 43069267694.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:48:50.097062Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 43194921296.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:21:41.621308Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |