PREVIEW / stock_5min / 2020-04-06
file: by_date/stock_5min/2020/2020-04-06.parquet size: 6.4 MB rows: 404,041 symbols: 2,441
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-06 04:00:00 | AAPL | Stock | 62.9025 | 63.0275 | 62.75 | 62.75 | 25552.0 |
| 2020-04-06 04:05:00 | AAPL | Stock | 62.6925 | 62.7175 | 62.6325 | 62.6925 | 8424.0 |
| 2020-04-06 04:10:00 | AAPL | Stock | 62.6375 | 62.7 | 62.6025 | 62.61 | 12204.0 |
| 2020-04-06 04:15:00 | AAPL | Stock | 62.55 | 62.6075 | 62.5125 | 62.6075 | 4756.0 |
| 2020-04-06 04:20:00 | AAPL | Stock | 62.615 | 62.65 | 62.615 | 62.6375 | 2800.0 |
| 2020-04-06 04:25:00 | AAPL | Stock | 62.65 | 62.775 | 62.6 | 62.75 | 11600.0 |
| 2020-04-06 04:30:00 | AAPL | Stock | 62.85 | 62.85 | 62.5775 | 62.5775 | 4900.0 |
| 2020-04-06 04:35:00 | AAPL | Stock | 62.5625 | 62.575 | 62.4875 | 62.575 | 7500.0 |
| 2020-04-06 04:40:00 | AAPL | Stock | 62.6 | 62.79 | 62.6 | 62.7875 | 3904.0 |
| 2020-04-06 04:45:00 | AAPL | Stock | 62.8 | 62.85 | 62.6375 | 62.6375 | 8196.0 |
| 2020-04-06 04:50:00 | AAPL | Stock | 62.74 | 62.8875 | 62.74 | 62.75 | 23808.0 |
| 2020-04-06 04:55:00 | AAPL | Stock | 62.775 | 62.8675 | 62.75 | 62.8675 | 3072.0 |
| 2020-04-06 05:00:00 | AAPL | Stock | 62.8 | 62.8475 | 62.75 | 62.8475 | 4788.0 |
| 2020-04-06 05:05:00 | AAPL | Stock | 62.75 | 62.75 | 62.5525 | 62.5525 | 7696.0 |
| 2020-04-06 05:10:00 | AAPL | Stock | 62.625 | 62.7175 | 62.625 | 62.7175 | 2184.0 |
| 2020-04-06 05:15:00 | AAPL | Stock | 62.7175 | 62.74 | 62.7175 | 62.7375 | 3824.0 |
| 2020-04-06 05:20:00 | AAPL | Stock | 62.7325 | 62.8075 | 62.7325 | 62.8075 | 800.0 |
| 2020-04-06 05:25:00 | AAPL | Stock | 62.75 | 63.0 | 62.75 | 63.0 | 14088.0 |
| 2020-04-06 05:30:00 | AAPL | Stock | 62.985 | 63.0 | 62.9375 | 63.0 | 6116.0 |
| 2020-04-06 05:40:00 | AAPL | Stock | 62.9475 | 63.175 | 62.9475 | 63.175 | 13016.0 |
| 2020-04-06 05:45:00 | AAPL | Stock | 63.0375 | 63.0375 | 62.9825 | 62.9825 | 7784.0 |
| 2020-04-06 05:50:00 | AAPL | Stock | 62.9825 | 62.9825 | 62.9525 | 62.9525 | 5452.0 |
| 2020-04-06 05:55:00 | AAPL | Stock | 62.9375 | 62.9675 | 62.9 | 62.9675 | 4800.0 |
| 2020-04-06 06:00:00 | AAPL | Stock | 62.915 | 62.9425 | 62.88 | 62.9425 | 2400.0 |
| 2020-04-06 06:05:00 | AAPL | Stock | 62.915 | 62.915 | 62.9125 | 62.915 | 2000.0 |
| 2020-04-06 06:10:00 | AAPL | Stock | 62.8825 | 62.8825 | 62.75 | 62.75 | 3152.0 |
| 2020-04-06 06:15:00 | AAPL | Stock | 62.8625 | 62.93 | 62.8 | 62.925 | 3496.0 |
| 2020-04-06 06:20:00 | AAPL | Stock | 62.825 | 62.825 | 62.8225 | 62.8225 | 1700.0 |
| 2020-04-06 06:25:00 | AAPL | Stock | 62.9225 | 62.995 | 62.79 | 62.8125 | 4100.0 |
| 2020-04-06 06:30:00 | AAPL | Stock | 62.8125 | 62.8125 | 62.8125 | 62.8125 | 1424.0 |
| 2020-04-06 06:35:00 | AAPL | Stock | 62.8 | 62.87 | 62.8 | 62.825 | 2888.0 |
| 2020-04-06 06:40:00 | AAPL | Stock | 62.795 | 62.815 | 62.795 | 62.8125 | 2564.0 |
| 2020-04-06 06:45:00 | AAPL | Stock | 62.845 | 62.845 | 62.84 | 62.84 | 1956.0 |
| 2020-04-06 06:50:00 | AAPL | Stock | 62.825 | 62.825 | 62.8 | 62.8 | 2020.0 |
| 2020-04-06 06:55:00 | AAPL | Stock | 62.82 | 62.8625 | 62.795 | 62.8475 | 4884.0 |
| 2020-04-06 07:00:00 | AAPL | Stock | 62.795 | 62.875 | 62.55 | 62.5625 | 188176.0 |
| 2020-04-06 07:05:00 | AAPL | Stock | 62.55 | 62.575 | 62.4575 | 62.55 | 146972.0 |
| 2020-04-06 07:10:00 | AAPL | Stock | 62.6025 | 62.6375 | 62.575 | 62.6125 | 23848.0 |
| 2020-04-06 07:15:00 | AAPL | Stock | 62.5875 | 62.625 | 62.425 | 62.425 | 55248.0 |
| 2020-04-06 07:20:00 | AAPL | Stock | 62.375 | 62.585 | 62.375 | 62.5725 | 16528.0 |
| 2020-04-06 07:25:00 | AAPL | Stock | 62.6025 | 62.655 | 62.5375 | 62.5775 | 53988.0 |
| 2020-04-06 07:30:00 | AAPL | Stock | 62.565 | 62.5925 | 62.445 | 62.5 | 55464.0 |
| 2020-04-06 07:35:00 | AAPL | Stock | 62.45 | 62.58 | 62.4125 | 62.4825 | 101956.0 |
| 2020-04-06 07:40:00 | AAPL | Stock | 62.4725 | 62.56 | 62.455 | 62.455 | 66668.0 |
| 2020-04-06 07:45:00 | AAPL | Stock | 62.4875 | 62.5475 | 62.4375 | 62.5325 | 33840.0 |
| 2020-04-06 07:50:00 | AAPL | Stock | 62.48 | 62.485 | 62.435 | 62.485 | 48112.0 |
| 2020-04-06 07:55:00 | AAPL | Stock | 62.445 | 62.52 | 62.375 | 62.4675 | 45684.0 |
| 2020-04-06 08:00:00 | AAPL | Stock | 62.5 | 62.825 | 62.35 | 62.368 | 297268.0 |
| 2020-04-06 08:05:00 | AAPL | Stock | 62.335 | 62.375 | 62.271 | 62.35 | 51112.0 |
| 2020-04-06 08:10:00 | AAPL | Stock | 62.3678 | 62.46 | 62.3025 | 62.3755 | 23376.0 |
> showing 50 of 404,041 rows — these rows as CSV