PREVIEW / futures_1hour / 2009-12-04
file: by_date/futures_1hour/2009/2009-12-04.parquet size: 39 KB rows: 1,112
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-12-04 00:00:00 | ES | Futures | 1063.35 | 1064.08 | 1062.14 | 1062.87 | 4556.0 |
| 2009-12-04 01:00:00 | ES | Futures | 1063.11 | 1064.32 | 1062.63 | 1064.08 | 2437.0 |
| 2009-12-04 02:00:00 | ES | Futures | 1064.32 | 1066.02 | 1064.08 | 1065.78 | 8905.0 |
| 2009-12-04 03:00:00 | ES | Futures | 1065.78 | 1066.74 | 1064.56 | 1065.05 | 25430.0 |
| 2009-12-04 04:00:00 | ES | Futures | 1064.81 | 1066.26 | 1064.32 | 1065.53 | 16281.0 |
| 2009-12-04 05:00:00 | ES | Futures | 1065.53 | 1066.5 | 1064.81 | 1066.26 | 7600.0 |
| 2009-12-04 06:00:00 | ES | Futures | 1066.26 | 1066.5 | 1065.05 | 1065.53 | 8515.0 |
| 2009-12-04 07:00:00 | ES | Futures | 1065.53 | 1066.5 | 1065.29 | 1065.53 | 13664.0 |
| 2009-12-04 08:00:00 | ES | Futures | 1065.53 | 1079.34 | 1064.56 | 1076.43 | 252371.0 |
| 2009-12-04 09:00:00 | ES | Futures | 1076.19 | 1084.18 | 1074.5 | 1082.0 | 405806.0 |
| 2009-12-04 10:00:00 | ES | Futures | 1082.25 | 1082.97 | 1076.19 | 1077.16 | 367222.0 |
| 2009-12-04 11:00:00 | ES | Futures | 1076.92 | 1077.64 | 1061.17 | 1066.02 | 593699.0 |
| 2009-12-04 12:00:00 | ES | Futures | 1066.26 | 1070.62 | 1065.53 | 1069.41 | 205017.0 |
| 2009-12-04 13:00:00 | ES | Futures | 1069.41 | 1071.35 | 1063.84 | 1064.81 | 210938.0 |
| 2009-12-04 14:00:00 | ES | Futures | 1064.81 | 1068.44 | 1061.42 | 1067.71 | 268782.0 |
| 2009-12-04 15:00:00 | ES | Futures | 1067.71 | 1072.32 | 1066.74 | 1070.62 | 345772.0 |
| 2009-12-04 16:00:00 | ES | Futures | 1070.62 | 1074.01 | 1070.38 | 1073.77 | 131205.0 |
| 2009-12-04 00:00:00 | NQ | Futures | 2028.87 | 2029.44 | 2027.16 | 2028.59 | 166.0 |
| 2009-12-04 01:00:00 | NQ | Futures | 2028.59 | 2030.87 | 2027.45 | 2030.87 | 302.0 |
| 2009-12-04 02:00:00 | NQ | Futures | 2031.15 | 2034.58 | 2031.15 | 2034.58 | 687.0 |
| 2009-12-04 03:00:00 | NQ | Futures | 2034.29 | 2035.72 | 2031.72 | 2032.29 | 2026.0 |
| 2009-12-04 04:00:00 | NQ | Futures | 2032.29 | 2033.15 | 2030.01 | 2032.29 | 1099.0 |
| 2009-12-04 05:00:00 | NQ | Futures | 2032.01 | 2033.43 | 2030.3 | 2033.15 | 498.0 |
| 2009-12-04 06:00:00 | NQ | Futures | 2033.43 | 2033.72 | 2031.15 | 2031.72 | 482.0 |
| 2009-12-04 07:00:00 | NQ | Futures | 2031.72 | 2033.43 | 2031.72 | 2032.58 | 795.0 |
| 2009-12-04 08:00:00 | NQ | Futures | 2032.29 | 2060.53 | 2031.15 | 2055.96 | 17348.0 |
| 2009-12-04 09:00:00 | NQ | Futures | 2055.96 | 2071.94 | 2053.4 | 2068.8 | 57927.0 |
| 2009-12-04 10:00:00 | NQ | Futures | 2069.08 | 2070.51 | 2062.24 | 2063.66 | 56192.0 |
| 2009-12-04 11:00:00 | NQ | Futures | 2063.38 | 2063.66 | 2022.31 | 2033.15 | 91589.0 |
| 2009-12-04 12:00:00 | NQ | Futures | 2033.43 | 2041.13 | 2032.01 | 2038.57 | 39970.0 |
| 2009-12-04 13:00:00 | NQ | Futures | 2038.57 | 2041.7 | 2030.01 | 2031.44 | 33060.0 |
| 2009-12-04 14:00:00 | NQ | Futures | 2031.72 | 2039.99 | 2025.45 | 2038.85 | 40956.0 |
| 2009-12-04 15:00:00 | NQ | Futures | 2038.57 | 2048.26 | 2036.29 | 2043.13 | 51360.0 |
| 2009-12-04 16:00:00 | NQ | Futures | 2042.85 | 2049.41 | 2042.28 | 2047.41 | 10753.0 |
| 2009-12-04 00:00:00 | YM | Futures | 9627.4 | 9633.0 | 9619.0 | 9624.6 | 273.0 |
| 2009-12-04 01:00:00 | YM | Futures | 9624.6 | 9633.9 | 9620.0 | 9633.0 | 386.0 |
| 2009-12-04 02:00:00 | YM | Futures | 9634.9 | 9647.9 | 9634.9 | 9646.0 | 605.0 |
| 2009-12-04 03:00:00 | YM | Futures | 9645.1 | 9652.5 | 9634.9 | 9637.6 | 1271.0 |
| 2009-12-04 04:00:00 | YM | Futures | 9637.6 | 9645.1 | 9630.2 | 9641.4 | 558.0 |
| 2009-12-04 05:00:00 | YM | Futures | 9644.2 | 9645.1 | 9635.8 | 9644.2 | 469.0 |
| 2009-12-04 06:00:00 | YM | Futures | 9646.0 | 9646.9 | 9637.6 | 9642.3 | 744.0 |
| 2009-12-04 07:00:00 | YM | Futures | 9643.2 | 9653.5 | 9641.4 | 9644.2 | 1103.0 |
| 2009-12-04 08:00:00 | YM | Futures | 9643.2 | 9756.7 | 9638.6 | 9732.5 | 13309.0 |
| 2009-12-04 09:00:00 | YM | Futures | 9733.5 | 9775.3 | 9719.5 | 9762.3 | 25913.0 |
| 2009-12-04 10:00:00 | YM | Futures | 9763.2 | 9767.9 | 9722.3 | 9727.9 | 28020.0 |
| 2009-12-04 11:00:00 | YM | Futures | 9729.7 | 9729.7 | 9580.9 | 9620.0 | 50819.0 |
| 2009-12-04 12:00:00 | YM | Futures | 9619.0 | 9657.2 | 9615.3 | 9650.7 | 16392.0 |
| 2009-12-04 13:00:00 | YM | Futures | 9650.7 | 9666.5 | 9603.2 | 9610.7 | 14311.0 |
| 2009-12-04 14:00:00 | YM | Futures | 9611.6 | 9643.2 | 9588.3 | 9637.6 | 20896.0 |
| 2009-12-04 15:00:00 | YM | Futures | 9636.7 | 9671.1 | 9632.1 | 9653.5 | 25979.0 |
> showing 50 of 1,112 rows — these rows as CSV