PREVIEW / stock_5min / 2023-04-12
file: by_date/stock_5min/2023/2023-04-12.parquet size: 6.6 MB rows: 409,386 symbols: 1,760
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-04-12 04:05:00 | AAPL | Stock | 160.7 | 160.8 | 160.7 | 160.8 | 750.0 |
| 2023-04-12 04:15:00 | AAPL | Stock | 160.86 | 160.86 | 160.86 | 160.86 | 226.0 |
| 2023-04-12 04:20:00 | AAPL | Stock | 160.83 | 160.83 | 160.79 | 160.79 | 4870.0 |
| 2023-04-12 04:25:00 | AAPL | Stock | 160.86 | 160.86 | 160.86 | 160.86 | 139.0 |
| 2023-04-12 04:30:00 | AAPL | Stock | 160.82 | 160.82 | 160.82 | 160.82 | 100.0 |
| 2023-04-12 04:45:00 | AAPL | Stock | 160.87 | 160.87 | 160.84 | 160.84 | 969.0 |
| 2023-04-12 04:50:00 | AAPL | Stock | 160.85 | 160.95 | 160.84 | 160.95 | 12544.0 |
| 2023-04-12 04:55:00 | AAPL | Stock | 160.91 | 160.91 | 160.82 | 160.85 | 1221.0 |
| 2023-04-12 05:00:00 | AAPL | Stock | 160.9 | 160.9 | 160.85 | 160.85 | 600.0 |
| 2023-04-12 05:05:00 | AAPL | Stock | 160.87 | 160.9 | 160.87 | 160.9 | 2665.0 |
| 2023-04-12 05:10:00 | AAPL | Stock | 160.9 | 160.9 | 160.9 | 160.9 | 414.0 |
| 2023-04-12 05:15:00 | AAPL | Stock | 160.82 | 160.82 | 160.82 | 160.82 | 107.0 |
| 2023-04-12 05:20:00 | AAPL | Stock | 160.82 | 160.82 | 160.82 | 160.82 | 418.0 |
| 2023-04-12 05:25:00 | AAPL | Stock | 160.88 | 160.88 | 160.88 | 160.88 | 677.0 |
| 2023-04-12 05:30:00 | AAPL | Stock | 160.89 | 160.89 | 160.87 | 160.87 | 500.0 |
| 2023-04-12 05:35:00 | AAPL | Stock | 160.86 | 160.89 | 160.86 | 160.89 | 715.0 |
| 2023-04-12 05:45:00 | AAPL | Stock | 160.89 | 160.89 | 160.89 | 160.89 | 107.0 |
| 2023-04-12 05:55:00 | AAPL | Stock | 160.89 | 160.9 | 160.89 | 160.9 | 1400.0 |
| 2023-04-12 06:00:00 | AAPL | Stock | 160.98 | 160.99 | 160.98 | 160.99 | 1607.0 |
| 2023-04-12 06:10:00 | AAPL | Stock | 160.99 | 161.1 | 160.99 | 161.1 | 1221.0 |
| 2023-04-12 06:35:00 | AAPL | Stock | 160.88 | 160.88 | 160.88 | 160.88 | 237.0 |
| 2023-04-12 06:40:00 | AAPL | Stock | 160.88 | 160.89 | 160.8 | 160.8 | 2301.0 |
| 2023-04-12 06:45:00 | AAPL | Stock | 160.75 | 160.75 | 160.69 | 160.69 | 3826.0 |
| 2023-04-12 06:50:00 | AAPL | Stock | 160.71 | 160.71 | 160.71 | 160.71 | 200.0 |
| 2023-04-12 06:55:00 | AAPL | Stock | 160.68 | 160.68 | 160.62 | 160.62 | 326.0 |
| 2023-04-12 07:00:00 | AAPL | Stock | 160.63 | 160.8 | 160.63 | 160.72 | 1141.0 |
| 2023-04-12 07:05:00 | AAPL | Stock | 160.7 | 160.7 | 160.68 | 160.69 | 600.0 |
| 2023-04-12 07:10:00 | AAPL | Stock | 160.69 | 160.69 | 160.69 | 160.69 | 138.0 |
| 2023-04-12 07:15:00 | AAPL | Stock | 160.75 | 160.8 | 160.72 | 160.72 | 2026.0 |
| 2023-04-12 07:25:00 | AAPL | Stock | 160.68 | 160.68 | 160.64 | 160.64 | 922.0 |
| 2023-04-12 07:30:00 | AAPL | Stock | 160.62 | 160.7 | 160.62 | 160.7 | 542.0 |
| 2023-04-12 07:35:00 | AAPL | Stock | 160.74 | 160.78 | 160.74 | 160.78 | 235.0 |
| 2023-04-12 07:40:00 | AAPL | Stock | 160.82 | 160.82 | 160.82 | 160.82 | 694.0 |
| 2023-04-12 07:50:00 | AAPL | Stock | 160.89 | 160.89 | 160.89 | 160.89 | 500.0 |
| 2023-04-12 07:55:00 | AAPL | Stock | 160.89 | 160.92 | 160.89 | 160.91 | 1025.0 |
| 2023-04-12 08:00:00 | AAPL | Stock | 160.621 | 160.85 | 160.398 | 160.76 | 8279.0 |
| 2023-04-12 08:05:00 | AAPL | Stock | 160.79 | 160.8975 | 160.79 | 160.81 | 420.0 |
| 2023-04-12 08:10:00 | AAPL | Stock | 160.88 | 160.8996 | 160.79 | 160.8772 | 4651.0 |
| 2023-04-12 08:15:00 | AAPL | Stock | 160.8 | 160.87 | 160.75 | 160.79 | 9639.0 |
| 2023-04-12 08:20:00 | AAPL | Stock | 160.79 | 160.79 | 160.7 | 160.78 | 6906.0 |
| 2023-04-12 08:25:00 | AAPL | Stock | 160.75 | 160.85 | 160.6 | 160.68 | 21313.0 |
| 2023-04-12 08:30:00 | AAPL | Stock | 160.85 | 162.26 | 160.85 | 162.24 | 166671.0 |
| 2023-04-12 08:35:00 | AAPL | Stock | 162.2 | 162.3 | 161.7711 | 161.92 | 63522.0 |
| 2023-04-12 08:40:00 | AAPL | Stock | 161.96 | 162.09 | 161.55 | 161.78 | 45564.0 |
| 2023-04-12 08:45:00 | AAPL | Stock | 161.76 | 161.8 | 161.55 | 161.76 | 25922.0 |
| 2023-04-12 08:50:00 | AAPL | Stock | 161.63 | 161.95 | 161.55 | 161.88 | 43701.0 |
| 2023-04-12 08:55:00 | AAPL | Stock | 161.8 | 161.93 | 161.59 | 161.59 | 31220.0 |
| 2023-04-12 09:00:00 | AAPL | Stock | 161.6 | 161.65 | 161.37 | 161.55 | 58666.0 |
| 2023-04-12 09:05:00 | AAPL | Stock | 161.55 | 161.61 | 161.44 | 161.5602 | 28262.0 |
| 2023-04-12 09:10:00 | AAPL | Stock | 161.6187 | 161.93 | 161.5994 | 161.86 | 19210.0 |
> showing 50 of 409,386 rows — these rows as CSV