PREVIEW / stock_5min / 2013-09-23
file: by_date/stock_5min/2013/2013-09-23.parquet size: 5.2 MB rows: 348,318 symbols: 3,521
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-09-23 04:10:00 | AAPL | Stock | 16.7546 | 16.7546 | 16.7546 | 16.7546 | 2800.0 |
| 2013-09-23 04:35:00 | AAPL | Stock | 16.7893 | 16.7893 | 16.7893 | 16.7893 | 2800.0 |
| 2013-09-23 05:00:00 | AAPL | Stock | 16.8357 | 16.8357 | 16.8357 | 16.8357 | 3808.0 |
| 2013-09-23 05:20:00 | AAPL | Stock | 16.8039 | 16.8039 | 16.7857 | 16.7857 | 36540.0 |
| 2013-09-23 05:30:00 | AAPL | Stock | 16.765 | 16.765 | 16.765 | 16.765 | 2800.0 |
| 2013-09-23 05:35:00 | AAPL | Stock | 16.7636 | 16.7636 | 16.7636 | 16.7636 | 2800.0 |
| 2013-09-23 05:40:00 | AAPL | Stock | 16.76 | 16.76 | 16.76 | 16.76 | 2800.0 |
| 2013-09-23 05:45:00 | AAPL | Stock | 16.7443 | 16.7443 | 16.7443 | 16.7443 | 2800.0 |
| 2013-09-23 05:50:00 | AAPL | Stock | 16.7639 | 16.7639 | 16.7639 | 16.7639 | 2800.0 |
| 2013-09-23 06:00:00 | AAPL | Stock | 16.7743 | 16.7743 | 16.7732 | 16.7732 | 7000.0 |
| 2013-09-23 06:15:00 | AAPL | Stock | 16.7714 | 16.7786 | 16.7714 | 16.7786 | 37520.0 |
| 2013-09-23 06:25:00 | AAPL | Stock | 16.7875 | 16.7875 | 16.7732 | 16.7732 | 36400.0 |
| 2013-09-23 06:30:00 | AAPL | Stock | 16.7511 | 16.7511 | 16.7511 | 16.7511 | 2800.0 |
| 2013-09-23 06:35:00 | AAPL | Stock | 16.7511 | 16.755 | 16.7511 | 16.7511 | 8400.0 |
| 2013-09-23 06:40:00 | AAPL | Stock | 16.7404 | 16.7511 | 16.7404 | 16.7404 | 14000.0 |
| 2013-09-23 06:45:00 | AAPL | Stock | 16.7571 | 16.7571 | 16.7571 | 16.7571 | 8400.0 |
| 2013-09-23 06:50:00 | AAPL | Stock | 16.75 | 16.75 | 16.7429 | 16.7429 | 5600.0 |
| 2013-09-23 07:00:00 | AAPL | Stock | 16.7443 | 16.75 | 16.7143 | 16.7143 | 64064.0 |
| 2013-09-23 07:05:00 | AAPL | Stock | 16.7139 | 16.7143 | 16.6964 | 16.7143 | 21000.0 |
| 2013-09-23 07:10:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 2800.0 |
| 2013-09-23 07:15:00 | AAPL | Stock | 16.7 | 16.7 | 16.6868 | 16.6868 | 33600.0 |
| 2013-09-23 07:20:00 | AAPL | Stock | 16.6786 | 16.6786 | 16.6589 | 16.6589 | 11200.0 |
| 2013-09-23 07:25:00 | AAPL | Stock | 16.6446 | 16.6446 | 16.5718 | 16.6064 | 58940.0 |
| 2013-09-23 07:30:00 | AAPL | Stock | 16.5786 | 16.6014 | 16.5375 | 16.5957 | 161728.0 |
| 2013-09-23 07:35:00 | AAPL | Stock | 16.5546 | 16.5714 | 16.5357 | 16.5539 | 156772.0 |
| 2013-09-23 07:40:00 | AAPL | Stock | 16.5771 | 16.6211 | 16.5757 | 16.6211 | 93800.0 |
| 2013-09-23 07:45:00 | AAPL | Stock | 16.6143 | 16.6143 | 16.6143 | 16.6143 | 4004.0 |
| 2013-09-23 07:50:00 | AAPL | Stock | 16.6196 | 16.625 | 16.5982 | 16.5982 | 70532.0 |
| 2013-09-23 07:55:00 | AAPL | Stock | 16.5893 | 16.5893 | 16.5814 | 16.5893 | 16800.0 |
| 2013-09-23 08:00:00 | AAPL | Stock | 16.5893 | 16.7143 | 16.5361 | 16.5996 | 314160.0 |
| 2013-09-23 08:05:00 | AAPL | Stock | 16.6068 | 16.6071 | 16.5839 | 16.5946 | 123620.0 |
| 2013-09-23 08:10:00 | AAPL | Stock | 16.5911 | 16.6179 | 16.5911 | 16.5968 | 158256.0 |
| 2013-09-23 08:15:00 | AAPL | Stock | 16.5911 | 16.5911 | 16.55 | 16.5561 | 319676.0 |
| 2013-09-23 08:20:00 | AAPL | Stock | 16.5625 | 16.5689 | 16.55 | 16.5571 | 172620.0 |
| 2013-09-23 08:25:00 | AAPL | Stock | 16.5689 | 16.5818 | 16.5629 | 16.5811 | 81760.0 |
| 2013-09-23 08:30:00 | AAPL | Stock | 16.5811 | 17.5104 | 16.5811 | 17.4586 | 12738460.0 |
| 2013-09-23 08:35:00 | AAPL | Stock | 17.4561 | 17.4639 | 17.2143 | 17.2361 | 8196636.0 |
| 2013-09-23 08:40:00 | AAPL | Stock | 17.2325 | 17.315 | 17.2161 | 17.315 | 4386872.0 |
| 2013-09-23 08:45:00 | AAPL | Stock | 17.3161 | 17.4593 | 17.2968 | 17.4518 | 9722188.0 |
| 2013-09-23 08:50:00 | AAPL | Stock | 17.4518 | 17.7854 | 17.4386 | 17.7254 | 16504600.0 |
| 2013-09-23 08:55:00 | AAPL | Stock | 17.7493 | 17.7857 | 17.6789 | 17.7411 | 8703492.0 |
| 2013-09-23 09:00:00 | AAPL | Stock | 17.7411 | 17.7679 | 17.6896 | 17.7057 | 6204632.0 |
| 2013-09-23 09:05:00 | AAPL | Stock | 17.7032 | 17.7321 | 17.6989 | 17.7218 | 3651928.0 |
| 2013-09-23 09:10:00 | AAPL | Stock | 17.7214 | 17.7254 | 17.6896 | 17.7021 | 3991904.0 |
| 2013-09-23 09:15:00 | AAPL | Stock | 17.7025 | 17.7475 | 17.6986 | 17.7189 | 2562504.0 |
| 2013-09-23 09:20:00 | AAPL | Stock | 17.7196 | 17.7746 | 17.7143 | 17.7671 | 3024000.0 |
| 2013-09-23 09:25:00 | AAPL | Stock | 17.7671 | 17.8214 | 17.6786 | 17.7146 | 6389460.0 |
| 2013-09-23 09:30:00 | AAPL | Stock | 17.7182 | 17.7468 | 17.5536 | 17.5864 | 65586080.0 |
| 2013-09-23 09:35:00 | AAPL | Stock | 17.5846 | 17.6375 | 17.5339 | 17.6352 | 32202912.0 |
| 2013-09-23 09:40:00 | AAPL | Stock | 17.6357 | 17.6786 | 17.6214 | 17.6441 | 25179560.0 |
> showing 50 of 348,318 rows — these rows as CSV