PREVIEW / stock_5min / 2013-08-16
file: by_date/stock_5min/2013/2013-08-16.parquet size: 5.2 MB rows: 346,259 symbols: 3,505
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-16 04:50:00 | AAPL | Stock | 17.8321 | 17.8321 | 17.8321 | 17.8321 | 8960.0 |
| 2013-08-16 04:55:00 | AAPL | Stock | 17.8682 | 17.8682 | 17.8607 | 17.8607 | 22708.0 |
| 2013-08-16 05:05:00 | AAPL | Stock | 17.8671 | 17.8671 | 17.8671 | 17.8671 | 2800.0 |
| 2013-08-16 05:10:00 | AAPL | Stock | 17.8671 | 17.8671 | 17.8571 | 17.8571 | 14000.0 |
| 2013-08-16 05:30:00 | AAPL | Stock | 17.8357 | 17.8393 | 17.8357 | 17.8393 | 21812.0 |
| 2013-08-16 05:35:00 | AAPL | Stock | 17.8539 | 17.8539 | 17.85 | 17.85 | 5600.0 |
| 2013-08-16 05:40:00 | AAPL | Stock | 17.85 | 17.85 | 17.8036 | 17.8211 | 51520.0 |
| 2013-08-16 05:45:00 | AAPL | Stock | 17.8211 | 17.8211 | 17.8211 | 17.8211 | 16800.0 |
| 2013-08-16 06:20:00 | AAPL | Stock | 17.8496 | 17.8496 | 17.8496 | 17.8496 | 2800.0 |
| 2013-08-16 06:55:00 | AAPL | Stock | 17.8471 | 17.8471 | 17.8471 | 17.8471 | 2800.0 |
| 2013-08-16 07:00:00 | AAPL | Stock | 17.8393 | 17.8393 | 17.8393 | 17.8393 | 2800.0 |
| 2013-08-16 07:05:00 | AAPL | Stock | 17.8393 | 17.8393 | 17.8393 | 17.8393 | 5600.0 |
| 2013-08-16 07:10:00 | AAPL | Stock | 17.8289 | 17.8393 | 17.8232 | 17.8304 | 44520.0 |
| 2013-08-16 07:15:00 | AAPL | Stock | 17.8321 | 17.8536 | 17.8282 | 17.8536 | 45752.0 |
| 2013-08-16 07:20:00 | AAPL | Stock | 17.8511 | 17.8671 | 17.8482 | 17.8582 | 84840.0 |
| 2013-08-16 07:25:00 | AAPL | Stock | 17.8571 | 17.8743 | 17.8571 | 17.8661 | 36400.0 |
| 2013-08-16 07:30:00 | AAPL | Stock | 17.8593 | 17.8607 | 17.8482 | 17.8482 | 39368.0 |
| 2013-08-16 07:35:00 | AAPL | Stock | 17.8429 | 17.8536 | 17.8411 | 17.8536 | 11200.0 |
| 2013-08-16 07:40:00 | AAPL | Stock | 17.8607 | 17.8696 | 17.8607 | 17.8661 | 16800.0 |
| 2013-08-16 07:45:00 | AAPL | Stock | 17.8625 | 17.8839 | 17.8625 | 17.8761 | 115192.0 |
| 2013-08-16 07:50:00 | AAPL | Stock | 17.8882 | 17.8882 | 17.875 | 17.875 | 25200.0 |
| 2013-08-16 07:55:00 | AAPL | Stock | 17.8825 | 17.8825 | 17.875 | 17.8807 | 50120.0 |
| 2013-08-16 08:00:00 | AAPL | Stock | 17.8761 | 17.8904 | 17.8286 | 17.8696 | 285628.0 |
| 2013-08-16 08:05:00 | AAPL | Stock | 17.8607 | 17.8704 | 17.8536 | 17.8571 | 225428.0 |
| 2013-08-16 08:10:00 | AAPL | Stock | 17.8586 | 17.8668 | 17.8482 | 17.8482 | 166964.0 |
| 2013-08-16 08:15:00 | AAPL | Stock | 17.8493 | 17.8736 | 17.8493 | 17.8736 | 119504.0 |
| 2013-08-16 08:20:00 | AAPL | Stock | 17.8736 | 17.8907 | 17.8736 | 17.8846 | 254856.0 |
| 2013-08-16 08:25:00 | AAPL | Stock | 17.8821 | 17.8836 | 17.8714 | 17.875 | 184044.0 |
| 2013-08-16 08:30:00 | AAPL | Stock | 17.8732 | 17.8786 | 17.87 | 17.8707 | 148148.0 |
| 2013-08-16 08:35:00 | AAPL | Stock | 17.8714 | 17.875 | 17.8661 | 17.8679 | 58492.0 |
| 2013-08-16 08:40:00 | AAPL | Stock | 17.875 | 17.875 | 17.8729 | 17.875 | 39200.0 |
| 2013-08-16 08:45:00 | AAPL | Stock | 17.875 | 17.8786 | 17.8671 | 17.8689 | 105028.0 |
| 2013-08-16 08:50:00 | AAPL | Stock | 17.8732 | 17.8825 | 17.8732 | 17.8825 | 132440.0 |
| 2013-08-16 08:55:00 | AAPL | Stock | 17.8825 | 17.8911 | 17.8821 | 17.8907 | 140336.0 |
| 2013-08-16 09:00:00 | AAPL | Stock | 17.8879 | 17.8918 | 17.8804 | 17.8918 | 174104.0 |
| 2013-08-16 09:05:00 | AAPL | Stock | 17.8914 | 17.9161 | 17.8893 | 17.9114 | 436240.0 |
| 2013-08-16 09:10:00 | AAPL | Stock | 17.9157 | 17.9286 | 17.9004 | 17.9007 | 460208.0 |
| 2013-08-16 09:15:00 | AAPL | Stock | 17.8954 | 17.9179 | 17.8954 | 17.9143 | 324800.0 |
| 2013-08-16 09:20:00 | AAPL | Stock | 17.9107 | 17.9182 | 17.8964 | 17.9029 | 299852.0 |
| 2013-08-16 09:25:00 | AAPL | Stock | 17.9046 | 17.9143 | 17.8614 | 17.8636 | 1045380.0 |
| 2013-08-16 09:30:00 | AAPL | Stock | 17.8629 | 17.9186 | 17.8351 | 17.8682 | 32171692.0 |
| 2013-08-16 09:35:00 | AAPL | Stock | 17.8682 | 17.8889 | 17.8168 | 17.8818 | 11369176.0 |
| 2013-08-16 09:40:00 | AAPL | Stock | 17.8821 | 17.8839 | 17.8164 | 17.8545 | 8177120.0 |
| 2013-08-16 09:45:00 | AAPL | Stock | 17.851 | 17.8861 | 17.8275 | 17.8668 | 7594664.0 |
| 2013-08-16 09:50:00 | AAPL | Stock | 17.8711 | 17.9154 | 17.8668 | 17.8961 | 8934464.0 |
| 2013-08-16 09:55:00 | AAPL | Stock | 17.8991 | 17.9004 | 17.8425 | 17.8832 | 6695500.0 |
| 2013-08-16 10:00:00 | AAPL | Stock | 17.8876 | 17.9011 | 17.8593 | 17.9011 | 5094124.0 |
| 2013-08-16 10:05:00 | AAPL | Stock | 17.8986 | 17.915 | 17.8829 | 17.9007 | 6183576.0 |
| 2013-08-16 10:10:00 | AAPL | Stock | 17.8993 | 17.9357 | 17.8986 | 17.9214 | 9228100.0 |
| 2013-08-16 10:15:00 | AAPL | Stock | 17.9186 | 17.9343 | 17.8954 | 17.9014 | 5606524.0 |
> showing 50 of 346,259 rows — these rows as CSV