PREVIEW / futures_1hour / 2008-03-18
file: by_date/futures_1hour/2008/2008-03-18.parquet size: 45 KB rows: 1,266
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-03-18 00:00:00 | ES | Futures | 1193.09 | 1197.52 | 1191.46 | 1196.35 | 2047.0 |
| 2008-03-18 01:00:00 | ES | Futures | 1196.58 | 1197.52 | 1195.89 | 1196.35 | 1032.0 |
| 2008-03-18 02:00:00 | ES | Futures | 1196.35 | 1198.45 | 1195.65 | 1198.21 | 2185.0 |
| 2008-03-18 03:00:00 | ES | Futures | 1198.45 | 1203.8 | 1197.52 | 1202.4 | 12304.0 |
| 2008-03-18 04:00:00 | ES | Futures | 1202.17 | 1202.17 | 1199.38 | 1201.47 | 18560.0 |
| 2008-03-18 05:00:00 | ES | Futures | 1201.47 | 1204.97 | 1201.01 | 1201.94 | 18639.0 |
| 2008-03-18 06:00:00 | ES | Futures | 1201.94 | 1206.36 | 1201.47 | 1205.9 | 22414.0 |
| 2008-03-18 07:00:00 | ES | Futures | 1205.66 | 1209.39 | 1204.03 | 1207.99 | 47645.0 |
| 2008-03-18 08:00:00 | ES | Futures | 1207.99 | 1212.65 | 1207.06 | 1211.02 | 137379.0 |
| 2008-03-18 09:00:00 | ES | Futures | 1211.25 | 1216.84 | 1211.02 | 1215.21 | 245130.0 |
| 2008-03-18 10:00:00 | ES | Futures | 1215.21 | 1220.1 | 1213.58 | 1219.4 | 249942.0 |
| 2008-03-18 11:00:00 | ES | Futures | 1219.64 | 1223.59 | 1218.7 | 1220.33 | 188965.0 |
| 2008-03-18 12:00:00 | ES | Futures | 1220.57 | 1224.99 | 1218.94 | 1223.83 | 139816.0 |
| 2008-03-18 13:00:00 | ES | Futures | 1223.83 | 1227.55 | 1222.9 | 1225.92 | 145580.0 |
| 2008-03-18 14:00:00 | ES | Futures | 1225.92 | 1232.91 | 1207.29 | 1231.51 | 777144.0 |
| 2008-03-18 15:00:00 | ES | Futures | 1231.51 | 1240.13 | 1226.62 | 1239.66 | 537398.0 |
| 2008-03-18 16:00:00 | ES | Futures | 1239.43 | 1242.92 | 1238.96 | 1241.76 | 136048.0 |
| 2008-03-18 17:00:00 | ES | Futures | 1241.76 | 1242.45 | 1241.29 | 1241.99 | 2354.0 |
| 2008-03-18 18:00:00 | ES | Futures | 1241.99 | 1242.22 | 1240.59 | 1241.06 | 2840.0 |
| 2008-03-18 19:00:00 | ES | Futures | 1240.82 | 1241.99 | 1240.59 | 1241.52 | 2211.0 |
| 2008-03-18 20:00:00 | ES | Futures | 1241.52 | 1243.39 | 1240.13 | 1242.22 | 3936.0 |
| 2008-03-18 21:00:00 | ES | Futures | 1242.45 | 1245.48 | 1241.76 | 1243.39 | 5353.0 |
| 2008-03-18 22:00:00 | ES | Futures | 1243.62 | 1243.85 | 1241.76 | 1242.45 | 2622.0 |
| 2008-03-18 23:00:00 | ES | Futures | 1242.45 | 1243.15 | 1241.52 | 1241.76 | 1318.0 |
| 2008-03-18 00:00:00 | NQ | Futures | 1920.12 | 1926.63 | 1917.01 | 1925.21 | 199.0 |
| 2008-03-18 01:00:00 | NQ | Futures | 1925.21 | 1928.61 | 1923.52 | 1927.76 | 173.0 |
| 2008-03-18 02:00:00 | NQ | Futures | 1929.46 | 1930.02 | 1926.63 | 1929.46 | 52.0 |
| 2008-03-18 03:00:00 | NQ | Futures | 1930.02 | 1939.07 | 1929.74 | 1937.94 | 1460.0 |
| 2008-03-18 04:00:00 | NQ | Futures | 1937.38 | 1939.07 | 1933.7 | 1935.68 | 1603.0 |
| 2008-03-18 05:00:00 | NQ | Futures | 1935.68 | 1939.07 | 1930.31 | 1932.29 | 2318.0 |
| 2008-03-18 06:00:00 | NQ | Futures | 1932.85 | 1940.2 | 1931.44 | 1939.92 | 1333.0 |
| 2008-03-18 07:00:00 | NQ | Futures | 1939.92 | 1942.18 | 1935.96 | 1937.38 | 2853.0 |
| 2008-03-18 08:00:00 | NQ | Futures | 1937.66 | 1944.45 | 1935.96 | 1943.88 | 11976.0 |
| 2008-03-18 09:00:00 | NQ | Futures | 1943.88 | 1957.46 | 1943.03 | 1950.1 | 67904.0 |
| 2008-03-18 10:00:00 | NQ | Futures | 1950.39 | 1956.61 | 1948.69 | 1954.06 | 48451.0 |
| 2008-03-18 11:00:00 | NQ | Futures | 1953.78 | 1963.11 | 1952.93 | 1957.46 | 37375.0 |
| 2008-03-18 12:00:00 | NQ | Futures | 1957.74 | 1967.64 | 1954.63 | 1965.94 | 29923.0 |
| 2008-03-18 13:00:00 | NQ | Futures | 1965.66 | 1973.3 | 1964.81 | 1970.18 | 37068.0 |
| 2008-03-18 14:00:00 | NQ | Futures | 1970.47 | 1982.35 | 1942.18 | 1980.93 | 150617.0 |
| 2008-03-18 15:00:00 | NQ | Futures | 1980.93 | 1999.32 | 1973.3 | 1999.03 | 99815.0 |
| 2008-03-18 16:00:00 | NQ | Futures | 1998.75 | 2005.54 | 1997.05 | 2004.41 | 17927.0 |
| 2008-03-18 17:00:00 | NQ | Futures | 2004.41 | 2004.69 | 2002.71 | 2002.99 | 142.0 |
| 2008-03-18 18:00:00 | NQ | Futures | 2003.84 | 2004.69 | 2002.71 | 2002.71 | 126.0 |
| 2008-03-18 19:00:00 | NQ | Futures | 2002.71 | 2004.69 | 2001.86 | 2004.69 | 95.0 |
| 2008-03-18 20:00:00 | NQ | Futures | 2002.99 | 2006.67 | 2001.86 | 2005.25 | 338.0 |
| 2008-03-18 21:00:00 | NQ | Futures | 2005.82 | 2009.21 | 2002.99 | 2008.93 | 394.0 |
| 2008-03-18 22:00:00 | NQ | Futures | 2006.95 | 2006.95 | 2004.41 | 2005.25 | 84.0 |
| 2008-03-18 23:00:00 | NQ | Futures | 2004.69 | 2006.1 | 2003.56 | 2003.56 | 42.0 |
| 2008-03-18 00:00:00 | YM | Futures | 10903.8 | 10939.3 | 10895.6 | 10937.4 | 272.0 |
| 2008-03-18 01:00:00 | YM | Futures | 10934.7 | 10942.9 | 10924.7 | 10932.9 | 116.0 |
> showing 50 of 1,266 rows — these rows as CSV