PREVIEW / stock_30min / 2006-01-03
file: by_date/stock_30min/2006/2006-01-03.parquet size: 920 KB rows: 49,505 symbols: 2,178
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-03 06:30:00 | AAPL | Stock | 2.5839 | 2.5839 | 2.5839 | 2.5839 | 2800.0 |
| 2006-01-03 07:00:00 | AAPL | Stock | 2.5886 | 2.5896 | 2.5886 | 2.5896 | 22400.0 |
| 2006-01-03 07:30:00 | AAPL | Stock | 2.5946 | 2.5964 | 2.5932 | 2.5964 | 64400.0 |
| 2006-01-03 08:00:00 | AAPL | Stock | 2.5932 | 2.6054 | 2.5675 | 2.5932 | 2666076.0 |
| 2006-01-03 08:30:00 | AAPL | Stock | 2.5936 | 2.5943 | 2.5857 | 2.5907 | 1691788.0 |
| 2006-01-03 09:00:00 | AAPL | Stock | 2.5914 | 2.5943 | 2.5832 | 2.5843 | 3545752.0 |
| 2006-01-03 09:30:00 | AAPL | Stock | 2.585 | 2.6282 | 2.5804 | 2.6275 | 136790668.0 |
| 2006-01-03 10:00:00 | AAPL | Stock | 2.6279 | 2.6339 | 2.5921 | 2.5957 | 101026464.0 |
| 2006-01-03 10:30:00 | AAPL | Stock | 2.5954 | 2.6118 | 2.5886 | 2.5996 | 54651632.0 |
| 2006-01-03 11:00:00 | AAPL | Stock | 2.5999 | 2.6171 | 2.5943 | 2.6043 | 35713636.0 |
| 2006-01-03 11:30:00 | AAPL | Stock | 2.6046 | 2.6332 | 2.6036 | 2.6186 | 51528260.0 |
| 2006-01-03 12:00:00 | AAPL | Stock | 2.6186 | 2.6296 | 2.61 | 2.61 | 42152908.0 |
| 2006-01-03 12:30:00 | AAPL | Stock | 2.61 | 2.6196 | 2.6011 | 2.6132 | 33612236.0 |
| 2006-01-03 13:00:00 | AAPL | Stock | 2.6136 | 2.6182 | 2.5996 | 2.6011 | 28774256.0 |
| 2006-01-03 13:30:00 | AAPL | Stock | 2.6007 | 2.6118 | 2.5964 | 2.6046 | 26312244.0 |
| 2006-01-03 14:00:00 | AAPL | Stock | 2.6046 | 2.6396 | 2.6036 | 2.6368 | 69154316.0 |
| 2006-01-03 14:30:00 | AAPL | Stock | 2.6368 | 2.6446 | 2.6311 | 2.6425 | 53661216.0 |
| 2006-01-03 15:00:00 | AAPL | Stock | 2.6425 | 2.6604 | 2.6425 | 2.6568 | 60172140.0 |
| 2006-01-03 15:30:00 | AAPL | Stock | 2.6575 | 2.6696 | 2.6571 | 2.6689 | 86817416.0 |
| 2006-01-03 16:00:00 | AAPL | Stock | 2.6696 | 2.6732 | 2.6621 | 2.6696 | 3634792.0 |
| 2006-01-03 16:30:00 | AAPL | Stock | 2.6696 | 2.6696 | 2.6646 | 2.6661 | 395640.0 |
| 2006-01-03 17:00:00 | AAPL | Stock | 2.6686 | 2.6686 | 2.6643 | 2.6643 | 133840.0 |
| 2006-01-03 17:30:00 | AAPL | Stock | 2.6657 | 2.6696 | 2.6607 | 2.6639 | 3385928.0 |
| 2006-01-03 18:00:00 | AAPL | Stock | 2.6625 | 2.6675 | 2.6611 | 2.6671 | 145404.0 |
| 2006-01-03 07:30:00 | MSFT | Stock | 26.2 | 26.2 | 26.2 | 26.2 | 100.0 |
| 2006-01-03 08:00:00 | MSFT | Stock | 26.15 | 26.23 | 26.14 | 26.22 | 95618.0 |
| 2006-01-03 08:30:00 | MSFT | Stock | 26.22 | 26.27 | 26.15 | 26.26 | 131436.0 |
| 2006-01-03 09:00:00 | MSFT | Stock | 26.25 | 26.28 | 26.15 | 26.26 | 120067.0 |
| 2006-01-03 09:30:00 | MSFT | Stock | 26.25 | 26.27 | 26.14 | 26.2 | 6785611.0 |
| 2006-01-03 10:00:00 | MSFT | Stock | 26.2 | 26.22 | 26.1 | 26.11 | 4999328.0 |
| 2006-01-03 10:30:00 | MSFT | Stock | 26.11 | 26.248 | 26.1 | 26.152 | 3045268.0 |
| 2006-01-03 11:00:00 | MSFT | Stock | 26.15 | 26.22 | 26.128 | 26.19 | 3173403.0 |
| 2006-01-03 11:30:00 | MSFT | Stock | 26.19 | 26.3 | 26.19 | 26.3 | 3900696.0 |
| 2006-01-03 12:00:00 | MSFT | Stock | 26.3 | 26.39 | 26.26 | 26.33 | 4266136.0 |
| 2006-01-03 12:30:00 | MSFT | Stock | 26.33 | 26.4 | 26.3 | 26.37 | 3263658.0 |
| 2006-01-03 13:00:00 | MSFT | Stock | 26.37 | 26.42 | 26.34 | 26.41 | 4682713.0 |
| 2006-01-03 13:30:00 | MSFT | Stock | 26.41 | 26.52 | 26.39 | 26.47 | 5256212.0 |
| 2006-01-03 14:00:00 | MSFT | Stock | 26.46 | 26.74 | 26.46 | 26.72 | 6939152.0 |
| 2006-01-03 14:30:00 | MSFT | Stock | 26.72 | 26.89 | 26.71 | 26.82 | 8306988.0 |
| 2006-01-03 15:00:00 | MSFT | Stock | 26.82 | 27.0 | 26.51 | 26.96 | 9086753.0 |
| 2006-01-03 15:30:00 | MSFT | Stock | 26.96 | 27.001 | 26.8 | 26.82 | 12751448.0 |
| 2006-01-03 16:00:00 | MSFT | Stock | 26.86 | 26.92 | 26.46 | 26.9 | 400336.0 |
| 2006-01-03 16:30:00 | MSFT | Stock | 26.9 | 26.9 | 26.548 | 26.548 | 183675.0 |
| 2006-01-03 17:00:00 | MSFT | Stock | 26.9 | 26.9 | 26.85 | 26.85 | 1051.0 |
| 2006-01-03 17:30:00 | MSFT | Stock | 26.85 | 26.9 | 26.85 | 26.86 | 2599.0 |
| 2006-01-03 18:00:00 | MSFT | Stock | 26.86 | 26.9 | 26.85 | 26.9 | 1365.0 |
| 2006-01-03 07:30:00 | NVDA | Stock | 0.2958 | 0.2958 | 0.2958 | 0.2958 | 12000.0 |
| 2006-01-03 08:00:00 | NVDA | Stock | 0.3047 | 0.308 | 0.3047 | 0.308 | 877560.0 |
| 2006-01-03 08:30:00 | NVDA | Stock | 0.3054 | 0.3054 | 0.3053 | 0.3053 | 192000.0 |
| 2006-01-03 09:00:00 | NVDA | Stock | 0.3053 | 0.3072 | 0.3052 | 0.3054 | 324000.0 |
> showing 50 of 49,505 rows — these rows as CSV