PREVIEW / stock_5min / 2013-06-12
file: by_date/stock_5min/2013/2013-06-12.parquet size: 5.1 MB rows: 342,990 symbols: 3,494
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-06-12 05:55:00 | AAPL | Stock | 15.7043 | 15.7043 | 15.7043 | 15.7043 | 2800.0 |
| 2013-06-12 06:05:00 | AAPL | Stock | 15.7054 | 15.7054 | 15.7054 | 15.7054 | 2800.0 |
| 2013-06-12 06:10:00 | AAPL | Stock | 15.6968 | 15.6968 | 15.6964 | 15.6964 | 5600.0 |
| 2013-06-12 06:15:00 | AAPL | Stock | 15.6964 | 15.6964 | 15.6964 | 15.6964 | 2800.0 |
| 2013-06-12 06:30:00 | AAPL | Stock | 15.6964 | 15.6964 | 15.6964 | 15.6964 | 7000.0 |
| 2013-06-12 06:45:00 | AAPL | Stock | 15.7107 | 15.7107 | 15.7104 | 15.7107 | 16800.0 |
| 2013-06-12 06:55:00 | AAPL | Stock | 15.7282 | 15.7286 | 15.7282 | 15.7286 | 16772.0 |
| 2013-06-12 07:00:00 | AAPL | Stock | 15.7321 | 15.7446 | 15.7107 | 15.7193 | 66864.0 |
| 2013-06-12 07:05:00 | AAPL | Stock | 15.7221 | 15.7268 | 15.7221 | 15.7268 | 5600.0 |
| 2013-06-12 07:10:00 | AAPL | Stock | 15.7357 | 15.7357 | 15.7236 | 15.7314 | 26600.0 |
| 2013-06-12 07:15:00 | AAPL | Stock | 15.7304 | 15.7304 | 15.7229 | 15.7232 | 19600.0 |
| 2013-06-12 07:20:00 | AAPL | Stock | 15.7143 | 15.7143 | 15.7143 | 15.7143 | 14000.0 |
| 2013-06-12 07:25:00 | AAPL | Stock | 15.7225 | 15.7225 | 15.7225 | 15.7225 | 2800.0 |
| 2013-06-12 07:30:00 | AAPL | Stock | 15.7143 | 15.715 | 15.7 | 15.7143 | 30240.0 |
| 2013-06-12 07:35:00 | AAPL | Stock | 15.7225 | 15.7243 | 15.7221 | 15.7243 | 20160.0 |
| 2013-06-12 07:40:00 | AAPL | Stock | 15.7311 | 15.7375 | 15.7311 | 15.7375 | 22288.0 |
| 2013-06-12 07:45:00 | AAPL | Stock | 15.7454 | 15.7454 | 15.7375 | 15.7375 | 8400.0 |
| 2013-06-12 07:50:00 | AAPL | Stock | 15.7304 | 15.7304 | 15.7304 | 15.7304 | 2800.0 |
| 2013-06-12 07:55:00 | AAPL | Stock | 15.7268 | 15.7268 | 15.7232 | 15.7232 | 28000.0 |
| 2013-06-12 08:00:00 | AAPL | Stock | 15.7271 | 15.7454 | 15.6429 | 15.7143 | 312312.0 |
| 2013-06-12 08:05:00 | AAPL | Stock | 15.7154 | 15.7214 | 15.7143 | 15.7154 | 57092.0 |
| 2013-06-12 08:10:00 | AAPL | Stock | 15.7143 | 15.7143 | 15.7018 | 15.7018 | 97020.0 |
| 2013-06-12 08:15:00 | AAPL | Stock | 15.7007 | 15.71 | 15.6914 | 15.6914 | 113680.0 |
| 2013-06-12 08:20:00 | AAPL | Stock | 15.6946 | 15.6993 | 15.6839 | 15.6943 | 49000.0 |
| 2013-06-12 08:25:00 | AAPL | Stock | 15.6946 | 15.7143 | 15.6943 | 15.7143 | 77364.0 |
| 2013-06-12 08:35:00 | AAPL | Stock | 15.7118 | 15.7118 | 15.6964 | 15.7111 | 172620.0 |
| 2013-06-12 08:40:00 | AAPL | Stock | 15.6964 | 15.7061 | 15.6964 | 15.7057 | 30520.0 |
| 2013-06-12 08:45:00 | AAPL | Stock | 15.7061 | 15.7196 | 15.7061 | 15.7179 | 118384.0 |
| 2013-06-12 08:50:00 | AAPL | Stock | 15.7136 | 15.7175 | 15.7025 | 15.7136 | 77308.0 |
| 2013-06-12 08:55:00 | AAPL | Stock | 15.72 | 15.7221 | 15.72 | 15.7221 | 37240.0 |
| 2013-06-12 09:00:00 | AAPL | Stock | 15.7221 | 15.7268 | 15.7146 | 15.7268 | 25928.0 |
| 2013-06-12 09:05:00 | AAPL | Stock | 15.7296 | 15.7375 | 15.7111 | 15.7321 | 346304.0 |
| 2013-06-12 09:10:00 | AAPL | Stock | 15.7321 | 15.7371 | 15.7286 | 15.7314 | 126280.0 |
| 2013-06-12 09:15:00 | AAPL | Stock | 15.7232 | 15.7329 | 15.7232 | 15.7329 | 56000.0 |
| 2013-06-12 09:20:00 | AAPL | Stock | 15.7286 | 15.7368 | 15.7218 | 15.7286 | 178304.0 |
| 2013-06-12 09:25:00 | AAPL | Stock | 15.7229 | 15.7229 | 15.6911 | 15.6971 | 225120.0 |
| 2013-06-12 09:30:00 | AAPL | Stock | 15.6968 | 15.7343 | 15.6582 | 15.6664 | 10167528.0 |
| 2013-06-12 09:35:00 | AAPL | Stock | 15.6664 | 15.7479 | 15.6664 | 15.7257 | 7170408.0 |
| 2013-06-12 09:40:00 | AAPL | Stock | 15.7216 | 15.7589 | 15.7096 | 15.7287 | 7126224.0 |
| 2013-06-12 09:45:00 | AAPL | Stock | 15.7271 | 15.7331 | 15.6543 | 15.6543 | 6131384.0 |
| 2013-06-12 09:50:00 | AAPL | Stock | 15.6573 | 15.69 | 15.6468 | 15.6668 | 4443320.0 |
| 2013-06-12 09:55:00 | AAPL | Stock | 15.6679 | 15.685 | 15.6361 | 15.6479 | 5107088.0 |
| 2013-06-12 10:00:00 | AAPL | Stock | 15.6479 | 15.6511 | 15.5832 | 15.5918 | 7370720.0 |
| 2013-06-12 10:05:00 | AAPL | Stock | 15.5925 | 15.5964 | 15.5229 | 15.5639 | 9489116.0 |
| 2013-06-12 10:10:00 | AAPL | Stock | 15.5639 | 15.5889 | 15.5511 | 15.5854 | 5735912.0 |
| 2013-06-12 10:15:00 | AAPL | Stock | 15.5854 | 15.5896 | 15.5511 | 15.5682 | 5401620.0 |
| 2013-06-12 10:20:00 | AAPL | Stock | 15.5679 | 15.5932 | 15.5632 | 15.5821 | 4559240.0 |
| 2013-06-12 10:25:00 | AAPL | Stock | 15.5793 | 15.61 | 15.5768 | 15.6015 | 5597452.0 |
| 2013-06-12 10:30:00 | AAPL | Stock | 15.6014 | 15.6071 | 15.5904 | 15.595 | 2992108.0 |
| 2013-06-12 10:35:00 | AAPL | Stock | 15.5984 | 15.6036 | 15.5764 | 15.5823 | 2626428.0 |
> showing 50 of 342,990 rows — these rows as CSV