PREVIEW / futures_1hour / 2008-08-05
file: by_date/futures_1hour/2008/2008-08-05.parquet size: 44 KB rows: 1,284
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-08-05 00:00:00 | ES | Futures | 1162.31 | 1163.01 | 1162.08 | 1162.31 | 406.0 |
| 2008-08-05 01:00:00 | ES | Futures | 1162.08 | 1163.47 | 1159.75 | 1161.38 | 3021.0 |
| 2008-08-05 02:00:00 | ES | Futures | 1161.38 | 1163.47 | 1161.15 | 1163.01 | 4046.0 |
| 2008-08-05 03:00:00 | ES | Futures | 1163.24 | 1163.94 | 1159.52 | 1163.7 | 11381.0 |
| 2008-08-05 04:00:00 | ES | Futures | 1163.47 | 1171.37 | 1163.47 | 1169.28 | 33356.0 |
| 2008-08-05 05:00:00 | ES | Futures | 1169.51 | 1171.84 | 1168.35 | 1170.21 | 15067.0 |
| 2008-08-05 06:00:00 | ES | Futures | 1170.21 | 1172.54 | 1169.05 | 1171.14 | 16429.0 |
| 2008-08-05 07:00:00 | ES | Futures | 1171.14 | 1171.14 | 1168.12 | 1168.82 | 18270.0 |
| 2008-08-05 08:00:00 | ES | Futures | 1168.82 | 1170.21 | 1167.89 | 1169.75 | 18207.0 |
| 2008-08-05 09:00:00 | ES | Futures | 1169.75 | 1174.63 | 1168.82 | 1174.16 | 205553.0 |
| 2008-08-05 10:00:00 | ES | Futures | 1174.16 | 1178.58 | 1173.7 | 1178.35 | 296513.0 |
| 2008-08-05 11:00:00 | ES | Futures | 1178.35 | 1181.13 | 1177.65 | 1181.13 | 170772.0 |
| 2008-08-05 12:00:00 | ES | Futures | 1181.13 | 1182.99 | 1179.28 | 1181.83 | 128235.0 |
| 2008-08-05 13:00:00 | ES | Futures | 1181.83 | 1184.16 | 1180.9 | 1182.3 | 107172.0 |
| 2008-08-05 14:00:00 | ES | Futures | 1182.3 | 1189.27 | 1177.88 | 1186.95 | 435594.0 |
| 2008-08-05 15:00:00 | ES | Futures | 1187.18 | 1193.22 | 1185.78 | 1192.99 | 398197.0 |
| 2008-08-05 16:00:00 | ES | Futures | 1192.76 | 1194.15 | 1191.83 | 1192.99 | 134973.0 |
| 2008-08-05 17:00:00 | ES | Futures | 1192.99 | 1194.61 | 1192.76 | 1193.69 | 4136.0 |
| 2008-08-05 18:00:00 | ES | Futures | 1194.38 | 1194.61 | 1192.76 | 1193.45 | 2639.0 |
| 2008-08-05 19:00:00 | ES | Futures | 1193.45 | 1194.15 | 1193.22 | 1193.69 | 924.0 |
| 2008-08-05 20:00:00 | ES | Futures | 1193.92 | 1194.15 | 1192.76 | 1192.76 | 1444.0 |
| 2008-08-05 21:00:00 | ES | Futures | 1192.76 | 1193.22 | 1192.06 | 1193.22 | 1659.0 |
| 2008-08-05 22:00:00 | ES | Futures | 1193.22 | 1193.92 | 1192.99 | 1193.45 | 933.0 |
| 2008-08-05 23:00:00 | ES | Futures | 1193.69 | 1194.61 | 1193.22 | 1194.38 | 1541.0 |
| 2008-08-05 00:00:00 | NQ | Futures | 2041.59 | 2041.59 | 2041.31 | 2041.31 | 6.0 |
| 2008-08-05 01:00:00 | NQ | Futures | 2041.59 | 2043.0 | 2038.5 | 2040.47 | 241.0 |
| 2008-08-05 02:00:00 | NQ | Futures | 2040.47 | 2043.0 | 2039.34 | 2042.44 | 694.0 |
| 2008-08-05 03:00:00 | NQ | Futures | 2042.72 | 2045.25 | 2036.53 | 2044.69 | 1738.0 |
| 2008-08-05 04:00:00 | NQ | Futures | 2045.25 | 2060.16 | 2045.25 | 2056.22 | 2779.0 |
| 2008-08-05 05:00:00 | NQ | Futures | 2056.22 | 2061.0 | 2054.81 | 2057.63 | 1060.0 |
| 2008-08-05 06:00:00 | NQ | Futures | 2057.63 | 2061.0 | 2055.94 | 2059.03 | 1015.0 |
| 2008-08-05 07:00:00 | NQ | Futures | 2059.03 | 2059.32 | 2053.41 | 2054.25 | 2053.0 |
| 2008-08-05 08:00:00 | NQ | Futures | 2054.25 | 2057.63 | 2053.13 | 2055.66 | 4573.0 |
| 2008-08-05 09:00:00 | NQ | Futures | 2055.66 | 2064.94 | 2054.25 | 2063.82 | 44007.0 |
| 2008-08-05 10:00:00 | NQ | Futures | 2063.82 | 2071.69 | 2062.97 | 2070.29 | 52139.0 |
| 2008-08-05 11:00:00 | NQ | Futures | 2070.29 | 2082.1 | 2069.72 | 2082.1 | 53023.0 |
| 2008-08-05 12:00:00 | NQ | Futures | 2081.82 | 2082.1 | 2075.91 | 2079.85 | 26620.0 |
| 2008-08-05 13:00:00 | NQ | Futures | 2080.13 | 2084.63 | 2077.6 | 2079.85 | 30983.0 |
| 2008-08-05 14:00:00 | NQ | Futures | 2079.85 | 2098.7 | 2073.1 | 2094.48 | 81928.0 |
| 2008-08-05 15:00:00 | NQ | Futures | 2093.91 | 2108.26 | 2089.98 | 2105.17 | 82345.0 |
| 2008-08-05 16:00:00 | NQ | Futures | 2105.17 | 2110.23 | 2100.95 | 2108.82 | 26868.0 |
| 2008-08-05 17:00:00 | NQ | Futures | 2109.38 | 2118.39 | 2108.82 | 2115.01 | 2126.0 |
| 2008-08-05 18:00:00 | NQ | Futures | 2115.29 | 2115.85 | 2112.48 | 2113.32 | 621.0 |
| 2008-08-05 19:00:00 | NQ | Futures | 2113.32 | 2114.45 | 2112.48 | 2113.89 | 142.0 |
| 2008-08-05 20:00:00 | NQ | Futures | 2113.6 | 2114.45 | 2112.2 | 2112.2 | 185.0 |
| 2008-08-05 21:00:00 | NQ | Futures | 2112.2 | 2114.17 | 2111.63 | 2113.89 | 222.0 |
| 2008-08-05 22:00:00 | NQ | Futures | 2114.17 | 2114.45 | 2113.04 | 2113.04 | 105.0 |
| 2008-08-05 23:00:00 | NQ | Futures | 2113.89 | 2116.42 | 2113.04 | 2115.29 | 446.0 |
| 2008-08-05 00:00:00 | YM | Futures | 10254.8 | 10259.4 | 10251.2 | 10257.6 | 40.0 |
| 2008-08-05 01:00:00 | YM | Futures | 10255.7 | 10260.3 | 10238.5 | 10246.6 | 238.0 |
> showing 50 of 1,284 rows — these rows as CSV