PREVIEW / stock_1min / 2009-02-27
file: by_date/stock_1min/2009/2009-02-27.parquet size: 12.8 MB rows: 984,563 symbols: 2,710
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-02-27 07:16:00 | AAPL | Stock | 3.1518 | 3.1518 | 3.1518 | 3.1518 | 2800.0 |
| 2009-02-27 07:17:00 | AAPL | Stock | 3.1518 | 3.1518 | 3.1518 | 3.1518 | 5600.0 |
| 2009-02-27 07:18:00 | AAPL | Stock | 3.1518 | 3.1518 | 3.1429 | 3.1429 | 8400.0 |
| 2009-02-27 07:30:00 | AAPL | Stock | 3.1418 | 3.1418 | 3.1418 | 3.1418 | 26600.0 |
| 2009-02-27 08:00:00 | AAPL | Stock | 3.1493 | 3.1493 | 3.1493 | 3.1493 | 5600.0 |
| 2009-02-27 08:01:00 | AAPL | Stock | 3.1471 | 3.1471 | 3.1471 | 3.1471 | 2800.0 |
| 2009-02-27 08:02:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 3192.0 |
| 2009-02-27 08:03:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 24808.0 |
| 2009-02-27 08:04:00 | AAPL | Stock | 3.135 | 3.135 | 3.1336 | 3.1339 | 28000.0 |
| 2009-02-27 08:05:00 | AAPL | Stock | 3.1339 | 3.1339 | 3.1339 | 3.1339 | 31640.0 |
| 2009-02-27 08:08:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 2800.0 |
| 2009-02-27 08:13:00 | AAPL | Stock | 3.1368 | 3.1368 | 3.1368 | 3.1368 | 2800.0 |
| 2009-02-27 08:17:00 | AAPL | Stock | 3.1429 | 3.1446 | 3.1429 | 3.1446 | 9800.0 |
| 2009-02-27 08:18:00 | AAPL | Stock | 3.1446 | 3.1446 | 3.1429 | 3.1429 | 5600.0 |
| 2009-02-27 08:19:00 | AAPL | Stock | 3.1393 | 3.1393 | 3.1393 | 3.1393 | 4760.0 |
| 2009-02-27 08:20:00 | AAPL | Stock | 3.1357 | 3.1357 | 3.1339 | 3.1339 | 47012.0 |
| 2009-02-27 08:21:00 | AAPL | Stock | 3.1339 | 3.1339 | 3.1314 | 3.1314 | 33600.0 |
| 2009-02-27 08:22:00 | AAPL | Stock | 3.1275 | 3.1275 | 3.1275 | 3.1275 | 2800.0 |
| 2009-02-27 08:24:00 | AAPL | Stock | 3.1286 | 3.1286 | 3.125 | 3.125 | 28700.0 |
| 2009-02-27 08:25:00 | AAPL | Stock | 3.125 | 3.125 | 3.125 | 3.125 | 7000.0 |
| 2009-02-27 08:26:00 | AAPL | Stock | 3.1304 | 3.1304 | 3.125 | 3.1268 | 56000.0 |
| 2009-02-27 08:27:00 | AAPL | Stock | 3.1268 | 3.1268 | 3.1268 | 3.1268 | 5600.0 |
| 2009-02-27 08:30:00 | AAPL | Stock | 3.1279 | 3.1279 | 3.1279 | 3.1279 | 5600.0 |
| 2009-02-27 08:31:00 | AAPL | Stock | 3.1279 | 3.1279 | 3.1268 | 3.1268 | 56000.0 |
| 2009-02-27 08:32:00 | AAPL | Stock | 3.1339 | 3.1339 | 3.1318 | 3.1318 | 36624.0 |
| 2009-02-27 08:35:00 | AAPL | Stock | 3.1339 | 3.1339 | 3.1339 | 3.1339 | 3444.0 |
| 2009-02-27 08:39:00 | AAPL | Stock | 3.1311 | 3.1318 | 3.1268 | 3.1268 | 89516.0 |
| 2009-02-27 08:40:00 | AAPL | Stock | 3.1268 | 3.1296 | 3.1268 | 3.1296 | 14000.0 |
| 2009-02-27 08:41:00 | AAPL | Stock | 3.1296 | 3.1304 | 3.1296 | 3.1304 | 16800.0 |
| 2009-02-27 08:42:00 | AAPL | Stock | 3.1307 | 3.1339 | 3.1307 | 3.1339 | 11200.0 |
| 2009-02-27 08:43:00 | AAPL | Stock | 3.1382 | 3.1386 | 3.1382 | 3.1386 | 5600.0 |
| 2009-02-27 08:44:00 | AAPL | Stock | 3.1404 | 3.1404 | 3.1357 | 3.1393 | 19600.0 |
| 2009-02-27 08:46:00 | AAPL | Stock | 3.1375 | 3.1389 | 3.1375 | 3.1389 | 5600.0 |
| 2009-02-27 08:47:00 | AAPL | Stock | 3.1389 | 3.1425 | 3.1357 | 3.1425 | 84000.0 |
| 2009-02-27 08:48:00 | AAPL | Stock | 3.1411 | 3.1486 | 3.1411 | 3.1482 | 203868.0 |
| 2009-02-27 08:50:00 | AAPL | Stock | 3.1461 | 3.1482 | 3.1461 | 3.1464 | 11200.0 |
| 2009-02-27 08:51:00 | AAPL | Stock | 3.1489 | 3.1489 | 3.1464 | 3.1489 | 39200.0 |
| 2009-02-27 08:52:00 | AAPL | Stock | 3.1489 | 3.1489 | 3.1464 | 3.1464 | 30800.0 |
| 2009-02-27 08:53:00 | AAPL | Stock | 3.1464 | 3.1464 | 3.1464 | 3.1464 | 9044.0 |
| 2009-02-27 08:54:00 | AAPL | Stock | 3.1464 | 3.15 | 3.1464 | 3.15 | 28000.0 |
| 2009-02-27 08:55:00 | AAPL | Stock | 3.1486 | 3.1486 | 3.1475 | 3.1475 | 8400.0 |
| 2009-02-27 08:56:00 | AAPL | Stock | 3.1482 | 3.1482 | 3.1482 | 3.1482 | 28476.0 |
| 2009-02-27 08:57:00 | AAPL | Stock | 3.1482 | 3.1482 | 3.1464 | 3.1464 | 30856.0 |
| 2009-02-27 08:58:00 | AAPL | Stock | 3.1464 | 3.1482 | 3.1464 | 3.1482 | 19600.0 |
| 2009-02-27 09:01:00 | AAPL | Stock | 3.1471 | 3.1471 | 3.1471 | 3.1471 | 5600.0 |
| 2009-02-27 09:02:00 | AAPL | Stock | 3.1468 | 3.1468 | 3.1468 | 3.1468 | 2800.0 |
| 2009-02-27 09:04:00 | AAPL | Stock | 3.1482 | 3.1482 | 3.1482 | 3.1482 | 10640.0 |
| 2009-02-27 09:06:00 | AAPL | Stock | 3.1464 | 3.1464 | 3.1464 | 3.1464 | 8120.0 |
| 2009-02-27 09:07:00 | AAPL | Stock | 3.1464 | 3.1464 | 3.1429 | 3.1429 | 41580.0 |
| 2009-02-27 09:08:00 | AAPL | Stock | 3.1432 | 3.1432 | 3.1404 | 3.1404 | 61460.0 |
> showing 50 of 984,563 rows — these rows as CSV