PREVIEW / stock_1min / 2007-02-09
file: by_date/stock_1min/2007/2007-02-09.parquet size: 9.3 MB rows: 746,816 symbols: 2,044
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-02-09 06:01:00 | AAPL | Stock | 3.0646 | 3.0646 | 3.0646 | 3.0646 | 14000.0 |
| 2007-02-09 06:32:00 | AAPL | Stock | 3.0625 | 3.0625 | 3.0625 | 3.0625 | 11200.0 |
| 2007-02-09 06:35:00 | AAPL | Stock | 3.0632 | 3.0632 | 3.0632 | 3.0632 | 2800.0 |
| 2007-02-09 06:37:00 | AAPL | Stock | 3.0632 | 3.0636 | 3.0632 | 3.0632 | 11200.0 |
| 2007-02-09 06:45:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 2800.0 |
| 2007-02-09 06:46:00 | AAPL | Stock | 3.075 | 3.075 | 3.075 | 3.075 | 2800.0 |
| 2007-02-09 07:12:00 | AAPL | Stock | 3.0754 | 3.0754 | 3.0754 | 3.0754 | 12600.0 |
| 2007-02-09 07:13:00 | AAPL | Stock | 3.0668 | 3.0668 | 3.0668 | 3.0668 | 8400.0 |
| 2007-02-09 07:14:00 | AAPL | Stock | 3.0675 | 3.0675 | 3.0675 | 3.0675 | 14000.0 |
| 2007-02-09 07:15:00 | AAPL | Stock | 3.0675 | 3.0675 | 3.0675 | 3.0675 | 8400.0 |
| 2007-02-09 07:16:00 | AAPL | Stock | 3.0643 | 3.0643 | 3.0636 | 3.0636 | 28000.0 |
| 2007-02-09 07:29:00 | AAPL | Stock | 3.0668 | 3.0668 | 3.0668 | 3.0668 | 5600.0 |
| 2007-02-09 07:38:00 | AAPL | Stock | 3.0621 | 3.0632 | 3.0621 | 3.0632 | 5600.0 |
| 2007-02-09 07:41:00 | AAPL | Stock | 3.0714 | 3.0714 | 3.0714 | 3.0714 | 56000.0 |
| 2007-02-09 07:57:00 | AAPL | Stock | 3.0618 | 3.0618 | 3.0607 | 3.0607 | 53200.0 |
| 2007-02-09 07:59:00 | AAPL | Stock | 3.0611 | 3.0618 | 3.0607 | 3.0607 | 30800.0 |
| 2007-02-09 08:00:00 | AAPL | Stock | 3.0693 | 3.0707 | 3.0593 | 3.0607 | 231924.0 |
| 2007-02-09 08:01:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0586 | 3.0586 | 180880.0 |
| 2007-02-09 08:02:00 | AAPL | Stock | 3.0589 | 3.0589 | 3.0575 | 3.0575 | 152208.0 |
| 2007-02-09 08:03:00 | AAPL | Stock | 3.0582 | 3.0589 | 3.0571 | 3.0571 | 95200.0 |
| 2007-02-09 08:04:00 | AAPL | Stock | 3.0571 | 3.0604 | 3.0568 | 3.0575 | 91364.0 |
| 2007-02-09 08:05:00 | AAPL | Stock | 3.0564 | 3.0571 | 3.0536 | 3.0536 | 232568.0 |
| 2007-02-09 08:06:00 | AAPL | Stock | 3.0536 | 3.0554 | 3.0536 | 3.0536 | 173600.0 |
| 2007-02-09 08:07:00 | AAPL | Stock | 3.0536 | 3.0554 | 3.0536 | 3.0554 | 120400.0 |
| 2007-02-09 08:08:00 | AAPL | Stock | 3.0536 | 3.0571 | 3.0536 | 3.0571 | 282800.0 |
| 2007-02-09 08:09:00 | AAPL | Stock | 3.0593 | 3.0596 | 3.0589 | 3.0596 | 26600.0 |
| 2007-02-09 08:10:00 | AAPL | Stock | 3.0596 | 3.0604 | 3.0586 | 3.0586 | 65548.0 |
| 2007-02-09 08:11:00 | AAPL | Stock | 3.0575 | 3.0582 | 3.0554 | 3.0554 | 111300.0 |
| 2007-02-09 08:12:00 | AAPL | Stock | 3.0557 | 3.0571 | 3.0557 | 3.0571 | 14000.0 |
| 2007-02-09 08:14:00 | AAPL | Stock | 3.0596 | 3.0596 | 3.0589 | 3.0589 | 8400.0 |
| 2007-02-09 08:16:00 | AAPL | Stock | 3.0593 | 3.0604 | 3.0593 | 3.0593 | 81564.0 |
| 2007-02-09 08:17:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0604 | 3.0604 | 172228.0 |
| 2007-02-09 08:18:00 | AAPL | Stock | 3.0604 | 3.0607 | 3.0604 | 3.0607 | 92400.0 |
| 2007-02-09 08:19:00 | AAPL | Stock | 3.0604 | 3.0604 | 3.0604 | 3.0604 | 6972.0 |
| 2007-02-09 08:20:00 | AAPL | Stock | 3.0604 | 3.0607 | 3.0604 | 3.0607 | 16800.0 |
| 2007-02-09 08:21:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0604 | 3.0604 | 263200.0 |
| 2007-02-09 08:22:00 | AAPL | Stock | 3.0596 | 3.0596 | 3.0596 | 3.0596 | 25228.0 |
| 2007-02-09 08:23:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0607 | 3.0607 | 26824.0 |
| 2007-02-09 08:24:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0607 | 3.0607 | 14000.0 |
| 2007-02-09 08:25:00 | AAPL | Stock | 3.0589 | 3.0607 | 3.0589 | 3.0607 | 37800.0 |
| 2007-02-09 08:26:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0607 | 3.0607 | 28000.0 |
| 2007-02-09 08:27:00 | AAPL | Stock | 3.0589 | 3.0589 | 3.0589 | 3.0589 | 28000.0 |
| 2007-02-09 08:29:00 | AAPL | Stock | 3.0589 | 3.0589 | 3.0589 | 3.0589 | 30800.0 |
| 2007-02-09 08:30:00 | AAPL | Stock | 3.0604 | 3.0604 | 3.0589 | 3.0589 | 22400.0 |
| 2007-02-09 08:33:00 | AAPL | Stock | 3.06 | 3.0607 | 3.0589 | 3.0607 | 187656.0 |
| 2007-02-09 08:34:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0607 | 3.0607 | 102200.0 |
| 2007-02-09 08:35:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0607 | 3.0607 | 55832.0 |
| 2007-02-09 08:36:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0607 | 3.0607 | 240800.0 |
| 2007-02-09 08:37:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0607 | 3.0607 | 154000.0 |
| 2007-02-09 08:38:00 | AAPL | Stock | 3.0614 | 3.0614 | 3.0604 | 3.0604 | 80360.0 |
> showing 50 of 746,816 rows — these rows as CSV