PREVIEW / futures_1hour / 2008-07-06
file: by_date/futures_1hour/2008/2008-07-06.parquet size: 13 KB rows: 223
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-06 18:00:00 | ES | Futures | 1169.98 | 1172.3 | 1169.51 | 1171.61 | 2618.0 |
| 2008-07-06 19:00:00 | ES | Futures | 1171.61 | 1171.84 | 1169.98 | 1170.21 | 2128.0 |
| 2008-07-06 20:00:00 | ES | Futures | 1170.21 | 1171.14 | 1169.05 | 1171.14 | 1900.0 |
| 2008-07-06 21:00:00 | ES | Futures | 1171.14 | 1171.37 | 1168.58 | 1170.44 | 2436.0 |
| 2008-07-06 22:00:00 | ES | Futures | 1170.44 | 1172.07 | 1169.98 | 1171.37 | 2348.0 |
| 2008-07-06 23:00:00 | ES | Futures | 1171.84 | 1174.16 | 1171.14 | 1173.7 | 3293.0 |
| 2008-07-06 18:00:00 | NQ | Futures | 2043.0 | 2046.94 | 2043.0 | 2043.84 | 920.0 |
| 2008-07-06 19:00:00 | NQ | Futures | 2043.84 | 2044.13 | 2042.44 | 2042.44 | 98.0 |
| 2008-07-06 20:00:00 | NQ | Futures | 2042.44 | 2044.69 | 2041.59 | 2044.41 | 160.0 |
| 2008-07-06 21:00:00 | NQ | Futures | 2044.97 | 2046.09 | 2042.72 | 2045.25 | 190.0 |
| 2008-07-06 22:00:00 | NQ | Futures | 2045.53 | 2047.5 | 2044.41 | 2047.22 | 225.0 |
| 2008-07-06 23:00:00 | NQ | Futures | 2047.5 | 2051.16 | 2046.66 | 2050.6 | 227.0 |
| 2008-07-06 18:00:00 | YM | Futures | 10216.7 | 10238.5 | 10216.7 | 10238.5 | 270.0 |
| 2008-07-06 19:00:00 | YM | Futures | 10235.7 | 10241.2 | 10220.3 | 10225.7 | 179.0 |
| 2008-07-06 20:00:00 | YM | Futures | 10223.0 | 10232.1 | 10214.8 | 10232.1 | 131.0 |
| 2008-07-06 21:00:00 | YM | Futures | 10233.0 | 10233.0 | 10211.2 | 10221.2 | 195.0 |
| 2008-07-06 22:00:00 | YM | Futures | 10225.7 | 10238.5 | 10221.2 | 10233.9 | 161.0 |
| 2008-07-06 23:00:00 | YM | Futures | 10236.6 | 10254.8 | 10233.9 | 10252.1 | 307.0 |
| 2008-07-06 18:00:00 | CL | Futures | 547.51 | 548.49 | 547.17 | 547.66 | 528.0 |
| 2008-07-06 19:00:00 | CL | Futures | 547.66 | 547.81 | 546.1 | 547.24 | 294.0 |
| 2008-07-06 20:00:00 | CL | Futures | 547.2 | 547.39 | 546.22 | 546.22 | 161.0 |
| 2008-07-06 21:00:00 | CL | Futures | 546.41 | 546.71 | 545.34 | 545.46 | 433.0 |
| 2008-07-06 22:00:00 | CL | Futures | 545.38 | 545.91 | 545.08 | 545.53 | 252.0 |
| 2008-07-06 23:00:00 | CL | Futures | 545.53 | 545.72 | 545.27 | 545.46 | 104.0 |
| 2008-07-06 18:00:00 | GC | Futures | 1347.7 | 1347.9 | 1345.2 | 1345.2 | 217.0 |
| 2008-07-06 19:00:00 | GC | Futures | 1345.5 | 1346.8 | 1344.6 | 1345.4 | 388.0 |
| 2008-07-06 20:00:00 | GC | Futures | 1345.4 | 1345.8 | 1342.3 | 1343.8 | 969.0 |
| 2008-07-06 21:00:00 | GC | Futures | 1343.8 | 1344.8 | 1340.0 | 1340.9 | 1558.0 |
| 2008-07-06 22:00:00 | GC | Futures | 1340.9 | 1341.0 | 1335.3 | 1337.6 | 2085.0 |
| 2008-07-06 23:00:00 | GC | Futures | 1337.6 | 1338.4 | 1337.0 | 1337.0 | 600.0 |
| 2008-07-06 18:00:00 | ZN | Futures | 85.815407 | 85.885613 | 85.815407 | 85.873912 | 2054.0 |
| 2008-07-06 19:00:00 | ZN | Futures | 85.873912 | 85.944118 | 85.85051 | 85.932417 | 2779.0 |
| 2008-07-06 20:00:00 | ZN | Futures | 85.944118 | 85.96752 | 85.838809 | 85.838809 | 3617.0 |
| 2008-07-06 21:00:00 | ZN | Futures | 85.85051 | 85.873912 | 85.827108 | 85.827108 | 4419.0 |
| 2008-07-06 22:00:00 | ZN | Futures | 85.827108 | 85.827108 | 85.768603 | 85.780304 | 2439.0 |
| 2008-07-06 23:00:00 | ZN | Futures | 85.780304 | 85.780304 | 85.686695 | 85.686695 | 3792.0 |
> showing 36 of 223 rows — these rows as CSV