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 |
|---|
| 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 |
|---|
| 50392d18-19be-4b97-bd64-71ef9f3ad8c1 | 2026-09-25 15:52 | 2026-09-25 15:51 | 2026-09-25 15:51 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 5.0000 | 4.9500 | 5.0500 | 237.6050 | 12000.00 | 2000.00 | 500.00 | 24 | 6 | 3068 | 2694 | 1.13882702301411 | 0.73810682386623 | 0.73810682386623 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 52085649335.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:54:56.567521Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 712cfd17-8e83-4eeb-9b8c-6f95094d16a3 | 2026-09-25 12:09 | 2026-09-25 12:09 | 2026-09-25 12:09 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 5.5000 | 5.3500 | 5.6500 | 239.1400 | 24200.00 | 22550.00 | 1650.00 | 44 | 6 | 1968 | 2694 | 0.730512249443207 | 0.736089110886999 | 0.736089110886999 | false | false | false | true | ||||||||||||||||
| 5e6b88ce-af66-4057-9b33-8128c14406ac | 2026-09-25 11:52 | 2026-09-25 11:51 | 2026-09-25 11:51 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 4.1500 | 4.1500 | 4.5000 | 235.0000 | 13695.00 | 0.00 | 13695.00 | 33 | 7 | 1710 | 2694 | 0.634743875278396 | 0.716799559031191 | 0.716799559031191 | false | false | false | true | ||||||||||||||||
| e61f4ec4-b09e-40cb-b1aa-658aa4115e05 | 2026-09-25 10:03 | 2026-09-25 10:03 | 2026-09-25 10:03 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 5.8000 | 5.6000 | 5.8000 | 239.0350 | 37117.00 | 37117.00 | 0.00 | 64 | 8 | 937 | 2694 | 0.347809948032665 | 0.763441792002579 | 0.763441792002579 | true | false | false | true | ||||||||||||||||
| cd45ec3a-16cf-4af4-b69b-5c7b5aa1f629 | 2026-09-25 09:36 | 2026-09-25 09:36 | 2026-09-25 09:36 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 7.8500 | 7.7000 | 8.3500 | 242.7000 | 42365.00 | 17295.00 | 25070.00 | 54 | 7 | 416 | 2694 | 0.15441722345954 | 0.802466983277295 | 0.812087442527354 | true | false | false | true | ||||||||||||||||
| eaae719d-7891-4922-8971-0bcf0d6796a1 | 2026-09-24 13:01 | 2026-09-24 13:01 | 2026-09-24 13:01 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 11.0500 | 10.6500 | 11.0500 | 247.3400 | 41990.00 | 41990.00 | 0.00 | 38 | 11 | 2458 | 2504 | 0.981629392971246 | 0.83374748647453 | 0.83374748647453 | false | false | false | true | ||||||||||||||||
| 791cceb5-96a7-4cc7-a39b-b182e40ad2f1 | 2026-09-24 10:40 | 2026-09-24 10:40 | 2026-09-24 10:40 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 10.0000 | 9.6000 | 10.0500 | 245.0000 | 10005.00 | 10005.00 | 0.00 | 10 | 6 | 1753 | 2504 | 0.700079872204473 | 0.846445991215535 | 0.841901960821399 | false | false | false | true | ||||||||||||||||
| 8dfcde8d-0281-4623-9c0a-b5351249c94c | 2026-09-23 13:45 | 2026-09-23 13:45 | 2026-09-23 13:45 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 5.5000 | 5.2000 | 5.5000 | 232.0000 | 11000.00 | 11000.00 | 0.00 | 20 | 5 | 1091 | 2291 | 0.476211261457879 | 0.819229843731116 | 0.819229843731116 | false | false | false | true | ||||||||||||||||
| 6ac4cf99-beb3-44e5-b1db-98f06b432ba9 | 2026-09-23 12:52 | 2026-09-23 12:52 | 2026-09-23 12:52 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 4.6800 | 4.6000 | 4.8500 | 230.0800 | 15445.00 | 0.00 | 15445.00 | 33 | 5 | 921 | 2291 | 0.402007856831078 | 0.795947615647135 | 0.804206226584466 | false | false | false | true | ||||||||||||||||
| 1445735a-3968-4595-9058-731c154b88ab | 2026-09-22 09:38 | 2026-09-22 09:38 | 2026-09-22 09:38 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 11.0000 | 10.7500 | 11.0000 | 242.7000 | 18700.00 | 18700.00 | 0.00 | 17 | 6 | 536 | 1949 | 0.275012827090816 | 0.876637217284151 | 0.876637217284151 | false | false | false | true | ||||||||||||||||
| 09920ff2-7efb-4b68-84af-6ce49f3acea8 | 2026-09-21 14:45 | 2026-09-21 14:45 | 2026-09-21 14:45 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 9.0000 | 8.5500 | 9.0000 | 237.6399 | 10800.00 | 10800.00 | 0.00 | 12 | 10 | 2747 | 951 | 2.88853838065195 | 0.843817835659929 | 0.843817835659929 | true | false | false | true | ||||||||||||||||
| c66f78f5-d6f4-40ee-8246-d441161646a8 | 2026-09-21 12:17 | 2026-09-21 12:17 | 2026-09-21 12:17 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 6.9900 | 6.9500 | 7.4500 | 232.6600 | 50347.00 | 1430.00 | 48917.00 | 72 | 8 | 2146 | 951 | 2.25657202944269 | 0.830560263578637 | 0.836650832416077 | true | false | false | true | ||||||||||||||||
| fa036c6b-1d81-44d2-b69b-c284a524bddd | 2026-09-21 11:19 | 2026-09-21 11:19 | 2026-09-21 11:19 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 8.0000 | 7.7000 | 8.2500 | 234.5800 | 13607.00 | 13607.00 | 0.00 | 17 | 12 | 1785 | 951 | 1.87697160883281 | 0.857313948951947 | 0.85487311829386 | true | false | false | true | ||||||||||||||||
| 5db5221c-cee2-4007-9930-afd32d8fa182 | 2026-09-21 11:08 | 2026-09-21 11:08 | 2026-09-21 11:08 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 7.0000 | 6.6500 | 7.0000 | 232.1800 | 10500.00 | 10500.00 | 0.00 | 15 | 6 | 1605 | 951 | 1.68769716088328 | 0.843574133695946 | 0.843574133695946 | false | false | false | true | ||||||||||||||||
| 8ad002ac-a2ff-4893-b7a4-24a37cb0b5fb | 2026-09-17 11:53 | 2026-09-17 11:53 | 2026-09-17 11:53 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 3.7000 | 3.5000 | 3.8500 | 213.6200 | 16280.00 | 16280.00 | 0.00 | 44 | 5 | 532 | 866 | 0.61431870669746 | 0.828480115875434 | 0.828480115875434 | false | false | false | true | ||||||||||||||||
| a0ca7f22-3a99-4fda-b99b-071e55cd2147 | 2026-09-17 09:45 | 2026-09-17 09:45 | 2026-09-17 09:45 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 4.2000 | 3.8500 | 4.6000 | 214.3000 | 16800.00 | 0.00 | 13860.00 | 40 | 8 | 208 | 866 | 0.240184757505774 | 0.853879062557884 | 0.857433867585945 | false | false | false | true | ||||||||||||||||
| ac6ae978-e6c3-4fb4-ae3d-a060b7bdcd1b | 2026-09-16 11:07 | 2026-09-16 11:07 | 2026-09-16 11:07 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 4.8000 | 4.4000 | 4.8000 | 218.1800 | 19200.00 | 19200.00 | 0.00 | 40 | 15 | 138 | 802 | 0.172069825436409 | 0.8093696274538 | 0.809357812464922 | true | false | false | true | ||||||||||||||||
| 752296bf-3128-44c9-9c05-747e6e3447c1 | 2026-09-16 11:07 | 2026-09-16 11:07 | 2026-09-16 11:07 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 4.8000 | 4.4000 | 4.8000 | 217.9200 | 14880.00 | 14880.00 | 0.00 | 31 | 9 | 92 | 802 | 0.114713216957606 | 0.817374128840152 | 0.813745929593341 | false | false | false | true | ||||||||||||||||
| 5e20b52a-09ab-441d-90e3-f237382875a3 | 2026-09-09 10:09 | 2026-09-09 10:09 | 2026-09-09 10:09 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 19.9500 | 19.5000 | 20.4000 | 245.0700 | 59841.00 | 1995.00 | 57846.00 | 30 | 8 | 289 | 302 | 0.956953642384106 | 0.901065668007907 | 0.892363520137853 | true | false | false | |||||||||||||||||
| 6d061e35-6ebd-4546-aca3-17017065b8bc | 2026-09-08 15:59 | 2026-09-08 15:59 | 2026-09-08 15:59 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 19.0300 | 19.0000 | 20.2000 | 243.8300 | 57080.00 | 0.00 | 26600.00 | 30 | 6 | 982 | 357 | 2.75070028011204 | 0.860411020616694 | 0.860411020616694 | false | false | false | true | ||||||||||||||||
| cfad1cb9-e29d-4b26-b391-112f7a78690b | 2026-09-04 10:00 | 2026-09-04 09:59 | 2026-09-04 09:59 | NBIS | NBIS261002C00250000 | call | 250.0000 | 2026-10-02 | 9.2000 | 7.6500 | 9.2000 | 216.7499 | 23000.00 | 23000.00 | 0.00 | 25 | 5 | 46 | 271 | 0.169741697416974 | 0.845788682692936 | 0.845788682692936 | false | false | false | true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 52085649335.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:10:39.655295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 52085649335.00 |
| — |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:56:11.622901Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 52085649335.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:04:05.801469Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 52085649335.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:37:30.150792Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 49732983592.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:03:43.722265Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 49732983592.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:44:10.025245Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 49732983592.00 |
| — |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:48:41.957434Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 49732983592.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:52:42.063868Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51820096579.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:39:02.678096Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51091472486.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:46:35.766190Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 51091472486.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:17:17.704519Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 51091472486.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:22:54.080611Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51091472486.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:08:57.828180Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 47841194533.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:59:42.981722Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 47841194533.00 |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 45949405475.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 45949405475.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:11:22.686371Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:30:57.501605Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 46568297023.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |