PREVIEW / stock_1min / 2007-08-13
file: by_date/stock_1min/2007/2007-08-13.parquet size: 12.7 MB rows: 1,030,155 symbols: 2,570
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-13 09:30:00 | AAPL | Stock | 4.5829 | 4.595 | 4.5782 | 4.5934 | 13929216.0 |
| 2007-08-13 09:31:00 | AAPL | Stock | 4.5946 | 4.595 | 4.55 | 4.5607 | 6298264.0 |
| 2007-08-13 09:32:00 | AAPL | Stock | 4.5621 | 4.5714 | 4.5504 | 4.5625 | 3697876.0 |
| 2007-08-13 09:33:00 | AAPL | Stock | 4.5614 | 4.5654 | 4.5536 | 4.5564 | 3772552.0 |
| 2007-08-13 09:34:00 | AAPL | Stock | 4.5561 | 4.5579 | 4.5357 | 4.5391 | 5106388.0 |
| 2007-08-13 09:35:00 | AAPL | Stock | 4.5386 | 4.5471 | 4.53 | 4.5446 | 7097496.0 |
| 2007-08-13 09:36:00 | AAPL | Stock | 4.5446 | 4.5611 | 4.5304 | 4.5429 | 4314184.0 |
| 2007-08-13 09:37:00 | AAPL | Stock | 4.5429 | 4.551 | 4.5289 | 4.5389 | 5099444.0 |
| 2007-08-13 09:38:00 | AAPL | Stock | 4.5379 | 4.5618 | 4.535 | 4.5589 | 5278000.0 |
| 2007-08-13 09:39:00 | AAPL | Stock | 4.5568 | 4.5589 | 4.5436 | 4.5436 | 4426856.0 |
| 2007-08-13 09:40:00 | AAPL | Stock | 4.5436 | 4.5468 | 4.5389 | 4.5411 | 3426556.0 |
| 2007-08-13 09:41:00 | AAPL | Stock | 4.54 | 4.5461 | 4.5393 | 4.5418 | 2438688.0 |
| 2007-08-13 09:42:00 | AAPL | Stock | 4.5421 | 4.5446 | 4.5364 | 4.5404 | 2629648.0 |
| 2007-08-13 09:43:00 | AAPL | Stock | 4.5414 | 4.5518 | 4.54 | 4.5459 | 3304588.0 |
| 2007-08-13 09:44:00 | AAPL | Stock | 4.5457 | 4.5461 | 4.5311 | 4.5454 | 4268012.0 |
| 2007-08-13 09:45:00 | AAPL | Stock | 4.5454 | 4.5554 | 4.5401 | 4.5546 | 3730692.0 |
| 2007-08-13 09:46:00 | AAPL | Stock | 4.5536 | 4.5564 | 4.5425 | 4.5454 | 2718940.0 |
| 2007-08-13 09:47:00 | AAPL | Stock | 4.5454 | 4.5543 | 4.5418 | 4.5446 | 2414160.0 |
| 2007-08-13 09:48:00 | AAPL | Stock | 4.5454 | 4.5532 | 4.545 | 4.55 | 1478932.0 |
| 2007-08-13 09:49:00 | AAPL | Stock | 4.55 | 4.5571 | 4.5471 | 4.5479 | 3023160.0 |
| 2007-08-13 09:50:00 | AAPL | Stock | 4.5486 | 4.5486 | 4.5396 | 4.5404 | 3023440.0 |
| 2007-08-13 09:51:00 | AAPL | Stock | 4.5411 | 4.5421 | 4.5268 | 4.5375 | 6248704.0 |
| 2007-08-13 09:52:00 | AAPL | Stock | 4.5379 | 4.5464 | 4.5346 | 4.5371 | 3263232.0 |
| 2007-08-13 09:53:00 | AAPL | Stock | 4.5368 | 4.55 | 4.5368 | 4.5493 | 2212756.0 |
| 2007-08-13 09:54:00 | AAPL | Stock | 4.5479 | 4.5486 | 4.5357 | 4.5461 | 1845368.0 |
| 2007-08-13 09:55:00 | AAPL | Stock | 4.5457 | 4.5461 | 4.5407 | 4.5411 | 1710604.0 |
| 2007-08-13 09:56:00 | AAPL | Stock | 4.5411 | 4.5421 | 4.5336 | 4.5371 | 3054016.0 |
| 2007-08-13 09:57:00 | AAPL | Stock | 4.5379 | 4.5386 | 4.5289 | 4.5357 | 4474176.0 |
| 2007-08-13 09:58:00 | AAPL | Stock | 4.5357 | 4.5407 | 4.5271 | 4.5318 | 3077592.0 |
| 2007-08-13 09:59:00 | AAPL | Stock | 4.5307 | 4.5311 | 4.5179 | 4.5289 | 4936792.0 |
| 2007-08-13 10:00:00 | AAPL | Stock | 4.5296 | 4.5389 | 4.5282 | 4.535 | 3499328.0 |
| 2007-08-13 10:01:00 | AAPL | Stock | 4.5357 | 4.5443 | 4.5346 | 4.5411 | 2468676.0 |
| 2007-08-13 10:02:00 | AAPL | Stock | 4.5414 | 4.5471 | 4.5393 | 4.5421 | 1898400.0 |
| 2007-08-13 10:03:00 | AAPL | Stock | 4.5425 | 4.5518 | 4.5407 | 4.5496 | 3117492.0 |
| 2007-08-13 10:04:00 | AAPL | Stock | 4.5493 | 4.5511 | 4.5432 | 4.5464 | 1856624.0 |
| 2007-08-13 10:05:00 | AAPL | Stock | 4.5468 | 4.5554 | 4.5464 | 4.55 | 2466184.0 |
| 2007-08-13 10:06:00 | AAPL | Stock | 4.5496 | 4.5504 | 4.5429 | 4.5469 | 1531488.0 |
| 2007-08-13 10:07:00 | AAPL | Stock | 4.5461 | 4.5479 | 4.5421 | 4.5464 | 1164100.0 |
| 2007-08-13 10:08:00 | AAPL | Stock | 4.5471 | 4.5471 | 4.5393 | 4.5396 | 2094400.0 |
| 2007-08-13 10:09:00 | AAPL | Stock | 4.5393 | 4.545 | 4.5379 | 4.5425 | 1472940.0 |
| 2007-08-13 10:10:00 | AAPL | Stock | 4.5425 | 4.5536 | 4.5421 | 4.5489 | 2286508.0 |
| 2007-08-13 10:11:00 | AAPL | Stock | 4.5492 | 4.5496 | 4.5389 | 4.5443 | 1534680.0 |
| 2007-08-13 10:12:00 | AAPL | Stock | 4.5429 | 4.5471 | 4.5368 | 4.54 | 1155224.0 |
| 2007-08-13 10:13:00 | AAPL | Stock | 4.5389 | 4.5432 | 4.5386 | 4.5404 | 926996.0 |
| 2007-08-13 10:14:00 | AAPL | Stock | 4.54 | 4.5461 | 4.5357 | 4.5396 | 2267944.0 |
| 2007-08-13 10:15:00 | AAPL | Stock | 4.5393 | 4.5464 | 4.5375 | 4.5464 | 1002820.0 |
| 2007-08-13 10:16:00 | AAPL | Stock | 4.5464 | 4.5571 | 4.545 | 4.5571 | 3201828.0 |
| 2007-08-13 10:17:00 | AAPL | Stock | 4.5571 | 4.5625 | 4.5486 | 4.5514 | 3626896.0 |
| 2007-08-13 10:18:00 | AAPL | Stock | 4.5521 | 4.5596 | 4.5511 | 4.5575 | 2280236.0 |
| 2007-08-13 10:19:00 | AAPL | Stock | 4.5582 | 4.5596 | 4.55 | 4.5568 | 1810340.0 |
> showing 50 of 1,030,155 rows — these rows as CSV