PREVIEW / stock_5min / 2004-01-29
file: by_date/stock_5min/2004/2004-01-29.parquet size: 2.5 MB rows: 177,057 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-29 08:00:00 | AAPL | Stock | 0.4036 | 0.4036 | 0.4036 | 0.4036 | 22400.0 |
| 2004-01-29 08:10:00 | AAPL | Stock | 0.4036 | 0.4059 | 0.4036 | 0.4059 | 69888.0 |
| 2004-01-29 08:15:00 | AAPL | Stock | 0.4032 | 0.4032 | 0.4032 | 0.4032 | 11200.0 |
| 2004-01-29 08:30:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 56000.0 |
| 2004-01-29 08:35:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 72800.0 |
| 2004-01-29 08:40:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 39200.0 |
| 2004-01-29 08:45:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 28000.0 |
| 2004-01-29 09:25:00 | AAPL | Stock | 0.4059 | 0.4063 | 0.4054 | 0.4057 | 392000.0 |
| 2004-01-29 09:30:00 | AAPL | Stock | 0.4041 | 0.4071 | 0.4036 | 0.4036 | 4178104.0 |
| 2004-01-29 09:35:00 | AAPL | Stock | 0.4041 | 0.4063 | 0.4036 | 0.4059 | 2643704.0 |
| 2004-01-29 09:40:00 | AAPL | Stock | 0.4057 | 0.4063 | 0.4038 | 0.4039 | 2082304.0 |
| 2004-01-29 09:45:00 | AAPL | Stock | 0.4039 | 0.4039 | 0.4021 | 0.4032 | 3043656.0 |
| 2004-01-29 09:50:00 | AAPL | Stock | 0.4032 | 0.4036 | 0.4016 | 0.4027 | 3329200.0 |
| 2004-01-29 09:55:00 | AAPL | Stock | 0.4029 | 0.4043 | 0.4023 | 0.4041 | 2893632.0 |
| 2004-01-29 10:00:00 | AAPL | Stock | 0.4041 | 0.4041 | 0.4025 | 0.403 | 3094112.0 |
| 2004-01-29 10:05:00 | AAPL | Stock | 0.403 | 0.4036 | 0.4005 | 0.4005 | 5111624.0 |
| 2004-01-29 10:10:00 | AAPL | Stock | 0.4005 | 0.4036 | 0.4004 | 0.4023 | 3907736.0 |
| 2004-01-29 10:15:00 | AAPL | Stock | 0.4024 | 0.4025 | 0.3996 | 0.4004 | 4635512.0 |
| 2004-01-29 10:20:00 | AAPL | Stock | 0.4002 | 0.402 | 0.3995 | 0.402 | 3696784.0 |
| 2004-01-29 10:25:00 | AAPL | Stock | 0.4021 | 0.4045 | 0.4009 | 0.4045 | 2919616.0 |
| 2004-01-29 10:30:00 | AAPL | Stock | 0.4045 | 0.4048 | 0.402 | 0.4025 | 2435496.0 |
| 2004-01-29 10:35:00 | AAPL | Stock | 0.4025 | 0.4057 | 0.4021 | 0.4054 | 2911104.0 |
| 2004-01-29 10:40:00 | AAPL | Stock | 0.4052 | 0.4059 | 0.4052 | 0.4059 | 2675176.0 |
| 2004-01-29 10:45:00 | AAPL | Stock | 0.4059 | 0.4059 | 0.4032 | 0.4032 | 2350376.0 |
| 2004-01-29 10:50:00 | AAPL | Stock | 0.4032 | 0.4039 | 0.4016 | 0.4021 | 3846864.0 |
| 2004-01-29 10:55:00 | AAPL | Stock | 0.4021 | 0.4025 | 0.4014 | 0.4023 | 472080.0 |
| 2004-01-29 11:00:00 | AAPL | Stock | 0.4025 | 0.4027 | 0.4007 | 0.4009 | 2468928.0 |
| 2004-01-29 11:05:00 | AAPL | Stock | 0.4011 | 0.4014 | 0.4 | 0.4013 | 4032448.0 |
| 2004-01-29 11:10:00 | AAPL | Stock | 0.4013 | 0.4016 | 0.4007 | 0.4007 | 1841112.0 |
| 2004-01-29 11:15:00 | AAPL | Stock | 0.4005 | 0.4021 | 0.4004 | 0.4016 | 2775024.0 |
| 2004-01-29 11:20:00 | AAPL | Stock | 0.4014 | 0.4018 | 0.4011 | 0.4018 | 1268680.0 |
| 2004-01-29 11:25:00 | AAPL | Stock | 0.4016 | 0.4016 | 0.4002 | 0.4009 | 1272880.0 |
| 2004-01-29 11:30:00 | AAPL | Stock | 0.4009 | 0.4016 | 0.4007 | 0.4009 | 1311128.0 |
| 2004-01-29 11:35:00 | AAPL | Stock | 0.4011 | 0.4014 | 0.3995 | 0.3995 | 3039680.0 |
| 2004-01-29 11:40:00 | AAPL | Stock | 0.3998 | 0.4011 | 0.3995 | 0.4007 | 886536.0 |
| 2004-01-29 11:45:00 | AAPL | Stock | 0.4006 | 0.4018 | 0.4002 | 0.4018 | 1380120.0 |
| 2004-01-29 11:50:00 | AAPL | Stock | 0.4018 | 0.4021 | 0.4013 | 0.4014 | 1328880.0 |
| 2004-01-29 11:55:00 | AAPL | Stock | 0.4014 | 0.4016 | 0.4 | 0.4005 | 988008.0 |
| 2004-01-29 12:00:00 | AAPL | Stock | 0.4005 | 0.4018 | 0.4005 | 0.4011 | 954800.0 |
| 2004-01-29 12:05:00 | AAPL | Stock | 0.4009 | 0.4013 | 0.4005 | 0.4009 | 881216.0 |
| 2004-01-29 12:10:00 | AAPL | Stock | 0.4009 | 0.4009 | 0.3993 | 0.4 | 1463616.0 |
| 2004-01-29 12:15:00 | AAPL | Stock | 0.4 | 0.4009 | 0.4 | 0.4 | 905912.0 |
| 2004-01-29 12:20:00 | AAPL | Stock | 0.4005 | 0.4005 | 0.3998 | 0.4002 | 702576.0 |
| 2004-01-29 12:25:00 | AAPL | Stock | 0.4004 | 0.4004 | 0.3998 | 0.4002 | 305032.0 |
| 2004-01-29 12:30:00 | AAPL | Stock | 0.4 | 0.4007 | 0.4 | 0.4007 | 473144.0 |
| 2004-01-29 12:35:00 | AAPL | Stock | 0.4002 | 0.4005 | 0.3995 | 0.3995 | 397600.0 |
| 2004-01-29 12:40:00 | AAPL | Stock | 0.3995 | 0.3995 | 0.3984 | 0.3988 | 1664544.0 |
| 2004-01-29 12:45:00 | AAPL | Stock | 0.3988 | 0.3996 | 0.3986 | 0.3986 | 701960.0 |
| 2004-01-29 12:50:00 | AAPL | Stock | 0.3986 | 0.4004 | 0.3986 | 0.4004 | 1586704.0 |
| 2004-01-29 12:55:00 | AAPL | Stock | 0.4007 | 0.4011 | 0.4004 | 0.4011 | 1114624.0 |
> showing 50 of 177,057 rows — these rows as CSV