PREVIEW / stock_5min / 2004-01-22
file: by_date/stock_5min/2004/2004-01-22.parquet size: 2.5 MB rows: 176,533 symbols: 1,716
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-22 08:25:00 | AAPL | Stock | 0.4038 | 0.4039 | 0.4 | 0.4 | 83272.0 |
| 2004-01-22 08:30:00 | AAPL | Stock | 0.4038 | 0.4038 | 0.4038 | 0.4038 | 11200.0 |
| 2004-01-22 09:00:00 | AAPL | Stock | 0.4036 | 0.4036 | 0.4036 | 0.4036 | 28000.0 |
| 2004-01-22 09:05:00 | AAPL | Stock | 0.4039 | 0.4039 | 0.4036 | 0.4036 | 22400.0 |
| 2004-01-22 09:10:00 | AAPL | Stock | 0.4041 | 0.4041 | 0.4041 | 0.4041 | 5600.0 |
| 2004-01-22 09:20:00 | AAPL | Stock | 0.4041 | 0.4041 | 0.4041 | 0.4041 | 11200.0 |
| 2004-01-22 09:25:00 | AAPL | Stock | 0.4045 | 0.4045 | 0.4041 | 0.4041 | 168000.0 |
| 2004-01-22 09:30:00 | AAPL | Stock | 0.4029 | 0.4054 | 0.4018 | 0.4052 | 3981264.0 |
| 2004-01-22 09:35:00 | AAPL | Stock | 0.4052 | 0.4077 | 0.4052 | 0.4077 | 4171216.0 |
| 2004-01-22 09:40:00 | AAPL | Stock | 0.4077 | 0.4077 | 0.4059 | 0.4066 | 4279912.0 |
| 2004-01-22 09:45:00 | AAPL | Stock | 0.4066 | 0.4068 | 0.4041 | 0.4043 | 5773880.0 |
| 2004-01-22 09:50:00 | AAPL | Stock | 0.4048 | 0.4061 | 0.4048 | 0.4052 | 1584912.0 |
| 2004-01-22 09:55:00 | AAPL | Stock | 0.4052 | 0.4054 | 0.4045 | 0.4045 | 2252880.0 |
| 2004-01-22 10:00:00 | AAPL | Stock | 0.4046 | 0.4048 | 0.4025 | 0.4025 | 4772264.0 |
| 2004-01-22 10:05:00 | AAPL | Stock | 0.4025 | 0.4025 | 0.4014 | 0.402 | 4399248.0 |
| 2004-01-22 10:10:00 | AAPL | Stock | 0.4018 | 0.4025 | 0.4014 | 0.4023 | 8639680.0 |
| 2004-01-22 10:15:00 | AAPL | Stock | 0.402 | 0.4041 | 0.4016 | 0.4038 | 5669216.0 |
| 2004-01-22 10:20:00 | AAPL | Stock | 0.4038 | 0.4038 | 0.4029 | 0.403 | 2434376.0 |
| 2004-01-22 10:25:00 | AAPL | Stock | 0.403 | 0.4032 | 0.4016 | 0.4018 | 2293816.0 |
| 2004-01-22 10:30:00 | AAPL | Stock | 0.4018 | 0.4023 | 0.4011 | 0.4011 | 4109392.0 |
| 2004-01-22 10:35:00 | AAPL | Stock | 0.4013 | 0.4023 | 0.4009 | 0.4021 | 2561328.0 |
| 2004-01-22 10:40:00 | AAPL | Stock | 0.4023 | 0.403 | 0.4016 | 0.4018 | 2335928.0 |
| 2004-01-22 10:45:00 | AAPL | Stock | 0.4021 | 0.4021 | 0.4011 | 0.4016 | 1709960.0 |
| 2004-01-22 10:50:00 | AAPL | Stock | 0.4016 | 0.4018 | 0.4011 | 0.4014 | 1875216.0 |
| 2004-01-22 10:55:00 | AAPL | Stock | 0.4014 | 0.4016 | 0.3997 | 0.4004 | 3603656.0 |
| 2004-01-22 11:00:00 | AAPL | Stock | 0.4004 | 0.4007 | 0.3988 | 0.3996 | 4254376.0 |
| 2004-01-22 11:05:00 | AAPL | Stock | 0.3995 | 0.4007 | 0.3991 | 0.4007 | 1982400.0 |
| 2004-01-22 11:10:00 | AAPL | Stock | 0.4005 | 0.4009 | 0.3996 | 0.4 | 1898400.0 |
| 2004-01-22 11:15:00 | AAPL | Stock | 0.4 | 0.4002 | 0.3988 | 0.3988 | 3160080.0 |
| 2004-01-22 11:20:00 | AAPL | Stock | 0.3988 | 0.3996 | 0.3988 | 0.3995 | 1349600.0 |
| 2004-01-22 11:25:00 | AAPL | Stock | 0.3995 | 0.3995 | 0.3991 | 0.3991 | 739200.0 |
| 2004-01-22 11:30:00 | AAPL | Stock | 0.3995 | 0.3995 | 0.3989 | 0.3993 | 1427440.0 |
| 2004-01-22 11:35:00 | AAPL | Stock | 0.3993 | 0.4009 | 0.3991 | 0.4005 | 2239888.0 |
| 2004-01-22 11:40:00 | AAPL | Stock | 0.4004 | 0.4007 | 0.4002 | 0.4005 | 691600.0 |
| 2004-01-22 11:45:00 | AAPL | Stock | 0.4004 | 0.4007 | 0.3998 | 0.4004 | 1015112.0 |
| 2004-01-22 11:50:00 | AAPL | Stock | 0.4002 | 0.4009 | 0.4 | 0.4007 | 1022000.0 |
| 2004-01-22 11:55:00 | AAPL | Stock | 0.4007 | 0.4007 | 0.4 | 0.4005 | 1123920.0 |
| 2004-01-22 12:00:00 | AAPL | Stock | 0.4004 | 0.4018 | 0.4004 | 0.4018 | 2060464.0 |
| 2004-01-22 12:05:00 | AAPL | Stock | 0.4018 | 0.402 | 0.4018 | 0.4018 | 1028944.0 |
| 2004-01-22 12:10:00 | AAPL | Stock | 0.4018 | 0.4025 | 0.4014 | 0.402 | 1502480.0 |
| 2004-01-22 12:15:00 | AAPL | Stock | 0.402 | 0.4021 | 0.4014 | 0.4018 | 634648.0 |
| 2004-01-22 12:20:00 | AAPL | Stock | 0.4014 | 0.4025 | 0.4014 | 0.402 | 1374688.0 |
| 2004-01-22 12:25:00 | AAPL | Stock | 0.402 | 0.402 | 0.4018 | 0.402 | 178472.0 |
| 2004-01-22 12:30:00 | AAPL | Stock | 0.402 | 0.4021 | 0.4018 | 0.4018 | 396592.0 |
| 2004-01-22 12:35:00 | AAPL | Stock | 0.4018 | 0.4034 | 0.4018 | 0.4034 | 3055080.0 |
| 2004-01-22 12:40:00 | AAPL | Stock | 0.4034 | 0.4034 | 0.4025 | 0.4032 | 1615096.0 |
| 2004-01-22 12:45:00 | AAPL | Stock | 0.403 | 0.4032 | 0.402 | 0.4023 | 852096.0 |
| 2004-01-22 12:50:00 | AAPL | Stock | 0.4023 | 0.4023 | 0.4012 | 0.4012 | 686000.0 |
| 2004-01-22 12:55:00 | AAPL | Stock | 0.4013 | 0.4016 | 0.4013 | 0.4014 | 457408.0 |
| 2004-01-22 13:00:00 | AAPL | Stock | 0.4014 | 0.4016 | 0.4013 | 0.4013 | 502488.0 |
> showing 50 of 176,533 rows — these rows as CSV