PREVIEW / stock_5min / 2003-11-03
file: by_date/stock_5min/2003/2003-11-03.parquet size: 2.4 MB rows: 167,774 symbols: 1,661
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-11-03 09:00:00 | AAPL | Stock | 0.4088 | 0.4088 | 0.4088 | 0.4088 | 89600.0 |
| 2003-11-03 09:25:00 | AAPL | Stock | 0.4088 | 0.4088 | 0.408 | 0.4084 | 705600.0 |
| 2003-11-03 09:30:00 | AAPL | Stock | 0.4077 | 0.4088 | 0.4068 | 0.4088 | 2152696.0 |
| 2003-11-03 09:35:00 | AAPL | Stock | 0.4086 | 0.4113 | 0.4086 | 0.4096 | 2629144.0 |
| 2003-11-03 09:40:00 | AAPL | Stock | 0.4102 | 0.4104 | 0.4095 | 0.4102 | 1054480.0 |
| 2003-11-03 09:45:00 | AAPL | Stock | 0.4102 | 0.4102 | 0.4098 | 0.4102 | 1415848.0 |
| 2003-11-03 09:50:00 | AAPL | Stock | 0.4104 | 0.4118 | 0.4103 | 0.4111 | 3015208.0 |
| 2003-11-03 09:55:00 | AAPL | Stock | 0.4111 | 0.413 | 0.4104 | 0.413 | 7622216.0 |
| 2003-11-03 10:00:00 | AAPL | Stock | 0.413 | 0.415 | 0.413 | 0.4145 | 3581424.0 |
| 2003-11-03 10:05:00 | AAPL | Stock | 0.4145 | 0.4154 | 0.4141 | 0.4154 | 4009544.0 |
| 2003-11-03 10:10:00 | AAPL | Stock | 0.4154 | 0.4154 | 0.4134 | 0.4141 | 1632736.0 |
| 2003-11-03 10:15:00 | AAPL | Stock | 0.4145 | 0.4152 | 0.4141 | 0.4152 | 1251824.0 |
| 2003-11-03 10:20:00 | AAPL | Stock | 0.4152 | 0.4159 | 0.415 | 0.4152 | 1654912.0 |
| 2003-11-03 10:25:00 | AAPL | Stock | 0.4154 | 0.4154 | 0.4146 | 0.4152 | 3114496.0 |
| 2003-11-03 10:30:00 | AAPL | Stock | 0.4152 | 0.4152 | 0.4145 | 0.4146 | 1397648.0 |
| 2003-11-03 10:35:00 | AAPL | Stock | 0.4146 | 0.415 | 0.4143 | 0.4146 | 1915872.0 |
| 2003-11-03 10:40:00 | AAPL | Stock | 0.415 | 0.4161 | 0.415 | 0.4161 | 2058672.0 |
| 2003-11-03 10:45:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4148 | 0.4159 | 1072120.0 |
| 2003-11-03 10:50:00 | AAPL | Stock | 0.4154 | 0.4154 | 0.4141 | 0.4141 | 950768.0 |
| 2003-11-03 10:55:00 | AAPL | Stock | 0.4139 | 0.4148 | 0.4139 | 0.4148 | 1418480.0 |
| 2003-11-03 11:00:00 | AAPL | Stock | 0.4148 | 0.4161 | 0.4148 | 0.4161 | 1600984.0 |
| 2003-11-03 11:05:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.415 | 0.415 | 527520.0 |
| 2003-11-03 11:10:00 | AAPL | Stock | 0.4152 | 0.4152 | 0.4143 | 0.4144 | 433328.0 |
| 2003-11-03 11:15:00 | AAPL | Stock | 0.4143 | 0.4145 | 0.4134 | 0.4134 | 673176.0 |
| 2003-11-03 11:20:00 | AAPL | Stock | 0.4134 | 0.4143 | 0.4134 | 0.4134 | 1766576.0 |
| 2003-11-03 11:25:00 | AAPL | Stock | 0.4134 | 0.4143 | 0.4134 | 0.4141 | 481600.0 |
| 2003-11-03 11:30:00 | AAPL | Stock | 0.4139 | 0.4143 | 0.4136 | 0.4139 | 487200.0 |
| 2003-11-03 11:35:00 | AAPL | Stock | 0.4141 | 0.4143 | 0.4139 | 0.4141 | 510720.0 |
| 2003-11-03 11:40:00 | AAPL | Stock | 0.4139 | 0.4141 | 0.4138 | 0.4139 | 296968.0 |
| 2003-11-03 11:45:00 | AAPL | Stock | 0.4139 | 0.4139 | 0.4136 | 0.4138 | 235200.0 |
| 2003-11-03 11:50:00 | AAPL | Stock | 0.4138 | 0.4138 | 0.413 | 0.413 | 1909152.0 |
| 2003-11-03 11:55:00 | AAPL | Stock | 0.413 | 0.413 | 0.4121 | 0.4121 | 1314432.0 |
| 2003-11-03 12:00:00 | AAPL | Stock | 0.4125 | 0.4125 | 0.4105 | 0.4107 | 4939312.0 |
| 2003-11-03 12:05:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4095 | 0.4104 | 2934064.0 |
| 2003-11-03 12:10:00 | AAPL | Stock | 0.4104 | 0.4107 | 0.41 | 0.4105 | 1642704.0 |
| 2003-11-03 12:15:00 | AAPL | Stock | 0.4105 | 0.4118 | 0.4105 | 0.4116 | 3422664.0 |
| 2003-11-03 12:20:00 | AAPL | Stock | 0.4116 | 0.4116 | 0.4114 | 0.4114 | 1457736.0 |
| 2003-11-03 12:25:00 | AAPL | Stock | 0.4116 | 0.4116 | 0.4114 | 0.4114 | 828744.0 |
| 2003-11-03 12:30:00 | AAPL | Stock | 0.4116 | 0.412 | 0.4107 | 0.4107 | 15852704.0 |
| 2003-11-03 12:35:00 | AAPL | Stock | 0.4107 | 0.4109 | 0.4096 | 0.4107 | 18753560.0 |
| 2003-11-03 12:40:00 | AAPL | Stock | 0.4109 | 0.4109 | 0.4105 | 0.4107 | 720944.0 |
| 2003-11-03 12:45:00 | AAPL | Stock | 0.4109 | 0.4111 | 0.4104 | 0.4105 | 1859200.0 |
| 2003-11-03 12:50:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4105 | 0.4105 | 1604960.0 |
| 2003-11-03 12:55:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4105 | 0.4107 | 3791200.0 |
| 2003-11-03 13:00:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4104 | 0.4107 | 4991728.0 |
| 2003-11-03 13:05:00 | AAPL | Stock | 0.4107 | 0.4127 | 0.4107 | 0.4127 | 3193512.0 |
| 2003-11-03 13:10:00 | AAPL | Stock | 0.4127 | 0.4141 | 0.4127 | 0.4139 | 6729016.0 |
| 2003-11-03 13:15:00 | AAPL | Stock | 0.4139 | 0.4141 | 0.4136 | 0.4138 | 3904936.0 |
| 2003-11-03 13:20:00 | AAPL | Stock | 0.4139 | 0.4141 | 0.4138 | 0.4141 | 6004600.0 |
| 2003-11-03 13:25:00 | AAPL | Stock | 0.4139 | 0.4141 | 0.4136 | 0.4136 | 2850960.0 |
> showing 50 of 167,774 rows — these rows as CSV