PREVIEW / futures_30min / 2010-05-16
file: by_date/futures_30min/2010/2010-05-16.parquet size: 20 KB rows: 456
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-16 18:00:00 | ES | Futures | 1108.47 | 1110.67 | 1106.03 | 1108.23 | 12606.0 |
| 2010-05-16 18:30:00 | ES | Futures | 1108.47 | 1109.21 | 1106.76 | 1107.01 | 2796.0 |
| 2010-05-16 19:00:00 | ES | Futures | 1106.76 | 1106.76 | 1103.83 | 1104.32 | 7858.0 |
| 2010-05-16 19:30:00 | ES | Futures | 1104.32 | 1108.47 | 1104.32 | 1107.98 | 5290.0 |
| 2010-05-16 20:00:00 | ES | Futures | 1108.23 | 1109.45 | 1104.32 | 1105.05 | 9095.0 |
| 2010-05-16 20:30:00 | ES | Futures | 1105.3 | 1108.47 | 1104.81 | 1107.74 | 5932.0 |
| 2010-05-16 21:00:00 | ES | Futures | 1107.74 | 1108.72 | 1105.54 | 1105.54 | 3655.0 |
| 2010-05-16 21:30:00 | ES | Futures | 1105.3 | 1105.78 | 1101.63 | 1103.1 | 8475.0 |
| 2010-05-16 22:00:00 | ES | Futures | 1103.1 | 1103.34 | 1096.25 | 1096.99 | 17686.0 |
| 2010-05-16 22:30:00 | ES | Futures | 1096.99 | 1098.45 | 1096.25 | 1097.23 | 12279.0 |
| 2010-05-16 23:00:00 | ES | Futures | 1096.99 | 1099.18 | 1095.52 | 1098.7 | 8343.0 |
| 2010-05-16 23:30:00 | ES | Futures | 1098.7 | 1099.43 | 1095.27 | 1096.01 | 6290.0 |
| 2010-05-16 18:00:00 | NQ | Futures | 2185.31 | 2189.89 | 2179.87 | 2185.02 | 716.0 |
| 2010-05-16 18:30:00 | NQ | Futures | 2184.74 | 2185.88 | 2181.87 | 2181.87 | 141.0 |
| 2010-05-16 19:00:00 | NQ | Futures | 2180.73 | 2181.59 | 2176.15 | 2177.86 | 364.0 |
| 2010-05-16 19:30:00 | NQ | Futures | 2177.58 | 2185.02 | 2177.29 | 2184.74 | 320.0 |
| 2010-05-16 20:00:00 | NQ | Futures | 2184.74 | 2186.45 | 2177.86 | 2178.72 | 467.0 |
| 2010-05-16 20:30:00 | NQ | Futures | 2179.58 | 2185.6 | 2178.15 | 2183.88 | 427.0 |
| 2010-05-16 21:00:00 | NQ | Futures | 2184.16 | 2185.31 | 2180.15 | 2180.15 | 354.0 |
| 2010-05-16 21:30:00 | NQ | Futures | 2179.58 | 2179.87 | 2172.71 | 2175.29 | 579.0 |
| 2010-05-16 22:00:00 | NQ | Futures | 2175.29 | 2175.29 | 2162.11 | 2163.26 | 1047.0 |
| 2010-05-16 22:30:00 | NQ | Futures | 2163.83 | 2166.12 | 2161.83 | 2163.54 | 721.0 |
| 2010-05-16 23:00:00 | NQ | Futures | 2163.54 | 2167.55 | 2159.82 | 2166.12 | 554.0 |
| 2010-05-16 23:30:00 | NQ | Futures | 2165.55 | 2167.27 | 2159.54 | 2161.25 | 423.0 |
| 2010-05-16 18:00:00 | YM | Futures | 9974.4 | 9990.4 | 9951.8 | 9966.9 | 271.0 |
| 2010-05-16 18:30:00 | YM | Futures | 9969.7 | 9977.2 | 9958.4 | 9959.3 | 118.0 |
| 2010-05-16 19:00:00 | YM | Futures | 9959.3 | 9959.3 | 9931.1 | 9936.7 | 501.0 |
| 2010-05-16 19:30:00 | YM | Futures | 9934.9 | 9966.9 | 9933.9 | 9966.9 | 404.0 |
| 2010-05-16 20:00:00 | YM | Futures | 9965.0 | 9976.3 | 9936.7 | 9942.4 | 397.0 |
| 2010-05-16 20:30:00 | YM | Futures | 9943.3 | 9965.9 | 9937.7 | 9960.3 | 286.0 |
| 2010-05-16 21:00:00 | YM | Futures | 9962.2 | 9966.9 | 9945.2 | 9945.2 | 361.0 |
| 2010-05-16 21:30:00 | YM | Futures | 9944.3 | 9944.3 | 9911.3 | 9921.7 | 612.0 |
| 2010-05-16 22:00:00 | YM | Futures | 9921.7 | 9921.7 | 9865.2 | 9870.9 | 1641.0 |
| 2010-05-16 22:30:00 | YM | Futures | 9870.9 | 9885.0 | 9866.2 | 9872.8 | 1093.0 |
| 2010-05-16 23:00:00 | YM | Futures | 9872.8 | 9889.7 | 9861.5 | 9885.0 | 827.0 |
| 2010-05-16 23:30:00 | YM | Futures | 9884.1 | 9889.7 | 9854.9 | 9867.1 | 792.0 |
| 2010-05-16 18:00:00 | CL | Futures | 148.74 | 149.35 | 148.33 | 148.36 | 164.0 |
| 2010-05-16 18:30:00 | CL | Futures | 148.4 | 148.48 | 148.36 | 148.46 | 60.0 |
| 2010-05-16 19:00:00 | CL | Futures | 148.38 | 148.44 | 148.19 | 148.25 | 177.0 |
| 2010-05-16 19:30:00 | CL | Futures | 148.19 | 148.27 | 147.91 | 147.99 | 165.0 |
| 2010-05-16 20:00:00 | CL | Futures | 147.97 | 147.99 | 146.83 | 146.93 | 566.0 |
| 2010-05-16 20:30:00 | CL | Futures | 146.95 | 147.24 | 146.77 | 147.09 | 216.0 |
| 2010-05-16 21:00:00 | CL | Futures | 147.09 | 147.13 | 146.83 | 146.97 | 137.0 |
| 2010-05-16 21:30:00 | CL | Futures | 146.89 | 146.89 | 145.63 | 145.73 | 590.0 |
| 2010-05-16 22:00:00 | CL | Futures | 145.77 | 145.77 | 144.73 | 144.84 | 1121.0 |
| 2010-05-16 22:30:00 | CL | Futures | 144.84 | 145.43 | 144.69 | 145.34 | 669.0 |
| 2010-05-16 23:00:00 | CL | Futures | 145.28 | 145.59 | 145.0 | 145.49 | 442.0 |
| 2010-05-16 23:30:00 | CL | Futures | 145.41 | 145.61 | 144.9 | 145.28 | 251.0 |
| 2010-05-16 18:00:00 | GC | Futures | 1732.3 | 1737.0 | 1730.9 | 1735.8 | 1053.0 |
| 2010-05-16 18:30:00 | GC | Futures | 1735.8 | 1735.8 | 1731.0 | 1733.8 | 530.0 |
> showing 50 of 456 rows — these rows as CSV