PREVIEW / futures_1hour / 2010-11-07
file: by_date/futures_1hour/2010/2010-11-07.parquet size: 14 KB rows: 278
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-07 18:00:00 | ES | Futures | 1203.31 | 1204.54 | 1202.32 | 1204.3 | 10293.0 |
| 2010-11-07 19:00:00 | ES | Futures | 1204.05 | 1205.04 | 1203.56 | 1204.3 | 6487.0 |
| 2010-11-07 20:00:00 | ES | Futures | 1204.3 | 1204.54 | 1200.35 | 1201.09 | 9433.0 |
| 2010-11-07 21:00:00 | ES | Futures | 1201.34 | 1201.83 | 1199.61 | 1201.83 | 10406.0 |
| 2010-11-07 22:00:00 | ES | Futures | 1201.58 | 1202.32 | 1200.6 | 1200.85 | 8090.0 |
| 2010-11-07 23:00:00 | ES | Futures | 1200.85 | 1201.83 | 1200.11 | 1200.85 | 3258.0 |
| 2010-11-07 18:00:00 | NQ | Futures | 2502.36 | 2505.81 | 2499.49 | 2505.52 | 1038.0 |
| 2010-11-07 19:00:00 | NQ | Futures | 2505.52 | 2506.38 | 2503.51 | 2505.52 | 270.0 |
| 2010-11-07 20:00:00 | NQ | Futures | 2505.52 | 2505.52 | 2498.63 | 2500.07 | 487.0 |
| 2010-11-07 21:00:00 | NQ | Futures | 2500.07 | 2500.93 | 2496.34 | 2500.93 | 807.0 |
| 2010-11-07 22:00:00 | NQ | Futures | 2500.64 | 2503.8 | 2498.92 | 2499.21 | 540.0 |
| 2010-11-07 23:00:00 | NQ | Futures | 2498.92 | 2500.36 | 2498.63 | 2499.21 | 129.0 |
| 2010-11-07 18:00:00 | YM | Futures | 10830.7 | 10839.2 | 10821.1 | 10838.3 | 419.0 |
| 2010-11-07 19:00:00 | YM | Futures | 10839.2 | 10845.9 | 10832.6 | 10840.2 | 223.0 |
| 2010-11-07 20:00:00 | YM | Futures | 10838.3 | 10838.3 | 10809.7 | 10813.5 | 304.0 |
| 2010-11-07 21:00:00 | YM | Futures | 10813.5 | 10818.3 | 10802.1 | 10818.3 | 426.0 |
| 2010-11-07 22:00:00 | YM | Futures | 10818.3 | 10824.9 | 10809.7 | 10811.6 | 395.0 |
| 2010-11-07 23:00:00 | YM | Futures | 10811.6 | 10820.2 | 10804.9 | 10813.5 | 292.0 |
| 2010-11-07 18:00:00 | CL | Futures | 164.03 | 164.16 | 163.49 | 164.13 | 1806.0 |
| 2010-11-07 19:00:00 | CL | Futures | 164.13 | 164.22 | 163.77 | 163.79 | 984.0 |
| 2010-11-07 20:00:00 | CL | Futures | 163.79 | 163.96 | 163.51 | 163.6 | 1156.0 |
| 2010-11-07 21:00:00 | CL | Futures | 163.6 | 163.68 | 162.92 | 163.17 | 2354.0 |
| 2010-11-07 22:00:00 | CL | Futures | 163.21 | 163.49 | 163.04 | 163.13 | 607.0 |
| 2010-11-07 23:00:00 | CL | Futures | 163.13 | 163.3 | 163.04 | 163.13 | 451.0 |
| 2010-11-07 18:00:00 | GC | Futures | 1954.5 | 1954.9 | 1949.1 | 1952.4 | 1956.0 |
| 2010-11-07 19:00:00 | GC | Futures | 1952.2 | 1956.6 | 1951.0 | 1951.7 | 2755.0 |
| 2010-11-07 20:00:00 | GC | Futures | 1951.7 | 1951.8 | 1945.4 | 1948.7 | 3142.0 |
| 2010-11-07 21:00:00 | GC | Futures | 1948.6 | 1949.6 | 1942.6 | 1945.5 | 3223.0 |
| 2010-11-07 22:00:00 | GC | Futures | 1945.6 | 1946.8 | 1942.7 | 1944.8 | 1167.0 |
| 2010-11-07 23:00:00 | GC | Futures | 1944.8 | 1945.8 | 1941.6 | 1944.0 | 2050.0 |
| 2010-11-07 18:00:00 | ZN | Futures | 106.279699 | 106.34483 | 106.240621 | 106.331804 | 2290.0 |
| 2010-11-07 19:00:00 | ZN | Futures | 106.331804 | 106.383908 | 106.331804 | 106.357856 | 4541.0 |
| 2010-11-07 20:00:00 | ZN | Futures | 106.34483 | 106.40996 | 106.34483 | 106.396934 | 4493.0 |
| 2010-11-07 21:00:00 | ZN | Futures | 106.396934 | 106.422986 | 106.357856 | 106.383908 | 3549.0 |
| 2010-11-07 22:00:00 | ZN | Futures | 106.370882 | 106.396934 | 106.370882 | 106.370882 | 891.0 |
| 2010-11-07 23:00:00 | ZN | Futures | 106.383908 | 106.40996 | 106.383908 | 106.396934 | 1606.0 |
> showing 36 of 278 rows — these rows as CSV