PREVIEW / futures_1hour / 2015-04-05
file: by_date/futures_1hour/2015/2015-04-05.parquet size: 14 KB rows: 271
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 |
|---|---|---|---|---|---|---|---|
| 2015-04-05 18:00:00 | ES | Futures | 2154.67 | 2161.28 | 2153.88 | 2155.73 | 11988.0 |
| 2015-04-05 19:00:00 | ES | Futures | 2155.99 | 2159.43 | 2154.67 | 2159.16 | 2742.0 |
| 2015-04-05 20:00:00 | ES | Futures | 2159.16 | 2162.33 | 2158.63 | 2161.28 | 5494.0 |
| 2015-04-05 21:00:00 | ES | Futures | 2161.54 | 2163.39 | 2158.9 | 2162.6 | 5405.0 |
| 2015-04-05 22:00:00 | ES | Futures | 2162.6 | 2162.6 | 2160.48 | 2161.01 | 1760.0 |
| 2015-04-05 23:00:00 | ES | Futures | 2161.01 | 2161.8 | 2160.22 | 2161.8 | 1321.0 |
| 2015-04-05 18:00:00 | NQ | Futures | 5016.72 | 5031.72 | 5016.14 | 5020.25 | 1831.0 |
| 2015-04-05 19:00:00 | NQ | Futures | 5020.25 | 5029.66 | 5018.19 | 5028.78 | 443.0 |
| 2015-04-05 20:00:00 | NQ | Futures | 5029.37 | 5034.37 | 5025.84 | 5032.9 | 887.0 |
| 2015-04-05 21:00:00 | NQ | Futures | 5032.31 | 5037.31 | 5027.31 | 5035.25 | 725.0 |
| 2015-04-05 22:00:00 | NQ | Futures | 5035.25 | 5035.54 | 5031.43 | 5033.78 | 307.0 |
| 2015-04-05 23:00:00 | NQ | Futures | 5033.19 | 5034.66 | 5032.02 | 5034.07 | 250.0 |
| 2015-04-05 18:00:00 | YM | Futures | 18363.2 | 18417.7 | 18359.0 | 18368.4 | 1676.0 |
| 2015-04-05 19:00:00 | YM | Futures | 18368.4 | 18396.8 | 18363.2 | 18396.8 | 689.0 |
| 2015-04-05 20:00:00 | YM | Futures | 18394.7 | 18424.0 | 18392.6 | 18416.7 | 1205.0 |
| 2015-04-05 21:00:00 | YM | Futures | 18416.7 | 18429.3 | 18393.6 | 18419.8 | 1139.0 |
| 2015-04-05 22:00:00 | YM | Futures | 18419.8 | 18421.9 | 18405.1 | 18412.5 | 465.0 |
| 2015-04-05 23:00:00 | YM | Futures | 18412.5 | 18419.8 | 18406.2 | 18416.7 | 613.0 |
| 2015-04-05 18:00:00 | CL | Futures | 78.06 | 79.05 | 78.06 | 78.44 | 2875.0 |
| 2015-04-05 19:00:00 | CL | Futures | 78.45 | 78.96 | 78.34 | 78.89 | 1152.0 |
| 2015-04-05 20:00:00 | CL | Futures | 78.91 | 79.45 | 78.75 | 78.91 | 3011.0 |
| 2015-04-05 21:00:00 | CL | Futures | 78.91 | 79.07 | 78.66 | 78.7 | 2258.0 |
| 2015-04-05 22:00:00 | CL | Futures | 78.7 | 79.0 | 78.63 | 78.8 | 1597.0 |
| 2015-04-05 23:00:00 | CL | Futures | 78.81 | 78.96 | 78.66 | 78.93 | 1292.0 |
| 2015-04-05 18:00:00 | GC | Futures | 1656.1 | 1662.7 | 1656.1 | 1661.3 | 6226.0 |
| 2015-04-05 19:00:00 | GC | Futures | 1661.4 | 1663.3 | 1660.3 | 1663.2 | 1483.0 |
| 2015-04-05 20:00:00 | GC | Futures | 1663.2 | 1664.6 | 1662.7 | 1662.8 | 3169.0 |
| 2015-04-05 21:00:00 | GC | Futures | 1662.7 | 1663.3 | 1660.9 | 1661.6 | 2270.0 |
| 2015-04-05 22:00:00 | GC | Futures | 1661.6 | 1662.5 | 1660.3 | 1662.5 | 1455.0 |
| 2015-04-05 23:00:00 | GC | Futures | 1662.5 | 1663.5 | 1661.0 | 1663.1 | 1754.0 |
| 2015-04-05 18:00:00 | ZN | Futures | 124.156852 | 124.261387 | 124.126985 | 124.246453 | 4393.0 |
| 2015-04-05 19:00:00 | ZN | Futures | 124.246453 | 124.27632 | 124.201653 | 124.216586 | 3729.0 |
| 2015-04-05 20:00:00 | ZN | Futures | 124.201653 | 124.246453 | 124.201653 | 124.23152 | 4438.0 |
| 2015-04-05 21:00:00 | ZN | Futures | 124.23152 | 124.27632 | 124.216586 | 124.23152 | 3761.0 |
| 2015-04-05 22:00:00 | ZN | Futures | 124.23152 | 124.261387 | 124.23152 | 124.23152 | 1430.0 |
| 2015-04-05 23:00:00 | ZN | Futures | 124.23152 | 124.246453 | 124.216586 | 124.23152 | 1854.0 |
> showing 36 of 271 rows — these rows as CSV