PREVIEW / stock_5min / 2018-02-23
file: by_date/stock_5min/2018/2018-02-23.parquet size: 5.5 MB rows: 352,415 symbols: 2,868
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 |
|---|---|---|---|---|---|---|---|
| 2018-02-23 04:10:00 | AAPL | Stock | 43.325 | 43.325 | 43.325 | 43.325 | 400.0 |
| 2018-02-23 04:15:00 | AAPL | Stock | 43.4 | 43.4 | 43.4 | 43.4 | 400.0 |
| 2018-02-23 04:20:00 | AAPL | Stock | 43.375 | 43.375 | 43.375 | 43.375 | 3760.0 |
| 2018-02-23 04:25:00 | AAPL | Stock | 43.3775 | 43.3775 | 43.375 | 43.375 | 2400.0 |
| 2018-02-23 04:50:00 | AAPL | Stock | 43.395 | 43.395 | 43.395 | 43.395 | 6800.0 |
| 2018-02-23 05:15:00 | AAPL | Stock | 43.395 | 43.395 | 43.3375 | 43.3375 | 4000.0 |
| 2018-02-23 05:20:00 | AAPL | Stock | 43.35 | 43.4 | 43.35 | 43.3675 | 4000.0 |
| 2018-02-23 05:25:00 | AAPL | Stock | 43.3625 | 43.3975 | 43.36 | 43.3975 | 3800.0 |
| 2018-02-23 05:30:00 | AAPL | Stock | 43.325 | 43.325 | 43.325 | 43.325 | 4000.0 |
| 2018-02-23 05:35:00 | AAPL | Stock | 43.325 | 43.325 | 43.325 | 43.325 | 6400.0 |
| 2018-02-23 05:40:00 | AAPL | Stock | 43.325 | 43.325 | 43.325 | 43.325 | 4400.0 |
| 2018-02-23 05:50:00 | AAPL | Stock | 43.325 | 43.325 | 43.3125 | 43.3125 | 5600.0 |
| 2018-02-23 06:00:00 | AAPL | Stock | 43.335 | 43.3625 | 43.325 | 43.325 | 3800.0 |
| 2018-02-23 06:05:00 | AAPL | Stock | 43.375 | 43.3975 | 43.375 | 43.3975 | 1876.0 |
| 2018-02-23 06:10:00 | AAPL | Stock | 43.4 | 43.4475 | 43.4 | 43.4475 | 29200.0 |
| 2018-02-23 06:15:00 | AAPL | Stock | 43.39 | 43.425 | 43.39 | 43.425 | 9936.0 |
| 2018-02-23 06:20:00 | AAPL | Stock | 43.3575 | 43.38 | 43.3575 | 43.365 | 4000.0 |
| 2018-02-23 06:25:00 | AAPL | Stock | 43.4025 | 43.4025 | 43.4025 | 43.4025 | 3300.0 |
| 2018-02-23 06:30:00 | AAPL | Stock | 43.4025 | 43.4025 | 43.4025 | 43.4025 | 400.0 |
| 2018-02-23 06:40:00 | AAPL | Stock | 43.425 | 43.425 | 43.4 | 43.415 | 13200.0 |
| 2018-02-23 06:45:00 | AAPL | Stock | 43.415 | 43.415 | 43.415 | 43.415 | 400.0 |
| 2018-02-23 06:50:00 | AAPL | Stock | 43.41 | 43.45 | 43.41 | 43.4225 | 6136.0 |
| 2018-02-23 06:55:00 | AAPL | Stock | 43.4075 | 43.42 | 43.4075 | 43.42 | 1448.0 |
| 2018-02-23 07:00:00 | AAPL | Stock | 43.4125 | 43.45 | 43.4125 | 43.425 | 36016.0 |
| 2018-02-23 07:05:00 | AAPL | Stock | 43.4475 | 43.45 | 43.425 | 43.425 | 28020.0 |
| 2018-02-23 07:10:00 | AAPL | Stock | 43.4175 | 43.4225 | 43.4 | 43.4225 | 14760.0 |
| 2018-02-23 07:15:00 | AAPL | Stock | 43.425 | 43.425 | 43.3975 | 43.4 | 30596.0 |
| 2018-02-23 07:20:00 | AAPL | Stock | 43.395 | 43.435 | 43.3925 | 43.435 | 29552.0 |
| 2018-02-23 07:25:00 | AAPL | Stock | 43.44 | 43.45 | 43.435 | 43.435 | 8400.0 |
| 2018-02-23 07:30:00 | AAPL | Stock | 43.415 | 43.42 | 43.4 | 43.42 | 10400.0 |
| 2018-02-23 07:35:00 | AAPL | Stock | 43.395 | 43.395 | 43.38 | 43.38 | 1200.0 |
| 2018-02-23 07:40:00 | AAPL | Stock | 43.4125 | 43.4125 | 43.3975 | 43.4 | 5268.0 |
| 2018-02-23 07:45:00 | AAPL | Stock | 43.4 | 43.4025 | 43.4 | 43.4025 | 3592.0 |
| 2018-02-23 07:50:00 | AAPL | Stock | 43.405 | 43.405 | 43.3875 | 43.3875 | 8196.0 |
| 2018-02-23 07:55:00 | AAPL | Stock | 43.4025 | 43.4025 | 43.3875 | 43.395 | 11280.0 |
| 2018-02-23 08:00:00 | AAPL | Stock | 43.4062 | 43.4525 | 43.3775 | 43.425 | 89568.0 |
| 2018-02-23 08:05:00 | AAPL | Stock | 43.4325 | 43.47 | 43.425 | 43.46 | 53116.0 |
| 2018-02-23 08:10:00 | AAPL | Stock | 43.455 | 43.4625 | 43.445 | 43.45 | 14712.0 |
| 2018-02-23 08:15:00 | AAPL | Stock | 43.4525 | 43.455 | 43.445 | 43.455 | 27612.0 |
| 2018-02-23 08:20:00 | AAPL | Stock | 43.4625 | 43.4625 | 43.4275 | 43.4475 | 19628.0 |
| 2018-02-23 08:25:00 | AAPL | Stock | 43.425 | 43.4325 | 43.425 | 43.425 | 15680.0 |
| 2018-02-23 08:30:00 | AAPL | Stock | 43.445 | 43.445 | 43.4175 | 43.425 | 40200.0 |
| 2018-02-23 08:35:00 | AAPL | Stock | 43.435 | 43.4375 | 43.405 | 43.4075 | 10708.0 |
| 2018-02-23 08:40:00 | AAPL | Stock | 43.4075 | 43.425 | 43.4075 | 43.4125 | 10800.0 |
| 2018-02-23 08:45:00 | AAPL | Stock | 43.4225 | 43.4275 | 43.415 | 43.4275 | 27744.0 |
| 2018-02-23 08:50:00 | AAPL | Stock | 43.4125 | 43.4275 | 43.3825 | 43.4225 | 32196.0 |
| 2018-02-23 08:55:00 | AAPL | Stock | 43.4 | 43.4 | 43.3575 | 43.37 | 50056.0 |
| 2018-02-23 09:00:00 | AAPL | Stock | 43.3875 | 43.3875 | 43.3625 | 43.3875 | 22356.0 |
| 2018-02-23 09:05:00 | AAPL | Stock | 43.3775 | 43.4 | 43.375 | 43.3875 | 20060.0 |
| 2018-02-23 09:10:00 | AAPL | Stock | 43.38 | 43.38 | 43.3625 | 43.365 | 14712.0 |
> showing 50 of 352,415 rows — these rows as CSV