PREVIEW / stock_5min / 2015-08-28
file: by_date/stock_5min/2015/2015-08-28.parquet size: 5.5 MB rows: 364,740 symbols: 3,468
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-08-28 04:00:00 | AAPL | Stock | 28.325 | 28.325 | 28.1 | 28.1125 | 11544.0 |
| 2015-08-28 04:10:00 | AAPL | Stock | 28.15 | 28.15 | 28.145 | 28.145 | 18400.0 |
| 2015-08-28 04:15:00 | AAPL | Stock | 28.155 | 28.155 | 28.15 | 28.15 | 10424.0 |
| 2015-08-28 04:20:00 | AAPL | Stock | 28.1525 | 28.1525 | 28.1525 | 28.1525 | 2000.0 |
| 2015-08-28 04:25:00 | AAPL | Stock | 28.145 | 28.1525 | 28.145 | 28.1525 | 13724.0 |
| 2015-08-28 04:30:00 | AAPL | Stock | 28.145 | 28.155 | 28.12 | 28.145 | 8924.0 |
| 2015-08-28 04:35:00 | AAPL | Stock | 28.1625 | 28.1675 | 28.1625 | 28.1675 | 1652.0 |
| 2015-08-28 04:40:00 | AAPL | Stock | 28.13 | 28.13 | 28.13 | 28.13 | 400.0 |
| 2015-08-28 04:45:00 | AAPL | Stock | 28.13 | 28.13 | 28.13 | 28.13 | 2800.0 |
| 2015-08-28 04:50:00 | AAPL | Stock | 28.13 | 28.13 | 28.1125 | 28.12 | 22200.0 |
| 2015-08-28 04:55:00 | AAPL | Stock | 28.12 | 28.12 | 28.12 | 28.12 | 1600.0 |
| 2015-08-28 05:00:00 | AAPL | Stock | 28.1325 | 28.1325 | 28.12 | 28.12 | 4800.0 |
| 2015-08-28 05:05:00 | AAPL | Stock | 28.12 | 28.1275 | 28.085 | 28.1275 | 12400.0 |
| 2015-08-28 05:10:00 | AAPL | Stock | 28.1325 | 28.1325 | 28.0575 | 28.0575 | 12572.0 |
| 2015-08-28 05:15:00 | AAPL | Stock | 28.07 | 28.07 | 28.0675 | 28.0675 | 2224.0 |
| 2015-08-28 05:20:00 | AAPL | Stock | 28.1125 | 28.1125 | 28.1125 | 28.1125 | 2400.0 |
| 2015-08-28 05:30:00 | AAPL | Stock | 28.125 | 28.1425 | 28.125 | 28.1425 | 3040.0 |
| 2015-08-28 05:40:00 | AAPL | Stock | 28.18 | 28.1825 | 28.175 | 28.175 | 1400.0 |
| 2015-08-28 05:45:00 | AAPL | Stock | 28.1625 | 28.1625 | 28.125 | 28.125 | 4000.0 |
| 2015-08-28 05:55:00 | AAPL | Stock | 28.17 | 28.1825 | 28.17 | 28.1825 | 4500.0 |
| 2015-08-28 06:00:00 | AAPL | Stock | 28.195 | 28.2475 | 28.195 | 28.2125 | 13504.0 |
| 2015-08-28 06:05:00 | AAPL | Stock | 28.225 | 28.2275 | 28.18 | 28.18 | 14996.0 |
| 2015-08-28 06:10:00 | AAPL | Stock | 28.1875 | 28.1875 | 28.1375 | 28.1875 | 8392.0 |
| 2015-08-28 06:15:00 | AAPL | Stock | 28.1825 | 28.1875 | 28.1375 | 28.1375 | 12028.0 |
| 2015-08-28 06:20:00 | AAPL | Stock | 28.15 | 28.15 | 28.1275 | 28.1275 | 7320.0 |
| 2015-08-28 06:25:00 | AAPL | Stock | 28.125 | 28.125 | 28.0825 | 28.085 | 3200.0 |
| 2015-08-28 06:30:00 | AAPL | Stock | 28.1 | 28.1 | 28.05 | 28.0875 | 9124.0 |
| 2015-08-28 06:35:00 | AAPL | Stock | 28.0875 | 28.1475 | 28.0875 | 28.0875 | 4040.0 |
| 2015-08-28 06:50:00 | AAPL | Stock | 28.1 | 28.1 | 28.075 | 28.075 | 10776.0 |
| 2015-08-28 06:55:00 | AAPL | Stock | 28.0625 | 28.0625 | 28.0425 | 28.0425 | 31412.0 |
| 2015-08-28 07:00:00 | AAPL | Stock | 28.0225 | 28.0225 | 28.0 | 28.0 | 18904.0 |
| 2015-08-28 07:05:00 | AAPL | Stock | 28.005 | 28.025 | 27.995 | 27.995 | 21972.0 |
| 2015-08-28 07:10:00 | AAPL | Stock | 27.9875 | 28.02 | 27.9875 | 28.02 | 4400.0 |
| 2015-08-28 07:15:00 | AAPL | Stock | 28.03 | 28.045 | 28.03 | 28.045 | 5020.0 |
| 2015-08-28 07:20:00 | AAPL | Stock | 28.045 | 28.05 | 28.045 | 28.0475 | 9844.0 |
| 2015-08-28 07:25:00 | AAPL | Stock | 28.0475 | 28.0575 | 28.0475 | 28.0575 | 9076.0 |
| 2015-08-28 07:30:00 | AAPL | Stock | 28.0575 | 28.0925 | 28.0575 | 28.06 | 14888.0 |
| 2015-08-28 07:35:00 | AAPL | Stock | 28.0575 | 28.1175 | 28.0375 | 28.0975 | 10040.0 |
| 2015-08-28 07:40:00 | AAPL | Stock | 28.09 | 28.09 | 28.0675 | 28.075 | 2520.0 |
| 2015-08-28 07:45:00 | AAPL | Stock | 28.0675 | 28.075 | 28.05 | 28.075 | 11208.0 |
| 2015-08-28 07:50:00 | AAPL | Stock | 28.075 | 28.075 | 28.075 | 28.075 | 400.0 |
| 2015-08-28 07:55:00 | AAPL | Stock | 28.06 | 28.075 | 28.06 | 28.065 | 4468.0 |
| 2015-08-28 08:00:00 | AAPL | Stock | 28.0675 | 28.1125 | 27.965 | 27.965 | 167724.0 |
| 2015-08-28 08:05:00 | AAPL | Stock | 27.975 | 28.015 | 27.975 | 27.985 | 38380.0 |
| 2015-08-28 08:10:00 | AAPL | Stock | 28.0 | 28.0025 | 27.985 | 27.9875 | 54172.0 |
| 2015-08-28 08:15:00 | AAPL | Stock | 27.9825 | 27.9925 | 27.965 | 27.9925 | 104532.0 |
| 2015-08-28 08:20:00 | AAPL | Stock | 27.995 | 28.0225 | 27.98 | 28.015 | 97152.0 |
| 2015-08-28 08:25:00 | AAPL | Stock | 28.02 | 28.0375 | 28.0125 | 28.0225 | 17956.0 |
| 2015-08-28 08:30:00 | AAPL | Stock | 28.025 | 28.0575 | 27.9875 | 28.0275 | 36320.0 |
| 2015-08-28 08:35:00 | AAPL | Stock | 28.0375 | 28.05 | 27.98 | 27.995 | 59708.0 |
> showing 50 of 364,740 rows — these rows as CSV