PREVIEW / stock_1min / 2005-03-18
file: by_date/stock_1min/2005/2005-03-18.parquet size: 6.7 MB rows: 558,750 symbols: 1,592
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-18 08:00:00 | AAPL | Stock | 1.5571 | 1.5589 | 1.5436 | 1.5536 | 133700.0 |
| 2005-03-18 08:01:00 | AAPL | Stock | 1.5571 | 1.5593 | 1.5546 | 1.5593 | 1501752.0 |
| 2005-03-18 08:02:00 | AAPL | Stock | 1.5593 | 1.5625 | 1.5593 | 1.5611 | 672112.0 |
| 2005-03-18 08:03:00 | AAPL | Stock | 1.5611 | 1.5675 | 1.5607 | 1.5611 | 764400.0 |
| 2005-03-18 08:04:00 | AAPL | Stock | 1.5607 | 1.5625 | 1.5589 | 1.5625 | 883204.0 |
| 2005-03-18 08:05:00 | AAPL | Stock | 1.5621 | 1.5643 | 1.5621 | 1.5643 | 391776.0 |
| 2005-03-18 08:06:00 | AAPL | Stock | 1.5675 | 1.5675 | 1.5657 | 1.5664 | 148400.0 |
| 2005-03-18 08:07:00 | AAPL | Stock | 1.5646 | 1.5661 | 1.5632 | 1.5643 | 284228.0 |
| 2005-03-18 08:08:00 | AAPL | Stock | 1.5643 | 1.5664 | 1.5625 | 1.5639 | 882644.0 |
| 2005-03-18 08:09:00 | AAPL | Stock | 1.5639 | 1.5664 | 1.5625 | 1.5625 | 238084.0 |
| 2005-03-18 08:10:00 | AAPL | Stock | 1.5618 | 1.5639 | 1.5596 | 1.5596 | 454860.0 |
| 2005-03-18 08:11:00 | AAPL | Stock | 1.5596 | 1.5625 | 1.555 | 1.555 | 714140.0 |
| 2005-03-18 08:12:00 | AAPL | Stock | 1.5536 | 1.5554 | 1.5536 | 1.5554 | 852600.0 |
| 2005-03-18 08:13:00 | AAPL | Stock | 1.5593 | 1.5593 | 1.5554 | 1.5554 | 153076.0 |
| 2005-03-18 08:14:00 | AAPL | Stock | 1.5554 | 1.5571 | 1.5536 | 1.5557 | 449400.0 |
| 2005-03-18 08:15:00 | AAPL | Stock | 1.5571 | 1.5571 | 1.555 | 1.5554 | 410704.0 |
| 2005-03-18 08:16:00 | AAPL | Stock | 1.5568 | 1.5571 | 1.5564 | 1.5571 | 36400.0 |
| 2005-03-18 08:17:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5571 | 1.5586 | 36400.0 |
| 2005-03-18 08:18:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 16800.0 |
| 2005-03-18 08:19:00 | AAPL | Stock | 1.5589 | 1.5604 | 1.5589 | 1.56 | 130620.0 |
| 2005-03-18 08:20:00 | AAPL | Stock | 1.5589 | 1.5611 | 1.5554 | 1.5607 | 544040.0 |
| 2005-03-18 08:21:00 | AAPL | Stock | 1.5607 | 1.5607 | 1.5586 | 1.5604 | 70000.0 |
| 2005-03-18 08:22:00 | AAPL | Stock | 1.5607 | 1.5621 | 1.5604 | 1.5607 | 32480.0 |
| 2005-03-18 08:23:00 | AAPL | Stock | 1.5607 | 1.5611 | 1.5607 | 1.5607 | 58800.0 |
| 2005-03-18 08:24:00 | AAPL | Stock | 1.5611 | 1.5611 | 1.5582 | 1.56 | 416920.0 |
| 2005-03-18 08:25:00 | AAPL | Stock | 1.5589 | 1.5607 | 1.5579 | 1.5596 | 50400.0 |
| 2005-03-18 08:26:00 | AAPL | Stock | 1.5589 | 1.5596 | 1.5589 | 1.5589 | 30800.0 |
| 2005-03-18 08:27:00 | AAPL | Stock | 1.5589 | 1.56 | 1.5589 | 1.5589 | 30800.0 |
| 2005-03-18 08:28:00 | AAPL | Stock | 1.5593 | 1.5593 | 1.5586 | 1.5589 | 215600.0 |
| 2005-03-18 08:29:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5568 | 1.5568 | 50120.0 |
| 2005-03-18 08:30:00 | AAPL | Stock | 1.5568 | 1.5568 | 1.5546 | 1.5554 | 113960.0 |
| 2005-03-18 08:31:00 | AAPL | Stock | 1.5546 | 1.5554 | 1.5518 | 1.5554 | 265580.0 |
| 2005-03-18 08:32:00 | AAPL | Stock | 1.5543 | 1.5554 | 1.5504 | 1.5521 | 145600.0 |
| 2005-03-18 08:33:00 | AAPL | Stock | 1.5532 | 1.5536 | 1.5482 | 1.5504 | 563640.0 |
| 2005-03-18 08:34:00 | AAPL | Stock | 1.5514 | 1.5546 | 1.5514 | 1.5529 | 19180.0 |
| 2005-03-18 08:35:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5521 | 1.5521 | 19600.0 |
| 2005-03-18 08:36:00 | AAPL | Stock | 1.5514 | 1.5514 | 1.5514 | 1.5514 | 2800.0 |
| 2005-03-18 08:37:00 | AAPL | Stock | 1.5529 | 1.5536 | 1.5525 | 1.5536 | 77280.0 |
| 2005-03-18 08:38:00 | AAPL | Stock | 1.5536 | 1.555 | 1.5536 | 1.555 | 37940.0 |
| 2005-03-18 08:39:00 | AAPL | Stock | 1.555 | 1.5557 | 1.5536 | 1.555 | 183400.0 |
| 2005-03-18 08:40:00 | AAPL | Stock | 1.5546 | 1.5564 | 1.5546 | 1.5564 | 182000.0 |
| 2005-03-18 08:41:00 | AAPL | Stock | 1.5564 | 1.5589 | 1.5554 | 1.5557 | 481040.0 |
| 2005-03-18 08:42:00 | AAPL | Stock | 1.5554 | 1.5589 | 1.5554 | 1.5582 | 140560.0 |
| 2005-03-18 08:43:00 | AAPL | Stock | 1.5571 | 1.5607 | 1.5571 | 1.5607 | 616000.0 |
| 2005-03-18 08:44:00 | AAPL | Stock | 1.5607 | 1.5611 | 1.5575 | 1.5586 | 168000.0 |
| 2005-03-18 08:45:00 | AAPL | Stock | 1.5582 | 1.5607 | 1.5582 | 1.5582 | 75600.0 |
| 2005-03-18 08:46:00 | AAPL | Stock | 1.5586 | 1.5596 | 1.5582 | 1.5589 | 53480.0 |
| 2005-03-18 08:47:00 | AAPL | Stock | 1.5593 | 1.5593 | 1.5586 | 1.5589 | 75880.0 |
| 2005-03-18 08:48:00 | AAPL | Stock | 1.5586 | 1.5586 | 1.5582 | 1.5582 | 19600.0 |
| 2005-03-18 08:49:00 | AAPL | Stock | 1.5582 | 1.5589 | 1.5582 | 1.5589 | 46452.0 |
> showing 50 of 558,750 rows — these rows as CSV