PREVIEW / futures_1hour / 2013-09-22
file: by_date/futures_1hour/2013/2013-09-22.parquet size: 14 KB rows: 254
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-09-22 18:00:00 | ES | Futures | 1760.84 | 1761.1 | 1755.94 | 1758.52 | 13827.0 |
| 2013-09-22 19:00:00 | ES | Futures | 1758.52 | 1758.77 | 1755.68 | 1756.19 | 3072.0 |
| 2013-09-22 20:00:00 | ES | Futures | 1755.94 | 1756.97 | 1755.16 | 1755.94 | 4678.0 |
| 2013-09-22 21:00:00 | ES | Futures | 1755.68 | 1757.48 | 1755.42 | 1757.48 | 6440.0 |
| 2013-09-22 22:00:00 | ES | Futures | 1757.48 | 1758.77 | 1757.48 | 1758.52 | 3469.0 |
| 2013-09-22 23:00:00 | ES | Futures | 1758.26 | 1759.55 | 1758.26 | 1758.77 | 1980.0 |
| 2013-09-22 18:00:00 | NQ | Futures | 3743.97 | 3746.87 | 3736.12 | 3740.77 | 1305.0 |
| 2013-09-22 19:00:00 | NQ | Futures | 3741.06 | 3741.64 | 3736.12 | 3737.58 | 368.0 |
| 2013-09-22 20:00:00 | NQ | Futures | 3737.0 | 3739.9 | 3735.83 | 3737.0 | 609.0 |
| 2013-09-22 21:00:00 | NQ | Futures | 3736.7 | 3742.51 | 3736.41 | 3741.93 | 968.0 |
| 2013-09-22 22:00:00 | NQ | Futures | 3741.93 | 3744.26 | 3741.93 | 3742.8 | 476.0 |
| 2013-09-22 23:00:00 | NQ | Futures | 3743.09 | 3745.13 | 3742.8 | 3743.09 | 327.0 |
| 2013-09-22 18:00:00 | YM | Futures | 15757.8 | 15770.1 | 15729.2 | 15749.7 | 1937.0 |
| 2013-09-22 19:00:00 | YM | Futures | 15749.7 | 15752.7 | 15730.3 | 15732.3 | 415.0 |
| 2013-09-22 20:00:00 | YM | Futures | 15732.3 | 15739.5 | 15727.2 | 15730.3 | 873.0 |
| 2013-09-22 21:00:00 | YM | Futures | 15731.3 | 15748.7 | 15729.2 | 15746.6 | 1211.0 |
| 2013-09-22 22:00:00 | YM | Futures | 15746.6 | 15757.8 | 15746.6 | 15752.7 | 471.0 |
| 2013-09-22 23:00:00 | YM | Futures | 15753.8 | 15761.9 | 15752.7 | 15754.8 | 230.0 |
| 2013-09-22 18:00:00 | CL | Futures | 166.78 | 166.78 | 166.03 | 166.19 | 1603.0 |
| 2013-09-22 19:00:00 | CL | Futures | 166.2 | 166.36 | 166.16 | 166.2 | 368.0 |
| 2013-09-22 20:00:00 | CL | Futures | 166.19 | 166.52 | 166.19 | 166.27 | 655.0 |
| 2013-09-22 21:00:00 | CL | Futures | 166.27 | 166.7 | 166.25 | 166.54 | 1379.0 |
| 2013-09-22 22:00:00 | CL | Futures | 166.54 | 166.65 | 166.36 | 166.38 | 692.0 |
| 2013-09-22 23:00:00 | CL | Futures | 166.38 | 166.58 | 166.38 | 166.57 | 513.0 |
| 2013-09-22 18:00:00 | GC | Futures | 1819.0 | 1821.6 | 1814.3 | 1817.6 | 4280.0 |
| 2013-09-22 19:00:00 | GC | Futures | 1817.8 | 1824.2 | 1817.5 | 1822.7 | 2131.0 |
| 2013-09-22 20:00:00 | GC | Futures | 1822.6 | 1822.7 | 1811.7 | 1811.7 | 2659.0 |
| 2013-09-22 21:00:00 | GC | Futures | 1811.6 | 1811.7 | 1800.4 | 1809.4 | 8738.0 |
| 2013-09-22 22:00:00 | GC | Futures | 1809.3 | 1813.4 | 1807.2 | 1811.1 | 2682.0 |
| 2013-09-22 23:00:00 | GC | Futures | 1810.9 | 1811.9 | 1808.6 | 1811.2 | 1079.0 |
| 2013-09-22 18:00:00 | ZN | Futures | 114.500661 | 114.55779 | 114.486379 | 114.55779 | 1644.0 |
| 2013-09-22 19:00:00 | ZN | Futures | 114.55779 | 114.614919 | 114.55779 | 114.600637 | 2190.0 |
| 2013-09-22 20:00:00 | ZN | Futures | 114.614919 | 114.643484 | 114.586355 | 114.643484 | 3221.0 |
| 2013-09-22 21:00:00 | ZN | Futures | 114.629201 | 114.643484 | 114.572072 | 114.586355 | 6154.0 |
| 2013-09-22 22:00:00 | ZN | Futures | 114.586355 | 114.614919 | 114.572072 | 114.614919 | 2019.0 |
| 2013-09-22 23:00:00 | ZN | Futures | 114.614919 | 114.614919 | 114.572072 | 114.614919 | 1871.0 |
> showing 36 of 254 rows — these rows as CSV