PREVIEW / stock_5min / 2022-07-26
file: by_date/stock_5min/2022/2022-07-26.parquet size: 6.7 MB rows: 413,873 symbols: 2,257
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-26 04:00:00 | AAPL | Stock | 153.24 | 153.24 | 152.37 | 152.6 | 4843.0 |
| 2022-07-26 04:05:00 | AAPL | Stock | 152.5 | 152.59 | 152.4 | 152.59 | 756.0 |
| 2022-07-26 04:10:00 | AAPL | Stock | 152.45 | 152.45 | 152.08 | 152.28 | 5788.0 |
| 2022-07-26 04:15:00 | AAPL | Stock | 152.35 | 152.35 | 152.35 | 152.35 | 100.0 |
| 2022-07-26 04:20:00 | AAPL | Stock | 152.35 | 152.35 | 152.35 | 152.35 | 1131.0 |
| 2022-07-26 04:25:00 | AAPL | Stock | 152.49 | 152.5 | 152.43 | 152.49 | 3554.0 |
| 2022-07-26 04:30:00 | AAPL | Stock | 152.54 | 152.55 | 152.49 | 152.55 | 2742.0 |
| 2022-07-26 04:35:00 | AAPL | Stock | 152.55 | 152.56 | 152.55 | 152.56 | 1698.0 |
| 2022-07-26 04:40:00 | AAPL | Stock | 152.6 | 152.6 | 152.6 | 152.6 | 200.0 |
| 2022-07-26 04:45:00 | AAPL | Stock | 152.54 | 152.54 | 152.54 | 152.54 | 715.0 |
| 2022-07-26 04:50:00 | AAPL | Stock | 152.51 | 152.54 | 152.44 | 152.54 | 749.0 |
| 2022-07-26 04:55:00 | AAPL | Stock | 152.55 | 152.55 | 152.55 | 152.55 | 445.0 |
| 2022-07-26 05:00:00 | AAPL | Stock | 152.65 | 152.68 | 152.65 | 152.68 | 890.0 |
| 2022-07-26 05:05:00 | AAPL | Stock | 152.67 | 152.79 | 152.65 | 152.66 | 1228.0 |
| 2022-07-26 05:15:00 | AAPL | Stock | 152.73 | 152.73 | 152.61 | 152.61 | 240.0 |
| 2022-07-26 05:20:00 | AAPL | Stock | 152.6 | 152.67 | 152.6 | 152.67 | 1381.0 |
| 2022-07-26 05:30:00 | AAPL | Stock | 152.51 | 152.51 | 152.5 | 152.5 | 2820.0 |
| 2022-07-26 05:35:00 | AAPL | Stock | 152.5 | 152.63 | 152.5 | 152.63 | 878.0 |
| 2022-07-26 05:40:00 | AAPL | Stock | 152.61 | 152.65 | 152.61 | 152.65 | 1102.0 |
| 2022-07-26 05:45:00 | AAPL | Stock | 152.68 | 152.8 | 152.68 | 152.8 | 200.0 |
| 2022-07-26 05:50:00 | AAPL | Stock | 152.83 | 152.85 | 152.77 | 152.77 | 2372.0 |
| 2022-07-26 05:55:00 | AAPL | Stock | 152.69 | 152.69 | 152.69 | 152.69 | 100.0 |
| 2022-07-26 06:00:00 | AAPL | Stock | 152.83 | 152.83 | 152.8 | 152.8 | 716.0 |
| 2022-07-26 06:05:00 | AAPL | Stock | 152.85 | 152.85 | 152.68 | 152.68 | 800.0 |
| 2022-07-26 06:10:00 | AAPL | Stock | 152.8 | 152.8 | 152.68 | 152.68 | 748.0 |
| 2022-07-26 06:15:00 | AAPL | Stock | 152.68 | 152.68 | 152.68 | 152.68 | 195.0 |
| 2022-07-26 06:20:00 | AAPL | Stock | 152.6 | 152.6 | 152.25 | 152.34 | 3075.0 |
| 2022-07-26 06:25:00 | AAPL | Stock | 152.35 | 152.39 | 152.3 | 152.39 | 10181.0 |
| 2022-07-26 06:30:00 | AAPL | Stock | 152.39 | 152.39 | 152.21 | 152.25 | 7056.0 |
| 2022-07-26 06:35:00 | AAPL | Stock | 152.25 | 152.25 | 152.13 | 152.13 | 1190.0 |
| 2022-07-26 06:40:00 | AAPL | Stock | 152.18 | 152.28 | 152.17 | 152.2 | 4678.0 |
| 2022-07-26 06:45:00 | AAPL | Stock | 152.22 | 152.29 | 152.22 | 152.29 | 1602.0 |
| 2022-07-26 06:50:00 | AAPL | Stock | 152.3 | 152.42 | 152.3 | 152.42 | 2519.0 |
| 2022-07-26 06:55:00 | AAPL | Stock | 152.4 | 152.41 | 152.39 | 152.4 | 1150.0 |
| 2022-07-26 07:00:00 | AAPL | Stock | 152.35 | 152.38 | 152.27 | 152.29 | 11902.0 |
| 2022-07-26 07:05:00 | AAPL | Stock | 152.37 | 152.42 | 152.2 | 152.2 | 5264.0 |
| 2022-07-26 07:10:00 | AAPL | Stock | 152.21 | 152.21 | 152.05 | 152.1 | 9285.0 |
| 2022-07-26 07:15:00 | AAPL | Stock | 152.14 | 152.19 | 152.01 | 152.01 | 6546.0 |
| 2022-07-26 07:20:00 | AAPL | Stock | 152.03 | 152.23 | 152.0 | 152.11 | 11753.0 |
| 2022-07-26 07:25:00 | AAPL | Stock | 152.14 | 152.3 | 152.11 | 152.26 | 4337.0 |
| 2022-07-26 07:30:00 | AAPL | Stock | 152.29 | 152.3 | 152.23 | 152.23 | 2181.0 |
| 2022-07-26 07:35:00 | AAPL | Stock | 152.24 | 152.29 | 152.2 | 152.27 | 2421.0 |
| 2022-07-26 07:40:00 | AAPL | Stock | 152.27 | 152.28 | 152.2 | 152.2 | 1880.0 |
| 2022-07-26 07:45:00 | AAPL | Stock | 152.25 | 152.44 | 152.25 | 152.44 | 6208.0 |
| 2022-07-26 07:50:00 | AAPL | Stock | 152.45 | 152.47 | 152.26 | 152.26 | 5573.0 |
| 2022-07-26 07:55:00 | AAPL | Stock | 152.26 | 152.26 | 152.11 | 152.11 | 3587.0 |
| 2022-07-26 08:00:00 | AAPL | Stock | 152.31 | 152.568 | 151.5 | 152.04 | 84644.0 |
| 2022-07-26 08:05:00 | AAPL | Stock | 152.04 | 152.1 | 152.01 | 152.03 | 23431.0 |
| 2022-07-26 08:10:00 | AAPL | Stock | 152.0307 | 152.15 | 152.0307 | 152.07 | 9891.0 |
| 2022-07-26 08:15:00 | AAPL | Stock | 152.05 | 152.11 | 151.94 | 151.98 | 15407.0 |
> showing 50 of 413,873 rows — these rows as CSV