PREVIEW / stock_30min / 2006-01-06
file: by_date/stock_30min/2006/2006-01-06.parquet size: 898 KB rows: 48,319 symbols: 2,172
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-01-06 08:00:00 | AAPL | Stock | 2.6607 | 2.6782 | 2.6339 | 2.6718 | 880180.0 |
| 2006-01-06 08:30:00 | AAPL | Stock | 2.6714 | 2.6782 | 2.6679 | 2.6768 | 1283856.0 |
| 2006-01-06 09:00:00 | AAPL | Stock | 2.6775 | 2.6871 | 2.6771 | 2.6836 | 4400116.0 |
| 2006-01-06 09:30:00 | AAPL | Stock | 2.6875 | 2.6957 | 2.6625 | 2.6696 | 76825532.0 |
| 2006-01-06 10:00:00 | AAPL | Stock | 2.6696 | 2.6871 | 2.6668 | 2.6753 | 56978432.0 |
| 2006-01-06 10:30:00 | AAPL | Stock | 2.675 | 2.6996 | 2.675 | 2.6889 | 68984608.0 |
| 2006-01-06 11:00:00 | AAPL | Stock | 2.6889 | 2.6925 | 2.6732 | 2.6914 | 45513104.0 |
| 2006-01-06 11:30:00 | AAPL | Stock | 2.6911 | 2.7104 | 2.6889 | 2.7093 | 62870360.0 |
| 2006-01-06 12:00:00 | AAPL | Stock | 2.71 | 2.73 | 2.7096 | 2.7214 | 67231416.0 |
| 2006-01-06 12:30:00 | AAPL | Stock | 2.7214 | 2.7286 | 2.7064 | 2.7125 | 45315900.0 |
| 2006-01-06 13:00:00 | AAPL | Stock | 2.7125 | 2.73 | 2.7104 | 2.7239 | 27631548.0 |
| 2006-01-06 13:30:00 | AAPL | Stock | 2.7243 | 2.7389 | 2.7154 | 2.7329 | 46070304.0 |
| 2006-01-06 14:00:00 | AAPL | Stock | 2.7325 | 2.7393 | 2.7243 | 2.7261 | 47165888.0 |
| 2006-01-06 14:30:00 | AAPL | Stock | 2.7257 | 2.7307 | 2.7175 | 2.7214 | 36844304.0 |
| 2006-01-06 15:00:00 | AAPL | Stock | 2.7214 | 2.7275 | 2.7132 | 2.7171 | 44177560.0 |
| 2006-01-06 15:30:00 | AAPL | Stock | 2.7175 | 2.7257 | 2.7125 | 2.7254 | 59265500.0 |
| 2006-01-06 16:00:00 | AAPL | Stock | 2.7254 | 2.7286 | 2.7232 | 2.7282 | 2032464.0 |
| 2006-01-06 16:30:00 | AAPL | Stock | 2.7257 | 2.7282 | 2.7232 | 2.7232 | 426104.0 |
| 2006-01-06 17:00:00 | AAPL | Stock | 2.7236 | 2.7279 | 2.7236 | 2.725 | 41580.0 |
| 2006-01-06 17:30:00 | AAPL | Stock | 2.725 | 2.7279 | 2.7239 | 2.7268 | 221144.0 |
| 2006-01-06 18:00:00 | AAPL | Stock | 2.7254 | 2.7282 | 2.7254 | 2.7254 | 98504.0 |
| 2006-01-06 04:00:00 | MSFT | Stock | 26.84 | 26.84 | 26.84 | 26.84 | 1000.0 |
| 2006-01-06 07:00:00 | MSFT | Stock | 26.78 | 26.83 | 26.75 | 26.75 | 2900.0 |
| 2006-01-06 07:30:00 | MSFT | Stock | 26.8 | 26.8 | 26.77 | 26.77 | 400.0 |
| 2006-01-06 08:00:00 | MSFT | Stock | 26.8 | 26.85 | 26.8 | 26.81 | 40135.0 |
| 2006-01-06 08:30:00 | MSFT | Stock | 26.81 | 26.94 | 26.8 | 26.94 | 101361.0 |
| 2006-01-06 09:00:00 | MSFT | Stock | 26.94 | 26.96 | 26.86 | 26.88 | 203387.0 |
| 2006-01-06 09:30:00 | MSFT | Stock | 26.89 | 27.0 | 26.73 | 26.732 | 9305305.0 |
| 2006-01-06 10:00:00 | MSFT | Stock | 26.73 | 26.92 | 26.6 | 26.64 | 8076913.0 |
| 2006-01-06 10:30:00 | MSFT | Stock | 26.65 | 26.7 | 26.49 | 26.53 | 7009057.0 |
| 2006-01-06 11:00:00 | MSFT | Stock | 26.54 | 26.61 | 26.49 | 26.56 | 5350980.0 |
| 2006-01-06 11:30:00 | MSFT | Stock | 26.55 | 26.65 | 26.54 | 26.6 | 5541015.0 |
| 2006-01-06 12:00:00 | MSFT | Stock | 26.6 | 26.84 | 26.58 | 26.69 | 5029920.0 |
| 2006-01-06 12:30:00 | MSFT | Stock | 26.69 | 26.78 | 26.64 | 26.75 | 6883205.0 |
| 2006-01-06 13:00:00 | MSFT | Stock | 26.75 | 26.75 | 26.65 | 26.71 | 2662411.0 |
| 2006-01-06 13:30:00 | MSFT | Stock | 26.71 | 26.77 | 26.71 | 26.72 | 5377098.0 |
| 2006-01-06 14:00:00 | MSFT | Stock | 26.72 | 26.77 | 26.68 | 26.7 | 4557522.0 |
| 2006-01-06 14:30:00 | MSFT | Stock | 26.7 | 26.84 | 26.68 | 26.8 | 6103368.0 |
| 2006-01-06 15:00:00 | MSFT | Stock | 26.8 | 26.94 | 26.8 | 26.9 | 11513378.0 |
| 2006-01-06 15:30:00 | MSFT | Stock | 26.9 | 26.95 | 26.83 | 26.94 | 10263093.0 |
| 2006-01-06 16:00:00 | MSFT | Stock | 26.94 | 27.02 | 26.75 | 26.99 | 2832424.0 |
| 2006-01-06 16:30:00 | MSFT | Stock | 27.0 | 27.03 | 26.91 | 27.03 | 15614.0 |
| 2006-01-06 17:00:00 | MSFT | Stock | 26.96 | 27.0 | 26.96 | 27.0 | 19140.0 |
| 2006-01-06 17:30:00 | MSFT | Stock | 27.0 | 27.01 | 26.96 | 27.01 | 20901.0 |
| 2006-01-06 18:00:00 | MSFT | Stock | 27.01 | 27.01 | 26.99 | 27.0 | 6016.0 |
| 2006-01-06 08:00:00 | NVDA | Stock | 0.3342 | 0.335 | 0.3342 | 0.335 | 96000.0 |
| 2006-01-06 09:00:00 | NVDA | Stock | 0.3358 | 0.3387 | 0.3358 | 0.3381 | 2005680.0 |
| 2006-01-06 09:30:00 | NVDA | Stock | 0.3387 | 0.3387 | 0.3254 | 0.3317 | 144377640.0 |
| 2006-01-06 10:00:00 | NVDA | Stock | 0.3314 | 0.334 | 0.3292 | 0.3335 | 61133160.0 |
| 2006-01-06 10:30:00 | NVDA | Stock | 0.3335 | 0.3336 | 0.331 | 0.3311 | 26001000.0 |
> showing 50 of 48,319 rows — these rows as CSV