PREVIEW / stock_5min / 2022-08-09
file: by_date/stock_5min/2022/2022-08-09.parquet size: 7.0 MB rows: 435,411 symbols: 2,309
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-08-09 04:00:00 | AAPL | Stock | 165.0 | 165.15 | 164.7 | 164.76 | 5221.0 |
| 2022-08-09 04:05:00 | AAPL | Stock | 164.71 | 164.71 | 164.31 | 164.31 | 6911.0 |
| 2022-08-09 04:10:00 | AAPL | Stock | 164.49 | 164.6 | 164.48 | 164.48 | 1363.0 |
| 2022-08-09 04:15:00 | AAPL | Stock | 164.52 | 164.64 | 164.52 | 164.64 | 544.0 |
| 2022-08-09 04:20:00 | AAPL | Stock | 164.68 | 164.75 | 164.68 | 164.75 | 1140.0 |
| 2022-08-09 04:25:00 | AAPL | Stock | 164.87 | 164.89 | 164.87 | 164.88 | 692.0 |
| 2022-08-09 04:30:00 | AAPL | Stock | 164.93 | 165.09 | 164.93 | 164.98 | 3008.0 |
| 2022-08-09 04:35:00 | AAPL | Stock | 165.1 | 165.1 | 165.1 | 165.1 | 139.0 |
| 2022-08-09 04:40:00 | AAPL | Stock | 165.01 | 165.01 | 165.01 | 165.01 | 129.0 |
| 2022-08-09 04:45:00 | AAPL | Stock | 164.88 | 164.88 | 164.88 | 164.88 | 122.0 |
| 2022-08-09 04:50:00 | AAPL | Stock | 164.81 | 164.81 | 164.8 | 164.8 | 1087.0 |
| 2022-08-09 05:00:00 | AAPL | Stock | 164.95 | 164.95 | 164.95 | 164.95 | 100.0 |
| 2022-08-09 05:05:00 | AAPL | Stock | 164.95 | 164.95 | 164.94 | 164.94 | 344.0 |
| 2022-08-09 05:20:00 | AAPL | Stock | 164.86 | 164.86 | 164.82 | 164.82 | 580.0 |
| 2022-08-09 05:25:00 | AAPL | Stock | 164.86 | 164.86 | 164.75 | 164.75 | 1459.0 |
| 2022-08-09 05:40:00 | AAPL | Stock | 164.72 | 164.72 | 164.72 | 164.72 | 300.0 |
| 2022-08-09 05:55:00 | AAPL | Stock | 164.67 | 164.67 | 164.6 | 164.65 | 777.0 |
| 2022-08-09 06:00:00 | AAPL | Stock | 164.68 | 164.68 | 164.68 | 164.68 | 312.0 |
| 2022-08-09 06:05:00 | AAPL | Stock | 164.65 | 164.65 | 164.64 | 164.64 | 693.0 |
| 2022-08-09 06:10:00 | AAPL | Stock | 164.62 | 164.62 | 164.28 | 164.28 | 6712.0 |
| 2022-08-09 06:15:00 | AAPL | Stock | 164.16 | 164.16 | 163.96 | 164.0 | 14433.0 |
| 2022-08-09 06:20:00 | AAPL | Stock | 164.06 | 164.06 | 163.89 | 163.99 | 3189.0 |
| 2022-08-09 06:25:00 | AAPL | Stock | 163.97 | 163.99 | 163.96 | 163.99 | 2462.0 |
| 2022-08-09 06:30:00 | AAPL | Stock | 163.91 | 163.97 | 163.88 | 163.96 | 3063.0 |
| 2022-08-09 06:35:00 | AAPL | Stock | 163.94 | 163.97 | 163.94 | 163.97 | 423.0 |
| 2022-08-09 06:40:00 | AAPL | Stock | 164.0 | 164.01 | 163.97 | 163.97 | 2265.0 |
| 2022-08-09 06:45:00 | AAPL | Stock | 163.92 | 163.99 | 163.88 | 163.92 | 741.0 |
| 2022-08-09 06:50:00 | AAPL | Stock | 163.93 | 164.0 | 163.93 | 164.0 | 485.0 |
| 2022-08-09 06:55:00 | AAPL | Stock | 163.93 | 164.01 | 163.93 | 164.01 | 1324.0 |
| 2022-08-09 07:00:00 | AAPL | Stock | 164.09 | 164.3 | 164.09 | 164.2 | 14464.0 |
| 2022-08-09 07:05:00 | AAPL | Stock | 164.15 | 164.2 | 164.07 | 164.2 | 4692.0 |
| 2022-08-09 07:10:00 | AAPL | Stock | 164.16 | 164.26 | 164.16 | 164.21 | 6697.0 |
| 2022-08-09 07:15:00 | AAPL | Stock | 164.21 | 164.22 | 164.11 | 164.11 | 5772.0 |
| 2022-08-09 07:20:00 | AAPL | Stock | 164.12 | 164.18 | 164.04 | 164.18 | 3627.0 |
| 2022-08-09 07:25:00 | AAPL | Stock | 164.04 | 164.05 | 164.0 | 164.04 | 11965.0 |
| 2022-08-09 07:30:00 | AAPL | Stock | 164.02 | 164.04 | 163.92 | 164.01 | 5349.0 |
| 2022-08-09 07:35:00 | AAPL | Stock | 164.14 | 164.2 | 164.0 | 164.03 | 2635.0 |
| 2022-08-09 07:40:00 | AAPL | Stock | 164.03 | 164.03 | 163.61 | 163.69 | 11728.0 |
| 2022-08-09 07:45:00 | AAPL | Stock | 163.77 | 163.77 | 163.69 | 163.73 | 5313.0 |
| 2022-08-09 07:50:00 | AAPL | Stock | 163.75 | 163.79 | 163.7 | 163.79 | 1667.0 |
| 2022-08-09 07:55:00 | AAPL | Stock | 163.76 | 163.8 | 163.75 | 163.75 | 2635.0 |
| 2022-08-09 08:00:00 | AAPL | Stock | 164.2751 | 165.0 | 163.6439 | 163.81 | 133499.0 |
| 2022-08-09 08:05:00 | AAPL | Stock | 163.82 | 163.82 | 163.65 | 163.65 | 23880.0 |
| 2022-08-09 08:10:00 | AAPL | Stock | 163.7 | 163.7 | 163.5 | 163.6 | 12366.0 |
| 2022-08-09 08:15:00 | AAPL | Stock | 163.71 | 163.79 | 163.71 | 163.73 | 25247.0 |
| 2022-08-09 08:20:00 | AAPL | Stock | 163.76 | 163.89 | 163.76 | 163.84 | 19869.0 |
| 2022-08-09 08:25:00 | AAPL | Stock | 163.87 | 163.93 | 163.84 | 163.8444 | 14520.0 |
| 2022-08-09 08:30:00 | AAPL | Stock | 163.78 | 163.99 | 163.74 | 163.97 | 26029.0 |
| 2022-08-09 08:35:00 | AAPL | Stock | 163.93 | 163.99 | 163.92 | 163.96 | 6610.0 |
| 2022-08-09 08:40:00 | AAPL | Stock | 163.98 | 163.99 | 163.85 | 163.85 | 22433.0 |
> showing 50 of 435,411 rows — these rows as CSV