PREVIEW / stock_5min / 2015-02-04
file: by_date/stock_5min/2015/2015-02-04.parquet size: 5.5 MB rows: 362,869 symbols: 3,546
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 |
|---|---|---|---|---|---|---|---|
| 2015-02-04 04:45:00 | AAPL | Stock | 29.5975 | 29.5975 | 29.53 | 29.575 | 3200.0 |
| 2015-02-04 04:50:00 | AAPL | Stock | 29.5625 | 29.5625 | 29.5625 | 29.5625 | 400.0 |
| 2015-02-04 05:00:00 | AAPL | Stock | 29.5875 | 29.5875 | 29.5875 | 29.5875 | 800.0 |
| 2015-02-04 05:15:00 | AAPL | Stock | 29.575 | 29.575 | 29.575 | 29.575 | 2000.0 |
| 2015-02-04 05:40:00 | AAPL | Stock | 29.6175 | 29.6175 | 29.6175 | 29.6175 | 2400.0 |
| 2015-02-04 06:05:00 | AAPL | Stock | 29.5775 | 29.5775 | 29.5775 | 29.5775 | 400.0 |
| 2015-02-04 06:10:00 | AAPL | Stock | 29.625 | 29.625 | 29.625 | 29.625 | 424.0 |
| 2015-02-04 06:15:00 | AAPL | Stock | 29.595 | 29.62 | 29.595 | 29.62 | 4904.0 |
| 2015-02-04 06:20:00 | AAPL | Stock | 29.6225 | 29.6325 | 29.6225 | 29.6325 | 1304.0 |
| 2015-02-04 06:35:00 | AAPL | Stock | 29.655 | 29.6575 | 29.655 | 29.6575 | 2804.0 |
| 2015-02-04 06:55:00 | AAPL | Stock | 29.645 | 29.645 | 29.645 | 29.645 | 1200.0 |
| 2015-02-04 07:00:00 | AAPL | Stock | 29.645 | 29.645 | 29.6275 | 29.6275 | 4000.0 |
| 2015-02-04 07:05:00 | AAPL | Stock | 29.65 | 29.65 | 29.6375 | 29.6375 | 3032.0 |
| 2015-02-04 07:10:00 | AAPL | Stock | 29.635 | 29.65 | 29.635 | 29.65 | 5440.0 |
| 2015-02-04 07:15:00 | AAPL | Stock | 29.635 | 29.635 | 29.5625 | 29.58 | 12620.0 |
| 2015-02-04 07:20:00 | AAPL | Stock | 29.6 | 29.6 | 29.6 | 29.6 | 400.0 |
| 2015-02-04 07:25:00 | AAPL | Stock | 29.58 | 29.58 | 29.58 | 29.58 | 7200.0 |
| 2015-02-04 07:30:00 | AAPL | Stock | 29.6 | 29.6 | 29.6 | 29.6 | 400.0 |
| 2015-02-04 07:35:00 | AAPL | Stock | 29.6 | 29.615 | 29.6 | 29.6 | 10804.0 |
| 2015-02-04 07:40:00 | AAPL | Stock | 29.6 | 29.6125 | 29.6 | 29.6 | 7600.0 |
| 2015-02-04 07:50:00 | AAPL | Stock | 29.61 | 29.6125 | 29.595 | 29.595 | 10076.0 |
| 2015-02-04 07:55:00 | AAPL | Stock | 29.5875 | 29.59 | 29.575 | 29.59 | 43812.0 |
| 2015-02-04 08:00:00 | AAPL | Stock | 29.6 | 29.6 | 29.5425 | 29.5725 | 84052.0 |
| 2015-02-04 08:05:00 | AAPL | Stock | 29.5725 | 29.5725 | 29.5625 | 29.5675 | 19080.0 |
| 2015-02-04 08:10:00 | AAPL | Stock | 29.555 | 29.57 | 29.5525 | 29.57 | 21720.0 |
| 2015-02-04 08:15:00 | AAPL | Stock | 29.565 | 29.5975 | 29.5575 | 29.595 | 24680.0 |
| 2015-02-04 08:20:00 | AAPL | Stock | 29.59 | 29.61 | 29.59 | 29.6075 | 6892.0 |
| 2015-02-04 08:25:00 | AAPL | Stock | 29.5875 | 29.5875 | 29.55 | 29.5575 | 61000.0 |
| 2015-02-04 08:30:00 | AAPL | Stock | 29.565 | 29.565 | 29.56 | 29.5625 | 15840.0 |
| 2015-02-04 08:35:00 | AAPL | Stock | 29.56 | 29.575 | 29.55 | 29.56 | 45876.0 |
| 2015-02-04 08:40:00 | AAPL | Stock | 29.5525 | 29.5675 | 29.525 | 29.5375 | 47396.0 |
| 2015-02-04 08:45:00 | AAPL | Stock | 29.5375 | 29.5575 | 29.5352 | 29.55 | 62104.0 |
| 2015-02-04 08:50:00 | AAPL | Stock | 29.5425 | 29.55 | 29.5275 | 29.5375 | 26492.0 |
| 2015-02-04 08:55:00 | AAPL | Stock | 29.5475 | 29.5775 | 29.5375 | 29.575 | 47556.0 |
| 2015-02-04 09:00:00 | AAPL | Stock | 29.575 | 29.575 | 29.545 | 29.5575 | 7504.0 |
| 2015-02-04 09:05:00 | AAPL | Stock | 29.5575 | 29.5575 | 29.5375 | 29.5375 | 16684.0 |
| 2015-02-04 09:10:00 | AAPL | Stock | 29.5325 | 29.54 | 29.5125 | 29.54 | 65156.0 |
| 2015-02-04 09:15:00 | AAPL | Stock | 29.55 | 29.55 | 29.54 | 29.5475 | 11868.0 |
| 2015-02-04 09:20:00 | AAPL | Stock | 29.55 | 29.555 | 29.4925 | 29.5 | 95456.0 |
| 2015-02-04 09:25:00 | AAPL | Stock | 29.6625 | 29.6625 | 29.495 | 29.6175 | 111280.0 |
| 2015-02-04 09:30:00 | AAPL | Stock | 29.625 | 29.78 | 29.5772 | 29.735 | 9268548.0 |
| 2015-02-04 09:35:00 | AAPL | Stock | 29.735 | 29.74 | 29.61 | 29.68 | 4717508.0 |
| 2015-02-04 09:40:00 | AAPL | Stock | 29.68 | 29.735 | 29.66 | 29.69 | 2599112.0 |
| 2015-02-04 09:45:00 | AAPL | Stock | 29.6875 | 29.7638 | 29.6725 | 29.7425 | 4674512.0 |
| 2015-02-04 09:50:00 | AAPL | Stock | 29.7445 | 29.87 | 29.7445 | 29.8675 | 7622848.0 |
| 2015-02-04 09:55:00 | AAPL | Stock | 29.8662 | 29.9225 | 29.8525 | 29.89 | 6527592.0 |
| 2015-02-04 10:00:00 | AAPL | Stock | 29.895 | 29.9375 | 29.8225 | 29.8562 | 6581836.0 |
| 2015-02-04 10:05:00 | AAPL | Stock | 29.8575 | 29.8975 | 29.8525 | 29.8675 | 2919348.0 |
| 2015-02-04 10:10:00 | AAPL | Stock | 29.87 | 29.95 | 29.8675 | 29.911 | 4396484.0 |
| 2015-02-04 10:15:00 | AAPL | Stock | 29.9112 | 29.93 | 29.8825 | 29.9275 | 3127028.0 |
> showing 50 of 362,869 rows — these rows as CSV