PREVIEW / stock_5min / 2020-09-21
file: by_date/stock_5min/2020/2020-09-21.parquet size: 6.7 MB rows: 425,330 symbols: 2,496
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-09-21 04:00:00 | AAPL | Stock | 105.64 | 105.68 | 105.01 | 105.25 | 26412.0 |
| 2020-09-21 04:05:00 | AAPL | Stock | 105.3 | 105.41 | 105.24 | 105.3 | 21940.0 |
| 2020-09-21 04:10:00 | AAPL | Stock | 105.31 | 105.31 | 104.9 | 104.9 | 26938.0 |
| 2020-09-21 04:15:00 | AAPL | Stock | 104.87 | 104.95 | 104.7 | 104.78 | 26235.0 |
| 2020-09-21 04:20:00 | AAPL | Stock | 104.8 | 104.8 | 104.39 | 104.6 | 24624.0 |
| 2020-09-21 04:25:00 | AAPL | Stock | 104.59 | 104.72 | 104.38 | 104.72 | 11867.0 |
| 2020-09-21 04:30:00 | AAPL | Stock | 104.79 | 104.8 | 104.5 | 104.5 | 13161.0 |
| 2020-09-21 04:35:00 | AAPL | Stock | 104.52 | 104.61 | 104.51 | 104.51 | 7025.0 |
| 2020-09-21 04:40:00 | AAPL | Stock | 104.52 | 104.52 | 104.17 | 104.22 | 23035.0 |
| 2020-09-21 04:45:00 | AAPL | Stock | 104.22 | 104.42 | 103.92 | 104.18 | 32591.0 |
| 2020-09-21 04:50:00 | AAPL | Stock | 104.16 | 104.43 | 104.11 | 104.36 | 25784.0 |
| 2020-09-21 04:55:00 | AAPL | Stock | 104.39 | 104.54 | 104.32 | 104.37 | 12380.0 |
| 2020-09-21 05:00:00 | AAPL | Stock | 104.36 | 104.38 | 104.2 | 104.3 | 14166.0 |
| 2020-09-21 05:05:00 | AAPL | Stock | 104.28 | 104.68 | 104.28 | 104.6 | 9136.0 |
| 2020-09-21 05:10:00 | AAPL | Stock | 104.6 | 105.23 | 104.6 | 104.9 | 19946.0 |
| 2020-09-21 05:15:00 | AAPL | Stock | 104.9 | 105.0 | 104.9 | 104.93 | 8020.0 |
| 2020-09-21 05:20:00 | AAPL | Stock | 104.96 | 104.96 | 104.73 | 104.77 | 4478.0 |
| 2020-09-21 05:25:00 | AAPL | Stock | 104.81 | 104.81 | 104.3 | 104.43 | 7294.0 |
| 2020-09-21 05:30:00 | AAPL | Stock | 104.65 | 104.7 | 104.31 | 104.31 | 11401.0 |
| 2020-09-21 05:35:00 | AAPL | Stock | 104.3 | 104.55 | 104.29 | 104.29 | 5114.0 |
| 2020-09-21 05:40:00 | AAPL | Stock | 104.25 | 104.28 | 104.12 | 104.2 | 30163.0 |
| 2020-09-21 05:45:00 | AAPL | Stock | 104.2 | 104.22 | 103.91 | 104.18 | 30570.0 |
| 2020-09-21 05:50:00 | AAPL | Stock | 104.14 | 104.37 | 103.95 | 104.37 | 7421.0 |
| 2020-09-21 05:55:00 | AAPL | Stock | 104.39 | 104.39 | 103.95 | 104.05 | 11413.0 |
| 2020-09-21 06:00:00 | AAPL | Stock | 104.08 | 104.2 | 104.0 | 104.12 | 6342.0 |
| 2020-09-21 06:05:00 | AAPL | Stock | 104.14 | 104.44 | 104.05 | 104.32 | 6368.0 |
| 2020-09-21 06:10:00 | AAPL | Stock | 104.3 | 104.4 | 104.2 | 104.2 | 5712.0 |
| 2020-09-21 06:15:00 | AAPL | Stock | 104.24 | 104.35 | 104.2 | 104.25 | 6699.0 |
| 2020-09-21 06:20:00 | AAPL | Stock | 104.28 | 105.0 | 104.25 | 105.0 | 23898.0 |
| 2020-09-21 06:25:00 | AAPL | Stock | 104.9 | 104.91 | 104.56 | 104.66 | 9425.0 |
| 2020-09-21 06:30:00 | AAPL | Stock | 104.65 | 105.1 | 104.65 | 105.08 | 24695.0 |
| 2020-09-21 06:35:00 | AAPL | Stock | 105.1 | 105.1 | 104.91 | 105.0 | 13932.0 |
| 2020-09-21 06:40:00 | AAPL | Stock | 105.0 | 105.01 | 104.88 | 105.01 | 19415.0 |
| 2020-09-21 06:45:00 | AAPL | Stock | 105.02 | 105.18 | 104.88 | 105.0 | 20725.0 |
| 2020-09-21 06:50:00 | AAPL | Stock | 105.0 | 105.11 | 104.95 | 105.1 | 13390.0 |
| 2020-09-21 06:55:00 | AAPL | Stock | 105.1 | 105.2 | 105.02 | 105.2 | 11297.0 |
| 2020-09-21 07:00:00 | AAPL | Stock | 105.15 | 105.44 | 104.01 | 104.31 | 486602.0 |
| 2020-09-21 07:05:00 | AAPL | Stock | 104.26 | 104.38 | 103.91 | 104.09 | 167230.0 |
| 2020-09-21 07:10:00 | AAPL | Stock | 104.08 | 104.25 | 104.0 | 104.25 | 56059.0 |
| 2020-09-21 07:15:00 | AAPL | Stock | 104.25 | 104.29 | 104.0 | 104.02 | 42458.0 |
| 2020-09-21 07:20:00 | AAPL | Stock | 104.05 | 104.05 | 103.54 | 103.6 | 88940.0 |
| 2020-09-21 07:25:00 | AAPL | Stock | 103.56 | 103.59 | 103.36 | 103.59 | 101988.0 |
| 2020-09-21 07:30:00 | AAPL | Stock | 103.56 | 103.81 | 103.43 | 103.74 | 116062.0 |
| 2020-09-21 07:35:00 | AAPL | Stock | 103.72 | 104.01 | 103.61 | 103.96 | 95218.0 |
| 2020-09-21 07:40:00 | AAPL | Stock | 103.96 | 104.2 | 103.86 | 104.15 | 65331.0 |
| 2020-09-21 07:45:00 | AAPL | Stock | 104.111 | 104.66 | 104.1 | 104.57 | 109168.0 |
| 2020-09-21 07:50:00 | AAPL | Stock | 104.58 | 104.7 | 104.35 | 104.5 | 82765.0 |
| 2020-09-21 07:55:00 | AAPL | Stock | 104.5 | 104.74 | 104.44 | 104.49 | 72121.0 |
| 2020-09-21 08:00:00 | AAPL | Stock | 104.52 | 105.35 | 103.38 | 104.2 | 592703.0 |
| 2020-09-21 08:05:00 | AAPL | Stock | 104.19 | 104.19 | 103.8 | 103.87 | 192892.0 |
> showing 50 of 425,330 rows — these rows as CSV