PREVIEW / stock_5min / 2012-05-21
file: by_date/stock_5min/2012/2012-05-21.parquet size: 4.9 MB rows: 330,038 symbols: 3,524
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-21 04:00:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.0 | 19.0357 | 14000.0 |
| 2012-05-21 04:10:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 4760.0 |
| 2012-05-21 05:05:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 2800.0 |
| 2012-05-21 05:20:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 8400.0 |
| 2012-05-21 05:25:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 2800.0 |
| 2012-05-21 05:55:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 2800.0 |
| 2012-05-21 06:10:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 6216.0 |
| 2012-05-21 06:20:00 | AAPL | Stock | 19.0857 | 19.0857 | 19.0857 | 19.0857 | 11200.0 |
| 2012-05-21 06:30:00 | AAPL | Stock | 19.0571 | 19.0571 | 19.0571 | 19.0571 | 2800.0 |
| 2012-05-21 06:55:00 | AAPL | Stock | 19.0964 | 19.1071 | 19.0964 | 19.1071 | 11200.0 |
| 2012-05-21 07:00:00 | AAPL | Stock | 19.1429 | 19.1429 | 19.1071 | 19.1071 | 72660.0 |
| 2012-05-21 07:05:00 | AAPL | Stock | 19.1107 | 19.1107 | 19.0721 | 19.0893 | 31836.0 |
| 2012-05-21 07:10:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 11200.0 |
| 2012-05-21 07:15:00 | AAPL | Stock | 19.1029 | 19.1029 | 19.0889 | 19.0893 | 19600.0 |
| 2012-05-21 07:20:00 | AAPL | Stock | 19.0893 | 19.0893 | 19.0893 | 19.0893 | 5600.0 |
| 2012-05-21 07:25:00 | AAPL | Stock | 19.0821 | 19.0911 | 19.0804 | 19.0804 | 8400.0 |
| 2012-05-21 07:30:00 | AAPL | Stock | 19.0804 | 19.0893 | 19.0804 | 19.0893 | 5600.0 |
| 2012-05-21 07:35:00 | AAPL | Stock | 19.0843 | 19.0843 | 19.0843 | 19.0843 | 5600.0 |
| 2012-05-21 07:40:00 | AAPL | Stock | 19.0975 | 19.1136 | 19.0975 | 19.0996 | 65324.0 |
| 2012-05-21 07:45:00 | AAPL | Stock | 19.1071 | 19.1107 | 19.1071 | 19.1107 | 33600.0 |
| 2012-05-21 07:50:00 | AAPL | Stock | 19.0989 | 19.0989 | 19.0793 | 19.0793 | 16520.0 |
| 2012-05-21 07:55:00 | AAPL | Stock | 19.0825 | 19.0893 | 19.0732 | 19.0846 | 50400.0 |
| 2012-05-21 08:00:00 | AAPL | Stock | 19.0768 | 19.105 | 19.055 | 19.0643 | 355740.0 |
| 2012-05-21 08:05:00 | AAPL | Stock | 19.0579 | 19.0779 | 19.0536 | 19.0582 | 661080.0 |
| 2012-05-21 08:10:00 | AAPL | Stock | 19.0604 | 19.0654 | 19.0536 | 19.0604 | 114380.0 |
| 2012-05-21 08:15:00 | AAPL | Stock | 19.0614 | 19.0643 | 19.0536 | 19.0629 | 584136.0 |
| 2012-05-21 08:20:00 | AAPL | Stock | 19.055 | 19.0807 | 19.0536 | 19.0714 | 378056.0 |
| 2012-05-21 08:25:00 | AAPL | Stock | 19.0682 | 19.0893 | 19.0593 | 19.0893 | 254604.0 |
| 2012-05-21 08:30:00 | AAPL | Stock | 19.0954 | 19.1071 | 19.0893 | 19.0911 | 329448.0 |
| 2012-05-21 08:35:00 | AAPL | Stock | 19.0911 | 19.0961 | 19.0771 | 19.0857 | 270480.0 |
| 2012-05-21 08:40:00 | AAPL | Stock | 19.0861 | 19.0861 | 19.045 | 19.0514 | 433076.0 |
| 2012-05-21 08:45:00 | AAPL | Stock | 19.0557 | 19.0821 | 19.0557 | 19.0707 | 317072.0 |
| 2012-05-21 08:50:00 | AAPL | Stock | 19.0721 | 19.0839 | 19.0661 | 19.075 | 445004.0 |
| 2012-05-21 08:55:00 | AAPL | Stock | 19.0714 | 19.0721 | 19.05 | 19.0575 | 234836.0 |
| 2012-05-21 09:00:00 | AAPL | Stock | 19.0639 | 19.0639 | 19.0568 | 19.0625 | 156380.0 |
| 2012-05-21 09:05:00 | AAPL | Stock | 19.0575 | 19.0671 | 19.0564 | 19.0593 | 348404.0 |
| 2012-05-21 09:10:00 | AAPL | Stock | 19.0632 | 19.0786 | 19.0625 | 19.0682 | 298816.0 |
| 2012-05-21 09:15:00 | AAPL | Stock | 19.0743 | 19.0743 | 19.0679 | 19.0714 | 77420.0 |
| 2012-05-21 09:20:00 | AAPL | Stock | 19.0661 | 19.0661 | 19.0579 | 19.0643 | 289184.0 |
| 2012-05-21 09:25:00 | AAPL | Stock | 19.0636 | 19.1014 | 19.0611 | 19.0886 | 364336.0 |
| 2012-05-21 09:30:00 | AAPL | Stock | 19.0929 | 19.2357 | 19.0732 | 19.2225 | 16521456.0 |
| 2012-05-21 09:35:00 | AAPL | Stock | 19.2239 | 19.2543 | 19.1239 | 19.2364 | 15476104.0 |
| 2012-05-21 09:40:00 | AAPL | Stock | 19.2368 | 19.2496 | 19.1639 | 19.2129 | 9290092.0 |
| 2012-05-21 09:45:00 | AAPL | Stock | 19.2121 | 19.2132 | 19.1668 | 19.1957 | 7301000.0 |
| 2012-05-21 09:50:00 | AAPL | Stock | 19.2002 | 19.225 | 19.1429 | 19.1479 | 10102848.0 |
| 2012-05-21 09:55:00 | AAPL | Stock | 19.1475 | 19.2 | 19.1429 | 19.19 | 7476476.0 |
| 2012-05-21 10:00:00 | AAPL | Stock | 19.1925 | 19.2229 | 19.1511 | 19.2214 | 6748980.0 |
| 2012-05-21 10:05:00 | AAPL | Stock | 19.2179 | 19.2739 | 19.1793 | 19.27 | 10637956.0 |
| 2012-05-21 10:10:00 | AAPL | Stock | 19.2654 | 19.3464 | 19.2575 | 19.3115 | 14366660.0 |
| 2012-05-21 10:15:00 | AAPL | Stock | 19.3184 | 19.4429 | 19.2918 | 19.4418 | 16274972.0 |
> showing 50 of 330,038 rows — these rows as CSV