PREVIEW / futures_1hour / 2008-02-18
file: by_date/futures_1hour/2008/2008-02-18.parquet size: 25 KB rows: 650
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-18 00:00:00 | ES | Futures | 1258.58 | 1259.04 | 1257.64 | 1257.64 | 902.0 |
| 2008-02-18 01:00:00 | ES | Futures | 1258.11 | 1258.81 | 1256.94 | 1258.34 | 904.0 |
| 2008-02-18 02:00:00 | ES | Futures | 1258.11 | 1259.04 | 1256.71 | 1259.04 | 2832.0 |
| 2008-02-18 03:00:00 | ES | Futures | 1259.04 | 1259.74 | 1257.18 | 1257.18 | 9512.0 |
| 2008-02-18 04:00:00 | ES | Futures | 1257.18 | 1264.64 | 1256.94 | 1264.41 | 12972.0 |
| 2008-02-18 05:00:00 | ES | Futures | 1264.41 | 1266.74 | 1263.94 | 1265.57 | 11383.0 |
| 2008-02-18 06:00:00 | ES | Futures | 1265.57 | 1265.8 | 1263.47 | 1263.47 | 6494.0 |
| 2008-02-18 07:00:00 | ES | Futures | 1263.47 | 1265.57 | 1263.24 | 1263.94 | 5845.0 |
| 2008-02-18 08:00:00 | ES | Futures | 1263.94 | 1265.57 | 1262.07 | 1265.34 | 5985.0 |
| 2008-02-18 09:00:00 | ES | Futures | 1265.34 | 1268.37 | 1264.41 | 1268.14 | 11365.0 |
| 2008-02-18 10:00:00 | ES | Futures | 1267.9 | 1273.5 | 1267.9 | 1272.57 | 25879.0 |
| 2008-02-18 11:00:00 | ES | Futures | 1272.57 | 1276.3 | 1271.87 | 1275.83 | 19195.0 |
| 2008-02-18 18:00:00 | ES | Futures | 1273.97 | 1274.2 | 1271.63 | 1272.57 | 5487.0 |
| 2008-02-18 19:00:00 | ES | Futures | 1272.33 | 1273.73 | 1272.33 | 1273.27 | 1320.0 |
| 2008-02-18 20:00:00 | ES | Futures | 1273.27 | 1273.73 | 1272.57 | 1273.27 | 1376.0 |
| 2008-02-18 21:00:00 | ES | Futures | 1273.03 | 1273.5 | 1272.1 | 1273.5 | 1623.0 |
| 2008-02-18 22:00:00 | ES | Futures | 1273.27 | 1274.2 | 1272.1 | 1272.57 | 1262.0 |
| 2008-02-18 23:00:00 | ES | Futures | 1272.57 | 1273.5 | 1272.33 | 1272.33 | 1336.0 |
| 2008-02-18 00:00:00 | NQ | Futures | 2028.63 | 2028.91 | 2027.5 | 2027.78 | 24.0 |
| 2008-02-18 01:00:00 | NQ | Futures | 2028.63 | 2030.05 | 2026.08 | 2027.5 | 156.0 |
| 2008-02-18 02:00:00 | NQ | Futures | 2026.93 | 2029.2 | 2025.79 | 2027.5 | 214.0 |
| 2008-02-18 03:00:00 | NQ | Futures | 2028.91 | 2031.19 | 2027.78 | 2027.78 | 1275.0 |
| 2008-02-18 04:00:00 | NQ | Futures | 2027.78 | 2039.42 | 2027.78 | 2039.13 | 974.0 |
| 2008-02-18 05:00:00 | NQ | Futures | 2039.13 | 2043.39 | 2038.0 | 2041.97 | 706.0 |
| 2008-02-18 06:00:00 | NQ | Futures | 2041.97 | 2041.97 | 2037.43 | 2037.43 | 350.0 |
| 2008-02-18 07:00:00 | NQ | Futures | 2038.28 | 2041.12 | 2037.43 | 2039.98 | 291.0 |
| 2008-02-18 08:00:00 | NQ | Futures | 2039.7 | 2041.4 | 2037.15 | 2041.4 | 299.0 |
| 2008-02-18 09:00:00 | NQ | Futures | 2041.4 | 2047.65 | 2040.27 | 2047.65 | 1876.0 |
| 2008-02-18 10:00:00 | NQ | Futures | 2047.93 | 2062.69 | 2047.93 | 2059.57 | 5089.0 |
| 2008-02-18 11:00:00 | NQ | Futures | 2059.57 | 2067.52 | 2058.43 | 2066.1 | 3614.0 |
| 2008-02-18 18:00:00 | NQ | Futures | 2063.26 | 2063.26 | 2057.3 | 2058.15 | 696.0 |
| 2008-02-18 19:00:00 | NQ | Futures | 2059.0 | 2061.56 | 2059.0 | 2060.71 | 86.0 |
| 2008-02-18 20:00:00 | NQ | Futures | 2060.71 | 2061.27 | 2059.57 | 2059.57 | 81.0 |
| 2008-02-18 21:00:00 | NQ | Futures | 2059.57 | 2059.85 | 2056.73 | 2059.0 | 375.0 |
| 2008-02-18 22:00:00 | NQ | Futures | 2059.29 | 2060.71 | 2057.02 | 2057.02 | 117.0 |
| 2008-02-18 23:00:00 | NQ | Futures | 2057.58 | 2059.29 | 2057.02 | 2058.43 | 54.0 |
| 2008-02-18 00:00:00 | YM | Futures | 11209.0 | 11214.5 | 11203.6 | 11206.3 | 70.0 |
| 2008-02-18 01:00:00 | YM | Futures | 11204.5 | 11208.1 | 11201.8 | 11208.1 | 87.0 |
| 2008-02-18 02:00:00 | YM | Futures | 11207.2 | 11210.9 | 11197.2 | 11210.9 | 194.0 |
| 2008-02-18 03:00:00 | YM | Futures | 11210.9 | 11221.8 | 11202.7 | 11205.4 | 515.0 |
| 2008-02-18 04:00:00 | YM | Futures | 11203.6 | 11257.2 | 11203.6 | 11253.6 | 676.0 |
| 2008-02-18 05:00:00 | YM | Futures | 11253.6 | 11269.9 | 11252.7 | 11262.7 | 467.0 |
| 2008-02-18 06:00:00 | YM | Futures | 11263.6 | 11264.5 | 11247.2 | 11247.2 | 236.0 |
| 2008-02-18 07:00:00 | YM | Futures | 11246.3 | 11259.0 | 11243.6 | 11250.8 | 214.0 |
| 2008-02-18 08:00:00 | YM | Futures | 11249.9 | 11259.9 | 11238.1 | 11259.9 | 230.0 |
| 2008-02-18 09:00:00 | YM | Futures | 11259.9 | 11286.3 | 11259.0 | 11286.3 | 890.0 |
| 2008-02-18 10:00:00 | YM | Futures | 11287.2 | 11344.4 | 11286.3 | 11328.1 | 3653.0 |
| 2008-02-18 11:00:00 | YM | Futures | 11329.0 | 11355.3 | 11323.5 | 11353.5 | 726.0 |
| 2008-02-18 18:00:00 | YM | Futures | 11343.5 | 11346.2 | 11217.2 | 11326.2 | 367.0 |
| 2008-02-18 19:00:00 | YM | Futures | 11327.2 | 11338.1 | 11323.5 | 11333.5 | 228.0 |
> showing 50 of 650 rows — these rows as CSV