PREVIEW / futures_30min / 2013-05-12
file: by_date/futures_30min/2013/2013-05-12.parquet size: 20 KB rows: 508
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 | 1672.24 | 1672.24 | 18848.0 |
| 2013-05-12 18:30:00 | ES | Futures | 1671.98 | 1672.5 | 1670.69 | 1672.24 | 8100.0 |
| 2013-05-12 19:00:00 | ES | Futures | 1672.24 | 1673.27 | 1671.98 | 1672.24 | 2321.0 |
| 2013-05-12 19:30:00 | ES | Futures | 1672.24 | 1673.01 | 1671.72 | 1671.98 | 1700.0 |
| 2013-05-12 20:00:00 | ES | Futures | 1671.98 | 1673.78 | 1671.21 | 1673.01 | 4439.0 |
| 2013-05-12 20:30:00 | ES | Futures | 1673.01 | 1673.78 | 1672.75 | 1673.01 | 2052.0 |
| 2013-05-12 21:00:00 | ES | Futures | 1673.27 | 1673.78 | 1672.75 | 1672.75 | 2357.0 |
| 2013-05-12 21:30:00 | ES | Futures | 1673.01 | 1673.78 | 1672.5 | 1673.53 | 2536.0 |
| 2013-05-12 22:00:00 | ES | Futures | 1673.53 | 1675.33 | 1673.53 | 1673.78 | 4984.0 |
| 2013-05-12 22:30:00 | ES | Futures | 1673.53 | 1674.56 | 1673.53 | 1674.3 | 957.0 |
| 2013-05-12 23:00:00 | ES | Futures | 1674.3 | 1674.81 | 1673.78 | 1674.3 | 1822.0 |
| 2013-05-12 23:30:00 | ES | Futures | 1674.56 | 1674.56 | 1673.53 | 1673.78 | 2921.0 |
| 2013-05-12 18:00:00 | NQ | Futures | 3467.64 | 3467.64 | 3460.35 | 3460.93 | 1062.0 |
| 2013-05-12 18:30:00 | NQ | Futures | 3460.64 | 3460.93 | 3457.43 | 3460.35 | 362.0 |
| 2013-05-12 19:00:00 | NQ | Futures | 3460.64 | 3462.39 | 3460.35 | 3460.93 | 96.0 |
| 2013-05-12 19:30:00 | NQ | Futures | 3460.64 | 3462.1 | 3459.77 | 3459.77 | 103.0 |
| 2013-05-12 20:00:00 | NQ | Futures | 3459.77 | 3463.27 | 3458.89 | 3461.81 | 477.0 |
| 2013-05-12 20:30:00 | NQ | Futures | 3461.81 | 3462.97 | 3461.81 | 3461.81 | 257.0 |
| 2013-05-12 21:00:00 | NQ | Futures | 3461.52 | 3462.97 | 3461.22 | 3461.22 | 182.0 |
| 2013-05-12 21:30:00 | NQ | Futures | 3461.52 | 3462.68 | 3460.93 | 3462.68 | 292.0 |
| 2013-05-12 22:00:00 | NQ | Futures | 3462.39 | 3465.89 | 3462.39 | 3462.97 | 380.0 |
| 2013-05-12 22:30:00 | NQ | Futures | 3463.27 | 3464.43 | 3463.27 | 3464.14 | 132.0 |
| 2013-05-12 23:00:00 | NQ | Futures | 3464.14 | 3465.31 | 3463.56 | 3464.43 | 171.0 |
| 2013-05-12 23:30:00 | NQ | Futures | 3464.14 | 3464.72 | 3462.1 | 3462.68 | 522.0 |
| 2013-05-12 18:00:00 | YM | Futures | 15203.6 | 15206.6 | 15186.4 | 15186.4 | 1004.0 |
| 2013-05-12 18:30:00 | YM | Futures | 15186.4 | 15191.5 | 15176.3 | 15186.4 | 470.0 |
| 2013-05-12 19:00:00 | YM | Futures | 15187.4 | 15193.5 | 15186.4 | 15191.5 | 199.0 |
| 2013-05-12 19:30:00 | YM | Futures | 15191.5 | 15195.5 | 15185.4 | 15187.4 | 241.0 |
| 2013-05-12 20:00:00 | YM | Futures | 15187.4 | 15200.6 | 15184.4 | 15195.5 | 675.0 |
| 2013-05-12 20:30:00 | YM | Futures | 15194.5 | 15200.6 | 15194.5 | 15197.5 | 218.0 |
| 2013-05-12 21:00:00 | YM | Futures | 15196.5 | 15201.6 | 15192.5 | 15194.5 | 298.0 |
| 2013-05-12 21:30:00 | YM | Futures | 15195.5 | 15198.5 | 15190.5 | 15198.5 | 347.0 |
| 2013-05-12 22:00:00 | YM | Futures | 15197.5 | 15212.7 | 15197.5 | 15199.6 | 437.0 |
| 2013-05-12 22:30:00 | YM | Futures | 15200.6 | 15208.7 | 15200.6 | 15207.6 | 338.0 |
| 2013-05-12 23:00:00 | YM | Futures | 15206.6 | 15207.6 | 15202.6 | 15204.6 | 328.0 |
| 2013-05-12 23:30:00 | YM | Futures | 15205.6 | 15206.6 | 15196.5 | 15199.6 | 608.0 |
| 2013-05-12 18:00:00 | CL | Futures | 150.38 | 150.46 | 150.16 | 150.22 | 912.0 |
| 2013-05-12 18:30:00 | CL | Futures | 150.22 | 150.35 | 150.17 | 150.3 | 255.0 |
| 2013-05-12 19:00:00 | CL | Futures | 150.28 | 150.33 | 150.13 | 150.17 | 317.0 |
| 2013-05-12 19:30:00 | CL | Futures | 150.19 | 150.19 | 150.05 | 150.05 | 352.0 |
| 2013-05-12 20:00:00 | CL | Futures | 150.05 | 150.22 | 150.05 | 150.17 | 331.0 |
| 2013-05-12 20:30:00 | CL | Futures | 150.17 | 150.21 | 149.77 | 149.78 | 822.0 |
| 2013-05-12 21:00:00 | CL | Futures | 149.78 | 149.91 | 149.4 | 149.45 | 1543.0 |
| 2013-05-12 21:30:00 | CL | Futures | 149.45 | 149.56 | 149.4 | 149.56 | 598.0 |
| 2013-05-12 22:00:00 | CL | Futures | 149.56 | 149.69 | 149.5 | 149.51 | 350.0 |
| 2013-05-12 22:30:00 | CL | Futures | 149.51 | 149.7 | 149.51 | 149.58 | 350.0 |
| 2013-05-12 23:00:00 | CL | Futures | 149.61 | 149.69 | 149.58 | 149.66 | 204.0 |
| 2013-05-12 23:30:00 | CL | Futures | 149.67 | 149.78 | 149.59 | 149.61 | 420.0 |
| 2013-05-12 18:00:00 | GC | Futures | 1988.4 | 1989.2 | 1978.9 | 1979.2 | 1753.0 |
| 2013-05-12 18:30:00 | GC | Futures | 1979.2 | 1980.9 | 1975.7 | 1978.5 | 1532.0 |
> showing 50 of 508 rows — these rows as CSV