PREVIEW / futures_1hour / 2017-03-19
file: by_date/futures_1hour/2017/2017-03-19.parquet size: 15 KB rows: 282
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-03-19 18:00:00 | ES | Futures | 2593.49 | 2594.59 | 2591.31 | 2591.85 | 6548.0 |
| 2017-03-19 19:00:00 | ES | Futures | 2591.85 | 2592.95 | 2591.31 | 2592.67 | 3116.0 |
| 2017-03-19 20:00:00 | ES | Futures | 2592.67 | 2592.67 | 2588.03 | 2589.12 | 9502.0 |
| 2017-03-19 21:00:00 | ES | Futures | 2589.4 | 2590.49 | 2588.3 | 2588.58 | 5675.0 |
| 2017-03-19 22:00:00 | ES | Futures | 2588.58 | 2589.67 | 2588.03 | 2589.4 | 4467.0 |
| 2017-03-19 23:00:00 | ES | Futures | 2589.4 | 2589.94 | 2588.3 | 2588.85 | 2283.0 |
| 2017-03-19 18:00:00 | NQ | Futures | 6448.47 | 6450.56 | 6442.81 | 6444.3 | 1360.0 |
| 2017-03-19 19:00:00 | NQ | Futures | 6444.9 | 6447.88 | 6444.0 | 6447.88 | 532.0 |
| 2017-03-19 20:00:00 | NQ | Futures | 6447.28 | 6447.28 | 6435.06 | 6437.74 | 2245.0 |
| 2017-03-19 21:00:00 | NQ | Futures | 6437.74 | 6440.72 | 6436.25 | 6436.85 | 1211.0 |
| 2017-03-19 22:00:00 | NQ | Futures | 6436.85 | 6439.53 | 6435.06 | 6439.53 | 1189.0 |
| 2017-03-19 23:00:00 | NQ | Futures | 6439.53 | 6440.42 | 6438.04 | 6438.64 | 501.0 |
| 2017-03-19 18:00:00 | YM | Futures | 22660.7 | 22671.6 | 22652.0 | 22658.5 | 1471.0 |
| 2017-03-19 19:00:00 | YM | Futures | 22658.5 | 22666.1 | 22654.2 | 22663.9 | 501.0 |
| 2017-03-19 20:00:00 | YM | Futures | 22662.9 | 22663.9 | 22631.3 | 22642.2 | 1614.0 |
| 2017-03-19 21:00:00 | YM | Futures | 22642.2 | 22649.8 | 22635.7 | 22638.9 | 1029.0 |
| 2017-03-19 22:00:00 | YM | Futures | 22638.9 | 22649.8 | 22634.6 | 22649.8 | 984.0 |
| 2017-03-19 23:00:00 | YM | Futures | 22648.7 | 22652.0 | 22641.1 | 22644.4 | 509.0 |
| 2017-03-19 18:00:00 | CL | Futures | 45.75 | 45.78 | 45.69 | 45.73 | 1494.0 |
| 2017-03-19 19:00:00 | CL | Futures | 45.73 | 45.74 | 45.66 | 45.67 | 1253.0 |
| 2017-03-19 20:00:00 | CL | Futures | 45.67 | 45.68 | 45.36 | 45.41 | 7569.0 |
| 2017-03-19 21:00:00 | CL | Futures | 45.41 | 45.49 | 45.37 | 45.45 | 3610.0 |
| 2017-03-19 22:00:00 | CL | Futures | 45.45 | 45.52 | 45.45 | 45.51 | 2042.0 |
| 2017-03-19 23:00:00 | CL | Futures | 45.51 | 45.51 | 45.42 | 45.44 | 1672.0 |
| 2017-03-19 18:00:00 | GC | Futures | 1655.1 | 1657.5 | 1654.8 | 1656.7 | 1439.0 |
| 2017-03-19 19:00:00 | GC | Futures | 1656.7 | 1657.8 | 1655.2 | 1657.8 | 2270.0 |
| 2017-03-19 20:00:00 | GC | Futures | 1657.8 | 1658.2 | 1656.5 | 1657.5 | 2774.0 |
| 2017-03-19 21:00:00 | GC | Futures | 1657.4 | 1661.2 | 1657.1 | 1660.9 | 7669.0 |
| 2017-03-19 22:00:00 | GC | Futures | 1660.8 | 1662.4 | 1659.8 | 1661.7 | 6786.0 |
| 2017-03-19 23:00:00 | GC | Futures | 1661.6 | 1662.1 | 1661.2 | 1661.3 | 2236.0 |
| 2017-03-19 18:00:00 | ZN | Futures | 122.756873 | 122.803371 | 122.741373 | 122.756873 | 5782.0 |
| 2017-03-19 19:00:00 | ZN | Futures | 122.772372 | 122.818871 | 122.772372 | 122.803371 | 2571.0 |
| 2017-03-19 20:00:00 | ZN | Futures | 122.818871 | 122.86537 | 122.803371 | 122.834371 | 7168.0 |
| 2017-03-19 21:00:00 | ZN | Futures | 122.834371 | 122.942868 | 122.834371 | 122.896369 | 11587.0 |
| 2017-03-19 22:00:00 | ZN | Futures | 122.896369 | 122.942868 | 122.880869 | 122.896369 | 10101.0 |
| 2017-03-19 23:00:00 | ZN | Futures | 122.911869 | 122.927368 | 122.896369 | 122.911869 | 2028.0 |
> showing 36 of 282 rows — these rows as CSV