PREVIEW / futures_1hour / 2008-06-12
file: by_date/futures_1hour/2008/2008-06-12.parquet size: 42 KB rows: 1,202
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-06-12 00:00:00 | ES | Futures | 1246.18 | 1246.41 | 1245.48 | 1245.71 | 1173.0 |
| 2008-06-12 01:00:00 | ES | Futures | 1245.71 | 1246.41 | 1245.02 | 1246.18 | 1190.0 |
| 2008-06-12 02:00:00 | ES | Futures | 1246.18 | 1248.28 | 1245.95 | 1247.34 | 5959.0 |
| 2008-06-12 03:00:00 | ES | Futures | 1247.58 | 1250.14 | 1247.34 | 1249.67 | 15168.0 |
| 2008-06-12 04:00:00 | ES | Futures | 1249.67 | 1251.3 | 1247.34 | 1247.81 | 14392.0 |
| 2008-06-12 05:00:00 | ES | Futures | 1247.81 | 1249.44 | 1247.81 | 1248.74 | 10313.0 |
| 2008-06-12 06:00:00 | ES | Futures | 1248.74 | 1252.47 | 1248.28 | 1252.23 | 16651.0 |
| 2008-06-12 07:00:00 | ES | Futures | 1252.23 | 1253.63 | 1251.07 | 1253.4 | 30028.0 |
| 2008-06-12 08:00:00 | ES | Futures | 1253.4 | 1256.89 | 1248.28 | 1253.4 | 117258.0 |
| 2008-06-12 09:00:00 | ES | Futures | 1253.63 | 1259.68 | 1248.97 | 1257.36 | 183339.0 |
| 2008-06-12 10:00:00 | ES | Futures | 1257.59 | 1260.62 | 1253.4 | 1257.12 | 149235.0 |
| 2008-06-12 11:00:00 | ES | Futures | 1257.12 | 1260.15 | 1255.03 | 1255.73 | 68998.0 |
| 2008-06-12 12:00:00 | ES | Futures | 1255.73 | 1258.52 | 1254.56 | 1255.26 | 52183.0 |
| 2008-06-12 13:00:00 | ES | Futures | 1255.03 | 1256.89 | 1249.21 | 1250.6 | 67997.0 |
| 2008-06-12 14:00:00 | ES | Futures | 1250.84 | 1252.23 | 1245.25 | 1248.97 | 84504.0 |
| 2008-06-12 15:00:00 | ES | Futures | 1248.74 | 1249.44 | 1239.66 | 1248.28 | 168928.0 |
| 2008-06-12 16:00:00 | ES | Futures | 1248.51 | 1250.37 | 1247.11 | 1249.67 | 27061.0 |
| 2008-06-12 17:00:00 | ES | Futures | 1249.44 | 1251.53 | 1249.21 | 1249.44 | 2039.0 |
| 2008-06-12 18:00:00 | ES | Futures | 1249.44 | 1250.84 | 1249.21 | 1250.37 | 836.0 |
| 2008-06-12 19:00:00 | ES | Futures | 1250.6 | 1251.07 | 1248.97 | 1249.9 | 676.0 |
| 2008-06-12 20:00:00 | ES | Futures | 1249.9 | 1251.77 | 1249.21 | 1249.67 | 972.0 |
| 2008-06-12 21:00:00 | ES | Futures | 1249.67 | 1250.6 | 1248.04 | 1248.51 | 1138.0 |
| 2008-06-12 22:00:00 | ES | Futures | 1248.51 | 1248.74 | 1247.58 | 1248.04 | 377.0 |
| 2008-06-12 23:00:00 | ES | Futures | 1248.04 | 1248.97 | 1247.81 | 1248.51 | 389.0 |
| 2008-06-12 00:00:00 | NQ | Futures | 2180.61 | 2183.15 | 2180.04 | 2182.02 | 205.0 |
| 2008-06-12 01:00:00 | NQ | Futures | 2182.59 | 2183.44 | 2180.61 | 2181.74 | 147.0 |
| 2008-06-12 02:00:00 | NQ | Futures | 2182.31 | 2186.27 | 2181.46 | 2186.27 | 493.0 |
| 2008-06-12 03:00:00 | NQ | Futures | 2185.7 | 2190.79 | 2185.7 | 2189.94 | 1372.0 |
| 2008-06-12 04:00:00 | NQ | Futures | 2189.94 | 2192.2 | 2185.13 | 2185.42 | 1247.0 |
| 2008-06-12 05:00:00 | NQ | Futures | 2185.7 | 2187.68 | 2185.42 | 2186.83 | 753.0 |
| 2008-06-12 06:00:00 | NQ | Futures | 2186.55 | 2193.05 | 2186.27 | 2192.49 | 1145.0 |
| 2008-06-12 07:00:00 | NQ | Futures | 2193.05 | 2195.6 | 2190.22 | 2195.03 | 2743.0 |
| 2008-06-12 08:00:00 | NQ | Futures | 2194.75 | 2200.12 | 2187.96 | 2194.47 | 13787.0 |
| 2008-06-12 09:00:00 | NQ | Futures | 2194.18 | 2212.85 | 2189.66 | 2207.19 | 36633.0 |
| 2008-06-12 10:00:00 | NQ | Futures | 2207.19 | 2210.87 | 2187.11 | 2201.82 | 37691.0 |
| 2008-06-12 11:00:00 | NQ | Futures | 2201.54 | 2208.89 | 2194.18 | 2196.73 | 17419.0 |
| 2008-06-12 12:00:00 | NQ | Futures | 2196.73 | 2204.37 | 2191.64 | 2191.92 | 8247.0 |
| 2008-06-12 13:00:00 | NQ | Futures | 2191.64 | 2195.6 | 2181.17 | 2185.98 | 13294.0 |
| 2008-06-12 14:00:00 | NQ | Futures | 2185.98 | 2189.38 | 2165.34 | 2177.21 | 21050.0 |
| 2008-06-12 15:00:00 | NQ | Futures | 2177.21 | 2182.02 | 2161.09 | 2180.61 | 31589.0 |
| 2008-06-12 16:00:00 | NQ | Futures | 2180.33 | 2188.53 | 2180.04 | 2185.42 | 4474.0 |
| 2008-06-12 17:00:00 | NQ | Futures | 2184.0 | 2186.27 | 2183.15 | 2183.44 | 50.0 |
| 2008-06-12 18:00:00 | NQ | Futures | 2182.59 | 2184.57 | 2181.17 | 2183.15 | 16.0 |
| 2008-06-12 19:00:00 | NQ | Futures | 2184.57 | 2185.13 | 2183.15 | 2183.44 | 15.0 |
| 2008-06-12 20:00:00 | NQ | Futures | 2185.13 | 2185.13 | 2183.44 | 2183.72 | 18.0 |
| 2008-06-12 21:00:00 | NQ | Futures | 2182.59 | 2184.0 | 2181.74 | 2183.15 | 17.0 |
| 2008-06-12 22:00:00 | NQ | Futures | 2182.02 | 2182.02 | 2180.04 | 2180.61 | 15.0 |
| 2008-06-12 23:00:00 | NQ | Futures | 2180.61 | 2181.74 | 2180.61 | 2181.17 | 16.0 |
| 2008-06-12 00:00:00 | YM | Futures | 11017.4 | 11017.4 | 11011.0 | 11015.6 | 9.0 |
| 2008-06-12 01:00:00 | YM | Futures | 11011.9 | 11011.9 | 11001.9 | 11006.5 | 19.0 |
> showing 50 of 1,202 rows — these rows as CSV