PREVIEW / stock_1hour / 2009-09-17
file: by_date/stock_1hour/2009/2009-09-17.parquet size: 896 KB rows: 42,492 symbols: 3,384
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2009-09-17 07:00:00 | AAPL | Stock | 6.4968 | 6.51 | 6.4893 | 6.4982 | 82432.0 |
| 2009-09-17 08:00:00 | AAPL | Stock | 6.5 | 6.5321 | 6.4921 | 6.4921 | 3329340.0 |
| 2009-09-17 09:00:00 | AAPL | Stock | 6.4943 | 6.5786 | 6.4932 | 6.5671 | 114442468.0 |
| 2009-09-17 10:00:00 | AAPL | Stock | 6.5679 | 6.6239 | 6.5536 | 6.6111 | 157947300.0 |
| 2009-09-17 11:00:00 | AAPL | Stock | 6.6128 | 6.6711 | 6.61 | 6.6464 | 161384244.0 |
| 2009-09-17 12:00:00 | AAPL | Stock | 6.6465 | 6.6536 | 6.5729 | 6.5743 | 108409504.0 |
| 2009-09-17 13:00:00 | AAPL | Stock | 6.5743 | 6.6279 | 6.5725 | 6.6207 | 81097016.0 |
| 2009-09-17 14:00:00 | AAPL | Stock | 6.6207 | 6.6243 | 6.5921 | 6.6171 | 60057452.0 |
| 2009-09-17 15:00:00 | AAPL | Stock | 6.6164 | 6.6257 | 6.5843 | 6.5918 | 107185820.0 |
| 2009-09-17 16:00:00 | AAPL | Stock | 6.5911 | 6.6264 | 6.5811 | 6.5893 | 12851496.0 |
| 2009-09-17 17:00:00 | AAPL | Stock | 6.5929 | 6.5936 | 6.5618 | 6.5654 | 371728.0 |
| 2009-09-17 18:00:00 | AAPL | Stock | 6.5654 | 6.5911 | 6.5436 | 6.5571 | 1137976.0 |
| 2009-09-17 19:00:00 | AAPL | Stock | 6.5539 | 6.5589 | 6.5536 | 6.5557 | 487956.0 |
| 2009-09-17 04:00:00 | MSFT | Stock | 25.43 | 25.43 | 25.43 | 25.43 | 400.0 |
| 2009-09-17 08:00:00 | MSFT | Stock | 25.2 | 25.2 | 25.07 | 25.1 | 36897.0 |
| 2009-09-17 09:00:00 | MSFT | Stock | 25.07 | 25.19 | 25.05 | 25.15 | 3930929.0 |
| 2009-09-17 10:00:00 | MSFT | Stock | 25.15 | 25.18 | 25.065 | 25.18 | 7457096.0 |
| 2009-09-17 11:00:00 | MSFT | Stock | 25.17 | 25.27 | 25.14 | 25.19 | 5252767.0 |
| 2009-09-17 12:00:00 | MSFT | Stock | 25.19 | 25.22 | 25.06 | 25.14 | 4137640.0 |
| 2009-09-17 13:00:00 | MSFT | Stock | 25.13 | 25.21 | 25.12 | 25.15 | 3919884.0 |
| 2009-09-17 14:00:00 | MSFT | Stock | 25.16 | 25.27 | 25.14 | 25.25 | 4071605.0 |
| 2009-09-17 15:00:00 | MSFT | Stock | 25.24 | 25.38 | 25.23 | 25.3 | 9151311.0 |
| 2009-09-17 16:00:00 | MSFT | Stock | 25.29 | 25.32 | 25.186 | 25.3 | 3045864.0 |
| 2009-09-17 17:00:00 | MSFT | Stock | 25.28 | 25.28 | 25.28 | 25.28 | 1301.0 |
| 2009-09-17 18:00:00 | MSFT | Stock | 25.28 | 25.3 | 25.25 | 25.25 | 13362.0 |
| 2009-09-17 19:00:00 | MSFT | Stock | 25.25 | 25.25 | 25.24 | 25.24 | 2825.0 |
| 2009-09-17 05:00:00 | NVDA | Stock | 0.4 | 0.4 | 0.4 | 0.4 | 8000.0 |
| 2009-09-17 06:00:00 | NVDA | Stock | 0.4 | 0.4 | 0.4 | 0.4 | 4000.0 |
| 2009-09-17 08:00:00 | NVDA | Stock | 0.3953 | 0.3955 | 0.3938 | 0.3938 | 103080.0 |
| 2009-09-17 09:00:00 | NVDA | Stock | 0.3962 | 0.3975 | 0.392 | 0.394 | 71186240.0 |
| 2009-09-17 10:00:00 | NVDA | Stock | 0.3942 | 0.395 | 0.3865 | 0.3885 | 191041800.0 |
| 2009-09-17 11:00:00 | NVDA | Stock | 0.3885 | 0.3888 | 0.3825 | 0.3838 | 107307640.0 |
| 2009-09-17 12:00:00 | NVDA | Stock | 0.384 | 0.384 | 0.3768 | 0.3778 | 120721320.0 |
| 2009-09-17 13:00:00 | NVDA | Stock | 0.3775 | 0.3791 | 0.3742 | 0.379 | 159090080.0 |
| 2009-09-17 14:00:00 | NVDA | Stock | 0.379 | 0.3808 | 0.378 | 0.3808 | 98143320.0 |
| 2009-09-17 15:00:00 | NVDA | Stock | 0.3805 | 0.3833 | 0.3805 | 0.3808 | 156599720.0 |
| 2009-09-17 16:00:00 | NVDA | Stock | 0.381 | 0.3837 | 0.3808 | 0.3818 | 14334320.0 |
| 2009-09-17 17:00:00 | NVDA | Stock | 0.382 | 0.382 | 0.3813 | 0.3813 | 20000.0 |
| 2009-09-17 18:00:00 | NVDA | Stock | 0.382 | 0.3828 | 0.382 | 0.3828 | 36000.0 |
| 2009-09-17 08:00:00 | AMZN | Stock | 4.535 | 4.5875 | 4.525 | 4.5425 | 359440.0 |
| 2009-09-17 09:00:00 | AMZN | Stock | 4.5445 | 4.55 | 4.4625 | 4.476 | 31473720.0 |
| 2009-09-17 10:00:00 | AMZN | Stock | 4.479 | 4.5125 | 4.45 | 4.4985 | 31235040.0 |
| 2009-09-17 11:00:00 | AMZN | Stock | 4.4985 | 4.519 | 4.475 | 4.4855 | 16411280.0 |
| 2009-09-17 12:00:00 | AMZN | Stock | 4.4855 | 4.5 | 4.457 | 4.4575 | 15191120.0 |
| 2009-09-17 13:00:00 | AMZN | Stock | 4.457 | 4.5125 | 4.4525 | 4.5065 | 12475560.0 |
| 2009-09-17 14:00:00 | AMZN | Stock | 4.506 | 4.5595 | 4.498 | 4.5485 | 18543200.0 |
| 2009-09-17 15:00:00 | AMZN | Stock | 4.547 | 4.5535 | 4.509 | 4.5245 | 26398600.0 |
| 2009-09-17 16:00:00 | AMZN | Stock | 4.522 | 4.525 | 4.5 | 4.522 | 4259300.0 |
| 2009-09-17 17:00:00 | AMZN | Stock | 4.522 | 4.522 | 4.516 | 4.516 | 326000.0 |
| 2009-09-17 18:00:00 | AMZN | Stock | 4.511 | 4.511 | 4.5105 | 4.5105 | 22000.0 |
> showing 50 of 42,492 rows — these rows as CSV