PREVIEW / stock_5min / 2022-10-11
file: by_date/stock_5min/2022/2022-10-11.parquet size: 6.7 MB rows: 414,700 symbols: 2,201
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 |
|---|---|---|---|---|---|---|---|
| 2022-10-11 04:00:00 | AAPL | Stock | 139.69 | 139.82 | 139.34 | 139.63 | 4299.0 |
| 2022-10-11 04:05:00 | AAPL | Stock | 139.78 | 140.03 | 139.67 | 140.0 | 3781.0 |
| 2022-10-11 04:10:00 | AAPL | Stock | 139.9 | 139.99 | 139.9 | 139.99 | 1275.0 |
| 2022-10-11 04:15:00 | AAPL | Stock | 139.92 | 139.92 | 139.61 | 139.61 | 7589.0 |
| 2022-10-11 04:20:00 | AAPL | Stock | 139.7 | 139.82 | 139.7 | 139.7 | 1780.0 |
| 2022-10-11 04:25:00 | AAPL | Stock | 139.67 | 139.67 | 139.62 | 139.62 | 1270.0 |
| 2022-10-11 04:30:00 | AAPL | Stock | 139.6 | 139.6 | 139.5 | 139.52 | 4604.0 |
| 2022-10-11 04:35:00 | AAPL | Stock | 139.42 | 139.42 | 139.28 | 139.31 | 2480.0 |
| 2022-10-11 04:40:00 | AAPL | Stock | 139.32 | 139.57 | 139.32 | 139.43 | 1433.0 |
| 2022-10-11 04:45:00 | AAPL | Stock | 139.41 | 139.5 | 139.41 | 139.43 | 2108.0 |
| 2022-10-11 04:50:00 | AAPL | Stock | 139.41 | 139.41 | 139.04 | 139.12 | 3352.0 |
| 2022-10-11 04:55:00 | AAPL | Stock | 139.24 | 139.24 | 139.12 | 139.13 | 1381.0 |
| 2022-10-11 05:00:00 | AAPL | Stock | 139.17 | 139.36 | 139.15 | 139.32 | 1868.0 |
| 2022-10-11 05:05:00 | AAPL | Stock | 139.37 | 139.37 | 139.13 | 139.34 | 4367.0 |
| 2022-10-11 05:10:00 | AAPL | Stock | 139.37 | 139.37 | 139.37 | 139.37 | 117.0 |
| 2022-10-11 05:15:00 | AAPL | Stock | 139.37 | 139.37 | 139.35 | 139.35 | 325.0 |
| 2022-10-11 05:20:00 | AAPL | Stock | 139.35 | 139.46 | 139.35 | 139.46 | 702.0 |
| 2022-10-11 05:25:00 | AAPL | Stock | 139.45 | 139.45 | 139.35 | 139.35 | 311.0 |
| 2022-10-11 05:30:00 | AAPL | Stock | 139.35 | 139.35 | 139.12 | 139.14 | 2282.0 |
| 2022-10-11 05:35:00 | AAPL | Stock | 139.14 | 139.29 | 139.14 | 139.29 | 897.0 |
| 2022-10-11 05:40:00 | AAPL | Stock | 139.24 | 139.24 | 139.16 | 139.24 | 946.0 |
| 2022-10-11 05:45:00 | AAPL | Stock | 139.24 | 139.24 | 139.12 | 139.14 | 2808.0 |
| 2022-10-11 05:50:00 | AAPL | Stock | 139.14 | 139.34 | 139.06 | 139.33 | 3786.0 |
| 2022-10-11 05:55:00 | AAPL | Stock | 139.32 | 139.45 | 139.29 | 139.31 | 1645.0 |
| 2022-10-11 06:00:00 | AAPL | Stock | 139.17 | 139.2 | 139.04 | 139.04 | 8555.0 |
| 2022-10-11 06:05:00 | AAPL | Stock | 139.16 | 139.16 | 139.0 | 139.06 | 6802.0 |
| 2022-10-11 06:10:00 | AAPL | Stock | 139.09 | 139.29 | 139.09 | 139.25 | 3035.0 |
| 2022-10-11 06:15:00 | AAPL | Stock | 139.21 | 139.27 | 139.1 | 139.1 | 876.0 |
| 2022-10-11 06:20:00 | AAPL | Stock | 139.13 | 139.23 | 139.12 | 139.23 | 2668.0 |
| 2022-10-11 06:25:00 | AAPL | Stock | 139.28 | 139.49 | 139.25 | 139.27 | 8192.0 |
| 2022-10-11 06:30:00 | AAPL | Stock | 139.3 | 139.31 | 139.3 | 139.3 | 1400.0 |
| 2022-10-11 06:35:00 | AAPL | Stock | 139.33 | 139.47 | 139.33 | 139.35 | 486.0 |
| 2022-10-11 06:40:00 | AAPL | Stock | 139.4 | 139.48 | 139.4 | 139.48 | 1509.0 |
| 2022-10-11 06:45:00 | AAPL | Stock | 139.48 | 139.48 | 139.4 | 139.45 | 2290.0 |
| 2022-10-11 06:50:00 | AAPL | Stock | 139.45 | 139.5 | 139.45 | 139.5 | 2348.0 |
| 2022-10-11 06:55:00 | AAPL | Stock | 139.55 | 139.63 | 139.55 | 139.62 | 684.0 |
| 2022-10-11 07:00:00 | AAPL | Stock | 139.62 | 139.79 | 139.62 | 139.75 | 28541.0 |
| 2022-10-11 07:05:00 | AAPL | Stock | 139.75 | 139.9 | 139.75 | 139.83 | 12948.0 |
| 2022-10-11 07:10:00 | AAPL | Stock | 139.82 | 139.89 | 139.82 | 139.83 | 1978.0 |
| 2022-10-11 07:15:00 | AAPL | Stock | 139.9 | 139.93 | 139.85 | 139.93 | 4805.0 |
| 2022-10-11 07:20:00 | AAPL | Stock | 139.94 | 140.0 | 139.85 | 140.0 | 5822.0 |
| 2022-10-11 07:25:00 | AAPL | Stock | 140.05 | 140.05 | 139.95 | 139.98 | 4273.0 |
| 2022-10-11 07:30:00 | AAPL | Stock | 139.95 | 139.98 | 139.92 | 139.94 | 2072.0 |
| 2022-10-11 07:35:00 | AAPL | Stock | 139.94 | 140.03 | 139.9 | 139.9 | 1639.0 |
| 2022-10-11 07:40:00 | AAPL | Stock | 139.88 | 139.98 | 139.88 | 139.94 | 1493.0 |
| 2022-10-11 07:45:00 | AAPL | Stock | 139.86 | 139.86 | 139.69 | 139.69 | 9092.0 |
| 2022-10-11 07:50:00 | AAPL | Stock | 139.66 | 139.66 | 139.48 | 139.5 | 12635.0 |
| 2022-10-11 07:55:00 | AAPL | Stock | 139.62 | 139.86 | 139.54 | 139.86 | 10818.0 |
| 2022-10-11 08:00:00 | AAPL | Stock | 139.7 | 140.0759 | 139.0115 | 139.89 | 55027.0 |
| 2022-10-11 08:05:00 | AAPL | Stock | 139.9 | 139.97 | 139.84 | 139.96 | 12206.0 |
> showing 50 of 414,700 rows — these rows as CSV