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 |
|---|
| 92eb6d1e-c474-4eb1-85df-20239840f745 | 2026-09-09 11:32 | 2026-09-09 11:32 | 2026-09-09 11:32 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 43.3500 | 43.1000 | 43.7500 | 360.5400 | 260101.00 | 0.00 | 260101.00 | 60 | 13 | 108 | 4720 | 0.0228813559322034 | 0.425314471601554 | 0.425314471601554 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1645565687063.00 | 2026-12-10 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 96a0cdbd-dc1d-4a02-9a27-b661957a23b9 | 2026-09-09 12:47 | 2026-09-09 12:47 | 2026-09-09 12:47 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 43.7500 | 43.7500 | 44.1500 | 361.0000 | 271250.00 | 0.00 | 271250.00 | 62 | 7 | 179 | 4720 | 0.0379237288135593 | 0.423632021900712 | 0.423632021900712 | false | false | false | |||||||||||||||||
| 51c330b4-4e6a-4304-a0ad-ee07f2cc6875 | 2026-09-14 10:59 | 2026-09-14 10:59 | 2026-09-14 10:59 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 32.2800 | 32.0000 | 32.5500 | 344.1500 | 100068.00 | 100068.00 | 0.00 | 31 | 5 | 502 | 4750 | 0.105684210526316 | 0.411774356647174 | 0.411774356647174 | false | false | false | |||||||||||||||||
| 16a11d21-0f6e-4b7d-a51a-670c5ac7ae45 | 2026-09-17 09:35 | 2026-09-17 09:35 | 2026-09-17 09:35 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 33.0000 | 32.2000 | 33.0000 | 348.0300 | 273900.00 | 273900.00 | 0.00 | 83 | 6 | 129 | 5508 | 0.0234204793028322 | 0.398710825992948 | 0.398710825992948 | false | false | false | |||||||||||||||||
| 0ea43496-d30c-4466-b31d-5c5eb9efe4cb | 2026-09-21 09:36 | 2026-09-21 09:36 | 2026-09-21 09:36 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 37.4900 | 36.7500 | 38.2500 | 355.4200 | 52490.00 | 14990.00 | 22500.00 | 14 | 5 | 77 | 5400 | 0.0142592592592593 | 0.409519055448561 | 0.409519055448561 | true | false | false | |||||||||||||||||
| 06b40263-019c-42bf-b1b2-390e8023e5fa | 2026-09-23 09:40 | 2026-09-23 09:39 | 2026-09-23 09:39 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 38.9500 | 38.9500 | 40.1500 | 357.6350 | 38950.00 | 0.00 | 38950.00 | 10 | 5 | 19 | 5411 | 0.00351136573646276 | 0.415054833541225 | 0.415054833541225 | false | false | false | |||||||||||||||||
| 50a568e6-b468-4a67-9f25-27ae4e425ac9 | 2026-09-25 14:36 | 2026-09-25 14:36 | 2026-09-25 14:36 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 35.2200 | 35.0500 | 35.2500 | 352.9650 | 56345.00 | 56345.00 | 0.00 | 16 | 5 | 232 | 5737 | 0.0404392539654872 | 0.40600105194322 | 0.40665622407582 | false | false | false | |||||||||||||||||
| b2a7c140-ac65-414e-a844-59aa06b0e67c | 2026-09-28 15:21 | 2026-09-28 15:21 | 2026-09-28 15:21 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 32.9000 | 32.9000 | 33.0000 | 349.6900 | 55930.00 | 0.00 | 55930.00 | 17 | 6 | 634 | 5806 | 0.109197382018601 | 0.406838138839336 | 0.406838138839336 | false | false | false | |||||||||||||||||
| 92c890b2-1455-4003-8d28-2192ba5e30f5 | 2026-09-29 12:27 | 2026-09-29 12:27 | 2026-09-29 12:27 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 37.6100 | 37.5000 | 38.0000 | 357.0700 | 33845.00 | 7525.00 | 26320.00 | 9 | 7 | 259 | 5999 | 0.0431738623103851 | 0.414128460962615 | 0.414795612371542 | false | false | false | |||||||||||||||||
| ca4a4168-6d32-4f54-b9cd-742b43b1e810 | 2026-10-01 14:41 | 2026-10-01 14:41 | 2026-10-01 14:41 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 31.4000 | 30.7500 | 31.4000 | 347.5450 | 37680.00 | 37680.00 | 0.00 | 12 | 5 | 294 | 5939 | 0.0495032833810406 | 0.409485471764773 | 0.409485471764773 | false | false | false | |||||||||||||||||
| d465f57c-7ed4-4d28-aec2-7a9445e1d262 | 2026-10-02 13:41 | 2026-10-02 13:41 | 2026-10-02 13:41 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 33.0000 | 33.0000 | 33.8000 | 351.7000 | 46205.00 | 3305.00 | 42900.00 | 14 | 5 | 365 | 6141 | 0.0594365738479075 | 0.402290519026963 | 0.40182473206524 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1645565687063.00 |
| 2026-12-10 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1645565687063.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1657881652115.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1695306910256.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T13:37:32.114796Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1695306910256.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:41:33.731511Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1684184352671.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:38:37.498256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1668717791908.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:23:02.177643Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1695115965062.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:30:08.808043Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1640410166809.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T18:43:39.301035Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1695306910256.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T17:46:42.697780Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |