PREVIEW / stock_5min / 2020-01-16
file: by_date/stock_5min/2020/2020-01-16.parquet size: 6.0 MB rows: 372,864 symbols: 2,455
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-01-16 04:00:00 | AAPL | Stock | 78.2625 | 78.2625 | 78.2625 | 78.2625 | 852.0 |
| 2020-01-16 04:05:00 | AAPL | Stock | 78.42 | 78.42 | 78.42 | 78.42 | 400.0 |
| 2020-01-16 04:10:00 | AAPL | Stock | 78.42 | 78.42 | 78.42 | 78.42 | 400.0 |
| 2020-01-16 04:15:00 | AAPL | Stock | 78.4475 | 78.46 | 78.4475 | 78.46 | 1340.0 |
| 2020-01-16 04:20:00 | AAPL | Stock | 78.495 | 78.525 | 78.495 | 78.525 | 1600.0 |
| 2020-01-16 04:25:00 | AAPL | Stock | 78.525 | 78.525 | 78.35 | 78.35 | 8280.0 |
| 2020-01-16 04:30:00 | AAPL | Stock | 78.37 | 78.4375 | 78.37 | 78.4375 | 2072.0 |
| 2020-01-16 04:35:00 | AAPL | Stock | 78.45 | 78.45 | 78.45 | 78.45 | 1600.0 |
| 2020-01-16 04:40:00 | AAPL | Stock | 78.45 | 78.45 | 78.45 | 78.45 | 10280.0 |
| 2020-01-16 04:55:00 | AAPL | Stock | 78.45 | 78.45 | 78.45 | 78.45 | 2360.0 |
| 2020-01-16 05:00:00 | AAPL | Stock | 78.4 | 78.4 | 78.4 | 78.4 | 1920.0 |
| 2020-01-16 05:15:00 | AAPL | Stock | 78.395 | 78.425 | 78.395 | 78.425 | 10716.0 |
| 2020-01-16 05:20:00 | AAPL | Stock | 78.42 | 78.42 | 78.42 | 78.42 | 3200.0 |
| 2020-01-16 05:30:00 | AAPL | Stock | 78.4 | 78.4 | 78.4 | 78.4 | 2000.0 |
| 2020-01-16 05:35:00 | AAPL | Stock | 78.3775 | 78.3775 | 78.3775 | 78.3775 | 1920.0 |
| 2020-01-16 05:45:00 | AAPL | Stock | 78.445 | 78.445 | 78.3875 | 78.445 | 2000.0 |
| 2020-01-16 05:55:00 | AAPL | Stock | 78.425 | 78.425 | 78.4225 | 78.425 | 2604.0 |
| 2020-01-16 06:00:00 | AAPL | Stock | 78.4275 | 78.4575 | 78.4275 | 78.4575 | 3196.0 |
| 2020-01-16 06:05:00 | AAPL | Stock | 78.4325 | 78.4325 | 78.4125 | 78.4125 | 2400.0 |
| 2020-01-16 06:10:00 | AAPL | Stock | 78.3525 | 78.3525 | 78.32 | 78.32 | 2060.0 |
| 2020-01-16 06:15:00 | AAPL | Stock | 78.3875 | 78.4025 | 78.3875 | 78.4025 | 1200.0 |
| 2020-01-16 06:20:00 | AAPL | Stock | 78.4325 | 78.435 | 78.4325 | 78.4325 | 2932.0 |
| 2020-01-16 06:30:00 | AAPL | Stock | 78.355 | 78.4325 | 78.355 | 78.425 | 3920.0 |
| 2020-01-16 06:35:00 | AAPL | Stock | 78.415 | 78.415 | 78.415 | 78.415 | 1240.0 |
| 2020-01-16 06:40:00 | AAPL | Stock | 78.4 | 78.4 | 78.4 | 78.4 | 400.0 |
| 2020-01-16 06:45:00 | AAPL | Stock | 78.4475 | 78.4475 | 78.4475 | 78.4475 | 400.0 |
| 2020-01-16 06:50:00 | AAPL | Stock | 78.45 | 78.45 | 78.45 | 78.45 | 600.0 |
| 2020-01-16 06:55:00 | AAPL | Stock | 78.425 | 78.425 | 78.425 | 78.425 | 800.0 |
| 2020-01-16 07:00:00 | AAPL | Stock | 78.4075 | 78.4975 | 78.4075 | 78.4875 | 41188.0 |
| 2020-01-16 07:05:00 | AAPL | Stock | 78.495 | 78.5875 | 78.495 | 78.5725 | 50620.0 |
| 2020-01-16 07:10:00 | AAPL | Stock | 78.5725 | 78.6225 | 78.5075 | 78.5625 | 69424.0 |
| 2020-01-16 07:15:00 | AAPL | Stock | 78.5525 | 78.56 | 78.5075 | 78.545 | 19148.0 |
| 2020-01-16 07:20:00 | AAPL | Stock | 78.5275 | 78.5375 | 78.4175 | 78.4875 | 61248.0 |
| 2020-01-16 07:25:00 | AAPL | Stock | 78.48 | 78.55 | 78.4275 | 78.475 | 92652.0 |
| 2020-01-16 07:30:00 | AAPL | Stock | 78.4525 | 78.475 | 78.4425 | 78.45 | 11504.0 |
| 2020-01-16 07:35:00 | AAPL | Stock | 78.45 | 78.4925 | 78.4375 | 78.4925 | 31376.0 |
| 2020-01-16 07:40:00 | AAPL | Stock | 78.51 | 78.55 | 78.5 | 78.5125 | 33740.0 |
| 2020-01-16 07:45:00 | AAPL | Stock | 78.5025 | 78.5375 | 78.5 | 78.505 | 11220.0 |
| 2020-01-16 07:50:00 | AAPL | Stock | 78.5075 | 78.515 | 78.4325 | 78.4475 | 41852.0 |
| 2020-01-16 07:55:00 | AAPL | Stock | 78.43 | 78.445 | 78.4 | 78.4025 | 17560.0 |
| 2020-01-16 08:00:00 | AAPL | Stock | 78.45 | 78.5925 | 78.4075 | 78.455 | 113336.0 |
| 2020-01-16 08:05:00 | AAPL | Stock | 78.475 | 78.475 | 78.4 | 78.4 | 23588.0 |
| 2020-01-16 08:10:00 | AAPL | Stock | 78.3925 | 78.4305 | 78.375 | 78.405 | 32692.0 |
| 2020-01-16 08:15:00 | AAPL | Stock | 78.425 | 78.45 | 78.3825 | 78.4375 | 27740.0 |
| 2020-01-16 08:20:00 | AAPL | Stock | 78.4625 | 78.465 | 78.4375 | 78.46 | 20884.0 |
| 2020-01-16 08:25:00 | AAPL | Stock | 78.445 | 78.4675 | 78.415 | 78.415 | 29656.0 |
| 2020-01-16 08:30:00 | AAPL | Stock | 78.46 | 78.56 | 78.415 | 78.56 | 63672.0 |
| 2020-01-16 08:35:00 | AAPL | Stock | 78.56 | 78.56 | 78.4825 | 78.5175 | 42804.0 |
| 2020-01-16 08:40:00 | AAPL | Stock | 78.525 | 78.5475 | 78.5 | 78.504 | 36076.0 |
| 2020-01-16 08:45:00 | AAPL | Stock | 78.525 | 78.53 | 78.465 | 78.4875 | 23892.0 |
> showing 50 of 372,864 rows — these rows as CSV