PREVIEW / futures_1hour / 2009-09-27
file: by_date/futures_1hour/2009/2009-09-27.parquet size: 13 KB rows: 229
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-09-27 18:00:00 | ES | Futures | 1009.82 | 1012.24 | 1009.82 | 1011.28 | 5893.0 |
| 2009-09-27 19:00:00 | ES | Futures | 1011.28 | 1011.28 | 1006.19 | 1007.16 | 7360.0 |
| 2009-09-27 20:00:00 | ES | Futures | 1006.92 | 1008.61 | 1005.22 | 1006.19 | 14883.0 |
| 2009-09-27 21:00:00 | ES | Futures | 1006.19 | 1007.16 | 1003.52 | 1005.22 | 11493.0 |
| 2009-09-27 22:00:00 | ES | Futures | 1005.22 | 1006.43 | 1004.74 | 1006.19 | 3664.0 |
| 2009-09-27 23:00:00 | ES | Futures | 1006.19 | 1006.43 | 1004.25 | 1004.49 | 3547.0 |
| 2009-09-27 18:00:00 | NQ | Futures | 1935.9 | 1940.46 | 1934.76 | 1938.75 | 647.0 |
| 2009-09-27 19:00:00 | NQ | Futures | 1938.75 | 1939.04 | 1930.19 | 1931.05 | 898.0 |
| 2009-09-27 20:00:00 | NQ | Futures | 1930.76 | 1933.33 | 1927.34 | 1929.62 | 1401.0 |
| 2009-09-27 21:00:00 | NQ | Futures | 1929.05 | 1930.76 | 1925.63 | 1928.48 | 963.0 |
| 2009-09-27 22:00:00 | NQ | Futures | 1928.2 | 1930.48 | 1927.91 | 1930.48 | 454.0 |
| 2009-09-27 23:00:00 | NQ | Futures | 1930.19 | 1930.48 | 1926.77 | 1927.63 | 528.0 |
| 2009-09-27 18:00:00 | YM | Futures | 8950.2 | 8971.6 | 8945.6 | 8962.3 | 420.0 |
| 2009-09-27 19:00:00 | YM | Futures | 8962.3 | 8962.3 | 8926.1 | 8933.5 | 291.0 |
| 2009-09-27 20:00:00 | YM | Futures | 8933.5 | 8945.6 | 8918.6 | 8926.1 | 899.0 |
| 2009-09-27 21:00:00 | YM | Futures | 8926.1 | 8930.7 | 8902.8 | 8915.8 | 706.0 |
| 2009-09-27 22:00:00 | YM | Futures | 8914.9 | 8926.1 | 8913.0 | 8926.1 | 255.0 |
| 2009-09-27 23:00:00 | YM | Futures | 8925.1 | 8925.1 | 8910.2 | 8911.2 | 399.0 |
| 2009-09-27 18:00:00 | CL | Futures | 148.78 | 149.54 | 148.78 | 149.27 | 726.0 |
| 2009-09-27 19:00:00 | CL | Futures | 149.25 | 149.74 | 149.16 | 149.72 | 357.0 |
| 2009-09-27 20:00:00 | CL | Futures | 149.68 | 149.92 | 149.11 | 149.16 | 1101.0 |
| 2009-09-27 21:00:00 | CL | Futures | 149.16 | 149.38 | 147.65 | 147.94 | 1638.0 |
| 2009-09-27 22:00:00 | CL | Futures | 147.9 | 148.33 | 147.74 | 148.06 | 573.0 |
| 2009-09-27 23:00:00 | CL | Futures | 148.03 | 148.03 | 147.43 | 147.54 | 597.0 |
| 2009-09-27 18:00:00 | GC | Futures | 1401.8 | 1405.8 | 1401.4 | 1405.1 | 696.0 |
| 2009-09-27 19:00:00 | GC | Futures | 1404.8 | 1405.6 | 1401.3 | 1405.5 | 1116.0 |
| 2009-09-27 20:00:00 | GC | Futures | 1405.5 | 1407.6 | 1403.7 | 1404.8 | 2516.0 |
| 2009-09-27 21:00:00 | GC | Futures | 1404.6 | 1405.2 | 1399.0 | 1401.1 | 2253.0 |
| 2009-09-27 22:00:00 | GC | Futures | 1401.1 | 1403.1 | 1400.6 | 1402.0 | 946.0 |
| 2009-09-27 23:00:00 | GC | Futures | 1402.1 | 1402.1 | 1396.6 | 1397.3 | 1618.0 |
| 2009-09-27 18:00:00 | ZN | Futures | 94.796561 | 94.809109 | 94.784014 | 94.796561 | 922.0 |
| 2009-09-27 19:00:00 | ZN | Futures | 94.784014 | 94.984774 | 94.784014 | 94.884394 | 8178.0 |
| 2009-09-27 20:00:00 | ZN | Futures | 94.884394 | 94.947131 | 94.859299 | 94.909489 | 5162.0 |
| 2009-09-27 21:00:00 | ZN | Futures | 94.909489 | 94.934584 | 94.846751 | 94.909489 | 7745.0 |
| 2009-09-27 22:00:00 | ZN | Futures | 94.909489 | 94.922036 | 94.896941 | 94.909489 | 848.0 |
| 2009-09-27 23:00:00 | ZN | Futures | 94.909489 | 94.922036 | 94.896941 | 94.896941 | 586.0 |
> showing 36 of 229 rows — these rows as CSV