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_alerts566,287 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 |
|---|
| a1b32075-4a8b-4ae0-8b7f-2d69c8e74003 | 2026-08-17 10:36 | 2026-08-17 10:36 | 2026-08-17 10:36 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 11.7000 | 11.4500 | 11.7000 | 405.6500 | 475020.00 | 475020.00 | 0.00 | 406 | 25 | 760 | 3605 | 0.210818307905687 | 0.238383862932824 | 0.238383862932824 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 143675098310.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3e64722d-0b90-4d6a-9c3c-a2a43bb08c68 | 2026-08-17 10:36 | 2026-08-17 10:36 | 2026-08-17 10:36 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 11.7000 | 11.5000 | 11.7500 | 405.6350 | 251550.00 | 26910.00 | 224640.00 | 215 | 6 | 1010 | 3605 | 0.280166435506241 | 0.238454710873247 | 0.238454710873247 | false | false | false | |||||||||||||||||
| dbc650a9-501b-4b3d-9638-3cde1b7a1f46 | 2026-08-17 10:39 | 2026-08-17 10:39 | 2026-08-17 10:39 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 11.5800 | 11.3500 | 11.6000 | 405.1200 | 482863.00 | 482863.00 | 0.00 | 417 | 21 | 1435 | 3605 | 0.398058252427184 | 0.238954223636486 | 0.239597697132193 | false | false | false | |||||||||||||||||
| 86d49ce3-17de-46d0-8a1d-55c34c9e3970 | 2026-08-20 09:37 | 2026-08-20 09:37 | 2026-08-20 09:37 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 14.0500 | 13.7000 | 14.0500 | 410.8100 | 983386.00 | 983386.00 | 0.00 | 700 | 48 | 702 | 4605 | 0.152442996742671 | 0.24696510767784 | 0.247163395872043 | false | false | false | |||||||||||||||||
| e05fbee5-7407-418c-9003-3c28881ee1d4 | 2026-08-20 12:03 | 2026-08-20 12:03 | 2026-08-20 12:03 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 16.0500 | 15.7500 | 16.0500 | 414.7600 | 81855.00 | 81855.00 | 0.00 | 51 | 8 | 1221 | 4605 | 0.26514657980456 | 0.251059369345367 | 0.251059369345367 | false | false | false | |||||||||||||||||
| d8c3bad2-ad82-46bd-9b5b-b9b9d2d98898 | 2026-09-03 14:16 | 2026-09-03 14:16 | 2026-09-03 14:16 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 12.7600 | 12.7500 | 12.9000 | 411.2200 | 127556.00 | 0.00 | 127556.00 | 100 | 8 | 625 | 6405 | 0.0975800156128025 | 0.251437406211351 | 0.251437406211351 | false | false | false | |||||||||||||||||
| 14d9cd88-800f-4aea-aeed-490eb4bbf007 | 2026-09-16 13:32 | 2026-09-16 13:31 | 2026-09-16 13:31 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 7.4600 | 7.4000 | 7.5500 | 398.5400 | 76086.00 | 745.00 | 73851.00 | 102 | 7 | 308 | 23238 | 0.0132541526809536 | 0.26240788900156 | 0.26240788900156 | true | false | false | |||||||||||||||||
| 1496fdb6-83ca-4434-a6fa-bed9d26d09fe | 2026-09-18 13:32 | 2026-09-18 13:32 | 2026-09-18 13:32 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 6.8000 | 6.8000 | 6.8500 | 402.1550 | 68000.00 | 0.00 | 20400.00 | 100 | 9 | 698 | 22815 | 0.0305939075169844 | 0.237147982579768 | 0.237147982579768 | true | false | false | |||||||||||||||||
| db9382aa-82e3-44d5-a307-2b4fdffbb194 | 2026-09-18 15:57 | 2026-09-18 15:57 | 2026-09-18 15:57 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 6.5600 | 6.3500 | 6.6000 | 401.0000 | 75432.00 | 75432.00 | 0.00 | 115 | 9 | 873 | 22815 | 0.0382642998027613 | 0.238270489424342 | 0.23613387133144 | false | false | false | |||||||||||||||||
| fdc9ed7e-977d-40a8-a910-c8a15b408a4f | 2026-09-18 15:57 | 2026-09-18 15:57 | 2026-09-18 15:57 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 6.5400 | 6.3500 | 6.6000 | 401.0000 | 109139.00 | 109139.00 | 0.00 | 167 | 8 | 1458 | 22815 | 0.063905325443787 | 0.236568935785984 | 0.238170400432344 | false | false | false | |||||||||||||||||
| d0dcb3c5-9784-4739-bc32-a7c3e43a956f | 2026-09-18 15:57 | 2026-09-18 15:57 | 2026-09-18 15:57 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 6.5700 | 6.3500 | 6.6000 | 401.0000 | 145093.00 | 145093.00 | 0.00 | 221 | 10 | 1219 | 22815 | 0.0534297611220688 | 0.236312214719963 | 0.238170400432344 | false | false | false | |||||||||||||||||
| 9383aed8-a374-4727-b2c4-5d3fdeae3d46 | 2026-09-18 15:57 | 2026-09-18 15:57 | 2026-09-18 15:57 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 6.6500 | 6.5500 | 6.6500 | 401.0000 | 726175.00 | 725515.00 | 0.00 | 1092 | 18 | 3659 | 22815 | 0.16037694499233 | 0.237294252343122 | 0.237904834202736 | false | false | false | |||||||||||||||||
| 6d954b80-ceff-4a97-9f9f-3f6ab4db1ad1 | 2026-09-18 15:57 | 2026-09-18 15:57 | 2026-09-18 15:57 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 6.6200 | 6.4500 | 6.6500 | 401.0000 | 139642.00 | 137002.00 | 660.00 | 211 | 13 | 2531 | 22815 | 0.110935787858865 | 0.237394417244079 | 0.237571853306052 | true | false | false | |||||||||||||||||
| 356cec53-dd56-4e5a-bc21-52f41b9d9ff0 | 2026-09-18 15:57 | 2026-09-18 15:57 | 2026-09-18 15:57 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 6.6000 | 6.4500 | 6.6000 | 401.0000 | 255420.00 | 255420.00 | 0.00 | 387 | 5 | 2320 | 22815 | 0.101687486302871 | 0.237469535196071 | 0.237469535196071 | false | false | false | |||||||||||||||||
| 938057d3-a65a-4e69-a658-5da83be7eaf7 | 2026-09-23 10:23 | 2026-09-23 10:23 | 2026-09-23 10:23 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 3.8000 | 3.8000 | 3.9000 | 392.4800 | 1045770.00 | 0.00 | 1045770.00 | 2752 | 50 | 2968 | 26579 | 0.111667105609692 | 0.234698204926312 | 0.234698204926312 | false | false | false | |||||||||||||||||
| a9a7d0c6-77ef-456a-b105-de42d7cf8861 | 2026-09-25 13:05 | 2026-09-25 13:05 | 2026-09-25 13:05 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 3.3500 | 3.2500 | 3.3500 | 393.5000 | 346390.00 | 346390.00 | 0.00 | 1034 | 46 | 3132 | 23931 | 0.130876269274163 | 0.223724249903795 | 0.223589759875807 | true | false | false | |||||||||||||||||
| b0a276bf-0910-4dfe-8350-3b759ccdf2e6 | 2026-09-25 13:07 | 2026-09-25 13:07 | 2026-09-25 13:07 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 3.3500 | 3.2500 | 3.4000 | 393.3800 | 593955.00 | 591275.00 | 0.00 | 1773 | 41 | 4905 | 23931 | 0.204964272282813 | 0.224354285387054 | 0.224129458501792 | true | false | false | |||||||||||||||||
| 37c0655c-4711-4980-947c-7f55320b60a6 | 2026-09-28 13:06 | 2026-09-28 13:06 | 2026-09-28 13:06 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 1.7200 | 1.7200 | 1.7300 | 378.3550 | 51428.00 | 0.00 | 51428.00 | 299 | 14 | 1125 | 25491 | 0.0441332234906438 | 0.246181866574503 | 0.246181866574503 | false | false | false | |||||||||||||||||
| e7986318-a96a-4cd5-a9e6-d0f0a4302998 | 2026-09-28 13:09 | 2026-09-28 13:09 | 2026-09-28 13:09 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 1.7400 | 1.7100 | 1.7400 | 378.3800 | 34800.00 | 34800.00 | 0.00 | 200 | 6 | 1326 | 25491 | 0.0520183594209721 | 0.246840924949685 | 0.246840924949685 | false | false | false | |||||||||||||||||
| 1c3ef9b6-ad68-4da6-9a49-8854271d6b79 | 2026-09-29 10:06 | 2026-09-29 10:06 | 2026-09-29 10:06 | GLD | GLD261120C00430000 | call | 430.0000 | 2026-11-20 | 1.9400 | 1.8900 | 1.9500 | 381.8455 | 194000.00 | 174600.00 | 3686.00 | 1000 | 38 | 1023 | 25337 | 0.0403757350909737 | 0.242507489439951 | 0.242507489439951 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145045725759.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147832545538.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147832545538.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 147832545538.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 147832545538.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 147832545538.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 147832545538.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147832545538.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146956242979.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 144613484818.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:13:31.947650Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 144613484818.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:13:31.947650Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 144430510273.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:11:31.612097Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 144430510273.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:11:31.612097Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 141045832097.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:06:19.717900Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |