PREVIEW / futures_1hour / 2013-07-07
file: by_date/futures_1hour/2013/2013-07-07.parquet size: 14 KB rows: 260
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-07 18:00:00 | ES | Futures | 1683.84 | 1685.9 | 1683.32 | 1685.64 | 8645.0 |
| 2013-07-07 19:00:00 | ES | Futures | 1685.9 | 1686.42 | 1684.87 | 1685.64 | 7066.0 |
| 2013-07-07 20:00:00 | ES | Futures | 1685.9 | 1687.45 | 1685.64 | 1687.2 | 6461.0 |
| 2013-07-07 21:00:00 | ES | Futures | 1687.45 | 1687.45 | 1683.84 | 1684.09 | 12834.0 |
| 2013-07-07 22:00:00 | ES | Futures | 1684.09 | 1685.13 | 1683.58 | 1685.13 | 7094.0 |
| 2013-07-07 23:00:00 | ES | Futures | 1685.13 | 1686.68 | 1684.35 | 1685.13 | 4050.0 |
| 2013-07-07 18:00:00 | NQ | Futures | 3461.83 | 3467.09 | 3460.95 | 3467.09 | 529.0 |
| 2013-07-07 19:00:00 | NQ | Futures | 3467.09 | 3468.26 | 3465.04 | 3467.38 | 406.0 |
| 2013-07-07 20:00:00 | NQ | Futures | 3467.67 | 3471.76 | 3467.09 | 3470.89 | 1266.0 |
| 2013-07-07 21:00:00 | NQ | Futures | 3470.89 | 3471.18 | 3465.04 | 3465.33 | 1548.0 |
| 2013-07-07 22:00:00 | NQ | Futures | 3465.63 | 3467.67 | 3464.16 | 3467.09 | 661.0 |
| 2013-07-07 23:00:00 | NQ | Futures | 3467.09 | 3470.01 | 3465.92 | 3467.67 | 366.0 |
| 2013-07-07 18:00:00 | YM | Futures | 15316.5 | 15336.8 | 15312.4 | 15335.8 | 465.0 |
| 2013-07-07 19:00:00 | YM | Futures | 15334.8 | 15339.8 | 15328.7 | 15335.8 | 345.0 |
| 2013-07-07 20:00:00 | YM | Futures | 15334.8 | 15349.0 | 15333.7 | 15344.9 | 798.0 |
| 2013-07-07 21:00:00 | YM | Futures | 15344.9 | 15346.9 | 15319.5 | 15320.5 | 1914.0 |
| 2013-07-07 22:00:00 | YM | Futures | 15319.5 | 15328.7 | 15316.5 | 15326.6 | 867.0 |
| 2013-07-07 23:00:00 | YM | Futures | 15326.6 | 15338.8 | 15323.6 | 15326.6 | 692.0 |
| 2013-07-07 18:00:00 | CL | Futures | 162.51 | 162.77 | 161.8 | 162.33 | 3035.0 |
| 2013-07-07 19:00:00 | CL | Futures | 162.35 | 162.46 | 162.15 | 162.18 | 876.0 |
| 2013-07-07 20:00:00 | CL | Futures | 162.18 | 162.23 | 161.68 | 161.72 | 1315.0 |
| 2013-07-07 21:00:00 | CL | Futures | 161.72 | 161.88 | 161.46 | 161.54 | 1334.0 |
| 2013-07-07 22:00:00 | CL | Futures | 161.54 | 161.91 | 161.54 | 161.85 | 970.0 |
| 2013-07-07 23:00:00 | CL | Futures | 161.88 | 162.08 | 161.79 | 161.91 | 942.0 |
| 2013-07-07 18:00:00 | GC | Futures | 1674.7 | 1685.6 | 1674.3 | 1678.7 | 2392.0 |
| 2013-07-07 19:00:00 | GC | Futures | 1678.6 | 1679.1 | 1668.1 | 1669.8 | 2240.0 |
| 2013-07-07 20:00:00 | GC | Futures | 1669.6 | 1678.7 | 1669.5 | 1676.9 | 2795.0 |
| 2013-07-07 21:00:00 | GC | Futures | 1676.9 | 1677.1 | 1665.5 | 1669.6 | 6553.0 |
| 2013-07-07 22:00:00 | GC | Futures | 1669.5 | 1673.6 | 1667.9 | 1673.2 | 2917.0 |
| 2013-07-07 23:00:00 | GC | Futures | 1673.3 | 1674.4 | 1669.8 | 1670.3 | 1993.0 |
| 2013-07-07 18:00:00 | ZN | Futures | 112.86829 | 112.86829 | 112.698478 | 112.712629 | 8889.0 |
| 2013-07-07 19:00:00 | ZN | Futures | 112.698478 | 112.769233 | 112.684327 | 112.712629 | 6544.0 |
| 2013-07-07 20:00:00 | ZN | Futures | 112.698478 | 112.755082 | 112.627723 | 112.72678 | 11320.0 |
| 2013-07-07 21:00:00 | ZN | Futures | 112.740931 | 112.939045 | 112.72678 | 112.939045 | 17294.0 |
| 2013-07-07 22:00:00 | ZN | Futures | 112.939045 | 112.953196 | 112.882441 | 112.896592 | 6467.0 |
| 2013-07-07 23:00:00 | ZN | Futures | 112.896592 | 112.924894 | 112.86829 | 112.896592 | 4552.0 |
> showing 36 of 260 rows — these rows as CSV