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 |
|---|
| 580da258-252e-4cec-b93f-0bd6d4737b75 | 2026-09-25 15:53 | 2026-09-25 15:53 | 2026-09-25 15:53 | SOXS | SOXS261002C00034000 | call | 34.0000 | 2026-10-02 | 1.0700 | 1.0500 | 1.1500 | 32.1550 | 26750.00 | 21614.00 | 5136.00 | 250 | 8 | 1160 | 515 | 2.25242718446602 | 1.00725837607607 | 1.00725837607607 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 1794774987.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:54:56.567521Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| fbfeb66a-92e2-469e-ab11-bf493c86814a | 2026-09-28 10:53 | 2026-09-28 10:52 | 2026-09-28 10:52 | SOXS | SOXS261002C00034000 | call | 34.0000 | 2026-10-02 | 2.9900 | 2.8400 | 3.0000 | 35.9000 | 45747.00 | 45747.00 | 0.00 | 153 | 13 | 773 | 1177 | 0.656754460492778 | 1.28909010952338 | 1.28909010952338 | true | false | false | true | ||||||||||||||||
| f2590a9d-423e-4d16-aad6-209f87b195d8 | 2026-09-28 11:17 | 2026-09-28 11:17 | 2026-09-28 11:17 | SOXS | SOXS261002C00034000 | call | 34.0000 | 2026-10-02 | 2.9500 | 2.6500 | 2.9500 | 35.0000 | 15930.00 | 15930.00 | 0.00 | 54 | 11 | 853 | 1177 | 0.724723874256585 | 1.26430919761725 | 1.26430919761725 | true | false | false | true | ||||||||||||||||
| ad7addf2-2547-4848-b53c-cb310c2ff19d | 2026-09-29 10:28 | 2026-09-29 10:28 | 2026-09-29 10:28 | SOXS | SOXS261002C00034000 | call | 34.0000 | 2026-10-02 | 0.8600 | 0.7700 | 0.8600 | 32.2300 | 17200.00 | 17200.00 | 0.00 | 200 | 5 | 584 | 1078 | 0.541743970315399 | 1.32613030298953 | 1.32613030298953 | false | false | false | true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 1738840561.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:55:24.203019Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 1738840561.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:21:41.621308Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 1846077105.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:29:42.133638Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |