PREVIEW / stock_5min / 2020-02-20
file: by_date/stock_5min/2020/2020-02-20.parquet size: 6.0 MB rows: 372,745 symbols: 2,432
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-02-20 04:00:00 | AAPL | Stock | 80.8225 | 80.86 | 80.8225 | 80.86 | 13296.0 |
| 2020-02-20 04:05:00 | AAPL | Stock | 80.8625 | 80.8625 | 80.8625 | 80.8625 | 1100.0 |
| 2020-02-20 04:10:00 | AAPL | Stock | 80.8325 | 80.8325 | 80.8325 | 80.8325 | 400.0 |
| 2020-02-20 04:20:00 | AAPL | Stock | 80.825 | 80.825 | 80.825 | 80.825 | 2800.0 |
| 2020-02-20 04:25:00 | AAPL | Stock | 80.7525 | 80.7525 | 80.75 | 80.75 | 1200.0 |
| 2020-02-20 04:40:00 | AAPL | Stock | 80.825 | 80.825 | 80.825 | 80.825 | 1924.0 |
| 2020-02-20 05:20:00 | AAPL | Stock | 80.775 | 80.775 | 80.775 | 80.775 | 5600.0 |
| 2020-02-20 05:55:00 | AAPL | Stock | 80.75 | 80.75 | 80.75 | 80.75 | 400.0 |
| 2020-02-20 06:50:00 | AAPL | Stock | 80.71 | 80.71 | 80.675 | 80.675 | 3076.0 |
| 2020-02-20 07:00:00 | AAPL | Stock | 80.7 | 80.795 | 80.625 | 80.72 | 51812.0 |
| 2020-02-20 07:05:00 | AAPL | Stock | 80.7475 | 80.76 | 80.7475 | 80.755 | 9684.0 |
| 2020-02-20 07:10:00 | AAPL | Stock | 80.7725 | 80.8125 | 80.7625 | 80.77 | 9184.0 |
| 2020-02-20 07:15:00 | AAPL | Stock | 80.7525 | 80.77 | 80.7475 | 80.7475 | 12660.0 |
| 2020-02-20 07:20:00 | AAPL | Stock | 80.75 | 80.75 | 80.625 | 80.625 | 25424.0 |
| 2020-02-20 07:25:00 | AAPL | Stock | 80.675 | 80.725 | 80.675 | 80.725 | 2000.0 |
| 2020-02-20 07:30:00 | AAPL | Stock | 80.6725 | 80.69 | 80.6725 | 80.69 | 17900.0 |
| 2020-02-20 07:35:00 | AAPL | Stock | 80.7075 | 80.7075 | 80.7075 | 80.7075 | 548.0 |
| 2020-02-20 07:40:00 | AAPL | Stock | 80.6925 | 80.6925 | 80.65 | 80.6725 | 5028.0 |
| 2020-02-20 07:45:00 | AAPL | Stock | 80.675 | 80.705 | 80.675 | 80.705 | 1200.0 |
| 2020-02-20 07:50:00 | AAPL | Stock | 80.705 | 80.705 | 80.6875 | 80.705 | 5280.0 |
| 2020-02-20 07:55:00 | AAPL | Stock | 80.7375 | 80.775 | 80.7375 | 80.775 | 9144.0 |
| 2020-02-20 08:00:00 | AAPL | Stock | 80.75 | 80.8088 | 80.625 | 80.7325 | 45084.0 |
| 2020-02-20 08:05:00 | AAPL | Stock | 80.7525 | 80.7675 | 80.7325 | 80.7675 | 3000.0 |
| 2020-02-20 08:10:00 | AAPL | Stock | 80.775 | 80.8 | 80.75 | 80.8 | 12068.0 |
| 2020-02-20 08:15:00 | AAPL | Stock | 80.79 | 80.795 | 80.79 | 80.795 | 1988.0 |
| 2020-02-20 08:20:00 | AAPL | Stock | 80.7875 | 80.7975 | 80.75 | 80.75 | 13340.0 |
| 2020-02-20 08:25:00 | AAPL | Stock | 80.7375 | 80.7475 | 80.675 | 80.675 | 25392.0 |
| 2020-02-20 08:30:00 | AAPL | Stock | 80.68 | 80.7775 | 80.6625 | 80.75 | 28064.0 |
| 2020-02-20 08:35:00 | AAPL | Stock | 80.7275 | 80.7275 | 80.5375 | 80.5675 | 53636.0 |
| 2020-02-20 08:40:00 | AAPL | Stock | 80.575 | 80.6375 | 80.51 | 80.6375 | 39996.0 |
| 2020-02-20 08:45:00 | AAPL | Stock | 80.6365 | 80.6575 | 80.6075 | 80.625 | 15004.0 |
| 2020-02-20 08:50:00 | AAPL | Stock | 80.6125 | 80.6575 | 80.5545 | 80.6125 | 47864.0 |
| 2020-02-20 08:55:00 | AAPL | Stock | 80.605 | 80.655 | 80.605 | 80.645 | 21080.0 |
| 2020-02-20 09:00:00 | AAPL | Stock | 80.625 | 80.675 | 80.625 | 80.64 | 13908.0 |
| 2020-02-20 09:05:00 | AAPL | Stock | 80.673 | 80.6825 | 80.625 | 80.63 | 26380.0 |
| 2020-02-20 09:10:00 | AAPL | Stock | 80.625 | 80.6425 | 80.61 | 80.6425 | 10036.0 |
| 2020-02-20 09:15:00 | AAPL | Stock | 80.6425 | 80.66 | 80.64 | 80.66 | 8120.0 |
| 2020-02-20 09:20:00 | AAPL | Stock | 80.65 | 80.685 | 80.625 | 80.6825 | 52244.0 |
| 2020-02-20 09:25:00 | AAPL | Stock | 80.6625 | 80.685 | 80.6425 | 80.6425 | 2460.0 |
| 2020-02-20 09:30:00 | AAPL | Stock | 80.6575 | 81.1625 | 80.645 | 81.0325 | 3684780.0 |
| 2020-02-20 09:35:00 | AAPL | Stock | 81.0375 | 81.0385 | 80.7252 | 80.967 | 2154152.0 |
| 2020-02-20 09:40:00 | AAPL | Stock | 80.965 | 81.0152 | 80.84 | 80.9625 | 1270628.0 |
| 2020-02-20 09:45:00 | AAPL | Stock | 80.945 | 80.98 | 80.8925 | 80.965 | 981820.0 |
| 2020-02-20 09:50:00 | AAPL | Stock | 80.9662 | 81.1125 | 80.965 | 81.0875 | 1517412.0 |
| 2020-02-20 09:55:00 | AAPL | Stock | 81.09 | 81.1225 | 81.0325 | 81.095 | 1060628.0 |
| 2020-02-20 10:00:00 | AAPL | Stock | 81.0975 | 81.11 | 80.98 | 81.0675 | 897644.0 |
| 2020-02-20 10:05:00 | AAPL | Stock | 81.065 | 81.135 | 81.0425 | 81.0725 | 913600.0 |
| 2020-02-20 10:10:00 | AAPL | Stock | 81.075 | 81.1075 | 80.975 | 80.9975 | 858344.0 |
| 2020-02-20 10:15:00 | AAPL | Stock | 80.9975 | 81.0025 | 80.795 | 80.795 | 1213732.0 |
| 2020-02-20 10:20:00 | AAPL | Stock | 80.795 | 80.8225 | 80.735 | 80.7712 | 1242360.0 |
> showing 50 of 372,745 rows — these rows as CSV