PREVIEW / stock_5min / 2015-05-11
file: by_date/stock_5min/2015/2015-05-11.parquet size: 5.4 MB rows: 362,799 symbols: 3,512
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 |
|---|---|---|---|---|---|---|---|
| 2015-05-11 04:20:00 | AAPL | Stock | 31.885 | 31.905 | 31.885 | 31.905 | 3568.0 |
| 2015-05-11 04:25:00 | AAPL | Stock | 31.94 | 31.9575 | 31.94 | 31.9575 | 1332.0 |
| 2015-05-11 04:30:00 | AAPL | Stock | 31.9225 | 31.9225 | 31.9225 | 31.9225 | 2000.0 |
| 2015-05-11 04:40:00 | AAPL | Stock | 31.9 | 31.9 | 31.89 | 31.89 | 4000.0 |
| 2015-05-11 05:20:00 | AAPL | Stock | 31.895 | 31.895 | 31.895 | 31.895 | 400.0 |
| 2015-05-11 05:45:00 | AAPL | Stock | 31.8725 | 31.915 | 31.8725 | 31.915 | 1484.0 |
| 2015-05-11 05:50:00 | AAPL | Stock | 31.8875 | 31.8875 | 31.8875 | 31.8875 | 800.0 |
| 2015-05-11 06:00:00 | AAPL | Stock | 31.8875 | 31.8875 | 31.87 | 31.87 | 1412.0 |
| 2015-05-11 06:05:00 | AAPL | Stock | 31.88 | 31.88 | 31.87 | 31.88 | 4000.0 |
| 2015-05-11 06:10:00 | AAPL | Stock | 31.8725 | 31.875 | 31.8725 | 31.875 | 3600.0 |
| 2015-05-11 06:15:00 | AAPL | Stock | 31.875 | 31.8775 | 31.875 | 31.8775 | 800.0 |
| 2015-05-11 06:20:00 | AAPL | Stock | 31.8825 | 31.8825 | 31.8825 | 31.8825 | 2240.0 |
| 2015-05-11 06:25:00 | AAPL | Stock | 31.885 | 31.8875 | 31.885 | 31.8875 | 8288.0 |
| 2015-05-11 06:45:00 | AAPL | Stock | 31.88 | 31.8875 | 31.85 | 31.8875 | 10980.0 |
| 2015-05-11 07:05:00 | AAPL | Stock | 31.875 | 31.875 | 31.85 | 31.85 | 12128.0 |
| 2015-05-11 07:10:00 | AAPL | Stock | 31.8525 | 31.8625 | 31.85 | 31.85 | 3360.0 |
| 2015-05-11 07:15:00 | AAPL | Stock | 31.8375 | 31.85 | 31.8375 | 31.85 | 1696.0 |
| 2015-05-11 07:25:00 | AAPL | Stock | 31.84 | 31.845 | 31.84 | 31.845 | 4180.0 |
| 2015-05-11 07:30:00 | AAPL | Stock | 31.83 | 31.83 | 31.8175 | 31.8175 | 2020.0 |
| 2015-05-11 07:35:00 | AAPL | Stock | 31.845 | 31.8525 | 31.825 | 31.85 | 25596.0 |
| 2015-05-11 07:40:00 | AAPL | Stock | 31.85 | 31.875 | 31.85 | 31.875 | 12316.0 |
| 2015-05-11 07:55:00 | AAPL | Stock | 31.85 | 31.85 | 31.845 | 31.85 | 5600.0 |
| 2015-05-11 08:00:00 | AAPL | Stock | 31.85 | 31.9 | 31.82 | 31.85 | 82696.0 |
| 2015-05-11 08:05:00 | AAPL | Stock | 31.8475 | 31.8575 | 31.8475 | 31.8475 | 56488.0 |
| 2015-05-11 08:10:00 | AAPL | Stock | 31.8475 | 31.8725 | 31.8425 | 31.8625 | 136948.0 |
| 2015-05-11 08:15:00 | AAPL | Stock | 31.85 | 31.855 | 31.8375 | 31.8475 | 33652.0 |
| 2015-05-11 08:20:00 | AAPL | Stock | 31.8425 | 31.85 | 31.8425 | 31.8425 | 32704.0 |
| 2015-05-11 08:25:00 | AAPL | Stock | 31.835 | 31.8498 | 31.835 | 31.8498 | 3048.0 |
| 2015-05-11 08:30:00 | AAPL | Stock | 31.835 | 31.835 | 31.835 | 31.835 | 800.0 |
| 2015-05-11 08:35:00 | AAPL | Stock | 31.835 | 31.835 | 31.8275 | 31.8275 | 18064.0 |
| 2015-05-11 08:40:00 | AAPL | Stock | 31.835 | 31.835 | 31.83 | 31.8325 | 8364.0 |
| 2015-05-11 08:45:00 | AAPL | Stock | 31.8302 | 31.8425 | 31.83 | 31.84 | 20948.0 |
| 2015-05-11 08:50:00 | AAPL | Stock | 31.83 | 31.84 | 31.815 | 31.825 | 58724.0 |
| 2015-05-11 08:55:00 | AAPL | Stock | 31.8175 | 31.8325 | 31.8175 | 31.8325 | 24240.0 |
| 2015-05-11 09:00:00 | AAPL | Stock | 31.835 | 31.855 | 31.8275 | 31.855 | 23636.0 |
| 2015-05-11 09:05:00 | AAPL | Stock | 31.8475 | 31.86 | 31.825 | 31.825 | 48660.0 |
| 2015-05-11 09:10:00 | AAPL | Stock | 31.83 | 31.85 | 31.83 | 31.8425 | 59564.0 |
| 2015-05-11 09:15:00 | AAPL | Stock | 31.8425 | 31.8425 | 31.83 | 31.83 | 39204.0 |
| 2015-05-11 09:20:00 | AAPL | Stock | 31.835 | 31.835 | 31.8225 | 31.8325 | 33140.0 |
| 2015-05-11 09:25:00 | AAPL | Stock | 31.825 | 31.85 | 31.7625 | 31.85 | 73516.0 |
| 2015-05-11 09:30:00 | AAPL | Stock | 31.8475 | 31.89 | 31.7575 | 31.82 | 5154412.0 |
| 2015-05-11 09:35:00 | AAPL | Stock | 31.8175 | 31.8675 | 31.6425 | 31.67 | 5950912.0 |
| 2015-05-11 09:40:00 | AAPL | Stock | 31.67 | 31.6825 | 31.535 | 31.565 | 5636816.0 |
| 2015-05-11 09:45:00 | AAPL | Stock | 31.5675 | 31.66 | 31.5675 | 31.642 | 3777480.0 |
| 2015-05-11 09:50:00 | AAPL | Stock | 31.64 | 31.64 | 31.51 | 31.5275 | 4744048.0 |
| 2015-05-11 09:55:00 | AAPL | Stock | 31.5275 | 31.59 | 31.47 | 31.552 | 5866012.0 |
| 2015-05-11 10:00:00 | AAPL | Stock | 31.55 | 31.63 | 31.5425 | 31.6175 | 2781624.0 |
| 2015-05-11 10:05:00 | AAPL | Stock | 31.6175 | 31.6325 | 31.575 | 31.6225 | 2475096.0 |
| 2015-05-11 10:10:00 | AAPL | Stock | 31.6225 | 31.6225 | 31.56 | 31.59 | 2140032.0 |
| 2015-05-11 10:15:00 | AAPL | Stock | 31.5912 | 31.5925 | 31.5325 | 31.555 | 2328936.0 |
> showing 50 of 362,799 rows — these rows as CSV