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 |
|---|
| efb9b713-9721-4e1d-bc95-a0c7eecf84a8 | 2026-09-16 15:00 | 2026-09-16 15:00 | 2026-09-16 15:00 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 8.1000 | 7.9500 | 8.3000 | 332.1500 | 1076490.00 | 848880.00 | 1620.00 | 1329 | 8 | 2711 | 19934 | 0.135998796026889 | 0.33124185537621 | 0.34122263210644 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4851251373800.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 69c663cf-8455-439e-a3fc-5c72654735d7 | 2026-09-11 09:35 | 2026-09-11 09:35 | 2026-09-11 09:35 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 10.0000 | 9.7000 | 10.0000 | 332.0000 | 324000.00 | 324000.00 | 0.00 | 324 | 16 | 968 | 23064 | 0.0419701699618453 | 0.290174892262177 | 0.290174892262177 | false | false | false | true | ||||||||||||||||
| a1d0e64d-20c4-4d01-9286-66d2295df527 | 2026-09-10 12:43 | 2026-09-10 12:43 | 2026-09-10 12:43 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 5.0000 | 4.9000 | 5.0500 | 323.0000 | 123501.00 | 123501.00 | 0.00 | 247 | 12 | 17199 | 24545 | 0.700712976166225 | 0.282463246807294 | 0.282733323018949 | true | false | false | true | ||||||||||||||||
| f76fa7be-4150-40c2-b2a0-f9d57b1d49dc | 2026-09-10 12:37 | 2026-09-10 12:37 | 2026-09-10 12:37 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 4.7000 | 4.6500 | 4.8500 | 323.0000 | 184260.00 | 960.00 | 183300.00 | 392 | 24 | 16526 | 24545 | 0.673293949887961 | 0.281993522688134 | 0.290752065906895 | true | false | false | true | ||||||||||||||||
| 820e0064-9026-4a63-9097-d36086659118 | 2026-09-10 11:20 | 2026-09-10 11:20 | 2026-09-10 11:20 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 3.8500 | 3.7500 | 3.8500 | 321.8900 | 187110.00 | 187110.00 | 0.00 | 486 | 9 | 11370 | 24545 | 0.463230800570381 | 0.269515666730813 | 0.269515666730813 | true | false | false | true | ||||||||||||||||
| 6dae4008-857c-49ac-b57d-21b821e2e79e | 2026-09-09 13:01 | 2026-09-09 13:01 | 2026-09-09 13:01 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 2.4800 | 2.4700 | 2.5300 | 314.0000 | 124248.00 | 0.00 | 124248.00 | 501 | 33 | 8950 | 21692 | 0.412594504886594 | 0.313839473626105 | 0.313839473626105 | false | false | false | true | ||||||||||||||||
| 63d456ea-b23c-441f-9dc8-c5a0e06b2831 | 2026-09-09 12:53 | 2026-09-09 12:53 | 2026-09-09 12:53 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 2.2900 | 2.2900 | 2.3200 | 313.0000 | 114500.00 | 0.00 | 114500.00 | 500 | 30 | 8337 | 21692 | 0.384335238797713 | 0.31523066980199 | 0.31523066980199 | false | false | false | true | ||||||||||||||||
| beaf729f-b998-4545-b76c-51f1c647fbd7 | 2026-09-09 09:31 | 2026-09-09 09:31 | 2026-09-09 09:31 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 2.9000 | 2.8800 | 2.9900 | 315.7900 | 218624.00 | 0.00 | 218624.00 | 754 | 6 | 878 | 21692 | 0.0404757514290983 | 0.317384619853732 | 0.318549286965322 | true | false | false | true | ||||||||||||||||
| 5a56f860-1edf-4957-aeca-61497e259618 | 2026-09-08 15:59 | 2026-09-08 15:59 | 2026-09-08 15:59 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 2.9300 | 2.9000 | 2.9500 | 315.8900 | 193673.00 | 138589.00 | 46294.00 | 661 | 30 | 8474 | 19825 | 0.427440100882724 | 0.301626504754798 | 0.301709062673945 | false | false | false | true | ||||||||||||||||
| 4457365b-6b41-434b-bbae-07a5982a0f50 | 2026-09-03 11:10 | 2026-09-03 11:10 | 2026-09-03 11:10 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 10.5000 | 10.3000 | 10.5500 | 330.5600 | 174300.00 | 174300.00 | 0.00 | 166 | 5 | 2023 | 20387 | 0.0992299014077598 | 0.266459830829021 | 0.266459830829021 | false | false | false | true | ||||||||||||||||
| 9afd9cd4-7fdc-4a74-96d8-ac12b2ddc840 | 2026-09-03 10:38 | 2026-09-03 10:37 | 2026-09-03 10:37 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 9.6000 | 9.4500 | 9.6000 | 329.0800 | 192000.00 | 192000.00 | 0.00 | 200 | 18 | 1658 | 20387 | 0.08132633540982 | 0.267648118686709 | 0.267648118686709 | false | false | false | true | ||||||||||||||||
| 79dcbdc9-bf50-483b-94f5-5733f8f63acc | 2026-09-01 11:48 | 2026-09-01 11:48 | 2026-09-01 11:48 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 8.0000 | 7.8000 | 8.0000 | 325.8800 | 164800.00 | 164800.00 | 0.00 | 206 | 7 | 7554 | 22171 | 0.340715348879166 | 0.259048219584079 | 0.259048219584079 | true | false | false | true | ||||||||||||||||
| e9815497-f439-43f8-b7c4-6df6b17df669 | 2026-09-01 11:02 | 2026-09-01 11:02 | 2026-09-01 11:02 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 6.8300 | 6.7500 | 6.9500 | 323.8600 | 1727480.00 | 902445.00 | 825035.00 | 2528 | 59 | 6166 | 22171 | 0.27811104596094 | 0.253566127722594 | 0.253742968703451 | false | false | false | true | ||||||||||||||||
| eb7835aa-0e73-4a00-8d34-bbdf0f10fbf9 | 2026-09-01 10:33 | 2026-09-01 10:33 | 2026-09-01 10:33 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 8.0000 | 7.9000 | 8.0000 | 325.7400 | 168800.00 | 168800.00 | 0.00 | 211 | 9 | 3022 | 22171 | 0.136304181137522 | 0.261957738821204 | 0.261764386151582 | false | false | false | true | ||||||||||||||||
| 9770b5fb-1a32-4443-9a12-f06d7f8532fc | 2026-09-01 10:13 | 2026-09-01 10:13 | 2026-09-01 10:13 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 6.7500 | 6.6500 | 6.7500 | 323.4200 | 170775.00 | 170775.00 | 0.00 | 253 | 15 | 1651 | 22171 | 0.0744666456181498 | 0.261146563940185 | 0.259743061707807 | true | false | false | true | ||||||||||||||||
| 121ec633-448a-4e58-a2cb-efe6e411f580 | 2026-08-24 12:46 | 2026-08-24 12:46 | 2026-08-24 12:46 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 3.7000 | 3.6500 | 3.7000 | 312.6100 | 802530.00 | 802530.00 | 0.00 | 2169 | 23 | 5146 | 20623 | 0.249527226882607 | 0.247277255131297 | 0.247172058277219 | false | false | false | true | ||||||||||||||||
| 87888f37-7d7f-4b5f-8bb8-43dfb1a79511 | 2026-08-24 12:46 | 2026-08-24 12:46 | 2026-08-24 12:46 | AAPL | AAPL260918C00325000 | call | 325.0000 | 2026-09-18 | 3.6500 | 3.5500 | 3.7000 | 312.5495 | 711710.00 | 684700.00 | 27010.00 | 1950 | 65 | 2567 | 20623 | 0.124472676138292 | 0.246719270102789 | 0.246043295339142 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:37:33.609039Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T17:02:16.286608Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T17:02:16.286608Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T15:21:12.723015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:12:38.137640Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:40:26.963433Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T16:07:53.122506Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T15:18:08.991662Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:20:18.853903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:17:38.633077Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4861029474400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:17:38.633077Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |