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_alerts658,639 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 |
|---|
| 2f32ef49-6cef-41ab-90b3-48f75efc429c | 2026-08-17 09:49 | 2026-08-17 09:49 | 2026-08-17 09:49 | AXTI | AXTI260918C00100000 | call | 100.0000 | 2026-09-18 | 10.5000 | 10.1000 | 10.5000 | 89.6700 | 13650.00 | 13650.00 | 0.00 | 13 | 6 | 1048 | 3798 | 0.275934702474987 | 1.34885891976557 | 1.34885891976557 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 3741607477.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1575ff03-c35a-4c87-accd-150cb31b4227 | 2026-08-17 09:49 | 2026-08-17 09:48 | 2026-08-17 09:48 | AXTI | AXTI260918C00090000 | call | 90.0000 | 2026-09-18 | 13.9300 | 12.9000 | 14.0000 | 89.3663 | 41775.00 | 41775.00 | 0.00 | 30 | 7 | 186 | 3312 | 0.0561594202898551 | 1.33968391181624 | 1.33968391181624 | false | false | false | true | ||||||||||||||||
| 35908c62-edf0-49e4-80a2-c520e1927afd | 2026-08-17 09:48 | 2026-08-17 09:48 | 2026-08-17 09:48 | AXTI | AXTI260918C00100000 | call | 100.0000 | 2026-09-18 | 10.0000 | 9.4000 | 10.0000 | 88.9700 | 18000.00 | 18000.00 | 0.00 | 18 | 7 | 1006 | 3798 | 0.264876250658241 | 1.33253952432228 | 1.33253952432228 | false | false | false | true | ||||||||||||||||
| a7054b5b-7378-4598-bb69-20a8f9e39532 | 2026-08-17 09:47 | 2026-08-17 09:47 | 2026-08-17 09:47 | AXTI | AXTI260821C00100000 | call | 100.0000 | 2026-08-21 | 2.4600 | 2.4000 | 2.5000 | 88.6400 | 19426.00 | 7195.00 | 6596.00 | 79 | 26 | 484 | 4338 | 0.111572153065929 | 1.66236670981658 | 1.68719517697631 | false | false | false | true | ||||||||||||||||
| dc5364b2-3199-4edd-84bc-218402b07ec4 | 2026-08-17 09:47 | 2026-08-17 09:47 | 2026-08-17 09:47 | AXTI | AXTI261120C00095000 | call | 95.0000 | 2026-11-20 | 22.4000 | 22.1000 | 22.4000 | 88.7700 | 356160.00 | 356160.00 | 0.00 | 159 | 26 | 180 | 276 | 0.652173913043478 | 1.36872878112591 | 1.36872878112591 | false | false | false | |||||||||||||||||
| 7ae5d0bd-62c7-46db-8a9a-430a403da5ba | 2026-08-17 09:47 | 2026-08-17 09:47 | 2026-08-17 09:47 | AXTI | AXTI261120C00100000 | call | 100.0000 | 2026-11-20 | 20.6100 | 20.5000 | 20.8000 | 88.7700 | 119540.00 | 119540.00 | 0.00 | 58 | 8 | 109 | 870 | 0.125287356321839 | 1.35644454289576 | 1.3677171268575 | true | false | false | true | ||||||||||||||||
| 1455f9af-ddcf-464e-91c9-fbe26bdad289 | 2026-08-17 09:47 | 2026-08-17 09:47 | 2026-08-17 09:47 | AXTI | AXTI261120C00105000 | call | 105.0000 | 2026-11-20 | 19.2000 | 19.1000 | 19.4000 | 88.7700 | 249575.00 | 216955.00 | 32620.00 | 130 | 25 | 130 | 737 | 0.176390773405699 | 1.3597852898122 | 1.3597852898122 | false | false | false | |||||||||||||||||
| 0b0458bb-8b2d-404b-8580-0a6efbe64f20 | 2026-08-17 09:47 | 2026-08-17 09:47 | 2026-08-17 09:47 | AXTI | AXTI261120C00110000 | call | 110.0000 | 2026-11-20 | 17.9200 | 17.8000 | 18.0000 | 88.7700 | 308235.00 | 187195.00 | 121040.00 | 172 | 23 | 172 | 375 | 0.458666666666667 | 1.36778304389111 | 1.36778304389111 | false | false | false | |||||||||||||||||
| 355c8d10-ac52-42ae-8b01-1aab2a45bd51 | 2026-08-17 09:44 | 2026-08-17 09:43 | 2026-08-17 09:43 | AXTI | AXTI270219C00140000 | call | 140.0000 | 2027-02-19 | 20.1000 | 17.8000 | 20.5000 | 88.8000 | 406050.00 | 305550.00 | 100500.00 | 202 | 7 | 202 | 1422 | 0.142053445850914 | 1.29845669829451 | 1.31348684379998 | false | false | false | |||||||||||||||||
| 34793d12-8ff1-4ea0-a6a0-eb45c2168cdf | 2026-08-17 09:38 | 2026-08-17 09:38 | 2026-08-17 09:38 | AXTI | AXTI260821P00086000 | put | 86.0000 | 2026-08-21 | 5.6000 | 4.3000 | 5.6000 | 85.8900 | 15120.00 | 15120.00 | 0.00 | 27 | 16 | 180 | 8 | 22.5 | 1.55183316476939 | 1.55183316476939 | false | false | false | true | ||||||||||||||||
| 6428b72e-ec2e-4395-82f4-640246db7ffd | 2026-08-17 09:38 | 2026-08-17 09:38 | 2026-08-17 09:38 | AXTI | AXTI260821P00086000 | put | 86.0000 | 2026-08-21 | 5.6000 | 4.3000 | 5.6000 | 86.0750 | 14000.00 | 14000.00 | 0.00 | 25 | 21 | 147 | 8 | 18.375 | 1.57596948715648 | 1.57596948715648 | false | false | false | true | ||||||||||||||||
| d1dbe157-951b-4337-a475-10cf72736a31 | 2026-08-17 09:38 | 2026-08-17 09:38 | 2026-08-17 09:38 | AXTI | AXTI260821P00086000 | put | 86.0000 | 2026-08-21 | 5.3000 | 4.3000 | 5.3000 | 86.6700 | 24910.00 | 24910.00 | 0.00 | 47 | 15 | 120 | 8 | 15 | 1.5679327397505 | 1.5679327397505 | true | false | false | true | ||||||||||||||||
| 3e195f30-8373-4bde-9d23-651e61eadcd9 | 2026-08-17 09:38 | 2026-08-17 09:38 | 2026-08-17 09:38 | AXTI | AXTI260821P00079000 | put | 79.0000 | 2026-08-21 | 2.2500 | 1.9000 | 2.2500 | 87.0175 | 11250.00 | 11250.00 | 0.00 | 50 | 17 | 52 | 73 | 0.712328767123288 | 1.54268013282538 | 1.54268013282538 | false | false | false | true | ||||||||||||||||
| fc6462eb-2fba-41e0-9914-b8628f1c1405 | 2026-08-17 09:37 | 2026-08-17 09:37 | 2026-08-17 09:37 | AXTI | AXTI260918C00085000 | call | 85.0000 | 2026-09-18 | 14.5000 | 14.5000 | 15.3000 | 87.4500 | 123250.00 | 0.00 | 123250.00 | 85 | 9 | 106 | 929 | 0.114101184068891 | 1.2950976456256 | 1.2950976456256 | false | false | false | true | ||||||||||||||||
| 72885079-8a9e-43b4-a538-a247023d63cf | 2026-08-17 09:31 | 2026-08-17 09:30 | 2026-08-17 09:30 | AXTI | AXTI260918C00100000 | call | 100.0000 | 2026-09-18 | 9.3000 | 8.7000 | 9.4000 | 88.4900 | 10225.00 | 10225.00 | 0.00 | 11 | 6 | 350 | 3798 | 0.0921537651395471 | 1.28645880458639 | 1.28645880458639 | false | false | false | true | ||||||||||||||||
| 134f9456-8141-4851-a545-3828a7cd3dd3 | 2026-08-17 09:31 | 2026-08-17 09:30 | 2026-08-17 09:30 | AXTI | AXTI260918C00100000 | call | 100.0000 | 2026-09-18 | 8.9700 | 8.8000 | 9.4000 | 88.4446 | 10768.00 | 3728.00 | 7040.00 | 12 | 5 | 367 | 3798 | 0.0966298051606108 | 1.23503564918679 | 1.29132752684769 | false | false | false | |||||||||||||||||
| f767693b-639b-46f3-9301-4fac1c25a97b | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | AXTI | AXTI260918C00100000 | call | 100.0000 | 2026-09-18 | 9.2100 | 9.1000 | 9.5000 | 88.4300 | 12900.00 | 0.00 | 5460.00 | 14 | 5 | 284 | 3798 | 0.0747761979989468 | 1.26976996308859 | 1.26976996308859 | false | false | false | true | ||||||||||||||||
| edc2ee88-5fcc-4a14-930f-abf5eee8d8ab | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | AXTI | AXTI260821C00092000 | call | 92.0000 | 2026-08-21 | 4.5000 | 4.4000 | 4.5000 | 88.7600 | 35100.00 | 35100.00 | 0.00 | 78 | 18 | 80 | 44 | 1.81818181818182 | 1.58331185197 | 1.58253200485046 | true | false | false | true | ||||||||||||||||
| 752b69dc-3175-4832-854a-d1752acf38bc | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | AXTI | AXTI260821C00089000 | call | 89.0000 | 2026-08-21 | 5.7800 | 4.3000 | 6.0000 | 88.7600 | 30640.00 | 25430.00 | 5210.00 | 53 | 17 | 58 | 48 | 1.20833333333333 | 1.59282205603655 | 1.59190879015272 | true | false | false | true | ||||||||||||||||
| 1d332cba-2eef-423a-a7bc-ae68ee8510e5 | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | AXTI | AXTI260821C00093000 | call | 93.0000 | 2026-08-21 | 4.1000 | 2.8000 | 4.2000 | 88.7600 | 40180.00 | 39770.00 | 0.00 | 98 | 17 | 98 | 241 | 0.406639004149378 | 1.60687689984592 | 1.57449585137498 | true | false | false | true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3741607477.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |