PREVIEW / stock_5min / 2023-06-08
file: by_date/stock_5min/2023/2023-06-08.parquet size: 6.7 MB rows: 409,070 symbols: 1,621
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 |
|---|---|---|---|---|---|---|---|
| 2023-06-08 04:00:00 | AAPL | Stock | 177.69 | 177.69 | 177.21 | 177.32 | 2210.0 |
| 2023-06-08 04:05:00 | AAPL | Stock | 177.23 | 177.3 | 177.23 | 177.23 | 845.0 |
| 2023-06-08 04:10:00 | AAPL | Stock | 177.33 | 177.4 | 177.32 | 177.36 | 1945.0 |
| 2023-06-08 04:15:00 | AAPL | Stock | 177.42 | 177.48 | 177.42 | 177.48 | 300.0 |
| 2023-06-08 04:25:00 | AAPL | Stock | 177.61 | 177.67 | 177.6 | 177.65 | 1369.0 |
| 2023-06-08 04:35:00 | AAPL | Stock | 177.77 | 177.77 | 177.75 | 177.75 | 1076.0 |
| 2023-06-08 04:45:00 | AAPL | Stock | 177.7 | 177.7 | 177.65 | 177.65 | 850.0 |
| 2023-06-08 04:50:00 | AAPL | Stock | 177.64 | 177.64 | 177.61 | 177.61 | 904.0 |
| 2023-06-08 04:55:00 | AAPL | Stock | 177.74 | 177.77 | 177.74 | 177.77 | 859.0 |
| 2023-06-08 05:10:00 | AAPL | Stock | 177.82 | 177.91 | 177.82 | 177.91 | 1489.0 |
| 2023-06-08 05:15:00 | AAPL | Stock | 177.91 | 177.91 | 177.88 | 177.88 | 2244.0 |
| 2023-06-08 05:20:00 | AAPL | Stock | 177.99 | 177.99 | 177.99 | 177.99 | 224.0 |
| 2023-06-08 05:30:00 | AAPL | Stock | 177.98 | 177.99 | 177.98 | 177.99 | 212.0 |
| 2023-06-08 05:35:00 | AAPL | Stock | 177.93 | 178.03 | 177.89 | 178.03 | 419.0 |
| 2023-06-08 05:40:00 | AAPL | Stock | 178.1 | 178.25 | 178.1 | 178.25 | 790.0 |
| 2023-06-08 05:45:00 | AAPL | Stock | 178.19 | 178.25 | 178.19 | 178.25 | 200.0 |
| 2023-06-08 05:50:00 | AAPL | Stock | 178.24 | 178.27 | 178.22 | 178.27 | 3276.0 |
| 2023-06-08 05:55:00 | AAPL | Stock | 178.27 | 178.27 | 178.27 | 178.27 | 2509.0 |
| 2023-06-08 06:00:00 | AAPL | Stock | 178.01 | 178.07 | 178.01 | 178.03 | 1207.0 |
| 2023-06-08 06:10:00 | AAPL | Stock | 178.12 | 178.19 | 178.12 | 178.19 | 260.0 |
| 2023-06-08 06:15:00 | AAPL | Stock | 178.36 | 178.36 | 178.17 | 178.26 | 745.0 |
| 2023-06-08 06:20:00 | AAPL | Stock | 178.17 | 178.17 | 178.17 | 178.17 | 148.0 |
| 2023-06-08 06:30:00 | AAPL | Stock | 178.03 | 178.03 | 178.02 | 178.02 | 353.0 |
| 2023-06-08 06:35:00 | AAPL | Stock | 178.04 | 178.15 | 178.03 | 178.11 | 1460.0 |
| 2023-06-08 06:40:00 | AAPL | Stock | 178.11 | 178.11 | 178.03 | 178.03 | 540.0 |
| 2023-06-08 06:45:00 | AAPL | Stock | 178.04 | 178.15 | 177.99 | 178.15 | 2396.0 |
| 2023-06-08 06:50:00 | AAPL | Stock | 178.0 | 178.0 | 177.83 | 177.91 | 2008.0 |
| 2023-06-08 07:00:00 | AAPL | Stock | 177.94 | 178.1 | 177.9 | 178.05 | 8133.0 |
| 2023-06-08 07:05:00 | AAPL | Stock | 178.02 | 178.05 | 177.87 | 177.89 | 8820.0 |
| 2023-06-08 07:10:00 | AAPL | Stock | 177.94 | 177.94 | 177.74 | 177.75 | 8854.0 |
| 2023-06-08 07:15:00 | AAPL | Stock | 177.75 | 177.84 | 177.75 | 177.79 | 2667.0 |
| 2023-06-08 07:20:00 | AAPL | Stock | 177.8 | 177.85 | 177.8 | 177.85 | 1344.0 |
| 2023-06-08 07:25:00 | AAPL | Stock | 177.82 | 177.86 | 177.79 | 177.79 | 3011.0 |
| 2023-06-08 07:30:00 | AAPL | Stock | 177.82 | 177.82 | 177.7 | 177.7 | 2022.0 |
| 2023-06-08 07:35:00 | AAPL | Stock | 177.66 | 177.67 | 177.52 | 177.67 | 3626.0 |
| 2023-06-08 07:40:00 | AAPL | Stock | 177.65 | 177.68 | 177.65 | 177.68 | 2535.0 |
| 2023-06-08 07:45:00 | AAPL | Stock | 177.67 | 177.68 | 177.65 | 177.65 | 1603.0 |
| 2023-06-08 07:50:00 | AAPL | Stock | 177.65 | 177.76 | 177.65 | 177.75 | 4236.0 |
| 2023-06-08 08:00:00 | AAPL | Stock | 177.99 | 178.2685 | 176.58 | 177.75 | 38119.0 |
| 2023-06-08 08:05:00 | AAPL | Stock | 177.71 | 177.77 | 177.6501 | 177.7 | 4966.0 |
| 2023-06-08 08:10:00 | AAPL | Stock | 177.67 | 177.72 | 177.5154 | 177.5154 | 10363.0 |
| 2023-06-08 08:15:00 | AAPL | Stock | 177.55 | 177.5876 | 177.4 | 177.5876 | 4754.0 |
| 2023-06-08 08:20:00 | AAPL | Stock | 177.55 | 177.5899 | 177.48 | 177.58 | 5774.0 |
| 2023-06-08 08:25:00 | AAPL | Stock | 177.63 | 177.6583 | 177.6 | 177.6 | 3956.0 |
| 2023-06-08 08:30:00 | AAPL | Stock | 177.65 | 178.5 | 177.6 | 178.0 | 42905.0 |
| 2023-06-08 08:35:00 | AAPL | Stock | 178.0 | 178.23 | 177.94 | 177.94 | 20923.0 |
| 2023-06-08 08:40:00 | AAPL | Stock | 177.94 | 178.04 | 177.84 | 177.99 | 2903.0 |
| 2023-06-08 08:45:00 | AAPL | Stock | 178.0 | 178.1 | 177.9 | 177.95 | 19752.0 |
| 2023-06-08 08:50:00 | AAPL | Stock | 177.96 | 178.23 | 177.96 | 178.15 | 15088.0 |
| 2023-06-08 08:55:00 | AAPL | Stock | 178.03 | 178.03 | 177.57 | 177.96 | 21243.0 |
> showing 50 of 409,070 rows — these rows as CSV