PREVIEW / stock_5min / 2004-01-21
file: by_date/stock_5min/2004/2004-01-21.parquet size: 2.5 MB rows: 175,196 symbols: 1,720
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-21 08:00:00 | AAPL | Stock | 0.4061 | 0.4061 | 0.4061 | 0.4061 | 56000.0 |
| 2004-01-21 08:05:00 | AAPL | Stock | 0.4069 | 0.4069 | 0.4063 | 0.4063 | 1215200.0 |
| 2004-01-21 08:10:00 | AAPL | Stock | 0.4059 | 0.4059 | 0.4059 | 0.4059 | 28000.0 |
| 2004-01-21 08:25:00 | AAPL | Stock | 0.405 | 0.4054 | 0.405 | 0.4054 | 84000.0 |
| 2004-01-21 09:05:00 | AAPL | Stock | 0.4041 | 0.4046 | 0.4041 | 0.4046 | 84000.0 |
| 2004-01-21 09:10:00 | AAPL | Stock | 0.4041 | 0.4046 | 0.4041 | 0.4046 | 39200.0 |
| 2004-01-21 09:20:00 | AAPL | Stock | 0.4038 | 0.4038 | 0.4038 | 0.4038 | 5600.0 |
| 2004-01-21 09:25:00 | AAPL | Stock | 0.4045 | 0.4054 | 0.4045 | 0.4048 | 268800.0 |
| 2004-01-21 09:30:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4007 | 0.4009 | 8952384.0 |
| 2004-01-21 09:35:00 | AAPL | Stock | 0.4007 | 0.4013 | 0.4005 | 0.4005 | 3619728.0 |
| 2004-01-21 09:40:00 | AAPL | Stock | 0.4005 | 0.402 | 0.4005 | 0.4016 | 2982112.0 |
| 2004-01-21 09:45:00 | AAPL | Stock | 0.4018 | 0.402 | 0.4009 | 0.4014 | 4491984.0 |
| 2004-01-21 09:50:00 | AAPL | Stock | 0.4016 | 0.4017 | 0.4014 | 0.4014 | 1880088.0 |
| 2004-01-21 09:55:00 | AAPL | Stock | 0.4013 | 0.4014 | 0.4011 | 0.4014 | 1591800.0 |
| 2004-01-21 10:00:00 | AAPL | Stock | 0.4013 | 0.4016 | 0.4013 | 0.4014 | 2906008.0 |
| 2004-01-21 10:05:00 | AAPL | Stock | 0.4014 | 0.4016 | 0.4014 | 0.4014 | 2794008.0 |
| 2004-01-21 10:10:00 | AAPL | Stock | 0.4016 | 0.4025 | 0.4014 | 0.4023 | 2850064.0 |
| 2004-01-21 10:15:00 | AAPL | Stock | 0.4025 | 0.4038 | 0.4025 | 0.4037 | 3538136.0 |
| 2004-01-21 10:20:00 | AAPL | Stock | 0.4039 | 0.405 | 0.4032 | 0.4032 | 3383912.0 |
| 2004-01-21 10:25:00 | AAPL | Stock | 0.4034 | 0.4034 | 0.4013 | 0.4018 | 2370312.0 |
| 2004-01-21 10:30:00 | AAPL | Stock | 0.4018 | 0.4032 | 0.4018 | 0.4029 | 1593760.0 |
| 2004-01-21 10:35:00 | AAPL | Stock | 0.4029 | 0.4031 | 0.4018 | 0.403 | 2617272.0 |
| 2004-01-21 10:40:00 | AAPL | Stock | 0.4027 | 0.4041 | 0.4027 | 0.4039 | 1836240.0 |
| 2004-01-21 10:45:00 | AAPL | Stock | 0.4038 | 0.4039 | 0.4036 | 0.4036 | 1746808.0 |
| 2004-01-21 10:50:00 | AAPL | Stock | 0.4038 | 0.4046 | 0.4036 | 0.4046 | 1491672.0 |
| 2004-01-21 10:55:00 | AAPL | Stock | 0.4048 | 0.4054 | 0.4045 | 0.4048 | 3243744.0 |
| 2004-01-21 11:00:00 | AAPL | Stock | 0.4046 | 0.4054 | 0.4046 | 0.4048 | 3673768.0 |
| 2004-01-21 11:05:00 | AAPL | Stock | 0.405 | 0.4052 | 0.4036 | 0.4038 | 3445008.0 |
| 2004-01-21 11:10:00 | AAPL | Stock | 0.4041 | 0.4046 | 0.4034 | 0.4034 | 5006120.0 |
| 2004-01-21 11:15:00 | AAPL | Stock | 0.4036 | 0.4041 | 0.4034 | 0.4034 | 1866928.0 |
| 2004-01-21 11:20:00 | AAPL | Stock | 0.4034 | 0.4038 | 0.4032 | 0.4032 | 1767920.0 |
| 2004-01-21 11:25:00 | AAPL | Stock | 0.4032 | 0.4048 | 0.4029 | 0.4038 | 2102912.0 |
| 2004-01-21 11:30:00 | AAPL | Stock | 0.4039 | 0.405 | 0.4032 | 0.4048 | 1468600.0 |
| 2004-01-21 11:35:00 | AAPL | Stock | 0.405 | 0.405 | 0.4032 | 0.4038 | 1122296.0 |
| 2004-01-21 11:40:00 | AAPL | Stock | 0.4038 | 0.4039 | 0.403 | 0.4034 | 1002400.0 |
| 2004-01-21 11:45:00 | AAPL | Stock | 0.4034 | 0.4038 | 0.4034 | 0.4036 | 798280.0 |
| 2004-01-21 11:50:00 | AAPL | Stock | 0.4036 | 0.4038 | 0.4032 | 0.4038 | 1205568.0 |
| 2004-01-21 11:55:00 | AAPL | Stock | 0.4038 | 0.4039 | 0.4032 | 0.4036 | 2704352.0 |
| 2004-01-21 12:00:00 | AAPL | Stock | 0.4036 | 0.4048 | 0.4034 | 0.4045 | 3635072.0 |
| 2004-01-21 12:05:00 | AAPL | Stock | 0.4041 | 0.4045 | 0.4039 | 0.4039 | 1561000.0 |
| 2004-01-21 12:10:00 | AAPL | Stock | 0.4039 | 0.4041 | 0.4039 | 0.4039 | 818272.0 |
| 2004-01-21 12:15:00 | AAPL | Stock | 0.4039 | 0.4041 | 0.4036 | 0.4038 | 738304.0 |
| 2004-01-21 12:20:00 | AAPL | Stock | 0.4038 | 0.4052 | 0.4038 | 0.405 | 4545576.0 |
| 2004-01-21 12:25:00 | AAPL | Stock | 0.4052 | 0.4052 | 0.4043 | 0.4045 | 1085896.0 |
| 2004-01-21 12:30:00 | AAPL | Stock | 0.4043 | 0.405 | 0.4039 | 0.4043 | 1795192.0 |
| 2004-01-21 12:35:00 | AAPL | Stock | 0.4045 | 0.4046 | 0.4036 | 0.4039 | 783496.0 |
| 2004-01-21 12:40:00 | AAPL | Stock | 0.4039 | 0.4043 | 0.4038 | 0.4041 | 613424.0 |
| 2004-01-21 12:45:00 | AAPL | Stock | 0.4041 | 0.4045 | 0.4036 | 0.4038 | 1241240.0 |
| 2004-01-21 12:50:00 | AAPL | Stock | 0.4041 | 0.4041 | 0.4034 | 0.4034 | 914144.0 |
| 2004-01-21 12:55:00 | AAPL | Stock | 0.4036 | 0.4039 | 0.4032 | 0.4039 | 571536.0 |
> showing 50 of 175,196 rows — these rows as CSV