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 |
|---|
| db47d28d-5963-4c96-ac24-27f264dbbf8b | 2026-09-25 13:41 | 2026-09-25 13:41 | 2026-09-25 13:41 | AMZN | AMZN261002C00250000 | call | 250.0000 | 2026-10-02 | 4.0300 | 3.9500 | 4.0500 | 250.1200 | 12503.00 | 12503.00 | 0.00 | 31 | 22 | 11222 | 4762 | 2.35657286854263 | 0.279665003839958 | 0.279665003839958 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 2693018909521.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T17:50:01.932714Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 91a6dcb2-d0f7-4898-a118-7006f5edb409 | 2026-09-25 13:41 | 2026-09-25 13:41 | 2026-09-25 13:41 | AMZN | AMZN261002C00250000 | call | 250.0000 | 2026-10-02 | 4.0300 | 3.9500 | 4.1000 | 250.0900 | 11272.00 | 6448.00 | 4824.00 | 28 | 24 | 11265 | 4762 | 2.36560268794624 | 0.28079531073301 | 0.281519915254758 | false | false | false | |||||||||||||||||
| 591d23fb-916b-4af4-92f9-f9e62da4af06 | 2026-09-28 15:04 | 2026-09-28 15:04 | 2026-09-28 15:04 | AMZN | AMZN261002C00250000 | call | 250.0000 | 2026-10-02 | 1.7800 | 1.7600 | 1.8000 | 246.1029 | 89235.00 | 42065.00 | 0.00 | 500 | 7 | 11239 | 11289 | 0.99557090973514 | 0.322220317874505 | 0.323289815322726 | true | false | false | |||||||||||||||||
| a6192407-4459-496a-b887-737c95c8e54b | 2026-09-29 14:00 | 2026-09-29 14:00 | 2026-09-29 14:00 | AMZN | AMZN261002C00250000 | call | 250.0000 | 2026-10-02 | 1.6600 | 1.6200 | 1.6600 | 246.6150 | 17060.00 | 17060.00 | 0.00 | 103 | 8 | 10760 | 12748 | 0.844053969250078 | 0.336416452887418 | 0.337348260944387 | true | false | false | |||||||||||||||||
| 0e323747-ef80-427f-b882-f700cb36e4b8 | 2026-09-30 09:58 | 2026-09-30 09:58 | 2026-09-30 09:58 | AMZN | AMZN261002C00250000 | call | 250.0000 | 2026-10-02 | 2.0000 | 1.9300 | 2.0500 | 248.6050 | 13394.00 | 13394.00 | 0.00 | 67 | 12 | 3907 | 12947 | 0.301768749517263 | 0.365871810071617 | 0.362234949387654 | false | false | false | |||||||||||||||||
| 06611d03-9eb3-4254-b4bd-07fdb68ec21d | 2026-09-30 10:00 | 2026-09-30 10:00 | 2026-09-30 10:00 | AMZN | AMZN261002C00250000 | call | 250.0000 | 2026-10-02 | 2.2000 | 2.1500 | 2.2300 | 249.0300 | 68647.00 | 68425.00 | 222.00 | 312 | 12 | 4697 | 12947 | 0.362786745964316 | 0.360337785055472 | 0.360001207128016 | true | false | false | |||||||||||||||||
| 8b8d1450-ee73-4782-9a62-49dce1ee6019 | 2026-09-30 10:04 | 2026-09-30 10:04 | 2026-09-30 10:04 | AMZN | AMZN261002C00250000 | call | 250.0000 | 2026-10-02 | 2.8600 | 2.7500 | 2.9300 | 250.1700 | 10026.00 | 7820.00 | 2206.00 | 35 | 7 | 6938 | 12947 | 0.535877037151464 | 0.358304556772105 | 0.363724909029068 | false | false | false | |||||||||||||||||
| 3ca185bc-effd-4735-b029-1ee3ba44180a | 2026-09-30 15:50 | 2026-09-30 15:50 | 2026-09-30 15:50 | AMZN | AMZN261002C00250000 | call | 250.0000 | 2026-10-02 | 2.6500 | 2.6000 | 2.7000 | 250.0000 | 51190.00 | 50661.00 | 529.00 | 193 | 23 | 14367 | 12947 | 1.10967791766432 | 0.334888315853003 | 0.337671945610405 | true | false | false | |||||||||||||||||
| 264bde45-da2e-4666-bc69-e52500c75489 | 2026-10-01 09:38 | 2026-10-01 09:38 | 2026-10-01 09:38 | AMZN | AMZN261002C00250000 | call | 250.0000 | 2026-10-02 | 2.5700 | 2.5700 | 2.6600 | 250.0000 | 23689.00 | 11610.00 | 12079.00 | 92 | 8 | 978 | 12059 | 0.0811012521767974 | 0.413098806829311 | 0.415031408956818 | false | false | false | |||||||||||||||||
| d2decfe5-4a84-4f14-a165-823cdc21a61c | 2026-10-02 09:31 | 2026-10-02 09:31 | 2026-10-02 09:31 | AMZN | AMZN261002C00250000 | call | 250.0000 | 2026-10-02 | 2.9900 | 2.8500 | 3.1000 | 252.4800 | 44307.00 | 14807.00 | 29500.00 | 148 | 17 | 1532 | 12851 | 0.11921251264493 | 0.517479994652136 | 0.568016578491634 | true | false | false | |||||||||||||||||
| 46cfe31d-e414-4428-a136-a0a649dd65cc | 2026-10-02 10:04 | 2026-10-02 10:04 | 2026-10-02 10:04 | AMZN | AMZN261002C00250000 | call | 250.0000 | 2026-10-02 | 2.7000 | 2.5700 | 2.7000 | 252.4000 | 56420.00 | 56420.00 | 0.00 | 209 | 6 | 7534 | 12851 | 0.586257878764298 | 0.411769654337118 | 0.423089100014988 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2693018909521.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:50:01.932714Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2655051085748.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:04:54.976253Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2660659968805.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:00:33.837310Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2660659968805.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:59:55.546961Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2660659968805.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:00:43.571575Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2660659968805.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:05:50.172417Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2660659968805.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:52:25.570899Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2677486617978.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:40:19.886026Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2712973589629.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T13:31:51.524532Z"} |
| 2026-10-02 |
| 2026-10-02 23:43 |
| 2026-10-02 23:43 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2712973589629.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T14:04:57.964450Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |