PREVIEW / stock_1min / 2011-07-13
file: by_date/stock_1min/2011/2011-07-13.parquet size: 13.1 MB rows: 982,835 symbols: 2,856
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-13 04:05:00 | AAPL | Stock | 12.7129 | 12.7129 | 12.7129 | 12.7129 | 2800.0 |
| 2011-07-13 04:08:00 | AAPL | Stock | 12.7132 | 12.7132 | 12.7132 | 12.7132 | 2800.0 |
| 2011-07-13 04:09:00 | AAPL | Stock | 12.7125 | 12.7125 | 12.6964 | 12.6964 | 8400.0 |
| 2011-07-13 04:37:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6964 | 12.6964 | 2800.0 |
| 2011-07-13 04:40:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6964 | 12.6964 | 5600.0 |
| 2011-07-13 04:41:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6964 | 12.6964 | 5600.0 |
| 2011-07-13 04:54:00 | AAPL | Stock | 12.7018 | 12.7018 | 12.7018 | 12.7018 | 2800.0 |
| 2011-07-13 05:04:00 | AAPL | Stock | 12.7018 | 12.7018 | 12.7018 | 12.7018 | 2800.0 |
| 2011-07-13 05:39:00 | AAPL | Stock | 12.7125 | 12.7125 | 12.7125 | 12.7125 | 8400.0 |
| 2011-07-13 05:40:00 | AAPL | Stock | 12.7121 | 12.7129 | 12.7121 | 12.7129 | 5600.0 |
| 2011-07-13 05:46:00 | AAPL | Stock | 12.7225 | 12.7225 | 12.7225 | 12.7225 | 2800.0 |
| 2011-07-13 05:48:00 | AAPL | Stock | 12.7318 | 12.7318 | 12.7318 | 12.7318 | 5600.0 |
| 2011-07-13 05:49:00 | AAPL | Stock | 12.7332 | 12.7332 | 12.7321 | 12.7321 | 21000.0 |
| 2011-07-13 05:52:00 | AAPL | Stock | 12.7475 | 12.7475 | 12.7475 | 12.7475 | 2800.0 |
| 2011-07-13 06:10:00 | AAPL | Stock | 12.7179 | 12.7179 | 12.7179 | 12.7179 | 11760.0 |
| 2011-07-13 06:12:00 | AAPL | Stock | 12.7336 | 12.7336 | 12.7336 | 12.7336 | 2800.0 |
| 2011-07-13 06:22:00 | AAPL | Stock | 12.7293 | 12.7293 | 12.7293 | 12.7293 | 2800.0 |
| 2011-07-13 06:37:00 | AAPL | Stock | 12.7257 | 12.7257 | 12.7257 | 12.7257 | 2800.0 |
| 2011-07-13 06:39:00 | AAPL | Stock | 12.7429 | 12.7429 | 12.7429 | 12.7429 | 2800.0 |
| 2011-07-13 06:51:00 | AAPL | Stock | 12.7343 | 12.7357 | 12.7343 | 12.7357 | 5600.0 |
| 2011-07-13 06:55:00 | AAPL | Stock | 12.7214 | 12.7232 | 12.7214 | 12.7232 | 11200.0 |
| 2011-07-13 06:56:00 | AAPL | Stock | 12.725 | 12.725 | 12.725 | 12.725 | 5600.0 |
| 2011-07-13 07:02:00 | AAPL | Stock | 12.7254 | 12.7254 | 12.725 | 12.725 | 29680.0 |
| 2011-07-13 07:03:00 | AAPL | Stock | 12.725 | 12.7321 | 12.725 | 12.7321 | 14000.0 |
| 2011-07-13 07:07:00 | AAPL | Stock | 12.7307 | 12.7321 | 12.7307 | 12.7314 | 24780.0 |
| 2011-07-13 07:08:00 | AAPL | Stock | 12.7321 | 12.7321 | 12.7307 | 12.7307 | 11200.0 |
| 2011-07-13 07:09:00 | AAPL | Stock | 12.7379 | 12.7379 | 12.7379 | 12.7379 | 2800.0 |
| 2011-07-13 07:10:00 | AAPL | Stock | 12.7289 | 12.7289 | 12.7289 | 12.7289 | 5600.0 |
| 2011-07-13 07:12:00 | AAPL | Stock | 12.7268 | 12.7268 | 12.7268 | 12.7268 | 2800.0 |
| 2011-07-13 07:14:00 | AAPL | Stock | 12.7379 | 12.7379 | 12.7379 | 12.7379 | 2800.0 |
| 2011-07-13 07:15:00 | AAPL | Stock | 12.7379 | 12.7379 | 12.7371 | 12.7379 | 25340.0 |
| 2011-07-13 07:16:00 | AAPL | Stock | 12.7411 | 12.7643 | 12.7411 | 12.7643 | 30800.0 |
| 2011-07-13 07:17:00 | AAPL | Stock | 12.7504 | 12.7571 | 12.7504 | 12.7571 | 19600.0 |
| 2011-07-13 07:18:00 | AAPL | Stock | 12.755 | 12.7607 | 12.755 | 12.7607 | 8400.0 |
| 2011-07-13 07:22:00 | AAPL | Stock | 12.7621 | 12.7625 | 12.7621 | 12.7625 | 5600.0 |
| 2011-07-13 07:23:00 | AAPL | Stock | 12.7625 | 12.7625 | 12.7571 | 12.7571 | 9884.0 |
| 2011-07-13 07:24:00 | AAPL | Stock | 12.7607 | 12.7679 | 12.7607 | 12.7679 | 42000.0 |
| 2011-07-13 07:25:00 | AAPL | Stock | 12.7686 | 12.7686 | 12.7643 | 12.7643 | 16800.0 |
| 2011-07-13 07:28:00 | AAPL | Stock | 12.7646 | 12.7646 | 12.7646 | 12.7646 | 5600.0 |
| 2011-07-13 07:30:00 | AAPL | Stock | 12.7707 | 12.7707 | 12.7707 | 12.7707 | 16604.0 |
| 2011-07-13 07:31:00 | AAPL | Stock | 12.7707 | 12.7707 | 12.7707 | 12.7707 | 5600.0 |
| 2011-07-13 07:32:00 | AAPL | Stock | 12.7679 | 12.7679 | 12.7679 | 12.7679 | 2940.0 |
| 2011-07-13 07:33:00 | AAPL | Stock | 12.7679 | 12.7679 | 12.7679 | 12.7679 | 2800.0 |
| 2011-07-13 07:35:00 | AAPL | Stock | 12.7696 | 12.7696 | 12.7696 | 12.7696 | 2800.0 |
| 2011-07-13 07:37:00 | AAPL | Stock | 12.7675 | 12.7675 | 12.7675 | 12.7675 | 11200.0 |
| 2011-07-13 07:40:00 | AAPL | Stock | 12.7679 | 12.77 | 12.7679 | 12.77 | 12600.0 |
| 2011-07-13 07:42:00 | AAPL | Stock | 12.7654 | 12.7654 | 12.7654 | 12.7654 | 5600.0 |
| 2011-07-13 07:43:00 | AAPL | Stock | 12.77 | 12.77 | 12.7664 | 12.7664 | 36400.0 |
| 2011-07-13 07:44:00 | AAPL | Stock | 12.7675 | 12.7675 | 12.7675 | 12.7675 | 2800.0 |
| 2011-07-13 07:45:00 | AAPL | Stock | 12.7711 | 12.7754 | 12.7711 | 12.7754 | 28000.0 |
> showing 50 of 982,835 rows — these rows as CSV