PREVIEW / futures_1hour / 2013-05-12
file: by_date/futures_1hour/2013/2013-05-12.parquet size: 14 KB rows: 270
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-05-12 18:00:00 | ES | Futures | 1674.81 | 1675.59 | 1670.69 | 1672.24 | 26948.0 |
| 2013-05-12 19:00:00 | ES | Futures | 1672.24 | 1673.27 | 1671.72 | 1671.98 | 4021.0 |
| 2013-05-12 20:00:00 | ES | Futures | 1671.98 | 1673.78 | 1671.21 | 1673.01 | 6491.0 |
| 2013-05-12 21:00:00 | ES | Futures | 1673.27 | 1673.78 | 1672.5 | 1673.53 | 4893.0 |
| 2013-05-12 22:00:00 | ES | Futures | 1673.53 | 1675.33 | 1673.53 | 1674.3 | 5941.0 |
| 2013-05-12 23:00:00 | ES | Futures | 1674.3 | 1674.81 | 1673.53 | 1673.78 | 4743.0 |
| 2013-05-12 18:00:00 | NQ | Futures | 3467.64 | 3467.64 | 3457.43 | 3460.35 | 1424.0 |
| 2013-05-12 19:00:00 | NQ | Futures | 3460.64 | 3462.39 | 3459.77 | 3459.77 | 199.0 |
| 2013-05-12 20:00:00 | NQ | Futures | 3459.77 | 3463.27 | 3458.89 | 3461.81 | 734.0 |
| 2013-05-12 21:00:00 | NQ | Futures | 3461.52 | 3462.97 | 3460.93 | 3462.68 | 474.0 |
| 2013-05-12 22:00:00 | NQ | Futures | 3462.39 | 3465.89 | 3462.39 | 3464.14 | 512.0 |
| 2013-05-12 23:00:00 | NQ | Futures | 3464.14 | 3465.31 | 3462.1 | 3462.68 | 693.0 |
| 2013-05-12 18:00:00 | YM | Futures | 15203.6 | 15206.6 | 15176.3 | 15186.4 | 1474.0 |
| 2013-05-12 19:00:00 | YM | Futures | 15187.4 | 15195.5 | 15185.4 | 15187.4 | 440.0 |
| 2013-05-12 20:00:00 | YM | Futures | 15187.4 | 15200.6 | 15184.4 | 15197.5 | 893.0 |
| 2013-05-12 21:00:00 | YM | Futures | 15196.5 | 15201.6 | 15190.5 | 15198.5 | 645.0 |
| 2013-05-12 22:00:00 | YM | Futures | 15197.5 | 15212.7 | 15197.5 | 15207.6 | 775.0 |
| 2013-05-12 23:00:00 | YM | Futures | 15206.6 | 15207.6 | 15196.5 | 15199.6 | 936.0 |
| 2013-05-12 18:00:00 | CL | Futures | 150.38 | 150.46 | 150.16 | 150.3 | 1167.0 |
| 2013-05-12 19:00:00 | CL | Futures | 150.28 | 150.33 | 150.05 | 150.05 | 669.0 |
| 2013-05-12 20:00:00 | CL | Futures | 150.05 | 150.22 | 149.77 | 149.78 | 1153.0 |
| 2013-05-12 21:00:00 | CL | Futures | 149.78 | 149.91 | 149.4 | 149.56 | 2141.0 |
| 2013-05-12 22:00:00 | CL | Futures | 149.56 | 149.7 | 149.5 | 149.58 | 700.0 |
| 2013-05-12 23:00:00 | CL | Futures | 149.61 | 149.78 | 149.58 | 149.61 | 624.0 |
| 2013-05-12 18:00:00 | GC | Futures | 1988.4 | 1989.2 | 1975.7 | 1978.5 | 3285.0 |
| 2013-05-12 19:00:00 | GC | Futures | 1978.9 | 1980.8 | 1972.3 | 1973.3 | 3051.0 |
| 2013-05-12 20:00:00 | GC | Futures | 1973.4 | 1976.0 | 1970.5 | 1972.3 | 4308.0 |
| 2013-05-12 21:00:00 | GC | Futures | 1972.4 | 1976.0 | 1956.8 | 1963.8 | 8371.0 |
| 2013-05-12 22:00:00 | GC | Futures | 1963.8 | 1969.3 | 1963.4 | 1964.6 | 5169.0 |
| 2013-05-12 23:00:00 | GC | Futures | 1964.7 | 1964.7 | 1958.8 | 1963.6 | 3709.0 |
| 2013-05-12 18:00:00 | ZN | Futures | 118.613919 | 118.613919 | 118.389245 | 118.459455 | 25150.0 |
| 2013-05-12 19:00:00 | ZN | Futures | 118.473497 | 118.473497 | 118.417329 | 118.445413 | 11784.0 |
| 2013-05-12 20:00:00 | ZN | Futures | 118.431371 | 118.585835 | 118.431371 | 118.501582 | 24212.0 |
| 2013-05-12 21:00:00 | ZN | Futures | 118.501582 | 118.543708 | 118.459455 | 118.529666 | 7313.0 |
| 2013-05-12 22:00:00 | ZN | Futures | 118.529666 | 118.571792 | 118.515624 | 118.529666 | 9504.0 |
| 2013-05-12 23:00:00 | ZN | Futures | 118.543708 | 118.543708 | 118.48754 | 118.501582 | 5703.0 |
> showing 36 of 270 rows — these rows as CSV