PREVIEW / stock_5min / 2020-02-10
file: by_date/stock_5min/2020/2020-02-10.parquet size: 5.9 MB rows: 363,711 symbols: 2,428
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-10 04:00:00 | AAPL | Stock | 79.485 | 79.6 | 79.485 | 79.58 | 31940.0 |
| 2020-02-10 04:05:00 | AAPL | Stock | 79.58 | 79.625 | 79.58 | 79.625 | 8404.0 |
| 2020-02-10 04:10:00 | AAPL | Stock | 79.6575 | 79.6575 | 79.625 | 79.625 | 1564.0 |
| 2020-02-10 04:15:00 | AAPL | Stock | 79.655 | 79.655 | 79.655 | 79.655 | 620.0 |
| 2020-02-10 04:20:00 | AAPL | Stock | 79.65 | 79.65 | 79.65 | 79.65 | 1108.0 |
| 2020-02-10 04:25:00 | AAPL | Stock | 79.5975 | 79.65 | 79.58 | 79.65 | 5984.0 |
| 2020-02-10 04:30:00 | AAPL | Stock | 79.63 | 79.63 | 79.57 | 79.6075 | 3804.0 |
| 2020-02-10 04:35:00 | AAPL | Stock | 79.595 | 79.605 | 79.595 | 79.605 | 4000.0 |
| 2020-02-10 04:45:00 | AAPL | Stock | 79.525 | 79.525 | 79.45 | 79.45 | 2100.0 |
| 2020-02-10 04:50:00 | AAPL | Stock | 79.4975 | 79.5125 | 79.4125 | 79.4125 | 9172.0 |
| 2020-02-10 04:55:00 | AAPL | Stock | 79.39 | 79.39 | 79.3875 | 79.3875 | 4324.0 |
| 2020-02-10 05:00:00 | AAPL | Stock | 79.3 | 79.3 | 79.1375 | 79.1375 | 2448.0 |
| 2020-02-10 05:05:00 | AAPL | Stock | 79.125 | 79.175 | 79.125 | 79.1325 | 3460.0 |
| 2020-02-10 05:10:00 | AAPL | Stock | 79.1875 | 79.3725 | 79.1875 | 79.3675 | 3564.0 |
| 2020-02-10 05:15:00 | AAPL | Stock | 79.3725 | 79.3725 | 79.3725 | 79.3725 | 2276.0 |
| 2020-02-10 05:25:00 | AAPL | Stock | 79.315 | 79.315 | 79.315 | 79.315 | 400.0 |
| 2020-02-10 05:30:00 | AAPL | Stock | 79.3425 | 79.3425 | 79.25 | 79.25 | 6564.0 |
| 2020-02-10 05:35:00 | AAPL | Stock | 79.27 | 79.3625 | 79.27 | 79.3625 | 1920.0 |
| 2020-02-10 05:40:00 | AAPL | Stock | 79.325 | 79.4575 | 79.325 | 79.425 | 28024.0 |
| 2020-02-10 05:45:00 | AAPL | Stock | 79.375 | 79.4575 | 79.375 | 79.4575 | 4408.0 |
| 2020-02-10 05:50:00 | AAPL | Stock | 79.3875 | 79.3875 | 79.3475 | 79.35 | 3596.0 |
| 2020-02-10 06:00:00 | AAPL | Stock | 79.3875 | 79.3875 | 79.3875 | 79.3875 | 400.0 |
| 2020-02-10 06:05:00 | AAPL | Stock | 79.4575 | 79.5125 | 79.4575 | 79.5 | 7428.0 |
| 2020-02-10 06:10:00 | AAPL | Stock | 79.45 | 79.455 | 79.45 | 79.45 | 11276.0 |
| 2020-02-10 06:15:00 | AAPL | Stock | 79.45 | 79.45 | 79.3875 | 79.3875 | 3600.0 |
| 2020-02-10 06:20:00 | AAPL | Stock | 79.39 | 79.39 | 79.3875 | 79.3875 | 800.0 |
| 2020-02-10 06:25:00 | AAPL | Stock | 79.375 | 79.5075 | 79.35 | 79.5075 | 5488.0 |
| 2020-02-10 06:30:00 | AAPL | Stock | 79.5075 | 79.5075 | 79.5 | 79.5 | 1200.0 |
| 2020-02-10 06:35:00 | AAPL | Stock | 79.545 | 79.56 | 79.54 | 79.56 | 3604.0 |
| 2020-02-10 06:40:00 | AAPL | Stock | 79.56 | 79.625 | 79.56 | 79.6125 | 8760.0 |
| 2020-02-10 06:45:00 | AAPL | Stock | 79.625 | 79.625 | 79.5825 | 79.5825 | 5448.0 |
| 2020-02-10 06:50:00 | AAPL | Stock | 79.5825 | 79.615 | 79.5375 | 79.5825 | 14736.0 |
| 2020-02-10 06:55:00 | AAPL | Stock | 79.5475 | 79.5475 | 79.5225 | 79.5225 | 8988.0 |
| 2020-02-10 07:00:00 | AAPL | Stock | 79.56 | 79.56 | 79.25 | 79.25 | 107864.0 |
| 2020-02-10 07:05:00 | AAPL | Stock | 79.165 | 79.165 | 79.05 | 79.1375 | 26628.0 |
| 2020-02-10 07:10:00 | AAPL | Stock | 79.21 | 79.225 | 79.175 | 79.175 | 7152.0 |
| 2020-02-10 07:15:00 | AAPL | Stock | 79.2225 | 79.315 | 79.2225 | 79.2375 | 26024.0 |
| 2020-02-10 07:20:00 | AAPL | Stock | 79.2025 | 79.3125 | 79.2025 | 79.25 | 22068.0 |
| 2020-02-10 07:25:00 | AAPL | Stock | 79.205 | 79.25 | 79.1925 | 79.25 | 20020.0 |
| 2020-02-10 07:30:00 | AAPL | Stock | 79.25 | 79.2875 | 79.225 | 79.275 | 50048.0 |
| 2020-02-10 07:35:00 | AAPL | Stock | 79.255 | 79.3125 | 79.255 | 79.3125 | 11216.0 |
| 2020-02-10 07:40:00 | AAPL | Stock | 79.3125 | 79.375 | 79.285 | 79.3 | 20732.0 |
| 2020-02-10 07:45:00 | AAPL | Stock | 79.3 | 79.325 | 79.2775 | 79.2775 | 18952.0 |
| 2020-02-10 07:50:00 | AAPL | Stock | 79.31 | 79.315 | 79.22 | 79.225 | 31132.0 |
| 2020-02-10 07:55:00 | AAPL | Stock | 79.2225 | 79.2225 | 79.1125 | 79.2 | 97496.0 |
| 2020-02-10 08:00:00 | AAPL | Stock | 79.2 | 80.2075 | 79.04 | 79.125 | 300664.0 |
| 2020-02-10 08:05:00 | AAPL | Stock | 79.1225 | 79.15 | 79.0375 | 79.1 | 71248.0 |
| 2020-02-10 08:10:00 | AAPL | Stock | 79.1 | 79.1375 | 79.07 | 79.1175 | 34180.0 |
| 2020-02-10 08:15:00 | AAPL | Stock | 79.1125 | 79.2 | 79.1125 | 79.15 | 31520.0 |
| 2020-02-10 08:20:00 | AAPL | Stock | 79.15 | 79.2275 | 79.1325 | 79.1675 | 36280.0 |
> showing 50 of 363,711 rows — these rows as CSV