PREVIEW / stock_30min / 2015-02-19
file: by_date/stock_30min/2015/2015-02-19.parquet size: 1.6 MB rows: 83,623 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-02-19 04:00:00 | AAPL | Stock | 32.1475 | 32.16 | 32.1375 | 32.16 | 6380.0 |
| 2015-02-19 04:30:00 | AAPL | Stock | 32.1575 | 32.1575 | 32.125 | 32.125 | 9884.0 |
| 2015-02-19 05:00:00 | AAPL | Stock | 32.135 | 32.195 | 32.075 | 32.195 | 13492.0 |
| 2015-02-19 05:30:00 | AAPL | Stock | 32.1725 | 32.175 | 32.1725 | 32.175 | 6000.0 |
| 2015-02-19 06:00:00 | AAPL | Stock | 32.1875 | 32.2 | 32.175 | 32.175 | 34436.0 |
| 2015-02-19 06:30:00 | AAPL | Stock | 32.175 | 32.22 | 32.175 | 32.22 | 14060.0 |
| 2015-02-19 07:00:00 | AAPL | Stock | 32.2175 | 32.2375 | 32.0875 | 32.1375 | 164232.0 |
| 2015-02-19 07:30:00 | AAPL | Stock | 32.115 | 32.1375 | 32.1025 | 32.1375 | 59564.0 |
| 2015-02-19 08:00:00 | AAPL | Stock | 32.15 | 32.19 | 32.1025 | 32.125 | 351944.0 |
| 2015-02-19 08:30:00 | AAPL | Stock | 32.125 | 32.1625 | 32.1175 | 32.125 | 282068.0 |
| 2015-02-19 09:00:00 | AAPL | Stock | 32.13 | 32.1788 | 32.09 | 32.1375 | 301832.0 |
| 2015-02-19 09:30:00 | AAPL | Stock | 32.115 | 32.2225 | 32.0825 | 32.1662 | 24989436.0 |
| 2015-02-19 10:00:00 | AAPL | Stock | 32.165 | 32.2425 | 32.1025 | 32.2025 | 16232360.0 |
| 2015-02-19 10:30:00 | AAPL | Stock | 32.2038 | 32.2575 | 32.18 | 32.1825 | 12156916.0 |
| 2015-02-19 11:00:00 | AAPL | Stock | 32.1825 | 32.2 | 32.1225 | 32.175 | 11316312.0 |
| 2015-02-19 11:30:00 | AAPL | Stock | 32.175 | 32.185 | 32.13 | 32.1812 | 6497940.0 |
| 2015-02-19 12:00:00 | AAPL | Stock | 32.18 | 32.1925 | 32.1552 | 32.1675 | 5055048.0 |
| 2015-02-19 12:30:00 | AAPL | Stock | 32.1688 | 32.1868 | 32.1075 | 32.18 | 7686656.0 |
| 2015-02-19 13:00:00 | AAPL | Stock | 32.18 | 32.1975 | 32.1625 | 32.175 | 5835316.0 |
| 2015-02-19 13:30:00 | AAPL | Stock | 32.175 | 32.19 | 32.15 | 32.175 | 4888044.0 |
| 2015-02-19 14:00:00 | AAPL | Stock | 32.1725 | 32.1825 | 32.1275 | 32.1292 | 4970232.0 |
| 2015-02-19 14:30:00 | AAPL | Stock | 32.1287 | 32.17 | 32.09 | 32.1675 | 8860408.0 |
| 2015-02-19 15:00:00 | AAPL | Stock | 32.1688 | 32.22 | 32.1675 | 32.2125 | 10789388.0 |
| 2015-02-19 15:30:00 | AAPL | Stock | 32.2125 | 32.2175 | 32.0825 | 32.115 | 13327084.0 |
| 2015-02-19 16:00:00 | AAPL | Stock | 32.1135 | 32.1935 | 32.075 | 32.0975 | 4944228.0 |
| 2015-02-19 16:30:00 | AAPL | Stock | 32.095 | 32.1682 | 32.095 | 32.1175 | 170868.0 |
| 2015-02-19 17:00:00 | AAPL | Stock | 32.1175 | 32.1275 | 32.11 | 32.11 | 53396.0 |
| 2015-02-19 17:30:00 | AAPL | Stock | 32.1125 | 32.115 | 32.1075 | 32.1125 | 28524.0 |
| 2015-02-19 18:00:00 | AAPL | Stock | 32.1125 | 32.125 | 32.1123 | 32.125 | 40468.0 |
| 2015-02-19 18:30:00 | AAPL | Stock | 32.1225 | 32.1372 | 32.11 | 32.11 | 33560.0 |
| 2015-02-19 19:00:00 | AAPL | Stock | 32.11 | 32.1225 | 32.105 | 32.1225 | 41772.0 |
| 2015-02-19 19:30:00 | AAPL | Stock | 32.1225 | 32.1425 | 32.1225 | 32.125 | 101200.0 |
| 2015-02-19 04:00:00 | MSFT | Stock | 43.46 | 43.46 | 43.46 | 43.46 | 100.0 |
| 2015-02-19 05:00:00 | MSFT | Stock | 43.53 | 43.53 | 43.52 | 43.52 | 1800.0 |
| 2015-02-19 05:30:00 | MSFT | Stock | 43.53 | 43.53 | 43.53 | 43.53 | 100.0 |
| 2015-02-19 06:00:00 | MSFT | Stock | 43.53 | 43.53 | 43.53 | 43.53 | 200.0 |
| 2015-02-19 06:30:00 | MSFT | Stock | 43.53 | 43.53 | 43.53 | 43.53 | 200.0 |
| 2015-02-19 07:00:00 | MSFT | Stock | 43.58 | 43.58 | 43.51 | 43.51 | 1633.0 |
| 2015-02-19 08:00:00 | MSFT | Stock | 43.54 | 43.55 | 43.5 | 43.5 | 3932.0 |
| 2015-02-19 08:30:00 | MSFT | Stock | 43.5 | 43.5 | 43.5 | 43.5 | 642.0 |
| 2015-02-19 09:00:00 | MSFT | Stock | 43.4 | 43.45 | 43.17 | 43.17 | 70291.0 |
| 2015-02-19 09:30:00 | MSFT | Stock | 43.26 | 43.3 | 43.05 | 43.21 | 5054576.0 |
| 2015-02-19 10:00:00 | MSFT | Stock | 43.2 | 43.305 | 43.175 | 43.27 | 1823651.0 |
| 2015-02-19 10:30:00 | MSFT | Stock | 43.27 | 43.29 | 43.2 | 43.25 | 2170788.0 |
| 2015-02-19 11:00:00 | MSFT | Stock | 43.25 | 43.46 | 43.18 | 43.43 | 2277138.0 |
| 2015-02-19 11:30:00 | MSFT | Stock | 43.435 | 43.526 | 43.39 | 43.43 | 1421219.0 |
| 2015-02-19 12:00:00 | MSFT | Stock | 43.43 | 43.465 | 43.37 | 43.37 | 712540.0 |
| 2015-02-19 12:30:00 | MSFT | Stock | 43.375 | 43.39 | 43.27 | 43.377 | 1134410.0 |
| 2015-02-19 13:00:00 | MSFT | Stock | 43.375 | 43.405 | 43.315 | 43.365 | 773462.0 |
| 2015-02-19 13:30:00 | MSFT | Stock | 43.365 | 43.42 | 43.34 | 43.41 | 751784.0 |
> showing 50 of 83,623 rows — these rows as CSV