PREVIEW / futures_1hour / 2016-04-24
file: by_date/futures_1hour/2016/2016-04-24.parquet size: 15 KB rows: 289
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 |
|---|---|---|---|---|---|---|---|
| 2016-04-24 18:00:00 | ES | Futures | 2258.65 | 2258.65 | 2254.87 | 2254.87 | 6177.0 |
| 2016-04-24 19:00:00 | ES | Futures | 2255.14 | 2255.68 | 2254.06 | 2254.6 | 2151.0 |
| 2016-04-24 20:00:00 | ES | Futures | 2254.6 | 2254.87 | 2252.98 | 2253.25 | 8077.0 |
| 2016-04-24 21:00:00 | ES | Futures | 2252.98 | 2254.33 | 2250.55 | 2251.63 | 12035.0 |
| 2016-04-24 22:00:00 | ES | Futures | 2251.36 | 2252.98 | 2248.93 | 2249.74 | 4891.0 |
| 2016-04-24 23:00:00 | ES | Futures | 2250.01 | 2250.28 | 2248.93 | 2249.74 | 2620.0 |
| 2016-04-24 18:00:00 | NQ | Futures | 5328.16 | 5331.43 | 5322.81 | 5323.1 | 634.0 |
| 2016-04-24 19:00:00 | NQ | Futures | 5323.1 | 5324.0 | 5319.53 | 5321.02 | 344.0 |
| 2016-04-24 20:00:00 | NQ | Futures | 5320.43 | 5322.21 | 5315.37 | 5316.56 | 828.0 |
| 2016-04-24 21:00:00 | NQ | Futures | 5316.26 | 5317.75 | 5309.12 | 5310.01 | 1178.0 |
| 2016-04-24 22:00:00 | NQ | Futures | 5310.01 | 5315.07 | 5304.95 | 5307.04 | 683.0 |
| 2016-04-24 23:00:00 | NQ | Futures | 5307.33 | 5308.52 | 5303.47 | 5305.25 | 373.0 |
| 2016-04-24 18:00:00 | YM | Futures | 19227.4 | 19231.7 | 19195.3 | 19200.7 | 621.0 |
| 2016-04-24 19:00:00 | YM | Futures | 19199.6 | 19203.9 | 19188.9 | 19190.0 | 310.0 |
| 2016-04-24 20:00:00 | YM | Futures | 19191.0 | 19192.1 | 19177.1 | 19180.3 | 809.0 |
| 2016-04-24 21:00:00 | YM | Futures | 19179.2 | 19187.8 | 19161.1 | 19164.3 | 1212.0 |
| 2016-04-24 22:00:00 | YM | Futures | 19164.3 | 19177.1 | 19149.3 | 19156.8 | 698.0 |
| 2016-04-24 23:00:00 | YM | Futures | 19156.8 | 19160.0 | 19147.1 | 19153.6 | 342.0 |
| 2016-04-24 18:00:00 | CL | Futures | 47.01 | 47.01 | 46.73 | 46.79 | 1898.0 |
| 2016-04-24 19:00:00 | CL | Futures | 46.78 | 46.81 | 46.61 | 46.63 | 2530.0 |
| 2016-04-24 20:00:00 | CL | Futures | 46.63 | 46.64 | 46.16 | 46.22 | 7613.0 |
| 2016-04-24 21:00:00 | CL | Futures | 46.21 | 46.42 | 46.15 | 46.34 | 6202.0 |
| 2016-04-24 22:00:00 | CL | Futures | 46.34 | 46.42 | 46.32 | 46.36 | 2471.0 |
| 2016-04-24 23:00:00 | CL | Futures | 46.35 | 46.38 | 46.3 | 46.36 | 1569.0 |
| 2016-04-24 18:00:00 | GC | Futures | 1683.7 | 1684.1 | 1680.8 | 1681.5 | 1328.0 |
| 2016-04-24 19:00:00 | GC | Futures | 1681.5 | 1683.4 | 1680.6 | 1683.1 | 985.0 |
| 2016-04-24 20:00:00 | GC | Futures | 1683.0 | 1683.3 | 1679.9 | 1681.1 | 2594.0 |
| 2016-04-24 21:00:00 | GC | Futures | 1681.2 | 1685.6 | 1679.3 | 1683.1 | 5760.0 |
| 2016-04-24 22:00:00 | GC | Futures | 1683.1 | 1685.6 | 1683.0 | 1684.2 | 2394.0 |
| 2016-04-24 23:00:00 | GC | Futures | 1684.4 | 1685.2 | 1683.1 | 1684.5 | 1268.0 |
| 2016-04-24 18:00:00 | ZN | Futures | 126.119058 | 126.119058 | 126.058197 | 126.088628 | 3669.0 |
| 2016-04-24 19:00:00 | ZN | Futures | 126.073413 | 126.073413 | 126.027767 | 126.042982 | 2687.0 |
| 2016-04-24 20:00:00 | ZN | Futures | 126.042982 | 126.103843 | 126.042982 | 126.103843 | 5835.0 |
| 2016-04-24 21:00:00 | ZN | Futures | 126.103843 | 126.164704 | 126.058197 | 126.149489 | 13733.0 |
| 2016-04-24 22:00:00 | ZN | Futures | 126.149489 | 126.149489 | 126.119058 | 126.134274 | 3586.0 |
| 2016-04-24 23:00:00 | ZN | Futures | 126.134274 | 126.164704 | 126.103843 | 126.134274 | 10845.0 |
> showing 36 of 289 rows — these rows as CSV