PREVIEW / stock_30min / 2015-08-31
file: by_date/stock_30min/2015/2015-08-31.parquet size: 1.6 MB rows: 83,367 symbols: 3,479
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-31 04:00:00 | AAPL | Stock | 28.375 | 28.375 | 28.0125 | 28.0125 | 91412.0 |
| 2015-08-31 04:30:00 | AAPL | Stock | 28.025 | 28.04 | 27.975 | 27.99 | 42368.0 |
| 2015-08-31 05:00:00 | AAPL | Stock | 28.0 | 28.075 | 28.0 | 28.0625 | 60664.0 |
| 2015-08-31 05:30:00 | AAPL | Stock | 28.0625 | 28.075 | 28.0 | 28.05 | 42948.0 |
| 2015-08-31 06:00:00 | AAPL | Stock | 28.05 | 28.1275 | 28.0375 | 28.1125 | 42692.0 |
| 2015-08-31 06:30:00 | AAPL | Stock | 28.15 | 28.15 | 28.075 | 28.0775 | 34784.0 |
| 2015-08-31 07:00:00 | AAPL | Stock | 28.0875 | 28.125 | 28.0625 | 28.125 | 127272.0 |
| 2015-08-31 07:30:00 | AAPL | Stock | 28.1225 | 28.1775 | 28.1125 | 28.1725 | 72216.0 |
| 2015-08-31 08:00:00 | AAPL | Stock | 28.1575 | 28.175 | 28.03 | 28.115 | 477280.0 |
| 2015-08-31 08:30:00 | AAPL | Stock | 28.115 | 28.115 | 28.05 | 28.075 | 369960.0 |
| 2015-08-31 09:00:00 | AAPL | Stock | 28.065 | 28.3225 | 27.975 | 28.0 | 1157136.0 |
| 2015-08-31 09:30:00 | AAPL | Stock | 28.0075 | 28.3 | 28.0 | 28.0925 | 24107688.0 |
| 2015-08-31 10:00:00 | AAPL | Stock | 28.095 | 28.275 | 28.0075 | 28.2375 | 16805844.0 |
| 2015-08-31 10:30:00 | AAPL | Stock | 28.2375 | 28.3625 | 28.1925 | 28.2175 | 13500920.0 |
| 2015-08-31 11:00:00 | AAPL | Stock | 28.22 | 28.345 | 28.13 | 28.295 | 11942684.0 |
| 2015-08-31 11:30:00 | AAPL | Stock | 28.2925 | 28.4675 | 28.2175 | 28.4475 | 16928780.0 |
| 2015-08-31 12:00:00 | AAPL | Stock | 28.445 | 28.6325 | 28.4375 | 28.6125 | 15659068.0 |
| 2015-08-31 12:30:00 | AAPL | Stock | 28.6125 | 28.62 | 28.515 | 28.5175 | 11765744.0 |
| 2015-08-31 13:00:00 | AAPL | Stock | 28.515 | 28.5525 | 28.3625 | 28.4438 | 10562824.0 |
| 2015-08-31 13:30:00 | AAPL | Stock | 28.445 | 28.4525 | 28.3125 | 28.3575 | 10094664.0 |
| 2015-08-31 14:00:00 | AAPL | Stock | 28.3625 | 28.455 | 28.2025 | 28.2525 | 12516464.0 |
| 2015-08-31 14:30:00 | AAPL | Stock | 28.2525 | 28.285 | 28.0775 | 28.125 | 12294160.0 |
| 2015-08-31 15:00:00 | AAPL | Stock | 28.1228 | 28.2975 | 28.1175 | 28.19 | 14676500.0 |
| 2015-08-31 15:30:00 | AAPL | Stock | 28.19 | 28.3288 | 28.17 | 28.1775 | 23182720.0 |
| 2015-08-31 16:00:00 | AAPL | Stock | 28.19 | 28.21 | 28.15 | 28.1625 | 15776596.0 |
| 2015-08-31 16:30:00 | AAPL | Stock | 28.1625 | 28.1865 | 28.1408 | 28.1475 | 257208.0 |
| 2015-08-31 17:00:00 | AAPL | Stock | 28.1625 | 28.1775 | 28.155 | 28.1725 | 55272.0 |
| 2015-08-31 17:30:00 | AAPL | Stock | 28.175 | 28.1875 | 28.1625 | 28.175 | 38676.0 |
| 2015-08-31 18:00:00 | AAPL | Stock | 28.1675 | 28.1725 | 28.1375 | 28.1442 | 48576.0 |
| 2015-08-31 18:30:00 | AAPL | Stock | 28.1375 | 28.1375 | 28.1275 | 28.135 | 14088.0 |
| 2015-08-31 19:00:00 | AAPL | Stock | 28.13 | 28.135 | 28.125 | 28.125 | 39260.0 |
| 2015-08-31 19:30:00 | AAPL | Stock | 28.1275 | 28.1275 | 28.0625 | 28.0625 | 72064.0 |
| 2015-08-31 07:00:00 | MSFT | Stock | 43.94 | 43.94 | 43.66 | 43.66 | 200.0 |
| 2015-08-31 08:00:00 | MSFT | Stock | 43.733 | 43.783 | 43.73 | 43.73 | 7630.0 |
| 2015-08-31 08:30:00 | MSFT | Stock | 43.73 | 43.747 | 43.64 | 43.747 | 1590.0 |
| 2015-08-31 09:00:00 | MSFT | Stock | 43.74 | 43.93 | 43.653 | 43.72 | 155356.0 |
| 2015-08-31 09:30:00 | MSFT | Stock | 43.65 | 43.78 | 43.25 | 43.28 | 2443795.0 |
| 2015-08-31 10:00:00 | MSFT | Stock | 43.28 | 43.35 | 43.1 | 43.31 | 2061014.0 |
| 2015-08-31 10:30:00 | MSFT | Stock | 43.31 | 43.66 | 43.3 | 43.42 | 1863422.0 |
| 2015-08-31 11:00:00 | MSFT | Stock | 43.41 | 43.71 | 43.22 | 43.65 | 1890807.0 |
| 2015-08-31 11:30:00 | MSFT | Stock | 43.64 | 43.84 | 43.53 | 43.765 | 1269817.0 |
| 2015-08-31 12:00:00 | MSFT | Stock | 43.77 | 43.9 | 43.72 | 43.9 | 676182.0 |
| 2015-08-31 12:30:00 | MSFT | Stock | 43.9 | 43.93 | 43.79 | 43.84 | 805801.0 |
| 2015-08-31 13:00:00 | MSFT | Stock | 43.85 | 43.93 | 43.7 | 43.74 | 831243.0 |
| 2015-08-31 13:30:00 | MSFT | Stock | 43.75 | 43.76 | 43.57 | 43.62 | 1251069.0 |
| 2015-08-31 14:00:00 | MSFT | Stock | 43.63 | 43.66 | 43.37 | 43.496 | 1863328.0 |
| 2015-08-31 14:30:00 | MSFT | Stock | 43.5 | 43.57 | 43.28 | 43.35 | 1849477.0 |
| 2015-08-31 15:00:00 | MSFT | Stock | 43.35 | 43.48 | 43.3 | 43.38 | 2094185.0 |
| 2015-08-31 15:30:00 | MSFT | Stock | 43.38 | 43.58 | 43.345 | 43.51 | 5484065.0 |
| 2015-08-31 16:00:00 | MSFT | Stock | 43.52 | 43.526 | 43.41 | 43.49 | 7704652.0 |
> showing 50 of 83,367 rows — these rows as CSV