PREVIEW / futures_1hour / 2009-12-13
file: by_date/futures_1hour/2009/2009-12-13.parquet size: 13 KB rows: 241
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-13 18:00:00 | ES | Futures | 1073.04 | 1074.01 | 1072.07 | 1072.8 | 1024.0 |
| 2009-12-13 19:00:00 | ES | Futures | 1072.56 | 1074.5 | 1072.56 | 1073.53 | 1807.0 |
| 2009-12-13 20:00:00 | ES | Futures | 1073.28 | 1074.74 | 1071.83 | 1072.07 | 2092.0 |
| 2009-12-13 21:00:00 | ES | Futures | 1072.32 | 1072.8 | 1071.59 | 1072.56 | 630.0 |
| 2009-12-13 22:00:00 | ES | Futures | 1072.56 | 1072.8 | 1070.14 | 1070.86 | 2933.0 |
| 2009-12-13 23:00:00 | ES | Futures | 1070.86 | 1082.73 | 1070.62 | 1079.58 | 9470.0 |
| 2009-12-13 18:00:00 | NQ | Futures | 2046.84 | 2050.83 | 2043.7 | 2045.98 | 57.0 |
| 2009-12-13 19:00:00 | NQ | Futures | 2046.27 | 2049.41 | 2046.27 | 2048.26 | 29.0 |
| 2009-12-13 20:00:00 | NQ | Futures | 2045.98 | 2048.26 | 2043.7 | 2043.7 | 70.0 |
| 2009-12-13 21:00:00 | NQ | Futures | 2044.27 | 2045.7 | 2043.42 | 2043.42 | 38.0 |
| 2009-12-13 22:00:00 | NQ | Futures | 2044.56 | 2044.56 | 2039.99 | 2041.42 | 53.0 |
| 2009-12-13 23:00:00 | NQ | Futures | 2043.99 | 2064.52 | 2043.99 | 2059.96 | 412.0 |
| 2009-12-13 18:00:00 | YM | Futures | 9752.1 | 9760.5 | 9743.7 | 9748.4 | 230.0 |
| 2009-12-13 19:00:00 | YM | Futures | 9748.4 | 9762.4 | 9747.4 | 9754.9 | 341.0 |
| 2009-12-13 20:00:00 | YM | Futures | 9754.0 | 9763.3 | 9740.9 | 9744.6 | 459.0 |
| 2009-12-13 21:00:00 | YM | Futures | 9744.6 | 9748.4 | 9739.0 | 9746.5 | 259.0 |
| 2009-12-13 22:00:00 | YM | Futures | 9746.5 | 9746.5 | 9727.8 | 9734.3 | 363.0 |
| 2009-12-13 23:00:00 | YM | Futures | 9734.3 | 9835.4 | 9731.5 | 9801.7 | 2034.0 |
| 2009-12-13 18:00:00 | CL | Futures | 154.22 | 154.45 | 152.52 | 153.52 | 2687.0 |
| 2009-12-13 19:00:00 | CL | Futures | 153.56 | 153.94 | 153.32 | 153.56 | 1179.0 |
| 2009-12-13 20:00:00 | CL | Futures | 153.56 | 153.83 | 152.98 | 153.16 | 1038.0 |
| 2009-12-13 21:00:00 | CL | Futures | 153.14 | 153.43 | 152.85 | 152.94 | 1072.0 |
| 2009-12-13 22:00:00 | CL | Futures | 152.94 | 152.96 | 151.92 | 152.67 | 2680.0 |
| 2009-12-13 23:00:00 | CL | Futures | 152.61 | 153.83 | 152.47 | 153.56 | 2831.0 |
| 2009-12-13 18:00:00 | GC | Futures | 1570.8 | 1576.1 | 1566.7 | 1570.4 | 4082.0 |
| 2009-12-13 19:00:00 | GC | Futures | 1570.4 | 1579.5 | 1569.8 | 1576.8 | 4718.0 |
| 2009-12-13 20:00:00 | GC | Futures | 1576.8 | 1583.6 | 1576.0 | 1583.0 | 4162.0 |
| 2009-12-13 21:00:00 | GC | Futures | 1582.8 | 1583.9 | 1580.1 | 1582.8 | 2408.0 |
| 2009-12-13 22:00:00 | GC | Futures | 1582.8 | 1582.8 | 1577.1 | 1580.9 | 2775.0 |
| 2009-12-13 23:00:00 | GC | Futures | 1580.6 | 1588.3 | 1578.7 | 1585.6 | 4819.0 |
| 2009-12-13 18:00:00 | ZN | Futures | 95.517253 | 95.593402 | 95.504561 | 95.593402 | 1310.0 |
| 2009-12-13 19:00:00 | ZN | Futures | 95.593402 | 95.720319 | 95.568019 | 95.694935 | 5230.0 |
| 2009-12-13 20:00:00 | ZN | Futures | 95.694935 | 95.707627 | 95.656861 | 95.694935 | 2497.0 |
| 2009-12-13 21:00:00 | ZN | Futures | 95.694935 | 95.745702 | 95.694935 | 95.720319 | 3445.0 |
| 2009-12-13 22:00:00 | ZN | Futures | 95.720319 | 95.771085 | 95.694935 | 95.720319 | 3039.0 |
| 2009-12-13 23:00:00 | ZN | Futures | 95.73301 | 95.745702 | 95.555327 | 95.606094 | 11472.0 |
> showing 36 of 241 rows — these rows as CSV