PREVIEW / stock_1min / 2005-01-04
file: by_date/stock_1min/2005/2005-01-04.parquet size: 7.4 MB rows: 594,514 symbols: 1,576
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-04 08:08:00 | AAPL | Stock | 1.1348 | 1.1348 | 1.1348 | 1.1348 | 50400.0 |
| 2005-01-04 08:09:00 | AAPL | Stock | 1.1371 | 1.1411 | 1.1371 | 1.1411 | 65800.0 |
| 2005-01-04 08:10:00 | AAPL | Stock | 1.1389 | 1.1411 | 1.1389 | 1.1396 | 121520.0 |
| 2005-01-04 08:11:00 | AAPL | Stock | 1.1407 | 1.1411 | 1.1407 | 1.1411 | 190400.0 |
| 2005-01-04 08:12:00 | AAPL | Stock | 1.1411 | 1.1425 | 1.1411 | 1.142 | 245280.0 |
| 2005-01-04 08:13:00 | AAPL | Stock | 1.1425 | 1.1429 | 1.1416 | 1.1429 | 402080.0 |
| 2005-01-04 08:14:00 | AAPL | Stock | 1.143 | 1.143 | 1.143 | 1.143 | 28000.0 |
| 2005-01-04 08:15:00 | AAPL | Stock | 1.143 | 1.1445 | 1.1429 | 1.1445 | 143920.0 |
| 2005-01-04 08:16:00 | AAPL | Stock | 1.1446 | 1.1446 | 1.1446 | 1.1446 | 56000.0 |
| 2005-01-04 08:17:00 | AAPL | Stock | 1.143 | 1.1446 | 1.143 | 1.1438 | 112000.0 |
| 2005-01-04 08:18:00 | AAPL | Stock | 1.1429 | 1.1429 | 1.1402 | 1.1402 | 95200.0 |
| 2005-01-04 08:19:00 | AAPL | Stock | 1.142 | 1.142 | 1.1411 | 1.142 | 123200.0 |
| 2005-01-04 08:20:00 | AAPL | Stock | 1.1404 | 1.1411 | 1.1402 | 1.1411 | 212800.0 |
| 2005-01-04 08:21:00 | AAPL | Stock | 1.1411 | 1.1411 | 1.1409 | 1.1409 | 40320.0 |
| 2005-01-04 08:22:00 | AAPL | Stock | 1.1409 | 1.1409 | 1.1375 | 1.1375 | 224896.0 |
| 2005-01-04 08:23:00 | AAPL | Stock | 1.1375 | 1.1375 | 1.1366 | 1.1366 | 76384.0 |
| 2005-01-04 08:24:00 | AAPL | Stock | 1.1366 | 1.1366 | 1.1366 | 1.1366 | 106400.0 |
| 2005-01-04 08:25:00 | AAPL | Stock | 1.1366 | 1.1366 | 1.1366 | 1.1366 | 84000.0 |
| 2005-01-04 08:26:00 | AAPL | Stock | 1.1366 | 1.1366 | 1.1366 | 1.1366 | 56000.0 |
| 2005-01-04 08:27:00 | AAPL | Stock | 1.1366 | 1.138 | 1.1366 | 1.138 | 140000.0 |
| 2005-01-04 08:28:00 | AAPL | Stock | 1.1375 | 1.138 | 1.1375 | 1.138 | 445536.0 |
| 2005-01-04 08:29:00 | AAPL | Stock | 1.1375 | 1.1375 | 1.1375 | 1.1375 | 11200.0 |
| 2005-01-04 08:30:00 | AAPL | Stock | 1.1375 | 1.1384 | 1.1375 | 1.1384 | 42952.0 |
| 2005-01-04 08:31:00 | AAPL | Stock | 1.1375 | 1.1384 | 1.1375 | 1.1384 | 60200.0 |
| 2005-01-04 08:32:00 | AAPL | Stock | 1.1384 | 1.1384 | 1.1384 | 1.1384 | 50400.0 |
| 2005-01-04 08:33:00 | AAPL | Stock | 1.1384 | 1.1423 | 1.1384 | 1.1421 | 201600.0 |
| 2005-01-04 08:34:00 | AAPL | Stock | 1.142 | 1.1436 | 1.142 | 1.143 | 263480.0 |
| 2005-01-04 08:35:00 | AAPL | Stock | 1.1432 | 1.1432 | 1.1421 | 1.1427 | 196000.0 |
| 2005-01-04 08:37:00 | AAPL | Stock | 1.1427 | 1.1429 | 1.1427 | 1.1427 | 57624.0 |
| 2005-01-04 08:38:00 | AAPL | Stock | 1.1427 | 1.1427 | 1.1427 | 1.1427 | 28000.0 |
| 2005-01-04 08:39:00 | AAPL | Stock | 1.1414 | 1.1414 | 1.1414 | 1.1414 | 19880.0 |
| 2005-01-04 08:40:00 | AAPL | Stock | 1.142 | 1.142 | 1.1414 | 1.1414 | 16800.0 |
| 2005-01-04 08:41:00 | AAPL | Stock | 1.1409 | 1.1411 | 1.1409 | 1.1411 | 64680.0 |
| 2005-01-04 08:43:00 | AAPL | Stock | 1.1416 | 1.1416 | 1.1407 | 1.1407 | 11200.0 |
| 2005-01-04 08:45:00 | AAPL | Stock | 1.1411 | 1.1411 | 1.1411 | 1.1411 | 11200.0 |
| 2005-01-04 08:47:00 | AAPL | Stock | 1.1405 | 1.1405 | 1.1402 | 1.1402 | 252000.0 |
| 2005-01-04 08:48:00 | AAPL | Stock | 1.1395 | 1.1395 | 1.1395 | 1.1395 | 16800.0 |
| 2005-01-04 08:49:00 | AAPL | Stock | 1.1393 | 1.1395 | 1.1393 | 1.1395 | 19600.0 |
| 2005-01-04 08:51:00 | AAPL | Stock | 1.1393 | 1.1393 | 1.1393 | 1.1393 | 11200.0 |
| 2005-01-04 08:53:00 | AAPL | Stock | 1.1393 | 1.1393 | 1.1393 | 1.1393 | 72800.0 |
| 2005-01-04 08:54:00 | AAPL | Stock | 1.1393 | 1.1393 | 1.1393 | 1.1393 | 5600.0 |
| 2005-01-04 08:58:00 | AAPL | Stock | 1.1402 | 1.1402 | 1.1393 | 1.1393 | 134400.0 |
| 2005-01-04 08:59:00 | AAPL | Stock | 1.1393 | 1.1393 | 1.1393 | 1.1393 | 5600.0 |
| 2005-01-04 09:01:00 | AAPL | Stock | 1.1311 | 1.1311 | 1.1311 | 1.1311 | 168000.0 |
| 2005-01-04 09:02:00 | AAPL | Stock | 1.1393 | 1.1393 | 1.1393 | 1.1393 | 5600.0 |
| 2005-01-04 09:03:00 | AAPL | Stock | 1.1393 | 1.1393 | 1.1393 | 1.1393 | 11200.0 |
| 2005-01-04 09:05:00 | AAPL | Stock | 1.1393 | 1.1407 | 1.1393 | 1.1407 | 19600.0 |
| 2005-01-04 09:06:00 | AAPL | Stock | 1.1407 | 1.1407 | 1.1407 | 1.1407 | 16800.0 |
| 2005-01-04 09:07:00 | AAPL | Stock | 1.1393 | 1.1393 | 1.1393 | 1.1393 | 28000.0 |
| 2005-01-04 09:09:00 | AAPL | Stock | 1.1407 | 1.1411 | 1.1393 | 1.1393 | 181720.0 |
> showing 50 of 594,514 rows — these rows as CSV