PREVIEW / stock_5min / 2024-10-31
file: by_date/stock_5min/2024/2024-10-31.parquet size: 6.8 MB rows: 409,456 symbols: 735
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-10-31 04:00:00 | AAPL | Stock | 230.13 | 230.78 | 229.2 | 229.2 | 6021.0 |
| 2024-10-31 04:05:00 | AAPL | Stock | 229.6 | 229.6 | 229.2 | 229.2 | 976.0 |
| 2024-10-31 04:10:00 | AAPL | Stock | 229.24 | 229.42 | 229.18 | 229.42 | 3494.0 |
| 2024-10-31 04:15:00 | AAPL | Stock | 229.53 | 229.8 | 229.53 | 229.69 | 1330.0 |
| 2024-10-31 04:20:00 | AAPL | Stock | 229.61 | 229.61 | 229.6 | 229.6 | 1194.0 |
| 2024-10-31 04:30:00 | AAPL | Stock | 229.36 | 229.43 | 229.36 | 229.41 | 593.0 |
| 2024-10-31 04:35:00 | AAPL | Stock | 229.4 | 229.6 | 229.4 | 229.6 | 962.0 |
| 2024-10-31 04:45:00 | AAPL | Stock | 229.57 | 229.68 | 229.53 | 229.68 | 1915.0 |
| 2024-10-31 04:50:00 | AAPL | Stock | 229.66 | 229.66 | 229.6 | 229.6 | 537.0 |
| 2024-10-31 04:55:00 | AAPL | Stock | 229.69 | 229.7 | 229.67 | 229.67 | 530.0 |
| 2024-10-31 05:00:00 | AAPL | Stock | 229.6 | 229.6 | 229.5 | 229.5 | 738.0 |
| 2024-10-31 05:05:00 | AAPL | Stock | 229.35 | 229.35 | 229.35 | 229.35 | 100.0 |
| 2024-10-31 05:10:00 | AAPL | Stock | 229.37 | 229.49 | 229.37 | 229.37 | 1030.0 |
| 2024-10-31 05:15:00 | AAPL | Stock | 229.39 | 229.43 | 229.39 | 229.4 | 1106.0 |
| 2024-10-31 05:20:00 | AAPL | Stock | 229.39 | 229.39 | 229.39 | 229.39 | 140.0 |
| 2024-10-31 05:25:00 | AAPL | Stock | 229.38 | 229.41 | 229.32 | 229.41 | 1619.0 |
| 2024-10-31 05:30:00 | AAPL | Stock | 229.31 | 229.31 | 229.29 | 229.29 | 202.0 |
| 2024-10-31 05:35:00 | AAPL | Stock | 229.31 | 229.31 | 229.31 | 229.31 | 285.0 |
| 2024-10-31 05:40:00 | AAPL | Stock | 229.35 | 229.35 | 229.35 | 229.35 | 533.0 |
| 2024-10-31 05:45:00 | AAPL | Stock | 229.36 | 229.37 | 229.36 | 229.36 | 957.0 |
| 2024-10-31 05:50:00 | AAPL | Stock | 229.33 | 229.33 | 229.3 | 229.3 | 269.0 |
| 2024-10-31 05:55:00 | AAPL | Stock | 229.35 | 229.35 | 229.23 | 229.23 | 637.0 |
| 2024-10-31 06:00:00 | AAPL | Stock | 229.26 | 229.26 | 229.26 | 229.26 | 203.0 |
| 2024-10-31 06:05:00 | AAPL | Stock | 229.3 | 229.3 | 229.3 | 229.3 | 100.0 |
| 2024-10-31 06:10:00 | AAPL | Stock | 229.24 | 229.24 | 229.24 | 229.24 | 446.0 |
| 2024-10-31 06:15:00 | AAPL | Stock | 229.29 | 229.3 | 229.29 | 229.3 | 694.0 |
| 2024-10-31 06:25:00 | AAPL | Stock | 229.29 | 229.29 | 229.29 | 229.29 | 150.0 |
| 2024-10-31 06:30:00 | AAPL | Stock | 229.32 | 229.37 | 229.32 | 229.37 | 490.0 |
| 2024-10-31 06:35:00 | AAPL | Stock | 229.37 | 229.4 | 229.36 | 229.37 | 1502.0 |
| 2024-10-31 06:40:00 | AAPL | Stock | 229.31 | 229.31 | 229.31 | 229.31 | 900.0 |
| 2024-10-31 06:45:00 | AAPL | Stock | 229.31 | 229.36 | 229.3 | 229.3 | 1081.0 |
| 2024-10-31 06:50:00 | AAPL | Stock | 229.31 | 229.54 | 229.31 | 229.54 | 1324.0 |
| 2024-10-31 06:55:00 | AAPL | Stock | 229.57 | 229.57 | 229.55 | 229.55 | 364.0 |
| 2024-10-31 07:00:00 | AAPL | Stock | 229.56 | 229.69 | 229.51 | 229.67 | 4858.0 |
| 2024-10-31 07:05:00 | AAPL | Stock | 229.65 | 229.67 | 229.61 | 229.61 | 1821.0 |
| 2024-10-31 07:10:00 | AAPL | Stock | 229.65 | 229.8 | 229.65 | 229.8 | 899.0 |
| 2024-10-31 07:15:00 | AAPL | Stock | 229.74 | 229.74 | 229.51 | 229.62 | 8367.0 |
| 2024-10-31 07:20:00 | AAPL | Stock | 229.62 | 229.62 | 229.62 | 229.62 | 767.0 |
| 2024-10-31 07:25:00 | AAPL | Stock | 229.57 | 229.57 | 229.5 | 229.5 | 1787.0 |
| 2024-10-31 07:30:00 | AAPL | Stock | 229.44 | 229.47 | 229.3 | 229.3 | 2238.0 |
| 2024-10-31 07:35:00 | AAPL | Stock | 229.4 | 229.4 | 229.25 | 229.25 | 2525.0 |
| 2024-10-31 07:40:00 | AAPL | Stock | 229.25 | 229.4 | 229.25 | 229.4 | 1709.0 |
| 2024-10-31 07:45:00 | AAPL | Stock | 229.49 | 229.49 | 229.4 | 229.4 | 400.0 |
| 2024-10-31 07:50:00 | AAPL | Stock | 229.37 | 229.52 | 229.37 | 229.49 | 4569.0 |
| 2024-10-31 07:55:00 | AAPL | Stock | 229.58 | 229.73 | 229.58 | 229.73 | 8376.0 |
| 2024-10-31 08:00:00 | AAPL | Stock | 229.57 | 230.92 | 229.2 | 229.92 | 50723.0 |
| 2024-10-31 08:05:00 | AAPL | Stock | 229.84 | 229.98 | 229.82 | 229.95 | 19938.0 |
| 2024-10-31 08:10:00 | AAPL | Stock | 229.95 | 230.04 | 229.95 | 230.04 | 19802.0 |
| 2024-10-31 08:15:00 | AAPL | Stock | 230.0201 | 230.06 | 229.99 | 230.0 | 16637.0 |
| 2024-10-31 08:20:00 | AAPL | Stock | 230.0 | 230.0 | 229.92 | 229.92 | 1991.0 |
> showing 50 of 409,456 rows — these rows as CSV