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 | strike |
|---|
| expirydate |
|---|
| 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 |
|---|
| 3638c156-f543-403c-b23d-04456dc3a501 | 2026-09-04 15:58 | 2026-09-04 15:58 | 2026-09-04 15:58 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 3.2300 | 3.1000 | 3.2500 | 100.8050 | 1990003.00 | 1990003.00 | 0.00 | 6161 | 2 | 15324 | 5589 | 2.74181427804616 | 0.47166723587977 | 0.47166723587977 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | Common Stock | Energy | 40610811028.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T20:00:02.053596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 15949357-60c5-4907-bb77-b4f4d5017b93 | 2026-09-01 15:29 | 2026-09-01 15:29 | 2026-09-01 15:29 | CCJ | CCJ270617P00085000 | put | 85.0000 | 2027-06-17 | 9.2000 | 8.8500 | 10.0000 | 96.5500 | 230000.00 | 0.00 | 230000.00 | 250 | 1 | 250 | 126 | 1.98412698412698 | 0.486931004570565 | 0.486931004570565 | false | true | false | |||||||||||||||||
| 303c906d-1990-4d10-8783-31e301fe8a7d | 2026-08-28 10:10 | 2026-08-28 10:09 | 2026-08-28 10:09 | CCJ | CCJ261016C00125000 | call | 125.0000 | 2026-10-16 | 1.3600 | 1.2300 | 1.4200 | 102.2680 | 139672.00 | 139672.00 | 0.00 | 1027 | 1 | 1028 | 1532 | 0.671018276762402 | 0.483922445172878 | 0.483922445172878 | false | true | false | |||||||||||||||||
| c4c3d807-49bb-4e8d-9afa-308a1cfff7d8 | 2026-08-21 15:54 | 2026-08-21 15:54 | 2026-08-21 15:54 | CCJ | CCJ260918C00125000 | call | 125.0000 | 2026-09-18 | 0.6400 | 0.4000 | 0.7600 | 102.6200 | 96000.00 | 96000.00 | 0.00 | 1500 | 1 | 1523 | 1584 | 0.961489898989899 | 0.514845313962971 | 0.514845313962971 | false | true | false | |||||||||||||||||
| d83a85cd-9add-4285-9ac4-9aabee869d8d | 2026-08-21 10:32 | 2026-08-21 10:32 | 2026-08-21 10:32 | CCJ | CCJ270115C00100000 | call | 100.0000 | 2027-01-15 | 13.4000 | 13.0000 | 14.7000 | 100.2800 | 1340000.00 | 0.00 | 1340000.00 | 1000 | 2 | 1004 | 1257 | 0.798727128082737 | 0.497059177477769 | 0.497059177477769 | false | true | ||||||||||||||||||
| f3df78c9-12f8-42b3-b9d8-61d7d808e534 | 2026-08-18 12:55 | 2026-08-18 12:55 | 2026-08-18 12:55 | CCJ | CCJ260821P00080000 | put | 80.0000 | 2026-08-21 | 0.0100 | 0.0000 | 0.1800 | 95.8750 | 2257.00 | 0.00 | 2257.00 | 1505 | 2 | 17306 | 36619 | 0.472596193233021 | 0.778755291573971 | 0.778755291573971 | false | true | false |
| true |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T19:44:53.190071Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| false |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 2 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |