PREVIEW / futures_30min / 2014-08-17
file: by_date/futures_30min/2014/2014-08-17.parquet size: 19 KB rows: 509
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-08-17 18:00:00 | ES | Futures | 2038.78 | 2044.52 | 2038.78 | 2042.17 | 13319.0 |
| 2014-08-17 18:30:00 | ES | Futures | 2042.17 | 2042.69 | 2041.13 | 2041.91 | 2212.0 |
| 2014-08-17 19:00:00 | ES | Futures | 2041.91 | 2043.21 | 2041.65 | 2042.95 | 1714.0 |
| 2014-08-17 19:30:00 | ES | Futures | 2042.95 | 2043.21 | 2041.91 | 2042.43 | 1570.0 |
| 2014-08-17 20:00:00 | ES | Futures | 2042.17 | 2042.17 | 2040.87 | 2041.65 | 2092.0 |
| 2014-08-17 20:30:00 | ES | Futures | 2041.39 | 2042.43 | 2041.39 | 2042.43 | 1414.0 |
| 2014-08-17 21:00:00 | ES | Futures | 2042.43 | 2042.43 | 2040.87 | 2041.65 | 2513.0 |
| 2014-08-17 21:30:00 | ES | Futures | 2041.39 | 2042.17 | 2041.13 | 2041.91 | 2343.0 |
| 2014-08-17 22:00:00 | ES | Futures | 2041.91 | 2041.91 | 2040.87 | 2041.13 | 1418.0 |
| 2014-08-17 22:30:00 | ES | Futures | 2041.39 | 2041.39 | 2039.83 | 2040.35 | 2922.0 |
| 2014-08-17 23:00:00 | ES | Futures | 2040.61 | 2041.13 | 2040.35 | 2040.87 | 525.0 |
| 2014-08-17 23:30:00 | ES | Futures | 2041.13 | 2041.91 | 2040.61 | 2041.65 | 1593.0 |
| 2014-08-17 18:00:00 | NQ | Futures | 4661.72 | 4673.99 | 4661.72 | 4669.9 | 2473.0 |
| 2014-08-17 18:30:00 | NQ | Futures | 4669.9 | 4671.07 | 4668.15 | 4668.73 | 348.0 |
| 2014-08-17 19:00:00 | NQ | Futures | 4668.73 | 4671.36 | 4668.73 | 4671.07 | 198.0 |
| 2014-08-17 19:30:00 | NQ | Futures | 4671.07 | 4671.36 | 4669.9 | 4670.77 | 105.0 |
| 2014-08-17 20:00:00 | NQ | Futures | 4670.48 | 4670.48 | 4667.56 | 4669.02 | 330.0 |
| 2014-08-17 20:30:00 | NQ | Futures | 4669.02 | 4670.48 | 4669.02 | 4670.48 | 176.0 |
| 2014-08-17 21:00:00 | NQ | Futures | 4670.19 | 4670.19 | 4667.85 | 4668.44 | 373.0 |
| 2014-08-17 21:30:00 | NQ | Futures | 4668.73 | 4668.73 | 4666.98 | 4667.56 | 516.0 |
| 2014-08-17 22:00:00 | NQ | Futures | 4667.85 | 4667.85 | 4666.39 | 4667.27 | 251.0 |
| 2014-08-17 22:30:00 | NQ | Futures | 4667.27 | 4667.27 | 4662.89 | 4665.23 | 464.0 |
| 2014-08-17 23:00:00 | NQ | Futures | 4665.23 | 4666.1 | 4665.23 | 4665.81 | 165.0 |
| 2014-08-17 23:30:00 | NQ | Futures | 4666.1 | 4668.15 | 4665.23 | 4667.56 | 266.0 |
| 2014-08-17 18:00:00 | YM | Futures | 17241.1 | 17284.5 | 17231.8 | 17261.8 | 1337.0 |
| 2014-08-17 18:30:00 | YM | Futures | 17261.8 | 17264.9 | 17256.6 | 17260.7 | 228.0 |
| 2014-08-17 19:00:00 | YM | Futures | 17259.7 | 17266.9 | 17258.7 | 17266.9 | 154.0 |
| 2014-08-17 19:30:00 | YM | Futures | 17268.0 | 17268.0 | 17259.7 | 17261.8 | 133.0 |
| 2014-08-17 20:00:00 | YM | Futures | 17260.7 | 17260.7 | 17252.5 | 17258.7 | 335.0 |
| 2014-08-17 20:30:00 | YM | Futures | 17257.6 | 17263.8 | 17257.6 | 17263.8 | 154.0 |
| 2014-08-17 21:00:00 | YM | Futures | 17263.8 | 17263.8 | 17252.5 | 17256.6 | 373.0 |
| 2014-08-17 21:30:00 | YM | Futures | 17257.6 | 17261.8 | 17254.5 | 17258.7 | 255.0 |
| 2014-08-17 22:00:00 | YM | Futures | 17257.6 | 17257.6 | 17251.4 | 17253.5 | 132.0 |
| 2014-08-17 22:30:00 | YM | Futures | 17254.5 | 17255.6 | 17243.1 | 17247.3 | 349.0 |
| 2014-08-17 23:00:00 | YM | Futures | 17247.3 | 17252.5 | 17247.3 | 17251.4 | 72.0 |
| 2014-08-17 23:30:00 | YM | Futures | 17252.5 | 17258.7 | 17248.3 | 17255.6 | 306.0 |
| 2014-08-17 18:00:00 | CL | Futures | 156.93 | 156.93 | 156.37 | 156.5 | 536.0 |
| 2014-08-17 18:30:00 | CL | Futures | 156.5 | 156.51 | 156.45 | 156.45 | 90.0 |
| 2014-08-17 19:00:00 | CL | Futures | 156.46 | 156.46 | 156.37 | 156.43 | 199.0 |
| 2014-08-17 19:30:00 | CL | Futures | 156.45 | 156.56 | 156.45 | 156.51 | 206.0 |
| 2014-08-17 20:00:00 | CL | Futures | 156.53 | 156.63 | 156.48 | 156.56 | 135.0 |
| 2014-08-17 20:30:00 | CL | Futures | 156.6 | 156.6 | 156.43 | 156.46 | 178.0 |
| 2014-08-17 21:00:00 | CL | Futures | 156.43 | 156.46 | 156.37 | 156.45 | 170.0 |
| 2014-08-17 21:30:00 | CL | Futures | 156.43 | 156.48 | 156.37 | 156.46 | 101.0 |
| 2014-08-17 22:00:00 | CL | Futures | 156.43 | 156.48 | 156.4 | 156.46 | 53.0 |
| 2014-08-17 22:30:00 | CL | Futures | 156.48 | 156.48 | 156.4 | 156.46 | 73.0 |
| 2014-08-17 23:00:00 | CL | Futures | 156.48 | 156.51 | 156.45 | 156.45 | 58.0 |
| 2014-08-17 23:30:00 | CL | Futures | 156.43 | 156.48 | 156.4 | 156.45 | 90.0 |
| 2014-08-17 18:00:00 | GC | Futures | 1785.4 | 1786.1 | 1782.8 | 1783.7 | 969.0 |
| 2014-08-17 18:30:00 | GC | Futures | 1783.7 | 1785.1 | 1783.6 | 1784.6 | 202.0 |
> showing 50 of 509 rows — these rows as CSV