PREVIEW / stock_1min / 2010-08-19
file: by_date/stock_1min/2010/2010-08-19.parquet size: 12.7 MB rows: 978,290 symbols: 2,824
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-19 06:11:00 | AAPL | Stock | 9.065 | 9.065 | 9.065 | 9.065 | 7000.0 |
| 2010-08-19 06:14:00 | AAPL | Stock | 9.0661 | 9.0661 | 9.0661 | 9.0661 | 2800.0 |
| 2010-08-19 07:24:00 | AAPL | Stock | 9.0643 | 9.0643 | 9.0643 | 9.0643 | 11200.0 |
| 2010-08-19 07:28:00 | AAPL | Stock | 9.0625 | 9.0625 | 9.0625 | 9.0625 | 2800.0 |
| 2010-08-19 07:31:00 | AAPL | Stock | 9.0564 | 9.0564 | 9.0564 | 9.0564 | 7000.0 |
| 2010-08-19 07:33:00 | AAPL | Stock | 9.0564 | 9.0564 | 9.0564 | 9.0564 | 5600.0 |
| 2010-08-19 07:34:00 | AAPL | Stock | 9.0561 | 9.0561 | 9.0557 | 9.0557 | 15120.0 |
| 2010-08-19 07:40:00 | AAPL | Stock | 9.0532 | 9.0536 | 9.0529 | 9.0529 | 25200.0 |
| 2010-08-19 07:44:00 | AAPL | Stock | 9.0529 | 9.0529 | 9.0529 | 9.0529 | 2800.0 |
| 2010-08-19 07:45:00 | AAPL | Stock | 9.0529 | 9.0529 | 9.0529 | 9.0529 | 5600.0 |
| 2010-08-19 07:46:00 | AAPL | Stock | 9.0529 | 9.0529 | 9.0529 | 9.0529 | 14000.0 |
| 2010-08-19 07:47:00 | AAPL | Stock | 9.0529 | 9.0529 | 9.0529 | 9.0529 | 2800.0 |
| 2010-08-19 07:55:00 | AAPL | Stock | 9.0518 | 9.0518 | 9.0518 | 9.0518 | 2800.0 |
| 2010-08-19 08:00:00 | AAPL | Stock | 9.0589 | 9.0589 | 9.0518 | 9.0525 | 36400.0 |
| 2010-08-19 08:02:00 | AAPL | Stock | 9.0518 | 9.0518 | 9.0507 | 9.0507 | 68040.0 |
| 2010-08-19 08:03:00 | AAPL | Stock | 9.0514 | 9.0589 | 9.0514 | 9.0571 | 77560.0 |
| 2010-08-19 08:04:00 | AAPL | Stock | 9.0536 | 9.0589 | 9.0536 | 9.0571 | 53760.0 |
| 2010-08-19 08:05:00 | AAPL | Stock | 9.0586 | 9.0621 | 9.0586 | 9.0621 | 14980.0 |
| 2010-08-19 08:06:00 | AAPL | Stock | 9.0621 | 9.0621 | 9.0621 | 9.0621 | 8400.0 |
| 2010-08-19 08:07:00 | AAPL | Stock | 9.0621 | 9.0696 | 9.0621 | 9.0696 | 90860.0 |
| 2010-08-19 08:08:00 | AAPL | Stock | 9.0696 | 9.0714 | 9.0682 | 9.0714 | 94220.0 |
| 2010-08-19 08:09:00 | AAPL | Stock | 9.0714 | 9.075 | 9.0714 | 9.0714 | 19600.0 |
| 2010-08-19 08:10:00 | AAPL | Stock | 9.075 | 9.075 | 9.075 | 9.075 | 8400.0 |
| 2010-08-19 08:11:00 | AAPL | Stock | 9.0743 | 9.0746 | 9.0732 | 9.0746 | 16800.0 |
| 2010-08-19 08:12:00 | AAPL | Stock | 9.0718 | 9.0718 | 9.0675 | 9.0675 | 25200.0 |
| 2010-08-19 08:13:00 | AAPL | Stock | 9.0707 | 9.0714 | 9.0643 | 9.0643 | 78400.0 |
| 2010-08-19 08:14:00 | AAPL | Stock | 9.0661 | 9.0661 | 9.0657 | 9.0657 | 5600.0 |
| 2010-08-19 08:15:00 | AAPL | Stock | 9.0671 | 9.0671 | 9.0632 | 9.0661 | 44800.0 |
| 2010-08-19 08:16:00 | AAPL | Stock | 9.0661 | 9.0679 | 9.0661 | 9.0679 | 22400.0 |
| 2010-08-19 08:17:00 | AAPL | Stock | 9.0679 | 9.0679 | 9.0679 | 9.0679 | 5600.0 |
| 2010-08-19 08:18:00 | AAPL | Stock | 9.0679 | 9.0679 | 9.0625 | 9.0625 | 58688.0 |
| 2010-08-19 08:19:00 | AAPL | Stock | 9.0625 | 9.0625 | 9.0625 | 9.0625 | 11200.0 |
| 2010-08-19 08:20:00 | AAPL | Stock | 9.0643 | 9.0689 | 9.0643 | 9.0689 | 16044.0 |
| 2010-08-19 08:21:00 | AAPL | Stock | 9.0686 | 9.0775 | 9.0686 | 9.0775 | 64400.0 |
| 2010-08-19 08:22:00 | AAPL | Stock | 9.0775 | 9.0839 | 9.0775 | 9.0839 | 56000.0 |
| 2010-08-19 08:23:00 | AAPL | Stock | 9.0839 | 9.0857 | 9.0804 | 9.0857 | 46900.0 |
| 2010-08-19 08:24:00 | AAPL | Stock | 9.0804 | 9.0804 | 9.0786 | 9.0786 | 16800.0 |
| 2010-08-19 08:25:00 | AAPL | Stock | 9.0818 | 9.0818 | 9.0818 | 9.0818 | 8400.0 |
| 2010-08-19 08:26:00 | AAPL | Stock | 9.0811 | 9.0818 | 9.0811 | 9.0818 | 11200.0 |
| 2010-08-19 08:27:00 | AAPL | Stock | 9.0814 | 9.0821 | 9.0811 | 9.0814 | 62160.0 |
| 2010-08-19 08:28:00 | AAPL | Stock | 9.0804 | 9.0843 | 9.0804 | 9.0843 | 19600.0 |
| 2010-08-19 08:29:00 | AAPL | Stock | 9.0839 | 9.0857 | 9.0786 | 9.0786 | 76020.0 |
| 2010-08-19 08:30:00 | AAPL | Stock | 9.085 | 9.0854 | 9.0196 | 9.0536 | 548968.0 |
| 2010-08-19 08:31:00 | AAPL | Stock | 9.0611 | 9.0611 | 9.0268 | 9.0321 | 116144.0 |
| 2010-08-19 08:32:00 | AAPL | Stock | 9.0375 | 9.0464 | 9.0357 | 9.0364 | 88200.0 |
| 2010-08-19 08:33:00 | AAPL | Stock | 9.0436 | 9.0436 | 9.0146 | 9.0146 | 373660.0 |
| 2010-08-19 08:34:00 | AAPL | Stock | 9.0129 | 9.0179 | 9.0 | 9.0071 | 211568.0 |
| 2010-08-19 08:35:00 | AAPL | Stock | 9.0061 | 9.0118 | 8.9968 | 9.0118 | 154336.0 |
| 2010-08-19 08:36:00 | AAPL | Stock | 9.0118 | 9.0175 | 9.0057 | 9.0061 | 72184.0 |
| 2010-08-19 08:37:00 | AAPL | Stock | 9.0111 | 9.0132 | 9.0054 | 9.0089 | 73416.0 |
> showing 50 of 978,290 rows — these rows as CSV