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 |
|---|
| fca38bf5-f9a5-4406-b3e7-4a40432390ea | 2026-09-28 13:38 | 2026-09-28 13:38 | 2026-09-28 13:38 | AMD | AMD261120C00670000 | call | 670.0000 | 2026-11-20 | 30.1000 | 30.0500 | 30.1000 | 605.0000 | 192640.00 | 87290.00 | 0.00 | 64 | 6 | 162 | 1056 | 0.153409090909091 | 0.571175405844526 | 0.571175405844526 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 992332603781.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T17:41:35.586557Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 76978295-e951-4996-822e-cf34e16a7b33 | 2026-09-24 15:13 | 2026-09-24 15:13 | 2026-09-24 15:13 | AMD | AMD261120C00670000 | call | 670.0000 | 2026-11-20 | 41.3800 | 40.7000 | 41.5000 | 624.5600 | 28965.00 | 8295.00 | 20670.00 | 7 | 5 | 123 | 1003 | 0.122632103688933 | 0.589998650155016 | 0.587851977794807 | true | false | false | true | ||||||||||||||||
| 8db2ada6-5f11-4896-914a-5afc0c13a7a2 | 2026-09-24 12:44 | 2026-09-24 12:44 | 2026-09-24 12:44 | AMD | AMD261120C00670000 | call | 670.0000 | 2026-11-20 | 42.5000 | 41.3000 | 43.7000 | 627.5250 | 174230.00 | 4225.00 | 170005.00 | 41 | 9 | 66 | 1003 | 0.06580259222333 | 0.586185446548235 | 0.58420200915891 | true | false | false | true | ||||||||||||||||
| 27798c22-c38a-4938-8c5f-7eb27582abfa | 2026-09-24 12:26 | 2026-09-24 12:26 | 2026-09-24 12:26 | AMD | AMD261120C00670000 | call | 670.0000 | 2026-11-20 | 37.9900 | 37.6500 | 38.0500 | 619.0400 | 22795.00 | 15200.00 | 7595.00 | 6 | 6 | 16 | 1003 | 0.0159521435692921 | 0.578137533735717 | 0.578137533735717 | true | false | false | true | ||||||||||||||||
| 46558c75-9d67-495e-bcbf-871331448ee3 | 2026-09-21 15:23 | 2026-09-21 15:23 | 2026-09-21 15:23 | AMD | AMD261120C00670000 | call | 670.0000 | 2026-11-20 | 40.2500 | 40.1000 | 40.7000 | 613.7400 | 80495.00 | 4015.00 | 76480.00 | 20 | 6 | 437 | 636 | 0.687106918238994 | 0.608530489479229 | 0.607501718865077 | true | false | false | true | ||||||||||||||||
| 8928f331-3863-4055-ab43-2a7a1bb7ccad | 2026-09-21 10:50 | 2026-09-21 10:50 | 2026-09-21 10:50 | AMD | AMD261120C00670000 | call | 670.0000 | 2026-11-20 | 39.9000 | 39.7000 | 40.3500 | 611.6200 | 183525.00 | 0.00 | 179530.00 | 46 | 13 | 331 | 636 | 0.520440251572327 | 0.613329497898286 | 0.611968754964921 | true | false | false | true | ||||||||||||||||
| 0255d660-e65b-49e2-bd08-14bdebf514e2 | 2026-09-21 10:49 | 2026-09-21 10:49 | 2026-09-21 10:49 | AMD | AMD261120C00670000 | call | 670.0000 | 2026-11-20 | 40.0000 | 39.5500 | 40.2500 | 611.9900 | 40000.00 | 35995.00 | 4005.00 | 10 | 9 | 283 | 636 | 0.44496855345912 | 0.614105637552833 | 0.613999302200582 | true | false | false | true | ||||||||||||||||
| 6b743f30-a5d3-4f66-a708-e1bf7d4236cd | 2026-09-21 10:01 | 2026-09-21 10:01 | 2026-09-21 10:01 | AMD | AMD261120C00670000 | call | 670.0000 | 2026-11-20 | 38.6000 | 38.2500 | 39.1000 | 608.2350 | 582850.00 | 3850.00 | 579000.00 | 151 | 22 | 243 | 636 | 0.382075471698113 | 0.61498053041641 | 0.613935219342862 | true | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1003335485564.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:15:33.602136Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1003335485564.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:45:03.999525Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1003335485564.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:27:48.650295Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:25:50.208697Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:51:11.587541Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:51:11.587541Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:02:45.816631Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |