PREVIEW / futures_30min / 2010-06-06
file: by_date/futures_30min/2010/2010-06-06.parquet size: 19 KB rows: 457
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-06 18:00:00 | ES | Futures | 1040.28 | 1041.74 | 1037.59 | 1039.06 | 11607.0 |
| 2010-06-06 18:30:00 | ES | Futures | 1038.81 | 1040.77 | 1032.95 | 1034.66 | 10537.0 |
| 2010-06-06 19:00:00 | ES | Futures | 1034.66 | 1036.86 | 1033.92 | 1036.61 | 5530.0 |
| 2010-06-06 19:30:00 | ES | Futures | 1036.61 | 1040.77 | 1036.61 | 1037.59 | 8306.0 |
| 2010-06-06 20:00:00 | ES | Futures | 1037.59 | 1038.81 | 1033.43 | 1035.15 | 12625.0 |
| 2010-06-06 20:30:00 | ES | Futures | 1035.15 | 1035.39 | 1028.55 | 1031.72 | 13284.0 |
| 2010-06-06 21:00:00 | ES | Futures | 1031.72 | 1032.95 | 1029.52 | 1029.52 | 4734.0 |
| 2010-06-06 21:30:00 | ES | Futures | 1029.52 | 1030.99 | 1028.55 | 1028.55 | 7369.0 |
| 2010-06-06 22:00:00 | ES | Futures | 1028.79 | 1032.21 | 1028.55 | 1030.75 | 5555.0 |
| 2010-06-06 22:30:00 | ES | Futures | 1030.75 | 1034.17 | 1030.26 | 1033.19 | 5002.0 |
| 2010-06-06 23:00:00 | ES | Futures | 1033.19 | 1033.43 | 1030.75 | 1031.97 | 2547.0 |
| 2010-06-06 23:30:00 | ES | Futures | 1031.72 | 1034.17 | 1031.72 | 1033.43 | 2958.0 |
| 2010-06-06 18:00:00 | NQ | Futures | 2098.25 | 2098.82 | 2092.24 | 2094.82 | 518.0 |
| 2010-06-06 18:30:00 | NQ | Futures | 2094.53 | 2097.39 | 2076.77 | 2084.79 | 1625.0 |
| 2010-06-06 19:00:00 | NQ | Futures | 2085.37 | 2089.37 | 2084.22 | 2089.37 | 417.0 |
| 2010-06-06 19:30:00 | NQ | Futures | 2089.66 | 2097.39 | 2089.66 | 2091.67 | 447.0 |
| 2010-06-06 20:00:00 | NQ | Futures | 2091.95 | 2093.38 | 2083.07 | 2086.8 | 764.0 |
| 2010-06-06 20:30:00 | NQ | Futures | 2086.51 | 2086.51 | 2075.06 | 2079.92 | 846.0 |
| 2010-06-06 21:00:00 | NQ | Futures | 2080.21 | 2082.5 | 2076.2 | 2077.06 | 682.0 |
| 2010-06-06 21:30:00 | NQ | Futures | 2076.77 | 2079.35 | 2075.34 | 2076.77 | 1123.0 |
| 2010-06-06 22:00:00 | NQ | Futures | 2076.77 | 2084.22 | 2076.2 | 2080.78 | 698.0 |
| 2010-06-06 22:30:00 | NQ | Futures | 2080.78 | 2086.8 | 2080.21 | 2084.51 | 440.0 |
| 2010-06-06 23:00:00 | NQ | Futures | 2083.65 | 2084.79 | 2079.92 | 2083.65 | 276.0 |
| 2010-06-06 23:30:00 | NQ | Futures | 2082.5 | 2087.66 | 2082.5 | 2085.37 | 291.0 |
| 2010-06-06 18:00:00 | YM | Futures | 9338.3 | 9345.8 | 9320.4 | 9329.8 | 452.0 |
| 2010-06-06 18:30:00 | YM | Futures | 9329.8 | 9339.2 | 9274.3 | 9285.6 | 1008.0 |
| 2010-06-06 19:00:00 | YM | Futures | 9287.5 | 9308.2 | 9281.8 | 9307.2 | 748.0 |
| 2010-06-06 19:30:00 | YM | Futures | 9307.2 | 9336.4 | 9307.2 | 9311.9 | 561.0 |
| 2010-06-06 20:00:00 | YM | Futures | 9312.9 | 9327.0 | 9281.8 | 9297.8 | 877.0 |
| 2010-06-06 20:30:00 | YM | Futures | 9296.9 | 9299.7 | 9245.1 | 9265.8 | 1214.0 |
| 2010-06-06 21:00:00 | YM | Futures | 9266.8 | 9277.1 | 9243.2 | 9244.2 | 680.0 |
| 2010-06-06 21:30:00 | YM | Futures | 9244.2 | 9260.2 | 9244.2 | 9247.0 | 754.0 |
| 2010-06-06 22:00:00 | YM | Futures | 9247.0 | 9268.7 | 9242.3 | 9258.3 | 738.0 |
| 2010-06-06 22:30:00 | YM | Futures | 9259.2 | 9282.8 | 9258.3 | 9277.1 | 628.0 |
| 2010-06-06 23:00:00 | YM | Futures | 9277.1 | 9277.1 | 9260.2 | 9265.8 | 393.0 |
| 2010-06-06 23:30:00 | YM | Futures | 9265.8 | 9283.7 | 9263.9 | 9276.2 | 394.0 |
| 2010-06-06 18:00:00 | CL | Futures | 138.35 | 138.83 | 138.2 | 138.59 | 1369.0 |
| 2010-06-06 18:30:00 | CL | Futures | 138.59 | 138.63 | 137.98 | 138.08 | 871.0 |
| 2010-06-06 19:00:00 | CL | Futures | 138.08 | 138.41 | 138.08 | 138.31 | 634.0 |
| 2010-06-06 19:30:00 | CL | Futures | 138.31 | 138.57 | 138.28 | 138.33 | 478.0 |
| 2010-06-06 20:00:00 | CL | Futures | 138.33 | 138.45 | 137.86 | 138.08 | 970.0 |
| 2010-06-06 20:30:00 | CL | Futures | 138.0 | 138.18 | 136.7 | 137.17 | 2290.0 |
| 2010-06-06 21:00:00 | CL | Futures | 137.17 | 137.43 | 136.94 | 136.98 | 1091.0 |
| 2010-06-06 21:30:00 | CL | Futures | 136.98 | 137.69 | 136.94 | 137.37 | 1313.0 |
| 2010-06-06 22:00:00 | CL | Futures | 137.37 | 137.94 | 137.35 | 137.72 | 875.0 |
| 2010-06-06 22:30:00 | CL | Futures | 137.74 | 138.04 | 137.61 | 137.88 | 570.0 |
| 2010-06-06 23:00:00 | CL | Futures | 137.9 | 137.92 | 137.59 | 137.67 | 519.0 |
| 2010-06-06 23:30:00 | CL | Futures | 137.71 | 138.0 | 137.61 | 137.72 | 463.0 |
| 2010-06-06 18:00:00 | GC | Futures | 1713.8 | 1715.4 | 1711.7 | 1713.2 | 581.0 |
| 2010-06-06 18:30:00 | GC | Futures | 1713.2 | 1715.8 | 1713.1 | 1714.4 | 350.0 |
> showing 50 of 457 rows — these rows as CSV