PREVIEW / stock_30min / 2015-03-04
file: by_date/stock_30min/2015/2015-03-04.parquet size: 1.6 MB rows: 82,351 symbols: 3,499
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-04 04:00:00 | AAPL | Stock | 32.34 | 32.34 | 32.205 | 32.225 | 9676.0 |
| 2015-03-04 05:00:00 | AAPL | Stock | 32.27 | 32.3375 | 32.27 | 32.3375 | 21600.0 |
| 2015-03-04 05:30:00 | AAPL | Stock | 32.305 | 32.335 | 32.2675 | 32.28 | 26868.0 |
| 2015-03-04 06:00:00 | AAPL | Stock | 32.28 | 32.28 | 32.25 | 32.25 | 12620.0 |
| 2015-03-04 06:30:00 | AAPL | Stock | 32.25 | 32.275 | 32.2275 | 32.25 | 30380.0 |
| 2015-03-04 07:00:00 | AAPL | Stock | 32.25 | 32.25 | 32.2 | 32.25 | 27112.0 |
| 2015-03-04 07:30:00 | AAPL | Stock | 32.25 | 32.25 | 32.2125 | 32.2425 | 34356.0 |
| 2015-03-04 08:00:00 | AAPL | Stock | 32.2425 | 32.34 | 32.2 | 32.2375 | 217068.0 |
| 2015-03-04 08:30:00 | AAPL | Stock | 32.2375 | 32.3025 | 32.23 | 32.285 | 188896.0 |
| 2015-03-04 09:00:00 | AAPL | Stock | 32.2825 | 32.34 | 32.265 | 32.2775 | 394944.0 |
| 2015-03-04 09:30:00 | AAPL | Stock | 32.275 | 32.39 | 32.0975 | 32.1678 | 22204764.0 |
| 2015-03-04 10:00:00 | AAPL | Stock | 32.17 | 32.28 | 32.1475 | 32.1675 | 11092544.0 |
| 2015-03-04 10:30:00 | AAPL | Stock | 32.1675 | 32.2775 | 32.1562 | 32.255 | 7698232.0 |
| 2015-03-04 11:00:00 | AAPL | Stock | 32.255 | 32.335 | 32.2075 | 32.2275 | 9172744.0 |
| 2015-03-04 11:30:00 | AAPL | Stock | 32.2275 | 32.2525 | 32.1625 | 32.2358 | 8210980.0 |
| 2015-03-04 12:00:00 | AAPL | Stock | 32.2362 | 32.28 | 32.205 | 32.25 | 3928744.0 |
| 2015-03-04 12:30:00 | AAPL | Stock | 32.25 | 32.2875 | 32.2325 | 32.245 | 3987656.0 |
| 2015-03-04 13:00:00 | AAPL | Stock | 32.245 | 32.295 | 32.2175 | 32.2668 | 3319204.0 |
| 2015-03-04 13:30:00 | AAPL | Stock | 32.265 | 32.2825 | 32.185 | 32.2112 | 3413092.0 |
| 2015-03-04 14:00:00 | AAPL | Stock | 32.21 | 32.23 | 32.1625 | 32.21 | 4302756.0 |
| 2015-03-04 14:30:00 | AAPL | Stock | 32.2125 | 32.25 | 32.2 | 32.2065 | 3493192.0 |
| 2015-03-04 15:00:00 | AAPL | Stock | 32.2062 | 32.2275 | 32.1275 | 32.1725 | 8533964.0 |
| 2015-03-04 15:30:00 | AAPL | Stock | 32.1708 | 32.225 | 32.08 | 32.14 | 15437076.0 |
| 2015-03-04 16:00:00 | AAPL | Stock | 32.135 | 32.2225 | 32.1025 | 32.105 | 10778444.0 |
| 2015-03-04 16:30:00 | AAPL | Stock | 32.105 | 32.2245 | 32.0975 | 32.12 | 2097740.0 |
| 2015-03-04 17:00:00 | AAPL | Stock | 32.12 | 32.135 | 32.0525 | 32.1 | 281748.0 |
| 2015-03-04 17:30:00 | AAPL | Stock | 32.1 | 32.1625 | 32.0925 | 32.1325 | 120452.0 |
| 2015-03-04 18:00:00 | AAPL | Stock | 32.1278 | 32.1325 | 32.11 | 32.11 | 39152.0 |
| 2015-03-04 18:30:00 | AAPL | Stock | 32.1325 | 32.135 | 32.105 | 32.1075 | 63784.0 |
| 2015-03-04 19:00:00 | AAPL | Stock | 32.11 | 32.1225 | 32.11 | 32.1225 | 12396.0 |
| 2015-03-04 19:30:00 | AAPL | Stock | 32.115 | 32.12 | 32.11 | 32.11 | 37356.0 |
| 2015-03-04 04:00:00 | MSFT | Stock | 43.64 | 43.64 | 43.64 | 43.64 | 2107.0 |
| 2015-03-04 06:00:00 | MSFT | Stock | 43.21 | 43.21 | 43.21 | 43.21 | 200.0 |
| 2015-03-04 08:00:00 | MSFT | Stock | 43.34 | 43.34 | 43.11 | 43.11 | 14476.0 |
| 2015-03-04 08:30:00 | MSFT | Stock | 43.18 | 43.18 | 43.15 | 43.15 | 1100.0 |
| 2015-03-04 09:00:00 | MSFT | Stock | 43.28 | 43.28 | 42.9 | 43.0 | 79814.0 |
| 2015-03-04 09:30:00 | MSFT | Stock | 43.01 | 43.09 | 42.88 | 42.99 | 4275296.0 |
| 2015-03-04 10:00:00 | MSFT | Stock | 42.99 | 43.08 | 42.91 | 43.02 | 2741656.0 |
| 2015-03-04 10:30:00 | MSFT | Stock | 43.01 | 43.17 | 43.0 | 43.11 | 1814087.0 |
| 2015-03-04 11:00:00 | MSFT | Stock | 43.11 | 43.21 | 43.05 | 43.15 | 1365142.0 |
| 2015-03-04 11:30:00 | MSFT | Stock | 43.19 | 43.19 | 43.05 | 43.07 | 1247461.0 |
| 2015-03-04 12:00:00 | MSFT | Stock | 43.07 | 43.18 | 43.045 | 43.16 | 809123.0 |
| 2015-03-04 12:30:00 | MSFT | Stock | 43.165 | 43.21 | 43.09 | 43.09 | 917633.0 |
| 2015-03-04 13:00:00 | MSFT | Stock | 43.09 | 43.14 | 43.06 | 43.08 | 843258.0 |
| 2015-03-04 13:30:00 | MSFT | Stock | 43.09 | 43.13 | 43.0 | 43.01 | 1087625.0 |
| 2015-03-04 14:00:00 | MSFT | Stock | 43.01 | 43.04 | 42.95 | 42.991 | 1224293.0 |
| 2015-03-04 14:30:00 | MSFT | Stock | 43.0 | 43.11 | 42.98 | 43.05 | 1034307.0 |
| 2015-03-04 15:00:00 | MSFT | Stock | 43.055 | 43.07 | 42.99 | 43.043 | 1455801.0 |
| 2015-03-04 15:30:00 | MSFT | Stock | 43.04 | 43.11 | 43.02 | 43.06 | 2845565.0 |
| 2015-03-04 16:00:00 | MSFT | Stock | 43.055 | 43.401 | 43.041 | 43.059 | 2974683.0 |
> showing 50 of 82,351 rows — these rows as CSV