PREVIEW / stock_5min / 2021-12-16
file: by_date/stock_5min/2021/2021-12-16.parquet size: 7.7 MB rows: 478,174 symbols: 2,643
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-16 04:00:00 | AAPL | Stock | 180.55 | 180.68 | 180.25 | 180.57 | 13273.0 |
| 2021-12-16 04:05:00 | AAPL | Stock | 180.5 | 180.56 | 180.32 | 180.32 | 8462.0 |
| 2021-12-16 04:10:00 | AAPL | Stock | 180.24 | 180.44 | 180.24 | 180.4 | 3777.0 |
| 2021-12-16 04:15:00 | AAPL | Stock | 180.38 | 180.38 | 180.17 | 180.2 | 5433.0 |
| 2021-12-16 04:20:00 | AAPL | Stock | 180.17 | 180.33 | 180.17 | 180.3 | 1935.0 |
| 2021-12-16 04:25:00 | AAPL | Stock | 180.22 | 180.22 | 180.15 | 180.19 | 4104.0 |
| 2021-12-16 04:30:00 | AAPL | Stock | 180.23 | 180.35 | 180.14 | 180.35 | 4326.0 |
| 2021-12-16 04:35:00 | AAPL | Stock | 180.33 | 180.37 | 180.24 | 180.26 | 2345.0 |
| 2021-12-16 04:40:00 | AAPL | Stock | 180.3 | 180.38 | 180.3 | 180.38 | 1194.0 |
| 2021-12-16 04:45:00 | AAPL | Stock | 180.38 | 180.44 | 180.38 | 180.44 | 2116.0 |
| 2021-12-16 04:50:00 | AAPL | Stock | 180.44 | 180.45 | 180.4 | 180.45 | 2958.0 |
| 2021-12-16 04:55:00 | AAPL | Stock | 180.56 | 180.68 | 180.56 | 180.57 | 6015.0 |
| 2021-12-16 05:00:00 | AAPL | Stock | 180.59 | 180.7 | 180.58 | 180.7 | 1678.0 |
| 2021-12-16 05:05:00 | AAPL | Stock | 180.76 | 180.83 | 180.76 | 180.79 | 3710.0 |
| 2021-12-16 05:10:00 | AAPL | Stock | 180.79 | 180.83 | 180.76 | 180.83 | 1549.0 |
| 2021-12-16 05:15:00 | AAPL | Stock | 180.74 | 180.88 | 180.74 | 180.88 | 1691.0 |
| 2021-12-16 05:20:00 | AAPL | Stock | 180.9 | 180.92 | 180.64 | 180.68 | 3384.0 |
| 2021-12-16 05:25:00 | AAPL | Stock | 180.69 | 180.69 | 180.52 | 180.57 | 1117.0 |
| 2021-12-16 05:30:00 | AAPL | Stock | 180.57 | 180.57 | 180.57 | 180.57 | 129.0 |
| 2021-12-16 05:35:00 | AAPL | Stock | 180.66 | 180.69 | 180.66 | 180.69 | 458.0 |
| 2021-12-16 05:40:00 | AAPL | Stock | 180.69 | 180.81 | 180.68 | 180.81 | 4303.0 |
| 2021-12-16 05:45:00 | AAPL | Stock | 180.81 | 180.81 | 180.67 | 180.67 | 1318.0 |
| 2021-12-16 05:50:00 | AAPL | Stock | 180.72 | 180.72 | 180.6 | 180.6 | 3204.0 |
| 2021-12-16 05:55:00 | AAPL | Stock | 180.63 | 180.87 | 180.61 | 180.84 | 3500.0 |
| 2021-12-16 06:00:00 | AAPL | Stock | 180.83 | 180.86 | 180.83 | 180.86 | 1945.0 |
| 2021-12-16 06:05:00 | AAPL | Stock | 180.78 | 180.8 | 180.78 | 180.8 | 433.0 |
| 2021-12-16 06:10:00 | AAPL | Stock | 180.75 | 180.75 | 180.74 | 180.75 | 12463.0 |
| 2021-12-16 06:15:00 | AAPL | Stock | 180.73 | 180.75 | 180.65 | 180.65 | 6949.0 |
| 2021-12-16 06:20:00 | AAPL | Stock | 180.6 | 180.74 | 180.6 | 180.74 | 5114.0 |
| 2021-12-16 06:25:00 | AAPL | Stock | 180.72 | 180.94 | 180.72 | 180.94 | 21567.0 |
| 2021-12-16 06:30:00 | AAPL | Stock | 180.8 | 181.25 | 180.8 | 181.14 | 7255.0 |
| 2021-12-16 06:35:00 | AAPL | Stock | 181.06 | 181.09 | 180.96 | 180.96 | 6309.0 |
| 2021-12-16 06:40:00 | AAPL | Stock | 180.95 | 181.12 | 180.82 | 181.02 | 3465.0 |
| 2021-12-16 06:45:00 | AAPL | Stock | 181.0 | 181.01 | 180.91 | 180.96 | 8515.0 |
| 2021-12-16 06:50:00 | AAPL | Stock | 180.93 | 180.93 | 180.6 | 180.63 | 6064.0 |
| 2021-12-16 06:55:00 | AAPL | Stock | 180.69 | 180.75 | 180.62 | 180.7 | 19186.0 |
| 2021-12-16 07:00:00 | AAPL | Stock | 180.64 | 180.9 | 180.5 | 180.6 | 51816.0 |
| 2021-12-16 07:05:00 | AAPL | Stock | 180.62 | 180.62 | 180.41 | 180.58 | 16883.0 |
| 2021-12-16 07:10:00 | AAPL | Stock | 180.53 | 180.65 | 180.52 | 180.52 | 15916.0 |
| 2021-12-16 07:15:00 | AAPL | Stock | 180.52 | 180.6 | 180.4 | 180.46 | 45253.0 |
| 2021-12-16 07:20:00 | AAPL | Stock | 180.44 | 180.6 | 180.4 | 180.57 | 15528.0 |
| 2021-12-16 07:25:00 | AAPL | Stock | 180.6 | 180.72 | 180.45 | 180.5 | 32580.0 |
| 2021-12-16 07:30:00 | AAPL | Stock | 180.48 | 180.58 | 180.48 | 180.56 | 15662.0 |
| 2021-12-16 07:35:00 | AAPL | Stock | 180.53 | 180.54 | 180.45 | 180.48 | 10242.0 |
| 2021-12-16 07:40:00 | AAPL | Stock | 180.46 | 180.48 | 180.33 | 180.33 | 12666.0 |
| 2021-12-16 07:45:00 | AAPL | Stock | 180.37 | 180.44 | 180.01 | 180.2 | 49497.0 |
| 2021-12-16 07:50:00 | AAPL | Stock | 180.18 | 180.19 | 180.1 | 180.13 | 10999.0 |
| 2021-12-16 07:55:00 | AAPL | Stock | 180.11 | 180.22 | 180.1 | 180.18 | 27685.0 |
| 2021-12-16 08:00:00 | AAPL | Stock | 180.7 | 180.84 | 178.852 | 180.22 | 307640.0 |
| 2021-12-16 08:05:00 | AAPL | Stock | 180.23 | 180.25 | 179.87 | 179.9 | 82750.0 |
> showing 50 of 478,174 rows — these rows as CSV