PREVIEW / futures_1hour / 2013-07-28
file: by_date/futures_1hour/2013/2013-07-28.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 |
|---|---|---|---|---|---|---|---|
| 2013-07-28 18:00:00 | ES | Futures | 1743.81 | 1745.36 | 1743.29 | 1744.84 | 3890.0 |
| 2013-07-28 19:00:00 | ES | Futures | 1744.84 | 1744.84 | 1743.55 | 1744.06 | 2101.0 |
| 2013-07-28 20:00:00 | ES | Futures | 1743.81 | 1744.84 | 1743.55 | 1744.32 | 4063.0 |
| 2013-07-28 21:00:00 | ES | Futures | 1744.32 | 1744.58 | 1742.0 | 1742.51 | 5350.0 |
| 2013-07-28 22:00:00 | ES | Futures | 1742.26 | 1743.55 | 1741.22 | 1742.0 | 4528.0 |
| 2013-07-28 23:00:00 | ES | Futures | 1742.0 | 1742.26 | 1739.41 | 1739.93 | 6585.0 |
| 2013-07-28 18:00:00 | NQ | Futures | 3588.66 | 3592.75 | 3588.66 | 3592.16 | 522.0 |
| 2013-07-28 19:00:00 | NQ | Futures | 3592.46 | 3592.46 | 3589.53 | 3589.83 | 209.0 |
| 2013-07-28 20:00:00 | NQ | Futures | 3589.83 | 3591.58 | 3588.66 | 3591.58 | 813.0 |
| 2013-07-28 21:00:00 | NQ | Futures | 3591.58 | 3591.58 | 3587.2 | 3587.49 | 803.0 |
| 2013-07-28 22:00:00 | NQ | Futures | 3588.07 | 3590.99 | 3586.03 | 3587.49 | 791.0 |
| 2013-07-28 23:00:00 | NQ | Futures | 3587.78 | 3587.78 | 3582.81 | 3583.69 | 700.0 |
| 2013-07-28 18:00:00 | YM | Futures | 15736.0 | 15748.1 | 15732.9 | 15745.1 | 429.0 |
| 2013-07-28 19:00:00 | YM | Futures | 15745.1 | 15746.1 | 15734.9 | 15736.0 | 363.0 |
| 2013-07-28 20:00:00 | YM | Futures | 15736.0 | 15744.1 | 15732.9 | 15744.1 | 733.0 |
| 2013-07-28 21:00:00 | YM | Futures | 15742.0 | 15743.1 | 15724.8 | 15726.8 | 1047.0 |
| 2013-07-28 22:00:00 | YM | Futures | 15726.8 | 15737.0 | 15719.7 | 15727.8 | 1004.0 |
| 2013-07-28 23:00:00 | YM | Futures | 15728.8 | 15728.8 | 15708.5 | 15709.5 | 1074.0 |
| 2013-07-28 18:00:00 | CL | Futures | 164.44 | 164.88 | 163.95 | 164.39 | 1633.0 |
| 2013-07-28 19:00:00 | CL | Futures | 164.39 | 164.51 | 164.29 | 164.33 | 451.0 |
| 2013-07-28 20:00:00 | CL | Futures | 164.36 | 164.61 | 164.31 | 164.56 | 630.0 |
| 2013-07-28 21:00:00 | CL | Futures | 164.56 | 164.61 | 164.23 | 164.25 | 922.0 |
| 2013-07-28 22:00:00 | CL | Futures | 164.23 | 164.26 | 164.01 | 164.14 | 947.0 |
| 2013-07-28 23:00:00 | CL | Futures | 164.14 | 164.22 | 163.89 | 163.9 | 834.0 |
| 2013-07-28 18:00:00 | GC | Futures | 1827.9 | 1830.0 | 1827.2 | 1827.4 | 487.0 |
| 2013-07-28 19:00:00 | GC | Futures | 1827.5 | 1827.5 | 1823.8 | 1824.5 | 382.0 |
| 2013-07-28 20:00:00 | GC | Futures | 1824.5 | 1824.6 | 1820.4 | 1820.5 | 789.0 |
| 2013-07-28 21:00:00 | GC | Futures | 1820.8 | 1823.1 | 1816.4 | 1818.3 | 1504.0 |
| 2013-07-28 22:00:00 | GC | Futures | 1818.6 | 1822.7 | 1817.8 | 1821.6 | 667.0 |
| 2013-07-28 23:00:00 | GC | Futures | 1821.5 | 1822.3 | 1816.8 | 1818.9 | 1142.0 |
| 2013-07-28 18:00:00 | ZN | Futures | 114.679616 | 114.722069 | 114.679616 | 114.707918 | 2290.0 |
| 2013-07-28 19:00:00 | ZN | Futures | 114.693767 | 114.750371 | 114.693767 | 114.73622 | 1144.0 |
| 2013-07-28 20:00:00 | ZN | Futures | 114.73622 | 114.73622 | 114.693767 | 114.722069 | 2840.0 |
| 2013-07-28 21:00:00 | ZN | Futures | 114.722069 | 114.764522 | 114.679616 | 114.750371 | 4032.0 |
| 2013-07-28 22:00:00 | ZN | Futures | 114.750371 | 114.778673 | 114.73622 | 114.750371 | 3192.0 |
| 2013-07-28 23:00:00 | ZN | Futures | 114.750371 | 114.778673 | 114.750371 | 114.750371 | 2757.0 |
> showing 36 of 270 rows — these rows as CSV