PREVIEW / stock_5min / 2003-10-21
file: by_date/stock_5min/2003/2003-10-21.parquet size: 2.2 MB rows: 159,372 symbols: 1,648
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-21 08:00:00 | AAPL | Stock | 0.4196 | 0.4196 | 0.4196 | 0.4196 | 28000.0 |
| 2003-10-21 08:45:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4161 | 0.4161 | 56000.0 |
| 2003-10-21 09:00:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4161 | 0.4161 | 89600.0 |
| 2003-10-21 09:15:00 | AAPL | Stock | 0.4159 | 0.4161 | 0.4159 | 0.4161 | 50400.0 |
| 2003-10-21 09:25:00 | AAPL | Stock | 0.4164 | 0.417 | 0.4163 | 0.417 | 700000.0 |
| 2003-10-21 09:30:00 | AAPL | Stock | 0.4163 | 0.4179 | 0.4125 | 0.4125 | 8209544.0 |
| 2003-10-21 09:35:00 | AAPL | Stock | 0.4127 | 0.413 | 0.4098 | 0.4098 | 4907784.0 |
| 2003-10-21 09:40:00 | AAPL | Stock | 0.4096 | 0.4098 | 0.4063 | 0.4075 | 9864680.0 |
| 2003-10-21 09:45:00 | AAPL | Stock | 0.4073 | 0.4098 | 0.4071 | 0.408 | 5163760.0 |
| 2003-10-21 09:50:00 | AAPL | Stock | 0.408 | 0.4089 | 0.4074 | 0.408 | 3281600.0 |
| 2003-10-21 09:55:00 | AAPL | Stock | 0.4079 | 0.4098 | 0.4077 | 0.4091 | 2889600.0 |
| 2003-10-21 10:00:00 | AAPL | Stock | 0.4091 | 0.4098 | 0.4091 | 0.4093 | 2391200.0 |
| 2003-10-21 10:05:00 | AAPL | Stock | 0.4093 | 0.4113 | 0.4089 | 0.4113 | 2529408.0 |
| 2003-10-21 10:10:00 | AAPL | Stock | 0.4111 | 0.412 | 0.4105 | 0.4114 | 2206568.0 |
| 2003-10-21 10:15:00 | AAPL | Stock | 0.4113 | 0.412 | 0.4113 | 0.4118 | 2194024.0 |
| 2003-10-21 10:20:00 | AAPL | Stock | 0.4118 | 0.4118 | 0.4113 | 0.4114 | 1865024.0 |
| 2003-10-21 10:25:00 | AAPL | Stock | 0.4116 | 0.4116 | 0.4105 | 0.4107 | 2713256.0 |
| 2003-10-21 10:30:00 | AAPL | Stock | 0.4107 | 0.4113 | 0.4105 | 0.4113 | 1255800.0 |
| 2003-10-21 10:35:00 | AAPL | Stock | 0.4113 | 0.4113 | 0.4098 | 0.4098 | 2781800.0 |
| 2003-10-21 10:40:00 | AAPL | Stock | 0.4102 | 0.4105 | 0.4098 | 0.4104 | 924000.0 |
| 2003-10-21 10:45:00 | AAPL | Stock | 0.4104 | 0.4107 | 0.4089 | 0.4102 | 2964136.0 |
| 2003-10-21 10:50:00 | AAPL | Stock | 0.4102 | 0.4104 | 0.4089 | 0.4095 | 1704696.0 |
| 2003-10-21 10:55:00 | AAPL | Stock | 0.4098 | 0.4105 | 0.4095 | 0.4105 | 823200.0 |
| 2003-10-21 11:00:00 | AAPL | Stock | 0.4104 | 0.4111 | 0.4102 | 0.4102 | 1596000.0 |
| 2003-10-21 11:05:00 | AAPL | Stock | 0.4105 | 0.4109 | 0.4102 | 0.4102 | 1164240.0 |
| 2003-10-21 11:10:00 | AAPL | Stock | 0.4105 | 0.4107 | 0.4102 | 0.4103 | 428176.0 |
| 2003-10-21 11:15:00 | AAPL | Stock | 0.4103 | 0.4105 | 0.4103 | 0.4105 | 201600.0 |
| 2003-10-21 11:20:00 | AAPL | Stock | 0.4105 | 0.4107 | 0.4104 | 0.4107 | 1306648.0 |
| 2003-10-21 11:25:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4102 | 0.4102 | 1288000.0 |
| 2003-10-21 11:30:00 | AAPL | Stock | 0.4102 | 0.4113 | 0.4102 | 0.4107 | 3622192.0 |
| 2003-10-21 11:35:00 | AAPL | Stock | 0.4109 | 0.4113 | 0.4109 | 0.4109 | 306320.0 |
| 2003-10-21 11:40:00 | AAPL | Stock | 0.4109 | 0.4113 | 0.4107 | 0.4111 | 464800.0 |
| 2003-10-21 11:45:00 | AAPL | Stock | 0.4113 | 0.4113 | 0.4109 | 0.4109 | 649600.0 |
| 2003-10-21 11:50:00 | AAPL | Stock | 0.4111 | 0.4138 | 0.4111 | 0.4138 | 1785336.0 |
| 2003-10-21 11:55:00 | AAPL | Stock | 0.4134 | 0.4143 | 0.4121 | 0.4138 | 3514000.0 |
| 2003-10-21 12:00:00 | AAPL | Stock | 0.4138 | 0.4148 | 0.4136 | 0.4148 | 1310064.0 |
| 2003-10-21 12:05:00 | AAPL | Stock | 0.4148 | 0.4148 | 0.4139 | 0.4143 | 3072552.0 |
| 2003-10-21 12:10:00 | AAPL | Stock | 0.4143 | 0.4145 | 0.4139 | 0.4141 | 1676080.0 |
| 2003-10-21 12:15:00 | AAPL | Stock | 0.4143 | 0.415 | 0.4136 | 0.4143 | 1795360.0 |
| 2003-10-21 12:20:00 | AAPL | Stock | 0.4141 | 0.4143 | 0.4132 | 0.4141 | 2450728.0 |
| 2003-10-21 12:25:00 | AAPL | Stock | 0.4141 | 0.4148 | 0.4139 | 0.4146 | 1284080.0 |
| 2003-10-21 12:30:00 | AAPL | Stock | 0.4146 | 0.415 | 0.4141 | 0.4148 | 1405600.0 |
| 2003-10-21 12:35:00 | AAPL | Stock | 0.4148 | 0.4152 | 0.4146 | 0.4152 | 977536.0 |
| 2003-10-21 12:40:00 | AAPL | Stock | 0.415 | 0.4159 | 0.4148 | 0.4159 | 1129800.0 |
| 2003-10-21 12:45:00 | AAPL | Stock | 0.4155 | 0.4155 | 0.4148 | 0.4148 | 1657264.0 |
| 2003-10-21 12:50:00 | AAPL | Stock | 0.4148 | 0.4148 | 0.4146 | 0.4148 | 100800.0 |
| 2003-10-21 12:55:00 | AAPL | Stock | 0.4146 | 0.4148 | 0.4141 | 0.4141 | 660800.0 |
| 2003-10-21 13:00:00 | AAPL | Stock | 0.4139 | 0.4143 | 0.4138 | 0.4143 | 851424.0 |
| 2003-10-21 13:05:00 | AAPL | Stock | 0.4143 | 0.4146 | 0.4141 | 0.4144 | 728000.0 |
| 2003-10-21 13:10:00 | AAPL | Stock | 0.4143 | 0.4143 | 0.4123 | 0.4123 | 1750000.0 |
> showing 50 of 159,372 rows — these rows as CSV