PREVIEW / stock_5min / 2020-04-03
file: by_date/stock_5min/2020/2020-04-03.parquet size: 6.1 MB rows: 390,918 symbols: 2,395
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-03 04:00:00 | AAPL | Stock | 60.655 | 60.655 | 60.655 | 60.655 | 800.0 |
| 2020-04-03 04:05:00 | AAPL | Stock | 60.7075 | 60.825 | 60.7075 | 60.825 | 3160.0 |
| 2020-04-03 04:10:00 | AAPL | Stock | 60.825 | 60.825 | 60.825 | 60.825 | 416.0 |
| 2020-04-03 04:15:00 | AAPL | Stock | 60.7075 | 60.7075 | 60.7075 | 60.7075 | 1080.0 |
| 2020-04-03 04:25:00 | AAPL | Stock | 60.5025 | 60.5025 | 60.35 | 60.35 | 2676.0 |
| 2020-04-03 04:30:00 | AAPL | Stock | 60.5 | 60.5025 | 60.5 | 60.5025 | 800.0 |
| 2020-04-03 05:35:00 | AAPL | Stock | 60.4125 | 60.4125 | 60.4125 | 60.4125 | 868.0 |
| 2020-04-03 05:40:00 | AAPL | Stock | 60.375 | 60.375 | 60.375 | 60.375 | 400.0 |
| 2020-04-03 05:50:00 | AAPL | Stock | 60.4125 | 60.4125 | 60.4125 | 60.4125 | 1200.0 |
| 2020-04-03 05:55:00 | AAPL | Stock | 60.525 | 60.525 | 60.525 | 60.525 | 1200.0 |
| 2020-04-03 06:00:00 | AAPL | Stock | 60.5975 | 60.5975 | 60.5975 | 60.5975 | 500.0 |
| 2020-04-03 06:05:00 | AAPL | Stock | 60.5975 | 60.67 | 60.5975 | 60.67 | 4708.0 |
| 2020-04-03 06:10:00 | AAPL | Stock | 60.625 | 60.625 | 60.625 | 60.625 | 1084.0 |
| 2020-04-03 06:30:00 | AAPL | Stock | 60.5 | 60.515 | 60.5 | 60.515 | 2784.0 |
| 2020-04-03 06:35:00 | AAPL | Stock | 60.625 | 60.625 | 60.625 | 60.625 | 400.0 |
| 2020-04-03 06:50:00 | AAPL | Stock | 60.56 | 60.5725 | 60.545 | 60.5725 | 1360.0 |
| 2020-04-03 06:55:00 | AAPL | Stock | 60.605 | 60.605 | 60.605 | 60.605 | 544.0 |
| 2020-04-03 07:00:00 | AAPL | Stock | 60.5 | 60.72 | 60.5 | 60.72 | 26140.0 |
| 2020-04-03 07:05:00 | AAPL | Stock | 60.7625 | 60.815 | 60.685 | 60.685 | 17820.0 |
| 2020-04-03 07:10:00 | AAPL | Stock | 60.6375 | 60.6375 | 60.5825 | 60.5875 | 7548.0 |
| 2020-04-03 07:15:00 | AAPL | Stock | 60.6675 | 60.6925 | 60.59 | 60.625 | 19328.0 |
| 2020-04-03 07:20:00 | AAPL | Stock | 60.6525 | 60.685 | 60.625 | 60.6725 | 7784.0 |
| 2020-04-03 07:25:00 | AAPL | Stock | 60.695 | 60.695 | 60.6 | 60.625 | 11956.0 |
| 2020-04-03 07:30:00 | AAPL | Stock | 60.625 | 60.7225 | 60.625 | 60.7 | 9736.0 |
| 2020-04-03 07:35:00 | AAPL | Stock | 60.72 | 60.7575 | 60.7 | 60.7575 | 12728.0 |
| 2020-04-03 07:40:00 | AAPL | Stock | 60.8 | 60.8 | 60.7175 | 60.725 | 6348.0 |
| 2020-04-03 07:45:00 | AAPL | Stock | 60.795 | 61.0475 | 60.75 | 60.975 | 26716.0 |
| 2020-04-03 07:50:00 | AAPL | Stock | 60.94 | 61.07 | 60.875 | 61.07 | 31376.0 |
| 2020-04-03 07:55:00 | AAPL | Stock | 61.0025 | 61.45 | 61.0 | 61.3775 | 57720.0 |
| 2020-04-03 08:00:00 | AAPL | Stock | 60.7 | 61.45 | 60.575 | 61.325 | 72676.0 |
| 2020-04-03 08:05:00 | AAPL | Stock | 61.2475 | 61.2475 | 61.065 | 61.065 | 14492.0 |
| 2020-04-03 08:10:00 | AAPL | Stock | 61.0625 | 61.0725 | 60.825 | 60.895 | 21248.0 |
| 2020-04-03 08:15:00 | AAPL | Stock | 60.9375 | 61.1 | 60.9 | 60.9 | 23852.0 |
| 2020-04-03 08:20:00 | AAPL | Stock | 60.895 | 61.0375 | 60.8875 | 60.965 | 26108.0 |
| 2020-04-03 08:25:00 | AAPL | Stock | 60.965 | 60.965 | 60.7125 | 60.75 | 83196.0 |
| 2020-04-03 08:30:00 | AAPL | Stock | 60.75 | 61.1875 | 60.5 | 60.915 | 313752.0 |
| 2020-04-03 08:35:00 | AAPL | Stock | 61.0 | 61.025 | 60.775 | 60.975 | 157680.0 |
| 2020-04-03 08:40:00 | AAPL | Stock | 60.9025 | 61.06 | 60.7875 | 60.7925 | 45908.0 |
| 2020-04-03 08:45:00 | AAPL | Stock | 60.8 | 60.95 | 60.7925 | 60.9498 | 18064.0 |
| 2020-04-03 08:50:00 | AAPL | Stock | 60.84 | 60.925 | 60.7975 | 60.8725 | 11836.0 |
| 2020-04-03 08:55:00 | AAPL | Stock | 60.8975 | 60.8975 | 60.7625 | 60.8725 | 10308.0 |
| 2020-04-03 09:00:00 | AAPL | Stock | 60.8032 | 61.225 | 60.8032 | 61.135 | 68180.0 |
| 2020-04-03 09:05:00 | AAPL | Stock | 61.1128 | 61.175 | 60.9575 | 60.9575 | 58464.0 |
| 2020-04-03 09:10:00 | AAPL | Stock | 60.925 | 61.0 | 60.8775 | 60.975 | 22980.0 |
| 2020-04-03 09:15:00 | AAPL | Stock | 60.9625 | 60.9975 | 60.7875 | 60.79 | 38100.0 |
| 2020-04-03 09:20:00 | AAPL | Stock | 60.7925 | 61.0 | 60.7925 | 60.95 | 22368.0 |
| 2020-04-03 09:25:00 | AAPL | Stock | 60.9625 | 61.075 | 60.6025 | 60.7425 | 130172.0 |
| 2020-04-03 09:30:00 | AAPL | Stock | 60.725 | 61.0975 | 60.5625 | 61.0385 | 3481620.0 |
| 2020-04-03 09:35:00 | AAPL | Stock | 61.045 | 61.0808 | 60.825 | 61.0525 | 1516928.0 |
| 2020-04-03 09:40:00 | AAPL | Stock | 61.04 | 61.425 | 61.0268 | 61.18 | 2933668.0 |
> showing 50 of 390,918 rows — these rows as CSV