PREVIEW / futures_1hour / 2013-03-24
file: by_date/futures_1hour/2013/2013-03-24.parquet size: 15 KB rows: 281
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-24 18:00:00 | ES | Futures | 1597.02 | 1599.6 | 1595.48 | 1598.83 | 12153.0 |
| 2013-03-24 19:00:00 | ES | Futures | 1598.57 | 1605.52 | 1598.57 | 1603.46 | 22210.0 |
| 2013-03-24 20:00:00 | ES | Futures | 1603.46 | 1604.75 | 1602.69 | 1604.49 | 11579.0 |
| 2013-03-24 21:00:00 | ES | Futures | 1604.75 | 1606.81 | 1604.49 | 1606.3 | 12875.0 |
| 2013-03-24 22:00:00 | ES | Futures | 1606.55 | 1606.81 | 1605.01 | 1606.55 | 9761.0 |
| 2013-03-24 23:00:00 | ES | Futures | 1606.81 | 1607.07 | 1605.52 | 1605.78 | 4499.0 |
| 2013-03-24 18:00:00 | NQ | Futures | 3259.1 | 3263.76 | 3258.22 | 3263.47 | 798.0 |
| 2013-03-24 19:00:00 | NQ | Futures | 3263.47 | 3278.06 | 3263.18 | 3274.26 | 2626.0 |
| 2013-03-24 20:00:00 | NQ | Futures | 3274.26 | 3276.31 | 3271.93 | 3276.01 | 956.0 |
| 2013-03-24 21:00:00 | NQ | Futures | 3276.31 | 3277.76 | 3274.56 | 3277.18 | 795.0 |
| 2013-03-24 22:00:00 | NQ | Futures | 3277.18 | 3277.76 | 3273.97 | 3277.47 | 567.0 |
| 2013-03-24 23:00:00 | NQ | Futures | 3277.47 | 3278.35 | 3275.43 | 3275.72 | 377.0 |
| 2013-03-24 18:00:00 | YM | Futures | 14609.2 | 14617.3 | 14587.9 | 14611.2 | 558.0 |
| 2013-03-24 19:00:00 | YM | Futures | 14610.2 | 14663.8 | 14610.2 | 14647.6 | 2317.0 |
| 2013-03-24 20:00:00 | YM | Futures | 14646.6 | 14654.7 | 14641.5 | 14652.6 | 1593.0 |
| 2013-03-24 21:00:00 | YM | Futures | 14651.6 | 14671.8 | 14651.6 | 14666.8 | 1579.0 |
| 2013-03-24 22:00:00 | YM | Futures | 14666.8 | 14668.8 | 14656.7 | 14666.8 | 895.0 |
| 2013-03-24 23:00:00 | YM | Futures | 14667.8 | 14669.8 | 14658.7 | 14660.7 | 420.0 |
| 2013-03-24 18:00:00 | CL | Futures | 148.31 | 148.42 | 148.28 | 148.3 | 597.0 |
| 2013-03-24 19:00:00 | CL | Futures | 148.28 | 148.71 | 148.28 | 148.69 | 859.0 |
| 2013-03-24 20:00:00 | CL | Futures | 148.68 | 148.83 | 148.58 | 148.82 | 1420.0 |
| 2013-03-24 21:00:00 | CL | Futures | 148.82 | 148.98 | 148.8 | 148.94 | 1055.0 |
| 2013-03-24 22:00:00 | CL | Futures | 148.96 | 148.98 | 148.8 | 148.87 | 875.0 |
| 2013-03-24 23:00:00 | CL | Futures | 148.87 | 148.98 | 148.83 | 148.83 | 443.0 |
| 2013-03-24 18:00:00 | GC | Futures | 2212.4 | 2213.6 | 2209.6 | 2210.7 | 819.0 |
| 2013-03-24 19:00:00 | GC | Futures | 2210.6 | 2210.7 | 2202.4 | 2207.9 | 2931.0 |
| 2013-03-24 20:00:00 | GC | Futures | 2208.0 | 2211.4 | 2204.4 | 2210.5 | 2756.0 |
| 2013-03-24 21:00:00 | GC | Futures | 2210.3 | 2211.4 | 2209.0 | 2211.2 | 2549.0 |
| 2013-03-24 22:00:00 | GC | Futures | 2211.2 | 2217.9 | 2210.5 | 2215.8 | 3659.0 |
| 2013-03-24 23:00:00 | GC | Futures | 2216.0 | 2216.7 | 2213.6 | 2214.0 | 1419.0 |
| 2013-03-24 18:00:00 | ZN | Futures | 118.136486 | 118.178613 | 118.122444 | 118.150528 | 6566.0 |
| 2013-03-24 19:00:00 | ZN | Futures | 118.150528 | 118.150528 | 117.953938 | 117.982023 | 28441.0 |
| 2013-03-24 20:00:00 | ZN | Futures | 117.982023 | 117.982023 | 117.89777 | 117.939896 | 18747.0 |
| 2013-03-24 21:00:00 | ZN | Futures | 117.939896 | 117.939896 | 117.827559 | 117.869686 | 19918.0 |
| 2013-03-24 22:00:00 | ZN | Futures | 117.855644 | 117.911812 | 117.841601 | 117.841601 | 13450.0 |
| 2013-03-24 23:00:00 | ZN | Futures | 117.855644 | 117.925854 | 117.841601 | 117.925854 | 9939.0 |
> showing 36 of 281 rows — these rows as CSV