PREVIEW / stock_5min / 2023-05-04
file: by_date/stock_5min/2023/2023-05-04.parquet size: 6.9 MB rows: 423,917 symbols: 1,657
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 |
|---|---|---|---|---|---|---|---|
| 2023-05-04 04:00:00 | AAPL | Stock | 166.02 | 166.44 | 165.9 | 165.91 | 11670.0 |
| 2023-05-04 04:05:00 | AAPL | Stock | 165.9 | 165.9 | 165.71 | 165.72 | 6657.0 |
| 2023-05-04 04:10:00 | AAPL | Stock | 165.65 | 165.69 | 165.5 | 165.65 | 12132.0 |
| 2023-05-04 04:15:00 | AAPL | Stock | 165.65 | 165.75 | 165.65 | 165.75 | 4370.0 |
| 2023-05-04 04:20:00 | AAPL | Stock | 165.81 | 165.81 | 165.75 | 165.8 | 1904.0 |
| 2023-05-04 04:25:00 | AAPL | Stock | 165.8 | 165.8 | 165.35 | 165.36 | 6489.0 |
| 2023-05-04 04:30:00 | AAPL | Stock | 165.43 | 165.43 | 165.34 | 165.36 | 4181.0 |
| 2023-05-04 04:35:00 | AAPL | Stock | 165.3 | 165.34 | 165.15 | 165.25 | 7650.0 |
| 2023-05-04 04:40:00 | AAPL | Stock | 165.32 | 165.48 | 165.29 | 165.48 | 4800.0 |
| 2023-05-04 04:45:00 | AAPL | Stock | 165.5 | 165.6 | 165.4 | 165.4 | 1799.0 |
| 2023-05-04 04:50:00 | AAPL | Stock | 165.36 | 165.5 | 165.23 | 165.5 | 1963.0 |
| 2023-05-04 04:55:00 | AAPL | Stock | 165.5 | 165.5 | 165.4 | 165.4 | 682.0 |
| 2023-05-04 05:00:00 | AAPL | Stock | 165.5 | 165.62 | 165.5 | 165.57 | 1400.0 |
| 2023-05-04 05:05:00 | AAPL | Stock | 165.58 | 165.6 | 165.51 | 165.6 | 1310.0 |
| 2023-05-04 05:10:00 | AAPL | Stock | 165.64 | 165.64 | 165.58 | 165.58 | 571.0 |
| 2023-05-04 05:15:00 | AAPL | Stock | 165.55 | 165.55 | 165.5 | 165.5 | 1256.0 |
| 2023-05-04 05:25:00 | AAPL | Stock | 165.63 | 165.64 | 165.6 | 165.6 | 516.0 |
| 2023-05-04 05:30:00 | AAPL | Stock | 165.54 | 165.54 | 165.2 | 165.4 | 3133.0 |
| 2023-05-04 05:35:00 | AAPL | Stock | 165.4 | 165.5 | 165.4 | 165.5 | 3245.0 |
| 2023-05-04 05:40:00 | AAPL | Stock | 165.55 | 165.64 | 165.5 | 165.64 | 2016.0 |
| 2023-05-04 05:45:00 | AAPL | Stock | 165.6 | 165.6 | 165.36 | 165.36 | 4441.0 |
| 2023-05-04 05:50:00 | AAPL | Stock | 165.48 | 165.5 | 165.41 | 165.41 | 923.0 |
| 2023-05-04 06:00:00 | AAPL | Stock | 165.5 | 165.5 | 165.41 | 165.41 | 306.0 |
| 2023-05-04 06:05:00 | AAPL | Stock | 165.35 | 165.37 | 165.32 | 165.36 | 1338.0 |
| 2023-05-04 06:10:00 | AAPL | Stock | 165.39 | 165.41 | 165.36 | 165.41 | 835.0 |
| 2023-05-04 06:15:00 | AAPL | Stock | 165.51 | 165.64 | 165.51 | 165.64 | 1820.0 |
| 2023-05-04 06:20:00 | AAPL | Stock | 165.7 | 165.7 | 165.65 | 165.65 | 454.0 |
| 2023-05-04 06:25:00 | AAPL | Stock | 165.77 | 165.9 | 165.76 | 165.9 | 3975.0 |
| 2023-05-04 06:30:00 | AAPL | Stock | 165.91 | 166.16 | 165.88 | 166.16 | 9146.0 |
| 2023-05-04 06:35:00 | AAPL | Stock | 166.04 | 166.07 | 165.72 | 165.72 | 7453.0 |
| 2023-05-04 06:40:00 | AAPL | Stock | 165.8 | 165.81 | 165.72 | 165.8 | 2193.0 |
| 2023-05-04 06:45:00 | AAPL | Stock | 165.72 | 165.79 | 165.61 | 165.64 | 2664.0 |
| 2023-05-04 06:50:00 | AAPL | Stock | 165.63 | 165.77 | 165.58 | 165.6 | 5379.0 |
| 2023-05-04 06:55:00 | AAPL | Stock | 165.59 | 165.6 | 165.5 | 165.5 | 2979.0 |
| 2023-05-04 07:00:00 | AAPL | Stock | 165.52 | 165.57 | 165.43 | 165.43 | 10516.0 |
| 2023-05-04 07:05:00 | AAPL | Stock | 165.46 | 165.5 | 165.38 | 165.38 | 3607.0 |
| 2023-05-04 07:10:00 | AAPL | Stock | 165.33 | 165.35 | 165.25 | 165.35 | 5900.0 |
| 2023-05-04 07:15:00 | AAPL | Stock | 165.32 | 165.37 | 165.17 | 165.2 | 13354.0 |
| 2023-05-04 07:20:00 | AAPL | Stock | 165.15 | 165.15 | 164.8 | 164.95 | 31179.0 |
| 2023-05-04 07:25:00 | AAPL | Stock | 164.97 | 165.15 | 164.9 | 165.15 | 11752.0 |
| 2023-05-04 07:30:00 | AAPL | Stock | 165.15 | 165.29 | 165.15 | 165.29 | 8317.0 |
| 2023-05-04 07:35:00 | AAPL | Stock | 165.28 | 165.32 | 165.27 | 165.28 | 4992.0 |
| 2023-05-04 07:40:00 | AAPL | Stock | 165.28 | 165.28 | 164.94 | 164.99 | 16358.0 |
| 2023-05-04 07:45:00 | AAPL | Stock | 164.96 | 165.1 | 164.86 | 165.07 | 6922.0 |
| 2023-05-04 07:50:00 | AAPL | Stock | 165.09 | 165.13 | 165.0 | 165.05 | 6943.0 |
| 2023-05-04 07:55:00 | AAPL | Stock | 165.05 | 165.2 | 165.04 | 165.15 | 2383.0 |
| 2023-05-04 08:00:00 | AAPL | Stock | 165.399 | 166.62 | 164.83 | 165.1 | 122585.0 |
| 2023-05-04 08:05:00 | AAPL | Stock | 165.1099 | 165.16 | 164.95 | 165.0 | 14893.0 |
| 2023-05-04 08:10:00 | AAPL | Stock | 165.0 | 165.01 | 164.75 | 164.7506 | 29843.0 |
| 2023-05-04 08:15:00 | AAPL | Stock | 164.75 | 164.85 | 164.48 | 164.56 | 31019.0 |
> showing 50 of 423,917 rows — these rows as CSV