PREVIEW / futures_1hour / 2010-02-21
file: by_date/futures_1hour/2010/2010-02-21.parquet size: 13 KB rows: 228
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-21 18:00:00 | ES | Futures | 1076.18 | 1078.37 | 1075.93 | 1078.37 | 9544.0 |
| 2010-02-21 19:00:00 | ES | Futures | 1078.12 | 1080.07 | 1077.88 | 1079.83 | 7524.0 |
| 2010-02-21 20:00:00 | ES | Futures | 1079.58 | 1080.07 | 1079.34 | 1079.83 | 7680.0 |
| 2010-02-21 21:00:00 | ES | Futures | 1080.07 | 1080.31 | 1079.1 | 1080.31 | 3867.0 |
| 2010-02-21 22:00:00 | ES | Futures | 1080.07 | 1080.56 | 1079.58 | 1080.56 | 4796.0 |
| 2010-02-21 23:00:00 | ES | Futures | 1080.56 | 1080.56 | 1078.61 | 1079.34 | 3111.0 |
| 2010-02-21 18:00:00 | NQ | Futures | 2077.95 | 2084.24 | 2077.67 | 2083.66 | 1138.0 |
| 2010-02-21 19:00:00 | NQ | Futures | 2083.66 | 2086.24 | 2083.09 | 2085.66 | 362.0 |
| 2010-02-21 20:00:00 | NQ | Futures | 2085.66 | 2087.09 | 2084.81 | 2086.24 | 319.0 |
| 2010-02-21 21:00:00 | NQ | Futures | 2086.24 | 2086.81 | 2085.09 | 2086.52 | 169.0 |
| 2010-02-21 22:00:00 | NQ | Futures | 2086.81 | 2087.66 | 2086.24 | 2087.09 | 403.0 |
| 2010-02-21 23:00:00 | NQ | Futures | 2087.09 | 2087.09 | 2084.24 | 2085.38 | 135.0 |
| 2010-02-21 18:00:00 | YM | Futures | 9702.5 | 9727.8 | 9702.5 | 9726.8 | 211.0 |
| 2010-02-21 19:00:00 | YM | Futures | 9725.9 | 9739.0 | 9725.9 | 9737.1 | 336.0 |
| 2010-02-21 20:00:00 | YM | Futures | 9738.1 | 9742.7 | 9733.4 | 9739.9 | 230.0 |
| 2010-02-21 21:00:00 | YM | Futures | 9739.9 | 9743.7 | 9735.2 | 9743.7 | 140.0 |
| 2010-02-21 22:00:00 | YM | Futures | 9743.7 | 9745.5 | 9738.1 | 9744.6 | 202.0 |
| 2010-02-21 23:00:00 | YM | Futures | 9743.7 | 9743.7 | 9731.5 | 9735.2 | 182.0 |
| 2010-02-21 18:00:00 | CL | Futures | 170.86 | 171.27 | 170.44 | 170.93 | 1350.0 |
| 2010-02-21 19:00:00 | CL | Futures | 170.95 | 171.82 | 170.95 | 171.71 | 1555.0 |
| 2010-02-21 20:00:00 | CL | Futures | 171.65 | 171.88 | 171.48 | 171.86 | 1053.0 |
| 2010-02-21 21:00:00 | CL | Futures | 171.82 | 171.84 | 171.5 | 171.71 | 676.0 |
| 2010-02-21 22:00:00 | CL | Futures | 171.71 | 171.78 | 171.59 | 171.69 | 317.0 |
| 2010-02-21 23:00:00 | CL | Futures | 171.69 | 171.73 | 171.25 | 171.37 | 665.0 |
| 2010-02-21 18:00:00 | GC | Futures | 1579.8 | 1586.4 | 1579.5 | 1586.0 | 2672.0 |
| 2010-02-21 19:00:00 | GC | Futures | 1586.0 | 1593.0 | 1584.1 | 1590.9 | 4918.0 |
| 2010-02-21 20:00:00 | GC | Futures | 1591.0 | 1591.0 | 1585.7 | 1589.3 | 2919.0 |
| 2010-02-21 21:00:00 | GC | Futures | 1589.3 | 1589.3 | 1584.7 | 1587.4 | 1242.0 |
| 2010-02-21 22:00:00 | GC | Futures | 1587.1 | 1587.8 | 1585.8 | 1586.8 | 1146.0 |
| 2010-02-21 23:00:00 | GC | Futures | 1586.8 | 1586.9 | 1583.0 | 1585.3 | 1418.0 |
| 2010-02-21 18:00:00 | ZN | Futures | 95.18727 | 95.225345 | 95.161887 | 95.18727 | 2781.0 |
| 2010-02-21 19:00:00 | ZN | Futures | 95.18727 | 95.212653 | 95.174578 | 95.199962 | 3084.0 |
| 2010-02-21 20:00:00 | ZN | Futures | 95.199962 | 95.212653 | 95.161887 | 95.161887 | 1448.0 |
| 2010-02-21 21:00:00 | ZN | Futures | 95.161887 | 95.18727 | 95.136504 | 95.136504 | 1395.0 |
| 2010-02-21 22:00:00 | ZN | Futures | 95.136504 | 95.149195 | 95.123812 | 95.136504 | 1566.0 |
| 2010-02-21 23:00:00 | ZN | Futures | 95.136504 | 95.174578 | 95.123812 | 95.174578 | 1144.0 |
> showing 36 of 228 rows — these rows as CSV