PREVIEW / stock_5min / 2020-05-28
file: by_date/stock_5min/2020/2020-05-28.parquet size: 6.6 MB rows: 416,722 symbols: 2,387
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-28 04:15:00 | AAPL | Stock | 79.375 | 79.3925 | 79.3525 | 79.3525 | 4708.0 |
| 2020-05-28 04:25:00 | AAPL | Stock | 79.205 | 79.205 | 79.205 | 79.205 | 424.0 |
| 2020-05-28 04:30:00 | AAPL | Stock | 79.2125 | 79.2125 | 79.2125 | 79.2125 | 400.0 |
| 2020-05-28 04:35:00 | AAPL | Stock | 79.125 | 79.125 | 79.125 | 79.125 | 1600.0 |
| 2020-05-28 04:55:00 | AAPL | Stock | 79.125 | 79.125 | 79.125 | 79.125 | 400.0 |
| 2020-05-28 05:05:00 | AAPL | Stock | 79.25 | 79.275 | 79.25 | 79.275 | 1940.0 |
| 2020-05-28 05:25:00 | AAPL | Stock | 79.275 | 79.275 | 79.275 | 79.275 | 800.0 |
| 2020-05-28 05:35:00 | AAPL | Stock | 79.25 | 79.25 | 79.25 | 79.25 | 676.0 |
| 2020-05-28 05:45:00 | AAPL | Stock | 79.2125 | 79.2125 | 79.2125 | 79.2125 | 400.0 |
| 2020-05-28 05:50:00 | AAPL | Stock | 79.125 | 79.125 | 79.01 | 79.115 | 1892.0 |
| 2020-05-28 05:55:00 | AAPL | Stock | 79.095 | 79.095 | 79.0175 | 79.0175 | 800.0 |
| 2020-05-28 06:00:00 | AAPL | Stock | 79.095 | 79.095 | 79.095 | 79.095 | 400.0 |
| 2020-05-28 06:05:00 | AAPL | Stock | 79.095 | 79.095 | 79.095 | 79.095 | 400.0 |
| 2020-05-28 06:10:00 | AAPL | Stock | 79.15 | 79.1575 | 79.1025 | 79.1575 | 3312.0 |
| 2020-05-28 06:15:00 | AAPL | Stock | 79.0975 | 79.15 | 79.0975 | 79.1 | 3200.0 |
| 2020-05-28 06:20:00 | AAPL | Stock | 79.1 | 79.1 | 79.0975 | 79.1 | 1276.0 |
| 2020-05-28 06:25:00 | AAPL | Stock | 79.1975 | 79.2125 | 79.1975 | 79.2125 | 948.0 |
| 2020-05-28 06:30:00 | AAPL | Stock | 79.3375 | 79.3375 | 79.3375 | 79.3375 | 400.0 |
| 2020-05-28 06:40:00 | AAPL | Stock | 79.22 | 79.22 | 79.22 | 79.22 | 800.0 |
| 2020-05-28 06:45:00 | AAPL | Stock | 79.29 | 79.45 | 79.29 | 79.45 | 1400.0 |
| 2020-05-28 06:50:00 | AAPL | Stock | 79.405 | 79.405 | 79.405 | 79.405 | 800.0 |
| 2020-05-28 07:00:00 | AAPL | Stock | 79.405 | 79.42 | 79.225 | 79.225 | 17432.0 |
| 2020-05-28 07:05:00 | AAPL | Stock | 79.2325 | 79.3375 | 79.225 | 79.275 | 15404.0 |
| 2020-05-28 07:10:00 | AAPL | Stock | 79.2875 | 79.2875 | 79.2525 | 79.2525 | 1600.0 |
| 2020-05-28 07:15:00 | AAPL | Stock | 79.25 | 79.25 | 79.125 | 79.125 | 18220.0 |
| 2020-05-28 07:20:00 | AAPL | Stock | 79.1375 | 79.14 | 79.09 | 79.1 | 24932.0 |
| 2020-05-28 07:25:00 | AAPL | Stock | 79.1625 | 79.2075 | 79.11 | 79.205 | 10600.0 |
| 2020-05-28 07:30:00 | AAPL | Stock | 79.15 | 79.2375 | 79.15 | 79.235 | 7084.0 |
| 2020-05-28 07:35:00 | AAPL | Stock | 79.225 | 79.225 | 79.1625 | 79.1625 | 2400.0 |
| 2020-05-28 07:40:00 | AAPL | Stock | 79.165 | 79.2025 | 79.165 | 79.165 | 7216.0 |
| 2020-05-28 07:45:00 | AAPL | Stock | 79.2025 | 79.2025 | 79.125 | 79.125 | 13740.0 |
| 2020-05-28 07:50:00 | AAPL | Stock | 79.15 | 79.1725 | 79.15 | 79.1725 | 1112.0 |
| 2020-05-28 07:55:00 | AAPL | Stock | 79.15 | 79.15 | 79.025 | 79.025 | 75360.0 |
| 2020-05-28 08:00:00 | AAPL | Stock | 79.05 | 79.435 | 78.9925 | 79.025 | 127628.0 |
| 2020-05-28 08:05:00 | AAPL | Stock | 78.98 | 79.025 | 78.7875 | 78.9 | 19312.0 |
| 2020-05-28 08:10:00 | AAPL | Stock | 78.8375 | 78.9525 | 78.8375 | 78.95 | 29896.0 |
| 2020-05-28 08:15:00 | AAPL | Stock | 78.9175 | 78.9475 | 78.865 | 78.895 | 14124.0 |
| 2020-05-28 08:20:00 | AAPL | Stock | 78.875 | 78.8925 | 78.725 | 78.8025 | 81760.0 |
| 2020-05-28 08:25:00 | AAPL | Stock | 78.8275 | 78.8625 | 78.795 | 78.825 | 13568.0 |
| 2020-05-28 08:30:00 | AAPL | Stock | 78.8225 | 78.9375 | 78.69 | 78.9325 | 64720.0 |
| 2020-05-28 08:35:00 | AAPL | Stock | 78.9375 | 79.1 | 78.8475 | 78.855 | 22884.0 |
| 2020-05-28 08:40:00 | AAPL | Stock | 78.8775 | 78.9478 | 78.875 | 78.88 | 19444.0 |
| 2020-05-28 08:45:00 | AAPL | Stock | 78.855 | 78.855 | 78.75 | 78.7925 | 65748.0 |
| 2020-05-28 08:50:00 | AAPL | Stock | 78.825 | 78.8375 | 78.715 | 78.715 | 59880.0 |
| 2020-05-28 08:55:00 | AAPL | Stock | 78.715 | 78.835 | 78.625 | 78.815 | 38248.0 |
| 2020-05-28 09:00:00 | AAPL | Stock | 78.8575 | 78.95 | 78.8575 | 78.925 | 54096.0 |
| 2020-05-28 09:05:00 | AAPL | Stock | 78.925 | 78.995 | 78.8725 | 78.875 | 27956.0 |
| 2020-05-28 09:10:00 | AAPL | Stock | 78.8775 | 78.9125 | 78.8125 | 78.8825 | 22052.0 |
| 2020-05-28 09:15:00 | AAPL | Stock | 78.8975 | 79.0975 | 78.8975 | 79.0375 | 21372.0 |
| 2020-05-28 09:20:00 | AAPL | Stock | 79.015 | 79.0425 | 78.9775 | 79.005 | 12612.0 |
> showing 50 of 416,722 rows — these rows as CSV