PREVIEW / stock_5min / 2020-08-27
file: by_date/stock_5min/2020/2020-08-27.parquet size: 6.5 MB rows: 407,108 symbols: 2,449
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-08-27 04:00:00 | AAPL | Stock | 126.5275 | 126.645 | 126.5275 | 126.645 | 3980.0 |
| 2020-08-27 04:05:00 | AAPL | Stock | 126.6 | 126.625 | 126.43 | 126.4625 | 11116.0 |
| 2020-08-27 04:20:00 | AAPL | Stock | 126.3825 | 126.3825 | 126.3825 | 126.3825 | 400.0 |
| 2020-08-27 04:25:00 | AAPL | Stock | 126.425 | 126.425 | 126.425 | 126.425 | 400.0 |
| 2020-08-27 04:45:00 | AAPL | Stock | 126.4175 | 126.48 | 126.4175 | 126.48 | 1512.0 |
| 2020-08-27 04:50:00 | AAPL | Stock | 126.4225 | 126.4225 | 126.4225 | 126.4225 | 800.0 |
| 2020-08-27 05:00:00 | AAPL | Stock | 126.36 | 126.36 | 126.2575 | 126.2575 | 1600.0 |
| 2020-08-27 05:05:00 | AAPL | Stock | 126.2575 | 126.2575 | 126.2575 | 126.2575 | 400.0 |
| 2020-08-27 05:15:00 | AAPL | Stock | 126.2025 | 126.2025 | 126.155 | 126.155 | 4112.0 |
| 2020-08-27 05:20:00 | AAPL | Stock | 126.1175 | 126.12 | 126.1175 | 126.12 | 1200.0 |
| 2020-08-27 05:25:00 | AAPL | Stock | 126.05 | 126.05 | 126.005 | 126.005 | 1128.0 |
| 2020-08-27 05:35:00 | AAPL | Stock | 126.245 | 126.26 | 126.245 | 126.26 | 800.0 |
| 2020-08-27 05:45:00 | AAPL | Stock | 126.225 | 126.2475 | 126.225 | 126.2475 | 1440.0 |
| 2020-08-27 05:50:00 | AAPL | Stock | 126.25 | 126.25 | 126.2075 | 126.245 | 2160.0 |
| 2020-08-27 05:55:00 | AAPL | Stock | 126.285 | 126.325 | 126.285 | 126.325 | 812.0 |
| 2020-08-27 06:00:00 | AAPL | Stock | 126.325 | 126.325 | 126.325 | 126.325 | 5296.0 |
| 2020-08-27 06:05:00 | AAPL | Stock | 126.2925 | 126.2925 | 126.2925 | 126.2925 | 800.0 |
| 2020-08-27 06:10:00 | AAPL | Stock | 126.37 | 126.37 | 126.37 | 126.37 | 400.0 |
| 2020-08-27 06:15:00 | AAPL | Stock | 126.325 | 126.325 | 126.325 | 126.325 | 408.0 |
| 2020-08-27 06:20:00 | AAPL | Stock | 126.325 | 126.325 | 126.325 | 126.325 | 588.0 |
| 2020-08-27 06:25:00 | AAPL | Stock | 126.305 | 126.3625 | 126.305 | 126.3625 | 1052.0 |
| 2020-08-27 06:30:00 | AAPL | Stock | 126.355 | 126.355 | 126.35 | 126.35 | 904.0 |
| 2020-08-27 06:35:00 | AAPL | Stock | 126.3575 | 126.375 | 126.3575 | 126.375 | 8340.0 |
| 2020-08-27 06:45:00 | AAPL | Stock | 126.375 | 126.375 | 126.375 | 126.375 | 640.0 |
| 2020-08-27 06:50:00 | AAPL | Stock | 126.35 | 126.35 | 126.35 | 126.35 | 600.0 |
| 2020-08-27 06:55:00 | AAPL | Stock | 126.375 | 126.375 | 126.375 | 126.375 | 6584.0 |
| 2020-08-27 07:00:00 | AAPL | Stock | 126.375 | 126.5875 | 126.29 | 126.5875 | 72240.0 |
| 2020-08-27 07:05:00 | AAPL | Stock | 126.55 | 126.595 | 126.54 | 126.595 | 19520.0 |
| 2020-08-27 07:10:00 | AAPL | Stock | 126.625 | 126.9 | 126.625 | 126.9 | 66028.0 |
| 2020-08-27 07:15:00 | AAPL | Stock | 126.905 | 126.9925 | 126.875 | 126.8775 | 66008.0 |
| 2020-08-27 07:20:00 | AAPL | Stock | 126.9 | 127.0325 | 126.8225 | 126.9975 | 38120.0 |
| 2020-08-27 07:25:00 | AAPL | Stock | 126.9925 | 127.1425 | 126.91 | 127.0525 | 69452.0 |
| 2020-08-27 07:30:00 | AAPL | Stock | 127.0525 | 127.315 | 127.01 | 127.315 | 53512.0 |
| 2020-08-27 07:35:00 | AAPL | Stock | 127.3 | 127.4675 | 127.1925 | 127.1925 | 113380.0 |
| 2020-08-27 07:40:00 | AAPL | Stock | 127.1875 | 127.28 | 127.18 | 127.28 | 29716.0 |
| 2020-08-27 07:45:00 | AAPL | Stock | 127.25 | 127.25 | 126.84 | 126.8425 | 28244.0 |
| 2020-08-27 07:50:00 | AAPL | Stock | 126.875 | 127.1225 | 126.875 | 127.1125 | 32608.0 |
| 2020-08-27 07:55:00 | AAPL | Stock | 127.07 | 127.185 | 127.07 | 127.1375 | 34312.0 |
| 2020-08-27 08:00:00 | AAPL | Stock | 126.825 | 127.445 | 126.2625 | 127.1375 | 210644.0 |
| 2020-08-27 08:05:00 | AAPL | Stock | 127.1012 | 127.1375 | 127.0025 | 127.0425 | 29336.0 |
| 2020-08-27 08:10:00 | AAPL | Stock | 127.075 | 127.15 | 127.0425 | 127.15 | 16852.0 |
| 2020-08-27 08:15:00 | AAPL | Stock | 127.075 | 127.1625 | 127.0725 | 127.1075 | 43872.0 |
| 2020-08-27 08:20:00 | AAPL | Stock | 127.05 | 127.0625 | 126.925 | 127.0025 | 37604.0 |
| 2020-08-27 08:25:00 | AAPL | Stock | 126.975 | 126.975 | 126.875 | 126.935 | 39104.0 |
| 2020-08-27 08:30:00 | AAPL | Stock | 126.9975 | 127.15 | 126.945 | 127.1025 | 84072.0 |
| 2020-08-27 08:35:00 | AAPL | Stock | 127.075 | 127.075 | 126.9575 | 127.0175 | 32544.0 |
| 2020-08-27 08:40:00 | AAPL | Stock | 127.0475 | 127.1 | 127.025 | 127.05 | 29936.0 |
| 2020-08-27 08:45:00 | AAPL | Stock | 127.025 | 127.1 | 127.025 | 127.1 | 14032.0 |
| 2020-08-27 08:50:00 | AAPL | Stock | 127.0575 | 127.125 | 127.025 | 127.05 | 40148.0 |
| 2020-08-27 08:55:00 | AAPL | Stock | 127.0575 | 127.06 | 126.905 | 126.985 | 52340.0 |
> showing 50 of 407,108 rows — these rows as CSV