PREVIEW / futures_1hour / 2008-07-11
file: by_date/futures_1hour/2008/2008-07-11.parquet size: 37 KB rows: 1,005
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-11 00:00:00 | ES | Futures | 1165.8 | 1173.0 | 1164.4 | 1165.8 | 12542.0 |
| 2008-07-11 01:00:00 | ES | Futures | 1165.8 | 1167.89 | 1165.1 | 1167.42 | 2939.0 |
| 2008-07-11 02:00:00 | ES | Futures | 1167.42 | 1168.12 | 1165.1 | 1165.33 | 3646.0 |
| 2008-07-11 03:00:00 | ES | Futures | 1165.56 | 1166.73 | 1162.31 | 1162.54 | 14914.0 |
| 2008-07-11 04:00:00 | ES | Futures | 1162.54 | 1166.49 | 1162.08 | 1164.4 | 10076.0 |
| 2008-07-11 05:00:00 | ES | Futures | 1164.4 | 1165.1 | 1161.61 | 1161.84 | 27384.0 |
| 2008-07-11 06:00:00 | ES | Futures | 1161.84 | 1163.01 | 1156.03 | 1159.29 | 40708.0 |
| 2008-07-11 07:00:00 | ES | Futures | 1159.06 | 1159.75 | 1150.92 | 1154.41 | 69268.0 |
| 2008-07-11 08:00:00 | ES | Futures | 1154.41 | 1155.8 | 1149.99 | 1151.85 | 69221.0 |
| 2008-07-11 09:00:00 | ES | Futures | 1151.85 | 1157.66 | 1146.97 | 1156.5 | 368064.0 |
| 2008-07-11 10:00:00 | ES | Futures | 1156.5 | 1159.29 | 1145.34 | 1150.22 | 535508.0 |
| 2008-07-11 11:00:00 | ES | Futures | 1150.46 | 1152.32 | 1140.69 | 1148.6 | 393487.0 |
| 2008-07-11 12:00:00 | ES | Futures | 1148.83 | 1148.83 | 1139.53 | 1142.32 | 199807.0 |
| 2008-07-11 13:00:00 | ES | Futures | 1142.09 | 1151.39 | 1139.3 | 1148.6 | 282245.0 |
| 2008-07-11 14:00:00 | ES | Futures | 1148.6 | 1163.47 | 1143.95 | 1162.08 | 470390.0 |
| 2008-07-11 15:00:00 | ES | Futures | 1162.08 | 1169.98 | 1148.83 | 1153.71 | 646853.0 |
| 2008-07-11 16:00:00 | ES | Futures | 1153.94 | 1154.64 | 1152.32 | 1152.55 | 76671.0 |
| 2008-07-11 00:00:00 | NQ | Futures | 2077.32 | 2093.07 | 2077.04 | 2079.01 | 1540.0 |
| 2008-07-11 01:00:00 | NQ | Futures | 2080.13 | 2083.51 | 2078.72 | 2082.38 | 297.0 |
| 2008-07-11 02:00:00 | NQ | Futures | 2082.66 | 2082.66 | 2075.07 | 2075.35 | 610.0 |
| 2008-07-11 03:00:00 | NQ | Futures | 2075.63 | 2077.6 | 2068.6 | 2069.44 | 1066.0 |
| 2008-07-11 04:00:00 | NQ | Futures | 2069.16 | 2077.04 | 2068.88 | 2075.35 | 1009.0 |
| 2008-07-11 05:00:00 | NQ | Futures | 2075.63 | 2077.88 | 2065.78 | 2067.75 | 1790.0 |
| 2008-07-11 06:00:00 | NQ | Futures | 2067.75 | 2070.29 | 2059.88 | 2064.66 | 3328.0 |
| 2008-07-11 07:00:00 | NQ | Futures | 2064.66 | 2066.07 | 2050.88 | 2057.35 | 6552.0 |
| 2008-07-11 08:00:00 | NQ | Futures | 2057.35 | 2060.44 | 2048.34 | 2053.97 | 10483.0 |
| 2008-07-11 09:00:00 | NQ | Futures | 2053.41 | 2062.69 | 2037.66 | 2057.35 | 73467.0 |
| 2008-07-11 10:00:00 | NQ | Futures | 2057.35 | 2061.57 | 2036.81 | 2048.06 | 77299.0 |
| 2008-07-11 11:00:00 | NQ | Futures | 2048.06 | 2050.88 | 2027.81 | 2043.56 | 64346.0 |
| 2008-07-11 12:00:00 | NQ | Futures | 2043.56 | 2044.97 | 2011.78 | 2017.4 | 56856.0 |
| 2008-07-11 13:00:00 | NQ | Futures | 2017.68 | 2039.63 | 2014.03 | 2034.84 | 60683.0 |
| 2008-07-11 14:00:00 | NQ | Futures | 2034.56 | 2061.85 | 2023.59 | 2058.75 | 83456.0 |
| 2008-07-11 15:00:00 | NQ | Futures | 2059.03 | 2077.32 | 2033.72 | 2044.97 | 131733.0 |
| 2008-07-11 16:00:00 | NQ | Futures | 2044.97 | 2048.91 | 2044.13 | 2046.66 | 9616.0 |
| 2008-07-11 00:00:00 | YM | Futures | 10193.9 | 10252.1 | 10192.1 | 10199.4 | 1243.0 |
| 2008-07-11 01:00:00 | YM | Futures | 10199.4 | 10214.8 | 10193.9 | 10209.4 | 295.0 |
| 2008-07-11 02:00:00 | YM | Futures | 10212.1 | 10212.1 | 10195.8 | 10195.8 | 319.0 |
| 2008-07-11 03:00:00 | YM | Futures | 10195.8 | 10204.8 | 10172.1 | 10172.1 | 650.0 |
| 2008-07-11 04:00:00 | YM | Futures | 10173.9 | 10200.3 | 10172.1 | 10187.6 | 583.0 |
| 2008-07-11 05:00:00 | YM | Futures | 10188.5 | 10196.7 | 10165.8 | 10167.6 | 1313.0 |
| 2008-07-11 06:00:00 | YM | Futures | 10167.6 | 10173.0 | 10121.2 | 10138.5 | 3426.0 |
| 2008-07-11 07:00:00 | YM | Futures | 10139.4 | 10141.2 | 10081.2 | 10107.6 | 3884.0 |
| 2008-07-11 08:00:00 | YM | Futures | 10106.7 | 10114.9 | 10075.8 | 10086.7 | 4992.0 |
| 2008-07-11 09:00:00 | YM | Futures | 10085.8 | 10109.4 | 10028.5 | 10101.2 | 36069.0 |
| 2008-07-11 10:00:00 | YM | Futures | 10101.2 | 10118.5 | 10006.7 | 10041.2 | 52352.0 |
| 2008-07-11 11:00:00 | YM | Futures | 10042.2 | 10054.9 | 9964.9 | 10024.9 | 31058.0 |
| 2008-07-11 12:00:00 | YM | Futures | 10024.9 | 10027.6 | 9964.9 | 9984.0 | 20870.0 |
| 2008-07-11 13:00:00 | YM | Futures | 9984.0 | 10046.7 | 9963.1 | 10026.7 | 28084.0 |
| 2008-07-11 14:00:00 | YM | Futures | 10027.6 | 10152.1 | 9988.5 | 10138.5 | 45427.0 |
| 2008-07-11 15:00:00 | YM | Futures | 10140.3 | 10205.7 | 10044.0 | 10089.4 | 71874.0 |
> showing 50 of 1,005 rows — these rows as CSV