PREVIEW / stock_5min / 2014-09-23
file: by_date/stock_5min/2014/2014-09-23.parquet size: 5.5 MB rows: 367,097 symbols: 3,578
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 |
|---|---|---|---|---|---|---|---|
| 2014-09-23 04:00:00 | AAPL | Stock | 25.265 | 25.265 | 25.14 | 25.14 | 5360.0 |
| 2014-09-23 04:05:00 | AAPL | Stock | 25.1575 | 25.1575 | 25.1575 | 25.1575 | 400.0 |
| 2014-09-23 04:15:00 | AAPL | Stock | 25.185 | 25.185 | 25.185 | 25.185 | 1796.0 |
| 2014-09-23 04:20:00 | AAPL | Stock | 25.1775 | 25.185 | 25.1775 | 25.185 | 5040.0 |
| 2014-09-23 04:25:00 | AAPL | Stock | 25.1725 | 25.1725 | 25.1725 | 25.1725 | 2000.0 |
| 2014-09-23 04:45:00 | AAPL | Stock | 25.175 | 25.185 | 25.175 | 25.185 | 6296.0 |
| 2014-09-23 04:50:00 | AAPL | Stock | 25.185 | 25.185 | 25.185 | 25.185 | 6800.0 |
| 2014-09-23 05:00:00 | AAPL | Stock | 25.17 | 25.17 | 25.17 | 25.17 | 400.0 |
| 2014-09-23 05:05:00 | AAPL | Stock | 25.17 | 25.17 | 25.16 | 25.16 | 1600.0 |
| 2014-09-23 05:30:00 | AAPL | Stock | 25.1375 | 25.1475 | 25.1375 | 25.1475 | 3600.0 |
| 2014-09-23 05:35:00 | AAPL | Stock | 25.125 | 25.125 | 25.07 | 25.1 | 6800.0 |
| 2014-09-23 05:40:00 | AAPL | Stock | 25.1 | 25.1 | 25.1 | 25.1 | 800.0 |
| 2014-09-23 05:45:00 | AAPL | Stock | 25.0825 | 25.0825 | 25.07 | 25.07 | 4956.0 |
| 2014-09-23 05:50:00 | AAPL | Stock | 25.07 | 25.0875 | 25.07 | 25.0875 | 1520.0 |
| 2014-09-23 06:05:00 | AAPL | Stock | 25.1475 | 25.1475 | 25.1475 | 25.1475 | 800.0 |
| 2014-09-23 06:10:00 | AAPL | Stock | 25.1275 | 25.1275 | 25.1275 | 25.1275 | 1596.0 |
| 2014-09-23 06:20:00 | AAPL | Stock | 25.145 | 25.145 | 25.145 | 25.145 | 2400.0 |
| 2014-09-23 06:25:00 | AAPL | Stock | 25.1375 | 25.1375 | 25.125 | 25.125 | 4400.0 |
| 2014-09-23 06:30:00 | AAPL | Stock | 25.1225 | 25.1225 | 25.1025 | 25.1025 | 3400.0 |
| 2014-09-23 06:35:00 | AAPL | Stock | 25.105 | 25.105 | 25.105 | 25.105 | 400.0 |
| 2014-09-23 06:45:00 | AAPL | Stock | 25.1125 | 25.1125 | 25.1025 | 25.1025 | 4164.0 |
| 2014-09-23 06:50:00 | AAPL | Stock | 25.12 | 25.125 | 25.1125 | 25.1125 | 4800.0 |
| 2014-09-23 06:55:00 | AAPL | Stock | 25.1225 | 25.1475 | 25.1225 | 25.1475 | 9600.0 |
| 2014-09-23 07:00:00 | AAPL | Stock | 25.1625 | 25.1625 | 25.1425 | 25.15 | 3800.0 |
| 2014-09-23 07:05:00 | AAPL | Stock | 25.1625 | 25.1625 | 25.1625 | 25.1625 | 400.0 |
| 2014-09-23 07:10:00 | AAPL | Stock | 25.1625 | 25.165 | 25.15 | 25.1525 | 8800.0 |
| 2014-09-23 07:15:00 | AAPL | Stock | 25.14 | 25.14 | 25.135 | 25.135 | 4000.0 |
| 2014-09-23 07:20:00 | AAPL | Stock | 25.1375 | 25.1375 | 25.125 | 25.125 | 8120.0 |
| 2014-09-23 07:25:00 | AAPL | Stock | 25.12 | 25.16 | 25.105 | 25.16 | 20268.0 |
| 2014-09-23 07:30:00 | AAPL | Stock | 25.1275 | 25.1675 | 25.1275 | 25.1675 | 6692.0 |
| 2014-09-23 07:35:00 | AAPL | Stock | 25.1675 | 25.1675 | 25.1475 | 25.15 | 9092.0 |
| 2014-09-23 07:40:00 | AAPL | Stock | 25.15 | 25.15 | 25.1275 | 25.1275 | 18800.0 |
| 2014-09-23 07:45:00 | AAPL | Stock | 25.145 | 25.1675 | 25.145 | 25.1675 | 21800.0 |
| 2014-09-23 07:50:00 | AAPL | Stock | 25.15 | 25.15 | 25.14 | 25.14 | 8400.0 |
| 2014-09-23 07:55:00 | AAPL | Stock | 25.155 | 25.155 | 25.155 | 25.155 | 3000.0 |
| 2014-09-23 08:00:00 | AAPL | Stock | 25.1425 | 25.17 | 25.14 | 25.16 | 58136.0 |
| 2014-09-23 08:05:00 | AAPL | Stock | 25.16 | 25.185 | 25.16 | 25.175 | 55724.0 |
| 2014-09-23 08:10:00 | AAPL | Stock | 25.17 | 25.185 | 25.17 | 25.185 | 54852.0 |
| 2014-09-23 08:15:00 | AAPL | Stock | 25.185 | 25.1875 | 25.175 | 25.175 | 26800.0 |
| 2014-09-23 08:20:00 | AAPL | Stock | 25.175 | 25.185 | 25.17 | 25.17 | 30640.0 |
| 2014-09-23 08:25:00 | AAPL | Stock | 25.165 | 25.185 | 25.165 | 25.185 | 28140.0 |
| 2014-09-23 08:30:00 | AAPL | Stock | 25.185 | 25.185 | 25.165 | 25.175 | 7100.0 |
| 2014-09-23 08:35:00 | AAPL | Stock | 25.175 | 25.1875 | 25.1675 | 25.1875 | 19804.0 |
| 2014-09-23 08:40:00 | AAPL | Stock | 25.1925 | 25.1925 | 25.165 | 25.1675 | 38320.0 |
| 2014-09-23 08:45:00 | AAPL | Stock | 25.1775 | 25.1775 | 25.1725 | 25.175 | 5100.0 |
| 2014-09-23 08:50:00 | AAPL | Stock | 25.1725 | 25.19 | 25.1625 | 25.1625 | 70580.0 |
| 2014-09-23 08:55:00 | AAPL | Stock | 25.1625 | 25.1925 | 25.16 | 25.1925 | 91064.0 |
| 2014-09-23 09:00:00 | AAPL | Stock | 25.185 | 25.1875 | 25.175 | 25.1875 | 19988.0 |
| 2014-09-23 09:05:00 | AAPL | Stock | 25.19 | 25.195 | 25.18 | 25.1875 | 31404.0 |
| 2014-09-23 09:10:00 | AAPL | Stock | 25.19 | 25.19 | 25.1775 | 25.1775 | 15368.0 |
> showing 50 of 367,097 rows — these rows as CSV