PREVIEW / stock_5min / 2023-05-25
file: by_date/stock_5min/2023/2023-05-25.parquet size: 6.7 MB rows: 413,572 symbols: 1,671
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-25 04:00:00 | AAPL | Stock | 171.37 | 171.65 | 171.37 | 171.65 | 9660.0 |
| 2023-05-25 04:05:00 | AAPL | Stock | 171.64 | 171.8 | 171.62 | 171.8 | 5800.0 |
| 2023-05-25 04:10:00 | AAPL | Stock | 171.58 | 171.75 | 171.58 | 171.61 | 2143.0 |
| 2023-05-25 04:15:00 | AAPL | Stock | 171.61 | 171.75 | 171.61 | 171.7 | 4983.0 |
| 2023-05-25 04:20:00 | AAPL | Stock | 171.62 | 171.74 | 171.6 | 171.61 | 2275.0 |
| 2023-05-25 04:25:00 | AAPL | Stock | 171.58 | 171.65 | 171.58 | 171.58 | 2527.0 |
| 2023-05-25 04:35:00 | AAPL | Stock | 171.6 | 171.6 | 171.41 | 171.47 | 692.0 |
| 2023-05-25 04:40:00 | AAPL | Stock | 171.5 | 171.54 | 171.5 | 171.53 | 3818.0 |
| 2023-05-25 04:45:00 | AAPL | Stock | 171.58 | 171.58 | 171.55 | 171.55 | 320.0 |
| 2023-05-25 04:50:00 | AAPL | Stock | 171.54 | 171.71 | 171.53 | 171.64 | 3266.0 |
| 2023-05-25 04:55:00 | AAPL | Stock | 171.59 | 171.64 | 171.59 | 171.64 | 1587.0 |
| 2023-05-25 05:00:00 | AAPL | Stock | 171.72 | 171.74 | 171.65 | 171.7 | 3496.0 |
| 2023-05-25 05:05:00 | AAPL | Stock | 171.7 | 171.75 | 171.63 | 171.75 | 4469.0 |
| 2023-05-25 05:10:00 | AAPL | Stock | 171.55 | 171.61 | 171.52 | 171.61 | 1140.0 |
| 2023-05-25 05:15:00 | AAPL | Stock | 171.62 | 171.62 | 171.56 | 171.56 | 2041.0 |
| 2023-05-25 05:20:00 | AAPL | Stock | 171.57 | 171.59 | 171.55 | 171.59 | 1110.0 |
| 2023-05-25 05:25:00 | AAPL | Stock | 171.54 | 171.54 | 171.54 | 171.54 | 150.0 |
| 2023-05-25 05:30:00 | AAPL | Stock | 171.53 | 171.55 | 171.53 | 171.53 | 1109.0 |
| 2023-05-25 05:35:00 | AAPL | Stock | 171.58 | 171.58 | 171.58 | 171.58 | 100.0 |
| 2023-05-25 05:40:00 | AAPL | Stock | 171.58 | 171.58 | 171.54 | 171.54 | 649.0 |
| 2023-05-25 05:45:00 | AAPL | Stock | 171.55 | 171.58 | 171.55 | 171.58 | 300.0 |
| 2023-05-25 05:50:00 | AAPL | Stock | 171.62 | 171.68 | 171.62 | 171.65 | 2927.0 |
| 2023-05-25 05:55:00 | AAPL | Stock | 171.65 | 171.65 | 171.63 | 171.65 | 725.0 |
| 2023-05-25 06:00:00 | AAPL | Stock | 171.59 | 171.65 | 171.59 | 171.64 | 1631.0 |
| 2023-05-25 06:05:00 | AAPL | Stock | 171.63 | 171.63 | 171.63 | 171.63 | 100.0 |
| 2023-05-25 06:10:00 | AAPL | Stock | 171.62 | 171.68 | 171.6 | 171.6 | 6551.0 |
| 2023-05-25 06:15:00 | AAPL | Stock | 171.62 | 171.65 | 171.6 | 171.65 | 2701.0 |
| 2023-05-25 06:20:00 | AAPL | Stock | 171.63 | 171.63 | 171.5 | 171.5 | 1706.0 |
| 2023-05-25 06:25:00 | AAPL | Stock | 171.62 | 171.65 | 171.51 | 171.59 | 1933.0 |
| 2023-05-25 06:30:00 | AAPL | Stock | 171.54 | 171.54 | 171.3 | 171.39 | 1602.0 |
| 2023-05-25 06:35:00 | AAPL | Stock | 171.31 | 171.37 | 171.28 | 171.28 | 4303.0 |
| 2023-05-25 06:40:00 | AAPL | Stock | 171.23 | 171.25 | 171.08 | 171.25 | 4231.0 |
| 2023-05-25 06:45:00 | AAPL | Stock | 171.25 | 171.25 | 171.1 | 171.1 | 623.0 |
| 2023-05-25 06:50:00 | AAPL | Stock | 171.13 | 171.16 | 171.09 | 171.16 | 8109.0 |
| 2023-05-25 06:55:00 | AAPL | Stock | 171.16 | 171.18 | 171.12 | 171.13 | 6080.0 |
| 2023-05-25 07:00:00 | AAPL | Stock | 171.16 | 171.16 | 171.07 | 171.14 | 10427.0 |
| 2023-05-25 07:05:00 | AAPL | Stock | 171.15 | 171.2 | 171.07 | 171.2 | 8223.0 |
| 2023-05-25 07:10:00 | AAPL | Stock | 171.2 | 171.2 | 171.12 | 171.12 | 16755.0 |
| 2023-05-25 07:15:00 | AAPL | Stock | 171.19 | 171.19 | 171.01 | 171.01 | 12225.0 |
| 2023-05-25 07:20:00 | AAPL | Stock | 171.01 | 171.05 | 170.8 | 170.85 | 24009.0 |
| 2023-05-25 07:25:00 | AAPL | Stock | 170.82 | 171.0 | 170.76 | 170.92 | 17765.0 |
| 2023-05-25 07:30:00 | AAPL | Stock | 170.91 | 170.92 | 170.67 | 170.7 | 10545.0 |
| 2023-05-25 07:35:00 | AAPL | Stock | 170.8 | 170.81 | 170.69 | 170.81 | 11703.0 |
| 2023-05-25 07:40:00 | AAPL | Stock | 170.82 | 171.0 | 170.82 | 171.0 | 4287.0 |
| 2023-05-25 07:45:00 | AAPL | Stock | 171.0 | 171.19 | 171.0 | 171.12 | 4621.0 |
| 2023-05-25 07:50:00 | AAPL | Stock | 171.14 | 171.17 | 171.1 | 171.1 | 1460.0 |
| 2023-05-25 07:55:00 | AAPL | Stock | 171.12 | 171.17 | 171.08 | 171.15 | 6852.0 |
| 2023-05-25 08:00:00 | AAPL | Stock | 171.1582 | 171.6015 | 170.75 | 171.24 | 71935.0 |
| 2023-05-25 08:05:00 | AAPL | Stock | 171.27 | 171.4154 | 171.2 | 171.35 | 11748.0 |
| 2023-05-25 08:10:00 | AAPL | Stock | 171.32 | 171.4813 | 171.3 | 171.35 | 17953.0 |
> showing 50 of 413,572 rows — these rows as CSV