PREVIEW / stock_5min / 2015-05-05
file: by_date/stock_5min/2015/2015-05-05.parquet size: 5.6 MB rows: 369,556 symbols: 3,523
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-05-05 04:00:00 | AAPL | Stock | 32.2 | 32.2 | 32.2 | 32.2 | 4000.0 |
| 2015-05-05 04:05:00 | AAPL | Stock | 32.2 | 32.2 | 32.1925 | 32.1925 | 13740.0 |
| 2015-05-05 04:15:00 | AAPL | Stock | 32.2025 | 32.2175 | 32.2025 | 32.2175 | 1744.0 |
| 2015-05-05 04:20:00 | AAPL | Stock | 32.275 | 32.275 | 32.275 | 32.275 | 2000.0 |
| 2015-05-05 04:25:00 | AAPL | Stock | 32.245 | 32.245 | 32.215 | 32.215 | 5300.0 |
| 2015-05-05 04:50:00 | AAPL | Stock | 32.225 | 32.225 | 32.2225 | 32.2225 | 1200.0 |
| 2015-05-05 05:00:00 | AAPL | Stock | 32.225 | 32.225 | 32.225 | 32.225 | 1200.0 |
| 2015-05-05 05:10:00 | AAPL | Stock | 32.215 | 32.215 | 32.215 | 32.215 | 3736.0 |
| 2015-05-05 05:25:00 | AAPL | Stock | 32.265 | 32.265 | 32.265 | 32.265 | 400.0 |
| 2015-05-05 06:10:00 | AAPL | Stock | 32.2375 | 32.245 | 32.2375 | 32.245 | 800.0 |
| 2015-05-05 06:20:00 | AAPL | Stock | 32.24 | 32.24 | 32.24 | 32.24 | 4072.0 |
| 2015-05-05 06:30:00 | AAPL | Stock | 32.215 | 32.215 | 32.215 | 32.215 | 1652.0 |
| 2015-05-05 06:35:00 | AAPL | Stock | 32.215 | 32.215 | 32.2025 | 32.2025 | 9652.0 |
| 2015-05-05 06:40:00 | AAPL | Stock | 32.195 | 32.195 | 32.1925 | 32.1925 | 3200.0 |
| 2015-05-05 06:45:00 | AAPL | Stock | 32.1975 | 32.1975 | 32.1925 | 32.1925 | 4200.0 |
| 2015-05-05 06:50:00 | AAPL | Stock | 32.1925 | 32.1925 | 32.1925 | 32.1925 | 400.0 |
| 2015-05-05 06:55:00 | AAPL | Stock | 32.1925 | 32.1925 | 32.1925 | 32.1925 | 400.0 |
| 2015-05-05 07:00:00 | AAPL | Stock | 32.1925 | 32.1925 | 32.1925 | 32.1925 | 2000.0 |
| 2015-05-05 07:05:00 | AAPL | Stock | 32.1775 | 32.1825 | 32.1575 | 32.1825 | 12344.0 |
| 2015-05-05 07:10:00 | AAPL | Stock | 32.1825 | 32.1825 | 32.17 | 32.17 | 1656.0 |
| 2015-05-05 07:15:00 | AAPL | Stock | 32.1625 | 32.1625 | 32.1325 | 32.1325 | 2956.0 |
| 2015-05-05 07:20:00 | AAPL | Stock | 32.1325 | 32.1375 | 32.125 | 32.125 | 14016.0 |
| 2015-05-05 07:25:00 | AAPL | Stock | 32.12 | 32.1225 | 32.12 | 32.1225 | 16272.0 |
| 2015-05-05 07:30:00 | AAPL | Stock | 32.1225 | 32.1225 | 32.11 | 32.11 | 13200.0 |
| 2015-05-05 07:35:00 | AAPL | Stock | 32.1125 | 32.1225 | 32.1 | 32.1125 | 10000.0 |
| 2015-05-05 07:40:00 | AAPL | Stock | 32.1 | 32.1 | 32.05 | 32.05 | 33780.0 |
| 2015-05-05 07:45:00 | AAPL | Stock | 32.075 | 32.1225 | 32.075 | 32.1225 | 51880.0 |
| 2015-05-05 07:50:00 | AAPL | Stock | 32.0675 | 32.0975 | 32.0675 | 32.0825 | 37840.0 |
| 2015-05-05 07:55:00 | AAPL | Stock | 32.075 | 32.0825 | 32.055 | 32.0675 | 29244.0 |
| 2015-05-05 08:00:00 | AAPL | Stock | 32.08 | 32.2325 | 32.0575 | 32.0875 | 143196.0 |
| 2015-05-05 08:05:00 | AAPL | Stock | 32.0875 | 32.095 | 32.0675 | 32.0675 | 59352.0 |
| 2015-05-05 08:10:00 | AAPL | Stock | 32.0725 | 32.08 | 32.0525 | 32.06 | 127068.0 |
| 2015-05-05 08:15:00 | AAPL | Stock | 32.0625 | 32.075 | 32.0625 | 32.0725 | 38960.0 |
| 2015-05-05 08:20:00 | AAPL | Stock | 32.0725 | 32.08 | 32.0575 | 32.08 | 78040.0 |
| 2015-05-05 08:25:00 | AAPL | Stock | 32.075 | 32.0875 | 32.06 | 32.0875 | 35768.0 |
| 2015-05-05 08:30:00 | AAPL | Stock | 32.09 | 32.1 | 32.0525 | 32.0625 | 44376.0 |
| 2015-05-05 08:35:00 | AAPL | Stock | 32.0675 | 32.1025 | 32.0625 | 32.0625 | 84832.0 |
| 2015-05-05 08:40:00 | AAPL | Stock | 32.075 | 32.0925 | 32.0725 | 32.0925 | 18780.0 |
| 2015-05-05 08:45:00 | AAPL | Stock | 32.1 | 32.1175 | 32.0875 | 32.095 | 19788.0 |
| 2015-05-05 08:50:00 | AAPL | Stock | 32.0875 | 32.0875 | 32.05 | 32.0625 | 30388.0 |
| 2015-05-05 08:55:00 | AAPL | Stock | 32.06 | 32.0625 | 32.05 | 32.0625 | 50296.0 |
| 2015-05-05 09:00:00 | AAPL | Stock | 32.0675 | 32.0675 | 32.0375 | 32.045 | 78812.0 |
| 2015-05-05 09:05:00 | AAPL | Stock | 32.04 | 32.04 | 32.0175 | 32.0375 | 82820.0 |
| 2015-05-05 09:10:00 | AAPL | Stock | 32.0375 | 32.0775 | 32.0375 | 32.0628 | 46144.0 |
| 2015-05-05 09:15:00 | AAPL | Stock | 32.0625 | 32.095 | 32.06 | 32.075 | 43112.0 |
| 2015-05-05 09:20:00 | AAPL | Stock | 32.0925 | 32.095 | 32.0725 | 32.085 | 33144.0 |
| 2015-05-05 09:25:00 | AAPL | Stock | 32.075 | 32.0875 | 32.03 | 32.0375 | 115544.0 |
| 2015-05-05 09:30:00 | AAPL | Stock | 32.0375 | 32.1125 | 31.9525 | 32.0 | 6403308.0 |
| 2015-05-05 09:35:00 | AAPL | Stock | 32.005 | 32.0575 | 31.925 | 31.9275 | 3980300.0 |
| 2015-05-05 09:40:00 | AAPL | Stock | 31.935 | 32.01 | 31.925 | 31.9555 | 4013360.0 |
> showing 50 of 369,556 rows — these rows as CSV