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 |
|---|
| 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 |
|---|
| f79e414c-0d53-4f46-b5ec-cfb7f6555904 | 2026-09-22 11:47 | 2026-09-22 11:47 | 2026-09-22 11:47 | IGV | IGV261016P00095000 | put | 95.0000 | 2026-10-16 | 0.3700 | 0.3700 | 0.4000 | 105.9900 | 29489.00 | 0.00 | 29489.00 | 797 | 26 | 1065 | 7622 | 0.139727105746523 | 0.330879332278073 | 0.330879332278073 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 13830698840.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T15:49:01.734970Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 6ebeb916-ffd5-42c3-88e1-d3cc44c3d26f | 2026-09-18 10:21 | 2026-09-18 10:21 | 2026-09-18 10:21 | IGV | IGV261016P00095000 | put | 95.0000 | 2026-10-16 | 0.7100 | 0.6700 | 0.7100 | 103.7600 | 62693.00 | 62693.00 | 0.00 | 883 | 33 | 994 | 7359 | 0.135072700095122 | 0.32288680258461 | 0.32288680258461 | false | false | false | true | false | |||||||||||||||
| 978d25cd-664e-46d3-8b2c-faceaf193027 | 2026-09-14 14:04 | 2026-09-14 14:04 | 2026-09-14 14:04 | IGV | IGV261016P00095000 | put | 95.0000 | 2026-10-16 | 0.5700 | 0.5200 | 0.5700 | 106.9950 | 51243.00 | 51243.00 | 0.00 | 899 | 16 | 5726 | 3367 | 1.7006237006237 | 0.343067797546452 | 0.343067797546452 | false | false | false | true | false | |||||||||||||||
| c424002b-35e7-433b-b030-faae159bd3d2 | 2026-09-14 13:20 | 2026-09-14 13:20 | 2026-09-14 13:20 | IGV | IGV261016P00095000 | put | 95.0000 | 2026-10-16 | 0.5800 | 0.5400 | 0.5800 | 106.7400 | 94018.00 | 94018.00 | 0.00 | 1621 | 7 | 4815 | 3367 | 1.43005643005643 | 0.340121724311258 | 0.340121724311258 | false | false | false | true | false | |||||||||||||||
| 224c6e8a-2af8-411c-a32f-a9e1e6cba24e | 2026-09-14 10:33 | 2026-09-14 10:33 | 2026-09-14 10:33 | IGV | IGV261016P00095000 | put | 95.0000 | 2026-10-16 | 0.8000 | 0.7600 | 0.8200 | 104.9000 | 118079.00 | 118000.00 | 0.00 | 1476 | 18 | 3007 | 3367 | 0.893079893079893 | 0.338794355743472 | 0.338794355743472 | false | false | false | true | false | |||||||||||||||
| 9e1f8a98-6021-4778-92a2-d897f05b6806 | 2026-09-14 10:24 | 2026-09-14 10:24 | 2026-09-14 10:24 | IGV | IGV261016P00095000 | put | 95.0000 | 2026-10-16 | 0.8500 | 0.8000 | 0.8600 | 104.0000 | 73741.00 | 63325.00 | 10416.00 | 869 | 12 | 1521 | 3367 | 0.451737451737452 | 0.33698325734518 | 0.335596138344579 | false | false | false | true | false | |||||||||||||||
| 931d69d8-3917-4d61-9371-f5e574f69c3d | 2026-09-14 09:49 | 2026-09-14 09:49 | 2026-09-14 09:49 | IGV | IGV261016P00095000 | put | 95.0000 | 2026-10-16 | 0.9700 | 0.9100 | 0.9700 | 103.6200 | 39770.00 | 39770.00 | 0.00 | 410 | 26 | 437 | 3367 | 0.12978912978913 | 0.334900708843081 | 0.334900708843081 | false | false | false | true | false | |||||||||||||||
| b5217f4a-e88d-4ce1-841c-0b6a82b2832d | 2026-09-11 09:36 | 2026-09-11 09:36 | 2026-09-11 09:36 | IGV | IGV261016P00095000 | put | 95.0000 | 2026-10-16 | 1.3000 | 1.3000 | 1.4500 | 101.0000 | 38870.00 | 0.00 | 38870.00 | 299 | 30 | 302 | 2843 | 0.106225817798101 | 0.322498091505957 | 0.322498091505957 | false | false | false | true | false | |||||||||||||||
| 1c1703ba-7ef6-41e0-a4a2-a69bfc542b84 | 2026-09-01 11:12 | 2026-09-01 11:12 | 2026-09-01 11:12 | IGV | IGV261016P00095000 | put | 95.0000 | 2026-10-16 | 0.8900 | 0.7700 | 1.0000 | 106.5700 | 17711.00 | 445.00 | 17266.00 | 199 | 5 | 208 | 1950 | 0.106666666666667 | 0.327832385350025 | 0.327749084471605 | false | false | false | true | false | |||||||||||||||
| a84cb926-cfb6-431e-a92a-790d009d77f7 | 2026-08-28 14:03 | 2026-08-28 14:03 | 2026-08-28 14:03 | IGV | IGV261016P00095000 | put | 95.0000 | 2026-10-16 | 0.6900 | 0.6900 | 0.7100 | 109.6400 | 11937.00 | 0.00 | 11937.00 | 173 | 5 | 220 | 2311 | 0.0951968844655993 | 0.335451464875732 | 0.335451464875732 | false | false | false | true | false | |||||||||||||||
| 0bda247a-c582-45fc-a3f8-b42ae51625dd | 2026-08-27 10:54 | 2026-08-27 10:54 | 2026-08-27 10:54 | IGV | IGV261016P00095000 | put | 95.0000 | 2026-10-16 | 0.7600 | 0.7600 | 0.8100 | 108.8600 | 79800.00 | 0.00 | 79800.00 | 1050 | 19 | 1082 | 3183 | 0.339930882814954 | 0.330433751764123 | 0.330433751764123 | true | false | false | true | false | |||||||||||||||
| 6cff5a1c-092e-4e6c-a11d-6993a61a5cf5 | 2026-08-26 09:57 | 2026-08-26 09:57 | 2026-08-26 09:57 | IGV | IGV261016P00095000 | put | 95.0000 | 2026-10-16 | 1.9000 | 1.8000 | 2.5300 | 102.0500 | 38256.00 | 0.00 | 38256.00 | 201 | 8 | 201 | 3269 | 0.061486693178342 | 0.32628468455231 | 0.32628468455231 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14284070404.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13356725098.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T18:18:53.599003Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13356725098.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13356725098.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:43:33.165845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 13356725098.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13356725098.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 13356725098.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:37:33.609039Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T15:18:08.991662Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T18:18:32.282709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:06:04.251678Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |