PREVIEW / futures_30min / 2010-05-30
file: by_date/futures_30min/2010/2010-05-30.parquet size: 16 KB rows: 323
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-05-30 18:00:00 | ES | Futures | 1064.23 | 1064.48 | 1061.54 | 1062.77 | 9358.0 |
| 2010-05-30 18:30:00 | ES | Futures | 1062.77 | 1066.68 | 1062.77 | 1065.94 | 2221.0 |
| 2010-05-30 19:00:00 | ES | Futures | 1065.94 | 1067.41 | 1065.94 | 1065.94 | 1166.0 |
| 2010-05-30 19:30:00 | ES | Futures | 1065.94 | 1067.9 | 1064.72 | 1067.65 | 2280.0 |
| 2010-05-30 20:00:00 | ES | Futures | 1067.9 | 1070.34 | 1066.68 | 1069.12 | 5313.0 |
| 2010-05-30 20:30:00 | ES | Futures | 1069.12 | 1069.61 | 1067.17 | 1068.14 | 3366.0 |
| 2010-05-30 21:00:00 | ES | Futures | 1068.39 | 1069.61 | 1067.9 | 1069.12 | 1959.0 |
| 2010-05-30 21:30:00 | ES | Futures | 1069.12 | 1069.61 | 1067.65 | 1069.12 | 1664.0 |
| 2010-05-30 22:00:00 | ES | Futures | 1069.12 | 1069.61 | 1068.39 | 1068.88 | 1062.0 |
| 2010-05-30 22:30:00 | ES | Futures | 1068.88 | 1071.32 | 1068.88 | 1071.08 | 2551.0 |
| 2010-05-30 23:00:00 | ES | Futures | 1070.83 | 1071.08 | 1068.63 | 1069.36 | 1456.0 |
| 2010-05-30 23:30:00 | ES | Futures | 1069.36 | 1071.56 | 1069.12 | 1071.08 | 2122.0 |
| 2010-05-30 18:00:00 | NQ | Futures | 2121.45 | 2122.88 | 2119.16 | 2121.16 | 996.0 |
| 2010-05-30 18:30:00 | NQ | Futures | 2121.73 | 2129.47 | 2121.16 | 2127.18 | 210.0 |
| 2010-05-30 19:00:00 | NQ | Futures | 2127.75 | 2131.47 | 2127.75 | 2128.03 | 102.0 |
| 2010-05-30 19:30:00 | NQ | Futures | 2128.61 | 2131.47 | 2125.46 | 2131.47 | 169.0 |
| 2010-05-30 20:00:00 | NQ | Futures | 2131.47 | 2136.05 | 2129.75 | 2133.76 | 587.0 |
| 2010-05-30 20:30:00 | NQ | Futures | 2134.05 | 2134.62 | 2130.61 | 2131.76 | 247.0 |
| 2010-05-30 21:00:00 | NQ | Futures | 2132.33 | 2135.19 | 2131.76 | 2134.05 | 355.0 |
| 2010-05-30 21:30:00 | NQ | Futures | 2134.33 | 2134.91 | 2130.9 | 2134.62 | 242.0 |
| 2010-05-30 22:00:00 | NQ | Futures | 2134.62 | 2135.19 | 2132.33 | 2133.19 | 170.0 |
| 2010-05-30 22:30:00 | NQ | Futures | 2133.19 | 2137.49 | 2133.19 | 2136.63 | 304.0 |
| 2010-05-30 23:00:00 | NQ | Futures | 2136.34 | 2136.63 | 2133.48 | 2134.33 | 114.0 |
| 2010-05-30 23:30:00 | NQ | Futures | 2134.62 | 2137.2 | 2134.33 | 2136.91 | 232.0 |
| 2010-05-30 18:00:00 | YM | Futures | 9528.4 | 9528.4 | 9504.8 | 9519.0 | 418.0 |
| 2010-05-30 18:30:00 | YM | Futures | 9520.8 | 9546.2 | 9510.5 | 9543.4 | 116.0 |
| 2010-05-30 19:00:00 | YM | Futures | 9545.3 | 9553.8 | 9541.5 | 9543.4 | 82.0 |
| 2010-05-30 19:30:00 | YM | Futures | 9546.2 | 9564.1 | 9535.9 | 9563.2 | 190.0 |
| 2010-05-30 20:00:00 | YM | Futures | 9562.2 | 9571.6 | 9538.7 | 9565.1 | 695.0 |
| 2010-05-30 20:30:00 | YM | Futures | 9566.0 | 9568.8 | 9550.0 | 9555.7 | 183.0 |
| 2010-05-30 21:00:00 | YM | Futures | 9557.5 | 9571.6 | 9556.6 | 9565.1 | 159.0 |
| 2010-05-30 21:30:00 | YM | Futures | 9566.0 | 9567.9 | 9555.7 | 9561.3 | 81.0 |
| 2010-05-30 22:00:00 | YM | Futures | 9565.1 | 9574.5 | 9558.5 | 9564.1 | 246.0 |
| 2010-05-30 22:30:00 | YM | Futures | 9565.1 | 9579.2 | 9565.1 | 9575.4 | 149.0 |
| 2010-05-30 23:00:00 | YM | Futures | 9575.4 | 9576.4 | 9564.1 | 9568.8 | 89.0 |
| 2010-05-30 23:30:00 | YM | Futures | 9571.6 | 9582.9 | 9570.7 | 9578.2 | 111.0 |
| 2010-05-30 18:00:00 | CL | Futures | 145.47 | 145.47 | 145.24 | 145.47 | 292.0 |
| 2010-05-30 18:30:00 | CL | Futures | 145.47 | 145.51 | 145.28 | 145.36 | 137.0 |
| 2010-05-30 19:00:00 | CL | Futures | 145.41 | 145.49 | 145.26 | 145.3 | 76.0 |
| 2010-05-30 19:30:00 | CL | Futures | 145.34 | 145.49 | 145.28 | 145.41 | 68.0 |
| 2010-05-30 20:00:00 | CL | Futures | 145.38 | 146.87 | 145.32 | 146.06 | 970.0 |
| 2010-05-30 20:30:00 | CL | Futures | 146.06 | 146.2 | 145.47 | 145.59 | 1015.0 |
| 2010-05-30 21:00:00 | CL | Futures | 145.61 | 146.2 | 145.57 | 146.02 | 733.0 |
| 2010-05-30 21:30:00 | CL | Futures | 146.04 | 146.18 | 145.65 | 145.87 | 474.0 |
| 2010-05-30 22:00:00 | CL | Futures | 145.89 | 146.24 | 145.83 | 146.06 | 223.0 |
| 2010-05-30 22:30:00 | CL | Futures | 146.1 | 146.34 | 146.02 | 146.28 | 202.0 |
| 2010-05-30 23:00:00 | CL | Futures | 146.24 | 146.36 | 145.73 | 146.16 | 281.0 |
| 2010-05-30 23:30:00 | CL | Futures | 146.18 | 146.26 | 146.08 | 146.2 | 153.0 |
| 2010-05-30 18:00:00 | GC | Futures | 1707.6 | 1707.6 | 1705.5 | 1706.8 | 267.0 |
| 2010-05-30 18:30:00 | GC | Futures | 1707.1 | 1707.5 | 1706.5 | 1706.7 | 65.0 |
> showing 50 of 323 rows — these rows as CSV