PREVIEW / futures_1hour / 2008-01-11
file: by_date/futures_1hour/2008/2008-01-11.parquet size: 24 KB rows: 602
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-11 00:00:00 | ES | Futures | 1318.5 | 1319.2 | 1315.93 | 1316.4 | 5244.0 |
| 2008-01-11 01:00:00 | ES | Futures | 1316.4 | 1317.57 | 1315.7 | 1315.93 | 2902.0 |
| 2008-01-11 02:00:00 | ES | Futures | 1315.93 | 1320.13 | 1315.7 | 1317.33 | 11932.0 |
| 2008-01-11 03:00:00 | ES | Futures | 1317.33 | 1320.13 | 1316.87 | 1318.03 | 19346.0 |
| 2008-01-11 04:00:00 | ES | Futures | 1318.03 | 1319.9 | 1315.93 | 1319.2 | 16359.0 |
| 2008-01-11 05:00:00 | ES | Futures | 1319.43 | 1319.43 | 1317.1 | 1317.57 | 8212.0 |
| 2008-01-11 06:00:00 | ES | Futures | 1317.57 | 1318.27 | 1311.27 | 1313.6 | 28192.0 |
| 2008-01-11 07:00:00 | ES | Futures | 1313.6 | 1319.2 | 1311.5 | 1317.33 | 57943.0 |
| 2008-01-11 08:00:00 | ES | Futures | 1317.57 | 1320.6 | 1315.7 | 1319.2 | 47051.0 |
| 2008-01-11 09:00:00 | ES | Futures | 1319.2 | 1323.16 | 1315.93 | 1318.73 | 245464.0 |
| 2008-01-11 10:00:00 | ES | Futures | 1318.73 | 1325.26 | 1314.3 | 1322.46 | 309525.0 |
| 2008-01-11 11:00:00 | ES | Futures | 1322.46 | 1327.59 | 1318.96 | 1323.63 | 239608.0 |
| 2008-01-11 12:00:00 | ES | Futures | 1323.86 | 1325.03 | 1317.57 | 1324.56 | 166265.0 |
| 2008-01-11 13:00:00 | ES | Futures | 1324.33 | 1325.03 | 1311.97 | 1313.6 | 263737.0 |
| 2008-01-11 14:00:00 | ES | Futures | 1313.6 | 1319.2 | 1310.57 | 1314.3 | 179175.0 |
| 2008-01-11 15:00:00 | ES | Futures | 1314.3 | 1317.57 | 1305.91 | 1312.9 | 463903.0 |
| 2008-01-11 16:00:00 | ES | Futures | 1312.9 | 1314.77 | 1312.44 | 1313.6 | 81089.0 |
| 2008-01-11 00:00:00 | NQ | Futures | 2216.25 | 2218.81 | 2212.85 | 2212.85 | 397.0 |
| 2008-01-11 01:00:00 | NQ | Futures | 2212.56 | 2214.55 | 2211.71 | 2211.71 | 162.0 |
| 2008-01-11 02:00:00 | NQ | Futures | 2211.71 | 2218.24 | 2210.86 | 2214.55 | 379.0 |
| 2008-01-11 03:00:00 | NQ | Futures | 2214.55 | 2218.81 | 2214.26 | 2215.4 | 681.0 |
| 2008-01-11 04:00:00 | NQ | Futures | 2215.4 | 2221.36 | 2213.41 | 2220.79 | 1172.0 |
| 2008-01-11 05:00:00 | NQ | Futures | 2220.51 | 2221.36 | 2218.81 | 2219.37 | 1422.0 |
| 2008-01-11 06:00:00 | NQ | Futures | 2219.09 | 2220.23 | 2205.18 | 2210.86 | 1677.0 |
| 2008-01-11 07:00:00 | NQ | Futures | 2211.14 | 2219.37 | 2206.32 | 2215.97 | 4119.0 |
| 2008-01-11 08:00:00 | NQ | Futures | 2216.54 | 2219.09 | 2211.71 | 2215.97 | 5239.0 |
| 2008-01-11 09:00:00 | NQ | Futures | 2216.25 | 2221.36 | 2207.17 | 2210.29 | 50878.0 |
| 2008-01-11 10:00:00 | NQ | Futures | 2210.29 | 2213.13 | 2200.07 | 2206.03 | 69912.0 |
| 2008-01-11 11:00:00 | NQ | Futures | 2206.32 | 2215.68 | 2198.09 | 2207.74 | 61799.0 |
| 2008-01-11 12:00:00 | NQ | Futures | 2208.02 | 2211.71 | 2195.53 | 2206.03 | 49504.0 |
| 2008-01-11 13:00:00 | NQ | Futures | 2206.03 | 2206.88 | 2185.03 | 2185.03 | 63983.0 |
| 2008-01-11 14:00:00 | NQ | Futures | 2185.03 | 2198.09 | 2179.07 | 2186.16 | 48368.0 |
| 2008-01-11 15:00:00 | NQ | Futures | 2186.16 | 2196.95 | 2171.12 | 2186.73 | 108036.0 |
| 2008-01-11 16:00:00 | NQ | Futures | 2186.73 | 2194.68 | 2184.46 | 2186.16 | 15358.0 |
| 2008-01-11 00:00:00 | YM | Futures | 11625.1 | 11628.8 | 11606.1 | 11608.8 | 318.0 |
| 2008-01-11 01:00:00 | YM | Futures | 11610.6 | 11616.1 | 11597.0 | 11597.9 | 333.0 |
| 2008-01-11 02:00:00 | YM | Futures | 11597.9 | 11627.0 | 11597.9 | 11608.8 | 710.0 |
| 2008-01-11 03:00:00 | YM | Futures | 11607.9 | 11630.6 | 11605.2 | 11615.1 | 911.0 |
| 2008-01-11 04:00:00 | YM | Futures | 11617.9 | 11626.1 | 11597.0 | 11620.6 | 1069.0 |
| 2008-01-11 05:00:00 | YM | Futures | 11620.6 | 11624.2 | 11608.8 | 11611.5 | 678.0 |
| 2008-01-11 06:00:00 | YM | Futures | 11609.7 | 11617.0 | 11565.2 | 11583.4 | 1656.0 |
| 2008-01-11 07:00:00 | YM | Futures | 11585.2 | 11623.3 | 11566.1 | 11612.4 | 2897.0 |
| 2008-01-11 08:00:00 | YM | Futures | 11612.4 | 11637.0 | 11605.2 | 11621.5 | 4253.0 |
| 2008-01-11 09:00:00 | YM | Futures | 11622.4 | 11639.7 | 11576.1 | 11586.1 | 24513.0 |
| 2008-01-11 10:00:00 | YM | Futures | 11586.1 | 11607.0 | 11547.0 | 11592.4 | 33785.0 |
| 2008-01-11 11:00:00 | YM | Futures | 11593.3 | 11621.5 | 11557.9 | 11589.7 | 24746.0 |
| 2008-01-11 12:00:00 | YM | Futures | 11589.7 | 11596.1 | 11536.1 | 11590.6 | 21601.0 |
| 2008-01-11 13:00:00 | YM | Futures | 11590.6 | 11597.9 | 11485.2 | 11498.0 | 30800.0 |
| 2008-01-11 14:00:00 | YM | Futures | 11498.0 | 11536.1 | 11475.2 | 11501.6 | 20547.0 |
| 2008-01-11 15:00:00 | YM | Futures | 11501.6 | 11528.8 | 11438.0 | 11496.1 | 40097.0 |
> showing 50 of 602 rows — these rows as CSV