PREVIEW / stock_5min / 2020-01-21
file: by_date/stock_5min/2020/2020-01-21.parquet size: 6.1 MB rows: 378,474 symbols: 2,488
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-01-21 04:00:00 | AAPL | Stock | 79.2425 | 79.25 | 79.085 | 79.25 | 6604.0 |
| 2020-01-21 04:10:00 | AAPL | Stock | 79.2325 | 79.2325 | 79.2325 | 79.2325 | 1896.0 |
| 2020-01-21 04:15:00 | AAPL | Stock | 79.2325 | 79.2325 | 79.2325 | 79.2325 | 400.0 |
| 2020-01-21 04:20:00 | AAPL | Stock | 79.245 | 79.25 | 79.245 | 79.25 | 1440.0 |
| 2020-01-21 04:25:00 | AAPL | Stock | 79.205 | 79.205 | 79.2025 | 79.2025 | 800.0 |
| 2020-01-21 04:30:00 | AAPL | Stock | 79.2325 | 79.2325 | 79.2325 | 79.2325 | 792.0 |
| 2020-01-21 04:35:00 | AAPL | Stock | 79.2325 | 79.31 | 79.2325 | 79.31 | 1108.0 |
| 2020-01-21 04:40:00 | AAPL | Stock | 79.2075 | 79.2075 | 79.1275 | 79.1275 | 4792.0 |
| 2020-01-21 04:45:00 | AAPL | Stock | 79.15 | 79.15 | 79.15 | 79.15 | 3856.0 |
| 2020-01-21 04:50:00 | AAPL | Stock | 79.175 | 79.185 | 79.165 | 79.185 | 2580.0 |
| 2020-01-21 04:55:00 | AAPL | Stock | 79.225 | 79.225 | 79.2175 | 79.225 | 1600.0 |
| 2020-01-21 05:00:00 | AAPL | Stock | 79.2 | 79.225 | 79.2 | 79.225 | 4148.0 |
| 2020-01-21 05:05:00 | AAPL | Stock | 79.225 | 79.225 | 79.225 | 79.225 | 5772.0 |
| 2020-01-21 05:10:00 | AAPL | Stock | 79.225 | 79.225 | 79.225 | 79.225 | 400.0 |
| 2020-01-21 05:15:00 | AAPL | Stock | 79.25 | 79.25 | 79.175 | 79.175 | 1940.0 |
| 2020-01-21 05:25:00 | AAPL | Stock | 79.175 | 79.175 | 79.175 | 79.175 | 880.0 |
| 2020-01-21 05:45:00 | AAPL | Stock | 79.175 | 79.175 | 79.125 | 79.1575 | 11184.0 |
| 2020-01-21 06:10:00 | AAPL | Stock | 79.25 | 79.25 | 79.25 | 79.25 | 628.0 |
| 2020-01-21 06:15:00 | AAPL | Stock | 79.1875 | 79.2 | 79.1375 | 79.1375 | 4800.0 |
| 2020-01-21 06:20:00 | AAPL | Stock | 79.1875 | 79.1875 | 79.1875 | 79.1875 | 1200.0 |
| 2020-01-21 06:25:00 | AAPL | Stock | 79.1025 | 79.1025 | 79.1025 | 79.1025 | 3804.0 |
| 2020-01-21 06:30:00 | AAPL | Stock | 79.1025 | 79.1025 | 79.1025 | 79.1025 | 1784.0 |
| 2020-01-21 06:35:00 | AAPL | Stock | 79.1675 | 79.175 | 79.1675 | 79.175 | 800.0 |
| 2020-01-21 06:40:00 | AAPL | Stock | 79.2 | 79.285 | 79.2 | 79.285 | 3860.0 |
| 2020-01-21 06:45:00 | AAPL | Stock | 79.1925 | 79.1925 | 79.1925 | 79.1925 | 800.0 |
| 2020-01-21 06:55:00 | AAPL | Stock | 79.25 | 79.25 | 79.2475 | 79.25 | 3368.0 |
| 2020-01-21 07:00:00 | AAPL | Stock | 79.25 | 79.3725 | 79.225 | 79.325 | 63028.0 |
| 2020-01-21 07:05:00 | AAPL | Stock | 79.305 | 79.325 | 79.28 | 79.2925 | 60820.0 |
| 2020-01-21 07:10:00 | AAPL | Stock | 79.295 | 79.295 | 79.275 | 79.2775 | 7540.0 |
| 2020-01-21 07:15:00 | AAPL | Stock | 79.2825 | 79.2825 | 79.2575 | 79.265 | 5688.0 |
| 2020-01-21 07:20:00 | AAPL | Stock | 79.25 | 79.2625 | 79.225 | 79.225 | 33552.0 |
| 2020-01-21 07:25:00 | AAPL | Stock | 79.245 | 79.25 | 79.245 | 79.25 | 25548.0 |
| 2020-01-21 07:30:00 | AAPL | Stock | 79.26 | 79.29 | 79.2475 | 79.29 | 10192.0 |
| 2020-01-21 07:35:00 | AAPL | Stock | 79.2525 | 79.265 | 79.2425 | 79.25 | 26232.0 |
| 2020-01-21 07:40:00 | AAPL | Stock | 79.24 | 79.25 | 79.2125 | 79.2125 | 16116.0 |
| 2020-01-21 07:45:00 | AAPL | Stock | 79.2125 | 79.215 | 79.2025 | 79.2025 | 6780.0 |
| 2020-01-21 07:50:00 | AAPL | Stock | 79.2125 | 79.275 | 79.2125 | 79.27 | 15052.0 |
| 2020-01-21 07:55:00 | AAPL | Stock | 79.27 | 79.28 | 79.25 | 79.25 | 10124.0 |
| 2020-01-21 08:00:00 | AAPL | Stock | 79.3125 | 79.34 | 79.2025 | 79.2025 | 145192.0 |
| 2020-01-21 08:05:00 | AAPL | Stock | 79.215 | 79.275 | 79.215 | 79.255 | 16692.0 |
| 2020-01-21 08:10:00 | AAPL | Stock | 79.255 | 79.275 | 79.25 | 79.2625 | 26464.0 |
| 2020-01-21 08:15:00 | AAPL | Stock | 79.275 | 79.285 | 79.2125 | 79.2125 | 34548.0 |
| 2020-01-21 08:20:00 | AAPL | Stock | 79.225 | 79.2725 | 79.22 | 79.2325 | 32764.0 |
| 2020-01-21 08:25:00 | AAPL | Stock | 79.2475 | 79.3 | 79.2275 | 79.295 | 28516.0 |
| 2020-01-21 08:30:00 | AAPL | Stock | 79.2775 | 79.2775 | 79.2575 | 79.2775 | 12948.0 |
| 2020-01-21 08:35:00 | AAPL | Stock | 79.2625 | 79.275 | 79.2125 | 79.2225 | 40608.0 |
| 2020-01-21 08:40:00 | AAPL | Stock | 79.2125 | 79.2325 | 79.2 | 79.2225 | 24036.0 |
| 2020-01-21 08:45:00 | AAPL | Stock | 79.205 | 79.225 | 79.2025 | 79.225 | 36480.0 |
| 2020-01-21 08:50:00 | AAPL | Stock | 79.225 | 79.245 | 79.215 | 79.225 | 22928.0 |
| 2020-01-21 08:55:00 | AAPL | Stock | 79.225 | 79.225 | 79.195 | 79.2 | 30504.0 |
> showing 50 of 378,474 rows — these rows as CSV