PREVIEW / stock_5min / 2021-07-22
file: by_date/stock_5min/2021/2021-07-22.parquet size: 7.1 MB rows: 439,581 symbols: 2,846
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-22 04:00:00 | AAPL | Stock | 145.64 | 145.85 | 145.64 | 145.75 | 1351.0 |
| 2021-07-22 04:05:00 | AAPL | Stock | 145.79 | 145.8 | 145.75 | 145.8 | 879.0 |
| 2021-07-22 04:10:00 | AAPL | Stock | 145.75 | 145.75 | 145.75 | 145.75 | 155.0 |
| 2021-07-22 04:15:00 | AAPL | Stock | 145.75 | 145.75 | 145.75 | 145.75 | 589.0 |
| 2021-07-22 04:20:00 | AAPL | Stock | 145.73 | 145.73 | 145.6 | 145.6 | 1202.0 |
| 2021-07-22 04:25:00 | AAPL | Stock | 145.69 | 145.69 | 145.69 | 145.69 | 298.0 |
| 2021-07-22 04:30:00 | AAPL | Stock | 145.7 | 145.7 | 145.7 | 145.7 | 137.0 |
| 2021-07-22 04:35:00 | AAPL | Stock | 145.71 | 145.71 | 145.65 | 145.65 | 459.0 |
| 2021-07-22 04:50:00 | AAPL | Stock | 145.71 | 145.71 | 145.7 | 145.7 | 970.0 |
| 2021-07-22 04:55:00 | AAPL | Stock | 145.69 | 145.69 | 145.65 | 145.65 | 477.0 |
| 2021-07-22 05:00:00 | AAPL | Stock | 145.66 | 145.66 | 145.66 | 145.66 | 100.0 |
| 2021-07-22 05:05:00 | AAPL | Stock | 145.66 | 145.66 | 145.66 | 145.66 | 100.0 |
| 2021-07-22 05:10:00 | AAPL | Stock | 145.65 | 145.65 | 145.65 | 145.65 | 697.0 |
| 2021-07-22 05:15:00 | AAPL | Stock | 145.63 | 145.65 | 145.62 | 145.62 | 673.0 |
| 2021-07-22 05:25:00 | AAPL | Stock | 145.67 | 145.79 | 145.67 | 145.79 | 526.0 |
| 2021-07-22 05:30:00 | AAPL | Stock | 145.72 | 145.72 | 145.72 | 145.72 | 600.0 |
| 2021-07-22 05:35:00 | AAPL | Stock | 145.74 | 145.74 | 145.74 | 145.74 | 223.0 |
| 2021-07-22 05:40:00 | AAPL | Stock | 145.71 | 145.71 | 145.7 | 145.7 | 1705.0 |
| 2021-07-22 05:45:00 | AAPL | Stock | 145.72 | 145.72 | 145.72 | 145.72 | 166.0 |
| 2021-07-22 05:50:00 | AAPL | Stock | 145.72 | 145.72 | 145.7 | 145.7 | 215.0 |
| 2021-07-22 06:05:00 | AAPL | Stock | 145.66 | 145.66 | 145.51 | 145.52 | 1752.0 |
| 2021-07-22 06:15:00 | AAPL | Stock | 145.58 | 145.6 | 145.58 | 145.6 | 1854.0 |
| 2021-07-22 06:20:00 | AAPL | Stock | 145.62 | 145.65 | 145.6 | 145.65 | 852.0 |
| 2021-07-22 06:25:00 | AAPL | Stock | 145.67 | 145.67 | 145.6 | 145.6 | 533.0 |
| 2021-07-22 06:45:00 | AAPL | Stock | 145.67 | 145.7 | 145.67 | 145.7 | 964.0 |
| 2021-07-22 06:55:00 | AAPL | Stock | 145.7 | 145.7 | 145.7 | 145.7 | 100.0 |
| 2021-07-22 07:00:00 | AAPL | Stock | 145.69 | 145.74 | 145.66 | 145.68 | 6199.0 |
| 2021-07-22 07:05:00 | AAPL | Stock | 145.7 | 145.75 | 145.67 | 145.69 | 7245.0 |
| 2021-07-22 07:10:00 | AAPL | Stock | 145.67 | 145.74 | 145.67 | 145.74 | 13967.0 |
| 2021-07-22 07:15:00 | AAPL | Stock | 145.73 | 145.73 | 145.69 | 145.69 | 6233.0 |
| 2021-07-22 07:20:00 | AAPL | Stock | 145.67 | 145.7 | 145.66 | 145.7 | 5945.0 |
| 2021-07-22 07:25:00 | AAPL | Stock | 145.68 | 145.7 | 145.62 | 145.631 | 7233.0 |
| 2021-07-22 07:30:00 | AAPL | Stock | 145.61 | 145.69 | 145.6 | 145.69 | 9298.0 |
| 2021-07-22 07:35:00 | AAPL | Stock | 145.68 | 145.9 | 145.55 | 145.85 | 25111.0 |
| 2021-07-22 07:40:00 | AAPL | Stock | 145.86 | 145.87 | 145.73 | 145.75 | 8950.0 |
| 2021-07-22 07:45:00 | AAPL | Stock | 145.74 | 145.87 | 145.74 | 145.77 | 9023.0 |
| 2021-07-22 07:50:00 | AAPL | Stock | 145.75 | 145.75 | 145.67 | 145.73 | 17786.0 |
| 2021-07-22 07:55:00 | AAPL | Stock | 145.74 | 145.76 | 145.68 | 145.68 | 9509.0 |
| 2021-07-22 08:00:00 | AAPL | Stock | 145.71 | 145.88 | 145.6 | 145.75 | 143804.0 |
| 2021-07-22 08:05:00 | AAPL | Stock | 145.76 | 145.83 | 145.75 | 145.77 | 15771.0 |
| 2021-07-22 08:10:00 | AAPL | Stock | 145.81 | 145.83 | 145.77 | 145.82 | 16081.0 |
| 2021-07-22 08:15:00 | AAPL | Stock | 145.8199 | 145.82 | 145.79 | 145.82 | 9439.0 |
| 2021-07-22 08:20:00 | AAPL | Stock | 145.82 | 145.9 | 145.81 | 145.86 | 15572.0 |
| 2021-07-22 08:25:00 | AAPL | Stock | 145.86 | 145.93 | 145.85 | 145.91 | 24939.0 |
| 2021-07-22 08:30:00 | AAPL | Stock | 145.91 | 145.98 | 145.82 | 145.975 | 35992.0 |
| 2021-07-22 08:35:00 | AAPL | Stock | 145.98 | 145.98 | 145.83 | 145.88 | 32186.0 |
| 2021-07-22 08:40:00 | AAPL | Stock | 145.86 | 145.96 | 145.83 | 145.9501 | 17827.0 |
| 2021-07-22 08:45:00 | AAPL | Stock | 145.95 | 146.16 | 145.92 | 146.15 | 43663.0 |
| 2021-07-22 08:50:00 | AAPL | Stock | 146.15 | 146.2 | 146.04 | 146.12 | 44485.0 |
| 2021-07-22 08:55:00 | AAPL | Stock | 146.0812 | 146.15 | 146.08 | 146.11 | 24541.0 |
> showing 50 of 439,581 rows — these rows as CSV