PREVIEW / stock_1min / 2006-06-23
file: by_date/stock_1min/2006/2006-06-23.parquet size: 8.1 MB rows: 669,187 symbols: 1,881
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-23 07:26:00 | AAPL | Stock | 2.1329 | 2.1329 | 2.1329 | 2.1329 | 2800.0 |
| 2006-06-23 08:00:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1357 | 2.1357 | 19600.0 |
| 2006-06-23 08:01:00 | AAPL | Stock | 2.1407 | 2.1411 | 2.1407 | 2.1411 | 78400.0 |
| 2006-06-23 08:02:00 | AAPL | Stock | 2.1411 | 2.1425 | 2.1411 | 2.1425 | 28000.0 |
| 2006-06-23 08:04:00 | AAPL | Stock | 2.14 | 2.14 | 2.14 | 2.14 | 5600.0 |
| 2006-06-23 08:07:00 | AAPL | Stock | 2.1357 | 2.1411 | 2.1357 | 2.1411 | 36400.0 |
| 2006-06-23 08:09:00 | AAPL | Stock | 2.1368 | 2.1368 | 2.1368 | 2.1368 | 2800.0 |
| 2006-06-23 08:10:00 | AAPL | Stock | 2.1414 | 2.1414 | 2.1414 | 2.1414 | 2800.0 |
| 2006-06-23 08:12:00 | AAPL | Stock | 2.1364 | 2.1364 | 2.1357 | 2.1357 | 34244.0 |
| 2006-06-23 08:13:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1357 | 2.1357 | 13860.0 |
| 2006-06-23 08:14:00 | AAPL | Stock | 2.1357 | 2.1375 | 2.1357 | 2.1375 | 14000.0 |
| 2006-06-23 08:16:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1357 | 2.1357 | 14000.0 |
| 2006-06-23 08:17:00 | AAPL | Stock | 2.135 | 2.135 | 2.1339 | 2.1339 | 39200.0 |
| 2006-06-23 08:18:00 | AAPL | Stock | 2.1339 | 2.1425 | 2.1339 | 2.1404 | 313320.0 |
| 2006-06-23 08:20:00 | AAPL | Stock | 2.135 | 2.1357 | 2.135 | 2.1357 | 86800.0 |
| 2006-06-23 08:21:00 | AAPL | Stock | 2.1339 | 2.1339 | 2.1339 | 2.1339 | 14000.0 |
| 2006-06-23 08:27:00 | AAPL | Stock | 2.1339 | 2.1339 | 2.1339 | 2.1339 | 8400.0 |
| 2006-06-23 08:29:00 | AAPL | Stock | 2.1339 | 2.135 | 2.1339 | 2.135 | 89600.0 |
| 2006-06-23 08:30:00 | AAPL | Stock | 2.1354 | 2.1368 | 2.1354 | 2.1368 | 28000.0 |
| 2006-06-23 08:31:00 | AAPL | Stock | 2.135 | 2.135 | 2.135 | 2.135 | 13020.0 |
| 2006-06-23 08:32:00 | AAPL | Stock | 2.1314 | 2.1318 | 2.1307 | 2.1307 | 39200.0 |
| 2006-06-23 08:33:00 | AAPL | Stock | 2.1339 | 2.1357 | 2.1339 | 2.135 | 56000.0 |
| 2006-06-23 08:34:00 | AAPL | Stock | 2.1329 | 2.1357 | 2.1329 | 2.1357 | 69020.0 |
| 2006-06-23 08:35:00 | AAPL | Stock | 2.1357 | 2.1389 | 2.1357 | 2.1389 | 56000.0 |
| 2006-06-23 08:36:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1357 | 2.1357 | 14000.0 |
| 2006-06-23 08:37:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1357 | 2.1357 | 75600.0 |
| 2006-06-23 08:38:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1357 | 2.1357 | 12180.0 |
| 2006-06-23 08:40:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1357 | 2.1357 | 28000.0 |
| 2006-06-23 08:47:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.135 | 2.135 | 22400.0 |
| 2006-06-23 08:48:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1346 | 2.1346 | 36400.0 |
| 2006-06-23 08:49:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1354 | 2.1357 | 99820.0 |
| 2006-06-23 08:50:00 | AAPL | Stock | 2.1346 | 2.1346 | 2.1346 | 2.1346 | 5600.0 |
| 2006-06-23 08:52:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1357 | 2.1357 | 2800.0 |
| 2006-06-23 08:53:00 | AAPL | Stock | 2.1361 | 2.1361 | 2.1361 | 2.1361 | 11200.0 |
| 2006-06-23 08:54:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1357 | 2.1357 | 19600.0 |
| 2006-06-23 08:56:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.135 | 2.135 | 100800.0 |
| 2006-06-23 08:57:00 | AAPL | Stock | 2.135 | 2.135 | 2.1343 | 2.1343 | 11200.0 |
| 2006-06-23 08:58:00 | AAPL | Stock | 2.135 | 2.135 | 2.135 | 2.135 | 11200.0 |
| 2006-06-23 08:59:00 | AAPL | Stock | 2.1343 | 2.1343 | 2.1343 | 2.1343 | 2800.0 |
| 2006-06-23 09:00:00 | AAPL | Stock | 2.1343 | 2.1343 | 2.1339 | 2.1339 | 25200.0 |
| 2006-06-23 09:01:00 | AAPL | Stock | 2.1339 | 2.1339 | 2.1321 | 2.1321 | 72800.0 |
| 2006-06-23 09:02:00 | AAPL | Stock | 2.1321 | 2.1321 | 2.1321 | 2.1321 | 30800.0 |
| 2006-06-23 09:03:00 | AAPL | Stock | 2.1311 | 2.1314 | 2.1307 | 2.1311 | 78400.0 |
| 2006-06-23 09:04:00 | AAPL | Stock | 2.1307 | 2.1307 | 2.1304 | 2.1304 | 30800.0 |
| 2006-06-23 09:05:00 | AAPL | Stock | 2.1293 | 2.1296 | 2.1279 | 2.1279 | 142800.0 |
| 2006-06-23 09:06:00 | AAPL | Stock | 2.1268 | 2.1271 | 2.1257 | 2.1257 | 48160.0 |
| 2006-06-23 09:07:00 | AAPL | Stock | 2.1268 | 2.1268 | 2.125 | 2.1257 | 41664.0 |
| 2006-06-23 09:08:00 | AAPL | Stock | 2.125 | 2.125 | 2.1239 | 2.1239 | 58800.0 |
| 2006-06-23 09:09:00 | AAPL | Stock | 2.1232 | 2.1232 | 2.1225 | 2.1232 | 67060.0 |
| 2006-06-23 09:10:00 | AAPL | Stock | 2.1232 | 2.125 | 2.1232 | 2.125 | 30800.0 |
> showing 50 of 669,187 rows — these rows as CSV