PREVIEW / stock_1min / 2008-07-07
file: by_date/stock_1min/2008/2008-07-07.parquet size: 13.3 MB rows: 1,056,669 symbols: 2,726
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-07-07 05:15:00 | AAPL | Stock | 6.1136 | 6.1136 | 6.1136 | 6.1136 | 2800.0 |
| 2008-07-07 06:58:00 | AAPL | Stock | 6.1125 | 6.1125 | 6.1125 | 6.1125 | 24724.0 |
| 2008-07-07 07:03:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 2800.0 |
| 2008-07-07 07:06:00 | AAPL | Stock | 6.1125 | 6.1125 | 6.1125 | 6.1125 | 8400.0 |
| 2008-07-07 07:07:00 | AAPL | Stock | 6.1125 | 6.1125 | 6.1125 | 6.1125 | 36400.0 |
| 2008-07-07 07:11:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 14000.0 |
| 2008-07-07 07:13:00 | AAPL | Stock | 6.1057 | 6.1057 | 6.1057 | 6.1057 | 2800.0 |
| 2008-07-07 07:14:00 | AAPL | Stock | 6.1057 | 6.1057 | 6.1057 | 6.1057 | 5600.0 |
| 2008-07-07 07:17:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 2800.0 |
| 2008-07-07 07:18:00 | AAPL | Stock | 6.1071 | 6.1164 | 6.1071 | 6.1164 | 25200.0 |
| 2008-07-07 07:20:00 | AAPL | Stock | 6.1164 | 6.1164 | 6.1164 | 6.1164 | 11676.0 |
| 2008-07-07 07:21:00 | AAPL | Stock | 6.1164 | 6.1164 | 6.1164 | 6.1164 | 16324.0 |
| 2008-07-07 07:22:00 | AAPL | Stock | 6.125 | 6.125 | 6.125 | 6.125 | 30940.0 |
| 2008-07-07 07:24:00 | AAPL | Stock | 6.125 | 6.125 | 6.125 | 6.125 | 17780.0 |
| 2008-07-07 07:26:00 | AAPL | Stock | 6.1243 | 6.1243 | 6.1243 | 6.1243 | 13020.0 |
| 2008-07-07 07:27:00 | AAPL | Stock | 6.125 | 6.1261 | 6.125 | 6.1261 | 28000.0 |
| 2008-07-07 07:28:00 | AAPL | Stock | 6.1261 | 6.1261 | 6.1261 | 6.1261 | 2800.0 |
| 2008-07-07 07:40:00 | AAPL | Stock | 6.1071 | 6.1079 | 6.1071 | 6.1071 | 85680.0 |
| 2008-07-07 07:41:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 54320.0 |
| 2008-07-07 07:49:00 | AAPL | Stock | 6.125 | 6.125 | 6.125 | 6.125 | 5600.0 |
| 2008-07-07 07:52:00 | AAPL | Stock | 6.1296 | 6.1296 | 6.1296 | 6.1296 | 2800.0 |
| 2008-07-07 07:53:00 | AAPL | Stock | 6.125 | 6.1286 | 6.125 | 6.1286 | 5600.0 |
| 2008-07-07 07:55:00 | AAPL | Stock | 6.1296 | 6.1321 | 6.1296 | 6.1321 | 8400.0 |
| 2008-07-07 07:56:00 | AAPL | Stock | 6.1321 | 6.1321 | 6.1321 | 6.1321 | 26320.0 |
| 2008-07-07 07:57:00 | AAPL | Stock | 6.1496 | 6.15 | 6.125 | 6.1357 | 64960.0 |
| 2008-07-07 07:58:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1364 | 6.1364 | 5600.0 |
| 2008-07-07 07:59:00 | AAPL | Stock | 6.1357 | 6.1357 | 6.1357 | 6.1357 | 16800.0 |
| 2008-07-07 08:00:00 | AAPL | Stock | 6.1361 | 6.1361 | 6.1246 | 6.1354 | 66052.0 |
| 2008-07-07 08:01:00 | AAPL | Stock | 6.1332 | 6.1332 | 6.1332 | 6.1332 | 5600.0 |
| 2008-07-07 08:02:00 | AAPL | Stock | 6.1321 | 6.1339 | 6.125 | 6.1339 | 128436.0 |
| 2008-07-07 08:03:00 | AAPL | Stock | 6.1268 | 6.135 | 6.125 | 6.135 | 22400.0 |
| 2008-07-07 08:04:00 | AAPL | Stock | 6.1321 | 6.1354 | 6.1321 | 6.1321 | 39200.0 |
| 2008-07-07 08:05:00 | AAPL | Stock | 6.1357 | 6.1393 | 6.1357 | 6.1357 | 78876.0 |
| 2008-07-07 08:06:00 | AAPL | Stock | 6.1425 | 6.1425 | 6.1396 | 6.1396 | 42000.0 |
| 2008-07-07 08:07:00 | AAPL | Stock | 6.1425 | 6.1425 | 6.14 | 6.1425 | 22400.0 |
| 2008-07-07 08:08:00 | AAPL | Stock | 6.1425 | 6.1429 | 6.1425 | 6.1429 | 131908.0 |
| 2008-07-07 08:09:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 5600.0 |
| 2008-07-07 08:10:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 35140.0 |
| 2008-07-07 08:11:00 | AAPL | Stock | 6.14 | 6.14 | 6.1364 | 6.1364 | 72800.0 |
| 2008-07-07 08:12:00 | AAPL | Stock | 6.1393 | 6.1396 | 6.1393 | 6.1396 | 8400.0 |
| 2008-07-07 08:14:00 | AAPL | Stock | 6.1396 | 6.1429 | 6.1396 | 6.1429 | 61600.0 |
| 2008-07-07 08:15:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1425 | 6.1425 | 67200.0 |
| 2008-07-07 08:16:00 | AAPL | Stock | 6.1429 | 6.1446 | 6.1414 | 6.1446 | 68488.0 |
| 2008-07-07 08:17:00 | AAPL | Stock | 6.1461 | 6.1464 | 6.1461 | 6.1464 | 14000.0 |
| 2008-07-07 08:18:00 | AAPL | Stock | 6.1482 | 6.1504 | 6.1429 | 6.1446 | 302932.0 |
| 2008-07-07 08:20:00 | AAPL | Stock | 6.1471 | 6.1571 | 6.1471 | 6.1571 | 196168.0 |
| 2008-07-07 08:21:00 | AAPL | Stock | 6.1596 | 6.1782 | 6.1593 | 6.1782 | 112252.0 |
| 2008-07-07 08:22:00 | AAPL | Stock | 6.1704 | 6.1768 | 6.1704 | 6.1768 | 35000.0 |
| 2008-07-07 08:23:00 | AAPL | Stock | 6.1693 | 6.1693 | 6.1618 | 6.1618 | 19600.0 |
| 2008-07-07 08:24:00 | AAPL | Stock | 6.1707 | 6.1782 | 6.1707 | 6.175 | 70000.0 |
> showing 50 of 1,056,669 rows — these rows as CSV