PREVIEW / stock_5min / 2020-11-12
file: by_date/stock_5min/2020/2020-11-12.parquet size: 6.7 MB rows: 413,674 symbols: 2,509
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-11-12 04:00:00 | AAPL | Stock | 119.22 | 119.22 | 118.7 | 119.04 | 8756.0 |
| 2020-11-12 04:05:00 | AAPL | Stock | 119.0 | 119.29 | 118.92 | 119.29 | 2796.0 |
| 2020-11-12 04:10:00 | AAPL | Stock | 119.16 | 119.18 | 119.0 | 119.17 | 8903.0 |
| 2020-11-12 04:15:00 | AAPL | Stock | 119.19 | 119.2 | 119.13 | 119.13 | 868.0 |
| 2020-11-12 04:20:00 | AAPL | Stock | 119.13 | 119.13 | 119.0 | 119.0 | 14194.0 |
| 2020-11-12 04:25:00 | AAPL | Stock | 119.16 | 119.2 | 119.16 | 119.2 | 2343.0 |
| 2020-11-12 04:30:00 | AAPL | Stock | 119.26 | 119.42 | 119.26 | 119.42 | 4815.0 |
| 2020-11-12 04:35:00 | AAPL | Stock | 119.44 | 119.64 | 119.4 | 119.64 | 1408.0 |
| 2020-11-12 04:40:00 | AAPL | Stock | 119.55 | 119.55 | 119.4 | 119.43 | 1464.0 |
| 2020-11-12 04:45:00 | AAPL | Stock | 119.69 | 119.84 | 119.47 | 119.75 | 5266.0 |
| 2020-11-12 04:50:00 | AAPL | Stock | 119.8 | 119.82 | 119.64 | 119.65 | 1640.0 |
| 2020-11-12 04:55:00 | AAPL | Stock | 119.65 | 119.97 | 119.6 | 119.83 | 4259.0 |
| 2020-11-12 05:00:00 | AAPL | Stock | 119.94 | 120.14 | 119.88 | 119.89 | 39638.0 |
| 2020-11-12 05:05:00 | AAPL | Stock | 119.88 | 119.88 | 119.76 | 119.83 | 1032.0 |
| 2020-11-12 05:10:00 | AAPL | Stock | 119.9 | 119.9 | 119.87 | 119.9 | 2329.0 |
| 2020-11-12 05:15:00 | AAPL | Stock | 119.9 | 120.16 | 119.9 | 120.14 | 5118.0 |
| 2020-11-12 05:20:00 | AAPL | Stock | 120.14 | 120.14 | 119.88 | 119.88 | 3242.0 |
| 2020-11-12 05:25:00 | AAPL | Stock | 119.88 | 119.91 | 119.8 | 119.8 | 1261.0 |
| 2020-11-12 05:30:00 | AAPL | Stock | 119.76 | 119.8 | 119.71 | 119.78 | 3976.0 |
| 2020-11-12 05:35:00 | AAPL | Stock | 119.8 | 119.91 | 119.76 | 119.91 | 3133.0 |
| 2020-11-12 05:40:00 | AAPL | Stock | 119.9 | 120.0 | 119.9 | 119.99 | 2071.0 |
| 2020-11-12 05:45:00 | AAPL | Stock | 120.0 | 120.0 | 119.77 | 119.78 | 1665.0 |
| 2020-11-12 05:50:00 | AAPL | Stock | 119.78 | 119.8 | 119.7 | 119.7 | 2168.0 |
| 2020-11-12 05:55:00 | AAPL | Stock | 119.62 | 120.0 | 119.61 | 119.95 | 3878.0 |
| 2020-11-12 06:00:00 | AAPL | Stock | 119.98 | 119.98 | 119.85 | 119.95 | 1296.0 |
| 2020-11-12 06:05:00 | AAPL | Stock | 119.91 | 119.91 | 119.91 | 119.91 | 100.0 |
| 2020-11-12 06:10:00 | AAPL | Stock | 119.91 | 119.91 | 119.68 | 119.7 | 4483.0 |
| 2020-11-12 06:15:00 | AAPL | Stock | 119.73 | 119.93 | 119.72 | 119.93 | 1783.0 |
| 2020-11-12 06:20:00 | AAPL | Stock | 119.95 | 120.0 | 119.95 | 119.96 | 2630.0 |
| 2020-11-12 06:25:00 | AAPL | Stock | 119.88 | 119.88 | 119.88 | 119.88 | 202.0 |
| 2020-11-12 06:30:00 | AAPL | Stock | 119.93 | 119.94 | 119.81 | 119.81 | 2355.0 |
| 2020-11-12 06:35:00 | AAPL | Stock | 119.94 | 119.96 | 119.93 | 119.93 | 2533.0 |
| 2020-11-12 06:45:00 | AAPL | Stock | 119.95 | 119.95 | 119.93 | 119.93 | 640.0 |
| 2020-11-12 06:50:00 | AAPL | Stock | 119.98 | 119.99 | 119.95 | 119.96 | 1200.0 |
| 2020-11-12 06:55:00 | AAPL | Stock | 119.95 | 119.95 | 119.8 | 119.8 | 1278.0 |
| 2020-11-12 07:00:00 | AAPL | Stock | 119.89 | 119.89 | 119.61 | 119.61 | 34883.0 |
| 2020-11-12 07:05:00 | AAPL | Stock | 119.61 | 119.62 | 119.19 | 119.32 | 28263.0 |
| 2020-11-12 07:10:00 | AAPL | Stock | 119.34 | 119.53 | 119.3 | 119.43 | 29248.0 |
| 2020-11-12 07:15:00 | AAPL | Stock | 119.4 | 119.45 | 119.35 | 119.45 | 14156.0 |
| 2020-11-12 07:20:00 | AAPL | Stock | 119.45 | 119.56 | 119.44 | 119.47 | 23618.0 |
| 2020-11-12 07:25:00 | AAPL | Stock | 119.48 | 119.74 | 119.47 | 119.74 | 15050.0 |
| 2020-11-12 07:30:00 | AAPL | Stock | 119.7 | 119.7 | 119.49 | 119.5 | 12221.0 |
| 2020-11-12 07:35:00 | AAPL | Stock | 119.49 | 119.6 | 119.42 | 119.42 | 12329.0 |
| 2020-11-12 07:40:00 | AAPL | Stock | 119.46 | 119.5 | 119.44 | 119.47 | 8451.0 |
| 2020-11-12 07:45:00 | AAPL | Stock | 119.51 | 119.63 | 119.48 | 119.53 | 18636.0 |
| 2020-11-12 07:50:00 | AAPL | Stock | 119.51 | 119.51 | 119.37 | 119.37 | 16715.0 |
| 2020-11-12 07:55:00 | AAPL | Stock | 119.38 | 119.41 | 119.3 | 119.35 | 10111.0 |
| 2020-11-12 08:00:00 | AAPL | Stock | 119.55 | 119.89 | 119.15 | 119.51 | 180284.0 |
| 2020-11-12 08:05:00 | AAPL | Stock | 119.52 | 119.52 | 119.35 | 119.41 | 22092.0 |
| 2020-11-12 08:10:00 | AAPL | Stock | 119.45 | 119.49 | 119.33 | 119.33 | 19204.0 |
> showing 50 of 413,674 rows — these rows as CSV