PREVIEW / futures_1hour / 2008-03-10
file: by_date/futures_1hour/2008/2008-03-10.parquet size: 39 KB rows: 1,135
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-10 00:00:00 | ES | Futures | 1201.22 | 1201.22 | 1199.59 | 1199.82 | 1898.0 |
| 2008-03-10 01:00:00 | ES | Futures | 1200.05 | 1201.92 | 1199.59 | 1200.99 | 1329.0 |
| 2008-03-10 02:00:00 | ES | Futures | 1201.22 | 1202.39 | 1200.52 | 1201.92 | 1321.0 |
| 2008-03-10 03:00:00 | ES | Futures | 1202.15 | 1205.42 | 1200.52 | 1204.48 | 6418.0 |
| 2008-03-10 04:00:00 | ES | Futures | 1204.48 | 1208.45 | 1202.15 | 1202.85 | 23343.0 |
| 2008-03-10 05:00:00 | ES | Futures | 1202.85 | 1207.75 | 1201.69 | 1205.42 | 16025.0 |
| 2008-03-10 06:00:00 | ES | Futures | 1205.42 | 1208.45 | 1204.72 | 1207.75 | 14202.0 |
| 2008-03-10 07:00:00 | ES | Futures | 1207.52 | 1211.95 | 1206.82 | 1208.45 | 35449.0 |
| 2008-03-10 08:00:00 | ES | Futures | 1208.45 | 1209.85 | 1205.18 | 1207.98 | 41167.0 |
| 2008-03-10 09:00:00 | ES | Futures | 1207.98 | 1209.38 | 1200.99 | 1205.65 | 189746.0 |
| 2008-03-10 10:00:00 | ES | Futures | 1205.88 | 1208.68 | 1200.52 | 1204.02 | 298228.0 |
| 2008-03-10 11:00:00 | ES | Futures | 1204.02 | 1207.05 | 1192.59 | 1197.72 | 348824.0 |
| 2008-03-10 12:00:00 | ES | Futures | 1197.96 | 1201.69 | 1192.13 | 1200.52 | 319785.0 |
| 2008-03-10 13:00:00 | ES | Futures | 1200.29 | 1201.22 | 1193.29 | 1193.53 | 157482.0 |
| 2008-03-10 14:00:00 | ES | Futures | 1193.53 | 1194.93 | 1186.76 | 1190.5 | 335747.0 |
| 2008-03-10 15:00:00 | ES | Futures | 1190.5 | 1193.53 | 1187.0 | 1189.33 | 398855.0 |
| 2008-03-10 16:00:00 | ES | Futures | 1189.33 | 1190.96 | 1186.53 | 1188.16 | 98421.0 |
| 2008-03-10 17:00:00 | ES | Futures | 1188.16 | 1189.1 | 1187.46 | 1187.46 | 3684.0 |
| 2008-03-10 18:00:00 | ES | Futures | 1187.7 | 1189.56 | 1187.46 | 1189.1 | 2348.0 |
| 2008-03-10 19:00:00 | ES | Futures | 1189.1 | 1190.03 | 1188.16 | 1188.86 | 3053.0 |
| 2008-03-10 20:00:00 | ES | Futures | 1189.1 | 1191.66 | 1189.1 | 1190.73 | 3038.0 |
| 2008-03-10 21:00:00 | ES | Futures | 1190.73 | 1194.93 | 1190.03 | 1193.53 | 6617.0 |
| 2008-03-10 22:00:00 | ES | Futures | 1193.76 | 1195.16 | 1193.29 | 1193.76 | 4677.0 |
| 2008-03-10 23:00:00 | ES | Futures | 1193.99 | 1194.46 | 1192.59 | 1193.29 | 2160.0 |
| 2008-03-10 00:00:00 | NQ | Futures | 1932.41 | 1932.41 | 1930.42 | 1930.42 | 35.0 |
| 2008-03-10 01:00:00 | NQ | Futures | 1931.27 | 1932.98 | 1930.42 | 1932.12 | 68.0 |
| 2008-03-10 02:00:00 | NQ | Futures | 1932.69 | 1935.25 | 1930.7 | 1932.98 | 40.0 |
| 2008-03-10 03:00:00 | NQ | Futures | 1933.26 | 1936.67 | 1930.99 | 1934.96 | 487.0 |
| 2008-03-10 04:00:00 | NQ | Futures | 1934.96 | 1943.19 | 1930.14 | 1930.7 | 1319.0 |
| 2008-03-10 05:00:00 | NQ | Futures | 1931.27 | 1946.32 | 1930.14 | 1942.06 | 2079.0 |
| 2008-03-10 06:00:00 | NQ | Futures | 1941.77 | 1947.17 | 1940.36 | 1945.75 | 765.0 |
| 2008-03-10 07:00:00 | NQ | Futures | 1945.75 | 1950.29 | 1941.77 | 1944.05 | 3349.0 |
| 2008-03-10 08:00:00 | NQ | Futures | 1943.76 | 1945.75 | 1938.37 | 1940.36 | 3289.0 |
| 2008-03-10 09:00:00 | NQ | Futures | 1940.36 | 1944.9 | 1930.99 | 1939.79 | 39034.0 |
| 2008-03-10 10:00:00 | NQ | Futures | 1939.79 | 1945.18 | 1931.84 | 1935.81 | 52271.0 |
| 2008-03-10 11:00:00 | NQ | Futures | 1935.53 | 1940.64 | 1916.51 | 1922.47 | 52964.0 |
| 2008-03-10 12:00:00 | NQ | Futures | 1922.19 | 1927.01 | 1914.53 | 1925.88 | 54994.0 |
| 2008-03-10 13:00:00 | NQ | Futures | 1925.6 | 1927.01 | 1912.54 | 1912.54 | 32747.0 |
| 2008-03-10 14:00:00 | NQ | Futures | 1912.82 | 1915.38 | 1902.32 | 1906.29 | 51409.0 |
| 2008-03-10 15:00:00 | NQ | Futures | 1906.01 | 1913.11 | 1900.62 | 1903.46 | 62143.0 |
| 2008-03-10 16:00:00 | NQ | Futures | 1903.46 | 1906.01 | 1894.66 | 1896.64 | 17413.0 |
| 2008-03-10 17:00:00 | NQ | Futures | 1896.08 | 1897.49 | 1894.94 | 1896.08 | 284.0 |
| 2008-03-10 18:00:00 | NQ | Futures | 1896.64 | 1899.2 | 1896.08 | 1899.2 | 266.0 |
| 2008-03-10 19:00:00 | NQ | Futures | 1898.91 | 1900.33 | 1898.06 | 1898.06 | 136.0 |
| 2008-03-10 20:00:00 | NQ | Futures | 1898.63 | 1904.02 | 1898.63 | 1902.89 | 192.0 |
| 2008-03-10 21:00:00 | NQ | Futures | 1902.89 | 1908.28 | 1902.32 | 1907.43 | 282.0 |
| 2008-03-10 22:00:00 | NQ | Futures | 1908.0 | 1908.28 | 1905.73 | 1907.15 | 98.0 |
| 2008-03-10 23:00:00 | NQ | Futures | 1906.86 | 1908.0 | 1904.02 | 1904.31 | 58.0 |
| 2008-03-10 01:00:00 | YM | Futures | 10765.7 | 10765.7 | 10765.7 | 10765.7 | 2.0 |
| 2008-03-10 03:00:00 | YM | Futures | 10771.2 | 10805.7 | 10771.2 | 10803.9 | 15.0 |
> showing 50 of 1,135 rows — these rows as CSV