PREVIEW / stock_30min / 2015-02-24
file: by_date/stock_30min/2015/2015-02-24.parquet size: 1.6 MB rows: 82,637 symbols: 3,516
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-02-24 04:00:00 | AAPL | Stock | 33.33 | 33.415 | 33.325 | 33.325 | 19080.0 |
| 2015-02-24 04:30:00 | AAPL | Stock | 33.3475 | 33.375 | 33.275 | 33.32 | 106212.0 |
| 2015-02-24 05:00:00 | AAPL | Stock | 33.3225 | 33.375 | 33.3075 | 33.3725 | 78936.0 |
| 2015-02-24 05:30:00 | AAPL | Stock | 33.365 | 33.365 | 33.305 | 33.305 | 22556.0 |
| 2015-02-24 06:00:00 | AAPL | Stock | 33.3125 | 33.325 | 33.275 | 33.3225 | 46672.0 |
| 2015-02-24 06:30:00 | AAPL | Stock | 33.2825 | 33.3625 | 33.28 | 33.2975 | 182252.0 |
| 2015-02-24 07:00:00 | AAPL | Stock | 33.285 | 33.29 | 33.2275 | 33.2725 | 303648.0 |
| 2015-02-24 07:30:00 | AAPL | Stock | 33.2725 | 33.275 | 33.2375 | 33.25 | 165912.0 |
| 2015-02-24 08:00:00 | AAPL | Stock | 33.2525 | 33.3 | 33.09 | 33.1375 | 1341080.0 |
| 2015-02-24 08:30:00 | AAPL | Stock | 33.145 | 33.175 | 33.125 | 33.1702 | 504720.0 |
| 2015-02-24 09:00:00 | AAPL | Stock | 33.1725 | 33.25 | 33.095 | 33.2375 | 1559036.0 |
| 2015-02-24 09:30:00 | AAPL | Stock | 33.2375 | 33.24 | 32.7925 | 32.93 | 52387916.0 |
| 2015-02-24 10:00:00 | AAPL | Stock | 32.9325 | 33.1775 | 32.8925 | 33.1525 | 25080684.0 |
| 2015-02-24 10:30:00 | AAPL | Stock | 33.1525 | 33.325 | 33.115 | 33.2975 | 26332240.0 |
| 2015-02-24 11:00:00 | AAPL | Stock | 33.2978 | 33.4 | 33.215 | 33.37 | 20429560.0 |
| 2015-02-24 11:30:00 | AAPL | Stock | 33.37 | 33.38 | 33.2125 | 33.215 | 16117192.0 |
| 2015-02-24 12:00:00 | AAPL | Stock | 33.2175 | 33.25 | 33.1175 | 33.145 | 13183348.0 |
| 2015-02-24 12:30:00 | AAPL | Stock | 33.1475 | 33.1625 | 32.915 | 33.0175 | 21953280.0 |
| 2015-02-24 13:00:00 | AAPL | Stock | 33.0175 | 33.12 | 33.01 | 33.0825 | 11550176.0 |
| 2015-02-24 13:30:00 | AAPL | Stock | 33.085 | 33.195 | 33.0655 | 33.125 | 8957800.0 |
| 2015-02-24 14:00:00 | AAPL | Stock | 33.1225 | 33.2225 | 33.1125 | 33.1575 | 8610688.0 |
| 2015-02-24 14:30:00 | AAPL | Stock | 33.155 | 33.22 | 33.085 | 33.1748 | 10202348.0 |
| 2015-02-24 15:00:00 | AAPL | Stock | 33.1725 | 33.24 | 33.15 | 33.2242 | 10007536.0 |
| 2015-02-24 15:30:00 | AAPL | Stock | 33.2238 | 33.24 | 32.9825 | 33.045 | 23044700.0 |
| 2015-02-24 16:00:00 | AAPL | Stock | 33.0425 | 33.277 | 32.9192 | 33.0375 | 6526528.0 |
| 2015-02-24 16:30:00 | AAPL | Stock | 33.0375 | 33.151 | 33.0 | 33.0 | 236260.0 |
| 2015-02-24 17:00:00 | AAPL | Stock | 33.0 | 33.005 | 32.935 | 32.965 | 265956.0 |
| 2015-02-24 17:30:00 | AAPL | Stock | 32.97 | 32.98 | 32.9525 | 32.9725 | 90832.0 |
| 2015-02-24 18:00:00 | AAPL | Stock | 32.97 | 33.0425 | 32.95 | 32.9625 | 70528.0 |
| 2015-02-24 18:30:00 | AAPL | Stock | 32.9625 | 32.9822 | 32.9575 | 32.9625 | 73584.0 |
| 2015-02-24 19:00:00 | AAPL | Stock | 32.965 | 32.9675 | 32.95 | 32.9575 | 76684.0 |
| 2015-02-24 19:30:00 | AAPL | Stock | 32.9525 | 32.96 | 32.9475 | 32.95 | 121208.0 |
| 2015-02-24 08:00:00 | MSFT | Stock | 44.05 | 44.06 | 44.05 | 44.06 | 812.0 |
| 2015-02-24 08:30:00 | MSFT | Stock | 44.07 | 44.07 | 44.06 | 44.06 | 1350.0 |
| 2015-02-24 09:00:00 | MSFT | Stock | 44.07 | 44.15 | 44.06 | 44.14 | 20119.0 |
| 2015-02-24 09:30:00 | MSFT | Stock | 44.15 | 44.17 | 43.92 | 44.07 | 4476590.0 |
| 2015-02-24 10:00:00 | MSFT | Stock | 44.07 | 44.2 | 44.0 | 44.16 | 2455364.0 |
| 2015-02-24 10:30:00 | MSFT | Stock | 44.15 | 44.16 | 44.0 | 44.04 | 1644629.0 |
| 2015-02-24 11:00:00 | MSFT | Stock | 44.04 | 44.24 | 44.04 | 44.24 | 1279239.0 |
| 2015-02-24 11:30:00 | MSFT | Stock | 44.234 | 44.3 | 44.1 | 44.13 | 1488799.0 |
| 2015-02-24 12:00:00 | MSFT | Stock | 44.135 | 44.2 | 44.07 | 44.195 | 796497.0 |
| 2015-02-24 12:30:00 | MSFT | Stock | 44.2 | 44.25 | 44.09 | 44.245 | 1097314.0 |
| 2015-02-24 13:00:00 | MSFT | Stock | 44.245 | 44.25 | 44.155 | 44.2 | 913913.0 |
| 2015-02-24 13:30:00 | MSFT | Stock | 44.205 | 44.22 | 44.145 | 44.16 | 970241.0 |
| 2015-02-24 14:00:00 | MSFT | Stock | 44.16 | 44.17 | 44.09 | 44.13 | 1416160.0 |
| 2015-02-24 14:30:00 | MSFT | Stock | 44.125 | 44.19 | 44.12 | 44.16 | 905831.0 |
| 2015-02-24 15:00:00 | MSFT | Stock | 44.16 | 44.17 | 44.09 | 44.14 | 1256462.0 |
| 2015-02-24 15:30:00 | MSFT | Stock | 44.135 | 44.155 | 44.06 | 44.1 | 2961229.0 |
| 2015-02-24 16:00:00 | MSFT | Stock | 44.09 | 44.19 | 43.78 | 43.9 | 2202931.0 |
| 2015-02-24 16:30:00 | MSFT | Stock | 44.155 | 44.155 | 43.949 | 44.126 | 13720.0 |
> showing 50 of 82,637 rows — these rows as CSV