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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| dc07c2dd-96a0-48ea-b728-f720d7237c30 | 2026-09-16 15:53 | 2026-09-16 15:53 | 2026-09-16 15:53 | CG | CG260918P00040000 | put | 40.0000 | 2026-09-18 | 0.7000 | 0.5500 | 0.7000 | 39.0000 | 12670.00 | 12670.00 | 0.00 | 181 | 14 | 4235 | 31109 | 0.136134237680414 | 0.55819748993973 | 0.55819748993973 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 14256875248.00 | 2026-11-06 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 204a6e7c-8098-4c0a-9fdd-1117b07de680 | 2026-09-16 15:53 | 2026-09-16 15:53 | 2026-09-16 15:53 | CG | CG260918P00040000 | put | 40.0000 | 2026-09-18 | 0.7000 | 0.5500 | 0.7000 | 39.0000 | 31780.00 | 31780.00 | 0.00 | 454 | 24 | 4790 | 31109 | 0.153974733999807 | 0.55819748993973 | 0.55819748993973 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 14256875248.00 | 2026-11-06 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 7f1816aa-0a12-40eb-81d1-92d122408456 | 2026-09-16 15:54 | 2026-09-16 15:53 | 2026-09-16 15:53 | CG | CG260918P00040000 | put | 40.0000 | 2026-09-18 | 0.7000 | 0.5500 | 0.7000 | 39.0000 | 27860.00 | 27860.00 | 0.00 | 398 | 12 | 5323 | 31109 | 0.171108039474107 | 0.553844150500478 | 0.553844150500478 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 14256875248.00 | 2026-11-06 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| ffab4a85-98ce-4512-acd7-1e1a3576b1af | 2026-09-16 15:54 | 2026-09-16 15:54 | 2026-09-16 15:54 | CG | CG260918P00040000 | put | 40.0000 | 2026-09-18 | 0.7500 | 0.5500 | 0.7500 | 39.0000 | 30750.00 | 30750.00 | 0.00 | 410 | 16 | 5749 | 31109 | 0.184801825838182 | 0.591943368461537 | 0.591943368461537 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 14256875248.00 | 2026-11-06 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 19b05bdb-69d3-4c13-b1b7-2347e7569e65 | 2026-09-17 11:01 | 2026-09-17 11:01 | 2026-09-17 11:01 | CG | CG261120P00035000 | put | 35.0000 | 2026-11-20 | 1.0100 | 1.0000 | 1.1000 | 40.5950 | 140390.00 | 0.00 | 111200.00 | 1390 | 2 | 1408 | 39 | 36.1025641025641 | 0.50196158378798 | 0.50196158378798 | false | true | false | true | true | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 14313888496.00 | 2026-11-06 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:02:25.509626Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 0aa23e94-acdd-4e30-81bd-9a7e890ca88a | 2026-09-17 12:16 | 2026-09-17 12:16 | 2026-09-17 12:16 | CG | CG261120C00042500 | call | 42.5000 | 2026-11-20 | 2.3500 | 2.3000 | 2.3500 | 40.6500 | 133940.00 | 133940.00 | 0.00 | 570 | 38 | 644 | 30 | 21.4666666666667 | 0.442855329870909 | 0.442855329870909 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 14313888496.00 | 2026-11-06 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T16:22:15.429007Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 107a0d25-5160-4fd7-8aa3-61c3eb156d3d | 2026-09-17 13:26 | 2026-09-17 13:25 | 2026-09-17 13:25 | CG | CG261120C00042500 | call | 42.5000 | 2026-11-20 | 2.2000 | 2.1500 | 2.3000 | 40.3000 | 18700.00 | 15400.00 | 3300.00 | 85 | 19 | 764 | 30 | 25.4666666666667 | 0.443863245665887 | 0.443863245665887 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 14313888496.00 | 2026-11-06 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 45102226-7bc3-402e-b622-da7a86e549fc | 2026-09-17 15:45 | 2026-09-17 15:45 | 2026-09-17 15:45 | CG | CG270115P00037500 | put | 37.5000 | 2027-01-15 | 2.6000 | 2.5500 | 2.6000 | 40.2900 | 22360.00 | 22360.00 | 0.00 | 86 | 22 | 86 | 366 | 0.234972677595628 | 0.458822279673188 | 0.458822279673188 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 14313888496.00 | 2026-11-06 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 0abc090a-ab28-4ddf-a813-64a655234806 | 2026-09-21 15:43 | 2026-09-21 15:43 | 2026-09-21 15:43 | CG | CG261016C00047500 | call | 47.5000 | 2026-10-16 | 0.2500 | 0.1500 | 0.4000 | 40.9200 | 26409.00 | 26084.00 | 325.00 | 1063 | 33 | 1786 | 543 | 3.28913443830571 | 0.442431847827747 | 0.442431847827747 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 14559758126.00 | 2026-11-06 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:46:53.809312Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| d3d5e526-2852-40fb-894b-46e1985032fe | 2026-09-21 15:43 | 2026-09-21 15:43 | 2026-09-21 15:43 | CG | CG261016C00047500 | call | 47.5000 | 2026-10-16 | 0.2500 | 0.2000 | 0.3000 | 40.9600 | 14000.00 | 11100.00 | 2725.00 | 560 | 20 | 2346 | 543 | 4.32044198895028 | 0.440777067976008 | 0.440225495005504 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 14559758126.00 | 2026-11-06 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:46:53.809312Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |