PREVIEW / stock_1min / 2011-05-20
file: by_date/stock_1min/2011/2011-05-20.parquet size: 12.9 MB rows: 979,779 symbols: 2,866
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-20 04:41:00 | AAPL | Stock | 12.1664 | 12.1664 | 12.1664 | 12.1664 | 2800.0 |
| 2011-05-20 05:29:00 | AAPL | Stock | 12.1643 | 12.1643 | 12.1429 | 12.1429 | 14000.0 |
| 2011-05-20 07:01:00 | AAPL | Stock | 12.1429 | 12.1429 | 12.1429 | 12.1429 | 2800.0 |
| 2011-05-20 07:03:00 | AAPL | Stock | 12.1643 | 12.165 | 12.1643 | 12.165 | 9800.0 |
| 2011-05-20 07:05:00 | AAPL | Stock | 12.1629 | 12.1629 | 12.1629 | 12.1629 | 2800.0 |
| 2011-05-20 07:06:00 | AAPL | Stock | 12.1589 | 12.1589 | 12.1586 | 12.1586 | 8400.0 |
| 2011-05-20 07:07:00 | AAPL | Stock | 12.1554 | 12.1554 | 12.1554 | 12.1554 | 2800.0 |
| 2011-05-20 07:16:00 | AAPL | Stock | 12.1643 | 12.1643 | 12.1625 | 12.1643 | 26320.0 |
| 2011-05-20 07:23:00 | AAPL | Stock | 12.1432 | 12.1432 | 12.1429 | 12.1429 | 14000.0 |
| 2011-05-20 07:32:00 | AAPL | Stock | 12.1432 | 12.1432 | 12.1432 | 12.1432 | 2800.0 |
| 2011-05-20 07:45:00 | AAPL | Stock | 12.1429 | 12.1429 | 12.1429 | 12.1429 | 2800.0 |
| 2011-05-20 07:59:00 | AAPL | Stock | 12.1346 | 12.1346 | 12.1346 | 12.1346 | 2800.0 |
| 2011-05-20 08:00:00 | AAPL | Stock | 12.1375 | 12.1429 | 12.1375 | 12.1414 | 21504.0 |
| 2011-05-20 08:05:00 | AAPL | Stock | 12.1375 | 12.1375 | 12.1375 | 12.1375 | 5600.0 |
| 2011-05-20 08:06:00 | AAPL | Stock | 12.1339 | 12.1339 | 12.1339 | 12.1339 | 2800.0 |
| 2011-05-20 08:08:00 | AAPL | Stock | 12.1304 | 12.1304 | 12.1286 | 12.1286 | 44800.0 |
| 2011-05-20 08:09:00 | AAPL | Stock | 12.1361 | 12.1375 | 12.1286 | 12.1289 | 81200.0 |
| 2011-05-20 08:10:00 | AAPL | Stock | 12.1286 | 12.1286 | 12.1286 | 12.1286 | 8120.0 |
| 2011-05-20 08:14:00 | AAPL | Stock | 12.1618 | 12.1618 | 12.1618 | 12.1618 | 84196.0 |
| 2011-05-20 08:15:00 | AAPL | Stock | 12.1286 | 12.1286 | 12.1286 | 12.1286 | 19600.0 |
| 2011-05-20 08:18:00 | AAPL | Stock | 12.1357 | 12.1357 | 12.1357 | 12.1357 | 7840.0 |
| 2011-05-20 08:20:00 | AAPL | Stock | 12.1393 | 12.1393 | 12.1393 | 12.1393 | 3220.0 |
| 2011-05-20 08:31:00 | AAPL | Stock | 12.1393 | 12.1393 | 12.1393 | 12.1393 | 6496.0 |
| 2011-05-20 08:32:00 | AAPL | Stock | 12.1357 | 12.1357 | 12.1357 | 12.1357 | 2800.0 |
| 2011-05-20 08:33:00 | AAPL | Stock | 12.1393 | 12.1393 | 12.1393 | 12.1393 | 4004.0 |
| 2011-05-20 08:35:00 | AAPL | Stock | 12.1429 | 12.1429 | 12.1429 | 12.1429 | 2800.0 |
| 2011-05-20 08:48:00 | AAPL | Stock | 12.1429 | 12.1429 | 12.1429 | 12.1429 | 5600.0 |
| 2011-05-20 08:55:00 | AAPL | Stock | 12.1429 | 12.1429 | 12.1429 | 12.1429 | 8736.0 |
| 2011-05-20 09:01:00 | AAPL | Stock | 12.1432 | 12.1432 | 12.1429 | 12.1429 | 7056.0 |
| 2011-05-20 09:02:00 | AAPL | Stock | 12.1411 | 12.1411 | 12.1393 | 12.1393 | 14000.0 |
| 2011-05-20 09:05:00 | AAPL | Stock | 12.1346 | 12.1346 | 12.13 | 12.13 | 15400.0 |
| 2011-05-20 09:06:00 | AAPL | Stock | 12.1286 | 12.1304 | 12.1286 | 12.1286 | 41076.0 |
| 2011-05-20 09:07:00 | AAPL | Stock | 12.1257 | 12.1257 | 12.12 | 12.1221 | 148876.0 |
| 2011-05-20 09:08:00 | AAPL | Stock | 12.1361 | 12.1361 | 12.1361 | 12.1361 | 2800.0 |
| 2011-05-20 09:09:00 | AAPL | Stock | 12.1282 | 12.1282 | 12.1282 | 12.1282 | 5600.0 |
| 2011-05-20 09:10:00 | AAPL | Stock | 12.1411 | 12.1429 | 12.1321 | 12.1321 | 30800.0 |
| 2011-05-20 09:12:00 | AAPL | Stock | 12.1286 | 12.1321 | 12.1286 | 12.1321 | 10584.0 |
| 2011-05-20 09:13:00 | AAPL | Stock | 12.1271 | 12.1271 | 12.125 | 12.125 | 76664.0 |
| 2011-05-20 09:14:00 | AAPL | Stock | 12.1264 | 12.1271 | 12.125 | 12.125 | 11200.0 |
| 2011-05-20 09:15:00 | AAPL | Stock | 12.1268 | 12.1271 | 12.1268 | 12.1271 | 8400.0 |
| 2011-05-20 09:16:00 | AAPL | Stock | 12.1257 | 12.1257 | 12.125 | 12.125 | 18900.0 |
| 2011-05-20 09:18:00 | AAPL | Stock | 12.1271 | 12.1271 | 12.1271 | 12.1271 | 8400.0 |
| 2011-05-20 09:19:00 | AAPL | Stock | 12.1271 | 12.1271 | 12.125 | 12.1268 | 19600.0 |
| 2011-05-20 09:20:00 | AAPL | Stock | 12.1271 | 12.1271 | 12.1271 | 12.1271 | 54936.0 |
| 2011-05-20 09:21:00 | AAPL | Stock | 12.1264 | 12.1264 | 12.1232 | 12.1232 | 21336.0 |
| 2011-05-20 09:23:00 | AAPL | Stock | 12.1204 | 12.1239 | 12.1204 | 12.1239 | 30800.0 |
| 2011-05-20 09:26:00 | AAPL | Stock | 12.12 | 12.1214 | 12.1189 | 12.1189 | 77000.0 |
| 2011-05-20 09:27:00 | AAPL | Stock | 12.12 | 12.1214 | 12.12 | 12.12 | 169904.0 |
| 2011-05-20 09:28:00 | AAPL | Stock | 12.1304 | 12.1336 | 12.1221 | 12.1221 | 210728.0 |
| 2011-05-20 09:29:00 | AAPL | Stock | 12.1239 | 12.1346 | 12.1239 | 12.1332 | 165620.0 |
> showing 50 of 979,779 rows — these rows as CSV