PREVIEW / futures_30min / 2010-09-12
file: by_date/futures_30min/2010/2010-09-12.parquet size: 18 KB rows: 451
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-09-12 18:00:00 | ES | Futures | 1091.94 | 1097.34 | 1091.45 | 1094.64 | 5600.0 |
| 2010-09-12 18:30:00 | ES | Futures | 1094.64 | 1094.88 | 1093.9 | 1094.88 | 874.0 |
| 2010-09-12 19:00:00 | ES | Futures | 1094.88 | 1095.13 | 1094.39 | 1094.64 | 297.0 |
| 2010-09-12 19:30:00 | ES | Futures | 1094.39 | 1095.86 | 1094.39 | 1095.86 | 866.0 |
| 2010-09-12 20:00:00 | ES | Futures | 1095.86 | 1097.34 | 1095.62 | 1097.09 | 2979.0 |
| 2010-09-12 20:30:00 | ES | Futures | 1097.09 | 1097.34 | 1096.36 | 1096.85 | 902.0 |
| 2010-09-12 21:00:00 | ES | Futures | 1096.85 | 1097.34 | 1095.86 | 1096.11 | 564.0 |
| 2010-09-12 21:30:00 | ES | Futures | 1096.36 | 1096.85 | 1095.62 | 1096.11 | 572.0 |
| 2010-09-12 22:00:00 | ES | Futures | 1096.11 | 1097.09 | 1096.11 | 1096.6 | 404.0 |
| 2010-09-12 22:30:00 | ES | Futures | 1096.36 | 1097.83 | 1096.36 | 1097.83 | 908.0 |
| 2010-09-12 23:00:00 | ES | Futures | 1097.83 | 1097.83 | 1096.6 | 1097.83 | 634.0 |
| 2010-09-12 23:30:00 | ES | Futures | 1097.58 | 1098.81 | 1097.34 | 1098.07 | 1973.0 |
| 2010-09-12 18:00:00 | NQ | Futures | 2173.89 | 2181.63 | 2173.89 | 2180.19 | 668.0 |
| 2010-09-12 18:30:00 | NQ | Futures | 2179.05 | 2179.91 | 2178.19 | 2179.62 | 71.0 |
| 2010-09-12 19:00:00 | NQ | Futures | 2178.47 | 2180.19 | 2178.47 | 2178.47 | 15.0 |
| 2010-09-12 19:30:00 | NQ | Futures | 2179.05 | 2181.63 | 2178.47 | 2181.63 | 44.0 |
| 2010-09-12 20:00:00 | NQ | Futures | 2181.63 | 2184.78 | 2181.63 | 2184.78 | 136.0 |
| 2010-09-12 20:30:00 | NQ | Futures | 2184.49 | 2185.07 | 2182.49 | 2183.35 | 189.0 |
| 2010-09-12 21:00:00 | NQ | Futures | 2182.49 | 2184.49 | 2181.91 | 2182.2 | 107.0 |
| 2010-09-12 21:30:00 | NQ | Futures | 2181.91 | 2183.92 | 2181.91 | 2182.2 | 44.0 |
| 2010-09-12 22:00:00 | NQ | Futures | 2182.49 | 2184.49 | 2182.49 | 2184.49 | 167.0 |
| 2010-09-12 22:30:00 | NQ | Futures | 2183.63 | 2185.64 | 2183.35 | 2185.35 | 17.0 |
| 2010-09-12 23:00:00 | NQ | Futures | 2185.93 | 2185.93 | 2184.49 | 2184.49 | 4.0 |
| 2010-09-12 23:30:00 | NQ | Futures | 2185.35 | 2187.93 | 2185.35 | 2187.07 | 57.0 |
| 2010-09-12 18:00:00 | YM | Futures | 9954.3 | 9992.4 | 9927.6 | 9950.5 | 516.0 |
| 2010-09-12 18:30:00 | YM | Futures | 9949.5 | 9952.4 | 9941.9 | 9944.8 | 123.0 |
| 2010-09-12 19:00:00 | YM | Futures | 9946.7 | 9950.5 | 9944.8 | 9945.7 | 86.0 |
| 2010-09-12 19:30:00 | YM | Futures | 9946.7 | 9959.1 | 9946.7 | 9958.1 | 291.0 |
| 2010-09-12 20:00:00 | YM | Futures | 9959.1 | 9969.5 | 9959.1 | 9969.5 | 367.0 |
| 2010-09-12 20:30:00 | YM | Futures | 9968.6 | 9968.6 | 9962.9 | 9965.7 | 91.0 |
| 2010-09-12 21:00:00 | YM | Futures | 9966.7 | 9968.6 | 9959.1 | 9961.9 | 158.0 |
| 2010-09-12 21:30:00 | YM | Futures | 9961.9 | 9965.7 | 9959.1 | 9961.0 | 48.0 |
| 2010-09-12 22:00:00 | YM | Futures | 9961.0 | 9967.6 | 9961.0 | 9966.7 | 71.0 |
| 2010-09-12 22:30:00 | YM | Futures | 9964.8 | 9974.3 | 9964.8 | 9974.3 | 143.0 |
| 2010-09-12 23:00:00 | YM | Futures | 9973.4 | 9975.3 | 9967.6 | 9974.3 | 118.0 |
| 2010-09-12 23:30:00 | YM | Futures | 9974.3 | 9982.9 | 9974.3 | 9980.0 | 86.0 |
| 2010-09-12 18:00:00 | CL | Futures | 145.96 | 147.03 | 145.96 | 146.93 | 1269.0 |
| 2010-09-12 18:30:00 | CL | Futures | 146.91 | 146.97 | 146.76 | 146.84 | 173.0 |
| 2010-09-12 19:00:00 | CL | Futures | 146.8 | 146.89 | 146.74 | 146.8 | 174.0 |
| 2010-09-12 19:30:00 | CL | Futures | 146.8 | 147.06 | 146.8 | 147.05 | 257.0 |
| 2010-09-12 20:00:00 | CL | Futures | 147.05 | 147.73 | 146.99 | 147.7 | 1544.0 |
| 2010-09-12 20:30:00 | CL | Futures | 147.7 | 147.79 | 147.5 | 147.68 | 668.0 |
| 2010-09-12 21:00:00 | CL | Futures | 147.68 | 147.79 | 147.47 | 147.52 | 561.0 |
| 2010-09-12 21:30:00 | CL | Futures | 147.5 | 147.62 | 147.47 | 147.56 | 294.0 |
| 2010-09-12 22:00:00 | CL | Futures | 147.56 | 147.81 | 147.54 | 147.75 | 462.0 |
| 2010-09-12 22:30:00 | CL | Futures | 147.73 | 147.81 | 147.62 | 147.79 | 413.0 |
| 2010-09-12 23:00:00 | CL | Futures | 147.81 | 147.81 | 147.43 | 147.5 | 437.0 |
| 2010-09-12 23:30:00 | CL | Futures | 147.54 | 147.7 | 147.47 | 147.5 | 252.0 |
| 2010-09-12 18:00:00 | GC | Futures | 1745.0 | 1746.4 | 1742.5 | 1743.8 | 322.0 |
| 2010-09-12 18:30:00 | GC | Futures | 1743.9 | 1743.9 | 1743.3 | 1743.6 | 97.0 |
> showing 50 of 451 rows — these rows as CSV