PREVIEW / futures_1hour / 2011-05-30
file: by_date/futures_1hour/2011/2011-05-30.parquet size: 29 KB rows: 865
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-30 00:00:00 | ES | Futures | 1321.9 | 1322.15 | 1320.91 | 1321.15 | 1504.0 |
| 2011-05-30 01:00:00 | ES | Futures | 1321.15 | 1321.65 | 1320.66 | 1321.15 | 1926.0 |
| 2011-05-30 02:00:00 | ES | Futures | 1321.15 | 1322.15 | 1319.91 | 1321.9 | 5552.0 |
| 2011-05-30 03:00:00 | ES | Futures | 1321.9 | 1324.63 | 1321.9 | 1323.14 | 7553.0 |
| 2011-05-30 04:00:00 | ES | Futures | 1323.14 | 1323.89 | 1322.64 | 1323.39 | 2761.0 |
| 2011-05-30 05:00:00 | ES | Futures | 1323.64 | 1324.63 | 1323.14 | 1323.64 | 2174.0 |
| 2011-05-30 06:00:00 | ES | Futures | 1323.64 | 1324.38 | 1323.39 | 1324.13 | 1373.0 |
| 2011-05-30 07:00:00 | ES | Futures | 1324.38 | 1324.38 | 1323.64 | 1323.64 | 1162.0 |
| 2011-05-30 08:00:00 | ES | Futures | 1323.64 | 1323.89 | 1323.14 | 1323.64 | 1742.0 |
| 2011-05-30 09:00:00 | ES | Futures | 1323.64 | 1323.89 | 1323.14 | 1323.39 | 3980.0 |
| 2011-05-30 10:00:00 | ES | Futures | 1323.39 | 1323.39 | 1321.9 | 1322.15 | 4704.0 |
| 2011-05-30 11:00:00 | ES | Futures | 1322.4 | 1322.89 | 1321.65 | 1322.15 | 2617.0 |
| 2011-05-30 18:00:00 | ES | Futures | 1322.64 | 1324.63 | 1322.4 | 1324.38 | 2789.0 |
| 2011-05-30 19:00:00 | ES | Futures | 1324.38 | 1324.63 | 1323.89 | 1324.63 | 2167.0 |
| 2011-05-30 20:00:00 | ES | Futures | 1324.38 | 1328.11 | 1324.13 | 1327.86 | 10954.0 |
| 2011-05-30 21:00:00 | ES | Futures | 1327.86 | 1329.6 | 1327.61 | 1329.6 | 10228.0 |
| 2011-05-30 22:00:00 | ES | Futures | 1329.6 | 1331.34 | 1329.1 | 1330.1 | 9793.0 |
| 2011-05-30 23:00:00 | ES | Futures | 1329.85 | 1330.1 | 1329.1 | 1329.1 | 2460.0 |
| 2011-05-30 00:00:00 | NQ | Futures | 2681.8 | 2681.8 | 2680.07 | 2680.36 | 120.0 |
| 2011-05-30 01:00:00 | NQ | Futures | 2680.07 | 2680.93 | 2679.21 | 2680.07 | 111.0 |
| 2011-05-30 02:00:00 | NQ | Futures | 2680.07 | 2681.8 | 2678.64 | 2681.22 | 351.0 |
| 2011-05-30 03:00:00 | NQ | Futures | 2681.22 | 2684.96 | 2680.93 | 2683.23 | 648.0 |
| 2011-05-30 04:00:00 | NQ | Futures | 2682.95 | 2685.53 | 2682.66 | 2684.09 | 210.0 |
| 2011-05-30 05:00:00 | NQ | Futures | 2684.67 | 2686.39 | 2681.8 | 2682.37 | 530.0 |
| 2011-05-30 06:00:00 | NQ | Futures | 2682.66 | 2684.67 | 2682.37 | 2683.52 | 185.0 |
| 2011-05-30 07:00:00 | NQ | Futures | 2684.09 | 2684.38 | 2683.52 | 2683.81 | 149.0 |
| 2011-05-30 08:00:00 | NQ | Futures | 2683.52 | 2684.38 | 2682.95 | 2683.81 | 427.0 |
| 2011-05-30 09:00:00 | NQ | Futures | 2684.09 | 2685.82 | 2682.66 | 2683.23 | 732.0 |
| 2011-05-30 10:00:00 | NQ | Futures | 2683.23 | 2683.81 | 2680.65 | 2682.37 | 592.0 |
| 2011-05-30 11:00:00 | NQ | Futures | 2682.95 | 2683.52 | 2680.07 | 2681.22 | 405.0 |
| 2011-05-30 18:00:00 | NQ | Futures | 2682.66 | 2686.97 | 2682.66 | 2686.39 | 231.0 |
| 2011-05-30 19:00:00 | NQ | Futures | 2686.11 | 2687.83 | 2685.82 | 2687.26 | 153.0 |
| 2011-05-30 20:00:00 | NQ | Futures | 2686.68 | 2694.15 | 2686.11 | 2693.58 | 819.0 |
| 2011-05-30 21:00:00 | NQ | Futures | 2693.58 | 2697.6 | 2693.58 | 2697.6 | 950.0 |
| 2011-05-30 22:00:00 | NQ | Futures | 2697.31 | 2700.76 | 2696.16 | 2697.02 | 1032.0 |
| 2011-05-30 23:00:00 | NQ | Futures | 2697.31 | 2698.46 | 2696.45 | 2697.02 | 258.0 |
| 2011-05-30 00:00:00 | YM | Futures | 11979.2 | 11980.1 | 11974.4 | 11974.4 | 48.0 |
| 2011-05-30 01:00:00 | YM | Futures | 11973.4 | 11977.2 | 11969.5 | 11970.5 | 84.0 |
| 2011-05-30 02:00:00 | YM | Futures | 11970.5 | 11976.3 | 11962.8 | 11975.3 | 272.0 |
| 2011-05-30 03:00:00 | YM | Futures | 11974.4 | 11999.4 | 11974.4 | 11986.9 | 340.0 |
| 2011-05-30 04:00:00 | YM | Futures | 11985.9 | 11994.6 | 11982.1 | 11990.7 | 279.0 |
| 2011-05-30 05:00:00 | YM | Futures | 11994.6 | 11997.5 | 11989.8 | 11991.7 | 133.0 |
| 2011-05-30 06:00:00 | YM | Futures | 11991.7 | 11994.6 | 11988.8 | 11993.6 | 111.0 |
| 2011-05-30 07:00:00 | YM | Futures | 11994.6 | 11994.6 | 11991.7 | 11993.6 | 36.0 |
| 2011-05-30 08:00:00 | YM | Futures | 11992.7 | 11992.7 | 11988.8 | 11991.7 | 108.0 |
| 2011-05-30 09:00:00 | YM | Futures | 11991.7 | 11992.7 | 11983.0 | 11990.7 | 212.0 |
| 2011-05-30 10:00:00 | YM | Futures | 11988.8 | 11989.8 | 11974.4 | 11977.2 | 349.0 |
| 2011-05-30 11:00:00 | YM | Futures | 11977.2 | 11982.1 | 11974.4 | 11974.4 | 70.0 |
| 2011-05-30 18:00:00 | YM | Futures | 11982.1 | 11997.5 | 11982.1 | 11997.5 | 155.0 |
| 2011-05-30 19:00:00 | YM | Futures | 11997.5 | 12005.2 | 11995.5 | 12001.3 | 257.0 |
> showing 50 of 865 rows — these rows as CSV