PREVIEW / futures_1hour / 2015-03-29
file: by_date/futures_1hour/2015/2015-03-29.parquet size: 14 KB rows: 270
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-03-29 18:00:00 | ES | Futures | 2168.67 | 2171.84 | 2166.56 | 2166.82 | 3827.0 |
| 2015-03-29 19:00:00 | ES | Futures | 2166.82 | 2167.88 | 2165.77 | 2167.35 | 1791.0 |
| 2015-03-29 20:00:00 | ES | Futures | 2167.35 | 2168.41 | 2162.86 | 2165.5 | 7015.0 |
| 2015-03-29 21:00:00 | ES | Futures | 2165.77 | 2168.41 | 2165.24 | 2168.41 | 3628.0 |
| 2015-03-29 22:00:00 | ES | Futures | 2168.14 | 2174.75 | 2167.88 | 2174.48 | 8288.0 |
| 2015-03-29 23:00:00 | ES | Futures | 2174.75 | 2177.92 | 2173.43 | 2175.01 | 7367.0 |
| 2015-03-29 18:00:00 | NQ | Futures | 5090.24 | 5096.12 | 5083.48 | 5083.48 | 531.0 |
| 2015-03-29 19:00:00 | NQ | Futures | 5083.77 | 5086.12 | 5081.71 | 5084.36 | 263.0 |
| 2015-03-29 20:00:00 | NQ | Futures | 5084.95 | 5088.18 | 5076.42 | 5081.71 | 1444.0 |
| 2015-03-29 21:00:00 | NQ | Futures | 5080.83 | 5088.77 | 5080.83 | 5088.77 | 703.0 |
| 2015-03-29 22:00:00 | NQ | Futures | 5089.06 | 5110.82 | 5087.59 | 5105.83 | 2600.0 |
| 2015-03-29 23:00:00 | NQ | Futures | 5105.53 | 5114.35 | 5103.47 | 5107.0 | 1430.0 |
| 2015-03-29 18:00:00 | YM | Futures | 18481.7 | 18513.2 | 18468.1 | 18469.1 | 702.0 |
| 2015-03-29 19:00:00 | YM | Futures | 18469.1 | 18479.6 | 18460.7 | 18469.1 | 253.0 |
| 2015-03-29 20:00:00 | YM | Futures | 18469.1 | 18480.7 | 18440.8 | 18461.8 | 1478.0 |
| 2015-03-29 21:00:00 | YM | Futures | 18461.8 | 18485.9 | 18458.6 | 18483.8 | 758.0 |
| 2015-03-29 22:00:00 | YM | Futures | 18484.8 | 18537.3 | 18479.6 | 18535.2 | 1792.0 |
| 2015-03-29 23:00:00 | YM | Futures | 18537.3 | 18566.6 | 18521.5 | 18532.0 | 3191.0 |
| 2015-03-29 18:00:00 | CL | Futures | 76.64 | 76.7 | 75.66 | 76.01 | 3140.0 |
| 2015-03-29 19:00:00 | CL | Futures | 76.02 | 76.53 | 76.01 | 76.13 | 1896.0 |
| 2015-03-29 20:00:00 | CL | Futures | 76.15 | 76.46 | 75.91 | 76.35 | 2753.0 |
| 2015-03-29 21:00:00 | CL | Futures | 76.35 | 76.83 | 76.16 | 76.27 | 3729.0 |
| 2015-03-29 22:00:00 | CL | Futures | 76.26 | 76.27 | 75.77 | 76.02 | 4046.0 |
| 2015-03-29 23:00:00 | CL | Futures | 76.02 | 76.09 | 75.8 | 75.96 | 2154.0 |
| 2015-03-29 18:00:00 | GC | Futures | 1637.0 | 1638.4 | 1634.1 | 1636.0 | 947.0 |
| 2015-03-29 19:00:00 | GC | Futures | 1636.3 | 1636.6 | 1634.0 | 1635.2 | 575.0 |
| 2015-03-29 20:00:00 | GC | Futures | 1635.2 | 1636.0 | 1633.3 | 1635.9 | 1198.0 |
| 2015-03-29 21:00:00 | GC | Futures | 1635.9 | 1636.7 | 1631.8 | 1631.9 | 2413.0 |
| 2015-03-29 22:00:00 | GC | Futures | 1632.1 | 1632.6 | 1628.2 | 1631.3 | 3893.0 |
| 2015-03-29 23:00:00 | GC | Futures | 1631.5 | 1632.5 | 1630.4 | 1631.5 | 1270.0 |
| 2015-03-29 18:00:00 | ZN | Futures | 122.857641 | 122.917375 | 122.842707 | 122.857641 | 3103.0 |
| 2015-03-29 19:00:00 | ZN | Futures | 122.842707 | 122.917375 | 122.842707 | 122.902441 | 2160.0 |
| 2015-03-29 20:00:00 | ZN | Futures | 122.887508 | 122.977108 | 122.887508 | 122.932308 | 5533.0 |
| 2015-03-29 21:00:00 | ZN | Futures | 122.947241 | 122.947241 | 122.887508 | 122.902441 | 3817.0 |
| 2015-03-29 22:00:00 | ZN | Futures | 122.902441 | 122.917375 | 122.872574 | 122.887508 | 3189.0 |
| 2015-03-29 23:00:00 | ZN | Futures | 122.887508 | 122.887508 | 122.827774 | 122.857641 | 3836.0 |
> showing 36 of 270 rows — these rows as CSV