PREVIEW / stock_30min / 2007-12-26
file: by_date/stock_30min/2007/2007-12-26.parquet size: 1.2 MB rows: 70,282 symbols: 3,250
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-26 07:00:00 | AAPL | Stock | 7.1071 | 7.1307 | 7.1071 | 7.1286 | 103600.0 |
| 2007-12-26 07:30:00 | AAPL | Stock | 7.1379 | 7.1464 | 7.1146 | 7.1146 | 410592.0 |
| 2007-12-26 08:00:00 | AAPL | Stock | 7.1214 | 7.1768 | 7.1214 | 7.1521 | 5310816.0 |
| 2007-12-26 08:30:00 | AAPL | Stock | 7.1525 | 7.1543 | 7.1286 | 7.1321 | 3232684.0 |
| 2007-12-26 09:00:00 | AAPL | Stock | 7.1321 | 7.1325 | 7.1011 | 7.1079 | 5017460.0 |
| 2007-12-26 09:30:00 | AAPL | Stock | 7.1075 | 7.1125 | 7.0293 | 7.0525 | 102641028.0 |
| 2007-12-26 10:00:00 | AAPL | Stock | 7.0525 | 7.1118 | 7.0393 | 7.1007 | 55847372.0 |
| 2007-12-26 10:30:00 | AAPL | Stock | 7.1011 | 7.1225 | 7.0643 | 7.1089 | 47956664.0 |
| 2007-12-26 11:00:00 | AAPL | Stock | 7.11 | 7.1418 | 7.0975 | 7.1004 | 64461824.0 |
| 2007-12-26 11:30:00 | AAPL | Stock | 7.0993 | 7.1318 | 7.0946 | 7.0968 | 39213720.0 |
| 2007-12-26 12:00:00 | AAPL | Stock | 7.0975 | 7.1225 | 7.0961 | 7.1154 | 24699780.0 |
| 2007-12-26 12:30:00 | AAPL | Stock | 7.1146 | 7.1371 | 7.1064 | 7.1346 | 24512656.0 |
| 2007-12-26 13:00:00 | AAPL | Stock | 7.1343 | 7.1429 | 7.125 | 7.1375 | 38664696.0 |
| 2007-12-26 13:30:00 | AAPL | Stock | 7.1364 | 7.1771 | 7.1336 | 7.17 | 71000244.0 |
| 2007-12-26 14:00:00 | AAPL | Stock | 7.1707 | 7.1746 | 7.1346 | 7.1707 | 45814916.0 |
| 2007-12-26 14:30:00 | AAPL | Stock | 7.1704 | 7.1771 | 7.1496 | 7.1668 | 28475160.0 |
| 2007-12-26 15:00:00 | AAPL | Stock | 7.1666 | 7.1743 | 7.1214 | 7.125 | 49061264.0 |
| 2007-12-26 15:30:00 | AAPL | Stock | 7.125 | 7.1321 | 7.0857 | 7.1043 | 85258040.0 |
| 2007-12-26 16:00:00 | AAPL | Stock | 7.1043 | 7.1376 | 6.7804 | 7.1054 | 7155036.0 |
| 2007-12-26 16:30:00 | AAPL | Stock | 7.1039 | 7.1429 | 7.1 | 7.1 | 3926384.0 |
| 2007-12-26 17:00:00 | AAPL | Stock | 7.1004 | 7.105 | 7.0939 | 7.1029 | 178864.0 |
| 2007-12-26 17:30:00 | AAPL | Stock | 7.1 | 7.1075 | 7.1 | 7.1007 | 587664.0 |
| 2007-12-26 18:00:00 | AAPL | Stock | 7.1007 | 7.1061 | 7.1007 | 7.1025 | 50848.0 |
| 2007-12-26 18:30:00 | AAPL | Stock | 7.1029 | 7.1064 | 7.0946 | 7.1025 | 102172.0 |
| 2007-12-26 19:00:00 | AAPL | Stock | 7.1 | 7.1104 | 7.1 | 7.1071 | 291060.0 |
| 2007-12-26 19:30:00 | AAPL | Stock | 7.1104 | 7.1104 | 7.1 | 7.1071 | 163128.0 |
| 2007-12-26 07:00:00 | MSFT | Stock | 36.89 | 36.89 | 36.8 | 36.8 | 200.0 |
| 2007-12-26 07:30:00 | MSFT | Stock | 36.7 | 36.7 | 36.7 | 36.7 | 200.0 |
| 2007-12-26 08:00:00 | MSFT | Stock | 36.8 | 36.8 | 36.5 | 36.7 | 9523.0 |
| 2007-12-26 08:30:00 | MSFT | Stock | 36.73 | 36.74 | 36.68 | 36.68 | 2040.0 |
| 2007-12-26 09:00:00 | MSFT | Stock | 36.68 | 36.68 | 36.36 | 36.48 | 89637.0 |
| 2007-12-26 09:30:00 | MSFT | Stock | 36.41 | 36.54 | 36.38 | 36.39 | 2699438.0 |
| 2007-12-26 10:00:00 | MSFT | Stock | 36.39 | 36.45 | 36.39 | 36.41 | 1490278.0 |
| 2007-12-26 10:30:00 | MSFT | Stock | 36.41 | 36.43 | 36.28 | 36.29 | 1677108.0 |
| 2007-12-26 11:00:00 | MSFT | Stock | 36.29 | 36.37 | 36.26 | 36.278 | 1542531.0 |
| 2007-12-26 11:30:00 | MSFT | Stock | 36.27 | 36.38 | 36.27 | 36.37 | 1615517.0 |
| 2007-12-26 12:00:00 | MSFT | Stock | 36.36 | 36.4 | 36.33 | 36.38 | 1559518.0 |
| 2007-12-26 12:30:00 | MSFT | Stock | 36.38 | 36.44 | 36.35 | 36.41 | 1191669.0 |
| 2007-12-26 13:00:00 | MSFT | Stock | 36.41 | 36.51 | 36.4 | 36.49 | 1853322.0 |
| 2007-12-26 13:30:00 | MSFT | Stock | 36.495 | 36.58 | 36.47 | 36.57 | 1652923.0 |
| 2007-12-26 14:00:00 | MSFT | Stock | 36.57 | 36.58 | 36.53 | 36.551 | 1766268.0 |
| 2007-12-26 14:30:00 | MSFT | Stock | 36.56 | 36.64 | 36.53 | 36.592 | 3442957.0 |
| 2007-12-26 15:00:00 | MSFT | Stock | 36.59 | 36.62 | 36.52 | 36.56 | 2318676.0 |
| 2007-12-26 15:30:00 | MSFT | Stock | 36.56 | 36.63 | 36.53 | 36.61 | 3298568.0 |
| 2007-12-26 16:00:00 | MSFT | Stock | 36.6 | 36.62 | 36.479 | 36.61 | 2698376.0 |
| 2007-12-26 16:30:00 | MSFT | Stock | 36.61 | 36.61 | 36.6 | 36.61 | 1509520.0 |
| 2007-12-26 17:30:00 | MSFT | Stock | 36.61 | 36.62 | 36.6 | 36.62 | 58023.0 |
| 2007-12-26 18:30:00 | MSFT | Stock | 36.58 | 36.58 | 36.57 | 36.57 | 200.0 |
| 2007-12-26 19:30:00 | MSFT | Stock | 36.6 | 36.6 | 36.6 | 36.6 | 100.0 |
| 2007-12-26 08:30:00 | NVDA | Stock | 0.8988 | 0.8988 | 0.8988 | 0.8988 | 16400.0 |
> showing 50 of 70,282 rows — these rows as CSV