PREVIEW / stock_5min / 2020-01-15
file: by_date/stock_5min/2020/2020-01-15.parquet size: 6.0 MB rows: 372,383 symbols: 2,474
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-15 04:00:00 | AAPL | Stock | 77.9725 | 77.9725 | 77.875 | 77.875 | 14272.0 |
| 2020-01-15 04:05:00 | AAPL | Stock | 77.875 | 77.875 | 77.82 | 77.82 | 14316.0 |
| 2020-01-15 04:10:00 | AAPL | Stock | 77.82 | 77.82 | 77.72 | 77.725 | 13644.0 |
| 2020-01-15 04:15:00 | AAPL | Stock | 77.725 | 77.75 | 77.72 | 77.75 | 6396.0 |
| 2020-01-15 04:20:00 | AAPL | Stock | 77.755 | 77.755 | 77.75 | 77.75 | 1828.0 |
| 2020-01-15 04:25:00 | AAPL | Stock | 77.725 | 77.75 | 77.725 | 77.725 | 4492.0 |
| 2020-01-15 04:40:00 | AAPL | Stock | 77.825 | 77.86 | 77.825 | 77.86 | 4576.0 |
| 2020-01-15 04:45:00 | AAPL | Stock | 77.99 | 77.99 | 77.99 | 77.99 | 400.0 |
| 2020-01-15 04:50:00 | AAPL | Stock | 77.99 | 77.995 | 77.99 | 77.995 | 1300.0 |
| 2020-01-15 04:55:00 | AAPL | Stock | 77.89 | 77.89 | 77.89 | 77.89 | 400.0 |
| 2020-01-15 05:00:00 | AAPL | Stock | 77.8775 | 77.8775 | 77.875 | 77.875 | 2104.0 |
| 2020-01-15 05:05:00 | AAPL | Stock | 77.875 | 77.875 | 77.8 | 77.85 | 9584.0 |
| 2020-01-15 05:10:00 | AAPL | Stock | 77.85 | 77.85 | 77.85 | 77.85 | 4000.0 |
| 2020-01-15 05:15:00 | AAPL | Stock | 77.8875 | 77.995 | 77.8875 | 77.995 | 13436.0 |
| 2020-01-15 05:20:00 | AAPL | Stock | 77.9425 | 77.9425 | 77.9425 | 77.9425 | 400.0 |
| 2020-01-15 05:35:00 | AAPL | Stock | 77.97 | 77.9725 | 77.965 | 77.9725 | 10416.0 |
| 2020-01-15 05:50:00 | AAPL | Stock | 77.955 | 77.955 | 77.9125 | 77.9125 | 3420.0 |
| 2020-01-15 05:55:00 | AAPL | Stock | 77.9725 | 77.9725 | 77.9725 | 77.9725 | 1600.0 |
| 2020-01-15 06:00:00 | AAPL | Stock | 77.9725 | 77.9725 | 77.9725 | 77.9725 | 1200.0 |
| 2020-01-15 06:05:00 | AAPL | Stock | 77.9725 | 77.9725 | 77.9725 | 77.9725 | 400.0 |
| 2020-01-15 06:15:00 | AAPL | Stock | 77.97 | 77.97 | 77.97 | 77.97 | 400.0 |
| 2020-01-15 06:40:00 | AAPL | Stock | 77.9175 | 77.9725 | 77.9175 | 77.9725 | 3728.0 |
| 2020-01-15 06:45:00 | AAPL | Stock | 77.9875 | 77.9875 | 77.9375 | 77.9375 | 2532.0 |
| 2020-01-15 06:55:00 | AAPL | Stock | 77.98 | 77.9875 | 77.98 | 77.9875 | 4384.0 |
| 2020-01-15 07:00:00 | AAPL | Stock | 77.975 | 78.195 | 77.875 | 78.1425 | 78788.0 |
| 2020-01-15 07:05:00 | AAPL | Stock | 78.15 | 78.15 | 78.08 | 78.1125 | 28880.0 |
| 2020-01-15 07:10:00 | AAPL | Stock | 78.12 | 78.12 | 78.075 | 78.075 | 9824.0 |
| 2020-01-15 07:15:00 | AAPL | Stock | 78.11 | 78.175 | 78.11 | 78.175 | 17668.0 |
| 2020-01-15 07:20:00 | AAPL | Stock | 78.18 | 78.18 | 78.0525 | 78.0525 | 13476.0 |
| 2020-01-15 07:25:00 | AAPL | Stock | 78.05 | 78.0975 | 78.025 | 78.025 | 9420.0 |
| 2020-01-15 07:30:00 | AAPL | Stock | 78.0275 | 78.0275 | 78.0075 | 78.0125 | 19724.0 |
| 2020-01-15 07:35:00 | AAPL | Stock | 78.02 | 78.0525 | 78.02 | 78.05 | 10856.0 |
| 2020-01-15 07:40:00 | AAPL | Stock | 78.12 | 78.12 | 78.0875 | 78.09 | 3460.0 |
| 2020-01-15 07:45:00 | AAPL | Stock | 78.15 | 78.1875 | 78.1425 | 78.175 | 16508.0 |
| 2020-01-15 07:50:00 | AAPL | Stock | 78.1725 | 78.31 | 78.1725 | 78.31 | 44500.0 |
| 2020-01-15 07:55:00 | AAPL | Stock | 78.275 | 78.325 | 78.2525 | 78.2775 | 38560.0 |
| 2020-01-15 08:00:00 | AAPL | Stock | 78.285 | 78.3225 | 77.9175 | 78.3 | 203228.0 |
| 2020-01-15 08:05:00 | AAPL | Stock | 78.31 | 78.3475 | 78.2765 | 78.3475 | 60940.0 |
| 2020-01-15 08:10:00 | AAPL | Stock | 78.275 | 78.325 | 78.275 | 78.31 | 35540.0 |
| 2020-01-15 08:15:00 | AAPL | Stock | 78.3 | 78.3 | 78.235 | 78.235 | 58356.0 |
| 2020-01-15 08:20:00 | AAPL | Stock | 78.2375 | 78.2375 | 78.1875 | 78.2 | 49128.0 |
| 2020-01-15 08:25:00 | AAPL | Stock | 78.1875 | 78.2552 | 78.1875 | 78.2552 | 32452.0 |
| 2020-01-15 08:30:00 | AAPL | Stock | 78.2685 | 78.2925 | 78.1625 | 78.2125 | 70056.0 |
| 2020-01-15 08:35:00 | AAPL | Stock | 78.22 | 78.22 | 78.14 | 78.14 | 31408.0 |
| 2020-01-15 08:40:00 | AAPL | Stock | 78.1375 | 78.1725 | 78.065 | 78.11 | 59924.0 |
| 2020-01-15 08:45:00 | AAPL | Stock | 78.11 | 78.15 | 78.0625 | 78.0625 | 57744.0 |
| 2020-01-15 08:50:00 | AAPL | Stock | 78.06 | 78.0925 | 78.0275 | 78.07 | 33172.0 |
| 2020-01-15 08:55:00 | AAPL | Stock | 78.0725 | 78.0725 | 77.95 | 78.025 | 109088.0 |
| 2020-01-15 09:00:00 | AAPL | Stock | 78.0025 | 78.0375 | 77.9775 | 78.0325 | 57372.0 |
| 2020-01-15 09:05:00 | AAPL | Stock | 78.015 | 78.0325 | 77.9795 | 77.9795 | 45788.0 |
> showing 50 of 372,383 rows — these rows as CSV