PREVIEW / futures_1hour / 2012-02-10
file: by_date/futures_1hour/2012/2012-02-10.parquet size: 41 KB rows: 1,201
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-10 00:00:00 | ES | Futures | 1352.92 | 1353.18 | 1351.66 | 1352.92 | 7281.0 |
| 2012-02-10 01:00:00 | ES | Futures | 1352.92 | 1353.43 | 1352.17 | 1352.67 | 3974.0 |
| 2012-02-10 02:00:00 | ES | Futures | 1352.42 | 1353.43 | 1350.66 | 1350.91 | 14412.0 |
| 2012-02-10 03:00:00 | ES | Futures | 1350.91 | 1352.67 | 1349.9 | 1352.42 | 35308.0 |
| 2012-02-10 04:00:00 | ES | Futures | 1352.42 | 1353.68 | 1351.41 | 1352.17 | 18260.0 |
| 2012-02-10 05:00:00 | ES | Futures | 1352.17 | 1352.17 | 1349.65 | 1351.16 | 24379.0 |
| 2012-02-10 06:00:00 | ES | Futures | 1351.16 | 1351.66 | 1349.65 | 1350.4 | 16741.0 |
| 2012-02-10 07:00:00 | ES | Futures | 1350.15 | 1350.4 | 1345.36 | 1347.63 | 81214.0 |
| 2012-02-10 08:00:00 | ES | Futures | 1347.63 | 1348.89 | 1344.86 | 1346.88 | 73796.0 |
| 2012-02-10 09:00:00 | ES | Futures | 1346.88 | 1349.65 | 1345.87 | 1346.37 | 219837.0 |
| 2012-02-10 10:00:00 | ES | Futures | 1346.37 | 1348.39 | 1344.36 | 1347.88 | 338925.0 |
| 2012-02-10 11:00:00 | ES | Futures | 1348.14 | 1350.15 | 1347.13 | 1348.89 | 167423.0 |
| 2012-02-10 12:00:00 | ES | Futures | 1348.89 | 1350.91 | 1348.14 | 1350.4 | 96342.0 |
| 2012-02-10 13:00:00 | ES | Futures | 1350.4 | 1350.66 | 1345.62 | 1345.87 | 99335.0 |
| 2012-02-10 14:00:00 | ES | Futures | 1345.87 | 1348.14 | 1345.62 | 1347.13 | 85928.0 |
| 2012-02-10 15:00:00 | ES | Futures | 1347.13 | 1350.15 | 1344.61 | 1349.9 | 292560.0 |
| 2012-02-10 16:00:00 | ES | Futures | 1349.65 | 1351.92 | 1349.65 | 1350.91 | 100767.0 |
| 2012-02-10 00:00:00 | NQ | Futures | 2949.21 | 2950.36 | 2947.48 | 2949.5 | 659.0 |
| 2012-02-10 01:00:00 | NQ | Futures | 2949.5 | 2950.36 | 2948.05 | 2949.21 | 445.0 |
| 2012-02-10 02:00:00 | NQ | Futures | 2949.21 | 2949.79 | 2945.74 | 2946.03 | 1131.0 |
| 2012-02-10 03:00:00 | NQ | Futures | 2946.03 | 2949.21 | 2942.86 | 2947.76 | 2494.0 |
| 2012-02-10 04:00:00 | NQ | Futures | 2947.76 | 2949.79 | 2944.3 | 2947.48 | 1367.0 |
| 2012-02-10 05:00:00 | NQ | Futures | 2946.9 | 2947.76 | 2943.14 | 2946.32 | 796.0 |
| 2012-02-10 06:00:00 | NQ | Futures | 2946.32 | 2947.19 | 2942.86 | 2943.72 | 1202.0 |
| 2012-02-10 07:00:00 | NQ | Futures | 2943.72 | 2943.72 | 2932.46 | 2935.06 | 7089.0 |
| 2012-02-10 08:00:00 | NQ | Futures | 2935.06 | 2938.23 | 2933.04 | 2936.5 | 7221.0 |
| 2012-02-10 09:00:00 | NQ | Futures | 2936.79 | 2943.14 | 2931.88 | 2934.19 | 36753.0 |
| 2012-02-10 10:00:00 | NQ | Futures | 2933.9 | 2942.28 | 2928.7 | 2941.12 | 48850.0 |
| 2012-02-10 11:00:00 | NQ | Futures | 2941.41 | 2945.45 | 2939.1 | 2942.86 | 21857.0 |
| 2012-02-10 12:00:00 | NQ | Futures | 2942.86 | 2947.19 | 2941.41 | 2946.03 | 15262.0 |
| 2012-02-10 13:00:00 | NQ | Futures | 2946.03 | 2946.03 | 2934.19 | 2934.77 | 18974.0 |
| 2012-02-10 14:00:00 | NQ | Futures | 2935.06 | 2940.54 | 2934.48 | 2938.23 | 17987.0 |
| 2012-02-10 15:00:00 | NQ | Futures | 2938.52 | 2939.68 | 2929.28 | 2938.23 | 35428.0 |
| 2012-02-10 16:00:00 | NQ | Futures | 2938.52 | 2946.32 | 2938.23 | 2944.88 | 8333.0 |
| 2012-02-10 00:00:00 | YM | Futures | 12682.6 | 12684.6 | 12668.7 | 12683.6 | 974.0 |
| 2012-02-10 01:00:00 | YM | Futures | 12683.6 | 12688.5 | 12678.6 | 12683.6 | 288.0 |
| 2012-02-10 02:00:00 | YM | Futures | 12681.6 | 12690.5 | 12668.7 | 12671.7 | 1112.0 |
| 2012-02-10 03:00:00 | YM | Futures | 12670.7 | 12681.6 | 12659.8 | 12679.6 | 2474.0 |
| 2012-02-10 04:00:00 | YM | Futures | 12681.6 | 12690.5 | 12671.7 | 12677.6 | 1088.0 |
| 2012-02-10 05:00:00 | YM | Futures | 12676.6 | 12679.6 | 12662.7 | 12673.6 | 2327.0 |
| 2012-02-10 06:00:00 | YM | Futures | 12673.6 | 12680.6 | 12662.7 | 12667.7 | 1747.0 |
| 2012-02-10 07:00:00 | YM | Futures | 12666.7 | 12667.7 | 12628.1 | 12642.9 | 4335.0 |
| 2012-02-10 08:00:00 | YM | Futures | 12642.9 | 12653.8 | 12622.1 | 12636.0 | 4700.0 |
| 2012-02-10 09:00:00 | YM | Futures | 12636.0 | 12649.9 | 12607.2 | 12612.2 | 17348.0 |
| 2012-02-10 10:00:00 | YM | Futures | 12611.2 | 12624.1 | 12591.4 | 12622.1 | 16870.0 |
| 2012-02-10 11:00:00 | YM | Futures | 12622.1 | 12635.0 | 12612.2 | 12624.1 | 7477.0 |
| 2012-02-10 12:00:00 | YM | Futures | 12624.1 | 12632.0 | 12617.2 | 12631.0 | 3828.0 |
| 2012-02-10 13:00:00 | YM | Futures | 12631.0 | 12631.0 | 12595.3 | 12596.3 | 5235.0 |
| 2012-02-10 14:00:00 | YM | Futures | 12597.3 | 12616.2 | 12596.3 | 12611.2 | 4568.0 |
| 2012-02-10 15:00:00 | YM | Futures | 12610.2 | 12651.8 | 12593.4 | 12648.9 | 13006.0 |
> showing 50 of 1,201 rows — these rows as CSV