PREVIEW / stock_1min / 2012-05-31
file: by_date/stock_1min/2012/2012-05-31.parquet size: 13.4 MB rows: 992,169 symbols: 2,869
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-05-31 04:14:00 | AAPL | Stock | 20.7321 | 20.7321 | 20.7321 | 20.7321 | 2800.0 |
| 2012-05-31 04:29:00 | AAPL | Stock | 20.6786 | 20.6786 | 20.6786 | 20.6786 | 11200.0 |
| 2012-05-31 04:31:00 | AAPL | Stock | 20.6786 | 20.6786 | 20.6786 | 20.6786 | 2800.0 |
| 2012-05-31 04:41:00 | AAPL | Stock | 20.7036 | 20.7036 | 20.7036 | 20.7036 | 5600.0 |
| 2012-05-31 04:42:00 | AAPL | Stock | 20.7036 | 20.7036 | 20.7036 | 20.7036 | 5600.0 |
| 2012-05-31 04:43:00 | AAPL | Stock | 20.7036 | 20.7036 | 20.7036 | 20.7036 | 2800.0 |
| 2012-05-31 05:13:00 | AAPL | Stock | 20.7321 | 20.7321 | 20.7321 | 20.7321 | 2800.0 |
| 2012-05-31 05:14:00 | AAPL | Stock | 20.7429 | 20.7429 | 20.7429 | 20.7429 | 2800.0 |
| 2012-05-31 05:20:00 | AAPL | Stock | 20.725 | 20.725 | 20.725 | 20.725 | 14000.0 |
| 2012-05-31 05:21:00 | AAPL | Stock | 20.725 | 20.7321 | 20.725 | 20.7321 | 19600.0 |
| 2012-05-31 05:25:00 | AAPL | Stock | 20.7143 | 20.7143 | 20.7143 | 20.7143 | 4900.0 |
| 2012-05-31 05:30:00 | AAPL | Stock | 20.7321 | 20.7321 | 20.7321 | 20.7321 | 11200.0 |
| 2012-05-31 05:32:00 | AAPL | Stock | 20.7143 | 20.7143 | 20.7143 | 20.7143 | 8400.0 |
| 2012-05-31 05:33:00 | AAPL | Stock | 20.7143 | 20.7143 | 20.7143 | 20.7143 | 2800.0 |
| 2012-05-31 05:34:00 | AAPL | Stock | 20.75 | 20.75 | 20.75 | 20.75 | 2800.0 |
| 2012-05-31 05:36:00 | AAPL | Stock | 20.7732 | 20.7732 | 20.7732 | 20.7732 | 2800.0 |
| 2012-05-31 05:37:00 | AAPL | Stock | 20.7732 | 20.7732 | 20.7732 | 20.7732 | 5600.0 |
| 2012-05-31 05:38:00 | AAPL | Stock | 20.75 | 20.75 | 20.7411 | 20.7411 | 8400.0 |
| 2012-05-31 05:39:00 | AAPL | Stock | 20.7411 | 20.75 | 20.7411 | 20.7411 | 14000.0 |
| 2012-05-31 05:46:00 | AAPL | Stock | 20.7679 | 20.7679 | 20.7679 | 20.7679 | 5600.0 |
| 2012-05-31 06:19:00 | AAPL | Stock | 20.7679 | 20.7679 | 20.7679 | 20.7679 | 11200.0 |
| 2012-05-31 06:40:00 | AAPL | Stock | 20.7457 | 20.7457 | 20.7457 | 20.7457 | 14000.0 |
| 2012-05-31 06:50:00 | AAPL | Stock | 20.7321 | 20.7321 | 20.7321 | 20.7321 | 2800.0 |
| 2012-05-31 06:59:00 | AAPL | Stock | 20.7268 | 20.7268 | 20.7268 | 20.7268 | 5880.0 |
| 2012-05-31 07:00:00 | AAPL | Stock | 20.7268 | 20.7482 | 20.7268 | 20.7482 | 35840.0 |
| 2012-05-31 07:02:00 | AAPL | Stock | 20.7657 | 20.7657 | 20.7657 | 20.7657 | 14000.0 |
| 2012-05-31 07:03:00 | AAPL | Stock | 20.7657 | 20.7657 | 20.7657 | 20.7657 | 8400.0 |
| 2012-05-31 07:05:00 | AAPL | Stock | 20.75 | 20.75 | 20.75 | 20.75 | 4200.0 |
| 2012-05-31 07:06:00 | AAPL | Stock | 20.7464 | 20.7464 | 20.7464 | 20.7464 | 2800.0 |
| 2012-05-31 07:07:00 | AAPL | Stock | 20.7482 | 20.7496 | 20.7482 | 20.7496 | 5600.0 |
| 2012-05-31 07:08:00 | AAPL | Stock | 20.7493 | 20.75 | 20.7493 | 20.75 | 8400.0 |
| 2012-05-31 07:11:00 | AAPL | Stock | 20.75 | 20.75 | 20.75 | 20.75 | 5040.0 |
| 2012-05-31 07:12:00 | AAPL | Stock | 20.7554 | 20.7554 | 20.7554 | 20.7554 | 14000.0 |
| 2012-05-31 07:13:00 | AAPL | Stock | 20.7571 | 20.7643 | 20.7571 | 20.7643 | 19740.0 |
| 2012-05-31 07:14:00 | AAPL | Stock | 20.7643 | 20.7714 | 20.7643 | 20.7714 | 23464.0 |
| 2012-05-31 07:15:00 | AAPL | Stock | 20.7746 | 20.775 | 20.7679 | 20.7679 | 15820.0 |
| 2012-05-31 07:16:00 | AAPL | Stock | 20.7679 | 20.7679 | 20.7679 | 20.7679 | 3780.0 |
| 2012-05-31 07:17:00 | AAPL | Stock | 20.7571 | 20.7589 | 20.7504 | 20.7504 | 33684.0 |
| 2012-05-31 07:18:00 | AAPL | Stock | 20.7621 | 20.7621 | 20.7514 | 20.7514 | 8400.0 |
| 2012-05-31 07:19:00 | AAPL | Stock | 20.7614 | 20.7614 | 20.7614 | 20.7614 | 2800.0 |
| 2012-05-31 07:20:00 | AAPL | Stock | 20.7607 | 20.7607 | 20.7607 | 20.7607 | 2800.0 |
| 2012-05-31 07:21:00 | AAPL | Stock | 20.76 | 20.76 | 20.75 | 20.75 | 28560.0 |
| 2012-05-31 07:22:00 | AAPL | Stock | 20.75 | 20.7518 | 20.75 | 20.7518 | 5768.0 |
| 2012-05-31 07:23:00 | AAPL | Stock | 20.75 | 20.75 | 20.75 | 20.75 | 2800.0 |
| 2012-05-31 07:24:00 | AAPL | Stock | 20.7425 | 20.7464 | 20.7421 | 20.7464 | 21728.0 |
| 2012-05-31 07:26:00 | AAPL | Stock | 20.7464 | 20.7489 | 20.7464 | 20.7482 | 9072.0 |
| 2012-05-31 07:28:00 | AAPL | Stock | 20.7396 | 20.7396 | 20.7357 | 20.7357 | 5656.0 |
| 2012-05-31 07:30:00 | AAPL | Stock | 20.7364 | 20.7411 | 20.7321 | 20.7321 | 43540.0 |
| 2012-05-31 07:31:00 | AAPL | Stock | 20.7368 | 20.7411 | 20.7368 | 20.7411 | 22316.0 |
| 2012-05-31 07:32:00 | AAPL | Stock | 20.7325 | 20.7325 | 20.7268 | 20.7268 | 58380.0 |
> showing 50 of 992,169 rows — these rows as CSV