PREVIEW / stock_5min / 2013-07-03
file: by_date/stock_5min/2013/2013-07-03.parquet size: 3.0 MB rows: 187,690 symbols: 3,403
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-03 04:00:00 | AAPL | Stock | 14.9107 | 14.9107 | 14.9107 | 14.9107 | 8400.0 |
| 2013-07-03 04:05:00 | AAPL | Stock | 14.8393 | 14.8393 | 14.8286 | 14.8393 | 14000.0 |
| 2013-07-03 04:50:00 | AAPL | Stock | 14.8407 | 14.8407 | 14.8407 | 14.8407 | 2800.0 |
| 2013-07-03 05:10:00 | AAPL | Stock | 14.8839 | 14.8839 | 14.8839 | 14.8839 | 2800.0 |
| 2013-07-03 06:35:00 | AAPL | Stock | 14.8564 | 14.8571 | 14.8564 | 14.8571 | 5600.0 |
| 2013-07-03 06:45:00 | AAPL | Stock | 14.8571 | 14.8571 | 14.8571 | 14.8571 | 11200.0 |
| 2013-07-03 07:00:00 | AAPL | Stock | 14.8571 | 14.8654 | 14.8571 | 14.8571 | 50456.0 |
| 2013-07-03 07:05:00 | AAPL | Stock | 14.8575 | 14.8575 | 14.8571 | 14.8571 | 15204.0 |
| 2013-07-03 07:10:00 | AAPL | Stock | 14.8571 | 14.8575 | 14.8571 | 14.8575 | 21000.0 |
| 2013-07-03 07:15:00 | AAPL | Stock | 14.8571 | 14.8571 | 14.8571 | 14.8571 | 5600.0 |
| 2013-07-03 07:25:00 | AAPL | Stock | 14.8561 | 14.8568 | 14.8561 | 14.8568 | 5600.0 |
| 2013-07-03 07:30:00 | AAPL | Stock | 14.8721 | 14.8729 | 14.8721 | 14.8729 | 5600.0 |
| 2013-07-03 07:35:00 | AAPL | Stock | 14.875 | 14.875 | 14.875 | 14.875 | 8400.0 |
| 2013-07-03 07:40:00 | AAPL | Stock | 14.8679 | 14.8839 | 14.8679 | 14.8839 | 7000.0 |
| 2013-07-03 07:55:00 | AAPL | Stock | 14.875 | 14.8825 | 14.8732 | 14.8825 | 27804.0 |
| 2013-07-03 08:00:00 | AAPL | Stock | 14.8854 | 14.95 | 14.8393 | 14.8857 | 496132.0 |
| 2013-07-03 08:05:00 | AAPL | Stock | 14.8775 | 14.8821 | 14.8714 | 14.8814 | 50932.0 |
| 2013-07-03 08:10:00 | AAPL | Stock | 14.8814 | 14.8929 | 14.8689 | 14.8689 | 87416.0 |
| 2013-07-03 08:15:00 | AAPL | Stock | 14.8771 | 14.8982 | 14.8639 | 14.8929 | 248780.0 |
| 2013-07-03 08:20:00 | AAPL | Stock | 14.8929 | 14.9089 | 14.8904 | 14.9036 | 153384.0 |
| 2013-07-03 08:25:00 | AAPL | Stock | 14.9064 | 14.9425 | 14.9025 | 14.9286 | 455084.0 |
| 2013-07-03 08:30:00 | AAPL | Stock | 14.9289 | 14.9643 | 14.9289 | 14.9571 | 526988.0 |
| 2013-07-03 08:35:00 | AAPL | Stock | 14.9571 | 14.9643 | 14.9464 | 14.9529 | 415128.0 |
| 2013-07-03 08:40:00 | AAPL | Stock | 14.9511 | 14.9714 | 14.9475 | 14.9643 | 473508.0 |
| 2013-07-03 08:45:00 | AAPL | Stock | 14.9639 | 14.9925 | 14.9607 | 14.9925 | 235228.0 |
| 2013-07-03 08:50:00 | AAPL | Stock | 14.9939 | 15.0286 | 14.9911 | 15.0196 | 565516.0 |
| 2013-07-03 08:55:00 | AAPL | Stock | 15.0193 | 15.0229 | 15.0071 | 15.0143 | 190456.0 |
| 2013-07-03 09:00:00 | AAPL | Stock | 15.0129 | 15.02 | 15.0057 | 15.0157 | 368340.0 |
| 2013-07-03 09:05:00 | AAPL | Stock | 15.0168 | 15.0268 | 15.0146 | 15.0186 | 152348.0 |
| 2013-07-03 09:10:00 | AAPL | Stock | 15.02 | 15.03 | 15.015 | 15.03 | 450296.0 |
| 2013-07-03 09:15:00 | AAPL | Stock | 15.0314 | 15.0518 | 15.0182 | 15.0254 | 674128.0 |
| 2013-07-03 09:20:00 | AAPL | Stock | 15.0254 | 15.0636 | 15.0254 | 15.0286 | 1105160.0 |
| 2013-07-03 09:25:00 | AAPL | Stock | 15.0357 | 15.045 | 15.0179 | 15.0264 | 273700.0 |
| 2013-07-03 09:30:00 | AAPL | Stock | 15.0321 | 15.1064 | 15.0 | 15.0182 | 25733680.0 |
| 2013-07-03 09:35:00 | AAPL | Stock | 15.0189 | 15.0796 | 14.9579 | 14.9671 | 15516928.0 |
| 2013-07-03 09:40:00 | AAPL | Stock | 14.96 | 15.0089 | 14.9518 | 14.9911 | 10438568.0 |
| 2013-07-03 09:45:00 | AAPL | Stock | 14.988 | 15.0179 | 14.9218 | 14.9218 | 9448628.0 |
| 2013-07-03 09:50:00 | AAPL | Stock | 14.9218 | 14.9746 | 14.9093 | 14.9396 | 8743560.0 |
| 2013-07-03 09:55:00 | AAPL | Stock | 14.9446 | 14.9946 | 14.9254 | 14.9629 | 7940940.0 |
| 2013-07-03 10:00:00 | AAPL | Stock | 14.9639 | 15.0168 | 14.9361 | 14.9489 | 7726432.0 |
| 2013-07-03 10:05:00 | AAPL | Stock | 14.9466 | 14.9564 | 14.9089 | 14.9557 | 7976136.0 |
| 2013-07-03 10:10:00 | AAPL | Stock | 14.9492 | 14.9643 | 14.9157 | 14.9596 | 5237008.0 |
| 2013-07-03 10:15:00 | AAPL | Stock | 14.959 | 14.9707 | 14.9311 | 14.945 | 4335968.0 |
| 2013-07-03 10:20:00 | AAPL | Stock | 14.9425 | 14.9982 | 14.9407 | 14.9604 | 7314328.0 |
| 2013-07-03 10:25:00 | AAPL | Stock | 14.9589 | 14.9846 | 14.9571 | 14.9721 | 4066636.0 |
| 2013-07-03 10:30:00 | AAPL | Stock | 14.9775 | 15.0068 | 14.9729 | 14.9929 | 4253844.0 |
| 2013-07-03 10:35:00 | AAPL | Stock | 14.9957 | 14.9971 | 14.9575 | 14.9596 | 3085432.0 |
| 2013-07-03 10:40:00 | AAPL | Stock | 14.965 | 15.0039 | 14.9586 | 14.9966 | 2872436.0 |
| 2013-07-03 10:45:00 | AAPL | Stock | 14.9957 | 15.0 | 14.9714 | 14.9946 | 2424380.0 |
| 2013-07-03 10:50:00 | AAPL | Stock | 14.9935 | 15.0054 | 14.9711 | 14.9876 | 2700460.0 |
> showing 50 of 187,690 rows — these rows as CSV