PREVIEW / stock_5min / 2024-07-03
file: by_date/stock_5min/2024/2024-07-03.parquet size: 4.2 MB rows: 238,537 symbols: 861
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-07-03 04:00:00 | AAPL | Stock | 220.0 | 220.0 | 219.82 | 219.82 | 2034.0 |
| 2024-07-03 04:05:00 | AAPL | Stock | 219.7 | 219.7 | 219.68 | 219.68 | 467.0 |
| 2024-07-03 04:10:00 | AAPL | Stock | 219.8 | 219.8 | 219.76 | 219.76 | 228.0 |
| 2024-07-03 04:15:00 | AAPL | Stock | 219.79 | 219.8 | 219.66 | 219.74 | 1652.0 |
| 2024-07-03 04:20:00 | AAPL | Stock | 219.73 | 219.83 | 219.73 | 219.75 | 300.0 |
| 2024-07-03 04:25:00 | AAPL | Stock | 219.84 | 219.84 | 219.84 | 219.84 | 390.0 |
| 2024-07-03 04:30:00 | AAPL | Stock | 219.76 | 219.79 | 219.76 | 219.79 | 240.0 |
| 2024-07-03 04:35:00 | AAPL | Stock | 219.75 | 219.75 | 219.7 | 219.7 | 576.0 |
| 2024-07-03 04:40:00 | AAPL | Stock | 219.7 | 219.73 | 219.6 | 219.6 | 1402.0 |
| 2024-07-03 04:45:00 | AAPL | Stock | 219.68 | 219.85 | 219.68 | 219.85 | 2056.0 |
| 2024-07-03 04:50:00 | AAPL | Stock | 219.85 | 219.85 | 219.53 | 219.53 | 6590.0 |
| 2024-07-03 04:55:00 | AAPL | Stock | 219.58 | 219.7 | 219.58 | 219.7 | 3488.0 |
| 2024-07-03 05:00:00 | AAPL | Stock | 219.62 | 219.69 | 219.62 | 219.69 | 590.0 |
| 2024-07-03 05:05:00 | AAPL | Stock | 219.65 | 219.66 | 219.65 | 219.66 | 438.0 |
| 2024-07-03 05:10:00 | AAPL | Stock | 219.7 | 219.7 | 219.6 | 219.61 | 1650.0 |
| 2024-07-03 05:15:00 | AAPL | Stock | 219.65 | 219.67 | 219.61 | 219.61 | 1937.0 |
| 2024-07-03 05:20:00 | AAPL | Stock | 219.62 | 219.62 | 219.61 | 219.61 | 200.0 |
| 2024-07-03 05:25:00 | AAPL | Stock | 219.61 | 219.61 | 219.51 | 219.56 | 779.0 |
| 2024-07-03 05:35:00 | AAPL | Stock | 219.56 | 219.56 | 219.49 | 219.51 | 2758.0 |
| 2024-07-03 05:40:00 | AAPL | Stock | 219.53 | 219.53 | 219.53 | 219.53 | 500.0 |
| 2024-07-03 05:45:00 | AAPL | Stock | 219.54 | 219.54 | 219.52 | 219.52 | 2157.0 |
| 2024-07-03 05:50:00 | AAPL | Stock | 219.52 | 219.69 | 219.52 | 219.69 | 4025.0 |
| 2024-07-03 05:55:00 | AAPL | Stock | 219.61 | 219.75 | 219.61 | 219.71 | 1500.0 |
| 2024-07-03 06:00:00 | AAPL | Stock | 219.71 | 219.72 | 219.71 | 219.72 | 412.0 |
| 2024-07-03 06:05:00 | AAPL | Stock | 219.75 | 219.75 | 219.69 | 219.69 | 1100.0 |
| 2024-07-03 06:10:00 | AAPL | Stock | 219.69 | 219.69 | 219.69 | 219.69 | 100.0 |
| 2024-07-03 06:15:00 | AAPL | Stock | 219.69 | 219.69 | 219.69 | 219.69 | 164.0 |
| 2024-07-03 06:20:00 | AAPL | Stock | 219.62 | 219.62 | 219.55 | 219.55 | 3715.0 |
| 2024-07-03 06:25:00 | AAPL | Stock | 219.64 | 219.75 | 219.64 | 219.75 | 1710.0 |
| 2024-07-03 06:30:00 | AAPL | Stock | 219.8 | 219.8 | 219.8 | 219.8 | 100.0 |
| 2024-07-03 06:35:00 | AAPL | Stock | 219.74 | 219.75 | 219.74 | 219.74 | 400.0 |
| 2024-07-03 06:40:00 | AAPL | Stock | 219.72 | 219.72 | 219.7 | 219.7 | 997.0 |
| 2024-07-03 06:45:00 | AAPL | Stock | 219.69 | 219.69 | 219.6 | 219.6 | 300.0 |
| 2024-07-03 06:55:00 | AAPL | Stock | 219.62 | 219.62 | 219.53 | 219.6 | 2864.0 |
| 2024-07-03 07:00:00 | AAPL | Stock | 219.64 | 219.68 | 219.5 | 219.5 | 4129.0 |
| 2024-07-03 07:05:00 | AAPL | Stock | 219.52 | 219.59 | 219.5 | 219.59 | 3096.0 |
| 2024-07-03 07:10:00 | AAPL | Stock | 219.63 | 219.64 | 219.54 | 219.58 | 2500.0 |
| 2024-07-03 07:15:00 | AAPL | Stock | 219.54 | 219.62 | 219.54 | 219.62 | 1640.0 |
| 2024-07-03 07:20:00 | AAPL | Stock | 219.61 | 219.7 | 219.6 | 219.61 | 3165.0 |
| 2024-07-03 07:25:00 | AAPL | Stock | 219.56 | 219.56 | 219.55 | 219.55 | 6400.0 |
| 2024-07-03 07:30:00 | AAPL | Stock | 219.5 | 219.5 | 219.3 | 219.3 | 3793.0 |
| 2024-07-03 07:35:00 | AAPL | Stock | 219.3 | 219.33 | 219.21 | 219.25 | 2753.0 |
| 2024-07-03 07:40:00 | AAPL | Stock | 219.27 | 219.33 | 219.27 | 219.33 | 1570.0 |
| 2024-07-03 07:45:00 | AAPL | Stock | 219.35 | 219.49 | 219.35 | 219.49 | 9086.0 |
| 2024-07-03 07:50:00 | AAPL | Stock | 219.49 | 219.49 | 219.49 | 219.49 | 300.0 |
| 2024-07-03 07:55:00 | AAPL | Stock | 219.47 | 219.5 | 219.45 | 219.45 | 1590.0 |
| 2024-07-03 08:00:00 | AAPL | Stock | 219.635 | 219.89 | 219.21 | 219.64 | 50176.0 |
| 2024-07-03 08:05:00 | AAPL | Stock | 219.6499 | 219.6499 | 219.54 | 219.58 | 5054.0 |
| 2024-07-03 08:10:00 | AAPL | Stock | 219.64 | 219.65 | 219.5 | 219.62 | 9375.0 |
| 2024-07-03 08:15:00 | AAPL | Stock | 219.6 | 219.67 | 219.5439 | 219.59 | 14989.0 |
> showing 50 of 238,537 rows — these rows as CSV