PREVIEW / stock_5min / 2020-09-29
file: by_date/stock_5min/2020/2020-09-29.parquet size: 6.5 MB rows: 406,042 symbols: 2,489
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 |
|---|---|---|---|---|---|---|---|
| 2020-09-29 04:00:00 | AAPL | Stock | 115.0 | 115.0 | 114.34 | 114.34 | 10873.0 |
| 2020-09-29 04:05:00 | AAPL | Stock | 114.34 | 114.34 | 114.2 | 114.3 | 4606.0 |
| 2020-09-29 04:10:00 | AAPL | Stock | 114.28 | 114.43 | 114.23 | 114.43 | 2560.0 |
| 2020-09-29 04:15:00 | AAPL | Stock | 114.4 | 114.62 | 114.4 | 114.62 | 2258.0 |
| 2020-09-29 04:20:00 | AAPL | Stock | 114.62 | 114.7 | 114.55 | 114.55 | 1525.0 |
| 2020-09-29 04:25:00 | AAPL | Stock | 114.55 | 114.59 | 114.55 | 114.59 | 576.0 |
| 2020-09-29 04:30:00 | AAPL | Stock | 114.59 | 114.68 | 114.55 | 114.58 | 2728.0 |
| 2020-09-29 04:40:00 | AAPL | Stock | 114.65 | 114.74 | 114.5 | 114.5 | 2954.0 |
| 2020-09-29 04:45:00 | AAPL | Stock | 114.5 | 114.69 | 114.5 | 114.68 | 4332.0 |
| 2020-09-29 04:50:00 | AAPL | Stock | 114.49 | 114.54 | 114.49 | 114.5 | 1562.0 |
| 2020-09-29 04:55:00 | AAPL | Stock | 114.6 | 114.65 | 114.5 | 114.61 | 1145.0 |
| 2020-09-29 05:00:00 | AAPL | Stock | 114.6 | 114.69 | 114.6 | 114.69 | 300.0 |
| 2020-09-29 05:05:00 | AAPL | Stock | 114.67 | 114.89 | 114.67 | 114.75 | 2538.0 |
| 2020-09-29 05:10:00 | AAPL | Stock | 114.76 | 114.76 | 114.57 | 114.6 | 1618.0 |
| 2020-09-29 05:15:00 | AAPL | Stock | 114.65 | 114.65 | 114.51 | 114.51 | 699.0 |
| 2020-09-29 05:20:00 | AAPL | Stock | 114.53 | 114.53 | 114.39 | 114.39 | 1296.0 |
| 2020-09-29 05:25:00 | AAPL | Stock | 114.51 | 114.51 | 114.24 | 114.4 | 3085.0 |
| 2020-09-29 05:30:00 | AAPL | Stock | 114.4 | 114.4 | 114.22 | 114.39 | 4088.0 |
| 2020-09-29 05:35:00 | AAPL | Stock | 114.39 | 114.62 | 114.39 | 114.55 | 1527.0 |
| 2020-09-29 05:40:00 | AAPL | Stock | 114.58 | 114.58 | 114.53 | 114.54 | 946.0 |
| 2020-09-29 05:45:00 | AAPL | Stock | 114.58 | 114.58 | 114.5 | 114.5 | 296.0 |
| 2020-09-29 05:50:00 | AAPL | Stock | 114.5 | 114.7 | 114.5 | 114.7 | 1104.0 |
| 2020-09-29 05:55:00 | AAPL | Stock | 114.74 | 114.84 | 114.74 | 114.8 | 10087.0 |
| 2020-09-29 06:00:00 | AAPL | Stock | 114.77 | 114.77 | 114.62 | 114.7 | 8588.0 |
| 2020-09-29 06:05:00 | AAPL | Stock | 114.82 | 114.85 | 114.75 | 114.75 | 1879.0 |
| 2020-09-29 06:10:00 | AAPL | Stock | 114.87 | 114.98 | 114.85 | 114.95 | 2589.0 |
| 2020-09-29 06:15:00 | AAPL | Stock | 115.0 | 115.1 | 114.96 | 115.1 | 1005.0 |
| 2020-09-29 06:20:00 | AAPL | Stock | 115.09 | 115.1 | 114.93 | 115.0 | 5419.0 |
| 2020-09-29 06:25:00 | AAPL | Stock | 114.97 | 115.09 | 114.94 | 115.09 | 1652.0 |
| 2020-09-29 06:30:00 | AAPL | Stock | 115.07 | 115.11 | 115.0 | 115.11 | 6476.0 |
| 2020-09-29 06:35:00 | AAPL | Stock | 115.06 | 115.06 | 114.73 | 114.73 | 1021.0 |
| 2020-09-29 06:40:00 | AAPL | Stock | 114.83 | 114.83 | 114.8 | 114.8 | 2263.0 |
| 2020-09-29 06:45:00 | AAPL | Stock | 114.78 | 114.8 | 114.75 | 114.8 | 1747.0 |
| 2020-09-29 06:50:00 | AAPL | Stock | 114.8 | 114.85 | 114.8 | 114.83 | 1754.0 |
| 2020-09-29 06:55:00 | AAPL | Stock | 114.86 | 114.9 | 114.85 | 114.9 | 480.0 |
| 2020-09-29 07:00:00 | AAPL | Stock | 114.92 | 115.2 | 114.8 | 115.05 | 49220.0 |
| 2020-09-29 07:05:00 | AAPL | Stock | 115.08 | 115.15 | 115.0 | 115.13 | 31251.0 |
| 2020-09-29 07:10:00 | AAPL | Stock | 115.13 | 115.19 | 115.1 | 115.1 | 25197.0 |
| 2020-09-29 07:15:00 | AAPL | Stock | 115.1 | 115.11 | 114.85 | 114.85 | 126394.0 |
| 2020-09-29 07:20:00 | AAPL | Stock | 114.87 | 114.9 | 114.65 | 114.66 | 25284.0 |
| 2020-09-29 07:25:00 | AAPL | Stock | 114.69 | 115.01 | 114.69 | 114.86 | 29804.0 |
| 2020-09-29 07:30:00 | AAPL | Stock | 114.88 | 114.95 | 114.5 | 114.55 | 30785.0 |
| 2020-09-29 07:35:00 | AAPL | Stock | 114.64 | 114.73 | 114.5 | 114.6 | 23232.0 |
| 2020-09-29 07:40:00 | AAPL | Stock | 114.61 | 114.66 | 114.48 | 114.59 | 31039.0 |
| 2020-09-29 07:45:00 | AAPL | Stock | 114.59 | 114.67 | 114.52 | 114.67 | 10608.0 |
| 2020-09-29 07:50:00 | AAPL | Stock | 114.68 | 114.84 | 114.65 | 114.65 | 10063.0 |
| 2020-09-29 07:55:00 | AAPL | Stock | 114.66 | 114.66 | 114.48 | 114.48 | 16469.0 |
| 2020-09-29 08:00:00 | AAPL | Stock | 115.12 | 115.2 | 114.45 | 114.55 | 281610.0 |
| 2020-09-29 08:05:00 | AAPL | Stock | 114.586 | 114.586 | 114.42 | 114.46 | 28436.0 |
| 2020-09-29 08:10:00 | AAPL | Stock | 114.47 | 114.7 | 114.46 | 114.7 | 50579.0 |
> showing 50 of 406,042 rows — these rows as CSV