PREVIEW / stock_5min / 2020-03-31
file: by_date/stock_5min/2020/2020-03-31.parquet size: 6.4 MB rows: 407,360 symbols: 2,447
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-31 04:00:00 | AAPL | Stock | 64.3275 | 64.3275 | 64.18 | 64.2525 | 9092.0 |
| 2020-03-31 04:05:00 | AAPL | Stock | 64.1025 | 64.275 | 64.1 | 64.275 | 5644.0 |
| 2020-03-31 04:10:00 | AAPL | Stock | 64.36 | 64.36 | 64.2675 | 64.275 | 10692.0 |
| 2020-03-31 04:15:00 | AAPL | Stock | 64.32 | 64.32 | 64.25 | 64.2575 | 6484.0 |
| 2020-03-31 04:20:00 | AAPL | Stock | 64.3125 | 64.3375 | 64.2525 | 64.3375 | 3132.0 |
| 2020-03-31 04:25:00 | AAPL | Stock | 64.475 | 64.475 | 64.475 | 64.475 | 2408.0 |
| 2020-03-31 04:30:00 | AAPL | Stock | 64.475 | 64.5 | 64.475 | 64.5 | 2480.0 |
| 2020-03-31 04:35:00 | AAPL | Stock | 64.5 | 64.515 | 64.425 | 64.425 | 5220.0 |
| 2020-03-31 04:40:00 | AAPL | Stock | 64.575 | 64.575 | 64.575 | 64.575 | 3200.0 |
| 2020-03-31 04:45:00 | AAPL | Stock | 64.5075 | 64.5075 | 64.31 | 64.3875 | 3708.0 |
| 2020-03-31 04:50:00 | AAPL | Stock | 64.4975 | 64.4975 | 64.4725 | 64.4875 | 2588.0 |
| 2020-03-31 04:55:00 | AAPL | Stock | 64.675 | 64.675 | 64.48 | 64.625 | 5828.0 |
| 2020-03-31 05:00:00 | AAPL | Stock | 64.53 | 64.5625 | 64.5075 | 64.5625 | 6000.0 |
| 2020-03-31 05:10:00 | AAPL | Stock | 64.5275 | 64.5275 | 64.5275 | 64.5275 | 440.0 |
| 2020-03-31 05:15:00 | AAPL | Stock | 64.595 | 64.595 | 64.575 | 64.575 | 2568.0 |
| 2020-03-31 05:20:00 | AAPL | Stock | 64.575 | 64.625 | 64.575 | 64.625 | 6156.0 |
| 2020-03-31 05:25:00 | AAPL | Stock | 64.6125 | 64.6125 | 64.5925 | 64.5925 | 1676.0 |
| 2020-03-31 05:30:00 | AAPL | Stock | 64.5875 | 64.6025 | 64.5875 | 64.5875 | 6600.0 |
| 2020-03-31 05:35:00 | AAPL | Stock | 64.5375 | 64.625 | 64.5375 | 64.55 | 1524.0 |
| 2020-03-31 05:40:00 | AAPL | Stock | 64.5 | 64.5 | 64.5 | 64.5 | 2000.0 |
| 2020-03-31 05:45:00 | AAPL | Stock | 64.5 | 64.5 | 64.435 | 64.435 | 2000.0 |
| 2020-03-31 05:50:00 | AAPL | Stock | 64.3775 | 64.3775 | 64.3075 | 64.3075 | 3400.0 |
| 2020-03-31 06:00:00 | AAPL | Stock | 64.435 | 64.5 | 64.31 | 64.5 | 2748.0 |
| 2020-03-31 06:05:00 | AAPL | Stock | 64.3175 | 64.3225 | 64.3075 | 64.31 | 3636.0 |
| 2020-03-31 06:15:00 | AAPL | Stock | 64.31 | 64.43 | 64.25 | 64.25 | 12412.0 |
| 2020-03-31 06:20:00 | AAPL | Stock | 64.195 | 64.195 | 64.13 | 64.13 | 4768.0 |
| 2020-03-31 06:25:00 | AAPL | Stock | 64.09 | 64.0975 | 64.09 | 64.0975 | 2328.0 |
| 2020-03-31 06:30:00 | AAPL | Stock | 64.0525 | 64.2475 | 64.0525 | 64.165 | 3020.0 |
| 2020-03-31 06:35:00 | AAPL | Stock | 63.965 | 63.965 | 63.965 | 63.965 | 800.0 |
| 2020-03-31 06:40:00 | AAPL | Stock | 64.0 | 64.0 | 64.0 | 64.0 | 2400.0 |
| 2020-03-31 06:50:00 | AAPL | Stock | 64.0 | 64.0 | 64.0 | 64.0 | 2404.0 |
| 2020-03-31 06:55:00 | AAPL | Stock | 63.9975 | 63.9975 | 63.9025 | 63.9025 | 1868.0 |
| 2020-03-31 07:00:00 | AAPL | Stock | 63.9725 | 64.125 | 63.775 | 63.775 | 61952.0 |
| 2020-03-31 07:05:00 | AAPL | Stock | 63.85 | 64.0675 | 63.775 | 63.8 | 33384.0 |
| 2020-03-31 07:10:00 | AAPL | Stock | 63.8 | 63.9125 | 63.765 | 63.83 | 18676.0 |
| 2020-03-31 07:15:00 | AAPL | Stock | 63.845 | 63.9125 | 63.825 | 63.9125 | 12228.0 |
| 2020-03-31 07:20:00 | AAPL | Stock | 63.9125 | 64.0075 | 63.8475 | 63.905 | 32188.0 |
| 2020-03-31 07:25:00 | AAPL | Stock | 63.9325 | 63.95 | 63.88 | 63.88 | 5624.0 |
| 2020-03-31 07:30:00 | AAPL | Stock | 63.9225 | 63.98 | 63.8775 | 63.9775 | 6976.0 |
| 2020-03-31 07:35:00 | AAPL | Stock | 63.975 | 63.98 | 63.9 | 63.9 | 5652.0 |
| 2020-03-31 07:40:00 | AAPL | Stock | 63.875 | 63.9275 | 63.72 | 63.75 | 76272.0 |
| 2020-03-31 07:45:00 | AAPL | Stock | 63.7175 | 63.75 | 63.635 | 63.75 | 20724.0 |
| 2020-03-31 07:50:00 | AAPL | Stock | 63.795 | 63.86 | 63.775 | 63.805 | 11160.0 |
| 2020-03-31 07:55:00 | AAPL | Stock | 63.8 | 63.87 | 63.775 | 63.87 | 11552.0 |
| 2020-03-31 08:00:00 | AAPL | Stock | 63.8575 | 64.1175 | 63.5 | 63.7025 | 139700.0 |
| 2020-03-31 08:05:00 | AAPL | Stock | 63.58 | 63.58 | 63.2 | 63.2 | 66912.0 |
| 2020-03-31 08:10:00 | AAPL | Stock | 63.2 | 63.37 | 63.2 | 63.2075 | 71548.0 |
| 2020-03-31 08:15:00 | AAPL | Stock | 63.2 | 63.25 | 63.075 | 63.1875 | 42340.0 |
| 2020-03-31 08:20:00 | AAPL | Stock | 63.1975 | 63.37 | 63.0875 | 63.295 | 63260.0 |
| 2020-03-31 08:25:00 | AAPL | Stock | 63.2975 | 63.4225 | 63.295 | 63.3725 | 25036.0 |
> showing 50 of 407,360 rows — these rows as CSV