PREVIEW / stock_1min / 2004-07-12
file: by_date/stock_1min/2004/2004-07-12.parquet size: 5.7 MB rows: 478,341 symbols: 1,488
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-12 09:05:00 | AAPL | Stock | 0.5375 | 0.5375 | 0.5375 | 0.5375 | 280000.0 |
| 2004-07-12 09:20:00 | AAPL | Stock | 0.5355 | 0.5359 | 0.5355 | 0.5359 | 27720.0 |
| 2004-07-12 09:29:00 | AAPL | Stock | 0.537 | 0.537 | 0.5363 | 0.5364 | 224000.0 |
| 2004-07-12 09:30:00 | AAPL | Stock | 0.5359 | 0.5364 | 0.5348 | 0.5357 | 3091760.0 |
| 2004-07-12 09:31:00 | AAPL | Stock | 0.535 | 0.5357 | 0.5343 | 0.5348 | 676480.0 |
| 2004-07-12 09:32:00 | AAPL | Stock | 0.5345 | 0.5357 | 0.5345 | 0.5345 | 849296.0 |
| 2004-07-12 09:33:00 | AAPL | Stock | 0.5345 | 0.5357 | 0.5345 | 0.5357 | 1736784.0 |
| 2004-07-12 09:34:00 | AAPL | Stock | 0.5355 | 0.5355 | 0.5354 | 0.5355 | 996800.0 |
| 2004-07-12 09:35:00 | AAPL | Stock | 0.5354 | 0.5357 | 0.5325 | 0.5325 | 1572200.0 |
| 2004-07-12 09:36:00 | AAPL | Stock | 0.5354 | 0.5354 | 0.5321 | 0.5327 | 820736.0 |
| 2004-07-12 09:37:00 | AAPL | Stock | 0.533 | 0.5332 | 0.5325 | 0.5325 | 301392.0 |
| 2004-07-12 09:38:00 | AAPL | Stock | 0.5327 | 0.5327 | 0.5323 | 0.5323 | 175280.0 |
| 2004-07-12 09:39:00 | AAPL | Stock | 0.5327 | 0.5332 | 0.5325 | 0.5329 | 752976.0 |
| 2004-07-12 09:40:00 | AAPL | Stock | 0.533 | 0.5343 | 0.5327 | 0.5339 | 1331680.0 |
| 2004-07-12 09:41:00 | AAPL | Stock | 0.5339 | 0.5343 | 0.5321 | 0.5325 | 1294888.0 |
| 2004-07-12 09:42:00 | AAPL | Stock | 0.5327 | 0.5328 | 0.5323 | 0.5325 | 523768.0 |
| 2004-07-12 09:43:00 | AAPL | Stock | 0.5327 | 0.5334 | 0.5327 | 0.5334 | 324800.0 |
| 2004-07-12 09:44:00 | AAPL | Stock | 0.5336 | 0.5339 | 0.5327 | 0.5332 | 686000.0 |
| 2004-07-12 09:45:00 | AAPL | Stock | 0.533 | 0.5338 | 0.533 | 0.5338 | 390264.0 |
| 2004-07-12 09:46:00 | AAPL | Stock | 0.5334 | 0.5336 | 0.533 | 0.5336 | 2252544.0 |
| 2004-07-12 09:47:00 | AAPL | Stock | 0.5336 | 0.5336 | 0.5321 | 0.5323 | 2563680.0 |
| 2004-07-12 09:48:00 | AAPL | Stock | 0.5325 | 0.5339 | 0.5323 | 0.533 | 1785952.0 |
| 2004-07-12 09:49:00 | AAPL | Stock | 0.5332 | 0.5338 | 0.533 | 0.533 | 454048.0 |
| 2004-07-12 09:50:00 | AAPL | Stock | 0.5332 | 0.5332 | 0.532 | 0.5323 | 479864.0 |
| 2004-07-12 09:51:00 | AAPL | Stock | 0.5321 | 0.5323 | 0.5305 | 0.5311 | 1056328.0 |
| 2004-07-12 09:52:00 | AAPL | Stock | 0.5311 | 0.5318 | 0.5293 | 0.5295 | 1925448.0 |
| 2004-07-12 09:53:00 | AAPL | Stock | 0.5295 | 0.5304 | 0.5289 | 0.5295 | 1805160.0 |
| 2004-07-12 09:54:00 | AAPL | Stock | 0.5298 | 0.5304 | 0.5295 | 0.5296 | 3005520.0 |
| 2004-07-12 09:55:00 | AAPL | Stock | 0.5298 | 0.5298 | 0.5291 | 0.5295 | 509600.0 |
| 2004-07-12 09:56:00 | AAPL | Stock | 0.5295 | 0.5295 | 0.5289 | 0.5289 | 935200.0 |
| 2004-07-12 09:57:00 | AAPL | Stock | 0.5291 | 0.5293 | 0.5284 | 0.5288 | 2969288.0 |
| 2004-07-12 09:58:00 | AAPL | Stock | 0.5293 | 0.5298 | 0.5289 | 0.5289 | 1737624.0 |
| 2004-07-12 09:59:00 | AAPL | Stock | 0.5289 | 0.5289 | 0.5279 | 0.528 | 4222120.0 |
| 2004-07-12 10:00:00 | AAPL | Stock | 0.528 | 0.5284 | 0.5275 | 0.5277 | 1171408.0 |
| 2004-07-12 10:01:00 | AAPL | Stock | 0.5277 | 0.5286 | 0.5275 | 0.528 | 3458392.0 |
| 2004-07-12 10:02:00 | AAPL | Stock | 0.5279 | 0.5279 | 0.5271 | 0.5275 | 1420104.0 |
| 2004-07-12 10:03:00 | AAPL | Stock | 0.5273 | 0.5275 | 0.5271 | 0.5273 | 1099056.0 |
| 2004-07-12 10:04:00 | AAPL | Stock | 0.5273 | 0.5279 | 0.5271 | 0.5271 | 3349360.0 |
| 2004-07-12 10:05:00 | AAPL | Stock | 0.5271 | 0.5271 | 0.5255 | 0.5259 | 2775864.0 |
| 2004-07-12 10:06:00 | AAPL | Stock | 0.5257 | 0.5264 | 0.525 | 0.5257 | 2075696.0 |
| 2004-07-12 10:07:00 | AAPL | Stock | 0.5264 | 0.5268 | 0.5255 | 0.5255 | 2559200.0 |
| 2004-07-12 10:08:00 | AAPL | Stock | 0.5257 | 0.5259 | 0.5248 | 0.5259 | 2651432.0 |
| 2004-07-12 10:09:00 | AAPL | Stock | 0.5257 | 0.5266 | 0.5257 | 0.5266 | 1038520.0 |
| 2004-07-12 10:10:00 | AAPL | Stock | 0.5266 | 0.5279 | 0.5266 | 0.5279 | 1085504.0 |
| 2004-07-12 10:11:00 | AAPL | Stock | 0.5279 | 0.5286 | 0.5277 | 0.5284 | 960848.0 |
| 2004-07-12 10:12:00 | AAPL | Stock | 0.5282 | 0.5282 | 0.5266 | 0.528 | 1562008.0 |
| 2004-07-12 10:13:00 | AAPL | Stock | 0.5282 | 0.5284 | 0.5275 | 0.528 | 929600.0 |
| 2004-07-12 10:14:00 | AAPL | Stock | 0.528 | 0.528 | 0.5277 | 0.5279 | 809760.0 |
| 2004-07-12 10:15:00 | AAPL | Stock | 0.5277 | 0.528 | 0.5277 | 0.528 | 1344000.0 |
| 2004-07-12 10:16:00 | AAPL | Stock | 0.528 | 0.5286 | 0.528 | 0.5284 | 2746688.0 |
> showing 50 of 478,341 rows — these rows as CSV