PREVIEW / stock_5min / 2022-11-21
file: by_date/stock_5min/2022/2022-11-21.parquet size: 6.7 MB rows: 412,905 symbols: 2,089
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-11-21 04:00:00 | AAPL | Stock | 150.1 | 150.65 | 150.1 | 150.1 | 2745.0 |
| 2022-11-21 04:05:00 | AAPL | Stock | 150.1 | 150.18 | 150.1 | 150.11 | 5327.0 |
| 2022-11-21 04:10:00 | AAPL | Stock | 150.02 | 150.22 | 150.01 | 150.05 | 1600.0 |
| 2022-11-21 04:15:00 | AAPL | Stock | 150.04 | 150.19 | 150.04 | 150.19 | 1400.0 |
| 2022-11-21 04:20:00 | AAPL | Stock | 150.2 | 150.32 | 150.2 | 150.27 | 735.0 |
| 2022-11-21 04:25:00 | AAPL | Stock | 150.28 | 150.3 | 150.16 | 150.2 | 1955.0 |
| 2022-11-21 04:30:00 | AAPL | Stock | 150.19 | 150.19 | 150.1 | 150.13 | 1694.0 |
| 2022-11-21 04:40:00 | AAPL | Stock | 150.09 | 150.09 | 150.09 | 150.09 | 100.0 |
| 2022-11-21 04:45:00 | AAPL | Stock | 150.15 | 150.21 | 150.15 | 150.21 | 1019.0 |
| 2022-11-21 04:50:00 | AAPL | Stock | 150.17 | 150.19 | 150.17 | 150.19 | 389.0 |
| 2022-11-21 04:55:00 | AAPL | Stock | 150.25 | 150.25 | 150.17 | 150.17 | 756.0 |
| 2022-11-21 05:00:00 | AAPL | Stock | 150.16 | 150.2 | 150.16 | 150.2 | 434.0 |
| 2022-11-21 05:15:00 | AAPL | Stock | 150.15 | 150.15 | 150.01 | 150.01 | 2392.0 |
| 2022-11-21 05:20:00 | AAPL | Stock | 149.94 | 149.94 | 149.73 | 149.73 | 2318.0 |
| 2022-11-21 05:25:00 | AAPL | Stock | 149.74 | 149.8 | 149.08 | 149.44 | 7410.0 |
| 2022-11-21 05:30:00 | AAPL | Stock | 149.5 | 149.62 | 149.5 | 149.61 | 450.0 |
| 2022-11-21 05:35:00 | AAPL | Stock | 149.53 | 149.53 | 149.53 | 149.53 | 100.0 |
| 2022-11-21 05:40:00 | AAPL | Stock | 149.69 | 149.69 | 149.69 | 149.69 | 874.0 |
| 2022-11-21 05:45:00 | AAPL | Stock | 149.55 | 149.55 | 149.55 | 149.55 | 100.0 |
| 2022-11-21 05:55:00 | AAPL | Stock | 149.69 | 149.69 | 149.69 | 149.69 | 1000.0 |
| 2022-11-21 06:05:00 | AAPL | Stock | 149.7 | 149.7 | 149.7 | 149.7 | 100.0 |
| 2022-11-21 06:10:00 | AAPL | Stock | 149.86 | 149.86 | 149.86 | 149.86 | 319.0 |
| 2022-11-21 06:25:00 | AAPL | Stock | 149.75 | 149.75 | 149.6 | 149.6 | 1585.0 |
| 2022-11-21 06:35:00 | AAPL | Stock | 149.76 | 149.76 | 149.76 | 149.76 | 215.0 |
| 2022-11-21 06:40:00 | AAPL | Stock | 149.75 | 149.75 | 149.75 | 149.75 | 100.0 |
| 2022-11-21 06:45:00 | AAPL | Stock | 149.77 | 149.77 | 149.77 | 149.77 | 406.0 |
| 2022-11-21 06:50:00 | AAPL | Stock | 149.57 | 149.57 | 149.57 | 149.57 | 402.0 |
| 2022-11-21 06:55:00 | AAPL | Stock | 149.55 | 149.62 | 149.28 | 149.35 | 4691.0 |
| 2022-11-21 07:00:00 | AAPL | Stock | 149.42 | 149.72 | 149.42 | 149.66 | 11996.0 |
| 2022-11-21 07:05:00 | AAPL | Stock | 149.65 | 149.65 | 149.36 | 149.36 | 8663.0 |
| 2022-11-21 07:10:00 | AAPL | Stock | 149.43 | 149.6 | 149.43 | 149.57 | 5742.0 |
| 2022-11-21 07:15:00 | AAPL | Stock | 149.53 | 149.7 | 149.45 | 149.7 | 4155.0 |
| 2022-11-21 07:20:00 | AAPL | Stock | 149.71 | 149.71 | 149.6 | 149.6 | 2159.0 |
| 2022-11-21 07:25:00 | AAPL | Stock | 149.64 | 149.64 | 149.6 | 149.6 | 857.0 |
| 2022-11-21 07:30:00 | AAPL | Stock | 149.6 | 149.65 | 149.6 | 149.65 | 950.0 |
| 2022-11-21 07:35:00 | AAPL | Stock | 149.65 | 149.65 | 149.62 | 149.62 | 200.0 |
| 2022-11-21 07:40:00 | AAPL | Stock | 149.63 | 149.76 | 149.63 | 149.74 | 2953.0 |
| 2022-11-21 07:45:00 | AAPL | Stock | 149.77 | 149.83 | 149.66 | 149.73 | 6070.0 |
| 2022-11-21 07:50:00 | AAPL | Stock | 149.75 | 149.88 | 149.75 | 149.82 | 1650.0 |
| 2022-11-21 07:55:00 | AAPL | Stock | 149.82 | 149.87 | 149.77 | 149.77 | 2629.0 |
| 2022-11-21 08:00:00 | AAPL | Stock | 150.65 | 150.65 | 149.4315 | 149.94 | 65194.0 |
| 2022-11-21 08:05:00 | AAPL | Stock | 149.94 | 150.317 | 149.94 | 150.18 | 23674.0 |
| 2022-11-21 08:10:00 | AAPL | Stock | 150.15 | 150.39 | 150.13 | 150.35 | 14362.0 |
| 2022-11-21 08:15:00 | AAPL | Stock | 150.27 | 150.3899 | 150.22 | 150.28 | 25027.0 |
| 2022-11-21 08:20:00 | AAPL | Stock | 150.28 | 150.47 | 150.1904 | 150.46 | 10984.0 |
| 2022-11-21 08:25:00 | AAPL | Stock | 150.47 | 150.79 | 150.35 | 150.36 | 19809.0 |
| 2022-11-21 08:30:00 | AAPL | Stock | 150.42 | 150.45 | 150.3201 | 150.45 | 12219.0 |
| 2022-11-21 08:35:00 | AAPL | Stock | 150.38 | 150.4 | 150.03 | 150.13 | 22744.0 |
| 2022-11-21 08:40:00 | AAPL | Stock | 150.18 | 150.19 | 149.93 | 150.18 | 19277.0 |
| 2022-11-21 08:45:00 | AAPL | Stock | 150.15 | 150.21 | 150.15 | 150.15 | 9414.0 |
> showing 50 of 412,905 rows — these rows as CSV