PREVIEW / stock_5min / 2020-10-30
file: by_date/stock_5min/2020/2020-10-30.parquet size: 6.5 MB rows: 404,340 symbols: 2,516
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-10-30 04:00:00 | AAPL | Stock | 109.82 | 109.82 | 108.9 | 108.98 | 38860.0 |
| 2020-10-30 04:05:00 | AAPL | Stock | 108.9 | 109.53 | 108.7 | 109.4 | 26277.0 |
| 2020-10-30 04:10:00 | AAPL | Stock | 109.49 | 109.85 | 109.21 | 109.85 | 16192.0 |
| 2020-10-30 04:15:00 | AAPL | Stock | 109.8 | 109.89 | 109.74 | 109.89 | 7554.0 |
| 2020-10-30 04:20:00 | AAPL | Stock | 109.86 | 109.86 | 109.63 | 109.63 | 6063.0 |
| 2020-10-30 04:25:00 | AAPL | Stock | 109.69 | 109.86 | 109.34 | 109.57 | 9100.0 |
| 2020-10-30 04:30:00 | AAPL | Stock | 109.59 | 109.86 | 109.57 | 109.8 | 3848.0 |
| 2020-10-30 04:35:00 | AAPL | Stock | 109.8 | 109.81 | 109.7 | 109.71 | 2698.0 |
| 2020-10-30 04:40:00 | AAPL | Stock | 109.7 | 109.83 | 109.52 | 109.79 | 5135.0 |
| 2020-10-30 04:45:00 | AAPL | Stock | 109.71 | 109.74 | 109.6 | 109.63 | 7534.0 |
| 2020-10-30 04:50:00 | AAPL | Stock | 109.65 | 109.77 | 109.41 | 109.49 | 17787.0 |
| 2020-10-30 04:55:00 | AAPL | Stock | 109.19 | 109.8 | 109.19 | 109.8 | 9365.0 |
| 2020-10-30 05:00:00 | AAPL | Stock | 109.78 | 109.78 | 109.6 | 109.65 | 2107.0 |
| 2020-10-30 05:05:00 | AAPL | Stock | 109.74 | 110.0 | 109.5 | 109.83 | 14089.0 |
| 2020-10-30 05:10:00 | AAPL | Stock | 109.91 | 110.1 | 109.9 | 109.93 | 10038.0 |
| 2020-10-30 05:15:00 | AAPL | Stock | 109.95 | 110.2 | 109.95 | 110.16 | 3803.0 |
| 2020-10-30 05:20:00 | AAPL | Stock | 110.21 | 110.4 | 110.2 | 110.38 | 8410.0 |
| 2020-10-30 05:25:00 | AAPL | Stock | 110.35 | 110.4 | 110.18 | 110.37 | 8227.0 |
| 2020-10-30 05:30:00 | AAPL | Stock | 110.4 | 110.45 | 110.28 | 110.38 | 14901.0 |
| 2020-10-30 05:35:00 | AAPL | Stock | 110.36 | 110.36 | 110.3 | 110.32 | 3445.0 |
| 2020-10-30 05:40:00 | AAPL | Stock | 110.3 | 110.59 | 110.3 | 110.57 | 6348.0 |
| 2020-10-30 05:45:00 | AAPL | Stock | 110.57 | 110.57 | 110.48 | 110.53 | 1863.0 |
| 2020-10-30 05:50:00 | AAPL | Stock | 110.53 | 110.64 | 110.49 | 110.49 | 4868.0 |
| 2020-10-30 05:55:00 | AAPL | Stock | 110.46 | 110.51 | 110.07 | 110.51 | 4066.0 |
| 2020-10-30 06:00:00 | AAPL | Stock | 110.45 | 110.45 | 110.1 | 110.1 | 7000.0 |
| 2020-10-30 06:05:00 | AAPL | Stock | 110.2 | 110.64 | 110.2 | 110.59 | 3000.0 |
| 2020-10-30 06:10:00 | AAPL | Stock | 110.63 | 110.68 | 110.55 | 110.66 | 4324.0 |
| 2020-10-30 06:15:00 | AAPL | Stock | 110.68 | 110.75 | 110.6 | 110.7 | 6993.0 |
| 2020-10-30 06:20:00 | AAPL | Stock | 110.71 | 110.94 | 110.7 | 110.9 | 34143.0 |
| 2020-10-30 06:25:00 | AAPL | Stock | 110.84 | 111.13 | 110.69 | 110.78 | 28562.0 |
| 2020-10-30 06:30:00 | AAPL | Stock | 110.82 | 111.28 | 110.8 | 111.12 | 13004.0 |
| 2020-10-30 06:35:00 | AAPL | Stock | 111.02 | 111.08 | 110.71 | 110.9 | 8435.0 |
| 2020-10-30 06:40:00 | AAPL | Stock | 110.81 | 110.86 | 110.63 | 110.75 | 4987.0 |
| 2020-10-30 06:45:00 | AAPL | Stock | 110.81 | 111.2 | 110.71 | 110.72 | 15708.0 |
| 2020-10-30 06:50:00 | AAPL | Stock | 110.76 | 110.93 | 110.62 | 110.93 | 5932.0 |
| 2020-10-30 06:55:00 | AAPL | Stock | 110.9 | 111.19 | 110.9 | 111.05 | 21462.0 |
| 2020-10-30 07:00:00 | AAPL | Stock | 111.06 | 111.12 | 110.8 | 110.89 | 95439.0 |
| 2020-10-30 07:05:00 | AAPL | Stock | 110.95 | 111.01 | 110.81 | 110.99 | 36776.0 |
| 2020-10-30 07:10:00 | AAPL | Stock | 110.97 | 111.03 | 110.81 | 110.89 | 47637.0 |
| 2020-10-30 07:15:00 | AAPL | Stock | 110.85 | 111.0 | 110.76 | 110.83 | 50252.0 |
| 2020-10-30 07:20:00 | AAPL | Stock | 110.81 | 110.96 | 110.75 | 110.79 | 37911.0 |
| 2020-10-30 07:25:00 | AAPL | Stock | 110.79 | 110.8 | 110.65 | 110.68 | 25901.0 |
| 2020-10-30 07:30:00 | AAPL | Stock | 110.68 | 110.75 | 110.55 | 110.55 | 25787.0 |
| 2020-10-30 07:35:00 | AAPL | Stock | 110.54 | 110.54 | 110.5 | 110.5 | 29284.0 |
| 2020-10-30 07:40:00 | AAPL | Stock | 110.51 | 110.75 | 110.51 | 110.66 | 21919.0 |
| 2020-10-30 07:45:00 | AAPL | Stock | 110.68 | 110.68 | 110.52 | 110.55 | 17571.0 |
| 2020-10-30 07:50:00 | AAPL | Stock | 110.55 | 110.7 | 110.55 | 110.7 | 21390.0 |
| 2020-10-30 07:55:00 | AAPL | Stock | 110.71 | 110.74 | 110.61 | 110.73 | 24821.0 |
| 2020-10-30 08:00:00 | AAPL | Stock | 110.95 | 111.1 | 110.5 | 110.65 | 231780.0 |
| 2020-10-30 08:05:00 | AAPL | Stock | 110.62 | 110.63 | 110.36 | 110.45 | 99849.0 |
> showing 50 of 404,340 rows — these rows as CSV