PREVIEW / stock_1min / 2004-01-14
file: by_date/stock_1min/2004/2004-01-14.parquet size: 5.8 MB rows: 476,991 symbols: 1,406
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-01-14 08:05:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 11200.0 |
| 2004-01-14 08:08:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 39200.0 |
| 2004-01-14 08:09:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 5600.0 |
| 2004-01-14 08:18:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 5600.0 |
| 2004-01-14 08:25:00 | AAPL | Stock | 0.4348 | 0.4348 | 0.4348 | 0.4348 | 56000.0 |
| 2004-01-14 08:27:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 72800.0 |
| 2004-01-14 08:28:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 39200.0 |
| 2004-01-14 08:30:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 56000.0 |
| 2004-01-14 08:35:00 | AAPL | Stock | 0.4348 | 0.4348 | 0.4348 | 0.4348 | 11200.0 |
| 2004-01-14 08:37:00 | AAPL | Stock | 0.4341 | 0.4341 | 0.4341 | 0.4341 | 11200.0 |
| 2004-01-14 08:38:00 | AAPL | Stock | 0.4341 | 0.4341 | 0.4341 | 0.4341 | 44800.0 |
| 2004-01-14 08:39:00 | AAPL | Stock | 0.4348 | 0.4348 | 0.4348 | 0.4348 | 61600.0 |
| 2004-01-14 08:40:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 33600.0 |
| 2004-01-14 08:42:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 28000.0 |
| 2004-01-14 08:43:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 50400.0 |
| 2004-01-14 08:45:00 | AAPL | Stock | 0.4359 | 0.4359 | 0.4359 | 0.4359 | 11200.0 |
| 2004-01-14 08:46:00 | AAPL | Stock | 0.4359 | 0.4359 | 0.4359 | 0.4359 | 11200.0 |
| 2004-01-14 08:50:00 | AAPL | Stock | 0.4359 | 0.4359 | 0.4357 | 0.4357 | 28000.0 |
| 2004-01-14 08:52:00 | AAPL | Stock | 0.4364 | 0.4364 | 0.4364 | 0.4364 | 11200.0 |
| 2004-01-14 08:56:00 | AAPL | Stock | 0.437 | 0.437 | 0.437 | 0.437 | 11200.0 |
| 2004-01-14 08:58:00 | AAPL | Stock | 0.4371 | 0.4373 | 0.4371 | 0.4373 | 67200.0 |
| 2004-01-14 08:59:00 | AAPL | Stock | 0.4373 | 0.4373 | 0.4373 | 0.4373 | 28000.0 |
| 2004-01-14 09:01:00 | AAPL | Stock | 0.4373 | 0.4373 | 0.4373 | 0.4373 | 89600.0 |
| 2004-01-14 09:04:00 | AAPL | Stock | 0.4373 | 0.4375 | 0.4366 | 0.4366 | 268800.0 |
| 2004-01-14 09:08:00 | AAPL | Stock | 0.4371 | 0.4371 | 0.4366 | 0.4366 | 39200.0 |
| 2004-01-14 09:14:00 | AAPL | Stock | 0.4366 | 0.4366 | 0.4364 | 0.4364 | 72800.0 |
| 2004-01-14 09:15:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 56000.0 |
| 2004-01-14 09:24:00 | AAPL | Stock | 0.4352 | 0.4357 | 0.4352 | 0.4357 | 95200.0 |
| 2004-01-14 09:27:00 | AAPL | Stock | 0.4334 | 0.4334 | 0.4334 | 0.4334 | 5600.0 |
| 2004-01-14 09:29:00 | AAPL | Stock | 0.4336 | 0.4357 | 0.4336 | 0.4357 | 2161600.0 |
| 2004-01-14 09:30:00 | AAPL | Stock | 0.4357 | 0.4373 | 0.4357 | 0.4366 | 10499384.0 |
| 2004-01-14 09:31:00 | AAPL | Stock | 0.4368 | 0.437 | 0.4357 | 0.437 | 6294176.0 |
| 2004-01-14 09:32:00 | AAPL | Stock | 0.4366 | 0.437 | 0.4361 | 0.4363 | 1372000.0 |
| 2004-01-14 09:33:00 | AAPL | Stock | 0.4361 | 0.4375 | 0.4359 | 0.4373 | 4594856.0 |
| 2004-01-14 09:34:00 | AAPL | Stock | 0.437 | 0.4371 | 0.4362 | 0.4368 | 2563400.0 |
| 2004-01-14 09:35:00 | AAPL | Stock | 0.4366 | 0.4368 | 0.4361 | 0.4366 | 2149784.0 |
| 2004-01-14 09:36:00 | AAPL | Stock | 0.4366 | 0.4366 | 0.4361 | 0.4361 | 6296584.0 |
| 2004-01-14 09:37:00 | AAPL | Stock | 0.4361 | 0.4363 | 0.4352 | 0.4357 | 4029200.0 |
| 2004-01-14 09:38:00 | AAPL | Stock | 0.4357 | 0.4363 | 0.4355 | 0.4363 | 2568216.0 |
| 2004-01-14 09:39:00 | AAPL | Stock | 0.4363 | 0.4373 | 0.4359 | 0.437 | 2263520.0 |
| 2004-01-14 09:40:00 | AAPL | Stock | 0.4373 | 0.4382 | 0.4368 | 0.438 | 4075400.0 |
| 2004-01-14 09:41:00 | AAPL | Stock | 0.438 | 0.4382 | 0.4371 | 0.4375 | 2623432.0 |
| 2004-01-14 09:42:00 | AAPL | Stock | 0.4375 | 0.4375 | 0.4373 | 0.4373 | 737800.0 |
| 2004-01-14 09:43:00 | AAPL | Stock | 0.4375 | 0.4375 | 0.437 | 0.4371 | 3251584.0 |
| 2004-01-14 09:44:00 | AAPL | Stock | 0.4373 | 0.4373 | 0.4366 | 0.437 | 840000.0 |
| 2004-01-14 09:45:00 | AAPL | Stock | 0.437 | 0.4371 | 0.4364 | 0.4364 | 1410640.0 |
| 2004-01-14 09:46:00 | AAPL | Stock | 0.4364 | 0.4375 | 0.4364 | 0.4373 | 3054296.0 |
| 2004-01-14 09:47:00 | AAPL | Stock | 0.4373 | 0.4373 | 0.4366 | 0.437 | 2491720.0 |
| 2004-01-14 09:48:00 | AAPL | Stock | 0.437 | 0.4371 | 0.4366 | 0.4368 | 698600.0 |
| 2004-01-14 09:49:00 | AAPL | Stock | 0.437 | 0.437 | 0.4366 | 0.4368 | 3052784.0 |
> showing 50 of 476,991 rows — these rows as CSV