PREVIEW / futures_30min / 2010-10-03
file: by_date/futures_30min/2010/2010-10-03.parquet size: 19 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-10-03 18:00:00 | ES | Futures | 1127.15 | 1127.64 | 1125.18 | 1125.67 | 3802.0 |
| 2010-10-03 18:30:00 | ES | Futures | 1125.67 | 1125.92 | 1123.2 | 1123.45 | 2453.0 |
| 2010-10-03 19:00:00 | ES | Futures | 1123.45 | 1124.44 | 1122.71 | 1123.94 | 2798.0 |
| 2010-10-03 19:30:00 | ES | Futures | 1123.94 | 1124.19 | 1123.2 | 1123.7 | 1936.0 |
| 2010-10-03 20:00:00 | ES | Futures | 1123.7 | 1124.44 | 1122.96 | 1123.45 | 2129.0 |
| 2010-10-03 20:30:00 | ES | Futures | 1123.2 | 1124.19 | 1123.2 | 1123.45 | 1167.0 |
| 2010-10-03 21:00:00 | ES | Futures | 1123.45 | 1125.92 | 1123.2 | 1125.67 | 3367.0 |
| 2010-10-03 21:30:00 | ES | Futures | 1125.67 | 1126.41 | 1125.18 | 1126.16 | 2719.0 |
| 2010-10-03 22:00:00 | ES | Futures | 1125.92 | 1127.89 | 1125.92 | 1127.64 | 3466.0 |
| 2010-10-03 22:30:00 | ES | Futures | 1127.64 | 1127.89 | 1126.9 | 1127.64 | 1729.0 |
| 2010-10-03 23:00:00 | ES | Futures | 1127.39 | 1127.64 | 1125.92 | 1126.16 | 1376.0 |
| 2010-10-03 23:30:00 | ES | Futures | 1125.92 | 1126.16 | 1123.94 | 1124.44 | 3271.0 |
| 2010-10-03 18:00:00 | NQ | Futures | 2292.64 | 2292.64 | 2286.61 | 2287.76 | 311.0 |
| 2010-10-03 18:30:00 | NQ | Futures | 2286.9 | 2287.76 | 2282.02 | 2282.02 | 208.0 |
| 2010-10-03 19:00:00 | NQ | Futures | 2282.31 | 2284.6 | 2281.45 | 2283.74 | 127.0 |
| 2010-10-03 19:30:00 | NQ | Futures | 2283.74 | 2283.74 | 2281.74 | 2282.02 | 150.0 |
| 2010-10-03 20:00:00 | NQ | Futures | 2282.6 | 2284.32 | 2281.74 | 2282.31 | 146.0 |
| 2010-10-03 20:30:00 | NQ | Futures | 2282.88 | 2284.6 | 2282.02 | 2283.74 | 116.0 |
| 2010-10-03 21:00:00 | NQ | Futures | 2283.46 | 2288.33 | 2282.88 | 2287.76 | 191.0 |
| 2010-10-03 21:30:00 | NQ | Futures | 2287.76 | 2289.48 | 2287.19 | 2288.33 | 112.0 |
| 2010-10-03 22:00:00 | NQ | Futures | 2288.05 | 2291.2 | 2288.05 | 2291.2 | 171.0 |
| 2010-10-03 22:30:00 | NQ | Futures | 2291.49 | 2291.78 | 2290.34 | 2290.92 | 127.0 |
| 2010-10-03 23:00:00 | NQ | Futures | 2291.2 | 2291.2 | 2287.76 | 2287.76 | 141.0 |
| 2010-10-03 23:30:00 | NQ | Futures | 2287.47 | 2288.33 | 2284.6 | 2285.47 | 126.0 |
| 2010-10-03 18:00:00 | YM | Futures | 10260.1 | 10269.6 | 10249.6 | 10252.5 | 84.0 |
| 2010-10-03 18:30:00 | YM | Futures | 10251.5 | 10253.4 | 10231.5 | 10234.4 | 59.0 |
| 2010-10-03 19:00:00 | YM | Futures | 10234.4 | 10242.0 | 10227.7 | 10239.1 | 71.0 |
| 2010-10-03 19:30:00 | YM | Futures | 10238.2 | 10238.2 | 10232.4 | 10238.2 | 55.0 |
| 2010-10-03 20:00:00 | YM | Futures | 10238.2 | 10243.9 | 10232.4 | 10236.3 | 217.0 |
| 2010-10-03 20:30:00 | YM | Futures | 10236.3 | 10242.9 | 10234.4 | 10239.1 | 146.0 |
| 2010-10-03 21:00:00 | YM | Futures | 10236.3 | 10259.1 | 10234.4 | 10256.3 | 269.0 |
| 2010-10-03 21:30:00 | YM | Futures | 10255.3 | 10261.0 | 10251.5 | 10258.2 | 193.0 |
| 2010-10-03 22:00:00 | YM | Futures | 10260.1 | 10269.6 | 10257.2 | 10269.6 | 168.0 |
| 2010-10-03 22:30:00 | YM | Futures | 10268.6 | 10269.6 | 10264.8 | 10266.7 | 65.0 |
| 2010-10-03 23:00:00 | YM | Futures | 10267.7 | 10268.6 | 10255.3 | 10255.3 | 88.0 |
| 2010-10-03 23:30:00 | YM | Futures | 10255.3 | 10255.3 | 10242.0 | 10245.8 | 137.0 |
| 2010-10-03 18:00:00 | CL | Futures | 154.52 | 154.88 | 154.37 | 154.64 | 728.0 |
| 2010-10-03 18:30:00 | CL | Futures | 154.66 | 154.66 | 154.28 | 154.28 | 214.0 |
| 2010-10-03 19:00:00 | CL | Futures | 154.31 | 154.33 | 154.14 | 154.26 | 194.0 |
| 2010-10-03 19:30:00 | CL | Futures | 154.26 | 154.28 | 154.09 | 154.28 | 245.0 |
| 2010-10-03 20:00:00 | CL | Futures | 154.28 | 154.41 | 154.13 | 154.18 | 373.0 |
| 2010-10-03 20:30:00 | CL | Futures | 154.18 | 154.28 | 154.11 | 154.22 | 142.0 |
| 2010-10-03 21:00:00 | CL | Futures | 154.24 | 154.31 | 154.22 | 154.28 | 210.0 |
| 2010-10-03 21:30:00 | CL | Futures | 154.26 | 154.31 | 154.18 | 154.24 | 204.0 |
| 2010-10-03 22:00:00 | CL | Futures | 154.2 | 154.43 | 154.18 | 154.43 | 158.0 |
| 2010-10-03 22:30:00 | CL | Futures | 154.43 | 154.48 | 154.31 | 154.33 | 89.0 |
| 2010-10-03 23:00:00 | CL | Futures | 154.37 | 154.43 | 154.22 | 154.22 | 169.0 |
| 2010-10-03 23:30:00 | CL | Futures | 154.22 | 154.3 | 154.16 | 154.24 | 111.0 |
| 2010-10-03 18:00:00 | GC | Futures | 1846.3 | 1848.5 | 1844.9 | 1848.0 | 522.0 |
| 2010-10-03 18:30:00 | GC | Futures | 1847.8 | 1848.5 | 1847.4 | 1848.5 | 198.0 |
> showing 50 of 486 rows — these rows as CSV