PREVIEW / futures_1hour / 2008-03-11
file: by_date/futures_1hour/2008/2008-03-11.parquet size: 42 KB rows: 1,185
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-11 00:00:00 | ES | Futures | 1193.29 | 1194.23 | 1191.19 | 1193.99 | 2691.0 |
| 2008-03-11 01:00:00 | ES | Futures | 1194.23 | 1194.69 | 1192.36 | 1193.76 | 2270.0 |
| 2008-03-11 02:00:00 | ES | Futures | 1194.23 | 1195.16 | 1193.76 | 1194.69 | 3701.0 |
| 2008-03-11 03:00:00 | ES | Futures | 1194.93 | 1197.26 | 1194.69 | 1195.39 | 9198.0 |
| 2008-03-11 04:00:00 | ES | Futures | 1195.39 | 1196.32 | 1191.89 | 1193.29 | 19120.0 |
| 2008-03-11 05:00:00 | ES | Futures | 1193.29 | 1198.89 | 1193.29 | 1197.96 | 24778.0 |
| 2008-03-11 06:00:00 | ES | Futures | 1197.96 | 1199.59 | 1196.09 | 1198.89 | 21815.0 |
| 2008-03-11 07:00:00 | ES | Futures | 1198.66 | 1200.29 | 1196.32 | 1196.79 | 36904.0 |
| 2008-03-11 08:00:00 | ES | Futures | 1196.79 | 1221.27 | 1194.46 | 1217.31 | 266959.0 |
| 2008-03-11 09:00:00 | ES | Futures | 1217.31 | 1218.94 | 1210.55 | 1210.78 | 338896.0 |
| 2008-03-11 10:00:00 | ES | Futures | 1210.55 | 1214.28 | 1208.22 | 1211.95 | 362463.0 |
| 2008-03-11 11:00:00 | ES | Futures | 1211.95 | 1213.11 | 1199.82 | 1201.92 | 359588.0 |
| 2008-03-11 12:00:00 | ES | Futures | 1202.15 | 1207.28 | 1199.59 | 1204.95 | 322176.0 |
| 2008-03-11 13:00:00 | ES | Futures | 1205.18 | 1212.88 | 1202.39 | 1212.18 | 307808.0 |
| 2008-03-11 14:00:00 | ES | Futures | 1212.18 | 1223.6 | 1211.25 | 1221.27 | 359281.0 |
| 2008-03-11 15:00:00 | ES | Futures | 1221.27 | 1232.46 | 1219.17 | 1231.53 | 510408.0 |
| 2008-03-11 16:00:00 | ES | Futures | 1231.53 | 1235.26 | 1230.83 | 1235.26 | 152959.0 |
| 2008-03-11 17:00:00 | ES | Futures | 1235.03 | 1237.36 | 1234.8 | 1237.36 | 5338.0 |
| 2008-03-11 18:00:00 | ES | Futures | 1237.13 | 1238.76 | 1235.96 | 1236.66 | 7168.0 |
| 2008-03-11 19:00:00 | ES | Futures | 1236.43 | 1237.59 | 1234.8 | 1235.96 | 3389.0 |
| 2008-03-11 20:00:00 | ES | Futures | 1235.96 | 1236.19 | 1234.56 | 1234.56 | 2951.0 |
| 2008-03-11 21:00:00 | ES | Futures | 1234.56 | 1235.03 | 1234.1 | 1234.56 | 2534.0 |
| 2008-03-11 22:00:00 | ES | Futures | 1234.56 | 1235.03 | 1234.1 | 1234.56 | 1804.0 |
| 2008-03-11 23:00:00 | ES | Futures | 1234.33 | 1234.56 | 1233.16 | 1233.16 | 2966.0 |
| 2008-03-11 00:00:00 | NQ | Futures | 1905.16 | 1907.71 | 1902.6 | 1907.71 | 268.0 |
| 2008-03-11 01:00:00 | NQ | Futures | 1907.71 | 1909.42 | 1905.73 | 1908.56 | 146.0 |
| 2008-03-11 02:00:00 | NQ | Futures | 1908.85 | 1911.12 | 1908.85 | 1910.55 | 209.0 |
| 2008-03-11 03:00:00 | NQ | Futures | 1911.12 | 1913.39 | 1909.42 | 1909.98 | 596.0 |
| 2008-03-11 04:00:00 | NQ | Futures | 1909.98 | 1912.82 | 1904.02 | 1904.87 | 2309.0 |
| 2008-03-11 05:00:00 | NQ | Futures | 1904.59 | 1914.53 | 1904.59 | 1912.82 | 1826.0 |
| 2008-03-11 06:00:00 | NQ | Futures | 1913.11 | 1915.94 | 1908.0 | 1911.97 | 1258.0 |
| 2008-03-11 07:00:00 | NQ | Futures | 1912.82 | 1915.66 | 1907.15 | 1907.71 | 2847.0 |
| 2008-03-11 08:00:00 | NQ | Futures | 1907.71 | 1943.76 | 1902.6 | 1937.8 | 28615.0 |
| 2008-03-11 09:00:00 | NQ | Futures | 1937.52 | 1947.74 | 1931.56 | 1932.98 | 65571.0 |
| 2008-03-11 10:00:00 | NQ | Futures | 1933.26 | 1941.49 | 1927.3 | 1938.65 | 56300.0 |
| 2008-03-11 11:00:00 | NQ | Futures | 1938.65 | 1940.92 | 1919.92 | 1924.18 | 54858.0 |
| 2008-03-11 12:00:00 | NQ | Futures | 1924.18 | 1932.12 | 1916.23 | 1925.88 | 51566.0 |
| 2008-03-11 13:00:00 | NQ | Futures | 1925.88 | 1943.19 | 1923.32 | 1942.06 | 51600.0 |
| 2008-03-11 14:00:00 | NQ | Futures | 1942.06 | 1960.22 | 1940.07 | 1955.4 | 66554.0 |
| 2008-03-11 15:00:00 | NQ | Futures | 1955.4 | 1978.39 | 1952.28 | 1977.54 | 82988.0 |
| 2008-03-11 16:00:00 | NQ | Futures | 1977.25 | 1990.88 | 1976.97 | 1988.89 | 25634.0 |
| 2008-03-11 17:00:00 | NQ | Futures | 1988.89 | 1990.31 | 1987.76 | 1988.61 | 810.0 |
| 2008-03-11 18:00:00 | NQ | Futures | 1988.61 | 1993.15 | 1988.32 | 1989.46 | 677.0 |
| 2008-03-11 19:00:00 | NQ | Futures | 1989.46 | 1991.73 | 1989.18 | 1991.45 | 370.0 |
| 2008-03-11 20:00:00 | NQ | Futures | 1991.16 | 1991.45 | 1988.32 | 1988.89 | 143.0 |
| 2008-03-11 21:00:00 | NQ | Futures | 1988.61 | 1989.46 | 1987.76 | 1988.04 | 158.0 |
| 2008-03-11 22:00:00 | NQ | Futures | 1987.76 | 1988.61 | 1986.91 | 1987.19 | 196.0 |
| 2008-03-11 23:00:00 | NQ | Futures | 1987.47 | 1988.32 | 1986.05 | 1986.05 | 122.0 |
| 2008-03-11 00:00:00 | YM | Futures | 10723.9 | 10723.9 | 10723.9 | 10723.9 | 1.0 |
| 2008-03-11 01:00:00 | YM | Futures | 10735.7 | 10737.5 | 10722.1 | 10737.5 | 5.0 |
> showing 50 of 1,185 rows — these rows as CSV