PREVIEW / stock_1min / 2010-05-18
file: by_date/stock_1min/2010/2010-05-18.parquet size: 14.0 MB rows: 1,053,111 symbols: 2,828
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-18 04:17:00 | AAPL | Stock | 9.1293 | 9.1293 | 9.1293 | 9.1293 | 2800.0 |
| 2010-05-18 04:46:00 | AAPL | Stock | 9.1357 | 9.1357 | 9.1357 | 9.1357 | 2800.0 |
| 2010-05-18 04:59:00 | AAPL | Stock | 9.0982 | 9.1061 | 9.0982 | 9.1061 | 28000.0 |
| 2010-05-18 05:28:00 | AAPL | Stock | 9.1075 | 9.1075 | 9.1075 | 9.1075 | 2884.0 |
| 2010-05-18 05:29:00 | AAPL | Stock | 9.1161 | 9.1161 | 9.1161 | 9.1161 | 8400.0 |
| 2010-05-18 05:31:00 | AAPL | Stock | 9.1161 | 9.1161 | 9.1161 | 9.1161 | 2800.0 |
| 2010-05-18 05:32:00 | AAPL | Stock | 9.1161 | 9.1161 | 9.1161 | 9.1161 | 2800.0 |
| 2010-05-18 05:42:00 | AAPL | Stock | 9.1161 | 9.1161 | 9.1161 | 9.1161 | 2800.0 |
| 2010-05-18 05:46:00 | AAPL | Stock | 9.1161 | 9.1161 | 9.1161 | 9.1161 | 25200.0 |
| 2010-05-18 05:50:00 | AAPL | Stock | 9.1071 | 9.1071 | 9.1071 | 9.1071 | 2800.0 |
| 2010-05-18 07:03:00 | AAPL | Stock | 9.1375 | 9.1393 | 9.1375 | 9.1382 | 26320.0 |
| 2010-05-18 07:04:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.1429 | 9.1429 | 8400.0 |
| 2010-05-18 07:05:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.1382 | 9.1382 | 24276.0 |
| 2010-05-18 07:09:00 | AAPL | Stock | 9.1425 | 9.1425 | 9.1425 | 9.1425 | 2800.0 |
| 2010-05-18 07:10:00 | AAPL | Stock | 9.1404 | 9.1429 | 9.1404 | 9.1429 | 33236.0 |
| 2010-05-18 07:11:00 | AAPL | Stock | 9.1421 | 9.1421 | 9.125 | 9.125 | 16240.0 |
| 2010-05-18 07:13:00 | AAPL | Stock | 9.135 | 9.1354 | 9.135 | 9.1354 | 5600.0 |
| 2010-05-18 07:16:00 | AAPL | Stock | 9.1389 | 9.1393 | 9.1389 | 9.1393 | 14000.0 |
| 2010-05-18 07:17:00 | AAPL | Stock | 9.1418 | 9.1482 | 9.1418 | 9.1482 | 56000.0 |
| 2010-05-18 07:18:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.1429 | 9.1429 | 42000.0 |
| 2010-05-18 07:20:00 | AAPL | Stock | 9.1375 | 9.1429 | 9.1289 | 9.1421 | 33600.0 |
| 2010-05-18 07:21:00 | AAPL | Stock | 9.1357 | 9.1425 | 9.1357 | 9.1425 | 28000.0 |
| 2010-05-18 07:26:00 | AAPL | Stock | 9.1318 | 9.1318 | 9.1318 | 9.1318 | 14000.0 |
| 2010-05-18 07:30:00 | AAPL | Stock | 9.1371 | 9.1411 | 9.1371 | 9.1411 | 25200.0 |
| 2010-05-18 07:34:00 | AAPL | Stock | 9.1393 | 9.1393 | 9.1393 | 9.1393 | 2800.0 |
| 2010-05-18 07:37:00 | AAPL | Stock | 9.135 | 9.135 | 9.135 | 9.135 | 2800.0 |
| 2010-05-18 07:38:00 | AAPL | Stock | 9.135 | 9.1407 | 9.135 | 9.1407 | 16800.0 |
| 2010-05-18 07:39:00 | AAPL | Stock | 9.1393 | 9.1393 | 9.1393 | 9.1393 | 14000.0 |
| 2010-05-18 07:40:00 | AAPL | Stock | 9.1404 | 9.1432 | 9.1404 | 9.1429 | 65828.0 |
| 2010-05-18 07:41:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.1429 | 9.1429 | 13300.0 |
| 2010-05-18 07:43:00 | AAPL | Stock | 9.1425 | 9.1429 | 9.1425 | 9.1425 | 53116.0 |
| 2010-05-18 07:44:00 | AAPL | Stock | 9.1425 | 9.1425 | 9.1425 | 9.1425 | 12684.0 |
| 2010-05-18 07:45:00 | AAPL | Stock | 9.14 | 9.14 | 9.14 | 9.14 | 6244.0 |
| 2010-05-18 07:46:00 | AAPL | Stock | 9.14 | 9.14 | 9.14 | 9.14 | 5600.0 |
| 2010-05-18 07:50:00 | AAPL | Stock | 9.1425 | 9.1429 | 9.1425 | 9.1429 | 36960.0 |
| 2010-05-18 07:51:00 | AAPL | Stock | 9.1382 | 9.1404 | 9.1346 | 9.14 | 16800.0 |
| 2010-05-18 07:57:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.1429 | 9.1429 | 2800.0 |
| 2010-05-18 07:59:00 | AAPL | Stock | 9.1461 | 9.1461 | 9.1389 | 9.1389 | 19600.0 |
| 2010-05-18 08:00:00 | AAPL | Stock | 9.1429 | 9.1468 | 9.1357 | 9.1411 | 110152.0 |
| 2010-05-18 08:01:00 | AAPL | Stock | 9.1389 | 9.1393 | 9.1386 | 9.1389 | 62440.0 |
| 2010-05-18 08:02:00 | AAPL | Stock | 9.1389 | 9.1475 | 9.1389 | 9.1425 | 192388.0 |
| 2010-05-18 08:03:00 | AAPL | Stock | 9.1418 | 9.1443 | 9.1418 | 9.1425 | 70000.0 |
| 2010-05-18 08:04:00 | AAPL | Stock | 9.1429 | 9.1475 | 9.1429 | 9.1461 | 88200.0 |
| 2010-05-18 08:05:00 | AAPL | Stock | 9.1461 | 9.1482 | 9.1457 | 9.1479 | 40600.0 |
| 2010-05-18 08:06:00 | AAPL | Stock | 9.1496 | 9.1496 | 9.1457 | 9.1477 | 84000.0 |
| 2010-05-18 08:07:00 | AAPL | Stock | 9.1446 | 9.1454 | 9.1357 | 9.1375 | 291592.0 |
| 2010-05-18 08:09:00 | AAPL | Stock | 9.1368 | 9.1368 | 9.1364 | 9.1364 | 22400.0 |
| 2010-05-18 08:10:00 | AAPL | Stock | 9.1386 | 9.1386 | 9.1375 | 9.1375 | 36400.0 |
| 2010-05-18 08:11:00 | AAPL | Stock | 9.1384 | 9.1386 | 9.1325 | 9.1336 | 122920.0 |
| 2010-05-18 08:12:00 | AAPL | Stock | 9.1357 | 9.1357 | 9.1357 | 9.1357 | 19600.0 |
> showing 50 of 1,053,111 rows — these rows as CSV