PREVIEW / stock_5min / 2023-12-12
file: by_date/stock_5min/2023/2023-12-12.parquet size: 6.7 MB rows: 405,342 symbols: 1,285
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-12-12 04:00:00 | AAPL | Stock | 193.34 | 193.34 | 193.18 | 193.18 | 540.0 |
| 2023-12-12 04:05:00 | AAPL | Stock | 193.38 | 193.38 | 193.21 | 193.21 | 1324.0 |
| 2023-12-12 04:15:00 | AAPL | Stock | 193.2 | 193.2 | 193.2 | 193.2 | 121.0 |
| 2023-12-12 04:20:00 | AAPL | Stock | 193.25 | 193.26 | 193.25 | 193.26 | 200.0 |
| 2023-12-12 04:25:00 | AAPL | Stock | 193.24 | 193.24 | 193.24 | 193.24 | 936.0 |
| 2023-12-12 04:30:00 | AAPL | Stock | 193.18 | 193.18 | 193.18 | 193.18 | 389.0 |
| 2023-12-12 04:35:00 | AAPL | Stock | 193.2 | 193.2 | 193.01 | 193.05 | 3941.0 |
| 2023-12-12 04:45:00 | AAPL | Stock | 193.02 | 193.02 | 192.88 | 192.88 | 1481.0 |
| 2023-12-12 04:50:00 | AAPL | Stock | 192.83 | 192.84 | 192.75 | 192.83 | 2122.0 |
| 2023-12-12 04:55:00 | AAPL | Stock | 192.8 | 192.8 | 192.8 | 192.8 | 698.0 |
| 2023-12-12 05:00:00 | AAPL | Stock | 192.8 | 192.81 | 192.8 | 192.81 | 1010.0 |
| 2023-12-12 05:05:00 | AAPL | Stock | 192.82 | 192.84 | 192.81 | 192.82 | 3224.0 |
| 2023-12-12 05:10:00 | AAPL | Stock | 192.82 | 192.82 | 192.82 | 192.82 | 100.0 |
| 2023-12-12 05:15:00 | AAPL | Stock | 192.82 | 192.82 | 192.82 | 192.82 | 3922.0 |
| 2023-12-12 05:20:00 | AAPL | Stock | 192.78 | 192.78 | 192.73 | 192.73 | 1957.0 |
| 2023-12-12 05:25:00 | AAPL | Stock | 192.56 | 192.56 | 192.56 | 192.56 | 100.0 |
| 2023-12-12 05:30:00 | AAPL | Stock | 192.56 | 192.56 | 192.52 | 192.54 | 673.0 |
| 2023-12-12 05:35:00 | AAPL | Stock | 192.51 | 192.51 | 192.45 | 192.5 | 1901.0 |
| 2023-12-12 05:40:00 | AAPL | Stock | 192.62 | 192.62 | 192.62 | 192.62 | 223.0 |
| 2023-12-12 05:45:00 | AAPL | Stock | 192.61 | 192.61 | 192.5 | 192.5 | 5838.0 |
| 2023-12-12 05:50:00 | AAPL | Stock | 192.53 | 192.53 | 192.53 | 192.53 | 200.0 |
| 2023-12-12 05:55:00 | AAPL | Stock | 192.53 | 192.54 | 192.29 | 192.54 | 10893.0 |
| 2023-12-12 06:00:00 | AAPL | Stock | 192.54 | 192.54 | 192.54 | 192.54 | 100.0 |
| 2023-12-12 06:10:00 | AAPL | Stock | 192.66 | 192.7 | 192.65 | 192.7 | 2583.0 |
| 2023-12-12 06:15:00 | AAPL | Stock | 192.85 | 192.85 | 192.77 | 192.77 | 200.0 |
| 2023-12-12 06:30:00 | AAPL | Stock | 192.73 | 192.73 | 192.7 | 192.7 | 869.0 |
| 2023-12-12 06:35:00 | AAPL | Stock | 192.67 | 192.67 | 192.67 | 192.67 | 100.0 |
| 2023-12-12 06:40:00 | AAPL | Stock | 192.64 | 192.64 | 192.64 | 192.64 | 200.0 |
| 2023-12-12 07:00:00 | AAPL | Stock | 192.74 | 192.86 | 192.65 | 192.79 | 4165.0 |
| 2023-12-12 07:05:00 | AAPL | Stock | 192.75 | 192.75 | 192.75 | 192.75 | 304.0 |
| 2023-12-12 07:10:00 | AAPL | Stock | 192.76 | 192.8 | 192.7 | 192.7 | 2896.0 |
| 2023-12-12 07:15:00 | AAPL | Stock | 192.83 | 192.86 | 192.83 | 192.86 | 728.0 |
| 2023-12-12 07:20:00 | AAPL | Stock | 192.82 | 192.88 | 192.8 | 192.8 | 3265.0 |
| 2023-12-12 07:25:00 | AAPL | Stock | 192.87 | 192.9 | 192.86 | 192.86 | 1250.0 |
| 2023-12-12 07:30:00 | AAPL | Stock | 192.89 | 192.89 | 192.85 | 192.85 | 1100.0 |
| 2023-12-12 07:35:00 | AAPL | Stock | 192.9 | 192.9 | 192.9 | 192.9 | 102.0 |
| 2023-12-12 07:40:00 | AAPL | Stock | 192.94 | 192.98 | 192.9 | 192.98 | 3753.0 |
| 2023-12-12 07:45:00 | AAPL | Stock | 193.0 | 193.08 | 193.0 | 193.08 | 760.0 |
| 2023-12-12 07:50:00 | AAPL | Stock | 193.08 | 193.13 | 193.08 | 193.11 | 4321.0 |
| 2023-12-12 07:55:00 | AAPL | Stock | 193.13 | 193.24 | 193.1 | 193.12 | 9276.0 |
| 2023-12-12 08:00:00 | AAPL | Stock | 192.73 | 193.24 | 192.5543 | 193.0 | 39422.0 |
| 2023-12-12 08:05:00 | AAPL | Stock | 192.99 | 193.1277 | 192.94 | 193.0 | 4713.0 |
| 2023-12-12 08:10:00 | AAPL | Stock | 192.99 | 193.0 | 192.867 | 192.9 | 3993.0 |
| 2023-12-12 08:15:00 | AAPL | Stock | 192.91 | 193.06 | 192.91 | 193.0 | 6484.0 |
| 2023-12-12 08:20:00 | AAPL | Stock | 193.02 | 193.02 | 192.9 | 193.0 | 10502.0 |
| 2023-12-12 08:25:00 | AAPL | Stock | 192.99 | 193.25 | 192.99 | 193.25 | 6104.0 |
| 2023-12-12 08:30:00 | AAPL | Stock | 192.99 | 193.55 | 192.6 | 192.6987 | 49777.0 |
| 2023-12-12 08:35:00 | AAPL | Stock | 192.65 | 192.9 | 192.23 | 192.66 | 55605.0 |
| 2023-12-12 08:40:00 | AAPL | Stock | 192.66 | 192.83 | 192.6 | 192.63 | 21103.0 |
| 2023-12-12 08:45:00 | AAPL | Stock | 192.63 | 192.63 | 192.33 | 192.49 | 14518.0 |
> showing 50 of 405,342 rows — these rows as CSV