PREVIEW / stock_5min / 2021-07-01
file: by_date/stock_5min/2021/2021-07-01.parquet size: 7.6 MB rows: 467,330 symbols: 2,949
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 |
|---|---|---|---|---|---|---|---|
| 2021-07-01 04:00:00 | AAPL | Stock | 137.27 | 137.35 | 137.27 | 137.35 | 1250.0 |
| 2021-07-01 04:05:00 | AAPL | Stock | 137.35 | 137.35 | 137.2 | 137.21 | 11049.0 |
| 2021-07-01 04:10:00 | AAPL | Stock | 137.1 | 137.14 | 137.1 | 137.14 | 300.0 |
| 2021-07-01 04:15:00 | AAPL | Stock | 137.05 | 137.05 | 137.0 | 137.0 | 1601.0 |
| 2021-07-01 04:25:00 | AAPL | Stock | 136.98 | 137.04 | 136.98 | 137.04 | 875.0 |
| 2021-07-01 04:30:00 | AAPL | Stock | 137.0 | 137.05 | 137.0 | 137.05 | 520.0 |
| 2021-07-01 04:35:00 | AAPL | Stock | 137.05 | 137.1 | 137.05 | 137.1 | 472.0 |
| 2021-07-01 04:40:00 | AAPL | Stock | 137.13 | 137.13 | 137.13 | 137.13 | 247.0 |
| 2021-07-01 04:45:00 | AAPL | Stock | 137.1 | 137.1 | 137.06 | 137.06 | 784.0 |
| 2021-07-01 05:00:00 | AAPL | Stock | 136.98 | 136.98 | 136.98 | 136.98 | 600.0 |
| 2021-07-01 05:05:00 | AAPL | Stock | 136.93 | 136.93 | 136.89 | 136.89 | 773.0 |
| 2021-07-01 05:10:00 | AAPL | Stock | 136.9 | 136.97 | 136.9 | 136.97 | 262.0 |
| 2021-07-01 05:15:00 | AAPL | Stock | 136.9 | 136.9 | 136.9 | 136.9 | 143.0 |
| 2021-07-01 05:20:00 | AAPL | Stock | 136.82 | 136.82 | 136.82 | 136.82 | 100.0 |
| 2021-07-01 05:35:00 | AAPL | Stock | 136.84 | 136.86 | 136.84 | 136.86 | 1206.0 |
| 2021-07-01 05:40:00 | AAPL | Stock | 136.86 | 136.86 | 136.78 | 136.84 | 3444.0 |
| 2021-07-01 05:45:00 | AAPL | Stock | 136.83 | 136.83 | 136.79 | 136.79 | 2115.0 |
| 2021-07-01 05:50:00 | AAPL | Stock | 136.8 | 136.8 | 136.76 | 136.76 | 310.0 |
| 2021-07-01 06:00:00 | AAPL | Stock | 136.81 | 136.81 | 136.78 | 136.78 | 252.0 |
| 2021-07-01 06:10:00 | AAPL | Stock | 136.8 | 136.84 | 136.8 | 136.84 | 3873.0 |
| 2021-07-01 06:15:00 | AAPL | Stock | 136.85 | 136.85 | 136.72 | 136.76 | 6270.0 |
| 2021-07-01 06:20:00 | AAPL | Stock | 136.72 | 136.74 | 136.7 | 136.7 | 1345.0 |
| 2021-07-01 06:25:00 | AAPL | Stock | 136.67 | 136.67 | 136.64 | 136.64 | 849.0 |
| 2021-07-01 06:30:00 | AAPL | Stock | 136.66 | 136.66 | 136.6 | 136.6 | 2010.0 |
| 2021-07-01 06:35:00 | AAPL | Stock | 136.61 | 136.69 | 136.6 | 136.69 | 3242.0 |
| 2021-07-01 06:40:00 | AAPL | Stock | 136.65 | 136.65 | 136.6 | 136.6 | 1711.0 |
| 2021-07-01 06:45:00 | AAPL | Stock | 136.6 | 136.6 | 136.6 | 136.6 | 929.0 |
| 2021-07-01 06:50:00 | AAPL | Stock | 136.55 | 136.55 | 136.51 | 136.51 | 1557.0 |
| 2021-07-01 06:55:00 | AAPL | Stock | 136.51 | 136.51 | 136.48 | 136.51 | 1468.0 |
| 2021-07-01 07:00:00 | AAPL | Stock | 136.59 | 136.7 | 136.51 | 136.67 | 17235.0 |
| 2021-07-01 07:05:00 | AAPL | Stock | 136.67 | 136.72 | 136.61 | 136.69 | 3318.0 |
| 2021-07-01 07:10:00 | AAPL | Stock | 136.7 | 136.74 | 136.69 | 136.69 | 6830.0 |
| 2021-07-01 07:15:00 | AAPL | Stock | 136.69 | 136.73 | 136.69 | 136.73 | 3304.0 |
| 2021-07-01 07:20:00 | AAPL | Stock | 136.72 | 136.73 | 136.67 | 136.67 | 3475.0 |
| 2021-07-01 07:25:00 | AAPL | Stock | 136.69 | 136.75 | 136.69 | 136.74 | 1080.0 |
| 2021-07-01 07:30:00 | AAPL | Stock | 136.74 | 136.83 | 136.74 | 136.77 | 10918.0 |
| 2021-07-01 07:35:00 | AAPL | Stock | 136.76 | 136.8 | 136.75 | 136.8 | 6574.0 |
| 2021-07-01 07:40:00 | AAPL | Stock | 136.82 | 136.86 | 136.8 | 136.86 | 2624.0 |
| 2021-07-01 07:45:00 | AAPL | Stock | 136.86 | 136.96 | 136.85 | 136.9 | 13596.0 |
| 2021-07-01 07:50:00 | AAPL | Stock | 136.9 | 136.92 | 136.86 | 136.86 | 6558.0 |
| 2021-07-01 07:55:00 | AAPL | Stock | 136.869 | 136.94 | 136.84 | 136.94 | 3215.0 |
| 2021-07-01 08:00:00 | AAPL | Stock | 136.95 | 137.01 | 136.61 | 137.01 | 110143.0 |
| 2021-07-01 08:05:00 | AAPL | Stock | 136.98 | 137.05 | 136.618 | 136.97 | 27093.0 |
| 2021-07-01 08:10:00 | AAPL | Stock | 136.971 | 137.0 | 136.95 | 136.97 | 8879.0 |
| 2021-07-01 08:15:00 | AAPL | Stock | 136.96 | 136.96 | 136.9 | 136.92 | 5939.0 |
| 2021-07-01 08:20:00 | AAPL | Stock | 136.91 | 136.92 | 136.81 | 136.88 | 30467.0 |
| 2021-07-01 08:25:00 | AAPL | Stock | 136.82 | 136.89 | 136.8 | 136.8 | 13220.0 |
| 2021-07-01 08:30:00 | AAPL | Stock | 136.83 | 136.95 | 136.79 | 136.94 | 20052.0 |
| 2021-07-01 08:35:00 | AAPL | Stock | 136.94 | 136.96 | 136.9 | 136.9 | 19718.0 |
| 2021-07-01 08:40:00 | AAPL | Stock | 136.9 | 136.91 | 136.81 | 136.82 | 4866.0 |
> showing 50 of 467,330 rows — these rows as CSV