PREVIEW / stock_1min / 2009-02-09
file: by_date/stock_1min/2009/2009-02-09.parquet size: 11.9 MB rows: 918,094 symbols: 2,705
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-09 06:38:00 | AAPL | Stock | 3.5446 | 3.5446 | 3.5446 | 3.5446 | 5600.0 |
| 2009-02-09 06:39:00 | AAPL | Stock | 3.5536 | 3.5536 | 3.5536 | 3.5536 | 5600.0 |
| 2009-02-09 06:41:00 | AAPL | Stock | 3.5571 | 3.5571 | 3.5571 | 3.5571 | 3920.0 |
| 2009-02-09 07:12:00 | AAPL | Stock | 3.5536 | 3.5536 | 3.5536 | 3.5536 | 2800.0 |
| 2009-02-09 07:15:00 | AAPL | Stock | 3.5536 | 3.5536 | 3.5536 | 3.5536 | 2940.0 |
| 2009-02-09 07:18:00 | AAPL | Stock | 3.5536 | 3.5536 | 3.5536 | 3.5536 | 2800.0 |
| 2009-02-09 07:21:00 | AAPL | Stock | 3.5536 | 3.5536 | 3.5536 | 3.5536 | 2800.0 |
| 2009-02-09 07:23:00 | AAPL | Stock | 3.5536 | 3.5536 | 3.5536 | 3.5536 | 16660.0 |
| 2009-02-09 07:27:00 | AAPL | Stock | 3.5554 | 3.5554 | 3.5554 | 3.5554 | 5600.0 |
| 2009-02-09 07:30:00 | AAPL | Stock | 3.5571 | 3.5571 | 3.5571 | 3.5571 | 16800.0 |
| 2009-02-09 07:31:00 | AAPL | Stock | 3.5607 | 3.5607 | 3.5607 | 3.5607 | 14000.0 |
| 2009-02-09 07:33:00 | AAPL | Stock | 3.5571 | 3.5571 | 3.5571 | 3.5571 | 2800.0 |
| 2009-02-09 07:35:00 | AAPL | Stock | 3.5604 | 3.5604 | 3.5604 | 3.5604 | 2800.0 |
| 2009-02-09 07:50:00 | AAPL | Stock | 3.5571 | 3.5571 | 3.5571 | 3.5571 | 5600.0 |
| 2009-02-09 07:56:00 | AAPL | Stock | 3.555 | 3.5557 | 3.555 | 3.5557 | 5600.0 |
| 2009-02-09 07:59:00 | AAPL | Stock | 3.5571 | 3.5571 | 3.5571 | 3.5571 | 2800.0 |
| 2009-02-09 08:00:00 | AAPL | Stock | 3.5536 | 3.5707 | 3.5536 | 3.5636 | 85036.0 |
| 2009-02-09 08:02:00 | AAPL | Stock | 3.5629 | 3.5629 | 3.5561 | 3.5561 | 47600.0 |
| 2009-02-09 08:03:00 | AAPL | Stock | 3.5561 | 3.5571 | 3.5561 | 3.5571 | 7644.0 |
| 2009-02-09 08:04:00 | AAPL | Stock | 3.5568 | 3.5575 | 3.5557 | 3.5561 | 45164.0 |
| 2009-02-09 08:05:00 | AAPL | Stock | 3.5575 | 3.5589 | 3.5575 | 3.5589 | 9520.0 |
| 2009-02-09 08:07:00 | AAPL | Stock | 3.5568 | 3.5571 | 3.5564 | 3.5564 | 20440.0 |
| 2009-02-09 08:08:00 | AAPL | Stock | 3.5571 | 3.5586 | 3.5564 | 3.5586 | 36932.0 |
| 2009-02-09 08:10:00 | AAPL | Stock | 3.5614 | 3.5625 | 3.5614 | 3.5625 | 17584.0 |
| 2009-02-09 08:12:00 | AAPL | Stock | 3.5579 | 3.5579 | 3.5571 | 3.5571 | 26600.0 |
| 2009-02-09 08:13:00 | AAPL | Stock | 3.5571 | 3.5621 | 3.5571 | 3.5621 | 6720.0 |
| 2009-02-09 08:14:00 | AAPL | Stock | 3.5571 | 3.5571 | 3.5571 | 3.5571 | 28000.0 |
| 2009-02-09 08:17:00 | AAPL | Stock | 3.5589 | 3.5589 | 3.5554 | 3.5554 | 30800.0 |
| 2009-02-09 08:19:00 | AAPL | Stock | 3.5554 | 3.5607 | 3.5554 | 3.5607 | 25200.0 |
| 2009-02-09 08:20:00 | AAPL | Stock | 3.5607 | 3.5607 | 3.5607 | 3.5607 | 2800.0 |
| 2009-02-09 08:21:00 | AAPL | Stock | 3.56 | 3.56 | 3.56 | 3.56 | 5600.0 |
| 2009-02-09 08:22:00 | AAPL | Stock | 3.56 | 3.56 | 3.56 | 3.56 | 36400.0 |
| 2009-02-09 08:23:00 | AAPL | Stock | 3.5589 | 3.5589 | 3.5579 | 3.5579 | 8400.0 |
| 2009-02-09 08:24:00 | AAPL | Stock | 3.56 | 3.56 | 3.56 | 3.56 | 5600.0 |
| 2009-02-09 08:28:00 | AAPL | Stock | 3.5607 | 3.5607 | 3.5607 | 3.5607 | 4480.0 |
| 2009-02-09 08:30:00 | AAPL | Stock | 3.5618 | 3.5618 | 3.5618 | 3.5618 | 4620.0 |
| 2009-02-09 08:31:00 | AAPL | Stock | 3.5629 | 3.5629 | 3.5607 | 3.5607 | 34020.0 |
| 2009-02-09 08:38:00 | AAPL | Stock | 3.5589 | 3.5589 | 3.5561 | 3.5561 | 56000.0 |
| 2009-02-09 08:39:00 | AAPL | Stock | 3.5611 | 3.5625 | 3.5611 | 3.5625 | 14280.0 |
| 2009-02-09 08:40:00 | AAPL | Stock | 3.5625 | 3.5639 | 3.5625 | 3.5639 | 64232.0 |
| 2009-02-09 08:43:00 | AAPL | Stock | 3.5629 | 3.5643 | 3.5629 | 3.5643 | 8400.0 |
| 2009-02-09 08:46:00 | AAPL | Stock | 3.5679 | 3.5707 | 3.5679 | 3.5707 | 12600.0 |
| 2009-02-09 08:48:00 | AAPL | Stock | 3.5704 | 3.5704 | 3.5704 | 3.5704 | 2800.0 |
| 2009-02-09 08:50:00 | AAPL | Stock | 3.5696 | 3.5707 | 3.5696 | 3.5707 | 12600.0 |
| 2009-02-09 08:52:00 | AAPL | Stock | 3.5704 | 3.5704 | 3.5704 | 3.5704 | 2800.0 |
| 2009-02-09 09:01:00 | AAPL | Stock | 3.5679 | 3.5679 | 3.5679 | 3.5679 | 3640.0 |
| 2009-02-09 09:05:00 | AAPL | Stock | 3.5693 | 3.5693 | 3.5636 | 3.5636 | 14000.0 |
| 2009-02-09 09:06:00 | AAPL | Stock | 3.5675 | 3.5675 | 3.5675 | 3.5675 | 2800.0 |
| 2009-02-09 09:07:00 | AAPL | Stock | 3.5643 | 3.5643 | 3.5643 | 3.5643 | 8484.0 |
| 2009-02-09 09:08:00 | AAPL | Stock | 3.5643 | 3.5671 | 3.5643 | 3.5671 | 30716.0 |
> showing 50 of 918,094 rows — these rows as CSV