PREVIEW / stock_5min / 2014-02-13
file: by_date/stock_5min/2014/2014-02-13.parquet size: 5.5 MB rows: 359,218 symbols: 3,541
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:00:00 | AAPL | Stock | 19.0893 | 19.0893 | 19.0393 | 19.0393 | 22400.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:20:00 | AAPL | Stock | 19.0607 | 19.0607 | 19.0607 | 19.0607 | 2800.0 |
| 2014-02-13 04:45:00 | AAPL | Stock | 19.0193 | 19.0193 | 19.0193 | 19.0193 | 5096.0 |
| 2014-02-13 05:20:00 | AAPL | Stock | 19.0371 | 19.0371 | 19.0371 | 19.0371 | 8400.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:30: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.0554 | 19.0464 | 19.0554 | 5600.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.0821 | 19.0357 | 19.0382 | 72548.0 |
| 2014-02-13 07:15: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.0554 | 19.0625 | 30436.0 |
| 2014-02-13 07:30:00 | AAPL | Stock | 19.0536 | 19.0536 | 19.0464 | 19.0464 | 21000.0 |
| 2014-02-13 07:45:00 | AAPL | Stock | 19.0711 | 19.0711 | 19.0554 | 19.0554 | 12404.0 |
| 2014-02-13 07:50:00 | AAPL | Stock | 19.0468 | 19.0468 | 19.0357 | 19.0357 | 130956.0 |
| 2014-02-13 07:55: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.0246 | 19.0246 | 172452.0 |
| 2014-02-13 08:05:00 | AAPL | Stock | 19.0357 | 19.0396 | 19.0307 | 19.0329 | 28308.0 |
| 2014-02-13 08:10:00 | AAPL | Stock | 19.0243 | 19.0286 | 19.0132 | 19.0132 | 64064.0 |
| 2014-02-13 08:15:00 | AAPL | Stock | 19.0075 | 19.0368 | 19.0011 | 19.0357 | 133616.0 |
| 2014-02-13 08:20:00 | AAPL | Stock | 19.0432 | 19.0464 | 19.0343 | 19.0386 | 25200.0 |
| 2014-02-13 08:25:00 | AAPL | Stock | 19.0357 | 19.0364 | 19.0357 | 19.0357 | 159600.0 |
| 2014-02-13 08:30:00 | AAPL | Stock | 19.0296 | 19.0357 | 19.0089 | 19.0357 | 507976.0 |
| 2014-02-13 08:35:00 | AAPL | Stock | 19.0282 | 19.0364 | 19.0214 | 19.0321 | 44800.0 |
| 2014-02-13 08:40:00 | AAPL | Stock | 19.0318 | 19.0357 | 19.0268 | 19.0357 | 19600.0 |
| 2014-02-13 08:45:00 | AAPL | Stock | 19.0325 | 19.0464 | 19.0318 | 19.0464 | 33264.0 |
| 2014-02-13 08:50:00 | AAPL | Stock | 19.0536 | 19.0679 | 19.0486 | 19.0536 | 145040.0 |
| 2014-02-13 08:55:00 | AAPL | Stock | 19.0532 | 19.0643 | 19.0532 | 19.0636 | 57932.0 |
| 2014-02-13 09:00:00 | AAPL | Stock | 19.0561 | 19.0579 | 19.0554 | 19.0579 | 37688.0 |
| 2014-02-13 09:05:00 | AAPL | Stock | 19.0589 | 19.0607 | 19.0557 | 19.0596 | 60452.0 |
| 2014-02-13 09:10:00 | AAPL | Stock | 19.0596 | 19.0625 | 19.05 | 19.0539 | 53928.0 |
| 2014-02-13 09:15:00 | AAPL | Stock | 19.0521 | 19.0557 | 19.0521 | 19.0554 | 34720.0 |
| 2014-02-13 09:20:00 | AAPL | Stock | 19.0557 | 19.0596 | 19.0554 | 19.0593 | 33600.0 |
| 2014-02-13 09:25:00 | AAPL | Stock | 19.0586 | 19.1071 | 19.0543 | 19.0979 | 265972.0 |
| 2014-02-13 09:30:00 | AAPL | Stock | 19.0879 | 19.1389 | 19.0786 | 19.1039 | 11352852.0 |
| 2014-02-13 09:35:00 | AAPL | Stock | 19.1032 | 19.1507 | 19.1032 | 19.1479 | 6478528.0 |
| 2014-02-13 09:40:00 | AAPL | Stock | 19.1429 | 19.1921 | 19.1357 | 19.1868 | 7644364.0 |
| 2014-02-13 09:45:00 | AAPL | Stock | 19.1846 | 19.2275 | 19.1754 | 19.215 | 6271972.0 |
| 2014-02-13 09:50:00 | AAPL | Stock | 19.2154 | 19.2554 | 19.215 | 19.2425 | 8467788.0 |
| 2014-02-13 09:55:00 | AAPL | Stock | 19.2414 | 19.2457 | 19.2 | 19.2082 | 4454156.0 |
| 2014-02-13 10:00:00 | AAPL | Stock | 19.2082 | 19.2286 | 19.1857 | 19.2236 | 4358116.0 |
| 2014-02-13 10:05:00 | AAPL | Stock | 19.2264 | 19.2454 | 19.2154 | 19.2393 | 2911888.0 |
| 2014-02-13 10:10:00 | AAPL | Stock | 19.2389 | 19.2446 | 19.2204 | 19.2429 | 2252516.0 |
| 2014-02-13 10:15:00 | AAPL | Stock | 19.2443 | 19.3014 | 19.2429 | 19.2956 | 10916164.0 |
| 2014-02-13 10:20:00 | AAPL | Stock | 19.2946 | 19.3014 | 19.2686 | 19.2804 | 5351052.0 |
| 2014-02-13 10:25:00 | AAPL | Stock | 19.2791 | 19.2936 | 19.27 | 19.2893 | 2844296.0 |
| 2014-02-13 10:30:00 | AAPL | Stock | 19.2876 | 19.2996 | 19.2804 | 19.2996 | 1965964.0 |
> showing 50 of 359,218 rows — these rows as CSV