PREVIEW / stock_1min / 2007-07-20
file: by_date/stock_1min/2007/2007-07-20.parquet size: 11.8 MB rows: 958,422 symbols: 2,508
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-07-20 09:30:00 | AAPL | Stock | 5.0589 | 5.0604 | 5.0432 | 5.0443 | 66210368.0 |
| 2007-07-20 09:31:00 | AAPL | Stock | 5.0446 | 5.06 | 5.0443 | 5.0482 | 4198236.0 |
| 2007-07-20 09:32:00 | AAPL | Stock | 5.0482 | 5.0504 | 5.0393 | 5.0411 | 5810896.0 |
| 2007-07-20 09:33:00 | AAPL | Stock | 5.0411 | 5.0586 | 5.0408 | 5.0586 | 7472696.0 |
| 2007-07-20 09:34:00 | AAPL | Stock | 5.0586 | 5.0625 | 5.0393 | 5.0621 | 6904660.0 |
| 2007-07-20 09:35:00 | AAPL | Stock | 5.0618 | 5.0657 | 5.0536 | 5.0579 | 7075208.0 |
| 2007-07-20 09:36:00 | AAPL | Stock | 5.0582 | 5.0618 | 5.0546 | 5.0575 | 3794616.0 |
| 2007-07-20 09:37:00 | AAPL | Stock | 5.0571 | 5.0571 | 5.0496 | 5.05 | 4592392.0 |
| 2007-07-20 09:38:00 | AAPL | Stock | 5.0504 | 5.0557 | 5.05 | 5.0536 | 3143056.0 |
| 2007-07-20 09:39:00 | AAPL | Stock | 5.0536 | 5.0554 | 5.0532 | 5.0543 | 2468424.0 |
| 2007-07-20 09:40:00 | AAPL | Stock | 5.0543 | 5.0593 | 5.0539 | 5.0589 | 3316460.0 |
| 2007-07-20 09:41:00 | AAPL | Stock | 5.0589 | 5.0589 | 5.0568 | 5.0568 | 4454156.0 |
| 2007-07-20 09:42:00 | AAPL | Stock | 5.0571 | 5.0625 | 5.0568 | 5.0593 | 2756768.0 |
| 2007-07-20 09:43:00 | AAPL | Stock | 5.0589 | 5.0592 | 5.0525 | 5.0567 | 3656128.0 |
| 2007-07-20 09:44:00 | AAPL | Stock | 5.0564 | 5.0582 | 5.0525 | 5.0536 | 2864736.0 |
| 2007-07-20 09:45:00 | AAPL | Stock | 5.0532 | 5.0539 | 5.05 | 5.0529 | 2829876.0 |
| 2007-07-20 09:46:00 | AAPL | Stock | 5.0529 | 5.0529 | 5.0482 | 5.0496 | 2784544.0 |
| 2007-07-20 09:47:00 | AAPL | Stock | 5.05 | 5.05 | 5.0446 | 5.0461 | 2447004.0 |
| 2007-07-20 09:48:00 | AAPL | Stock | 5.0464 | 5.0489 | 5.0461 | 5.0482 | 3091396.0 |
| 2007-07-20 09:49:00 | AAPL | Stock | 5.0479 | 5.0514 | 5.0468 | 5.0479 | 3064376.0 |
| 2007-07-20 09:50:00 | AAPL | Stock | 5.0479 | 5.0514 | 5.0471 | 5.0514 | 3355884.0 |
| 2007-07-20 09:51:00 | AAPL | Stock | 5.0511 | 5.0554 | 5.0489 | 5.0531 | 2954112.0 |
| 2007-07-20 09:52:00 | AAPL | Stock | 5.0536 | 5.0536 | 5.0482 | 5.05 | 3098620.0 |
| 2007-07-20 09:53:00 | AAPL | Stock | 5.05 | 5.0525 | 5.0496 | 5.0507 | 1654324.0 |
| 2007-07-20 09:54:00 | AAPL | Stock | 5.0507 | 5.0507 | 5.0457 | 5.0457 | 3526320.0 |
| 2007-07-20 09:55:00 | AAPL | Stock | 5.0454 | 5.0461 | 5.0321 | 5.0321 | 6894300.0 |
| 2007-07-20 09:56:00 | AAPL | Stock | 5.0321 | 5.0339 | 5.0179 | 5.0189 | 12374348.0 |
| 2007-07-20 09:57:00 | AAPL | Stock | 5.0189 | 5.03 | 5.0139 | 5.0286 | 8988448.0 |
| 2007-07-20 09:58:00 | AAPL | Stock | 5.0279 | 5.0289 | 5.0179 | 5.0254 | 5927628.0 |
| 2007-07-20 09:59:00 | AAPL | Stock | 5.0257 | 5.0304 | 5.0232 | 5.03 | 3194632.0 |
| 2007-07-20 10:00:00 | AAPL | Stock | 5.0293 | 5.0307 | 5.0239 | 5.0264 | 3628016.0 |
| 2007-07-20 10:01:00 | AAPL | Stock | 5.0257 | 5.0325 | 5.0257 | 5.0325 | 2602208.0 |
| 2007-07-20 10:02:00 | AAPL | Stock | 5.0321 | 5.0339 | 5.0286 | 5.0304 | 2452856.0 |
| 2007-07-20 10:03:00 | AAPL | Stock | 5.0304 | 5.0375 | 5.03 | 5.0368 | 2342844.0 |
| 2007-07-20 10:04:00 | AAPL | Stock | 5.0368 | 5.0389 | 5.0368 | 5.0379 | 3341156.0 |
| 2007-07-20 10:05:00 | AAPL | Stock | 5.0379 | 5.0396 | 5.0368 | 5.0382 | 3036180.0 |
| 2007-07-20 10:06:00 | AAPL | Stock | 5.0386 | 5.0414 | 5.0379 | 5.0411 | 2369976.0 |
| 2007-07-20 10:07:00 | AAPL | Stock | 5.04 | 5.0418 | 5.0386 | 5.04 | 2228464.0 |
| 2007-07-20 10:08:00 | AAPL | Stock | 5.04 | 5.0432 | 5.0396 | 5.0411 | 1985228.0 |
| 2007-07-20 10:09:00 | AAPL | Stock | 5.0414 | 5.0414 | 5.0368 | 5.0386 | 2860704.0 |
| 2007-07-20 10:10:00 | AAPL | Stock | 5.0386 | 5.0393 | 5.0304 | 5.0307 | 3383576.0 |
| 2007-07-20 10:11:00 | AAPL | Stock | 5.0311 | 5.0357 | 5.0289 | 5.035 | 2151884.0 |
| 2007-07-20 10:12:00 | AAPL | Stock | 5.035 | 5.0375 | 5.0311 | 5.0371 | 2341864.0 |
| 2007-07-20 10:13:00 | AAPL | Stock | 5.0371 | 5.0393 | 5.0332 | 5.0386 | 2040388.0 |
| 2007-07-20 10:14:00 | AAPL | Stock | 5.0386 | 5.0407 | 5.0375 | 5.0386 | 2394812.0 |
| 2007-07-20 10:15:00 | AAPL | Stock | 5.0382 | 5.0382 | 5.0332 | 5.035 | 1878184.0 |
| 2007-07-20 10:16:00 | AAPL | Stock | 5.035 | 5.0371 | 5.0336 | 5.0368 | 1636992.0 |
| 2007-07-20 10:17:00 | AAPL | Stock | 5.0368 | 5.0386 | 5.0357 | 5.0374 | 1842092.0 |
| 2007-07-20 10:18:00 | AAPL | Stock | 5.0375 | 5.0375 | 5.0304 | 5.0336 | 3953880.0 |
| 2007-07-20 10:19:00 | AAPL | Stock | 5.0336 | 5.0354 | 5.0304 | 5.0336 | 2237592.0 |
> showing 50 of 958,422 rows — these rows as CSV