PREVIEW / stock_1min / 2004-03-18
file: by_date/stock_1min/2004/2004-03-18.parquet size: 5.6 MB rows: 476,393 symbols: 1,433
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 |
|---|---|---|---|---|---|---|---|
| 2004-03-18 08:01:00 | AAPL | Stock | 0.4677 | 0.4677 | 0.4677 | 0.4677 | 56000.0 |
| 2004-03-18 08:12:00 | AAPL | Stock | 0.4661 | 0.4661 | 0.4661 | 0.4661 | 28000.0 |
| 2004-03-18 08:34:00 | AAPL | Stock | 0.4659 | 0.4659 | 0.4659 | 0.4659 | 28000.0 |
| 2004-03-18 08:36:00 | AAPL | Stock | 0.4661 | 0.4661 | 0.4661 | 0.4661 | 5600.0 |
| 2004-03-18 08:37:00 | AAPL | Stock | 0.4659 | 0.4659 | 0.4659 | 0.4659 | 5600.0 |
| 2004-03-18 09:11:00 | AAPL | Stock | 0.4646 | 0.4646 | 0.4646 | 0.4646 | 56000.0 |
| 2004-03-18 09:18:00 | AAPL | Stock | 0.4464 | 0.4464 | 0.4464 | 0.4464 | 5600.0 |
| 2004-03-18 09:24:00 | AAPL | Stock | 0.4634 | 0.4634 | 0.4634 | 0.4634 | 11200.0 |
| 2004-03-18 09:29:00 | AAPL | Stock | 0.4632 | 0.4643 | 0.4616 | 0.4616 | 336000.0 |
| 2004-03-18 09:30:00 | AAPL | Stock | 0.4632 | 0.4643 | 0.4616 | 0.4625 | 2450504.0 |
| 2004-03-18 09:31:00 | AAPL | Stock | 0.4629 | 0.4629 | 0.4607 | 0.4627 | 1095472.0 |
| 2004-03-18 09:32:00 | AAPL | Stock | 0.4627 | 0.4638 | 0.4627 | 0.463 | 515200.0 |
| 2004-03-18 09:33:00 | AAPL | Stock | 0.4632 | 0.4636 | 0.4632 | 0.4634 | 526400.0 |
| 2004-03-18 09:34:00 | AAPL | Stock | 0.4634 | 0.4638 | 0.463 | 0.4638 | 976472.0 |
| 2004-03-18 09:35:00 | AAPL | Stock | 0.4639 | 0.4643 | 0.4632 | 0.4639 | 1218000.0 |
| 2004-03-18 09:36:00 | AAPL | Stock | 0.4639 | 0.4654 | 0.4636 | 0.4636 | 1208592.0 |
| 2004-03-18 09:37:00 | AAPL | Stock | 0.4638 | 0.4638 | 0.463 | 0.4632 | 506856.0 |
| 2004-03-18 09:38:00 | AAPL | Stock | 0.4632 | 0.4632 | 0.4616 | 0.4616 | 1607256.0 |
| 2004-03-18 09:39:00 | AAPL | Stock | 0.4618 | 0.463 | 0.4614 | 0.4623 | 1581888.0 |
| 2004-03-18 09:40:00 | AAPL | Stock | 0.4623 | 0.4629 | 0.4621 | 0.4627 | 901600.0 |
| 2004-03-18 09:41:00 | AAPL | Stock | 0.4627 | 0.4627 | 0.4618 | 0.4625 | 685888.0 |
| 2004-03-18 09:42:00 | AAPL | Stock | 0.4623 | 0.4627 | 0.4621 | 0.4627 | 824320.0 |
| 2004-03-18 09:43:00 | AAPL | Stock | 0.4625 | 0.4627 | 0.4623 | 0.4623 | 3628688.0 |
| 2004-03-18 09:44:00 | AAPL | Stock | 0.4623 | 0.4627 | 0.4623 | 0.4625 | 1102752.0 |
| 2004-03-18 09:45:00 | AAPL | Stock | 0.4627 | 0.4627 | 0.4621 | 0.4623 | 4170880.0 |
| 2004-03-18 09:46:00 | AAPL | Stock | 0.4625 | 0.4627 | 0.4623 | 0.4627 | 1372000.0 |
| 2004-03-18 09:47:00 | AAPL | Stock | 0.4627 | 0.4627 | 0.4623 | 0.4623 | 339360.0 |
| 2004-03-18 09:48:00 | AAPL | Stock | 0.4623 | 0.4625 | 0.4623 | 0.4625 | 273168.0 |
| 2004-03-18 09:49:00 | AAPL | Stock | 0.4625 | 0.4625 | 0.4621 | 0.4625 | 1209824.0 |
| 2004-03-18 09:50:00 | AAPL | Stock | 0.4623 | 0.4625 | 0.4618 | 0.4618 | 604576.0 |
| 2004-03-18 09:51:00 | AAPL | Stock | 0.4618 | 0.4627 | 0.4604 | 0.4604 | 3664024.0 |
| 2004-03-18 09:52:00 | AAPL | Stock | 0.4604 | 0.4611 | 0.4604 | 0.4607 | 1247176.0 |
| 2004-03-18 09:53:00 | AAPL | Stock | 0.4611 | 0.4611 | 0.4607 | 0.4609 | 1008000.0 |
| 2004-03-18 09:54:00 | AAPL | Stock | 0.4609 | 0.4627 | 0.4607 | 0.4623 | 1808632.0 |
| 2004-03-18 09:55:00 | AAPL | Stock | 0.4623 | 0.4625 | 0.4604 | 0.4604 | 2092328.0 |
| 2004-03-18 09:56:00 | AAPL | Stock | 0.4604 | 0.4607 | 0.4591 | 0.4596 | 2747752.0 |
| 2004-03-18 09:57:00 | AAPL | Stock | 0.4596 | 0.46 | 0.4595 | 0.4596 | 486192.0 |
| 2004-03-18 09:58:00 | AAPL | Stock | 0.4596 | 0.46 | 0.4596 | 0.4596 | 1140384.0 |
| 2004-03-18 09:59:00 | AAPL | Stock | 0.4596 | 0.4605 | 0.4596 | 0.4598 | 1228416.0 |
| 2004-03-18 10:00:00 | AAPL | Stock | 0.4598 | 0.4604 | 0.4586 | 0.4586 | 2803360.0 |
| 2004-03-18 10:01:00 | AAPL | Stock | 0.4586 | 0.4598 | 0.4586 | 0.4591 | 1205120.0 |
| 2004-03-18 10:02:00 | AAPL | Stock | 0.4586 | 0.46 | 0.4579 | 0.46 | 1356264.0 |
| 2004-03-18 10:03:00 | AAPL | Stock | 0.46 | 0.4605 | 0.4598 | 0.4604 | 314216.0 |
| 2004-03-18 10:04:00 | AAPL | Stock | 0.4602 | 0.4602 | 0.4586 | 0.4586 | 740992.0 |
| 2004-03-18 10:05:00 | AAPL | Stock | 0.4586 | 0.4602 | 0.4586 | 0.4598 | 414232.0 |
| 2004-03-18 10:06:00 | AAPL | Stock | 0.4598 | 0.4604 | 0.4598 | 0.4604 | 467544.0 |
| 2004-03-18 10:07:00 | AAPL | Stock | 0.4604 | 0.4613 | 0.4602 | 0.4613 | 951384.0 |
| 2004-03-18 10:08:00 | AAPL | Stock | 0.4613 | 0.4616 | 0.4609 | 0.4613 | 532000.0 |
| 2004-03-18 10:09:00 | AAPL | Stock | 0.4614 | 0.4614 | 0.4611 | 0.4613 | 240296.0 |
| 2004-03-18 10:10:00 | AAPL | Stock | 0.4613 | 0.4618 | 0.4611 | 0.4611 | 533400.0 |
> showing 50 of 476,393 rows — these rows as CSV