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 |
|---|
| 8f2af134-d60b-45f6-aedc-0de0a0eb0c39 | 2026-08-28 12:05 | 2026-08-28 12:04 | 2026-08-28 12:04 | SPXW | SPXW260918C07700000 | call | 7700.0000 | 2026-09-18 | 105.8000 | 105.4000 | 106.0000 | 7705.0000 | 1058000.00 | 571320.00 | 486680.00 | 100 | 8 | 404 | 3258 | 0.124002455494168 | 0.111967238785775 | 0.111967238785775 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4a79e70a-282a-4455-91e9-318782735b28 | 2026-09-10 09:37 | 2026-09-10 09:37 | 2026-09-10 09:37 | SPXW | SPXW260918C07700000 | call | 7700.0000 | 2026-09-18 | 23.0800 | 22.6000 | 23.2000 | 7592.6000 | 150000.00 | 150000.00 | 0.00 | 65 | 6 | 233 | 5004 | 0.0465627498001599 | 0.13416554198442 | 0.13416554198442 | true | false | false | true | ||||||||||||||||
| 8dd91485-b66e-4f32-900d-ca28c711c74e | 2026-09-11 14:45 | 2026-09-11 14:45 | 2026-09-11 14:45 | SPXW | SPXW260918C07700000 | call | 7700.0000 | 2026-09-18 | 34.0800 | 33.8000 | 34.2000 | 7664.9900 | 184020.00 | 184020.00 | 0.00 | 54 | 9 | 1897 | 4976 | 0.381229903536977 | 0.111212553963407 | 0.111455552045635 | false | false | false | true | ||||||||||||||||
| 78a99e1e-0616-480c-b230-451a16d86712 | 2026-09-11 14:45 | 2026-09-11 14:45 | 2026-09-11 14:45 | SPXW | SPXW260918C07700000 | call | 7700.0000 | 2026-09-18 | 34.2000 | 34.0000 | 34.3000 | 7664.9500 | 297540.00 | 218880.00 | 78660.00 | 87 | 5 | 2187 | 4976 | 0.439509646302251 | 0.111737948943882 | 0.111737948943882 | false | false | false | true | ||||||||||||||||
| e49d480f-dbc2-463a-b4aa-77d51fe61ec3 | 2026-09-11 14:45 | 2026-09-11 14:45 | 2026-09-11 14:45 | SPXW | SPXW260918C07700000 | call | 7700.0000 | 2026-09-18 | 34.4000 | 34.2000 | 34.5000 | 7665.1900 | 206400.00 | 196080.00 | 10320.00 | 60 | 5 | 2292 | 4976 | 0.460610932475884 | 0.11198694133709 | 0.11198694133709 | false | false | false | true | ||||||||||||||||
| 215c09ab-795b-486f-917b-e2dd962f7f53 | 2026-09-11 14:45 | 2026-09-11 14:45 | 2026-09-11 14:45 | SPXW | SPXW260918C07700000 | call | 7700.0000 | 2026-09-18 | 34.3900 | 34.1000 | 34.5000 | 7665.1900 | 127230.00 | 127230.00 | 0.00 | 37 | 7 | 2329 | 4976 | 0.468046623794212 | 0.111744116763588 | 0.11198694133709 | false | false | false | true | ||||||||||||||||
| be328f2b-97ee-4e86-8d57-f202c0de40fc | 2026-09-14 10:14 | 2026-09-14 10:14 | 2026-09-14 10:14 | SPXW | SPXW260918C07700000 | call | 7700.0000 | 2026-09-18 | 16.6000 | 16.5000 | 16.8000 | 7620.0100 | 199200.00 | 92960.00 | 28220.00 | 120 | 15 | 1348 | 5591 | 0.241101770702915 | 0.140486267403967 | 0.1403974820773 | false | false | false | true | ||||||||||||||||
| 06e98025-f3e5-4af1-99d4-bdf6a2cc8bd7 | 2026-09-15 15:56 | 2026-09-15 15:56 | 2026-09-15 15:56 | SPXW | SPXW260918C07700000 | call | 7700.0000 | 2026-09-18 | 7.3000 | 7.1000 | 7.4000 | 7560.0000 | 364270.00 | 154030.00 | 210240.00 | 499 | 23 | 2375 | 5444 | 0.43626010286554 | 0.153001803934792 | 0.153001803934792 | false | false | false | true | ||||||||||||||||
| cd70344b-0b57-47a2-a417-cde57e9b55ac | 2026-09-16 09:31 | 2026-09-16 09:31 | 2026-09-16 09:31 | SPXW | SPXW260918C07700000 | call | 7700.0000 | 2026-09-18 | 8.9000 | 8.8000 | 9.2000 | 7605.3200 | 406730.00 | 86330.00 | 320400.00 | 457 | 6 | 1020 | 6428 | 0.158680771624144 | 0.172424880403797 | 0.172424880403797 | false | false | false | true | ||||||||||||||||
| c7e16f39-e832-4660-8171-f760a3d5c6d5 | 2026-09-16 09:31 | 2026-09-16 09:31 | 2026-09-16 09:31 | SPXW | SPXW260918C07700000 | call | 7700.0000 | 2026-09-18 | 9.3400 | 9.1000 | 9.6000 | 7604.9700 | 128920.00 | 0.00 | 128920.00 | 138 | 23 | 171 | 6428 | 0.026602364654636 | 0.176300486569677 | 0.176300486569677 | false | false | false | true | ||||||||||||||||
| 98fd0182-d960-4598-b3bb-05afdaada8a5 | 2026-09-17 14:42 | 2026-09-17 14:42 | 2026-09-17 14:42 | SPXW | SPXW260918C07700000 | call | 7700.0000 | 2026-09-18 | 2.4000 | 2.5000 | 2.5500 | 7634.7600 | 360000.00 | 0.00 | 0.00 | 1500 | 8 | 11672 | 10448 | 1.11715160796325 | 0.125523945981221 | 0.125523945981221 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:42:34.192825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:14:09.812180Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |