PREVIEW / stock_5min / 2024-08-16
file: by_date/stock_5min/2024/2024-08-16.parquet size: 6.4 MB rows: 388,087 symbols: 843
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 |
|---|---|---|---|---|---|---|---|
| 2024-08-16 04:00:00 | AAPL | Stock | 225.61 | 225.61 | 225.38 | 225.38 | 2435.0 |
| 2024-08-16 04:05:00 | AAPL | Stock | 225.39 | 225.39 | 225.39 | 225.39 | 100.0 |
| 2024-08-16 04:10:00 | AAPL | Stock | 225.38 | 225.58 | 225.37 | 225.57 | 566.0 |
| 2024-08-16 04:15:00 | AAPL | Stock | 225.58 | 225.61 | 225.51 | 225.6 | 1188.0 |
| 2024-08-16 04:20:00 | AAPL | Stock | 225.6 | 225.6 | 225.5 | 225.5 | 1092.0 |
| 2024-08-16 04:25:00 | AAPL | Stock | 225.36 | 225.36 | 225.34 | 225.34 | 710.0 |
| 2024-08-16 04:30:00 | AAPL | Stock | 225.45 | 225.46 | 225.45 | 225.46 | 1314.0 |
| 2024-08-16 04:35:00 | AAPL | Stock | 225.45 | 225.63 | 225.45 | 225.6 | 2304.0 |
| 2024-08-16 04:40:00 | AAPL | Stock | 225.51 | 225.51 | 225.35 | 225.4 | 2987.0 |
| 2024-08-16 04:45:00 | AAPL | Stock | 225.45 | 225.5 | 225.45 | 225.5 | 3317.0 |
| 2024-08-16 04:50:00 | AAPL | Stock | 225.49 | 225.49 | 225.42 | 225.43 | 2076.0 |
| 2024-08-16 04:55:00 | AAPL | Stock | 225.42 | 225.42 | 225.3 | 225.3 | 767.0 |
| 2024-08-16 05:00:00 | AAPL | Stock | 225.38 | 225.38 | 225.31 | 225.31 | 1078.0 |
| 2024-08-16 05:05:00 | AAPL | Stock | 225.34 | 225.34 | 225.33 | 225.33 | 605.0 |
| 2024-08-16 05:10:00 | AAPL | Stock | 225.36 | 225.36 | 225.36 | 225.36 | 276.0 |
| 2024-08-16 05:15:00 | AAPL | Stock | 225.4 | 225.43 | 225.4 | 225.4 | 1640.0 |
| 2024-08-16 05:25:00 | AAPL | Stock | 225.44 | 225.44 | 225.44 | 225.44 | 100.0 |
| 2024-08-16 05:35:00 | AAPL | Stock | 225.46 | 225.46 | 225.45 | 225.45 | 310.0 |
| 2024-08-16 05:40:00 | AAPL | Stock | 225.33 | 225.34 | 225.33 | 225.34 | 1068.0 |
| 2024-08-16 05:50:00 | AAPL | Stock | 225.39 | 225.39 | 225.33 | 225.33 | 736.0 |
| 2024-08-16 05:55:00 | AAPL | Stock | 225.4 | 225.4 | 225.4 | 225.4 | 100.0 |
| 2024-08-16 06:00:00 | AAPL | Stock | 225.37 | 225.37 | 225.37 | 225.37 | 100.0 |
| 2024-08-16 06:05:00 | AAPL | Stock | 225.37 | 225.37 | 225.37 | 225.37 | 323.0 |
| 2024-08-16 06:10:00 | AAPL | Stock | 225.36 | 225.36 | 225.36 | 225.36 | 500.0 |
| 2024-08-16 06:15:00 | AAPL | Stock | 225.3 | 225.3 | 225.23 | 225.23 | 1297.0 |
| 2024-08-16 06:20:00 | AAPL | Stock | 225.3 | 225.31 | 225.3 | 225.31 | 1343.0 |
| 2024-08-16 06:25:00 | AAPL | Stock | 225.42 | 225.42 | 225.42 | 225.42 | 287.0 |
| 2024-08-16 06:30:00 | AAPL | Stock | 225.32 | 225.32 | 225.3 | 225.3 | 454.0 |
| 2024-08-16 06:40:00 | AAPL | Stock | 225.29 | 225.29 | 225.29 | 225.29 | 100.0 |
| 2024-08-16 06:45:00 | AAPL | Stock | 225.23 | 225.24 | 225.21 | 225.23 | 767.0 |
| 2024-08-16 06:50:00 | AAPL | Stock | 225.11 | 225.11 | 225.0 | 225.0 | 1916.0 |
| 2024-08-16 06:55:00 | AAPL | Stock | 225.2 | 225.2 | 225.2 | 225.2 | 500.0 |
| 2024-08-16 07:00:00 | AAPL | Stock | 225.27 | 225.39 | 225.1 | 225.18 | 6968.0 |
| 2024-08-16 07:05:00 | AAPL | Stock | 225.2 | 225.2 | 225.1 | 225.1 | 1642.0 |
| 2024-08-16 07:10:00 | AAPL | Stock | 225.09 | 225.1 | 225.09 | 225.1 | 504.0 |
| 2024-08-16 07:15:00 | AAPL | Stock | 225.0 | 225.1 | 225.0 | 225.1 | 2836.0 |
| 2024-08-16 07:20:00 | AAPL | Stock | 225.05 | 225.08 | 224.93 | 224.96 | 1134.0 |
| 2024-08-16 07:25:00 | AAPL | Stock | 224.94 | 225.02 | 224.94 | 224.95 | 1113.0 |
| 2024-08-16 07:30:00 | AAPL | Stock | 224.93 | 225.02 | 224.93 | 225.02 | 841.0 |
| 2024-08-16 07:35:00 | AAPL | Stock | 225.01 | 225.2 | 225.01 | 225.2 | 1040.0 |
| 2024-08-16 07:40:00 | AAPL | Stock | 225.16 | 225.16 | 225.08 | 225.08 | 843.0 |
| 2024-08-16 07:45:00 | AAPL | Stock | 225.08 | 225.18 | 225.06 | 225.13 | 940.0 |
| 2024-08-16 07:50:00 | AAPL | Stock | 225.15 | 225.18 | 225.13 | 225.13 | 450.0 |
| 2024-08-16 07:55:00 | AAPL | Stock | 225.01 | 225.01 | 224.9 | 224.9 | 1591.0 |
| 2024-08-16 08:00:00 | AAPL | Stock | 224.9 | 225.64 | 224.8 | 224.85 | 46158.0 |
| 2024-08-16 08:05:00 | AAPL | Stock | 224.87 | 225.0 | 224.7693 | 224.95 | 8451.0 |
| 2024-08-16 08:10:00 | AAPL | Stock | 225.03 | 225.03 | 224.57 | 224.69 | 7369.0 |
| 2024-08-16 08:15:00 | AAPL | Stock | 224.6114 | 224.67 | 224.4 | 224.4 | 9258.0 |
| 2024-08-16 08:20:00 | AAPL | Stock | 224.36 | 224.5182 | 224.3 | 224.41 | 6085.0 |
| 2024-08-16 08:25:00 | AAPL | Stock | 224.45 | 224.45 | 224.38 | 224.38 | 5446.0 |
> showing 50 of 388,087 rows — these rows as CSV