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 | 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 |
|---|
| b7990cd0-a2b9-4841-a6ef-d2db1cb2dca7 | 2026-09-14 10:17 | 2026-09-14 10:17 | 2026-09-14 10:17 | XYZ | XYZ270319C00082500 | call | 82.5000 | 2027-03-19 | 10.3000 | 10.0500 | 10.3000 | 79.0000 | 142140.00 | 142140.00 | 0.00 | 138 | 6 | 138 | 160 | 0.8625 | 0.481124768389109 | 0.481124768389109 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 42989463840.00 | 2026-11-05 | unknown | 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 |
| 934f67e0-9b6e-475d-9962-436b6e68166e | 2026-09-14 10:18 | 2026-09-14 10:18 | 2026-09-14 10:18 | XYZ | XYZ270319C00082500 | call | 82.5000 | 2027-03-19 | 10.2500 | 10.2000 | 10.4500 | 79.0000 | 436650.00 | 117875.00 | 318775.00 | 426 | 36 | 564 | 160 | 3.525 | 0.480122452774728 | 0.480609297455166 | true | false | false | true | ||||||||||||||||
| 296df898-812f-4013-a076-a23813c0f981 | 2026-09-14 10:18 | 2026-09-14 10:18 | 2026-09-14 10:18 | XYZ | XYZ270319C00082500 | call | 82.5000 | 2027-03-19 | 10.1500 | 10.1500 | 10.4500 | 79.0000 | 127891.00 | 0.00 | 127891.00 | 126 | 27 | 713 | 160 | 4.45625 | 0.477503616190073 | 0.477503616190073 | true | false | false | true | ||||||||||||||||
| de4b4d8f-f1b5-4ebd-9064-035ccc8f3d8f | 2026-09-17 13:22 | 2026-09-17 13:21 | 2026-09-17 13:21 | XYZ | XYZ270319C00082500 | call | 82.5000 | 2027-03-19 | 8.4000 | 8.4000 | 8.5500 | 76.8000 | 60480.00 | 0.00 | 60480.00 | 72 | 15 | 235 | 765 | 0.30718954248366 | 0.461869505081471 | 0.461753089166908 | false | false | false | true | ||||||||||||||||
| 0a8c82e4-bb74-425a-a28a-407a38807022 | 2026-09-17 13:22 | 2026-09-17 13:21 | 2026-09-17 13:21 | XYZ | XYZ270319C00082500 | call | 82.5000 | 2027-03-19 | 8.4000 | 8.3500 | 8.5000 | 76.8000 | 36960.00 | 1680.00 | 35280.00 | 44 | 9 | 298 | 765 | 0.389542483660131 | 0.461753089166908 | 0.461753089166908 | false | false | false | true | ||||||||||||||||
| a9b920fb-5e34-4333-aead-0f263fdc370d | 2026-09-18 12:00 | 2026-09-18 12:00 | 2026-09-18 12:00 | XYZ | XYZ270319C00082500 | call | 82.5000 | 2027-03-19 | 8.1500 | 8.1500 | 8.4500 | 76.3200 | 285250.00 | 0.00 | 285250.00 | 350 | 6 | 375 | 1067 | 0.3514526710403 | 0.463097432081936 | 0.463097432081936 | false | false | false | true | ||||||||||||||||
| 0d81c1e9-1886-461f-9633-7cf974133e9e | 2026-09-18 12:23 | 2026-09-18 12:23 | 2026-09-18 12:23 | XYZ | XYZ270319C00082500 | call | 82.5000 | 2027-03-19 | 8.2500 | 8.2500 | 8.4000 | 76.0000 | 170775.00 | 0.00 | 170775.00 | 207 | 9 | 582 | 1067 | 0.545454545454545 | 0.463110409055623 | 0.463110409055623 | false | false | false | true | ||||||||||||||||
| 43acd61e-206f-4cef-96de-28dad2274a53 | 2026-09-18 12:31 | 2026-09-18 12:31 | 2026-09-18 12:31 | XYZ | XYZ270319C00082500 | call | 82.5000 | 2027-03-19 | 8.2500 | 8.2500 | 8.4000 | 76.5100 | 108075.00 | 0.00 | 108075.00 | 131 | 6 | 713 | 1067 | 0.668228678537957 | 0.463342446208448 | 0.463342446208448 | false | false | false | true | ||||||||||||||||
| daeb28f4-47b4-42c4-9c86-a0400d4dafac | 2026-09-21 11:24 | 2026-09-21 11:24 | 2026-09-21 11:24 | XYZ | XYZ270319C00082500 | call | 82.5000 | 2027-03-19 | 8.6600 | 8.4500 | 8.8500 | 77.8110 | 55400.00 | 35000.00 | 20400.00 | 64 | 5 | 74 | 1073 | 0.0689655172413793 | 0.461320669100451 | 0.449810556445413 | false | false | false | true | ||||||||||||||||
| 4f6085d3-a91c-4472-9b72-499c5d3cb412 | 2026-09-21 12:33 | 2026-09-21 12:33 | 2026-09-21 12:33 | XYZ | XYZ270319C00082500 | call | 82.5000 | 2027-03-19 | 8.6500 | 8.6500 | 8.8500 | 77.8200 | 54495.00 | 0.00 | 54495.00 | 63 | 11 | 205 | 1073 | 0.191053122087605 | 0.456740013602186 | 0.456502089563015 | false | false | false | true | ||||||||||||||||
| d81ad9d1-81ca-4cab-8e93-d1e3d9eebcfd | 2026-09-21 15:20 | 2026-09-21 15:19 | 2026-09-21 15:19 | XYZ | XYZ270319C00082500 | call | 82.5000 | 2027-03-19 | 8.8000 | 8.4500 | 8.8000 | 78.0400 | 478700.00 | 475200.00 | 3500.00 | 544 | 12 | 752 | 1073 | 0.700838769804287 | 0.458390459757563 | 0.458151303687473 | false | false | false | true | ||||||||||||||||
| e04e0800-55dc-409b-979f-1af71fbb2ce2 | 2026-09-29 15:35 | 2026-09-29 15:35 | 2026-09-29 15:35 | XYZ | XYZ270319C00082500 | call | 82.5000 | 2027-03-19 | 6.6000 | 6.4000 | 6.8000 | 73.9250 | 320760.00 | 92400.00 | 128700.00 | 486 | 14 | 501 | 2005 | 0.249875311720698 | 0.459221588524572 | 0.459221588524572 | true | false | false | true | ||||||||||||||||
| 863e18f1-846d-4ea9-8706-a7a52b207588 | 2026-09-29 15:36 | 2026-09-29 15:36 | 2026-09-29 15:36 | XYZ | XYZ270319C00082500 | call | 82.5000 | 2027-03-19 | 6.6500 | 6.4000 | 6.7500 | 74.0000 | 51870.00 | 665.00 | 33250.00 | 78 | 5 | 729 | 2005 | 0.36359102244389 | 0.459805314875532 | 0.459805314875532 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42989463840.00 |
| 2026-11-05 |
| unknown |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42989463840.00 |
| 2026-11-05 |
| unknown |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 41356199520.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 41356199520.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 41253444480.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 41253444480.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:25:30.671610Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 41253444480.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:45:45.480252Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 42134974560.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:27:55.894324Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42134974560.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:34:45.939712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 42134974560.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40047424800.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:36:36.492519Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40047424800.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:43:26.980226Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |