PREVIEW / futures_30min / 2015-07-12
file: by_date/futures_30min/2015/2015-07-12.parquet size: 20 KB rows: 526
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-12 18:00:00 | ES | Futures | 2188.29 | 2198.68 | 2185.37 | 2194.42 | 24835.0 |
| 2015-07-12 18:30:00 | ES | Futures | 2194.68 | 2194.95 | 2191.49 | 2191.76 | 5536.0 |
| 2015-07-12 19:00:00 | ES | Futures | 2192.02 | 2196.02 | 2191.76 | 2194.95 | 5951.0 |
| 2015-07-12 19:30:00 | ES | Futures | 2194.95 | 2195.48 | 2193.35 | 2193.89 | 2127.0 |
| 2015-07-12 20:00:00 | ES | Futures | 2193.89 | 2194.15 | 2192.02 | 2193.09 | 3934.0 |
| 2015-07-12 20:30:00 | ES | Futures | 2193.09 | 2193.89 | 2192.29 | 2193.35 | 2813.0 |
| 2015-07-12 21:00:00 | ES | Futures | 2193.09 | 2194.42 | 2192.82 | 2193.89 | 2144.0 |
| 2015-07-12 21:30:00 | ES | Futures | 2193.89 | 2194.95 | 2193.09 | 2194.42 | 4635.0 |
| 2015-07-12 22:00:00 | ES | Futures | 2194.68 | 2197.88 | 2194.42 | 2196.28 | 4706.0 |
| 2015-07-12 22:30:00 | ES | Futures | 2196.55 | 2197.61 | 2195.75 | 2197.61 | 1220.0 |
| 2015-07-12 23:00:00 | ES | Futures | 2197.61 | 2203.74 | 2197.35 | 2200.54 | 10880.0 |
| 2015-07-12 23:30:00 | ES | Futures | 2200.81 | 2201.87 | 2197.35 | 2200.54 | 6977.0 |
| 2015-07-12 18:00:00 | NQ | Futures | 5186.96 | 5201.75 | 5173.36 | 5194.95 | 2458.0 |
| 2015-07-12 18:30:00 | NQ | Futures | 5194.65 | 5194.65 | 5189.33 | 5189.33 | 511.0 |
| 2015-07-12 19:00:00 | NQ | Futures | 5189.92 | 5199.68 | 5189.63 | 5198.2 | 579.0 |
| 2015-07-12 19:30:00 | NQ | Futures | 5197.91 | 5198.79 | 5195.54 | 5196.43 | 308.0 |
| 2015-07-12 20:00:00 | NQ | Futures | 5196.43 | 5196.72 | 5191.7 | 5194.65 | 617.0 |
| 2015-07-12 20:30:00 | NQ | Futures | 5194.65 | 5197.61 | 5193.17 | 5194.95 | 406.0 |
| 2015-07-12 21:00:00 | NQ | Futures | 5194.65 | 5198.2 | 5194.06 | 5197.02 | 295.0 |
| 2015-07-12 21:30:00 | NQ | Futures | 5196.72 | 5201.46 | 5196.43 | 5199.09 | 823.0 |
| 2015-07-12 22:00:00 | NQ | Futures | 5199.09 | 5207.67 | 5199.09 | 5204.12 | 827.0 |
| 2015-07-12 22:30:00 | NQ | Futures | 5204.41 | 5207.67 | 5203.23 | 5207.67 | 216.0 |
| 2015-07-12 23:00:00 | NQ | Futures | 5207.37 | 5223.05 | 5207.37 | 5215.65 | 1732.0 |
| 2015-07-12 23:30:00 | NQ | Futures | 5215.65 | 5218.02 | 5207.37 | 5213.88 | 817.0 |
| 2015-07-12 18:00:00 | YM | Futures | 18504.0 | 18571.4 | 18473.5 | 18547.2 | 2540.0 |
| 2015-07-12 18:30:00 | YM | Futures | 18545.1 | 18548.3 | 18524.0 | 18525.1 | 384.0 |
| 2015-07-12 19:00:00 | YM | Futures | 18526.1 | 18560.9 | 18526.1 | 18554.6 | 497.0 |
| 2015-07-12 19:30:00 | YM | Futures | 18553.5 | 18556.7 | 18542.0 | 18544.1 | 193.0 |
| 2015-07-12 20:00:00 | YM | Futures | 18544.1 | 18545.1 | 18527.2 | 18535.6 | 953.0 |
| 2015-07-12 20:30:00 | YM | Futures | 18535.6 | 18542.0 | 18533.5 | 18539.8 | 341.0 |
| 2015-07-12 21:00:00 | YM | Futures | 18539.8 | 18544.1 | 18535.6 | 18540.9 | 308.0 |
| 2015-07-12 21:30:00 | YM | Futures | 18543.0 | 18553.5 | 18536.7 | 18548.3 | 529.0 |
| 2015-07-12 22:00:00 | YM | Futures | 18547.2 | 18570.4 | 18546.2 | 18560.9 | 697.0 |
| 2015-07-12 22:30:00 | YM | Futures | 18563.0 | 18574.6 | 18555.6 | 18574.6 | 257.0 |
| 2015-07-12 23:00:00 | YM | Futures | 18575.7 | 18618.9 | 18575.7 | 18595.7 | 1920.0 |
| 2015-07-12 23:30:00 | YM | Futures | 18596.7 | 18604.1 | 18574.6 | 18593.6 | 966.0 |
| 2015-07-12 18:00:00 | CL | Futures | 77.69 | 77.88 | 77.12 | 77.3 | 3439.0 |
| 2015-07-12 18:30:00 | CL | Futures | 77.3 | 77.39 | 77.2 | 77.35 | 681.0 |
| 2015-07-12 19:00:00 | CL | Futures | 77.35 | 77.69 | 77.33 | 77.69 | 639.0 |
| 2015-07-12 19:30:00 | CL | Futures | 77.68 | 77.78 | 77.6 | 77.63 | 526.0 |
| 2015-07-12 20:00:00 | CL | Futures | 77.63 | 77.77 | 77.63 | 77.68 | 501.0 |
| 2015-07-12 20:30:00 | CL | Futures | 77.66 | 77.71 | 77.6 | 77.63 | 601.0 |
| 2015-07-12 21:00:00 | CL | Futures | 77.63 | 77.65 | 77.24 | 77.33 | 1667.0 |
| 2015-07-12 21:30:00 | CL | Futures | 77.32 | 77.42 | 77.15 | 77.2 | 1035.0 |
| 2015-07-12 22:00:00 | CL | Futures | 77.18 | 77.39 | 77.14 | 77.24 | 893.0 |
| 2015-07-12 22:30:00 | CL | Futures | 77.24 | 77.33 | 77.17 | 77.27 | 860.0 |
| 2015-07-12 23:00:00 | CL | Futures | 77.29 | 77.44 | 77.23 | 77.38 | 812.0 |
| 2015-07-12 23:30:00 | CL | Futures | 77.36 | 77.42 | 77.26 | 77.35 | 566.0 |
| 2015-07-12 18:00:00 | GC | Futures | 1586.5 | 1588.7 | 1584.9 | 1584.9 | 1357.0 |
| 2015-07-12 18:30:00 | GC | Futures | 1584.9 | 1587.9 | 1584.3 | 1586.1 | 914.0 |
> showing 50 of 526 rows — these rows as CSV