PREVIEW / stock_1hour / 2009-06-24
file: by_date/stock_1hour/2009/2009-06-24.parquet size: 845 KB rows: 41,427 symbols: 3,359
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-06-24 06:00:00 | AAPL | Stock | 4.7896 | 4.7896 | 4.7857 | 4.7857 | 8400.0 |
| 2009-06-24 07:00:00 | AAPL | Stock | 4.8207 | 4.8214 | 4.8007 | 4.8096 | 134428.0 |
| 2009-06-24 08:00:00 | AAPL | Stock | 4.8043 | 4.8679 | 4.7964 | 4.8604 | 3600380.0 |
| 2009-06-24 09:00:00 | AAPL | Stock | 4.8629 | 4.8643 | 4.8164 | 4.8536 | 76166916.0 |
| 2009-06-24 10:00:00 | AAPL | Stock | 4.8536 | 4.9089 | 4.8371 | 4.8807 | 104165348.0 |
| 2009-06-24 11:00:00 | AAPL | Stock | 4.8807 | 4.9107 | 4.8807 | 4.9043 | 37898112.0 |
| 2009-06-24 12:00:00 | AAPL | Stock | 4.9043 | 4.9057 | 4.8857 | 4.8975 | 29036336.0 |
| 2009-06-24 13:00:00 | AAPL | Stock | 4.8975 | 4.9071 | 4.8832 | 4.8874 | 25188324.0 |
| 2009-06-24 14:00:00 | AAPL | Stock | 4.8871 | 4.9032 | 4.8596 | 4.8818 | 76030304.0 |
| 2009-06-24 15:00:00 | AAPL | Stock | 4.882 | 4.8893 | 4.8375 | 4.8668 | 104509552.0 |
| 2009-06-24 16:00:00 | AAPL | Stock | 4.8664 | 4.8731 | 4.8643 | 4.87 | 17978212.0 |
| 2009-06-24 17:00:00 | AAPL | Stock | 4.8714 | 4.8839 | 4.7861 | 4.8779 | 601020.0 |
| 2009-06-24 18:00:00 | AAPL | Stock | 4.8771 | 4.8804 | 4.865 | 4.8804 | 866796.0 |
| 2009-06-24 19:00:00 | AAPL | Stock | 4.8782 | 4.8782 | 4.8704 | 4.8746 | 286076.0 |
| 2009-06-24 07:00:00 | MSFT | Stock | 23.41 | 23.45 | 23.41 | 23.45 | 1100.0 |
| 2009-06-24 08:00:00 | MSFT | Stock | 23.49 | 23.54 | 23.45 | 23.54 | 22534.0 |
| 2009-06-24 09:00:00 | MSFT | Stock | 23.55 | 23.6 | 23.4 | 23.445 | 5862947.0 |
| 2009-06-24 10:00:00 | MSFT | Stock | 23.46 | 23.7 | 23.36 | 23.7 | 11148262.0 |
| 2009-06-24 11:00:00 | MSFT | Stock | 23.697 | 23.75 | 23.61 | 23.63 | 4763445.0 |
| 2009-06-24 12:00:00 | MSFT | Stock | 23.63 | 23.72 | 23.59 | 23.69 | 5619130.0 |
| 2009-06-24 13:00:00 | MSFT | Stock | 23.69 | 23.75 | 23.64 | 23.675 | 3519017.0 |
| 2009-06-24 14:00:00 | MSFT | Stock | 23.68 | 23.75 | 23.48 | 23.59 | 10004706.0 |
| 2009-06-24 15:00:00 | MSFT | Stock | 23.59 | 23.64 | 23.39 | 23.49 | 10294218.0 |
| 2009-06-24 16:00:00 | MSFT | Stock | 23.49 | 23.59 | 23.47 | 23.49 | 2409509.0 |
| 2009-06-24 17:00:00 | MSFT | Stock | 23.34 | 23.51 | 23.34 | 23.5 | 9800.0 |
| 2009-06-24 18:00:00 | MSFT | Stock | 23.5 | 23.52 | 23.45 | 23.48 | 13243.0 |
| 2009-06-24 19:00:00 | MSFT | Stock | 23.47 | 23.5 | 23.47 | 23.5 | 500.0 |
| 2009-06-24 09:00:00 | NVDA | Stock | 0.265 | 0.2743 | 0.265 | 0.2731 | 104458200.0 |
| 2009-06-24 10:00:00 | NVDA | Stock | 0.273 | 0.2775 | 0.271 | 0.2763 | 138310880.0 |
| 2009-06-24 11:00:00 | NVDA | Stock | 0.2765 | 0.2772 | 0.2748 | 0.2763 | 38481640.0 |
| 2009-06-24 12:00:00 | NVDA | Stock | 0.2763 | 0.2768 | 0.274 | 0.274 | 37460480.0 |
| 2009-06-24 13:00:00 | NVDA | Stock | 0.2743 | 0.2748 | 0.273 | 0.273 | 18600040.0 |
| 2009-06-24 14:00:00 | NVDA | Stock | 0.2731 | 0.2748 | 0.27 | 0.2725 | 60436360.0 |
| 2009-06-24 15:00:00 | NVDA | Stock | 0.2728 | 0.2735 | 0.2695 | 0.2718 | 99073040.0 |
| 2009-06-24 16:00:00 | NVDA | Stock | 0.2715 | 0.275 | 0.2712 | 0.2712 | 16526200.0 |
| 2009-06-24 17:00:00 | NVDA | Stock | 0.2625 | 0.2712 | 0.2625 | 0.2712 | 788000.0 |
| 2009-06-24 08:00:00 | AMZN | Stock | 3.91 | 3.9215 | 3.91 | 3.9215 | 24840.0 |
| 2009-06-24 09:00:00 | AMZN | Stock | 3.9225 | 3.955 | 3.89 | 3.952 | 16027840.0 |
| 2009-06-24 10:00:00 | AMZN | Stock | 3.9525 | 4.0265 | 3.933 | 3.9925 | 31509800.0 |
| 2009-06-24 11:00:00 | AMZN | Stock | 3.994 | 4.011 | 3.985 | 3.9925 | 8783920.0 |
| 2009-06-24 12:00:00 | AMZN | Stock | 3.992 | 4.007 | 3.979 | 4.0035 | 8123920.0 |
| 2009-06-24 13:00:00 | AMZN | Stock | 4.004 | 4.0185 | 3.9805 | 3.984 | 8218100.0 |
| 2009-06-24 14:00:00 | AMZN | Stock | 3.985 | 4.015 | 3.9565 | 3.9765 | 19868720.0 |
| 2009-06-24 15:00:00 | AMZN | Stock | 3.977 | 3.9865 | 3.938 | 3.964 | 23612700.0 |
| 2009-06-24 16:00:00 | AMZN | Stock | 3.968 | 3.977 | 3.9635 | 3.9635 | 1104860.0 |
| 2009-06-24 17:00:00 | AMZN | Stock | 3.884 | 3.9725 | 3.884 | 3.9725 | 16000.0 |
| 2009-06-24 08:00:00 | TLT | Stock | 93.48 | 93.48 | 93.17 | 93.42 | 2100.0 |
| 2009-06-24 09:00:00 | TLT | Stock | 93.8 | 93.84 | 93.37 | 93.49 | 325054.0 |
| 2009-06-24 10:00:00 | TLT | Stock | 93.49 | 93.6 | 92.89 | 92.93 | 547373.0 |
| 2009-06-24 11:00:00 | TLT | Stock | 92.92 | 93.14 | 92.82 | 93.05 | 539443.0 |
> showing 50 of 41,427 rows — these rows as CSV