PREVIEW / stock_1min / 2011-04-18
file: by_date/stock_1min/2011/2011-04-18.parquet size: 13.2 MB rows: 983,505 symbols: 2,863
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-04-18 04:19:00 | AAPL | Stock | 11.7143 | 11.7143 | 11.7143 | 11.7143 | 2800.0 |
| 2011-04-18 04:25:00 | AAPL | Stock | 11.7082 | 11.7082 | 11.7082 | 11.7082 | 2800.0 |
| 2011-04-18 04:36:00 | AAPL | Stock | 11.6964 | 11.6964 | 11.6964 | 11.6964 | 5600.0 |
| 2011-04-18 06:00:00 | AAPL | Stock | 11.6964 | 11.6964 | 11.6964 | 11.6964 | 5600.0 |
| 2011-04-18 06:35:00 | AAPL | Stock | 11.6625 | 11.6625 | 11.6625 | 11.6625 | 2800.0 |
| 2011-04-18 06:42:00 | AAPL | Stock | 11.6521 | 11.6521 | 11.6521 | 11.6521 | 5600.0 |
| 2011-04-18 07:03:00 | AAPL | Stock | 11.6796 | 11.695 | 11.6796 | 11.695 | 8400.0 |
| 2011-04-18 07:04:00 | AAPL | Stock | 11.6929 | 11.6929 | 11.6929 | 11.6929 | 2800.0 |
| 2011-04-18 07:05:00 | AAPL | Stock | 11.6925 | 11.6925 | 11.6925 | 11.6925 | 2800.0 |
| 2011-04-18 07:07:00 | AAPL | Stock | 11.6925 | 11.6925 | 11.6925 | 11.6925 | 4200.0 |
| 2011-04-18 07:14:00 | AAPL | Stock | 11.6875 | 11.6875 | 11.6875 | 11.6875 | 5600.0 |
| 2011-04-18 07:15:00 | AAPL | Stock | 11.6875 | 11.6875 | 11.6875 | 11.6875 | 10080.0 |
| 2011-04-18 07:16:00 | AAPL | Stock | 11.6964 | 11.6964 | 11.6964 | 11.6964 | 11060.0 |
| 2011-04-18 07:17:00 | AAPL | Stock | 11.71 | 11.71 | 11.71 | 11.71 | 5600.0 |
| 2011-04-18 07:19:00 | AAPL | Stock | 11.7143 | 11.7143 | 11.6964 | 11.6964 | 19600.0 |
| 2011-04-18 07:20:00 | AAPL | Stock | 11.6964 | 11.6964 | 11.6964 | 11.6964 | 2800.0 |
| 2011-04-18 07:23:00 | AAPL | Stock | 11.7143 | 11.7143 | 11.7143 | 11.7143 | 17080.0 |
| 2011-04-18 07:30:00 | AAPL | Stock | 11.7143 | 11.7143 | 11.7143 | 11.7143 | 11704.0 |
| 2011-04-18 07:31:00 | AAPL | Stock | 11.7214 | 11.7286 | 11.7214 | 11.7286 | 72800.0 |
| 2011-04-18 07:32:00 | AAPL | Stock | 11.7286 | 11.7386 | 11.7286 | 11.73 | 25200.0 |
| 2011-04-18 07:33:00 | AAPL | Stock | 11.7196 | 11.7196 | 11.7193 | 11.7196 | 47600.0 |
| 2011-04-18 07:35:00 | AAPL | Stock | 11.7196 | 11.7196 | 11.7196 | 11.7196 | 2800.0 |
| 2011-04-18 07:37:00 | AAPL | Stock | 11.7411 | 11.7421 | 11.7411 | 11.7421 | 19600.0 |
| 2011-04-18 07:42:00 | AAPL | Stock | 11.7354 | 11.7354 | 11.735 | 11.735 | 5600.0 |
| 2011-04-18 07:45:00 | AAPL | Stock | 11.72 | 11.72 | 11.72 | 11.72 | 2800.0 |
| 2011-04-18 07:46:00 | AAPL | Stock | 11.7214 | 11.7214 | 11.7214 | 11.7214 | 2800.0 |
| 2011-04-18 07:52:00 | AAPL | Stock | 11.7268 | 11.7268 | 11.7268 | 11.7268 | 8400.0 |
| 2011-04-18 07:54:00 | AAPL | Stock | 11.73 | 11.73 | 11.73 | 11.73 | 2800.0 |
| 2011-04-18 07:55:00 | AAPL | Stock | 11.7268 | 11.7268 | 11.7268 | 11.7268 | 7000.0 |
| 2011-04-18 08:00:00 | AAPL | Stock | 11.725 | 11.7354 | 11.725 | 11.7354 | 48076.0 |
| 2011-04-18 08:01:00 | AAPL | Stock | 11.7321 | 11.7321 | 11.7179 | 11.7179 | 45164.0 |
| 2011-04-18 08:02:00 | AAPL | Stock | 11.7179 | 11.7257 | 11.7179 | 11.7257 | 12628.0 |
| 2011-04-18 08:03:00 | AAPL | Stock | 11.7257 | 11.7321 | 11.7257 | 11.7321 | 39424.0 |
| 2011-04-18 08:04:00 | AAPL | Stock | 11.7325 | 11.7354 | 11.7321 | 11.7354 | 17920.0 |
| 2011-04-18 08:05:00 | AAPL | Stock | 11.7396 | 11.7496 | 11.7396 | 11.7496 | 62160.0 |
| 2011-04-18 08:06:00 | AAPL | Stock | 11.75 | 11.7579 | 11.75 | 11.75 | 35672.0 |
| 2011-04-18 08:07:00 | AAPL | Stock | 11.7521 | 11.7546 | 11.7496 | 11.7536 | 58744.0 |
| 2011-04-18 08:08:00 | AAPL | Stock | 11.7554 | 11.7554 | 11.7554 | 11.7554 | 3640.0 |
| 2011-04-18 08:09:00 | AAPL | Stock | 11.7496 | 11.7504 | 11.7496 | 11.7496 | 27160.0 |
| 2011-04-18 08:10:00 | AAPL | Stock | 11.7496 | 11.75 | 11.7457 | 11.7457 | 17164.0 |
| 2011-04-18 08:11:00 | AAPL | Stock | 11.7446 | 11.7446 | 11.7411 | 11.7411 | 19712.0 |
| 2011-04-18 08:12:00 | AAPL | Stock | 11.7396 | 11.7396 | 11.735 | 11.7389 | 11928.0 |
| 2011-04-18 08:13:00 | AAPL | Stock | 11.7375 | 11.7429 | 11.735 | 11.7375 | 21840.0 |
| 2011-04-18 08:14:00 | AAPL | Stock | 11.7375 | 11.7429 | 11.7361 | 11.7429 | 19600.0 |
| 2011-04-18 08:15:00 | AAPL | Stock | 11.7425 | 11.7429 | 11.7425 | 11.7429 | 8400.0 |
| 2011-04-18 08:16:00 | AAPL | Stock | 11.7407 | 11.7411 | 11.7407 | 11.7411 | 5600.0 |
| 2011-04-18 08:17:00 | AAPL | Stock | 11.7357 | 11.7357 | 11.7357 | 11.7357 | 2800.0 |
| 2011-04-18 08:18:00 | AAPL | Stock | 11.7332 | 11.7339 | 11.7321 | 11.7321 | 35700.0 |
| 2011-04-18 08:19:00 | AAPL | Stock | 11.7329 | 11.7411 | 11.7329 | 11.7411 | 24640.0 |
| 2011-04-18 08:20:00 | AAPL | Stock | 11.7411 | 11.7471 | 11.7411 | 11.7471 | 5600.0 |
> showing 50 of 983,505 rows — these rows as CSV