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 |
|---|
| 890a46fe-6b1e-48ce-a65c-79155d27df9c | 2026-08-21 09:38 | 2026-08-21 09:38 | 2026-08-21 09:38 | UUUU | UUUU260918C00018000 | call | 18.0000 | 2026-09-18 | 0.4300 | 0.3600 | 0.4300 | 15.1500 | 13350.00 | 13350.00 | 0.00 | 311 | 24 | 568 | 4797 | 0.118407337919533 | 0.773504782068898 | 0.765934485384585 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 3084568100.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 58d0e740-825b-4b3f-9a11-348095639d1f | 2026-08-20 15:26 | 2026-08-20 15:26 | 2026-08-20 15:26 | UUUU | UUUU260918C00015000 | call | 15.0000 | 2026-09-18 | 0.6300 | 0.6300 | 0.6400 | 13.7550 | 12726.00 | 0.00 | 12726.00 | 202 | 10 | 321 | 1591 | 0.201759899434318 | 0.701656648425291 | 0.701656648425291 | false | false | false | true | ||||||||||||||||
| eaa270c7-e6a3-4a6b-8126-00be81bc327d | 2026-08-20 13:29 | 2026-08-20 13:29 | 2026-08-20 13:29 | UUUU | UUUU260821C00014000 | call | 14.0000 | 2026-08-21 | 0.2000 | 0.1900 | 0.2400 | 13.8650 | 10000.00 | 4560.00 | 4800.00 | 500 | 6 | 679 | 2995 | 0.226711185308848 | 0.898505412487562 | 0.898505412487562 | false | false | false | |||||||||||||||||
| c8b9e3e9-ce0b-42c9-9df4-4e5adcce23f9 | 2026-08-20 13:13 | 2026-08-20 13:13 | 2026-08-20 13:13 | UUUU | UUUU261016C00014000 | call | 14.0000 | 2026-10-16 | 1.6100 | 1.6100 | 1.6900 | 13.9716 | 16100.00 | 0.00 | 16100.00 | 100 | 17 | 113 | 891 | 0.12682379349046 | 0.722314552038073 | 0.722314552038073 | false | false | false | true | ||||||||||||||||
| 10e6e255-a670-4efa-a981-5477b394e513 | 2026-08-20 12:06 | 2026-08-20 12:06 | 2026-08-20 12:06 | UUUU | UUUU261120C00020000 | call | 20.0000 | 2026-11-20 | 0.6200 | 0.6000 | 0.6800 | 13.9301 | 32486.00 | 123.00 | 32363.00 | 524 | 37 | 591 | 1173 | 0.50383631713555 | 0.76633133274299 | 0.762756242582639 | true | false | false | true | ||||||||||||||||
| 05dec19b-c71d-41d7-94a5-ab39b3d3037b | 2026-08-20 11:45 | 2026-08-20 11:45 | 2026-08-20 11:45 | UUUU | UUUU270115C00012000 | call | 12.0000 | 2027-01-15 | 3.7000 | 3.7000 | 3.8000 | 13.9534 | 18500.00 | 0.00 | 18500.00 | 50 | 6 | 223 | 2765 | 0.0806509945750452 | 0.767911372404136 | 0.767911372404136 | false | false | false | true | ||||||||||||||||
| 989d1dd6-666e-41b0-95f7-aea7e3f088c3 | 2026-08-19 15:46 | 2026-08-19 15:45 | 2026-08-19 15:45 | UUUU | UUUU280121C00030000 | call | 30.0000 | 2028-01-21 | 2.9200 | 2.9200 | 3.0000 | 14.9550 | 13724.00 | 0.00 | 13724.00 | 47 | 6 | 68 | 39396 | 0.00172606355975226 | 0.81910353900833 | 0.81910353900833 | false | false | false | true | ||||||||||||||||
| d1a872c2-9ccd-4115-a58a-b4fdfcbfd190 | 2026-08-19 14:50 | 2026-08-19 14:50 | 2026-08-19 14:50 | UUUU | UUUU261120P00014000 | put | 14.0000 | 2026-11-20 | 1.7300 | 1.7300 | 1.7900 | 14.8395 | 16089.00 | 0.00 | 16089.00 | 93 | 9 | 94 | 831 | 0.113116726835138 | 0.760639615654836 | 0.760639615654836 | false | false | false | true | ||||||||||||||||
| 1a26de20-ecce-48d6-a6f5-0e9220f41e4f | 2026-08-19 13:50 | 2026-08-19 13:50 | 2026-08-19 13:50 | UUUU | UUUU261120C00020000 | call | 20.0000 | 2026-11-20 | 0.8400 | 0.8400 | 0.9000 | 14.7250 | 11424.00 | 0.00 | 11424.00 | 136 | 19 | 155 | 1080 | 0.143518518518519 | 0.768855264742744 | 0.768855264742744 | false | false | false | true | ||||||||||||||||
| c84bdffa-c8bf-4682-b999-e0ca4587de53 | 2026-08-19 12:37 | 2026-08-19 12:37 | 2026-08-19 12:37 | UUUU | UUUU260821C00015000 | call | 15.0000 | 2026-08-21 | 0.2500 | 0.2400 | 0.2900 | 14.7850 | 15375.00 | 400.00 | 14975.00 | 615 | 39 | 817 | 3665 | 0.222919508867667 | 0.7861738317391 | 0.7861738317391 | true | false | false | true | ||||||||||||||||
| 8213a75f-5773-4bbe-a003-6f2676b8ed54 | 2026-08-19 12:11 | 2026-08-19 12:11 | 2026-08-19 12:11 | UUUU | UUUU261120P00012000 | put | 12.0000 | 2026-11-20 | 0.9100 | 0.9100 | 0.9900 | 14.8650 | 42497.00 | 0.00 | 42497.00 | 467 | 16 | 515 | 453 | 1.13686534216336 | 0.776144326023327 | 0.776144326023327 | false | false | false | true | ||||||||||||||||
| 2b2e5342-90fe-4f31-85bd-12e701e09b29 | 2026-08-19 11:07 | 2026-08-19 11:07 | 2026-08-19 11:07 | UUUU | UUUU261120C00018000 | call | 18.0000 | 2026-11-20 | 1.2900 | 1.2900 | 1.3400 | 14.8100 | 53406.00 | 0.00 | 53406.00 | 414 | 20 | 425 | 1860 | 0.228494623655914 | 0.772336382487945 | 0.772336382487945 | false | false | false | |||||||||||||||||
| 0516a70c-6ed1-434e-8721-7f9c3cd356a7 | 2026-08-19 10:51 | 2026-08-19 10:51 | 2026-08-19 10:51 | UUUU | UUUU260828C00014000 | call | 14.0000 | 2026-08-28 | 1.1300 | 1.0300 | 1.1300 | 14.7516 | 11274.00 | 8362.00 | 2912.00 | 100 | 8 | 169 | 679 | 0.248895434462445 | 0.756512100077418 | 0.744183793842032 | false | false | false | |||||||||||||||||
| 26c22a84-5ba3-438c-a1b6-d49ed86d24fb | 2026-08-18 13:36 | 2026-08-18 13:36 | 2026-08-18 13:36 | UUUU | UUUU261120C00014000 | call | 14.0000 | 2026-11-20 | 2.3100 | 2.3100 | 2.4200 | 14.1650 | 10626.00 | 0.00 | 10626.00 | 46 | 17 | 50 | 2914 | 0.0171585449553878 | 0.764165326108794 | 0.764165326108794 | false | false | false | true | ||||||||||||||||
| 1e166909-a3b6-4b1e-a6d6-0f6009eb7dd1 | 2026-08-17 14:53 | 2026-08-17 14:53 | 2026-08-17 14:53 | UUUU | UUUU261016C00018000 | call | 18.0000 | 2026-10-16 | 0.7800 | 0.7800 | 0.8000 | 14.8050 | 43368.00 | 0.00 | 43368.00 | 556 | 10 | 716 | 2193 | 0.326493388052896 | 0.739105746486092 | 0.740584677634275 | false | false | false | |||||||||||||||||
| a3438c87-76d9-440e-bc26-c44b7c9b3406 | 2026-08-17 11:26 | 2026-08-17 11:26 | 2026-08-17 11:26 | UUUU | UUUU261016C00018000 | call | 18.0000 | 2026-10-16 | 0.8500 | 0.8500 | 0.9000 | 14.9950 | 11135.00 | 0.00 | 11135.00 | 131 | 12 | 138 | 2193 | 0.0629274965800274 | 0.74447035845087 | 0.74447035845087 | false | false | false | true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 3084568100.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |