PREVIEW / stock_5min / 2024-06-21
file: by_date/stock_5min/2024/2024-06-21.parquet size: 6.5 MB rows: 391,022 symbols: 957
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-06-21 04:00:00 | AAPL | Stock | 209.47 | 209.62 | 209.03 | 209.03 | 5642.0 |
| 2024-06-21 04:05:00 | AAPL | Stock | 209.05 | 209.11 | 208.92 | 208.92 | 3762.0 |
| 2024-06-21 04:10:00 | AAPL | Stock | 208.92 | 208.92 | 208.81 | 208.81 | 1779.0 |
| 2024-06-21 04:15:00 | AAPL | Stock | 208.8 | 208.8 | 208.67 | 208.72 | 3636.0 |
| 2024-06-21 04:20:00 | AAPL | Stock | 208.71 | 208.81 | 208.68 | 208.81 | 922.0 |
| 2024-06-21 04:25:00 | AAPL | Stock | 208.84 | 208.99 | 208.84 | 208.98 | 656.0 |
| 2024-06-21 04:30:00 | AAPL | Stock | 208.84 | 209.0 | 208.84 | 209.0 | 5416.0 |
| 2024-06-21 04:35:00 | AAPL | Stock | 209.01 | 209.01 | 208.82 | 208.82 | 964.0 |
| 2024-06-21 04:40:00 | AAPL | Stock | 208.82 | 209.44 | 208.8 | 209.44 | 3670.0 |
| 2024-06-21 04:45:00 | AAPL | Stock | 209.31 | 209.33 | 209.26 | 209.3 | 2527.0 |
| 2024-06-21 04:50:00 | AAPL | Stock | 209.22 | 209.22 | 209.22 | 209.22 | 779.0 |
| 2024-06-21 04:55:00 | AAPL | Stock | 209.13 | 209.13 | 209.0 | 209.0 | 1120.0 |
| 2024-06-21 05:00:00 | AAPL | Stock | 209.0 | 209.26 | 209.0 | 209.26 | 2380.0 |
| 2024-06-21 05:05:00 | AAPL | Stock | 209.33 | 209.33 | 209.11 | 209.11 | 1003.0 |
| 2024-06-21 05:10:00 | AAPL | Stock | 209.1 | 209.1 | 209.1 | 209.1 | 749.0 |
| 2024-06-21 05:15:00 | AAPL | Stock | 208.9 | 208.92 | 208.75 | 208.9 | 2272.0 |
| 2024-06-21 05:20:00 | AAPL | Stock | 208.9 | 209.2 | 208.88 | 209.2 | 2954.0 |
| 2024-06-21 05:35:00 | AAPL | Stock | 209.18 | 209.28 | 209.18 | 209.28 | 956.0 |
| 2024-06-21 05:40:00 | AAPL | Stock | 209.29 | 209.3 | 209.08 | 209.08 | 2689.0 |
| 2024-06-21 05:45:00 | AAPL | Stock | 209.06 | 209.08 | 209.06 | 209.08 | 750.0 |
| 2024-06-21 05:50:00 | AAPL | Stock | 209.0 | 209.0 | 209.0 | 209.0 | 356.0 |
| 2024-06-21 05:55:00 | AAPL | Stock | 209.04 | 209.04 | 209.04 | 209.04 | 100.0 |
| 2024-06-21 06:00:00 | AAPL | Stock | 209.09 | 209.15 | 209.09 | 209.15 | 887.0 |
| 2024-06-21 06:10:00 | AAPL | Stock | 209.12 | 209.36 | 209.12 | 209.36 | 1006.0 |
| 2024-06-21 06:15:00 | AAPL | Stock | 209.41 | 209.5 | 209.41 | 209.5 | 562.0 |
| 2024-06-21 06:20:00 | AAPL | Stock | 209.52 | 209.67 | 209.5 | 209.67 | 5875.0 |
| 2024-06-21 06:25:00 | AAPL | Stock | 209.6 | 209.6 | 209.5 | 209.5 | 1080.0 |
| 2024-06-21 06:30:00 | AAPL | Stock | 209.52 | 209.52 | 209.52 | 209.52 | 256.0 |
| 2024-06-21 06:35:00 | AAPL | Stock | 209.56 | 209.66 | 209.56 | 209.66 | 468.0 |
| 2024-06-21 06:40:00 | AAPL | Stock | 209.64 | 209.99 | 209.64 | 209.91 | 2487.0 |
| 2024-06-21 06:45:00 | AAPL | Stock | 210.0 | 210.0 | 210.0 | 210.0 | 551.0 |
| 2024-06-21 06:50:00 | AAPL | Stock | 210.0 | 210.0 | 210.0 | 210.0 | 257.0 |
| 2024-06-21 06:55:00 | AAPL | Stock | 210.05 | 210.3 | 210.03 | 210.15 | 4349.0 |
| 2024-06-21 07:00:00 | AAPL | Stock | 210.01 | 210.4 | 210.01 | 210.34 | 7092.0 |
| 2024-06-21 07:05:00 | AAPL | Stock | 210.42 | 210.58 | 210.42 | 210.47 | 11372.0 |
| 2024-06-21 07:10:00 | AAPL | Stock | 210.47 | 210.6 | 210.47 | 210.6 | 3482.0 |
| 2024-06-21 07:15:00 | AAPL | Stock | 210.5 | 210.5 | 210.2 | 210.39 | 7032.0 |
| 2024-06-21 07:20:00 | AAPL | Stock | 210.45 | 210.77 | 210.4 | 210.7 | 9203.0 |
| 2024-06-21 07:25:00 | AAPL | Stock | 210.69 | 210.77 | 210.65 | 210.7 | 4156.0 |
| 2024-06-21 07:30:00 | AAPL | Stock | 210.65 | 210.65 | 210.5 | 210.51 | 5962.0 |
| 2024-06-21 07:35:00 | AAPL | Stock | 210.5 | 210.52 | 210.4 | 210.4 | 2490.0 |
| 2024-06-21 07:40:00 | AAPL | Stock | 210.37 | 210.37 | 210.33 | 210.33 | 2852.0 |
| 2024-06-21 07:45:00 | AAPL | Stock | 210.35 | 210.35 | 210.29 | 210.29 | 1574.0 |
| 2024-06-21 07:50:00 | AAPL | Stock | 210.285 | 210.285 | 210.05 | 210.2 | 4158.0 |
| 2024-06-21 07:55:00 | AAPL | Stock | 210.21 | 210.54 | 210.21 | 210.35 | 6185.0 |
| 2024-06-21 08:00:00 | AAPL | Stock | 210.3 | 210.81 | 209.0502 | 209.65 | 79509.0 |
| 2024-06-21 08:05:00 | AAPL | Stock | 210.2 | 210.2 | 210.0 | 210.1 | 18958.0 |
| 2024-06-21 08:10:00 | AAPL | Stock | 210.06 | 210.1052 | 209.84 | 209.92 | 13039.0 |
| 2024-06-21 08:15:00 | AAPL | Stock | 209.926 | 210.1 | 209.92 | 210.0 | 10128.0 |
| 2024-06-21 08:20:00 | AAPL | Stock | 209.96 | 210.0 | 209.67 | 209.86 | 17639.0 |
> showing 50 of 391,022 rows — these rows as CSV