PREVIEW / futures_1hour / 2017-04-23
file: by_date/futures_1hour/2017/2017-04-23.parquet size: 15 KB rows: 309
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-23 18:00:00 | ES | Futures | 2584.75 | 2592.4 | 2584.48 | 2588.3 | 64710.0 |
| 2017-04-23 19:00:00 | ES | Futures | 2588.03 | 2589.4 | 2586.12 | 2586.66 | 12885.0 |
| 2017-04-23 20:00:00 | ES | Futures | 2586.39 | 2587.76 | 2585.57 | 2587.48 | 12718.0 |
| 2017-04-23 21:00:00 | ES | Futures | 2587.48 | 2587.76 | 2584.21 | 2585.57 | 13861.0 |
| 2017-04-23 22:00:00 | ES | Futures | 2585.3 | 2585.84 | 2584.21 | 2584.75 | 5388.0 |
| 2017-04-23 23:00:00 | ES | Futures | 2585.03 | 2585.57 | 2584.48 | 2585.3 | 3770.0 |
| 2017-04-23 18:00:00 | NQ | Futures | 6524.5 | 6558.49 | 6524.5 | 6543.58 | 8265.0 |
| 2017-04-23 19:00:00 | NQ | Futures | 6543.28 | 6548.65 | 6539.71 | 6544.77 | 2095.0 |
| 2017-04-23 20:00:00 | NQ | Futures | 6544.48 | 6548.05 | 6543.28 | 6547.76 | 2649.0 |
| 2017-04-23 21:00:00 | NQ | Futures | 6548.05 | 6548.05 | 6538.51 | 6541.79 | 2696.0 |
| 2017-04-23 22:00:00 | NQ | Futures | 6542.09 | 6544.18 | 6539.41 | 6542.39 | 1529.0 |
| 2017-04-23 23:00:00 | NQ | Futures | 6542.69 | 6545.37 | 6542.09 | 6545.07 | 811.0 |
| 2017-04-23 18:00:00 | YM | Futures | 22386.8 | 22512.9 | 22386.8 | 22459.6 | 5975.0 |
| 2017-04-23 19:00:00 | YM | Futures | 22459.6 | 22478.1 | 22447.7 | 22449.8 | 1744.0 |
| 2017-04-23 20:00:00 | YM | Futures | 22448.8 | 22462.9 | 22445.5 | 22459.6 | 2237.0 |
| 2017-04-23 21:00:00 | YM | Futures | 22461.8 | 22461.8 | 22427.0 | 22436.8 | 2701.0 |
| 2017-04-23 22:00:00 | YM | Futures | 22436.8 | 22442.2 | 22421.6 | 22430.3 | 1087.0 |
| 2017-04-23 23:00:00 | YM | Futures | 22430.3 | 22437.9 | 22428.1 | 22436.8 | 552.0 |
| 2017-04-23 18:00:00 | CL | Futures | 45.8 | 46.05 | 45.79 | 45.91 | 8502.0 |
| 2017-04-23 19:00:00 | CL | Futures | 45.91 | 45.98 | 45.9 | 45.94 | 1914.0 |
| 2017-04-23 20:00:00 | CL | Futures | 45.95 | 45.98 | 45.82 | 45.95 | 4378.0 |
| 2017-04-23 21:00:00 | CL | Futures | 45.95 | 46.0 | 45.9 | 45.95 | 2707.0 |
| 2017-04-23 22:00:00 | CL | Futures | 45.94 | 45.97 | 45.9 | 45.94 | 2950.0 |
| 2017-04-23 23:00:00 | CL | Futures | 45.94 | 45.99 | 45.94 | 45.98 | 1508.0 |
| 2017-04-23 18:00:00 | GC | Futures | 1718.4 | 1718.4 | 1699.6 | 1705.4 | 28171.0 |
| 2017-04-23 19:00:00 | GC | Futures | 1705.4 | 1713.0 | 1705.2 | 1712.2 | 11390.0 |
| 2017-04-23 20:00:00 | GC | Futures | 1712.4 | 1712.6 | 1709.8 | 1710.5 | 8989.0 |
| 2017-04-23 21:00:00 | GC | Futures | 1710.3 | 1716.8 | 1709.9 | 1714.8 | 13423.0 |
| 2017-04-23 22:00:00 | GC | Futures | 1714.8 | 1715.6 | 1711.8 | 1713.7 | 8016.0 |
| 2017-04-23 23:00:00 | GC | Futures | 1713.6 | 1715.2 | 1713.3 | 1714.5 | 3013.0 |
| 2017-04-23 18:00:00 | ZN | Futures | 124.461829 | 124.461829 | 124.198336 | 124.337832 | 103768.0 |
| 2017-04-23 19:00:00 | ZN | Futures | 124.353332 | 124.399831 | 124.275834 | 124.384331 | 35282.0 |
| 2017-04-23 20:00:00 | ZN | Futures | 124.399831 | 124.41533 | 124.353332 | 124.368831 | 31156.0 |
| 2017-04-23 21:00:00 | ZN | Futures | 124.368831 | 124.461829 | 124.368831 | 124.43083 | 30782.0 |
| 2017-04-23 22:00:00 | ZN | Futures | 124.44633 | 124.44633 | 124.384331 | 124.399831 | 15775.0 |
| 2017-04-23 23:00:00 | ZN | Futures | 124.399831 | 124.44633 | 124.399831 | 124.43083 | 8899.0 |
> showing 36 of 309 rows — these rows as CSV