PREVIEW / futures_1hour / 2008-03-14
file: by_date/futures_1hour/2008/2008-03-14.parquet size: 37 KB rows: 996
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-14 00:00:00 | ES | Futures | 1216.14 | 1216.84 | 1213.35 | 1215.91 | 5835.0 |
| 2008-03-14 01:00:00 | ES | Futures | 1215.68 | 1217.54 | 1212.65 | 1215.44 | 3309.0 |
| 2008-03-14 02:00:00 | ES | Futures | 1215.44 | 1219.17 | 1214.98 | 1218.94 | 1771.0 |
| 2008-03-14 03:00:00 | ES | Futures | 1218.94 | 1220.57 | 1216.84 | 1217.07 | 5197.0 |
| 2008-03-14 04:00:00 | ES | Futures | 1217.31 | 1222.43 | 1216.14 | 1222.2 | 11182.0 |
| 2008-03-14 05:00:00 | ES | Futures | 1222.2 | 1223.83 | 1220.33 | 1223.13 | 8646.0 |
| 2008-03-14 06:00:00 | ES | Futures | 1223.36 | 1224.29 | 1220.8 | 1221.03 | 8686.0 |
| 2008-03-14 07:00:00 | ES | Futures | 1221.03 | 1221.03 | 1214.75 | 1218.01 | 33248.0 |
| 2008-03-14 08:00:00 | ES | Futures | 1218.01 | 1236.4 | 1216.84 | 1233.84 | 153272.0 |
| 2008-03-14 09:00:00 | ES | Futures | 1233.84 | 1244.32 | 1203.34 | 1203.57 | 644544.0 |
| 2008-03-14 10:00:00 | ES | Futures | 1203.8 | 1217.31 | 1191.46 | 1208.92 | 615590.0 |
| 2008-03-14 11:00:00 | ES | Futures | 1208.92 | 1213.58 | 1201.47 | 1205.9 | 313304.0 |
| 2008-03-14 12:00:00 | ES | Futures | 1205.66 | 1209.39 | 1198.91 | 1202.87 | 256699.0 |
| 2008-03-14 13:00:00 | ES | Futures | 1202.87 | 1203.8 | 1196.12 | 1197.52 | 252421.0 |
| 2008-03-14 14:00:00 | ES | Futures | 1197.28 | 1200.08 | 1187.97 | 1194.02 | 385757.0 |
| 2008-03-14 15:00:00 | ES | Futures | 1194.26 | 1211.95 | 1192.39 | 1201.71 | 543736.0 |
| 2008-03-14 16:00:00 | ES | Futures | 1201.71 | 1204.97 | 1197.98 | 1203.8 | 110723.0 |
| 2008-03-14 00:00:00 | NQ | Futures | 1977.25 | 1980.65 | 1973.86 | 1976.69 | 474.0 |
| 2008-03-14 01:00:00 | NQ | Futures | 1976.97 | 1978.95 | 1970.18 | 1974.43 | 289.0 |
| 2008-03-14 02:00:00 | NQ | Futures | 1974.14 | 1979.23 | 1974.14 | 1979.23 | 224.0 |
| 2008-03-14 03:00:00 | NQ | Futures | 1979.8 | 1979.8 | 1975.84 | 1976.12 | 402.0 |
| 2008-03-14 04:00:00 | NQ | Futures | 1977.25 | 1984.33 | 1974.71 | 1984.04 | 781.0 |
| 2008-03-14 05:00:00 | NQ | Futures | 1983.76 | 1986.59 | 1982.06 | 1985.74 | 650.0 |
| 2008-03-14 06:00:00 | NQ | Futures | 1986.02 | 1987.72 | 1981.78 | 1981.78 | 815.0 |
| 2008-03-14 07:00:00 | NQ | Futures | 1981.78 | 1982.06 | 1973.58 | 1978.1 | 2115.0 |
| 2008-03-14 08:00:00 | NQ | Futures | 1978.39 | 2017.13 | 1976.69 | 2007.52 | 18662.0 |
| 2008-03-14 09:00:00 | NQ | Futures | 2007.23 | 2017.98 | 1950.1 | 1950.67 | 106848.0 |
| 2008-03-14 10:00:00 | NQ | Futures | 1950.95 | 1976.12 | 1930.87 | 1961.7 | 126540.0 |
| 2008-03-14 11:00:00 | NQ | Futures | 1961.13 | 1967.07 | 1946.43 | 1954.91 | 55331.0 |
| 2008-03-14 12:00:00 | NQ | Futures | 1954.91 | 1961.13 | 1941.62 | 1950.1 | 44181.0 |
| 2008-03-14 13:00:00 | NQ | Futures | 1950.1 | 1952.65 | 1939.64 | 1941.9 | 39769.0 |
| 2008-03-14 14:00:00 | NQ | Futures | 1941.62 | 1944.73 | 1926.06 | 1937.09 | 71390.0 |
| 2008-03-14 15:00:00 | NQ | Futures | 1937.09 | 1965.09 | 1932.29 | 1950.67 | 93359.0 |
| 2008-03-14 16:00:00 | NQ | Futures | 1950.67 | 1952.93 | 1938.79 | 1947.56 | 12965.0 |
| 2008-03-14 00:00:00 | YM | Futures | 10963.8 | 10971.1 | 10952.9 | 10967.4 | 274.0 |
| 2008-03-14 01:00:00 | YM | Futures | 10967.4 | 10977.4 | 10925.6 | 10949.3 | 331.0 |
| 2008-03-14 02:00:00 | YM | Futures | 10949.3 | 10983.8 | 10949.3 | 10981.1 | 157.0 |
| 2008-03-14 03:00:00 | YM | Futures | 10981.1 | 10997.4 | 10967.4 | 10969.2 | 707.0 |
| 2008-03-14 04:00:00 | YM | Futures | 10966.5 | 11011.0 | 10960.2 | 11010.1 | 726.0 |
| 2008-03-14 05:00:00 | YM | Futures | 11010.1 | 11018.3 | 10996.5 | 11015.6 | 683.0 |
| 2008-03-14 06:00:00 | YM | Futures | 11010.1 | 11022.9 | 10999.2 | 10999.2 | 541.0 |
| 2008-03-14 07:00:00 | YM | Futures | 10998.3 | 10998.3 | 10952.9 | 10979.2 | 1643.0 |
| 2008-03-14 08:00:00 | YM | Futures | 10977.4 | 11121.9 | 10962.0 | 11099.2 | 8745.0 |
| 2008-03-14 09:00:00 | YM | Futures | 11100.1 | 11176.4 | 10858.4 | 10862.9 | 43891.0 |
| 2008-03-14 10:00:00 | YM | Futures | 10862.9 | 10983.8 | 10767.5 | 10922.0 | 52473.0 |
| 2008-03-14 11:00:00 | YM | Futures | 10921.1 | 10954.7 | 10860.2 | 10885.6 | 26828.0 |
| 2008-03-14 12:00:00 | YM | Futures | 10884.7 | 10918.4 | 10829.3 | 10859.3 | 24844.0 |
| 2008-03-14 13:00:00 | YM | Futures | 10858.4 | 10871.1 | 10810.2 | 10822.9 | 22364.0 |
| 2008-03-14 14:00:00 | YM | Futures | 10823.9 | 10850.2 | 10734.8 | 10799.3 | 32925.0 |
| 2008-03-14 15:00:00 | YM | Futures | 10799.3 | 10953.8 | 10785.7 | 10867.5 | 47416.0 |
> showing 50 of 996 rows — these rows as CSV