PREVIEW / stock_5min / 2021-05-19
file: by_date/stock_5min/2021/2021-05-19.parquet size: 7.3 MB rows: 455,929 symbols: 2,957
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-05-19 04:00:00 | AAPL | Stock | 123.83 | 123.83 | 123.33 | 123.51 | 3835.0 |
| 2021-05-19 04:05:00 | AAPL | Stock | 123.51 | 123.76 | 123.51 | 123.6 | 2303.0 |
| 2021-05-19 04:10:00 | AAPL | Stock | 123.65 | 123.65 | 123.4 | 123.4 | 2521.0 |
| 2021-05-19 04:15:00 | AAPL | Stock | 123.38 | 123.43 | 123.26 | 123.26 | 3043.0 |
| 2021-05-19 04:20:00 | AAPL | Stock | 123.23 | 123.4 | 123.21 | 123.4 | 9821.0 |
| 2021-05-19 04:25:00 | AAPL | Stock | 123.41 | 123.5 | 123.2 | 123.5 | 6147.0 |
| 2021-05-19 04:30:00 | AAPL | Stock | 123.5 | 123.58 | 123.5 | 123.52 | 6177.0 |
| 2021-05-19 04:35:00 | AAPL | Stock | 123.5 | 123.58 | 123.5 | 123.52 | 1860.0 |
| 2021-05-19 04:40:00 | AAPL | Stock | 123.51 | 123.51 | 123.16 | 123.35 | 4616.0 |
| 2021-05-19 04:45:00 | AAPL | Stock | 123.37 | 123.37 | 123.24 | 123.33 | 7748.0 |
| 2021-05-19 04:50:00 | AAPL | Stock | 123.35 | 123.35 | 123.18 | 123.2 | 2449.0 |
| 2021-05-19 04:55:00 | AAPL | Stock | 123.24 | 123.44 | 123.24 | 123.44 | 1694.0 |
| 2021-05-19 05:05:00 | AAPL | Stock | 123.5 | 123.5 | 123.5 | 123.5 | 658.0 |
| 2021-05-19 05:15:00 | AAPL | Stock | 123.6 | 123.66 | 123.6 | 123.66 | 1047.0 |
| 2021-05-19 05:20:00 | AAPL | Stock | 123.69 | 123.71 | 123.66 | 123.66 | 1197.0 |
| 2021-05-19 05:25:00 | AAPL | Stock | 123.65 | 123.65 | 123.6 | 123.61 | 716.0 |
| 2021-05-19 05:30:00 | AAPL | Stock | 123.6 | 123.62 | 123.6 | 123.62 | 656.0 |
| 2021-05-19 05:35:00 | AAPL | Stock | 123.55 | 123.55 | 123.5 | 123.52 | 2216.0 |
| 2021-05-19 05:40:00 | AAPL | Stock | 123.6 | 123.64 | 123.4 | 123.4 | 1636.0 |
| 2021-05-19 05:45:00 | AAPL | Stock | 123.35 | 123.35 | 123.19 | 123.22 | 9751.0 |
| 2021-05-19 05:50:00 | AAPL | Stock | 123.24 | 123.24 | 123.11 | 123.11 | 5021.0 |
| 2021-05-19 05:55:00 | AAPL | Stock | 123.11 | 123.19 | 123.01 | 123.19 | 6445.0 |
| 2021-05-19 06:00:00 | AAPL | Stock | 123.1 | 123.18 | 123.1 | 123.16 | 2018.0 |
| 2021-05-19 06:05:00 | AAPL | Stock | 123.14 | 123.14 | 123.06 | 123.06 | 719.0 |
| 2021-05-19 06:10:00 | AAPL | Stock | 123.19 | 123.25 | 123.19 | 123.25 | 726.0 |
| 2021-05-19 06:15:00 | AAPL | Stock | 123.29 | 123.29 | 123.29 | 123.29 | 702.0 |
| 2021-05-19 06:20:00 | AAPL | Stock | 123.27 | 123.41 | 123.27 | 123.41 | 1605.0 |
| 2021-05-19 06:25:00 | AAPL | Stock | 123.38 | 123.38 | 123.29 | 123.32 | 5563.0 |
| 2021-05-19 06:30:00 | AAPL | Stock | 123.36 | 123.36 | 123.28 | 123.28 | 572.0 |
| 2021-05-19 06:35:00 | AAPL | Stock | 123.27 | 123.37 | 123.27 | 123.37 | 995.0 |
| 2021-05-19 06:40:00 | AAPL | Stock | 123.39 | 123.48 | 123.39 | 123.48 | 945.0 |
| 2021-05-19 06:45:00 | AAPL | Stock | 123.42 | 123.45 | 123.42 | 123.42 | 787.0 |
| 2021-05-19 06:50:00 | AAPL | Stock | 123.37 | 123.42 | 123.37 | 123.42 | 617.0 |
| 2021-05-19 06:55:00 | AAPL | Stock | 123.42 | 123.42 | 123.4 | 123.41 | 1276.0 |
| 2021-05-19 07:00:00 | AAPL | Stock | 123.5 | 123.67 | 123.3 | 123.53 | 32488.0 |
| 2021-05-19 07:05:00 | AAPL | Stock | 123.51 | 123.51 | 123.28 | 123.33 | 36674.0 |
| 2021-05-19 07:10:00 | AAPL | Stock | 123.33 | 123.4 | 123.23 | 123.39 | 29342.0 |
| 2021-05-19 07:15:00 | AAPL | Stock | 123.39 | 123.39 | 123.1 | 123.13 | 30392.0 |
| 2021-05-19 07:20:00 | AAPL | Stock | 123.16 | 123.2 | 123.03 | 123.08 | 13982.0 |
| 2021-05-19 07:25:00 | AAPL | Stock | 123.1 | 123.19 | 123.06 | 123.18 | 13188.0 |
| 2021-05-19 07:30:00 | AAPL | Stock | 123.15 | 123.19 | 123.01 | 123.05 | 44125.0 |
| 2021-05-19 07:35:00 | AAPL | Stock | 123.07 | 123.17 | 123.03 | 123.09 | 14667.0 |
| 2021-05-19 07:40:00 | AAPL | Stock | 123.06 | 123.15 | 122.95 | 123.031 | 34040.0 |
| 2021-05-19 07:45:00 | AAPL | Stock | 123.04 | 123.15 | 123.01 | 123.15 | 31117.0 |
| 2021-05-19 07:50:00 | AAPL | Stock | 123.1 | 123.13 | 123.03 | 123.03 | 6940.0 |
| 2021-05-19 07:55:00 | AAPL | Stock | 123.05 | 123.08 | 123.0 | 123.05 | 16744.0 |
| 2021-05-19 08:00:00 | AAPL | Stock | 123.52 | 125.162 | 122.99 | 123.26 | 187520.0 |
| 2021-05-19 08:05:00 | AAPL | Stock | 123.28 | 123.33 | 123.21 | 123.28 | 29433.0 |
| 2021-05-19 08:10:00 | AAPL | Stock | 123.25 | 123.32 | 123.1 | 123.28 | 29582.0 |
| 2021-05-19 08:15:00 | AAPL | Stock | 123.28 | 123.29 | 123.16 | 123.2 | 20194.0 |
> showing 50 of 455,929 rows — these rows as CSV