PREVIEW / stock_5min / 2020-08-06
file: by_date/stock_5min/2020/2020-08-06.parquet size: 6.6 MB rows: 416,173 symbols: 2,419
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-08-06 04:00:00 | AAPL | Stock | 110.05 | 110.05 | 110.05 | 110.05 | 612.0 |
| 2020-08-06 04:05:00 | AAPL | Stock | 109.8025 | 109.8025 | 109.8025 | 109.8025 | 800.0 |
| 2020-08-06 04:10:00 | AAPL | Stock | 109.7825 | 109.7825 | 109.7825 | 109.7825 | 400.0 |
| 2020-08-06 04:15:00 | AAPL | Stock | 109.7925 | 109.7925 | 109.7825 | 109.7825 | 2300.0 |
| 2020-08-06 04:20:00 | AAPL | Stock | 109.8725 | 109.92 | 109.8725 | 109.92 | 1612.0 |
| 2020-08-06 04:25:00 | AAPL | Stock | 109.9225 | 109.9225 | 109.9 | 109.9 | 1668.0 |
| 2020-08-06 04:40:00 | AAPL | Stock | 109.8275 | 109.8275 | 109.815 | 109.815 | 804.0 |
| 2020-08-06 04:50:00 | AAPL | Stock | 109.875 | 109.875 | 109.875 | 109.875 | 2800.0 |
| 2020-08-06 05:10:00 | AAPL | Stock | 109.85 | 109.85 | 109.825 | 109.85 | 4800.0 |
| 2020-08-06 05:15:00 | AAPL | Stock | 109.85 | 109.8525 | 109.85 | 109.8525 | 2112.0 |
| 2020-08-06 05:20:00 | AAPL | Stock | 109.825 | 109.825 | 109.825 | 109.825 | 800.0 |
| 2020-08-06 05:30:00 | AAPL | Stock | 109.8525 | 109.8525 | 109.8525 | 109.8525 | 800.0 |
| 2020-08-06 05:35:00 | AAPL | Stock | 109.85 | 109.8875 | 109.85 | 109.8875 | 4196.0 |
| 2020-08-06 05:40:00 | AAPL | Stock | 109.8875 | 109.8875 | 109.8875 | 109.8875 | 800.0 |
| 2020-08-06 05:45:00 | AAPL | Stock | 109.8525 | 109.8525 | 109.8325 | 109.8325 | 2000.0 |
| 2020-08-06 05:50:00 | AAPL | Stock | 109.89 | 109.9275 | 109.8875 | 109.9275 | 5064.0 |
| 2020-08-06 05:55:00 | AAPL | Stock | 109.95 | 109.95 | 109.95 | 109.95 | 400.0 |
| 2020-08-06 06:00:00 | AAPL | Stock | 109.9975 | 109.9975 | 109.9975 | 109.9975 | 940.0 |
| 2020-08-06 06:15:00 | AAPL | Stock | 109.8925 | 109.8925 | 109.7 | 109.7 | 2220.0 |
| 2020-08-06 06:20:00 | AAPL | Stock | 109.78 | 109.78 | 109.7525 | 109.7525 | 2712.0 |
| 2020-08-06 06:30:00 | AAPL | Stock | 109.69 | 109.7275 | 109.69 | 109.7275 | 800.0 |
| 2020-08-06 06:35:00 | AAPL | Stock | 109.695 | 109.72 | 109.6925 | 109.6925 | 7920.0 |
| 2020-08-06 06:40:00 | AAPL | Stock | 109.6925 | 109.6925 | 109.65 | 109.65 | 4472.0 |
| 2020-08-06 06:45:00 | AAPL | Stock | 109.6925 | 109.6925 | 109.6925 | 109.6925 | 848.0 |
| 2020-08-06 06:50:00 | AAPL | Stock | 109.65 | 109.65 | 109.6 | 109.6 | 4000.0 |
| 2020-08-06 06:55:00 | AAPL | Stock | 109.605 | 109.65 | 109.6025 | 109.65 | 2400.0 |
| 2020-08-06 07:00:00 | AAPL | Stock | 109.7 | 109.85 | 109.58 | 109.76 | 46256.0 |
| 2020-08-06 07:05:00 | AAPL | Stock | 109.78 | 109.825 | 109.73 | 109.825 | 17156.0 |
| 2020-08-06 07:10:00 | AAPL | Stock | 109.8275 | 109.8275 | 109.79 | 109.825 | 13672.0 |
| 2020-08-06 07:15:00 | AAPL | Stock | 109.8275 | 109.8325 | 109.79 | 109.8325 | 6684.0 |
| 2020-08-06 07:20:00 | AAPL | Stock | 109.8125 | 109.825 | 109.8125 | 109.825 | 5524.0 |
| 2020-08-06 07:25:00 | AAPL | Stock | 109.75 | 109.8175 | 109.75 | 109.8175 | 6836.0 |
| 2020-08-06 07:30:00 | AAPL | Stock | 109.85 | 109.875 | 109.8375 | 109.8475 | 9800.0 |
| 2020-08-06 07:35:00 | AAPL | Stock | 109.82 | 109.825 | 109.8 | 109.8225 | 12320.0 |
| 2020-08-06 07:40:00 | AAPL | Stock | 109.8225 | 109.825 | 109.75 | 109.7525 | 6800.0 |
| 2020-08-06 07:45:00 | AAPL | Stock | 109.7525 | 109.7825 | 109.655 | 109.69 | 16828.0 |
| 2020-08-06 07:50:00 | AAPL | Stock | 109.6575 | 109.7375 | 109.65 | 109.705 | 22192.0 |
| 2020-08-06 07:55:00 | AAPL | Stock | 109.68 | 109.8475 | 109.6775 | 109.8475 | 6300.0 |
| 2020-08-06 08:00:00 | AAPL | Stock | 109.843 | 109.875 | 109.648 | 109.775 | 67996.0 |
| 2020-08-06 08:05:00 | AAPL | Stock | 109.725 | 109.725 | 109.625 | 109.625 | 62176.0 |
| 2020-08-06 08:10:00 | AAPL | Stock | 109.675 | 109.77 | 109.675 | 109.755 | 23956.0 |
| 2020-08-06 08:15:00 | AAPL | Stock | 109.725 | 109.7782 | 109.725 | 109.7552 | 8816.0 |
| 2020-08-06 08:20:00 | AAPL | Stock | 109.7775 | 109.7925 | 109.75 | 109.7875 | 19192.0 |
| 2020-08-06 08:25:00 | AAPL | Stock | 109.795 | 109.8325 | 109.725 | 109.8325 | 28824.0 |
| 2020-08-06 08:30:00 | AAPL | Stock | 109.855 | 110.225 | 109.845 | 110.1875 | 162116.0 |
| 2020-08-06 08:35:00 | AAPL | Stock | 110.175 | 110.2675 | 110.15 | 110.25 | 146084.0 |
| 2020-08-06 08:40:00 | AAPL | Stock | 110.2625 | 110.3625 | 110.175 | 110.3625 | 100864.0 |
| 2020-08-06 08:45:00 | AAPL | Stock | 110.3425 | 110.4212 | 110.3125 | 110.3625 | 86800.0 |
| 2020-08-06 08:50:00 | AAPL | Stock | 110.3625 | 110.395 | 110.355 | 110.39 | 71672.0 |
| 2020-08-06 08:55:00 | AAPL | Stock | 110.39 | 110.39 | 110.2975 | 110.355 | 60332.0 |
> showing 50 of 416,173 rows — these rows as CSV