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 |
|---|
| a6cc0602-d8b2-48e0-a346-2eddc710c075 | 2026-08-17 12:54 | 2026-08-17 12:54 | 2026-08-17 12:54 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 16.6500 | 16.6300 | 16.6500 | 774.7700 | 416250.00 | 416250.00 | 0.00 | 250 | 5 | 635 | 9584 | 0.0662562604340568 | 0.17655377941549 | 0.17655377941549 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 802935622223.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 102a37d8-e122-432c-8695-97539d911a6b | 2026-08-17 12:55 | 2026-08-17 12:54 | 2026-08-17 12:54 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 16.6400 | 16.6100 | 16.6400 | 774.8600 | 416000.00 | 416000.00 | 0.00 | 250 | 5 | 885 | 9584 | 0.0923414023372287 | 0.176666188802866 | 0.176666188802866 | false | false | false | true | ||||||||||||||||
| 2716d453-46bc-4532-a664-4fa99bd6fe61 | 2026-08-18 12:11 | 2026-08-18 12:11 | 2026-08-18 12:11 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 18.1900 | 18.1900 | 18.2200 | 768.4900 | 454750.00 | 0.00 | 454750.00 | 250 | 5 | 1371 | 10315 | 0.132913233155599 | 0.174066598196983 | 0.174066598196983 | false | false | false | true | ||||||||||||||||
| 2466931f-88d6-450d-b2a8-040c7a30597a | 2026-08-18 12:13 | 2026-08-18 12:13 | 2026-08-18 12:13 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 18.1500 | 18.1500 | 18.1800 | 768.6400 | 453750.00 | 0.00 | 453750.00 | 250 | 5 | 1871 | 10315 | 0.181386330586524 | 0.174130451088698 | 0.174130451088698 | false | false | false | true | ||||||||||||||||
| ea68e931-4521-41e3-8ed8-df2d8dff6d14 | 2026-08-18 12:13 | 2026-08-18 12:13 | 2026-08-18 12:13 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 18.1500 | 18.1500 | 18.1800 | 768.6400 | 453750.00 | 0.00 | 453750.00 | 250 | 6 | 2123 | 10315 | 0.205816771691711 | 0.174130451088698 | 0.174130451088698 | false | false | false | true | ||||||||||||||||
| 78de9c84-0b00-41f6-8e54-4982d78f460f | 2026-08-18 12:20 | 2026-08-18 12:20 | 2026-08-18 12:20 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 18.2400 | 18.2400 | 18.2700 | 768.3500 | 456000.00 | 0.00 | 456000.00 | 250 | 5 | 2623 | 10315 | 0.254289869122637 | 0.174084604818061 | 0.174084604818061 | false | false | false | true | ||||||||||||||||
| d73f4fc2-9c84-4433-8ff6-803974c52015 | 2026-08-21 09:50 | 2026-08-21 09:50 | 2026-08-21 09:50 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 18.2200 | 18.1700 | 18.2200 | 765.0200 | 559354.00 | 559354.00 | 0.00 | 307 | 8 | 323 | 8607 | 0.0375275938189845 | 0.168077565174426 | 0.168077565174426 | false | false | false | true | ||||||||||||||||
| 7895f7bc-83c8-4a78-a213-109393db1b2a | 2026-09-01 11:36 | 2026-09-01 11:36 | 2026-09-01 11:36 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 16.5600 | 16.5600 | 16.6000 | 763.7000 | 516672.00 | 0.00 | 516672.00 | 312 | 8 | 449 | 10946 | 0.0410195505207382 | 0.160925304736339 | 0.160925304736339 | false | false | false | true | ||||||||||||||||
| 5b03a46c-2bc7-4594-acb5-5159ced70bf4 | 2026-09-16 15:50 | 2026-09-16 15:49 | 2026-09-16 15:49 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 19.6500 | 19.5500 | 20.0300 | 753.0000 | 143445.00 | 78600.00 | 64845.00 | 73 | 5 | 925 | 20101 | 0.0460176110641262 | 0.165907481492527 | 0.165907481492527 | true | false | false | true | ||||||||||||||||
| 1af5bc35-ea12-438d-9015-b60999dc1816 | 2026-09-21 10:10 | 2026-09-21 10:10 | 2026-09-21 10:10 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 13.0000 | 12.9700 | 13.0000 | 767.4250 | 273000.00 | 273000.00 | 0.00 | 210 | 7 | 589 | 20869 | 0.0282236810580287 | 0.158009556391392 | 0.158009556391392 | false | false | false | true | ||||||||||||||||
| 82922bd6-98f3-480d-87bc-a668380b3ea3 | 2026-09-21 15:52 | 2026-09-21 15:52 | 2026-09-21 15:52 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 11.5900 | 11.5900 | 11.6000 | 773.0000 | 11590.00 | 0.00 | 11590.00 | 10 | 5 | 1603 | 20869 | 0.0768124970051272 | 0.162196554817139 | 0.162196554817139 | false | false | false | true | ||||||||||||||||
| c024f33c-f126-4e8f-b367-b7e4feeaf72a | 2026-09-21 15:54 | 2026-09-21 15:54 | 2026-09-21 15:54 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 11.5900 | 11.5600 | 11.5900 | 773.0000 | 837957.00 | 837957.00 | 0.00 | 723 | 27 | 2495 | 20869 | 0.119555321289952 | 0.161940887831388 | 0.161940887831388 | false | false | false | true | ||||||||||||||||
| 75c75553-9971-404f-8a5f-2ed1aa24221c | 2026-09-22 13:54 | 2026-09-22 13:54 | 2026-09-22 13:54 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 11.1300 | 11.1200 | 11.1400 | 774.1900 | 365064.00 | 1113.00 | 363951.00 | 328 | 5 | 941 | 21954 | 0.0428623485469618 | 0.160171101657478 | 0.160171101657478 | false | false | false | true | ||||||||||||||||
| 617b349d-731a-48b3-9375-2cabda255049 | 2026-09-24 09:49 | 2026-09-24 09:49 | 2026-09-24 09:49 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 13.9100 | 13.9000 | 13.9300 | 764.7500 | 13910.00 | 2782.00 | 11128.00 | 10 | 5 | 42 | 21650 | 0.00193995381062356 | 0.160531043833529 | 0.160531043833529 | false | false | false | true | ||||||||||||||||
| 737e77cc-48f6-42e9-b8c8-45e2929e5e74 | 2026-09-24 13:18 | 2026-09-24 13:18 | 2026-09-24 13:18 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 12.9500 | 12.9200 | 12.9500 | 768.1400 | 12950.00 | 12950.00 | 0.00 | 10 | 7 | 541 | 21650 | 0.0249884526558891 | 0.161687061357705 | 0.161687061357705 | false | false | false | true | ||||||||||||||||
| c214e7a0-f69f-4c6f-b731-36185b97ab9a | 2026-09-24 15:58 | 2026-09-24 15:58 | 2026-09-24 15:58 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 13.0600 | 13.0600 | 13.0750 | 767.0000 | 39180.00 | 0.00 | 39180.00 | 30 | 9 | 604 | 21650 | 0.0278983833718245 | 0.161066100992897 | 0.161066100992897 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T15:45:30.323966Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 797118136526.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:10:29.738922Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 785048619408.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:57:38.128984Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:51:23.785124Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:20:10.992675Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |