PREVIEW / stock_1min / 2012-01-05
file: by_date/stock_1min/2012/2012-01-05.parquet size: 12.9 MB rows: 961,256 symbols: 2,850
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-05 04:52:00 | AAPL | Stock | 14.7504 | 14.7504 | 14.7504 | 14.7504 | 5600.0 |
| 2012-01-05 05:06:00 | AAPL | Stock | 14.7339 | 14.7339 | 14.7321 | 14.7321 | 7000.0 |
| 2012-01-05 05:07:00 | AAPL | Stock | 14.7321 | 14.7321 | 14.7321 | 14.7321 | 24220.0 |
| 2012-01-05 05:22:00 | AAPL | Stock | 14.7321 | 14.7321 | 14.7321 | 14.7321 | 25200.0 |
| 2012-01-05 05:44:00 | AAPL | Stock | 14.7321 | 14.7321 | 14.7321 | 14.7321 | 2800.0 |
| 2012-01-05 05:55:00 | AAPL | Stock | 14.7143 | 14.7143 | 14.7143 | 14.7143 | 2800.0 |
| 2012-01-05 06:03:00 | AAPL | Stock | 14.7143 | 14.7143 | 14.7143 | 14.7143 | 5600.0 |
| 2012-01-05 06:04:00 | AAPL | Stock | 14.7 | 14.7 | 14.7 | 14.7 | 12600.0 |
| 2012-01-05 06:17:00 | AAPL | Stock | 14.7143 | 14.7143 | 14.7143 | 14.7143 | 5600.0 |
| 2012-01-05 06:39:00 | AAPL | Stock | 14.6982 | 14.6982 | 14.6982 | 14.6982 | 2800.0 |
| 2012-01-05 06:40:00 | AAPL | Stock | 14.6964 | 14.6964 | 14.6964 | 14.6964 | 2800.0 |
| 2012-01-05 06:41:00 | AAPL | Stock | 14.685 | 14.685 | 14.685 | 14.685 | 5600.0 |
| 2012-01-05 06:42:00 | AAPL | Stock | 14.6786 | 14.6786 | 14.6786 | 14.6786 | 5600.0 |
| 2012-01-05 06:53:00 | AAPL | Stock | 14.6971 | 14.6971 | 14.6971 | 14.6971 | 5600.0 |
| 2012-01-05 07:01:00 | AAPL | Stock | 14.7054 | 14.7054 | 14.7054 | 14.7054 | 8400.0 |
| 2012-01-05 07:03:00 | AAPL | Stock | 14.7232 | 14.725 | 14.7232 | 14.725 | 7280.0 |
| 2012-01-05 07:11:00 | AAPL | Stock | 14.7271 | 14.7271 | 14.7271 | 14.7271 | 5600.0 |
| 2012-01-05 07:13:00 | AAPL | Stock | 14.7286 | 14.7286 | 14.7279 | 14.7279 | 11200.0 |
| 2012-01-05 07:15:00 | AAPL | Stock | 14.7325 | 14.7325 | 14.7325 | 14.7325 | 5600.0 |
| 2012-01-05 07:16:00 | AAPL | Stock | 14.7364 | 14.7364 | 14.7364 | 14.7364 | 5096.0 |
| 2012-01-05 07:17:00 | AAPL | Stock | 14.7321 | 14.7321 | 14.7271 | 14.7271 | 30240.0 |
| 2012-01-05 07:19:00 | AAPL | Stock | 14.7232 | 14.7232 | 14.7193 | 14.7193 | 14700.0 |
| 2012-01-05 07:28:00 | AAPL | Stock | 14.7257 | 14.7257 | 14.7257 | 14.7257 | 2800.0 |
| 2012-01-05 07:32:00 | AAPL | Stock | 14.7432 | 14.7436 | 14.7432 | 14.7436 | 11340.0 |
| 2012-01-05 07:37:00 | AAPL | Stock | 14.7486 | 14.7489 | 14.7486 | 14.7489 | 5740.0 |
| 2012-01-05 07:38:00 | AAPL | Stock | 14.7464 | 14.7464 | 14.7464 | 14.7464 | 2800.0 |
| 2012-01-05 07:39:00 | AAPL | Stock | 14.7582 | 14.7582 | 14.7582 | 14.7582 | 2800.0 |
| 2012-01-05 07:43:00 | AAPL | Stock | 14.7546 | 14.7571 | 14.7546 | 14.7571 | 8400.0 |
| 2012-01-05 07:45:00 | AAPL | Stock | 14.7507 | 14.7507 | 14.75 | 14.75 | 81200.0 |
| 2012-01-05 07:47:00 | AAPL | Stock | 14.75 | 14.75 | 14.75 | 14.75 | 14000.0 |
| 2012-01-05 07:48:00 | AAPL | Stock | 14.7532 | 14.7654 | 14.7532 | 14.7654 | 27552.0 |
| 2012-01-05 07:52:00 | AAPL | Stock | 14.7554 | 14.7621 | 14.7554 | 14.7621 | 11200.0 |
| 2012-01-05 07:53:00 | AAPL | Stock | 14.7668 | 14.7689 | 14.7668 | 14.7689 | 28000.0 |
| 2012-01-05 07:54:00 | AAPL | Stock | 14.7739 | 14.7761 | 14.7739 | 14.7761 | 8400.0 |
| 2012-01-05 07:55:00 | AAPL | Stock | 14.7721 | 14.775 | 14.7704 | 14.775 | 56000.0 |
| 2012-01-05 07:58:00 | AAPL | Stock | 14.7714 | 14.7714 | 14.7704 | 14.7704 | 75600.0 |
| 2012-01-05 08:00:00 | AAPL | Stock | 14.7743 | 14.7757 | 14.7589 | 14.7589 | 50372.0 |
| 2012-01-05 08:01:00 | AAPL | Stock | 14.7607 | 14.7614 | 14.76 | 14.76 | 14420.0 |
| 2012-01-05 08:02:00 | AAPL | Stock | 14.7611 | 14.7611 | 14.7536 | 14.7536 | 33600.0 |
| 2012-01-05 08:03:00 | AAPL | Stock | 14.7586 | 14.7586 | 14.75 | 14.75 | 111720.0 |
| 2012-01-05 08:04:00 | AAPL | Stock | 14.7532 | 14.7582 | 14.7429 | 14.7429 | 59164.0 |
| 2012-01-05 08:05:00 | AAPL | Stock | 14.7429 | 14.7461 | 14.7429 | 14.7461 | 11200.0 |
| 2012-01-05 08:06:00 | AAPL | Stock | 14.7461 | 14.75 | 14.7432 | 14.75 | 47544.0 |
| 2012-01-05 08:07:00 | AAPL | Stock | 14.7496 | 14.75 | 14.7496 | 14.75 | 8400.0 |
| 2012-01-05 08:09:00 | AAPL | Stock | 14.75 | 14.75 | 14.7493 | 14.75 | 14000.0 |
| 2012-01-05 08:11:00 | AAPL | Stock | 14.7468 | 14.7468 | 14.7468 | 14.7468 | 2800.0 |
| 2012-01-05 08:12:00 | AAPL | Stock | 14.7429 | 14.7429 | 14.7429 | 14.7429 | 2800.0 |
| 2012-01-05 08:13:00 | AAPL | Stock | 14.7489 | 14.7489 | 14.7489 | 14.7489 | 2800.0 |
| 2012-01-05 08:14:00 | AAPL | Stock | 14.7429 | 14.7493 | 14.7411 | 14.7493 | 26460.0 |
| 2012-01-05 08:15:00 | AAPL | Stock | 14.7582 | 14.7804 | 14.7382 | 14.7804 | 215852.0 |
> showing 50 of 961,256 rows — these rows as CSV