PREVIEW / stock_5min / 2020-05-20
file: by_date/stock_5min/2020/2020-05-20.parquet size: 6.5 MB rows: 410,764 symbols: 2,378
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-05-20 04:00:00 | AAPL | Stock | 78.755 | 78.7625 | 78.755 | 78.7625 | 3892.0 |
| 2020-05-20 04:10:00 | AAPL | Stock | 78.87 | 78.9 | 78.87 | 78.9 | 4972.0 |
| 2020-05-20 04:15:00 | AAPL | Stock | 78.9 | 79.0 | 78.9 | 79.0 | 10688.0 |
| 2020-05-20 04:20:00 | AAPL | Stock | 78.9275 | 79.0 | 78.9275 | 79.0 | 2200.0 |
| 2020-05-20 04:25:00 | AAPL | Stock | 79.0475 | 79.0475 | 79.0475 | 79.0475 | 400.0 |
| 2020-05-20 05:10:00 | AAPL | Stock | 79.0675 | 79.0675 | 79.0675 | 79.0675 | 400.0 |
| 2020-05-20 05:20:00 | AAPL | Stock | 79.0675 | 79.0675 | 79.0675 | 79.0675 | 400.0 |
| 2020-05-20 05:55:00 | AAPL | Stock | 79.19 | 79.1925 | 79.19 | 79.1925 | 6400.0 |
| 2020-05-20 06:00:00 | AAPL | Stock | 79.13 | 79.255 | 79.13 | 79.255 | 2760.0 |
| 2020-05-20 06:05:00 | AAPL | Stock | 79.2975 | 79.2975 | 79.25 | 79.28 | 3324.0 |
| 2020-05-20 06:10:00 | AAPL | Stock | 79.25 | 79.25 | 79.25 | 79.25 | 5200.0 |
| 2020-05-20 06:15:00 | AAPL | Stock | 79.225 | 79.225 | 79.225 | 79.225 | 1772.0 |
| 2020-05-20 06:35:00 | AAPL | Stock | 79.295 | 79.295 | 79.295 | 79.295 | 400.0 |
| 2020-05-20 06:40:00 | AAPL | Stock | 79.3125 | 79.3125 | 79.2775 | 79.2775 | 8800.0 |
| 2020-05-20 06:45:00 | AAPL | Stock | 79.28 | 79.28 | 79.28 | 79.28 | 1200.0 |
| 2020-05-20 06:50:00 | AAPL | Stock | 79.2075 | 79.3125 | 79.2075 | 79.3125 | 5412.0 |
| 2020-05-20 06:55:00 | AAPL | Stock | 79.345 | 79.375 | 79.345 | 79.3625 | 3236.0 |
| 2020-05-20 07:00:00 | AAPL | Stock | 79.3075 | 79.375 | 79.205 | 79.205 | 67764.0 |
| 2020-05-20 07:05:00 | AAPL | Stock | 79.205 | 79.2325 | 79.205 | 79.225 | 17612.0 |
| 2020-05-20 07:10:00 | AAPL | Stock | 79.205 | 79.2375 | 79.205 | 79.2375 | 44984.0 |
| 2020-05-20 07:15:00 | AAPL | Stock | 79.2275 | 79.25 | 79.2125 | 79.2125 | 8140.0 |
| 2020-05-20 07:20:00 | AAPL | Stock | 79.2 | 79.2 | 79.175 | 79.175 | 7928.0 |
| 2020-05-20 07:25:00 | AAPL | Stock | 79.1875 | 79.21 | 79.1625 | 79.1875 | 11748.0 |
| 2020-05-20 07:30:00 | AAPL | Stock | 79.1875 | 79.1875 | 79.125 | 79.125 | 6752.0 |
| 2020-05-20 07:35:00 | AAPL | Stock | 79.1025 | 79.1425 | 79.075 | 79.1425 | 12716.0 |
| 2020-05-20 07:40:00 | AAPL | Stock | 79.14 | 79.2 | 79.1 | 79.2 | 13600.0 |
| 2020-05-20 07:45:00 | AAPL | Stock | 79.1875 | 79.2375 | 79.13 | 79.225 | 18084.0 |
| 2020-05-20 07:50:00 | AAPL | Stock | 79.2 | 79.2 | 79.175 | 79.175 | 7236.0 |
| 2020-05-20 07:55:00 | AAPL | Stock | 79.2225 | 79.2225 | 79.2225 | 79.2225 | 400.0 |
| 2020-05-20 08:00:00 | AAPL | Stock | 79.2 | 79.36 | 79.0625 | 79.1875 | 173832.0 |
| 2020-05-20 08:05:00 | AAPL | Stock | 79.18 | 79.225 | 79.1775 | 79.225 | 5200.0 |
| 2020-05-20 08:10:00 | AAPL | Stock | 79.225 | 79.25 | 79.2175 | 79.25 | 43992.0 |
| 2020-05-20 08:15:00 | AAPL | Stock | 79.25 | 79.25 | 79.175 | 79.2025 | 20420.0 |
| 2020-05-20 08:20:00 | AAPL | Stock | 79.175 | 79.2275 | 79.175 | 79.1838 | 22480.0 |
| 2020-05-20 08:25:00 | AAPL | Stock | 79.179 | 79.22 | 79.175 | 79.205 | 8612.0 |
| 2020-05-20 08:30:00 | AAPL | Stock | 79.1925 | 79.205 | 79.175 | 79.175 | 10604.0 |
| 2020-05-20 08:35:00 | AAPL | Stock | 79.1725 | 79.1875 | 79.1275 | 79.1625 | 10140.0 |
| 2020-05-20 08:40:00 | AAPL | Stock | 79.1425 | 79.1625 | 78.285 | 79.13 | 23548.0 |
| 2020-05-20 08:45:00 | AAPL | Stock | 79.1475 | 79.1625 | 79.125 | 79.1625 | 5676.0 |
| 2020-05-20 08:50:00 | AAPL | Stock | 79.1625 | 79.175 | 79.125 | 79.15 | 37324.0 |
| 2020-05-20 08:55:00 | AAPL | Stock | 79.155 | 79.1925 | 79.1375 | 79.1375 | 26240.0 |
| 2020-05-20 09:00:00 | AAPL | Stock | 79.2 | 79.2225 | 79.175 | 79.2 | 14448.0 |
| 2020-05-20 09:05:00 | AAPL | Stock | 79.2125 | 79.2175 | 79.0975 | 79.15 | 34452.0 |
| 2020-05-20 09:10:00 | AAPL | Stock | 79.1375 | 79.1625 | 79.1025 | 79.1625 | 18336.0 |
| 2020-05-20 09:15:00 | AAPL | Stock | 79.1625 | 79.2375 | 79.1475 | 79.2375 | 67484.0 |
| 2020-05-20 09:20:00 | AAPL | Stock | 79.2225 | 79.25 | 79.2225 | 79.2475 | 65128.0 |
| 2020-05-20 09:25:00 | AAPL | Stock | 79.2475 | 79.25 | 79.1325 | 79.135 | 47264.0 |
| 2020-05-20 09:30:00 | AAPL | Stock | 79.17 | 79.515 | 79.05 | 79.4562 | 5391132.0 |
| 2020-05-20 09:35:00 | AAPL | Stock | 79.4528 | 79.5925 | 79.3525 | 79.5675 | 2654732.0 |
| 2020-05-20 09:40:00 | AAPL | Stock | 79.565 | 79.6675 | 79.4825 | 79.6075 | 2201828.0 |
> showing 50 of 410,764 rows — these rows as CSV