PREVIEW / stock_5min / 2020-04-22
file: by_date/stock_5min/2020/2020-04-22.parquet size: 6.1 MB rows: 389,149 symbols: 2,377
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-04-22 04:00:00 | AAPL | Stock | 67.995 | 67.995 | 67.995 | 67.995 | 13228.0 |
| 2020-04-22 04:05:00 | AAPL | Stock | 67.925 | 67.935 | 67.8725 | 67.8725 | 7096.0 |
| 2020-04-22 04:10:00 | AAPL | Stock | 67.925 | 68.245 | 67.925 | 68.245 | 8988.0 |
| 2020-04-22 04:15:00 | AAPL | Stock | 68.06 | 68.1075 | 68.0275 | 68.1075 | 2956.0 |
| 2020-04-22 04:20:00 | AAPL | Stock | 68.1075 | 68.1625 | 68.1075 | 68.16 | 3660.0 |
| 2020-04-22 04:25:00 | AAPL | Stock | 68.165 | 68.165 | 68.165 | 68.165 | 516.0 |
| 2020-04-22 04:30:00 | AAPL | Stock | 68.235 | 68.235 | 68.235 | 68.235 | 400.0 |
| 2020-04-22 04:35:00 | AAPL | Stock | 68.25 | 68.25 | 68.25 | 68.25 | 1340.0 |
| 2020-04-22 04:40:00 | AAPL | Stock | 68.275 | 68.31 | 68.2425 | 68.245 | 4520.0 |
| 2020-04-22 04:45:00 | AAPL | Stock | 68.1575 | 68.1575 | 68.1575 | 68.1575 | 400.0 |
| 2020-04-22 05:00:00 | AAPL | Stock | 68.325 | 68.325 | 68.325 | 68.325 | 2012.0 |
| 2020-04-22 05:05:00 | AAPL | Stock | 68.28 | 68.3 | 68.28 | 68.3 | 800.0 |
| 2020-04-22 05:10:00 | AAPL | Stock | 68.35 | 68.41 | 68.35 | 68.41 | 840.0 |
| 2020-04-22 05:20:00 | AAPL | Stock | 68.375 | 68.38 | 68.375 | 68.38 | 992.0 |
| 2020-04-22 05:25:00 | AAPL | Stock | 68.425 | 68.475 | 68.425 | 68.4375 | 2420.0 |
| 2020-04-22 05:30:00 | AAPL | Stock | 68.4 | 68.4 | 68.4 | 68.4 | 800.0 |
| 2020-04-22 06:00:00 | AAPL | Stock | 68.4 | 68.4 | 68.325 | 68.325 | 1320.0 |
| 2020-04-22 06:05:00 | AAPL | Stock | 68.275 | 68.275 | 68.2575 | 68.2575 | 5964.0 |
| 2020-04-22 06:10:00 | AAPL | Stock | 68.25 | 68.25 | 68.25 | 68.25 | 2308.0 |
| 2020-04-22 06:15:00 | AAPL | Stock | 68.1975 | 68.1975 | 68.175 | 68.175 | 2204.0 |
| 2020-04-22 06:20:00 | AAPL | Stock | 68.2 | 68.2 | 68.2 | 68.2 | 800.0 |
| 2020-04-22 06:25:00 | AAPL | Stock | 68.2 | 68.265 | 68.2 | 68.2625 | 14708.0 |
| 2020-04-22 06:30:00 | AAPL | Stock | 68.2625 | 68.3625 | 68.2625 | 68.305 | 8400.0 |
| 2020-04-22 06:35:00 | AAPL | Stock | 68.275 | 68.275 | 68.25 | 68.25 | 21244.0 |
| 2020-04-22 06:40:00 | AAPL | Stock | 68.27 | 68.27 | 68.25 | 68.25 | 17688.0 |
| 2020-04-22 06:45:00 | AAPL | Stock | 68.1925 | 68.195 | 68.125 | 68.1775 | 7852.0 |
| 2020-04-22 06:50:00 | AAPL | Stock | 68.1625 | 68.21 | 68.125 | 68.125 | 6964.0 |
| 2020-04-22 06:55:00 | AAPL | Stock | 68.2175 | 68.225 | 68.2175 | 68.225 | 1200.0 |
| 2020-04-22 07:00:00 | AAPL | Stock | 68.18 | 68.325 | 68.125 | 68.1575 | 40800.0 |
| 2020-04-22 07:05:00 | AAPL | Stock | 68.175 | 68.2475 | 68.1 | 68.125 | 27020.0 |
| 2020-04-22 07:10:00 | AAPL | Stock | 68.1275 | 68.225 | 68.1275 | 68.225 | 15928.0 |
| 2020-04-22 07:15:00 | AAPL | Stock | 68.235 | 68.25 | 68.1375 | 68.1375 | 7136.0 |
| 2020-04-22 07:20:00 | AAPL | Stock | 68.18 | 68.1825 | 68.08 | 68.08 | 5548.0 |
| 2020-04-22 07:25:00 | AAPL | Stock | 68.05 | 68.1125 | 68.025 | 68.05 | 7560.0 |
| 2020-04-22 07:30:00 | AAPL | Stock | 68.115 | 68.165 | 68.0875 | 68.1625 | 9504.0 |
| 2020-04-22 07:35:00 | AAPL | Stock | 68.125 | 68.125 | 68.05 | 68.0525 | 10496.0 |
| 2020-04-22 07:40:00 | AAPL | Stock | 68.1 | 68.11 | 68.0575 | 68.075 | 2900.0 |
| 2020-04-22 07:45:00 | AAPL | Stock | 68.0975 | 68.15 | 68.0275 | 68.0825 | 6744.0 |
| 2020-04-22 07:50:00 | AAPL | Stock | 68.0825 | 68.175 | 68.0625 | 68.175 | 9272.0 |
| 2020-04-22 07:55:00 | AAPL | Stock | 68.195 | 68.2125 | 68.1725 | 68.18 | 17588.0 |
| 2020-04-22 08:00:00 | AAPL | Stock | 68.18 | 68.2725 | 68.0 | 68.125 | 128820.0 |
| 2020-04-22 08:05:00 | AAPL | Stock | 68.125 | 68.125 | 68.005 | 68.005 | 10404.0 |
| 2020-04-22 08:10:00 | AAPL | Stock | 68.005 | 68.045 | 68.0025 | 68.045 | 12104.0 |
| 2020-04-22 08:15:00 | AAPL | Stock | 68.045 | 68.105 | 67.95 | 68.075 | 43628.0 |
| 2020-04-22 08:20:00 | AAPL | Stock | 68.085 | 68.125 | 68.05 | 68.1 | 36752.0 |
| 2020-04-22 08:25:00 | AAPL | Stock | 68.125 | 68.1975 | 68.125 | 68.195 | 28524.0 |
| 2020-04-22 08:30:00 | AAPL | Stock | 68.185 | 68.2125 | 68.175 | 68.21 | 15108.0 |
| 2020-04-22 08:35:00 | AAPL | Stock | 68.2 | 68.2225 | 68.1725 | 68.2225 | 99424.0 |
| 2020-04-22 08:40:00 | AAPL | Stock | 68.225 | 68.385 | 68.225 | 68.35 | 192216.0 |
| 2020-04-22 08:45:00 | AAPL | Stock | 68.345 | 68.3625 | 68.3375 | 68.35 | 12080.0 |
> showing 50 of 389,149 rows — these rows as CSV