PREVIEW / futures_1hour / 2011-05-08
file: by_date/futures_1hour/2011/2011-05-08.parquet size: 14 KB rows: 277
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-08 18:00:00 | ES | Futures | 1328.85 | 1334.07 | 1328.61 | 1330.59 | 18020.0 |
| 2011-05-08 19:00:00 | ES | Futures | 1330.59 | 1333.82 | 1330.35 | 1333.08 | 4178.0 |
| 2011-05-08 20:00:00 | ES | Futures | 1333.08 | 1333.58 | 1330.1 | 1330.84 | 7203.0 |
| 2011-05-08 21:00:00 | ES | Futures | 1330.59 | 1332.83 | 1329.85 | 1332.33 | 7328.0 |
| 2011-05-08 22:00:00 | ES | Futures | 1332.08 | 1333.33 | 1331.84 | 1332.58 | 2400.0 |
| 2011-05-08 23:00:00 | ES | Futures | 1332.58 | 1333.58 | 1332.33 | 1332.83 | 3635.0 |
| 2011-05-08 18:00:00 | NQ | Futures | 2732.94 | 2742.42 | 2732.94 | 2736.67 | 2265.0 |
| 2011-05-08 19:00:00 | NQ | Futures | 2736.67 | 2742.71 | 2736.39 | 2741.56 | 710.0 |
| 2011-05-08 20:00:00 | NQ | Futures | 2741.27 | 2742.42 | 2737.82 | 2738.68 | 1329.0 |
| 2011-05-08 21:00:00 | NQ | Futures | 2738.68 | 2742.13 | 2736.96 | 2741.27 | 488.0 |
| 2011-05-08 22:00:00 | NQ | Futures | 2740.98 | 2742.42 | 2740.7 | 2740.7 | 253.0 |
| 2011-05-08 23:00:00 | NQ | Futures | 2740.98 | 2742.42 | 2740.7 | 2740.98 | 184.0 |
| 2011-05-08 18:00:00 | YM | Futures | 12122.7 | 12175.7 | 12122.7 | 12142.9 | 451.0 |
| 2011-05-08 19:00:00 | YM | Futures | 12142.9 | 12167.0 | 12142.9 | 12166.0 | 198.0 |
| 2011-05-08 20:00:00 | YM | Futures | 12165.1 | 12168.9 | 12141.9 | 12146.8 | 297.0 |
| 2011-05-08 21:00:00 | YM | Futures | 12145.8 | 12167.0 | 12141.0 | 12161.2 | 334.0 |
| 2011-05-08 22:00:00 | YM | Futures | 12160.2 | 12169.9 | 12158.3 | 12162.2 | 174.0 |
| 2011-05-08 23:00:00 | YM | Futures | 12162.2 | 12173.7 | 12159.3 | 12163.1 | 158.0 |
| 2011-05-08 18:00:00 | CL | Futures | 170.02 | 171.33 | 168.82 | 169.38 | 5790.0 |
| 2011-05-08 19:00:00 | CL | Futures | 169.38 | 171.13 | 169.31 | 170.83 | 2710.0 |
| 2011-05-08 20:00:00 | CL | Futures | 170.87 | 171.07 | 169.43 | 169.53 | 2178.0 |
| 2011-05-08 21:00:00 | CL | Futures | 169.53 | 170.71 | 168.98 | 170.4 | 2955.0 |
| 2011-05-08 22:00:00 | CL | Futures | 170.4 | 171.06 | 170.04 | 170.68 | 1731.0 |
| 2011-05-08 23:00:00 | CL | Futures | 170.68 | 171.54 | 170.68 | 171.23 | 1822.0 |
| 2011-05-08 18:00:00 | GC | Futures | 2088.9 | 2089.0 | 2078.3 | 2082.2 | 1908.0 |
| 2011-05-08 19:00:00 | GC | Futures | 2081.9 | 2086.4 | 2081.1 | 2084.6 | 893.0 |
| 2011-05-08 20:00:00 | GC | Futures | 2084.6 | 2086.9 | 2083.2 | 2085.7 | 1284.0 |
| 2011-05-08 21:00:00 | GC | Futures | 2085.8 | 2089.6 | 2084.7 | 2087.4 | 1607.0 |
| 2011-05-08 22:00:00 | GC | Futures | 2087.4 | 2092.1 | 2087.1 | 2090.1 | 1803.0 |
| 2011-05-08 23:00:00 | GC | Futures | 2090.1 | 2100.3 | 2089.9 | 2098.4 | 3562.0 |
| 2011-05-08 18:00:00 | ZN | Futures | 104.018117 | 104.03142 | 103.951601 | 103.978207 | 6247.0 |
| 2011-05-08 19:00:00 | ZN | Futures | 103.978207 | 103.978207 | 103.924994 | 103.938298 | 3991.0 |
| 2011-05-08 20:00:00 | ZN | Futures | 103.951601 | 103.978207 | 103.924994 | 103.978207 | 7139.0 |
| 2011-05-08 21:00:00 | ZN | Futures | 103.978207 | 104.004814 | 103.964904 | 103.978207 | 4534.0 |
| 2011-05-08 22:00:00 | ZN | Futures | 103.991511 | 104.018117 | 103.978207 | 104.004814 | 2682.0 |
| 2011-05-08 23:00:00 | ZN | Futures | 103.991511 | 104.004814 | 103.978207 | 104.004814 | 1456.0 |
> showing 36 of 277 rows — these rows as CSV