PREVIEW / stock_5min / 2024-09-27
file: by_date/stock_5min/2024/2024-09-27.parquet size: 6.7 MB rows: 404,139 symbols: 770
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-09-27 04:00:00 | AAPL | Stock | 226.4 | 227.23 | 226.11 | 227.23 | 4069.0 |
| 2024-09-27 04:05:00 | AAPL | Stock | 227.19 | 227.19 | 227.07 | 227.07 | 4276.0 |
| 2024-09-27 04:10:00 | AAPL | Stock | 227.34 | 227.34 | 227.3 | 227.3 | 426.0 |
| 2024-09-27 04:15:00 | AAPL | Stock | 227.4 | 227.4 | 227.32 | 227.36 | 500.0 |
| 2024-09-27 04:20:00 | AAPL | Stock | 227.36 | 227.39 | 227.36 | 227.39 | 999.0 |
| 2024-09-27 04:25:00 | AAPL | Stock | 227.5 | 227.57 | 227.46 | 227.57 | 1150.0 |
| 2024-09-27 04:30:00 | AAPL | Stock | 227.56 | 227.62 | 227.4 | 227.42 | 3734.0 |
| 2024-09-27 04:40:00 | AAPL | Stock | 227.45 | 227.47 | 227.4 | 227.45 | 600.0 |
| 2024-09-27 04:45:00 | AAPL | Stock | 227.34 | 227.34 | 227.34 | 227.34 | 100.0 |
| 2024-09-27 04:50:00 | AAPL | Stock | 227.39 | 227.39 | 227.34 | 227.34 | 262.0 |
| 2024-09-27 04:55:00 | AAPL | Stock | 227.24 | 227.24 | 227.24 | 227.24 | 100.0 |
| 2024-09-27 05:05:00 | AAPL | Stock | 227.24 | 227.24 | 227.23 | 227.23 | 554.0 |
| 2024-09-27 05:10:00 | AAPL | Stock | 227.32 | 227.32 | 227.0 | 227.11 | 4426.0 |
| 2024-09-27 05:15:00 | AAPL | Stock | 227.35 | 227.52 | 227.35 | 227.52 | 354.0 |
| 2024-09-27 05:20:00 | AAPL | Stock | 227.53 | 227.53 | 227.52 | 227.52 | 600.0 |
| 2024-09-27 05:25:00 | AAPL | Stock | 227.43 | 227.43 | 227.43 | 227.43 | 103.0 |
| 2024-09-27 05:30:00 | AAPL | Stock | 227.26 | 227.26 | 227.14 | 227.14 | 283.0 |
| 2024-09-27 05:35:00 | AAPL | Stock | 227.2 | 227.2 | 227.15 | 227.15 | 574.0 |
| 2024-09-27 05:40:00 | AAPL | Stock | 227.23 | 227.23 | 227.23 | 227.23 | 207.0 |
| 2024-09-27 05:45:00 | AAPL | Stock | 227.3 | 227.3 | 227.3 | 227.3 | 400.0 |
| 2024-09-27 05:50:00 | AAPL | Stock | 227.33 | 227.65 | 227.26 | 227.65 | 4679.0 |
| 2024-09-27 05:55:00 | AAPL | Stock | 227.74 | 228.11 | 227.74 | 228.11 | 7415.0 |
| 2024-09-27 06:00:00 | AAPL | Stock | 227.92 | 227.92 | 227.85 | 227.85 | 797.0 |
| 2024-09-27 06:10:00 | AAPL | Stock | 227.97 | 227.97 | 227.97 | 227.97 | 350.0 |
| 2024-09-27 06:15:00 | AAPL | Stock | 227.97 | 227.97 | 227.97 | 227.97 | 100.0 |
| 2024-09-27 06:20:00 | AAPL | Stock | 228.09 | 228.09 | 228.0 | 228.0 | 450.0 |
| 2024-09-27 06:25:00 | AAPL | Stock | 228.0 | 228.0 | 228.0 | 228.0 | 300.0 |
| 2024-09-27 06:30:00 | AAPL | Stock | 227.94 | 228.0 | 227.72 | 227.72 | 2076.0 |
| 2024-09-27 06:35:00 | AAPL | Stock | 227.57 | 227.75 | 227.57 | 227.57 | 2955.0 |
| 2024-09-27 06:40:00 | AAPL | Stock | 227.52 | 227.52 | 227.52 | 227.52 | 800.0 |
| 2024-09-27 06:45:00 | AAPL | Stock | 227.62 | 227.77 | 227.62 | 227.77 | 540.0 |
| 2024-09-27 06:50:00 | AAPL | Stock | 227.72 | 227.72 | 227.72 | 227.72 | 500.0 |
| 2024-09-27 07:00:00 | AAPL | Stock | 227.68 | 227.68 | 227.68 | 227.68 | 100.0 |
| 2024-09-27 07:05:00 | AAPL | Stock | 227.62 | 227.68 | 227.62 | 227.63 | 724.0 |
| 2024-09-27 07:10:00 | AAPL | Stock | 227.62 | 227.62 | 227.62 | 227.62 | 100.0 |
| 2024-09-27 07:15:00 | AAPL | Stock | 227.67 | 227.68 | 227.67 | 227.68 | 365.0 |
| 2024-09-27 07:20:00 | AAPL | Stock | 227.75 | 227.99 | 227.75 | 227.99 | 2469.0 |
| 2024-09-27 07:30:00 | AAPL | Stock | 227.85 | 227.85 | 227.85 | 227.85 | 100.0 |
| 2024-09-27 07:35:00 | AAPL | Stock | 227.77 | 227.77 | 227.75 | 227.75 | 443.0 |
| 2024-09-27 07:45:00 | AAPL | Stock | 227.78 | 227.9 | 227.78 | 227.9 | 829.0 |
| 2024-09-27 07:50:00 | AAPL | Stock | 227.98 | 228.1 | 227.98 | 228.1 | 1490.0 |
| 2024-09-27 07:55:00 | AAPL | Stock | 228.11 | 228.11 | 227.99 | 228.01 | 763.0 |
| 2024-09-27 08:00:00 | AAPL | Stock | 227.69 | 228.0865 | 226.89 | 227.99 | 19945.0 |
| 2024-09-27 08:05:00 | AAPL | Stock | 228.0 | 228.07 | 226.952 | 228.0425 | 5720.0 |
| 2024-09-27 08:10:00 | AAPL | Stock | 228.06 | 228.1 | 228.01 | 228.1 | 2523.0 |
| 2024-09-27 08:15:00 | AAPL | Stock | 228.1257 | 228.13 | 228.0 | 228.05 | 3188.0 |
| 2024-09-27 08:20:00 | AAPL | Stock | 228.01 | 228.08 | 228.01 | 228.08 | 1925.0 |
| 2024-09-27 08:25:00 | AAPL | Stock | 228.0001 | 228.15 | 228.0001 | 228.1467 | 4292.0 |
| 2024-09-27 08:30:00 | AAPL | Stock | 228.15 | 228.47 | 228.15 | 228.42 | 8754.0 |
| 2024-09-27 08:35:00 | AAPL | Stock | 228.37 | 228.49 | 228.3 | 228.3001 | 7247.0 |
> showing 50 of 404,139 rows — these rows as CSV