PREVIEW / stock_5min / 2020-01-08
file: by_date/stock_5min/2020/2020-01-08.parquet size: 6.1 MB rows: 374,108 symbols: 2,474
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-08 04:00:00 | AAPL | Stock | 74.125 | 74.3375 | 74.125 | 74.25 | 15208.0 |
| 2020-01-08 04:05:00 | AAPL | Stock | 74.32 | 74.32 | 74.215 | 74.2475 | 12840.0 |
| 2020-01-08 04:10:00 | AAPL | Stock | 74.235 | 74.345 | 74.215 | 74.3075 | 23304.0 |
| 2020-01-08 04:15:00 | AAPL | Stock | 74.2925 | 74.2925 | 74.23 | 74.2625 | 13056.0 |
| 2020-01-08 04:20:00 | AAPL | Stock | 74.2525 | 74.2625 | 74.21 | 74.25 | 10200.0 |
| 2020-01-08 04:25:00 | AAPL | Stock | 74.2475 | 74.2875 | 74.2125 | 74.2475 | 14632.0 |
| 2020-01-08 04:30:00 | AAPL | Stock | 74.2625 | 74.3125 | 74.1725 | 74.2 | 9612.0 |
| 2020-01-08 04:35:00 | AAPL | Stock | 74.22 | 74.2625 | 74.22 | 74.2225 | 7668.0 |
| 2020-01-08 04:40:00 | AAPL | Stock | 74.2225 | 74.275 | 74.2225 | 74.275 | 2412.0 |
| 2020-01-08 04:45:00 | AAPL | Stock | 74.25 | 74.25 | 74.25 | 74.25 | 800.0 |
| 2020-01-08 04:50:00 | AAPL | Stock | 74.25 | 74.3 | 74.25 | 74.3 | 3600.0 |
| 2020-01-08 05:00:00 | AAPL | Stock | 74.25 | 74.25 | 74.25 | 74.25 | 400.0 |
| 2020-01-08 05:05:00 | AAPL | Stock | 74.265 | 74.265 | 74.2625 | 74.2625 | 1600.0 |
| 2020-01-08 05:10:00 | AAPL | Stock | 74.2625 | 74.2625 | 74.25 | 74.2625 | 4400.0 |
| 2020-01-08 05:15:00 | AAPL | Stock | 74.275 | 74.4375 | 74.275 | 74.4375 | 12788.0 |
| 2020-01-08 05:20:00 | AAPL | Stock | 74.4675 | 74.5 | 74.4375 | 74.4375 | 12496.0 |
| 2020-01-08 05:25:00 | AAPL | Stock | 74.4025 | 74.45 | 74.4025 | 74.45 | 4780.0 |
| 2020-01-08 05:30:00 | AAPL | Stock | 74.475 | 74.475 | 74.475 | 74.475 | 4416.0 |
| 2020-01-08 05:35:00 | AAPL | Stock | 74.475 | 74.475 | 74.45 | 74.45 | 1620.0 |
| 2020-01-08 05:40:00 | AAPL | Stock | 74.4625 | 74.4725 | 74.4625 | 74.4725 | 1640.0 |
| 2020-01-08 05:45:00 | AAPL | Stock | 74.47 | 74.47 | 74.47 | 74.47 | 1200.0 |
| 2020-01-08 05:50:00 | AAPL | Stock | 74.45 | 74.45 | 74.45 | 74.45 | 400.0 |
| 2020-01-08 05:55:00 | AAPL | Stock | 74.5 | 74.5 | 74.5 | 74.5 | 728.0 |
| 2020-01-08 06:00:00 | AAPL | Stock | 74.5625 | 74.5625 | 74.5325 | 74.5325 | 5676.0 |
| 2020-01-08 06:05:00 | AAPL | Stock | 74.5325 | 74.5325 | 74.5 | 74.5 | 12840.0 |
| 2020-01-08 06:20:00 | AAPL | Stock | 74.5 | 74.6025 | 74.5 | 74.6025 | 10416.0 |
| 2020-01-08 06:25:00 | AAPL | Stock | 74.6025 | 74.6325 | 74.6025 | 74.6325 | 3200.0 |
| 2020-01-08 06:30:00 | AAPL | Stock | 74.6625 | 74.6875 | 74.575 | 74.625 | 12776.0 |
| 2020-01-08 06:35:00 | AAPL | Stock | 74.6575 | 74.6575 | 74.6075 | 74.6075 | 4400.0 |
| 2020-01-08 06:40:00 | AAPL | Stock | 74.61 | 74.6225 | 74.61 | 74.61 | 2004.0 |
| 2020-01-08 06:45:00 | AAPL | Stock | 74.61 | 74.6125 | 74.61 | 74.6125 | 11412.0 |
| 2020-01-08 06:50:00 | AAPL | Stock | 74.6125 | 74.6125 | 74.605 | 74.605 | 800.0 |
| 2020-01-08 06:55:00 | AAPL | Stock | 74.5975 | 74.625 | 74.5675 | 74.5925 | 22732.0 |
| 2020-01-08 07:00:00 | AAPL | Stock | 74.54 | 74.59 | 74.4 | 74.4975 | 74952.0 |
| 2020-01-08 07:05:00 | AAPL | Stock | 74.45 | 74.55 | 74.45 | 74.4825 | 51404.0 |
| 2020-01-08 07:10:00 | AAPL | Stock | 74.48 | 74.5125 | 74.475 | 74.5 | 26116.0 |
| 2020-01-08 07:15:00 | AAPL | Stock | 74.4975 | 74.4975 | 74.45 | 74.475 | 16420.0 |
| 2020-01-08 07:20:00 | AAPL | Stock | 74.4625 | 74.545 | 74.455 | 74.4625 | 24148.0 |
| 2020-01-08 07:25:00 | AAPL | Stock | 74.525 | 74.525 | 74.4975 | 74.5125 | 32740.0 |
| 2020-01-08 07:30:00 | AAPL | Stock | 74.485 | 74.545 | 74.485 | 74.545 | 8536.0 |
| 2020-01-08 07:35:00 | AAPL | Stock | 74.5125 | 74.525 | 74.5 | 74.525 | 16924.0 |
| 2020-01-08 07:40:00 | AAPL | Stock | 74.5425 | 74.5925 | 74.5425 | 74.5875 | 29336.0 |
| 2020-01-08 07:45:00 | AAPL | Stock | 74.5975 | 74.6 | 74.575 | 74.59 | 26428.0 |
| 2020-01-08 07:50:00 | AAPL | Stock | 74.5875 | 74.615 | 74.575 | 74.615 | 15976.0 |
| 2020-01-08 07:55:00 | AAPL | Stock | 74.62 | 74.635 | 74.5875 | 74.6175 | 47228.0 |
| 2020-01-08 08:00:00 | AAPL | Stock | 74.425 | 74.7825 | 74.3875 | 74.58 | 270888.0 |
| 2020-01-08 08:05:00 | AAPL | Stock | 74.6125 | 74.625 | 74.575 | 74.575 | 15496.0 |
| 2020-01-08 08:10:00 | AAPL | Stock | 74.575 | 74.66 | 74.575 | 74.625 | 35316.0 |
| 2020-01-08 08:15:00 | AAPL | Stock | 74.6425 | 74.75 | 74.6425 | 74.7025 | 71704.0 |
| 2020-01-08 08:20:00 | AAPL | Stock | 74.7275 | 74.7475 | 74.67 | 74.6725 | 72120.0 |
> showing 50 of 374,108 rows — these rows as CSV