PREVIEW / stock_5min / 2020-12-24
file: by_date/stock_5min/2020/2020-12-24.parquet size: 4.5 MB rows: 270,150 symbols: 2,659
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-24 04:00:00 | AAPL | Stock | 131.05 | 131.05 | 131.01 | 131.01 | 2578.0 |
| 2020-12-24 04:05:00 | AAPL | Stock | 131.0 | 131.05 | 131.0 | 131.01 | 1859.0 |
| 2020-12-24 04:10:00 | AAPL | Stock | 131.0 | 131.15 | 131.0 | 131.05 | 1926.0 |
| 2020-12-24 04:15:00 | AAPL | Stock | 131.05 | 131.05 | 131.05 | 131.05 | 430.0 |
| 2020-12-24 04:20:00 | AAPL | Stock | 131.05 | 131.1 | 131.01 | 131.01 | 902.0 |
| 2020-12-24 04:25:00 | AAPL | Stock | 131.03 | 131.03 | 131.0 | 131.0 | 950.0 |
| 2020-12-24 04:30:00 | AAPL | Stock | 131.0 | 131.0 | 131.0 | 131.0 | 1405.0 |
| 2020-12-24 04:35:00 | AAPL | Stock | 131.05 | 131.05 | 131.02 | 131.02 | 2500.0 |
| 2020-12-24 04:40:00 | AAPL | Stock | 131.09 | 131.09 | 131.09 | 131.09 | 200.0 |
| 2020-12-24 04:45:00 | AAPL | Stock | 131.0 | 131.0 | 131.0 | 131.0 | 178.0 |
| 2020-12-24 05:00:00 | AAPL | Stock | 131.01 | 131.02 | 131.0 | 131.02 | 834.0 |
| 2020-12-24 05:05:00 | AAPL | Stock | 131.0 | 131.0 | 131.0 | 131.0 | 109.0 |
| 2020-12-24 05:15:00 | AAPL | Stock | 131.01 | 131.01 | 131.0 | 131.0 | 588.0 |
| 2020-12-24 05:20:00 | AAPL | Stock | 131.05 | 131.05 | 131.05 | 131.05 | 100.0 |
| 2020-12-24 05:25:00 | AAPL | Stock | 131.04 | 131.05 | 131.04 | 131.05 | 350.0 |
| 2020-12-24 05:45:00 | AAPL | Stock | 130.9 | 130.9 | 130.8 | 130.8 | 3692.0 |
| 2020-12-24 05:50:00 | AAPL | Stock | 130.77 | 130.8 | 130.77 | 130.8 | 994.0 |
| 2020-12-24 05:55:00 | AAPL | Stock | 130.71 | 130.71 | 130.7 | 130.7 | 891.0 |
| 2020-12-24 06:00:00 | AAPL | Stock | 130.77 | 130.8 | 130.77 | 130.8 | 3778.0 |
| 2020-12-24 06:05:00 | AAPL | Stock | 130.8 | 130.8 | 130.7 | 130.7 | 5063.0 |
| 2020-12-24 06:15:00 | AAPL | Stock | 130.8 | 130.8 | 130.69 | 130.74 | 3287.0 |
| 2020-12-24 06:25:00 | AAPL | Stock | 130.82 | 130.82 | 130.82 | 130.82 | 600.0 |
| 2020-12-24 06:35:00 | AAPL | Stock | 130.98 | 130.98 | 130.93 | 130.93 | 640.0 |
| 2020-12-24 06:50:00 | AAPL | Stock | 130.96 | 130.96 | 130.9 | 130.9 | 520.0 |
| 2020-12-24 07:00:00 | AAPL | Stock | 131.0 | 131.05 | 130.93 | 131.0 | 30283.0 |
| 2020-12-24 07:05:00 | AAPL | Stock | 131.0 | 131.05 | 130.93 | 131.0 | 10026.0 |
| 2020-12-24 07:10:00 | AAPL | Stock | 131.0 | 131.05 | 130.98 | 131.0 | 14088.0 |
| 2020-12-24 07:15:00 | AAPL | Stock | 131.05 | 131.05 | 131.0 | 131.0 | 5054.0 |
| 2020-12-24 07:20:00 | AAPL | Stock | 131.03 | 131.03 | 130.98 | 131.0 | 6156.0 |
| 2020-12-24 07:25:00 | AAPL | Stock | 131.0 | 131.0 | 130.97 | 131.0 | 6143.0 |
| 2020-12-24 07:30:00 | AAPL | Stock | 131.0 | 131.0 | 130.97 | 130.99 | 6318.0 |
| 2020-12-24 07:35:00 | AAPL | Stock | 131.0 | 131.0 | 130.96 | 130.98 | 12749.0 |
| 2020-12-24 07:40:00 | AAPL | Stock | 130.98 | 131.1 | 130.98 | 131.03 | 17669.0 |
| 2020-12-24 07:45:00 | AAPL | Stock | 131.03 | 131.06 | 131.021 | 131.021 | 4309.0 |
| 2020-12-24 07:50:00 | AAPL | Stock | 131.05 | 131.07 | 131.04 | 131.04 | 7736.0 |
| 2020-12-24 07:55:00 | AAPL | Stock | 131.07 | 131.08 | 131.05 | 131.07 | 4120.0 |
| 2020-12-24 08:00:00 | AAPL | Stock | 131.05 | 131.1 | 130.9 | 131.07 | 81313.0 |
| 2020-12-24 08:05:00 | AAPL | Stock | 131.08 | 131.13 | 131.06 | 131.07 | 27825.0 |
| 2020-12-24 08:10:00 | AAPL | Stock | 131.09 | 131.1 | 131.07 | 131.08 | 15101.0 |
| 2020-12-24 08:15:00 | AAPL | Stock | 131.09 | 131.12 | 131.09 | 131.1 | 14509.0 |
| 2020-12-24 08:20:00 | AAPL | Stock | 131.1 | 131.12 | 131.07 | 131.1 | 22578.0 |
| 2020-12-24 08:25:00 | AAPL | Stock | 131.1 | 131.12 | 131.08 | 131.11 | 21807.0 |
| 2020-12-24 08:30:00 | AAPL | Stock | 131.09 | 131.11 | 131.01 | 131.05 | 27551.0 |
| 2020-12-24 08:35:00 | AAPL | Stock | 131.069 | 131.069 | 131.02 | 131.05 | 10679.0 |
| 2020-12-24 08:40:00 | AAPL | Stock | 131.04 | 131.1 | 131.0 | 131.07 | 31795.0 |
| 2020-12-24 08:45:00 | AAPL | Stock | 131.07 | 131.21 | 131.07 | 131.2 | 82316.0 |
| 2020-12-24 08:50:00 | AAPL | Stock | 131.2 | 131.46 | 131.18 | 131.43 | 46854.0 |
| 2020-12-24 08:55:00 | AAPL | Stock | 131.42 | 131.43 | 131.26 | 131.27 | 27902.0 |
| 2020-12-24 09:00:00 | AAPL | Stock | 131.28 | 131.4 | 131.17 | 131.3 | 23587.0 |
| 2020-12-24 09:05:00 | AAPL | Stock | 131.3 | 131.3 | 131.08 | 131.12 | 36914.0 |
> showing 50 of 270,150 rows — these rows as CSV