PREVIEW / stock_5min / 2020-11-27
file: by_date/stock_5min/2020/2020-11-27.parquet size: 4.5 MB rows: 268,745 symbols: 2,578
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-11-27 04:00:00 | AAPL | Stock | 116.8 | 116.88 | 116.51 | 116.8 | 6145.0 |
| 2020-11-27 04:05:00 | AAPL | Stock | 116.8 | 116.8 | 116.62 | 116.65 | 617.0 |
| 2020-11-27 04:10:00 | AAPL | Stock | 116.65 | 116.7 | 116.65 | 116.7 | 300.0 |
| 2020-11-27 04:15:00 | AAPL | Stock | 116.7 | 116.79 | 116.7 | 116.79 | 1035.0 |
| 2020-11-27 04:20:00 | AAPL | Stock | 116.84 | 116.95 | 116.84 | 116.95 | 2019.0 |
| 2020-11-27 04:25:00 | AAPL | Stock | 116.95 | 116.95 | 116.89 | 116.89 | 424.0 |
| 2020-11-27 04:30:00 | AAPL | Stock | 116.92 | 116.92 | 116.81 | 116.81 | 611.0 |
| 2020-11-27 04:35:00 | AAPL | Stock | 116.84 | 116.85 | 116.84 | 116.85 | 3095.0 |
| 2020-11-27 04:40:00 | AAPL | Stock | 116.92 | 116.95 | 116.92 | 116.92 | 1300.0 |
| 2020-11-27 04:45:00 | AAPL | Stock | 116.95 | 116.98 | 116.91 | 116.98 | 1008.0 |
| 2020-11-27 04:50:00 | AAPL | Stock | 116.9 | 116.9 | 116.9 | 116.9 | 631.0 |
| 2020-11-27 04:55:00 | AAPL | Stock | 116.9 | 116.9 | 116.86 | 116.86 | 635.0 |
| 2020-11-27 05:00:00 | AAPL | Stock | 116.8 | 116.83 | 116.8 | 116.83 | 431.0 |
| 2020-11-27 05:05:00 | AAPL | Stock | 116.81 | 116.81 | 116.77 | 116.77 | 1063.0 |
| 2020-11-27 05:10:00 | AAPL | Stock | 116.83 | 116.83 | 116.83 | 116.83 | 454.0 |
| 2020-11-27 05:15:00 | AAPL | Stock | 116.8 | 116.8 | 116.8 | 116.8 | 150.0 |
| 2020-11-27 05:20:00 | AAPL | Stock | 116.77 | 116.77 | 116.77 | 116.77 | 177.0 |
| 2020-11-27 05:30:00 | AAPL | Stock | 116.74 | 116.77 | 116.74 | 116.77 | 436.0 |
| 2020-11-27 05:35:00 | AAPL | Stock | 116.84 | 116.84 | 116.84 | 116.84 | 128.0 |
| 2020-11-27 05:40:00 | AAPL | Stock | 116.83 | 116.83 | 116.74 | 116.74 | 635.0 |
| 2020-11-27 05:45:00 | AAPL | Stock | 116.79 | 116.79 | 116.79 | 116.79 | 157.0 |
| 2020-11-27 05:50:00 | AAPL | Stock | 116.76 | 116.76 | 116.76 | 116.76 | 100.0 |
| 2020-11-27 05:55:00 | AAPL | Stock | 116.84 | 116.87 | 116.84 | 116.87 | 650.0 |
| 2020-11-27 06:00:00 | AAPL | Stock | 116.9 | 116.9 | 116.9 | 116.9 | 124.0 |
| 2020-11-27 06:05:00 | AAPL | Stock | 116.9 | 116.94 | 116.9 | 116.9 | 533.0 |
| 2020-11-27 06:10:00 | AAPL | Stock | 116.94 | 116.98 | 116.94 | 116.96 | 2680.0 |
| 2020-11-27 06:15:00 | AAPL | Stock | 116.9 | 116.9 | 116.9 | 116.9 | 195.0 |
| 2020-11-27 06:25:00 | AAPL | Stock | 116.83 | 116.94 | 116.83 | 116.94 | 659.0 |
| 2020-11-27 06:45:00 | AAPL | Stock | 116.84 | 116.9 | 116.84 | 116.9 | 1699.0 |
| 2020-11-27 06:50:00 | AAPL | Stock | 116.84 | 116.85 | 116.84 | 116.84 | 2223.0 |
| 2020-11-27 06:55:00 | AAPL | Stock | 116.84 | 116.9 | 116.84 | 116.89 | 779.0 |
| 2020-11-27 07:00:00 | AAPL | Stock | 116.86 | 116.96 | 116.74 | 116.75 | 23844.0 |
| 2020-11-27 07:05:00 | AAPL | Stock | 116.79 | 116.85 | 116.77 | 116.77 | 9559.0 |
| 2020-11-27 07:10:00 | AAPL | Stock | 116.81 | 116.89 | 116.81 | 116.82 | 4174.0 |
| 2020-11-27 07:15:00 | AAPL | Stock | 116.82 | 116.82 | 116.8 | 116.8 | 3298.0 |
| 2020-11-27 07:20:00 | AAPL | Stock | 116.79 | 116.8 | 116.77 | 116.77 | 5538.0 |
| 2020-11-27 07:25:00 | AAPL | Stock | 116.78 | 116.78 | 116.76 | 116.78 | 3242.0 |
| 2020-11-27 07:30:00 | AAPL | Stock | 116.76 | 116.76 | 116.63 | 116.63 | 3755.0 |
| 2020-11-27 07:35:00 | AAPL | Stock | 116.65 | 116.75 | 116.6 | 116.63 | 26599.0 |
| 2020-11-27 07:40:00 | AAPL | Stock | 116.64 | 116.67 | 116.64 | 116.67 | 5822.0 |
| 2020-11-27 07:45:00 | AAPL | Stock | 116.68 | 116.79 | 116.68 | 116.77 | 18305.0 |
| 2020-11-27 07:50:00 | AAPL | Stock | 116.77 | 116.8 | 116.7 | 116.7 | 13656.0 |
| 2020-11-27 07:55:00 | AAPL | Stock | 116.72 | 116.75 | 116.68 | 116.7 | 8801.0 |
| 2020-11-27 08:00:00 | AAPL | Stock | 116.74 | 116.96 | 116.6 | 116.746 | 109779.0 |
| 2020-11-27 08:05:00 | AAPL | Stock | 116.75 | 116.8 | 116.7 | 116.77 | 15575.0 |
| 2020-11-27 08:10:00 | AAPL | Stock | 116.75 | 116.79 | 116.71 | 116.74 | 11179.0 |
| 2020-11-27 08:15:00 | AAPL | Stock | 116.74 | 116.75 | 116.71 | 116.73 | 7920.0 |
| 2020-11-27 08:20:00 | AAPL | Stock | 116.72 | 116.76 | 116.72 | 116.76 | 10206.0 |
| 2020-11-27 08:25:00 | AAPL | Stock | 116.77 | 116.8 | 116.75 | 116.75 | 10090.0 |
| 2020-11-27 08:30:00 | AAPL | Stock | 116.77 | 116.79 | 116.76 | 116.78 | 12480.0 |
> showing 50 of 268,745 rows — these rows as CSV