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 | 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 |
|---|
| 66f9ae7d-f1a9-4346-8b70-5e271b1e40da | 2026-08-17 15:18 | 2026-08-17 15:17 | 2026-08-17 15:17 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 1.1900 | 1.1700 | 1.2000 | 6.4250 | 72709.00 | 72709.00 | 0.00 | 611 | 15 | 1453 | 54255 | 0.0267809418486775 | 0.835131777117274 | 0.835131777117274 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 4242831138.00 | 2026-11-05 | unknown | — | 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 |
| 93ead336-0dc3-411c-9147-505fbc801112 | 2026-08-17 15:39 | 2026-08-17 15:39 | 2026-08-17 15:39 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 1.2400 | 1.1900 | 1.2600 | 6.4500 | 11205.00 | 3592.00 | 2363.00 | 90 | 9 | 1724 | 54255 | 0.0317758731914109 | 0.844954756957792 | 0.863301524707842 | false | false | false | true | ||||||||||||||||
| d1288fef-7206-4da3-b0e9-401c2a6e5fcd | 2026-08-18 10:00 | 2026-08-18 10:00 | 2026-08-18 10:00 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 1.1300 | 1.0700 | 1.1300 | 6.2300 | 37091.00 | 37091.00 | 0.00 | 329 | 8 | 543 | 55369 | 0.00980693167656992 | 0.86081345529323 | 0.86081345529323 | false | false | false | true | ||||||||||||||||
| 3f061996-6455-4293-bbfd-e23e5bd136e0 | 2026-08-18 10:37 | 2026-08-18 10:37 | 2026-08-18 10:37 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 1.0700 | 1.0600 | 1.0900 | 6.2300 | 63237.00 | 52644.00 | 10379.00 | 591 | 13 | 1169 | 55369 | 0.0211128971084903 | 0.830986996704638 | 0.829316196860207 | true | false | false | true | ||||||||||||||||
| d7285407-307c-4625-aecd-3d804fd3872f | 2026-08-18 11:21 | 2026-08-18 11:21 | 2026-08-18 11:21 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 1.0800 | 1.0600 | 1.0900 | 6.2400 | 19440.00 | 19008.00 | 432.00 | 180 | 9 | 1741 | 55369 | 0.0314435875670502 | 0.832262500001769 | 0.832262500001769 | true | false | false | true | ||||||||||||||||
| f80e821f-889f-407e-8cc1-aa5c0a6f2963 | 2026-08-19 10:11 | 2026-08-19 10:11 | 2026-08-19 10:11 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 1.0400 | 1.0200 | 1.0600 | 6.1800 | 19032.00 | 16328.00 | 2704.00 | 183 | 10 | 309 | 55946 | 0.00552318306938834 | 0.828338550307649 | 0.830005006524857 | true | false | false | true | ||||||||||||||||
| 68b085e9-fda0-4da5-bb0d-54a232ba4632 | 2026-08-19 14:17 | 2026-08-19 14:17 | 2026-08-19 14:17 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 1.1000 | 1.0700 | 1.1000 | 6.3200 | 35750.00 | 35750.00 | 0.00 | 325 | 14 | 1063 | 55946 | 0.0190004647338505 | 0.820921048899871 | 0.820921048899871 | false | false | false | true | ||||||||||||||||
| 4807c342-e281-490e-ac61-2b5d54a4c099 | 2026-08-20 10:02 | 2026-08-20 10:02 | 2026-08-20 10:02 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 1.0300 | 1.0300 | 1.0800 | 6.2750 | 12772.00 | 0.00 | 12772.00 | 124 | 12 | 252 | 56616 | 0.00445103857566766 | 0.794988156936572 | 0.794988156936572 | false | false | false | true | ||||||||||||||||
| 8f2c67cc-5961-4f8a-8b65-a1b5f7003a5f | 2026-08-20 10:53 | 2026-08-20 10:53 | 2026-08-20 10:53 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 0.9500 | 0.9500 | 0.9600 | 6.1750 | 10355.00 | 0.00 | 10355.00 | 109 | 5 | 2357 | 56616 | 0.0416313409636852 | 0.777198418598964 | 0.777198418598964 | false | false | false | true | ||||||||||||||||
| 2b24a656-4dbb-4ad1-83b0-46c8372caeac | 2026-08-20 11:21 | 2026-08-20 11:20 | 2026-08-20 11:20 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 0.9100 | 0.9100 | 0.9400 | 6.1001 | 24661.00 | 0.00 | 24661.00 | 271 | 13 | 4077 | 56616 | 0.072011445527766 | 0.775823552829305 | 0.775823552829305 | false | false | false | true | ||||||||||||||||
| a43f4c85-70c4-422f-99a4-7a3b912592e8 | 2026-08-20 11:24 | 2026-08-20 11:24 | 2026-08-20 11:24 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 0.9200 | 0.9000 | 0.9200 | 6.1000 | 20608.00 | 20608.00 | 0.00 | 224 | 8 | 5430 | 56616 | 0.0959092835947435 | 0.782309078045938 | 0.782309078045938 | false | false | false | true | ||||||||||||||||
| 936aea49-b48b-4a86-8750-c7a797bf321b | 2026-08-20 12:41 | 2026-08-20 12:41 | 2026-08-20 12:41 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 0.9500 | 0.9000 | 1.0000 | 6.0450 | 16625.00 | 14440.00 | 0.00 | 175 | 6 | 7617 | 56616 | 0.134537939805002 | 0.819693629326949 | 0.819693629326949 | false | false | false | true | ||||||||||||||||
| 40ba1894-6ade-4053-befc-6744b4fb2a66 | 2026-08-26 09:52 | 2026-08-26 09:52 | 2026-08-26 09:52 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 0.9000 | 0.9000 | 0.9100 | 6.0650 | 23400.00 | 0.00 | 23400.00 | 260 | 17 | 1692 | 50111 | 0.0337650416076311 | 0.797853320143454 | 0.797853320143454 | false | false | false | true | ||||||||||||||||
| 64c06340-956b-411b-8445-e5396123a9bf | 2026-09-08 13:15 | 2026-09-08 13:15 | 2026-09-08 13:15 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 0.7300 | 0.7300 | 0.7400 | 5.8750 | 14600.00 | 0.00 | 14600.00 | 200 | 28 | 1331 | 60502 | 0.021999272751314 | 0.782661900864884 | 0.782661900864884 | false | false | false | true | ||||||||||||||||
| 1dfbed41-aa61-4d45-9201-1aa9881f6004 | 2026-09-17 09:42 | 2026-09-17 09:42 | 2026-09-17 09:42 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 0.4500 | 0.4500 | 0.4600 | 5.3893 | 94275.00 | 0.00 | 94275.00 | 2095 | 22 | 2146 | 62385 | 0.0343992947022521 | 0.74603294646861 | 0.74603294646861 | false | false | false | true | ||||||||||||||||
| 1abce1e6-54ee-4d5e-a451-08702bc8fdf8 | 2026-09-17 11:37 | 2026-09-17 11:37 | 2026-09-17 11:37 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 0.4600 | 0.4400 | 0.4600 | 5.3600 | 21683.00 | 12098.00 | 0.00 | 476 | 12 | 2964 | 62385 | 0.047511421014667 | 0.765661578300293 | 0.755132886332669 | false | false | false | true | ||||||||||||||||
| 80a51aa6-c363-40f4-a31e-b0ba5a709e93 | 2026-09-22 12:50 | 2026-09-22 12:50 | 2026-09-22 12:50 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 0.5400 | 0.5300 | 0.5400 | 5.6599 | 10962.00 | 10962.00 | 0.00 | 203 | 23 | 2642 | 67838 | 0.0389457236357204 | 0.754057390716514 | 0.752467891251998 | true | false | false | true | ||||||||||||||||
| 2bbfb0aa-03c7-4619-84c8-03808d1210a1 | 2026-09-24 09:41 | 2026-09-24 09:41 | 2026-09-24 09:41 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 0.5100 | 0.5100 | 0.5400 | 5.6250 | 50643.00 | 0.00 | 50643.00 | 993 | 19 | 1134 | 69951 | 0.0162113479435605 | 0.745727670604053 | 0.745727670604053 | false | false | false | true | ||||||||||||||||
| 54e8f5f6-5f8d-465d-a024-2c2d07320a09 | 2026-09-25 10:14 | 2026-09-25 10:14 | 2026-09-25 10:14 | ACHR | ACHR270115C00007000 | call | 7.0000 | 2027-01-15 | 0.5200 | 0.5100 | 0.5600 | 5.6600 | 10400.00 | 52.00 | 10348.00 | 200 | 13 | 259 | 70062 | 0.00369672575718649 | 0.74606379758209 | 0.74606379758209 | true | false | false | true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 4242831138.00 |
| 2026-11-05 |
| unknown |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 4242831138.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4242831138.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4242831138.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:23:23.944279Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4242831138.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4242831138.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4242831138.00 |
| 2026-11-05 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4242831138.00 |
| 2026-11-05 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4242831138.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4242831138.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4242831138.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4242831138.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4242831138.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:42:35.153326Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4158128520.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:47:44.789077Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4158128520.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:37:51.418712Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4381435422.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:52:20.560244Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4396835898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:42:52.039375Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 4319833518.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:14:35.986965Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |