PREVIEW / futures_30min / 2014-11-30
file: by_date/futures_30min/2014/2014-11-30.parquet size: 21 KB rows: 541
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 |
|---|---|---|---|---|---|---|---|
| 2014-11-30 18:00:00 | ES | Futures | 2162.02 | 2162.8 | 2153.63 | 2158.35 | 24959.0 |
| 2014-11-30 18:30:00 | ES | Futures | 2158.61 | 2159.14 | 2153.63 | 2156.78 | 8053.0 |
| 2014-11-30 19:00:00 | ES | Futures | 2157.04 | 2158.09 | 2155.73 | 2157.83 | 4575.0 |
| 2014-11-30 19:30:00 | ES | Futures | 2157.83 | 2160.18 | 2157.56 | 2159.92 | 3212.0 |
| 2014-11-30 20:00:00 | ES | Futures | 2159.66 | 2161.23 | 2158.61 | 2159.4 | 5140.0 |
| 2014-11-30 20:30:00 | ES | Futures | 2159.4 | 2159.66 | 2157.3 | 2157.56 | 3922.0 |
| 2014-11-30 21:00:00 | ES | Futures | 2157.3 | 2158.61 | 2156.52 | 2157.04 | 2690.0 |
| 2014-11-30 21:30:00 | ES | Futures | 2157.04 | 2158.35 | 2155.47 | 2155.73 | 3727.0 |
| 2014-11-30 22:00:00 | ES | Futures | 2155.73 | 2156.52 | 2155.47 | 2155.99 | 2042.0 |
| 2014-11-30 22:30:00 | ES | Futures | 2155.99 | 2157.3 | 2155.99 | 2157.04 | 1620.0 |
| 2014-11-30 23:00:00 | ES | Futures | 2157.04 | 2157.3 | 2155.21 | 2155.99 | 1145.0 |
| 2014-11-30 23:30:00 | ES | Futures | 2155.99 | 2157.83 | 2155.47 | 2157.04 | 2161.0 |
| 2014-11-30 18:00:00 | NQ | Futures | 5075.74 | 5079.84 | 5059.92 | 5072.22 | 3972.0 |
| 2014-11-30 18:30:00 | NQ | Futures | 5072.22 | 5073.69 | 5061.09 | 5067.53 | 1475.0 |
| 2014-11-30 19:00:00 | NQ | Futures | 5067.53 | 5072.52 | 5065.19 | 5071.34 | 1678.0 |
| 2014-11-30 19:30:00 | NQ | Futures | 5071.05 | 5076.32 | 5071.05 | 5075.45 | 642.0 |
| 2014-11-30 20:00:00 | NQ | Futures | 5075.15 | 5079.55 | 5073.69 | 5075.74 | 1036.0 |
| 2014-11-30 20:30:00 | NQ | Futures | 5075.45 | 5076.91 | 5071.93 | 5072.81 | 882.0 |
| 2014-11-30 21:00:00 | NQ | Futures | 5072.22 | 5075.45 | 5070.17 | 5071.64 | 749.0 |
| 2014-11-30 21:30:00 | NQ | Futures | 5071.34 | 5074.57 | 5068.12 | 5068.71 | 742.0 |
| 2014-11-30 22:00:00 | NQ | Futures | 5068.71 | 5071.05 | 5068.12 | 5069.29 | 425.0 |
| 2014-11-30 22:30:00 | NQ | Futures | 5069.29 | 5072.81 | 5069.0 | 5072.22 | 323.0 |
| 2014-11-30 23:00:00 | NQ | Futures | 5071.93 | 5071.93 | 5066.95 | 5069.29 | 349.0 |
| 2014-11-30 23:30:00 | NQ | Futures | 5069.0 | 5073.69 | 5067.83 | 5071.64 | 393.0 |
| 2014-11-30 18:00:00 | YM | Futures | 18491.1 | 18494.3 | 18408.0 | 18471.4 | 3895.0 |
| 2014-11-30 18:30:00 | YM | Futures | 18470.4 | 18475.6 | 18432.9 | 18455.8 | 1095.0 |
| 2014-11-30 19:00:00 | YM | Futures | 18455.8 | 18468.3 | 18450.6 | 18464.1 | 1155.0 |
| 2014-11-30 19:30:00 | YM | Futures | 18464.1 | 18488.0 | 18464.1 | 18483.9 | 703.0 |
| 2014-11-30 20:00:00 | YM | Futures | 18483.9 | 18492.2 | 18476.6 | 18479.7 | 1050.0 |
| 2014-11-30 20:30:00 | YM | Futures | 18478.7 | 18481.8 | 18465.2 | 18465.2 | 644.0 |
| 2014-11-30 21:00:00 | YM | Futures | 18466.2 | 18473.5 | 18456.8 | 18463.1 | 483.0 |
| 2014-11-30 21:30:00 | YM | Futures | 18462.0 | 18471.4 | 18451.6 | 18452.7 | 734.0 |
| 2014-11-30 22:00:00 | YM | Futures | 18453.7 | 18458.9 | 18450.6 | 18455.8 | 446.0 |
| 2014-11-30 22:30:00 | YM | Futures | 18454.8 | 18470.4 | 18454.8 | 18468.3 | 609.0 |
| 2014-11-30 23:00:00 | YM | Futures | 18468.3 | 18468.3 | 18451.6 | 18456.8 | 252.0 |
| 2014-11-30 23:30:00 | YM | Futures | 18455.8 | 18470.4 | 18453.7 | 18464.1 | 351.0 |
| 2014-11-30 18:00:00 | CL | Futures | 111.17 | 111.48 | 108.85 | 108.85 | 14208.0 |
| 2014-11-30 18:30:00 | CL | Futures | 108.88 | 109.37 | 108.06 | 108.28 | 6735.0 |
| 2014-11-30 19:00:00 | CL | Futures | 108.31 | 109.02 | 107.97 | 108.87 | 5246.0 |
| 2014-11-30 19:30:00 | CL | Futures | 108.87 | 109.46 | 108.09 | 109.15 | 4989.0 |
| 2014-11-30 20:00:00 | CL | Futures | 109.14 | 109.29 | 108.66 | 109.02 | 2573.0 |
| 2014-11-30 20:30:00 | CL | Futures | 109.0 | 109.29 | 108.73 | 109.24 | 2675.0 |
| 2014-11-30 21:00:00 | CL | Futures | 109.24 | 109.41 | 108.82 | 108.97 | 2420.0 |
| 2014-11-30 21:30:00 | CL | Futures | 108.98 | 109.22 | 108.92 | 108.98 | 1064.0 |
| 2014-11-30 22:00:00 | CL | Futures | 108.98 | 109.09 | 108.83 | 108.97 | 887.0 |
| 2014-11-30 22:30:00 | CL | Futures | 108.93 | 109.09 | 108.68 | 108.8 | 1001.0 |
| 2014-11-30 23:00:00 | CL | Futures | 108.78 | 108.87 | 108.28 | 108.53 | 2995.0 |
| 2014-11-30 23:30:00 | CL | Futures | 108.56 | 109.09 | 108.56 | 108.92 | 1518.0 |
| 2014-11-30 18:00:00 | GC | Futures | 1586.1 | 1586.2 | 1573.2 | 1574.6 | 11502.0 |
| 2014-11-30 18:30:00 | GC | Futures | 1574.5 | 1575.3 | 1561.9 | 1572.8 | 11306.0 |
> showing 50 of 541 rows — these rows as CSV