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 |
|---|
| 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 |
|---|
| b2e452b7-aef9-4a6b-9e60-38a5d678782c | 2026-09-30 15:55 | 2026-09-30 15:55 | 2026-09-30 15:55 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.6600 | 0.6400 | 0.6600 | 10.3150 | 18018.00 | 7260.00 | 0.00 | 273 | 5 | 6119 | 43073 | 0.142061151997771 | 0.539190327783265 | 0.539190327783265 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 10893552463.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T19:56:14.102421Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| 4b598be7-7447-4e47-8c75-c631274413ce | 2026-09-30 15:55 | 2026-09-30 15:55 | 2026-09-30 15:55 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.6600 | 0.6000 | 0.6600 | 10.3000 | 66000.00 | 66000.00 | 0.00 | 1000 | 11 | 5515 | 43073 | 0.128038446358508 | 0.54182738068682 | 0.54182738068682 | false | false | false | true | ||||||||||||||||
| ab052057-2ed7-473f-96b2-270bb0ded325 | 2026-09-30 15:36 | 2026-09-30 15:36 | 2026-09-30 15:36 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.7000 | 0.7000 | 0.7500 | 10.3950 | 75880.00 | 0.00 | 75880.00 | 1084 | 15 | 3881 | 43073 | 0.090102848652288 | 0.543810270986329 | 0.543810270986329 | false | false | false | true | ||||||||||||||||
| 66fc6608-65af-4016-a7cf-028e0487301e | 2026-09-30 15:36 | 2026-09-30 15:36 | 2026-09-30 15:36 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.7000 | 0.6700 | 0.7400 | 10.4197 | 19810.00 | 3990.00 | 7980.00 | 283 | 5 | 2797 | 43073 | 0.0649362709818216 | 0.539406430073013 | 0.539406430073013 | false | false | false | true | ||||||||||||||||
| cdaae2e6-1c0d-4601-a481-2622c62782ed | 2026-09-30 09:33 | 2026-09-30 09:33 | 2026-09-30 09:33 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.6700 | 0.6700 | 0.7000 | 10.2950 | 11390.00 | 0.00 | 11390.00 | 170 | 5 | 223 | 43073 | 0.00517725721449632 | 0.547453503258093 | 0.547453503258093 | false | false | false | true | ||||||||||||||||
| 8d74b85e-babf-43ef-b006-9945ba8199cb | 2026-09-29 09:56 | 2026-09-29 09:56 | 2026-09-29 09:56 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.6600 | 0.6600 | 0.7100 | 10.2550 | 287562.00 | 0.00 | 287562.00 | 4357 | 33 | 12272 | 32360 | 0.379233621755253 | 0.546883655382276 | 0.546883655382276 | false | false | false | |||||||||||||||||
| 18cde5ad-60be-48c6-b337-6586c7979636 | 2026-09-29 09:44 | 2026-09-29 09:43 | 2026-09-29 09:43 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.6500 | 0.6500 | 0.7200 | 10.2350 | 111345.00 | 0.00 | 111345.00 | 1713 | 24 | 7366 | 32360 | 0.227626699629172 | 0.545613517207523 | 0.545613517207523 | false | false | false | |||||||||||||||||
| ec900d6d-e613-44aa-b6d8-c2f6c1a59cbe | 2026-09-29 09:42 | 2026-09-29 09:42 | 2026-09-29 09:42 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.6500 | 0.6500 | 0.6600 | 10.2150 | 78836.00 | 20856.00 | 57980.00 | 1208 | 22 | 4899 | 32360 | 0.151390605686032 | 0.5491038992881 | 0.553890253323762 | false | false | false | |||||||||||||||||
| 6573ef8b-a902-445b-bef0-a164c2416aaf | 2026-09-29 09:42 | 2026-09-29 09:42 | 2026-09-29 09:42 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.6500 | 0.6400 | 0.6500 | 10.2200 | 17225.00 | 13780.00 | 0.00 | 265 | 5 | 3691 | 32360 | 0.114060568603214 | 0.548231215381167 | 0.548231215381167 | false | false | false | true | ||||||||||||||||
| 57e680d9-7496-48a6-8a11-f3add99cab1a | 2026-09-29 09:42 | 2026-09-29 09:42 | 2026-09-29 09:42 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.6600 | 0.6600 | 0.6700 | 10.2200 | 43494.00 | 0.00 | 43494.00 | 659 | 12 | 3426 | 32360 | 0.105871446229913 | 0.549510702437935 | 0.553014222215651 | false | false | false | true | ||||||||||||||||
| fa402233-94a2-4f3b-bfea-96baf92edc29 | 2026-09-29 09:42 | 2026-09-29 09:42 | 2026-09-29 09:42 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.6600 | 0.6600 | 0.6700 | 10.2250 | 15972.00 | 0.00 | 15972.00 | 242 | 18 | 2767 | 32360 | 0.0855067985166873 | 0.552138253068882 | 0.552138253068882 | false | false | false | true | ||||||||||||||||
| b6f251ac-f9a7-40f9-94a5-5c203a28d63e | 2026-09-29 09:42 | 2026-09-29 09:42 | 2026-09-29 09:42 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.6700 | 0.6700 | 0.7200 | 10.2200 | 71020.00 | 0.00 | 71020.00 | 1060 | 18 | 2525 | 32360 | 0.0780284301606922 | 0.555150534068365 | 0.557788201678598 | false | false | false | |||||||||||||||||
| 6302d01c-ae2b-45b6-99b6-f50d76ae2a32 | 2026-09-29 09:42 | 2026-09-29 09:42 | 2026-09-29 09:42 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.6600 | 0.6500 | 0.7300 | 10.2200 | 25806.00 | 5148.00 | 15180.00 | 391 | 6 | 1465 | 32360 | 0.0452719406674907 | 0.553014222215651 | 0.553014222215651 | false | false | false | |||||||||||||||||
| 844e38d0-53e0-4ec6-8bea-9ea7cc5dabd8 | 2026-09-29 09:41 | 2026-09-29 09:41 | 2026-09-29 09:41 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.6800 | 0.6500 | 0.7400 | 10.2568 | 73032.00 | 56372.00 | 4012.00 | 1074 | 11 | 1074 | 32360 | 0.0331891223733004 | 0.556059174209222 | 0.556059174209222 | false | false | false | |||||||||||||||||
| a839fc36-2e0a-4268-8c8b-09fd4b1e1965 | 2026-09-28 12:35 | 2026-09-28 12:35 | 2026-09-28 12:35 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.7100 | 0.7000 | 0.7500 | 10.2006 | 21087.00 | 639.00 | 14342.00 | 297 | 8 | 502 | 32205 | 0.0155876416705481 | 0.577463238281819 | 0.577463238281819 | false | false | false | true | ||||||||||||||||
| 8a896447-297b-40e9-ac66-44477baebacd | 2026-08-24 11:15 | 2026-08-24 11:15 | 2026-08-24 11:15 | PSKY | PSKY270115C00012000 | call | 12.0000 | 2027-01-15 | 0.8500 | 0.8100 | 0.9300 | 10.2950 | 20230.00 | 11815.00 | 8415.00 | 238 | 6 | 243 | 29798 | 0.00815490972548493 | 0.540575300086338 | 0.540575300086338 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 10893552463.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:56:14.102421Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 10893552463.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:37:24.384434Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 10893552463.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:37:24.384434Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 10893552463.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:34:41.867394Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 10893552463.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:56:35.860979Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 10893552463.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:46:07.678707Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 10893552463.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:44:04.459232Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 10893552463.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:44:04.459232Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 10893552463.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:44:04.459232Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 10893552463.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:44:04.459232Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 10893552463.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:44:04.459232Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 10893552463.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:44:04.459232Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 10893552463.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:42:07.664429Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 11209781714.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:39:53.834597Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 11853144672.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:29:12.492303Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |