PREVIEW / stock_5min / 2024-01-17
file: by_date/stock_5min/2024/2024-01-17.parquet size: 6.6 MB rows: 398,010 symbols: 1,169
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-01-17 04:00:00 | AAPL | Stock | 182.6 | 182.6 | 181.8 | 181.95 | 4791.0 |
| 2024-01-17 04:05:00 | AAPL | Stock | 181.9 | 181.9 | 181.5 | 181.6 | 4627.0 |
| 2024-01-17 04:10:00 | AAPL | Stock | 181.61 | 181.61 | 181.5 | 181.5 | 2906.0 |
| 2024-01-17 04:15:00 | AAPL | Stock | 181.48 | 181.61 | 181.48 | 181.61 | 1262.0 |
| 2024-01-17 04:20:00 | AAPL | Stock | 181.64 | 181.72 | 181.64 | 181.71 | 500.0 |
| 2024-01-17 04:25:00 | AAPL | Stock | 181.75 | 181.88 | 181.75 | 181.76 | 1314.0 |
| 2024-01-17 04:35:00 | AAPL | Stock | 181.86 | 181.88 | 181.85 | 181.85 | 738.0 |
| 2024-01-17 04:40:00 | AAPL | Stock | 181.88 | 181.88 | 181.8 | 181.8 | 1380.0 |
| 2024-01-17 04:45:00 | AAPL | Stock | 181.82 | 181.82 | 181.8 | 181.8 | 2752.0 |
| 2024-01-17 04:50:00 | AAPL | Stock | 181.86 | 181.86 | 181.86 | 181.86 | 100.0 |
| 2024-01-17 04:55:00 | AAPL | Stock | 181.9 | 181.98 | 181.9 | 181.9 | 3164.0 |
| 2024-01-17 05:00:00 | AAPL | Stock | 181.93 | 181.93 | 181.93 | 181.93 | 119.0 |
| 2024-01-17 05:05:00 | AAPL | Stock | 181.96 | 181.96 | 181.9 | 181.9 | 3750.0 |
| 2024-01-17 05:10:00 | AAPL | Stock | 181.9 | 181.9 | 181.9 | 181.9 | 1949.0 |
| 2024-01-17 05:15:00 | AAPL | Stock | 181.9 | 181.9 | 181.89 | 181.89 | 906.0 |
| 2024-01-17 05:20:00 | AAPL | Stock | 181.85 | 181.9 | 181.84 | 181.85 | 2631.0 |
| 2024-01-17 05:25:00 | AAPL | Stock | 181.85 | 181.85 | 181.8 | 181.81 | 5923.0 |
| 2024-01-17 05:30:00 | AAPL | Stock | 181.75 | 181.75 | 181.74 | 181.74 | 255.0 |
| 2024-01-17 05:35:00 | AAPL | Stock | 181.75 | 181.75 | 181.75 | 181.75 | 100.0 |
| 2024-01-17 05:40:00 | AAPL | Stock | 181.71 | 181.71 | 181.71 | 181.71 | 292.0 |
| 2024-01-17 05:45:00 | AAPL | Stock | 181.72 | 181.73 | 181.67 | 181.67 | 5391.0 |
| 2024-01-17 06:00:00 | AAPL | Stock | 181.7 | 181.75 | 181.7 | 181.75 | 485.0 |
| 2024-01-17 06:05:00 | AAPL | Stock | 181.71 | 181.78 | 181.71 | 181.78 | 287.0 |
| 2024-01-17 06:10:00 | AAPL | Stock | 181.7 | 181.7 | 181.7 | 181.7 | 150.0 |
| 2024-01-17 06:15:00 | AAPL | Stock | 181.81 | 181.9 | 181.81 | 181.9 | 1878.0 |
| 2024-01-17 06:20:00 | AAPL | Stock | 181.89 | 181.9 | 181.89 | 181.9 | 589.0 |
| 2024-01-17 06:25:00 | AAPL | Stock | 181.88 | 181.88 | 181.88 | 181.88 | 190.0 |
| 2024-01-17 06:30:00 | AAPL | Stock | 181.89 | 181.89 | 181.85 | 181.85 | 388.0 |
| 2024-01-17 06:35:00 | AAPL | Stock | 181.89 | 182.09 | 181.89 | 182.09 | 5015.0 |
| 2024-01-17 06:40:00 | AAPL | Stock | 182.08 | 182.08 | 182.08 | 182.08 | 100.0 |
| 2024-01-17 06:45:00 | AAPL | Stock | 182.06 | 182.08 | 182.06 | 182.06 | 971.0 |
| 2024-01-17 06:50:00 | AAPL | Stock | 182.2 | 182.2 | 182.2 | 182.2 | 289.0 |
| 2024-01-17 07:00:00 | AAPL | Stock | 182.19 | 182.37 | 182.19 | 182.37 | 5649.0 |
| 2024-01-17 07:05:00 | AAPL | Stock | 182.29 | 182.34 | 182.22 | 182.22 | 1275.0 |
| 2024-01-17 07:10:00 | AAPL | Stock | 182.23 | 182.25 | 182.14 | 182.25 | 3695.0 |
| 2024-01-17 07:15:00 | AAPL | Stock | 182.23 | 182.27 | 182.22 | 182.25 | 646.0 |
| 2024-01-17 07:20:00 | AAPL | Stock | 182.25 | 182.43 | 182.25 | 182.42 | 2334.0 |
| 2024-01-17 07:25:00 | AAPL | Stock | 182.47 | 182.5 | 182.37 | 182.37 | 4989.0 |
| 2024-01-17 07:30:00 | AAPL | Stock | 182.37 | 182.38 | 182.25 | 182.25 | 4046.0 |
| 2024-01-17 07:35:00 | AAPL | Stock | 182.36 | 182.36 | 182.35 | 182.35 | 810.0 |
| 2024-01-17 07:40:00 | AAPL | Stock | 182.27 | 182.27 | 182.13 | 182.17 | 5463.0 |
| 2024-01-17 07:45:00 | AAPL | Stock | 182.17 | 182.17 | 182.09 | 182.09 | 10837.0 |
| 2024-01-17 07:50:00 | AAPL | Stock | 182.15 | 182.15 | 182.15 | 182.15 | 100.0 |
| 2024-01-17 07:55:00 | AAPL | Stock | 182.1 | 182.33 | 182.0 | 182.25 | 4384.0 |
| 2024-01-17 08:00:00 | AAPL | Stock | 182.2928 | 183.63 | 181.76 | 182.56 | 174110.0 |
| 2024-01-17 08:05:00 | AAPL | Stock | 182.25 | 182.25 | 182.15 | 182.19 | 4740.0 |
| 2024-01-17 08:10:00 | AAPL | Stock | 182.157 | 182.17 | 182.1 | 182.16 | 2038.0 |
| 2024-01-17 08:15:00 | AAPL | Stock | 182.2399 | 182.2399 | 182.01 | 182.01 | 6275.0 |
| 2024-01-17 08:20:00 | AAPL | Stock | 182.01 | 182.05 | 181.88 | 181.88 | 9579.0 |
| 2024-01-17 08:25:00 | AAPL | Stock | 181.88 | 181.88 | 181.75 | 181.82 | 8453.0 |
> showing 50 of 398,010 rows — these rows as CSV