PREVIEW / stock_1min / 2009-02-17
file: by_date/stock_1min/2009/2009-02-17.parquet size: 12.2 MB rows: 959,983 symbols: 2,682
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-02-17 04:15:00 | AAPL | Stock | 3.5182 | 3.5182 | 3.5182 | 3.5182 | 2800.0 |
| 2009-02-17 05:30:00 | AAPL | Stock | 3.4821 | 3.4821 | 3.4821 | 3.4821 | 2800.0 |
| 2009-02-17 07:34:00 | AAPL | Stock | 3.4714 | 3.4714 | 3.4714 | 3.4714 | 5600.0 |
| 2009-02-17 07:37:00 | AAPL | Stock | 3.4707 | 3.4714 | 3.4707 | 3.4714 | 14000.0 |
| 2009-02-17 07:39:00 | AAPL | Stock | 3.4696 | 3.4696 | 3.4696 | 3.4696 | 8400.0 |
| 2009-02-17 07:40:00 | AAPL | Stock | 3.4682 | 3.4682 | 3.4682 | 3.4682 | 3724.0 |
| 2009-02-17 07:43:00 | AAPL | Stock | 3.4679 | 3.4679 | 3.4679 | 3.4679 | 4620.0 |
| 2009-02-17 07:44:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4643 | 3.4643 | 2800.0 |
| 2009-02-17 07:51:00 | AAPL | Stock | 3.4571 | 3.4571 | 3.4571 | 3.4571 | 2800.0 |
| 2009-02-17 07:55:00 | AAPL | Stock | 3.4639 | 3.4643 | 3.4639 | 3.4643 | 5600.0 |
| 2009-02-17 07:56:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4643 | 3.4643 | 5600.0 |
| 2009-02-17 08:00:00 | AAPL | Stock | 3.4696 | 3.4714 | 3.4575 | 3.4714 | 15680.0 |
| 2009-02-17 08:01:00 | AAPL | Stock | 3.4714 | 3.4818 | 3.4714 | 3.4818 | 16800.0 |
| 2009-02-17 08:02:00 | AAPL | Stock | 3.4714 | 3.4796 | 3.4714 | 3.4796 | 17892.0 |
| 2009-02-17 08:03:00 | AAPL | Stock | 3.4814 | 3.4814 | 3.4718 | 3.4718 | 19208.0 |
| 2009-02-17 08:04:00 | AAPL | Stock | 3.4786 | 3.4786 | 3.4714 | 3.4714 | 32760.0 |
| 2009-02-17 08:07:00 | AAPL | Stock | 3.4732 | 3.4732 | 3.4732 | 3.4732 | 2800.0 |
| 2009-02-17 08:08:00 | AAPL | Stock | 3.475 | 3.475 | 3.475 | 3.475 | 2800.0 |
| 2009-02-17 08:09:00 | AAPL | Stock | 3.4732 | 3.4736 | 3.4732 | 3.4736 | 16800.0 |
| 2009-02-17 08:10:00 | AAPL | Stock | 3.4746 | 3.4746 | 3.4746 | 3.4746 | 28000.0 |
| 2009-02-17 08:11:00 | AAPL | Stock | 3.4764 | 3.4764 | 3.475 | 3.4754 | 19320.0 |
| 2009-02-17 08:13:00 | AAPL | Stock | 3.4768 | 3.4768 | 3.4768 | 3.4768 | 2800.0 |
| 2009-02-17 08:14:00 | AAPL | Stock | 3.4786 | 3.4786 | 3.4768 | 3.4768 | 11200.0 |
| 2009-02-17 08:15:00 | AAPL | Stock | 3.4796 | 3.4821 | 3.4782 | 3.4804 | 26012.0 |
| 2009-02-17 08:17:00 | AAPL | Stock | 3.4786 | 3.4818 | 3.4786 | 3.4818 | 56000.0 |
| 2009-02-17 08:18:00 | AAPL | Stock | 3.4786 | 3.4786 | 3.4732 | 3.4732 | 26376.0 |
| 2009-02-17 08:20:00 | AAPL | Stock | 3.4714 | 3.4786 | 3.4714 | 3.4786 | 15400.0 |
| 2009-02-17 08:21:00 | AAPL | Stock | 3.4779 | 3.4779 | 3.4779 | 3.4779 | 4200.0 |
| 2009-02-17 08:24:00 | AAPL | Stock | 3.4732 | 3.4732 | 3.4732 | 3.4732 | 13636.0 |
| 2009-02-17 08:25:00 | AAPL | Stock | 3.475 | 3.475 | 3.4732 | 3.4732 | 14000.0 |
| 2009-02-17 08:26:00 | AAPL | Stock | 3.4779 | 3.4779 | 3.4779 | 3.4779 | 5600.0 |
| 2009-02-17 08:28:00 | AAPL | Stock | 3.475 | 3.475 | 3.475 | 3.475 | 5600.0 |
| 2009-02-17 08:30:00 | AAPL | Stock | 3.4764 | 3.4779 | 3.4714 | 3.4714 | 17920.0 |
| 2009-02-17 08:31:00 | AAPL | Stock | 3.4689 | 3.4689 | 3.4679 | 3.4679 | 23940.0 |
| 2009-02-17 08:32:00 | AAPL | Stock | 3.4664 | 3.4664 | 3.4618 | 3.4618 | 39480.0 |
| 2009-02-17 08:33:00 | AAPL | Stock | 3.4579 | 3.4579 | 3.4579 | 3.4579 | 15932.0 |
| 2009-02-17 08:34:00 | AAPL | Stock | 3.4571 | 3.4579 | 3.4571 | 3.4571 | 146552.0 |
| 2009-02-17 08:35:00 | AAPL | Stock | 3.4571 | 3.4575 | 3.4571 | 3.4575 | 53200.0 |
| 2009-02-17 08:36:00 | AAPL | Stock | 3.4575 | 3.4646 | 3.4575 | 3.4646 | 63980.0 |
| 2009-02-17 08:37:00 | AAPL | Stock | 3.4646 | 3.465 | 3.4639 | 3.4643 | 234920.0 |
| 2009-02-17 08:38:00 | AAPL | Stock | 3.4593 | 3.4639 | 3.4589 | 3.4604 | 89600.0 |
| 2009-02-17 08:39:00 | AAPL | Stock | 3.4604 | 3.4607 | 3.4596 | 3.4596 | 40600.0 |
| 2009-02-17 08:40:00 | AAPL | Stock | 3.46 | 3.46 | 3.4593 | 3.4596 | 11200.0 |
| 2009-02-17 08:41:00 | AAPL | Stock | 3.4593 | 3.4596 | 3.4589 | 3.4589 | 70000.0 |
| 2009-02-17 08:42:00 | AAPL | Stock | 3.4593 | 3.4593 | 3.4593 | 3.4593 | 95200.0 |
| 2009-02-17 08:43:00 | AAPL | Stock | 3.4593 | 3.4593 | 3.4593 | 3.4593 | 70000.0 |
| 2009-02-17 08:44:00 | AAPL | Stock | 3.4589 | 3.4611 | 3.4589 | 3.4611 | 5600.0 |
| 2009-02-17 08:45:00 | AAPL | Stock | 3.4654 | 3.4675 | 3.4636 | 3.4636 | 11200.0 |
| 2009-02-17 08:46:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4621 | 3.4621 | 25200.0 |
| 2009-02-17 08:50:00 | AAPL | Stock | 3.4636 | 3.4636 | 3.4636 | 3.4636 | 8400.0 |
> showing 50 of 959,983 rows — these rows as CSV