PREVIEW / futures_30min / 2010-05-09
file: by_date/futures_30min/2010/2010-05-09.parquet size: 20 KB rows: 486
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-09 18:00:00 | ES | Futures | 1100.16 | 1105.54 | 1098.21 | 1101.38 | 47533.0 |
| 2010-05-09 18:30:00 | ES | Futures | 1101.14 | 1105.05 | 1099.92 | 1101.14 | 16317.0 |
| 2010-05-09 19:00:00 | ES | Futures | 1101.38 | 1103.83 | 1098.45 | 1098.94 | 9690.0 |
| 2010-05-09 19:30:00 | ES | Futures | 1098.94 | 1100.9 | 1096.5 | 1100.16 | 17182.0 |
| 2010-05-09 20:00:00 | ES | Futures | 1100.41 | 1105.05 | 1099.92 | 1103.34 | 20647.0 |
| 2010-05-09 20:30:00 | ES | Futures | 1103.1 | 1107.5 | 1102.85 | 1106.76 | 26705.0 |
| 2010-05-09 21:00:00 | ES | Futures | 1107.01 | 1108.72 | 1104.32 | 1107.98 | 20219.0 |
| 2010-05-09 21:30:00 | ES | Futures | 1107.74 | 1110.18 | 1106.76 | 1109.7 | 19414.0 |
| 2010-05-09 22:00:00 | ES | Futures | 1109.7 | 1111.65 | 1109.21 | 1109.7 | 18327.0 |
| 2010-05-09 22:30:00 | ES | Futures | 1109.7 | 1110.43 | 1109.21 | 1109.45 | 3943.0 |
| 2010-05-09 23:00:00 | ES | Futures | 1109.45 | 1111.65 | 1107.98 | 1111.41 | 10407.0 |
| 2010-05-09 23:30:00 | ES | Futures | 1111.16 | 1113.12 | 1111.16 | 1112.14 | 9207.0 |
| 2010-05-09 18:00:00 | NQ | Futures | 2146.36 | 2161.83 | 2144.64 | 2152.95 | 2308.0 |
| 2010-05-09 18:30:00 | NQ | Futures | 2154.38 | 2160.11 | 2150.66 | 2153.81 | 935.0 |
| 2010-05-09 19:00:00 | NQ | Futures | 2152.95 | 2158.68 | 2148.37 | 2149.23 | 948.0 |
| 2010-05-09 19:30:00 | NQ | Futures | 2149.51 | 2152.09 | 2144.64 | 2151.52 | 839.0 |
| 2010-05-09 20:00:00 | NQ | Futures | 2151.23 | 2161.25 | 2150.37 | 2158.1 | 920.0 |
| 2010-05-09 20:30:00 | NQ | Futures | 2157.24 | 2164.4 | 2155.53 | 2163.26 | 1418.0 |
| 2010-05-09 21:00:00 | NQ | Futures | 2162.97 | 2166.98 | 2158.68 | 2166.12 | 1167.0 |
| 2010-05-09 21:30:00 | NQ | Futures | 2166.12 | 2170.99 | 2164.69 | 2169.85 | 1381.0 |
| 2010-05-09 22:00:00 | NQ | Futures | 2170.13 | 2173.85 | 2168.7 | 2169.56 | 981.0 |
| 2010-05-09 22:30:00 | NQ | Futures | 2169.85 | 2170.42 | 2168.13 | 2168.7 | 243.0 |
| 2010-05-09 23:00:00 | NQ | Futures | 2169.27 | 2173.0 | 2165.84 | 2173.0 | 916.0 |
| 2010-05-09 23:30:00 | NQ | Futures | 2172.42 | 2175.86 | 2171.85 | 2174.14 | 1052.0 |
| 2010-05-09 18:00:00 | YM | Futures | 9847.4 | 9907.6 | 9847.4 | 9870.9 | 992.0 |
| 2010-05-09 18:30:00 | YM | Futures | 9873.7 | 9899.1 | 9863.4 | 9871.8 | 535.0 |
| 2010-05-09 19:00:00 | YM | Futures | 9872.8 | 9889.7 | 9850.2 | 9850.2 | 372.0 |
| 2010-05-09 19:30:00 | YM | Futures | 9852.1 | 9867.1 | 9834.2 | 9862.4 | 506.0 |
| 2010-05-09 20:00:00 | YM | Futures | 9861.5 | 9899.1 | 9858.6 | 9891.6 | 885.0 |
| 2010-05-09 20:30:00 | YM | Futures | 9887.8 | 9915.1 | 9878.4 | 9911.3 | 1771.0 |
| 2010-05-09 21:00:00 | YM | Futures | 9912.3 | 9926.4 | 9890.6 | 9918.9 | 1101.0 |
| 2010-05-09 21:30:00 | YM | Futures | 9918.9 | 9933.0 | 9909.5 | 9929.2 | 1613.0 |
| 2010-05-09 22:00:00 | YM | Futures | 9928.3 | 9946.2 | 9925.5 | 9927.3 | 803.0 |
| 2010-05-09 22:30:00 | YM | Futures | 9927.3 | 9934.9 | 9924.5 | 9926.4 | 245.0 |
| 2010-05-09 23:00:00 | YM | Futures | 9925.5 | 9943.3 | 9916.0 | 9939.6 | 754.0 |
| 2010-05-09 23:30:00 | YM | Futures | 9940.5 | 9953.7 | 9938.6 | 9945.2 | 347.0 |
| 2010-05-09 18:00:00 | CL | Futures | 159.18 | 159.98 | 158.53 | 159.33 | 3796.0 |
| 2010-05-09 18:30:00 | CL | Futures | 159.39 | 159.91 | 159.14 | 159.26 | 1422.0 |
| 2010-05-09 19:00:00 | CL | Futures | 159.26 | 159.56 | 159.08 | 159.16 | 507.0 |
| 2010-05-09 19:30:00 | CL | Futures | 159.2 | 159.26 | 158.6 | 159.14 | 1101.0 |
| 2010-05-09 20:00:00 | CL | Futures | 159.12 | 159.68 | 159.1 | 159.66 | 1461.0 |
| 2010-05-09 20:30:00 | CL | Futures | 159.62 | 160.0 | 159.06 | 159.6 | 2076.0 |
| 2010-05-09 21:00:00 | CL | Futures | 159.6 | 160.39 | 159.22 | 160.29 | 1567.0 |
| 2010-05-09 21:30:00 | CL | Futures | 160.29 | 160.52 | 160.14 | 160.16 | 1008.0 |
| 2010-05-09 22:00:00 | CL | Futures | 160.23 | 160.6 | 159.93 | 160.29 | 1393.0 |
| 2010-05-09 22:30:00 | CL | Futures | 160.25 | 160.67 | 160.14 | 160.39 | 753.0 |
| 2010-05-09 23:00:00 | CL | Futures | 160.37 | 160.79 | 160.29 | 160.77 | 654.0 |
| 2010-05-09 23:30:00 | CL | Futures | 160.79 | 160.81 | 160.5 | 160.69 | 555.0 |
| 2010-05-09 18:00:00 | GC | Futures | 1697.1 | 1697.1 | 1681.8 | 1686.6 | 3972.0 |
| 2010-05-09 18:30:00 | GC | Futures | 1686.6 | 1691.1 | 1685.3 | 1689.0 | 838.0 |
> showing 50 of 486 rows — these rows as CSV