PREVIEW / stock_1min / 2010-02-23
file: by_date/stock_1min/2010/2010-02-23.parquet size: 12.9 MB rows: 988,607 symbols: 2,809
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-23 04:49:00 | AAPL | Stock | 7.1764 | 7.1764 | 7.1764 | 7.1764 | 2800.0 |
| 2010-02-23 05:31:00 | AAPL | Stock | 7.1621 | 7.1621 | 7.1611 | 7.1611 | 5740.0 |
| 2010-02-23 06:13:00 | AAPL | Stock | 7.1411 | 7.1411 | 7.1411 | 7.1411 | 4032.0 |
| 2010-02-23 06:37:00 | AAPL | Stock | 7.1254 | 7.1254 | 7.1254 | 7.1254 | 2800.0 |
| 2010-02-23 06:46:00 | AAPL | Stock | 7.1254 | 7.1254 | 7.1254 | 7.1254 | 2800.0 |
| 2010-02-23 07:06:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 3220.0 |
| 2010-02-23 07:24:00 | AAPL | Stock | 7.1289 | 7.1289 | 7.1289 | 7.1289 | 11200.0 |
| 2010-02-23 07:26:00 | AAPL | Stock | 7.1336 | 7.1336 | 7.1336 | 7.1336 | 2800.0 |
| 2010-02-23 07:37:00 | AAPL | Stock | 7.1321 | 7.1321 | 7.1304 | 7.1304 | 16800.0 |
| 2010-02-23 07:44:00 | AAPL | Stock | 7.1286 | 7.1286 | 7.1286 | 7.1286 | 2800.0 |
| 2010-02-23 07:47:00 | AAPL | Stock | 7.1304 | 7.1304 | 7.1304 | 7.1304 | 2800.0 |
| 2010-02-23 08:00:00 | AAPL | Stock | 7.1304 | 7.15 | 7.1304 | 7.1329 | 58800.0 |
| 2010-02-23 08:01:00 | AAPL | Stock | 7.1386 | 7.1393 | 7.1386 | 7.1393 | 5600.0 |
| 2010-02-23 08:02:00 | AAPL | Stock | 7.14 | 7.14 | 7.14 | 7.14 | 2800.0 |
| 2010-02-23 08:03:00 | AAPL | Stock | 7.1357 | 7.14 | 7.1357 | 7.14 | 55580.0 |
| 2010-02-23 08:04:00 | AAPL | Stock | 7.1393 | 7.1393 | 7.1393 | 7.1393 | 10780.0 |
| 2010-02-23 08:11:00 | AAPL | Stock | 7.1375 | 7.1375 | 7.1375 | 7.1375 | 14000.0 |
| 2010-02-23 08:13:00 | AAPL | Stock | 7.1375 | 7.1375 | 7.1375 | 7.1375 | 19600.0 |
| 2010-02-23 08:14:00 | AAPL | Stock | 7.1375 | 7.1375 | 7.1375 | 7.1375 | 95200.0 |
| 2010-02-23 08:15:00 | AAPL | Stock | 7.1375 | 7.1375 | 7.1357 | 7.1357 | 15680.0 |
| 2010-02-23 08:16:00 | AAPL | Stock | 7.1321 | 7.1321 | 7.1321 | 7.1321 | 11200.0 |
| 2010-02-23 08:18:00 | AAPL | Stock | 7.1321 | 7.1321 | 7.1321 | 7.1321 | 7000.0 |
| 2010-02-23 08:21:00 | AAPL | Stock | 7.1389 | 7.1393 | 7.1389 | 7.1393 | 5600.0 |
| 2010-02-23 08:23:00 | AAPL | Stock | 7.1393 | 7.14 | 7.1393 | 7.1393 | 30800.0 |
| 2010-02-23 08:26:00 | AAPL | Stock | 7.1429 | 7.1429 | 7.1429 | 7.1429 | 2800.0 |
| 2010-02-23 08:27:00 | AAPL | Stock | 7.1429 | 7.1429 | 7.1429 | 7.1429 | 2800.0 |
| 2010-02-23 08:28:00 | AAPL | Stock | 7.1429 | 7.1429 | 7.1429 | 7.1429 | 14000.0 |
| 2010-02-23 08:30:00 | AAPL | Stock | 7.1375 | 7.1375 | 7.1364 | 7.1364 | 5600.0 |
| 2010-02-23 08:33:00 | AAPL | Stock | 7.1389 | 7.1389 | 7.1389 | 7.1389 | 2800.0 |
| 2010-02-23 08:34:00 | AAPL | Stock | 7.1389 | 7.1411 | 7.1389 | 7.1411 | 5600.0 |
| 2010-02-23 08:35:00 | AAPL | Stock | 7.1375 | 7.1409 | 7.1375 | 7.1409 | 16800.0 |
| 2010-02-23 08:36:00 | AAPL | Stock | 7.1368 | 7.1368 | 7.1364 | 7.1364 | 8400.0 |
| 2010-02-23 08:37:00 | AAPL | Stock | 7.1393 | 7.1393 | 7.1336 | 7.1354 | 65100.0 |
| 2010-02-23 08:38:00 | AAPL | Stock | 7.1325 | 7.1354 | 7.13 | 7.1321 | 50400.0 |
| 2010-02-23 08:39:00 | AAPL | Stock | 7.1314 | 7.1321 | 7.1307 | 7.1321 | 29400.0 |
| 2010-02-23 08:40:00 | AAPL | Stock | 7.1321 | 7.1325 | 7.13 | 7.13 | 32200.0 |
| 2010-02-23 08:41:00 | AAPL | Stock | 7.1293 | 7.13 | 7.1282 | 7.1282 | 145712.0 |
| 2010-02-23 08:42:00 | AAPL | Stock | 7.1268 | 7.1318 | 7.1268 | 7.1318 | 15596.0 |
| 2010-02-23 08:43:00 | AAPL | Stock | 7.1304 | 7.1304 | 7.1304 | 7.1304 | 2800.0 |
| 2010-02-23 08:46:00 | AAPL | Stock | 7.1321 | 7.1321 | 7.1321 | 7.1321 | 15120.0 |
| 2010-02-23 08:47:00 | AAPL | Stock | 7.1321 | 7.1321 | 7.1321 | 7.1321 | 30492.0 |
| 2010-02-23 08:51:00 | AAPL | Stock | 7.1321 | 7.1339 | 7.1321 | 7.1339 | 5600.0 |
| 2010-02-23 08:53:00 | AAPL | Stock | 7.1346 | 7.1346 | 7.1321 | 7.1321 | 19600.0 |
| 2010-02-23 08:54:00 | AAPL | Stock | 7.1336 | 7.1343 | 7.1336 | 7.1343 | 42000.0 |
| 2010-02-23 08:55:00 | AAPL | Stock | 7.1339 | 7.1339 | 7.1339 | 7.1339 | 11200.0 |
| 2010-02-23 08:58:00 | AAPL | Stock | 7.1336 | 7.1336 | 7.1336 | 7.1336 | 5600.0 |
| 2010-02-23 09:00:00 | AAPL | Stock | 7.1332 | 7.1332 | 7.1332 | 7.1332 | 2800.0 |
| 2010-02-23 09:02:00 | AAPL | Stock | 7.1354 | 7.1354 | 7.1354 | 7.1354 | 2800.0 |
| 2010-02-23 09:03:00 | AAPL | Stock | 7.1336 | 7.1336 | 7.1329 | 7.1329 | 30800.0 |
| 2010-02-23 09:04:00 | AAPL | Stock | 7.1325 | 7.1325 | 7.1307 | 7.1307 | 43176.0 |
> showing 50 of 988,607 rows — these rows as CSV