PREVIEW / futures_1hour / 2008-02-25
file: by_date/futures_1hour/2008/2008-02-25.parquet size: 37 KB rows: 1,090
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-25 00:00:00 | ES | Futures | 1271.17 | 1271.4 | 1270.47 | 1271.17 | 1359.0 |
| 2008-02-25 01:00:00 | ES | Futures | 1271.4 | 1272.1 | 1270.23 | 1270.47 | 3462.0 |
| 2008-02-25 02:00:00 | ES | Futures | 1270.47 | 1270.47 | 1266.5 | 1266.97 | 7873.0 |
| 2008-02-25 03:00:00 | ES | Futures | 1267.2 | 1269.07 | 1264.87 | 1268.37 | 15861.0 |
| 2008-02-25 04:00:00 | ES | Futures | 1268.6 | 1270.93 | 1267.67 | 1268.6 | 13455.0 |
| 2008-02-25 05:00:00 | ES | Futures | 1268.37 | 1268.84 | 1266.74 | 1268.14 | 4651.0 |
| 2008-02-25 06:00:00 | ES | Futures | 1268.14 | 1269.54 | 1266.74 | 1267.2 | 4723.0 |
| 2008-02-25 07:00:00 | ES | Futures | 1266.97 | 1267.67 | 1263.47 | 1264.64 | 17946.0 |
| 2008-02-25 08:00:00 | ES | Futures | 1264.64 | 1265.8 | 1261.84 | 1263.47 | 32657.0 |
| 2008-02-25 09:00:00 | ES | Futures | 1263.24 | 1265.8 | 1256.48 | 1257.18 | 190154.0 |
| 2008-02-25 10:00:00 | ES | Futures | 1257.18 | 1272.1 | 1255.55 | 1271.17 | 367120.0 |
| 2008-02-25 11:00:00 | ES | Futures | 1271.17 | 1271.63 | 1262.54 | 1263.24 | 189276.0 |
| 2008-02-25 12:00:00 | ES | Futures | 1263.24 | 1266.04 | 1261.14 | 1264.87 | 118626.0 |
| 2008-02-25 13:00:00 | ES | Futures | 1264.64 | 1267.9 | 1259.98 | 1264.87 | 129367.0 |
| 2008-02-25 14:00:00 | ES | Futures | 1264.87 | 1279.09 | 1263.01 | 1272.33 | 468956.0 |
| 2008-02-25 15:00:00 | ES | Futures | 1272.1 | 1282.83 | 1269.07 | 1279.56 | 373887.0 |
| 2008-02-25 16:00:00 | ES | Futures | 1279.56 | 1281.43 | 1278.4 | 1279.09 | 76646.0 |
| 2008-02-25 17:00:00 | ES | Futures | 1278.86 | 1279.56 | 1277.93 | 1277.93 | 3897.0 |
| 2008-02-25 18:00:00 | ES | Futures | 1277.7 | 1279.09 | 1277.46 | 1277.7 | 3741.0 |
| 2008-02-25 19:00:00 | ES | Futures | 1277.7 | 1279.79 | 1277.23 | 1279.56 | 2070.0 |
| 2008-02-25 20:00:00 | ES | Futures | 1279.33 | 1279.79 | 1278.4 | 1279.79 | 1355.0 |
| 2008-02-25 21:00:00 | ES | Futures | 1279.56 | 1280.03 | 1278.86 | 1279.56 | 1073.0 |
| 2008-02-25 22:00:00 | ES | Futures | 1279.33 | 1280.49 | 1278.86 | 1279.09 | 2039.0 |
| 2008-02-25 23:00:00 | ES | Futures | 1279.09 | 1279.33 | 1276.76 | 1278.4 | 2629.0 |
| 2008-02-25 00:00:00 | NQ | Futures | 2031.75 | 2032.6 | 2029.77 | 2032.04 | 142.0 |
| 2008-02-25 01:00:00 | NQ | Futures | 2032.6 | 2034.02 | 2031.47 | 2031.47 | 179.0 |
| 2008-02-25 02:00:00 | NQ | Futures | 2030.62 | 2030.62 | 2024.66 | 2026.64 | 377.0 |
| 2008-02-25 03:00:00 | NQ | Futures | 2026.08 | 2029.48 | 2022.1 | 2026.93 | 835.0 |
| 2008-02-25 04:00:00 | NQ | Futures | 2027.78 | 2032.04 | 2026.08 | 2027.78 | 726.0 |
| 2008-02-25 05:00:00 | NQ | Futures | 2027.5 | 2028.06 | 2021.82 | 2024.94 | 902.0 |
| 2008-02-25 06:00:00 | NQ | Futures | 2025.51 | 2027.21 | 2022.67 | 2023.52 | 942.0 |
| 2008-02-25 07:00:00 | NQ | Futures | 2023.24 | 2024.37 | 2016.99 | 2018.98 | 2011.0 |
| 2008-02-25 08:00:00 | NQ | Futures | 2019.26 | 2020.12 | 2014.15 | 2016.14 | 4036.0 |
| 2008-02-25 09:00:00 | NQ | Futures | 2016.14 | 2020.97 | 2005.64 | 2007.34 | 41145.0 |
| 2008-02-25 10:00:00 | NQ | Futures | 2006.77 | 2032.04 | 2003.65 | 2028.63 | 74498.0 |
| 2008-02-25 11:00:00 | NQ | Futures | 2028.63 | 2030.62 | 2016.71 | 2017.84 | 36231.0 |
| 2008-02-25 12:00:00 | NQ | Futures | 2017.84 | 2020.12 | 2011.6 | 2018.98 | 31675.0 |
| 2008-02-25 13:00:00 | NQ | Futures | 2018.7 | 2022.39 | 2003.37 | 2011.88 | 29766.0 |
| 2008-02-25 14:00:00 | NQ | Futures | 2011.6 | 2034.59 | 2007.91 | 2020.4 | 83692.0 |
| 2008-02-25 15:00:00 | NQ | Futures | 2020.68 | 2037.71 | 2015.57 | 2029.48 | 65015.0 |
| 2008-02-25 16:00:00 | NQ | Futures | 2029.2 | 2030.62 | 2026.36 | 2029.2 | 10101.0 |
| 2008-02-25 17:00:00 | NQ | Futures | 2028.35 | 2030.9 | 2028.35 | 2029.77 | 310.0 |
| 2008-02-25 18:00:00 | NQ | Futures | 2029.77 | 2030.05 | 2028.35 | 2028.35 | 301.0 |
| 2008-02-25 19:00:00 | NQ | Futures | 2027.78 | 2032.04 | 2027.78 | 2031.47 | 106.0 |
| 2008-02-25 20:00:00 | NQ | Futures | 2031.19 | 2031.19 | 2029.48 | 2030.62 | 36.0 |
| 2008-02-25 21:00:00 | NQ | Futures | 2030.62 | 2032.04 | 2030.62 | 2031.19 | 52.0 |
| 2008-02-25 22:00:00 | NQ | Futures | 2031.47 | 2034.31 | 2030.33 | 2030.9 | 62.0 |
| 2008-02-25 23:00:00 | NQ | Futures | 2030.62 | 2031.19 | 2026.93 | 2027.5 | 69.0 |
| 2008-02-25 00:00:00 | YM | Futures | 11310.8 | 11315.3 | 11305.4 | 11314.4 | 63.0 |
| 2008-02-25 01:00:00 | YM | Futures | 11314.4 | 11322.6 | 11303.5 | 11308.1 | 421.0 |
> showing 50 of 1,090 rows — these rows as CSV