PREVIEW / stock_1min / 2010-02-12
file: by_date/stock_1min/2010/2010-02-12.parquet size: 12.4 MB rows: 943,022 symbols: 2,790
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-02-12 04:57:00 | AAPL | Stock | 7.0964 | 7.0964 | 7.0964 | 7.0964 | 2800.0 |
| 2010-02-12 05:29:00 | AAPL | Stock | 7.0604 | 7.0604 | 7.0604 | 7.0604 | 5600.0 |
| 2010-02-12 05:34:00 | AAPL | Stock | 7.0511 | 7.0511 | 7.0511 | 7.0511 | 5292.0 |
| 2010-02-12 06:13:00 | AAPL | Stock | 7.0439 | 7.0439 | 7.0439 | 7.0439 | 2800.0 |
| 2010-02-12 06:32:00 | AAPL | Stock | 7.0361 | 7.0361 | 7.0361 | 7.0361 | 2800.0 |
| 2010-02-12 06:33:00 | AAPL | Stock | 7.0332 | 7.0332 | 7.0332 | 7.0332 | 5600.0 |
| 2010-02-12 06:34:00 | AAPL | Stock | 7.0357 | 7.0357 | 7.0357 | 7.0357 | 5600.0 |
| 2010-02-12 06:35:00 | AAPL | Stock | 7.0236 | 7.0236 | 7.0236 | 7.0236 | 2800.0 |
| 2010-02-12 07:01:00 | AAPL | Stock | 7.0511 | 7.0511 | 7.0511 | 7.0511 | 2800.0 |
| 2010-02-12 07:25:00 | AAPL | Stock | 7.0657 | 7.0689 | 7.0657 | 7.0657 | 11200.0 |
| 2010-02-12 07:27:00 | AAPL | Stock | 7.0768 | 7.0771 | 7.0764 | 7.0764 | 31276.0 |
| 2010-02-12 07:28:00 | AAPL | Stock | 7.0779 | 7.0779 | 7.0764 | 7.0764 | 15400.0 |
| 2010-02-12 07:42:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0711 | 7.0711 | 111860.0 |
| 2010-02-12 07:43:00 | AAPL | Stock | 7.0668 | 7.0668 | 7.0668 | 7.0668 | 15400.0 |
| 2010-02-12 07:44:00 | AAPL | Stock | 7.0668 | 7.0686 | 7.0668 | 7.0686 | 5600.0 |
| 2010-02-12 07:47:00 | AAPL | Stock | 7.0707 | 7.0714 | 7.0707 | 7.0711 | 86800.0 |
| 2010-02-12 07:48:00 | AAPL | Stock | 7.0682 | 7.0682 | 7.0679 | 7.0679 | 61600.0 |
| 2010-02-12 07:49:00 | AAPL | Stock | 7.0664 | 7.0664 | 7.0661 | 7.0661 | 5600.0 |
| 2010-02-12 07:56:00 | AAPL | Stock | 7.0657 | 7.0657 | 7.0639 | 7.0639 | 30800.0 |
| 2010-02-12 07:57:00 | AAPL | Stock | 7.0643 | 7.0643 | 7.0625 | 7.0625 | 28000.0 |
| 2010-02-12 07:58:00 | AAPL | Stock | 7.0625 | 7.0625 | 7.0625 | 7.0625 | 5600.0 |
| 2010-02-12 07:59:00 | AAPL | Stock | 7.0661 | 7.0682 | 7.0661 | 7.0682 | 11200.0 |
| 2010-02-12 08:00:00 | AAPL | Stock | 7.0714 | 7.0811 | 7.0629 | 7.0696 | 228508.0 |
| 2010-02-12 08:01:00 | AAPL | Stock | 7.0679 | 7.0714 | 7.0646 | 7.0646 | 43680.0 |
| 2010-02-12 08:02:00 | AAPL | Stock | 7.065 | 7.0679 | 7.0643 | 7.065 | 45500.0 |
| 2010-02-12 08:03:00 | AAPL | Stock | 7.065 | 7.075 | 7.065 | 7.075 | 92456.0 |
| 2010-02-12 08:04:00 | AAPL | Stock | 7.0732 | 7.0732 | 7.0732 | 7.0732 | 8400.0 |
| 2010-02-12 08:06:00 | AAPL | Stock | 7.0707 | 7.0714 | 7.0707 | 7.0707 | 30800.0 |
| 2010-02-12 08:07:00 | AAPL | Stock | 7.0679 | 7.0679 | 7.0636 | 7.0636 | 59668.0 |
| 2010-02-12 08:09:00 | AAPL | Stock | 7.0657 | 7.0657 | 7.0607 | 7.0607 | 19600.0 |
| 2010-02-12 08:10:00 | AAPL | Stock | 7.0593 | 7.0593 | 7.0571 | 7.0589 | 122248.0 |
| 2010-02-12 08:11:00 | AAPL | Stock | 7.0496 | 7.0496 | 7.0496 | 7.0496 | 4200.0 |
| 2010-02-12 08:12:00 | AAPL | Stock | 7.0568 | 7.0575 | 7.0568 | 7.0575 | 9800.0 |
| 2010-02-12 08:13:00 | AAPL | Stock | 7.0575 | 7.0575 | 7.0564 | 7.0564 | 23800.0 |
| 2010-02-12 08:14:00 | AAPL | Stock | 7.0568 | 7.0568 | 7.0561 | 7.0564 | 22820.0 |
| 2010-02-12 08:15:00 | AAPL | Stock | 7.0562 | 7.0564 | 7.0539 | 7.0539 | 41860.0 |
| 2010-02-12 08:16:00 | AAPL | Stock | 7.0561 | 7.0564 | 7.0525 | 7.0536 | 71428.0 |
| 2010-02-12 08:17:00 | AAPL | Stock | 7.0561 | 7.0571 | 7.0561 | 7.0571 | 5600.0 |
| 2010-02-12 08:18:00 | AAPL | Stock | 7.0614 | 7.0657 | 7.0614 | 7.0654 | 25200.0 |
| 2010-02-12 08:19:00 | AAPL | Stock | 7.0679 | 7.0679 | 7.0611 | 7.0632 | 8400.0 |
| 2010-02-12 08:20:00 | AAPL | Stock | 7.0632 | 7.0668 | 7.0632 | 7.0668 | 5600.0 |
| 2010-02-12 08:22:00 | AAPL | Stock | 7.0664 | 7.0664 | 7.065 | 7.065 | 5600.0 |
| 2010-02-12 08:23:00 | AAPL | Stock | 7.0675 | 7.0679 | 7.0661 | 7.0679 | 28000.0 |
| 2010-02-12 08:24:00 | AAPL | Stock | 7.0679 | 7.0679 | 7.0679 | 7.0679 | 86800.0 |
| 2010-02-12 08:25:00 | AAPL | Stock | 7.0679 | 7.0679 | 7.0679 | 7.0679 | 28000.0 |
| 2010-02-12 08:27:00 | AAPL | Stock | 7.0679 | 7.0679 | 7.0661 | 7.0668 | 67200.0 |
| 2010-02-12 08:28:00 | AAPL | Stock | 7.0668 | 7.0679 | 7.0668 | 7.0679 | 28000.0 |
| 2010-02-12 08:29:00 | AAPL | Stock | 7.0679 | 7.0679 | 7.0671 | 7.0671 | 14000.0 |
| 2010-02-12 08:30:00 | AAPL | Stock | 7.0679 | 7.0679 | 7.0657 | 7.0664 | 99512.0 |
| 2010-02-12 08:31:00 | AAPL | Stock | 7.0664 | 7.0707 | 7.0654 | 7.0707 | 57708.0 |
> showing 50 of 943,022 rows — these rows as CSV