PREVIEW / stock_5min / 2022-06-01
file: by_date/stock_5min/2022/2022-06-01.parquet size: 7.0 MB rows: 439,541 symbols: 2,416
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-06-01 04:00:00 | AAPL | Stock | 148.95 | 149.48 | 148.95 | 149.11 | 1800.0 |
| 2022-06-01 04:05:00 | AAPL | Stock | 149.17 | 149.17 | 148.35 | 148.4 | 8696.0 |
| 2022-06-01 04:10:00 | AAPL | Stock | 148.59 | 148.67 | 148.48 | 148.5 | 3176.0 |
| 2022-06-01 04:15:00 | AAPL | Stock | 148.59 | 148.59 | 148.52 | 148.52 | 1528.0 |
| 2022-06-01 04:20:00 | AAPL | Stock | 148.51 | 148.6 | 148.5 | 148.6 | 3282.0 |
| 2022-06-01 04:25:00 | AAPL | Stock | 148.73 | 148.75 | 148.73 | 148.75 | 398.0 |
| 2022-06-01 04:30:00 | AAPL | Stock | 148.75 | 148.88 | 148.75 | 148.83 | 1483.0 |
| 2022-06-01 04:35:00 | AAPL | Stock | 148.71 | 148.71 | 148.63 | 148.63 | 306.0 |
| 2022-06-01 04:40:00 | AAPL | Stock | 148.62 | 148.7 | 148.51 | 148.7 | 1239.0 |
| 2022-06-01 04:45:00 | AAPL | Stock | 148.83 | 148.85 | 148.79 | 148.79 | 1874.0 |
| 2022-06-01 04:55:00 | AAPL | Stock | 148.88 | 148.88 | 148.76 | 148.76 | 233.0 |
| 2022-06-01 05:00:00 | AAPL | Stock | 148.85 | 148.89 | 148.83 | 148.83 | 813.0 |
| 2022-06-01 05:05:00 | AAPL | Stock | 148.76 | 148.94 | 148.76 | 148.94 | 535.0 |
| 2022-06-01 05:10:00 | AAPL | Stock | 148.95 | 148.95 | 148.95 | 148.95 | 260.0 |
| 2022-06-01 05:20:00 | AAPL | Stock | 149.0 | 149.0 | 148.98 | 149.0 | 1614.0 |
| 2022-06-01 05:30:00 | AAPL | Stock | 149.04 | 149.04 | 149.04 | 149.04 | 113.0 |
| 2022-06-01 05:35:00 | AAPL | Stock | 149.0 | 149.0 | 149.0 | 149.0 | 676.0 |
| 2022-06-01 05:40:00 | AAPL | Stock | 148.91 | 148.97 | 148.9 | 148.97 | 1074.0 |
| 2022-06-01 05:45:00 | AAPL | Stock | 148.86 | 148.87 | 148.85 | 148.85 | 1071.0 |
| 2022-06-01 06:05:00 | AAPL | Stock | 148.84 | 148.85 | 148.8 | 148.8 | 3542.0 |
| 2022-06-01 06:10:00 | AAPL | Stock | 148.81 | 148.81 | 148.77 | 148.77 | 1031.0 |
| 2022-06-01 06:15:00 | AAPL | Stock | 148.78 | 148.78 | 148.78 | 148.78 | 350.0 |
| 2022-06-01 06:20:00 | AAPL | Stock | 148.95 | 148.96 | 148.81 | 148.81 | 1440.0 |
| 2022-06-01 06:25:00 | AAPL | Stock | 148.87 | 148.87 | 148.76 | 148.76 | 1035.0 |
| 2022-06-01 06:30:00 | AAPL | Stock | 148.9 | 148.9 | 148.81 | 148.81 | 400.0 |
| 2022-06-01 06:35:00 | AAPL | Stock | 148.9 | 148.9 | 148.8 | 148.8 | 2160.0 |
| 2022-06-01 06:40:00 | AAPL | Stock | 148.79 | 148.85 | 148.78 | 148.85 | 5200.0 |
| 2022-06-01 06:45:00 | AAPL | Stock | 148.8 | 148.8 | 148.78 | 148.78 | 377.0 |
| 2022-06-01 06:50:00 | AAPL | Stock | 148.71 | 148.71 | 148.6 | 148.6 | 1707.0 |
| 2022-06-01 06:55:00 | AAPL | Stock | 148.61 | 148.75 | 148.6 | 148.75 | 1831.0 |
| 2022-06-01 07:00:00 | AAPL | Stock | 148.75 | 148.87 | 148.52 | 148.7 | 19903.0 |
| 2022-06-01 07:05:00 | AAPL | Stock | 148.68 | 148.88 | 148.68 | 148.78 | 3506.0 |
| 2022-06-01 07:10:00 | AAPL | Stock | 148.77 | 148.88 | 148.77 | 148.85 | 2059.0 |
| 2022-06-01 07:15:00 | AAPL | Stock | 148.87 | 148.89 | 148.75 | 148.75 | 9027.0 |
| 2022-06-01 07:20:00 | AAPL | Stock | 148.78 | 148.84 | 148.67 | 148.83 | 3239.0 |
| 2022-06-01 07:25:00 | AAPL | Stock | 148.83 | 148.89 | 148.77 | 148.77 | 2912.0 |
| 2022-06-01 07:30:00 | AAPL | Stock | 148.81 | 148.96 | 148.76 | 148.93 | 6893.0 |
| 2022-06-01 07:35:00 | AAPL | Stock | 148.97 | 149.05 | 148.97 | 149.01 | 3792.0 |
| 2022-06-01 07:40:00 | AAPL | Stock | 149.0 | 149.01 | 148.88 | 148.88 | 8471.0 |
| 2022-06-01 07:45:00 | AAPL | Stock | 148.85 | 149.05 | 148.85 | 148.97 | 8319.0 |
| 2022-06-01 07:50:00 | AAPL | Stock | 148.98 | 149.04 | 148.98 | 149.0 | 2418.0 |
| 2022-06-01 07:55:00 | AAPL | Stock | 149.04 | 149.27 | 149.04 | 149.27 | 4897.0 |
| 2022-06-01 08:00:00 | AAPL | Stock | 148.75 | 149.5795 | 148.5312 | 149.53 | 114011.0 |
| 2022-06-01 08:05:00 | AAPL | Stock | 149.55 | 149.63 | 149.46 | 149.51 | 33547.0 |
| 2022-06-01 08:10:00 | AAPL | Stock | 149.54 | 149.57 | 149.49 | 149.5 | 19329.0 |
| 2022-06-01 08:15:00 | AAPL | Stock | 149.5 | 149.5599 | 149.4 | 149.43 | 29074.0 |
| 2022-06-01 08:20:00 | AAPL | Stock | 149.4201 | 149.75 | 149.34 | 149.671 | 35189.0 |
| 2022-06-01 08:25:00 | AAPL | Stock | 149.63 | 149.89 | 149.63 | 149.8 | 32961.0 |
| 2022-06-01 08:30:00 | AAPL | Stock | 149.78 | 149.8299 | 149.68 | 149.8299 | 48330.0 |
| 2022-06-01 08:35:00 | AAPL | Stock | 149.81 | 149.85 | 149.71 | 149.83 | 13881.0 |
> showing 50 of 439,541 rows — these rows as CSV