PREVIEW / stock_5min / 2014-06-04
file: by_date/stock_5min/2014/2014-06-04.parquet size: 5.4 MB rows: 362,525 symbols: 3,533
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-06-04 04:10:00 | AAPL | Stock | 22.8143 | 22.8143 | 22.8143 | 22.8143 | 2800.0 |
| 2014-06-04 04:45:00 | AAPL | Stock | 22.8289 | 22.8289 | 22.8161 | 22.8221 | 16800.0 |
| 2014-06-04 04:50:00 | AAPL | Stock | 22.8243 | 22.8246 | 22.8236 | 22.8236 | 20104.0 |
| 2014-06-04 05:00:00 | AAPL | Stock | 22.8036 | 22.8036 | 22.7964 | 22.7964 | 5600.0 |
| 2014-06-04 05:05:00 | AAPL | Stock | 22.7861 | 22.7861 | 22.7861 | 22.7861 | 2800.0 |
| 2014-06-04 05:15:00 | AAPL | Stock | 22.7721 | 22.7721 | 22.7721 | 22.7721 | 2800.0 |
| 2014-06-04 05:25:00 | AAPL | Stock | 22.78 | 22.7854 | 22.7714 | 22.7854 | 11200.0 |
| 2014-06-04 05:30:00 | AAPL | Stock | 22.7625 | 22.7643 | 22.7625 | 22.7643 | 5600.0 |
| 2014-06-04 06:05:00 | AAPL | Stock | 22.7643 | 22.7643 | 22.7643 | 22.7643 | 8008.0 |
| 2014-06-04 06:10:00 | AAPL | Stock | 22.7732 | 22.7732 | 22.7732 | 22.7732 | 2800.0 |
| 2014-06-04 06:30:00 | AAPL | Stock | 22.7854 | 22.7857 | 22.7854 | 22.7857 | 6440.0 |
| 2014-06-04 06:40:00 | AAPL | Stock | 22.7768 | 22.7768 | 22.7768 | 22.7768 | 2800.0 |
| 2014-06-04 06:45:00 | AAPL | Stock | 22.7739 | 22.7739 | 22.7739 | 22.7739 | 5600.0 |
| 2014-06-04 07:00:00 | AAPL | Stock | 22.8036 | 22.8075 | 22.7861 | 22.795 | 25200.0 |
| 2014-06-04 07:05:00 | AAPL | Stock | 22.7911 | 22.7911 | 22.7857 | 22.7857 | 17920.0 |
| 2014-06-04 07:10:00 | AAPL | Stock | 22.8068 | 22.8068 | 22.8068 | 22.8068 | 2800.0 |
| 2014-06-04 07:15:00 | AAPL | Stock | 22.8125 | 22.8196 | 22.7982 | 22.7982 | 58800.0 |
| 2014-06-04 07:20:00 | AAPL | Stock | 22.7979 | 22.7979 | 22.7757 | 22.7854 | 53676.0 |
| 2014-06-04 07:25:00 | AAPL | Stock | 22.7846 | 22.7857 | 22.7846 | 22.7857 | 16800.0 |
| 2014-06-04 07:30:00 | AAPL | Stock | 22.7857 | 22.7921 | 22.7857 | 22.7921 | 8400.0 |
| 2014-06-04 07:35:00 | AAPL | Stock | 22.7875 | 22.7875 | 22.7846 | 22.7846 | 5600.0 |
| 2014-06-04 07:45:00 | AAPL | Stock | 22.7832 | 22.7832 | 22.7696 | 22.7779 | 14000.0 |
| 2014-06-04 07:50:00 | AAPL | Stock | 22.775 | 22.775 | 22.7682 | 22.77 | 16800.0 |
| 2014-06-04 07:55:00 | AAPL | Stock | 22.7546 | 22.7546 | 22.7418 | 22.7536 | 53368.0 |
| 2014-06-04 08:00:00 | AAPL | Stock | 22.7657 | 22.8196 | 22.7536 | 22.7679 | 256676.0 |
| 2014-06-04 08:05:00 | AAPL | Stock | 22.7679 | 22.7786 | 22.7643 | 22.7643 | 23184.0 |
| 2014-06-04 08:15:00 | AAPL | Stock | 22.7643 | 22.7721 | 22.7564 | 22.7564 | 187460.0 |
| 2014-06-04 08:20:00 | AAPL | Stock | 22.7543 | 22.7543 | 22.7536 | 22.7536 | 25368.0 |
| 2014-06-04 08:25:00 | AAPL | Stock | 22.7536 | 22.7536 | 22.7536 | 22.7536 | 5600.0 |
| 2014-06-04 08:30:00 | AAPL | Stock | 22.7607 | 22.7607 | 22.7379 | 22.7379 | 140056.0 |
| 2014-06-04 08:35:00 | AAPL | Stock | 22.7311 | 22.7382 | 22.7146 | 22.725 | 91588.0 |
| 2014-06-04 08:40:00 | AAPL | Stock | 22.7311 | 22.7386 | 22.7311 | 22.7339 | 51800.0 |
| 2014-06-04 08:45:00 | AAPL | Stock | 22.7261 | 22.7279 | 22.7168 | 22.7168 | 64400.0 |
| 2014-06-04 08:50:00 | AAPL | Stock | 22.7268 | 22.7268 | 22.7196 | 22.7207 | 37016.0 |
| 2014-06-04 08:55:00 | AAPL | Stock | 22.73 | 22.7318 | 22.7257 | 22.7304 | 75600.0 |
| 2014-06-04 09:00:00 | AAPL | Stock | 22.7311 | 22.7318 | 22.7311 | 22.7318 | 43680.0 |
| 2014-06-04 09:05:00 | AAPL | Stock | 22.7379 | 22.7379 | 22.7343 | 22.7343 | 14000.0 |
| 2014-06-04 09:10:00 | AAPL | Stock | 22.7429 | 22.7429 | 22.7407 | 22.7407 | 11200.0 |
| 2014-06-04 09:15:00 | AAPL | Stock | 22.74 | 22.7604 | 22.7375 | 22.7536 | 81116.0 |
| 2014-06-04 09:20:00 | AAPL | Stock | 22.7536 | 22.7546 | 22.75 | 22.7536 | 66248.0 |
| 2014-06-04 09:25:00 | AAPL | Stock | 22.7536 | 22.7661 | 22.7468 | 22.7468 | 142800.0 |
| 2014-06-04 09:30:00 | AAPL | Stock | 22.7657 | 22.8429 | 22.7525 | 22.8232 | 12325068.0 |
| 2014-06-04 09:35:00 | AAPL | Stock | 22.8246 | 22.8257 | 22.7182 | 22.7804 | 8729980.0 |
| 2014-06-04 09:40:00 | AAPL | Stock | 22.775 | 22.8014 | 22.7393 | 22.7886 | 5580960.0 |
| 2014-06-04 09:45:00 | AAPL | Stock | 22.7821 | 22.8464 | 22.7718 | 22.8418 | 5779368.0 |
| 2014-06-04 09:50:00 | AAPL | Stock | 22.8454 | 22.9354 | 22.8404 | 22.9064 | 11486748.0 |
| 2014-06-04 09:55:00 | AAPL | Stock | 22.9104 | 22.9189 | 22.8875 | 22.9143 | 4437972.0 |
| 2014-06-04 10:00:00 | AAPL | Stock | 22.9164 | 22.9182 | 22.8689 | 22.8889 | 5142816.0 |
| 2014-06-04 10:05:00 | AAPL | Stock | 22.8882 | 22.8914 | 22.8661 | 22.8882 | 2382184.0 |
| 2014-06-04 10:10:00 | AAPL | Stock | 22.8829 | 22.9196 | 22.8754 | 22.9018 | 3736796.0 |
> showing 50 of 362,525 rows — these rows as CSV