PREVIEW / stock_1min / 2011-09-09
file: by_date/stock_1min/2011/2011-09-09.parquet size: 13.8 MB rows: 1,041,955 symbols: 2,827
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-09 04:49:00 | AAPL | Stock | 13.6732 | 13.6732 | 13.6732 | 13.6732 | 4200.0 |
| 2011-09-09 05:07:00 | AAPL | Stock | 13.7046 | 13.7046 | 13.7046 | 13.7046 | 2800.0 |
| 2011-09-09 05:18:00 | AAPL | Stock | 13.7046 | 13.7046 | 13.7046 | 13.7046 | 2800.0 |
| 2011-09-09 05:47:00 | AAPL | Stock | 13.7021 | 13.7021 | 13.7021 | 13.7021 | 2800.0 |
| 2011-09-09 05:49:00 | AAPL | Stock | 13.7054 | 13.7054 | 13.7054 | 13.7054 | 28000.0 |
| 2011-09-09 05:54:00 | AAPL | Stock | 13.7054 | 13.7054 | 13.7054 | 13.7054 | 16800.0 |
| 2011-09-09 05:58:00 | AAPL | Stock | 13.6786 | 13.6786 | 13.6786 | 13.6786 | 2800.0 |
| 2011-09-09 05:59:00 | AAPL | Stock | 13.6786 | 13.6786 | 13.6786 | 13.6786 | 11200.0 |
| 2011-09-09 06:06:00 | AAPL | Stock | 13.7211 | 13.7211 | 13.7211 | 13.7211 | 2800.0 |
| 2011-09-09 06:40:00 | AAPL | Stock | 13.6818 | 13.6818 | 13.6818 | 13.6818 | 36400.0 |
| 2011-09-09 06:42:00 | AAPL | Stock | 13.6889 | 13.6889 | 13.6889 | 13.6889 | 14000.0 |
| 2011-09-09 06:43:00 | AAPL | Stock | 13.6889 | 13.7046 | 13.6889 | 13.7046 | 11760.0 |
| 2011-09-09 06:49:00 | AAPL | Stock | 13.6693 | 13.6693 | 13.6679 | 13.6679 | 5600.0 |
| 2011-09-09 07:01:00 | AAPL | Stock | 13.6682 | 13.6682 | 13.6682 | 13.6682 | 2800.0 |
| 2011-09-09 07:04:00 | AAPL | Stock | 13.6789 | 13.6789 | 13.6789 | 13.6789 | 5600.0 |
| 2011-09-09 07:05:00 | AAPL | Stock | 13.6704 | 13.6786 | 13.6704 | 13.6786 | 9660.0 |
| 2011-09-09 07:06:00 | AAPL | Stock | 13.6704 | 13.6704 | 13.6607 | 13.6607 | 41608.0 |
| 2011-09-09 07:09:00 | AAPL | Stock | 13.6611 | 13.6611 | 13.6611 | 13.6611 | 2800.0 |
| 2011-09-09 07:10:00 | AAPL | Stock | 13.6786 | 13.6786 | 13.6704 | 13.6704 | 7000.0 |
| 2011-09-09 07:23:00 | AAPL | Stock | 13.7 | 13.7004 | 13.7 | 13.7004 | 5600.0 |
| 2011-09-09 07:26:00 | AAPL | Stock | 13.6993 | 13.6993 | 13.6993 | 13.6993 | 2800.0 |
| 2011-09-09 07:29:00 | AAPL | Stock | 13.6929 | 13.6929 | 13.6929 | 13.6929 | 83580.0 |
| 2011-09-09 07:30:00 | AAPL | Stock | 13.6825 | 13.6825 | 13.6825 | 13.6825 | 2800.0 |
| 2011-09-09 07:35:00 | AAPL | Stock | 13.6839 | 13.6839 | 13.6839 | 13.6839 | 4200.0 |
| 2011-09-09 07:38:00 | AAPL | Stock | 13.6789 | 13.6789 | 13.6789 | 13.6789 | 5600.0 |
| 2011-09-09 07:39:00 | AAPL | Stock | 13.675 | 13.675 | 13.6732 | 13.6732 | 30800.0 |
| 2011-09-09 07:40:00 | AAPL | Stock | 13.6725 | 13.675 | 13.6721 | 13.675 | 30800.0 |
| 2011-09-09 07:42:00 | AAPL | Stock | 13.6757 | 13.6839 | 13.6757 | 13.6839 | 25200.0 |
| 2011-09-09 07:47:00 | AAPL | Stock | 13.6839 | 13.6839 | 13.6839 | 13.6839 | 14000.0 |
| 2011-09-09 07:49:00 | AAPL | Stock | 13.6857 | 13.6857 | 13.6857 | 13.6857 | 2800.0 |
| 2011-09-09 07:50:00 | AAPL | Stock | 13.6857 | 13.6857 | 13.6857 | 13.6857 | 2800.0 |
| 2011-09-09 07:54:00 | AAPL | Stock | 13.6786 | 13.6786 | 13.6786 | 13.6786 | 2800.0 |
| 2011-09-09 07:55:00 | AAPL | Stock | 13.6768 | 13.6789 | 13.675 | 13.6786 | 75600.0 |
| 2011-09-09 07:57:00 | AAPL | Stock | 13.6857 | 13.6857 | 13.6857 | 13.6857 | 5600.0 |
| 2011-09-09 07:58:00 | AAPL | Stock | 13.6893 | 13.6893 | 13.6893 | 13.6893 | 2800.0 |
| 2011-09-09 08:00:00 | AAPL | Stock | 13.6893 | 13.6964 | 13.6875 | 13.695 | 51156.0 |
| 2011-09-09 08:01:00 | AAPL | Stock | 13.6964 | 13.6964 | 13.6964 | 13.6964 | 14000.0 |
| 2011-09-09 08:02:00 | AAPL | Stock | 13.6957 | 13.6957 | 13.6957 | 13.6957 | 4200.0 |
| 2011-09-09 08:03:00 | AAPL | Stock | 13.7007 | 13.7007 | 13.7007 | 13.7007 | 2800.0 |
| 2011-09-09 08:04:00 | AAPL | Stock | 13.6957 | 13.6964 | 13.6946 | 13.6964 | 17360.0 |
| 2011-09-09 08:05:00 | AAPL | Stock | 13.7007 | 13.7054 | 13.6957 | 13.7032 | 104216.0 |
| 2011-09-09 08:06:00 | AAPL | Stock | 13.6996 | 13.7321 | 13.6996 | 13.7293 | 137480.0 |
| 2011-09-09 08:07:00 | AAPL | Stock | 13.7279 | 13.7279 | 13.7143 | 13.7143 | 100744.0 |
| 2011-09-09 08:08:00 | AAPL | Stock | 13.7175 | 13.7457 | 13.7175 | 13.7457 | 63000.0 |
| 2011-09-09 08:09:00 | AAPL | Stock | 13.7461 | 13.7571 | 13.7332 | 13.7546 | 270480.0 |
| 2011-09-09 08:10:00 | AAPL | Stock | 13.7539 | 13.7671 | 13.7539 | 13.7607 | 36456.0 |
| 2011-09-09 08:11:00 | AAPL | Stock | 13.7607 | 13.7636 | 13.7582 | 13.7586 | 122360.0 |
| 2011-09-09 08:12:00 | AAPL | Stock | 13.7586 | 13.7679 | 13.7586 | 13.7661 | 55160.0 |
| 2011-09-09 08:13:00 | AAPL | Stock | 13.7571 | 13.7571 | 13.7571 | 13.7571 | 5600.0 |
| 2011-09-09 08:14:00 | AAPL | Stock | 13.7536 | 13.7568 | 13.7511 | 13.7518 | 86492.0 |
> showing 50 of 1,041,955 rows — these rows as CSV