PREVIEW / stock_5min / 2014-01-16
file: by_date/stock_5min/2014/2014-01-16.parquet size: 5.4 MB rows: 355,140 symbols: 3,518
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-01-16 05:05:00 | AAPL | Stock | 19.9339 | 19.9339 | 19.9339 | 19.9339 | 5600.0 |
| 2014-01-16 05:15:00 | AAPL | Stock | 19.9368 | 19.9368 | 19.9368 | 19.9368 | 5600.0 |
| 2014-01-16 05:20:00 | AAPL | Stock | 19.9368 | 19.9368 | 19.9368 | 19.9368 | 2800.0 |
| 2014-01-16 06:35:00 | AAPL | Stock | 19.9336 | 19.9336 | 19.9336 | 19.9336 | 2800.0 |
| 2014-01-16 06:45:00 | AAPL | Stock | 19.9179 | 19.9179 | 19.9179 | 19.9179 | 5320.0 |
| 2014-01-16 07:05:00 | AAPL | Stock | 19.9179 | 19.9286 | 19.9179 | 19.9286 | 8400.0 |
| 2014-01-16 07:10:00 | AAPL | Stock | 19.9286 | 19.9379 | 19.9286 | 19.9379 | 10500.0 |
| 2014-01-16 07:25:00 | AAPL | Stock | 19.9214 | 19.9268 | 19.8929 | 19.9 | 44520.0 |
| 2014-01-16 07:30:00 | AAPL | Stock | 19.8929 | 19.9286 | 19.8929 | 19.9286 | 89600.0 |
| 2014-01-16 07:40:00 | AAPL | Stock | 19.895 | 19.895 | 19.8839 | 19.8839 | 41300.0 |
| 2014-01-16 07:45:00 | AAPL | Stock | 19.8664 | 19.8664 | 19.8496 | 19.8664 | 41972.0 |
| 2014-01-16 07:50:00 | AAPL | Stock | 19.8579 | 19.8596 | 19.8571 | 19.8571 | 24276.0 |
| 2014-01-16 07:55:00 | AAPL | Stock | 19.8529 | 19.8629 | 19.8521 | 19.8629 | 60620.0 |
| 2014-01-16 08:00:00 | AAPL | Stock | 19.8786 | 19.9379 | 19.8054 | 19.8054 | 581868.0 |
| 2014-01-16 08:05:00 | AAPL | Stock | 19.8057 | 19.8354 | 19.8054 | 19.8354 | 48440.0 |
| 2014-01-16 08:10:00 | AAPL | Stock | 19.8264 | 19.8354 | 19.8243 | 19.8354 | 28728.0 |
| 2014-01-16 08:15:00 | AAPL | Stock | 19.8243 | 19.825 | 19.7932 | 19.8036 | 102088.0 |
| 2014-01-16 08:20:00 | AAPL | Stock | 19.8036 | 19.8214 | 19.8036 | 19.8143 | 97692.0 |
| 2014-01-16 08:25:00 | AAPL | Stock | 19.8182 | 19.8279 | 19.8182 | 19.8193 | 134680.0 |
| 2014-01-16 08:30:00 | AAPL | Stock | 19.8214 | 19.8214 | 19.8118 | 19.8214 | 86240.0 |
| 2014-01-16 08:35:00 | AAPL | Stock | 19.8211 | 19.8214 | 19.8111 | 19.8214 | 30800.0 |
| 2014-01-16 08:40:00 | AAPL | Stock | 19.82 | 19.8214 | 19.82 | 19.8204 | 32200.0 |
| 2014-01-16 08:45:00 | AAPL | Stock | 19.8214 | 19.8214 | 19.8125 | 19.8214 | 102144.0 |
| 2014-01-16 08:50:00 | AAPL | Stock | 19.8214 | 19.8214 | 19.8125 | 19.8182 | 122808.0 |
| 2014-01-16 08:55:00 | AAPL | Stock | 19.8196 | 19.8196 | 19.8179 | 19.8179 | 24080.0 |
| 2014-01-16 09:00:00 | AAPL | Stock | 19.8143 | 19.8179 | 19.8107 | 19.8143 | 87640.0 |
| 2014-01-16 09:05:00 | AAPL | Stock | 19.8175 | 19.8179 | 19.8143 | 19.8164 | 44660.0 |
| 2014-01-16 09:10:00 | AAPL | Stock | 19.8196 | 19.835 | 19.8179 | 19.8218 | 120176.0 |
| 2014-01-16 09:15:00 | AAPL | Stock | 19.8239 | 19.8239 | 19.8089 | 19.8089 | 73192.0 |
| 2014-01-16 09:20:00 | AAPL | Stock | 19.8121 | 19.8142 | 19.8089 | 19.8089 | 14700.0 |
| 2014-01-16 09:25:00 | AAPL | Stock | 19.8139 | 19.8264 | 19.8139 | 19.8207 | 132916.0 |
| 2014-01-16 09:30:00 | AAPL | Stock | 19.8211 | 19.8875 | 19.8161 | 19.84 | 11548600.0 |
| 2014-01-16 09:35:00 | AAPL | Stock | 19.845 | 19.8857 | 19.7771 | 19.815 | 8901088.0 |
| 2014-01-16 09:40:00 | AAPL | Stock | 19.8148 | 19.8149 | 19.7454 | 19.7726 | 7526316.0 |
| 2014-01-16 09:45:00 | AAPL | Stock | 19.7721 | 19.7761 | 19.7218 | 19.7457 | 7886956.0 |
| 2014-01-16 09:50:00 | AAPL | Stock | 19.7471 | 19.7704 | 19.7029 | 19.7689 | 6192620.0 |
| 2014-01-16 09:55:00 | AAPL | Stock | 19.7704 | 19.8107 | 19.7689 | 19.7869 | 5348672.0 |
| 2014-01-16 10:00:00 | AAPL | Stock | 19.7886 | 19.7968 | 19.7432 | 19.7775 | 4280836.0 |
| 2014-01-16 10:05:00 | AAPL | Stock | 19.7761 | 19.8004 | 19.7643 | 19.7782 | 3459624.0 |
| 2014-01-16 10:10:00 | AAPL | Stock | 19.7757 | 19.8057 | 19.7721 | 19.8007 | 3293472.0 |
| 2014-01-16 10:15:00 | AAPL | Stock | 19.8043 | 19.8068 | 19.7696 | 19.7921 | 1989708.0 |
| 2014-01-16 10:20:00 | AAPL | Stock | 19.7932 | 19.8393 | 19.7868 | 19.8371 | 4061456.0 |
| 2014-01-16 10:25:00 | AAPL | Stock | 19.8304 | 19.85 | 19.8036 | 19.8414 | 3652824.0 |
| 2014-01-16 10:30:00 | AAPL | Stock | 19.845 | 19.8486 | 19.8229 | 19.8396 | 2250220.0 |
| 2014-01-16 10:35:00 | AAPL | Stock | 19.8396 | 19.8418 | 19.8304 | 19.8354 | 1557612.0 |
| 2014-01-16 10:40:00 | AAPL | Stock | 19.8371 | 19.8414 | 19.8054 | 19.81 | 2667308.0 |
| 2014-01-16 10:45:00 | AAPL | Stock | 19.8093 | 19.8093 | 19.7764 | 19.8089 | 2743160.0 |
| 2014-01-16 10:50:00 | AAPL | Stock | 19.8073 | 19.8075 | 19.7604 | 19.7786 | 2289168.0 |
| 2014-01-16 10:55:00 | AAPL | Stock | 19.7832 | 19.8061 | 19.7821 | 19.7843 | 1855924.0 |
| 2014-01-16 11:00:00 | AAPL | Stock | 19.7873 | 19.7961 | 19.7754 | 19.7943 | 1645056.0 |
> showing 50 of 355,140 rows — these rows as CSV