PREVIEW / stock_1min / 2004-07-14
file: by_date/stock_1min/2004/2004-07-14.parquet size: 5.9 MB rows: 490,827 symbols: 1,474
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-07-14 08:02:00 | AAPL | Stock | 0.521 | 0.521 | 0.521 | 0.521 | 716800.0 |
| 2004-07-14 08:27:00 | AAPL | Stock | 0.5164 | 0.5164 | 0.5164 | 0.5164 | 28000.0 |
| 2004-07-14 08:29:00 | AAPL | Stock | 0.5175 | 0.5179 | 0.5175 | 0.5179 | 11200.0 |
| 2004-07-14 08:49:00 | AAPL | Stock | 0.517 | 0.517 | 0.517 | 0.517 | 5600.0 |
| 2004-07-14 09:17:00 | AAPL | Stock | 0.517 | 0.517 | 0.517 | 0.517 | 50400.0 |
| 2004-07-14 09:22:00 | AAPL | Stock | 0.5179 | 0.5218 | 0.5179 | 0.5218 | 4894400.0 |
| 2004-07-14 09:23:00 | AAPL | Stock | 0.5179 | 0.5179 | 0.5179 | 0.5179 | 165200.0 |
| 2004-07-14 09:26:00 | AAPL | Stock | 0.5171 | 0.5173 | 0.5171 | 0.5173 | 61600.0 |
| 2004-07-14 09:29:00 | AAPL | Stock | 0.5168 | 0.5168 | 0.5141 | 0.5141 | 387016.0 |
| 2004-07-14 09:30:00 | AAPL | Stock | 0.5171 | 0.5171 | 0.5132 | 0.5134 | 6958840.0 |
| 2004-07-14 09:31:00 | AAPL | Stock | 0.5139 | 0.517 | 0.5132 | 0.5155 | 2049376.0 |
| 2004-07-14 09:32:00 | AAPL | Stock | 0.5155 | 0.517 | 0.5155 | 0.517 | 759528.0 |
| 2004-07-14 09:33:00 | AAPL | Stock | 0.517 | 0.5177 | 0.5161 | 0.5174 | 1771392.0 |
| 2004-07-14 09:34:00 | AAPL | Stock | 0.5173 | 0.5179 | 0.5168 | 0.5177 | 2696568.0 |
| 2004-07-14 09:35:00 | AAPL | Stock | 0.5177 | 0.5189 | 0.5161 | 0.5188 | 1921416.0 |
| 2004-07-14 09:36:00 | AAPL | Stock | 0.5188 | 0.5189 | 0.5186 | 0.5188 | 2223200.0 |
| 2004-07-14 09:37:00 | AAPL | Stock | 0.5188 | 0.5196 | 0.5186 | 0.5196 | 1250816.0 |
| 2004-07-14 09:38:00 | AAPL | Stock | 0.5193 | 0.52 | 0.5186 | 0.5186 | 1800904.0 |
| 2004-07-14 09:39:00 | AAPL | Stock | 0.5195 | 0.52 | 0.5193 | 0.52 | 2818984.0 |
| 2004-07-14 09:40:00 | AAPL | Stock | 0.52 | 0.5202 | 0.5196 | 0.5198 | 1680952.0 |
| 2004-07-14 09:41:00 | AAPL | Stock | 0.5196 | 0.5198 | 0.5196 | 0.5198 | 644896.0 |
| 2004-07-14 09:42:00 | AAPL | Stock | 0.5198 | 0.5211 | 0.5198 | 0.5211 | 1970808.0 |
| 2004-07-14 09:43:00 | AAPL | Stock | 0.5211 | 0.522 | 0.5204 | 0.5216 | 2033808.0 |
| 2004-07-14 09:44:00 | AAPL | Stock | 0.5214 | 0.5216 | 0.5205 | 0.5205 | 3913896.0 |
| 2004-07-14 09:45:00 | AAPL | Stock | 0.5205 | 0.5214 | 0.5205 | 0.5211 | 2872632.0 |
| 2004-07-14 09:46:00 | AAPL | Stock | 0.5211 | 0.5214 | 0.5207 | 0.5207 | 2991968.0 |
| 2004-07-14 09:47:00 | AAPL | Stock | 0.5207 | 0.5214 | 0.5202 | 0.5211 | 1523200.0 |
| 2004-07-14 09:48:00 | AAPL | Stock | 0.5211 | 0.5213 | 0.5204 | 0.5211 | 686224.0 |
| 2004-07-14 09:49:00 | AAPL | Stock | 0.5209 | 0.5211 | 0.5205 | 0.5207 | 1574272.0 |
| 2004-07-14 09:50:00 | AAPL | Stock | 0.5205 | 0.5209 | 0.5205 | 0.5205 | 2248400.0 |
| 2004-07-14 09:51:00 | AAPL | Stock | 0.5204 | 0.5211 | 0.5202 | 0.5209 | 1037288.0 |
| 2004-07-14 09:52:00 | AAPL | Stock | 0.5211 | 0.5211 | 0.5207 | 0.5207 | 1153600.0 |
| 2004-07-14 09:53:00 | AAPL | Stock | 0.5207 | 0.5209 | 0.5207 | 0.5209 | 578648.0 |
| 2004-07-14 09:54:00 | AAPL | Stock | 0.5207 | 0.5211 | 0.5207 | 0.5211 | 896000.0 |
| 2004-07-14 09:55:00 | AAPL | Stock | 0.5211 | 0.5211 | 0.5207 | 0.5209 | 548800.0 |
| 2004-07-14 09:56:00 | AAPL | Stock | 0.5207 | 0.5209 | 0.5207 | 0.5207 | 2302440.0 |
| 2004-07-14 09:57:00 | AAPL | Stock | 0.5207 | 0.5209 | 0.5205 | 0.5205 | 425600.0 |
| 2004-07-14 09:58:00 | AAPL | Stock | 0.5207 | 0.5207 | 0.5193 | 0.5195 | 1489600.0 |
| 2004-07-14 09:59:00 | AAPL | Stock | 0.5195 | 0.5202 | 0.5195 | 0.5202 | 1357664.0 |
| 2004-07-14 10:00:00 | AAPL | Stock | 0.5204 | 0.5204 | 0.5198 | 0.5198 | 260568.0 |
| 2004-07-14 10:01:00 | AAPL | Stock | 0.5198 | 0.5204 | 0.5196 | 0.5198 | 807408.0 |
| 2004-07-14 10:02:00 | AAPL | Stock | 0.5198 | 0.5202 | 0.5196 | 0.52 | 1211896.0 |
| 2004-07-14 10:03:00 | AAPL | Stock | 0.52 | 0.5207 | 0.5196 | 0.5207 | 2657648.0 |
| 2004-07-14 10:04:00 | AAPL | Stock | 0.5207 | 0.5209 | 0.52 | 0.5205 | 888384.0 |
| 2004-07-14 10:05:00 | AAPL | Stock | 0.5207 | 0.5207 | 0.52 | 0.5204 | 772800.0 |
| 2004-07-14 10:06:00 | AAPL | Stock | 0.5204 | 0.5209 | 0.5204 | 0.5209 | 1189216.0 |
| 2004-07-14 10:07:00 | AAPL | Stock | 0.5209 | 0.5213 | 0.5207 | 0.5207 | 1686160.0 |
| 2004-07-14 10:08:00 | AAPL | Stock | 0.5207 | 0.5209 | 0.5207 | 0.5207 | 274400.0 |
| 2004-07-14 10:09:00 | AAPL | Stock | 0.5209 | 0.5216 | 0.5209 | 0.5216 | 598920.0 |
| 2004-07-14 10:10:00 | AAPL | Stock | 0.5216 | 0.5218 | 0.5214 | 0.5216 | 604912.0 |
> showing 50 of 490,827 rows — these rows as CSV