PREVIEW / futures_1hour / 2014-11-16
file: by_date/futures_1hour/2014/2014-11-16.parquet size: 15 KB rows: 279
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 |
|---|---|---|---|---|---|---|---|
| 2014-11-16 18:00:00 | ES | Futures | 2136.08 | 2136.08 | 2132.15 | 2132.94 | 6929.0 |
| 2014-11-16 19:00:00 | ES | Futures | 2132.68 | 2132.94 | 2125.6 | 2129.01 | 16486.0 |
| 2014-11-16 20:00:00 | ES | Futures | 2129.27 | 2129.27 | 2126.39 | 2127.7 | 9099.0 |
| 2014-11-16 21:00:00 | ES | Futures | 2127.44 | 2127.7 | 2122.2 | 2124.29 | 17657.0 |
| 2014-11-16 22:00:00 | ES | Futures | 2124.29 | 2126.65 | 2124.03 | 2126.13 | 4694.0 |
| 2014-11-16 23:00:00 | ES | Futures | 2125.87 | 2126.65 | 2125.34 | 2126.13 | 1978.0 |
| 2014-11-16 18:00:00 | NQ | Futures | 4949.75 | 4950.33 | 4942.13 | 4943.3 | 1001.0 |
| 2014-11-16 19:00:00 | NQ | Futures | 4943.59 | 4943.59 | 4929.24 | 4936.85 | 3265.0 |
| 2014-11-16 20:00:00 | NQ | Futures | 4936.27 | 4936.85 | 4930.11 | 4933.34 | 1766.0 |
| 2014-11-16 21:00:00 | NQ | Futures | 4933.04 | 4934.22 | 4921.03 | 4924.84 | 3027.0 |
| 2014-11-16 22:00:00 | NQ | Futures | 4924.25 | 4932.46 | 4924.25 | 4930.7 | 1430.0 |
| 2014-11-16 23:00:00 | NQ | Futures | 4930.41 | 4932.46 | 4927.77 | 4930.11 | 463.0 |
| 2014-11-16 18:00:00 | YM | Futures | 18307.1 | 18308.2 | 18279.0 | 18285.3 | 716.0 |
| 2014-11-16 19:00:00 | YM | Futures | 18284.2 | 18286.3 | 18227.0 | 18255.1 | 2617.0 |
| 2014-11-16 20:00:00 | YM | Futures | 18254.1 | 18258.2 | 18237.4 | 18246.8 | 1601.0 |
| 2014-11-16 21:00:00 | YM | Futures | 18244.7 | 18247.8 | 18207.3 | 18216.7 | 1998.0 |
| 2014-11-16 22:00:00 | YM | Futures | 18216.7 | 18237.4 | 18216.7 | 18231.2 | 824.0 |
| 2014-11-16 23:00:00 | YM | Futures | 18232.2 | 18239.5 | 18229.1 | 18236.4 | 413.0 |
| 2014-11-16 18:00:00 | CL | Futures | 127.85 | 128.29 | 127.23 | 127.35 | 668.0 |
| 2014-11-16 19:00:00 | CL | Futures | 127.38 | 127.75 | 127.31 | 127.56 | 350.0 |
| 2014-11-16 20:00:00 | CL | Futures | 127.55 | 127.67 | 127.28 | 127.31 | 282.0 |
| 2014-11-16 21:00:00 | CL | Futures | 127.29 | 127.33 | 126.94 | 127.01 | 638.0 |
| 2014-11-16 22:00:00 | CL | Futures | 127.03 | 127.18 | 126.87 | 127.14 | 221.0 |
| 2014-11-16 23:00:00 | CL | Futures | 127.09 | 127.11 | 127.01 | 127.08 | 64.0 |
| 2014-11-16 18:00:00 | GC | Futures | 1622.9 | 1625.4 | 1617.1 | 1617.4 | 4834.0 |
| 2014-11-16 19:00:00 | GC | Futures | 1617.5 | 1621.9 | 1617.3 | 1620.2 | 5345.0 |
| 2014-11-16 20:00:00 | GC | Futures | 1620.2 | 1634.0 | 1620.2 | 1625.6 | 17474.0 |
| 2014-11-16 21:00:00 | GC | Futures | 1625.6 | 1626.9 | 1621.7 | 1622.2 | 6594.0 |
| 2014-11-16 22:00:00 | GC | Futures | 1622.2 | 1624.8 | 1620.4 | 1622.1 | 2737.0 |
| 2014-11-16 23:00:00 | GC | Futures | 1622.1 | 1625.9 | 1621.9 | 1624.5 | 2101.0 |
| 2014-11-16 18:00:00 | ZN | Futures | 119.813533 | 119.946609 | 119.813533 | 119.931823 | 7598.0 |
| 2014-11-16 19:00:00 | ZN | Futures | 119.931823 | 120.094473 | 119.931823 | 120.079686 | 19378.0 |
| 2014-11-16 20:00:00 | ZN | Futures | 120.094473 | 120.168404 | 120.0649 | 120.124045 | 22681.0 |
| 2014-11-16 21:00:00 | ZN | Futures | 120.124045 | 120.18319 | 120.124045 | 120.138832 | 9997.0 |
| 2014-11-16 22:00:00 | ZN | Futures | 120.138832 | 120.153618 | 120.109259 | 120.138832 | 3612.0 |
| 2014-11-16 23:00:00 | ZN | Futures | 120.153618 | 120.168404 | 120.138832 | 120.138832 | 2561.0 |
> showing 36 of 279 rows — these rows as CSV