PREVIEW / stock_5min / 2020-06-01
file: by_date/stock_5min/2020/2020-06-01.parquet size: 6.5 MB rows: 410,268 symbols: 2,380
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-06-01 04:00:00 | AAPL | Stock | 79.75 | 79.75 | 79.75 | 79.75 | 784.0 |
| 2020-06-01 04:05:00 | AAPL | Stock | 79.275 | 79.275 | 79.1675 | 79.1675 | 2224.0 |
| 2020-06-01 04:10:00 | AAPL | Stock | 79.25 | 79.25 | 78.575 | 78.77 | 19012.0 |
| 2020-06-01 04:15:00 | AAPL | Stock | 78.955 | 79.005 | 78.9 | 79.0 | 17024.0 |
| 2020-06-01 04:20:00 | AAPL | Stock | 78.9275 | 78.9275 | 78.8275 | 78.8275 | 10116.0 |
| 2020-06-01 04:25:00 | AAPL | Stock | 78.83 | 79.0 | 78.83 | 79.0 | 1900.0 |
| 2020-06-01 04:30:00 | AAPL | Stock | 78.9875 | 78.9875 | 78.9875 | 78.9875 | 800.0 |
| 2020-06-01 04:35:00 | AAPL | Stock | 78.9375 | 78.9375 | 78.9375 | 78.9375 | 1160.0 |
| 2020-06-01 04:40:00 | AAPL | Stock | 79.075 | 79.075 | 79.075 | 79.075 | 400.0 |
| 2020-06-01 04:45:00 | AAPL | Stock | 79.15 | 79.15 | 79.15 | 79.15 | 800.0 |
| 2020-06-01 04:50:00 | AAPL | Stock | 79.1475 | 79.1475 | 79.125 | 79.125 | 4860.0 |
| 2020-06-01 05:00:00 | AAPL | Stock | 79.0875 | 79.0875 | 79.075 | 79.075 | 3140.0 |
| 2020-06-01 05:05:00 | AAPL | Stock | 79.25 | 79.25 | 79.25 | 79.25 | 400.0 |
| 2020-06-01 05:10:00 | AAPL | Stock | 79.1 | 79.1 | 79.1 | 79.1 | 400.0 |
| 2020-06-01 05:25:00 | AAPL | Stock | 79.1875 | 79.1875 | 79.1875 | 79.1875 | 400.0 |
| 2020-06-01 05:40:00 | AAPL | Stock | 79.125 | 79.125 | 79.125 | 79.125 | 680.0 |
| 2020-06-01 05:45:00 | AAPL | Stock | 79.13 | 79.13 | 78.95 | 79.0 | 9260.0 |
| 2020-06-01 06:00:00 | AAPL | Stock | 79.0 | 79.0 | 79.0 | 79.0 | 800.0 |
| 2020-06-01 06:05:00 | AAPL | Stock | 79.13 | 79.13 | 79.13 | 79.13 | 484.0 |
| 2020-06-01 06:10:00 | AAPL | Stock | 79.1375 | 79.1375 | 79.1375 | 79.1375 | 1200.0 |
| 2020-06-01 06:20:00 | AAPL | Stock | 79.245 | 79.3 | 79.245 | 79.3 | 1436.0 |
| 2020-06-01 06:25:00 | AAPL | Stock | 79.3 | 79.3 | 79.25 | 79.25 | 1212.0 |
| 2020-06-01 06:30:00 | AAPL | Stock | 79.25 | 79.25 | 78.95 | 79.085 | 4872.0 |
| 2020-06-01 06:40:00 | AAPL | Stock | 79.3425 | 79.3425 | 79.24 | 79.24 | 800.0 |
| 2020-06-01 06:50:00 | AAPL | Stock | 79.3325 | 79.3725 | 79.325 | 79.3725 | 2400.0 |
| 2020-06-01 06:55:00 | AAPL | Stock | 79.365 | 79.365 | 79.2775 | 79.2775 | 1200.0 |
| 2020-06-01 07:00:00 | AAPL | Stock | 79.35 | 79.595 | 79.3025 | 79.5 | 42216.0 |
| 2020-06-01 07:05:00 | AAPL | Stock | 79.5475 | 79.625 | 79.5 | 79.5 | 19048.0 |
| 2020-06-01 07:10:00 | AAPL | Stock | 79.55 | 79.5625 | 79.455 | 79.5625 | 28732.0 |
| 2020-06-01 07:15:00 | AAPL | Stock | 79.5275 | 79.5625 | 79.5 | 79.55 | 4516.0 |
| 2020-06-01 07:20:00 | AAPL | Stock | 79.5425 | 79.5425 | 79.4625 | 79.4925 | 23392.0 |
| 2020-06-01 07:25:00 | AAPL | Stock | 79.5 | 79.5 | 79.4675 | 79.4925 | 4796.0 |
| 2020-06-01 07:30:00 | AAPL | Stock | 79.495 | 79.4975 | 79.4525 | 79.4675 | 33740.0 |
| 2020-06-01 07:35:00 | AAPL | Stock | 79.47 | 79.475 | 79.455 | 79.46 | 3600.0 |
| 2020-06-01 07:40:00 | AAPL | Stock | 79.475 | 79.475 | 79.4375 | 79.4375 | 30576.0 |
| 2020-06-01 07:45:00 | AAPL | Stock | 79.4375 | 79.475 | 79.42 | 79.475 | 9072.0 |
| 2020-06-01 07:50:00 | AAPL | Stock | 79.4275 | 79.4275 | 79.35 | 79.35 | 20496.0 |
| 2020-06-01 07:55:00 | AAPL | Stock | 79.33 | 79.375 | 79.33 | 79.375 | 6492.0 |
| 2020-06-01 08:00:00 | AAPL | Stock | 79.55 | 79.625 | 79.315 | 79.3375 | 58728.0 |
| 2020-06-01 08:05:00 | AAPL | Stock | 79.3675 | 79.4625 | 79.3675 | 79.4475 | 12872.0 |
| 2020-06-01 08:10:00 | AAPL | Stock | 79.425 | 79.45 | 79.4075 | 79.4075 | 22068.0 |
| 2020-06-01 08:15:00 | AAPL | Stock | 79.4125 | 79.45 | 79.325 | 79.35 | 43100.0 |
| 2020-06-01 08:20:00 | AAPL | Stock | 79.37 | 79.4625 | 79.325 | 79.3775 | 52224.0 |
| 2020-06-01 08:25:00 | AAPL | Stock | 79.405 | 79.405 | 79.3125 | 79.3125 | 39184.0 |
| 2020-06-01 08:30:00 | AAPL | Stock | 79.315 | 79.425 | 79.2025 | 79.225 | 90000.0 |
| 2020-06-01 08:35:00 | AAPL | Stock | 79.225 | 79.2925 | 79.125 | 79.13 | 53408.0 |
| 2020-06-01 08:40:00 | AAPL | Stock | 79.1675 | 79.225 | 79.1525 | 79.225 | 21492.0 |
| 2020-06-01 08:45:00 | AAPL | Stock | 79.205 | 79.2725 | 79.1925 | 79.258 | 19668.0 |
| 2020-06-01 08:50:00 | AAPL | Stock | 79.2675 | 79.2725 | 79.195 | 79.23 | 30560.0 |
| 2020-06-01 08:55:00 | AAPL | Stock | 79.25 | 79.315 | 79.25 | 79.2875 | 7768.0 |
> showing 50 of 410,268 rows — these rows as CSV