PREVIEW / futures_1hour / 2013-10-20
file: by_date/futures_1hour/2013/2013-10-20.parquet size: 14 KB rows: 263
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-20 18:00:00 | ES | Futures | 1793.34 | 1794.11 | 1791.54 | 1793.34 | 6301.0 |
| 2013-10-20 19:00:00 | ES | Futures | 1793.34 | 1794.37 | 1792.31 | 1794.37 | 2715.0 |
| 2013-10-20 20:00:00 | ES | Futures | 1794.11 | 1795.15 | 1793.08 | 1793.34 | 6032.0 |
| 2013-10-20 21:00:00 | ES | Futures | 1793.34 | 1794.11 | 1792.31 | 1793.34 | 4267.0 |
| 2013-10-20 22:00:00 | ES | Futures | 1793.34 | 1793.6 | 1792.31 | 1792.82 | 1428.0 |
| 2013-10-20 23:00:00 | ES | Futures | 1792.82 | 1794.11 | 1792.82 | 1793.6 | 1522.0 |
| 2013-10-20 18:00:00 | NQ | Futures | 3885.7 | 3887.73 | 3883.08 | 3887.15 | 815.0 |
| 2013-10-20 19:00:00 | NQ | Futures | 3886.86 | 3889.47 | 3885.41 | 3889.47 | 360.0 |
| 2013-10-20 20:00:00 | NQ | Futures | 3889.47 | 3891.21 | 3887.15 | 3887.73 | 612.0 |
| 2013-10-20 21:00:00 | NQ | Futures | 3888.02 | 3888.31 | 3885.41 | 3887.44 | 696.0 |
| 2013-10-20 22:00:00 | NQ | Futures | 3887.15 | 3887.44 | 3885.7 | 3886.57 | 224.0 |
| 2013-10-20 23:00:00 | NQ | Futures | 3886.86 | 3888.31 | 3886.28 | 3887.73 | 259.0 |
| 2013-10-20 18:00:00 | YM | Futures | 15652.7 | 15663.9 | 15643.5 | 15658.8 | 1068.0 |
| 2013-10-20 19:00:00 | YM | Futures | 15657.8 | 15665.9 | 15652.7 | 15665.9 | 329.0 |
| 2013-10-20 20:00:00 | YM | Futures | 15667.0 | 15673.1 | 15658.8 | 15660.8 | 738.0 |
| 2013-10-20 21:00:00 | YM | Futures | 15661.8 | 15667.0 | 15653.7 | 15662.9 | 729.0 |
| 2013-10-20 22:00:00 | YM | Futures | 15662.9 | 15662.9 | 15656.7 | 15659.8 | 371.0 |
| 2013-10-20 23:00:00 | YM | Futures | 15660.8 | 15664.9 | 15658.8 | 15663.9 | 264.0 |
| 2013-10-20 18:00:00 | CL | Futures | 160.54 | 160.64 | 160.37 | 160.61 | 548.0 |
| 2013-10-20 19:00:00 | CL | Futures | 160.59 | 160.59 | 160.46 | 160.58 | 254.0 |
| 2013-10-20 20:00:00 | CL | Futures | 160.58 | 160.77 | 160.5 | 160.67 | 543.0 |
| 2013-10-20 21:00:00 | CL | Futures | 160.67 | 160.85 | 160.51 | 160.78 | 847.0 |
| 2013-10-20 22:00:00 | CL | Futures | 160.77 | 160.8 | 160.56 | 160.65 | 316.0 |
| 2013-10-20 23:00:00 | CL | Futures | 160.64 | 160.72 | 160.58 | 160.59 | 262.0 |
| 2013-10-20 18:00:00 | GC | Futures | 1803.9 | 1804.5 | 1798.4 | 1802.6 | 897.0 |
| 2013-10-20 19:00:00 | GC | Futures | 1802.4 | 1808.5 | 1802.3 | 1805.7 | 800.0 |
| 2013-10-20 20:00:00 | GC | Futures | 1805.7 | 1806.7 | 1802.8 | 1805.3 | 1121.0 |
| 2013-10-20 21:00:00 | GC | Futures | 1805.2 | 1805.6 | 1802.3 | 1804.3 | 2228.0 |
| 2013-10-20 22:00:00 | GC | Futures | 1804.3 | 1808.7 | 1803.7 | 1807.5 | 2526.0 |
| 2013-10-20 23:00:00 | GC | Futures | 1807.4 | 1808.0 | 1805.4 | 1807.1 | 1610.0 |
| 2013-10-20 18:00:00 | ZN | Futures | 115.986013 | 116.014578 | 115.957449 | 115.986013 | 2675.0 |
| 2013-10-20 19:00:00 | ZN | Futures | 115.986013 | 116.014578 | 115.957449 | 116.000296 | 5787.0 |
| 2013-10-20 20:00:00 | ZN | Futures | 116.000296 | 116.000296 | 115.928885 | 115.971731 | 7199.0 |
| 2013-10-20 21:00:00 | ZN | Futures | 115.986013 | 116.057425 | 115.971731 | 116.014578 | 6518.0 |
| 2013-10-20 22:00:00 | ZN | Futures | 116.014578 | 116.02886 | 116.000296 | 116.02886 | 1983.0 |
| 2013-10-20 23:00:00 | ZN | Futures | 116.02886 | 116.02886 | 115.986013 | 116.014578 | 1303.0 |
> showing 36 of 263 rows — these rows as CSV