PREVIEW / stock_5min / 2015-08-06
file: by_date/stock_5min/2015/2015-08-06.parquet size: 5.6 MB rows: 366,476 symbols: 3,486
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-08-06 04:05:00 | AAPL | Stock | 28.8875 | 28.8875 | 28.8875 | 28.8875 | 3200.0 |
| 2015-08-06 04:15:00 | AAPL | Stock | 28.8875 | 28.8875 | 28.885 | 28.885 | 1200.0 |
| 2015-08-06 04:20:00 | AAPL | Stock | 28.875 | 28.875 | 28.875 | 28.875 | 23200.0 |
| 2015-08-06 04:25:00 | AAPL | Stock | 28.875 | 28.8875 | 28.875 | 28.8875 | 5408.0 |
| 2015-08-06 04:30:00 | AAPL | Stock | 28.8875 | 28.8875 | 28.875 | 28.875 | 1976.0 |
| 2015-08-06 04:35:00 | AAPL | Stock | 28.8875 | 28.8875 | 28.875 | 28.875 | 3096.0 |
| 2015-08-06 04:50:00 | AAPL | Stock | 28.875 | 28.875 | 28.875 | 28.875 | 400.0 |
| 2015-08-06 05:20:00 | AAPL | Stock | 28.875 | 28.875 | 28.875 | 28.875 | 1600.0 |
| 2015-08-06 05:25:00 | AAPL | Stock | 28.865 | 28.875 | 28.865 | 28.875 | 3240.0 |
| 2015-08-06 05:35:00 | AAPL | Stock | 28.84 | 28.8525 | 28.84 | 28.8525 | 3280.0 |
| 2015-08-06 06:00:00 | AAPL | Stock | 28.86 | 28.86 | 28.86 | 28.86 | 400.0 |
| 2015-08-06 06:20:00 | AAPL | Stock | 28.8875 | 28.9275 | 28.8875 | 28.9275 | 2800.0 |
| 2015-08-06 06:45:00 | AAPL | Stock | 28.875 | 28.8875 | 28.875 | 28.8875 | 3000.0 |
| 2015-08-06 06:50:00 | AAPL | Stock | 28.8825 | 28.8875 | 28.8825 | 28.8875 | 7600.0 |
| 2015-08-06 06:55:00 | AAPL | Stock | 28.875 | 28.875 | 28.855 | 28.855 | 11640.0 |
| 2015-08-06 07:00:00 | AAPL | Stock | 28.875 | 28.875 | 28.8625 | 28.8625 | 13412.0 |
| 2015-08-06 07:05:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.8475 | 28.8625 | 30976.0 |
| 2015-08-06 07:15:00 | AAPL | Stock | 28.875 | 28.875 | 28.875 | 28.875 | 8000.0 |
| 2015-08-06 07:20:00 | AAPL | Stock | 28.875 | 28.875 | 28.85 | 28.85 | 16000.0 |
| 2015-08-06 07:30:00 | AAPL | Stock | 28.8525 | 28.87 | 28.8525 | 28.87 | 21600.0 |
| 2015-08-06 07:35:00 | AAPL | Stock | 28.87 | 28.9125 | 28.8625 | 28.9125 | 103496.0 |
| 2015-08-06 07:40:00 | AAPL | Stock | 28.9125 | 28.9125 | 28.8875 | 28.9125 | 20136.0 |
| 2015-08-06 07:45:00 | AAPL | Stock | 28.9125 | 28.9125 | 28.8775 | 28.8775 | 12600.0 |
| 2015-08-06 07:50:00 | AAPL | Stock | 28.8875 | 28.8875 | 28.85 | 28.875 | 26964.0 |
| 2015-08-06 07:55:00 | AAPL | Stock | 28.8775 | 28.885 | 28.8775 | 28.885 | 2000.0 |
| 2015-08-06 08:00:00 | AAPL | Stock | 28.8775 | 28.9125 | 28.8475 | 28.89 | 102180.0 |
| 2015-08-06 08:05:00 | AAPL | Stock | 28.8875 | 28.9 | 28.8825 | 28.8868 | 39148.0 |
| 2015-08-06 08:10:00 | AAPL | Stock | 28.8875 | 28.9075 | 28.88 | 28.9 | 83280.0 |
| 2015-08-06 08:15:00 | AAPL | Stock | 28.9075 | 28.9225 | 28.8925 | 28.9025 | 101572.0 |
| 2015-08-06 08:20:00 | AAPL | Stock | 28.905 | 28.9375 | 28.9025 | 28.9375 | 96468.0 |
| 2015-08-06 08:25:00 | AAPL | Stock | 28.9375 | 28.95 | 28.9225 | 28.925 | 235660.0 |
| 2015-08-06 08:30:00 | AAPL | Stock | 28.925 | 28.95 | 28.89 | 28.9025 | 149772.0 |
| 2015-08-06 08:35:00 | AAPL | Stock | 28.9125 | 28.985 | 28.905 | 28.9625 | 358300.0 |
| 2015-08-06 08:40:00 | AAPL | Stock | 28.96 | 28.96 | 28.9158 | 28.92 | 90772.0 |
| 2015-08-06 08:45:00 | AAPL | Stock | 28.915 | 28.925 | 28.875 | 28.9125 | 62052.0 |
| 2015-08-06 08:50:00 | AAPL | Stock | 28.93 | 28.94 | 28.925 | 28.935 | 6400.0 |
| 2015-08-06 08:55:00 | AAPL | Stock | 28.935 | 28.9475 | 28.925 | 28.9475 | 28684.0 |
| 2015-08-06 09:00:00 | AAPL | Stock | 28.955 | 28.96 | 28.9425 | 28.945 | 68980.0 |
| 2015-08-06 09:05:00 | AAPL | Stock | 28.945 | 28.95 | 28.9375 | 28.9425 | 106928.0 |
| 2015-08-06 09:10:00 | AAPL | Stock | 28.9375 | 28.945 | 28.9225 | 28.945 | 96704.0 |
| 2015-08-06 09:15:00 | AAPL | Stock | 28.945 | 28.975 | 28.945 | 28.96 | 87040.0 |
| 2015-08-06 09:20:00 | AAPL | Stock | 28.9618 | 29.03 | 28.95 | 28.9925 | 288548.0 |
| 2015-08-06 09:25:00 | AAPL | Stock | 28.9875 | 29.0275 | 28.9525 | 28.9925 | 121288.0 |
| 2015-08-06 09:30:00 | AAPL | Stock | 28.9925 | 29.125 | 28.9325 | 28.935 | 10386776.0 |
| 2015-08-06 09:35:00 | AAPL | Stock | 28.945 | 28.9725 | 28.775 | 28.78 | 7173228.0 |
| 2015-08-06 09:40:00 | AAPL | Stock | 28.7822 | 28.8575 | 28.7 | 28.7875 | 6568412.0 |
| 2015-08-06 09:45:00 | AAPL | Stock | 28.791 | 28.935 | 28.7875 | 28.8102 | 4361288.0 |
| 2015-08-06 09:50:00 | AAPL | Stock | 28.81 | 28.8875 | 28.705 | 28.725 | 4723312.0 |
| 2015-08-06 09:55:00 | AAPL | Stock | 28.7275 | 28.7825 | 28.6775 | 28.7475 | 4719568.0 |
| 2015-08-06 10:00:00 | AAPL | Stock | 28.75 | 28.7525 | 28.675 | 28.71 | 3751912.0 |
> showing 50 of 366,476 rows — these rows as CSV