PREVIEW / stock_1min / 2007-05-24
file: by_date/stock_1min/2007/2007-05-24.parquet size: 11.5 MB rows: 927,337 symbols: 2,473
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-05-24 09:30:00 | AAPL | Stock | 4.0289 | 4.0336 | 4.0275 | 4.0329 | 7134624.0 |
| 2007-05-24 09:31:00 | AAPL | Stock | 4.0329 | 4.0357 | 4.0321 | 4.0339 | 2845892.0 |
| 2007-05-24 09:32:00 | AAPL | Stock | 4.0339 | 4.0343 | 4.0271 | 4.0271 | 4994248.0 |
| 2007-05-24 09:33:00 | AAPL | Stock | 4.0275 | 4.0275 | 4.0125 | 4.021 | 5222224.0 |
| 2007-05-24 09:34:00 | AAPL | Stock | 4.0214 | 4.0321 | 4.0207 | 4.0314 | 2525796.0 |
| 2007-05-24 09:35:00 | AAPL | Stock | 4.0318 | 4.0454 | 4.0286 | 4.0386 | 5374208.0 |
| 2007-05-24 09:36:00 | AAPL | Stock | 4.045 | 4.045 | 4.035 | 4.0357 | 6233248.0 |
| 2007-05-24 09:37:00 | AAPL | Stock | 4.0346 | 4.0625 | 4.025 | 4.0257 | 4158364.0 |
| 2007-05-24 09:38:00 | AAPL | Stock | 4.0264 | 4.0321 | 4.025 | 4.0289 | 2689568.0 |
| 2007-05-24 09:39:00 | AAPL | Stock | 4.0293 | 4.0357 | 4.0261 | 4.0317 | 2689344.0 |
| 2007-05-24 09:40:00 | AAPL | Stock | 4.0314 | 4.0346 | 4.0314 | 4.0336 | 2772420.0 |
| 2007-05-24 09:41:00 | AAPL | Stock | 4.0336 | 4.0406 | 4.0325 | 4.0371 | 5490436.0 |
| 2007-05-24 09:42:00 | AAPL | Stock | 4.0371 | 4.0393 | 4.0343 | 4.035 | 2713564.0 |
| 2007-05-24 09:43:00 | AAPL | Stock | 4.035 | 4.0411 | 4.0343 | 4.0393 | 1745968.0 |
| 2007-05-24 09:44:00 | AAPL | Stock | 4.04 | 4.0425 | 4.0361 | 4.0386 | 2211440.0 |
| 2007-05-24 09:45:00 | AAPL | Stock | 4.0379 | 4.0439 | 4.0375 | 4.0418 | 2128056.0 |
| 2007-05-24 09:46:00 | AAPL | Stock | 4.0414 | 4.0532 | 4.0344 | 4.0344 | 3359972.0 |
| 2007-05-24 09:47:00 | AAPL | Stock | 4.0536 | 4.0589 | 4.0514 | 4.0564 | 3264128.0 |
| 2007-05-24 09:48:00 | AAPL | Stock | 4.0557 | 4.0589 | 4.055 | 4.0579 | 1687756.0 |
| 2007-05-24 09:49:00 | AAPL | Stock | 4.0577 | 4.0589 | 4.0554 | 4.0554 | 3474296.0 |
| 2007-05-24 09:50:00 | AAPL | Stock | 4.055 | 4.0657 | 4.055 | 4.0589 | 3711904.0 |
| 2007-05-24 09:51:00 | AAPL | Stock | 4.0589 | 4.0604 | 4.0504 | 4.0532 | 3516240.0 |
| 2007-05-24 09:52:00 | AAPL | Stock | 4.0532 | 4.0561 | 4.0493 | 4.0529 | 3009188.0 |
| 2007-05-24 09:53:00 | AAPL | Stock | 4.0532 | 4.0561 | 4.05 | 4.0554 | 2116772.0 |
| 2007-05-24 09:54:00 | AAPL | Stock | 4.0557 | 4.0561 | 4.0529 | 4.0529 | 1994496.0 |
| 2007-05-24 09:55:00 | AAPL | Stock | 4.0525 | 4.0568 | 4.0511 | 4.0564 | 1751680.0 |
| 2007-05-24 09:56:00 | AAPL | Stock | 4.0561 | 4.0575 | 4.0529 | 4.0529 | 1571248.0 |
| 2007-05-24 09:57:00 | AAPL | Stock | 4.0525 | 4.0561 | 4.0496 | 4.0554 | 2176468.0 |
| 2007-05-24 09:58:00 | AAPL | Stock | 4.0554 | 4.0575 | 4.0532 | 4.0539 | 1528464.0 |
| 2007-05-24 09:59:00 | AAPL | Stock | 4.0536 | 4.055 | 4.05 | 4.055 | 1326052.0 |
| 2007-05-24 10:00:00 | AAPL | Stock | 4.055 | 4.0571 | 4.0536 | 4.0561 | 4598132.0 |
| 2007-05-24 10:01:00 | AAPL | Stock | 4.0557 | 4.0629 | 4.0529 | 4.0625 | 2388792.0 |
| 2007-05-24 10:02:00 | AAPL | Stock | 4.0629 | 4.0668 | 4.0607 | 4.0643 | 4284028.0 |
| 2007-05-24 10:03:00 | AAPL | Stock | 4.0643 | 4.0707 | 4.0639 | 4.0707 | 5829236.0 |
| 2007-05-24 10:04:00 | AAPL | Stock | 4.0707 | 4.0729 | 4.0661 | 4.0696 | 8573712.0 |
| 2007-05-24 10:05:00 | AAPL | Stock | 4.0696 | 4.0711 | 4.0664 | 4.0693 | 2693600.0 |
| 2007-05-24 10:06:00 | AAPL | Stock | 4.0696 | 4.0793 | 4.0693 | 4.0793 | 4936680.0 |
| 2007-05-24 10:07:00 | AAPL | Stock | 4.08 | 4.0879 | 4.0775 | 4.0789 | 7398888.0 |
| 2007-05-24 10:08:00 | AAPL | Stock | 4.0782 | 4.0829 | 4.0779 | 4.0811 | 3196620.0 |
| 2007-05-24 10:09:00 | AAPL | Stock | 4.0814 | 4.0846 | 4.0782 | 4.0789 | 2354604.0 |
| 2007-05-24 10:10:00 | AAPL | Stock | 4.0793 | 4.0811 | 4.0746 | 4.0775 | 2386216.0 |
| 2007-05-24 10:11:00 | AAPL | Stock | 4.0771 | 4.0779 | 4.0739 | 4.0761 | 2561804.0 |
| 2007-05-24 10:12:00 | AAPL | Stock | 4.0764 | 4.0796 | 4.0739 | 4.0746 | 1585892.0 |
| 2007-05-24 10:13:00 | AAPL | Stock | 4.0754 | 4.0771 | 4.0742 | 4.0746 | 1593032.0 |
| 2007-05-24 10:14:00 | AAPL | Stock | 4.0743 | 4.075 | 4.0664 | 4.0711 | 4443152.0 |
| 2007-05-24 10:15:00 | AAPL | Stock | 4.0711 | 4.0714 | 4.0689 | 4.0711 | 1777272.0 |
| 2007-05-24 10:16:00 | AAPL | Stock | 4.0711 | 4.0714 | 4.0686 | 4.0711 | 2471840.0 |
| 2007-05-24 10:17:00 | AAPL | Stock | 4.0711 | 4.0711 | 4.0675 | 4.0682 | 2185792.0 |
| 2007-05-24 10:18:00 | AAPL | Stock | 4.0686 | 4.0732 | 4.0675 | 4.0714 | 2237480.0 |
| 2007-05-24 10:19:00 | AAPL | Stock | 4.0714 | 4.0714 | 4.0679 | 4.0693 | 805140.0 |
> showing 50 of 927,337 rows — these rows as CSV