PREVIEW / futures_1hour / 2008-07-13
file: by_date/futures_1hour/2008/2008-07-13.parquet size: 13 KB rows: 237
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-13 18:00:00 | ES | Futures | 1152.78 | 1165.33 | 1152.78 | 1163.24 | 22113.0 |
| 2008-07-13 19:00:00 | ES | Futures | 1163.24 | 1163.47 | 1160.68 | 1162.08 | 6945.0 |
| 2008-07-13 20:00:00 | ES | Futures | 1162.08 | 1164.87 | 1161.15 | 1163.01 | 5241.0 |
| 2008-07-13 21:00:00 | ES | Futures | 1163.01 | 1166.96 | 1163.01 | 1166.03 | 5405.0 |
| 2008-07-13 22:00:00 | ES | Futures | 1166.26 | 1166.73 | 1163.94 | 1163.94 | 3990.0 |
| 2008-07-13 23:00:00 | ES | Futures | 1164.17 | 1164.63 | 1162.54 | 1163.24 | 3300.0 |
| 2008-07-13 18:00:00 | NQ | Futures | 2045.25 | 2070.57 | 2045.25 | 2066.91 | 1376.0 |
| 2008-07-13 19:00:00 | NQ | Futures | 2067.19 | 2067.19 | 2064.1 | 2064.94 | 774.0 |
| 2008-07-13 20:00:00 | NQ | Futures | 2065.5 | 2070.85 | 2065.22 | 2066.07 | 410.0 |
| 2008-07-13 21:00:00 | NQ | Futures | 2067.75 | 2074.5 | 2067.19 | 2073.94 | 393.0 |
| 2008-07-13 22:00:00 | NQ | Futures | 2073.66 | 2075.35 | 2068.6 | 2069.16 | 404.0 |
| 2008-07-13 23:00:00 | NQ | Futures | 2068.88 | 2068.88 | 2065.5 | 2066.35 | 268.0 |
| 2008-07-13 18:00:00 | YM | Futures | 10079.4 | 10170.3 | 10034.0 | 10154.9 | 1094.0 |
| 2008-07-13 19:00:00 | YM | Futures | 10154.9 | 10156.7 | 10144.9 | 10150.3 | 367.0 |
| 2008-07-13 20:00:00 | YM | Futures | 10153.0 | 10169.4 | 10147.6 | 10158.5 | 400.0 |
| 2008-07-13 21:00:00 | YM | Futures | 10163.9 | 10185.8 | 10159.4 | 10176.7 | 585.0 |
| 2008-07-13 22:00:00 | YM | Futures | 10178.5 | 10180.3 | 10164.8 | 10164.8 | 263.0 |
| 2008-07-13 23:00:00 | YM | Futures | 10164.8 | 10169.4 | 10153.9 | 10156.7 | 173.0 |
| 2008-07-13 18:00:00 | CL | Futures | 549.1 | 550.47 | 546.75 | 547.09 | 990.0 |
| 2008-07-13 19:00:00 | CL | Futures | 547.05 | 547.05 | 540.75 | 544.05 | 1590.0 |
| 2008-07-13 20:00:00 | CL | Futures | 544.4 | 545.31 | 543.83 | 544.17 | 402.0 |
| 2008-07-13 21:00:00 | CL | Futures | 544.21 | 545.42 | 544.13 | 545.42 | 566.0 |
| 2008-07-13 22:00:00 | CL | Futures | 545.46 | 546.45 | 545.34 | 546.41 | 533.0 |
| 2008-07-13 23:00:00 | CL | Futures | 546.45 | 550.85 | 546.29 | 550.51 | 1112.0 |
| 2008-07-13 18:00:00 | GC | Futures | 1393.6 | 1395.4 | 1387.6 | 1391.1 | 2147.0 |
| 2008-07-13 19:00:00 | GC | Futures | 1391.1 | 1394.2 | 1389.2 | 1394.2 | 1914.0 |
| 2008-07-13 20:00:00 | GC | Futures | 1394.1 | 1394.4 | 1391.6 | 1393.1 | 2387.0 |
| 2008-07-13 21:00:00 | GC | Futures | 1392.9 | 1393.5 | 1392.5 | 1392.5 | 2057.0 |
| 2008-07-13 22:00:00 | GC | Futures | 1392.6 | 1393.5 | 1391.1 | 1391.9 | 887.0 |
| 2008-07-13 23:00:00 | GC | Futures | 1391.8 | 1393.1 | 1388.2 | 1391.5 | 1271.0 |
| 2008-07-13 18:00:00 | ZN | Futures | 85.487778 | 85.51118 | 85.206953 | 85.253757 | 13328.0 |
| 2008-07-13 19:00:00 | ZN | Futures | 85.253757 | 85.382469 | 85.253757 | 85.312262 | 10377.0 |
| 2008-07-13 20:00:00 | ZN | Futures | 85.300561 | 85.323963 | 85.230355 | 85.277159 | 11350.0 |
| 2008-07-13 21:00:00 | ZN | Futures | 85.277159 | 85.382469 | 85.253757 | 85.312262 | 5987.0 |
| 2008-07-13 22:00:00 | ZN | Futures | 85.312262 | 85.323963 | 85.277159 | 85.312262 | 3781.0 |
| 2008-07-13 23:00:00 | ZN | Futures | 85.323963 | 85.370767 | 85.312262 | 85.347365 | 2686.0 |
> showing 36 of 237 rows — these rows as CSV