PREVIEW / stock_5min / 2021-12-01
file: by_date/stock_5min/2021/2021-12-01.parquet size: 8.1 MB rows: 497,545 symbols: 2,700
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-01 04:00:00 | AAPL | Stock | 167.2 | 167.92 | 166.95 | 167.8 | 16239.0 |
| 2021-12-01 04:05:00 | AAPL | Stock | 167.73 | 167.78 | 167.71 | 167.78 | 1838.0 |
| 2021-12-01 04:10:00 | AAPL | Stock | 167.73 | 167.83 | 167.73 | 167.83 | 7604.0 |
| 2021-12-01 04:15:00 | AAPL | Stock | 167.81 | 168.0 | 167.8 | 167.95 | 4444.0 |
| 2021-12-01 04:20:00 | AAPL | Stock | 167.95 | 168.0 | 167.86 | 167.86 | 3564.0 |
| 2021-12-01 04:25:00 | AAPL | Stock | 167.8 | 167.8 | 167.73 | 167.77 | 4407.0 |
| 2021-12-01 04:30:00 | AAPL | Stock | 167.77 | 167.9 | 167.77 | 167.9 | 1772.0 |
| 2021-12-01 04:35:00 | AAPL | Stock | 167.9 | 167.94 | 167.84 | 167.94 | 6535.0 |
| 2021-12-01 04:40:00 | AAPL | Stock | 167.95 | 168.0 | 167.93 | 167.95 | 8558.0 |
| 2021-12-01 04:45:00 | AAPL | Stock | 167.95 | 167.99 | 167.92 | 167.96 | 5850.0 |
| 2021-12-01 04:50:00 | AAPL | Stock | 167.98 | 167.98 | 167.94 | 167.94 | 6312.0 |
| 2021-12-01 04:55:00 | AAPL | Stock | 167.9 | 167.95 | 167.9 | 167.95 | 2937.0 |
| 2021-12-01 05:00:00 | AAPL | Stock | 167.91 | 167.95 | 167.84 | 167.95 | 1478.0 |
| 2021-12-01 05:05:00 | AAPL | Stock | 167.9 | 167.92 | 167.76 | 167.88 | 13788.0 |
| 2021-12-01 05:10:00 | AAPL | Stock | 167.85 | 167.85 | 167.85 | 167.85 | 201.0 |
| 2021-12-01 05:15:00 | AAPL | Stock | 167.82 | 167.82 | 167.8 | 167.8 | 1559.0 |
| 2021-12-01 05:20:00 | AAPL | Stock | 167.82 | 167.82 | 167.77 | 167.8 | 1017.0 |
| 2021-12-01 05:25:00 | AAPL | Stock | 167.8 | 167.8 | 167.76 | 167.77 | 2422.0 |
| 2021-12-01 05:30:00 | AAPL | Stock | 167.8 | 167.81 | 167.79 | 167.8 | 1732.0 |
| 2021-12-01 05:35:00 | AAPL | Stock | 167.79 | 167.81 | 167.78 | 167.81 | 1901.0 |
| 2021-12-01 05:40:00 | AAPL | Stock | 167.79 | 167.8 | 167.76 | 167.76 | 1737.0 |
| 2021-12-01 05:45:00 | AAPL | Stock | 167.76 | 167.81 | 167.75 | 167.75 | 5065.0 |
| 2021-12-01 05:50:00 | AAPL | Stock | 167.75 | 167.75 | 167.75 | 167.75 | 100.0 |
| 2021-12-01 05:55:00 | AAPL | Stock | 167.8 | 167.81 | 167.8 | 167.81 | 399.0 |
| 2021-12-01 06:00:00 | AAPL | Stock | 167.8 | 167.81 | 167.78 | 167.81 | 8569.0 |
| 2021-12-01 06:05:00 | AAPL | Stock | 167.8 | 167.85 | 167.8 | 167.85 | 3544.0 |
| 2021-12-01 06:10:00 | AAPL | Stock | 167.81 | 167.84 | 167.8 | 167.84 | 4413.0 |
| 2021-12-01 06:15:00 | AAPL | Stock | 167.8 | 167.8 | 167.65 | 167.71 | 5056.0 |
| 2021-12-01 06:20:00 | AAPL | Stock | 167.66 | 167.86 | 167.65 | 167.85 | 5928.0 |
| 2021-12-01 06:25:00 | AAPL | Stock | 167.85 | 167.9 | 167.82 | 167.82 | 3396.0 |
| 2021-12-01 06:30:00 | AAPL | Stock | 167.83 | 167.86 | 167.78 | 167.85 | 2229.0 |
| 2021-12-01 06:35:00 | AAPL | Stock | 167.85 | 167.86 | 167.83 | 167.85 | 2457.0 |
| 2021-12-01 06:40:00 | AAPL | Stock | 167.84 | 167.86 | 167.84 | 167.86 | 4657.0 |
| 2021-12-01 06:45:00 | AAPL | Stock | 167.87 | 167.95 | 167.84 | 167.92 | 3421.0 |
| 2021-12-01 06:50:00 | AAPL | Stock | 167.94 | 168.0 | 167.94 | 167.97 | 1641.0 |
| 2021-12-01 06:55:00 | AAPL | Stock | 167.99 | 168.09 | 167.99 | 168.09 | 4515.0 |
| 2021-12-01 07:00:00 | AAPL | Stock | 168.07 | 168.35 | 167.9 | 168.28 | 67882.0 |
| 2021-12-01 07:05:00 | AAPL | Stock | 168.29 | 168.32 | 168.14 | 168.32 | 15832.0 |
| 2021-12-01 07:10:00 | AAPL | Stock | 168.26 | 168.33 | 168.12 | 168.27 | 24643.0 |
| 2021-12-01 07:15:00 | AAPL | Stock | 168.26 | 168.31 | 168.2 | 168.23 | 21346.0 |
| 2021-12-01 07:20:00 | AAPL | Stock | 168.21 | 168.32 | 168.21 | 168.3 | 5890.0 |
| 2021-12-01 07:25:00 | AAPL | Stock | 168.29 | 168.43 | 168.28 | 168.43 | 17834.0 |
| 2021-12-01 07:30:00 | AAPL | Stock | 168.4 | 168.55 | 168.35 | 168.45 | 46635.0 |
| 2021-12-01 07:35:00 | AAPL | Stock | 168.47 | 168.48 | 168.32 | 168.36 | 35873.0 |
| 2021-12-01 07:40:00 | AAPL | Stock | 168.4 | 168.58 | 168.4 | 168.58 | 24568.0 |
| 2021-12-01 07:45:00 | AAPL | Stock | 168.58 | 168.65 | 168.4 | 168.48 | 27987.0 |
| 2021-12-01 07:50:00 | AAPL | Stock | 168.45 | 168.6 | 168.41 | 168.6 | 18703.0 |
| 2021-12-01 07:55:00 | AAPL | Stock | 168.59 | 168.6 | 168.49 | 168.5 | 30345.0 |
| 2021-12-01 08:00:00 | AAPL | Stock | 168.29 | 168.61 | 164.887 | 168.19 | 280742.0 |
| 2021-12-01 08:05:00 | AAPL | Stock | 168.19 | 168.24 | 168.0 | 168.0301 | 44523.0 |
> showing 50 of 497,545 rows — these rows as CSV