PREVIEW / stock_5min / 2024-03-21
file: by_date/stock_5min/2024/2024-03-21.parquet size: 6.9 MB rows: 414,871 symbols: 1,077
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-03-21 04:00:00 | AAPL | Stock | 177.03 | 177.03 | 176.11 | 176.6 | 8965.0 |
| 2024-03-21 04:05:00 | AAPL | Stock | 176.69 | 176.89 | 176.66 | 176.79 | 3943.0 |
| 2024-03-21 04:10:00 | AAPL | Stock | 176.92 | 176.99 | 176.76 | 176.77 | 4252.0 |
| 2024-03-21 04:15:00 | AAPL | Stock | 176.88 | 176.97 | 176.78 | 176.97 | 3590.0 |
| 2024-03-21 04:20:00 | AAPL | Stock | 176.97 | 176.98 | 176.8 | 176.8 | 1890.0 |
| 2024-03-21 04:25:00 | AAPL | Stock | 176.85 | 176.88 | 176.85 | 176.88 | 1245.0 |
| 2024-03-21 04:30:00 | AAPL | Stock | 176.81 | 176.88 | 176.81 | 176.88 | 510.0 |
| 2024-03-21 04:35:00 | AAPL | Stock | 176.88 | 176.97 | 176.88 | 176.97 | 3165.0 |
| 2024-03-21 04:40:00 | AAPL | Stock | 176.9 | 176.9 | 176.56 | 176.57 | 7656.0 |
| 2024-03-21 04:45:00 | AAPL | Stock | 176.6 | 176.85 | 176.6 | 176.85 | 1192.0 |
| 2024-03-21 04:50:00 | AAPL | Stock | 176.85 | 176.85 | 176.81 | 176.81 | 2424.0 |
| 2024-03-21 04:55:00 | AAPL | Stock | 176.75 | 176.79 | 176.51 | 176.79 | 3369.0 |
| 2024-03-21 05:00:00 | AAPL | Stock | 176.78 | 176.78 | 176.78 | 176.78 | 173.0 |
| 2024-03-21 05:05:00 | AAPL | Stock | 176.67 | 176.67 | 176.6 | 176.6 | 1594.0 |
| 2024-03-21 05:10:00 | AAPL | Stock | 176.61 | 176.61 | 176.34 | 176.34 | 2614.0 |
| 2024-03-21 05:15:00 | AAPL | Stock | 176.49 | 176.57 | 176.49 | 176.57 | 1345.0 |
| 2024-03-21 05:20:00 | AAPL | Stock | 176.6 | 176.73 | 176.6 | 176.73 | 1037.0 |
| 2024-03-21 05:25:00 | AAPL | Stock | 176.56 | 176.56 | 176.56 | 176.56 | 300.0 |
| 2024-03-21 05:30:00 | AAPL | Stock | 176.55 | 176.55 | 176.45 | 176.45 | 1324.0 |
| 2024-03-21 05:35:00 | AAPL | Stock | 176.43 | 176.43 | 176.43 | 176.43 | 100.0 |
| 2024-03-21 05:40:00 | AAPL | Stock | 176.58 | 176.67 | 176.58 | 176.67 | 2475.0 |
| 2024-03-21 05:45:00 | AAPL | Stock | 176.66 | 176.66 | 176.59 | 176.63 | 913.0 |
| 2024-03-21 05:50:00 | AAPL | Stock | 176.61 | 176.61 | 176.58 | 176.58 | 690.0 |
| 2024-03-21 06:00:00 | AAPL | Stock | 176.62 | 176.62 | 176.55 | 176.55 | 1021.0 |
| 2024-03-21 06:05:00 | AAPL | Stock | 176.55 | 176.6 | 176.51 | 176.6 | 2147.0 |
| 2024-03-21 06:15:00 | AAPL | Stock | 176.5 | 176.51 | 176.5 | 176.51 | 1273.0 |
| 2024-03-21 06:20:00 | AAPL | Stock | 176.49 | 176.5 | 176.46 | 176.5 | 700.0 |
| 2024-03-21 06:25:00 | AAPL | Stock | 176.47 | 176.56 | 176.47 | 176.53 | 1297.0 |
| 2024-03-21 06:30:00 | AAPL | Stock | 176.49 | 176.49 | 176.45 | 176.45 | 2645.0 |
| 2024-03-21 06:35:00 | AAPL | Stock | 176.44 | 176.44 | 176.4 | 176.4 | 2208.0 |
| 2024-03-21 06:40:00 | AAPL | Stock | 176.4 | 176.47 | 176.4 | 176.4 | 2914.0 |
| 2024-03-21 06:45:00 | AAPL | Stock | 176.4 | 176.45 | 176.36 | 176.4 | 2303.0 |
| 2024-03-21 06:50:00 | AAPL | Stock | 176.41 | 176.41 | 176.41 | 176.41 | 100.0 |
| 2024-03-21 06:55:00 | AAPL | Stock | 176.5 | 176.51 | 176.42 | 176.46 | 2946.0 |
| 2024-03-21 07:00:00 | AAPL | Stock | 176.52 | 176.69 | 176.4 | 176.68 | 29258.0 |
| 2024-03-21 07:05:00 | AAPL | Stock | 176.69 | 176.78 | 176.69 | 176.76 | 10946.0 |
| 2024-03-21 07:10:00 | AAPL | Stock | 176.77 | 176.79 | 176.76 | 176.78 | 2545.0 |
| 2024-03-21 07:15:00 | AAPL | Stock | 176.75 | 176.83 | 176.75 | 176.78 | 10635.0 |
| 2024-03-21 07:20:00 | AAPL | Stock | 176.78 | 176.79 | 176.77 | 176.78 | 1668.0 |
| 2024-03-21 07:25:00 | AAPL | Stock | 176.79 | 176.8 | 176.78 | 176.8 | 1583.0 |
| 2024-03-21 07:30:00 | AAPL | Stock | 176.77 | 176.84 | 176.75 | 176.84 | 1148.0 |
| 2024-03-21 07:35:00 | AAPL | Stock | 176.8 | 176.82 | 176.8 | 176.81 | 469.0 |
| 2024-03-21 07:40:00 | AAPL | Stock | 176.83 | 177.02 | 176.83 | 177.01 | 5023.0 |
| 2024-03-21 07:45:00 | AAPL | Stock | 177.01 | 177.01 | 176.92 | 176.96 | 2589.0 |
| 2024-03-21 07:50:00 | AAPL | Stock | 176.96 | 176.96 | 176.9 | 176.9 | 3268.0 |
| 2024-03-21 07:55:00 | AAPL | Stock | 176.9 | 176.911 | 176.9 | 176.9 | 4417.0 |
| 2024-03-21 08:00:00 | AAPL | Stock | 176.68 | 177.16 | 176.4 | 177.09 | 94514.0 |
| 2024-03-21 08:05:00 | AAPL | Stock | 177.09 | 177.1449 | 176.63 | 176.9792 | 16246.0 |
| 2024-03-21 08:10:00 | AAPL | Stock | 176.95 | 176.98 | 176.91 | 176.98 | 6207.0 |
| 2024-03-21 08:15:00 | AAPL | Stock | 176.98 | 177.14 | 176.97 | 177.12 | 12347.0 |
> showing 50 of 414,871 rows — these rows as CSV