PREVIEW / futures_1hour / 2010-08-01
file: by_date/futures_1hour/2010/2010-08-01.parquet size: 13 KB rows: 248
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-08-01 18:00:00 | ES | Futures | 1084.09 | 1084.33 | 1081.39 | 1082.61 | 5798.0 |
| 2010-08-01 19:00:00 | ES | Futures | 1082.61 | 1083.84 | 1081.88 | 1083.35 | 2668.0 |
| 2010-08-01 20:00:00 | ES | Futures | 1083.35 | 1086.54 | 1083.11 | 1086.3 | 8149.0 |
| 2010-08-01 21:00:00 | ES | Futures | 1086.3 | 1086.3 | 1084.58 | 1085.31 | 5302.0 |
| 2010-08-01 22:00:00 | ES | Futures | 1085.31 | 1086.05 | 1083.84 | 1084.82 | 3714.0 |
| 2010-08-01 23:00:00 | ES | Futures | 1084.58 | 1087.03 | 1084.33 | 1086.3 | 5635.0 |
| 2010-08-01 18:00:00 | NQ | Futures | 2142.08 | 2149.25 | 2137.21 | 2141.22 | 796.0 |
| 2010-08-01 19:00:00 | NQ | Futures | 2141.51 | 2143.51 | 2140.36 | 2142.94 | 233.0 |
| 2010-08-01 20:00:00 | NQ | Futures | 2142.94 | 2148.39 | 2142.08 | 2148.39 | 720.0 |
| 2010-08-01 21:00:00 | NQ | Futures | 2148.39 | 2148.39 | 2145.23 | 2146.95 | 303.0 |
| 2010-08-01 22:00:00 | NQ | Futures | 2146.67 | 2147.81 | 2143.51 | 2145.81 | 308.0 |
| 2010-08-01 23:00:00 | NQ | Futures | 2146.09 | 2151.25 | 2145.23 | 2149.82 | 869.0 |
| 2010-08-01 18:00:00 | YM | Futures | 9900.6 | 9911.9 | 9890.1 | 9897.7 | 330.0 |
| 2010-08-01 19:00:00 | YM | Futures | 9899.6 | 9906.2 | 9890.1 | 9903.4 | 360.0 |
| 2010-08-01 20:00:00 | YM | Futures | 9903.4 | 9928.0 | 9901.5 | 9926.1 | 499.0 |
| 2010-08-01 21:00:00 | YM | Futures | 9926.1 | 9927.1 | 9913.8 | 9920.4 | 370.0 |
| 2010-08-01 22:00:00 | YM | Futures | 9921.4 | 9923.3 | 9906.2 | 9915.7 | 273.0 |
| 2010-08-01 23:00:00 | YM | Futures | 9914.8 | 9930.8 | 9911.9 | 9925.2 | 408.0 |
| 2010-08-01 18:00:00 | CL | Futures | 151.53 | 151.91 | 151.3 | 151.35 | 677.0 |
| 2010-08-01 19:00:00 | CL | Futures | 151.33 | 151.62 | 151.3 | 151.62 | 171.0 |
| 2010-08-01 20:00:00 | CL | Futures | 151.64 | 152.14 | 151.56 | 152.04 | 953.0 |
| 2010-08-01 21:00:00 | CL | Futures | 152.02 | 152.29 | 151.87 | 152.2 | 889.0 |
| 2010-08-01 22:00:00 | CL | Futures | 152.18 | 152.29 | 151.66 | 151.99 | 816.0 |
| 2010-08-01 23:00:00 | CL | Futures | 151.93 | 152.27 | 151.83 | 151.89 | 545.0 |
| 2010-08-01 18:00:00 | GC | Futures | 1656.2 | 1657.6 | 1654.4 | 1655.5 | 662.0 |
| 2010-08-01 19:00:00 | GC | Futures | 1655.5 | 1656.5 | 1655.5 | 1655.8 | 263.0 |
| 2010-08-01 20:00:00 | GC | Futures | 1655.6 | 1658.8 | 1653.2 | 1657.6 | 958.0 |
| 2010-08-01 21:00:00 | GC | Futures | 1657.6 | 1657.9 | 1655.5 | 1656.7 | 1231.0 |
| 2010-08-01 22:00:00 | GC | Futures | 1656.7 | 1659.8 | 1656.5 | 1658.3 | 1300.0 |
| 2010-08-01 23:00:00 | GC | Futures | 1658.3 | 1659.3 | 1657.2 | 1657.7 | 515.0 |
| 2010-08-01 18:00:00 | ZN | Futures | 102.424675 | 102.437606 | 102.372952 | 102.385883 | 2127.0 |
| 2010-08-01 19:00:00 | ZN | Futures | 102.385883 | 102.398813 | 102.321229 | 102.33416 | 3355.0 |
| 2010-08-01 20:00:00 | ZN | Futures | 102.33416 | 102.372952 | 102.269506 | 102.308298 | 8340.0 |
| 2010-08-01 21:00:00 | ZN | Futures | 102.295367 | 102.360021 | 102.295367 | 102.33416 | 4202.0 |
| 2010-08-01 22:00:00 | ZN | Futures | 102.34709 | 102.34709 | 102.321229 | 102.321229 | 1877.0 |
| 2010-08-01 23:00:00 | ZN | Futures | 102.33416 | 102.360021 | 102.321229 | 102.33416 | 1900.0 |
> showing 36 of 248 rows — these rows as CSV