PREVIEW / stock_5min / 2021-12-14
file: by_date/stock_5min/2021/2021-12-14.parquet size: 7.6 MB rows: 469,222 symbols: 2,693
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-14 04:00:00 | AAPL | Stock | 177.27 | 177.68 | 176.98 | 177.26 | 73221.0 |
| 2021-12-14 04:05:00 | AAPL | Stock | 177.26 | 177.84 | 177.26 | 177.58 | 29655.0 |
| 2021-12-14 04:10:00 | AAPL | Stock | 177.61 | 177.66 | 177.04 | 177.34 | 21403.0 |
| 2021-12-14 04:15:00 | AAPL | Stock | 177.39 | 177.63 | 177.32 | 177.59 | 16567.0 |
| 2021-12-14 04:20:00 | AAPL | Stock | 177.5 | 177.74 | 177.4 | 177.4 | 15884.0 |
| 2021-12-14 04:25:00 | AAPL | Stock | 177.29 | 177.49 | 177.2 | 177.31 | 16526.0 |
| 2021-12-14 04:30:00 | AAPL | Stock | 177.34 | 177.41 | 177.0 | 177.11 | 12787.0 |
| 2021-12-14 04:35:00 | AAPL | Stock | 177.12 | 177.12 | 176.5 | 176.56 | 14531.0 |
| 2021-12-14 04:40:00 | AAPL | Stock | 176.48 | 176.93 | 176.4 | 176.4 | 20330.0 |
| 2021-12-14 04:45:00 | AAPL | Stock | 176.58 | 176.75 | 176.48 | 176.61 | 4445.0 |
| 2021-12-14 04:50:00 | AAPL | Stock | 176.52 | 176.52 | 176.06 | 176.13 | 15962.0 |
| 2021-12-14 04:55:00 | AAPL | Stock | 176.09 | 176.2 | 175.74 | 175.85 | 20934.0 |
| 2021-12-14 05:00:00 | AAPL | Stock | 175.8 | 176.39 | 175.8 | 176.0 | 13513.0 |
| 2021-12-14 05:05:00 | AAPL | Stock | 176.0 | 176.45 | 175.9 | 176.4 | 10534.0 |
| 2021-12-14 05:10:00 | AAPL | Stock | 176.32 | 176.32 | 176.1 | 176.1 | 4777.0 |
| 2021-12-14 05:15:00 | AAPL | Stock | 176.24 | 176.24 | 176.13 | 176.13 | 1929.0 |
| 2021-12-14 05:20:00 | AAPL | Stock | 176.13 | 176.32 | 176.13 | 176.24 | 5788.0 |
| 2021-12-14 05:25:00 | AAPL | Stock | 176.26 | 176.35 | 176.24 | 176.35 | 2726.0 |
| 2021-12-14 05:30:00 | AAPL | Stock | 176.26 | 176.5 | 176.26 | 176.5 | 7720.0 |
| 2021-12-14 05:35:00 | AAPL | Stock | 176.49 | 176.5 | 176.31 | 176.39 | 6626.0 |
| 2021-12-14 05:40:00 | AAPL | Stock | 176.43 | 176.43 | 176.41 | 176.41 | 340.0 |
| 2021-12-14 05:45:00 | AAPL | Stock | 176.31 | 176.31 | 176.16 | 176.16 | 5312.0 |
| 2021-12-14 05:50:00 | AAPL | Stock | 176.1 | 176.1 | 176.0 | 176.04 | 2101.0 |
| 2021-12-14 05:55:00 | AAPL | Stock | 176.14 | 176.33 | 176.14 | 176.33 | 2499.0 |
| 2021-12-14 06:00:00 | AAPL | Stock | 176.33 | 176.45 | 176.16 | 176.16 | 9839.0 |
| 2021-12-14 06:05:00 | AAPL | Stock | 176.35 | 176.44 | 176.31 | 176.36 | 1063.0 |
| 2021-12-14 06:10:00 | AAPL | Stock | 176.44 | 176.65 | 176.43 | 176.52 | 11539.0 |
| 2021-12-14 06:15:00 | AAPL | Stock | 176.59 | 176.65 | 176.59 | 176.62 | 3570.0 |
| 2021-12-14 06:20:00 | AAPL | Stock | 176.63 | 176.64 | 176.4 | 176.43 | 5966.0 |
| 2021-12-14 06:25:00 | AAPL | Stock | 176.54 | 176.6 | 176.52 | 176.57 | 3183.0 |
| 2021-12-14 06:30:00 | AAPL | Stock | 176.64 | 176.73 | 176.58 | 176.58 | 4585.0 |
| 2021-12-14 06:35:00 | AAPL | Stock | 176.52 | 176.52 | 176.28 | 176.41 | 3098.0 |
| 2021-12-14 06:40:00 | AAPL | Stock | 176.41 | 176.41 | 176.37 | 176.37 | 2795.0 |
| 2021-12-14 06:45:00 | AAPL | Stock | 176.48 | 176.54 | 176.26 | 176.27 | 6392.0 |
| 2021-12-14 06:50:00 | AAPL | Stock | 176.35 | 176.37 | 176.35 | 176.37 | 300.0 |
| 2021-12-14 06:55:00 | AAPL | Stock | 176.37 | 176.45 | 176.34 | 176.4 | 4025.0 |
| 2021-12-14 07:00:00 | AAPL | Stock | 176.45 | 176.68 | 176.0 | 176.5 | 60491.0 |
| 2021-12-14 07:05:00 | AAPL | Stock | 176.52 | 176.8 | 176.5 | 176.8 | 27765.0 |
| 2021-12-14 07:10:00 | AAPL | Stock | 176.81 | 176.81 | 176.63 | 176.81 | 16699.0 |
| 2021-12-14 07:15:00 | AAPL | Stock | 176.77 | 177.0 | 176.74 | 176.91 | 34348.0 |
| 2021-12-14 07:20:00 | AAPL | Stock | 176.9 | 177.35 | 176.88 | 177.35 | 68143.0 |
| 2021-12-14 07:25:00 | AAPL | Stock | 177.38 | 177.4 | 177.15 | 177.28 | 40632.0 |
| 2021-12-14 07:30:00 | AAPL | Stock | 177.25 | 177.27 | 177.1 | 177.2 | 11015.0 |
| 2021-12-14 07:35:00 | AAPL | Stock | 177.2 | 177.35 | 177.15 | 177.35 | 41843.0 |
| 2021-12-14 07:40:00 | AAPL | Stock | 177.37 | 177.41 | 177.14 | 177.28 | 33674.0 |
| 2021-12-14 07:45:00 | AAPL | Stock | 177.25 | 177.4 | 177.25 | 177.26 | 21374.0 |
| 2021-12-14 07:50:00 | AAPL | Stock | 177.28 | 177.31 | 177.15 | 177.22 | 18115.0 |
| 2021-12-14 07:55:00 | AAPL | Stock | 177.22 | 177.22 | 176.92 | 176.95 | 23505.0 |
| 2021-12-14 08:00:00 | AAPL | Stock | 176.64 | 177.42 | 175.301 | 176.88 | 225355.0 |
| 2021-12-14 08:05:00 | AAPL | Stock | 176.88 | 177.1101 | 176.76 | 177.11 | 75244.0 |
> showing 50 of 469,222 rows — these rows as CSV