PREVIEW / stock_5min / 2018-02-07
file: by_date/stock_5min/2018/2018-02-07.parquet size: 5.8 MB rows: 372,820 symbols: 2,901
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-07 04:00:00 | AAPL | Stock | 40.4125 | 40.45 | 40.35 | 40.35 | 7332.0 |
| 2018-02-07 04:05:00 | AAPL | Stock | 40.35 | 40.41 | 40.35 | 40.3875 | 4400.0 |
| 2018-02-07 04:20:00 | AAPL | Stock | 40.325 | 40.35 | 40.325 | 40.35 | 3352.0 |
| 2018-02-07 04:25:00 | AAPL | Stock | 40.35 | 40.45 | 40.35 | 40.45 | 7976.0 |
| 2018-02-07 04:50:00 | AAPL | Stock | 40.39 | 40.39 | 40.39 | 40.39 | 400.0 |
| 2018-02-07 04:55:00 | AAPL | Stock | 40.315 | 40.315 | 40.315 | 40.315 | 400.0 |
| 2018-02-07 05:00:00 | AAPL | Stock | 40.375 | 40.375 | 40.375 | 40.375 | 2000.0 |
| 2018-02-07 05:05:00 | AAPL | Stock | 40.405 | 40.405 | 40.3925 | 40.395 | 4000.0 |
| 2018-02-07 05:10:00 | AAPL | Stock | 40.405 | 40.445 | 40.405 | 40.445 | 5200.0 |
| 2018-02-07 05:15:00 | AAPL | Stock | 40.47 | 40.4925 | 40.47 | 40.4925 | 4048.0 |
| 2018-02-07 05:20:00 | AAPL | Stock | 40.4675 | 40.4675 | 40.4675 | 40.4675 | 400.0 |
| 2018-02-07 05:25:00 | AAPL | Stock | 40.43 | 40.43 | 40.43 | 40.43 | 800.0 |
| 2018-02-07 05:30:00 | AAPL | Stock | 40.4425 | 40.445 | 40.4425 | 40.445 | 6400.0 |
| 2018-02-07 05:35:00 | AAPL | Stock | 40.415 | 40.415 | 40.3675 | 40.37 | 5328.0 |
| 2018-02-07 05:45:00 | AAPL | Stock | 40.4075 | 40.445 | 40.4075 | 40.445 | 1200.0 |
| 2018-02-07 05:50:00 | AAPL | Stock | 40.4675 | 40.4675 | 40.415 | 40.415 | 2280.0 |
| 2018-02-07 05:55:00 | AAPL | Stock | 40.365 | 40.4125 | 40.365 | 40.4125 | 4000.0 |
| 2018-02-07 06:00:00 | AAPL | Stock | 40.4075 | 40.4075 | 40.25 | 40.25 | 4668.0 |
| 2018-02-07 06:05:00 | AAPL | Stock | 40.3125 | 40.4125 | 40.3125 | 40.4125 | 1600.0 |
| 2018-02-07 06:10:00 | AAPL | Stock | 40.4125 | 40.4125 | 40.4125 | 40.4125 | 1408.0 |
| 2018-02-07 06:25:00 | AAPL | Stock | 40.47 | 40.475 | 40.47 | 40.475 | 1972.0 |
| 2018-02-07 06:30:00 | AAPL | Stock | 40.4625 | 40.4625 | 40.4625 | 40.4625 | 400.0 |
| 2018-02-07 06:35:00 | AAPL | Stock | 40.5 | 40.5 | 40.5 | 40.5 | 5200.0 |
| 2018-02-07 06:40:00 | AAPL | Stock | 40.475 | 40.575 | 40.475 | 40.575 | 10120.0 |
| 2018-02-07 06:45:00 | AAPL | Stock | 40.5625 | 40.59 | 40.5625 | 40.5625 | 2628.0 |
| 2018-02-07 06:50:00 | AAPL | Stock | 40.5625 | 40.565 | 40.5625 | 40.565 | 5784.0 |
| 2018-02-07 06:55:00 | AAPL | Stock | 40.5625 | 40.5625 | 40.5 | 40.5625 | 30808.0 |
| 2018-02-07 07:00:00 | AAPL | Stock | 40.56 | 40.6 | 40.55 | 40.6 | 28348.0 |
| 2018-02-07 07:05:00 | AAPL | Stock | 40.6025 | 40.6025 | 40.565 | 40.565 | 23436.0 |
| 2018-02-07 07:10:00 | AAPL | Stock | 40.565 | 40.6475 | 40.5625 | 40.645 | 43852.0 |
| 2018-02-07 07:15:00 | AAPL | Stock | 40.6275 | 40.6475 | 40.5825 | 40.625 | 40012.0 |
| 2018-02-07 07:20:00 | AAPL | Stock | 40.625 | 40.625 | 40.6025 | 40.6225 | 3888.0 |
| 2018-02-07 07:25:00 | AAPL | Stock | 40.6025 | 40.645 | 40.5875 | 40.645 | 35476.0 |
| 2018-02-07 07:30:00 | AAPL | Stock | 40.6475 | 40.65 | 40.605 | 40.63 | 18836.0 |
| 2018-02-07 07:35:00 | AAPL | Stock | 40.63 | 40.6875 | 40.63 | 40.675 | 41832.0 |
| 2018-02-07 07:40:00 | AAPL | Stock | 40.68 | 40.6875 | 40.65 | 40.65 | 46304.0 |
| 2018-02-07 07:45:00 | AAPL | Stock | 40.645 | 40.65 | 40.63 | 40.6325 | 31924.0 |
| 2018-02-07 07:50:00 | AAPL | Stock | 40.6325 | 40.6475 | 40.6125 | 40.635 | 31816.0 |
| 2018-02-07 07:55:00 | AAPL | Stock | 40.6425 | 40.65 | 40.63 | 40.63 | 6856.0 |
| 2018-02-07 08:00:00 | AAPL | Stock | 40.5438 | 40.66 | 40.3325 | 40.64 | 88680.0 |
| 2018-02-07 08:05:00 | AAPL | Stock | 40.64 | 40.65 | 40.64 | 40.65 | 38868.0 |
| 2018-02-07 08:10:00 | AAPL | Stock | 40.65 | 40.71 | 40.65 | 40.68 | 31972.0 |
| 2018-02-07 08:15:00 | AAPL | Stock | 40.675 | 40.7375 | 40.675 | 40.7075 | 29244.0 |
| 2018-02-07 08:20:00 | AAPL | Stock | 40.7075 | 40.7075 | 40.64 | 40.64 | 56812.0 |
| 2018-02-07 08:25:00 | AAPL | Stock | 40.64 | 40.6775 | 40.625 | 40.6375 | 25436.0 |
| 2018-02-07 08:30:00 | AAPL | Stock | 40.6375 | 40.6625 | 40.6025 | 40.6125 | 81044.0 |
| 2018-02-07 08:35:00 | AAPL | Stock | 40.6125 | 40.625 | 40.6 | 40.6225 | 48364.0 |
| 2018-02-07 08:40:00 | AAPL | Stock | 40.6 | 40.65 | 40.6 | 40.6375 | 12320.0 |
| 2018-02-07 08:45:00 | AAPL | Stock | 40.625 | 40.65 | 40.59 | 40.605 | 29388.0 |
| 2018-02-07 08:50:00 | AAPL | Stock | 40.6125 | 40.6375 | 40.6125 | 40.625 | 36848.0 |
> showing 50 of 372,820 rows — these rows as CSV