PREVIEW / futures_1hour / 2013-03-17
file: by_date/futures_1hour/2013/2013-03-17.parquet size: 15 KB rows: 290
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 |
|---|---|---|---|---|---|---|---|
| 2013-03-17 18:00:00 | ES | Futures | 1590.84 | 1590.84 | 1582.86 | 1583.89 | 68018.0 |
| 2013-03-17 19:00:00 | ES | Futures | 1583.89 | 1586.2 | 1582.6 | 1583.11 | 24157.0 |
| 2013-03-17 20:00:00 | ES | Futures | 1583.11 | 1584.4 | 1582.6 | 1583.63 | 17689.0 |
| 2013-03-17 21:00:00 | ES | Futures | 1583.63 | 1583.63 | 1579.51 | 1580.28 | 28443.0 |
| 2013-03-17 22:00:00 | ES | Futures | 1580.02 | 1583.11 | 1580.02 | 1581.83 | 10471.0 |
| 2013-03-17 23:00:00 | ES | Futures | 1581.83 | 1582.86 | 1579.51 | 1580.02 | 10252.0 |
| 2013-03-17 18:00:00 | NQ | Futures | 3236.35 | 3236.35 | 3210.68 | 3223.51 | 3500.0 |
| 2013-03-17 19:00:00 | NQ | Futures | 3223.51 | 3227.89 | 3221.47 | 3221.76 | 668.0 |
| 2013-03-17 20:00:00 | NQ | Futures | 3221.76 | 3223.81 | 3221.18 | 3222.35 | 697.0 |
| 2013-03-17 21:00:00 | NQ | Futures | 3222.64 | 3222.64 | 3213.6 | 3215.06 | 1441.0 |
| 2013-03-17 22:00:00 | NQ | Futures | 3215.35 | 3220.31 | 3214.76 | 3218.26 | 752.0 |
| 2013-03-17 23:00:00 | NQ | Futures | 3218.26 | 3219.72 | 3214.76 | 3216.51 | 567.0 |
| 2013-03-17 18:00:00 | YM | Futures | 14525.3 | 14525.3 | 14460.6 | 14468.6 | 2962.0 |
| 2013-03-17 19:00:00 | YM | Futures | 14468.6 | 14486.8 | 14466.6 | 14468.6 | 1579.0 |
| 2013-03-17 20:00:00 | YM | Futures | 14469.7 | 14482.8 | 14467.6 | 14474.7 | 1846.0 |
| 2013-03-17 21:00:00 | YM | Futures | 14473.7 | 14475.7 | 14444.4 | 14452.5 | 2463.0 |
| 2013-03-17 22:00:00 | YM | Futures | 14452.5 | 14472.7 | 14451.5 | 14463.6 | 1600.0 |
| 2013-03-17 23:00:00 | YM | Futures | 14465.6 | 14469.7 | 14448.4 | 14456.5 | 1724.0 |
| 2013-03-17 18:00:00 | CL | Futures | 148.15 | 148.18 | 147.08 | 147.39 | 2166.0 |
| 2013-03-17 19:00:00 | CL | Futures | 147.38 | 147.42 | 146.84 | 146.95 | 1098.0 |
| 2013-03-17 20:00:00 | CL | Futures | 146.9 | 146.98 | 146.7 | 146.89 | 899.0 |
| 2013-03-17 21:00:00 | CL | Futures | 146.9 | 146.9 | 146.41 | 146.57 | 1537.0 |
| 2013-03-17 22:00:00 | CL | Futures | 146.55 | 146.68 | 146.43 | 146.54 | 554.0 |
| 2013-03-17 23:00:00 | CL | Futures | 146.54 | 146.76 | 146.48 | 146.73 | 470.0 |
| 2013-03-17 18:00:00 | GC | Futures | 2196.2 | 2210.7 | 2194.4 | 2204.0 | 7951.0 |
| 2013-03-17 19:00:00 | GC | Futures | 2204.1 | 2206.5 | 2200.6 | 2204.0 | 3090.0 |
| 2013-03-17 20:00:00 | GC | Futures | 2204.0 | 2204.6 | 2198.9 | 2203.5 | 3960.0 |
| 2013-03-17 21:00:00 | GC | Futures | 2203.5 | 2203.7 | 2186.0 | 2194.9 | 10232.0 |
| 2013-03-17 22:00:00 | GC | Futures | 2194.8 | 2196.7 | 2191.8 | 2195.6 | 3825.0 |
| 2013-03-17 23:00:00 | GC | Futures | 2195.6 | 2195.9 | 2193.6 | 2195.6 | 1494.0 |
| 2013-03-17 18:00:00 | ZN | Futures | 117.967981 | 118.178613 | 117.953938 | 118.16457 | 67949.0 |
| 2013-03-17 19:00:00 | ZN | Futures | 118.150528 | 118.304992 | 118.108402 | 118.248823 | 23966.0 |
| 2013-03-17 20:00:00 | ZN | Futures | 118.234781 | 118.29095 | 118.122444 | 118.192655 | 24891.0 |
| 2013-03-17 21:00:00 | ZN | Futures | 118.178613 | 118.276908 | 118.178613 | 118.192655 | 17164.0 |
| 2013-03-17 22:00:00 | ZN | Futures | 118.192655 | 118.206697 | 118.16457 | 118.206697 | 9474.0 |
| 2013-03-17 23:00:00 | ZN | Futures | 118.206697 | 118.276908 | 118.16457 | 118.248823 | 9813.0 |
> showing 36 of 290 rows — these rows as CSV