PREVIEW / stock_30min / 2015-03-10
file: by_date/stock_30min/2015/2015-03-10.parquet size: 1.6 MB rows: 84,833 symbols: 3,505
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-10 04:00:00 | AAPL | Stock | 31.7625 | 32.0 | 31.7575 | 31.7575 | 6800.0 |
| 2015-03-10 04:30:00 | AAPL | Stock | 31.6475 | 31.67 | 31.6475 | 31.67 | 2800.0 |
| 2015-03-10 05:00:00 | AAPL | Stock | 31.68 | 31.6925 | 31.575 | 31.5825 | 24468.0 |
| 2015-03-10 05:30:00 | AAPL | Stock | 31.59 | 31.6025 | 31.55 | 31.6 | 19304.0 |
| 2015-03-10 06:00:00 | AAPL | Stock | 31.6 | 31.6 | 31.4575 | 31.5 | 37344.0 |
| 2015-03-10 06:30:00 | AAPL | Stock | 31.52 | 31.595 | 31.5 | 31.5625 | 61252.0 |
| 2015-03-10 07:00:00 | AAPL | Stock | 31.5975 | 31.6125 | 31.4775 | 31.5025 | 164704.0 |
| 2015-03-10 07:30:00 | AAPL | Stock | 31.525 | 31.685 | 31.5025 | 31.615 | 241612.0 |
| 2015-03-10 08:00:00 | AAPL | Stock | 31.6175 | 31.72 | 31.5 | 31.6 | 704384.0 |
| 2015-03-10 08:30:00 | AAPL | Stock | 31.595 | 31.64 | 31.5475 | 31.61 | 585800.0 |
| 2015-03-10 09:00:00 | AAPL | Stock | 31.605 | 31.71 | 31.545 | 31.615 | 803528.0 |
| 2015-03-10 09:30:00 | AAPL | Stock | 31.6175 | 31.805 | 31.39 | 31.4972 | 30630904.0 |
| 2015-03-10 10:00:00 | AAPL | Stock | 31.4975 | 31.555 | 31.3 | 31.35 | 19941228.0 |
| 2015-03-10 10:30:00 | AAPL | Stock | 31.35 | 31.35 | 31.105 | 31.24 | 31818332.0 |
| 2015-03-10 11:00:00 | AAPL | Stock | 31.24 | 31.41 | 31.225 | 31.296 | 18726724.0 |
| 2015-03-10 11:30:00 | AAPL | Stock | 31.295 | 31.3725 | 31.145 | 31.1475 | 14662920.0 |
| 2015-03-10 12:00:00 | AAPL | Stock | 31.15 | 31.1875 | 31.0225 | 31.0375 | 19366512.0 |
| 2015-03-10 12:30:00 | AAPL | Stock | 31.0375 | 31.1375 | 30.95 | 31.06 | 16248096.0 |
| 2015-03-10 13:00:00 | AAPL | Stock | 31.0625 | 31.225 | 31.035 | 31.1575 | 10440620.0 |
| 2015-03-10 13:30:00 | AAPL | Stock | 31.16 | 31.3325 | 31.1475 | 31.2605 | 12320260.0 |
| 2015-03-10 14:00:00 | AAPL | Stock | 31.2625 | 31.36 | 31.14 | 31.175 | 11216960.0 |
| 2015-03-10 14:30:00 | AAPL | Stock | 31.1735 | 31.3075 | 31.1715 | 31.2275 | 9512228.0 |
| 2015-03-10 15:00:00 | AAPL | Stock | 31.2252 | 31.3475 | 31.2025 | 31.22 | 10050892.0 |
| 2015-03-10 15:30:00 | AAPL | Stock | 31.2222 | 31.2925 | 31.13 | 31.13 | 23638604.0 |
| 2015-03-10 16:00:00 | AAPL | Stock | 31.1275 | 31.485 | 31.1175 | 31.1325 | 22687064.0 |
| 2015-03-10 16:30:00 | AAPL | Stock | 31.1325 | 31.319 | 31.1238 | 31.16 | 964972.0 |
| 2015-03-10 17:00:00 | AAPL | Stock | 31.1575 | 31.1575 | 31.075 | 31.075 | 952288.0 |
| 2015-03-10 17:30:00 | AAPL | Stock | 31.0875 | 31.1275 | 31.035 | 31.075 | 170860.0 |
| 2015-03-10 18:00:00 | AAPL | Stock | 31.1 | 31.125 | 31.0825 | 31.12 | 88300.0 |
| 2015-03-10 18:30:00 | AAPL | Stock | 31.11 | 31.135 | 31.08 | 31.1275 | 52052.0 |
| 2015-03-10 19:00:00 | AAPL | Stock | 31.135 | 31.14 | 31.1275 | 31.1325 | 53804.0 |
| 2015-03-10 19:30:00 | AAPL | Stock | 31.145 | 31.18 | 31.1325 | 31.18 | 121520.0 |
| 2015-03-10 06:00:00 | MSFT | Stock | 42.53 | 42.53 | 42.53 | 42.53 | 200.0 |
| 2015-03-10 07:00:00 | MSFT | Stock | 42.51 | 42.51 | 42.45 | 42.45 | 710.0 |
| 2015-03-10 07:30:00 | MSFT | Stock | 42.46 | 42.46 | 42.46 | 42.46 | 100.0 |
| 2015-03-10 08:00:00 | MSFT | Stock | 42.46 | 42.47 | 42.44 | 42.44 | 5772.0 |
| 2015-03-10 08:30:00 | MSFT | Stock | 42.39 | 42.45 | 42.27 | 42.37 | 8675.0 |
| 2015-03-10 09:00:00 | MSFT | Stock | 42.35 | 42.45 | 42.33 | 42.35 | 13960.0 |
| 2015-03-10 09:30:00 | MSFT | Stock | 42.35 | 42.71 | 42.3 | 42.48 | 4038216.0 |
| 2015-03-10 10:00:00 | MSFT | Stock | 42.48 | 42.56 | 42.36 | 42.405 | 2817125.0 |
| 2015-03-10 10:30:00 | MSFT | Stock | 42.405 | 42.47 | 42.32 | 42.4 | 2321956.0 |
| 2015-03-10 11:00:00 | MSFT | Stock | 42.4 | 42.57 | 42.4 | 42.46 | 1564353.0 |
| 2015-03-10 11:30:00 | MSFT | Stock | 42.45 | 42.46 | 42.26 | 42.265 | 1557721.0 |
| 2015-03-10 12:00:00 | MSFT | Stock | 42.26 | 42.38 | 42.25 | 42.32 | 1384797.0 |
| 2015-03-10 12:30:00 | MSFT | Stock | 42.32 | 42.39 | 42.26 | 42.33 | 1240654.0 |
| 2015-03-10 13:00:00 | MSFT | Stock | 42.33 | 42.38 | 42.261 | 42.295 | 2187000.0 |
| 2015-03-10 13:30:00 | MSFT | Stock | 42.295 | 42.3 | 42.17 | 42.193 | 1590095.0 |
| 2015-03-10 14:00:00 | MSFT | Stock | 42.2 | 42.22 | 42.1 | 42.125 | 1826219.0 |
| 2015-03-10 14:30:00 | MSFT | Stock | 42.125 | 42.15 | 42.065 | 42.105 | 2469142.0 |
| 2015-03-10 15:00:00 | MSFT | Stock | 42.1 | 42.28 | 42.09 | 42.17 | 2243292.0 |
> showing 50 of 84,833 rows — these rows as CSV