PREVIEW / stock_30min / 2006-09-13
file: by_date/stock_30min/2006/2006-09-13.parquet size: 913 KB rows: 49,611 symbols: 2,364
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-13 04:00:00 | AAPL | Stock | 2.5982 | 2.5982 | 2.5982 | 2.5982 | 140000.0 |
| 2006-09-13 06:30:00 | AAPL | Stock | 2.6018 | 2.6018 | 2.6018 | 2.6018 | 11200.0 |
| 2006-09-13 07:00:00 | AAPL | Stock | 2.6071 | 2.6114 | 2.6061 | 2.6061 | 19600.0 |
| 2006-09-13 08:00:00 | AAPL | Stock | 2.6071 | 2.6136 | 2.6061 | 2.6093 | 1859480.0 |
| 2006-09-13 08:30:00 | AAPL | Stock | 2.6096 | 2.6125 | 2.6054 | 2.6089 | 3753428.0 |
| 2006-09-13 09:00:00 | AAPL | Stock | 2.6093 | 2.6125 | 2.6 | 2.6011 | 5445188.0 |
| 2006-09-13 09:30:00 | AAPL | Stock | 2.6018 | 2.6386 | 2.5889 | 2.6225 | 200907476.0 |
| 2006-09-13 10:00:00 | AAPL | Stock | 2.6221 | 2.6229 | 2.5982 | 2.6118 | 140026152.0 |
| 2006-09-13 10:30:00 | AAPL | Stock | 2.6121 | 2.6121 | 2.5821 | 2.6021 | 111930308.0 |
| 2006-09-13 11:00:00 | AAPL | Stock | 2.6018 | 2.6171 | 2.6007 | 2.6125 | 73256148.0 |
| 2006-09-13 11:30:00 | AAPL | Stock | 2.6129 | 2.636 | 2.6032 | 2.6082 | 48709640.0 |
| 2006-09-13 12:00:00 | AAPL | Stock | 2.6082 | 2.6118 | 2.6029 | 2.6086 | 47612852.0 |
| 2006-09-13 12:30:00 | AAPL | Stock | 2.6082 | 2.6118 | 2.6054 | 2.6096 | 33936588.0 |
| 2006-09-13 13:00:00 | AAPL | Stock | 2.6096 | 2.6221 | 2.6093 | 2.6157 | 53654580.0 |
| 2006-09-13 13:30:00 | AAPL | Stock | 2.6154 | 2.6268 | 2.6125 | 2.6161 | 59719996.0 |
| 2006-09-13 14:00:00 | AAPL | Stock | 2.6157 | 2.6246 | 2.6129 | 2.6246 | 40109160.0 |
| 2006-09-13 14:30:00 | AAPL | Stock | 2.6236 | 2.6407 | 2.6232 | 2.6386 | 94771992.0 |
| 2006-09-13 15:00:00 | AAPL | Stock | 2.6386 | 2.64 | 2.6189 | 2.6257 | 85263108.0 |
| 2006-09-13 15:30:00 | AAPL | Stock | 2.6254 | 2.6543 | 2.6236 | 2.6475 | 133602644.0 |
| 2006-09-13 16:00:00 | AAPL | Stock | 2.6475 | 2.6518 | 2.6464 | 2.6482 | 1577940.0 |
| 2006-09-13 16:30:00 | AAPL | Stock | 2.6482 | 2.65 | 2.6475 | 2.6493 | 310268.0 |
| 2006-09-13 17:00:00 | AAPL | Stock | 2.6489 | 2.65 | 2.6464 | 2.65 | 350168.0 |
| 2006-09-13 17:30:00 | AAPL | Stock | 2.65 | 2.65 | 2.6479 | 2.65 | 126364.0 |
| 2006-09-13 18:00:00 | AAPL | Stock | 2.65 | 2.6514 | 2.6482 | 2.65 | 112028.0 |
| 2006-09-13 07:00:00 | MSFT | Stock | 25.92 | 25.92 | 25.92 | 25.92 | 500.0 |
| 2006-09-13 08:00:00 | MSFT | Stock | 25.9 | 25.9 | 25.88 | 25.9 | 9000.0 |
| 2006-09-13 08:30:00 | MSFT | Stock | 25.87 | 25.93 | 25.87 | 25.88 | 17536.0 |
| 2006-09-13 09:00:00 | MSFT | Stock | 25.88 | 25.91 | 25.81 | 25.82 | 77650.0 |
| 2006-09-13 09:30:00 | MSFT | Stock | 25.82 | 25.97 | 25.82 | 25.95 | 3827899.0 |
| 2006-09-13 10:00:00 | MSFT | Stock | 25.94 | 25.97 | 25.87 | 25.92 | 3709466.0 |
| 2006-09-13 10:30:00 | MSFT | Stock | 25.93 | 26.1 | 25.88 | 25.91 | 3145168.0 |
| 2006-09-13 11:00:00 | MSFT | Stock | 25.9 | 25.95 | 25.89 | 25.95 | 1840088.0 |
| 2006-09-13 11:30:00 | MSFT | Stock | 25.948 | 25.96 | 25.89 | 25.93 | 2722369.0 |
| 2006-09-13 12:00:00 | MSFT | Stock | 25.94 | 25.95 | 25.89 | 25.9 | 1611632.0 |
| 2006-09-13 12:30:00 | MSFT | Stock | 25.89 | 25.97 | 25.89 | 25.91 | 2602414.0 |
| 2006-09-13 13:00:00 | MSFT | Stock | 25.913 | 25.931 | 25.49 | 25.9 | 2875772.0 |
| 2006-09-13 13:30:00 | MSFT | Stock | 25.89 | 25.92 | 25.89 | 25.91 | 999030.0 |
| 2006-09-13 14:00:00 | MSFT | Stock | 25.9 | 25.93 | 25.89 | 25.9 | 1592218.0 |
| 2006-09-13 14:30:00 | MSFT | Stock | 25.91 | 25.97 | 25.9 | 25.96 | 2548095.0 |
| 2006-09-13 15:00:00 | MSFT | Stock | 25.96 | 25.96 | 25.9 | 25.94 | 2925857.0 |
| 2006-09-13 15:30:00 | MSFT | Stock | 25.95 | 26.0 | 25.93 | 25.98 | 5305089.0 |
| 2006-09-13 16:00:00 | MSFT | Stock | 25.98 | 26.04 | 25.914 | 26.04 | 878746.0 |
| 2006-09-13 16:30:00 | MSFT | Stock | 25.99 | 26.05 | 25.99 | 26.04 | 14235.0 |
| 2006-09-13 17:00:00 | MSFT | Stock | 26.0 | 26.02 | 26.0 | 26.0 | 372900.0 |
| 2006-09-13 17:30:00 | MSFT | Stock | 26.0 | 26.0 | 26.0 | 26.0 | 645.0 |
| 2006-09-13 18:00:00 | MSFT | Stock | 26.0 | 26.01 | 26.0 | 26.01 | 236400.0 |
| 2006-09-13 08:00:00 | NVDA | Stock | 0.4808 | 0.4835 | 0.4808 | 0.4835 | 63600.0 |
| 2006-09-13 08:30:00 | NVDA | Stock | 0.4813 | 0.4848 | 0.4813 | 0.4843 | 57000.0 |
| 2006-09-13 09:00:00 | NVDA | Stock | 0.4833 | 0.4848 | 0.482 | 0.4823 | 204000.0 |
| 2006-09-13 09:30:00 | NVDA | Stock | 0.4823 | 0.491 | 0.4808 | 0.4883 | 70752480.0 |
> showing 50 of 49,611 rows — these rows as CSV