PREVIEW / stock_5min / 2017-03-01
file: by_date/stock_5min/2017/2017-03-01.parquet size: 5.7 MB rows: 369,517 symbols: 3,101
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 |
|---|---|---|---|---|---|---|---|
| 2017-03-01 04:00:00 | AAPL | Stock | 34.3125 | 34.345 | 34.3125 | 34.3325 | 2000.0 |
| 2017-03-01 04:05:00 | AAPL | Stock | 34.3325 | 34.36 | 34.3275 | 34.36 | 9600.0 |
| 2017-03-01 04:10:00 | AAPL | Stock | 34.3675 | 34.3825 | 34.3675 | 34.375 | 4140.0 |
| 2017-03-01 04:20:00 | AAPL | Stock | 34.395 | 34.4 | 34.395 | 34.4 | 8872.0 |
| 2017-03-01 04:25:00 | AAPL | Stock | 34.4 | 34.4 | 34.4 | 34.4 | 800.0 |
| 2017-03-01 05:15:00 | AAPL | Stock | 34.3975 | 34.3975 | 34.3975 | 34.3975 | 1200.0 |
| 2017-03-01 05:30:00 | AAPL | Stock | 34.3975 | 34.3975 | 34.3975 | 34.3975 | 828.0 |
| 2017-03-01 05:35:00 | AAPL | Stock | 34.3975 | 34.4025 | 34.3975 | 34.4025 | 1764.0 |
| 2017-03-01 05:45:00 | AAPL | Stock | 34.42 | 34.42 | 34.42 | 34.42 | 400.0 |
| 2017-03-01 05:50:00 | AAPL | Stock | 34.425 | 34.425 | 34.425 | 34.425 | 4000.0 |
| 2017-03-01 05:55:00 | AAPL | Stock | 34.4025 | 34.4025 | 34.4 | 34.4 | 3736.0 |
| 2017-03-01 06:00:00 | AAPL | Stock | 34.4 | 34.425 | 34.4 | 34.425 | 8752.0 |
| 2017-03-01 06:05:00 | AAPL | Stock | 34.4225 | 34.4225 | 34.4225 | 34.4225 | 400.0 |
| 2017-03-01 06:15:00 | AAPL | Stock | 34.42 | 34.4225 | 34.42 | 34.4225 | 1072.0 |
| 2017-03-01 06:25:00 | AAPL | Stock | 34.4225 | 34.4225 | 34.4225 | 34.4225 | 2800.0 |
| 2017-03-01 06:30:00 | AAPL | Stock | 34.42 | 34.4225 | 34.42 | 34.4225 | 7888.0 |
| 2017-03-01 06:35:00 | AAPL | Stock | 34.4225 | 34.4225 | 34.4 | 34.4 | 800.0 |
| 2017-03-01 06:40:00 | AAPL | Stock | 34.42 | 34.42 | 34.4 | 34.4 | 5048.0 |
| 2017-03-01 06:45:00 | AAPL | Stock | 34.4 | 34.4175 | 34.4 | 34.4175 | 15044.0 |
| 2017-03-01 06:50:00 | AAPL | Stock | 34.4175 | 34.43 | 34.4 | 34.4 | 5136.0 |
| 2017-03-01 06:55:00 | AAPL | Stock | 34.42 | 34.425 | 34.42 | 34.425 | 4356.0 |
| 2017-03-01 07:00:00 | AAPL | Stock | 34.425 | 34.425 | 34.4125 | 34.425 | 12884.0 |
| 2017-03-01 07:05:00 | AAPL | Stock | 34.425 | 34.4375 | 34.4125 | 34.425 | 28416.0 |
| 2017-03-01 07:10:00 | AAPL | Stock | 34.4075 | 34.4125 | 34.38 | 34.4125 | 6916.0 |
| 2017-03-01 07:15:00 | AAPL | Stock | 34.4125 | 34.4125 | 34.4125 | 34.4125 | 4600.0 |
| 2017-03-01 07:20:00 | AAPL | Stock | 34.4 | 34.41 | 34.4 | 34.4075 | 6796.0 |
| 2017-03-01 07:25:00 | AAPL | Stock | 34.41 | 34.425 | 34.41 | 34.425 | 5164.0 |
| 2017-03-01 07:30:00 | AAPL | Stock | 34.4275 | 34.4275 | 34.4125 | 34.4125 | 3388.0 |
| 2017-03-01 07:35:00 | AAPL | Stock | 34.4225 | 34.4225 | 34.42 | 34.42 | 2800.0 |
| 2017-03-01 07:40:00 | AAPL | Stock | 34.4175 | 34.435 | 34.4175 | 34.4325 | 1600.0 |
| 2017-03-01 07:45:00 | AAPL | Stock | 34.435 | 34.435 | 34.4275 | 34.4275 | 800.0 |
| 2017-03-01 07:50:00 | AAPL | Stock | 34.4325 | 34.45 | 34.4325 | 34.45 | 35112.0 |
| 2017-03-01 07:55:00 | AAPL | Stock | 34.4475 | 34.4625 | 34.4275 | 34.4475 | 62556.0 |
| 2017-03-01 08:00:00 | AAPL | Stock | 34.44 | 34.46 | 34.4 | 34.41 | 130924.0 |
| 2017-03-01 08:05:00 | AAPL | Stock | 34.43 | 34.4325 | 34.41 | 34.4325 | 7332.0 |
| 2017-03-01 08:10:00 | AAPL | Stock | 34.43 | 34.4375 | 34.42 | 34.425 | 22960.0 |
| 2017-03-01 08:15:00 | AAPL | Stock | 34.435 | 34.4475 | 34.435 | 34.4475 | 17280.0 |
| 2017-03-01 08:20:00 | AAPL | Stock | 34.45 | 34.4725 | 34.4425 | 34.45 | 47092.0 |
| 2017-03-01 08:25:00 | AAPL | Stock | 34.45 | 34.475 | 34.45 | 34.4625 | 42892.0 |
| 2017-03-01 08:30:00 | AAPL | Stock | 34.4625 | 34.475 | 34.45 | 34.4725 | 40088.0 |
| 2017-03-01 08:35:00 | AAPL | Stock | 34.475 | 34.4825 | 34.47 | 34.4825 | 43736.0 |
| 2017-03-01 08:40:00 | AAPL | Stock | 34.4825 | 34.485 | 34.4775 | 34.485 | 37508.0 |
| 2017-03-01 08:45:00 | AAPL | Stock | 34.485 | 34.4975 | 34.4825 | 34.4975 | 75836.0 |
| 2017-03-01 08:50:00 | AAPL | Stock | 34.4975 | 34.4975 | 34.4875 | 34.4925 | 31272.0 |
| 2017-03-01 08:55:00 | AAPL | Stock | 34.4925 | 34.4975 | 34.475 | 34.4875 | 35324.0 |
| 2017-03-01 09:00:00 | AAPL | Stock | 34.4775 | 34.4875 | 34.47 | 34.47 | 18624.0 |
| 2017-03-01 09:05:00 | AAPL | Stock | 34.475 | 34.485 | 34.475 | 34.485 | 23096.0 |
| 2017-03-01 09:10:00 | AAPL | Stock | 34.475 | 34.485 | 34.475 | 34.485 | 33980.0 |
| 2017-03-01 09:15:00 | AAPL | Stock | 34.475 | 34.4825 | 34.47 | 34.4825 | 21312.0 |
| 2017-03-01 09:20:00 | AAPL | Stock | 34.485 | 34.495 | 34.4625 | 34.47 | 72980.0 |
> showing 50 of 369,517 rows — these rows as CSV