PREVIEW / futures_30min / 2016-04-10
file: by_date/futures_30min/2016/2016-04-10.parquet size: 22 KB rows: 550
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 |
|---|---|---|---|---|---|---|---|
| 2016-04-10 18:00:00 | ES | Futures | 2204.12 | 2204.12 | 2201.42 | 2202.5 | 4987.0 |
| 2016-04-10 18:30:00 | ES | Futures | 2202.77 | 2205.2 | 2202.5 | 2204.12 | 1764.0 |
| 2016-04-10 19:00:00 | ES | Futures | 2204.12 | 2206.28 | 2203.85 | 2206.01 | 2053.0 |
| 2016-04-10 19:30:00 | ES | Futures | 2206.01 | 2206.55 | 2204.66 | 2205.2 | 2044.0 |
| 2016-04-10 20:00:00 | ES | Futures | 2204.93 | 2205.2 | 2201.42 | 2201.69 | 5456.0 |
| 2016-04-10 20:30:00 | ES | Futures | 2201.69 | 2202.5 | 2200.07 | 2201.69 | 5071.0 |
| 2016-04-10 21:00:00 | ES | Futures | 2201.69 | 2201.96 | 2195.75 | 2197.1 | 8450.0 |
| 2016-04-10 21:30:00 | ES | Futures | 2197.37 | 2200.61 | 2196.29 | 2199.53 | 7181.0 |
| 2016-04-10 22:00:00 | ES | Futures | 2199.26 | 2199.53 | 2197.1 | 2199.53 | 3255.0 |
| 2016-04-10 22:30:00 | ES | Futures | 2199.26 | 2203.85 | 2199.26 | 2202.77 | 6554.0 |
| 2016-04-10 23:00:00 | ES | Futures | 2203.04 | 2203.04 | 2200.88 | 2202.5 | 2422.0 |
| 2016-04-10 23:30:00 | ES | Futures | 2202.5 | 2204.12 | 2201.96 | 2202.5 | 3153.0 |
| 2016-04-10 18:00:00 | NQ | Futures | 5319.83 | 5319.83 | 5310.31 | 5314.18 | 434.0 |
| 2016-04-10 18:30:00 | NQ | Futures | 5313.58 | 5319.83 | 5313.58 | 5317.75 | 274.0 |
| 2016-04-10 19:00:00 | NQ | Futures | 5316.86 | 5324.29 | 5316.86 | 5324.29 | 420.0 |
| 2016-04-10 19:30:00 | NQ | Futures | 5324.59 | 5325.48 | 5320.13 | 5321.91 | 239.0 |
| 2016-04-10 20:00:00 | NQ | Futures | 5321.91 | 5321.91 | 5308.52 | 5310.01 | 572.0 |
| 2016-04-10 20:30:00 | NQ | Futures | 5310.01 | 5311.8 | 5304.66 | 5309.12 | 528.0 |
| 2016-04-10 21:00:00 | NQ | Futures | 5308.52 | 5309.42 | 5293.95 | 5298.71 | 1367.0 |
| 2016-04-10 21:30:00 | NQ | Futures | 5299.0 | 5307.04 | 5295.73 | 5304.06 | 738.0 |
| 2016-04-10 22:00:00 | NQ | Futures | 5304.66 | 5304.95 | 5298.41 | 5304.06 | 281.0 |
| 2016-04-10 22:30:00 | NQ | Futures | 5304.06 | 5315.96 | 5304.06 | 5313.58 | 783.0 |
| 2016-04-10 23:00:00 | NQ | Futures | 5313.29 | 5314.48 | 5308.82 | 5313.29 | 349.0 |
| 2016-04-10 23:30:00 | NQ | Futures | 5312.99 | 5317.75 | 5311.5 | 5312.99 | 356.0 |
| 2016-04-10 18:00:00 | YM | Futures | 18717.9 | 18721.1 | 18699.7 | 18709.3 | 490.0 |
| 2016-04-10 18:30:00 | YM | Futures | 18707.2 | 18726.5 | 18706.1 | 18715.8 | 280.0 |
| 2016-04-10 19:00:00 | YM | Futures | 18716.8 | 18734.0 | 18712.6 | 18732.9 | 327.0 |
| 2016-04-10 19:30:00 | YM | Futures | 18730.8 | 18736.1 | 18722.2 | 18724.3 | 254.0 |
| 2016-04-10 20:00:00 | YM | Futures | 18726.5 | 18726.5 | 18693.3 | 18696.5 | 653.0 |
| 2016-04-10 20:30:00 | YM | Futures | 18696.5 | 18704.0 | 18683.7 | 18696.5 | 647.0 |
| 2016-04-10 21:00:00 | YM | Futures | 18695.4 | 18696.5 | 18652.6 | 18664.4 | 1332.0 |
| 2016-04-10 21:30:00 | YM | Futures | 18668.7 | 18690.1 | 18659.0 | 18682.6 | 973.0 |
| 2016-04-10 22:00:00 | YM | Futures | 18681.5 | 18682.6 | 18663.3 | 18677.2 | 489.0 |
| 2016-04-10 22:30:00 | YM | Futures | 18679.4 | 18711.5 | 18676.2 | 18705.1 | 904.0 |
| 2016-04-10 23:00:00 | YM | Futures | 18706.1 | 18707.2 | 18693.3 | 18702.9 | 327.0 |
| 2016-04-10 23:30:00 | YM | Futures | 18701.9 | 18713.6 | 18698.6 | 18704.0 | 376.0 |
| 2016-04-10 18:00:00 | CL | Futures | 44.09 | 44.92 | 43.99 | 44.52 | 6571.0 |
| 2016-04-10 18:30:00 | CL | Futures | 44.53 | 44.7 | 44.48 | 44.67 | 1998.0 |
| 2016-04-10 19:00:00 | CL | Futures | 44.68 | 44.75 | 44.53 | 44.64 | 2561.0 |
| 2016-04-10 19:30:00 | CL | Futures | 44.64 | 44.65 | 44.51 | 44.61 | 1401.0 |
| 2016-04-10 20:00:00 | CL | Futures | 44.61 | 44.64 | 44.5 | 44.58 | 1801.0 |
| 2016-04-10 20:30:00 | CL | Futures | 44.59 | 44.6 | 44.52 | 44.55 | 1107.0 |
| 2016-04-10 21:00:00 | CL | Futures | 44.57 | 44.58 | 44.15 | 44.29 | 3820.0 |
| 2016-04-10 21:30:00 | CL | Futures | 44.28 | 44.33 | 44.12 | 44.25 | 2926.0 |
| 2016-04-10 22:00:00 | CL | Futures | 44.25 | 44.29 | 44.12 | 44.22 | 1551.0 |
| 2016-04-10 22:30:00 | CL | Futures | 44.21 | 44.42 | 44.21 | 44.35 | 2758.0 |
| 2016-04-10 23:00:00 | CL | Futures | 44.37 | 44.4 | 44.21 | 44.24 | 1674.0 |
| 2016-04-10 23:30:00 | CL | Futures | 44.23 | 44.32 | 44.13 | 44.24 | 1963.0 |
| 2016-04-10 18:00:00 | GC | Futures | 1693.6 | 1704.6 | 1693.4 | 1702.0 | 3254.0 |
| 2016-04-10 18:30:00 | GC | Futures | 1701.8 | 1704.6 | 1700.2 | 1700.5 | 1209.0 |
> showing 50 of 550 rows — these rows as CSV