PREVIEW / futures_30min / 2014-11-14
file: by_date/futures_30min/2014/2014-11-14.parquet size: 67 KB rows: 2,373
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-11-14 00:00:00 | ES | Futures | 2131.63 | 2132.68 | 2131.37 | 2132.15 | 917.0 |
| 2014-11-14 00:30:00 | ES | Futures | 2132.15 | 2132.94 | 2131.63 | 2132.94 | 1375.0 |
| 2014-11-14 01:00:00 | ES | Futures | 2132.94 | 2132.94 | 2132.15 | 2132.41 | 392.0 |
| 2014-11-14 01:30:00 | ES | Futures | 2132.41 | 2133.2 | 2132.41 | 2132.94 | 735.0 |
| 2014-11-14 02:00:00 | ES | Futures | 2133.2 | 2136.08 | 2133.2 | 2135.03 | 7636.0 |
| 2014-11-14 02:30:00 | ES | Futures | 2135.03 | 2136.34 | 2134.51 | 2135.3 | 3849.0 |
| 2014-11-14 03:00:00 | ES | Futures | 2135.03 | 2135.3 | 2131.1 | 2132.68 | 16559.0 |
| 2014-11-14 03:30:00 | ES | Futures | 2132.68 | 2134.25 | 2130.32 | 2131.37 | 10392.0 |
| 2014-11-14 04:00:00 | ES | Futures | 2131.1 | 2136.61 | 2131.1 | 2134.25 | 12911.0 |
| 2014-11-14 04:30:00 | ES | Futures | 2134.25 | 2135.56 | 2133.2 | 2135.3 | 9131.0 |
| 2014-11-14 05:00:00 | ES | Futures | 2135.3 | 2136.08 | 2133.99 | 2134.25 | 5472.0 |
| 2014-11-14 05:30:00 | ES | Futures | 2134.51 | 2135.03 | 2133.46 | 2133.99 | 5330.0 |
| 2014-11-14 06:00:00 | ES | Futures | 2133.99 | 2134.77 | 2131.37 | 2131.89 | 9533.0 |
| 2014-11-14 06:30:00 | ES | Futures | 2131.89 | 2132.41 | 2130.06 | 2131.63 | 18147.0 |
| 2014-11-14 07:00:00 | ES | Futures | 2131.89 | 2132.41 | 2130.58 | 2131.89 | 10861.0 |
| 2014-11-14 07:30:00 | ES | Futures | 2131.89 | 2132.41 | 2129.79 | 2131.89 | 11708.0 |
| 2014-11-14 08:00:00 | ES | Futures | 2131.89 | 2133.99 | 2131.63 | 2132.68 | 13608.0 |
| 2014-11-14 08:30:00 | ES | Futures | 2132.68 | 2135.56 | 2131.63 | 2132.94 | 29283.0 |
| 2014-11-14 09:00:00 | ES | Futures | 2132.94 | 2133.72 | 2131.63 | 2133.46 | 20673.0 |
| 2014-11-14 09:30:00 | ES | Futures | 2133.2 | 2135.03 | 2130.58 | 2133.46 | 113026.0 |
| 2014-11-14 10:00:00 | ES | Futures | 2133.2 | 2137.39 | 2131.89 | 2132.94 | 112684.0 |
| 2014-11-14 10:30:00 | ES | Futures | 2132.68 | 2135.82 | 2129.53 | 2135.03 | 111472.0 |
| 2014-11-14 11:00:00 | ES | Futures | 2135.3 | 2136.34 | 2133.72 | 2134.25 | 52698.0 |
| 2014-11-14 11:30:00 | ES | Futures | 2134.25 | 2135.82 | 2132.41 | 2133.72 | 61116.0 |
| 2014-11-14 12:00:00 | ES | Futures | 2133.72 | 2135.03 | 2132.41 | 2133.99 | 39282.0 |
| 2014-11-14 12:30:00 | ES | Futures | 2134.25 | 2135.03 | 2132.94 | 2132.94 | 24280.0 |
| 2014-11-14 13:00:00 | ES | Futures | 2133.2 | 2133.99 | 2131.89 | 2132.68 | 25221.0 |
| 2014-11-14 13:30:00 | ES | Futures | 2132.68 | 2133.46 | 2130.58 | 2130.58 | 28328.0 |
| 2014-11-14 14:00:00 | ES | Futures | 2130.84 | 2132.41 | 2129.27 | 2131.89 | 49162.0 |
| 2014-11-14 14:30:00 | ES | Futures | 2131.89 | 2132.94 | 2130.84 | 2131.37 | 31992.0 |
| 2014-11-14 15:00:00 | ES | Futures | 2131.63 | 2133.2 | 2131.37 | 2133.2 | 31038.0 |
| 2014-11-14 15:30:00 | ES | Futures | 2133.2 | 2135.03 | 2132.41 | 2134.77 | 95717.0 |
| 2014-11-14 16:00:00 | ES | Futures | 2134.77 | 2135.82 | 2133.99 | 2135.82 | 47999.0 |
| 2014-11-14 16:30:00 | ES | Futures | 2135.56 | 2136.34 | 2134.77 | 2136.08 | 7009.0 |
| 2014-11-14 17:00:00 | ES | Futures | 2136.08 | 2136.87 | 2135.82 | 2136.87 | 2003.0 |
| 2014-11-14 00:00:00 | NQ | Futures | 4931.29 | 4934.22 | 4931.29 | 4933.34 | 165.0 |
| 2014-11-14 00:30:00 | NQ | Futures | 4933.34 | 4935.39 | 4931.87 | 4935.1 | 224.0 |
| 2014-11-14 01:00:00 | NQ | Futures | 4935.39 | 4935.68 | 4932.75 | 4933.63 | 108.0 |
| 2014-11-14 01:30:00 | NQ | Futures | 4933.63 | 4934.51 | 4933.63 | 4934.51 | 105.0 |
| 2014-11-14 02:00:00 | NQ | Futures | 4934.51 | 4943.3 | 4934.51 | 4940.66 | 953.0 |
| 2014-11-14 02:30:00 | NQ | Futures | 4940.66 | 4942.42 | 4939.2 | 4939.49 | 438.0 |
| 2014-11-14 03:00:00 | NQ | Futures | 4939.78 | 4939.78 | 4930.11 | 4934.22 | 1986.0 |
| 2014-11-14 03:30:00 | NQ | Futures | 4933.63 | 4938.03 | 4928.36 | 4929.82 | 1537.0 |
| 2014-11-14 04:00:00 | NQ | Futures | 4929.53 | 4941.83 | 4928.65 | 4935.97 | 2162.0 |
| 2014-11-14 04:30:00 | NQ | Futures | 4935.97 | 4938.61 | 4933.34 | 4937.73 | 1151.0 |
| 2014-11-14 05:00:00 | NQ | Futures | 4937.44 | 4940.66 | 4935.97 | 4936.85 | 1037.0 |
| 2014-11-14 05:30:00 | NQ | Futures | 4937.15 | 4938.61 | 4934.22 | 4935.39 | 953.0 |
| 2014-11-14 06:00:00 | NQ | Futures | 4935.68 | 4937.44 | 4929.82 | 4931.29 | 1155.0 |
| 2014-11-14 06:30:00 | NQ | Futures | 4931.29 | 4932.75 | 4928.36 | 4931.87 | 2074.0 |
| 2014-11-14 07:00:00 | NQ | Futures | 4931.87 | 4934.22 | 4929.24 | 4932.46 | 1176.0 |
> showing 50 of 2,373 rows — these rows as CSV