PREVIEW / stock_1min / 2006-09-29
file: by_date/stock_1min/2006/2006-09-29.parquet size: 8.3 MB rows: 681,813 symbols: 1,951
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-29 07:33:00 | AAPL | Stock | 2.7607 | 2.7607 | 2.7607 | 2.7607 | 2800.0 |
| 2006-09-29 07:43:00 | AAPL | Stock | 2.7604 | 2.7611 | 2.7604 | 2.7611 | 16800.0 |
| 2006-09-29 07:50:00 | AAPL | Stock | 2.7625 | 2.7625 | 2.7625 | 2.7625 | 2800.0 |
| 2006-09-29 07:51:00 | AAPL | Stock | 2.7621 | 2.7621 | 2.7621 | 2.7621 | 5600.0 |
| 2006-09-29 07:57:00 | AAPL | Stock | 2.7632 | 2.7632 | 2.7632 | 2.7632 | 5600.0 |
| 2006-09-29 08:00:00 | AAPL | Stock | 2.7625 | 2.7646 | 2.7625 | 2.7643 | 108780.0 |
| 2006-09-29 08:01:00 | AAPL | Stock | 2.7661 | 2.7661 | 2.7621 | 2.7636 | 71400.0 |
| 2006-09-29 08:02:00 | AAPL | Stock | 2.7632 | 2.7632 | 2.7632 | 2.7632 | 11200.0 |
| 2006-09-29 08:04:00 | AAPL | Stock | 2.7611 | 2.7611 | 2.7607 | 2.7607 | 36400.0 |
| 2006-09-29 08:05:00 | AAPL | Stock | 2.7625 | 2.7625 | 2.7625 | 2.7625 | 2800.0 |
| 2006-09-29 08:07:00 | AAPL | Stock | 2.7607 | 2.7607 | 2.76 | 2.76 | 21000.0 |
| 2006-09-29 08:08:00 | AAPL | Stock | 2.7607 | 2.7607 | 2.7607 | 2.7607 | 28000.0 |
| 2006-09-29 08:09:00 | AAPL | Stock | 2.7607 | 2.7607 | 2.7607 | 2.7607 | 16800.0 |
| 2006-09-29 08:10:00 | AAPL | Stock | 2.7607 | 2.7607 | 2.7607 | 2.7607 | 33600.0 |
| 2006-09-29 08:11:00 | AAPL | Stock | 2.7625 | 2.7643 | 2.7625 | 2.7643 | 5600.0 |
| 2006-09-29 08:12:00 | AAPL | Stock | 2.7661 | 2.7664 | 2.765 | 2.7661 | 173600.0 |
| 2006-09-29 08:13:00 | AAPL | Stock | 2.7661 | 2.7661 | 2.7657 | 2.7657 | 47068.0 |
| 2006-09-29 08:14:00 | AAPL | Stock | 2.7657 | 2.7671 | 2.7657 | 2.7671 | 17332.0 |
| 2006-09-29 08:15:00 | AAPL | Stock | 2.7661 | 2.7679 | 2.7661 | 2.7679 | 109200.0 |
| 2006-09-29 08:16:00 | AAPL | Stock | 2.7679 | 2.7679 | 2.7679 | 2.7679 | 45668.0 |
| 2006-09-29 08:17:00 | AAPL | Stock | 2.7679 | 2.7679 | 2.7668 | 2.7668 | 57008.0 |
| 2006-09-29 08:19:00 | AAPL | Stock | 2.7668 | 2.7668 | 2.7668 | 2.7668 | 5600.0 |
| 2006-09-29 08:20:00 | AAPL | Stock | 2.7671 | 2.7675 | 2.7671 | 2.7675 | 14000.0 |
| 2006-09-29 08:21:00 | AAPL | Stock | 2.7679 | 2.7679 | 2.7679 | 2.7679 | 28000.0 |
| 2006-09-29 08:22:00 | AAPL | Stock | 2.7679 | 2.7679 | 2.7679 | 2.7679 | 18228.0 |
| 2006-09-29 08:23:00 | AAPL | Stock | 2.7679 | 2.7679 | 2.7675 | 2.7675 | 5964.0 |
| 2006-09-29 08:24:00 | AAPL | Stock | 2.7679 | 2.7679 | 2.7671 | 2.7671 | 53200.0 |
| 2006-09-29 08:25:00 | AAPL | Stock | 2.7643 | 2.7643 | 2.7643 | 2.7643 | 25200.0 |
| 2006-09-29 08:26:00 | AAPL | Stock | 2.7643 | 2.7643 | 2.7643 | 2.7643 | 5600.0 |
| 2006-09-29 08:29:00 | AAPL | Stock | 2.7639 | 2.7643 | 2.7639 | 2.7643 | 36120.0 |
| 2006-09-29 08:30:00 | AAPL | Stock | 2.7621 | 2.7621 | 2.7618 | 2.7618 | 22400.0 |
| 2006-09-29 08:31:00 | AAPL | Stock | 2.7636 | 2.7636 | 2.7636 | 2.7636 | 28000.0 |
| 2006-09-29 08:32:00 | AAPL | Stock | 2.7639 | 2.7643 | 2.7636 | 2.7643 | 296520.0 |
| 2006-09-29 08:33:00 | AAPL | Stock | 2.7618 | 2.7668 | 2.7618 | 2.7668 | 16800.0 |
| 2006-09-29 08:34:00 | AAPL | Stock | 2.7668 | 2.7668 | 2.7661 | 2.7661 | 10920.0 |
| 2006-09-29 08:36:00 | AAPL | Stock | 2.7661 | 2.7661 | 2.7661 | 2.7661 | 9380.0 |
| 2006-09-29 08:38:00 | AAPL | Stock | 2.7643 | 2.7643 | 2.7643 | 2.7643 | 2800.0 |
| 2006-09-29 08:39:00 | AAPL | Stock | 2.7607 | 2.7607 | 2.7607 | 2.7607 | 2800.0 |
| 2006-09-29 08:40:00 | AAPL | Stock | 2.7643 | 2.7643 | 2.7636 | 2.7636 | 22400.0 |
| 2006-09-29 08:41:00 | AAPL | Stock | 2.7636 | 2.7636 | 2.7636 | 2.7636 | 8400.0 |
| 2006-09-29 08:43:00 | AAPL | Stock | 2.7625 | 2.7625 | 2.7625 | 2.7625 | 33320.0 |
| 2006-09-29 08:45:00 | AAPL | Stock | 2.7643 | 2.7643 | 2.7643 | 2.7643 | 14000.0 |
| 2006-09-29 08:46:00 | AAPL | Stock | 2.7646 | 2.7657 | 2.7646 | 2.7657 | 31220.0 |
| 2006-09-29 08:47:00 | AAPL | Stock | 2.7661 | 2.7661 | 2.7625 | 2.7625 | 95200.0 |
| 2006-09-29 08:48:00 | AAPL | Stock | 2.7625 | 2.7625 | 2.7625 | 2.7625 | 11200.0 |
| 2006-09-29 08:49:00 | AAPL | Stock | 2.7643 | 2.7643 | 2.7643 | 2.7643 | 56000.0 |
| 2006-09-29 08:50:00 | AAPL | Stock | 2.7646 | 2.7679 | 2.7646 | 2.7679 | 96740.0 |
| 2006-09-29 08:51:00 | AAPL | Stock | 2.7643 | 2.7643 | 2.7643 | 2.7643 | 8400.0 |
| 2006-09-29 08:57:00 | AAPL | Stock | 2.7632 | 2.7632 | 2.7632 | 2.7632 | 19600.0 |
| 2006-09-29 08:58:00 | AAPL | Stock | 2.7632 | 2.7632 | 2.7632 | 2.7632 | 22400.0 |
> showing 50 of 681,813 rows — these rows as CSV