PREVIEW / futures_1hour / 2009-02-08
file: by_date/futures_1hour/2009/2009-02-08.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 |
|---|---|---|---|---|---|---|---|
| 2009-02-08 18:00:00 | ES | Futures | 823.51 | 823.74 | 815.92 | 816.63 | 10418.0 |
| 2009-02-08 19:00:00 | ES | Futures | 816.63 | 817.82 | 816.39 | 816.87 | 4023.0 |
| 2009-02-08 20:00:00 | ES | Futures | 816.87 | 817.1 | 814.49 | 814.73 | 4504.0 |
| 2009-02-08 21:00:00 | ES | Futures | 814.49 | 815.44 | 814.02 | 814.49 | 2331.0 |
| 2009-02-08 22:00:00 | ES | Futures | 814.26 | 815.21 | 812.6 | 813.07 | 4659.0 |
| 2009-02-08 23:00:00 | ES | Futures | 812.83 | 813.31 | 811.17 | 812.6 | 3168.0 |
| 2009-02-08 18:00:00 | NQ | Futures | 1437.88 | 1440.71 | 1429.98 | 1430.26 | 1315.0 |
| 2009-02-08 19:00:00 | NQ | Futures | 1429.98 | 1431.39 | 1429.98 | 1430.54 | 209.0 |
| 2009-02-08 20:00:00 | NQ | Futures | 1430.26 | 1430.26 | 1426.02 | 1427.72 | 281.0 |
| 2009-02-08 21:00:00 | NQ | Futures | 1427.43 | 1428.28 | 1425.46 | 1426.59 | 152.0 |
| 2009-02-08 22:00:00 | NQ | Futures | 1426.02 | 1428.28 | 1423.76 | 1424.61 | 333.0 |
| 2009-02-08 23:00:00 | NQ | Futures | 1424.05 | 1425.74 | 1423.48 | 1424.89 | 139.0 |
| 2009-02-08 18:00:00 | YM | Futures | 7540.8 | 7540.8 | 7464.2 | 7467.9 | 619.0 |
| 2009-02-08 19:00:00 | YM | Futures | 7469.7 | 7478.8 | 7467.0 | 7472.4 | 208.0 |
| 2009-02-08 20:00:00 | YM | Futures | 7473.4 | 7474.3 | 7454.2 | 7455.1 | 399.0 |
| 2009-02-08 21:00:00 | YM | Futures | 7454.2 | 7460.6 | 7449.7 | 7454.2 | 186.0 |
| 2009-02-08 22:00:00 | YM | Futures | 7454.2 | 7457.0 | 7437.8 | 7442.4 | 301.0 |
| 2009-02-08 23:00:00 | YM | Futures | 7439.6 | 7444.2 | 7429.6 | 7436.0 | 275.0 |
| 2009-02-08 18:00:00 | CL | Futures | 119.52 | 120.35 | 119.37 | 120.29 | 499.0 |
| 2009-02-08 19:00:00 | CL | Futures | 120.35 | 120.41 | 120.14 | 120.38 | 326.0 |
| 2009-02-08 20:00:00 | CL | Futures | 120.41 | 120.92 | 120.32 | 120.38 | 661.0 |
| 2009-02-08 21:00:00 | CL | Futures | 120.38 | 120.44 | 119.75 | 120.23 | 359.0 |
| 2009-02-08 22:00:00 | CL | Futures | 120.23 | 120.71 | 120.23 | 120.62 | 212.0 |
| 2009-02-08 23:00:00 | CL | Futures | 120.5 | 121.01 | 120.38 | 120.5 | 347.0 |
| 2009-02-08 18:00:00 | GC | Futures | 1299.4 | 1299.4 | 1289.5 | 1292.3 | 1058.0 |
| 2009-02-08 19:00:00 | GC | Futures | 1292.3 | 1292.9 | 1289.5 | 1290.2 | 829.0 |
| 2009-02-08 20:00:00 | GC | Futures | 1290.0 | 1291.6 | 1286.2 | 1291.2 | 1506.0 |
| 2009-02-08 21:00:00 | GC | Futures | 1291.2 | 1291.3 | 1289.0 | 1289.2 | 412.0 |
| 2009-02-08 22:00:00 | GC | Futures | 1288.9 | 1291.3 | 1288.9 | 1290.3 | 190.0 |
| 2009-02-08 23:00:00 | GC | Futures | 1290.0 | 1291.6 | 1289.2 | 1290.9 | 475.0 |
| 2009-02-08 18:00:00 | ZN | Futures | 93.991131 | 94.075525 | 93.991131 | 94.063469 | 2046.0 |
| 2009-02-08 19:00:00 | ZN | Futures | 94.051412 | 94.051412 | 93.954962 | 93.991131 | 1762.0 |
| 2009-02-08 20:00:00 | ZN | Futures | 93.991131 | 94.039356 | 93.979074 | 94.0273 | 2450.0 |
| 2009-02-08 21:00:00 | ZN | Futures | 94.0273 | 94.039356 | 94.015243 | 94.0273 | 672.0 |
| 2009-02-08 22:00:00 | ZN | Futures | 94.0273 | 94.051412 | 94.015243 | 94.039356 | 2791.0 |
| 2009-02-08 23:00:00 | ZN | Futures | 94.039356 | 94.063469 | 94.015243 | 94.0273 | 2184.0 |
> showing 36 of 223 rows — these rows as CSV