PREVIEW / futures_1hour / 2008-03-20
file: by_date/futures_1hour/2008/2008-03-20.parquet size: 37 KB rows: 1,011
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-20 00:00:00 | ES | Futures | 1202.64 | 1204.03 | 1202.64 | 1203.57 | 842.0 |
| 2008-03-20 01:00:00 | ES | Futures | 1203.57 | 1207.06 | 1203.57 | 1206.6 | 3795.0 |
| 2008-03-20 02:00:00 | ES | Futures | 1206.36 | 1207.99 | 1204.27 | 1207.76 | 5163.0 |
| 2008-03-20 03:00:00 | ES | Futures | 1207.76 | 1209.62 | 1206.83 | 1207.99 | 9700.0 |
| 2008-03-20 04:00:00 | ES | Futures | 1208.23 | 1212.18 | 1207.76 | 1211.49 | 36575.0 |
| 2008-03-20 05:00:00 | ES | Futures | 1211.49 | 1218.01 | 1211.25 | 1215.91 | 32590.0 |
| 2008-03-20 06:00:00 | ES | Futures | 1215.91 | 1218.01 | 1212.65 | 1213.12 | 24827.0 |
| 2008-03-20 07:00:00 | ES | Futures | 1213.35 | 1217.77 | 1212.18 | 1216.14 | 33335.0 |
| 2008-03-20 08:00:00 | ES | Futures | 1216.14 | 1216.61 | 1207.06 | 1207.99 | 87104.0 |
| 2008-03-20 09:00:00 | ES | Futures | 1207.99 | 1215.68 | 1206.6 | 1214.05 | 288044.0 |
| 2008-03-20 10:00:00 | ES | Futures | 1214.05 | 1224.99 | 1213.58 | 1224.76 | 361216.0 |
| 2008-03-20 11:00:00 | ES | Futures | 1224.53 | 1226.62 | 1218.24 | 1219.17 | 257914.0 |
| 2008-03-20 12:00:00 | ES | Futures | 1218.94 | 1224.99 | 1216.61 | 1219.17 | 184681.0 |
| 2008-03-20 13:00:00 | ES | Futures | 1218.94 | 1228.72 | 1218.94 | 1227.78 | 130774.0 |
| 2008-03-20 14:00:00 | ES | Futures | 1227.78 | 1236.4 | 1226.15 | 1235.7 | 219041.0 |
| 2008-03-20 15:00:00 | ES | Futures | 1235.7 | 1241.06 | 1233.37 | 1239.66 | 297295.0 |
| 2008-03-20 16:00:00 | ES | Futures | 1239.43 | 1239.66 | 1232.44 | 1234.07 | 118188.0 |
| 2008-03-20 00:00:00 | NQ | Futures | 1938.22 | 1941.05 | 1937.94 | 1940.2 | 71.0 |
| 2008-03-20 01:00:00 | NQ | Futures | 1941.34 | 1945.58 | 1940.2 | 1944.73 | 133.0 |
| 2008-03-20 02:00:00 | NQ | Futures | 1944.45 | 1950.39 | 1941.9 | 1947.56 | 328.0 |
| 2008-03-20 03:00:00 | NQ | Futures | 1947.56 | 1950.39 | 1946.14 | 1947.56 | 315.0 |
| 2008-03-20 04:00:00 | NQ | Futures | 1947.84 | 1955.19 | 1947.28 | 1951.8 | 1433.0 |
| 2008-03-20 05:00:00 | NQ | Futures | 1952.08 | 1959.44 | 1950.1 | 1957.17 | 1611.0 |
| 2008-03-20 06:00:00 | NQ | Futures | 1957.17 | 1961.42 | 1954.35 | 1955.76 | 1247.0 |
| 2008-03-20 07:00:00 | NQ | Futures | 1955.48 | 1961.98 | 1954.63 | 1958.02 | 1424.0 |
| 2008-03-20 08:00:00 | NQ | Futures | 1957.17 | 1961.7 | 1944.16 | 1948.69 | 11139.0 |
| 2008-03-20 09:00:00 | NQ | Futures | 1948.69 | 1956.89 | 1943.03 | 1954.91 | 52882.0 |
| 2008-03-20 10:00:00 | NQ | Futures | 1955.19 | 1963.96 | 1950.1 | 1963.11 | 67613.0 |
| 2008-03-20 11:00:00 | NQ | Futures | 1963.4 | 1965.66 | 1951.8 | 1954.06 | 44031.0 |
| 2008-03-20 12:00:00 | NQ | Futures | 1954.35 | 1963.4 | 1950.95 | 1952.93 | 34176.0 |
| 2008-03-20 13:00:00 | NQ | Futures | 1953.21 | 1974.43 | 1952.65 | 1971.6 | 40920.0 |
| 2008-03-20 14:00:00 | NQ | Futures | 1971.32 | 1981.5 | 1965.38 | 1980.37 | 46711.0 |
| 2008-03-20 15:00:00 | NQ | Futures | 1980.37 | 1990.27 | 1976.12 | 1989.98 | 65735.0 |
| 2008-03-20 16:00:00 | NQ | Futures | 1990.27 | 1990.27 | 1973.58 | 1980.93 | 13808.0 |
| 2008-03-20 00:00:00 | YM | Futures | 10971.1 | 10972.9 | 10965.6 | 10968.3 | 115.0 |
| 2008-03-20 01:00:00 | YM | Futures | 10968.3 | 10987.4 | 10968.3 | 10979.2 | 404.0 |
| 2008-03-20 02:00:00 | YM | Futures | 10974.7 | 10989.2 | 10960.2 | 10987.4 | 331.0 |
| 2008-03-20 03:00:00 | YM | Futures | 10989.2 | 11001.0 | 10983.8 | 10989.2 | 538.0 |
| 2008-03-20 04:00:00 | YM | Futures | 10990.1 | 11024.7 | 10986.5 | 11021.9 | 1416.0 |
| 2008-03-20 05:00:00 | YM | Futures | 11021.0 | 11067.4 | 11018.3 | 11054.7 | 1030.0 |
| 2008-03-20 06:00:00 | YM | Futures | 11055.6 | 11071.9 | 11031.0 | 11032.8 | 1022.0 |
| 2008-03-20 07:00:00 | YM | Futures | 11032.8 | 11068.3 | 11021.9 | 11055.6 | 1678.0 |
| 2008-03-20 08:00:00 | YM | Futures | 11061.9 | 11061.9 | 10992.9 | 11001.0 | 6816.0 |
| 2008-03-20 09:00:00 | YM | Futures | 11000.1 | 11064.6 | 10991.0 | 11042.8 | 20875.0 |
| 2008-03-20 10:00:00 | YM | Futures | 11041.9 | 11127.3 | 11041.0 | 11126.4 | 35265.0 |
| 2008-03-20 11:00:00 | YM | Futures | 11126.4 | 11137.3 | 11071.9 | 11081.0 | 22790.0 |
| 2008-03-20 12:00:00 | YM | Futures | 11081.0 | 11123.7 | 11065.6 | 11077.4 | 19879.0 |
| 2008-03-20 13:00:00 | YM | Futures | 11078.3 | 11156.4 | 11077.4 | 11149.2 | 16448.0 |
| 2008-03-20 14:00:00 | YM | Futures | 11147.3 | 11210.9 | 11132.8 | 11205.5 | 21051.0 |
| 2008-03-20 15:00:00 | YM | Futures | 11204.6 | 11248.2 | 11180.0 | 11242.7 | 25560.0 |
> showing 50 of 1,011 rows — these rows as CSV