PREVIEW / stock_5min / 2004-08-27
file: by_date/stock_5min/2004/2004-08-27.parquet size: 2.2 MB rows: 167,635 symbols: 1,816
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-08-27 08:00:00 | AAPL | Stock | 0.62 | 0.62 | 0.6161 | 0.6161 | 184800.0 |
| 2004-08-27 08:10:00 | AAPL | Stock | 0.6196 | 0.6196 | 0.6196 | 0.6196 | 5600.0 |
| 2004-08-27 08:20:00 | AAPL | Stock | 0.617 | 0.617 | 0.617 | 0.617 | 61600.0 |
| 2004-08-27 08:25:00 | AAPL | Stock | 0.6161 | 0.6161 | 0.6161 | 0.6161 | 168000.0 |
| 2004-08-27 08:30:00 | AAPL | Stock | 0.6161 | 0.6161 | 0.6161 | 0.6161 | 67200.0 |
| 2004-08-27 08:35:00 | AAPL | Stock | 0.6161 | 0.6161 | 0.6161 | 0.6161 | 16800.0 |
| 2004-08-27 08:45:00 | AAPL | Stock | 0.6168 | 0.6168 | 0.6168 | 0.6168 | 11200.0 |
| 2004-08-27 08:50:00 | AAPL | Stock | 0.6168 | 0.6168 | 0.6163 | 0.6163 | 28000.0 |
| 2004-08-27 08:55:00 | AAPL | Stock | 0.6161 | 0.6161 | 0.6159 | 0.6161 | 280000.0 |
| 2004-08-27 09:00:00 | AAPL | Stock | 0.6163 | 0.6163 | 0.6163 | 0.6163 | 89600.0 |
| 2004-08-27 09:05:00 | AAPL | Stock | 0.6163 | 0.617 | 0.6163 | 0.617 | 145600.0 |
| 2004-08-27 09:10:00 | AAPL | Stock | 0.6161 | 0.6175 | 0.6161 | 0.6175 | 190400.0 |
| 2004-08-27 09:15:00 | AAPL | Stock | 0.6173 | 0.6173 | 0.6173 | 0.6173 | 5600.0 |
| 2004-08-27 09:20:00 | AAPL | Stock | 0.6175 | 0.6189 | 0.6175 | 0.6189 | 276640.0 |
| 2004-08-27 09:25:00 | AAPL | Stock | 0.6188 | 0.6189 | 0.6179 | 0.6189 | 640752.0 |
| 2004-08-27 09:30:00 | AAPL | Stock | 0.618 | 0.6207 | 0.6161 | 0.6195 | 13202448.0 |
| 2004-08-27 09:35:00 | AAPL | Stock | 0.6189 | 0.6198 | 0.6166 | 0.6195 | 5831224.0 |
| 2004-08-27 09:40:00 | AAPL | Stock | 0.6195 | 0.6195 | 0.6154 | 0.6159 | 9448488.0 |
| 2004-08-27 09:45:00 | AAPL | Stock | 0.6161 | 0.6188 | 0.6146 | 0.6188 | 16296224.0 |
| 2004-08-27 09:50:00 | AAPL | Stock | 0.6189 | 0.6195 | 0.6166 | 0.6171 | 7826616.0 |
| 2004-08-27 09:55:00 | AAPL | Stock | 0.617 | 0.6184 | 0.6166 | 0.6177 | 4972912.0 |
| 2004-08-27 10:00:00 | AAPL | Stock | 0.6177 | 0.6196 | 0.617 | 0.6195 | 11481792.0 |
| 2004-08-27 10:05:00 | AAPL | Stock | 0.6177 | 0.62 | 0.6173 | 0.618 | 8254288.0 |
| 2004-08-27 10:10:00 | AAPL | Stock | 0.618 | 0.618 | 0.617 | 0.6175 | 3610992.0 |
| 2004-08-27 10:15:00 | AAPL | Stock | 0.6177 | 0.6177 | 0.6161 | 0.6163 | 5227264.0 |
| 2004-08-27 10:20:00 | AAPL | Stock | 0.6163 | 0.617 | 0.6116 | 0.6116 | 10353672.0 |
| 2004-08-27 10:25:00 | AAPL | Stock | 0.6116 | 0.6143 | 0.6116 | 0.6132 | 7235480.0 |
| 2004-08-27 10:30:00 | AAPL | Stock | 0.6134 | 0.6145 | 0.613 | 0.6136 | 6434624.0 |
| 2004-08-27 10:35:00 | AAPL | Stock | 0.6136 | 0.6139 | 0.6134 | 0.6136 | 3100552.0 |
| 2004-08-27 10:40:00 | AAPL | Stock | 0.6134 | 0.6136 | 0.6116 | 0.6121 | 8867208.0 |
| 2004-08-27 10:45:00 | AAPL | Stock | 0.6118 | 0.6125 | 0.6093 | 0.61 | 9504208.0 |
| 2004-08-27 10:50:00 | AAPL | Stock | 0.61 | 0.6105 | 0.6096 | 0.6096 | 6549984.0 |
| 2004-08-27 10:55:00 | AAPL | Stock | 0.6096 | 0.61 | 0.608 | 0.6086 | 19512136.0 |
| 2004-08-27 11:00:00 | AAPL | Stock | 0.6086 | 0.6105 | 0.6084 | 0.61 | 9418304.0 |
| 2004-08-27 11:05:00 | AAPL | Stock | 0.61 | 0.6107 | 0.6098 | 0.6102 | 7992992.0 |
| 2004-08-27 11:10:00 | AAPL | Stock | 0.6102 | 0.6107 | 0.6095 | 0.6095 | 2288328.0 |
| 2004-08-27 11:15:00 | AAPL | Stock | 0.6093 | 0.6105 | 0.6088 | 0.6104 | 5694192.0 |
| 2004-08-27 11:20:00 | AAPL | Stock | 0.6102 | 0.6104 | 0.6089 | 0.6089 | 1951264.0 |
| 2004-08-27 11:25:00 | AAPL | Stock | 0.6089 | 0.6089 | 0.6071 | 0.6084 | 7174272.0 |
| 2004-08-27 11:30:00 | AAPL | Stock | 0.6082 | 0.6086 | 0.6071 | 0.6073 | 6483176.0 |
| 2004-08-27 11:35:00 | AAPL | Stock | 0.6073 | 0.61 | 0.6073 | 0.6096 | 8179976.0 |
| 2004-08-27 11:40:00 | AAPL | Stock | 0.6095 | 0.6096 | 0.6089 | 0.6095 | 3368064.0 |
| 2004-08-27 11:45:00 | AAPL | Stock | 0.6091 | 0.6095 | 0.6084 | 0.6093 | 2434152.0 |
| 2004-08-27 11:50:00 | AAPL | Stock | 0.6093 | 0.6102 | 0.6089 | 0.61 | 6702976.0 |
| 2004-08-27 11:55:00 | AAPL | Stock | 0.61 | 0.6103 | 0.61 | 0.61 | 2305632.0 |
| 2004-08-27 12:00:00 | AAPL | Stock | 0.61 | 0.6105 | 0.6098 | 0.6098 | 964152.0 |
| 2004-08-27 12:05:00 | AAPL | Stock | 0.6098 | 0.6098 | 0.6093 | 0.6095 | 815192.0 |
| 2004-08-27 12:10:00 | AAPL | Stock | 0.6093 | 0.6098 | 0.6089 | 0.6093 | 3382792.0 |
| 2004-08-27 12:15:00 | AAPL | Stock | 0.6093 | 0.61 | 0.6093 | 0.6098 | 1461992.0 |
| 2004-08-27 12:20:00 | AAPL | Stock | 0.6098 | 0.6098 | 0.6095 | 0.6096 | 583464.0 |
> showing 50 of 167,635 rows — these rows as CSV