PREVIEW / stock_5min / 2019-06-26
file: by_date/stock_5min/2019/2019-06-26.parquet size: 5.7 MB rows: 365,513 symbols: 2,622
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 |
|---|---|---|---|---|---|---|---|
| 2019-06-26 04:15:00 | AAPL | Stock | 49.0325 | 49.0325 | 49.0325 | 49.0325 | 1200.0 |
| 2019-06-26 04:25:00 | AAPL | Stock | 49.06 | 49.06 | 49.06 | 49.06 | 800.0 |
| 2019-06-26 04:35:00 | AAPL | Stock | 48.9725 | 48.975 | 48.9725 | 48.975 | 800.0 |
| 2019-06-26 04:45:00 | AAPL | Stock | 49.0525 | 49.25 | 49.0525 | 49.25 | 3088.0 |
| 2019-06-26 04:50:00 | AAPL | Stock | 49.185 | 49.185 | 49.185 | 49.185 | 400.0 |
| 2019-06-26 04:55:00 | AAPL | Stock | 49.25 | 49.3 | 49.25 | 49.3 | 4000.0 |
| 2019-06-26 05:00:00 | AAPL | Stock | 49.255 | 49.255 | 49.2525 | 49.2525 | 800.0 |
| 2019-06-26 05:05:00 | AAPL | Stock | 49.31 | 49.325 | 49.31 | 49.325 | 800.0 |
| 2019-06-26 05:10:00 | AAPL | Stock | 49.4 | 49.5625 | 49.4 | 49.5625 | 3200.0 |
| 2019-06-26 05:15:00 | AAPL | Stock | 49.5975 | 49.5975 | 49.5975 | 49.5975 | 400.0 |
| 2019-06-26 05:20:00 | AAPL | Stock | 49.56 | 49.56 | 49.56 | 49.56 | 600.0 |
| 2019-06-26 05:25:00 | AAPL | Stock | 49.575 | 49.6875 | 49.575 | 49.6875 | 28360.0 |
| 2019-06-26 05:30:00 | AAPL | Stock | 49.685 | 49.685 | 49.685 | 49.685 | 1600.0 |
| 2019-06-26 05:45:00 | AAPL | Stock | 49.625 | 49.6625 | 49.625 | 49.6625 | 3808.0 |
| 2019-06-26 05:50:00 | AAPL | Stock | 49.625 | 49.65 | 49.625 | 49.65 | 2800.0 |
| 2019-06-26 05:55:00 | AAPL | Stock | 49.65 | 49.675 | 49.6375 | 49.675 | 8800.0 |
| 2019-06-26 06:00:00 | AAPL | Stock | 49.6925 | 49.6925 | 49.6925 | 49.6925 | 12000.0 |
| 2019-06-26 06:15:00 | AAPL | Stock | 49.675 | 49.6975 | 49.675 | 49.6975 | 5532.0 |
| 2019-06-26 06:20:00 | AAPL | Stock | 49.7 | 49.7 | 49.6975 | 49.7 | 11200.0 |
| 2019-06-26 06:25:00 | AAPL | Stock | 49.675 | 49.675 | 49.665 | 49.665 | 800.0 |
| 2019-06-26 06:30:00 | AAPL | Stock | 49.625 | 49.675 | 49.625 | 49.625 | 2832.0 |
| 2019-06-26 06:35:00 | AAPL | Stock | 49.5775 | 49.5775 | 49.5625 | 49.5625 | 3196.0 |
| 2019-06-26 06:40:00 | AAPL | Stock | 49.5625 | 49.5625 | 49.52 | 49.52 | 5036.0 |
| 2019-06-26 06:45:00 | AAPL | Stock | 49.505 | 49.505 | 49.505 | 49.505 | 400.0 |
| 2019-06-26 06:50:00 | AAPL | Stock | 49.5075 | 49.5075 | 49.5075 | 49.5075 | 400.0 |
| 2019-06-26 07:00:00 | AAPL | Stock | 49.57 | 49.5725 | 49.525 | 49.5575 | 12732.0 |
| 2019-06-26 07:05:00 | AAPL | Stock | 49.56 | 49.56 | 49.4875 | 49.5 | 18232.0 |
| 2019-06-26 07:10:00 | AAPL | Stock | 49.5025 | 49.52 | 49.5 | 49.52 | 4400.0 |
| 2019-06-26 07:15:00 | AAPL | Stock | 49.525 | 49.5375 | 49.5 | 49.5 | 40124.0 |
| 2019-06-26 07:20:00 | AAPL | Stock | 49.525 | 49.55 | 49.525 | 49.55 | 9664.0 |
| 2019-06-26 07:25:00 | AAPL | Stock | 49.5125 | 49.54 | 49.5025 | 49.54 | 7900.0 |
| 2019-06-26 07:30:00 | AAPL | Stock | 49.54 | 49.57 | 49.54 | 49.5625 | 15156.0 |
| 2019-06-26 07:35:00 | AAPL | Stock | 49.55 | 49.6075 | 49.525 | 49.605 | 13876.0 |
| 2019-06-26 07:40:00 | AAPL | Stock | 49.555 | 49.585 | 49.54 | 49.585 | 2228.0 |
| 2019-06-26 07:45:00 | AAPL | Stock | 49.5825 | 49.615 | 49.5825 | 49.5875 | 18632.0 |
| 2019-06-26 07:50:00 | AAPL | Stock | 49.6125 | 49.6125 | 49.57 | 49.6 | 13092.0 |
| 2019-06-26 07:55:00 | AAPL | Stock | 49.595 | 49.605 | 49.545 | 49.545 | 4520.0 |
| 2019-06-26 08:00:00 | AAPL | Stock | 49.575 | 49.625 | 49.5 | 49.5375 | 100000.0 |
| 2019-06-26 08:05:00 | AAPL | Stock | 49.5975 | 49.5975 | 49.55 | 49.55 | 13816.0 |
| 2019-06-26 08:10:00 | AAPL | Stock | 49.575 | 49.5975 | 49.57 | 49.5875 | 27188.0 |
| 2019-06-26 08:15:00 | AAPL | Stock | 49.5875 | 49.5925 | 49.5725 | 49.575 | 12376.0 |
| 2019-06-26 08:20:00 | AAPL | Stock | 49.575 | 49.575 | 49.46 | 49.4875 | 55148.0 |
| 2019-06-26 08:25:00 | AAPL | Stock | 49.5202 | 49.525 | 49.5 | 49.525 | 4900.0 |
| 2019-06-26 08:30:00 | AAPL | Stock | 49.5125 | 49.515 | 49.4 | 49.4 | 39220.0 |
| 2019-06-26 08:35:00 | AAPL | Stock | 49.4125 | 49.4525 | 49.4 | 49.425 | 35876.0 |
| 2019-06-26 08:40:00 | AAPL | Stock | 49.405 | 49.425 | 49.325 | 49.375 | 67128.0 |
| 2019-06-26 08:45:00 | AAPL | Stock | 49.3325 | 49.475 | 49.2825 | 49.4375 | 27024.0 |
| 2019-06-26 08:50:00 | AAPL | Stock | 49.425 | 49.425 | 49.375 | 49.3875 | 12312.0 |
| 2019-06-26 08:55:00 | AAPL | Stock | 49.4025 | 49.4725 | 49.4025 | 49.44 | 53068.0 |
| 2019-06-26 09:00:00 | AAPL | Stock | 49.4175 | 49.4375 | 49.4125 | 49.4365 | 7052.0 |
> showing 50 of 365,513 rows — these rows as CSV