PREVIEW / stock_5min / 2024-08-06
file: by_date/stock_5min/2024/2024-08-06.parquet size: 6.7 MB rows: 408,669 symbols: 878
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-06 04:00:00 | AAPL | Stock | 211.84 | 212.84 | 210.56 | 211.11 | 14866.0 |
| 2024-08-06 04:05:00 | AAPL | Stock | 211.1 | 211.3 | 210.16 | 210.16 | 15306.0 |
| 2024-08-06 04:10:00 | AAPL | Stock | 210.2 | 210.54 | 210.01 | 210.02 | 11827.0 |
| 2024-08-06 04:15:00 | AAPL | Stock | 210.11 | 210.42 | 210.03 | 210.21 | 4486.0 |
| 2024-08-06 04:20:00 | AAPL | Stock | 210.2 | 210.25 | 210.03 | 210.25 | 2197.0 |
| 2024-08-06 04:25:00 | AAPL | Stock | 210.38 | 210.72 | 210.38 | 210.7 | 5052.0 |
| 2024-08-06 04:30:00 | AAPL | Stock | 210.55 | 210.69 | 210.3 | 210.69 | 1586.0 |
| 2024-08-06 04:35:00 | AAPL | Stock | 210.46 | 210.58 | 210.1 | 210.33 | 4235.0 |
| 2024-08-06 04:40:00 | AAPL | Stock | 210.25 | 210.4 | 210.25 | 210.4 | 1123.0 |
| 2024-08-06 04:45:00 | AAPL | Stock | 210.4 | 210.4 | 210.3 | 210.38 | 1509.0 |
| 2024-08-06 04:50:00 | AAPL | Stock | 210.45 | 210.63 | 210.45 | 210.63 | 529.0 |
| 2024-08-06 04:55:00 | AAPL | Stock | 210.47 | 210.48 | 210.33 | 210.33 | 2682.0 |
| 2024-08-06 05:00:00 | AAPL | Stock | 210.32 | 210.32 | 209.54 | 209.79 | 14649.0 |
| 2024-08-06 05:05:00 | AAPL | Stock | 209.65 | 209.97 | 209.65 | 209.8 | 1401.0 |
| 2024-08-06 05:10:00 | AAPL | Stock | 209.68 | 209.68 | 209.31 | 209.46 | 2106.0 |
| 2024-08-06 05:15:00 | AAPL | Stock | 209.49 | 209.61 | 209.32 | 209.61 | 2306.0 |
| 2024-08-06 05:20:00 | AAPL | Stock | 209.74 | 210.0 | 209.74 | 210.0 | 1681.0 |
| 2024-08-06 05:25:00 | AAPL | Stock | 210.29 | 210.29 | 209.41 | 209.41 | 4377.0 |
| 2024-08-06 05:30:00 | AAPL | Stock | 209.5 | 209.59 | 209.28 | 209.28 | 1357.0 |
| 2024-08-06 05:35:00 | AAPL | Stock | 209.09 | 209.09 | 208.52 | 208.52 | 6374.0 |
| 2024-08-06 05:40:00 | AAPL | Stock | 208.34 | 208.93 | 208.23 | 208.93 | 2549.0 |
| 2024-08-06 05:45:00 | AAPL | Stock | 209.0 | 209.0 | 208.6 | 208.6 | 544.0 |
| 2024-08-06 05:50:00 | AAPL | Stock | 208.69 | 208.69 | 208.54 | 208.54 | 1143.0 |
| 2024-08-06 05:55:00 | AAPL | Stock | 208.63 | 209.26 | 208.59 | 209.21 | 772.0 |
| 2024-08-06 06:00:00 | AAPL | Stock | 209.02 | 209.02 | 208.3 | 208.38 | 6292.0 |
| 2024-08-06 06:05:00 | AAPL | Stock | 208.41 | 208.41 | 208.34 | 208.4 | 2293.0 |
| 2024-08-06 06:10:00 | AAPL | Stock | 208.4 | 208.75 | 208.3 | 208.75 | 12204.0 |
| 2024-08-06 06:15:00 | AAPL | Stock | 208.75 | 208.75 | 208.1 | 208.29 | 5530.0 |
| 2024-08-06 06:20:00 | AAPL | Stock | 208.15 | 208.2 | 207.85 | 207.85 | 4072.0 |
| 2024-08-06 06:25:00 | AAPL | Stock | 208.05 | 208.47 | 207.99 | 208.47 | 5246.0 |
| 2024-08-06 06:30:00 | AAPL | Stock | 208.46 | 208.75 | 208.46 | 208.7 | 5934.0 |
| 2024-08-06 06:35:00 | AAPL | Stock | 208.68 | 208.75 | 208.6 | 208.74 | 2463.0 |
| 2024-08-06 06:40:00 | AAPL | Stock | 208.73 | 208.75 | 208.36 | 208.36 | 3294.0 |
| 2024-08-06 06:45:00 | AAPL | Stock | 208.35 | 208.4 | 208.1 | 208.34 | 4510.0 |
| 2024-08-06 06:50:00 | AAPL | Stock | 208.4 | 208.73 | 208.4 | 208.58 | 5511.0 |
| 2024-08-06 06:55:00 | AAPL | Stock | 208.6 | 208.8 | 208.22 | 208.5 | 7996.0 |
| 2024-08-06 07:00:00 | AAPL | Stock | 208.45 | 209.25 | 208.45 | 208.71 | 33552.0 |
| 2024-08-06 07:05:00 | AAPL | Stock | 208.8 | 209.06 | 208.8 | 208.88 | 2743.0 |
| 2024-08-06 07:10:00 | AAPL | Stock | 208.86 | 209.0 | 208.71 | 208.92 | 7098.0 |
| 2024-08-06 07:15:00 | AAPL | Stock | 208.9 | 208.9 | 208.28 | 208.4 | 11033.0 |
| 2024-08-06 07:20:00 | AAPL | Stock | 208.4 | 208.74 | 208.35 | 208.37 | 10729.0 |
| 2024-08-06 07:25:00 | AAPL | Stock | 208.46 | 208.77 | 208.45 | 208.77 | 3574.0 |
| 2024-08-06 07:30:00 | AAPL | Stock | 208.8 | 209.14 | 208.5 | 208.79 | 11184.0 |
| 2024-08-06 07:35:00 | AAPL | Stock | 208.71 | 208.71 | 208.4 | 208.5 | 6502.0 |
| 2024-08-06 07:40:00 | AAPL | Stock | 208.47 | 208.47 | 207.7 | 207.74 | 16708.0 |
| 2024-08-06 07:45:00 | AAPL | Stock | 207.66 | 207.91 | 207.34 | 207.72 | 8069.0 |
| 2024-08-06 07:50:00 | AAPL | Stock | 207.79 | 207.8 | 207.2 | 207.54 | 9805.0 |
| 2024-08-06 07:55:00 | AAPL | Stock | 207.57 | 207.79 | 207.5 | 207.74 | 5034.0 |
| 2024-08-06 08:00:00 | AAPL | Stock | 208.9 | 214.8 | 207.2806 | 207.9892 | 75655.0 |
| 2024-08-06 08:05:00 | AAPL | Stock | 207.85 | 207.85 | 207.09 | 207.17 | 23167.0 |
> showing 50 of 408,669 rows — these rows as CSV