PREVIEW / futures_1hour / 2008-02-21
file: by_date/futures_1hour/2008/2008-02-21.parquet size: 33 KB rows: 902
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-02-21 00:00:00 | ES | Futures | 1270.93 | 1272.1 | 1270.0 | 1271.63 | 1102.0 |
| 2008-02-21 01:00:00 | ES | Futures | 1271.63 | 1271.87 | 1269.77 | 1270.47 | 919.0 |
| 2008-02-21 02:00:00 | ES | Futures | 1270.23 | 1271.17 | 1266.5 | 1267.9 | 6334.0 |
| 2008-02-21 03:00:00 | ES | Futures | 1267.9 | 1269.07 | 1265.11 | 1267.9 | 16874.0 |
| 2008-02-21 04:00:00 | ES | Futures | 1267.67 | 1270.47 | 1266.74 | 1270.47 | 11979.0 |
| 2008-02-21 05:00:00 | ES | Futures | 1270.47 | 1271.87 | 1268.84 | 1269.77 | 10918.0 |
| 2008-02-21 06:00:00 | ES | Futures | 1269.77 | 1275.83 | 1269.77 | 1274.9 | 27167.0 |
| 2008-02-21 07:00:00 | ES | Futures | 1274.66 | 1276.3 | 1273.03 | 1273.5 | 29301.0 |
| 2008-02-21 08:00:00 | ES | Futures | 1273.73 | 1275.83 | 1271.87 | 1274.2 | 39955.0 |
| 2008-02-21 09:00:00 | ES | Futures | 1274.2 | 1277.0 | 1271.63 | 1273.27 | 171443.0 |
| 2008-02-21 10:00:00 | ES | Futures | 1273.27 | 1273.73 | 1262.31 | 1262.54 | 400662.0 |
| 2008-02-21 11:00:00 | ES | Futures | 1262.54 | 1268.6 | 1262.07 | 1267.9 | 232174.0 |
| 2008-02-21 12:00:00 | ES | Futures | 1267.67 | 1267.9 | 1259.74 | 1262.07 | 188722.0 |
| 2008-02-21 13:00:00 | ES | Futures | 1262.31 | 1262.54 | 1254.38 | 1257.41 | 222630.0 |
| 2008-02-21 14:00:00 | ES | Futures | 1257.41 | 1261.37 | 1255.55 | 1256.94 | 203863.0 |
| 2008-02-21 15:00:00 | ES | Futures | 1256.71 | 1256.94 | 1249.02 | 1253.21 | 351057.0 |
| 2008-02-21 16:00:00 | ES | Futures | 1253.21 | 1256.48 | 1252.05 | 1254.38 | 83694.0 |
| 2008-02-21 17:00:00 | ES | Futures | 1254.15 | 1254.61 | 1252.75 | 1253.68 | 3465.0 |
| 2008-02-21 18:00:00 | ES | Futures | 1253.68 | 1253.91 | 1252.51 | 1253.45 | 3060.0 |
| 2008-02-21 19:00:00 | ES | Futures | 1253.68 | 1254.38 | 1252.75 | 1252.98 | 3887.0 |
| 2008-02-21 20:00:00 | ES | Futures | 1252.75 | 1253.91 | 1252.51 | 1253.45 | 1758.0 |
| 2008-02-21 21:00:00 | ES | Futures | 1253.45 | 1253.91 | 1252.75 | 1253.68 | 1136.0 |
| 2008-02-21 22:00:00 | ES | Futures | 1253.91 | 1254.38 | 1252.28 | 1252.75 | 1833.0 |
| 2008-02-21 23:00:00 | ES | Futures | 1252.75 | 1253.91 | 1252.05 | 1252.75 | 2057.0 |
| 2008-02-21 00:00:00 | NQ | Futures | 2037.43 | 2038.57 | 2034.59 | 2038.28 | 222.0 |
| 2008-02-21 01:00:00 | NQ | Futures | 2038.0 | 2038.85 | 2036.86 | 2038.28 | 110.0 |
| 2008-02-21 02:00:00 | NQ | Futures | 2037.71 | 2038.28 | 2031.47 | 2034.02 | 353.0 |
| 2008-02-21 03:00:00 | NQ | Futures | 2034.02 | 2036.01 | 2029.2 | 2033.74 | 841.0 |
| 2008-02-21 04:00:00 | NQ | Futures | 2033.46 | 2038.0 | 2031.47 | 2038.0 | 920.0 |
| 2008-02-21 05:00:00 | NQ | Futures | 2038.0 | 2045.66 | 2035.16 | 2038.57 | 2664.0 |
| 2008-02-21 06:00:00 | NQ | Futures | 2038.57 | 2049.35 | 2038.28 | 2047.65 | 2171.0 |
| 2008-02-21 07:00:00 | NQ | Futures | 2047.65 | 2053.61 | 2047.36 | 2052.19 | 3318.0 |
| 2008-02-21 08:00:00 | NQ | Futures | 2052.19 | 2055.88 | 2049.64 | 2052.47 | 7759.0 |
| 2008-02-21 09:00:00 | NQ | Futures | 2052.47 | 2055.88 | 2046.23 | 2050.2 | 44518.0 |
| 2008-02-21 10:00:00 | NQ | Futures | 2050.49 | 2053.04 | 2027.5 | 2027.78 | 75550.0 |
| 2008-02-21 11:00:00 | NQ | Futures | 2027.78 | 2035.16 | 2025.79 | 2032.04 | 47493.0 |
| 2008-02-21 12:00:00 | NQ | Futures | 2032.04 | 2032.04 | 2016.99 | 2024.37 | 39278.0 |
| 2008-02-21 13:00:00 | NQ | Futures | 2024.09 | 2025.22 | 2012.45 | 2015.86 | 38035.0 |
| 2008-02-21 14:00:00 | NQ | Futures | 2016.43 | 2025.79 | 2014.72 | 2017.84 | 35105.0 |
| 2008-02-21 15:00:00 | NQ | Futures | 2017.56 | 2017.84 | 2003.65 | 2010.75 | 59069.0 |
| 2008-02-21 16:00:00 | NQ | Futures | 2010.18 | 2018.7 | 2006.77 | 2013.02 | 12356.0 |
| 2008-02-21 17:00:00 | NQ | Futures | 2012.74 | 2013.3 | 2010.18 | 2011.6 | 253.0 |
| 2008-02-21 18:00:00 | NQ | Futures | 2011.6 | 2013.3 | 2011.03 | 2013.02 | 144.0 |
| 2008-02-21 19:00:00 | NQ | Futures | 2013.02 | 2014.15 | 2010.46 | 2010.46 | 173.0 |
| 2008-02-21 20:00:00 | NQ | Futures | 2010.46 | 2014.15 | 2009.05 | 2013.02 | 206.0 |
| 2008-02-21 21:00:00 | NQ | Futures | 2014.15 | 2014.44 | 2012.45 | 2014.15 | 140.0 |
| 2008-02-21 22:00:00 | NQ | Futures | 2014.44 | 2016.43 | 2011.88 | 2011.88 | 149.0 |
| 2008-02-21 23:00:00 | NQ | Futures | 2011.32 | 2015.01 | 2010.46 | 2012.17 | 55.0 |
| 2008-02-21 00:00:00 | YM | Futures | 11319.9 | 11325.3 | 11315.3 | 11321.7 | 78.0 |
| 2008-02-21 01:00:00 | YM | Futures | 11321.7 | 11326.2 | 11313.5 | 11313.5 | 103.0 |
> showing 50 of 902 rows — these rows as CSV