PREVIEW / stock_1min / 2008-04-29
file: by_date/stock_1min/2008/2008-04-29.parquet size: 11.8 MB rows: 949,613 symbols: 2,683
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-29 07:11:00 | AAPL | Stock | 6.1179 | 6.1296 | 6.1179 | 6.1296 | 11200.0 |
| 2008-04-29 07:31:00 | AAPL | Stock | 6.1293 | 6.1293 | 6.1293 | 6.1293 | 2800.0 |
| 2008-04-29 07:32:00 | AAPL | Stock | 6.1296 | 6.1296 | 6.1296 | 6.1296 | 11200.0 |
| 2008-04-29 07:33:00 | AAPL | Stock | 6.1271 | 6.1271 | 6.1268 | 6.1268 | 8120.0 |
| 2008-04-29 07:40:00 | AAPL | Stock | 6.1514 | 6.1514 | 6.1514 | 6.1514 | 14000.0 |
| 2008-04-29 07:53:00 | AAPL | Stock | 6.1357 | 6.1357 | 6.1357 | 6.1357 | 2800.0 |
| 2008-04-29 08:00:00 | AAPL | Stock | 6.1321 | 6.1375 | 6.1321 | 6.1375 | 215992.0 |
| 2008-04-29 08:01:00 | AAPL | Stock | 6.1429 | 6.1436 | 6.1393 | 6.1407 | 39872.0 |
| 2008-04-29 08:02:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1371 | 6.1371 | 56980.0 |
| 2008-04-29 08:03:00 | AAPL | Stock | 6.1339 | 6.1339 | 6.1339 | 6.1339 | 26180.0 |
| 2008-04-29 08:04:00 | AAPL | Stock | 6.1339 | 6.1339 | 6.1339 | 6.1339 | 170352.0 |
| 2008-04-29 08:05:00 | AAPL | Stock | 6.1339 | 6.1339 | 6.1321 | 6.1321 | 89012.0 |
| 2008-04-29 08:06:00 | AAPL | Stock | 6.1321 | 6.1321 | 6.1289 | 6.1289 | 32200.0 |
| 2008-04-29 08:07:00 | AAPL | Stock | 6.1286 | 6.1339 | 6.1286 | 6.1339 | 26992.0 |
| 2008-04-29 08:08:00 | AAPL | Stock | 6.1336 | 6.1336 | 6.1336 | 6.1336 | 2800.0 |
| 2008-04-29 08:09:00 | AAPL | Stock | 6.1307 | 6.1307 | 6.1307 | 6.1307 | 8400.0 |
| 2008-04-29 08:11:00 | AAPL | Stock | 6.1286 | 6.13 | 6.1268 | 6.1271 | 63700.0 |
| 2008-04-29 08:12:00 | AAPL | Stock | 6.1293 | 6.1321 | 6.1293 | 6.1321 | 19600.0 |
| 2008-04-29 08:13:00 | AAPL | Stock | 6.1329 | 6.14 | 6.1321 | 6.14 | 159432.0 |
| 2008-04-29 08:14:00 | AAPL | Stock | 6.14 | 6.1429 | 6.14 | 6.1429 | 12880.0 |
| 2008-04-29 08:15:00 | AAPL | Stock | 6.1429 | 6.1446 | 6.1429 | 6.1443 | 50400.0 |
| 2008-04-29 08:16:00 | AAPL | Stock | 6.1421 | 6.1446 | 6.1404 | 6.1407 | 100688.0 |
| 2008-04-29 08:17:00 | AAPL | Stock | 6.1425 | 6.1429 | 6.1425 | 6.1429 | 19600.0 |
| 2008-04-29 08:18:00 | AAPL | Stock | 6.14 | 6.1411 | 6.1393 | 6.1393 | 36400.0 |
| 2008-04-29 08:19:00 | AAPL | Stock | 6.1389 | 6.1389 | 6.1357 | 6.1379 | 25900.0 |
| 2008-04-29 08:20:00 | AAPL | Stock | 6.1393 | 6.1446 | 6.1393 | 6.1446 | 88480.0 |
| 2008-04-29 08:21:00 | AAPL | Stock | 6.1446 | 6.1446 | 6.1432 | 6.1432 | 89600.0 |
| 2008-04-29 08:22:00 | AAPL | Stock | 6.1464 | 6.1464 | 6.1393 | 6.1393 | 146524.0 |
| 2008-04-29 08:26:00 | AAPL | Stock | 6.1411 | 6.1411 | 6.1361 | 6.1361 | 6440.0 |
| 2008-04-29 08:27:00 | AAPL | Stock | 6.1364 | 6.1411 | 6.1364 | 6.1371 | 44800.0 |
| 2008-04-29 08:28:00 | AAPL | Stock | 6.1396 | 6.1396 | 6.1396 | 6.1396 | 2800.0 |
| 2008-04-29 08:30:00 | AAPL | Stock | 6.1421 | 6.1429 | 6.1421 | 6.1429 | 32060.0 |
| 2008-04-29 08:31:00 | AAPL | Stock | 6.1446 | 6.1446 | 6.1425 | 6.1425 | 49196.0 |
| 2008-04-29 08:33:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 11200.0 |
| 2008-04-29 08:34:00 | AAPL | Stock | 6.1429 | 6.1432 | 6.1429 | 6.1432 | 10920.0 |
| 2008-04-29 08:35:00 | AAPL | Stock | 6.1429 | 6.1443 | 6.1429 | 6.1429 | 30240.0 |
| 2008-04-29 08:36:00 | AAPL | Stock | 6.1436 | 6.1436 | 6.1432 | 6.1432 | 27776.0 |
| 2008-04-29 08:37:00 | AAPL | Stock | 6.1432 | 6.1461 | 6.1432 | 6.1461 | 5600.0 |
| 2008-04-29 08:38:00 | AAPL | Stock | 6.1461 | 6.1461 | 6.1461 | 6.1461 | 2800.0 |
| 2008-04-29 08:39:00 | AAPL | Stock | 6.1443 | 6.1446 | 6.1443 | 6.1446 | 48664.0 |
| 2008-04-29 08:40:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 16380.0 |
| 2008-04-29 08:41:00 | AAPL | Stock | 6.1429 | 6.1439 | 6.1429 | 6.1439 | 254940.0 |
| 2008-04-29 08:42:00 | AAPL | Stock | 6.1421 | 6.1425 | 6.1421 | 6.1425 | 11200.0 |
| 2008-04-29 08:43:00 | AAPL | Stock | 6.1425 | 6.1425 | 6.1425 | 6.1425 | 2800.0 |
| 2008-04-29 08:44:00 | AAPL | Stock | 6.1414 | 6.1414 | 6.1414 | 6.1414 | 2800.0 |
| 2008-04-29 08:45:00 | AAPL | Stock | 6.1411 | 6.1411 | 6.1407 | 6.1407 | 42000.0 |
| 2008-04-29 08:46:00 | AAPL | Stock | 6.1404 | 6.1404 | 6.1386 | 6.1393 | 46480.0 |
| 2008-04-29 08:47:00 | AAPL | Stock | 6.1368 | 6.1386 | 6.1361 | 6.1364 | 39480.0 |
| 2008-04-29 08:48:00 | AAPL | Stock | 6.1364 | 6.1364 | 6.1361 | 6.1361 | 11200.0 |
| 2008-04-29 08:49:00 | AAPL | Stock | 6.1357 | 6.1357 | 6.1336 | 6.1336 | 112000.0 |
> showing 50 of 949,613 rows — these rows as CSV