PREVIEW / futures_1hour / 2010-11-14
file: by_date/futures_1hour/2010/2010-11-14.parquet size: 14 KB rows: 269
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-11-14 18:00:00 | ES | Futures | 1178.66 | 1180.88 | 1178.17 | 1180.39 | 12159.0 |
| 2010-11-14 19:00:00 | ES | Futures | 1180.14 | 1181.87 | 1179.65 | 1181.37 | 6183.0 |
| 2010-11-14 20:00:00 | ES | Futures | 1181.37 | 1183.35 | 1180.88 | 1182.36 | 9309.0 |
| 2010-11-14 21:00:00 | ES | Futures | 1182.11 | 1182.36 | 1180.14 | 1180.63 | 7160.0 |
| 2010-11-14 22:00:00 | ES | Futures | 1180.63 | 1181.13 | 1178.42 | 1178.91 | 7691.0 |
| 2010-11-14 23:00:00 | ES | Futures | 1178.66 | 1181.37 | 1178.42 | 1181.13 | 3988.0 |
| 2010-11-14 18:00:00 | NQ | Futures | 2449.0 | 2453.88 | 2447.85 | 2452.73 | 893.0 |
| 2010-11-14 19:00:00 | NQ | Futures | 2452.16 | 2456.46 | 2451.58 | 2455.02 | 814.0 |
| 2010-11-14 20:00:00 | NQ | Futures | 2455.02 | 2458.47 | 2454.16 | 2457.03 | 559.0 |
| 2010-11-14 21:00:00 | NQ | Futures | 2456.75 | 2457.03 | 2453.59 | 2454.16 | 1275.0 |
| 2010-11-14 22:00:00 | NQ | Futures | 2454.16 | 2454.45 | 2451.01 | 2451.87 | 1027.0 |
| 2010-11-14 23:00:00 | NQ | Futures | 2452.16 | 2455.89 | 2451.58 | 2455.89 | 281.0 |
| 2010-11-14 18:00:00 | YM | Futures | 10622.0 | 10639.2 | 10621.1 | 10633.5 | 316.0 |
| 2010-11-14 19:00:00 | YM | Futures | 10633.5 | 10648.7 | 10628.7 | 10644.0 | 289.0 |
| 2010-11-14 20:00:00 | YM | Futures | 10643.0 | 10658.2 | 10642.1 | 10648.7 | 363.0 |
| 2010-11-14 21:00:00 | YM | Futures | 10648.7 | 10650.6 | 10633.5 | 10639.2 | 406.0 |
| 2010-11-14 22:00:00 | YM | Futures | 10638.2 | 10640.1 | 10619.2 | 10624.9 | 377.0 |
| 2010-11-14 23:00:00 | YM | Futures | 10624.9 | 10640.1 | 10616.3 | 10639.2 | 466.0 |
| 2010-11-14 18:00:00 | CL | Futures | 159.04 | 159.66 | 159.02 | 159.38 | 612.0 |
| 2010-11-14 19:00:00 | CL | Futures | 159.36 | 160.2 | 159.36 | 160.01 | 327.0 |
| 2010-11-14 20:00:00 | CL | Futures | 160.01 | 160.27 | 159.97 | 160.27 | 409.0 |
| 2010-11-14 21:00:00 | CL | Futures | 160.29 | 160.33 | 159.82 | 160.23 | 382.0 |
| 2010-11-14 22:00:00 | CL | Futures | 160.23 | 160.23 | 159.32 | 159.39 | 373.0 |
| 2010-11-14 23:00:00 | CL | Futures | 159.39 | 159.66 | 159.28 | 159.62 | 291.0 |
| 2010-11-14 18:00:00 | GC | Futures | 1918.1 | 1918.1 | 1914.0 | 1916.5 | 2202.0 |
| 2010-11-14 19:00:00 | GC | Futures | 1916.4 | 1924.4 | 1916.3 | 1920.3 | 4363.0 |
| 2010-11-14 20:00:00 | GC | Futures | 1920.7 | 1924.0 | 1918.9 | 1921.9 | 3166.0 |
| 2010-11-14 21:00:00 | GC | Futures | 1921.9 | 1922.1 | 1916.3 | 1917.5 | 2191.0 |
| 2010-11-14 22:00:00 | GC | Futures | 1917.4 | 1917.5 | 1911.4 | 1914.3 | 2976.0 |
| 2010-11-14 23:00:00 | GC | Futures | 1914.6 | 1915.3 | 1911.6 | 1914.9 | 1657.0 |
| 2010-11-14 18:00:00 | ZN | Futures | 104.95104 | 104.977092 | 104.911962 | 104.938014 | 4973.0 |
| 2010-11-14 19:00:00 | ZN | Futures | 104.938014 | 104.990119 | 104.938014 | 104.95104 | 4205.0 |
| 2010-11-14 20:00:00 | ZN | Futures | 104.95104 | 104.964066 | 104.781701 | 104.82078 | 12607.0 |
| 2010-11-14 21:00:00 | ZN | Futures | 104.82078 | 104.833806 | 104.755649 | 104.768675 | 5900.0 |
| 2010-11-14 22:00:00 | ZN | Futures | 104.768675 | 104.768675 | 104.52118 | 104.625389 | 25346.0 |
| 2010-11-14 23:00:00 | ZN | Futures | 104.625389 | 104.638415 | 104.534206 | 104.612363 | 8813.0 |
> showing 36 of 269 rows — these rows as CSV