PREVIEW / stock_5min / 2020-12-28
file: by_date/stock_5min/2020/2020-12-28.parquet size: 7.7 MB rows: 483,798 symbols: 2,687
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-12-28 04:00:00 | AAPL | Stock | 132.72 | 132.99 | 132.72 | 132.89 | 2950.0 |
| 2020-12-28 04:05:00 | AAPL | Stock | 132.75 | 132.75 | 132.65 | 132.65 | 1770.0 |
| 2020-12-28 04:10:00 | AAPL | Stock | 132.62 | 132.8 | 132.62 | 132.8 | 1634.0 |
| 2020-12-28 04:15:00 | AAPL | Stock | 132.8 | 132.86 | 132.8 | 132.85 | 1276.0 |
| 2020-12-28 04:20:00 | AAPL | Stock | 132.8 | 132.83 | 132.6 | 132.6 | 1734.0 |
| 2020-12-28 04:25:00 | AAPL | Stock | 132.7 | 132.85 | 132.7 | 132.85 | 788.0 |
| 2020-12-28 04:30:00 | AAPL | Stock | 132.88 | 132.9 | 132.88 | 132.9 | 826.0 |
| 2020-12-28 04:35:00 | AAPL | Stock | 132.9 | 132.93 | 132.88 | 132.89 | 1422.0 |
| 2020-12-28 04:40:00 | AAPL | Stock | 132.86 | 132.99 | 132.84 | 132.99 | 1780.0 |
| 2020-12-28 04:45:00 | AAPL | Stock | 132.96 | 132.97 | 132.9 | 132.96 | 2478.0 |
| 2020-12-28 04:50:00 | AAPL | Stock | 133.0 | 133.0 | 132.96 | 132.96 | 2394.0 |
| 2020-12-28 04:55:00 | AAPL | Stock | 132.99 | 132.99 | 132.99 | 132.99 | 454.0 |
| 2020-12-28 05:00:00 | AAPL | Stock | 133.0 | 133.0 | 132.95 | 132.95 | 1624.0 |
| 2020-12-28 05:05:00 | AAPL | Stock | 132.95 | 133.0 | 132.95 | 132.98 | 3180.0 |
| 2020-12-28 05:10:00 | AAPL | Stock | 132.99 | 132.99 | 132.98 | 132.99 | 1236.0 |
| 2020-12-28 05:15:00 | AAPL | Stock | 132.98 | 133.0 | 132.96 | 133.0 | 792.0 |
| 2020-12-28 05:20:00 | AAPL | Stock | 132.99 | 132.99 | 132.99 | 132.99 | 100.0 |
| 2020-12-28 05:25:00 | AAPL | Stock | 133.0 | 133.0 | 132.67 | 132.67 | 5820.0 |
| 2020-12-28 05:30:00 | AAPL | Stock | 132.68 | 132.79 | 132.57 | 132.62 | 7188.0 |
| 2020-12-28 05:35:00 | AAPL | Stock | 132.68 | 132.68 | 132.6 | 132.6 | 905.0 |
| 2020-12-28 05:40:00 | AAPL | Stock | 132.88 | 132.88 | 132.62 | 132.65 | 3781.0 |
| 2020-12-28 05:45:00 | AAPL | Stock | 132.78 | 132.78 | 132.78 | 132.78 | 121.0 |
| 2020-12-28 05:50:00 | AAPL | Stock | 132.83 | 132.83 | 132.83 | 132.83 | 261.0 |
| 2020-12-28 05:55:00 | AAPL | Stock | 132.8 | 132.83 | 132.8 | 132.8 | 3546.0 |
| 2020-12-28 06:00:00 | AAPL | Stock | 132.87 | 132.87 | 132.75 | 132.75 | 1308.0 |
| 2020-12-28 06:05:00 | AAPL | Stock | 132.87 | 132.9 | 132.87 | 132.9 | 915.0 |
| 2020-12-28 06:10:00 | AAPL | Stock | 132.91 | 132.93 | 132.9 | 132.92 | 1540.0 |
| 2020-12-28 06:15:00 | AAPL | Stock | 132.9 | 132.92 | 132.78 | 132.78 | 900.0 |
| 2020-12-28 06:20:00 | AAPL | Stock | 132.81 | 132.86 | 132.81 | 132.86 | 558.0 |
| 2020-12-28 06:25:00 | AAPL | Stock | 132.92 | 132.92 | 132.92 | 132.92 | 100.0 |
| 2020-12-28 06:30:00 | AAPL | Stock | 132.9 | 132.9 | 132.9 | 132.9 | 332.0 |
| 2020-12-28 06:35:00 | AAPL | Stock | 132.93 | 132.95 | 132.93 | 132.95 | 1202.0 |
| 2020-12-28 06:40:00 | AAPL | Stock | 132.95 | 132.95 | 132.92 | 132.95 | 2894.0 |
| 2020-12-28 06:45:00 | AAPL | Stock | 132.9 | 132.91 | 132.9 | 132.91 | 827.0 |
| 2020-12-28 06:50:00 | AAPL | Stock | 132.92 | 132.99 | 132.92 | 132.98 | 844.0 |
| 2020-12-28 06:55:00 | AAPL | Stock | 132.87 | 132.87 | 132.87 | 132.87 | 197.0 |
| 2020-12-28 07:00:00 | AAPL | Stock | 132.88 | 133.25 | 132.81 | 133.19 | 127066.0 |
| 2020-12-28 07:05:00 | AAPL | Stock | 133.19 | 133.35 | 133.14 | 133.27 | 36162.0 |
| 2020-12-28 07:10:00 | AAPL | Stock | 133.3 | 133.6 | 133.3 | 133.54 | 54773.0 |
| 2020-12-28 07:15:00 | AAPL | Stock | 133.55 | 133.55 | 133.42 | 133.42 | 16437.0 |
| 2020-12-28 07:20:00 | AAPL | Stock | 133.41 | 133.45 | 133.34 | 133.38 | 15896.0 |
| 2020-12-28 07:25:00 | AAPL | Stock | 133.38 | 133.55 | 133.38 | 133.54 | 25083.0 |
| 2020-12-28 07:30:00 | AAPL | Stock | 133.55 | 133.64 | 133.51 | 133.58 | 16871.0 |
| 2020-12-28 07:35:00 | AAPL | Stock | 133.54 | 133.64 | 133.52 | 133.58 | 18646.0 |
| 2020-12-28 07:40:00 | AAPL | Stock | 133.59 | 133.63 | 133.58 | 133.6 | 15758.0 |
| 2020-12-28 07:45:00 | AAPL | Stock | 133.6 | 133.61 | 133.58 | 133.6 | 10253.0 |
| 2020-12-28 07:50:00 | AAPL | Stock | 133.59 | 133.59 | 133.53 | 133.55 | 4500.0 |
| 2020-12-28 07:55:00 | AAPL | Stock | 133.55 | 133.65 | 133.5 | 133.65 | 27134.0 |
| 2020-12-28 08:00:00 | AAPL | Stock | 133.18 | 133.69 | 132.915 | 133.64 | 279250.0 |
| 2020-12-28 08:05:00 | AAPL | Stock | 133.64 | 133.76 | 133.61 | 133.62 | 70224.0 |
> showing 50 of 483,798 rows — these rows as CSV