PREVIEW / stock_5min / 2015-07-08
file: by_date/stock_5min/2015/2015-07-08.parquet size: 5.5 MB rows: 366,818 symbols: 3,489
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-07-08 04:00:00 | AAPL | Stock | 31.1175 | 31.1175 | 31.0025 | 31.0025 | 8504.0 |
| 2015-07-08 04:05:00 | AAPL | Stock | 31.12 | 31.125 | 31.12 | 31.125 | 5600.0 |
| 2015-07-08 04:10:00 | AAPL | Stock | 31.125 | 31.15 | 31.125 | 31.1375 | 2800.0 |
| 2015-07-08 04:15:00 | AAPL | Stock | 31.1525 | 31.1525 | 31.15 | 31.15 | 21200.0 |
| 2015-07-08 04:20:00 | AAPL | Stock | 31.1 | 31.1 | 31.1 | 31.1 | 800.0 |
| 2015-07-08 04:25:00 | AAPL | Stock | 31.05 | 31.05 | 31.045 | 31.045 | 12760.0 |
| 2015-07-08 04:30:00 | AAPL | Stock | 31.0775 | 31.0775 | 31.0775 | 31.0775 | 400.0 |
| 2015-07-08 04:35:00 | AAPL | Stock | 31.045 | 31.045 | 31.025 | 31.045 | 14040.0 |
| 2015-07-08 04:40:00 | AAPL | Stock | 31.0125 | 31.0125 | 31.0 | 31.0 | 16400.0 |
| 2015-07-08 04:45:00 | AAPL | Stock | 31.0 | 31.045 | 31.0 | 31.045 | 25160.0 |
| 2015-07-08 04:55:00 | AAPL | Stock | 31.075 | 31.075 | 31.0525 | 31.0525 | 1600.0 |
| 2015-07-08 05:00:00 | AAPL | Stock | 31.075 | 31.075 | 31.075 | 31.075 | 8800.0 |
| 2015-07-08 05:10:00 | AAPL | Stock | 31.0975 | 31.0975 | 31.0975 | 31.0975 | 2000.0 |
| 2015-07-08 05:15:00 | AAPL | Stock | 31.0925 | 31.0925 | 31.08 | 31.08 | 1588.0 |
| 2015-07-08 05:25:00 | AAPL | Stock | 31.08 | 31.08 | 31.075 | 31.075 | 9964.0 |
| 2015-07-08 05:40:00 | AAPL | Stock | 31.075 | 31.075 | 31.0525 | 31.0525 | 5200.0 |
| 2015-07-08 05:45:00 | AAPL | Stock | 31.0625 | 31.0625 | 31.0625 | 31.0625 | 1600.0 |
| 2015-07-08 05:50:00 | AAPL | Stock | 31.1 | 31.1 | 31.1 | 31.1 | 2400.0 |
| 2015-07-08 05:55:00 | AAPL | Stock | 31.1 | 31.1 | 31.1 | 31.1 | 708.0 |
| 2015-07-08 06:05:00 | AAPL | Stock | 31.1225 | 31.125 | 31.1225 | 31.1225 | 2400.0 |
| 2015-07-08 06:10:00 | AAPL | Stock | 31.1225 | 31.15 | 31.0875 | 31.0875 | 27100.0 |
| 2015-07-08 06:15:00 | AAPL | Stock | 31.125 | 31.125 | 31.125 | 31.125 | 400.0 |
| 2015-07-08 06:25:00 | AAPL | Stock | 31.125 | 31.1725 | 31.125 | 31.1325 | 4000.0 |
| 2015-07-08 06:35:00 | AAPL | Stock | 31.14 | 31.14 | 31.14 | 31.14 | 400.0 |
| 2015-07-08 06:40:00 | AAPL | Stock | 31.15 | 31.1625 | 31.15 | 31.1625 | 2708.0 |
| 2015-07-08 06:45:00 | AAPL | Stock | 31.1625 | 31.1625 | 31.1625 | 31.1625 | 400.0 |
| 2015-07-08 06:50:00 | AAPL | Stock | 31.16 | 31.16 | 31.14 | 31.15 | 2000.0 |
| 2015-07-08 06:55:00 | AAPL | Stock | 31.155 | 31.175 | 31.155 | 31.175 | 3600.0 |
| 2015-07-08 07:00:00 | AAPL | Stock | 31.2125 | 31.23 | 31.2 | 31.2 | 14400.0 |
| 2015-07-08 07:05:00 | AAPL | Stock | 31.2225 | 31.27 | 31.21 | 31.2325 | 26540.0 |
| 2015-07-08 07:10:00 | AAPL | Stock | 31.2475 | 31.3 | 31.2375 | 31.2375 | 10800.0 |
| 2015-07-08 07:15:00 | AAPL | Stock | 31.255 | 31.255 | 31.24 | 31.24 | 19896.0 |
| 2015-07-08 07:25:00 | AAPL | Stock | 31.2425 | 31.2875 | 31.2425 | 31.2875 | 13200.0 |
| 2015-07-08 07:30:00 | AAPL | Stock | 31.25 | 31.2825 | 31.2275 | 31.2375 | 13852.0 |
| 2015-07-08 07:35:00 | AAPL | Stock | 31.2275 | 31.2275 | 31.2275 | 31.2275 | 400.0 |
| 2015-07-08 07:40:00 | AAPL | Stock | 31.2275 | 31.2275 | 31.2 | 31.205 | 6800.0 |
| 2015-07-08 07:45:00 | AAPL | Stock | 31.2025 | 31.2175 | 31.19 | 31.2125 | 9920.0 |
| 2015-07-08 07:50:00 | AAPL | Stock | 31.2175 | 31.2175 | 31.19 | 31.19 | 4000.0 |
| 2015-07-08 07:55:00 | AAPL | Stock | 31.215 | 31.22 | 31.205 | 31.205 | 23572.0 |
| 2015-07-08 08:00:00 | AAPL | Stock | 31.2025 | 31.3125 | 31.0875 | 31.2375 | 106568.0 |
| 2015-07-08 08:05:00 | AAPL | Stock | 31.235 | 31.26 | 31.2325 | 31.2475 | 19472.0 |
| 2015-07-08 08:10:00 | AAPL | Stock | 31.2325 | 31.2475 | 31.23 | 31.2375 | 17212.0 |
| 2015-07-08 08:15:00 | AAPL | Stock | 31.23 | 31.23 | 31.2125 | 31.23 | 49700.0 |
| 2015-07-08 08:20:00 | AAPL | Stock | 31.215 | 31.235 | 31.2125 | 31.2242 | 40028.0 |
| 2015-07-08 08:25:00 | AAPL | Stock | 31.22 | 31.2425 | 31.2125 | 31.22 | 34968.0 |
| 2015-07-08 08:30:00 | AAPL | Stock | 31.225 | 31.2325 | 31.2125 | 31.2125 | 34100.0 |
| 2015-07-08 08:35:00 | AAPL | Stock | 31.21 | 31.21 | 31.18 | 31.185 | 46332.0 |
| 2015-07-08 08:40:00 | AAPL | Stock | 31.185 | 31.21 | 31.1825 | 31.1825 | 27908.0 |
| 2015-07-08 08:45:00 | AAPL | Stock | 31.18 | 31.18 | 31.15 | 31.1625 | 111732.0 |
| 2015-07-08 08:50:00 | AAPL | Stock | 31.1625 | 31.1775 | 31.16 | 31.1775 | 60712.0 |
> showing 50 of 366,818 rows — these rows as CSV