PREVIEW / stock_5min / 2021-07-08
file: by_date/stock_5min/2021/2021-07-08.parquet size: 7.7 MB rows: 477,843 symbols: 2,871
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-07-08 04:00:00 | AAPL | Stock | 142.52 | 143.43 | 141.75 | 141.75 | 29783.0 |
| 2021-07-08 04:05:00 | AAPL | Stock | 141.53 | 142.27 | 141.39 | 142.0 | 27624.0 |
| 2021-07-08 04:10:00 | AAPL | Stock | 141.96 | 142.39 | 141.9 | 142.26 | 13761.0 |
| 2021-07-08 04:15:00 | AAPL | Stock | 142.27 | 142.4 | 142.01 | 142.36 | 10850.0 |
| 2021-07-08 04:20:00 | AAPL | Stock | 142.23 | 142.25 | 142.08 | 142.11 | 5177.0 |
| 2021-07-08 04:25:00 | AAPL | Stock | 142.13 | 142.13 | 141.64 | 141.9 | 18236.0 |
| 2021-07-08 04:30:00 | AAPL | Stock | 141.62 | 141.98 | 141.6 | 141.98 | 12210.0 |
| 2021-07-08 04:35:00 | AAPL | Stock | 141.92 | 142.25 | 141.87 | 142.06 | 18710.0 |
| 2021-07-08 04:40:00 | AAPL | Stock | 142.19 | 142.25 | 142.06 | 142.07 | 10883.0 |
| 2021-07-08 04:45:00 | AAPL | Stock | 142.08 | 142.26 | 142.06 | 142.2 | 17340.0 |
| 2021-07-08 04:50:00 | AAPL | Stock | 142.14 | 142.17 | 142.11 | 142.12 | 4927.0 |
| 2021-07-08 04:55:00 | AAPL | Stock | 142.14 | 142.24 | 142.08 | 142.2 | 7014.0 |
| 2021-07-08 05:00:00 | AAPL | Stock | 142.23 | 142.61 | 142.14 | 142.27 | 48680.0 |
| 2021-07-08 05:05:00 | AAPL | Stock | 142.34 | 142.58 | 142.03 | 142.2 | 6621.0 |
| 2021-07-08 05:10:00 | AAPL | Stock | 142.03 | 142.16 | 141.96 | 142.16 | 5869.0 |
| 2021-07-08 05:15:00 | AAPL | Stock | 142.05 | 142.14 | 142.02 | 142.05 | 6386.0 |
| 2021-07-08 05:20:00 | AAPL | Stock | 142.05 | 142.05 | 141.9 | 141.94 | 8619.0 |
| 2021-07-08 05:25:00 | AAPL | Stock | 141.92 | 142.3 | 141.92 | 142.24 | 12787.0 |
| 2021-07-08 05:30:00 | AAPL | Stock | 142.17 | 142.39 | 142.16 | 142.2 | 4500.0 |
| 2021-07-08 05:35:00 | AAPL | Stock | 142.2 | 142.3 | 142.15 | 142.2 | 2735.0 |
| 2021-07-08 05:40:00 | AAPL | Stock | 142.14 | 142.4 | 142.13 | 142.34 | 13652.0 |
| 2021-07-08 05:45:00 | AAPL | Stock | 142.36 | 142.46 | 142.34 | 142.46 | 1731.0 |
| 2021-07-08 05:50:00 | AAPL | Stock | 142.41 | 142.41 | 142.3 | 142.32 | 18563.0 |
| 2021-07-08 05:55:00 | AAPL | Stock | 142.34 | 142.37 | 142.25 | 142.28 | 47259.0 |
| 2021-07-08 06:00:00 | AAPL | Stock | 142.2 | 142.21 | 141.98 | 142.2 | 10384.0 |
| 2021-07-08 06:05:00 | AAPL | Stock | 142.24 | 142.25 | 142.04 | 142.2 | 11863.0 |
| 2021-07-08 06:10:00 | AAPL | Stock | 142.07 | 142.75 | 141.9 | 142.13 | 55166.0 |
| 2021-07-08 06:15:00 | AAPL | Stock | 142.15 | 142.15 | 141.75 | 142.0 | 31453.0 |
| 2021-07-08 06:20:00 | AAPL | Stock | 141.83 | 141.96 | 141.6 | 141.91 | 10683.0 |
| 2021-07-08 06:25:00 | AAPL | Stock | 141.91 | 142.18 | 141.7 | 141.75 | 14900.0 |
| 2021-07-08 06:30:00 | AAPL | Stock | 141.65 | 141.8 | 141.65 | 141.74 | 8914.0 |
| 2021-07-08 06:35:00 | AAPL | Stock | 141.8 | 142.0 | 141.76 | 141.87 | 11751.0 |
| 2021-07-08 06:40:00 | AAPL | Stock | 141.97 | 142.0 | 141.83 | 141.95 | 20803.0 |
| 2021-07-08 06:45:00 | AAPL | Stock | 141.92 | 142.09 | 141.91 | 142.08 | 13916.0 |
| 2021-07-08 06:50:00 | AAPL | Stock | 142.05 | 142.22 | 141.97 | 142.03 | 10754.0 |
| 2021-07-08 06:55:00 | AAPL | Stock | 142.03 | 142.49 | 142.03 | 142.48 | 11267.0 |
| 2021-07-08 07:00:00 | AAPL | Stock | 142.42 | 142.7 | 142.1 | 142.2 | 90799.0 |
| 2021-07-08 07:05:00 | AAPL | Stock | 142.19 | 142.48 | 142.1 | 142.48 | 25046.0 |
| 2021-07-08 07:10:00 | AAPL | Stock | 142.45 | 142.45 | 142.2 | 142.2 | 26612.0 |
| 2021-07-08 07:15:00 | AAPL | Stock | 142.24 | 142.35 | 142.15 | 142.23 | 38986.0 |
| 2021-07-08 07:20:00 | AAPL | Stock | 142.23 | 142.3 | 142.12 | 142.16 | 33417.0 |
| 2021-07-08 07:25:00 | AAPL | Stock | 142.15 | 142.25 | 142.0 | 142.25 | 46750.0 |
| 2021-07-08 07:30:00 | AAPL | Stock | 142.221 | 142.221 | 141.99 | 142.05 | 42298.0 |
| 2021-07-08 07:35:00 | AAPL | Stock | 142.05 | 142.12 | 142.0 | 142.07 | 29842.0 |
| 2021-07-08 07:40:00 | AAPL | Stock | 142.02 | 142.04 | 141.92 | 141.95 | 36857.0 |
| 2021-07-08 07:45:00 | AAPL | Stock | 141.95 | 141.97 | 141.82 | 141.9 | 35971.0 |
| 2021-07-08 07:50:00 | AAPL | Stock | 141.89 | 141.89 | 141.8 | 141.81 | 25121.0 |
| 2021-07-08 07:55:00 | AAPL | Stock | 141.81 | 141.81 | 141.75 | 141.75 | 32301.0 |
| 2021-07-08 08:00:00 | AAPL | Stock | 142.48 | 142.65 | 141.71 | 141.82 | 550381.0 |
| 2021-07-08 08:05:00 | AAPL | Stock | 141.81 | 141.82 | 141.64 | 141.64 | 67066.0 |
> showing 50 of 477,843 rows — these rows as CSV