PREVIEW / futures_1hour / 2009-04-05
file: by_date/futures_1hour/2009/2009-04-05.parquet size: 13 KB rows: 227
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-04-05 18:00:00 | ES | Futures | 805.17 | 812.84 | 803.73 | 810.44 | 11901.0 |
| 2009-04-05 19:00:00 | ES | Futures | 810.44 | 810.44 | 807.57 | 809.24 | 4698.0 |
| 2009-04-05 20:00:00 | ES | Futures | 809.24 | 810.2 | 807.09 | 808.05 | 4105.0 |
| 2009-04-05 21:00:00 | ES | Futures | 808.05 | 810.44 | 807.81 | 809.72 | 5661.0 |
| 2009-04-05 22:00:00 | ES | Futures | 809.48 | 812.6 | 809.0 | 812.12 | 6375.0 |
| 2009-04-05 23:00:00 | ES | Futures | 812.12 | 812.84 | 811.16 | 811.4 | 3235.0 |
| 2009-04-05 18:00:00 | NQ | Futures | 1495.14 | 1507.93 | 1492.87 | 1504.52 | 911.0 |
| 2009-04-05 19:00:00 | NQ | Futures | 1504.52 | 1504.52 | 1498.55 | 1501.39 | 170.0 |
| 2009-04-05 20:00:00 | NQ | Futures | 1502.53 | 1504.24 | 1498.27 | 1501.11 | 286.0 |
| 2009-04-05 21:00:00 | NQ | Futures | 1500.26 | 1503.67 | 1499.69 | 1501.96 | 159.0 |
| 2009-04-05 22:00:00 | NQ | Futures | 1502.25 | 1508.21 | 1501.96 | 1507.36 | 185.0 |
| 2009-04-05 23:00:00 | NQ | Futures | 1507.08 | 1508.78 | 1505.94 | 1506.79 | 267.0 |
| 2009-04-05 18:00:00 | YM | Futures | 7332.3 | 7406.7 | 7316.7 | 7375.5 | 746.0 |
| 2009-04-05 19:00:00 | YM | Futures | 7375.5 | 7375.5 | 7353.4 | 7365.4 | 184.0 |
| 2009-04-05 20:00:00 | YM | Futures | 7365.4 | 7376.4 | 7352.5 | 7358.9 | 452.0 |
| 2009-04-05 21:00:00 | YM | Futures | 7358.0 | 7376.4 | 7357.1 | 7370.9 | 343.0 |
| 2009-04-05 22:00:00 | YM | Futures | 7370.9 | 7392.9 | 7366.3 | 7392.0 | 414.0 |
| 2009-04-05 23:00:00 | YM | Futures | 7390.2 | 7395.7 | 7387.4 | 7387.4 | 505.0 |
| 2009-04-05 18:00:00 | CL | Futures | 133.68 | 135.95 | 133.17 | 135.8 | 883.0 |
| 2009-04-05 19:00:00 | CL | Futures | 135.72 | 135.77 | 135.01 | 135.24 | 209.0 |
| 2009-04-05 20:00:00 | CL | Futures | 135.24 | 135.67 | 135.06 | 135.21 | 392.0 |
| 2009-04-05 21:00:00 | CL | Futures | 135.21 | 136.11 | 135.21 | 135.44 | 399.0 |
| 2009-04-05 22:00:00 | CL | Futures | 135.42 | 136.16 | 135.39 | 136.06 | 253.0 |
| 2009-04-05 23:00:00 | CL | Futures | 136.06 | 136.59 | 136.06 | 136.34 | 584.0 |
| 2009-04-05 18:00:00 | GC | Futures | 1274.4 | 1276.5 | 1268.1 | 1268.1 | 1100.0 |
| 2009-04-05 19:00:00 | GC | Futures | 1268.1 | 1270.0 | 1265.3 | 1268.3 | 850.0 |
| 2009-04-05 20:00:00 | GC | Futures | 1268.8 | 1271.4 | 1259.2 | 1261.3 | 2957.0 |
| 2009-04-05 21:00:00 | GC | Futures | 1261.5 | 1261.9 | 1256.4 | 1257.1 | 2835.0 |
| 2009-04-05 22:00:00 | GC | Futures | 1256.9 | 1258.5 | 1246.1 | 1249.7 | 4331.0 |
| 2009-04-05 23:00:00 | GC | Futures | 1249.8 | 1250.0 | 1241.9 | 1246.0 | 3057.0 |
| 2009-04-05 18:00:00 | ZN | Futures | 95.443417 | 95.443417 | 95.284691 | 95.30911 | 1119.0 |
| 2009-04-05 19:00:00 | ZN | Futures | 95.30911 | 95.431207 | 95.284691 | 95.406788 | 1476.0 |
| 2009-04-05 20:00:00 | ZN | Futures | 95.406788 | 95.492256 | 95.394578 | 95.467836 | 2634.0 |
| 2009-04-05 21:00:00 | ZN | Futures | 95.455627 | 95.492256 | 95.394578 | 95.406788 | 2884.0 |
| 2009-04-05 22:00:00 | ZN | Futures | 95.406788 | 95.431207 | 95.32132 | 95.333529 | 2640.0 |
| 2009-04-05 23:00:00 | ZN | Futures | 95.32132 | 95.357949 | 95.2969 | 95.30911 | 1232.0 |
> showing 36 of 227 rows — these rows as CSV