PREVIEW / stock_5min / 2020-04-02
file: by_date/stock_5min/2020/2020-04-02.parquet size: 6.3 MB rows: 400,773 symbols: 2,408
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-02 04:00:00 | AAPL | Stock | 61.1525 | 61.3725 | 61.1 | 61.3725 | 5504.0 |
| 2020-04-02 04:05:00 | AAPL | Stock | 61.5 | 61.5 | 61.4975 | 61.4975 | 1656.0 |
| 2020-04-02 04:10:00 | AAPL | Stock | 61.4025 | 61.465 | 61.4025 | 61.4475 | 2400.0 |
| 2020-04-02 04:15:00 | AAPL | Stock | 61.45 | 61.5025 | 61.45 | 61.5025 | 13748.0 |
| 2020-04-02 04:25:00 | AAPL | Stock | 61.55 | 61.55 | 61.55 | 61.55 | 800.0 |
| 2020-04-02 04:30:00 | AAPL | Stock | 61.5075 | 61.5075 | 61.425 | 61.425 | 1880.0 |
| 2020-04-02 04:40:00 | AAPL | Stock | 61.375 | 61.375 | 61.375 | 61.375 | 1200.0 |
| 2020-04-02 04:45:00 | AAPL | Stock | 61.3375 | 61.3375 | 61.3375 | 61.3375 | 400.0 |
| 2020-04-02 04:50:00 | AAPL | Stock | 61.3125 | 61.3575 | 61.25 | 61.3575 | 4160.0 |
| 2020-04-02 04:55:00 | AAPL | Stock | 61.35 | 61.355 | 61.35 | 61.355 | 800.0 |
| 2020-04-02 05:00:00 | AAPL | Stock | 61.355 | 61.3825 | 61.25 | 61.25 | 8864.0 |
| 2020-04-02 05:05:00 | AAPL | Stock | 61.25 | 61.25 | 61.2375 | 61.2375 | 1308.0 |
| 2020-04-02 05:10:00 | AAPL | Stock | 61.25 | 61.2575 | 61.25 | 61.2575 | 800.0 |
| 2020-04-02 05:15:00 | AAPL | Stock | 61.2425 | 61.25 | 61.2425 | 61.25 | 856.0 |
| 2020-04-02 05:20:00 | AAPL | Stock | 61.3575 | 61.375 | 61.3575 | 61.375 | 1012.0 |
| 2020-04-02 05:35:00 | AAPL | Stock | 61.2625 | 61.2625 | 61.25 | 61.25 | 2200.0 |
| 2020-04-02 05:45:00 | AAPL | Stock | 60.8575 | 60.99 | 60.8 | 60.99 | 1600.0 |
| 2020-04-02 05:55:00 | AAPL | Stock | 60.93 | 60.93 | 60.8775 | 60.8775 | 3800.0 |
| 2020-04-02 06:00:00 | AAPL | Stock | 60.9225 | 60.9225 | 60.8 | 60.8275 | 5396.0 |
| 2020-04-02 06:10:00 | AAPL | Stock | 61.035 | 61.0625 | 61.035 | 61.0625 | 800.0 |
| 2020-04-02 06:15:00 | AAPL | Stock | 61.0625 | 61.0625 | 61.0625 | 61.0625 | 1200.0 |
| 2020-04-02 06:20:00 | AAPL | Stock | 61.125 | 61.125 | 61.065 | 61.065 | 1636.0 |
| 2020-04-02 06:25:00 | AAPL | Stock | 61.035 | 61.125 | 61.035 | 61.0775 | 7200.0 |
| 2020-04-02 06:30:00 | AAPL | Stock | 61.0625 | 61.1 | 61.0625 | 61.0625 | 4292.0 |
| 2020-04-02 06:35:00 | AAPL | Stock | 61.0625 | 61.0725 | 61.0625 | 61.065 | 1840.0 |
| 2020-04-02 06:40:00 | AAPL | Stock | 61.125 | 61.125 | 61.125 | 61.125 | 880.0 |
| 2020-04-02 06:45:00 | AAPL | Stock | 61.125 | 61.3 | 61.0875 | 61.0875 | 10864.0 |
| 2020-04-02 06:50:00 | AAPL | Stock | 61.18 | 61.1825 | 61.055 | 61.0625 | 10804.0 |
| 2020-04-02 06:55:00 | AAPL | Stock | 61.0625 | 61.125 | 61.0625 | 61.125 | 3208.0 |
| 2020-04-02 07:00:00 | AAPL | Stock | 61.17 | 61.2 | 60.8875 | 60.8875 | 47328.0 |
| 2020-04-02 07:05:00 | AAPL | Stock | 60.8975 | 60.9575 | 60.825 | 60.8275 | 22520.0 |
| 2020-04-02 07:10:00 | AAPL | Stock | 60.85 | 61.0 | 60.8275 | 60.9625 | 32572.0 |
| 2020-04-02 07:15:00 | AAPL | Stock | 60.9575 | 61.215 | 60.9475 | 61.175 | 45816.0 |
| 2020-04-02 07:20:00 | AAPL | Stock | 61.17 | 61.225 | 61.0525 | 61.125 | 49612.0 |
| 2020-04-02 07:25:00 | AAPL | Stock | 61.15 | 61.185 | 61.0525 | 61.09 | 27364.0 |
| 2020-04-02 07:30:00 | AAPL | Stock | 61.08 | 61.1475 | 61.0375 | 61.1425 | 43528.0 |
| 2020-04-02 07:35:00 | AAPL | Stock | 61.15 | 61.15 | 61.075 | 61.125 | 23488.0 |
| 2020-04-02 07:40:00 | AAPL | Stock | 61.125 | 61.125 | 61.0375 | 61.075 | 35932.0 |
| 2020-04-02 07:45:00 | AAPL | Stock | 61.0625 | 61.175 | 61.0625 | 61.145 | 12724.0 |
| 2020-04-02 07:50:00 | AAPL | Stock | 61.165 | 61.2475 | 61.165 | 61.225 | 27848.0 |
| 2020-04-02 07:55:00 | AAPL | Stock | 61.1725 | 61.28 | 61.1725 | 61.28 | 43304.0 |
| 2020-04-02 08:00:00 | AAPL | Stock | 61.25 | 61.3175 | 60.825 | 61.2875 | 171408.0 |
| 2020-04-02 08:05:00 | AAPL | Stock | 61.2875 | 61.3 | 61.2 | 61.2125 | 34316.0 |
| 2020-04-02 08:10:00 | AAPL | Stock | 61.225 | 61.225 | 61.15 | 61.1875 | 20208.0 |
| 2020-04-02 08:15:00 | AAPL | Stock | 61.175 | 61.2 | 61.0375 | 61.055 | 79732.0 |
| 2020-04-02 08:20:00 | AAPL | Stock | 61.0625 | 61.175 | 61.055 | 61.055 | 26668.0 |
| 2020-04-02 08:25:00 | AAPL | Stock | 61.055 | 61.125 | 61.03 | 61.0925 | 22792.0 |
| 2020-04-02 08:30:00 | AAPL | Stock | 61.0575 | 61.1875 | 60.7875 | 60.7875 | 103024.0 |
| 2020-04-02 08:35:00 | AAPL | Stock | 60.78 | 60.78 | 60.45 | 60.55 | 163296.0 |
| 2020-04-02 08:40:00 | AAPL | Stock | 60.5125 | 60.62 | 60.05 | 60.4375 | 159816.0 |
> showing 50 of 400,773 rows — these rows as CSV