PREVIEW / futures_1hour / 2016-07-10
file: by_date/futures_1hour/2016/2016-07-10.parquet size: 15 KB rows: 291
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-07-10 18:00:00 | ES | Futures | 2299.93 | 2300.47 | 2299.66 | 2300.2 | 7690.0 |
| 2016-07-10 19:00:00 | ES | Futures | 2300.2 | 2302.1 | 2299.66 | 2301.83 | 4037.0 |
| 2016-07-10 20:00:00 | ES | Futures | 2301.56 | 2303.73 | 2301.56 | 2303.46 | 9758.0 |
| 2016-07-10 21:00:00 | ES | Futures | 2303.46 | 2304.81 | 2302.37 | 2302.37 | 7654.0 |
| 2016-07-10 22:00:00 | ES | Futures | 2302.64 | 2313.76 | 2302.37 | 2311.59 | 22666.0 |
| 2016-07-10 23:00:00 | ES | Futures | 2311.59 | 2311.86 | 2308.34 | 2308.88 | 7116.0 |
| 2016-07-10 18:00:00 | NQ | Futures | 5388.18 | 5388.18 | 5383.71 | 5385.79 | 703.0 |
| 2016-07-10 19:00:00 | NQ | Futures | 5385.2 | 5390.26 | 5384.9 | 5389.07 | 373.0 |
| 2016-07-10 20:00:00 | NQ | Futures | 5389.37 | 5396.82 | 5389.37 | 5395.03 | 1077.0 |
| 2016-07-10 21:00:00 | NQ | Futures | 5395.33 | 5399.5 | 5392.35 | 5393.54 | 1128.0 |
| 2016-07-10 22:00:00 | NQ | Futures | 5393.54 | 5417.98 | 5393.24 | 5414.7 | 2589.0 |
| 2016-07-10 23:00:00 | NQ | Futures | 5414.7 | 5415.6 | 5407.85 | 5408.44 | 892.0 |
| 2016-07-10 18:00:00 | YM | Futures | 19419.0 | 19423.3 | 19407.2 | 19409.4 | 665.0 |
| 2016-07-10 19:00:00 | YM | Futures | 19409.4 | 19427.7 | 19409.4 | 19424.4 | 550.0 |
| 2016-07-10 20:00:00 | YM | Futures | 19423.3 | 19447.0 | 19423.3 | 19442.7 | 1631.0 |
| 2016-07-10 21:00:00 | YM | Futures | 19443.8 | 19456.7 | 19437.3 | 19440.6 | 1670.0 |
| 2016-07-10 22:00:00 | YM | Futures | 19439.5 | 19522.4 | 19438.4 | 19510.5 | 4495.0 |
| 2016-07-10 23:00:00 | YM | Futures | 19510.5 | 19513.7 | 19484.7 | 19492.2 | 1379.0 |
| 2016-07-10 18:00:00 | CL | Futures | 47.19 | 47.42 | 46.99 | 47.33 | 3647.0 |
| 2016-07-10 19:00:00 | CL | Futures | 47.32 | 47.34 | 47.04 | 47.19 | 2120.0 |
| 2016-07-10 20:00:00 | CL | Futures | 47.19 | 47.28 | 47.07 | 47.1 | 1650.0 |
| 2016-07-10 21:00:00 | CL | Futures | 47.1 | 47.24 | 46.99 | 47.02 | 3522.0 |
| 2016-07-10 22:00:00 | CL | Futures | 47.02 | 47.1 | 46.91 | 47.05 | 4217.0 |
| 2016-07-10 23:00:00 | CL | Futures | 47.05 | 47.17 | 47.05 | 47.14 | 1380.0 |
| 2016-07-10 18:00:00 | GC | Futures | 1862.9 | 1873.2 | 1861.9 | 1870.1 | 5850.0 |
| 2016-07-10 19:00:00 | GC | Futures | 1870.1 | 1870.2 | 1865.6 | 1866.2 | 3026.0 |
| 2016-07-10 20:00:00 | GC | Futures | 1866.2 | 1867.1 | 1859.1 | 1859.6 | 6786.0 |
| 2016-07-10 21:00:00 | GC | Futures | 1859.5 | 1868.2 | 1856.9 | 1865.8 | 12331.0 |
| 2016-07-10 22:00:00 | GC | Futures | 1865.8 | 1867.3 | 1863.7 | 1865.5 | 5225.0 |
| 2016-07-10 23:00:00 | GC | Futures | 1865.4 | 1866.3 | 1863.6 | 1864.4 | 2315.0 |
| 2016-07-10 18:00:00 | ZN | Futures | 130.348893 | 130.379323 | 130.242386 | 130.272817 | 5327.0 |
| 2016-07-10 19:00:00 | ZN | Futures | 130.272817 | 130.333678 | 130.257601 | 130.272817 | 4388.0 |
| 2016-07-10 20:00:00 | ZN | Futures | 130.272817 | 130.272817 | 130.181525 | 130.196741 | 10110.0 |
| 2016-07-10 21:00:00 | ZN | Futures | 130.196741 | 130.257601 | 130.196741 | 130.242386 | 6274.0 |
| 2016-07-10 22:00:00 | ZN | Futures | 130.227171 | 130.257601 | 130.196741 | 130.211956 | 7505.0 |
| 2016-07-10 23:00:00 | ZN | Futures | 130.211956 | 130.303247 | 130.211956 | 130.272817 | 6658.0 |
> showing 36 of 291 rows — these rows as CSV