PREVIEW / stock_1hour / 2008-05-30
file: by_date/stock_1hour/2008/2008-05-30.parquet size: 863 KB rows: 40,872 symbols: 3,322
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-30 05:00:00 | AAPL | Stock | 6.7107 | 6.7107 | 6.7107 | 6.7107 | 2800.0 |
| 2008-05-30 06:00:00 | AAPL | Stock | 6.7107 | 6.7107 | 6.7107 | 6.7107 | 2800.0 |
| 2008-05-30 07:00:00 | AAPL | Stock | 6.7107 | 6.7132 | 6.6539 | 6.6539 | 57232.0 |
| 2008-05-30 08:00:00 | AAPL | Stock | 6.6793 | 6.7089 | 6.6793 | 6.705 | 1915256.0 |
| 2008-05-30 09:00:00 | AAPL | Stock | 6.7036 | 6.7375 | 6.6921 | 6.7307 | 104892200.0 |
| 2008-05-30 10:00:00 | AAPL | Stock | 6.7307 | 6.7564 | 6.7182 | 6.7371 | 130487224.0 |
| 2008-05-30 11:00:00 | AAPL | Stock | 6.7368 | 6.7518 | 6.7182 | 6.7507 | 63939120.0 |
| 2008-05-30 12:00:00 | AAPL | Stock | 6.75 | 6.7564 | 6.7375 | 6.7504 | 53566492.0 |
| 2008-05-30 13:00:00 | AAPL | Stock | 6.7504 | 6.765 | 6.7446 | 6.7521 | 54789952.0 |
| 2008-05-30 14:00:00 | AAPL | Stock | 6.752 | 6.7625 | 6.7386 | 6.7571 | 52215240.0 |
| 2008-05-30 15:00:00 | AAPL | Stock | 6.7579 | 6.7693 | 6.7236 | 6.7339 | 114570904.0 |
| 2008-05-30 16:00:00 | AAPL | Stock | 6.7339 | 6.7424 | 6.7289 | 6.7411 | 21928004.0 |
| 2008-05-30 17:00:00 | AAPL | Stock | 6.7375 | 6.75 | 6.7371 | 6.7418 | 2627184.0 |
| 2008-05-30 18:00:00 | AAPL | Stock | 6.7418 | 6.745 | 6.7393 | 6.7446 | 183624.0 |
| 2008-05-30 19:00:00 | AAPL | Stock | 6.7414 | 6.7454 | 6.7411 | 6.7454 | 265020.0 |
| 2008-05-30 08:00:00 | MSFT | Stock | 28.45 | 28.51 | 28.45 | 28.51 | 12545.0 |
| 2008-05-30 09:00:00 | MSFT | Stock | 28.49 | 28.7 | 28.3 | 28.505 | 6296905.0 |
| 2008-05-30 10:00:00 | MSFT | Stock | 28.51 | 28.66 | 28.48 | 28.54 | 6468237.0 |
| 2008-05-30 11:00:00 | MSFT | Stock | 28.55 | 28.57 | 28.43 | 28.45 | 9621930.0 |
| 2008-05-30 12:00:00 | MSFT | Stock | 28.455 | 28.47 | 28.36 | 28.45 | 5182477.0 |
| 2008-05-30 13:00:00 | MSFT | Stock | 28.45 | 28.56 | 28.44 | 28.492 | 7501015.0 |
| 2008-05-30 14:00:00 | MSFT | Stock | 28.49 | 28.498 | 28.329 | 28.38 | 7003958.0 |
| 2008-05-30 15:00:00 | MSFT | Stock | 28.37 | 28.45 | 28.2 | 28.23 | 12057939.0 |
| 2008-05-30 16:00:00 | MSFT | Stock | 28.23 | 28.6 | 28.18 | 28.413 | 6621683.0 |
| 2008-05-30 17:00:00 | MSFT | Stock | 28.322 | 28.45 | 28.24 | 28.45 | 611958.0 |
| 2008-05-30 18:00:00 | MSFT | Stock | 28.28 | 28.28 | 28.23 | 28.28 | 4182.0 |
| 2008-05-30 19:00:00 | MSFT | Stock | 28.28 | 28.31 | 28.28 | 28.31 | 28675.0 |
| 2008-05-30 08:00:00 | NVDA | Stock | 0.6 | 0.6025 | 0.5963 | 0.6025 | 1076400.0 |
| 2008-05-30 09:00:00 | NVDA | Stock | 0.6033 | 0.6125 | 0.6025 | 0.6115 | 129836680.0 |
| 2008-05-30 10:00:00 | NVDA | Stock | 0.6113 | 0.6135 | 0.6075 | 0.6125 | 120895040.0 |
| 2008-05-30 11:00:00 | NVDA | Stock | 0.6128 | 0.614 | 0.6085 | 0.6118 | 108066040.0 |
| 2008-05-30 12:00:00 | NVDA | Stock | 0.6118 | 0.614 | 0.6093 | 0.6128 | 109171560.0 |
| 2008-05-30 13:00:00 | NVDA | Stock | 0.6128 | 0.6135 | 0.6105 | 0.6125 | 63649560.0 |
| 2008-05-30 14:00:00 | NVDA | Stock | 0.6122 | 0.6195 | 0.611 | 0.619 | 111540520.0 |
| 2008-05-30 15:00:00 | NVDA | Stock | 0.619 | 0.6195 | 0.615 | 0.6175 | 154953920.0 |
| 2008-05-30 16:00:00 | NVDA | Stock | 0.6183 | 0.6188 | 0.6126 | 0.6176 | 5564760.0 |
| 2008-05-30 17:00:00 | NVDA | Stock | 0.6176 | 0.6223 | 0.6126 | 0.619 | 2143640.0 |
| 2008-05-30 18:00:00 | NVDA | Stock | 0.6218 | 0.6218 | 0.6218 | 0.6218 | 4000.0 |
| 2008-05-30 19:00:00 | NVDA | Stock | 0.6215 | 0.6215 | 0.6215 | 0.6215 | 6000.0 |
| 2008-05-30 09:00:00 | AMZN | Stock | 4.036 | 4.047 | 4.015 | 4.041 | 14442480.0 |
| 2008-05-30 10:00:00 | AMZN | Stock | 4.04 | 4.0535 | 4.025 | 4.0385 | 15666660.0 |
| 2008-05-30 11:00:00 | AMZN | Stock | 4.039 | 4.0635 | 4.034 | 4.0545 | 15093540.0 |
| 2008-05-30 12:00:00 | AMZN | Stock | 4.0545 | 4.0715 | 4.0525 | 4.0665 | 10169900.0 |
| 2008-05-30 13:00:00 | AMZN | Stock | 4.067 | 4.068 | 4.0585 | 4.062 | 7863620.0 |
| 2008-05-30 14:00:00 | AMZN | Stock | 4.062 | 4.082 | 4.0595 | 4.0805 | 11309460.0 |
| 2008-05-30 15:00:00 | AMZN | Stock | 4.08 | 4.0885 | 4.0735 | 4.0765 | 23176860.0 |
| 2008-05-30 16:00:00 | AMZN | Stock | 4.081 | 4.0818 | 4.0576 | 4.0811 | 1878300.0 |
| 2008-05-30 17:00:00 | AMZN | Stock | 4.0809 | 4.0818 | 4.0576 | 4.0585 | 724580.0 |
| 2008-05-30 18:00:00 | AMZN | Stock | 4.07 | 4.07 | 4.07 | 4.07 | 10000.0 |
| 2008-05-30 19:00:00 | AMZN | Stock | 4.07 | 4.07 | 4.07 | 4.07 | 24000.0 |
> showing 50 of 40,872 rows — these rows as CSV