PREVIEW / stock_5min / 2015-01-12
file: by_date/stock_5min/2015/2015-01-12.parquet size: 5.5 MB rows: 366,227 symbols: 3,545
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-12 04:45:00 | AAPL | Stock | 28.1 | 28.1125 | 28.1 | 28.1125 | 4728.0 |
| 2015-01-12 04:55:00 | AAPL | Stock | 28.15 | 28.3 | 28.15 | 28.3 | 5760.0 |
| 2015-01-12 05:00:00 | AAPL | Stock | 28.15 | 28.15 | 28.15 | 28.15 | 2000.0 |
| 2015-01-12 05:05:00 | AAPL | Stock | 28.15 | 28.15 | 28.15 | 28.15 | 400.0 |
| 2015-01-12 05:10:00 | AAPL | Stock | 28.1375 | 28.1375 | 28.1375 | 28.1375 | 4800.0 |
| 2015-01-12 05:20:00 | AAPL | Stock | 28.1475 | 28.1475 | 28.1475 | 28.1475 | 1000.0 |
| 2015-01-12 05:25:00 | AAPL | Stock | 28.1375 | 28.1375 | 28.1375 | 28.1375 | 800.0 |
| 2015-01-12 05:35:00 | AAPL | Stock | 28.175 | 28.175 | 28.175 | 28.175 | 800.0 |
| 2015-01-12 05:45:00 | AAPL | Stock | 28.175 | 28.175 | 28.175 | 28.175 | 2800.0 |
| 2015-01-12 05:50:00 | AAPL | Stock | 28.175 | 28.175 | 28.175 | 28.175 | 3600.0 |
| 2015-01-12 05:55:00 | AAPL | Stock | 28.1625 | 28.1625 | 28.1625 | 28.1625 | 1000.0 |
| 2015-01-12 06:00:00 | AAPL | Stock | 28.1625 | 28.1625 | 28.1625 | 28.1625 | 2736.0 |
| 2015-01-12 06:05:00 | AAPL | Stock | 28.1625 | 28.1625 | 28.1625 | 28.1625 | 2000.0 |
| 2015-01-12 06:10:00 | AAPL | Stock | 28.1625 | 28.1625 | 28.1625 | 28.1625 | 400.0 |
| 2015-01-12 06:15:00 | AAPL | Stock | 28.175 | 28.175 | 28.175 | 28.175 | 1488.0 |
| 2015-01-12 06:20:00 | AAPL | Stock | 28.175 | 28.18 | 28.175 | 28.18 | 2144.0 |
| 2015-01-12 06:25:00 | AAPL | Stock | 28.175 | 28.175 | 28.1625 | 28.1625 | 9840.0 |
| 2015-01-12 06:30:00 | AAPL | Stock | 28.15 | 28.1525 | 28.15 | 28.15 | 1200.0 |
| 2015-01-12 06:40:00 | AAPL | Stock | 28.15 | 28.15 | 28.15 | 28.15 | 2980.0 |
| 2015-01-12 06:45:00 | AAPL | Stock | 28.1425 | 28.15 | 28.14 | 28.15 | 5836.0 |
| 2015-01-12 06:50:00 | AAPL | Stock | 28.1475 | 28.1475 | 28.1375 | 28.1375 | 18000.0 |
| 2015-01-12 06:55:00 | AAPL | Stock | 28.1325 | 28.1325 | 28.1325 | 28.1325 | 400.0 |
| 2015-01-12 07:00:00 | AAPL | Stock | 28.1525 | 28.16 | 28.1475 | 28.1525 | 6000.0 |
| 2015-01-12 07:05:00 | AAPL | Stock | 28.155 | 28.155 | 28.145 | 28.1475 | 10000.0 |
| 2015-01-12 07:10:00 | AAPL | Stock | 28.1475 | 28.175 | 28.1475 | 28.1675 | 17312.0 |
| 2015-01-12 07:15:00 | AAPL | Stock | 28.1725 | 28.1725 | 28.1625 | 28.1625 | 7500.0 |
| 2015-01-12 07:20:00 | AAPL | Stock | 28.17 | 28.175 | 28.17 | 28.175 | 20500.0 |
| 2015-01-12 07:25:00 | AAPL | Stock | 28.1525 | 28.1525 | 28.1375 | 28.1375 | 6400.0 |
| 2015-01-12 07:30:00 | AAPL | Stock | 28.1525 | 28.16 | 28.1525 | 28.1575 | 14312.0 |
| 2015-01-12 07:35:00 | AAPL | Stock | 28.1425 | 28.155 | 28.1425 | 28.155 | 6800.0 |
| 2015-01-12 07:40:00 | AAPL | Stock | 28.15 | 28.15 | 28.145 | 28.145 | 4480.0 |
| 2015-01-12 07:45:00 | AAPL | Stock | 28.145 | 28.16 | 28.145 | 28.15 | 11640.0 |
| 2015-01-12 07:50:00 | AAPL | Stock | 28.15 | 28.15 | 28.125 | 28.125 | 17720.0 |
| 2015-01-12 07:55:00 | AAPL | Stock | 28.1225 | 28.1275 | 28.1225 | 28.1275 | 6908.0 |
| 2015-01-12 08:00:00 | AAPL | Stock | 28.1325 | 28.175 | 28.115 | 28.1175 | 182180.0 |
| 2015-01-12 08:05:00 | AAPL | Stock | 28.115 | 28.15 | 28.115 | 28.1425 | 107400.0 |
| 2015-01-12 08:10:00 | AAPL | Stock | 28.145 | 28.1575 | 28.1375 | 28.14 | 35668.0 |
| 2015-01-12 08:15:00 | AAPL | Stock | 28.1375 | 28.14 | 28.1025 | 28.1025 | 139868.0 |
| 2015-01-12 08:20:00 | AAPL | Stock | 28.1075 | 28.1125 | 28.0875 | 28.0925 | 82908.0 |
| 2015-01-12 08:25:00 | AAPL | Stock | 28.105 | 28.1125 | 28.05 | 28.0525 | 97980.0 |
| 2015-01-12 08:30:00 | AAPL | Stock | 28.0525 | 28.0625 | 28.0075 | 28.01 | 90548.0 |
| 2015-01-12 08:35:00 | AAPL | Stock | 28.0175 | 28.05 | 28.0025 | 28.04 | 77220.0 |
| 2015-01-12 08:40:00 | AAPL | Stock | 28.0375 | 28.0475 | 28.025 | 28.025 | 73136.0 |
| 2015-01-12 08:45:00 | AAPL | Stock | 28.025 | 28.0375 | 28.025 | 28.0375 | 10956.0 |
| 2015-01-12 08:50:00 | AAPL | Stock | 28.0375 | 28.05 | 28.03 | 28.03 | 46344.0 |
| 2015-01-12 08:55:00 | AAPL | Stock | 28.03 | 28.0425 | 28.03 | 28.0325 | 45388.0 |
| 2015-01-12 09:00:00 | AAPL | Stock | 28.0375 | 28.08 | 28.035 | 28.08 | 36608.0 |
| 2015-01-12 09:05:00 | AAPL | Stock | 28.07 | 28.08 | 28.0675 | 28.08 | 10460.0 |
| 2015-01-12 09:10:00 | AAPL | Stock | 28.085 | 28.085 | 28.065 | 28.07 | 15068.0 |
| 2015-01-12 09:15:00 | AAPL | Stock | 28.065 | 28.09 | 28.065 | 28.0875 | 29256.0 |
> showing 50 of 366,227 rows — these rows as CSV