PREVIEW / stock_5min / 2004-01-23
file: by_date/stock_5min/2004/2004-01-23.parquet size: 2.5 MB rows: 172,571 symbols: 1,715
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-23 08:05:00 | AAPL | Stock | 0.4052 | 0.4052 | 0.4052 | 0.4052 | 56000.0 |
| 2004-01-23 09:10:00 | AAPL | Stock | 0.3982 | 0.3982 | 0.3973 | 0.3973 | 123200.0 |
| 2004-01-23 09:20:00 | AAPL | Stock | 0.3975 | 0.3975 | 0.3975 | 0.3975 | 11200.0 |
| 2004-01-23 09:25:00 | AAPL | Stock | 0.3975 | 0.3995 | 0.3973 | 0.3995 | 196000.0 |
| 2004-01-23 09:30:00 | AAPL | Stock | 0.4004 | 0.4013 | 0.3984 | 0.4 | 4491984.0 |
| 2004-01-23 09:35:00 | AAPL | Stock | 0.4 | 0.4 | 0.3982 | 0.3986 | 4903248.0 |
| 2004-01-23 09:40:00 | AAPL | Stock | 0.3989 | 0.4014 | 0.3984 | 0.4009 | 4173568.0 |
| 2004-01-23 09:45:00 | AAPL | Stock | 0.4009 | 0.4027 | 0.4005 | 0.4013 | 4372312.0 |
| 2004-01-23 09:50:00 | AAPL | Stock | 0.4018 | 0.4018 | 0.4005 | 0.4018 | 2648688.0 |
| 2004-01-23 09:55:00 | AAPL | Stock | 0.4018 | 0.4018 | 0.4 | 0.4002 | 3915240.0 |
| 2004-01-23 10:00:00 | AAPL | Stock | 0.4 | 0.4005 | 0.3998 | 0.4004 | 1855392.0 |
| 2004-01-23 10:05:00 | AAPL | Stock | 0.4002 | 0.4032 | 0.4002 | 0.4028 | 4446064.0 |
| 2004-01-23 10:10:00 | AAPL | Stock | 0.4029 | 0.4036 | 0.4027 | 0.4027 | 3103296.0 |
| 2004-01-23 10:15:00 | AAPL | Stock | 0.4029 | 0.4036 | 0.4025 | 0.403 | 2167368.0 |
| 2004-01-23 10:20:00 | AAPL | Stock | 0.403 | 0.4052 | 0.403 | 0.4045 | 4241888.0 |
| 2004-01-23 10:25:00 | AAPL | Stock | 0.4046 | 0.4046 | 0.4038 | 0.4041 | 1466416.0 |
| 2004-01-23 10:30:00 | AAPL | Stock | 0.4038 | 0.4059 | 0.4038 | 0.4052 | 4054680.0 |
| 2004-01-23 10:35:00 | AAPL | Stock | 0.4048 | 0.4061 | 0.4046 | 0.4055 | 6111280.0 |
| 2004-01-23 10:40:00 | AAPL | Stock | 0.4055 | 0.4057 | 0.405 | 0.4052 | 1471064.0 |
| 2004-01-23 10:45:00 | AAPL | Stock | 0.4052 | 0.4054 | 0.4038 | 0.4045 | 2336880.0 |
| 2004-01-23 10:50:00 | AAPL | Stock | 0.4048 | 0.4054 | 0.4039 | 0.4043 | 2630768.0 |
| 2004-01-23 10:55:00 | AAPL | Stock | 0.4043 | 0.4043 | 0.403 | 0.4036 | 2066568.0 |
| 2004-01-23 11:00:00 | AAPL | Stock | 0.4036 | 0.4036 | 0.4027 | 0.4027 | 660016.0 |
| 2004-01-23 11:05:00 | AAPL | Stock | 0.4027 | 0.4036 | 0.4027 | 0.4034 | 1945496.0 |
| 2004-01-23 11:10:00 | AAPL | Stock | 0.4034 | 0.4036 | 0.4032 | 0.4036 | 2071608.0 |
| 2004-01-23 11:15:00 | AAPL | Stock | 0.4034 | 0.4036 | 0.4027 | 0.4027 | 1182720.0 |
| 2004-01-23 11:20:00 | AAPL | Stock | 0.403 | 0.403 | 0.402 | 0.4021 | 1297576.0 |
| 2004-01-23 11:25:00 | AAPL | Stock | 0.4025 | 0.4025 | 0.4014 | 0.4014 | 3833200.0 |
| 2004-01-23 11:30:00 | AAPL | Stock | 0.4014 | 0.4018 | 0.4013 | 0.4013 | 1125656.0 |
| 2004-01-23 11:35:00 | AAPL | Stock | 0.4013 | 0.4018 | 0.4009 | 0.4018 | 1646400.0 |
| 2004-01-23 11:40:00 | AAPL | Stock | 0.4018 | 0.4034 | 0.4018 | 0.4032 | 3307024.0 |
| 2004-01-23 11:45:00 | AAPL | Stock | 0.4034 | 0.4036 | 0.4027 | 0.4027 | 1410528.0 |
| 2004-01-23 11:50:00 | AAPL | Stock | 0.4025 | 0.4036 | 0.4023 | 0.4036 | 3034696.0 |
| 2004-01-23 11:55:00 | AAPL | Stock | 0.4036 | 0.4041 | 0.4034 | 0.4034 | 4284056.0 |
| 2004-01-23 12:00:00 | AAPL | Stock | 0.4032 | 0.4041 | 0.4023 | 0.4036 | 2769368.0 |
| 2004-01-23 12:05:00 | AAPL | Stock | 0.403 | 0.4036 | 0.4025 | 0.4032 | 3749760.0 |
| 2004-01-23 12:10:00 | AAPL | Stock | 0.403 | 0.4043 | 0.403 | 0.4043 | 5033112.0 |
| 2004-01-23 12:15:00 | AAPL | Stock | 0.4041 | 0.405 | 0.4039 | 0.4046 | 2393272.0 |
| 2004-01-23 12:20:00 | AAPL | Stock | 0.4048 | 0.4048 | 0.4032 | 0.4036 | 2338896.0 |
| 2004-01-23 12:25:00 | AAPL | Stock | 0.4032 | 0.4041 | 0.403 | 0.4041 | 4122832.0 |
| 2004-01-23 12:30:00 | AAPL | Stock | 0.4043 | 0.4048 | 0.4009 | 0.4011 | 3062696.0 |
| 2004-01-23 12:35:00 | AAPL | Stock | 0.4011 | 0.4038 | 0.4011 | 0.4038 | 2105544.0 |
| 2004-01-23 12:40:00 | AAPL | Stock | 0.4038 | 0.4045 | 0.4036 | 0.4039 | 1546664.0 |
| 2004-01-23 12:45:00 | AAPL | Stock | 0.4045 | 0.4046 | 0.4036 | 0.4038 | 1758400.0 |
| 2004-01-23 12:50:00 | AAPL | Stock | 0.4039 | 0.4041 | 0.4027 | 0.4027 | 2301712.0 |
| 2004-01-23 12:55:00 | AAPL | Stock | 0.4027 | 0.403 | 0.4023 | 0.4023 | 1175384.0 |
| 2004-01-23 13:00:00 | AAPL | Stock | 0.4029 | 0.4032 | 0.4025 | 0.4025 | 1020880.0 |
| 2004-01-23 13:05:00 | AAPL | Stock | 0.4025 | 0.4029 | 0.4023 | 0.4025 | 729400.0 |
| 2004-01-23 13:10:00 | AAPL | Stock | 0.4025 | 0.4032 | 0.4025 | 0.4029 | 820120.0 |
| 2004-01-23 13:15:00 | AAPL | Stock | 0.4025 | 0.4034 | 0.4025 | 0.403 | 431200.0 |
> showing 50 of 172,571 rows — these rows as CSV