PREVIEW / stock_30min / 2016-02-26
file: by_date/stock_30min/2016/2016-02-26.parquet size: 1.6 MB rows: 81,192 symbols: 3,342
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-26 04:00:00 | AAPL | Stock | 24.2125 | 24.25 | 24.2125 | 24.25 | 9200.0 |
| 2016-02-26 04:30:00 | AAPL | Stock | 24.3725 | 24.375 | 24.3725 | 24.375 | 7200.0 |
| 2016-02-26 05:00:00 | AAPL | Stock | 24.375 | 24.4025 | 24.375 | 24.4 | 2800.0 |
| 2016-02-26 05:30:00 | AAPL | Stock | 24.4 | 24.4 | 24.3875 | 24.3875 | 5200.0 |
| 2016-02-26 06:00:00 | AAPL | Stock | 24.3625 | 24.3625 | 24.35 | 24.35 | 1200.0 |
| 2016-02-26 06:30:00 | AAPL | Stock | 24.3425 | 24.3425 | 24.3 | 24.3 | 12200.0 |
| 2016-02-26 07:00:00 | AAPL | Stock | 24.3025 | 24.3025 | 24.255 | 24.2825 | 28400.0 |
| 2016-02-26 07:30:00 | AAPL | Stock | 24.285 | 24.285 | 24.2475 | 24.25 | 16740.0 |
| 2016-02-26 08:00:00 | AAPL | Stock | 24.2475 | 24.2975 | 24.24 | 24.27 | 93960.0 |
| 2016-02-26 08:30:00 | AAPL | Stock | 24.285 | 24.335 | 24.265 | 24.29 | 185840.0 |
| 2016-02-26 09:00:00 | AAPL | Stock | 24.2925 | 24.325 | 24.2825 | 24.295 | 257068.0 |
| 2016-02-26 09:30:00 | AAPL | Stock | 24.3 | 24.4175 | 24.2875 | 24.375 | 16799900.0 |
| 2016-02-26 10:00:00 | AAPL | Stock | 24.375 | 24.3762 | 24.27 | 24.3025 | 9644324.0 |
| 2016-02-26 10:30:00 | AAPL | Stock | 24.3 | 24.4325 | 24.2975 | 24.4175 | 8113340.0 |
| 2016-02-26 11:00:00 | AAPL | Stock | 24.4185 | 24.506 | 24.375 | 24.375 | 10802976.0 |
| 2016-02-26 11:30:00 | AAPL | Stock | 24.375 | 24.3825 | 24.33 | 24.3475 | 6768932.0 |
| 2016-02-26 12:00:00 | AAPL | Stock | 24.345 | 24.3475 | 24.2375 | 24.3 | 7089840.0 |
| 2016-02-26 12:30:00 | AAPL | Stock | 24.3025 | 24.3275 | 24.2375 | 24.275 | 4301300.0 |
| 2016-02-26 13:00:00 | AAPL | Stock | 24.275 | 24.33 | 24.22 | 24.22 | 4233404.0 |
| 2016-02-26 13:30:00 | AAPL | Stock | 24.22 | 24.27 | 24.1525 | 24.221 | 6778056.0 |
| 2016-02-26 14:00:00 | AAPL | Stock | 24.2225 | 24.2575 | 24.2092 | 24.25 | 4074836.0 |
| 2016-02-26 14:30:00 | AAPL | Stock | 24.2475 | 24.2525 | 24.145 | 24.18 | 5183800.0 |
| 2016-02-26 15:00:00 | AAPL | Stock | 24.18 | 24.275 | 24.1725 | 24.2362 | 6073296.0 |
| 2016-02-26 15:30:00 | AAPL | Stock | 24.235 | 24.275 | 24.215 | 24.2275 | 10691644.0 |
| 2016-02-26 16:00:00 | AAPL | Stock | 24.2275 | 24.3657 | 24.225 | 24.23 | 5750032.0 |
| 2016-02-26 16:30:00 | AAPL | Stock | 24.23 | 24.2375 | 24.2275 | 24.2275 | 69936.0 |
| 2016-02-26 17:00:00 | AAPL | Stock | 24.2275 | 24.2275 | 24.2225 | 24.2225 | 12676.0 |
| 2016-02-26 17:30:00 | AAPL | Stock | 24.2075 | 24.21 | 24.2075 | 24.2075 | 11672.0 |
| 2016-02-26 18:00:00 | AAPL | Stock | 24.2225 | 24.2225 | 24.21 | 24.2225 | 10900.0 |
| 2016-02-26 18:30:00 | AAPL | Stock | 24.2125 | 24.235 | 24.2125 | 24.235 | 54664.0 |
| 2016-02-26 19:00:00 | AAPL | Stock | 24.215 | 24.225 | 24.2125 | 24.225 | 23700.0 |
| 2016-02-26 19:30:00 | AAPL | Stock | 24.225 | 24.225 | 24.2125 | 24.2175 | 17652.0 |
| 2016-02-26 04:00:00 | MSFT | Stock | 52.25 | 52.5 | 52.25 | 52.5 | 1100.0 |
| 2016-02-26 04:30:00 | MSFT | Stock | 52.5 | 52.59 | 52.5 | 52.59 | 2600.0 |
| 2016-02-26 06:00:00 | MSFT | Stock | 52.32 | 52.34 | 52.32 | 52.34 | 1900.0 |
| 2016-02-26 06:30:00 | MSFT | Stock | 52.44 | 52.47 | 52.44 | 52.46 | 5320.0 |
| 2016-02-26 07:00:00 | MSFT | Stock | 52.48 | 52.48 | 52.48 | 52.48 | 2000.0 |
| 2016-02-26 07:30:00 | MSFT | Stock | 52.32 | 52.32 | 52.31 | 52.31 | 4230.0 |
| 2016-02-26 08:00:00 | MSFT | Stock | 52.31 | 52.35 | 52.27 | 52.35 | 9056.0 |
| 2016-02-26 08:30:00 | MSFT | Stock | 52.4 | 52.45 | 52.35 | 52.38 | 14814.0 |
| 2016-02-26 09:00:00 | MSFT | Stock | 52.38 | 52.6 | 52.36 | 52.6 | 40776.0 |
| 2016-02-26 09:30:00 | MSFT | Stock | 52.45 | 52.68 | 52.0 | 52.05 | 3301163.0 |
| 2016-02-26 10:00:00 | MSFT | Stock | 52.05 | 52.055 | 51.7 | 51.81 | 3315665.0 |
| 2016-02-26 10:30:00 | MSFT | Stock | 51.805 | 51.83 | 51.64 | 51.66 | 2158579.0 |
| 2016-02-26 11:00:00 | MSFT | Stock | 51.67 | 51.67 | 51.17 | 51.18 | 1995144.0 |
| 2016-02-26 11:30:00 | MSFT | Stock | 51.18 | 51.39 | 51.13 | 51.3 | 2638550.0 |
| 2016-02-26 12:00:00 | MSFT | Stock | 51.31 | 51.36 | 51.1 | 51.34 | 1864347.0 |
| 2016-02-26 12:30:00 | MSFT | Stock | 51.345 | 51.36 | 51.11 | 51.22 | 1129864.0 |
| 2016-02-26 13:00:00 | MSFT | Stock | 51.22 | 51.31 | 51.13 | 51.14 | 1103686.0 |
| 2016-02-26 13:30:00 | MSFT | Stock | 51.135 | 51.32 | 51.12 | 51.265 | 2254109.0 |
> showing 50 of 81,192 rows — these rows as CSV