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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| fcd1d944-caa0-41cf-bf01-ec2953c296fe | 2026-08-17 10:43 | 2026-08-17 10:43 | 2026-08-17 10:43 | PAAS | PAAS260828P00045500 | put | 45.5000 | 2026-08-28 | 0.6000 | 0.6000 | 0.7500 | 48.1600 | 18068.00 | 0.00 | 18068.00 | 300 | 6 | 304 | 69 | 4.40579710144928 | 0.493663080578805 | 0.506823472402781 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 20518640317.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3400abc3-8829-4016-91c8-bdc5264f4bd8 | 2026-08-17 14:48 | 2026-08-17 14:47 | 2026-08-17 14:47 | PAAS | PAAS260918C00050000 | call | 50.0000 | 2026-09-18 | 1.9500 | 1.9500 | 2.3000 | 48.1819 | 192964.00 | 0.00 | 192964.00 | 989 | 40 | 1086 | 1810 | 0.6 | 0.463123755241975 | 0.47140378058085 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 20518640317.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3ad74ff9-0852-4941-bf6c-78b8baff6e20 | 2026-08-20 11:13 | 2026-08-20 11:13 | 2026-08-20 11:13 | PAAS | PAAS261016C00055000 | call | 55.0000 | 2026-10-16 | 2.9800 | 2.7000 | 3.2000 | 52.0300 | 14880.00 | 2950.00 | 11930.00 | 50 | 7 | 163 | 852 | 0.19131455399061 | 0.492871738949152 | 0.494105903756124 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 20518640317.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:16:49.821442Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 65fdba83-dbea-44f0-be06-79287cbdec99 | 2026-08-20 12:55 | 2026-08-20 12:55 | 2026-08-20 12:55 | PAAS | PAAS280121P00037000 | put | 37.0000 | 2028-01-21 | 4.0600 | 4.0000 | 4.6000 | 51.8400 | 51120.00 | 0.00 | 51120.00 | 126 | 16 | 241 | 30 | 8.03333333333333 | 0.516541378342497 | 0.522801540560621 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 20518640317.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 84410552-8473-46ef-bf9a-5cb98e3a36ac | 2026-08-24 09:45 | 2026-08-24 09:44 | 2026-08-24 09:44 | PAAS | PAAS270319C00055000 | call | 55.0000 | 2027-03-19 | 7.5700 | 7.3000 | 7.7000 | 52.4300 | 41660.00 | 41660.00 | 0.00 | 55 | 6 | 64 | 2592 | 0.0246913580246914 | 0.517768641849205 | 0.517768641849205 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 20518640317.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:46:45.098903Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 87f50b5d-a15c-4c86-82b6-4a4af911fd65 | 2026-08-25 15:28 | 2026-08-25 15:28 | 2026-08-25 15:28 | PAAS | PAAS260918C00052000 | call | 52.0000 | 2026-09-18 | 3.9900 | 3.9000 | 4.0000 | 53.9550 | 32692.00 | 28782.00 | 3910.00 | 82 | 9 | 168 | 222 | 0.756756756756757 | 0.507739785868667 | 0.520671538296782 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 20518640317.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T19:47:14.629482Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fbec00c6-81f4-4a83-a777-f9be6972741e | 2026-08-31 14:09 | 2026-08-31 14:08 | 2026-08-31 14:08 | PAAS | PAAS261016P00048000 | put | 48.0000 | 2026-10-16 | 1.8500 | 1.8000 | 2.0000 | 51.0000 | 77341.00 | 370.00 | 76786.00 | 418 | 12 | 425 | 207 | 2.05314009661836 | 0.493167441519938 | 0.493167441519938 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 20518640317.00 | 2026-11-11 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T18:25:38.432903Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| efa8e23a-0422-4f93-b28b-69c1309e7102 | 2026-09-21 14:42 | 2026-09-21 14:42 | 2026-09-21 14:42 | PAAS | PAAS270115C00065000 | call | 65.0000 | 2027-01-15 | 1.4500 | 1.4500 | 1.5500 | 48.7400 | 10162.00 | 0.00 | 10162.00 | 70 | 8 | 106 | 1894 | 0.0559662090813094 | 0.509987064258811 | 0.509987064258811 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 20565043493.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:42:48.011261Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| c19cbca8-852c-48ff-8fe5-c2daeaebf1a8 | 2026-09-21 15:44 | 2026-09-21 15:44 | 2026-09-21 15:44 | PAAS | PAAS261023P00045000 | put | 45.0000 | 2026-10-23 | 1.0600 | 1.0500 | 1.2000 | 48.8050 | 10615.00 | 0.00 | 10615.00 | 100 | 10 | 102 | 18 | 5.66666666666667 | 0.463323237975423 | 0.467706412911926 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 20565043493.00 | 2026-11-11 | 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 |