Simplify AnalyticsOptions flow alerts (market-wide)
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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 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 |
| 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 | 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-08-21T14:36:46.143381Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 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 | 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 |
| 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 | 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 |
| 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 | true | 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 |
| 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 |