PREVIEW / stock_5min / 2016-03-15
file: by_date/stock_5min/2016/2016-03-15.parquet size: 5.3 MB rows: 353,614 symbols: 3,325
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-15 04:00:00 | AAPL | Stock | 25.7025 | 25.7025 | 25.5325 | 25.61 | 46400.0 |
| 2016-03-15 04:15:00 | AAPL | Stock | 25.625 | 25.625 | 25.625 | 25.625 | 3600.0 |
| 2016-03-15 04:20:00 | AAPL | Stock | 25.6 | 25.6 | 25.6 | 25.6 | 3600.0 |
| 2016-03-15 04:25:00 | AAPL | Stock | 25.625 | 25.625 | 25.625 | 25.625 | 400.0 |
| 2016-03-15 04:30:00 | AAPL | Stock | 25.575 | 25.575 | 25.56 | 25.56 | 11400.0 |
| 2016-03-15 04:55:00 | AAPL | Stock | 25.575 | 25.575 | 25.575 | 25.575 | 512.0 |
| 2016-03-15 05:00:00 | AAPL | Stock | 25.58 | 25.58 | 25.58 | 25.58 | 2800.0 |
| 2016-03-15 05:15:00 | AAPL | Stock | 25.6125 | 25.67 | 25.6125 | 25.67 | 4840.0 |
| 2016-03-15 05:20:00 | AAPL | Stock | 25.665 | 25.675 | 25.665 | 25.675 | 12800.0 |
| 2016-03-15 05:25:00 | AAPL | Stock | 25.67 | 25.68 | 25.6425 | 25.6775 | 5360.0 |
| 2016-03-15 05:30:00 | AAPL | Stock | 25.675 | 25.685 | 25.66 | 25.66 | 36372.0 |
| 2016-03-15 05:40:00 | AAPL | Stock | 25.675 | 25.675 | 25.675 | 25.675 | 7600.0 |
| 2016-03-15 06:00:00 | AAPL | Stock | 25.675 | 25.675 | 25.675 | 25.675 | 2000.0 |
| 2016-03-15 06:10:00 | AAPL | Stock | 25.675 | 25.75 | 25.675 | 25.75 | 11484.0 |
| 2016-03-15 06:15:00 | AAPL | Stock | 25.72 | 25.7225 | 25.7112 | 25.7225 | 8688.0 |
| 2016-03-15 06:20:00 | AAPL | Stock | 25.745 | 25.75 | 25.745 | 25.7475 | 4844.0 |
| 2016-03-15 06:25:00 | AAPL | Stock | 25.7725 | 25.825 | 25.7725 | 25.825 | 29192.0 |
| 2016-03-15 06:30:00 | AAPL | Stock | 25.8225 | 25.825 | 25.8225 | 25.825 | 800.0 |
| 2016-03-15 06:35:00 | AAPL | Stock | 25.8 | 25.8475 | 25.8 | 25.825 | 21072.0 |
| 2016-03-15 06:40:00 | AAPL | Stock | 25.85 | 25.8625 | 25.8375 | 25.8625 | 47172.0 |
| 2016-03-15 06:45:00 | AAPL | Stock | 25.85 | 25.88 | 25.8375 | 25.8725 | 51348.0 |
| 2016-03-15 06:50:00 | AAPL | Stock | 25.8625 | 25.9025 | 25.8625 | 25.9025 | 21600.0 |
| 2016-03-15 06:55:00 | AAPL | Stock | 25.9125 | 25.925 | 25.89 | 25.9075 | 27264.0 |
| 2016-03-15 07:00:00 | AAPL | Stock | 25.875 | 25.9375 | 25.875 | 25.9125 | 63896.0 |
| 2016-03-15 07:05:00 | AAPL | Stock | 25.9375 | 25.9375 | 25.9025 | 25.925 | 58144.0 |
| 2016-03-15 07:10:00 | AAPL | Stock | 25.9225 | 26.0 | 25.9225 | 25.9625 | 71760.0 |
| 2016-03-15 07:15:00 | AAPL | Stock | 25.995 | 26.0 | 25.9175 | 25.9175 | 29560.0 |
| 2016-03-15 07:20:00 | AAPL | Stock | 25.92 | 25.9225 | 25.9175 | 25.9225 | 5400.0 |
| 2016-03-15 07:25:00 | AAPL | Stock | 25.9125 | 26.0 | 25.9025 | 26.0 | 53052.0 |
| 2016-03-15 07:30:00 | AAPL | Stock | 25.99 | 26.0 | 25.9375 | 25.94 | 29196.0 |
| 2016-03-15 07:35:00 | AAPL | Stock | 25.9675 | 26.075 | 25.9675 | 26.075 | 56788.0 |
| 2016-03-15 07:40:00 | AAPL | Stock | 26.0625 | 26.125 | 26.06 | 26.0925 | 79368.0 |
| 2016-03-15 07:45:00 | AAPL | Stock | 26.08 | 26.12 | 26.0725 | 26.12 | 44612.0 |
| 2016-03-15 07:50:00 | AAPL | Stock | 26.1125 | 26.1225 | 26.025 | 26.025 | 101820.0 |
| 2016-03-15 07:55:00 | AAPL | Stock | 26.05 | 26.07 | 26.0225 | 26.0625 | 59996.0 |
| 2016-03-15 08:00:00 | AAPL | Stock | 26.045 | 26.0925 | 25.8875 | 26.0125 | 309952.0 |
| 2016-03-15 08:05:00 | AAPL | Stock | 26.0125 | 26.0375 | 26.0125 | 26.035 | 73280.0 |
| 2016-03-15 08:10:00 | AAPL | Stock | 26.0375 | 26.05 | 26.035 | 26.05 | 28560.0 |
| 2016-03-15 08:15:00 | AAPL | Stock | 26.05 | 26.0525 | 26.05 | 26.05 | 66340.0 |
| 2016-03-15 08:20:00 | AAPL | Stock | 26.05 | 26.065 | 26.05 | 26.06 | 98000.0 |
| 2016-03-15 08:25:00 | AAPL | Stock | 26.06 | 26.06 | 26.025 | 26.0425 | 90584.0 |
| 2016-03-15 08:30:00 | AAPL | Stock | 26.0275 | 26.04 | 25.9875 | 26.0 | 77376.0 |
| 2016-03-15 08:35:00 | AAPL | Stock | 26.0 | 26.005 | 25.9925 | 26.0025 | 210260.0 |
| 2016-03-15 08:40:00 | AAPL | Stock | 26.0025 | 26.005 | 25.9925 | 26.0025 | 253792.0 |
| 2016-03-15 08:45:00 | AAPL | Stock | 26.0 | 26.0025 | 26.0 | 26.0025 | 61744.0 |
| 2016-03-15 08:50:00 | AAPL | Stock | 26.0025 | 26.0025 | 25.9925 | 26.0 | 157448.0 |
| 2016-03-15 08:55:00 | AAPL | Stock | 26.0 | 26.0 | 25.9525 | 25.9575 | 70328.0 |
| 2016-03-15 09:00:00 | AAPL | Stock | 25.9575 | 26.01 | 25.9575 | 26.01 | 119308.0 |
| 2016-03-15 09:05:00 | AAPL | Stock | 26.01 | 26.05 | 26.01 | 26.0475 | 136524.0 |
| 2016-03-15 09:10:00 | AAPL | Stock | 26.05 | 26.0875 | 26.0425 | 26.0875 | 148384.0 |
> showing 50 of 353,614 rows — these rows as CSV