PREVIEW / stock_1min / 2012-03-30
file: by_date/stock_1min/2012/2012-03-30.parquet size: 13.0 MB rows: 964,782 symbols: 2,882
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-03-30 04:20:00 | AAPL | Stock | 21.6193 | 21.6193 | 21.6193 | 21.6193 | 2800.0 |
| 2012-03-30 04:24:00 | AAPL | Stock | 21.6193 | 21.6193 | 21.6193 | 21.6193 | 7000.0 |
| 2012-03-30 04:42:00 | AAPL | Stock | 21.6196 | 21.6196 | 21.6196 | 21.6196 | 14000.0 |
| 2012-03-30 04:46:00 | AAPL | Stock | 21.655 | 21.655 | 21.655 | 21.655 | 2800.0 |
| 2012-03-30 05:17:00 | AAPL | Stock | 21.6189 | 21.6189 | 21.6189 | 21.6189 | 11788.0 |
| 2012-03-30 05:27:00 | AAPL | Stock | 21.6425 | 21.6425 | 21.6425 | 21.6425 | 2800.0 |
| 2012-03-30 05:28:00 | AAPL | Stock | 21.6425 | 21.655 | 21.6425 | 21.655 | 14000.0 |
| 2012-03-30 05:33:00 | AAPL | Stock | 21.6429 | 21.6429 | 21.6429 | 21.6429 | 2800.0 |
| 2012-03-30 05:56:00 | AAPL | Stock | 21.6782 | 21.6782 | 21.6782 | 21.6782 | 2800.0 |
| 2012-03-30 06:06:00 | AAPL | Stock | 21.6789 | 21.6789 | 21.6789 | 21.6789 | 11200.0 |
| 2012-03-30 06:15:00 | AAPL | Stock | 21.6575 | 21.6575 | 21.6571 | 21.6571 | 11200.0 |
| 2012-03-30 06:16:00 | AAPL | Stock | 21.6571 | 21.6571 | 21.6439 | 21.6439 | 5656.0 |
| 2012-03-30 06:17:00 | AAPL | Stock | 21.6432 | 21.6432 | 21.6432 | 21.6432 | 5600.0 |
| 2012-03-30 06:29:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 5600.0 |
| 2012-03-30 06:32:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 2800.0 |
| 2012-03-30 06:39:00 | AAPL | Stock | 21.6957 | 21.6957 | 21.6957 | 21.6957 | 2800.0 |
| 2012-03-30 06:42:00 | AAPL | Stock | 21.6968 | 21.6968 | 21.6968 | 21.6968 | 5600.0 |
| 2012-03-30 06:43:00 | AAPL | Stock | 21.7136 | 21.7143 | 21.7136 | 21.7143 | 8400.0 |
| 2012-03-30 06:51:00 | AAPL | Stock | 21.7104 | 21.7104 | 21.7104 | 21.7104 | 2800.0 |
| 2012-03-30 06:53:00 | AAPL | Stock | 21.7104 | 21.7104 | 21.7104 | 21.7104 | 5208.0 |
| 2012-03-30 07:00:00 | AAPL | Stock | 21.7068 | 21.7125 | 21.7068 | 21.7125 | 22400.0 |
| 2012-03-30 07:01:00 | AAPL | Stock | 21.7204 | 21.7357 | 21.7143 | 21.7357 | 33600.0 |
| 2012-03-30 07:02:00 | AAPL | Stock | 21.7218 | 21.7304 | 21.7179 | 21.7286 | 46172.0 |
| 2012-03-30 07:03:00 | AAPL | Stock | 21.7443 | 21.7457 | 21.7232 | 21.725 | 33600.0 |
| 2012-03-30 07:04:00 | AAPL | Stock | 21.7186 | 21.7186 | 21.7186 | 21.7186 | 2800.0 |
| 2012-03-30 07:05:00 | AAPL | Stock | 21.725 | 21.7432 | 21.725 | 21.7432 | 15400.0 |
| 2012-03-30 07:06:00 | AAPL | Stock | 21.7443 | 21.7589 | 21.7443 | 21.7589 | 56000.0 |
| 2012-03-30 07:07:00 | AAPL | Stock | 21.7579 | 21.7579 | 21.7393 | 21.75 | 33460.0 |
| 2012-03-30 07:08:00 | AAPL | Stock | 21.75 | 21.75 | 21.75 | 21.75 | 2800.0 |
| 2012-03-30 07:09:00 | AAPL | Stock | 21.75 | 21.7571 | 21.75 | 21.7504 | 56000.0 |
| 2012-03-30 07:10:00 | AAPL | Stock | 21.7568 | 21.7671 | 21.7568 | 21.7671 | 32228.0 |
| 2012-03-30 07:12:00 | AAPL | Stock | 21.7593 | 21.7625 | 21.7464 | 21.75 | 78400.0 |
| 2012-03-30 07:13:00 | AAPL | Stock | 21.7496 | 21.7554 | 21.7407 | 21.75 | 70532.0 |
| 2012-03-30 07:14:00 | AAPL | Stock | 21.7625 | 21.7639 | 21.75 | 21.7639 | 21000.0 |
| 2012-03-30 07:15:00 | AAPL | Stock | 21.7657 | 21.7657 | 21.7571 | 21.7571 | 8400.0 |
| 2012-03-30 07:16:00 | AAPL | Stock | 21.7607 | 21.7643 | 21.7607 | 21.7643 | 8400.0 |
| 2012-03-30 07:17:00 | AAPL | Stock | 21.7696 | 21.7814 | 21.7679 | 21.7814 | 50932.0 |
| 2012-03-30 07:18:00 | AAPL | Stock | 21.7786 | 21.7975 | 21.7732 | 21.7732 | 136360.0 |
| 2012-03-30 07:19:00 | AAPL | Stock | 21.7821 | 21.7839 | 21.7714 | 21.7793 | 83720.0 |
| 2012-03-30 07:20:00 | AAPL | Stock | 21.7786 | 21.7786 | 21.7786 | 21.7786 | 2800.0 |
| 2012-03-30 07:21:00 | AAPL | Stock | 21.7704 | 21.7768 | 21.7704 | 21.7768 | 8400.0 |
| 2012-03-30 07:22:00 | AAPL | Stock | 21.7761 | 21.7761 | 21.7761 | 21.7761 | 2800.0 |
| 2012-03-30 07:23:00 | AAPL | Stock | 21.7804 | 21.7814 | 21.7768 | 21.7771 | 67172.0 |
| 2012-03-30 07:24:00 | AAPL | Stock | 21.7721 | 21.7721 | 21.7496 | 21.7543 | 64148.0 |
| 2012-03-30 07:25:00 | AAPL | Stock | 21.7675 | 21.7714 | 21.7661 | 21.7679 | 54600.0 |
| 2012-03-30 07:26:00 | AAPL | Stock | 21.7607 | 21.7607 | 21.7607 | 21.7607 | 11200.0 |
| 2012-03-30 07:28:00 | AAPL | Stock | 21.7679 | 21.7679 | 21.7679 | 21.7679 | 2800.0 |
| 2012-03-30 07:29:00 | AAPL | Stock | 21.7714 | 21.7768 | 21.7714 | 21.7768 | 28000.0 |
| 2012-03-30 07:30:00 | AAPL | Stock | 21.7732 | 21.7786 | 21.7732 | 21.7786 | 11200.0 |
| 2012-03-30 07:31:00 | AAPL | Stock | 21.7707 | 21.7707 | 21.77 | 21.77 | 36400.0 |
> showing 50 of 964,782 rows — these rows as CSV