PREVIEW / futures_1hour / 2008-03-02
file: by_date/futures_1hour/2008/2008-03-02.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-03-02 18:00:00 | ES | Futures | 1239.92 | 1240.39 | 1236.19 | 1238.76 | 11261.0 |
| 2008-03-02 19:00:00 | ES | Futures | 1238.99 | 1238.99 | 1233.86 | 1234.1 | 12305.0 |
| 2008-03-02 20:00:00 | ES | Futures | 1234.33 | 1235.03 | 1231.3 | 1231.53 | 9159.0 |
| 2008-03-02 21:00:00 | ES | Futures | 1231.53 | 1234.8 | 1231.06 | 1234.1 | 5966.0 |
| 2008-03-02 22:00:00 | ES | Futures | 1234.1 | 1236.19 | 1233.4 | 1235.73 | 5878.0 |
| 2008-03-02 23:00:00 | ES | Futures | 1235.73 | 1236.66 | 1234.33 | 1236.43 | 1453.0 |
| 2008-03-02 18:00:00 | NQ | Futures | 1984.63 | 1986.34 | 1978.11 | 1982.93 | 538.0 |
| 2008-03-02 19:00:00 | NQ | Futures | 1982.36 | 1982.36 | 1974.42 | 1976.12 | 1254.0 |
| 2008-03-02 20:00:00 | NQ | Futures | 1975.55 | 1977.54 | 1973.85 | 1974.13 | 659.0 |
| 2008-03-02 21:00:00 | NQ | Futures | 1973.57 | 1977.25 | 1973.57 | 1976.69 | 395.0 |
| 2008-03-02 22:00:00 | NQ | Futures | 1976.69 | 1977.82 | 1974.13 | 1977.82 | 513.0 |
| 2008-03-02 23:00:00 | NQ | Futures | 1976.97 | 1979.24 | 1974.98 | 1978.39 | 206.0 |
| 2008-03-02 18:00:00 | YM | Futures | 11155.4 | 11155.4 | 11111.8 | 11131.8 | 631.0 |
| 2008-03-02 19:00:00 | YM | Futures | 11125.5 | 11125.5 | 11093.7 | 11100.0 | 391.0 |
| 2008-03-02 20:00:00 | YM | Futures | 11097.3 | 11104.6 | 11071.9 | 11074.6 | 825.0 |
| 2008-03-02 21:00:00 | YM | Futures | 11073.7 | 11092.8 | 11071.9 | 11092.8 | 311.0 |
| 2008-03-02 22:00:00 | YM | Futures | 11090.9 | 11101.8 | 11081.0 | 11101.8 | 315.0 |
| 2008-03-02 23:00:00 | YM | Futures | 11101.8 | 11104.6 | 11086.4 | 11102.8 | 163.0 |
| 2008-03-02 18:00:00 | CL | Futures | 379.48 | 380.64 | 378.81 | 380.41 | 631.0 |
| 2008-03-02 19:00:00 | CL | Futures | 380.38 | 380.82 | 379.78 | 379.96 | 395.0 |
| 2008-03-02 20:00:00 | CL | Futures | 379.78 | 380.26 | 379.63 | 380.04 | 295.0 |
| 2008-03-02 21:00:00 | CL | Futures | 379.96 | 380.23 | 379.48 | 379.7 | 356.0 |
| 2008-03-02 22:00:00 | CL | Futures | 379.74 | 380.26 | 379.59 | 380.08 | 253.0 |
| 2008-03-02 23:00:00 | CL | Futures | 380.0 | 380.64 | 379.96 | 380.52 | 154.0 |
| 2008-03-02 18:00:00 | GC | Futures | 1420.2 | 1426.6 | 1420.1 | 1425.2 | 1853.0 |
| 2008-03-02 19:00:00 | GC | Futures | 1424.2 | 1430.0 | 1423.1 | 1428.7 | 1777.0 |
| 2008-03-02 20:00:00 | GC | Futures | 1428.4 | 1431.4 | 1427.1 | 1430.8 | 2327.0 |
| 2008-03-02 21:00:00 | GC | Futures | 1430.7 | 1431.6 | 1429.5 | 1429.8 | 1199.0 |
| 2008-03-02 22:00:00 | GC | Futures | 1429.7 | 1430.8 | 1429.1 | 1430.8 | 435.0 |
| 2008-03-02 23:00:00 | GC | Futures | 1430.6 | 1436.2 | 1430.3 | 1435.4 | 2273.0 |
| 2008-03-02 18:00:00 | ZN | Futures | 86.638723 | 86.638723 | 86.547584 | 86.547584 | 1404.0 |
| 2008-03-02 19:00:00 | ZN | Futures | 86.547584 | 86.604545 | 86.547584 | 86.604545 | 1240.0 |
| 2008-03-02 20:00:00 | ZN | Futures | 86.615938 | 86.62733 | 86.581761 | 86.62733 | 1104.0 |
| 2008-03-02 21:00:00 | ZN | Futures | 86.638723 | 86.638723 | 86.604545 | 86.615938 | 634.0 |
| 2008-03-02 22:00:00 | ZN | Futures | 86.604545 | 86.604545 | 86.558976 | 86.558976 | 790.0 |
| 2008-03-02 23:00:00 | ZN | Futures | 86.558976 | 86.581761 | 86.536191 | 86.547584 | 1054.0 |
> showing 36 of 237 rows — these rows as CSV