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_alerts658,639 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 | expiry |
|---|
| 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 |
|---|
| 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 | ||||||||||||||||
| 97af3228-e164-4614-a4fe-37cd7ad34565 | 2026-10-01 09:47 | 2026-10-01 09:47 | 2026-10-01 09:47 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 13.9900 | 13.9900 | 14.0100 | 763.0000 | 139900.00 | 0.00 | 139900.00 | 100 | 6 | 113 | 22006 | 0.00513496319185677 | 0.163019526376225 | 0.163019526376225 | true | false | false | true | ||||||||||||||||
| 42b5f399-d2a4-4af9-894a-dc14844b4267 | 2026-10-01 10:37 | 2026-10-01 10:37 | 2026-10-01 10:37 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 14.5800 | 14.5400 | 14.5800 | 761.8300 | 125388.00 | 125388.00 | 0.00 | 86 | 10 | 461 | 22006 | 0.02094883213669 | 0.16324273322159 | 0.16324273322159 | false | false | false | true | ||||||||||||||||
| ea8c92dd-ccf9-4bd8-b913-9367d84052d5 | 2026-10-01 11:11 | 2026-10-01 11:11 | 2026-10-01 11:11 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 15.5500 | 15.5500 | 15.5800 | 759.4100 | 101075.00 | 0.00 | 101075.00 | 65 | 6 | 628 | 22006 | 0.0285376715441243 | 0.163823554449233 | 0.163879811279259 | false | false | false | true | ||||||||||||||||
| 034d1bc9-4cdc-4d74-ad6b-0247f1352119 | 2026-10-01 13:03 | 2026-10-01 13:03 | 2026-10-01 13:03 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 14.5400 | 14.5400 | 14.5500 | 761.6500 | 491457.00 | 7275.00 | 484182.00 | 338 | 12 | 2407 | 22006 | 0.109379260201763 | 0.162524305498363 | 0.162448285176325 | false | false | false | true | ||||||||||||||||
| e2e2ba5b-6da8-4a58-bb86-a79b375138a0 | 2026-10-01 13:42 | 2026-10-01 13:42 | 2026-10-01 13:42 | SPY | SPY261218P00750000 | put | 750.0000 | 2026-12-18 | 13.5700 | 13.5400 | 13.5700 | 764.0000 | 13570.00 | 13570.00 | 0.00 | 10 | 7 | 2795 | 22006 | 0.127010815232209 | 0.162540460248643 | 0.162540460248643 | 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 |
| false |
| 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 |
| false |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 809216143062.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:48:26.450187Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 809216143062.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T14:39:17.807457Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 809216143062.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T15:13:24.019796Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 809216143062.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T17:06:52.790580Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 809216143062.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T17:45:53.938303Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |