PREVIEW / stock_1min / 2013-01-08
file: by_date/stock_1min/2013/2013-01-08.parquet size: 12.9 MB rows: 961,816 symbols: 2,790
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-08 04:58:00 | AAPL | Stock | 18.6743 | 18.6743 | 18.6743 | 18.6743 | 2800.0 |
| 2013-01-08 05:04:00 | AAPL | Stock | 18.6864 | 18.6864 | 18.6864 | 18.6864 | 2800.0 |
| 2013-01-08 05:36:00 | AAPL | Stock | 18.6911 | 18.6911 | 18.6911 | 18.6911 | 12600.0 |
| 2013-01-08 05:47:00 | AAPL | Stock | 18.7139 | 18.7139 | 18.7139 | 18.7139 | 5600.0 |
| 2013-01-08 05:59:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 27468.0 |
| 2013-01-08 06:10:00 | AAPL | Stock | 18.7325 | 18.7325 | 18.7325 | 18.7325 | 8400.0 |
| 2013-01-08 06:21:00 | AAPL | Stock | 18.7393 | 18.7393 | 18.7393 | 18.7393 | 2800.0 |
| 2013-01-08 06:25:00 | AAPL | Stock | 18.7386 | 18.7386 | 18.7386 | 18.7386 | 2800.0 |
| 2013-01-08 06:28:00 | AAPL | Stock | 18.7393 | 18.7393 | 18.7393 | 18.7393 | 2800.0 |
| 2013-01-08 06:29:00 | AAPL | Stock | 18.7464 | 18.7493 | 18.7464 | 18.7493 | 12600.0 |
| 2013-01-08 06:45:00 | AAPL | Stock | 18.7514 | 18.7514 | 18.7514 | 18.7514 | 2800.0 |
| 2013-01-08 06:51:00 | AAPL | Stock | 18.765 | 18.7857 | 18.765 | 18.7857 | 30800.0 |
| 2013-01-08 06:53:00 | AAPL | Stock | 18.8014 | 18.8214 | 18.8014 | 18.8214 | 12236.0 |
| 2013-01-08 06:55:00 | AAPL | Stock | 18.8161 | 18.8161 | 18.8161 | 18.8161 | 2800.0 |
| 2013-01-08 06:57:00 | AAPL | Stock | 18.7929 | 18.7929 | 18.7929 | 18.7929 | 2800.0 |
| 2013-01-08 07:00:00 | AAPL | Stock | 18.7846 | 18.7846 | 18.7846 | 18.7846 | 14000.0 |
| 2013-01-08 07:01:00 | AAPL | Stock | 18.8107 | 18.8107 | 18.7857 | 18.7882 | 60200.0 |
| 2013-01-08 07:03:00 | AAPL | Stock | 18.8032 | 18.8032 | 18.7946 | 18.7954 | 23548.0 |
| 2013-01-08 07:04:00 | AAPL | Stock | 18.7882 | 18.7886 | 18.7839 | 18.7839 | 58464.0 |
| 2013-01-08 07:06:00 | AAPL | Stock | 18.7775 | 18.7775 | 18.7718 | 18.7718 | 5600.0 |
| 2013-01-08 07:08:00 | AAPL | Stock | 18.7536 | 18.7536 | 18.7321 | 18.7321 | 64064.0 |
| 2013-01-08 07:10:00 | AAPL | Stock | 18.7343 | 18.7343 | 18.7343 | 18.7343 | 8400.0 |
| 2013-01-08 07:13:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 25200.0 |
| 2013-01-08 07:14:00 | AAPL | Stock | 18.7371 | 18.7371 | 18.7371 | 18.7371 | 2800.0 |
| 2013-01-08 07:15:00 | AAPL | Stock | 18.7371 | 18.7371 | 18.7143 | 18.725 | 25200.0 |
| 2013-01-08 07:16:00 | AAPL | Stock | 18.7321 | 18.7357 | 18.7321 | 18.7357 | 22400.0 |
| 2013-01-08 07:19:00 | AAPL | Stock | 18.7418 | 18.7429 | 18.7418 | 18.7429 | 5600.0 |
| 2013-01-08 07:21:00 | AAPL | Stock | 18.7321 | 18.7379 | 18.7321 | 18.7379 | 18900.0 |
| 2013-01-08 07:22:00 | AAPL | Stock | 18.7321 | 18.7496 | 18.7321 | 18.7496 | 6384.0 |
| 2013-01-08 07:23:00 | AAPL | Stock | 18.7493 | 18.7493 | 18.7493 | 18.7493 | 2800.0 |
| 2013-01-08 07:25:00 | AAPL | Stock | 18.7343 | 18.7343 | 18.7343 | 18.7343 | 2800.0 |
| 2013-01-08 07:27:00 | AAPL | Stock | 18.7464 | 18.7704 | 18.7464 | 18.75 | 95200.0 |
| 2013-01-08 07:30:00 | AAPL | Stock | 18.7386 | 18.7489 | 18.7386 | 18.7489 | 14000.0 |
| 2013-01-08 07:33:00 | AAPL | Stock | 18.7411 | 18.7411 | 18.7411 | 18.7411 | 10500.0 |
| 2013-01-08 07:35:00 | AAPL | Stock | 18.7411 | 18.7411 | 18.7411 | 18.7411 | 8400.0 |
| 2013-01-08 07:36:00 | AAPL | Stock | 18.7489 | 18.75 | 18.7489 | 18.7496 | 36400.0 |
| 2013-01-08 07:43:00 | AAPL | Stock | 18.7504 | 18.7504 | 18.7504 | 18.7504 | 7840.0 |
| 2013-01-08 07:44:00 | AAPL | Stock | 18.7504 | 18.7625 | 18.7504 | 18.7625 | 11200.0 |
| 2013-01-08 07:45:00 | AAPL | Stock | 18.7618 | 18.77 | 18.7618 | 18.77 | 19600.0 |
| 2013-01-08 07:46:00 | AAPL | Stock | 18.7679 | 18.7679 | 18.7679 | 18.7679 | 16800.0 |
| 2013-01-08 07:47:00 | AAPL | Stock | 18.7607 | 18.7607 | 18.7539 | 18.7543 | 11200.0 |
| 2013-01-08 07:48:00 | AAPL | Stock | 18.7543 | 18.7554 | 18.7539 | 18.7554 | 51968.0 |
| 2013-01-08 07:49:00 | AAPL | Stock | 18.7589 | 18.7632 | 18.7589 | 18.7632 | 11200.0 |
| 2013-01-08 07:52:00 | AAPL | Stock | 18.7586 | 18.7621 | 18.7586 | 18.7621 | 5600.0 |
| 2013-01-08 07:53:00 | AAPL | Stock | 18.7575 | 18.7575 | 18.7575 | 18.7575 | 3360.0 |
| 2013-01-08 07:55:00 | AAPL | Stock | 18.7589 | 18.7589 | 18.7589 | 18.7589 | 2800.0 |
| 2013-01-08 07:56:00 | AAPL | Stock | 18.7543 | 18.7543 | 18.7543 | 18.7543 | 2800.0 |
| 2013-01-08 08:00:00 | AAPL | Stock | 18.7539 | 18.8025 | 18.725 | 18.7543 | 66500.0 |
| 2013-01-08 08:01:00 | AAPL | Stock | 18.7543 | 18.7582 | 18.7543 | 18.7582 | 7280.0 |
| 2013-01-08 08:02:00 | AAPL | Stock | 18.7589 | 18.7589 | 18.7589 | 18.7589 | 5600.0 |
> showing 50 of 961,816 rows — these rows as CSV