PREVIEW / futures_1hour / 2009-12-06
file: by_date/futures_1hour/2009/2009-12-06.parquet size: 13 KB rows: 235
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-12-06 18:00:00 | ES | Futures | 1073.53 | 1076.19 | 1072.56 | 1074.5 | 10656.0 |
| 2009-12-06 19:00:00 | ES | Futures | 1074.5 | 1076.19 | 1073.53 | 1074.5 | 6212.0 |
| 2009-12-06 20:00:00 | ES | Futures | 1074.5 | 1075.22 | 1072.8 | 1073.04 | 4654.0 |
| 2009-12-06 21:00:00 | ES | Futures | 1073.04 | 1074.98 | 1072.8 | 1074.01 | 5099.0 |
| 2009-12-06 22:00:00 | ES | Futures | 1073.77 | 1074.01 | 1071.83 | 1072.56 | 3628.0 |
| 2009-12-06 23:00:00 | ES | Futures | 1072.8 | 1072.8 | 1071.83 | 1072.56 | 2025.0 |
| 2009-12-06 18:00:00 | NQ | Futures | 2047.69 | 2052.26 | 2045.7 | 2049.12 | 752.0 |
| 2009-12-06 19:00:00 | NQ | Futures | 2048.55 | 2051.69 | 2046.55 | 2048.83 | 324.0 |
| 2009-12-06 20:00:00 | NQ | Futures | 2048.83 | 2050.26 | 2045.98 | 2045.98 | 366.0 |
| 2009-12-06 21:00:00 | NQ | Futures | 2046.27 | 2049.41 | 2045.98 | 2046.84 | 416.0 |
| 2009-12-06 22:00:00 | NQ | Futures | 2047.12 | 2047.12 | 2044.56 | 2045.41 | 281.0 |
| 2009-12-06 23:00:00 | NQ | Futures | 2045.41 | 2045.98 | 2044.27 | 2045.41 | 99.0 |
| 2009-12-06 18:00:00 | YM | Futures | 9672.1 | 9690.7 | 9667.4 | 9678.6 | 458.0 |
| 2009-12-06 19:00:00 | YM | Futures | 9679.5 | 9692.5 | 9671.1 | 9679.5 | 550.0 |
| 2009-12-06 20:00:00 | YM | Futures | 9679.5 | 9682.3 | 9664.6 | 9665.5 | 296.0 |
| 2009-12-06 21:00:00 | YM | Futures | 9666.5 | 9682.3 | 9666.5 | 9672.1 | 330.0 |
| 2009-12-06 22:00:00 | YM | Futures | 9673.9 | 9673.9 | 9658.1 | 9664.6 | 205.0 |
| 2009-12-06 23:00:00 | YM | Futures | 9664.6 | 9665.5 | 9659.0 | 9662.8 | 91.0 |
| 2009-12-06 18:00:00 | CL | Futures | 167.89 | 168.55 | 167.51 | 167.85 | 1177.0 |
| 2009-12-06 19:00:00 | CL | Futures | 167.85 | 168.22 | 167.25 | 167.98 | 1401.0 |
| 2009-12-06 20:00:00 | CL | Futures | 167.96 | 168.07 | 167.31 | 167.47 | 837.0 |
| 2009-12-06 21:00:00 | CL | Futures | 167.51 | 168.02 | 167.4 | 167.73 | 706.0 |
| 2009-12-06 22:00:00 | CL | Futures | 167.76 | 167.98 | 167.49 | 167.56 | 518.0 |
| 2009-12-06 23:00:00 | CL | Futures | 167.58 | 167.65 | 167.51 | 167.56 | 306.0 |
| 2009-12-06 18:00:00 | GC | Futures | 1635.2 | 1638.3 | 1624.9 | 1632.9 | 7081.0 |
| 2009-12-06 19:00:00 | GC | Futures | 1632.9 | 1634.1 | 1613.6 | 1628.8 | 15578.0 |
| 2009-12-06 20:00:00 | GC | Futures | 1629.0 | 1631.8 | 1623.1 | 1623.3 | 5923.0 |
| 2009-12-06 21:00:00 | GC | Futures | 1623.3 | 1628.4 | 1623.1 | 1626.9 | 3265.0 |
| 2009-12-06 22:00:00 | GC | Futures | 1626.9 | 1632.6 | 1626.6 | 1630.8 | 2323.0 |
| 2009-12-06 23:00:00 | GC | Futures | 1630.4 | 1634.8 | 1629.8 | 1630.4 | 2318.0 |
| 2009-12-06 18:00:00 | ZN | Futures | 95.587055 | 95.624698 | 95.587055 | 95.624698 | 15.0 |
| 2009-12-06 19:00:00 | ZN | Futures | 95.624698 | 95.66234 | 95.599603 | 95.66234 | 100.0 |
| 2009-12-06 20:00:00 | ZN | Futures | 95.674888 | 95.699983 | 95.637245 | 95.66234 | 69.0 |
| 2009-12-06 21:00:00 | ZN | Futures | 95.687435 | 95.750173 | 95.649793 | 95.750173 | 241.0 |
| 2009-12-06 22:00:00 | ZN | Futures | 95.750173 | 95.775268 | 95.737626 | 95.750173 | 70.0 |
| 2009-12-06 23:00:00 | ZN | Futures | 95.775268 | 95.775268 | 95.750173 | 95.750173 | 8.0 |
> showing 36 of 235 rows — these rows as CSV