PREVIEW / stock_30min / 2006-01-26
file: by_date/stock_30min/2006/2006-01-26.parquet size: 905 KB rows: 48,783 symbols: 2,177
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-26 06:30:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 2800.0 |
| 2006-01-26 07:00:00 | AAPL | Stock | 2.6714 | 2.6714 | 2.6714 | 2.6714 | 2800.0 |
| 2006-01-26 07:30:00 | AAPL | Stock | 2.6718 | 2.6768 | 2.6718 | 2.6736 | 42000.0 |
| 2006-01-26 08:00:00 | AAPL | Stock | 2.6786 | 2.6861 | 2.6679 | 2.6682 | 2029748.0 |
| 2006-01-26 08:30:00 | AAPL | Stock | 2.6682 | 2.6686 | 2.6582 | 2.6629 | 2424604.0 |
| 2006-01-26 09:00:00 | AAPL | Stock | 2.6629 | 2.6689 | 2.6575 | 2.6646 | 3703896.0 |
| 2006-01-26 09:30:00 | AAPL | Stock | 2.6618 | 2.6939 | 2.6364 | 2.6504 | 154482328.0 |
| 2006-01-26 10:00:00 | AAPL | Stock | 2.65 | 2.6582 | 2.5696 | 2.57 | 190517012.0 |
| 2006-01-26 10:30:00 | AAPL | Stock | 2.5696 | 2.6064 | 2.5689 | 2.6057 | 155294916.0 |
| 2006-01-26 11:00:00 | AAPL | Stock | 2.6057 | 2.6061 | 2.5818 | 2.5985 | 70601188.0 |
| 2006-01-26 11:30:00 | AAPL | Stock | 2.5982 | 2.625 | 2.595 | 2.6143 | 89160148.0 |
| 2006-01-26 12:00:00 | AAPL | Stock | 2.6143 | 2.6214 | 2.6 | 2.6118 | 53524492.0 |
| 2006-01-26 12:30:00 | AAPL | Stock | 2.6118 | 2.6132 | 2.5979 | 2.6007 | 38875004.0 |
| 2006-01-26 13:00:00 | AAPL | Stock | 2.6007 | 2.6071 | 2.5936 | 2.5939 | 28288708.0 |
| 2006-01-26 13:30:00 | AAPL | Stock | 2.5936 | 2.5971 | 2.5732 | 2.5904 | 60087468.0 |
| 2006-01-26 14:00:00 | AAPL | Stock | 2.5904 | 2.6018 | 2.58 | 2.5839 | 55590612.0 |
| 2006-01-26 14:30:00 | AAPL | Stock | 2.5843 | 2.6161 | 2.5789 | 2.61 | 69802236.0 |
| 2006-01-26 15:00:00 | AAPL | Stock | 2.6093 | 2.6336 | 2.6021 | 2.6082 | 91647724.0 |
| 2006-01-26 15:30:00 | AAPL | Stock | 2.6082 | 2.6111 | 2.5786 | 2.5821 | 81108776.0 |
| 2006-01-26 16:00:00 | AAPL | Stock | 2.5836 | 2.5946 | 2.5607 | 2.5893 | 13513780.0 |
| 2006-01-26 16:30:00 | AAPL | Stock | 2.5893 | 2.6107 | 2.5832 | 2.6086 | 2793028.0 |
| 2006-01-26 17:00:00 | AAPL | Stock | 2.6104 | 2.6125 | 2.595 | 2.6018 | 1807792.0 |
| 2006-01-26 17:30:00 | AAPL | Stock | 2.5986 | 2.6139 | 2.595 | 2.6107 | 1986516.0 |
| 2006-01-26 18:00:00 | AAPL | Stock | 2.6107 | 2.625 | 2.6107 | 2.6211 | 1037092.0 |
| 2006-01-26 08:00:00 | MSFT | Stock | 26.5 | 26.5 | 26.48 | 26.49 | 7291.0 |
| 2006-01-26 08:30:00 | MSFT | Stock | 26.5 | 26.55 | 26.49 | 26.5 | 7650.0 |
| 2006-01-26 09:00:00 | MSFT | Stock | 26.52 | 26.57 | 26.5 | 26.54 | 110604.0 |
| 2006-01-26 09:30:00 | MSFT | Stock | 26.56 | 26.67 | 26.53 | 26.63 | 5651763.0 |
| 2006-01-26 10:00:00 | MSFT | Stock | 26.63 | 26.66 | 26.45 | 26.47 | 4798247.0 |
| 2006-01-26 10:30:00 | MSFT | Stock | 26.47 | 26.61 | 26.39 | 26.6 | 6415087.0 |
| 2006-01-26 11:00:00 | MSFT | Stock | 26.6 | 26.68 | 26.57 | 26.62 | 3049423.0 |
| 2006-01-26 11:30:00 | MSFT | Stock | 26.62 | 26.72 | 26.56 | 26.57 | 5213276.0 |
| 2006-01-26 12:00:00 | MSFT | Stock | 26.57 | 26.586 | 26.49 | 26.522 | 4955551.0 |
| 2006-01-26 12:30:00 | MSFT | Stock | 26.53 | 26.55 | 26.42 | 26.42 | 3456465.0 |
| 2006-01-26 13:00:00 | MSFT | Stock | 26.43 | 26.44 | 26.35 | 26.35 | 2689036.0 |
| 2006-01-26 13:30:00 | MSFT | Stock | 26.35 | 26.6 | 26.31 | 26.44 | 5494576.0 |
| 2006-01-26 14:00:00 | MSFT | Stock | 26.44 | 26.51 | 26.42 | 26.458 | 3717720.0 |
| 2006-01-26 14:30:00 | MSFT | Stock | 26.46 | 26.55 | 26.44 | 26.53 | 5478323.0 |
| 2006-01-26 15:00:00 | MSFT | Stock | 26.53 | 26.6 | 26.5 | 26.55 | 4817332.0 |
| 2006-01-26 15:30:00 | MSFT | Stock | 26.55 | 26.57 | 26.43 | 26.52 | 6446182.0 |
| 2006-01-26 16:00:00 | MSFT | Stock | 26.5 | 27.08 | 26.06 | 26.85 | 3264484.0 |
| 2006-01-26 16:30:00 | MSFT | Stock | 26.87 | 27.15 | 26.5 | 27.09 | 1431386.0 |
| 2006-01-26 17:00:00 | MSFT | Stock | 27.1 | 27.16 | 26.91 | 27.15 | 279721.0 |
| 2006-01-26 17:30:00 | MSFT | Stock | 27.16 | 27.17 | 26.95 | 26.95 | 173085.0 |
| 2006-01-26 18:00:00 | MSFT | Stock | 26.95 | 27.01 | 26.94 | 27.01 | 22520.0 |
| 2006-01-26 08:30:00 | NVDA | Stock | 0.3696 | 0.3696 | 0.3696 | 0.3696 | 468000.0 |
| 2006-01-26 09:00:00 | NVDA | Stock | 0.3708 | 0.3713 | 0.3687 | 0.3711 | 2749680.0 |
| 2006-01-26 09:30:00 | NVDA | Stock | 0.3711 | 0.3728 | 0.3687 | 0.3706 | 39723960.0 |
| 2006-01-26 10:00:00 | NVDA | Stock | 0.3707 | 0.3732 | 0.3706 | 0.3727 | 39273720.0 |
| 2006-01-26 10:30:00 | NVDA | Stock | 0.3728 | 0.3767 | 0.372 | 0.3728 | 40485840.0 |
> showing 50 of 48,783 rows — these rows as CSV