PREVIEW / stock_30min / 2015-03-03
file: by_date/stock_30min/2015/2015-03-03.parquet size: 1.6 MB rows: 82,853 symbols: 3,517
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-03-03 04:00:00 | AAPL | Stock | 32.225 | 32.275 | 32.225 | 32.275 | 1000.0 |
| 2015-03-03 05:00:00 | AAPL | Stock | 32.2725 | 32.275 | 32.25 | 32.2725 | 10920.0 |
| 2015-03-03 05:30:00 | AAPL | Stock | 32.2525 | 32.295 | 32.25 | 32.295 | 12752.0 |
| 2015-03-03 06:00:00 | AAPL | Stock | 32.295 | 32.325 | 32.275 | 32.325 | 13236.0 |
| 2015-03-03 06:30:00 | AAPL | Stock | 32.325 | 32.325 | 32.3125 | 32.3125 | 8152.0 |
| 2015-03-03 07:00:00 | AAPL | Stock | 32.3025 | 32.3325 | 32.3025 | 32.3325 | 33840.0 |
| 2015-03-03 07:30:00 | AAPL | Stock | 32.3325 | 32.3375 | 32.2925 | 32.3 | 49856.0 |
| 2015-03-03 08:00:00 | AAPL | Stock | 32.2975 | 32.3325 | 32.195 | 32.2025 | 332704.0 |
| 2015-03-03 08:30:00 | AAPL | Stock | 32.205 | 32.2375 | 32.1625 | 32.2275 | 197264.0 |
| 2015-03-03 09:00:00 | AAPL | Stock | 32.225 | 32.285 | 32.195 | 32.24 | 396296.0 |
| 2015-03-03 09:30:00 | AAPL | Stock | 32.2425 | 32.3675 | 32.1 | 32.235 | 23946360.0 |
| 2015-03-03 10:00:00 | AAPL | Stock | 32.2362 | 32.365 | 32.16 | 32.2075 | 14983016.0 |
| 2015-03-03 10:30:00 | AAPL | Stock | 32.2075 | 32.2575 | 32.0825 | 32.125 | 12209240.0 |
| 2015-03-03 11:00:00 | AAPL | Stock | 32.125 | 32.1925 | 32.089 | 32.15 | 8622820.0 |
| 2015-03-03 11:30:00 | AAPL | Stock | 32.1525 | 32.18 | 32.0525 | 32.1562 | 10817972.0 |
| 2015-03-03 12:00:00 | AAPL | Stock | 32.1572 | 32.1625 | 32.0225 | 32.0725 | 8053968.0 |
| 2015-03-03 12:30:00 | AAPL | Stock | 32.075 | 32.2122 | 32.0685 | 32.2068 | 6180272.0 |
| 2015-03-03 13:00:00 | AAPL | Stock | 32.205 | 32.245 | 32.1875 | 32.2112 | 5949012.0 |
| 2015-03-03 13:30:00 | AAPL | Stock | 32.21 | 32.25 | 32.195 | 32.22 | 4611788.0 |
| 2015-03-03 14:00:00 | AAPL | Stock | 32.22 | 32.38 | 32.175 | 32.37 | 11166112.0 |
| 2015-03-03 14:30:00 | AAPL | Stock | 32.3675 | 32.375 | 32.2525 | 32.26 | 6525444.0 |
| 2015-03-03 15:00:00 | AAPL | Stock | 32.2612 | 32.3425 | 32.2212 | 32.3225 | 7655668.0 |
| 2015-03-03 15:30:00 | AAPL | Stock | 32.325 | 32.3525 | 32.2875 | 32.345 | 10654116.0 |
| 2015-03-03 16:00:00 | AAPL | Stock | 32.3375 | 32.372 | 32.2262 | 32.34 | 6728324.0 |
| 2015-03-03 16:30:00 | AAPL | Stock | 32.34 | 32.34 | 32.3225 | 32.3225 | 519012.0 |
| 2015-03-03 17:00:00 | AAPL | Stock | 32.3275 | 32.34 | 32.3125 | 32.32 | 39808.0 |
| 2015-03-03 17:30:00 | AAPL | Stock | 32.315 | 32.3225 | 32.275 | 32.3075 | 50708.0 |
| 2015-03-03 18:00:00 | AAPL | Stock | 32.315 | 32.3225 | 32.3075 | 32.3225 | 22380.0 |
| 2015-03-03 18:30:00 | AAPL | Stock | 32.3175 | 32.325 | 32.3125 | 32.325 | 34592.0 |
| 2015-03-03 19:00:00 | AAPL | Stock | 32.3275 | 32.3275 | 32.315 | 32.315 | 22192.0 |
| 2015-03-03 19:30:00 | AAPL | Stock | 32.325 | 32.325 | 32.2575 | 32.2725 | 101552.0 |
| 2015-03-03 07:00:00 | MSFT | Stock | 43.84 | 43.84 | 43.84 | 43.84 | 100.0 |
| 2015-03-03 07:30:00 | MSFT | Stock | 43.76 | 43.84 | 43.76 | 43.76 | 1600.0 |
| 2015-03-03 08:00:00 | MSFT | Stock | 43.76 | 43.76 | 43.76 | 43.76 | 738.0 |
| 2015-03-03 08:30:00 | MSFT | Stock | 43.76 | 43.8 | 43.67 | 43.68 | 7512.0 |
| 2015-03-03 09:00:00 | MSFT | Stock | 43.63 | 43.88 | 43.4 | 43.56 | 105838.0 |
| 2015-03-03 09:30:00 | MSFT | Stock | 43.56 | 43.825 | 43.55 | 43.61 | 3197412.0 |
| 2015-03-03 10:00:00 | MSFT | Stock | 43.61 | 43.63 | 43.33 | 43.4 | 2457845.0 |
| 2015-03-03 10:30:00 | MSFT | Stock | 43.41 | 43.41 | 43.175 | 43.18 | 2706944.0 |
| 2015-03-03 11:00:00 | MSFT | Stock | 43.185 | 43.289 | 43.11 | 43.18 | 1957215.0 |
| 2015-03-03 11:30:00 | MSFT | Stock | 43.17 | 43.26 | 43.12 | 43.205 | 2195425.0 |
| 2015-03-03 12:00:00 | MSFT | Stock | 43.21 | 43.27 | 43.09 | 43.107 | 1245296.0 |
| 2015-03-03 12:30:00 | MSFT | Stock | 43.105 | 43.4 | 43.105 | 43.299 | 1615119.0 |
| 2015-03-03 13:00:00 | MSFT | Stock | 43.3 | 43.35 | 43.185 | 43.221 | 1542154.0 |
| 2015-03-03 13:30:00 | MSFT | Stock | 43.23 | 43.3 | 43.21 | 43.25 | 915737.0 |
| 2015-03-03 14:00:00 | MSFT | Stock | 43.26 | 43.34 | 43.24 | 43.32 | 1442231.0 |
| 2015-03-03 14:30:00 | MSFT | Stock | 43.314 | 43.34 | 43.22 | 43.29 | 1506769.0 |
| 2015-03-03 15:00:00 | MSFT | Stock | 43.295 | 43.31 | 43.2 | 43.307 | 2130842.0 |
| 2015-03-03 15:30:00 | MSFT | Stock | 43.306 | 43.33 | 43.27 | 43.27 | 4837573.0 |
| 2015-03-03 16:00:00 | MSFT | Stock | 43.28 | 43.347 | 43.2 | 43.28 | 2357122.0 |
> showing 50 of 82,853 rows — these rows as CSV