PREVIEW / futures_1hour / 2013-05-26
file: by_date/futures_1hour/2013/2013-05-26.parquet size: 12 KB rows: 210
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-05-26 18:00:00 | ES | Futures | 1700.06 | 1705.72 | 1700.06 | 1705.21 | 7478.0 |
| 2013-05-26 19:00:00 | ES | Futures | 1705.21 | 1705.21 | 1701.6 | 1702.12 | 5005.0 |
| 2013-05-26 20:00:00 | ES | Futures | 1701.86 | 1703.15 | 1697.74 | 1698.0 | 15409.0 |
| 2013-05-26 21:00:00 | ES | Futures | 1697.74 | 1702.89 | 1696.97 | 1702.37 | 8959.0 |
| 2013-05-26 22:00:00 | ES | Futures | 1702.37 | 1703.41 | 1700.57 | 1701.34 | 2684.0 |
| 2013-05-26 23:00:00 | ES | Futures | 1701.6 | 1702.37 | 1700.57 | 1702.12 | 1464.0 |
| 2013-05-26 18:00:00 | NQ | Futures | 3489.81 | 3505.56 | 3489.81 | 3505.27 | 912.0 |
| 2013-05-26 19:00:00 | NQ | Futures | 3504.97 | 3504.97 | 3499.14 | 3499.14 | 375.0 |
| 2013-05-26 20:00:00 | NQ | Futures | 3499.14 | 3500.6 | 3486.89 | 3486.89 | 2005.0 |
| 2013-05-26 21:00:00 | NQ | Futures | 3486.6 | 3496.22 | 3486.02 | 3495.93 | 1150.0 |
| 2013-05-26 22:00:00 | NQ | Futures | 3495.64 | 3498.56 | 3493.02 | 3495.64 | 496.0 |
| 2013-05-26 23:00:00 | NQ | Futures | 3495.06 | 3497.1 | 3493.02 | 3495.93 | 337.0 |
| 2013-05-26 18:00:00 | YM | Futures | 15472.5 | 15517.0 | 15472.5 | 15514.0 | 675.0 |
| 2013-05-26 19:00:00 | YM | Futures | 15514.0 | 15514.0 | 15487.7 | 15487.7 | 530.0 |
| 2013-05-26 20:00:00 | YM | Futures | 15486.7 | 15493.7 | 15449.3 | 15451.3 | 2145.0 |
| 2013-05-26 21:00:00 | YM | Futures | 15452.3 | 15490.7 | 15446.2 | 15488.7 | 1279.0 |
| 2013-05-26 22:00:00 | YM | Futures | 15487.7 | 15497.8 | 15473.5 | 15482.6 | 631.0 |
| 2013-05-26 23:00:00 | YM | Futures | 15482.6 | 15490.7 | 15473.5 | 15489.7 | 314.0 |
| 2013-05-26 18:00:00 | CL | Futures | 147.1 | 147.1 | 146.48 | 146.62 | 967.0 |
| 2013-05-26 19:00:00 | CL | Futures | 146.63 | 146.66 | 146.49 | 146.59 | 418.0 |
| 2013-05-26 20:00:00 | CL | Futures | 146.55 | 146.6 | 146.07 | 146.15 | 1166.0 |
| 2013-05-26 21:00:00 | CL | Futures | 146.12 | 146.33 | 146.1 | 146.32 | 629.0 |
| 2013-05-26 22:00:00 | CL | Futures | 146.32 | 146.52 | 146.27 | 146.38 | 548.0 |
| 2013-05-26 23:00:00 | CL | Futures | 146.4 | 146.55 | 146.32 | 146.48 | 477.0 |
| 2013-05-26 18:00:00 | GC | Futures | 1902.9 | 1904.4 | 1901.2 | 1901.6 | 209.0 |
| 2013-05-26 19:00:00 | GC | Futures | 1901.4 | 1901.7 | 1898.3 | 1900.7 | 82.0 |
| 2013-05-26 20:00:00 | GC | Futures | 1900.6 | 1901.4 | 1898.1 | 1898.5 | 151.0 |
| 2013-05-26 21:00:00 | GC | Futures | 1898.8 | 1903.9 | 1898.8 | 1902.5 | 201.0 |
| 2013-05-26 22:00:00 | GC | Futures | 1903.5 | 1908.3 | 1903.5 | 1907.3 | 236.0 |
| 2013-05-26 23:00:00 | GC | Futures | 1907.7 | 1910.9 | 1907.3 | 1908.4 | 195.0 |
| 2013-05-26 18:00:00 | ZN | Futures | 117.996065 | 117.996065 | 117.883728 | 117.939896 | 4430.0 |
| 2013-05-26 19:00:00 | ZN | Futures | 117.939896 | 117.982023 | 117.925854 | 117.982023 | 1145.0 |
| 2013-05-26 20:00:00 | ZN | Futures | 117.982023 | 118.080318 | 117.982023 | 118.052233 | 3913.0 |
| 2013-05-26 21:00:00 | ZN | Futures | 118.052233 | 118.052233 | 117.996065 | 118.024149 | 2931.0 |
| 2013-05-26 22:00:00 | ZN | Futures | 118.024149 | 118.052233 | 118.010107 | 118.052233 | 1690.0 |
| 2013-05-26 23:00:00 | ZN | Futures | 118.052233 | 118.080318 | 118.010107 | 118.024149 | 2766.0 |
> showing 36 of 210 rows — these rows as CSV