PREVIEW / futures_1hour / 2011-02-16
file: by_date/futures_1hour/2011/2011-02-16.parquet size: 48 KB rows: 1,464
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-02-16 00:00:00 | ES | Futures | 1317.55 | 1317.8 | 1316.31 | 1316.31 | 4621.0 |
| 2011-02-16 01:00:00 | ES | Futures | 1316.56 | 1318.04 | 1315.82 | 1317.3 | 4172.0 |
| 2011-02-16 02:00:00 | ES | Futures | 1317.3 | 1317.3 | 1316.06 | 1316.56 | 5548.0 |
| 2011-02-16 03:00:00 | ES | Futures | 1316.56 | 1319.03 | 1316.06 | 1318.54 | 23694.0 |
| 2011-02-16 04:00:00 | ES | Futures | 1318.54 | 1319.03 | 1317.3 | 1317.8 | 10438.0 |
| 2011-02-16 05:00:00 | ES | Futures | 1317.8 | 1318.29 | 1316.81 | 1317.05 | 12540.0 |
| 2011-02-16 06:00:00 | ES | Futures | 1317.05 | 1317.55 | 1316.56 | 1317.05 | 8614.0 |
| 2011-02-16 07:00:00 | ES | Futures | 1317.05 | 1317.3 | 1316.56 | 1317.05 | 11635.0 |
| 2011-02-16 08:00:00 | ES | Futures | 1317.3 | 1318.54 | 1316.56 | 1316.81 | 47611.0 |
| 2011-02-16 09:00:00 | ES | Futures | 1316.81 | 1318.54 | 1315.82 | 1318.54 | 194542.0 |
| 2011-02-16 10:00:00 | ES | Futures | 1318.54 | 1322.25 | 1316.31 | 1321.76 | 362563.0 |
| 2011-02-16 11:00:00 | ES | Futures | 1322.0 | 1322.25 | 1317.8 | 1319.28 | 283446.0 |
| 2011-02-16 12:00:00 | ES | Futures | 1319.53 | 1319.78 | 1313.84 | 1318.04 | 253017.0 |
| 2011-02-16 13:00:00 | ES | Futures | 1317.8 | 1320.02 | 1316.81 | 1319.78 | 98755.0 |
| 2011-02-16 14:00:00 | ES | Futures | 1320.02 | 1321.01 | 1316.81 | 1319.53 | 147739.0 |
| 2011-02-16 15:00:00 | ES | Futures | 1319.53 | 1321.51 | 1319.53 | 1320.02 | 193141.0 |
| 2011-02-16 16:00:00 | ES | Futures | 1320.27 | 1321.01 | 1318.79 | 1319.28 | 92421.0 |
| 2011-02-16 17:00:00 | ES | Futures | 1319.53 | 1319.78 | 1318.54 | 1318.54 | 3112.0 |
| 2011-02-16 18:00:00 | ES | Futures | 1318.79 | 1319.28 | 1318.29 | 1318.79 | 3371.0 |
| 2011-02-16 19:00:00 | ES | Futures | 1318.79 | 1319.28 | 1318.29 | 1318.54 | 4299.0 |
| 2011-02-16 20:00:00 | ES | Futures | 1318.54 | 1318.79 | 1317.8 | 1318.29 | 5359.0 |
| 2011-02-16 21:00:00 | ES | Futures | 1318.04 | 1318.54 | 1318.04 | 1318.54 | 1049.0 |
| 2011-02-16 22:00:00 | ES | Futures | 1318.29 | 1319.03 | 1317.55 | 1318.54 | 5232.0 |
| 2011-02-16 23:00:00 | ES | Futures | 1318.79 | 1318.79 | 1318.29 | 1318.54 | 1421.0 |
| 2011-02-16 00:00:00 | NQ | Futures | 2742.6 | 2742.6 | 2740.01 | 2740.01 | 203.0 |
| 2011-02-16 01:00:00 | NQ | Futures | 2740.01 | 2742.88 | 2738.86 | 2741.16 | 302.0 |
| 2011-02-16 02:00:00 | NQ | Futures | 2741.45 | 2741.73 | 2739.15 | 2740.01 | 438.0 |
| 2011-02-16 03:00:00 | NQ | Futures | 2740.01 | 2744.89 | 2739.72 | 2744.03 | 1179.0 |
| 2011-02-16 04:00:00 | NQ | Futures | 2744.03 | 2744.89 | 2742.31 | 2743.74 | 821.0 |
| 2011-02-16 05:00:00 | NQ | Futures | 2743.74 | 2743.74 | 2740.3 | 2741.16 | 881.0 |
| 2011-02-16 06:00:00 | NQ | Futures | 2741.16 | 2742.02 | 2740.01 | 2741.16 | 452.0 |
| 2011-02-16 07:00:00 | NQ | Futures | 2741.45 | 2741.73 | 2740.01 | 2741.73 | 1216.0 |
| 2011-02-16 08:00:00 | NQ | Futures | 2742.02 | 2745.18 | 2740.87 | 2742.02 | 7351.0 |
| 2011-02-16 09:00:00 | NQ | Futures | 2741.73 | 2747.47 | 2739.72 | 2745.18 | 27943.0 |
| 2011-02-16 10:00:00 | NQ | Futures | 2745.18 | 2758.67 | 2742.6 | 2758.67 | 45095.0 |
| 2011-02-16 11:00:00 | NQ | Futures | 2758.67 | 2758.96 | 2750.34 | 2753.5 | 36091.0 |
| 2011-02-16 12:00:00 | NQ | Futures | 2753.5 | 2754.36 | 2740.59 | 2748.91 | 32278.0 |
| 2011-02-16 13:00:00 | NQ | Futures | 2749.2 | 2754.36 | 2746.04 | 2754.08 | 11976.0 |
| 2011-02-16 14:00:00 | NQ | Futures | 2754.36 | 2755.51 | 2746.61 | 2752.93 | 18717.0 |
| 2011-02-16 15:00:00 | NQ | Futures | 2752.93 | 2756.66 | 2750.34 | 2751.49 | 27973.0 |
| 2011-02-16 16:00:00 | NQ | Futures | 2751.49 | 2753.22 | 2743.46 | 2746.33 | 13678.0 |
| 2011-02-16 17:00:00 | NQ | Futures | 2746.61 | 2747.19 | 2745.47 | 2746.04 | 121.0 |
| 2011-02-16 18:00:00 | NQ | Futures | 2746.04 | 2746.33 | 2744.6 | 2745.47 | 454.0 |
| 2011-02-16 19:00:00 | NQ | Futures | 2745.47 | 2745.75 | 2743.74 | 2744.89 | 300.0 |
| 2011-02-16 20:00:00 | NQ | Futures | 2744.6 | 2745.47 | 2743.74 | 2744.03 | 311.0 |
| 2011-02-16 21:00:00 | NQ | Futures | 2744.03 | 2744.89 | 2743.17 | 2744.03 | 216.0 |
| 2011-02-16 22:00:00 | NQ | Futures | 2743.74 | 2745.75 | 2742.02 | 2745.75 | 281.0 |
| 2011-02-16 23:00:00 | NQ | Futures | 2745.47 | 2745.75 | 2744.03 | 2744.6 | 87.0 |
| 2011-02-16 00:00:00 | YM | Futures | 11723.3 | 11723.3 | 11711.8 | 11711.8 | 248.0 |
| 2011-02-16 01:00:00 | YM | Futures | 11711.8 | 11724.2 | 11708.9 | 11717.5 | 189.0 |
> showing 50 of 1,464 rows — these rows as CSV