PREVIEW / stock_5min / 2014-11-05
file: by_date/stock_5min/2014/2014-11-05.parquet size: 5.5 MB rows: 360,813 symbols: 3,544
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 |
|---|---|---|---|---|---|---|---|
| 2014-11-05 04:00:00 | AAPL | Stock | 27.225 | 27.225 | 27.225 | 27.225 | 400.0 |
| 2014-11-05 04:10:00 | AAPL | Stock | 27.2375 | 27.2375 | 27.2125 | 27.2125 | 4000.0 |
| 2014-11-05 04:15:00 | AAPL | Stock | 27.2375 | 27.2375 | 27.2375 | 27.2375 | 1200.0 |
| 2014-11-05 04:20:00 | AAPL | Stock | 27.225 | 27.225 | 27.225 | 27.225 | 2000.0 |
| 2014-11-05 04:30:00 | AAPL | Stock | 27.225 | 27.225 | 27.225 | 27.225 | 400.0 |
| 2014-11-05 04:35:00 | AAPL | Stock | 27.245 | 27.245 | 27.2375 | 27.2375 | 4256.0 |
| 2014-11-05 04:40:00 | AAPL | Stock | 27.2375 | 27.25 | 27.2375 | 27.25 | 3800.0 |
| 2014-11-05 04:45:00 | AAPL | Stock | 27.2625 | 27.2625 | 27.2625 | 27.2625 | 400.0 |
| 2014-11-05 04:50:00 | AAPL | Stock | 27.2575 | 27.2625 | 27.2575 | 27.2625 | 3200.0 |
| 2014-11-05 04:55:00 | AAPL | Stock | 27.2575 | 27.2625 | 27.2575 | 27.2625 | 8400.0 |
| 2014-11-05 05:05:00 | AAPL | Stock | 27.2625 | 27.2625 | 27.2625 | 27.2625 | 1184.0 |
| 2014-11-05 05:15:00 | AAPL | Stock | 27.2875 | 27.2875 | 27.2875 | 27.2875 | 1820.0 |
| 2014-11-05 05:20:00 | AAPL | Stock | 27.2875 | 27.3375 | 27.2875 | 27.325 | 12720.0 |
| 2014-11-05 05:25:00 | AAPL | Stock | 27.32 | 27.32 | 27.32 | 27.32 | 400.0 |
| 2014-11-05 05:55:00 | AAPL | Stock | 27.29 | 27.29 | 27.29 | 27.29 | 400.0 |
| 2014-11-05 06:00:00 | AAPL | Stock | 27.295 | 27.32 | 27.295 | 27.32 | 4308.0 |
| 2014-11-05 06:05:00 | AAPL | Stock | 27.3175 | 27.3175 | 27.29 | 27.29 | 3200.0 |
| 2014-11-05 06:20:00 | AAPL | Stock | 27.275 | 27.275 | 27.265 | 27.265 | 2000.0 |
| 2014-11-05 06:25:00 | AAPL | Stock | 27.265 | 27.265 | 27.265 | 27.265 | 1600.0 |
| 2014-11-05 06:30:00 | AAPL | Stock | 27.265 | 27.275 | 27.265 | 27.275 | 7104.0 |
| 2014-11-05 06:35:00 | AAPL | Stock | 27.275 | 27.275 | 27.275 | 27.275 | 1600.0 |
| 2014-11-05 06:40:00 | AAPL | Stock | 27.2725 | 27.2725 | 27.2725 | 27.2725 | 5300.0 |
| 2014-11-05 06:45:00 | AAPL | Stock | 27.275 | 27.275 | 27.275 | 27.275 | 800.0 |
| 2014-11-05 06:50:00 | AAPL | Stock | 27.275 | 27.275 | 27.2725 | 27.2725 | 8800.0 |
| 2014-11-05 07:00:00 | AAPL | Stock | 27.265 | 27.2725 | 27.25 | 27.2525 | 12700.0 |
| 2014-11-05 07:05:00 | AAPL | Stock | 27.2675 | 27.2725 | 27.2525 | 27.2725 | 10500.0 |
| 2014-11-05 07:10:00 | AAPL | Stock | 27.2725 | 27.275 | 27.25 | 27.255 | 14472.0 |
| 2014-11-05 07:15:00 | AAPL | Stock | 27.2575 | 27.265 | 27.2575 | 27.265 | 5600.0 |
| 2014-11-05 07:20:00 | AAPL | Stock | 27.275 | 27.275 | 27.265 | 27.275 | 16720.0 |
| 2014-11-05 07:25:00 | AAPL | Stock | 27.275 | 27.285 | 27.275 | 27.285 | 12400.0 |
| 2014-11-05 07:30:00 | AAPL | Stock | 27.2875 | 27.2875 | 27.285 | 27.2875 | 15516.0 |
| 2014-11-05 07:35:00 | AAPL | Stock | 27.29 | 27.29 | 27.28 | 27.2825 | 8280.0 |
| 2014-11-05 07:40:00 | AAPL | Stock | 27.2875 | 27.29 | 27.2875 | 27.29 | 1536.0 |
| 2014-11-05 07:45:00 | AAPL | Stock | 27.29 | 27.29 | 27.2875 | 27.2875 | 11516.0 |
| 2014-11-05 07:50:00 | AAPL | Stock | 27.2875 | 27.2925 | 27.2875 | 27.2925 | 1400.0 |
| 2014-11-05 07:55:00 | AAPL | Stock | 27.2925 | 27.2925 | 27.2825 | 27.2875 | 7232.0 |
| 2014-11-05 08:00:00 | AAPL | Stock | 27.2875 | 27.32 | 27.1 | 27.255 | 198076.0 |
| 2014-11-05 08:05:00 | AAPL | Stock | 27.255 | 27.2825 | 27.255 | 27.2825 | 62808.0 |
| 2014-11-05 08:10:00 | AAPL | Stock | 27.2825 | 27.295 | 27.2775 | 27.2875 | 78152.0 |
| 2014-11-05 08:15:00 | AAPL | Stock | 27.2875 | 27.2875 | 27.275 | 27.28 | 45188.0 |
| 2014-11-05 08:20:00 | AAPL | Stock | 27.275 | 27.285 | 27.275 | 27.285 | 30784.0 |
| 2014-11-05 08:25:00 | AAPL | Stock | 27.2825 | 27.2825 | 27.2675 | 27.275 | 75376.0 |
| 2014-11-05 08:30:00 | AAPL | Stock | 27.2712 | 27.285 | 27.2625 | 27.27 | 57200.0 |
| 2014-11-05 08:35:00 | AAPL | Stock | 27.27 | 27.27 | 27.2675 | 27.27 | 5460.0 |
| 2014-11-05 08:40:00 | AAPL | Stock | 27.265 | 27.27 | 27.2625 | 27.27 | 17304.0 |
| 2014-11-05 08:45:00 | AAPL | Stock | 27.2675 | 27.285 | 27.2675 | 27.285 | 33576.0 |
| 2014-11-05 08:50:00 | AAPL | Stock | 27.275 | 27.285 | 27.275 | 27.275 | 10928.0 |
| 2014-11-05 08:55:00 | AAPL | Stock | 27.285 | 27.295 | 27.285 | 27.29 | 33120.0 |
| 2014-11-05 09:00:00 | AAPL | Stock | 27.295 | 27.3 | 27.275 | 27.2975 | 59576.0 |
| 2014-11-05 09:05:00 | AAPL | Stock | 27.2775 | 27.28 | 27.27 | 27.27 | 64624.0 |
> showing 50 of 360,813 rows — these rows as CSV