PREVIEW / stock_5min / 2020-04-14
file: by_date/stock_5min/2020/2020-04-14.parquet size: 6.5 MB rows: 408,088 symbols: 2,422
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-14 04:00:00 | AAPL | Stock | 69.375 | 69.4375 | 69.375 | 69.425 | 15696.0 |
| 2020-04-14 04:05:00 | AAPL | Stock | 69.425 | 69.425 | 69.425 | 69.425 | 3656.0 |
| 2020-04-14 04:10:00 | AAPL | Stock | 69.35 | 69.375 | 69.35 | 69.35 | 11704.0 |
| 2020-04-14 04:15:00 | AAPL | Stock | 69.375 | 69.375 | 69.0775 | 69.2525 | 10216.0 |
| 2020-04-14 04:20:00 | AAPL | Stock | 69.2525 | 69.3775 | 69.2525 | 69.3775 | 4068.0 |
| 2020-04-14 04:25:00 | AAPL | Stock | 69.4375 | 69.4375 | 69.4375 | 69.4375 | 888.0 |
| 2020-04-14 04:30:00 | AAPL | Stock | 69.4375 | 69.4375 | 69.4375 | 69.4375 | 400.0 |
| 2020-04-14 04:35:00 | AAPL | Stock | 69.3775 | 69.425 | 69.375 | 69.425 | 2108.0 |
| 2020-04-14 04:40:00 | AAPL | Stock | 69.425 | 69.45 | 69.425 | 69.45 | 3200.0 |
| 2020-04-14 04:45:00 | AAPL | Stock | 69.5 | 69.5 | 69.5 | 69.5 | 4400.0 |
| 2020-04-14 04:50:00 | AAPL | Stock | 69.4075 | 69.4375 | 69.4075 | 69.4375 | 4400.0 |
| 2020-04-14 04:55:00 | AAPL | Stock | 69.3325 | 69.45 | 69.3325 | 69.4 | 4656.0 |
| 2020-04-14 05:00:00 | AAPL | Stock | 69.45 | 69.45 | 69.4175 | 69.4175 | 1672.0 |
| 2020-04-14 05:05:00 | AAPL | Stock | 69.5 | 69.6 | 69.5 | 69.6 | 2800.0 |
| 2020-04-14 05:10:00 | AAPL | Stock | 69.625 | 69.65 | 69.625 | 69.65 | 8444.0 |
| 2020-04-14 05:15:00 | AAPL | Stock | 69.625 | 69.625 | 69.625 | 69.625 | 400.0 |
| 2020-04-14 05:20:00 | AAPL | Stock | 69.65 | 69.65 | 69.625 | 69.625 | 1776.0 |
| 2020-04-14 05:25:00 | AAPL | Stock | 69.625 | 69.7975 | 69.625 | 69.7975 | 24780.0 |
| 2020-04-14 05:30:00 | AAPL | Stock | 69.68 | 69.68 | 69.68 | 69.68 | 400.0 |
| 2020-04-14 05:35:00 | AAPL | Stock | 69.735 | 69.735 | 69.6 | 69.6125 | 2368.0 |
| 2020-04-14 05:40:00 | AAPL | Stock | 69.6425 | 69.6625 | 69.6425 | 69.6625 | 1600.0 |
| 2020-04-14 05:45:00 | AAPL | Stock | 69.7375 | 69.8125 | 69.7375 | 69.8125 | 2400.0 |
| 2020-04-14 05:50:00 | AAPL | Stock | 69.75 | 69.75 | 69.75 | 69.75 | 1600.0 |
| 2020-04-14 06:00:00 | AAPL | Stock | 69.75 | 69.75 | 69.625 | 69.625 | 5648.0 |
| 2020-04-14 06:05:00 | AAPL | Stock | 69.7 | 69.71 | 69.675 | 69.6975 | 4444.0 |
| 2020-04-14 06:10:00 | AAPL | Stock | 69.7025 | 69.74 | 69.7025 | 69.74 | 1176.0 |
| 2020-04-14 06:15:00 | AAPL | Stock | 69.7475 | 69.75 | 69.65 | 69.65 | 2000.0 |
| 2020-04-14 06:20:00 | AAPL | Stock | 69.6575 | 69.6575 | 69.6575 | 69.6575 | 400.0 |
| 2020-04-14 06:25:00 | AAPL | Stock | 69.725 | 69.75 | 69.725 | 69.75 | 7920.0 |
| 2020-04-14 06:35:00 | AAPL | Stock | 69.7125 | 69.725 | 69.7125 | 69.725 | 4568.0 |
| 2020-04-14 06:40:00 | AAPL | Stock | 69.725 | 69.725 | 69.6975 | 69.6975 | 4000.0 |
| 2020-04-14 06:45:00 | AAPL | Stock | 69.615 | 69.615 | 69.4325 | 69.4325 | 12292.0 |
| 2020-04-14 06:50:00 | AAPL | Stock | 69.435 | 69.435 | 69.435 | 69.435 | 800.0 |
| 2020-04-14 06:55:00 | AAPL | Stock | 69.5 | 69.5975 | 69.46 | 69.46 | 2140.0 |
| 2020-04-14 07:00:00 | AAPL | Stock | 69.5925 | 69.5925 | 69.385 | 69.4 | 87852.0 |
| 2020-04-14 07:05:00 | AAPL | Stock | 69.4125 | 69.45 | 69.38 | 69.44 | 28588.0 |
| 2020-04-14 07:10:00 | AAPL | Stock | 69.39 | 69.3925 | 69.31 | 69.31 | 66668.0 |
| 2020-04-14 07:15:00 | AAPL | Stock | 69.3125 | 69.3375 | 69.275 | 69.275 | 52080.0 |
| 2020-04-14 07:20:00 | AAPL | Stock | 69.2725 | 69.38 | 69.2725 | 69.38 | 33724.0 |
| 2020-04-14 07:25:00 | AAPL | Stock | 69.395 | 69.4375 | 69.325 | 69.435 | 29100.0 |
| 2020-04-14 07:30:00 | AAPL | Stock | 69.415 | 69.445 | 69.405 | 69.4125 | 45248.0 |
| 2020-04-14 07:35:00 | AAPL | Stock | 69.4 | 69.5 | 69.325 | 69.4875 | 49684.0 |
| 2020-04-14 07:40:00 | AAPL | Stock | 69.4875 | 69.5375 | 69.4875 | 69.52 | 34856.0 |
| 2020-04-14 07:45:00 | AAPL | Stock | 69.545 | 69.575 | 69.5175 | 69.55 | 57124.0 |
| 2020-04-14 07:50:00 | AAPL | Stock | 69.55 | 69.5875 | 69.46 | 69.465 | 39100.0 |
| 2020-04-14 07:55:00 | AAPL | Stock | 69.475 | 69.5825 | 69.465 | 69.575 | 12956.0 |
| 2020-04-14 08:00:00 | AAPL | Stock | 69.4 | 69.625 | 69.3175 | 69.575 | 160548.0 |
| 2020-04-14 08:05:00 | AAPL | Stock | 69.585 | 69.625 | 69.5525 | 69.625 | 43216.0 |
| 2020-04-14 08:10:00 | AAPL | Stock | 69.6225 | 69.6625 | 69.55 | 69.6625 | 51312.0 |
| 2020-04-14 08:15:00 | AAPL | Stock | 69.64 | 69.7 | 69.6375 | 69.675 | 63884.0 |
> showing 50 of 408,088 rows — these rows as CSV