PREVIEW / futures_30min / 2015-04-19
file: by_date/futures_30min/2015/2015-04-19.parquet size: 20 KB rows: 521
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-04-19 18:00:00 | ES | Futures | 2198.52 | 2199.04 | 2195.88 | 2196.67 | 12645.0 |
| 2015-04-19 18:30:00 | ES | Futures | 2196.93 | 2198.78 | 2196.67 | 2197.99 | 2500.0 |
| 2015-04-19 19:00:00 | ES | Futures | 2197.99 | 2198.25 | 2196.14 | 2197.46 | 1988.0 |
| 2015-04-19 19:30:00 | ES | Futures | 2197.46 | 2199.31 | 2197.2 | 2199.04 | 2889.0 |
| 2015-04-19 20:00:00 | ES | Futures | 2199.04 | 2199.04 | 2196.67 | 2197.99 | 2874.0 |
| 2015-04-19 20:30:00 | ES | Futures | 2197.99 | 2198.52 | 2197.2 | 2198.25 | 1814.0 |
| 2015-04-19 21:00:00 | ES | Futures | 2198.25 | 2199.57 | 2197.99 | 2198.52 | 3014.0 |
| 2015-04-19 21:30:00 | ES | Futures | 2198.52 | 2199.84 | 2198.25 | 2199.04 | 5213.0 |
| 2015-04-19 22:00:00 | ES | Futures | 2199.31 | 2202.74 | 2199.04 | 2201.95 | 10358.0 |
| 2015-04-19 22:30:00 | ES | Futures | 2201.69 | 2202.21 | 2200.63 | 2201.42 | 1810.0 |
| 2015-04-19 23:00:00 | ES | Futures | 2201.42 | 2201.95 | 2200.89 | 2201.69 | 1400.0 |
| 2015-04-19 23:30:00 | ES | Futures | 2201.69 | 2201.95 | 2201.16 | 2201.69 | 931.0 |
| 2015-04-19 18:00:00 | NQ | Futures | 5124.65 | 5127.29 | 5119.65 | 5120.53 | 1813.0 |
| 2015-04-19 18:30:00 | NQ | Futures | 5121.12 | 5124.65 | 5121.12 | 5124.06 | 419.0 |
| 2015-04-19 19:00:00 | NQ | Futures | 5123.76 | 5124.35 | 5119.35 | 5121.12 | 291.0 |
| 2015-04-19 19:30:00 | NQ | Futures | 5121.7 | 5124.94 | 5121.12 | 5124.65 | 379.0 |
| 2015-04-19 20:00:00 | NQ | Futures | 5124.06 | 5124.06 | 5119.35 | 5122.59 | 466.0 |
| 2015-04-19 20:30:00 | NQ | Futures | 5122.59 | 5124.06 | 5121.12 | 5123.76 | 267.0 |
| 2015-04-19 21:00:00 | NQ | Futures | 5123.17 | 5125.82 | 5122.88 | 5124.06 | 435.0 |
| 2015-04-19 21:30:00 | NQ | Futures | 5123.76 | 5125.53 | 5122.59 | 5123.17 | 821.0 |
| 2015-04-19 22:00:00 | NQ | Futures | 5123.17 | 5130.82 | 5123.17 | 5128.76 | 1421.0 |
| 2015-04-19 22:30:00 | NQ | Futures | 5128.76 | 5129.64 | 5126.41 | 5127.59 | 228.0 |
| 2015-04-19 23:00:00 | NQ | Futures | 5127.88 | 5129.35 | 5126.7 | 5128.17 | 205.0 |
| 2015-04-19 23:30:00 | NQ | Futures | 5128.47 | 5128.76 | 5127.0 | 5127.59 | 174.0 |
| 2015-04-19 18:00:00 | YM | Futures | 18669.4 | 18693.5 | 18655.8 | 18666.3 | 1080.0 |
| 2015-04-19 18:30:00 | YM | Futures | 18666.3 | 18680.9 | 18666.3 | 18674.7 | 184.0 |
| 2015-04-19 19:00:00 | YM | Futures | 18673.6 | 18677.8 | 18662.1 | 18669.4 | 190.0 |
| 2015-04-19 19:30:00 | YM | Futures | 18667.3 | 18680.9 | 18667.3 | 18679.9 | 250.0 |
| 2015-04-19 20:00:00 | YM | Futures | 18678.8 | 18678.8 | 18661.0 | 18671.5 | 408.0 |
| 2015-04-19 20:30:00 | YM | Futures | 18671.5 | 18678.8 | 18668.4 | 18677.8 | 244.0 |
| 2015-04-19 21:00:00 | YM | Futures | 18678.8 | 18689.3 | 18675.7 | 18679.9 | 408.0 |
| 2015-04-19 21:30:00 | YM | Futures | 18679.9 | 18688.3 | 18675.7 | 18680.9 | 594.0 |
| 2015-04-19 22:00:00 | YM | Futures | 18680.9 | 18711.4 | 18679.9 | 18706.1 | 928.0 |
| 2015-04-19 22:30:00 | YM | Futures | 18703.0 | 18705.1 | 18695.6 | 18704.0 | 226.0 |
| 2015-04-19 23:00:00 | YM | Futures | 18704.0 | 18706.1 | 18697.7 | 18701.9 | 150.0 |
| 2015-04-19 23:30:00 | YM | Futures | 18701.9 | 18705.1 | 18698.8 | 18700.9 | 162.0 |
| 2015-04-19 18:00:00 | CL | Futures | 88.05 | 88.21 | 87.8 | 88.06 | 1403.0 |
| 2015-04-19 18:30:00 | CL | Futures | 88.05 | 88.27 | 88.02 | 88.17 | 416.0 |
| 2015-04-19 19:00:00 | CL | Futures | 88.17 | 88.29 | 88.14 | 88.24 | 372.0 |
| 2015-04-19 19:30:00 | CL | Futures | 88.24 | 88.34 | 88.21 | 88.34 | 352.0 |
| 2015-04-19 20:00:00 | CL | Futures | 88.34 | 88.4 | 88.26 | 88.37 | 941.0 |
| 2015-04-19 20:30:00 | CL | Futures | 88.37 | 88.47 | 88.34 | 88.37 | 921.0 |
| 2015-04-19 21:00:00 | CL | Futures | 88.38 | 88.43 | 88.27 | 88.31 | 1282.0 |
| 2015-04-19 21:30:00 | CL | Futures | 88.32 | 88.53 | 88.26 | 88.43 | 1031.0 |
| 2015-04-19 22:00:00 | CL | Futures | 88.44 | 88.7 | 88.35 | 88.67 | 1588.0 |
| 2015-04-19 22:30:00 | CL | Futures | 88.7 | 88.84 | 88.61 | 88.76 | 1106.0 |
| 2015-04-19 23:00:00 | CL | Futures | 88.78 | 88.85 | 88.56 | 88.61 | 462.0 |
| 2015-04-19 23:30:00 | CL | Futures | 88.6 | 88.69 | 88.58 | 88.61 | 174.0 |
| 2015-04-19 18:00:00 | GC | Futures | 1644.9 | 1646.4 | 1644.6 | 1645.3 | 781.0 |
| 2015-04-19 18:30:00 | GC | Futures | 1645.2 | 1645.3 | 1643.5 | 1643.7 | 361.0 |
> showing 50 of 521 rows — these rows as CSV