PREVIEW / stock_5min / 2023-09-06
file: by_date/stock_5min/2023/2023-09-06.parquet size: 6.4 MB rows: 393,246 symbols: 1,428
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-09-06 04:00:00 | AAPL | Stock | 188.8 | 188.8 | 188.3 | 188.47 | 8161.0 |
| 2023-09-06 04:05:00 | AAPL | Stock | 188.61 | 188.61 | 188.5 | 188.59 | 2529.0 |
| 2023-09-06 04:10:00 | AAPL | Stock | 188.58 | 188.58 | 188.41 | 188.41 | 5702.0 |
| 2023-09-06 04:15:00 | AAPL | Stock | 188.44 | 188.44 | 188.31 | 188.31 | 1654.0 |
| 2023-09-06 04:20:00 | AAPL | Stock | 188.28 | 188.38 | 188.27 | 188.38 | 2278.0 |
| 2023-09-06 04:25:00 | AAPL | Stock | 188.37 | 188.4 | 188.37 | 188.4 | 2182.0 |
| 2023-09-06 04:30:00 | AAPL | Stock | 188.43 | 188.46 | 188.4 | 188.4 | 797.0 |
| 2023-09-06 04:35:00 | AAPL | Stock | 188.41 | 188.41 | 188.15 | 188.15 | 4976.0 |
| 2023-09-06 04:40:00 | AAPL | Stock | 188.1 | 188.24 | 188.02 | 188.24 | 4290.0 |
| 2023-09-06 04:45:00 | AAPL | Stock | 188.22 | 188.22 | 188.2 | 188.2 | 202.0 |
| 2023-09-06 04:50:00 | AAPL | Stock | 188.18 | 188.27 | 188.18 | 188.25 | 3326.0 |
| 2023-09-06 04:55:00 | AAPL | Stock | 188.29 | 188.29 | 188.2 | 188.2 | 6386.0 |
| 2023-09-06 05:00:00 | AAPL | Stock | 188.16 | 188.28 | 188.13 | 188.19 | 5107.0 |
| 2023-09-06 05:05:00 | AAPL | Stock | 188.2 | 188.25 | 188.2 | 188.25 | 639.0 |
| 2023-09-06 05:10:00 | AAPL | Stock | 188.23 | 188.23 | 188.2 | 188.2 | 8448.0 |
| 2023-09-06 05:15:00 | AAPL | Stock | 188.2 | 188.28 | 188.2 | 188.28 | 632.0 |
| 2023-09-06 05:20:00 | AAPL | Stock | 188.3 | 188.3 | 188.3 | 188.3 | 983.0 |
| 2023-09-06 05:25:00 | AAPL | Stock | 188.35 | 188.35 | 188.27 | 188.27 | 486.0 |
| 2023-09-06 05:30:00 | AAPL | Stock | 188.27 | 188.27 | 188.27 | 188.27 | 300.0 |
| 2023-09-06 05:35:00 | AAPL | Stock | 188.31 | 188.31 | 188.3 | 188.3 | 273.0 |
| 2023-09-06 05:45:00 | AAPL | Stock | 188.35 | 188.35 | 188.35 | 188.35 | 399.0 |
| 2023-09-06 05:50:00 | AAPL | Stock | 188.35 | 188.42 | 188.35 | 188.42 | 793.0 |
| 2023-09-06 05:55:00 | AAPL | Stock | 188.42 | 188.46 | 188.41 | 188.44 | 893.0 |
| 2023-09-06 06:00:00 | AAPL | Stock | 188.4 | 188.4 | 188.33 | 188.33 | 1536.0 |
| 2023-09-06 06:05:00 | AAPL | Stock | 188.32 | 188.34 | 188.32 | 188.34 | 400.0 |
| 2023-09-06 06:10:00 | AAPL | Stock | 188.36 | 188.42 | 188.35 | 188.38 | 3228.0 |
| 2023-09-06 06:15:00 | AAPL | Stock | 188.37 | 188.4 | 188.37 | 188.4 | 300.0 |
| 2023-09-06 06:20:00 | AAPL | Stock | 188.4 | 188.4 | 188.37 | 188.37 | 200.0 |
| 2023-09-06 06:25:00 | AAPL | Stock | 188.37 | 188.41 | 188.27 | 188.41 | 5010.0 |
| 2023-09-06 06:30:00 | AAPL | Stock | 188.41 | 188.46 | 188.4 | 188.46 | 2956.0 |
| 2023-09-06 06:35:00 | AAPL | Stock | 188.48 | 188.48 | 188.37 | 188.37 | 2393.0 |
| 2023-09-06 06:40:00 | AAPL | Stock | 188.37 | 188.37 | 188.34 | 188.34 | 1051.0 |
| 2023-09-06 06:45:00 | AAPL | Stock | 188.4 | 188.45 | 188.4 | 188.4 | 965.0 |
| 2023-09-06 06:50:00 | AAPL | Stock | 188.36 | 188.37 | 188.21 | 188.27 | 3918.0 |
| 2023-09-06 06:55:00 | AAPL | Stock | 188.22 | 188.38 | 188.21 | 188.38 | 2877.0 |
| 2023-09-06 07:00:00 | AAPL | Stock | 188.48 | 188.55 | 188.39 | 188.4 | 8673.0 |
| 2023-09-06 07:05:00 | AAPL | Stock | 188.41 | 188.48 | 188.4 | 188.48 | 7496.0 |
| 2023-09-06 07:10:00 | AAPL | Stock | 188.51 | 188.68 | 188.51 | 188.65 | 5062.0 |
| 2023-09-06 07:15:00 | AAPL | Stock | 188.68 | 188.7 | 188.62 | 188.67 | 6316.0 |
| 2023-09-06 07:20:00 | AAPL | Stock | 188.72 | 188.78 | 188.7 | 188.73 | 5340.0 |
| 2023-09-06 07:25:00 | AAPL | Stock | 188.74 | 188.74 | 188.6 | 188.7 | 5057.0 |
| 2023-09-06 07:30:00 | AAPL | Stock | 188.71 | 188.74 | 188.61 | 188.61 | 3979.0 |
| 2023-09-06 07:35:00 | AAPL | Stock | 188.65 | 188.8 | 188.65 | 188.8 | 818.0 |
| 2023-09-06 07:40:00 | AAPL | Stock | 188.82 | 188.82 | 188.54 | 188.55 | 5873.0 |
| 2023-09-06 07:45:00 | AAPL | Stock | 188.57 | 188.57 | 188.46 | 188.5 | 17612.0 |
| 2023-09-06 07:50:00 | AAPL | Stock | 188.47 | 188.47 | 188.41 | 188.42 | 5582.0 |
| 2023-09-06 07:55:00 | AAPL | Stock | 188.41 | 188.5 | 188.38 | 188.5 | 6570.0 |
| 2023-09-06 08:00:00 | AAPL | Stock | 188.46 | 189.5 | 188.15 | 188.4 | 77036.0 |
| 2023-09-06 08:05:00 | AAPL | Stock | 188.39 | 188.5 | 188.39 | 188.5 | 6074.0 |
| 2023-09-06 08:10:00 | AAPL | Stock | 188.5 | 188.5 | 188.4 | 188.42 | 4064.0 |
> showing 50 of 393,246 rows — these rows as CSV