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 |
|---|
| e54e2555-419f-4acc-b39f-fa3bde7d848f | 2026-09-25 13:39 | 2026-09-25 13:39 | 2026-09-25 13:39 | CCJ | CCJ280121C00120000 | call | 120.0000 | 2028-01-21 | 10.9500 | 10.9500 | 11.4500 | 88.0000 | 139097.00 | 3315.00 | 135782.00 | 127 | 30 | 1554 | 1935 | 0.803100775193798 | 0.461902554985101 | 0.464420682844522 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 38350784122.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T17:41:26.046305Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 1d9cbd03-c905-4608-baf9-b76ecbb6e11e | 2026-09-25 13:35 | 2026-09-25 13:35 | 2026-09-25 13:35 | CCJ | CCJ280121C00120000 | call | 120.0000 | 2028-01-21 | 11.0300 | 11.0000 | 11.5000 | 88.0000 | 61740.00 | 1105.00 | 60635.00 | 56 | 24 | 1427 | 1935 | 0.737467700258398 | 0.462361422134017 | 0.462361422134017 | false | false | false | true | ||||||||||||||||
| c9329f8b-2ead-45ce-b37b-ac074133e286 | 2026-09-25 13:28 | 2026-09-25 13:28 | 2026-09-25 13:28 | CCJ | CCJ280121C00120000 | call | 120.0000 | 2028-01-21 | 11.0000 | 11.0000 | 11.4000 | 88.2400 | 82500.00 | 0.00 | 82500.00 | 75 | 14 | 1345 | 1935 | 0.695090439276486 | 0.462094716754276 | 0.462094716754276 | false | false | false | true | ||||||||||||||||
| 4890e266-cd33-455f-bf5b-b0dde4f8730a | 2026-09-25 13:24 | 2026-09-25 13:23 | 2026-09-25 13:23 | CCJ | CCJ280121C00120000 | call | 120.0000 | 2028-01-21 | 11.0600 | 11.0000 | 11.4000 | 88.3100 | 88495.00 | 7770.00 | 80725.00 | 80 | 21 | 1270 | 1935 | 0.656330749354005 | 0.461348223096318 | 0.463860188543935 | false | false | false | true | ||||||||||||||||
| b7d124e8-d0dd-4498-8f62-2fc2edddf544 | 2026-09-25 13:13 | 2026-09-25 13:13 | 2026-09-25 13:13 | CCJ | CCJ280121C00120000 | call | 120.0000 | 2028-01-21 | 11.1200 | 11.1000 | 11.5000 | 88.0000 | 87870.00 | 7840.00 | 80030.00 | 79 | 19 | 1107 | 1935 | 0.572093023255814 | 0.462631182043857 | 0.465137804486365 | false | false | false | true | ||||||||||||||||
| 2843a08d-447d-4248-a05b-26171acb0c1c | 2026-09-25 13:00 | 2026-09-25 13:00 | 2026-09-25 13:00 | CCJ | CCJ280121C00120000 | call | 120.0000 | 2028-01-21 | 10.9500 | 10.9500 | 11.4500 | 88.2550 | 27385.00 | 0.00 | 27385.00 | 25 | 11 | 958 | 1935 | 0.495090439276486 | 0.460677186955142 | 0.461934718944696 | false | false | false | true | ||||||||||||||||
| c2241b61-3d0b-43fd-ba48-224143534c42 | 2026-09-25 12:56 | 2026-09-25 12:55 | 2026-09-25 12:55 | CCJ | CCJ280121C00120000 | call | 120.0000 | 2028-01-21 | 11.0000 | 11.0000 | 11.4000 | 88.2100 | 83615.00 | 1110.00 | 82505.00 | 76 | 12 | 887 | 1935 | 0.458397932816537 | 0.462414769570323 | 0.464929802413643 | false | false | false | true | ||||||||||||||||
| 67bcdf2c-301f-4fd6-8d8d-cfb6659d32ce | 2026-09-25 12:49 | 2026-09-25 12:49 | 2026-09-25 12:49 | CCJ | CCJ280121C00120000 | call | 120.0000 | 2028-01-21 | 11.0000 | 11.0000 | 11.5000 | 88.1900 | 88030.00 | 2220.00 | 85810.00 | 80 | 21 | 811 | 1935 | 0.419121447028424 | 0.462628180538183 | 0.465143827540352 | false | false | false | true | ||||||||||||||||
| 6433a1b8-649e-468f-81aa-41e0ca5eec84 | 2026-09-25 12:35 | 2026-09-25 12:35 | 2026-09-25 12:35 | CCJ | CCJ280121C00120000 | call | 120.0000 | 2028-01-21 | 11.2000 | 11.2000 | 11.7000 | 88.5700 | 86242.00 | 0.00 | 86242.00 | 77 | 32 | 660 | 1935 | 0.341085271317829 | 0.463585360988211 | 0.463585360988211 | false | false | false | true | ||||||||||||||||
| 9bec442c-e963-4365-952b-cf6cf8e18685 | 2026-09-25 12:16 | 2026-09-25 12:16 | 2026-09-25 12:16 | CCJ | CCJ280121C00120000 | call | 120.0000 | 2028-01-21 | 11.3500 | 11.3500 | 11.8500 | 88.9500 | 78315.00 | 0.00 | 78315.00 | 69 | 22 | 429 | 1935 | 0.221705426356589 | 0.463258064590973 | 0.463258064590973 | false | false | false | true | ||||||||||||||||
| 4037cc68-6d51-4036-acde-94d2f319f5df | 2026-09-25 11:45 | 2026-09-25 11:45 | 2026-09-25 11:45 | CCJ | CCJ280121C00120000 | call | 120.0000 | 2028-01-21 | 11.2000 | 11.2000 | 11.9000 | 88.3600 | 77280.00 | 0.00 | 77280.00 | 69 | 6 | 74 | 1935 | 0.0382428940568475 | 0.465834305850774 | 0.465834305850774 | false | false | false | true | ||||||||||||||||
| 4955a2ec-737a-419e-a4ca-97da5ad205fa | 2026-08-17 11:56 | 2026-08-17 11:56 | 2026-08-17 11:56 | CCJ | CCJ280121C00120000 | call | 120.0000 | 2028-01-21 | 19.4500 | 17.9000 | 19.4500 | 100.5800 | 29175.00 | 29175.00 | 0.00 | 15 | 5 | 30 | 1799 | 0.0166759310728182 | 0.502451113442922 | 0.502451113442922 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 38350784122.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:41:26.046305Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 38350784122.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:33:28.969909Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 38350784122.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:33:28.969909Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 38350784122.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:23:42.010099Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 38350784122.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:04:49.737352Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 38350784122.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:59:29.985705Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 38350784122.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:52:03.026935Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 38350784122.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:38:20.208952Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 38350784122.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:18:06.291601Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 38350784122.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:46:29.692189Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |