PREVIEW / stock_1min / 2009-08-25
file: by_date/stock_1min/2009/2009-08-25.parquet size: 12.5 MB rows: 941,519 symbols: 2,729
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-25 06:35:00 | AAPL | Stock | 6.0182 | 6.0182 | 6.0182 | 6.0182 | 14000.0 |
| 2009-08-25 07:31:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 2800.0 |
| 2009-08-25 07:34:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 3360.0 |
| 2009-08-25 07:42:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 5600.0 |
| 2009-08-25 07:44:00 | AAPL | Stock | 6.0429 | 6.0429 | 6.0429 | 6.0429 | 2800.0 |
| 2009-08-25 07:54:00 | AAPL | Stock | 6.0429 | 6.0429 | 6.0429 | 6.0429 | 2800.0 |
| 2009-08-25 07:59:00 | AAPL | Stock | 6.0429 | 6.0429 | 6.0429 | 6.0429 | 5600.0 |
| 2009-08-25 08:00:00 | AAPL | Stock | 6.0432 | 6.0464 | 6.0432 | 6.0432 | 17780.0 |
| 2009-08-25 08:01:00 | AAPL | Stock | 6.0432 | 6.0436 | 6.0432 | 6.0436 | 35700.0 |
| 2009-08-25 08:02:00 | AAPL | Stock | 6.0432 | 6.0432 | 6.0432 | 6.0432 | 2800.0 |
| 2009-08-25 08:03:00 | AAPL | Stock | 6.0432 | 6.0432 | 6.0432 | 6.0432 | 11200.0 |
| 2009-08-25 08:05:00 | AAPL | Stock | 6.0432 | 6.0464 | 6.0432 | 6.0464 | 22064.0 |
| 2009-08-25 08:06:00 | AAPL | Stock | 6.05 | 6.0514 | 6.05 | 6.0514 | 44296.0 |
| 2009-08-25 08:07:00 | AAPL | Stock | 6.0518 | 6.0525 | 6.0518 | 6.0525 | 43596.0 |
| 2009-08-25 08:08:00 | AAPL | Stock | 6.0571 | 6.0571 | 6.0525 | 6.0525 | 7840.0 |
| 2009-08-25 08:09:00 | AAPL | Stock | 6.0571 | 6.0625 | 6.0536 | 6.0625 | 50820.0 |
| 2009-08-25 08:10:00 | AAPL | Stock | 6.0607 | 6.0607 | 6.0607 | 6.0607 | 5600.0 |
| 2009-08-25 08:11:00 | AAPL | Stock | 6.0607 | 6.0607 | 6.0607 | 6.0607 | 2800.0 |
| 2009-08-25 08:12:00 | AAPL | Stock | 6.0607 | 6.0607 | 6.0607 | 6.0607 | 41104.0 |
| 2009-08-25 08:13:00 | AAPL | Stock | 6.0607 | 6.0607 | 6.0607 | 6.0607 | 3640.0 |
| 2009-08-25 08:14:00 | AAPL | Stock | 6.0643 | 6.0654 | 6.0643 | 6.0654 | 5600.0 |
| 2009-08-25 08:15:00 | AAPL | Stock | 6.0671 | 6.0679 | 6.0671 | 6.0679 | 24332.0 |
| 2009-08-25 08:16:00 | AAPL | Stock | 6.0668 | 6.0714 | 6.0668 | 6.0714 | 166040.0 |
| 2009-08-25 08:17:00 | AAPL | Stock | 6.0714 | 6.0725 | 6.0711 | 6.0714 | 228340.0 |
| 2009-08-25 08:18:00 | AAPL | Stock | 6.0718 | 6.0718 | 6.0711 | 6.0714 | 202720.0 |
| 2009-08-25 08:19:00 | AAPL | Stock | 6.0693 | 6.0714 | 6.0693 | 6.0714 | 30240.0 |
| 2009-08-25 08:20:00 | AAPL | Stock | 6.0711 | 6.0714 | 6.0707 | 6.0714 | 8960.0 |
| 2009-08-25 08:21:00 | AAPL | Stock | 6.0696 | 6.0714 | 6.0696 | 6.0714 | 19600.0 |
| 2009-08-25 08:22:00 | AAPL | Stock | 6.0704 | 6.0718 | 6.0704 | 6.0714 | 109200.0 |
| 2009-08-25 08:23:00 | AAPL | Stock | 6.0714 | 6.0714 | 6.0714 | 6.0714 | 13720.0 |
| 2009-08-25 08:25:00 | AAPL | Stock | 6.0714 | 6.0714 | 6.0661 | 6.0661 | 18900.0 |
| 2009-08-25 08:26:00 | AAPL | Stock | 6.0646 | 6.065 | 6.0646 | 6.0646 | 33600.0 |
| 2009-08-25 08:27:00 | AAPL | Stock | 6.0668 | 6.0668 | 6.0661 | 6.0661 | 5600.0 |
| 2009-08-25 08:29:00 | AAPL | Stock | 6.0661 | 6.0661 | 6.0661 | 6.0661 | 25200.0 |
| 2009-08-25 08:30:00 | AAPL | Stock | 6.0643 | 6.0675 | 6.0643 | 6.0675 | 28000.0 |
| 2009-08-25 08:31:00 | AAPL | Stock | 6.065 | 6.065 | 6.065 | 6.065 | 4200.0 |
| 2009-08-25 08:32:00 | AAPL | Stock | 6.0629 | 6.0629 | 6.0629 | 6.0629 | 2800.0 |
| 2009-08-25 08:33:00 | AAPL | Stock | 6.0632 | 6.0632 | 6.0629 | 6.0632 | 37800.0 |
| 2009-08-25 08:34:00 | AAPL | Stock | 6.0607 | 6.0607 | 6.0607 | 6.0607 | 22400.0 |
| 2009-08-25 08:35:00 | AAPL | Stock | 6.0632 | 6.0632 | 6.0632 | 6.0632 | 2800.0 |
| 2009-08-25 08:37:00 | AAPL | Stock | 6.0639 | 6.0643 | 6.0639 | 6.0643 | 5600.0 |
| 2009-08-25 08:39:00 | AAPL | Stock | 6.0632 | 6.0632 | 6.0632 | 6.0632 | 5600.0 |
| 2009-08-25 08:40:00 | AAPL | Stock | 6.0632 | 6.0636 | 6.0632 | 6.0636 | 16800.0 |
| 2009-08-25 08:41:00 | AAPL | Stock | 6.0661 | 6.0661 | 6.0661 | 6.0661 | 13748.0 |
| 2009-08-25 08:42:00 | AAPL | Stock | 6.0632 | 6.0679 | 6.0632 | 6.0661 | 58800.0 |
| 2009-08-25 08:43:00 | AAPL | Stock | 6.0661 | 6.0661 | 6.0661 | 6.0661 | 2800.0 |
| 2009-08-25 08:45:00 | AAPL | Stock | 6.0661 | 6.0661 | 6.0661 | 6.0661 | 11116.0 |
| 2009-08-25 08:46:00 | AAPL | Stock | 6.0668 | 6.0679 | 6.0661 | 6.0679 | 19600.0 |
| 2009-08-25 08:47:00 | AAPL | Stock | 6.0679 | 6.0696 | 6.0664 | 6.0696 | 47880.0 |
| 2009-08-25 08:48:00 | AAPL | Stock | 6.0696 | 6.0696 | 6.0682 | 6.0682 | 34580.0 |
> showing 50 of 941,519 rows — these rows as CSV