PREVIEW / stock_5min / 2015-07-20
file: by_date/stock_5min/2015/2015-07-20.parquet size: 5.5 MB rows: 360,905 symbols: 3,507
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-07-20 04:00:00 | AAPL | Stock | 32.5 | 32.55 | 32.5 | 32.55 | 8248.0 |
| 2015-07-20 04:05:00 | AAPL | Stock | 32.5475 | 32.5475 | 32.5475 | 32.5475 | 800.0 |
| 2015-07-20 04:10:00 | AAPL | Stock | 32.5375 | 32.5475 | 32.525 | 32.5475 | 2400.0 |
| 2015-07-20 04:15:00 | AAPL | Stock | 32.5425 | 32.55 | 32.5425 | 32.55 | 10400.0 |
| 2015-07-20 04:20:00 | AAPL | Stock | 32.55 | 32.56 | 32.55 | 32.56 | 12396.0 |
| 2015-07-20 04:25:00 | AAPL | Stock | 32.5575 | 32.5625 | 32.5525 | 32.5625 | 4404.0 |
| 2015-07-20 04:30:00 | AAPL | Stock | 32.555 | 32.56 | 32.5525 | 32.5525 | 14000.0 |
| 2015-07-20 04:35:00 | AAPL | Stock | 32.545 | 32.57 | 32.5425 | 32.565 | 10892.0 |
| 2015-07-20 04:40:00 | AAPL | Stock | 32.575 | 32.575 | 32.565 | 32.565 | 13312.0 |
| 2015-07-20 04:45:00 | AAPL | Stock | 32.605 | 32.605 | 32.605 | 32.605 | 9144.0 |
| 2015-07-20 04:50:00 | AAPL | Stock | 32.605 | 32.605 | 32.605 | 32.605 | 656.0 |
| 2015-07-20 04:55:00 | AAPL | Stock | 32.62 | 32.62 | 32.5775 | 32.5775 | 1944.0 |
| 2015-07-20 05:00:00 | AAPL | Stock | 32.6225 | 32.6225 | 32.6225 | 32.6225 | 400.0 |
| 2015-07-20 05:10:00 | AAPL | Stock | 32.5775 | 32.5825 | 32.575 | 32.5825 | 15668.0 |
| 2015-07-20 05:20:00 | AAPL | Stock | 32.575 | 32.6 | 32.575 | 32.6 | 13960.0 |
| 2015-07-20 05:25:00 | AAPL | Stock | 32.6025 | 32.6125 | 32.6 | 32.6125 | 5000.0 |
| 2015-07-20 05:35:00 | AAPL | Stock | 32.6125 | 32.6175 | 32.6125 | 32.615 | 12200.0 |
| 2015-07-20 05:45:00 | AAPL | Stock | 32.605 | 32.62 | 32.605 | 32.62 | 1040.0 |
| 2015-07-20 05:50:00 | AAPL | Stock | 32.62 | 32.62 | 32.62 | 32.62 | 2800.0 |
| 2015-07-20 05:55:00 | AAPL | Stock | 32.625 | 32.625 | 32.625 | 32.625 | 2000.0 |
| 2015-07-20 06:00:00 | AAPL | Stock | 32.625 | 32.645 | 32.625 | 32.645 | 17600.0 |
| 2015-07-20 06:05:00 | AAPL | Stock | 32.645 | 32.645 | 32.64 | 32.6425 | 5780.0 |
| 2015-07-20 06:10:00 | AAPL | Stock | 32.645 | 32.645 | 32.625 | 32.625 | 5864.0 |
| 2015-07-20 06:20:00 | AAPL | Stock | 32.6275 | 32.6475 | 32.6275 | 32.6475 | 2360.0 |
| 2015-07-20 06:25:00 | AAPL | Stock | 32.64 | 32.6625 | 32.64 | 32.6625 | 12212.0 |
| 2015-07-20 06:30:00 | AAPL | Stock | 32.6725 | 32.6875 | 32.6725 | 32.6875 | 19324.0 |
| 2015-07-20 06:40:00 | AAPL | Stock | 32.685 | 32.685 | 32.6775 | 32.6775 | 2400.0 |
| 2015-07-20 06:45:00 | AAPL | Stock | 32.685 | 32.685 | 32.665 | 32.67 | 1600.0 |
| 2015-07-20 06:50:00 | AAPL | Stock | 32.675 | 32.695 | 32.675 | 32.695 | 38168.0 |
| 2015-07-20 06:55:00 | AAPL | Stock | 32.6875 | 32.7075 | 32.6775 | 32.6775 | 18652.0 |
| 2015-07-20 07:00:00 | AAPL | Stock | 32.6875 | 32.7725 | 32.6875 | 32.75 | 82040.0 |
| 2015-07-20 07:05:00 | AAPL | Stock | 32.7125 | 32.7475 | 32.7125 | 32.7475 | 17584.0 |
| 2015-07-20 07:10:00 | AAPL | Stock | 32.75 | 32.755 | 32.7425 | 32.755 | 33220.0 |
| 2015-07-20 07:15:00 | AAPL | Stock | 32.7525 | 32.7525 | 32.73 | 32.75 | 18000.0 |
| 2015-07-20 07:20:00 | AAPL | Stock | 32.75 | 32.775 | 32.7475 | 32.775 | 37696.0 |
| 2015-07-20 07:25:00 | AAPL | Stock | 32.7825 | 32.7925 | 32.775 | 32.785 | 29012.0 |
| 2015-07-20 07:30:00 | AAPL | Stock | 32.775 | 32.8 | 32.765 | 32.7925 | 30056.0 |
| 2015-07-20 07:35:00 | AAPL | Stock | 32.7925 | 32.8125 | 32.7925 | 32.8 | 46840.0 |
| 2015-07-20 07:40:00 | AAPL | Stock | 32.8 | 32.8375 | 32.8 | 32.81 | 79488.0 |
| 2015-07-20 07:45:00 | AAPL | Stock | 32.8175 | 32.8275 | 32.815 | 32.8275 | 74408.0 |
| 2015-07-20 07:50:00 | AAPL | Stock | 32.8275 | 32.8625 | 32.82 | 32.85 | 95720.0 |
| 2015-07-20 07:55:00 | AAPL | Stock | 32.855 | 32.92 | 32.855 | 32.9125 | 147408.0 |
| 2015-07-20 08:00:00 | AAPL | Stock | 32.92 | 32.92 | 32.6375 | 32.8675 | 552608.0 |
| 2015-07-20 08:05:00 | AAPL | Stock | 32.8675 | 32.8675 | 32.8375 | 32.855 | 122084.0 |
| 2015-07-20 08:10:00 | AAPL | Stock | 32.8525 | 32.8675 | 32.8425 | 32.855 | 160120.0 |
| 2015-07-20 08:15:00 | AAPL | Stock | 32.8525 | 32.8625 | 32.8525 | 32.8625 | 97020.0 |
| 2015-07-20 08:20:00 | AAPL | Stock | 32.86 | 32.8875 | 32.855 | 32.885 | 198444.0 |
| 2015-07-20 08:25:00 | AAPL | Stock | 32.8825 | 32.8875 | 32.8775 | 32.8875 | 92872.0 |
| 2015-07-20 08:30:00 | AAPL | Stock | 32.8875 | 32.9125 | 32.885 | 32.9 | 128144.0 |
| 2015-07-20 08:35:00 | AAPL | Stock | 32.9 | 32.9125 | 32.8975 | 32.91 | 114112.0 |
> showing 50 of 360,905 rows — these rows as CSV