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 |
|---|
| 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 |
|---|
| 98993f92-4251-432c-a2eb-811cbd726bee | 2026-09-21 10:37 | 2026-09-21 10:37 | 2026-09-21 10:37 | AVGO | AVGO261030C00420000 | call | 420.0000 | 2026-10-30 | 2.4900 | 2.4600 | 2.4900 | 358.1250 | 14923.00 | 14923.00 | 0.00 | 60 | 17 | 1133 | 68 | 16.6617647058824 | 0.382165789289962 | 0.381736742674262 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 1731204606841.00 | 2026-12-10 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:39:35.705687Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 5be511c4-8daa-4f81-b1ee-57d816d803eb | 2026-09-21 10:50 | 2026-09-21 10:50 | 2026-09-21 10:50 | AVGO | AVGO261030C00420000 | call | 420.0000 | 2026-10-30 | 2.4800 | 2.4500 | 2.4800 | 357.8050 | 24763.00 | 24763.00 | 0.00 | 100 | 18 | 2586 | 68 | 38.0294117647059 | 0.383372843867806 | 0.382941873374555 | true | false | false | |||||||||||||||||
| f8630384-5cab-4741-b6e0-be148a2dd361 | 2026-09-22 15:37 | 2026-09-22 15:37 | 2026-09-22 15:37 | AVGO | AVGO261030C00420000 | call | 420.0000 | 2026-10-30 | 3.7500 | 3.7500 | 3.8000 | 365.0800 | 61541.00 | 0.00 | 61541.00 | 164 | 25 | 3589 | 3824 | 0.938546025104602 | 0.39925871937256 | 0.398911655560158 | false | false | false | |||||||||||||||||
| c1477279-f684-4d2c-ad77-f767304a475a | 2026-09-23 11:34 | 2026-09-23 11:34 | 2026-09-23 11:34 | AVGO | AVGO261030C00420000 | call | 420.0000 | 2026-10-30 | 2.4500 | 2.4000 | 2.4600 | 356.5500 | 36750.00 | 36750.00 | 0.00 | 150 | 20 | 2200 | 2435 | 0.903490759753593 | 0.399758157185732 | 0.398356189403371 | false | false | false | |||||||||||||||||
| 14394188-6c88-4331-8fbe-b8afc8f7085c | 2026-09-25 09:53 | 2026-09-25 09:53 | 2026-09-25 09:53 | AVGO | AVGO261030C00420000 | call | 420.0000 | 2026-10-30 | 1.8900 | 1.7800 | 1.9000 | 353.5500 | 37834.00 | 28384.00 | 0.00 | 200 | 25 | 596 | 7393 | 0.0806167996753686 | 0.399380912182909 | 0.397779332202864 | false | false | false | |||||||||||||||||
| 4155ed39-c05b-464f-b517-e299e8cbc70c | 2026-09-25 13:19 | 2026-09-25 13:19 | 2026-09-25 13:19 | AVGO | AVGO261030C00420000 | call | 420.0000 | 2026-10-30 | 1.9000 | 1.8500 | 1.9100 | 352.0000 | 18965.00 | 18965.00 | 0.00 | 100 | 8 | 4034 | 7393 | 0.545651291762478 | 0.403737522094888 | 0.402666948523338 | false | false | false | |||||||||||||||||
| 71a2ecb3-6c2b-41eb-90a1-013565ad780d | 2026-09-29 10:31 | 2026-09-29 10:31 | 2026-09-29 10:31 | AVGO | AVGO261030C00420000 | call | 420.0000 | 2026-10-30 | 2.1500 | 2.1400 | 2.2000 | 361.2250 | 18703.00 | 0.00 | 11393.00 | 87 | 14 | 1631 | 12866 | 0.126768226332971 | 0.39601269297799 | 0.39551246104981 | true | false | false | |||||||||||||||||
| 504c9969-63be-45d7-ae6f-191b58bac328 | 2026-09-29 10:31 | 2026-09-29 10:31 | 2026-09-29 10:31 | AVGO | AVGO261030C00420000 | call | 420.0000 | 2026-10-30 | 2.1600 | 2.1500 | 2.2000 | 361.2500 | 23342.00 | 1752.00 | 21590.00 | 108 | 19 | 1541 | 12866 | 0.119773045235504 | 0.397751509299024 | 0.395873169275707 | false | false | false | |||||||||||||||||
| 06636b76-718c-467f-8492-04c3d3ddfb62 | 2026-09-29 10:37 | 2026-09-29 10:37 | 2026-09-29 10:37 | AVGO | AVGO261030C00420000 | call | 420.0000 | 2026-10-30 | 2.1300 | 2.1200 | 2.1500 | 360.9899 | 34249.00 | 2343.00 | 31906.00 | 161 | 23 | 4849 | 12866 | 0.376884812684595 | 0.396599230724658 | 0.39632117700713 | false | false | false | |||||||||||||||||
| 00b9cdca-cc1d-40ed-85e9-5ee228d5a6fd | 2026-09-29 10:39 | 2026-09-29 10:39 | 2026-09-29 10:39 | AVGO | AVGO261030C00420000 | call | 420.0000 | 2026-10-30 | 2.0600 | 2.0500 | 2.0700 | 361.2450 | 20197.00 | 10350.00 | 8405.00 | 98 | 25 | 6953 | 12866 | 0.540416601896471 | 0.39133427454315 | 0.391870600064855 | false | false | false | |||||||||||||||||
| 2143c95d-2cc7-43bb-8ddf-bdcb314edfb9 | 2026-09-29 10:39 | 2026-09-29 10:39 | 2026-09-29 10:39 | AVGO | AVGO261030C00420000 | call | 420.0000 | 2026-10-30 | 2.0600 | 2.0500 | 2.0800 | 361.2800 | 23680.00 | 10300.00 | 8436.00 | 115 | 11 | 7068 | 12866 | 0.549354888854345 | 0.391168092447598 | 0.390658527764068 | false | false | false | |||||||||||||||||
| b83ee2b4-f31b-4442-81cb-a3f658b09cc4 | 2026-09-29 10:42 | 2026-09-29 10:42 | 2026-09-29 10:42 | AVGO | AVGO261030C00420000 | call | 420.0000 | 2026-10-30 | 2.1000 | 2.1000 | 2.1300 | 361.7050 | 42006.00 | 0.00 | 42006.00 | 200 | 6 | 8221 | 12866 | 0.638970931136328 | 0.391725433149325 | 0.390833426774976 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1731204606841.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:51:11.587541Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1740179030987.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1694590865776.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:35:15.101362Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1684184352671.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:54:35.682199Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1684184352671.00 |
| 2026-12-10 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:23:42.010099Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1695115965062.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:32:52.206353Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1695115965062.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:32:52.206353Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1695115965062.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:40:22.882759Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1695115965062.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:40:22.882759Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1695115965062.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:40:22.882759Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1695115965062.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:43:57.970888Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |