PREVIEW / stock_5min / 2024-02-01
file: by_date/stock_5min/2024/2024-02-01.parquet size: 6.7 MB rows: 408,084 symbols: 1,156
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-02-01 04:00:00 | AAPL | Stock | 185.49 | 185.9 | 185.49 | 185.88 | 2650.0 |
| 2024-02-01 04:05:00 | AAPL | Stock | 185.8 | 185.8 | 185.75 | 185.75 | 399.0 |
| 2024-02-01 04:10:00 | AAPL | Stock | 185.87 | 185.87 | 185.87 | 185.87 | 375.0 |
| 2024-02-01 04:20:00 | AAPL | Stock | 185.8 | 185.8 | 185.8 | 185.8 | 100.0 |
| 2024-02-01 04:25:00 | AAPL | Stock | 185.76 | 185.76 | 185.76 | 185.76 | 100.0 |
| 2024-02-01 04:35:00 | AAPL | Stock | 185.75 | 185.75 | 185.55 | 185.55 | 1038.0 |
| 2024-02-01 04:40:00 | AAPL | Stock | 185.52 | 185.54 | 185.45 | 185.5 | 2545.0 |
| 2024-02-01 04:55:00 | AAPL | Stock | 185.57 | 185.6 | 185.51 | 185.51 | 2743.0 |
| 2024-02-01 05:00:00 | AAPL | Stock | 185.4 | 185.41 | 185.4 | 185.4 | 2779.0 |
| 2024-02-01 05:05:00 | AAPL | Stock | 185.4 | 185.4 | 185.4 | 185.4 | 1777.0 |
| 2024-02-01 05:10:00 | AAPL | Stock | 185.4 | 185.4 | 185.4 | 185.4 | 3500.0 |
| 2024-02-01 05:20:00 | AAPL | Stock | 185.39 | 185.39 | 185.39 | 185.39 | 164.0 |
| 2024-02-01 05:25:00 | AAPL | Stock | 185.37 | 185.4 | 185.37 | 185.4 | 1050.0 |
| 2024-02-01 05:35:00 | AAPL | Stock | 185.4 | 185.4 | 185.36 | 185.4 | 1440.0 |
| 2024-02-01 05:40:00 | AAPL | Stock | 185.4 | 185.4 | 185.39 | 185.39 | 1600.0 |
| 2024-02-01 05:45:00 | AAPL | Stock | 185.4 | 185.5 | 185.4 | 185.5 | 3432.0 |
| 2024-02-01 05:50:00 | AAPL | Stock | 185.5 | 185.55 | 185.46 | 185.55 | 1761.0 |
| 2024-02-01 05:55:00 | AAPL | Stock | 185.54 | 185.69 | 185.54 | 185.69 | 4020.0 |
| 2024-02-01 06:05:00 | AAPL | Stock | 185.65 | 185.65 | 185.65 | 185.65 | 150.0 |
| 2024-02-01 06:10:00 | AAPL | Stock | 185.51 | 185.51 | 185.46 | 185.46 | 339.0 |
| 2024-02-01 06:15:00 | AAPL | Stock | 185.39 | 185.39 | 185.31 | 185.31 | 754.0 |
| 2024-02-01 06:20:00 | AAPL | Stock | 185.31 | 185.32 | 185.11 | 185.17 | 2381.0 |
| 2024-02-01 06:25:00 | AAPL | Stock | 185.11 | 185.11 | 185.11 | 185.11 | 525.0 |
| 2024-02-01 06:30:00 | AAPL | Stock | 185.06 | 185.13 | 185.06 | 185.13 | 203.0 |
| 2024-02-01 06:35:00 | AAPL | Stock | 185.2 | 185.21 | 185.19 | 185.2 | 1157.0 |
| 2024-02-01 06:40:00 | AAPL | Stock | 185.19 | 185.19 | 185.11 | 185.19 | 1934.0 |
| 2024-02-01 06:45:00 | AAPL | Stock | 185.32 | 185.8 | 185.32 | 185.54 | 14937.0 |
| 2024-02-01 06:50:00 | AAPL | Stock | 185.68 | 185.88 | 185.6 | 185.6 | 1999.0 |
| 2024-02-01 07:00:00 | AAPL | Stock | 185.64 | 185.64 | 185.44 | 185.46 | 3143.0 |
| 2024-02-01 07:05:00 | AAPL | Stock | 185.45 | 185.55 | 185.45 | 185.55 | 4159.0 |
| 2024-02-01 07:10:00 | AAPL | Stock | 185.62 | 185.62 | 185.5 | 185.58 | 2515.0 |
| 2024-02-01 07:15:00 | AAPL | Stock | 185.6 | 185.67 | 185.6 | 185.67 | 3029.0 |
| 2024-02-01 07:20:00 | AAPL | Stock | 185.7 | 185.76 | 185.5 | 185.68 | 7879.0 |
| 2024-02-01 07:25:00 | AAPL | Stock | 185.67 | 185.67 | 185.59 | 185.64 | 1673.0 |
| 2024-02-01 07:30:00 | AAPL | Stock | 185.55 | 185.55 | 185.55 | 185.55 | 150.0 |
| 2024-02-01 07:35:00 | AAPL | Stock | 185.61 | 185.61 | 185.61 | 185.61 | 102.0 |
| 2024-02-01 07:40:00 | AAPL | Stock | 185.63 | 185.7 | 185.63 | 185.7 | 4540.0 |
| 2024-02-01 07:45:00 | AAPL | Stock | 185.71 | 185.71 | 185.69 | 185.69 | 1186.0 |
| 2024-02-01 07:50:00 | AAPL | Stock | 185.7 | 185.82 | 185.7 | 185.82 | 1787.0 |
| 2024-02-01 07:55:00 | AAPL | Stock | 185.79 | 185.79 | 185.7 | 185.7 | 1536.0 |
| 2024-02-01 08:00:00 | AAPL | Stock | 185.7 | 186.0786 | 185.26 | 185.8 | 63739.0 |
| 2024-02-01 08:05:00 | AAPL | Stock | 185.82 | 185.82 | 185.623 | 185.65 | 9451.0 |
| 2024-02-01 08:10:00 | AAPL | Stock | 185.65 | 185.78 | 185.5 | 185.5 | 7323.0 |
| 2024-02-01 08:15:00 | AAPL | Stock | 185.48 | 185.59 | 185.3183 | 185.39 | 7016.0 |
| 2024-02-01 08:20:00 | AAPL | Stock | 185.34 | 185.45 | 185.34 | 185.45 | 8480.0 |
| 2024-02-01 08:25:00 | AAPL | Stock | 185.45 | 185.54 | 185.45 | 185.52 | 4040.0 |
| 2024-02-01 08:30:00 | AAPL | Stock | 185.55 | 185.8 | 185.55 | 185.63 | 10908.0 |
| 2024-02-01 08:35:00 | AAPL | Stock | 185.63 | 185.8 | 185.6 | 185.8 | 15495.0 |
| 2024-02-01 08:40:00 | AAPL | Stock | 185.78 | 185.86 | 185.6 | 185.6 | 28192.0 |
| 2024-02-01 08:45:00 | AAPL | Stock | 185.5981 | 185.7 | 185.5981 | 185.66 | 5337.0 |
> showing 50 of 408,084 rows — these rows as CSV