PREVIEW / stock_5min / 2004-01-08
file: by_date/stock_5min/2004/2004-01-08.parquet size: 2.4 MB rows: 174,568 symbols: 1,713
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-08 08:30:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 280000.0 |
| 2004-01-08 08:35:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 28000.0 |
| 2004-01-08 08:50:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 196000.0 |
| 2004-01-08 08:55:00 | AAPL | Stock | 0.4055 | 0.4055 | 0.4054 | 0.4054 | 56000.0 |
| 2004-01-08 09:00:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 28000.0 |
| 2004-01-08 09:05:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 16800.0 |
| 2004-01-08 09:15:00 | AAPL | Stock | 0.4052 | 0.4054 | 0.4052 | 0.4054 | 196000.0 |
| 2004-01-08 09:20:00 | AAPL | Stock | 0.4057 | 0.4059 | 0.4057 | 0.4059 | 224000.0 |
| 2004-01-08 09:25:00 | AAPL | Stock | 0.4063 | 0.4073 | 0.4063 | 0.4073 | 1405600.0 |
| 2004-01-08 09:30:00 | AAPL | Stock | 0.4075 | 0.4077 | 0.4055 | 0.4061 | 15334088.0 |
| 2004-01-08 09:35:00 | AAPL | Stock | 0.4061 | 0.4098 | 0.4059 | 0.4092 | 8755936.0 |
| 2004-01-08 09:40:00 | AAPL | Stock | 0.4096 | 0.4134 | 0.4089 | 0.4123 | 22212680.0 |
| 2004-01-08 09:45:00 | AAPL | Stock | 0.4125 | 0.4132 | 0.4114 | 0.4127 | 8937320.0 |
| 2004-01-08 09:50:00 | AAPL | Stock | 0.4127 | 0.4127 | 0.4107 | 0.4118 | 6094368.0 |
| 2004-01-08 09:55:00 | AAPL | Stock | 0.4118 | 0.4143 | 0.4118 | 0.4134 | 11257736.0 |
| 2004-01-08 10:00:00 | AAPL | Stock | 0.4132 | 0.4139 | 0.4131 | 0.4136 | 3287704.0 |
| 2004-01-08 10:05:00 | AAPL | Stock | 0.4136 | 0.4141 | 0.4132 | 0.4134 | 6963824.0 |
| 2004-01-08 10:10:00 | AAPL | Stock | 0.4134 | 0.4141 | 0.4125 | 0.4132 | 4888184.0 |
| 2004-01-08 10:15:00 | AAPL | Stock | 0.4129 | 0.4136 | 0.4084 | 0.4086 | 5968592.0 |
| 2004-01-08 10:20:00 | AAPL | Stock | 0.4086 | 0.4109 | 0.4086 | 0.4107 | 6376104.0 |
| 2004-01-08 10:25:00 | AAPL | Stock | 0.4111 | 0.4111 | 0.4095 | 0.4107 | 6682368.0 |
| 2004-01-08 10:30:00 | AAPL | Stock | 0.4107 | 0.4109 | 0.41 | 0.4104 | 5754000.0 |
| 2004-01-08 10:35:00 | AAPL | Stock | 0.4102 | 0.4107 | 0.4096 | 0.4102 | 3960320.0 |
| 2004-01-08 10:40:00 | AAPL | Stock | 0.4104 | 0.4105 | 0.41 | 0.4105 | 6049512.0 |
| 2004-01-08 10:45:00 | AAPL | Stock | 0.4104 | 0.4113 | 0.4098 | 0.4109 | 4076464.0 |
| 2004-01-08 10:50:00 | AAPL | Stock | 0.41 | 0.4116 | 0.41 | 0.4109 | 1775760.0 |
| 2004-01-08 10:55:00 | AAPL | Stock | 0.4113 | 0.4113 | 0.4109 | 0.4111 | 1766520.0 |
| 2004-01-08 11:00:00 | AAPL | Stock | 0.411 | 0.4111 | 0.4107 | 0.4109 | 1216040.0 |
| 2004-01-08 11:05:00 | AAPL | Stock | 0.4109 | 0.4109 | 0.41 | 0.41 | 1040536.0 |
| 2004-01-08 11:10:00 | AAPL | Stock | 0.4099 | 0.4102 | 0.4098 | 0.41 | 2393496.0 |
| 2004-01-08 11:15:00 | AAPL | Stock | 0.41 | 0.4111 | 0.41 | 0.4107 | 1901144.0 |
| 2004-01-08 11:20:00 | AAPL | Stock | 0.4109 | 0.4116 | 0.4107 | 0.4113 | 1441440.0 |
| 2004-01-08 11:25:00 | AAPL | Stock | 0.4113 | 0.4113 | 0.4107 | 0.4109 | 1268008.0 |
| 2004-01-08 11:30:00 | AAPL | Stock | 0.4107 | 0.4113 | 0.4102 | 0.4105 | 2239216.0 |
| 2004-01-08 11:35:00 | AAPL | Stock | 0.4105 | 0.4121 | 0.4104 | 0.4121 | 4876648.0 |
| 2004-01-08 11:40:00 | AAPL | Stock | 0.4123 | 0.4126 | 0.4113 | 0.4123 | 4808160.0 |
| 2004-01-08 11:45:00 | AAPL | Stock | 0.4121 | 0.4134 | 0.4116 | 0.4131 | 3257856.0 |
| 2004-01-08 11:50:00 | AAPL | Stock | 0.413 | 0.4139 | 0.4129 | 0.4138 | 5027680.0 |
| 2004-01-08 11:55:00 | AAPL | Stock | 0.4138 | 0.4139 | 0.4129 | 0.4132 | 3055416.0 |
| 2004-01-08 12:00:00 | AAPL | Stock | 0.4132 | 0.4136 | 0.4129 | 0.413 | 2488808.0 |
| 2004-01-08 12:05:00 | AAPL | Stock | 0.4132 | 0.4141 | 0.4132 | 0.4132 | 2162048.0 |
| 2004-01-08 12:10:00 | AAPL | Stock | 0.4132 | 0.4141 | 0.4129 | 0.4141 | 5342064.0 |
| 2004-01-08 12:15:00 | AAPL | Stock | 0.4141 | 0.4148 | 0.4134 | 0.4139 | 3653328.0 |
| 2004-01-08 12:20:00 | AAPL | Stock | 0.4139 | 0.4145 | 0.4134 | 0.4138 | 1862280.0 |
| 2004-01-08 12:25:00 | AAPL | Stock | 0.4138 | 0.4143 | 0.4129 | 0.4129 | 2525320.0 |
| 2004-01-08 12:30:00 | AAPL | Stock | 0.413 | 0.4132 | 0.4129 | 0.413 | 530320.0 |
| 2004-01-08 12:35:00 | AAPL | Stock | 0.413 | 0.4138 | 0.4129 | 0.4134 | 1704080.0 |
| 2004-01-08 12:40:00 | AAPL | Stock | 0.4134 | 0.4138 | 0.413 | 0.4138 | 1310064.0 |
| 2004-01-08 12:45:00 | AAPL | Stock | 0.4138 | 0.4139 | 0.4134 | 0.4134 | 793072.0 |
| 2004-01-08 12:50:00 | AAPL | Stock | 0.4134 | 0.4138 | 0.4132 | 0.4134 | 1305136.0 |
> showing 50 of 174,568 rows — these rows as CSV