PREVIEW / futures_1hour / 2008-06-06
file: by_date/futures_1hour/2008/2008-06-06.parquet size: 37 KB rows: 1,004
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-06 00:00:00 | ES | Futures | 1308.58 | 1309.05 | 1308.35 | 1308.35 | 374.0 |
| 2008-06-06 01:00:00 | ES | Futures | 1308.35 | 1309.28 | 1308.12 | 1308.12 | 1177.0 |
| 2008-06-06 02:00:00 | ES | Futures | 1308.12 | 1308.35 | 1306.95 | 1307.18 | 5243.0 |
| 2008-06-06 03:00:00 | ES | Futures | 1307.18 | 1314.17 | 1307.18 | 1311.38 | 17888.0 |
| 2008-06-06 04:00:00 | ES | Futures | 1311.14 | 1311.84 | 1309.28 | 1310.44 | 7861.0 |
| 2008-06-06 05:00:00 | ES | Futures | 1310.21 | 1310.44 | 1306.49 | 1308.35 | 15870.0 |
| 2008-06-06 06:00:00 | ES | Futures | 1308.35 | 1310.21 | 1306.25 | 1310.21 | 11542.0 |
| 2008-06-06 07:00:00 | ES | Futures | 1309.98 | 1310.21 | 1306.95 | 1309.05 | 14705.0 |
| 2008-06-06 08:00:00 | ES | Futures | 1309.05 | 1313.24 | 1299.97 | 1302.29 | 151089.0 |
| 2008-06-06 09:00:00 | ES | Futures | 1302.29 | 1302.29 | 1294.61 | 1295.31 | 310744.0 |
| 2008-06-06 10:00:00 | ES | Futures | 1295.54 | 1295.54 | 1286.23 | 1288.32 | 460003.0 |
| 2008-06-06 11:00:00 | ES | Futures | 1288.32 | 1288.56 | 1281.34 | 1284.83 | 318850.0 |
| 2008-06-06 12:00:00 | ES | Futures | 1284.83 | 1286.93 | 1282.27 | 1284.13 | 159520.0 |
| 2008-06-06 13:00:00 | ES | Futures | 1284.37 | 1285.3 | 1279.94 | 1282.5 | 237286.0 |
| 2008-06-06 14:00:00 | ES | Futures | 1282.5 | 1282.5 | 1273.89 | 1274.35 | 338215.0 |
| 2008-06-06 15:00:00 | ES | Futures | 1274.35 | 1282.04 | 1266.2 | 1266.67 | 510862.0 |
| 2008-06-06 16:00:00 | ES | Futures | 1266.67 | 1267.6 | 1265.27 | 1265.97 | 127635.0 |
| 2008-06-06 00:00:00 | NQ | Futures | 2326.27 | 2326.27 | 2324.29 | 2325.13 | 207.0 |
| 2008-06-06 01:00:00 | NQ | Futures | 2324.85 | 2325.98 | 2323.72 | 2324.85 | 199.0 |
| 2008-06-06 02:00:00 | NQ | Futures | 2324.85 | 2324.85 | 2322.31 | 2322.31 | 542.0 |
| 2008-06-06 03:00:00 | NQ | Futures | 2322.59 | 2333.62 | 2322.59 | 2331.07 | 2402.0 |
| 2008-06-06 04:00:00 | NQ | Futures | 2330.79 | 2331.07 | 2326.83 | 2328.81 | 1424.0 |
| 2008-06-06 05:00:00 | NQ | Futures | 2328.81 | 2330.23 | 2322.59 | 2325.7 | 1266.0 |
| 2008-06-06 06:00:00 | NQ | Futures | 2325.7 | 2329.38 | 2322.31 | 2329.09 | 440.0 |
| 2008-06-06 07:00:00 | NQ | Futures | 2329.09 | 2329.09 | 2322.59 | 2327.68 | 803.0 |
| 2008-06-06 08:00:00 | NQ | Futures | 2327.4 | 2332.2 | 2310.99 | 2315.8 | 16770.0 |
| 2008-06-06 09:00:00 | NQ | Futures | 2316.08 | 2316.08 | 2295.72 | 2302.51 | 65799.0 |
| 2008-06-06 10:00:00 | NQ | Futures | 2302.51 | 2302.79 | 2288.93 | 2291.19 | 76466.0 |
| 2008-06-06 11:00:00 | NQ | Futures | 2290.91 | 2291.76 | 2279.03 | 2284.41 | 64540.0 |
| 2008-06-06 12:00:00 | NQ | Futures | 2284.41 | 2290.91 | 2279.6 | 2285.82 | 33190.0 |
| 2008-06-06 13:00:00 | NQ | Futures | 2285.82 | 2286.67 | 2274.22 | 2277.9 | 49391.0 |
| 2008-06-06 14:00:00 | NQ | Futures | 2277.62 | 2278.47 | 2256.69 | 2257.54 | 92464.0 |
| 2008-06-06 15:00:00 | NQ | Futures | 2257.54 | 2275.92 | 2254.43 | 2254.43 | 99353.0 |
| 2008-06-06 16:00:00 | NQ | Futures | 2254.71 | 2254.71 | 2247.92 | 2249.9 | 17511.0 |
| 2008-06-06 00:00:00 | YM | Futures | 11463.5 | 11467.2 | 11460.8 | 11467.2 | 50.0 |
| 2008-06-06 01:00:00 | YM | Futures | 11465.4 | 11471.7 | 11461.7 | 11462.6 | 45.0 |
| 2008-06-06 02:00:00 | YM | Futures | 11461.7 | 11462.6 | 11455.4 | 11455.4 | 271.0 |
| 2008-06-06 03:00:00 | YM | Futures | 11456.3 | 11501.7 | 11456.3 | 11489.0 | 1546.0 |
| 2008-06-06 04:00:00 | YM | Futures | 11489.0 | 11490.8 | 11470.8 | 11481.7 | 421.0 |
| 2008-06-06 05:00:00 | YM | Futures | 11480.8 | 11481.7 | 11452.6 | 11470.8 | 1054.0 |
| 2008-06-06 06:00:00 | YM | Futures | 11470.8 | 11479.9 | 11450.8 | 11478.1 | 885.0 |
| 2008-06-06 07:00:00 | YM | Futures | 11478.1 | 11479.9 | 11454.5 | 11467.2 | 921.0 |
| 2008-06-06 08:00:00 | YM | Futures | 11467.2 | 11503.5 | 11399.9 | 11416.3 | 9600.0 |
| 2008-06-06 09:00:00 | YM | Futures | 11417.2 | 11417.2 | 11289.1 | 11294.5 | 30370.0 |
| 2008-06-06 10:00:00 | YM | Futures | 11294.5 | 11297.3 | 11233.7 | 11253.6 | 43982.0 |
| 2008-06-06 11:00:00 | YM | Futures | 11254.6 | 11258.2 | 11183.7 | 11218.2 | 36606.0 |
| 2008-06-06 12:00:00 | YM | Futures | 11217.3 | 11228.2 | 11193.7 | 11207.3 | 19854.0 |
| 2008-06-06 13:00:00 | YM | Futures | 11205.5 | 11216.4 | 11170.1 | 11197.3 | 27100.0 |
| 2008-06-06 14:00:00 | YM | Futures | 11196.4 | 11198.2 | 11132.8 | 11141.0 | 36973.0 |
| 2008-06-06 15:00:00 | YM | Futures | 11141.0 | 11200.9 | 11082.8 | 11086.5 | 46863.0 |
> showing 50 of 1,004 rows — these rows as CSV