PREVIEW / stock_5min / 2014-02-04
file: by_date/stock_5min/2014/2014-02-04.parquet size: 5.6 MB rows: 367,272 symbols: 3,536
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-04 04:15:00 | AAPL | Stock | 17.9629 | 17.9629 | 17.9629 | 17.9629 | 2800.0 |
| 2014-02-04 04:20:00 | AAPL | Stock | 17.9543 | 17.9543 | 17.9543 | 17.9543 | 2800.0 |
| 2014-02-04 04:25:00 | AAPL | Stock | 17.9464 | 17.9464 | 17.9464 | 17.9464 | 2800.0 |
| 2014-02-04 05:40:00 | AAPL | Stock | 17.9286 | 17.9286 | 17.9286 | 17.9286 | 2800.0 |
| 2014-02-04 06:00:00 | AAPL | Stock | 17.9289 | 17.9289 | 17.9289 | 17.9289 | 11200.0 |
| 2014-02-04 06:05:00 | AAPL | Stock | 17.9454 | 17.9454 | 17.9454 | 17.9454 | 2800.0 |
| 2014-02-04 06:10:00 | AAPL | Stock | 17.9371 | 17.9371 | 17.9371 | 17.9371 | 2800.0 |
| 2014-02-04 06:20:00 | AAPL | Stock | 17.9232 | 17.9232 | 17.9232 | 17.9232 | 5600.0 |
| 2014-02-04 06:25:00 | AAPL | Stock | 17.9375 | 17.9439 | 17.9375 | 17.9375 | 28000.0 |
| 2014-02-04 06:30:00 | AAPL | Stock | 17.9439 | 17.945 | 17.9439 | 17.9439 | 16800.0 |
| 2014-02-04 06:35:00 | AAPL | Stock | 17.9471 | 17.9532 | 17.9471 | 17.9532 | 28000.0 |
| 2014-02-04 06:45:00 | AAPL | Stock | 17.9439 | 17.9439 | 17.9439 | 17.9439 | 25340.0 |
| 2014-02-04 07:00:00 | AAPL | Stock | 17.9714 | 17.9714 | 17.9696 | 17.9696 | 5600.0 |
| 2014-02-04 07:05:00 | AAPL | Stock | 17.965 | 17.965 | 17.9643 | 17.9643 | 11200.0 |
| 2014-02-04 07:10:00 | AAPL | Stock | 17.9746 | 17.9786 | 17.9632 | 17.9786 | 57456.0 |
| 2014-02-04 07:15:00 | AAPL | Stock | 17.9786 | 18.0179 | 17.9786 | 18.0179 | 43036.0 |
| 2014-02-04 07:20:00 | AAPL | Stock | 18.0107 | 18.0125 | 17.9929 | 17.9929 | 14000.0 |
| 2014-02-04 07:25:00 | AAPL | Stock | 18.0 | 18.0193 | 18.0 | 18.0 | 33180.0 |
| 2014-02-04 07:30:00 | AAPL | Stock | 17.9964 | 18.0 | 17.9893 | 17.9893 | 60760.0 |
| 2014-02-04 07:35:00 | AAPL | Stock | 17.9761 | 17.9893 | 17.9761 | 17.9893 | 36512.0 |
| 2014-02-04 07:40:00 | AAPL | Stock | 17.9946 | 18.0 | 17.9946 | 18.0 | 17024.0 |
| 2014-02-04 07:45:00 | AAPL | Stock | 17.9854 | 17.9929 | 17.9854 | 17.9882 | 22260.0 |
| 2014-02-04 07:50:00 | AAPL | Stock | 17.9893 | 17.9929 | 17.9893 | 17.9911 | 12236.0 |
| 2014-02-04 07:55:00 | AAPL | Stock | 17.9914 | 18.0086 | 17.9911 | 18.0032 | 147392.0 |
| 2014-02-04 08:00:00 | AAPL | Stock | 18.0054 | 18.0329 | 17.9379 | 18.0057 | 444024.0 |
| 2014-02-04 08:05:00 | AAPL | Stock | 18.0125 | 18.0179 | 18.0 | 18.0 | 237692.0 |
| 2014-02-04 08:10:00 | AAPL | Stock | 18.0075 | 18.0179 | 18.0 | 18.0071 | 114800.0 |
| 2014-02-04 08:15:00 | AAPL | Stock | 18.0043 | 18.0179 | 18.0039 | 18.0179 | 63756.0 |
| 2014-02-04 08:20:00 | AAPL | Stock | 18.0264 | 18.0279 | 18.0204 | 18.0279 | 64540.0 |
| 2014-02-04 08:25:00 | AAPL | Stock | 18.0279 | 18.0579 | 18.0232 | 18.0571 | 239400.0 |
| 2014-02-04 08:30:00 | AAPL | Stock | 18.0464 | 18.0571 | 18.0304 | 18.0571 | 278768.0 |
| 2014-02-04 08:35:00 | AAPL | Stock | 18.0639 | 18.0639 | 18.0464 | 18.0607 | 126252.0 |
| 2014-02-04 08:40:00 | AAPL | Stock | 18.0586 | 18.0625 | 18.0439 | 18.0625 | 68796.0 |
| 2014-02-04 08:45:00 | AAPL | Stock | 18.0607 | 18.0714 | 18.0536 | 18.0714 | 231588.0 |
| 2014-02-04 08:50:00 | AAPL | Stock | 18.0679 | 18.0946 | 18.0621 | 18.0893 | 340872.0 |
| 2014-02-04 08:55:00 | AAPL | Stock | 18.0893 | 18.1286 | 18.0893 | 18.1189 | 394212.0 |
| 2014-02-04 09:00:00 | AAPL | Stock | 18.1082 | 18.1196 | 18.0886 | 18.0893 | 241500.0 |
| 2014-02-04 09:05:00 | AAPL | Stock | 18.0868 | 18.0896 | 18.0679 | 18.0811 | 116480.0 |
| 2014-02-04 09:10:00 | AAPL | Stock | 18.0786 | 18.0804 | 18.0671 | 18.0671 | 69496.0 |
| 2014-02-04 09:15:00 | AAPL | Stock | 18.0786 | 18.0786 | 18.0643 | 18.0761 | 22400.0 |
| 2014-02-04 09:20:00 | AAPL | Stock | 18.0711 | 18.0721 | 18.0536 | 18.0693 | 214480.0 |
| 2014-02-04 09:25:00 | AAPL | Stock | 18.0711 | 18.0779 | 18.0661 | 18.0679 | 257040.0 |
| 2014-02-04 09:30:00 | AAPL | Stock | 18.0686 | 18.1093 | 18.0314 | 18.0351 | 21309680.0 |
| 2014-02-04 09:35:00 | AAPL | Stock | 18.0357 | 18.0493 | 18.0086 | 18.0404 | 10045140.0 |
| 2014-02-04 09:40:00 | AAPL | Stock | 18.04 | 18.0496 | 17.9557 | 18.005 | 8469104.0 |
| 2014-02-04 09:45:00 | AAPL | Stock | 18.0021 | 18.0518 | 17.9821 | 18.0379 | 6531028.0 |
| 2014-02-04 09:50:00 | AAPL | Stock | 18.0379 | 18.0625 | 18.0086 | 18.0561 | 4412660.0 |
| 2014-02-04 09:55:00 | AAPL | Stock | 18.0568 | 18.1207 | 18.0568 | 18.1089 | 8367324.0 |
| 2014-02-04 10:00:00 | AAPL | Stock | 18.1132 | 18.1311 | 18.075 | 18.0879 | 6666352.0 |
| 2014-02-04 10:05:00 | AAPL | Stock | 18.0818 | 18.1146 | 18.0743 | 18.1004 | 4223744.0 |
> showing 50 of 367,272 rows — these rows as CSV