PREVIEW / stock_5min / 2020-03-24
file: by_date/stock_5min/2020/2020-03-24.parquet size: 6.7 MB rows: 424,881 symbols: 2,450
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-03-24 04:00:00 | AAPL | Stock | 58.255 | 58.75 | 58.0 | 58.7375 | 54420.0 |
| 2020-03-24 04:05:00 | AAPL | Stock | 58.7 | 58.8375 | 58.5525 | 58.7225 | 16404.0 |
| 2020-03-24 04:10:00 | AAPL | Stock | 58.55 | 58.7075 | 58.25 | 58.4475 | 17592.0 |
| 2020-03-24 04:15:00 | AAPL | Stock | 58.3925 | 58.525 | 58.3925 | 58.4375 | 12420.0 |
| 2020-03-24 04:20:00 | AAPL | Stock | 58.425 | 58.425 | 58.065 | 58.065 | 9108.0 |
| 2020-03-24 04:25:00 | AAPL | Stock | 58.1075 | 58.2125 | 58.025 | 58.075 | 10836.0 |
| 2020-03-24 04:30:00 | AAPL | Stock | 58.0625 | 58.075 | 57.925 | 58.0725 | 8312.0 |
| 2020-03-24 04:35:00 | AAPL | Stock | 58.0725 | 58.25 | 58.0 | 58.25 | 6676.0 |
| 2020-03-24 04:40:00 | AAPL | Stock | 58.375 | 58.4 | 58.375 | 58.375 | 2500.0 |
| 2020-03-24 04:45:00 | AAPL | Stock | 58.38 | 58.5 | 58.375 | 58.49 | 10532.0 |
| 2020-03-24 04:50:00 | AAPL | Stock | 58.495 | 58.495 | 58.3125 | 58.3825 | 1600.0 |
| 2020-03-24 05:00:00 | AAPL | Stock | 58.495 | 58.6 | 58.495 | 58.5 | 13160.0 |
| 2020-03-24 05:05:00 | AAPL | Stock | 58.4975 | 58.525 | 58.4975 | 58.525 | 7560.0 |
| 2020-03-24 05:10:00 | AAPL | Stock | 58.5175 | 58.55 | 58.5 | 58.55 | 5096.0 |
| 2020-03-24 05:15:00 | AAPL | Stock | 58.5725 | 58.575 | 58.5725 | 58.575 | 1800.0 |
| 2020-03-24 05:20:00 | AAPL | Stock | 58.545 | 58.5925 | 58.5 | 58.5875 | 4200.0 |
| 2020-03-24 05:25:00 | AAPL | Stock | 58.505 | 58.505 | 58.475 | 58.475 | 1088.0 |
| 2020-03-24 05:30:00 | AAPL | Stock | 58.5 | 58.55 | 58.45 | 58.55 | 9216.0 |
| 2020-03-24 05:35:00 | AAPL | Stock | 58.55 | 58.8675 | 58.55 | 58.8675 | 11980.0 |
| 2020-03-24 05:40:00 | AAPL | Stock | 58.8 | 58.875 | 58.75 | 58.8375 | 11140.0 |
| 2020-03-24 05:45:00 | AAPL | Stock | 58.825 | 58.825 | 58.74 | 58.74 | 1340.0 |
| 2020-03-24 05:50:00 | AAPL | Stock | 58.85 | 58.8875 | 58.85 | 58.85 | 2940.0 |
| 2020-03-24 05:55:00 | AAPL | Stock | 58.925 | 58.97 | 58.925 | 58.97 | 2400.0 |
| 2020-03-24 06:00:00 | AAPL | Stock | 59.0 | 59.025 | 59.0 | 59.0 | 6060.0 |
| 2020-03-24 06:05:00 | AAPL | Stock | 59.0475 | 59.11 | 59.0 | 59.11 | 10500.0 |
| 2020-03-24 06:10:00 | AAPL | Stock | 59.0875 | 59.25 | 59.0875 | 59.25 | 14224.0 |
| 2020-03-24 06:15:00 | AAPL | Stock | 59.25 | 59.4725 | 59.18 | 59.4325 | 22044.0 |
| 2020-03-24 06:20:00 | AAPL | Stock | 59.375 | 59.4425 | 59.1475 | 59.15 | 12984.0 |
| 2020-03-24 06:25:00 | AAPL | Stock | 59.1175 | 59.23 | 59.1 | 59.2225 | 9984.0 |
| 2020-03-24 06:30:00 | AAPL | Stock | 59.2175 | 59.425 | 59.2175 | 59.425 | 12452.0 |
| 2020-03-24 06:35:00 | AAPL | Stock | 59.4625 | 59.5 | 59.4625 | 59.5 | 41904.0 |
| 2020-03-24 06:40:00 | AAPL | Stock | 59.3825 | 59.3825 | 59.21 | 59.325 | 4172.0 |
| 2020-03-24 06:45:00 | AAPL | Stock | 59.275 | 59.275 | 59.0625 | 59.0625 | 6860.0 |
| 2020-03-24 06:50:00 | AAPL | Stock | 59.0625 | 59.1475 | 59.0 | 59.035 | 11252.0 |
| 2020-03-24 06:55:00 | AAPL | Stock | 59.0825 | 59.2075 | 59.0825 | 59.125 | 8176.0 |
| 2020-03-24 07:00:00 | AAPL | Stock | 59.125 | 59.21 | 58.5525 | 58.625 | 187936.0 |
| 2020-03-24 07:05:00 | AAPL | Stock | 58.565 | 58.6125 | 58.0 | 58.125 | 118592.0 |
| 2020-03-24 07:10:00 | AAPL | Stock | 58.125 | 58.35 | 58.0 | 58.3075 | 87032.0 |
| 2020-03-24 07:15:00 | AAPL | Stock | 58.25 | 58.2875 | 58.0375 | 58.1 | 60544.0 |
| 2020-03-24 07:20:00 | AAPL | Stock | 58.1 | 58.25 | 58.05 | 58.125 | 53012.0 |
| 2020-03-24 07:25:00 | AAPL | Stock | 58.125 | 58.4775 | 58.125 | 58.4375 | 59740.0 |
| 2020-03-24 07:30:00 | AAPL | Stock | 58.45 | 58.5725 | 58.2325 | 58.57 | 82352.0 |
| 2020-03-24 07:35:00 | AAPL | Stock | 58.5625 | 58.62 | 57.875 | 58.25 | 140612.0 |
| 2020-03-24 07:40:00 | AAPL | Stock | 58.2825 | 58.3625 | 57.955 | 58.175 | 73728.0 |
| 2020-03-24 07:45:00 | AAPL | Stock | 58.2 | 58.3075 | 58.175 | 58.285 | 31448.0 |
| 2020-03-24 07:50:00 | AAPL | Stock | 58.285 | 58.455 | 58.285 | 58.4475 | 160580.0 |
| 2020-03-24 07:55:00 | AAPL | Stock | 58.3875 | 58.425 | 58.2875 | 58.37 | 69348.0 |
| 2020-03-24 08:00:00 | AAPL | Stock | 59.045 | 59.045 | 58.0375 | 58.3375 | 311900.0 |
| 2020-03-24 08:05:00 | AAPL | Stock | 58.3375 | 58.3875 | 58.1875 | 58.1875 | 196764.0 |
| 2020-03-24 08:10:00 | AAPL | Stock | 58.1875 | 58.285 | 58.175 | 58.2125 | 50992.0 |
> showing 50 of 424,881 rows — these rows as CSV