PREVIEW / stock_5min / 2020-05-22
file: by_date/stock_5min/2020/2020-05-22.parquet size: 6.2 MB rows: 394,935 symbols: 2,370
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-05-22 04:00:00 | AAPL | Stock | 78.35 | 78.35 | 78.1775 | 78.1775 | 14300.0 |
| 2020-05-22 04:05:00 | AAPL | Stock | 78.125 | 78.125 | 78.125 | 78.125 | 1600.0 |
| 2020-05-22 04:15:00 | AAPL | Stock | 78.3075 | 78.32 | 78.3 | 78.3 | 4220.0 |
| 2020-05-22 04:25:00 | AAPL | Stock | 78.25 | 78.25 | 78.25 | 78.25 | 440.0 |
| 2020-05-22 04:30:00 | AAPL | Stock | 78.425 | 78.475 | 78.425 | 78.475 | 3400.0 |
| 2020-05-22 04:35:00 | AAPL | Stock | 78.3825 | 78.3825 | 78.3825 | 78.3825 | 1200.0 |
| 2020-05-22 04:40:00 | AAPL | Stock | 78.425 | 78.4875 | 78.425 | 78.4875 | 2260.0 |
| 2020-05-22 04:45:00 | AAPL | Stock | 78.46 | 78.46 | 78.46 | 78.46 | 1580.0 |
| 2020-05-22 04:50:00 | AAPL | Stock | 78.505 | 78.505 | 78.505 | 78.505 | 400.0 |
| 2020-05-22 04:55:00 | AAPL | Stock | 78.55 | 78.55 | 78.55 | 78.55 | 400.0 |
| 2020-05-22 05:00:00 | AAPL | Stock | 78.505 | 78.505 | 78.5 | 78.5 | 1600.0 |
| 2020-05-22 05:05:00 | AAPL | Stock | 78.5 | 78.5 | 78.5 | 78.5 | 800.0 |
| 2020-05-22 05:15:00 | AAPL | Stock | 78.5575 | 78.5625 | 78.55 | 78.5625 | 3200.0 |
| 2020-05-22 05:20:00 | AAPL | Stock | 78.695 | 78.695 | 78.695 | 78.695 | 420.0 |
| 2020-05-22 05:45:00 | AAPL | Stock | 78.64 | 78.67 | 78.64 | 78.67 | 27224.0 |
| 2020-05-22 05:50:00 | AAPL | Stock | 78.605 | 78.605 | 78.4825 | 78.54 | 1752.0 |
| 2020-05-22 06:00:00 | AAPL | Stock | 78.535 | 78.535 | 78.535 | 78.535 | 400.0 |
| 2020-05-22 06:20:00 | AAPL | Stock | 78.6625 | 78.6625 | 78.6575 | 78.6625 | 11472.0 |
| 2020-05-22 06:30:00 | AAPL | Stock | 78.725 | 78.8125 | 78.725 | 78.8125 | 800.0 |
| 2020-05-22 06:35:00 | AAPL | Stock | 78.755 | 78.755 | 78.75 | 78.75 | 4772.0 |
| 2020-05-22 06:40:00 | AAPL | Stock | 78.84 | 78.84 | 78.84 | 78.84 | 2224.0 |
| 2020-05-22 06:45:00 | AAPL | Stock | 78.7575 | 78.7575 | 78.6775 | 78.6775 | 8504.0 |
| 2020-05-22 06:55:00 | AAPL | Stock | 78.735 | 78.735 | 78.6875 | 78.725 | 3680.0 |
| 2020-05-22 07:00:00 | AAPL | Stock | 78.75 | 78.9275 | 78.75 | 78.775 | 32664.0 |
| 2020-05-22 07:05:00 | AAPL | Stock | 78.8125 | 78.875 | 78.8125 | 78.875 | 2400.0 |
| 2020-05-22 07:10:00 | AAPL | Stock | 78.875 | 79.0625 | 78.8725 | 79.0 | 36320.0 |
| 2020-05-22 07:15:00 | AAPL | Stock | 79.005 | 79.005 | 78.9075 | 78.9575 | 21844.0 |
| 2020-05-22 07:20:00 | AAPL | Stock | 78.9775 | 78.985 | 78.9125 | 78.985 | 13284.0 |
| 2020-05-22 07:25:00 | AAPL | Stock | 78.925 | 78.9775 | 78.875 | 78.9025 | 17836.0 |
| 2020-05-22 07:30:00 | AAPL | Stock | 78.96 | 78.9875 | 78.92 | 78.92 | 3508.0 |
| 2020-05-22 07:35:00 | AAPL | Stock | 78.9375 | 78.9375 | 78.9125 | 78.915 | 3932.0 |
| 2020-05-22 07:40:00 | AAPL | Stock | 78.9825 | 79.1275 | 78.9825 | 79.1275 | 36212.0 |
| 2020-05-22 07:45:00 | AAPL | Stock | 79.1725 | 79.19 | 79.11 | 79.17 | 47552.0 |
| 2020-05-22 07:50:00 | AAPL | Stock | 79.165 | 79.2425 | 79.1275 | 79.2225 | 30312.0 |
| 2020-05-22 07:55:00 | AAPL | Stock | 79.2225 | 79.225 | 79.15 | 79.15 | 4528.0 |
| 2020-05-22 08:00:00 | AAPL | Stock | 79.2025 | 79.245 | 78.7625 | 79.15 | 84400.0 |
| 2020-05-22 08:05:00 | AAPL | Stock | 79.1325 | 79.17 | 79.0312 | 79.13 | 9728.0 |
| 2020-05-22 08:10:00 | AAPL | Stock | 79.14 | 79.195 | 79.0675 | 79.195 | 15936.0 |
| 2020-05-22 08:15:00 | AAPL | Stock | 79.1925 | 79.2475 | 79.1775 | 79.1875 | 23916.0 |
| 2020-05-22 08:20:00 | AAPL | Stock | 79.1875 | 79.1875 | 79.08 | 79.125 | 17496.0 |
| 2020-05-22 08:25:00 | AAPL | Stock | 79.1175 | 79.1175 | 79.0 | 79.0 | 52548.0 |
| 2020-05-22 08:30:00 | AAPL | Stock | 79.0225 | 79.05 | 78.94 | 78.975 | 16056.0 |
| 2020-05-22 08:35:00 | AAPL | Stock | 78.995 | 79.015 | 78.955 | 78.96 | 11640.0 |
| 2020-05-22 08:40:00 | AAPL | Stock | 78.975 | 79.11 | 78.975 | 79.1 | 21564.0 |
| 2020-05-22 08:45:00 | AAPL | Stock | 79.1 | 79.1525 | 79.045 | 79.1055 | 22656.0 |
| 2020-05-22 08:50:00 | AAPL | Stock | 79.075 | 79.075 | 79.0 | 79.0 | 37476.0 |
| 2020-05-22 08:55:00 | AAPL | Stock | 78.9942 | 79.05 | 78.9925 | 79.025 | 14488.0 |
| 2020-05-22 09:00:00 | AAPL | Stock | 79.0 | 79.125 | 78.9525 | 79.075 | 27464.0 |
| 2020-05-22 09:05:00 | AAPL | Stock | 79.1175 | 79.1825 | 79.1175 | 79.1225 | 15348.0 |
| 2020-05-22 09:10:00 | AAPL | Stock | 79.125 | 79.125 | 79.0 | 79.05 | 22712.0 |
> showing 50 of 394,935 rows — these rows as CSV