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_alerts523,327 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 |
|---|
| 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 |
|---|
| 610aef69-b25b-4c70-9239-52aa72ad0e36 | 2026-09-28 15:59 | 2026-09-28 15:59 | 2026-09-28 15:59 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 1.7300 | 1.7200 | 1.7400 | 54.0000 | 18684.00 | 0.00 | 16435.00 | 108 | 6 | 3406 | 11181 | 0.304623915571058 | 0.361736190791846 | 0.361736190791846 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 38529495748.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| be20d810-d7bf-48bf-ae7d-c44dafeefc3e | 2026-09-28 11:45 | 2026-09-28 11:45 | 2026-09-28 11:45 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 1.6500 | 1.6100 | 1.6500 | 55.1445 | 165000.00 | 165000.00 | 0.00 | 1000 | 6 | 2082 | 11181 | 0.186208746981486 | 0.364077926471654 | 0.364077926471654 | false | false | false | true | false | |||||||||||||||
| 78a8c3ad-5b7f-4b60-99a7-d376b9fa812d | 2026-09-28 09:39 | 2026-09-28 09:39 | 2026-09-28 09:39 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 1.4400 | 1.4300 | 1.4800 | 55.5605 | 13248.00 | 0.00 | 13248.00 | 92 | 11 | 372 | 11181 | 0.0332707271263751 | 0.358736236317616 | 0.358736236317616 | true | false | false | true | false | |||||||||||||||
| c26c03f0-3f25-4f53-9d16-24c2570b4ea9 | 2026-09-18 13:52 | 2026-09-18 13:52 | 2026-09-18 13:52 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 0.5900 | 0.5800 | 0.5900 | 60.2739 | 25193.00 | 25193.00 | 0.00 | 427 | 30 | 1046 | 11619 | 0.0900249591186849 | 0.375692305813225 | 0.375648211241779 | false | false | false | true | false | |||||||||||||||
| 7013453e-1308-41fd-9b80-eed489264378 | 2026-09-17 09:31 | 2026-09-17 09:31 | 2026-09-17 09:31 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 1.0000 | 1.0000 | 1.0300 | 59.0400 | 24400.00 | 0.00 | 24400.00 | 244 | 17 | 329 | 11624 | 0.0283035099793531 | 0.402911580678558 | 0.402911580678558 | false | false | false | true | false | |||||||||||||||
| 98ea573f-7146-4d6f-8e58-0f978cfb1878 | 2026-09-16 15:53 | 2026-09-16 15:53 | 2026-09-16 15:53 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 1.7000 | 1.7000 | 1.7000 | 56.0000 | 40290.00 | 0.00 | 0.00 | 237 | 7 | 1930 | 11706 | 0.164872714847087 | 0.413263884506856 | 0.413263884506856 | false | false | false | true | false | |||||||||||||||
| 7ae96e21-e382-44b3-bd0c-a3e5b59e7109 | 2026-09-09 11:03 | 2026-09-09 11:03 | 2026-09-09 11:03 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 1.0300 | 1.0300 | 1.0700 | 61.0450 | 74675.00 | 0.00 | 74675.00 | 725 | 6 | 1628 | 10856 | 0.149963154016212 | 0.441804148848212 | 0.441804148848212 | false | false | false | true | false | |||||||||||||||
| 6c742ebc-f672-4c99-9cd7-db82087d8b07 | 2026-09-09 11:03 | 2026-09-09 11:03 | 2026-09-09 11:03 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 1.0300 | 1.0200 | 1.0300 | 60.9800 | 52942.00 | 52942.00 | 0.00 | 514 | 7 | 843 | 10856 | 0.0776529108327192 | 0.439408820002659 | 0.439408820002659 | false | false | false | true | false | |||||||||||||||
| a4efba87-b4a5-49a1-9120-e026b9cc1cdf | 2026-09-04 12:26 | 2026-09-04 12:26 | 2026-09-04 12:26 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 1.4500 | 1.4300 | 1.4500 | 59.6800 | 15950.00 | 15950.00 | 0.00 | 110 | 17 | 1105 | 9806 | 0.112686110544565 | 0.433738739334045 | 0.433738739334045 | false | false | false | true | false | |||||||||||||||
| ba47e99f-2f77-4fe6-99f9-7a7bea9595fa | 2026-08-27 12:50 | 2026-08-27 12:50 | 2026-08-27 12:50 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 1.1200 | 1.1200 | 1.1400 | 62.6950 | 246400.00 | 0.00 | 246400.00 | 2200 | 1 | 2330 | 9687 | 0.240528543408692 | 0.447636819229514 | 0.447636819229514 | false | true | false | true | false | |||||||||||||||
| 611869e7-6358-4c79-b8b5-ced8a20efd3f | 2026-08-26 11:55 | 2026-08-26 11:54 | 2026-08-26 11:54 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 1.3400 | 1.3000 | 1.3400 | 61.4050 | 20368.00 | 20368.00 | 0.00 | 152 | 5 | 421 | 9676 | 0.0435097147581645 | 0.437810275879872 | 0.437810275879872 | false | false | false | true | false | |||||||||||||||
| 578c135f-d104-465e-985f-df06f3c2b86d | 2026-08-26 11:54 | 2026-08-26 11:54 | 2026-08-26 11:54 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 1.3400 | 1.3100 | 1.3400 | 61.3795 | 26800.00 | 26800.00 | 0.00 | 200 | 6 | 269 | 9676 | 0.027800744109136 | 0.436991477502819 | 0.436991477502819 | false | false | false | true | false | |||||||||||||||
| eca71207-d5bf-4811-b35c-74681c60cf35 | 2026-08-20 09:49 | 2026-08-20 09:49 | 2026-08-20 09:49 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 1.6100 | 1.5900 | 1.6100 | 60.8300 | 80661.00 | 80661.00 | 0.00 | 501 | 7 | 553 | 7324 | 0.0755051884216275 | 0.434555920110222 | 0.434555920110222 | false | false | false | true | false | |||||||||||||||
| 2a145e19-d006-4f8a-8485-cbbbafc9fbcf | 2026-08-18 10:26 | 2026-08-18 10:26 | 2026-08-18 10:26 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 2.1800 | 2.1500 | 2.1800 | 58.5301 | 50140.00 | 50140.00 | 0.00 | 230 | 10 | 1013 | 7159 | 0.14150020952647 | 0.419887850682352 | 0.419887850682352 | false | false | false | true | false | |||||||||||||||
| 8aa46c5d-2594-4ef5-8703-4a2276c44956 | 2026-08-18 10:25 | 2026-08-18 10:25 | 2026-08-18 10:25 | SLV | SLV261016P00055000 | put | 55.0000 | 2026-10-16 | 2.1800 | 2.1500 | 2.1800 | 58.5100 | 117720.00 | 117720.00 | 0.00 | 540 | 8 | 553 | 7159 | 0.0772454253387345 | 0.419133738681815 | 0.419133738681815 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:46:51.854301Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:41:17.796982Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:59:53.998874Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:32:41.851557Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:57:23.365599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |