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 |
|---|
| 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 |
|---|
| b29de9cd-936d-4007-9505-5b0b6f9d3876 | 2026-09-23 15:18 | 2026-09-23 15:18 | 2026-09-23 15:18 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 3.4000 | 3.4000 | 3.5500 | 332.6200 | 17340.00 | 0.00 | 17340.00 | 51 | 28 | 2926 | 1552 | 1.88530927835052 | 0.961825183279189 | 0.962144340919826 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Technology | 353862214605.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T19:19:13.860823Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| e51e7dd2-3374-46e6-9b25-e2758576e533 | 2026-09-23 15:14 | 2026-09-23 15:14 | 2026-09-23 15:14 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 3.7000 | 3.5500 | 3.7000 | 333.7700 | 14800.00 | 14800.00 | 0.00 | 40 | 18 | 2771 | 1552 | 1.7854381443299 | 0.962672916757002 | 0.962672916757002 | false | false | false | true | ||||||||||||||||
| 144139f2-7352-436a-b1b0-2ae0374d8333 | 2026-09-22 15:13 | 2026-09-22 15:13 | 2026-09-22 15:13 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 3.9000 | 3.8500 | 4.0000 | 330.7400 | 68250.00 | 9360.00 | 58890.00 | 175 | 22 | 3435 | 1466 | 2.3431105047749 | 0.886165887281971 | 0.886165887281971 | false | false | false | true | ||||||||||||||||
| 4c96f31c-e371-452d-84ae-01816d256073 | 2026-09-22 14:01 | 2026-09-22 14:00 | 2026-09-22 14:00 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 3.6700 | 3.5500 | 4.0000 | 329.4800 | 14320.00 | 1490.00 | 8085.00 | 39 | 6 | 2879 | 1466 | 1.96384720327422 | 0.884285531266691 | 0.881979230802339 | false | false | false | true | ||||||||||||||||
| 4d7fdcea-89f5-4db6-8f15-7b91d2c83f40 | 2026-09-22 13:58 | 2026-09-22 13:58 | 2026-09-22 13:58 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 5.1000 | 5.1000 | 5.1500 | 334.0239 | 10200.00 | 0.00 | 10200.00 | 20 | 9 | 2805 | 1466 | 1.91336971350614 | 0.914474586173257 | 0.914474586173257 | false | false | false | true | ||||||||||||||||
| 67035da9-3c25-4fdb-a4a7-bb8f04fdcd5f | 2026-09-22 13:46 | 2026-09-22 13:46 | 2026-09-22 13:46 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 5.1000 | 5.1000 | 5.2500 | 334.2750 | 15300.00 | 0.00 | 15300.00 | 30 | 5 | 2502 | 1466 | 1.70668485675307 | 0.907284342207416 | 0.907284342207416 | false | false | false | true | ||||||||||||||||
| 453cdc14-f71c-4327-9876-cef0d8a89711 | 2026-09-22 13:40 | 2026-09-22 13:40 | 2026-09-22 13:40 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 4.7000 | 4.6000 | 4.7000 | 332.9200 | 21150.00 | 21150.00 | 0.00 | 45 | 26 | 2330 | 1466 | 1.5893587994543 | 0.907277307749293 | 0.907277307749293 | false | false | false | true | ||||||||||||||||
| 8288620a-41e9-4fb6-9753-5497ef44593c | 2026-09-22 13:33 | 2026-09-22 13:33 | 2026-09-22 13:33 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 4.5500 | 4.4500 | 4.6000 | 332.0000 | 10920.00 | 9100.00 | 1820.00 | 24 | 8 | 2223 | 1466 | 1.51637107776262 | 0.89655518900441 | 0.89655518900441 | false | false | false | true | ||||||||||||||||
| f5757553-33b9-4fce-b190-cd840d5797e4 | 2026-09-22 12:05 | 2026-09-22 12:05 | 2026-09-22 12:05 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 4.2500 | 4.2500 | 4.4500 | 330.5400 | 12760.00 | 860.00 | 11900.00 | 30 | 25 | 1901 | 1466 | 1.29672578444748 | 0.927587457013925 | 0.927587457013925 | false | false | false | true | ||||||||||||||||
| dec7f82e-4511-421a-a55f-ffb898062d59 | 2026-09-22 11:04 | 2026-09-22 11:04 | 2026-09-22 11:04 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 4.0000 | 3.8500 | 4.1500 | 328.5300 | 22400.00 | 8000.00 | 14400.00 | 56 | 11 | 1096 | 1466 | 0.747612551159618 | 0.954930157307557 | 0.954930157307557 | true | false | false | true | ||||||||||||||||
| 4cfd202e-05ae-49da-babd-941f0012f7ba | 2026-09-22 11:00 | 2026-09-22 11:00 | 2026-09-22 11:00 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 3.9000 | 3.7500 | 3.9000 | 328.0298 | 11310.00 | 11310.00 | 0.00 | 29 | 17 | 972 | 1466 | 0.663028649386085 | 0.957314720372149 | 0.957314720372149 | false | false | false | true | ||||||||||||||||
| a757d55d-a1af-4e24-a35c-db6f97051fa8 | 2026-09-21 15:39 | 2026-09-21 15:39 | 2026-09-21 15:39 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 4.0500 | 3.8000 | 4.0500 | 322.2400 | 13365.00 | 13365.00 | 0.00 | 33 | 18 | 3915 | 769 | 5.09102730819246 | 0.972271565006893 | 0.972271565006893 | true | false | false | true | ||||||||||||||||
| 34a33312-eeb7-4969-be4c-64642d93565d | 2026-09-21 13:21 | 2026-09-21 13:21 | 2026-09-21 13:21 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 3.3400 | 3.1500 | 3.4500 | 319.0000 | 10005.00 | 10005.00 | 0.00 | 30 | 8 | 3320 | 769 | 4.31729518855657 | 0.959501186803393 | 0.959501186803393 | false | false | false | true | ||||||||||||||||
| fe45f26d-16e2-451a-a7a6-77b4df065411 | 2026-09-21 13:04 | 2026-09-21 13:04 | 2026-09-21 13:04 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 3.2500 | 3.2500 | 3.4000 | 319.0050 | 27632.00 | 0.00 | 27632.00 | 85 | 11 | 3197 | 769 | 4.15734720416125 | 0.95919134061974 | 0.966829866492171 | false | false | false | true | ||||||||||||||||
| 6f6e5dd7-7f93-4030-9040-e90ee9a2bf60 | 2026-09-21 11:02 | 2026-09-21 11:02 | 2026-09-21 11:02 | ARM | ARM260925C00350000 | call | 350.0000 | 2026-09-25 | 2.8100 | 2.7500 | 2.8100 | 313.8677 | 14050.00 | 14050.00 | 0.00 | 50 | 26 | 2395 | 769 | 3.11443433029909 | 1.01457464396535 | 1.01457464396535 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 353862214605.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:19:13.860823Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 354543209966.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:17:07.798020Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Technology |
| 354543209966.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 354543209966.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 354543209966.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:49:14.593703Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 354543209966.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:49:14.593703Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 354543209966.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:40:26.166069Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Technology |
| 354543209966.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:07:35.242191Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 354543209966.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:05:44.724527Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 354543209966.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:00:53.883267Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 343583440871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Technology |
| 343583440871.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:24:56.111062Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 343583440871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:07:15.058898Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 343583440871.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:05:23.809831Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |