PREVIEW / stock_1min / 2014-01-24
file: by_date/stock_1min/2014/2014-01-24.parquet size: 16.1 MB rows: 1,126,697 symbols: 2,862
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 |
|---|---|---|---|---|---|---|---|
| 2014-01-24 04:00:00 | AAPL | Stock | 19.8632 | 19.8632 | 19.8343 | 19.8343 | 5600.0 |
| 2014-01-24 04:19:00 | AAPL | Stock | 19.7679 | 19.7679 | 19.7679 | 19.7679 | 2800.0 |
| 2014-01-24 04:23:00 | AAPL | Stock | 19.7579 | 19.7579 | 19.7514 | 19.7514 | 5600.0 |
| 2014-01-24 04:28:00 | AAPL | Stock | 19.7607 | 19.7607 | 19.7607 | 19.7607 | 8400.0 |
| 2014-01-24 04:32:00 | AAPL | Stock | 19.7718 | 19.7718 | 19.7718 | 19.7718 | 16800.0 |
| 2014-01-24 04:33:00 | AAPL | Stock | 19.8125 | 19.8154 | 19.8125 | 19.8154 | 8400.0 |
| 2014-01-24 04:34:00 | AAPL | Stock | 19.8154 | 19.8439 | 19.8154 | 19.8439 | 25200.0 |
| 2014-01-24 04:35:00 | AAPL | Stock | 19.8439 | 19.85 | 19.8439 | 19.85 | 5600.0 |
| 2014-01-24 04:38:00 | AAPL | Stock | 19.8464 | 19.8464 | 19.8464 | 19.8464 | 16800.0 |
| 2014-01-24 04:41:00 | AAPL | Stock | 19.8368 | 19.8368 | 19.8368 | 19.8368 | 2800.0 |
| 2014-01-24 05:03:00 | AAPL | Stock | 19.8025 | 19.8036 | 19.8025 | 19.8036 | 8400.0 |
| 2014-01-24 05:07:00 | AAPL | Stock | 19.7679 | 19.7679 | 19.7679 | 19.7679 | 5600.0 |
| 2014-01-24 05:11:00 | AAPL | Stock | 19.7607 | 19.7607 | 19.7607 | 19.7607 | 2800.0 |
| 2014-01-24 05:23:00 | AAPL | Stock | 19.7571 | 19.7571 | 19.7543 | 19.7543 | 11200.0 |
| 2014-01-24 05:24:00 | AAPL | Stock | 19.7471 | 19.7486 | 19.7361 | 19.7361 | 19600.0 |
| 2014-01-24 05:26:00 | AAPL | Stock | 19.7275 | 19.7379 | 19.7143 | 19.7375 | 39200.0 |
| 2014-01-24 05:27:00 | AAPL | Stock | 19.7289 | 19.7289 | 19.7289 | 19.7289 | 2800.0 |
| 2014-01-24 05:34:00 | AAPL | Stock | 19.7146 | 19.7146 | 19.7146 | 19.7146 | 2800.0 |
| 2014-01-24 05:41:00 | AAPL | Stock | 19.7289 | 19.7289 | 19.7268 | 19.7268 | 7448.0 |
| 2014-01-24 05:42:00 | AAPL | Stock | 19.7171 | 19.7171 | 19.7171 | 19.7171 | 2800.0 |
| 2014-01-24 05:50:00 | AAPL | Stock | 19.7218 | 19.7218 | 19.7218 | 19.7218 | 2800.0 |
| 2014-01-24 05:54:00 | AAPL | Stock | 19.7271 | 19.7271 | 19.7271 | 19.7271 | 2800.0 |
| 2014-01-24 05:55:00 | AAPL | Stock | 19.7271 | 19.7271 | 19.7271 | 19.7271 | 5600.0 |
| 2014-01-24 05:57:00 | AAPL | Stock | 19.7271 | 19.7271 | 19.7271 | 19.7271 | 15820.0 |
| 2014-01-24 06:01:00 | AAPL | Stock | 19.7143 | 19.7143 | 19.7143 | 19.7143 | 16520.0 |
| 2014-01-24 06:13:00 | AAPL | Stock | 19.7321 | 19.7321 | 19.725 | 19.725 | 5600.0 |
| 2014-01-24 06:14:00 | AAPL | Stock | 19.7321 | 19.7321 | 19.7321 | 19.7321 | 2800.0 |
| 2014-01-24 06:15:00 | AAPL | Stock | 19.7146 | 19.7146 | 19.7146 | 19.7146 | 2800.0 |
| 2014-01-24 06:19:00 | AAPL | Stock | 19.7161 | 19.7161 | 19.7161 | 19.7161 | 2800.0 |
| 2014-01-24 06:22:00 | AAPL | Stock | 19.7082 | 19.7082 | 19.7082 | 19.7082 | 2800.0 |
| 2014-01-24 06:23:00 | AAPL | Stock | 19.6964 | 19.6964 | 19.6964 | 19.6964 | 2800.0 |
| 2014-01-24 06:24:00 | AAPL | Stock | 19.6964 | 19.6964 | 19.6964 | 19.6964 | 5600.0 |
| 2014-01-24 06:26:00 | AAPL | Stock | 19.6964 | 19.6964 | 19.6964 | 19.6964 | 29400.0 |
| 2014-01-24 06:42:00 | AAPL | Stock | 19.6968 | 19.6986 | 19.6968 | 19.6986 | 8400.0 |
| 2014-01-24 06:44:00 | AAPL | Stock | 19.7004 | 19.7004 | 19.7004 | 19.7004 | 2800.0 |
| 2014-01-24 06:50:00 | AAPL | Stock | 19.7211 | 19.7211 | 19.7211 | 19.7211 | 2800.0 |
| 2014-01-24 06:53:00 | AAPL | Stock | 19.7211 | 19.7211 | 19.7211 | 19.7211 | 2800.0 |
| 2014-01-24 06:54:00 | AAPL | Stock | 19.7054 | 19.7054 | 19.7054 | 19.7054 | 2800.0 |
| 2014-01-24 07:01:00 | AAPL | Stock | 19.7307 | 19.7618 | 19.7307 | 19.7618 | 22960.0 |
| 2014-01-24 07:02:00 | AAPL | Stock | 19.7375 | 19.7543 | 19.7375 | 19.7543 | 7000.0 |
| 2014-01-24 07:03:00 | AAPL | Stock | 19.7325 | 19.7414 | 19.7143 | 19.7357 | 80416.0 |
| 2014-01-24 07:04:00 | AAPL | Stock | 19.7461 | 19.7461 | 19.7461 | 19.7461 | 2800.0 |
| 2014-01-24 07:07:00 | AAPL | Stock | 19.7332 | 19.7332 | 19.7311 | 19.7311 | 8400.0 |
| 2014-01-24 07:08:00 | AAPL | Stock | 19.7375 | 19.7411 | 19.7375 | 19.7411 | 11200.0 |
| 2014-01-24 07:09:00 | AAPL | Stock | 19.7429 | 19.7429 | 19.7429 | 19.7429 | 2800.0 |
| 2014-01-24 07:11:00 | AAPL | Stock | 19.7361 | 19.7361 | 19.7361 | 19.7361 | 4200.0 |
| 2014-01-24 07:14:00 | AAPL | Stock | 19.7461 | 19.7461 | 19.7461 | 19.7461 | 2800.0 |
| 2014-01-24 07:17:00 | AAPL | Stock | 19.75 | 19.75 | 19.74 | 19.74 | 7504.0 |
| 2014-01-24 07:18:00 | AAPL | Stock | 19.7343 | 19.7343 | 19.7343 | 19.7343 | 2800.0 |
| 2014-01-24 07:19:00 | AAPL | Stock | 19.7411 | 19.7411 | 19.7411 | 19.7411 | 5600.0 |
> showing 50 of 1,126,697 rows — these rows as CSV