uw_flow_alerts728,802 rows| 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 |
|---|
| 6f2f223d-2cbb-466d-9ebd-4554c6d0cd5c | 2026-08-25 10:01 | 2026-08-25 10:01 | 2026-08-25 10:01 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 158.2000 | 158.2000 | 158.6000 | 7674.6700 | 996660.00 | 0.00 | 996660.00 | 63 | 8 | 68 | 5259 | 0.0129302148697471 | 0.129894822373099 | 0.129894822373099 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T14:12:03.649618Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e81e8303-b946-4801-940e-bc6c9efae589 | 2026-08-25 10:02 | 2026-08-25 10:02 | 2026-08-25 10:02 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 157.8000 | 157.8000 | 158.2000 | 7674.7600 | 1088820.00 | 0.00 | 1088820.00 | 69 | 6 | 476 | 5259 | 0.0905115040882297 | 0.129506758721219 | 0.129506758721219 | false | false | false | |||||||||||||||||
| f2cb5836-122e-419a-9120-211d79fc6883 | 2026-08-27 12:18 | 2026-08-27 12:18 | 2026-08-27 12:18 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 178.0000 | 177.6000 | 178.2000 | 7724.2000 | 534000.00 | 0.00 | 0.00 | 30 | 6 | 1788 | 8090 | 0.221013597033375 | 0.126476102308433 | 0.126476102308433 | false | false | false | true | ||||||||||||||||
| 81a198b7-f3c1-4312-9575-61cf79791d37 | 2026-09-03 14:56 | 2026-09-03 14:56 | 2026-09-03 14:56 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 180.0000 | 178.8000 | 179.5000 | 7751.4100 | 1584000.00 | 0.00 | 0.00 | 88 | 5 | 968 | 10841 | 0.0892906558435569 | 0.126157349625226 | 0.126157349625226 | false | false | false | |||||||||||||||||
| df94804d-74cf-4a2f-bf9d-f20d4124bb43 | 2026-09-08 11:13 | 2026-09-08 11:13 | 2026-09-08 11:13 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 134.8900 | 137.9000 | 138.5000 | 7698.6400 | 202335.00 | 0.00 | 0.00 | 15 | 7 | 186 | 12561 | 0.0148077382374015 | 0.120703542875244 | 0.120703542875244 | false | false | false | |||||||||||||||||
| 10991493-4d3b-43eb-9b48-cdb309159bae | 2026-09-16 09:30 | 2026-09-16 09:30 | 2026-09-16 09:30 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 78.8000 | 0.0000 | 0.0000 | 7606.1700 | 409760.00 | 409760.00 | 0.00 | 52 | 25 | 52 | 14765 | 0.0035218421943786 | 0.125731796770519 | 0.125731796770519 | false | false | false | |||||||||||||||||
| a9a574a0-315b-4754-b9ce-a140add6e7fc | 2026-09-16 13:20 | 2026-09-16 13:20 | 2026-09-16 13:20 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 79.2000 | 78.8000 | 79.4000 | 7609.3100 | 1742400.00 | 1338480.00 | 403920.00 | 220 | 15 | 2518 | 14765 | 0.170538435489333 | 0.124685573654266 | 0.124685573654266 | false | false | false | |||||||||||||||||
| 0e64555c-addf-4931-81ac-6e87163d3f9b | 2026-09-16 14:54 | 2026-09-16 14:54 | 2026-09-16 14:54 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 63.5000 | 60.4000 | 61.7000 | 7563.9500 | 717550.00 | 0.00 | 0.00 | 113 | 10 | 2701 | 14765 | 0.182932610904165 | 0.12658061336414 | 0.12658061336414 | false | false | false | true | ||||||||||||||||
| c93b46be-ad48-41ed-b177-306dbb57e80e | 2026-09-18 14:55 | 2026-09-18 14:55 | 2026-09-18 14:55 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 77.9000 | 78.2000 | 78.8000 | 7642.9100 | 1776120.00 | 0.00 | 0.00 | 228 | 6 | 3928 | 18831 | 0.208592214964686 | 0.11080445840841 | 0.11080445840841 | false | false | false | true | ||||||||||||||||
| 4cf53751-4ac5-4242-809e-3b546b4e7c51 | 2026-09-18 16:33 | 2026-09-18 16:31 | 2026-09-18 16:31 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 85.3000 | 84.7000 | 86.0000 | 7630.0000 | 127950.00 | 51180.00 | 76770.00 | 15 | 9 | 4147 | 18831 | 0.220221974403908 | 0.115488591363406 | 0.115488591363406 | false | false | false | |||||||||||||||||
| eacbd30c-d523-4047-a742-9c9263960bdf | 2026-09-21 09:52 | 2026-09-21 09:52 | 2026-09-21 09:52 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 105.9000 | 106.3000 | 106.9000 | 7703.6900 | 1196670.00 | 0.00 | 1196670.00 | 113 | 6 | 525 | 19128 | 0.0274466750313676 | 0.115918147764782 | 0.115918147764782 | false | true | false | |||||||||||||||||
| 27a5e3ab-55c8-4deb-83ee-068f6e3de6ea | 2026-09-21 12:29 | 2026-09-21 12:29 | 2026-09-21 12:29 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 137.4000 | 136.9000 | 137.7000 | 7725.0000 | 137400.00 | 137400.00 | 0.00 | 10 | 7 | 975 | 19128 | 0.0509723964868256 | 0.122517740188187 | 0.122517740188187 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:12:03.649618Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:30:57.923324Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:14:28.726538Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:33:11.249350Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| 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 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| 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 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T13:53:49.501301Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:32:17.927421Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |