PREVIEW / futures_1hour / 2008-01-10
file: by_date/futures_1hour/2008/2008-01-10.parquet size: 29 KB rows: 746
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-10 00:00:00 | ES | Futures | 1317.8 | 1318.03 | 1315.7 | 1315.7 | 2870.0 |
| 2008-01-10 01:00:00 | ES | Futures | 1315.7 | 1315.7 | 1312.2 | 1313.14 | 6141.0 |
| 2008-01-10 02:00:00 | ES | Futures | 1313.14 | 1317.33 | 1313.14 | 1316.63 | 5672.0 |
| 2008-01-10 03:00:00 | ES | Futures | 1316.4 | 1316.63 | 1313.6 | 1314.53 | 13593.0 |
| 2008-01-10 04:00:00 | ES | Futures | 1314.77 | 1315.47 | 1310.57 | 1314.53 | 17530.0 |
| 2008-01-10 05:00:00 | ES | Futures | 1314.3 | 1315.47 | 1312.2 | 1314.77 | 12012.0 |
| 2008-01-10 06:00:00 | ES | Futures | 1314.53 | 1314.77 | 1311.04 | 1314.3 | 14883.0 |
| 2008-01-10 07:00:00 | ES | Futures | 1314.53 | 1316.87 | 1311.5 | 1315.0 | 37485.0 |
| 2008-01-10 08:00:00 | ES | Futures | 1315.0 | 1316.63 | 1308.47 | 1311.27 | 73319.0 |
| 2008-01-10 09:00:00 | ES | Futures | 1311.04 | 1314.07 | 1307.07 | 1312.9 | 189903.0 |
| 2008-01-10 10:00:00 | ES | Futures | 1312.9 | 1320.36 | 1312.2 | 1314.77 | 290730.0 |
| 2008-01-10 11:00:00 | ES | Futures | 1314.53 | 1315.7 | 1309.87 | 1314.53 | 166427.0 |
| 2008-01-10 12:00:00 | ES | Futures | 1314.3 | 1332.95 | 1312.44 | 1326.19 | 559788.0 |
| 2008-01-10 13:00:00 | ES | Futures | 1325.96 | 1327.59 | 1312.67 | 1318.27 | 333398.0 |
| 2008-01-10 14:00:00 | ES | Futures | 1318.03 | 1334.82 | 1314.07 | 1332.95 | 418329.0 |
| 2008-01-10 15:00:00 | ES | Futures | 1332.95 | 1339.48 | 1329.22 | 1330.16 | 428798.0 |
| 2008-01-10 16:00:00 | ES | Futures | 1330.16 | 1330.62 | 1322.93 | 1323.63 | 139180.0 |
| 2008-01-10 17:00:00 | ES | Futures | 1323.63 | 1324.56 | 1323.39 | 1324.33 | 2139.0 |
| 2008-01-10 18:00:00 | ES | Futures | 1324.09 | 1327.82 | 1324.09 | 1326.66 | 3875.0 |
| 2008-01-10 19:00:00 | ES | Futures | 1326.66 | 1326.66 | 1323.86 | 1324.33 | 2461.0 |
| 2008-01-10 20:00:00 | ES | Futures | 1324.09 | 1324.79 | 1323.39 | 1323.63 | 4672.0 |
| 2008-01-10 21:00:00 | ES | Futures | 1323.63 | 1323.86 | 1322.93 | 1323.16 | 2818.0 |
| 2008-01-10 22:00:00 | ES | Futures | 1322.93 | 1323.16 | 1319.9 | 1319.9 | 8673.0 |
| 2008-01-10 23:00:00 | ES | Futures | 1319.9 | 1320.36 | 1317.8 | 1318.5 | 5264.0 |
| 2008-01-10 00:00:00 | NQ | Futures | 2225.9 | 2226.19 | 2222.78 | 2223.06 | 304.0 |
| 2008-01-10 01:00:00 | NQ | Futures | 2222.78 | 2223.92 | 2216.82 | 2218.52 | 282.0 |
| 2008-01-10 02:00:00 | NQ | Futures | 2218.81 | 2224.2 | 2218.24 | 2223.35 | 430.0 |
| 2008-01-10 03:00:00 | NQ | Futures | 2222.21 | 2222.5 | 2217.39 | 2218.52 | 893.0 |
| 2008-01-10 04:00:00 | NQ | Futures | 2218.52 | 2219.94 | 2211.14 | 2217.1 | 1600.0 |
| 2008-01-10 05:00:00 | NQ | Futures | 2217.1 | 2218.52 | 2213.13 | 2217.1 | 928.0 |
| 2008-01-10 06:00:00 | NQ | Futures | 2216.82 | 2217.39 | 2211.71 | 2215.68 | 1459.0 |
| 2008-01-10 07:00:00 | NQ | Futures | 2214.26 | 2222.5 | 2210.86 | 2218.24 | 2838.0 |
| 2008-01-10 08:00:00 | NQ | Futures | 2218.52 | 2220.79 | 2201.78 | 2209.16 | 7358.0 |
| 2008-01-10 09:00:00 | NQ | Futures | 2209.16 | 2213.7 | 2199.22 | 2207.45 | 56787.0 |
| 2008-01-10 10:00:00 | NQ | Futures | 2207.17 | 2220.51 | 2203.76 | 2208.59 | 82488.0 |
| 2008-01-10 11:00:00 | NQ | Futures | 2208.87 | 2214.55 | 2204.05 | 2213.13 | 35649.0 |
| 2008-01-10 12:00:00 | NQ | Futures | 2212.56 | 2248.33 | 2210.29 | 2232.15 | 142830.0 |
| 2008-01-10 13:00:00 | NQ | Futures | 2231.86 | 2235.55 | 2207.45 | 2218.52 | 88197.0 |
| 2008-01-10 14:00:00 | NQ | Futures | 2218.52 | 2239.24 | 2211.99 | 2236.4 | 103042.0 |
| 2008-01-10 15:00:00 | NQ | Futures | 2236.12 | 2250.31 | 2227.89 | 2231.86 | 94915.0 |
| 2008-01-10 16:00:00 | NQ | Futures | 2231.58 | 2231.86 | 2220.23 | 2221.93 | 13964.0 |
| 2008-01-10 17:00:00 | NQ | Futures | 2222.21 | 2224.48 | 2222.21 | 2222.5 | 181.0 |
| 2008-01-10 18:00:00 | NQ | Futures | 2222.5 | 2228.74 | 2222.5 | 2226.75 | 367.0 |
| 2008-01-10 19:00:00 | NQ | Futures | 2225.33 | 2225.33 | 2222.5 | 2223.06 | 150.0 |
| 2008-01-10 20:00:00 | NQ | Futures | 2223.06 | 2223.63 | 2222.21 | 2222.5 | 110.0 |
| 2008-01-10 21:00:00 | NQ | Futures | 2222.78 | 2222.78 | 2220.51 | 2221.93 | 98.0 |
| 2008-01-10 22:00:00 | NQ | Futures | 2221.08 | 2221.36 | 2217.1 | 2217.39 | 302.0 |
| 2008-01-10 23:00:00 | NQ | Futures | 2217.67 | 2217.95 | 2214.55 | 2217.1 | 194.0 |
| 2008-01-10 00:00:00 | YM | Futures | 11587.9 | 11592.4 | 11572.4 | 11572.4 | 126.0 |
| 2008-01-10 01:00:00 | YM | Futures | 11572.4 | 11572.4 | 11547.9 | 11552.5 | 348.0 |
> showing 50 of 746 rows — these rows as CSV