PREVIEW / stock_5min / 2013-08-15
file: by_date/stock_5min/2013/2013-08-15.parquet size: 5.3 MB rows: 353,399 symbols: 3,551
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-08-15 04:00:00 | AAPL | Stock | 17.7414 | 17.8186 | 17.7414 | 17.8186 | 5628.0 |
| 2013-08-15 04:05:00 | AAPL | Stock | 17.8154 | 17.8154 | 17.8154 | 17.8154 | 2800.0 |
| 2013-08-15 04:10:00 | AAPL | Stock | 17.85 | 17.85 | 17.85 | 17.85 | 2800.0 |
| 2013-08-15 04:15:00 | AAPL | Stock | 17.85 | 17.85 | 17.8464 | 17.8464 | 5600.0 |
| 2013-08-15 04:20:00 | AAPL | Stock | 17.8464 | 17.8568 | 17.8464 | 17.8568 | 24332.0 |
| 2013-08-15 04:25:00 | AAPL | Stock | 17.8925 | 17.8925 | 17.8925 | 17.8925 | 5796.0 |
| 2013-08-15 04:35:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 14000.0 |
| 2013-08-15 04:40:00 | AAPL | Stock | 17.8718 | 17.8718 | 17.8718 | 17.8718 | 2800.0 |
| 2013-08-15 04:50:00 | AAPL | Stock | 17.8661 | 17.8679 | 17.8571 | 17.8571 | 27440.0 |
| 2013-08-15 04:55:00 | AAPL | Stock | 17.8461 | 17.8461 | 17.8461 | 17.8461 | 2800.0 |
| 2013-08-15 05:00:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8568 | 17.8568 | 5600.0 |
| 2013-08-15 05:05:00 | AAPL | Stock | 17.8482 | 17.8482 | 17.8482 | 17.8482 | 2800.0 |
| 2013-08-15 05:10:00 | AAPL | Stock | 17.8571 | 17.8782 | 17.8571 | 17.8782 | 23800.0 |
| 2013-08-15 05:20:00 | AAPL | Stock | 17.8568 | 17.8568 | 17.8482 | 17.8482 | 5600.0 |
| 2013-08-15 05:25:00 | AAPL | Stock | 17.8471 | 17.8571 | 17.8471 | 17.8571 | 11200.0 |
| 2013-08-15 05:35:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 8400.0 |
| 2013-08-15 05:40:00 | AAPL | Stock | 17.8575 | 17.8575 | 17.8575 | 17.8575 | 2800.0 |
| 2013-08-15 05:45:00 | AAPL | Stock | 17.8636 | 17.8636 | 17.8636 | 17.8636 | 3360.0 |
| 2013-08-15 05:50:00 | AAPL | Stock | 17.8661 | 17.8661 | 17.8575 | 17.8575 | 8400.0 |
| 2013-08-15 05:55:00 | AAPL | Stock | 17.8818 | 17.8818 | 17.8696 | 17.875 | 21000.0 |
| 2013-08-15 06:00:00 | AAPL | Stock | 17.875 | 17.8821 | 17.875 | 17.8821 | 19600.0 |
| 2013-08-15 06:10:00 | AAPL | Stock | 17.8854 | 17.8854 | 17.8854 | 17.8854 | 2800.0 |
| 2013-08-15 06:15:00 | AAPL | Stock | 17.87 | 17.87 | 17.85 | 17.85 | 53284.0 |
| 2013-08-15 06:20:00 | AAPL | Stock | 17.8464 | 17.8464 | 17.8461 | 17.8464 | 11200.0 |
| 2013-08-15 06:25:00 | AAPL | Stock | 17.8661 | 17.8661 | 17.8464 | 17.8568 | 30520.0 |
| 2013-08-15 06:35:00 | AAPL | Stock | 17.8525 | 17.8525 | 17.8393 | 17.8393 | 24444.0 |
| 2013-08-15 06:40:00 | AAPL | Stock | 17.8357 | 17.8625 | 17.8357 | 17.8625 | 14840.0 |
| 2013-08-15 06:50:00 | AAPL | Stock | 17.8304 | 17.8304 | 17.8286 | 17.8286 | 6216.0 |
| 2013-08-15 07:00:00 | AAPL | Stock | 17.8214 | 17.8532 | 17.8161 | 17.8457 | 88004.0 |
| 2013-08-15 07:05:00 | AAPL | Stock | 17.8493 | 17.855 | 17.8393 | 17.8468 | 81200.0 |
| 2013-08-15 07:10:00 | AAPL | Stock | 17.8446 | 17.8446 | 17.8393 | 17.8393 | 51408.0 |
| 2013-08-15 07:15:00 | AAPL | Stock | 17.8411 | 17.8411 | 17.8225 | 17.8225 | 56000.0 |
| 2013-08-15 07:20:00 | AAPL | Stock | 17.8214 | 17.8214 | 17.8036 | 17.8111 | 67200.0 |
| 2013-08-15 07:25:00 | AAPL | Stock | 17.8071 | 17.8071 | 17.7982 | 17.8025 | 85288.0 |
| 2013-08-15 07:30:00 | AAPL | Stock | 17.7939 | 17.8075 | 17.7939 | 17.8036 | 107240.0 |
| 2013-08-15 07:35:00 | AAPL | Stock | 17.8036 | 17.8171 | 17.8036 | 17.8125 | 77000.0 |
| 2013-08-15 07:40:00 | AAPL | Stock | 17.8125 | 17.8214 | 17.7964 | 17.8043 | 258888.0 |
| 2013-08-15 07:45:00 | AAPL | Stock | 17.8021 | 17.8118 | 17.7643 | 17.7643 | 120008.0 |
| 2013-08-15 07:50:00 | AAPL | Stock | 17.7679 | 17.7796 | 17.7575 | 17.7593 | 97300.0 |
| 2013-08-15 07:55:00 | AAPL | Stock | 17.77 | 17.77 | 17.7536 | 17.7657 | 70588.0 |
| 2013-08-15 08:00:00 | AAPL | Stock | 17.7554 | 17.8557 | 17.7218 | 17.7325 | 463988.0 |
| 2013-08-15 08:05:00 | AAPL | Stock | 17.7325 | 17.7357 | 17.6918 | 17.7029 | 648844.0 |
| 2013-08-15 08:10:00 | AAPL | Stock | 17.6946 | 17.7321 | 17.6946 | 17.7311 | 317632.0 |
| 2013-08-15 08:15:00 | AAPL | Stock | 17.725 | 17.7275 | 17.7161 | 17.7275 | 213976.0 |
| 2013-08-15 08:20:00 | AAPL | Stock | 17.7232 | 17.7304 | 17.6964 | 17.6964 | 333872.0 |
| 2013-08-15 08:25:00 | AAPL | Stock | 17.6964 | 17.7 | 17.6661 | 17.6754 | 678272.0 |
| 2013-08-15 08:30:00 | AAPL | Stock | 17.6686 | 17.6732 | 17.5932 | 17.5979 | 1046724.0 |
| 2013-08-15 08:35:00 | AAPL | Stock | 17.6071 | 17.6193 | 17.5986 | 17.6193 | 1003520.0 |
| 2013-08-15 08:40:00 | AAPL | Stock | 17.6204 | 17.6429 | 17.62 | 17.6286 | 660632.0 |
| 2013-08-15 08:45:00 | AAPL | Stock | 17.6325 | 17.6429 | 17.6314 | 17.6425 | 291928.0 |
> showing 50 of 353,399 rows — these rows as CSV