PREVIEW / stock_1min / 2007-01-23
file: by_date/stock_1min/2007/2007-01-23.parquet size: 9.3 MB rows: 751,345 symbols: 2,038
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 |
|---|---|---|---|---|---|---|---|
| 2007-01-23 05:59:00 | AAPL | Stock | 3.0932 | 3.0932 | 3.0932 | 3.0932 | 28000.0 |
| 2007-01-23 06:00:00 | AAPL | Stock | 3.0932 | 3.0932 | 3.0911 | 3.0918 | 25200.0 |
| 2007-01-23 06:22:00 | AAPL | Stock | 3.0932 | 3.0932 | 3.0932 | 3.0932 | 2800.0 |
| 2007-01-23 07:03:00 | AAPL | Stock | 3.0914 | 3.0914 | 3.0914 | 3.0914 | 2800.0 |
| 2007-01-23 07:04:00 | AAPL | Stock | 3.0868 | 3.0868 | 3.0846 | 3.0846 | 11200.0 |
| 2007-01-23 07:12:00 | AAPL | Stock | 3.0821 | 3.0821 | 3.0821 | 3.0821 | 11200.0 |
| 2007-01-23 07:21:00 | AAPL | Stock | 3.0821 | 3.0821 | 3.0821 | 3.0821 | 28000.0 |
| 2007-01-23 07:22:00 | AAPL | Stock | 3.0821 | 3.0821 | 3.0821 | 3.0821 | 11200.0 |
| 2007-01-23 07:25:00 | AAPL | Stock | 3.0807 | 3.0807 | 3.0807 | 3.0807 | 2800.0 |
| 2007-01-23 07:33:00 | AAPL | Stock | 3.0786 | 3.0821 | 3.0786 | 3.0821 | 44800.0 |
| 2007-01-23 07:34:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 2800.0 |
| 2007-01-23 07:36:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 28000.0 |
| 2007-01-23 07:37:00 | AAPL | Stock | 3.0804 | 3.0804 | 3.0804 | 3.0804 | 16800.0 |
| 2007-01-23 07:38:00 | AAPL | Stock | 3.0771 | 3.0771 | 3.0771 | 3.0771 | 16800.0 |
| 2007-01-23 07:40:00 | AAPL | Stock | 3.075 | 3.075 | 3.075 | 3.075 | 2800.0 |
| 2007-01-23 07:42:00 | AAPL | Stock | 3.0754 | 3.0754 | 3.0696 | 3.075 | 61600.0 |
| 2007-01-23 07:44:00 | AAPL | Stock | 3.075 | 3.075 | 3.0682 | 3.0682 | 114100.0 |
| 2007-01-23 07:45:00 | AAPL | Stock | 3.0664 | 3.0664 | 3.0618 | 3.0618 | 60424.0 |
| 2007-01-23 07:46:00 | AAPL | Stock | 3.0607 | 3.0618 | 3.0607 | 3.0618 | 8316.0 |
| 2007-01-23 07:47:00 | AAPL | Stock | 3.0643 | 3.0643 | 3.0643 | 3.0643 | 5600.0 |
| 2007-01-23 07:48:00 | AAPL | Stock | 3.0661 | 3.0661 | 3.0661 | 3.0661 | 8400.0 |
| 2007-01-23 07:49:00 | AAPL | Stock | 3.0618 | 3.0618 | 3.0571 | 3.0589 | 160860.0 |
| 2007-01-23 07:50:00 | AAPL | Stock | 3.0586 | 3.0586 | 3.0489 | 3.0536 | 144340.0 |
| 2007-01-23 07:51:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 58800.0 |
| 2007-01-23 07:52:00 | AAPL | Stock | 3.0554 | 3.0554 | 3.0536 | 3.0536 | 47040.0 |
| 2007-01-23 07:54:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 5600.0 |
| 2007-01-23 07:59:00 | AAPL | Stock | 3.0557 | 3.0557 | 3.0539 | 3.0557 | 36400.0 |
| 2007-01-23 08:00:00 | AAPL | Stock | 3.0571 | 3.0671 | 3.0554 | 3.0643 | 456400.0 |
| 2007-01-23 08:01:00 | AAPL | Stock | 3.0643 | 3.0679 | 3.0593 | 3.0593 | 120680.0 |
| 2007-01-23 08:02:00 | AAPL | Stock | 3.0607 | 3.0636 | 3.0607 | 3.0607 | 211400.0 |
| 2007-01-23 08:03:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0582 | 3.0582 | 112000.0 |
| 2007-01-23 08:04:00 | AAPL | Stock | 3.0589 | 3.0607 | 3.0571 | 3.0571 | 247184.0 |
| 2007-01-23 08:05:00 | AAPL | Stock | 3.0571 | 3.0604 | 3.0571 | 3.0571 | 303380.0 |
| 2007-01-23 08:06:00 | AAPL | Stock | 3.0607 | 3.0629 | 3.06 | 3.0611 | 212800.0 |
| 2007-01-23 08:07:00 | AAPL | Stock | 3.0632 | 3.0664 | 3.0632 | 3.0636 | 220192.0 |
| 2007-01-23 08:08:00 | AAPL | Stock | 3.0625 | 3.0632 | 3.0614 | 3.0632 | 66220.0 |
| 2007-01-23 08:09:00 | AAPL | Stock | 3.0621 | 3.0621 | 3.0607 | 3.0607 | 28000.0 |
| 2007-01-23 08:10:00 | AAPL | Stock | 3.0614 | 3.0629 | 3.0593 | 3.0625 | 106960.0 |
| 2007-01-23 08:11:00 | AAPL | Stock | 3.0621 | 3.0625 | 3.0607 | 3.0625 | 29400.0 |
| 2007-01-23 08:12:00 | AAPL | Stock | 3.0618 | 3.0632 | 3.0618 | 3.0632 | 78680.0 |
| 2007-01-23 08:13:00 | AAPL | Stock | 3.0632 | 3.0661 | 3.0632 | 3.0643 | 33880.0 |
| 2007-01-23 08:14:00 | AAPL | Stock | 3.0639 | 3.0639 | 3.0614 | 3.0614 | 24220.0 |
| 2007-01-23 08:15:00 | AAPL | Stock | 3.0625 | 3.0639 | 3.0625 | 3.0625 | 117600.0 |
| 2007-01-23 08:16:00 | AAPL | Stock | 3.0632 | 3.0639 | 3.0625 | 3.0639 | 120400.0 |
| 2007-01-23 08:17:00 | AAPL | Stock | 3.0639 | 3.0657 | 3.0636 | 3.0654 | 42560.0 |
| 2007-01-23 08:18:00 | AAPL | Stock | 3.0661 | 3.0675 | 3.0628 | 3.0657 | 315616.0 |
| 2007-01-23 08:19:00 | AAPL | Stock | 3.0661 | 3.0679 | 3.0643 | 3.0661 | 117628.0 |
| 2007-01-23 08:20:00 | AAPL | Stock | 3.0679 | 3.0729 | 3.0654 | 3.0696 | 431172.0 |
| 2007-01-23 08:21:00 | AAPL | Stock | 3.0696 | 3.0696 | 3.0664 | 3.0696 | 72408.0 |
| 2007-01-23 08:22:00 | AAPL | Stock | 3.0696 | 3.0696 | 3.0696 | 3.0696 | 8400.0 |
> showing 50 of 751,345 rows — these rows as CSV