PREVIEW / futures_1hour / 2010-04-25
file: by_date/futures_1hour/2010/2010-04-25.parquet size: 13 KB rows: 242
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-04-25 18:00:00 | ES | Futures | 1184.25 | 1184.49 | 1183.02 | 1183.51 | 5618.0 |
| 2010-04-25 19:00:00 | ES | Futures | 1183.51 | 1184.49 | 1183.02 | 1184.0 | 1802.0 |
| 2010-04-25 20:00:00 | ES | Futures | 1184.25 | 1186.45 | 1183.76 | 1186.2 | 5393.0 |
| 2010-04-25 21:00:00 | ES | Futures | 1186.2 | 1187.91 | 1186.2 | 1187.67 | 6991.0 |
| 2010-04-25 22:00:00 | ES | Futures | 1187.67 | 1188.16 | 1186.45 | 1187.18 | 4824.0 |
| 2010-04-25 23:00:00 | ES | Futures | 1187.18 | 1187.67 | 1186.45 | 1186.69 | 1755.0 |
| 2010-04-25 18:00:00 | NQ | Futures | 2348.26 | 2349.69 | 2346.82 | 2348.54 | 1066.0 |
| 2010-04-25 19:00:00 | NQ | Futures | 2348.54 | 2348.54 | 2346.82 | 2348.26 | 113.0 |
| 2010-04-25 20:00:00 | NQ | Futures | 2348.26 | 2353.7 | 2347.97 | 2353.12 | 650.0 |
| 2010-04-25 21:00:00 | NQ | Futures | 2352.84 | 2355.13 | 2352.26 | 2354.84 | 932.0 |
| 2010-04-25 22:00:00 | NQ | Futures | 2354.84 | 2355.41 | 2353.41 | 2354.27 | 250.0 |
| 2010-04-25 23:00:00 | NQ | Futures | 2354.56 | 2354.84 | 2353.41 | 2353.41 | 143.0 |
| 2010-04-25 18:00:00 | YM | Futures | 10481.6 | 10482.5 | 10471.2 | 10476.9 | 489.0 |
| 2010-04-25 19:00:00 | YM | Futures | 10476.9 | 10478.8 | 10471.2 | 10476.9 | 105.0 |
| 2010-04-25 20:00:00 | YM | Futures | 10476.9 | 10498.5 | 10476.9 | 10497.6 | 383.0 |
| 2010-04-25 21:00:00 | YM | Futures | 10497.6 | 10507.0 | 10495.7 | 10506.0 | 211.0 |
| 2010-04-25 22:00:00 | YM | Futures | 10507.0 | 10510.7 | 10497.6 | 10503.2 | 187.0 |
| 2010-04-25 23:00:00 | YM | Futures | 10503.2 | 10505.1 | 10496.6 | 10498.5 | 159.0 |
| 2010-04-25 18:00:00 | CL | Futures | 178.23 | 178.63 | 178.02 | 178.57 | 1119.0 |
| 2010-04-25 19:00:00 | CL | Futures | 178.57 | 178.65 | 178.13 | 178.17 | 590.0 |
| 2010-04-25 20:00:00 | CL | Futures | 178.17 | 178.94 | 178.15 | 178.8 | 1739.0 |
| 2010-04-25 21:00:00 | CL | Futures | 178.82 | 178.94 | 178.65 | 178.78 | 581.0 |
| 2010-04-25 22:00:00 | CL | Futures | 178.76 | 178.92 | 178.71 | 178.82 | 394.0 |
| 2010-04-25 23:00:00 | CL | Futures | 178.82 | 178.88 | 178.57 | 178.69 | 859.0 |
| 2010-04-25 18:00:00 | GC | Futures | 1628.9 | 1629.9 | 1626.4 | 1628.8 | 1619.0 |
| 2010-04-25 19:00:00 | GC | Futures | 1629.1 | 1629.5 | 1623.6 | 1623.6 | 1757.0 |
| 2010-04-25 20:00:00 | GC | Futures | 1623.7 | 1628.9 | 1623.6 | 1628.8 | 2554.0 |
| 2010-04-25 21:00:00 | GC | Futures | 1628.8 | 1632.0 | 1628.6 | 1630.6 | 3303.0 |
| 2010-04-25 22:00:00 | GC | Futures | 1630.8 | 1631.2 | 1628.9 | 1629.9 | 808.0 |
| 2010-04-25 23:00:00 | GC | Futures | 1629.9 | 1630.0 | 1628.5 | 1629.5 | 467.0 |
| 2010-04-25 18:00:00 | ZN | Futures | 95.805102 | 95.817949 | 95.728016 | 95.740863 | 2218.0 |
| 2010-04-25 19:00:00 | ZN | Futures | 95.740863 | 95.766559 | 95.689473 | 95.728016 | 2982.0 |
| 2010-04-25 20:00:00 | ZN | Futures | 95.728016 | 95.740863 | 95.676625 | 95.689473 | 4403.0 |
| 2010-04-25 21:00:00 | ZN | Futures | 95.689473 | 95.715168 | 95.676625 | 95.689473 | 2713.0 |
| 2010-04-25 22:00:00 | ZN | Futures | 95.70232 | 95.753711 | 95.689473 | 95.740863 | 2960.0 |
| 2010-04-25 23:00:00 | ZN | Futures | 95.740863 | 95.740863 | 95.728016 | 95.728016 | 46.0 |
> showing 36 of 242 rows — these rows as CSV