PREVIEW / stock_1min / 2013-07-25
file: by_date/stock_1min/2013/2013-07-25.parquet size: 13.9 MB rows: 1,024,287 symbols: 2,834
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-25 04:00:00 | AAPL | Stock | 15.7714 | 15.7714 | 15.7714 | 15.7714 | 2800.0 |
| 2013-07-25 04:01:00 | AAPL | Stock | 15.7857 | 15.7857 | 15.7857 | 15.7857 | 2800.0 |
| 2013-07-25 04:02:00 | AAPL | Stock | 15.7857 | 15.7857 | 15.7857 | 15.7857 | 2800.0 |
| 2013-07-25 04:35:00 | AAPL | Stock | 15.7589 | 15.7589 | 15.7589 | 15.7589 | 2800.0 |
| 2013-07-25 05:17:00 | AAPL | Stock | 15.7493 | 15.7493 | 15.7321 | 15.7321 | 12516.0 |
| 2013-07-25 05:26:00 | AAPL | Stock | 15.7318 | 15.7318 | 15.7143 | 15.7143 | 13188.0 |
| 2013-07-25 05:33:00 | AAPL | Stock | 15.7143 | 15.7143 | 15.7143 | 15.7143 | 2800.0 |
| 2013-07-25 05:37:00 | AAPL | Stock | 15.6839 | 15.6839 | 15.6839 | 15.6839 | 2800.0 |
| 2013-07-25 05:48:00 | AAPL | Stock | 15.6839 | 15.6839 | 15.6839 | 15.6839 | 6216.0 |
| 2013-07-25 05:49:00 | AAPL | Stock | 15.6786 | 15.6786 | 15.6786 | 15.6786 | 5600.0 |
| 2013-07-25 06:15:00 | AAPL | Stock | 15.6786 | 15.6786 | 15.6786 | 15.6786 | 16800.0 |
| 2013-07-25 06:54:00 | AAPL | Stock | 15.7036 | 15.7036 | 15.7036 | 15.7036 | 2800.0 |
| 2013-07-25 07:00:00 | AAPL | Stock | 15.6911 | 15.7054 | 15.6893 | 15.7054 | 28280.0 |
| 2013-07-25 07:01:00 | AAPL | Stock | 15.7054 | 15.7054 | 15.6921 | 15.7 | 25200.0 |
| 2013-07-25 07:02:00 | AAPL | Stock | 15.7 | 15.7143 | 15.7 | 15.7143 | 33544.0 |
| 2013-07-25 07:03:00 | AAPL | Stock | 15.7025 | 15.7025 | 15.7025 | 15.7025 | 5600.0 |
| 2013-07-25 07:04:00 | AAPL | Stock | 15.6943 | 15.7018 | 15.6943 | 15.7018 | 5600.0 |
| 2013-07-25 07:16:00 | AAPL | Stock | 15.6968 | 15.6968 | 15.6968 | 15.6968 | 3024.0 |
| 2013-07-25 07:22:00 | AAPL | Stock | 15.7054 | 15.7054 | 15.7054 | 15.7054 | 2800.0 |
| 2013-07-25 07:23:00 | AAPL | Stock | 15.7125 | 15.7143 | 15.7125 | 15.7143 | 19656.0 |
| 2013-07-25 07:25:00 | AAPL | Stock | 15.7054 | 15.7054 | 15.7054 | 15.7054 | 5600.0 |
| 2013-07-25 07:26:00 | AAPL | Stock | 15.7139 | 15.7143 | 15.7139 | 15.7143 | 17920.0 |
| 2013-07-25 07:32:00 | AAPL | Stock | 15.7168 | 15.7168 | 15.7168 | 15.7168 | 2800.0 |
| 2013-07-25 07:38:00 | AAPL | Stock | 15.7229 | 15.7243 | 15.7229 | 15.7243 | 14952.0 |
| 2013-07-25 07:39:00 | AAPL | Stock | 15.7286 | 15.73 | 15.7286 | 15.7293 | 15624.0 |
| 2013-07-25 07:40:00 | AAPL | Stock | 15.7243 | 15.7243 | 15.7243 | 15.7243 | 2800.0 |
| 2013-07-25 07:41:00 | AAPL | Stock | 15.7243 | 15.7243 | 15.7243 | 15.7243 | 2940.0 |
| 2013-07-25 07:42:00 | AAPL | Stock | 15.7246 | 15.7254 | 15.7232 | 15.7232 | 36400.0 |
| 2013-07-25 07:43:00 | AAPL | Stock | 15.7232 | 15.7311 | 15.7232 | 15.7246 | 30800.0 |
| 2013-07-25 07:47:00 | AAPL | Stock | 15.7296 | 15.7314 | 15.7246 | 15.7246 | 32536.0 |
| 2013-07-25 07:52:00 | AAPL | Stock | 15.7261 | 15.7261 | 15.7157 | 15.7211 | 71400.0 |
| 2013-07-25 07:53:00 | AAPL | Stock | 15.7264 | 15.7279 | 15.7264 | 15.7279 | 14000.0 |
| 2013-07-25 07:57:00 | AAPL | Stock | 15.7218 | 15.7221 | 15.7218 | 15.7221 | 5880.0 |
| 2013-07-25 07:59:00 | AAPL | Stock | 15.7268 | 15.7268 | 15.7268 | 15.7268 | 8400.0 |
| 2013-07-25 08:00:00 | AAPL | Stock | 15.7214 | 15.7318 | 15.7036 | 15.7104 | 44156.0 |
| 2013-07-25 08:01:00 | AAPL | Stock | 15.715 | 15.7157 | 15.7143 | 15.7157 | 11200.0 |
| 2013-07-25 08:02:00 | AAPL | Stock | 15.7264 | 15.7286 | 15.7264 | 15.7286 | 30660.0 |
| 2013-07-25 08:03:00 | AAPL | Stock | 15.7318 | 15.7414 | 15.7318 | 15.7414 | 29988.0 |
| 2013-07-25 08:04:00 | AAPL | Stock | 15.7411 | 15.7411 | 15.7411 | 15.7411 | 2800.0 |
| 2013-07-25 08:05:00 | AAPL | Stock | 15.74 | 15.7575 | 15.74 | 15.7568 | 122920.0 |
| 2013-07-25 08:06:00 | AAPL | Stock | 15.7568 | 15.7679 | 15.7543 | 15.7643 | 30800.0 |
| 2013-07-25 08:07:00 | AAPL | Stock | 15.6786 | 15.7564 | 15.6786 | 15.75 | 86800.0 |
| 2013-07-25 08:08:00 | AAPL | Stock | 15.75 | 15.75 | 15.75 | 15.75 | 2800.0 |
| 2013-07-25 08:09:00 | AAPL | Stock | 15.7361 | 15.7361 | 15.7357 | 15.7357 | 19600.0 |
| 2013-07-25 08:10:00 | AAPL | Stock | 15.7357 | 15.7357 | 15.7229 | 15.7286 | 60900.0 |
| 2013-07-25 08:13:00 | AAPL | Stock | 15.7296 | 15.7296 | 15.7286 | 15.7286 | 8400.0 |
| 2013-07-25 08:14:00 | AAPL | Stock | 15.725 | 15.725 | 15.725 | 15.725 | 8400.0 |
| 2013-07-25 08:15:00 | AAPL | Stock | 15.725 | 15.725 | 15.7125 | 15.7143 | 87416.0 |
| 2013-07-25 08:17:00 | AAPL | Stock | 15.7132 | 15.7132 | 15.7132 | 15.7132 | 2800.0 |
| 2013-07-25 08:18:00 | AAPL | Stock | 15.7054 | 15.7054 | 15.7054 | 15.7054 | 5600.0 |
> showing 50 of 1,024,287 rows — these rows as CSV