PREVIEW / stock_5min / 2020-02-06
file: by_date/stock_5min/2020/2020-02-06.parquet size: 5.9 MB rows: 364,441 symbols: 2,416
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-02-06 04:00:00 | AAPL | Stock | 80.775 | 81.0 | 80.775 | 81.0 | 9696.0 |
| 2020-02-06 04:05:00 | AAPL | Stock | 81.02 | 81.075 | 81.02 | 81.075 | 4356.0 |
| 2020-02-06 04:10:00 | AAPL | Stock | 81.0925 | 81.095 | 81.065 | 81.065 | 8328.0 |
| 2020-02-06 04:20:00 | AAPL | Stock | 80.9 | 80.9 | 80.875 | 80.88 | 4572.0 |
| 2020-02-06 04:25:00 | AAPL | Stock | 80.81 | 80.81 | 80.8 | 80.8 | 1872.0 |
| 2020-02-06 04:30:00 | AAPL | Stock | 80.85 | 80.86 | 80.85 | 80.86 | 2760.0 |
| 2020-02-06 04:35:00 | AAPL | Stock | 80.8375 | 80.8375 | 80.825 | 80.825 | 800.0 |
| 2020-02-06 04:40:00 | AAPL | Stock | 80.8 | 80.8 | 80.6975 | 80.6975 | 6400.0 |
| 2020-02-06 05:10:00 | AAPL | Stock | 80.675 | 80.75 | 80.675 | 80.75 | 2156.0 |
| 2020-02-06 05:15:00 | AAPL | Stock | 80.7475 | 80.75 | 80.7475 | 80.75 | 1536.0 |
| 2020-02-06 05:20:00 | AAPL | Stock | 80.68 | 80.68 | 80.68 | 80.68 | 1600.0 |
| 2020-02-06 05:25:00 | AAPL | Stock | 80.745 | 80.775 | 80.745 | 80.775 | 2000.0 |
| 2020-02-06 05:30:00 | AAPL | Stock | 80.745 | 80.745 | 80.745 | 80.745 | 692.0 |
| 2020-02-06 05:45:00 | AAPL | Stock | 80.705 | 80.705 | 80.6875 | 80.6875 | 1600.0 |
| 2020-02-06 05:55:00 | AAPL | Stock | 80.7625 | 80.7625 | 80.7625 | 80.7625 | 1548.0 |
| 2020-02-06 06:30:00 | AAPL | Stock | 80.75 | 80.7675 | 80.75 | 80.7675 | 8932.0 |
| 2020-02-06 06:40:00 | AAPL | Stock | 80.8 | 80.8175 | 80.75 | 80.8175 | 14164.0 |
| 2020-02-06 06:45:00 | AAPL | Stock | 80.8175 | 80.845 | 80.8 | 80.845 | 4560.0 |
| 2020-02-06 06:55:00 | AAPL | Stock | 80.825 | 80.875 | 80.825 | 80.875 | 6796.0 |
| 2020-02-06 07:00:00 | AAPL | Stock | 80.845 | 80.9925 | 80.845 | 80.9 | 46764.0 |
| 2020-02-06 07:05:00 | AAPL | Stock | 80.9 | 80.975 | 80.9 | 80.9 | 17080.0 |
| 2020-02-06 07:10:00 | AAPL | Stock | 80.8775 | 80.9125 | 80.8775 | 80.9 | 5760.0 |
| 2020-02-06 07:15:00 | AAPL | Stock | 80.9 | 80.9 | 80.8625 | 80.8625 | 3832.0 |
| 2020-02-06 07:20:00 | AAPL | Stock | 80.825 | 80.86 | 80.825 | 80.86 | 6496.0 |
| 2020-02-06 07:25:00 | AAPL | Stock | 80.8475 | 80.8475 | 80.8 | 80.81 | 2644.0 |
| 2020-02-06 07:30:00 | AAPL | Stock | 80.79 | 80.8475 | 80.79 | 80.8475 | 17464.0 |
| 2020-02-06 07:35:00 | AAPL | Stock | 80.8575 | 80.86 | 80.855 | 80.855 | 5884.0 |
| 2020-02-06 07:40:00 | AAPL | Stock | 80.855 | 80.875 | 80.855 | 80.855 | 18576.0 |
| 2020-02-06 07:45:00 | AAPL | Stock | 80.84 | 80.8525 | 80.84 | 80.8525 | 800.0 |
| 2020-02-06 07:50:00 | AAPL | Stock | 80.8125 | 80.8125 | 80.7525 | 80.775 | 17604.0 |
| 2020-02-06 07:55:00 | AAPL | Stock | 80.755 | 80.755 | 80.72 | 80.75 | 14804.0 |
| 2020-02-06 08:00:00 | AAPL | Stock | 80.925 | 80.9825 | 80.6835 | 80.725 | 236556.0 |
| 2020-02-06 08:05:00 | AAPL | Stock | 80.7175 | 80.75 | 80.68 | 80.75 | 18824.0 |
| 2020-02-06 08:10:00 | AAPL | Stock | 80.75 | 80.85 | 80.75 | 80.85 | 25336.0 |
| 2020-02-06 08:15:00 | AAPL | Stock | 80.7725 | 80.85 | 80.7475 | 80.8475 | 62664.0 |
| 2020-02-06 08:20:00 | AAPL | Stock | 80.8525 | 80.875 | 80.8 | 80.8125 | 66452.0 |
| 2020-02-06 08:25:00 | AAPL | Stock | 80.78 | 80.7875 | 80.7642 | 80.7825 | 12556.0 |
| 2020-02-06 08:30:00 | AAPL | Stock | 80.7875 | 80.87 | 80.7875 | 80.8 | 14892.0 |
| 2020-02-06 08:35:00 | AAPL | Stock | 80.8125 | 80.8225 | 80.7825 | 80.8125 | 11200.0 |
| 2020-02-06 08:40:00 | AAPL | Stock | 80.825 | 80.825 | 80.7275 | 80.7275 | 38424.0 |
| 2020-02-06 08:45:00 | AAPL | Stock | 80.7425 | 80.75 | 80.6325 | 80.69 | 32296.0 |
| 2020-02-06 08:50:00 | AAPL | Stock | 80.6875 | 80.7025 | 80.6525 | 80.6875 | 25272.0 |
| 2020-02-06 08:55:00 | AAPL | Stock | 80.675 | 80.675 | 80.575 | 80.6695 | 24520.0 |
| 2020-02-06 09:00:00 | AAPL | Stock | 80.6625 | 80.6838 | 80.5838 | 80.675 | 19152.0 |
| 2020-02-06 09:05:00 | AAPL | Stock | 80.6675 | 80.7125 | 80.6125 | 80.65 | 36368.0 |
| 2020-02-06 09:10:00 | AAPL | Stock | 80.6325 | 80.74 | 80.6275 | 80.68 | 37092.0 |
| 2020-02-06 09:15:00 | AAPL | Stock | 80.7228 | 80.7228 | 80.625 | 80.63 | 11528.0 |
| 2020-02-06 09:20:00 | AAPL | Stock | 80.63 | 80.6375 | 80.6 | 80.6 | 18880.0 |
| 2020-02-06 09:25:00 | AAPL | Stock | 80.6 | 80.68 | 80.5975 | 80.6375 | 31372.0 |
| 2020-02-06 09:30:00 | AAPL | Stock | 80.6125 | 80.9225 | 80.3303 | 80.425 | 4051820.0 |
> showing 50 of 364,441 rows — these rows as CSV