PREVIEW / futures_30min / 2014-07-25
file: by_date/futures_30min/2014/2014-07-25.parquet size: 64 KB rows: 2,319
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-07-25 00:00:00 | ES | Futures | 2063.54 | 2063.54 | 2063.28 | 2063.54 | 268.0 |
| 2014-07-25 00:30:00 | ES | Futures | 2063.54 | 2063.54 | 2061.98 | 2062.24 | 774.0 |
| 2014-07-25 01:00:00 | ES | Futures | 2062.24 | 2063.54 | 2061.98 | 2062.76 | 1715.0 |
| 2014-07-25 01:30:00 | ES | Futures | 2062.76 | 2063.8 | 2062.76 | 2063.28 | 955.0 |
| 2014-07-25 02:00:00 | ES | Futures | 2063.28 | 2064.06 | 2063.02 | 2063.54 | 2696.0 |
| 2014-07-25 02:30:00 | ES | Futures | 2063.54 | 2064.84 | 2063.02 | 2064.58 | 3562.0 |
| 2014-07-25 03:00:00 | ES | Futures | 2064.58 | 2064.84 | 2062.76 | 2063.8 | 13994.0 |
| 2014-07-25 03:30:00 | ES | Futures | 2063.8 | 2064.58 | 2063.28 | 2064.06 | 6722.0 |
| 2014-07-25 04:00:00 | ES | Futures | 2064.06 | 2064.84 | 2063.28 | 2064.32 | 8529.0 |
| 2014-07-25 04:30:00 | ES | Futures | 2064.32 | 2064.84 | 2063.28 | 2063.28 | 7078.0 |
| 2014-07-25 05:00:00 | ES | Futures | 2063.28 | 2064.06 | 2061.72 | 2063.02 | 10115.0 |
| 2014-07-25 05:30:00 | ES | Futures | 2063.02 | 2063.02 | 2061.46 | 2061.46 | 6205.0 |
| 2014-07-25 06:00:00 | ES | Futures | 2061.46 | 2062.5 | 2059.89 | 2061.2 | 12892.0 |
| 2014-07-25 06:30:00 | ES | Futures | 2060.94 | 2061.2 | 2059.37 | 2060.67 | 9764.0 |
| 2014-07-25 07:00:00 | ES | Futures | 2060.94 | 2061.72 | 2060.15 | 2061.2 | 5501.0 |
| 2014-07-25 07:30:00 | ES | Futures | 2061.2 | 2063.02 | 2061.2 | 2062.24 | 8912.0 |
| 2014-07-25 08:00:00 | ES | Futures | 2061.98 | 2062.24 | 2061.2 | 2061.72 | 8545.0 |
| 2014-07-25 08:30:00 | ES | Futures | 2061.98 | 2062.24 | 2060.94 | 2061.72 | 15589.0 |
| 2014-07-25 09:00:00 | ES | Futures | 2061.72 | 2061.72 | 2059.11 | 2059.63 | 22742.0 |
| 2014-07-25 09:30:00 | ES | Futures | 2059.63 | 2060.94 | 2056.24 | 2059.89 | 204806.0 |
| 2014-07-25 10:00:00 | ES | Futures | 2059.89 | 2061.46 | 2058.07 | 2060.67 | 91718.0 |
| 2014-07-25 10:30:00 | ES | Futures | 2060.41 | 2060.94 | 2056.5 | 2057.29 | 87003.0 |
| 2014-07-25 11:00:00 | ES | Futures | 2057.03 | 2057.29 | 2051.55 | 2053.9 | 184542.0 |
| 2014-07-25 11:30:00 | ES | Futures | 2053.9 | 2056.24 | 2053.9 | 2055.2 | 79760.0 |
| 2014-07-25 12:00:00 | ES | Futures | 2055.2 | 2057.29 | 2055.2 | 2056.24 | 53243.0 |
| 2014-07-25 12:30:00 | ES | Futures | 2056.5 | 2058.07 | 2055.72 | 2057.55 | 47277.0 |
| 2014-07-25 13:00:00 | ES | Futures | 2057.55 | 2057.55 | 2054.94 | 2055.98 | 56322.0 |
| 2014-07-25 13:30:00 | ES | Futures | 2055.98 | 2055.98 | 2053.64 | 2053.64 | 56366.0 |
| 2014-07-25 14:00:00 | ES | Futures | 2053.9 | 2057.03 | 2052.6 | 2056.24 | 62979.0 |
| 2014-07-25 14:30:00 | ES | Futures | 2056.5 | 2057.55 | 2054.94 | 2055.98 | 40044.0 |
| 2014-07-25 15:00:00 | ES | Futures | 2055.98 | 2056.24 | 2054.16 | 2054.42 | 74593.0 |
| 2014-07-25 15:30:00 | ES | Futures | 2054.42 | 2056.24 | 2053.38 | 2055.98 | 138930.0 |
| 2014-07-25 16:00:00 | ES | Futures | 2055.98 | 2056.24 | 2054.68 | 2054.68 | 73921.0 |
| 2014-07-25 16:30:00 | ES | Futures | 2054.94 | 2055.2 | 2054.68 | 2054.94 | 6227.0 |
| 2014-07-25 17:00:00 | ES | Futures | 2054.94 | 2054.94 | 2054.16 | 2054.42 | 1845.0 |
| 2014-07-25 00:00:00 | NQ | Futures | 4627.85 | 4628.43 | 4627.56 | 4628.14 | 80.0 |
| 2014-07-25 00:30:00 | NQ | Futures | 4628.14 | 4628.43 | 4624.93 | 4624.93 | 178.0 |
| 2014-07-25 01:00:00 | NQ | Futures | 4625.51 | 4628.72 | 4625.22 | 4627.26 | 205.0 |
| 2014-07-25 01:30:00 | NQ | Futures | 4627.26 | 4629.31 | 4627.26 | 4628.72 | 152.0 |
| 2014-07-25 02:00:00 | NQ | Futures | 4629.31 | 4630.18 | 4628.14 | 4629.02 | 459.0 |
| 2014-07-25 02:30:00 | NQ | Futures | 4629.31 | 4631.35 | 4628.14 | 4631.06 | 264.0 |
| 2014-07-25 03:00:00 | NQ | Futures | 4631.06 | 4631.94 | 4626.97 | 4629.02 | 1724.0 |
| 2014-07-25 03:30:00 | NQ | Futures | 4628.72 | 4630.48 | 4627.85 | 4629.89 | 1123.0 |
| 2014-07-25 04:00:00 | NQ | Futures | 4629.6 | 4631.35 | 4628.14 | 4630.48 | 1340.0 |
| 2014-07-25 04:30:00 | NQ | Futures | 4630.48 | 4631.35 | 4627.85 | 4628.43 | 1717.0 |
| 2014-07-25 05:00:00 | NQ | Futures | 4628.14 | 4629.6 | 4623.76 | 4626.1 | 2129.0 |
| 2014-07-25 05:30:00 | NQ | Futures | 4625.8 | 4625.8 | 4623.18 | 4623.18 | 948.0 |
| 2014-07-25 06:00:00 | NQ | Futures | 4623.18 | 4624.93 | 4619.96 | 4622.01 | 1821.0 |
| 2014-07-25 06:30:00 | NQ | Futures | 4621.72 | 4625.8 | 4620.26 | 4624.05 | 1643.0 |
| 2014-07-25 07:00:00 | NQ | Futures | 4624.05 | 4625.51 | 4622.01 | 4624.64 | 1293.0 |
> showing 50 of 2,319 rows — these rows as CSV