PREVIEW / stock_5min / 2020-12-07
file: by_date/stock_5min/2020/2020-12-07.parquet size: 7.5 MB rows: 462,617 symbols: 2,653
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-07 04:00:00 | AAPL | Stock | 122.0 | 122.0 | 121.77 | 121.77 | 769.0 |
| 2020-12-07 04:05:00 | AAPL | Stock | 121.71 | 121.71 | 121.2 | 121.5 | 12739.0 |
| 2020-12-07 04:10:00 | AAPL | Stock | 121.48 | 121.48 | 121.34 | 121.45 | 2937.0 |
| 2020-12-07 04:15:00 | AAPL | Stock | 121.45 | 121.5 | 121.42 | 121.5 | 9357.0 |
| 2020-12-07 04:20:00 | AAPL | Stock | 121.6 | 121.6 | 121.6 | 121.6 | 1400.0 |
| 2020-12-07 04:25:00 | AAPL | Stock | 121.62 | 121.65 | 121.5 | 121.5 | 1519.0 |
| 2020-12-07 04:30:00 | AAPL | Stock | 121.5 | 121.69 | 121.5 | 121.69 | 1431.0 |
| 2020-12-07 04:35:00 | AAPL | Stock | 121.68 | 121.68 | 121.55 | 121.6 | 1500.0 |
| 2020-12-07 04:40:00 | AAPL | Stock | 121.56 | 121.56 | 121.56 | 121.56 | 100.0 |
| 2020-12-07 04:45:00 | AAPL | Stock | 121.53 | 121.6 | 121.53 | 121.6 | 480.0 |
| 2020-12-07 04:55:00 | AAPL | Stock | 121.58 | 121.59 | 121.56 | 121.56 | 1037.0 |
| 2020-12-07 05:00:00 | AAPL | Stock | 121.51 | 121.6 | 121.51 | 121.58 | 1113.0 |
| 2020-12-07 05:05:00 | AAPL | Stock | 121.55 | 121.55 | 121.55 | 121.55 | 100.0 |
| 2020-12-07 05:10:00 | AAPL | Stock | 121.52 | 121.65 | 121.52 | 121.65 | 2011.0 |
| 2020-12-07 05:15:00 | AAPL | Stock | 121.67 | 121.8 | 121.67 | 121.8 | 7530.0 |
| 2020-12-07 05:20:00 | AAPL | Stock | 121.81 | 121.88 | 121.81 | 121.88 | 1021.0 |
| 2020-12-07 05:25:00 | AAPL | Stock | 121.82 | 121.82 | 121.82 | 121.82 | 100.0 |
| 2020-12-07 05:30:00 | AAPL | Stock | 121.71 | 121.71 | 121.63 | 121.63 | 600.0 |
| 2020-12-07 05:35:00 | AAPL | Stock | 121.68 | 121.7 | 121.68 | 121.7 | 668.0 |
| 2020-12-07 05:40:00 | AAPL | Stock | 121.78 | 121.8 | 121.78 | 121.8 | 602.0 |
| 2020-12-07 05:45:00 | AAPL | Stock | 121.84 | 121.84 | 121.84 | 121.84 | 247.0 |
| 2020-12-07 05:50:00 | AAPL | Stock | 121.78 | 121.78 | 121.78 | 121.78 | 300.0 |
| 2020-12-07 05:55:00 | AAPL | Stock | 121.84 | 121.85 | 121.84 | 121.84 | 728.0 |
| 2020-12-07 06:00:00 | AAPL | Stock | 121.84 | 122.18 | 121.84 | 122.18 | 12908.0 |
| 2020-12-07 06:05:00 | AAPL | Stock | 122.18 | 122.23 | 122.18 | 122.23 | 1818.0 |
| 2020-12-07 06:10:00 | AAPL | Stock | 122.23 | 122.28 | 122.21 | 122.28 | 2070.0 |
| 2020-12-07 06:15:00 | AAPL | Stock | 122.4 | 122.4 | 122.32 | 122.4 | 2200.0 |
| 2020-12-07 06:20:00 | AAPL | Stock | 122.36 | 122.36 | 122.35 | 122.35 | 200.0 |
| 2020-12-07 06:25:00 | AAPL | Stock | 122.35 | 122.35 | 122.15 | 122.26 | 5587.0 |
| 2020-12-07 06:35:00 | AAPL | Stock | 122.2 | 122.2 | 122.19 | 122.2 | 1620.0 |
| 2020-12-07 06:40:00 | AAPL | Stock | 122.25 | 122.25 | 122.25 | 122.25 | 200.0 |
| 2020-12-07 06:45:00 | AAPL | Stock | 122.23 | 122.25 | 122.04 | 122.04 | 4104.0 |
| 2020-12-07 06:55:00 | AAPL | Stock | 122.19 | 122.3 | 122.17 | 122.3 | 2146.0 |
| 2020-12-07 07:00:00 | AAPL | Stock | 122.2 | 122.47 | 122.05 | 122.36 | 26538.0 |
| 2020-12-07 07:05:00 | AAPL | Stock | 122.33 | 122.34 | 122.25 | 122.25 | 3058.0 |
| 2020-12-07 07:10:00 | AAPL | Stock | 122.25 | 122.34 | 122.25 | 122.32 | 6804.0 |
| 2020-12-07 07:15:00 | AAPL | Stock | 122.31 | 122.31 | 122.25 | 122.28 | 5335.0 |
| 2020-12-07 07:20:00 | AAPL | Stock | 122.16 | 122.16 | 122.16 | 122.16 | 300.0 |
| 2020-12-07 07:25:00 | AAPL | Stock | 122.15 | 122.15 | 122.12 | 122.12 | 2652.0 |
| 2020-12-07 07:30:00 | AAPL | Stock | 122.11 | 122.17 | 122.06 | 122.06 | 28080.0 |
| 2020-12-07 07:35:00 | AAPL | Stock | 122.07 | 122.07 | 122.03 | 122.07 | 2855.0 |
| 2020-12-07 07:40:00 | AAPL | Stock | 122.04 | 122.04 | 121.99 | 121.99 | 6606.0 |
| 2020-12-07 07:45:00 | AAPL | Stock | 121.99 | 122.16 | 121.98 | 122.16 | 7793.0 |
| 2020-12-07 07:50:00 | AAPL | Stock | 122.17 | 122.2 | 122.09 | 122.18 | 5373.0 |
| 2020-12-07 07:55:00 | AAPL | Stock | 122.17 | 122.17 | 122.16 | 122.16 | 490.0 |
| 2020-12-07 08:00:00 | AAPL | Stock | 122.13 | 122.42 | 121.966 | 122.15 | 120698.0 |
| 2020-12-07 08:05:00 | AAPL | Stock | 122.15 | 122.2 | 122.1 | 122.19 | 13644.0 |
| 2020-12-07 08:10:00 | AAPL | Stock | 122.2 | 122.25 | 122.18 | 122.2 | 12868.0 |
| 2020-12-07 08:15:00 | AAPL | Stock | 122.2 | 122.23 | 122.18 | 122.22 | 12275.0 |
| 2020-12-07 08:20:00 | AAPL | Stock | 122.23 | 122.284 | 122.22 | 122.25 | 10282.0 |
> showing 50 of 462,617 rows — these rows as CSV