PREVIEW / stock_1min / 2014-02-13
file: by_date/stock_1min/2014/2014-02-13.parquet size: 14.7 MB rows: 1,059,586 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-02-13 04:03:00 | AAPL | Stock | 19.0893 | 19.0893 | 19.0714 | 19.0714 | 14000.0 |
| 2014-02-13 04:04:00 | AAPL | Stock | 19.0411 | 19.0411 | 19.0393 | 19.0393 | 8400.0 |
| 2014-02-13 04:05:00 | AAPL | Stock | 19.0379 | 19.0379 | 19.0229 | 19.0229 | 14000.0 |
| 2014-02-13 04:15:00 | AAPL | Stock | 18.9546 | 18.9546 | 18.9546 | 18.9546 | 2800.0 |
| 2014-02-13 04:24:00 | AAPL | Stock | 19.0607 | 19.0607 | 19.0607 | 19.0607 | 2800.0 |
| 2014-02-13 04:46:00 | AAPL | Stock | 19.0193 | 19.0193 | 19.0193 | 19.0193 | 5096.0 |
| 2014-02-13 05:22:00 | AAPL | Stock | 19.0371 | 19.0371 | 19.0371 | 19.0371 | 5600.0 |
| 2014-02-13 05:23:00 | AAPL | Stock | 19.0371 | 19.0371 | 19.0371 | 19.0371 | 2800.0 |
| 2014-02-13 05:30:00 | AAPL | Stock | 19.0371 | 19.0371 | 19.0371 | 19.0371 | 2800.0 |
| 2014-02-13 06:15:00 | AAPL | Stock | 19.0357 | 19.0371 | 19.0357 | 19.0371 | 12936.0 |
| 2014-02-13 06:31:00 | AAPL | Stock | 19.0375 | 19.0375 | 19.0371 | 19.0371 | 7336.0 |
| 2014-02-13 06:45:00 | AAPL | Stock | 19.0375 | 19.0375 | 19.0371 | 19.0371 | 7000.0 |
| 2014-02-13 07:00:00 | AAPL | Stock | 19.0464 | 19.0464 | 19.0464 | 19.0464 | 2800.0 |
| 2014-02-13 07:02:00 | AAPL | Stock | 19.0554 | 19.0554 | 19.0554 | 19.0554 | 2800.0 |
| 2014-02-13 07:05:00 | AAPL | Stock | 19.0607 | 19.0607 | 19.0607 | 19.0607 | 2800.0 |
| 2014-02-13 07:10:00 | AAPL | Stock | 19.0796 | 19.0796 | 19.0796 | 19.0796 | 2800.0 |
| 2014-02-13 07:11:00 | AAPL | Stock | 19.0821 | 19.0821 | 19.0536 | 19.0536 | 18704.0 |
| 2014-02-13 07:12:00 | AAPL | Stock | 19.0536 | 19.0536 | 19.0357 | 19.0357 | 41244.0 |
| 2014-02-13 07:13:00 | AAPL | Stock | 19.0357 | 19.0382 | 19.0357 | 19.0382 | 9800.0 |
| 2014-02-13 07:16:00 | AAPL | Stock | 19.0693 | 19.075 | 19.0675 | 19.0714 | 25200.0 |
| 2014-02-13 07:20:00 | AAPL | Stock | 19.0889 | 19.0889 | 19.0889 | 19.0889 | 2800.0 |
| 2014-02-13 07:21:00 | AAPL | Stock | 19.0582 | 19.0582 | 19.0554 | 19.0554 | 24836.0 |
| 2014-02-13 07:23:00 | AAPL | Stock | 19.0625 | 19.0625 | 19.0625 | 19.0625 | 2800.0 |
| 2014-02-13 07:32:00 | AAPL | Stock | 19.0536 | 19.0536 | 19.0536 | 19.0536 | 5600.0 |
| 2014-02-13 07:34:00 | AAPL | Stock | 19.0475 | 19.0475 | 19.0464 | 19.0464 | 15400.0 |
| 2014-02-13 07:46:00 | AAPL | Stock | 19.0711 | 19.0711 | 19.0711 | 19.0711 | 2800.0 |
| 2014-02-13 07:49:00 | AAPL | Stock | 19.0575 | 19.0575 | 19.0554 | 19.0554 | 9604.0 |
| 2014-02-13 07:50:00 | AAPL | Stock | 19.0468 | 19.0468 | 19.0375 | 19.0375 | 124796.0 |
| 2014-02-13 07:54:00 | AAPL | Stock | 19.0364 | 19.0364 | 19.0357 | 19.0357 | 6160.0 |
| 2014-02-13 07:59:00 | AAPL | Stock | 19.0446 | 19.0446 | 19.0446 | 19.0446 | 16800.0 |
| 2014-02-13 08:00:00 | AAPL | Stock | 19.0446 | 19.0625 | 19.0357 | 19.0357 | 128632.0 |
| 2014-02-13 08:01:00 | AAPL | Stock | 19.0321 | 19.0321 | 19.025 | 19.025 | 18620.0 |
| 2014-02-13 08:03:00 | AAPL | Stock | 19.025 | 19.0257 | 19.025 | 19.025 | 14000.0 |
| 2014-02-13 08:04:00 | AAPL | Stock | 19.0254 | 19.0254 | 19.0246 | 19.0246 | 11200.0 |
| 2014-02-13 08:05:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 2800.0 |
| 2014-02-13 08:07:00 | AAPL | Stock | 19.0307 | 19.0307 | 19.0307 | 19.0307 | 2800.0 |
| 2014-02-13 08:08:00 | AAPL | Stock | 19.0346 | 19.0396 | 19.0329 | 19.0329 | 22708.0 |
| 2014-02-13 08:10:00 | AAPL | Stock | 19.0243 | 19.0286 | 19.0236 | 19.0236 | 19600.0 |
| 2014-02-13 08:11:00 | AAPL | Stock | 19.0236 | 19.0236 | 19.0236 | 19.0236 | 8400.0 |
| 2014-02-13 08:12:00 | AAPL | Stock | 19.0239 | 19.0239 | 19.0179 | 19.0179 | 33264.0 |
| 2014-02-13 08:14:00 | AAPL | Stock | 19.0132 | 19.0132 | 19.0132 | 19.0132 | 2800.0 |
| 2014-02-13 08:15:00 | AAPL | Stock | 19.0075 | 19.0179 | 19.0011 | 19.0171 | 50932.0 |
| 2014-02-13 08:16:00 | AAPL | Stock | 19.0139 | 19.0236 | 19.0139 | 19.0179 | 29176.0 |
| 2014-02-13 08:17:00 | AAPL | Stock | 19.025 | 19.0261 | 19.025 | 19.0261 | 5908.0 |
| 2014-02-13 08:18:00 | AAPL | Stock | 19.0343 | 19.0368 | 19.0343 | 19.0368 | 25200.0 |
| 2014-02-13 08:19:00 | AAPL | Stock | 19.0232 | 19.0368 | 19.0232 | 19.0357 | 22400.0 |
| 2014-02-13 08:20:00 | AAPL | Stock | 19.0432 | 19.0439 | 19.0343 | 19.0343 | 16800.0 |
| 2014-02-13 08:22:00 | AAPL | Stock | 19.0354 | 19.0354 | 19.0354 | 19.0354 | 2800.0 |
| 2014-02-13 08:23:00 | AAPL | Stock | 19.0464 | 19.0464 | 19.0464 | 19.0464 | 2800.0 |
| 2014-02-13 08:24:00 | AAPL | Stock | 19.0386 | 19.0386 | 19.0386 | 19.0386 | 2800.0 |
> showing 50 of 1,059,586 rows — these rows as CSV