PREVIEW / futures_1hour / 2009-11-26
file: by_date/futures_1hour/2009/2009-11-26.parquet size: 34 KB rows: 929
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-26 00:00:00 | ES | Futures | 1071.1 | 1071.35 | 1069.41 | 1069.65 | 3457.0 |
| 2009-11-26 01:00:00 | ES | Futures | 1069.65 | 1070.62 | 1069.17 | 1069.89 | 3296.0 |
| 2009-11-26 02:00:00 | ES | Futures | 1069.89 | 1070.14 | 1066.99 | 1068.68 | 10235.0 |
| 2009-11-26 03:00:00 | ES | Futures | 1068.92 | 1069.17 | 1062.87 | 1063.6 | 38522.0 |
| 2009-11-26 04:00:00 | ES | Futures | 1063.35 | 1063.84 | 1060.2 | 1061.42 | 36762.0 |
| 2009-11-26 05:00:00 | ES | Futures | 1061.66 | 1062.63 | 1058.02 | 1061.42 | 25481.0 |
| 2009-11-26 06:00:00 | ES | Futures | 1061.42 | 1063.6 | 1061.17 | 1062.63 | 13150.0 |
| 2009-11-26 07:00:00 | ES | Futures | 1062.38 | 1063.35 | 1061.66 | 1063.11 | 8642.0 |
| 2009-11-26 08:00:00 | ES | Futures | 1063.11 | 1063.6 | 1061.17 | 1061.9 | 7480.0 |
| 2009-11-26 09:00:00 | ES | Futures | 1061.9 | 1062.14 | 1052.21 | 1053.91 | 43248.0 |
| 2009-11-26 10:00:00 | ES | Futures | 1054.15 | 1056.09 | 1049.3 | 1049.55 | 41529.0 |
| 2009-11-26 11:00:00 | ES | Futures | 1049.3 | 1052.7 | 1049.3 | 1051.0 | 32145.0 |
| 2009-11-26 18:00:00 | ES | Futures | 1052.7 | 1054.63 | 1050.03 | 1051.97 | 14836.0 |
| 2009-11-26 19:00:00 | ES | Futures | 1051.73 | 1053.66 | 1051.0 | 1052.21 | 6639.0 |
| 2009-11-26 20:00:00 | ES | Futures | 1051.97 | 1052.21 | 1050.03 | 1050.27 | 5448.0 |
| 2009-11-26 21:00:00 | ES | Futures | 1050.27 | 1052.7 | 1049.06 | 1051.48 | 7668.0 |
| 2009-11-26 22:00:00 | ES | Futures | 1051.97 | 1053.18 | 1051.0 | 1051.73 | 3361.0 |
| 2009-11-26 23:00:00 | ES | Futures | 1051.48 | 1051.73 | 1043.98 | 1044.94 | 13629.0 |
| 2009-11-26 00:00:00 | NQ | Futures | 2039.42 | 2039.99 | 2036.57 | 2036.86 | 82.0 |
| 2009-11-26 01:00:00 | NQ | Futures | 2036.86 | 2038.85 | 2035.43 | 2036.86 | 301.0 |
| 2009-11-26 02:00:00 | NQ | Futures | 2037.14 | 2037.71 | 2032.58 | 2035.15 | 873.0 |
| 2009-11-26 03:00:00 | NQ | Futures | 2035.43 | 2035.72 | 2024.59 | 2024.88 | 2166.0 |
| 2009-11-26 04:00:00 | NQ | Futures | 2024.88 | 2028.02 | 2021.74 | 2024.31 | 3827.0 |
| 2009-11-26 05:00:00 | NQ | Futures | 2024.88 | 2026.87 | 2018.32 | 2024.88 | 1036.0 |
| 2009-11-26 06:00:00 | NQ | Futures | 2025.16 | 2029.16 | 2024.31 | 2026.3 | 765.0 |
| 2009-11-26 07:00:00 | NQ | Futures | 2026.87 | 2028.87 | 2025.16 | 2028.87 | 535.0 |
| 2009-11-26 08:00:00 | NQ | Futures | 2028.59 | 2028.87 | 2024.31 | 2026.59 | 584.0 |
| 2009-11-26 09:00:00 | NQ | Futures | 2026.3 | 2026.3 | 2004.91 | 2007.2 | 6308.0 |
| 2009-11-26 10:00:00 | NQ | Futures | 2007.48 | 2010.9 | 1994.93 | 1994.93 | 5731.0 |
| 2009-11-26 11:00:00 | NQ | Futures | 1994.93 | 1999.5 | 1992.37 | 1996.07 | 3432.0 |
| 2009-11-26 18:00:00 | NQ | Futures | 1999.21 | 2002.63 | 1994.08 | 1996.07 | 742.0 |
| 2009-11-26 19:00:00 | NQ | Futures | 1997.5 | 1999.21 | 1996.07 | 1996.36 | 127.0 |
| 2009-11-26 20:00:00 | NQ | Futures | 1996.93 | 1997.21 | 1994.65 | 1995.22 | 125.0 |
| 2009-11-26 21:00:00 | NQ | Futures | 1995.5 | 1998.36 | 1992.94 | 1998.07 | 287.0 |
| 2009-11-26 22:00:00 | NQ | Futures | 1998.07 | 2000.64 | 1996.36 | 1997.21 | 416.0 |
| 2009-11-26 23:00:00 | NQ | Futures | 1997.5 | 1997.5 | 1985.81 | 1986.38 | 1015.0 |
| 2009-11-26 00:00:00 | YM | Futures | 9684.2 | 9684.2 | 9673.9 | 9673.9 | 164.0 |
| 2009-11-26 01:00:00 | YM | Futures | 9675.8 | 9683.2 | 9670.2 | 9676.7 | 468.0 |
| 2009-11-26 02:00:00 | YM | Futures | 9677.6 | 9679.5 | 9654.4 | 9666.5 | 908.0 |
| 2009-11-26 03:00:00 | YM | Futures | 9667.4 | 9671.1 | 9623.7 | 9629.3 | 2561.0 |
| 2009-11-26 04:00:00 | YM | Futures | 9629.3 | 9631.1 | 9604.2 | 9611.6 | 1851.0 |
| 2009-11-26 05:00:00 | YM | Futures | 9615.3 | 9641.4 | 9589.3 | 9623.7 | 1802.0 |
| 2009-11-26 06:00:00 | YM | Futures | 9623.7 | 9641.4 | 9622.8 | 9628.3 | 841.0 |
| 2009-11-26 07:00:00 | YM | Futures | 9629.3 | 9634.9 | 9620.9 | 9633.9 | 591.0 |
| 2009-11-26 08:00:00 | YM | Futures | 9633.0 | 9635.8 | 9616.2 | 9624.6 | 770.0 |
| 2009-11-26 09:00:00 | YM | Futures | 9624.6 | 9624.6 | 9551.1 | 9566.0 | 4423.0 |
| 2009-11-26 10:00:00 | YM | Futures | 9565.1 | 9579.0 | 9529.7 | 9529.7 | 3574.0 |
| 2009-11-26 11:00:00 | YM | Futures | 9528.8 | 9553.9 | 9527.0 | 9544.6 | 1477.0 |
| 2009-11-26 18:00:00 | YM | Futures | 9549.3 | 9562.3 | 9536.3 | 9542.8 | 473.0 |
| 2009-11-26 19:00:00 | YM | Futures | 9544.6 | 9556.7 | 9539.0 | 9542.8 | 385.0 |
> showing 50 of 929 rows — these rows as CSV