PREVIEW / stock_5min / 2020-08-04
file: by_date/stock_5min/2020/2020-08-04.parquet size: 6.6 MB rows: 413,278 symbols: 2,434
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-04 04:00:00 | AAPL | Stock | 108.805 | 108.805 | 108.79 | 108.79 | 6820.0 |
| 2020-08-04 04:05:00 | AAPL | Stock | 108.625 | 108.625 | 108.405 | 108.405 | 4680.0 |
| 2020-08-04 04:10:00 | AAPL | Stock | 108.325 | 108.475 | 108.29 | 108.475 | 5896.0 |
| 2020-08-04 04:20:00 | AAPL | Stock | 108.445 | 108.5 | 108.445 | 108.5 | 1200.0 |
| 2020-08-04 04:25:00 | AAPL | Stock | 108.54 | 108.55 | 108.54 | 108.55 | 800.0 |
| 2020-08-04 04:30:00 | AAPL | Stock | 108.555 | 108.555 | 108.5 | 108.5 | 2244.0 |
| 2020-08-04 04:35:00 | AAPL | Stock | 108.4425 | 108.575 | 108.4425 | 108.5 | 2596.0 |
| 2020-08-04 04:40:00 | AAPL | Stock | 108.545 | 108.545 | 108.545 | 108.545 | 2400.0 |
| 2020-08-04 04:45:00 | AAPL | Stock | 108.505 | 108.505 | 108.505 | 108.505 | 800.0 |
| 2020-08-04 04:50:00 | AAPL | Stock | 108.42 | 108.4275 | 108.42 | 108.4275 | 940.0 |
| 2020-08-04 05:05:00 | AAPL | Stock | 108.625 | 108.8675 | 108.625 | 108.7825 | 9356.0 |
| 2020-08-04 05:15:00 | AAPL | Stock | 108.7825 | 108.7825 | 108.7475 | 108.7475 | 1904.0 |
| 2020-08-04 05:25:00 | AAPL | Stock | 108.7 | 108.7 | 108.7 | 108.7 | 548.0 |
| 2020-08-04 05:35:00 | AAPL | Stock | 108.675 | 108.6825 | 108.675 | 108.6825 | 800.0 |
| 2020-08-04 05:40:00 | AAPL | Stock | 108.7 | 108.7075 | 108.7 | 108.7 | 2000.0 |
| 2020-08-04 05:45:00 | AAPL | Stock | 108.8125 | 108.8125 | 108.8125 | 108.8125 | 496.0 |
| 2020-08-04 06:00:00 | AAPL | Stock | 108.785 | 108.785 | 108.785 | 108.785 | 860.0 |
| 2020-08-04 06:10:00 | AAPL | Stock | 108.78 | 108.78 | 108.78 | 108.78 | 500.0 |
| 2020-08-04 06:20:00 | AAPL | Stock | 108.7275 | 108.7925 | 108.7275 | 108.7925 | 800.0 |
| 2020-08-04 06:35:00 | AAPL | Stock | 108.75 | 108.75 | 108.7475 | 108.75 | 3828.0 |
| 2020-08-04 06:40:00 | AAPL | Stock | 108.7525 | 108.7525 | 108.7525 | 108.7525 | 504.0 |
| 2020-08-04 06:45:00 | AAPL | Stock | 108.75 | 108.85 | 108.75 | 108.85 | 2676.0 |
| 2020-08-04 06:50:00 | AAPL | Stock | 108.76 | 108.76 | 108.75 | 108.75 | 1992.0 |
| 2020-08-04 06:55:00 | AAPL | Stock | 108.75 | 108.75 | 108.75 | 108.75 | 800.0 |
| 2020-08-04 07:00:00 | AAPL | Stock | 108.75 | 109.145 | 108.735 | 109.1075 | 52640.0 |
| 2020-08-04 07:05:00 | AAPL | Stock | 109.0675 | 109.25 | 109.0675 | 109.25 | 29124.0 |
| 2020-08-04 07:10:00 | AAPL | Stock | 109.275 | 109.33 | 109.1875 | 109.1875 | 49144.0 |
| 2020-08-04 07:15:00 | AAPL | Stock | 109.125 | 109.155 | 108.865 | 108.865 | 23012.0 |
| 2020-08-04 07:20:00 | AAPL | Stock | 108.9 | 109.0875 | 108.9 | 109.0875 | 18300.0 |
| 2020-08-04 07:25:00 | AAPL | Stock | 109.075 | 109.1125 | 108.975 | 109.025 | 20716.0 |
| 2020-08-04 07:30:00 | AAPL | Stock | 109.04 | 109.0575 | 108.835 | 108.8625 | 47252.0 |
| 2020-08-04 07:35:00 | AAPL | Stock | 108.8675 | 108.875 | 108.75 | 108.755 | 26896.0 |
| 2020-08-04 07:40:00 | AAPL | Stock | 108.76 | 108.8375 | 108.76 | 108.765 | 20244.0 |
| 2020-08-04 07:45:00 | AAPL | Stock | 108.77 | 108.815 | 108.65 | 108.6875 | 12960.0 |
| 2020-08-04 07:50:00 | AAPL | Stock | 108.675 | 108.725 | 108.575 | 108.725 | 20376.0 |
| 2020-08-04 07:55:00 | AAPL | Stock | 108.72 | 108.7225 | 108.65 | 108.67 | 6696.0 |
| 2020-08-04 08:00:00 | AAPL | Stock | 109.0882 | 109.33 | 108.5 | 108.58 | 238972.0 |
| 2020-08-04 08:05:00 | AAPL | Stock | 108.59 | 108.7125 | 108.575 | 108.7125 | 17232.0 |
| 2020-08-04 08:10:00 | AAPL | Stock | 108.685 | 108.845 | 108.663 | 108.7875 | 40980.0 |
| 2020-08-04 08:15:00 | AAPL | Stock | 108.8 | 108.8125 | 108.7525 | 108.7875 | 13664.0 |
| 2020-08-04 08:20:00 | AAPL | Stock | 108.79 | 108.9375 | 108.7775 | 108.875 | 66944.0 |
| 2020-08-04 08:25:00 | AAPL | Stock | 108.88 | 108.88 | 108.805 | 108.8425 | 20328.0 |
| 2020-08-04 08:30:00 | AAPL | Stock | 108.8625 | 108.8725 | 108.7288 | 108.75 | 133704.0 |
| 2020-08-04 08:35:00 | AAPL | Stock | 108.75 | 108.8125 | 108.5625 | 108.7 | 60264.0 |
| 2020-08-04 08:40:00 | AAPL | Stock | 108.7225 | 108.75 | 108.575 | 108.6295 | 57444.0 |
| 2020-08-04 08:45:00 | AAPL | Stock | 108.6575 | 108.805 | 108.6505 | 108.805 | 40060.0 |
| 2020-08-04 08:50:00 | AAPL | Stock | 108.8 | 108.975 | 108.7 | 108.83 | 137324.0 |
| 2020-08-04 08:55:00 | AAPL | Stock | 108.8775 | 109.25 | 108.83 | 109.1325 | 184220.0 |
| 2020-08-04 09:00:00 | AAPL | Stock | 109.1578 | 109.4375 | 109.0 | 109.4375 | 113644.0 |
| 2020-08-04 09:05:00 | AAPL | Stock | 109.4225 | 109.475 | 109.1775 | 109.2025 | 120068.0 |
> showing 50 of 413,278 rows — these rows as CSV