PREVIEW / stock_5min / 2023-07-11
file: by_date/stock_5min/2023/2023-07-11.parquet size: 6.7 MB rows: 409,590 symbols: 1,561
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-07-11 04:00:00 | AAPL | Stock | 188.8 | 188.85 | 188.75 | 188.75 | 329.0 |
| 2023-07-11 04:05:00 | AAPL | Stock | 188.74 | 189.0 | 188.74 | 188.97 | 1514.0 |
| 2023-07-11 04:10:00 | AAPL | Stock | 188.98 | 188.98 | 188.93 | 188.95 | 8783.0 |
| 2023-07-11 04:15:00 | AAPL | Stock | 188.85 | 188.9 | 188.85 | 188.9 | 1527.0 |
| 2023-07-11 04:20:00 | AAPL | Stock | 188.88 | 188.88 | 188.88 | 188.88 | 200.0 |
| 2023-07-11 04:25:00 | AAPL | Stock | 188.9 | 188.9 | 188.87 | 188.88 | 587.0 |
| 2023-07-11 04:30:00 | AAPL | Stock | 188.83 | 188.83 | 188.75 | 188.75 | 2035.0 |
| 2023-07-11 04:35:00 | AAPL | Stock | 188.75 | 188.75 | 188.74 | 188.74 | 493.0 |
| 2023-07-11 04:40:00 | AAPL | Stock | 188.71 | 188.71 | 188.6 | 188.6 | 3690.0 |
| 2023-07-11 04:45:00 | AAPL | Stock | 188.55 | 188.58 | 188.55 | 188.58 | 1075.0 |
| 2023-07-11 04:50:00 | AAPL | Stock | 188.61 | 188.61 | 188.6 | 188.61 | 1032.0 |
| 2023-07-11 05:05:00 | AAPL | Stock | 188.78 | 188.79 | 188.78 | 188.79 | 2371.0 |
| 2023-07-11 05:15:00 | AAPL | Stock | 188.79 | 188.79 | 188.79 | 188.79 | 4765.0 |
| 2023-07-11 05:20:00 | AAPL | Stock | 188.83 | 188.83 | 188.83 | 188.83 | 350.0 |
| 2023-07-11 05:25:00 | AAPL | Stock | 188.81 | 188.81 | 188.81 | 188.81 | 124.0 |
| 2023-07-11 05:30:00 | AAPL | Stock | 188.86 | 188.87 | 188.86 | 188.87 | 516.0 |
| 2023-07-11 05:35:00 | AAPL | Stock | 188.94 | 189.0 | 188.94 | 189.0 | 5360.0 |
| 2023-07-11 05:40:00 | AAPL | Stock | 188.98 | 189.0 | 188.98 | 189.0 | 469.0 |
| 2023-07-11 05:45:00 | AAPL | Stock | 189.06 | 189.08 | 189.06 | 189.08 | 1332.0 |
| 2023-07-11 05:50:00 | AAPL | Stock | 189.08 | 189.27 | 189.08 | 189.27 | 6211.0 |
| 2023-07-11 05:55:00 | AAPL | Stock | 189.26 | 189.37 | 189.26 | 189.37 | 1160.0 |
| 2023-07-11 06:00:00 | AAPL | Stock | 189.2 | 189.2 | 189.2 | 189.2 | 225.0 |
| 2023-07-11 06:05:00 | AAPL | Stock | 189.28 | 189.29 | 189.22 | 189.22 | 1574.0 |
| 2023-07-11 06:10:00 | AAPL | Stock | 189.1 | 189.3 | 189.1 | 189.27 | 2107.0 |
| 2023-07-11 06:20:00 | AAPL | Stock | 189.12 | 189.12 | 189.09 | 189.09 | 200.0 |
| 2023-07-11 06:25:00 | AAPL | Stock | 189.12 | 189.24 | 189.12 | 189.21 | 1435.0 |
| 2023-07-11 06:30:00 | AAPL | Stock | 189.12 | 189.13 | 189.1 | 189.1 | 1366.0 |
| 2023-07-11 06:35:00 | AAPL | Stock | 189.12 | 189.12 | 189.12 | 189.12 | 100.0 |
| 2023-07-11 06:40:00 | AAPL | Stock | 189.15 | 189.16 | 189.1 | 189.1 | 1943.0 |
| 2023-07-11 06:45:00 | AAPL | Stock | 189.11 | 189.11 | 189.01 | 189.01 | 403.0 |
| 2023-07-11 06:50:00 | AAPL | Stock | 188.92 | 188.92 | 188.91 | 188.92 | 480.0 |
| 2023-07-11 06:55:00 | AAPL | Stock | 188.96 | 188.96 | 188.92 | 188.92 | 651.0 |
| 2023-07-11 07:00:00 | AAPL | Stock | 189.0 | 189.14 | 189.0 | 189.14 | 1602.0 |
| 2023-07-11 07:05:00 | AAPL | Stock | 189.18 | 189.25 | 189.17 | 189.25 | 3704.0 |
| 2023-07-11 07:10:00 | AAPL | Stock | 189.24 | 189.31 | 189.24 | 189.3 | 7710.0 |
| 2023-07-11 07:15:00 | AAPL | Stock | 189.31 | 189.31 | 189.31 | 189.31 | 582.0 |
| 2023-07-11 07:20:00 | AAPL | Stock | 189.28 | 189.36 | 189.27 | 189.36 | 1978.0 |
| 2023-07-11 07:25:00 | AAPL | Stock | 189.29 | 189.29 | 189.29 | 189.29 | 233.0 |
| 2023-07-11 07:30:00 | AAPL | Stock | 189.29 | 189.5 | 189.29 | 189.49 | 12964.0 |
| 2023-07-11 07:35:00 | AAPL | Stock | 189.45 | 189.45 | 189.4 | 189.4 | 2367.0 |
| 2023-07-11 07:40:00 | AAPL | Stock | 189.42 | 189.45 | 189.3 | 189.45 | 3454.0 |
| 2023-07-11 07:45:00 | AAPL | Stock | 189.45 | 189.51 | 189.45 | 189.51 | 1087.0 |
| 2023-07-11 07:50:00 | AAPL | Stock | 189.52 | 189.54 | 189.52 | 189.53 | 2326.0 |
| 2023-07-11 07:55:00 | AAPL | Stock | 189.49 | 189.49 | 189.4 | 189.44 | 1911.0 |
| 2023-07-11 08:00:00 | AAPL | Stock | 189.1 | 189.96 | 188.63 | 189.49 | 44690.0 |
| 2023-07-11 08:05:00 | AAPL | Stock | 189.45 | 189.45 | 189.32 | 189.32 | 5731.0 |
| 2023-07-11 08:10:00 | AAPL | Stock | 189.3 | 189.4197 | 189.29 | 189.35 | 5529.0 |
| 2023-07-11 08:15:00 | AAPL | Stock | 189.35 | 189.38 | 189.25 | 189.25 | 7644.0 |
| 2023-07-11 08:20:00 | AAPL | Stock | 189.29 | 189.41 | 189.25 | 189.35 | 10148.0 |
| 2023-07-11 08:25:00 | AAPL | Stock | 189.44 | 189.46 | 189.3813 | 189.46 | 3786.0 |
> showing 50 of 409,590 rows — these rows as CSV