PREVIEW / stock_30min / 2014-09-19
file: by_date/stock_30min/2014/2014-09-19.parquet size: 1.7 MB rows: 85,336 symbols: 3,582
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 |
|---|---|---|---|---|---|---|---|
| 2014-09-19 04:00:00 | AAPL | Stock | 25.4975 | 25.59 | 25.4975 | 25.535 | 16200.0 |
| 2014-09-19 04:30:00 | AAPL | Stock | 25.535 | 25.55 | 25.53 | 25.5475 | 21272.0 |
| 2014-09-19 05:00:00 | AAPL | Stock | 25.5475 | 25.55 | 25.53 | 25.55 | 17652.0 |
| 2014-09-19 05:30:00 | AAPL | Stock | 25.55 | 25.555 | 25.5 | 25.5 | 19680.0 |
| 2014-09-19 06:00:00 | AAPL | Stock | 25.5 | 25.55 | 25.4875 | 25.55 | 46856.0 |
| 2014-09-19 06:30:00 | AAPL | Stock | 25.505 | 25.53 | 25.505 | 25.53 | 4260.0 |
| 2014-09-19 07:00:00 | AAPL | Stock | 25.535 | 25.575 | 25.535 | 25.54 | 155708.0 |
| 2014-09-19 07:30:00 | AAPL | Stock | 25.54 | 25.5425 | 25.4875 | 25.4925 | 183976.0 |
| 2014-09-19 08:00:00 | AAPL | Stock | 25.5 | 25.57 | 25.4475 | 25.4825 | 576004.0 |
| 2014-09-19 08:30:00 | AAPL | Stock | 25.48 | 25.5225 | 25.465 | 25.52 | 226856.0 |
| 2014-09-19 09:00:00 | AAPL | Stock | 25.515 | 25.58 | 25.4775 | 25.5675 | 2597564.0 |
| 2014-09-19 09:30:00 | AAPL | Stock | 25.5675 | 25.5875 | 25.43 | 25.4768 | 70107344.0 |
| 2014-09-19 10:00:00 | AAPL | Stock | 25.4775 | 25.4875 | 25.345 | 25.3452 | 16650524.0 |
| 2014-09-19 10:30:00 | AAPL | Stock | 25.3462 | 25.445 | 25.31 | 25.4425 | 13240332.0 |
| 2014-09-19 11:00:00 | AAPL | Stock | 25.4425 | 25.49 | 25.3975 | 25.4 | 10980484.0 |
| 2014-09-19 11:30:00 | AAPL | Stock | 25.4 | 25.41 | 25.3502 | 25.4062 | 8881672.0 |
| 2014-09-19 12:00:00 | AAPL | Stock | 25.4075 | 25.437 | 25.33 | 25.39 | 9635104.0 |
| 2014-09-19 12:30:00 | AAPL | Stock | 25.3898 | 25.4075 | 25.335 | 25.3825 | 7192436.0 |
| 2014-09-19 13:00:00 | AAPL | Stock | 25.385 | 25.4325 | 25.365 | 25.43 | 8145796.0 |
| 2014-09-19 13:30:00 | AAPL | Stock | 25.4275 | 25.4625 | 25.4112 | 25.4425 | 8421004.0 |
| 2014-09-19 14:00:00 | AAPL | Stock | 25.4432 | 25.4575 | 25.4125 | 25.448 | 7865104.0 |
| 2014-09-19 14:30:00 | AAPL | Stock | 25.449 | 25.4975 | 25.435 | 25.49 | 9076272.0 |
| 2014-09-19 15:00:00 | AAPL | Stock | 25.49 | 25.51 | 25.445 | 25.4453 | 11767120.0 |
| 2014-09-19 15:30:00 | AAPL | Stock | 25.445 | 25.4525 | 25.22 | 25.2425 | 30978996.0 |
| 2014-09-19 16:00:00 | AAPL | Stock | 25.24 | 25.4918 | 25.2325 | 25.3375 | 49831704.0 |
| 2014-09-19 16:30:00 | AAPL | Stock | 25.3375 | 25.4475 | 25.2325 | 25.315 | 1757684.0 |
| 2014-09-19 17:00:00 | AAPL | Stock | 25.315 | 25.325 | 25.3025 | 25.3075 | 128960.0 |
| 2014-09-19 17:30:00 | AAPL | Stock | 25.3 | 25.325 | 25.24 | 25.315 | 106888.0 |
| 2014-09-19 18:00:00 | AAPL | Stock | 25.3075 | 25.3125 | 25.24 | 25.305 | 172496.0 |
| 2014-09-19 18:30:00 | AAPL | Stock | 25.3025 | 25.4475 | 25.295 | 25.325 | 102484.0 |
| 2014-09-19 19:00:00 | AAPL | Stock | 25.315 | 25.33 | 25.3075 | 25.3125 | 39244.0 |
| 2014-09-19 19:30:00 | AAPL | Stock | 25.3075 | 25.3125 | 25.275 | 25.2875 | 123928.0 |
| 2014-09-19 05:30:00 | MSFT | Stock | 46.81 | 46.81 | 46.81 | 46.81 | 300.0 |
| 2014-09-19 06:00:00 | MSFT | Stock | 46.81 | 46.81 | 46.81 | 46.81 | 600.0 |
| 2014-09-19 07:00:00 | MSFT | Stock | 46.68 | 46.75 | 46.5 | 46.7 | 1125.0 |
| 2014-09-19 07:30:00 | MSFT | Stock | 46.7 | 46.7 | 46.66 | 46.7 | 14091.0 |
| 2014-09-19 08:00:00 | MSFT | Stock | 46.68 | 46.68 | 46.68 | 46.68 | 410.0 |
| 2014-09-19 08:30:00 | MSFT | Stock | 46.7 | 46.7 | 46.66 | 46.66 | 3900.0 |
| 2014-09-19 09:00:00 | MSFT | Stock | 46.55 | 46.8 | 46.54 | 46.79 | 511647.0 |
| 2014-09-19 09:30:00 | MSFT | Stock | 46.77 | 47.19 | 46.6 | 47.177 | 21991315.0 |
| 2014-09-19 10:00:00 | MSFT | Stock | 47.175 | 47.18 | 46.87 | 46.89 | 3866628.0 |
| 2014-09-19 10:30:00 | MSFT | Stock | 46.9 | 46.98 | 46.74 | 46.98 | 3070033.0 |
| 2014-09-19 11:00:00 | MSFT | Stock | 46.98 | 47.01 | 46.89 | 47.01 | 1829840.0 |
| 2014-09-19 11:30:00 | MSFT | Stock | 47.01 | 47.01 | 46.8 | 46.85 | 1902226.0 |
| 2014-09-19 12:00:00 | MSFT | Stock | 46.85 | 46.87 | 46.71 | 46.78 | 2617951.0 |
| 2014-09-19 12:30:00 | MSFT | Stock | 46.776 | 46.87 | 46.73 | 46.86 | 1366056.0 |
| 2014-09-19 13:00:00 | MSFT | Stock | 46.87 | 46.959 | 46.82 | 46.955 | 1830958.0 |
| 2014-09-19 13:30:00 | MSFT | Stock | 46.95 | 46.99 | 46.85 | 46.925 | 2023323.0 |
| 2014-09-19 14:00:00 | MSFT | Stock | 46.92 | 46.99 | 46.83 | 46.98 | 1481164.0 |
| 2014-09-19 14:30:00 | MSFT | Stock | 46.98 | 47.15 | 46.97 | 47.03 | 3013052.0 |
> showing 50 of 85,336 rows — these rows as CSV