PREVIEW / stock_5min / 2004-01-15
file: by_date/stock_5min/2004/2004-01-15.parquet size: 2.4 MB rows: 172,798 symbols: 1,708
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-15 08:00:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4089 | 0.4107 | 1006880.0 |
| 2004-01-15 08:05:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4107 | 0.4107 | 67200.0 |
| 2004-01-15 08:10:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4107 | 0.4107 | 173600.0 |
| 2004-01-15 08:15:00 | AAPL | Stock | 0.4107 | 0.4127 | 0.4107 | 0.4127 | 1226400.0 |
| 2004-01-15 08:20:00 | AAPL | Stock | 0.4129 | 0.413 | 0.4107 | 0.4107 | 291200.0 |
| 2004-01-15 08:25:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4107 | 0.4107 | 190400.0 |
| 2004-01-15 08:30:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4105 | 0.4105 | 547400.0 |
| 2004-01-15 08:35:00 | AAPL | Stock | 0.4105 | 0.4107 | 0.4089 | 0.4093 | 957600.0 |
| 2004-01-15 08:40:00 | AAPL | Stock | 0.4093 | 0.4107 | 0.4082 | 0.4089 | 602000.0 |
| 2004-01-15 08:45:00 | AAPL | Stock | 0.4086 | 0.4107 | 0.408 | 0.4089 | 705600.0 |
| 2004-01-15 08:50:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4093 | 0.4107 | 974400.0 |
| 2004-01-15 08:55:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4088 | 0.4089 | 476000.0 |
| 2004-01-15 09:00:00 | AAPL | Stock | 0.4088 | 0.4088 | 0.4071 | 0.4086 | 647360.0 |
| 2004-01-15 09:05:00 | AAPL | Stock | 0.408 | 0.4089 | 0.408 | 0.4083 | 935200.0 |
| 2004-01-15 09:10:00 | AAPL | Stock | 0.4091 | 0.4092 | 0.4086 | 0.4089 | 114240.0 |
| 2004-01-15 09:15:00 | AAPL | Stock | 0.4089 | 0.4091 | 0.4084 | 0.4084 | 1010912.0 |
| 2004-01-15 09:20:00 | AAPL | Stock | 0.4088 | 0.4107 | 0.4088 | 0.4095 | 294000.0 |
| 2004-01-15 09:25:00 | AAPL | Stock | 0.41 | 0.4107 | 0.4075 | 0.4089 | 3349920.0 |
| 2004-01-15 09:30:00 | AAPL | Stock | 0.4091 | 0.4127 | 0.408 | 0.4089 | 59624600.0 |
| 2004-01-15 09:35:00 | AAPL | Stock | 0.4088 | 0.4116 | 0.4086 | 0.4102 | 26400360.0 |
| 2004-01-15 09:40:00 | AAPL | Stock | 0.4102 | 0.4107 | 0.4064 | 0.4066 | 31151232.0 |
| 2004-01-15 09:45:00 | AAPL | Stock | 0.4066 | 0.4089 | 0.4048 | 0.4071 | 35060704.0 |
| 2004-01-15 09:50:00 | AAPL | Stock | 0.407 | 0.4086 | 0.4054 | 0.4059 | 21446488.0 |
| 2004-01-15 09:55:00 | AAPL | Stock | 0.4059 | 0.4071 | 0.4046 | 0.4048 | 25883144.0 |
| 2004-01-15 10:00:00 | AAPL | Stock | 0.4048 | 0.4052 | 0.4034 | 0.4036 | 20937056.0 |
| 2004-01-15 10:05:00 | AAPL | Stock | 0.4034 | 0.4036 | 0.4018 | 0.4022 | 24574312.0 |
| 2004-01-15 10:10:00 | AAPL | Stock | 0.4021 | 0.4032 | 0.4018 | 0.4029 | 16721712.0 |
| 2004-01-15 10:15:00 | AAPL | Stock | 0.4027 | 0.4029 | 0.4023 | 0.4027 | 10996328.0 |
| 2004-01-15 10:20:00 | AAPL | Stock | 0.4026 | 0.4046 | 0.4023 | 0.4039 | 12911696.0 |
| 2004-01-15 10:25:00 | AAPL | Stock | 0.4039 | 0.4061 | 0.4038 | 0.4046 | 16880528.0 |
| 2004-01-15 10:30:00 | AAPL | Stock | 0.4046 | 0.4054 | 0.4044 | 0.405 | 7557536.0 |
| 2004-01-15 10:35:00 | AAPL | Stock | 0.4048 | 0.405 | 0.4041 | 0.4048 | 5037592.0 |
| 2004-01-15 10:40:00 | AAPL | Stock | 0.405 | 0.4061 | 0.4048 | 0.4055 | 8900192.0 |
| 2004-01-15 10:45:00 | AAPL | Stock | 0.4055 | 0.4134 | 0.405 | 0.4132 | 50746080.0 |
| 2004-01-15 10:50:00 | AAPL | Stock | 0.4132 | 0.4134 | 0.4093 | 0.4111 | 45281096.0 |
| 2004-01-15 10:55:00 | AAPL | Stock | 0.4109 | 0.4114 | 0.41 | 0.4107 | 14780304.0 |
| 2004-01-15 11:00:00 | AAPL | Stock | 0.4105 | 0.4109 | 0.4077 | 0.408 | 12238184.0 |
| 2004-01-15 11:05:00 | AAPL | Stock | 0.4079 | 0.4089 | 0.4071 | 0.4086 | 11082176.0 |
| 2004-01-15 11:10:00 | AAPL | Stock | 0.4086 | 0.4089 | 0.4082 | 0.4088 | 8036504.0 |
| 2004-01-15 11:15:00 | AAPL | Stock | 0.4088 | 0.4091 | 0.4077 | 0.4082 | 7768656.0 |
| 2004-01-15 11:20:00 | AAPL | Stock | 0.408 | 0.41 | 0.4079 | 0.41 | 11094160.0 |
| 2004-01-15 11:25:00 | AAPL | Stock | 0.4102 | 0.4107 | 0.4086 | 0.4088 | 5085640.0 |
| 2004-01-15 11:30:00 | AAPL | Stock | 0.4089 | 0.4104 | 0.4086 | 0.4102 | 3798480.0 |
| 2004-01-15 11:35:00 | AAPL | Stock | 0.4102 | 0.4116 | 0.4102 | 0.4111 | 16362192.0 |
| 2004-01-15 11:40:00 | AAPL | Stock | 0.4111 | 0.4121 | 0.4109 | 0.4116 | 8321208.0 |
| 2004-01-15 11:45:00 | AAPL | Stock | 0.412 | 0.4132 | 0.4111 | 0.413 | 25115944.0 |
| 2004-01-15 11:50:00 | AAPL | Stock | 0.4127 | 0.4132 | 0.4125 | 0.413 | 10341632.0 |
| 2004-01-15 11:55:00 | AAPL | Stock | 0.413 | 0.4134 | 0.4125 | 0.4127 | 16007264.0 |
| 2004-01-15 12:00:00 | AAPL | Stock | 0.4127 | 0.4132 | 0.412 | 0.4127 | 17287032.0 |
| 2004-01-15 12:05:00 | AAPL | Stock | 0.4127 | 0.4141 | 0.4127 | 0.4132 | 11746336.0 |
> showing 50 of 172,798 rows — these rows as CSV