PREVIEW / stock_5min / 2021-01-26
file: by_date/stock_5min/2021/2021-01-26.parquet size: 8.0 MB rows: 500,369 symbols: 2,723
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-01-26 04:00:00 | AAPL | Stock | 142.91 | 142.92 | 142.8 | 142.86 | 7549.0 |
| 2021-01-26 04:05:00 | AAPL | Stock | 142.97 | 143.2 | 142.97 | 142.99 | 6977.0 |
| 2021-01-26 04:10:00 | AAPL | Stock | 142.91 | 142.91 | 142.88 | 142.89 | 3676.0 |
| 2021-01-26 04:15:00 | AAPL | Stock | 142.98 | 143.01 | 142.96 | 142.96 | 1304.0 |
| 2021-01-26 04:20:00 | AAPL | Stock | 143.1 | 143.24 | 143.1 | 143.2 | 2960.0 |
| 2021-01-26 04:25:00 | AAPL | Stock | 143.28 | 143.28 | 143.15 | 143.19 | 3850.0 |
| 2021-01-26 04:30:00 | AAPL | Stock | 143.2 | 143.2 | 143.03 | 143.05 | 2130.0 |
| 2021-01-26 04:35:00 | AAPL | Stock | 143.02 | 143.02 | 142.78 | 142.89 | 3127.0 |
| 2021-01-26 04:40:00 | AAPL | Stock | 142.83 | 142.85 | 142.74 | 142.85 | 1715.0 |
| 2021-01-26 04:45:00 | AAPL | Stock | 142.79 | 142.79 | 142.74 | 142.79 | 795.0 |
| 2021-01-26 04:50:00 | AAPL | Stock | 142.77 | 142.82 | 142.75 | 142.75 | 3523.0 |
| 2021-01-26 04:55:00 | AAPL | Stock | 142.73 | 142.73 | 142.68 | 142.68 | 707.0 |
| 2021-01-26 05:00:00 | AAPL | Stock | 142.78 | 142.89 | 142.78 | 142.89 | 1258.0 |
| 2021-01-26 05:05:00 | AAPL | Stock | 142.92 | 143.0 | 142.9 | 143.0 | 4823.0 |
| 2021-01-26 05:10:00 | AAPL | Stock | 142.96 | 143.1 | 142.96 | 143.05 | 1434.0 |
| 2021-01-26 05:15:00 | AAPL | Stock | 143.05 | 143.1 | 143.05 | 143.1 | 215.0 |
| 2021-01-26 05:20:00 | AAPL | Stock | 143.0 | 143.1 | 142.96 | 142.96 | 2797.0 |
| 2021-01-26 05:25:00 | AAPL | Stock | 142.94 | 142.95 | 142.85 | 142.85 | 2360.0 |
| 2021-01-26 05:30:00 | AAPL | Stock | 142.94 | 142.94 | 142.9 | 142.9 | 1615.0 |
| 2021-01-26 05:35:00 | AAPL | Stock | 142.95 | 143.0 | 142.95 | 143.0 | 515.0 |
| 2021-01-26 05:40:00 | AAPL | Stock | 142.99 | 142.99 | 142.94 | 142.95 | 950.0 |
| 2021-01-26 05:45:00 | AAPL | Stock | 142.95 | 142.95 | 142.93 | 142.93 | 400.0 |
| 2021-01-26 05:50:00 | AAPL | Stock | 142.96 | 143.0 | 142.9 | 142.95 | 4227.0 |
| 2021-01-26 05:55:00 | AAPL | Stock | 143.1 | 143.12 | 143.1 | 143.12 | 1666.0 |
| 2021-01-26 06:00:00 | AAPL | Stock | 143.13 | 143.13 | 143.13 | 143.13 | 1099.0 |
| 2021-01-26 06:05:00 | AAPL | Stock | 143.11 | 143.13 | 143.0 | 143.0 | 2997.0 |
| 2021-01-26 06:10:00 | AAPL | Stock | 143.09 | 143.13 | 143.09 | 143.13 | 3197.0 |
| 2021-01-26 06:15:00 | AAPL | Stock | 143.17 | 143.2 | 143.17 | 143.2 | 590.0 |
| 2021-01-26 06:20:00 | AAPL | Stock | 143.2 | 143.25 | 143.17 | 143.21 | 2713.0 |
| 2021-01-26 06:25:00 | AAPL | Stock | 143.25 | 143.3 | 143.1 | 143.21 | 5100.0 |
| 2021-01-26 06:30:00 | AAPL | Stock | 143.23 | 143.23 | 143.05 | 143.05 | 2430.0 |
| 2021-01-26 06:35:00 | AAPL | Stock | 143.01 | 143.2 | 143.01 | 143.1 | 6569.0 |
| 2021-01-26 06:40:00 | AAPL | Stock | 143.24 | 143.34 | 143.2 | 143.34 | 3457.0 |
| 2021-01-26 06:45:00 | AAPL | Stock | 143.34 | 143.45 | 143.34 | 143.4 | 4543.0 |
| 2021-01-26 06:50:00 | AAPL | Stock | 143.4 | 143.5 | 143.35 | 143.35 | 6114.0 |
| 2021-01-26 06:55:00 | AAPL | Stock | 143.35 | 143.42 | 143.2 | 143.23 | 9453.0 |
| 2021-01-26 07:00:00 | AAPL | Stock | 143.25 | 143.58 | 143.15 | 143.38 | 79319.0 |
| 2021-01-26 07:05:00 | AAPL | Stock | 143.38 | 143.77 | 143.38 | 143.65 | 49750.0 |
| 2021-01-26 07:10:00 | AAPL | Stock | 143.69 | 143.77 | 143.65 | 143.72 | 42859.0 |
| 2021-01-26 07:15:00 | AAPL | Stock | 143.72 | 143.72 | 143.38 | 143.55 | 46670.0 |
| 2021-01-26 07:20:00 | AAPL | Stock | 143.55 | 143.69 | 143.45 | 143.65 | 24203.0 |
| 2021-01-26 07:25:00 | AAPL | Stock | 143.699 | 143.7 | 143.57 | 143.64 | 20209.0 |
| 2021-01-26 07:30:00 | AAPL | Stock | 143.65 | 143.65 | 143.42 | 143.57 | 42394.0 |
| 2021-01-26 07:35:00 | AAPL | Stock | 143.59 | 143.6 | 143.5 | 143.58 | 14129.0 |
| 2021-01-26 07:40:00 | AAPL | Stock | 143.58 | 143.62 | 143.5 | 143.61 | 30378.0 |
| 2021-01-26 07:45:00 | AAPL | Stock | 143.6 | 143.6 | 143.4 | 143.44 | 16310.0 |
| 2021-01-26 07:50:00 | AAPL | Stock | 143.43 | 143.43 | 143.26 | 143.35 | 55577.0 |
| 2021-01-26 07:55:00 | AAPL | Stock | 143.34 | 143.35 | 143.26 | 143.26 | 13167.0 |
| 2021-01-26 08:00:00 | AAPL | Stock | 142.92 | 143.77 | 142.57 | 143.25 | 192241.0 |
| 2021-01-26 08:05:00 | AAPL | Stock | 143.25 | 143.5 | 143.21 | 143.44 | 81197.0 |
> showing 50 of 500,369 rows — these rows as CSV