PREVIEW / stock_5min / 2024-06-07
file: by_date/stock_5min/2024/2024-06-07.parquet size: 6.5 MB rows: 391,832 symbols: 963
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-07 04:00:00 | AAPL | Stock | 195.02 | 195.03 | 194.98 | 194.98 | 1597.0 |
| 2024-06-07 04:05:00 | AAPL | Stock | 194.96 | 194.96 | 194.91 | 194.91 | 200.0 |
| 2024-06-07 04:10:00 | AAPL | Stock | 194.98 | 195.0 | 194.93 | 194.93 | 1787.0 |
| 2024-06-07 04:15:00 | AAPL | Stock | 194.93 | 194.95 | 194.8 | 194.8 | 3958.0 |
| 2024-06-07 04:20:00 | AAPL | Stock | 194.74 | 194.74 | 194.7 | 194.7 | 1487.0 |
| 2024-06-07 04:25:00 | AAPL | Stock | 194.81 | 194.81 | 194.81 | 194.81 | 239.0 |
| 2024-06-07 04:35:00 | AAPL | Stock | 194.9 | 194.9 | 194.87 | 194.87 | 930.0 |
| 2024-06-07 04:50:00 | AAPL | Stock | 194.88 | 194.88 | 194.82 | 194.82 | 1358.0 |
| 2024-06-07 04:55:00 | AAPL | Stock | 194.73 | 194.73 | 194.73 | 194.73 | 100.0 |
| 2024-06-07 05:00:00 | AAPL | Stock | 194.7 | 194.7 | 194.7 | 194.7 | 275.0 |
| 2024-06-07 05:20:00 | AAPL | Stock | 194.72 | 194.72 | 194.72 | 194.72 | 100.0 |
| 2024-06-07 05:25:00 | AAPL | Stock | 194.78 | 194.78 | 194.78 | 194.78 | 152.0 |
| 2024-06-07 05:30:00 | AAPL | Stock | 194.91 | 194.91 | 194.91 | 194.91 | 100.0 |
| 2024-06-07 05:35:00 | AAPL | Stock | 194.92 | 194.92 | 194.92 | 194.92 | 500.0 |
| 2024-06-07 05:50:00 | AAPL | Stock | 194.92 | 194.92 | 194.92 | 194.92 | 300.0 |
| 2024-06-07 05:55:00 | AAPL | Stock | 194.9 | 194.9 | 194.89 | 194.89 | 231.0 |
| 2024-06-07 06:05:00 | AAPL | Stock | 194.88 | 194.88 | 194.84 | 194.84 | 475.0 |
| 2024-06-07 06:10:00 | AAPL | Stock | 194.9 | 194.9 | 194.9 | 194.9 | 400.0 |
| 2024-06-07 06:20:00 | AAPL | Stock | 194.87 | 194.89 | 194.87 | 194.89 | 300.0 |
| 2024-06-07 06:30:00 | AAPL | Stock | 194.89 | 194.89 | 194.89 | 194.89 | 100.0 |
| 2024-06-07 06:45:00 | AAPL | Stock | 194.87 | 194.88 | 194.87 | 194.88 | 558.0 |
| 2024-06-07 06:50:00 | AAPL | Stock | 194.94 | 194.94 | 194.9 | 194.9 | 572.0 |
| 2024-06-07 06:55:00 | AAPL | Stock | 194.92 | 194.92 | 194.9 | 194.9 | 254.0 |
| 2024-06-07 07:00:00 | AAPL | Stock | 194.97 | 195.05 | 194.96 | 194.97 | 16396.0 |
| 2024-06-07 07:05:00 | AAPL | Stock | 194.9 | 194.91 | 194.9 | 194.91 | 300.0 |
| 2024-06-07 07:10:00 | AAPL | Stock | 194.91 | 194.91 | 194.77 | 194.77 | 3343.0 |
| 2024-06-07 07:15:00 | AAPL | Stock | 194.73 | 194.81 | 194.73 | 194.81 | 1301.0 |
| 2024-06-07 07:20:00 | AAPL | Stock | 194.81 | 194.81 | 194.81 | 194.81 | 491.0 |
| 2024-06-07 07:25:00 | AAPL | Stock | 194.81 | 194.84 | 194.81 | 194.84 | 1417.0 |
| 2024-06-07 07:30:00 | AAPL | Stock | 194.88 | 194.92 | 194.88 | 194.92 | 1111.0 |
| 2024-06-07 07:35:00 | AAPL | Stock | 195.0 | 195.0 | 194.99 | 194.99 | 4894.0 |
| 2024-06-07 07:40:00 | AAPL | Stock | 195.0 | 195.03 | 195.0 | 195.03 | 1020.0 |
| 2024-06-07 07:50:00 | AAPL | Stock | 195.08 | 195.08 | 195.08 | 195.08 | 170.0 |
| 2024-06-07 07:55:00 | AAPL | Stock | 195.11 | 195.12 | 195.06 | 195.12 | 800.0 |
| 2024-06-07 08:00:00 | AAPL | Stock | 195.0 | 195.23 | 194.74 | 195.23 | 33941.0 |
| 2024-06-07 08:05:00 | AAPL | Stock | 195.15 | 195.2999 | 194.9 | 194.92 | 18916.0 |
| 2024-06-07 08:10:00 | AAPL | Stock | 195.05 | 195.27 | 194.93 | 195.25 | 2331.0 |
| 2024-06-07 08:15:00 | AAPL | Stock | 195.27 | 195.27 | 195.17 | 195.2 | 1788.0 |
| 2024-06-07 08:20:00 | AAPL | Stock | 195.23 | 195.23 | 195.16 | 195.22 | 4984.0 |
| 2024-06-07 08:25:00 | AAPL | Stock | 195.15 | 195.18 | 195.12 | 195.16 | 2117.0 |
| 2024-06-07 08:30:00 | AAPL | Stock | 195.22 | 195.51 | 194.48 | 194.9197 | 61325.0 |
| 2024-06-07 08:35:00 | AAPL | Stock | 194.77 | 194.77 | 194.4 | 194.48 | 48671.0 |
| 2024-06-07 08:40:00 | AAPL | Stock | 194.44 | 194.47 | 193.66 | 193.85 | 86529.0 |
| 2024-06-07 08:45:00 | AAPL | Stock | 193.8 | 193.9 | 193.45 | 193.74 | 74586.0 |
| 2024-06-07 08:50:00 | AAPL | Stock | 193.7 | 193.8 | 193.6 | 193.6 | 42191.0 |
| 2024-06-07 08:55:00 | AAPL | Stock | 193.52 | 193.8 | 193.45 | 193.72 | 49733.0 |
| 2024-06-07 09:00:00 | AAPL | Stock | 193.65 | 193.95 | 193.6 | 193.89 | 18430.0 |
| 2024-06-07 09:05:00 | AAPL | Stock | 193.89 | 194.24 | 193.85 | 194.24 | 25950.0 |
| 2024-06-07 09:10:00 | AAPL | Stock | 194.29 | 194.3 | 194.15 | 194.27 | 12757.0 |
| 2024-06-07 09:15:00 | AAPL | Stock | 194.22 | 194.4 | 194.1517 | 194.4 | 19026.0 |
> showing 50 of 391,832 rows — these rows as CSV