PREVIEW / futures_1hour / 2010-05-23
file: by_date/futures_1hour/2010/2010-05-23.parquet size: 13 KB rows: 233
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-05-23 18:00:00 | ES | Futures | 1061.3 | 1062.52 | 1057.63 | 1059.83 | 17522.0 |
| 2010-05-23 19:00:00 | ES | Futures | 1059.59 | 1061.05 | 1056.9 | 1057.63 | 8289.0 |
| 2010-05-23 20:00:00 | ES | Futures | 1057.63 | 1058.61 | 1052.5 | 1052.99 | 18302.0 |
| 2010-05-23 21:00:00 | ES | Futures | 1052.99 | 1056.9 | 1050.79 | 1055.43 | 22749.0 |
| 2010-05-23 22:00:00 | ES | Futures | 1055.43 | 1060.57 | 1053.48 | 1059.34 | 16456.0 |
| 2010-05-23 23:00:00 | ES | Futures | 1059.34 | 1060.32 | 1054.21 | 1055.19 | 7120.0 |
| 2010-05-23 18:00:00 | NQ | Futures | 2086.22 | 2087.08 | 2076.49 | 2080.78 | 1355.0 |
| 2010-05-23 19:00:00 | NQ | Futures | 2080.78 | 2083.07 | 2076.2 | 2076.77 | 488.0 |
| 2010-05-23 20:00:00 | NQ | Futures | 2077.06 | 2079.35 | 2066.18 | 2067.32 | 1250.0 |
| 2010-05-23 21:00:00 | NQ | Futures | 2067.61 | 2075.06 | 2063.31 | 2072.76 | 1415.0 |
| 2010-05-23 22:00:00 | NQ | Futures | 2072.48 | 2082.5 | 2068.76 | 2081.36 | 1687.0 |
| 2010-05-23 23:00:00 | NQ | Futures | 2081.07 | 2082.22 | 2072.48 | 2075.34 | 743.0 |
| 2010-05-23 18:00:00 | YM | Futures | 9567.9 | 9573.5 | 9539.7 | 9559.4 | 352.0 |
| 2010-05-23 19:00:00 | YM | Futures | 9554.7 | 9563.2 | 9534.9 | 9536.8 | 264.0 |
| 2010-05-23 20:00:00 | YM | Futures | 9537.8 | 9547.2 | 9503.9 | 9506.7 | 840.0 |
| 2010-05-23 21:00:00 | YM | Futures | 9505.8 | 9539.7 | 9487.9 | 9530.2 | 1276.0 |
| 2010-05-23 22:00:00 | YM | Futures | 9530.2 | 9570.7 | 9516.1 | 9561.3 | 1934.0 |
| 2010-05-23 23:00:00 | YM | Futures | 9561.3 | 9566.0 | 9521.8 | 9527.4 | 752.0 |
| 2010-05-23 18:00:00 | CL | Futures | 138.89 | 138.94 | 137.39 | 138.1 | 1561.0 |
| 2010-05-23 19:00:00 | CL | Futures | 138.06 | 138.39 | 137.98 | 138.12 | 703.0 |
| 2010-05-23 20:00:00 | CL | Futures | 138.12 | 138.61 | 137.37 | 137.49 | 1702.0 |
| 2010-05-23 21:00:00 | CL | Futures | 137.47 | 138.16 | 136.9 | 137.9 | 2047.0 |
| 2010-05-23 22:00:00 | CL | Futures | 137.94 | 138.75 | 137.86 | 138.69 | 1351.0 |
| 2010-05-23 23:00:00 | CL | Futures | 138.67 | 138.73 | 138.04 | 138.59 | 919.0 |
| 2010-05-23 18:00:00 | GC | Futures | 1656.5 | 1662.4 | 1654.7 | 1661.0 | 832.0 |
| 2010-05-23 19:00:00 | GC | Futures | 1661.0 | 1662.2 | 1658.5 | 1661.0 | 678.0 |
| 2010-05-23 20:00:00 | GC | Futures | 1661.3 | 1666.2 | 1661.3 | 1663.2 | 2346.0 |
| 2010-05-23 21:00:00 | GC | Futures | 1663.2 | 1665.1 | 1661.0 | 1663.1 | 1394.0 |
| 2010-05-23 22:00:00 | GC | Futures | 1663.1 | 1666.6 | 1662.9 | 1666.3 | 968.0 |
| 2010-05-23 23:00:00 | GC | Futures | 1666.6 | 1666.6 | 1664.1 | 1664.8 | 973.0 |
| 2010-05-23 18:00:00 | ZN | Futures | 99.543775 | 99.620861 | 99.530927 | 99.543775 | 2675.0 |
| 2010-05-23 19:00:00 | ZN | Futures | 99.543775 | 99.56947 | 99.518079 | 99.56947 | 3785.0 |
| 2010-05-23 20:00:00 | ZN | Futures | 99.556623 | 99.685099 | 99.543775 | 99.672252 | 5695.0 |
| 2010-05-23 21:00:00 | ZN | Futures | 99.672252 | 99.762185 | 99.608013 | 99.672252 | 11308.0 |
| 2010-05-23 22:00:00 | ZN | Futures | 99.672252 | 99.697947 | 99.595166 | 99.608013 | 3832.0 |
| 2010-05-23 23:00:00 | ZN | Futures | 99.608013 | 99.672252 | 99.608013 | 99.633709 | 2907.0 |
> showing 36 of 233 rows — these rows as CSV