PREVIEW / stock_5min / 2022-07-11
file: by_date/stock_5min/2022/2022-07-11.parquet size: 6.6 MB rows: 411,188 symbols: 2,299
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-07-11 04:00:00 | AAPL | Stock | 145.98 | 145.98 | 145.3 | 145.55 | 7172.0 |
| 2022-07-11 04:05:00 | AAPL | Stock | 145.46 | 145.75 | 145.44 | 145.75 | 8753.0 |
| 2022-07-11 04:10:00 | AAPL | Stock | 145.75 | 145.96 | 145.75 | 145.9 | 1342.0 |
| 2022-07-11 04:15:00 | AAPL | Stock | 145.75 | 145.9 | 145.74 | 145.9 | 1866.0 |
| 2022-07-11 04:20:00 | AAPL | Stock | 145.78 | 145.81 | 145.64 | 145.79 | 2221.0 |
| 2022-07-11 04:25:00 | AAPL | Stock | 145.62 | 145.62 | 145.61 | 145.62 | 725.0 |
| 2022-07-11 04:30:00 | AAPL | Stock | 145.7 | 145.79 | 145.7 | 145.78 | 948.0 |
| 2022-07-11 04:35:00 | AAPL | Stock | 145.71 | 145.87 | 145.71 | 145.79 | 2944.0 |
| 2022-07-11 04:40:00 | AAPL | Stock | 145.79 | 145.79 | 145.76 | 145.76 | 1209.0 |
| 2022-07-11 04:50:00 | AAPL | Stock | 145.59 | 145.71 | 145.59 | 145.7 | 667.0 |
| 2022-07-11 04:55:00 | AAPL | Stock | 145.66 | 145.69 | 145.62 | 145.63 | 1481.0 |
| 2022-07-11 05:00:00 | AAPL | Stock | 145.63 | 145.75 | 145.62 | 145.75 | 4230.0 |
| 2022-07-11 05:05:00 | AAPL | Stock | 145.77 | 145.8 | 145.75 | 145.75 | 1582.0 |
| 2022-07-11 05:10:00 | AAPL | Stock | 145.8 | 145.85 | 145.76 | 145.85 | 1864.0 |
| 2022-07-11 05:15:00 | AAPL | Stock | 145.8 | 145.82 | 145.8 | 145.82 | 3024.0 |
| 2022-07-11 05:20:00 | AAPL | Stock | 145.82 | 145.89 | 145.82 | 145.89 | 5711.0 |
| 2022-07-11 05:25:00 | AAPL | Stock | 145.95 | 145.97 | 145.88 | 145.97 | 2680.0 |
| 2022-07-11 05:30:00 | AAPL | Stock | 145.83 | 145.92 | 145.82 | 145.83 | 5233.0 |
| 2022-07-11 05:35:00 | AAPL | Stock | 145.84 | 146.05 | 145.84 | 146.05 | 1478.0 |
| 2022-07-11 05:40:00 | AAPL | Stock | 145.88 | 145.88 | 145.87 | 145.87 | 1232.0 |
| 2022-07-11 05:45:00 | AAPL | Stock | 145.98 | 146.0 | 145.94 | 145.94 | 2034.0 |
| 2022-07-11 05:50:00 | AAPL | Stock | 145.9 | 146.02 | 145.9 | 146.0 | 3223.0 |
| 2022-07-11 05:55:00 | AAPL | Stock | 145.92 | 145.94 | 145.86 | 145.86 | 2046.0 |
| 2022-07-11 06:00:00 | AAPL | Stock | 145.87 | 145.87 | 145.82 | 145.87 | 11101.0 |
| 2022-07-11 06:05:00 | AAPL | Stock | 145.94 | 145.94 | 145.91 | 145.92 | 1406.0 |
| 2022-07-11 06:10:00 | AAPL | Stock | 145.95 | 145.95 | 145.95 | 145.95 | 700.0 |
| 2022-07-11 06:15:00 | AAPL | Stock | 146.0 | 146.09 | 145.99 | 146.09 | 1255.0 |
| 2022-07-11 06:20:00 | AAPL | Stock | 146.12 | 146.19 | 146.11 | 146.11 | 2252.0 |
| 2022-07-11 06:25:00 | AAPL | Stock | 146.07 | 146.15 | 145.99 | 145.99 | 4007.0 |
| 2022-07-11 06:30:00 | AAPL | Stock | 146.02 | 146.02 | 145.91 | 146.0 | 1912.0 |
| 2022-07-11 06:35:00 | AAPL | Stock | 146.0 | 146.0 | 146.0 | 146.0 | 284.0 |
| 2022-07-11 06:40:00 | AAPL | Stock | 146.01 | 146.09 | 146.01 | 146.09 | 400.0 |
| 2022-07-11 06:45:00 | AAPL | Stock | 146.09 | 146.09 | 146.08 | 146.08 | 263.0 |
| 2022-07-11 06:50:00 | AAPL | Stock | 145.98 | 145.98 | 145.98 | 145.98 | 299.0 |
| 2022-07-11 07:00:00 | AAPL | Stock | 146.0 | 146.1 | 146.0 | 146.1 | 7209.0 |
| 2022-07-11 07:05:00 | AAPL | Stock | 146.1 | 146.1 | 146.05 | 146.09 | 1226.0 |
| 2022-07-11 07:10:00 | AAPL | Stock | 146.1 | 146.2 | 146.1 | 146.15 | 11107.0 |
| 2022-07-11 07:15:00 | AAPL | Stock | 146.17 | 146.2 | 146.14 | 146.19 | 3455.0 |
| 2022-07-11 07:20:00 | AAPL | Stock | 146.14 | 146.15 | 146.14 | 146.15 | 2048.0 |
| 2022-07-11 07:25:00 | AAPL | Stock | 146.14 | 146.14 | 146.0 | 146.05 | 12129.0 |
| 2022-07-11 07:30:00 | AAPL | Stock | 146.05 | 146.1 | 146.02 | 146.02 | 7488.0 |
| 2022-07-11 07:35:00 | AAPL | Stock | 146.01 | 146.03 | 146.0 | 146.02 | 5615.0 |
| 2022-07-11 07:40:00 | AAPL | Stock | 146.0 | 146.0 | 145.85 | 145.93 | 7128.0 |
| 2022-07-11 07:45:00 | AAPL | Stock | 145.93 | 145.94 | 145.85 | 145.94 | 2796.0 |
| 2022-07-11 07:50:00 | AAPL | Stock | 145.85 | 145.88 | 145.83 | 145.83 | 2566.0 |
| 2022-07-11 07:55:00 | AAPL | Stock | 145.83 | 145.87 | 145.82 | 145.82 | 4842.0 |
| 2022-07-11 08:00:00 | AAPL | Stock | 146.1097 | 146.673 | 145.5 | 145.87 | 44861.0 |
| 2022-07-11 08:05:00 | AAPL | Stock | 145.8 | 145.94 | 145.78 | 145.87 | 6727.0 |
| 2022-07-11 08:10:00 | AAPL | Stock | 145.89 | 145.95 | 145.89 | 145.9498 | 4855.0 |
| 2022-07-11 08:15:00 | AAPL | Stock | 145.92 | 145.96 | 145.9 | 145.94 | 7510.0 |
> showing 50 of 411,188 rows — these rows as CSV