PREVIEW / stock_30min / 2009-11-20
file: by_date/stock_30min/2009/2009-11-20.parquet size: 1.3 MB rows: 70,880 symbols: 3,414
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-20 04:00:00 | AAPL | Stock | 7.1707 | 7.1707 | 7.1707 | 7.1707 | 3500.0 |
| 2009-11-20 05:00:00 | AAPL | Stock | 7.1546 | 7.1546 | 7.1411 | 7.1411 | 13916.0 |
| 2009-11-20 06:30:00 | AAPL | Stock | 7.1425 | 7.1425 | 7.1375 | 7.1375 | 12292.0 |
| 2009-11-20 07:00:00 | AAPL | Stock | 7.1232 | 7.1232 | 7.1232 | 7.1232 | 2800.0 |
| 2009-11-20 07:30:00 | AAPL | Stock | 7.1182 | 7.1282 | 7.1182 | 7.1282 | 8400.0 |
| 2009-11-20 08:00:00 | AAPL | Stock | 7.1304 | 7.1425 | 7.0954 | 7.1093 | 1851612.0 |
| 2009-11-20 08:30:00 | AAPL | Stock | 7.1212 | 7.1214 | 7.1036 | 7.1107 | 322140.0 |
| 2009-11-20 09:00:00 | AAPL | Stock | 7.1161 | 7.1179 | 7.1021 | 7.1043 | 1204392.0 |
| 2009-11-20 09:30:00 | AAPL | Stock | 7.1075 | 7.1346 | 7.0629 | 7.1182 | 84244524.0 |
| 2009-11-20 10:00:00 | AAPL | Stock | 7.1175 | 7.1275 | 7.1036 | 7.1252 | 34147204.0 |
| 2009-11-20 10:30:00 | AAPL | Stock | 7.1257 | 7.1275 | 7.11 | 7.1155 | 21500668.0 |
| 2009-11-20 11:00:00 | AAPL | Stock | 7.1157 | 7.1286 | 7.1 | 7.1154 | 21509320.0 |
| 2009-11-20 11:30:00 | AAPL | Stock | 7.1161 | 7.1307 | 7.1129 | 7.12 | 18804548.0 |
| 2009-11-20 12:00:00 | AAPL | Stock | 7.12 | 7.1282 | 7.1164 | 7.1236 | 9743132.0 |
| 2009-11-20 12:30:00 | AAPL | Stock | 7.1229 | 7.1332 | 7.1194 | 7.1314 | 12423236.0 |
| 2009-11-20 13:00:00 | AAPL | Stock | 7.1314 | 7.1461 | 7.1311 | 7.145 | 20596604.0 |
| 2009-11-20 13:30:00 | AAPL | Stock | 7.1443 | 7.1564 | 7.1425 | 7.1507 | 19753216.0 |
| 2009-11-20 14:00:00 | AAPL | Stock | 7.1505 | 7.1568 | 7.1464 | 7.1486 | 17032288.0 |
| 2009-11-20 14:30:00 | AAPL | Stock | 7.1482 | 7.1539 | 7.1457 | 7.1484 | 17901156.0 |
| 2009-11-20 15:00:00 | AAPL | Stock | 7.1479 | 7.15 | 7.1354 | 7.1451 | 29342656.0 |
| 2009-11-20 15:30:00 | AAPL | Stock | 7.1443 | 7.1489 | 7.1404 | 7.1404 | 53584552.0 |
| 2009-11-20 16:00:00 | AAPL | Stock | 7.1404 | 7.1438 | 7.1246 | 7.1425 | 9001020.0 |
| 2009-11-20 16:30:00 | AAPL | Stock | 7.1429 | 7.1443 | 7.1421 | 7.1429 | 459592.0 |
| 2009-11-20 17:00:00 | AAPL | Stock | 7.1436 | 7.1443 | 7.1432 | 7.1443 | 109060.0 |
| 2009-11-20 17:30:00 | AAPL | Stock | 7.1432 | 7.1432 | 7.1393 | 7.1393 | 95032.0 |
| 2009-11-20 18:00:00 | AAPL | Stock | 7.1393 | 7.1447 | 7.1393 | 7.1396 | 63140.0 |
| 2009-11-20 18:30:00 | AAPL | Stock | 7.1396 | 7.1421 | 7.1396 | 7.1396 | 87304.0 |
| 2009-11-20 19:00:00 | AAPL | Stock | 7.1411 | 7.1421 | 7.1393 | 7.1421 | 43400.0 |
| 2009-11-20 19:30:00 | AAPL | Stock | 7.1411 | 7.1411 | 7.1393 | 7.1393 | 54040.0 |
| 2009-11-20 08:00:00 | MSFT | Stock | 29.7 | 29.73 | 29.62 | 29.62 | 19636.0 |
| 2009-11-20 08:30:00 | MSFT | Stock | 29.63 | 29.66 | 29.62 | 29.62 | 5210.0 |
| 2009-11-20 09:00:00 | MSFT | Stock | 29.65 | 29.73 | 29.62 | 29.66 | 40029.0 |
| 2009-11-20 09:30:00 | MSFT | Stock | 29.66 | 29.72 | 29.43 | 29.52 | 6663460.0 |
| 2009-11-20 10:00:00 | MSFT | Stock | 29.52 | 29.55 | 29.46 | 29.522 | 3112081.0 |
| 2009-11-20 10:30:00 | MSFT | Stock | 29.53 | 29.55 | 29.45 | 29.55 | 3096370.0 |
| 2009-11-20 11:00:00 | MSFT | Stock | 29.54 | 29.65 | 29.52 | 29.54 | 2337437.0 |
| 2009-11-20 11:30:00 | MSFT | Stock | 29.532 | 29.6 | 29.5 | 29.56 | 1592261.0 |
| 2009-11-20 12:00:00 | MSFT | Stock | 29.56 | 29.57 | 29.45 | 29.45 | 1439841.0 |
| 2009-11-20 12:30:00 | MSFT | Stock | 29.45 | 29.51 | 29.43 | 29.5 | 1416810.0 |
| 2009-11-20 13:00:00 | MSFT | Stock | 29.502 | 29.57 | 29.5 | 29.55 | 1677485.0 |
| 2009-11-20 13:30:00 | MSFT | Stock | 29.548 | 29.63 | 29.53 | 29.598 | 1547761.0 |
| 2009-11-20 14:00:00 | MSFT | Stock | 29.6 | 29.65 | 29.56 | 29.61 | 1949564.0 |
| 2009-11-20 14:30:00 | MSFT | Stock | 29.615 | 29.64 | 29.58 | 29.62 | 1510698.0 |
| 2009-11-20 15:00:00 | MSFT | Stock | 29.61 | 29.72 | 29.6 | 29.695 | 2365281.0 |
| 2009-11-20 15:30:00 | MSFT | Stock | 29.7 | 29.77 | 29.63 | 29.63 | 4617374.0 |
| 2009-11-20 16:00:00 | MSFT | Stock | 29.63 | 29.67 | 29.555 | 29.64 | 1611528.0 |
| 2009-11-20 16:30:00 | MSFT | Stock | 29.62 | 29.66 | 29.606 | 29.66 | 190052.0 |
| 2009-11-20 17:00:00 | MSFT | Stock | 29.66 | 29.66 | 29.66 | 29.66 | 100104.0 |
| 2009-11-20 17:30:00 | MSFT | Stock | 29.63 | 29.67 | 29.6 | 29.67 | 2990.0 |
| 2009-11-20 18:00:00 | MSFT | Stock | 29.673 | 29.68 | 29.673 | 29.68 | 3590.0 |
> showing 50 of 70,880 rows — these rows as CSV