PREVIEW / futures_1hour / 2008-12-28
file: by_date/futures_1hour/2008/2008-12-28.parquet size: 13 KB rows: 226
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-12-28 18:00:00 | ES | Futures | 824.46 | 824.93 | 821.61 | 822.08 | 2303.0 |
| 2008-12-28 19:00:00 | ES | Futures | 822.08 | 822.8 | 820.9 | 821.61 | 2083.0 |
| 2008-12-28 20:00:00 | ES | Futures | 821.37 | 821.85 | 819.24 | 819.71 | 1435.0 |
| 2008-12-28 21:00:00 | ES | Futures | 819.95 | 819.95 | 816.39 | 817.82 | 2409.0 |
| 2008-12-28 22:00:00 | ES | Futures | 817.82 | 819.24 | 816.87 | 818.76 | 761.0 |
| 2008-12-28 23:00:00 | ES | Futures | 818.76 | 819.95 | 818.05 | 818.53 | 642.0 |
| 2008-12-28 18:00:00 | NQ | Futures | 1341.87 | 1342.44 | 1336.23 | 1336.23 | 128.0 |
| 2008-12-28 19:00:00 | NQ | Futures | 1336.51 | 1338.48 | 1335.1 | 1336.51 | 97.0 |
| 2008-12-28 20:00:00 | NQ | Futures | 1336.23 | 1337.35 | 1333.68 | 1333.68 | 20.0 |
| 2008-12-28 21:00:00 | NQ | Futures | 1333.4 | 1333.97 | 1328.6 | 1329.73 | 179.0 |
| 2008-12-28 22:00:00 | NQ | Futures | 1329.45 | 1332.84 | 1328.6 | 1332.27 | 29.0 |
| 2008-12-28 23:00:00 | NQ | Futures | 1331.71 | 1333.4 | 1331.14 | 1333.12 | 15.0 |
| 2008-12-28 18:00:00 | YM | Futures | 7712.1 | 7720.3 | 7679.3 | 7689.3 | 169.0 |
| 2008-12-28 19:00:00 | YM | Futures | 7688.4 | 7696.6 | 7686.6 | 7688.4 | 208.0 |
| 2008-12-28 20:00:00 | YM | Futures | 7686.6 | 7695.7 | 7677.5 | 7680.2 | 189.0 |
| 2008-12-28 21:00:00 | YM | Futures | 7681.1 | 7681.1 | 7652.0 | 7662.0 | 249.0 |
| 2008-12-28 22:00:00 | YM | Futures | 7662.9 | 7672.9 | 7655.6 | 7669.3 | 111.0 |
| 2008-12-28 23:00:00 | YM | Futures | 7671.1 | 7677.5 | 7664.7 | 7671.1 | 85.0 |
| 2008-12-28 18:00:00 | CL | Futures | 134.03 | 136.75 | 134.03 | 135.11 | 919.0 |
| 2008-12-28 19:00:00 | CL | Futures | 135.29 | 138.99 | 135.25 | 138.64 | 1043.0 |
| 2008-12-28 20:00:00 | CL | Futures | 138.5 | 138.85 | 136.47 | 136.68 | 540.0 |
| 2008-12-28 21:00:00 | CL | Futures | 136.68 | 137.73 | 136.47 | 137.63 | 292.0 |
| 2008-12-28 22:00:00 | CL | Futures | 137.56 | 137.59 | 136.2 | 136.54 | 521.0 |
| 2008-12-28 23:00:00 | CL | Futures | 136.54 | 136.65 | 134.38 | 134.97 | 754.0 |
| 2008-12-28 18:00:00 | GC | Futures | 1245.2 | 1257.6 | 1244.7 | 1253.2 | 2067.0 |
| 2008-12-28 19:00:00 | GC | Futures | 1253.2 | 1270.4 | 1251.9 | 1268.7 | 3602.0 |
| 2008-12-28 20:00:00 | GC | Futures | 1268.5 | 1271.8 | 1267.3 | 1268.3 | 2141.0 |
| 2008-12-28 21:00:00 | GC | Futures | 1268.3 | 1269.1 | 1260.4 | 1262.4 | 1478.0 |
| 2008-12-28 22:00:00 | GC | Futures | 1262.4 | 1264.1 | 1256.6 | 1263.3 | 1439.0 |
| 2008-12-28 23:00:00 | GC | Futures | 1262.6 | 1263.1 | 1257.6 | 1260.6 | 1055.0 |
| 2008-12-28 18:00:00 | ZN | Futures | 98.174676 | 98.234958 | 98.090282 | 98.114395 | 149.0 |
| 2008-12-28 19:00:00 | ZN | Futures | 98.114395 | 98.198789 | 98.114395 | 98.150564 | 150.0 |
| 2008-12-28 20:00:00 | ZN | Futures | 98.16262 | 98.16262 | 98.126451 | 98.150564 | 34.0 |
| 2008-12-28 21:00:00 | ZN | Futures | 98.16262 | 98.198789 | 98.150564 | 98.198789 | 239.0 |
| 2008-12-28 22:00:00 | ZN | Futures | 98.186733 | 98.186733 | 98.16262 | 98.186733 | 59.0 |
| 2008-12-28 23:00:00 | ZN | Futures | 98.174676 | 98.174676 | 98.126451 | 98.150564 | 26.0 |
> showing 36 of 226 rows — these rows as CSV