PREVIEW / futures_1hour / 2010-10-17
file: by_date/futures_1hour/2010/2010-10-17.parquet size: 14 KB rows: 266
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-17 18:00:00 | ES | Futures | 1157.71 | 1158.2 | 1156.48 | 1157.22 | 6658.0 |
| 2010-10-17 19:00:00 | ES | Futures | 1157.22 | 1157.46 | 1155.49 | 1155.99 | 5017.0 |
| 2010-10-17 20:00:00 | ES | Futures | 1155.99 | 1156.23 | 1154.51 | 1155.0 | 9750.0 |
| 2010-10-17 21:00:00 | ES | Futures | 1155.0 | 1155.49 | 1154.01 | 1154.51 | 7662.0 |
| 2010-10-17 22:00:00 | ES | Futures | 1154.26 | 1154.51 | 1150.56 | 1152.29 | 15193.0 |
| 2010-10-17 23:00:00 | ES | Futures | 1152.04 | 1152.78 | 1152.04 | 1152.04 | 3442.0 |
| 2010-10-17 18:00:00 | NQ | Futures | 2404.24 | 2406.25 | 2402.23 | 2403.96 | 864.0 |
| 2010-10-17 19:00:00 | NQ | Futures | 2403.67 | 2404.24 | 2400.51 | 2400.8 | 447.0 |
| 2010-10-17 20:00:00 | NQ | Futures | 2401.09 | 2401.37 | 2398.5 | 2399.37 | 860.0 |
| 2010-10-17 21:00:00 | NQ | Futures | 2399.08 | 2399.94 | 2397.07 | 2397.93 | 479.0 |
| 2010-10-17 22:00:00 | NQ | Futures | 2397.93 | 2398.22 | 2390.76 | 2393.63 | 1224.0 |
| 2010-10-17 23:00:00 | NQ | Futures | 2393.63 | 2395.35 | 2393.05 | 2394.2 | 485.0 |
| 2010-10-17 18:00:00 | YM | Futures | 10488.7 | 10496.3 | 10484.9 | 10489.6 | 124.0 |
| 2010-10-17 19:00:00 | YM | Futures | 10487.7 | 10491.5 | 10474.4 | 10478.2 | 119.0 |
| 2010-10-17 20:00:00 | YM | Futures | 10479.2 | 10481.1 | 10470.6 | 10473.4 | 404.0 |
| 2010-10-17 21:00:00 | YM | Futures | 10474.4 | 10477.3 | 10467.7 | 10468.7 | 268.0 |
| 2010-10-17 22:00:00 | YM | Futures | 10469.6 | 10469.6 | 10439.2 | 10449.6 | 505.0 |
| 2010-10-17 23:00:00 | YM | Futures | 10449.6 | 10456.3 | 10448.7 | 10451.5 | 102.0 |
| 2010-10-17 18:00:00 | CL | Futures | 154.29 | 154.35 | 153.76 | 153.76 | 467.0 |
| 2010-10-17 19:00:00 | CL | Futures | 153.76 | 153.82 | 153.45 | 153.45 | 551.0 |
| 2010-10-17 20:00:00 | CL | Futures | 153.56 | 153.61 | 152.75 | 152.98 | 939.0 |
| 2010-10-17 21:00:00 | CL | Futures | 153.01 | 153.39 | 152.96 | 153.3 | 607.0 |
| 2010-10-17 22:00:00 | CL | Futures | 153.33 | 153.46 | 152.38 | 152.68 | 1169.0 |
| 2010-10-17 23:00:00 | CL | Futures | 152.69 | 153.03 | 152.69 | 152.79 | 475.0 |
| 2010-10-17 18:00:00 | GC | Futures | 1918.1 | 1918.8 | 1912.6 | 1914.3 | 957.0 |
| 2010-10-17 19:00:00 | GC | Futures | 1914.3 | 1915.4 | 1911.1 | 1912.6 | 784.0 |
| 2010-10-17 20:00:00 | GC | Futures | 1912.6 | 1912.8 | 1897.4 | 1903.8 | 5904.0 |
| 2010-10-17 21:00:00 | GC | Futures | 1903.8 | 1905.3 | 1899.2 | 1902.1 | 3763.0 |
| 2010-10-17 22:00:00 | GC | Futures | 1902.1 | 1902.7 | 1898.5 | 1901.4 | 1894.0 |
| 2010-10-17 23:00:00 | GC | Futures | 1901.4 | 1902.6 | 1900.7 | 1901.6 | 769.0 |
| 2010-10-17 18:00:00 | ZN | Futures | 105.263666 | 105.354849 | 105.263666 | 105.354849 | 2993.0 |
| 2010-10-17 19:00:00 | ZN | Futures | 105.354849 | 105.393927 | 105.341822 | 105.393927 | 3926.0 |
| 2010-10-17 20:00:00 | ZN | Futures | 105.380901 | 105.419979 | 105.367875 | 105.393927 | 4737.0 |
| 2010-10-17 21:00:00 | ZN | Futures | 105.406953 | 105.406953 | 105.380901 | 105.393927 | 2477.0 |
| 2010-10-17 22:00:00 | ZN | Futures | 105.393927 | 105.433005 | 105.393927 | 105.406953 | 5460.0 |
| 2010-10-17 23:00:00 | ZN | Futures | 105.406953 | 105.419979 | 105.393927 | 105.406953 | 1565.0 |
> showing 36 of 266 rows — these rows as CSV