PREVIEW / stock_5min / 2021-10-12
file: by_date/stock_5min/2021/2021-10-12.parquet size: 7.1 MB rows: 432,671 symbols: 2,670
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-12 04:00:00 | AAPL | Stock | 142.3 | 142.46 | 142.23 | 142.4 | 2403.0 |
| 2021-10-12 04:05:00 | AAPL | Stock | 142.4 | 142.47 | 142.31 | 142.47 | 3029.0 |
| 2021-10-12 04:10:00 | AAPL | Stock | 142.44 | 142.5 | 142.44 | 142.5 | 488.0 |
| 2021-10-12 04:15:00 | AAPL | Stock | 142.43 | 142.43 | 142.39 | 142.39 | 858.0 |
| 2021-10-12 04:20:00 | AAPL | Stock | 142.4 | 142.4 | 142.29 | 142.39 | 28847.0 |
| 2021-10-12 04:25:00 | AAPL | Stock | 142.36 | 142.36 | 142.25 | 142.27 | 2266.0 |
| 2021-10-12 04:30:00 | AAPL | Stock | 142.26 | 142.3 | 142.2 | 142.2 | 4161.0 |
| 2021-10-12 04:35:00 | AAPL | Stock | 142.25 | 142.3 | 142.25 | 142.28 | 7313.0 |
| 2021-10-12 04:40:00 | AAPL | Stock | 142.29 | 142.3 | 142.29 | 142.3 | 4903.0 |
| 2021-10-12 04:45:00 | AAPL | Stock | 142.3 | 142.3 | 142.27 | 142.3 | 40651.0 |
| 2021-10-12 04:50:00 | AAPL | Stock | 142.3 | 142.35 | 142.3 | 142.35 | 19689.0 |
| 2021-10-12 05:00:00 | AAPL | Stock | 142.46 | 142.5 | 142.4 | 142.5 | 3581.0 |
| 2021-10-12 05:05:00 | AAPL | Stock | 142.55 | 142.71 | 142.55 | 142.61 | 3687.0 |
| 2021-10-12 05:10:00 | AAPL | Stock | 142.51 | 142.8 | 142.51 | 142.79 | 6499.0 |
| 2021-10-12 05:15:00 | AAPL | Stock | 142.64 | 142.64 | 142.64 | 142.64 | 336.0 |
| 2021-10-12 05:20:00 | AAPL | Stock | 142.78 | 142.78 | 142.78 | 142.78 | 195.0 |
| 2021-10-12 05:25:00 | AAPL | Stock | 142.77 | 142.77 | 142.74 | 142.74 | 515.0 |
| 2021-10-12 05:30:00 | AAPL | Stock | 142.76 | 142.77 | 142.72 | 142.72 | 2102.0 |
| 2021-10-12 05:35:00 | AAPL | Stock | 142.75 | 142.75 | 142.68 | 142.72 | 656.0 |
| 2021-10-12 05:40:00 | AAPL | Stock | 142.68 | 142.68 | 142.67 | 142.67 | 541.0 |
| 2021-10-12 05:45:00 | AAPL | Stock | 142.69 | 142.7 | 142.69 | 142.7 | 1269.0 |
| 2021-10-12 05:50:00 | AAPL | Stock | 142.7 | 142.7 | 142.7 | 142.7 | 100.0 |
| 2021-10-12 05:55:00 | AAPL | Stock | 142.77 | 142.77 | 142.7 | 142.7 | 1467.0 |
| 2021-10-12 06:00:00 | AAPL | Stock | 142.75 | 142.77 | 142.75 | 142.77 | 500.0 |
| 2021-10-12 06:05:00 | AAPL | Stock | 142.83 | 142.85 | 142.82 | 142.82 | 999.0 |
| 2021-10-12 06:10:00 | AAPL | Stock | 142.76 | 142.76 | 142.76 | 142.76 | 439.0 |
| 2021-10-12 06:15:00 | AAPL | Stock | 142.73 | 142.73 | 142.66 | 142.66 | 374.0 |
| 2021-10-12 06:20:00 | AAPL | Stock | 142.78 | 142.8 | 142.78 | 142.79 | 1165.0 |
| 2021-10-12 06:30:00 | AAPL | Stock | 142.8 | 142.8 | 142.8 | 142.8 | 458.0 |
| 2021-10-12 06:35:00 | AAPL | Stock | 142.8 | 142.8 | 142.8 | 142.8 | 1856.0 |
| 2021-10-12 06:40:00 | AAPL | Stock | 142.79 | 142.87 | 142.79 | 142.87 | 1025.0 |
| 2021-10-12 06:45:00 | AAPL | Stock | 142.87 | 142.94 | 142.86 | 142.94 | 2300.0 |
| 2021-10-12 06:50:00 | AAPL | Stock | 142.94 | 142.94 | 142.9 | 142.9 | 495.0 |
| 2021-10-12 06:55:00 | AAPL | Stock | 142.9 | 143.0 | 142.9 | 143.0 | 2524.0 |
| 2021-10-12 07:00:00 | AAPL | Stock | 143.01 | 143.07 | 142.9 | 142.92 | 21753.0 |
| 2021-10-12 07:05:00 | AAPL | Stock | 142.95 | 143.13 | 142.95 | 143.13 | 14126.0 |
| 2021-10-12 07:10:00 | AAPL | Stock | 143.05 | 143.08 | 143.05 | 143.08 | 6262.0 |
| 2021-10-12 07:15:00 | AAPL | Stock | 143.09 | 143.18 | 143.06 | 143.08 | 8601.0 |
| 2021-10-12 07:20:00 | AAPL | Stock | 143.1 | 143.18 | 143.1 | 143.16 | 7343.0 |
| 2021-10-12 07:25:00 | AAPL | Stock | 143.17 | 143.22 | 143.14 | 143.18 | 11487.0 |
| 2021-10-12 07:30:00 | AAPL | Stock | 143.16 | 143.2 | 143.1 | 143.1 | 6050.0 |
| 2021-10-12 07:35:00 | AAPL | Stock | 143.07 | 143.1 | 143.05 | 143.07 | 12743.0 |
| 2021-10-12 07:40:00 | AAPL | Stock | 143.07 | 143.07 | 143.01 | 143.01 | 5889.0 |
| 2021-10-12 07:45:00 | AAPL | Stock | 143.02 | 143.03 | 142.9 | 142.98 | 33773.0 |
| 2021-10-12 07:50:00 | AAPL | Stock | 142.98 | 143.04 | 142.96 | 143.04 | 2971.0 |
| 2021-10-12 07:55:00 | AAPL | Stock | 143.04 | 143.04 | 142.97 | 143.0 | 2869.0 |
| 2021-10-12 08:00:00 | AAPL | Stock | 143.02 | 143.22 | 142.9 | 143.04 | 166576.0 |
| 2021-10-12 08:05:00 | AAPL | Stock | 143.08 | 143.18 | 143.06 | 143.14 | 19407.0 |
| 2021-10-12 08:10:00 | AAPL | Stock | 143.1 | 143.18 | 143.07 | 143.18 | 7767.0 |
| 2021-10-12 08:15:00 | AAPL | Stock | 143.18 | 143.26 | 143.1603 | 143.21 | 13928.0 |
> showing 50 of 432,671 rows — these rows as CSV