PREVIEW / stock_1hour / 2008-07-22
file: by_date/stock_1hour/2008/2008-07-22.parquet size: 834 KB rows: 40,255 symbols: 3,325
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-07-22 04:00:00 | AAPL | Stock | 5.3214 | 5.3571 | 5.3214 | 5.3389 | 61600.0 |
| 2008-07-22 05:00:00 | AAPL | Stock | 5.3393 | 5.3571 | 5.3143 | 5.3571 | 572320.0 |
| 2008-07-22 06:00:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3571 | 5.3571 | 16800.0 |
| 2008-07-22 07:00:00 | AAPL | Stock | 5.3393 | 5.3643 | 5.3089 | 5.3143 | 3702300.0 |
| 2008-07-22 08:00:00 | AAPL | Stock | 5.3089 | 5.3957 | 5.2921 | 5.3575 | 32711420.0 |
| 2008-07-22 09:00:00 | AAPL | Stock | 5.3536 | 5.4554 | 5.2332 | 5.4182 | 427127260.0 |
| 2008-07-22 10:00:00 | AAPL | Stock | 5.4182 | 5.4849 | 5.4 | 5.4629 | 320138616.0 |
| 2008-07-22 11:00:00 | AAPL | Stock | 5.4629 | 5.5021 | 5.4475 | 5.4811 | 170862580.0 |
| 2008-07-22 12:00:00 | AAPL | Stock | 5.4811 | 5.4829 | 5.4221 | 5.4747 | 99064392.0 |
| 2008-07-22 13:00:00 | AAPL | Stock | 5.475 | 5.5386 | 5.4707 | 5.5374 | 147127736.0 |
| 2008-07-22 14:00:00 | AAPL | Stock | 5.5379 | 5.6864 | 5.5307 | 5.6839 | 291682048.0 |
| 2008-07-22 15:00:00 | AAPL | Stock | 5.6839 | 5.8129 | 5.6457 | 5.7925 | 355554248.0 |
| 2008-07-22 16:00:00 | AAPL | Stock | 5.7925 | 5.8004 | 5.5154 | 5.7875 | 14656880.0 |
| 2008-07-22 17:00:00 | AAPL | Stock | 5.7879 | 5.7893 | 5.7768 | 5.7821 | 1224188.0 |
| 2008-07-22 18:00:00 | AAPL | Stock | 5.7821 | 5.8018 | 5.7821 | 5.8018 | 2366448.0 |
| 2008-07-22 19:00:00 | AAPL | Stock | 5.7954 | 5.8018 | 5.7864 | 5.8018 | 406308.0 |
| 2008-07-22 06:00:00 | MSFT | Stock | 25.35 | 25.35 | 25.35 | 25.35 | 400.0 |
| 2008-07-22 07:00:00 | MSFT | Stock | 25.35 | 25.45 | 25.35 | 25.35 | 2800.0 |
| 2008-07-22 08:00:00 | MSFT | Stock | 25.36 | 25.48 | 25.36 | 25.4 | 87465.0 |
| 2008-07-22 09:00:00 | MSFT | Stock | 25.4 | 25.65 | 25.38 | 25.63 | 12453276.0 |
| 2008-07-22 10:00:00 | MSFT | Stock | 25.62 | 25.94 | 25.53 | 25.54 | 13949535.0 |
| 2008-07-22 11:00:00 | MSFT | Stock | 25.54 | 25.6 | 25.48 | 25.505 | 9697595.0 |
| 2008-07-22 12:00:00 | MSFT | Stock | 25.5 | 25.68 | 25.5 | 25.68 | 9602486.0 |
| 2008-07-22 13:00:00 | MSFT | Stock | 25.68 | 25.73 | 25.63 | 25.7 | 11465431.0 |
| 2008-07-22 14:00:00 | MSFT | Stock | 25.7 | 25.74 | 25.57 | 25.6 | 12139290.0 |
| 2008-07-22 15:00:00 | MSFT | Stock | 25.6 | 25.8 | 25.58 | 25.8 | 15645268.0 |
| 2008-07-22 16:00:00 | MSFT | Stock | 25.782 | 25.8 | 25.625 | 25.8 | 1752151.0 |
| 2008-07-22 17:00:00 | MSFT | Stock | 25.8 | 25.8 | 25.76 | 25.76 | 4976.0 |
| 2008-07-22 18:00:00 | MSFT | Stock | 25.8 | 25.8 | 25.8 | 25.8 | 238020.0 |
| 2008-07-22 19:00:00 | MSFT | Stock | 25.8 | 25.87 | 25.78 | 25.81 | 16300.0 |
| 2008-07-22 08:00:00 | NVDA | Stock | 0.2825 | 0.2878 | 0.2825 | 0.2878 | 347280.0 |
| 2008-07-22 09:00:00 | NVDA | Stock | 0.2865 | 0.2892 | 0.279 | 0.282 | 89414480.0 |
| 2008-07-22 10:00:00 | NVDA | Stock | 0.2818 | 0.287 | 0.2808 | 0.2812 | 68231680.0 |
| 2008-07-22 11:00:00 | NVDA | Stock | 0.2812 | 0.2855 | 0.281 | 0.2851 | 72970280.0 |
| 2008-07-22 12:00:00 | NVDA | Stock | 0.285 | 0.2875 | 0.2844 | 0.2855 | 61219440.0 |
| 2008-07-22 13:00:00 | NVDA | Stock | 0.2858 | 0.286 | 0.2819 | 0.2828 | 71434160.0 |
| 2008-07-22 14:00:00 | NVDA | Stock | 0.2827 | 0.2832 | 0.2805 | 0.2828 | 59756000.0 |
| 2008-07-22 15:00:00 | NVDA | Stock | 0.283 | 0.285 | 0.2825 | 0.2845 | 103403280.0 |
| 2008-07-22 16:00:00 | NVDA | Stock | 0.2845 | 0.2848 | 0.282 | 0.2845 | 9421080.0 |
| 2008-07-22 17:00:00 | NVDA | Stock | 0.2838 | 0.2845 | 0.2838 | 0.2838 | 41200.0 |
| 2008-07-22 18:00:00 | NVDA | Stock | 0.2838 | 0.2838 | 0.2835 | 0.2835 | 252000.0 |
| 2008-07-22 19:00:00 | NVDA | Stock | 0.2828 | 0.283 | 0.2828 | 0.283 | 24000.0 |
| 2008-07-22 08:00:00 | AMZN | Stock | 3.34 | 3.35 | 3.325 | 3.3375 | 349000.0 |
| 2008-07-22 09:00:00 | AMZN | Stock | 3.335 | 3.406 | 3.33 | 3.3935 | 19660040.0 |
| 2008-07-22 10:00:00 | AMZN | Stock | 3.3935 | 3.457 | 3.344 | 3.3455 | 30482920.0 |
| 2008-07-22 11:00:00 | AMZN | Stock | 3.3455 | 3.3845 | 3.345 | 3.3555 | 20246980.0 |
| 2008-07-22 12:00:00 | AMZN | Stock | 3.3555 | 3.3665 | 3.3475 | 3.349 | 14960800.0 |
| 2008-07-22 13:00:00 | AMZN | Stock | 3.3485 | 3.358 | 3.3175 | 3.3185 | 18809100.0 |
| 2008-07-22 14:00:00 | AMZN | Stock | 3.318 | 3.334 | 3.294 | 3.3335 | 34196340.0 |
| 2008-07-22 15:00:00 | AMZN | Stock | 3.3345 | 3.3985 | 3.325 | 3.3975 | 28523840.0 |
> showing 50 of 40,255 rows — these rows as CSV