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 |
|---|
| 7f632446-5d2a-41b6-9d61-2879c5546f53 | 2026-09-23 15:57 | 2026-09-23 15:57 | 2026-09-23 15:57 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 0.2600 | 0.2600 | 0.2800 | 336.8700 | 15288.00 | 0.00 | 15288.00 | 588 | 13 | 13722 | 7280 | 1.88489010989011 | 0.293293491179911 | 0.293293491179911 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4918530543600.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T19:57:58.068578Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 591005e0-87c1-459a-b63e-95f508cb54ed | 2026-09-23 15:37 | 2026-09-23 15:37 | 2026-09-23 15:37 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 0.2200 | 0.2000 | 0.2200 | 336.5900 | 13152.00 | 13152.00 | 0.00 | 599 | 44 | 12661 | 7280 | 1.73914835164835 | 0.284820951648901 | 0.287847358266965 | false | false | false | true | ||||||||||||||||
| c7a3ee1f-409e-42b3-bb13-d29c3e83b163 | 2026-09-23 15:13 | 2026-09-23 15:13 | 2026-09-23 15:13 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 0.1800 | 0.1800 | 0.2000 | 336.5200 | 19057.00 | 100.00 | 18900.00 | 1058 | 51 | 11378 | 7280 | 1.56291208791209 | 0.276729899866552 | 0.276689320660181 | false | false | false | true | ||||||||||||||||
| 1eed5462-c470-4ebe-a32f-572f568946c2 | 2026-09-23 11:07 | 2026-09-23 11:07 | 2026-09-23 11:07 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 0.3000 | 0.3000 | 0.3200 | 337.9800 | 29970.00 | 0.00 | 29970.00 | 999 | 21 | 6238 | 7280 | 0.856868131868132 | 0.279508792252843 | 0.279173834502869 | false | false | false | true | ||||||||||||||||
| e8bbc988-62a0-4de4-93e9-5884df41aa1f | 2026-09-23 10:56 | 2026-09-23 10:56 | 2026-09-23 10:56 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 0.3500 | 0.3200 | 0.3500 | 338.1700 | 26250.00 | 26250.00 | 0.00 | 750 | 11 | 4707 | 7280 | 0.646565934065934 | 0.286419023882869 | 0.286419023882869 | false | false | false | true | ||||||||||||||||
| b30e18cd-13d9-4d1b-8798-6d37229ba982 | 2026-09-22 15:16 | 2026-09-22 15:16 | 2026-09-22 15:16 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 0.7500 | 0.7300 | 0.7500 | 340.1250 | 124800.00 | 124800.00 | 0.00 | 1664 | 43 | 18621 | 4658 | 3.99763847144697 | 0.251556743540126 | 0.251556743540126 | false | false | false | true | ||||||||||||||||
| e7b3591e-2bc5-4de6-965a-e5bc0e8c9eec | 2026-09-22 11:27 | 2026-09-22 11:27 | 2026-09-22 11:27 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 1.7200 | 1.6400 | 1.7800 | 343.0000 | 24424.00 | 516.00 | 22016.00 | 142 | 24 | 12497 | 4658 | 2.68291112065264 | 0.268396274659674 | 0.270120989031893 | true | false | false | true | ||||||||||||||||
| 66e7e32a-704a-4da0-b13d-e46ebbd16def | 2026-09-22 11:21 | 2026-09-22 11:21 | 2026-09-22 11:21 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 1.6700 | 1.6400 | 1.6700 | 343.2505 | 17201.00 | 17201.00 | 0.00 | 103 | 10 | 12052 | 4658 | 2.587376556462 | 0.267312443986947 | 0.267312443986947 | false | false | false | true | ||||||||||||||||
| 460b1047-63ba-43d0-9722-2011c3f79f7a | 2026-09-22 10:51 | 2026-09-22 10:51 | 2026-09-22 10:51 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 1.1800 | 1.1800 | 1.2500 | 341.4749 | 87084.00 | 0.00 | 87084.00 | 738 | 53 | 10380 | 4658 | 2.22842421640189 | 0.265346320530451 | 0.267736986722092 | false | false | false | true | ||||||||||||||||
| 08476e22-d87d-48ec-a6e5-6cd94b3e66b1 | 2026-09-22 10:16 | 2026-09-22 10:15 | 2026-09-22 10:15 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 0.8100 | 0.8100 | 0.8500 | 339.6500 | 287064.00 | 0.00 | 287064.00 | 3544 | 62 | 8223 | 4658 | 1.76534993559468 | 0.269548378243478 | 0.269548378243478 | false | false | false | true | ||||||||||||||||
| 6c0f1d9d-5852-4432-8beb-b5ed970791f0 | 2026-09-22 09:54 | 2026-09-22 09:54 | 2026-09-22 09:54 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 1.0400 | 1.0400 | 1.0800 | 340.8100 | 12484.00 | 0.00 | 12272.00 | 120 | 9 | 3598 | 4658 | 0.772434521253757 | 0.26923676448273 | 0.271415290669967 | false | false | false | true | ||||||||||||||||
| 4bf7ff66-3044-46e8-b3fc-a829225d6731 | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 1.4000 | 1.2500 | 1.4000 | 341.5600 | 15945.00 | 15945.00 | 0.00 | 114 | 8 | 396 | 4658 | 0.0850150279089738 | 0.291270376705433 | 0.287773715841845 | true | false | false | true | ||||||||||||||||
| a1a9cac8-5d5a-48de-95b8-a7ac05e26e7e | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 1.1700 | 1.0600 | 1.1900 | 340.7100 | 19035.00 | 14754.00 | 4281.00 | 163 | 18 | 204 | 4658 | 0.0437956204379562 | 0.281419471120519 | 0.285677177259042 | true | false | false | true | ||||||||||||||||
| a2546a48-b98a-40eb-8238-e9c34a1a136a | 2026-09-21 15:29 | 2026-09-21 15:29 | 2026-09-21 15:29 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 0.9200 | 0.8800 | 0.9200 | 339.5500 | 21160.00 | 21160.00 | 0.00 | 230 | 7 | 6812 | 2704 | 2.51923076923077 | 0.246580707783832 | 0.246184736375264 | false | false | false | true | ||||||||||||||||
| 2d92a230-2faa-4b7e-94aa-d0b8eaef47f9 | 2026-09-21 12:14 | 2026-09-21 12:14 | 2026-09-21 12:14 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 0.7300 | 0.7300 | 0.7800 | 338.5800 | 17301.00 | 0.00 | 17301.00 | 237 | 13 | 4335 | 2704 | 1.60318047337278 | 0.244189201669143 | 0.244189201669143 | false | false | false | true | ||||||||||||||||
| 32ca7f51-6fac-4a9e-aa9e-9bed1a53f5a0 | 2026-09-21 12:13 | 2026-09-21 12:13 | 2026-09-21 12:13 | AAPL | AAPL260925C00347500 | call | 347.5000 | 2026-09-25 | 0.7600 | 0.7300 | 0.7700 | 338.6600 | 21204.00 | 19076.00 | 2128.00 | 279 | 31 | 3939 | 2704 | 1.45673076923077 | 0.246118104077499 | 0.246118104077499 | true | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:42:45.926021Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| 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 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:09:03.866421Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:57:22.994560Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:29:11.777432Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:21:55.684470Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:17:46.082263Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:56:25.927111Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:31:35.812482Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:30:37.895663Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| 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 |