PREVIEW / futures_1hour / 2008-01-04
file: by_date/futures_1hour/2008/2008-01-04.parquet size: 24 KB rows: 591
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-01-04 00:00:00 | ES | Futures | 1363.5 | 1364.2 | 1363.26 | 1363.73 | 2146.0 |
| 2008-01-04 01:00:00 | ES | Futures | 1363.96 | 1364.43 | 1363.5 | 1363.96 | 925.0 |
| 2008-01-04 02:00:00 | ES | Futures | 1363.96 | 1364.2 | 1362.1 | 1362.1 | 3117.0 |
| 2008-01-04 03:00:00 | ES | Futures | 1362.33 | 1363.26 | 1361.4 | 1362.56 | 9102.0 |
| 2008-01-04 04:00:00 | ES | Futures | 1362.56 | 1364.43 | 1362.33 | 1363.73 | 7108.0 |
| 2008-01-04 05:00:00 | ES | Futures | 1363.96 | 1364.66 | 1363.03 | 1363.96 | 6876.0 |
| 2008-01-04 06:00:00 | ES | Futures | 1363.73 | 1364.43 | 1363.03 | 1363.73 | 4412.0 |
| 2008-01-04 07:00:00 | ES | Futures | 1363.73 | 1363.73 | 1361.4 | 1363.03 | 11540.0 |
| 2008-01-04 08:00:00 | ES | Futures | 1363.26 | 1364.66 | 1345.08 | 1346.24 | 163529.0 |
| 2008-01-04 09:00:00 | ES | Futures | 1346.48 | 1346.71 | 1339.25 | 1342.05 | 261912.0 |
| 2008-01-04 10:00:00 | ES | Futures | 1341.81 | 1344.15 | 1331.32 | 1332.25 | 353663.0 |
| 2008-01-04 11:00:00 | ES | Futures | 1332.25 | 1337.38 | 1330.16 | 1335.75 | 248241.0 |
| 2008-01-04 12:00:00 | ES | Futures | 1335.98 | 1339.48 | 1332.02 | 1334.12 | 154077.0 |
| 2008-01-04 13:00:00 | ES | Futures | 1334.12 | 1334.82 | 1328.06 | 1332.95 | 181364.0 |
| 2008-01-04 14:00:00 | ES | Futures | 1332.72 | 1332.95 | 1322.93 | 1327.82 | 287247.0 |
| 2008-01-04 15:00:00 | ES | Futures | 1327.82 | 1330.62 | 1322.23 | 1322.46 | 360334.0 |
| 2008-01-04 16:00:00 | ES | Futures | 1322.23 | 1327.36 | 1322.0 | 1326.66 | 115375.0 |
| 2008-01-04 00:00:00 | NQ | Futures | 2362.15 | 2362.15 | 2358.46 | 2360.16 | 210.0 |
| 2008-01-04 01:00:00 | NQ | Futures | 2360.44 | 2361.58 | 2360.16 | 2361.3 | 78.0 |
| 2008-01-04 02:00:00 | NQ | Futures | 2360.44 | 2361.01 | 2356.75 | 2357.61 | 127.0 |
| 2008-01-04 03:00:00 | NQ | Futures | 2357.89 | 2361.86 | 2356.19 | 2358.46 | 899.0 |
| 2008-01-04 04:00:00 | NQ | Futures | 2358.17 | 2362.15 | 2357.89 | 2360.16 | 444.0 |
| 2008-01-04 05:00:00 | NQ | Futures | 2360.16 | 2361.01 | 2359.31 | 2360.44 | 542.0 |
| 2008-01-04 06:00:00 | NQ | Futures | 2360.16 | 2360.44 | 2358.46 | 2358.74 | 557.0 |
| 2008-01-04 07:00:00 | NQ | Futures | 2358.74 | 2358.74 | 2353.35 | 2355.05 | 1989.0 |
| 2008-01-04 08:00:00 | NQ | Futures | 2355.33 | 2357.61 | 2318.72 | 2319.57 | 20975.0 |
| 2008-01-04 09:00:00 | NQ | Futures | 2319.57 | 2320.99 | 2305.95 | 2309.35 | 62599.0 |
| 2008-01-04 10:00:00 | NQ | Futures | 2309.64 | 2314.75 | 2275.29 | 2277.56 | 95166.0 |
| 2008-01-04 11:00:00 | NQ | Futures | 2277.56 | 2291.47 | 2274.44 | 2287.78 | 65998.0 |
| 2008-01-04 12:00:00 | NQ | Futures | 2287.78 | 2297.43 | 2281.82 | 2284.37 | 43759.0 |
| 2008-01-04 13:00:00 | NQ | Futures | 2284.37 | 2286.36 | 2269.61 | 2281.54 | 48559.0 |
| 2008-01-04 14:00:00 | NQ | Futures | 2281.54 | 2281.54 | 2249.18 | 2261.38 | 67019.0 |
| 2008-01-04 15:00:00 | NQ | Futures | 2261.1 | 2266.49 | 2245.77 | 2247.47 | 89564.0 |
| 2008-01-04 16:00:00 | NQ | Futures | 2247.19 | 2257.41 | 2244.35 | 2252.3 | 23496.0 |
| 2008-01-04 00:00:00 | YM | Futures | 11962.2 | 11967.6 | 11959.5 | 11964.9 | 66.0 |
| 2008-01-04 01:00:00 | YM | Futures | 11964.9 | 11970.4 | 11961.3 | 11968.6 | 122.0 |
| 2008-01-04 02:00:00 | YM | Futures | 11966.7 | 11970.4 | 11950.4 | 11954.9 | 288.0 |
| 2008-01-04 03:00:00 | YM | Futures | 11954.9 | 11964.9 | 11946.8 | 11957.7 | 745.0 |
| 2008-01-04 04:00:00 | YM | Futures | 11958.6 | 11971.3 | 11955.8 | 11968.6 | 411.0 |
| 2008-01-04 05:00:00 | YM | Futures | 11967.6 | 11974.0 | 11962.2 | 11965.8 | 263.0 |
| 2008-01-04 06:00:00 | YM | Futures | 11964.9 | 11974.9 | 11961.3 | 11970.4 | 495.0 |
| 2008-01-04 07:00:00 | YM | Futures | 11968.6 | 11968.6 | 11952.2 | 11964.0 | 534.0 |
| 2008-01-04 08:00:00 | YM | Futures | 11964.0 | 11971.3 | 11829.6 | 11840.5 | 9253.0 |
| 2008-01-04 09:00:00 | YM | Futures | 11841.4 | 11845.0 | 11784.1 | 11795.9 | 22463.0 |
| 2008-01-04 10:00:00 | YM | Futures | 11796.8 | 11815.9 | 11722.4 | 11728.7 | 30590.0 |
| 2008-01-04 11:00:00 | YM | Futures | 11726.9 | 11771.4 | 11716.0 | 11764.1 | 20091.0 |
| 2008-01-04 12:00:00 | YM | Futures | 11764.1 | 11789.6 | 11728.7 | 11746.9 | 16328.0 |
| 2008-01-04 13:00:00 | YM | Futures | 11746.9 | 11756.0 | 11705.1 | 11742.3 | 18558.0 |
| 2008-01-04 14:00:00 | YM | Futures | 11741.4 | 11741.4 | 11671.5 | 11705.1 | 24920.0 |
| 2008-01-04 15:00:00 | YM | Futures | 11705.1 | 11726.0 | 11667.8 | 11671.5 | 30373.0 |
> showing 50 of 591 rows — these rows as CSV