PREVIEW / futures_30min / 2013-07-07
file: by_date/futures_30min/2013/2013-07-07.parquet size: 19 KB rows: 486
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.13 | 1683.32 | 1684.87 | 5139.0 |
| 2013-07-07 18:30:00 | ES | Futures | 1684.87 | 1685.9 | 1684.61 | 1685.64 | 3506.0 |
| 2013-07-07 19:00:00 | ES | Futures | 1685.9 | 1686.42 | 1684.87 | 1686.16 | 5040.0 |
| 2013-07-07 19:30:00 | ES | Futures | 1686.16 | 1686.42 | 1685.64 | 1685.64 | 2026.0 |
| 2013-07-07 20:00:00 | ES | Futures | 1685.9 | 1687.45 | 1685.64 | 1687.2 | 5006.0 |
| 2013-07-07 20:30:00 | ES | Futures | 1687.2 | 1687.45 | 1686.68 | 1687.2 | 1455.0 |
| 2013-07-07 21:00:00 | ES | Futures | 1687.45 | 1687.45 | 1686.42 | 1686.94 | 2909.0 |
| 2013-07-07 21:30:00 | ES | Futures | 1686.94 | 1687.2 | 1683.84 | 1684.09 | 9925.0 |
| 2013-07-07 22:00:00 | ES | Futures | 1684.09 | 1684.61 | 1683.58 | 1684.35 | 4928.0 |
| 2013-07-07 22:30:00 | ES | Futures | 1684.35 | 1685.13 | 1683.58 | 1685.13 | 2166.0 |
| 2013-07-07 23:00:00 | ES | Futures | 1685.13 | 1685.13 | 1684.35 | 1684.87 | 1337.0 |
| 2013-07-07 23:30:00 | ES | Futures | 1685.13 | 1686.68 | 1684.87 | 1685.13 | 2713.0 |
| 2013-07-07 18:00:00 | NQ | Futures | 3461.83 | 3465.92 | 3460.95 | 3464.16 | 357.0 |
| 2013-07-07 18:30:00 | NQ | Futures | 3464.46 | 3467.09 | 3464.16 | 3467.09 | 172.0 |
| 2013-07-07 19:00:00 | NQ | Futures | 3467.09 | 3467.38 | 3465.04 | 3467.09 | 225.0 |
| 2013-07-07 19:30:00 | NQ | Futures | 3467.38 | 3468.26 | 3466.21 | 3467.38 | 181.0 |
| 2013-07-07 20:00:00 | NQ | Futures | 3467.67 | 3471.76 | 3467.09 | 3470.59 | 830.0 |
| 2013-07-07 20:30:00 | NQ | Futures | 3470.89 | 3471.18 | 3470.3 | 3470.89 | 436.0 |
| 2013-07-07 21:00:00 | NQ | Futures | 3470.89 | 3471.18 | 3470.3 | 3471.18 | 313.0 |
| 2013-07-07 21:30:00 | NQ | Futures | 3470.89 | 3471.18 | 3465.04 | 3465.33 | 1235.0 |
| 2013-07-07 22:00:00 | NQ | Futures | 3465.63 | 3466.21 | 3464.16 | 3466.21 | 398.0 |
| 2013-07-07 22:30:00 | NQ | Futures | 3465.92 | 3467.67 | 3464.46 | 3467.09 | 263.0 |
| 2013-07-07 23:00:00 | NQ | Futures | 3467.09 | 3467.09 | 3465.92 | 3466.79 | 84.0 |
| 2013-07-07 23:30:00 | NQ | Futures | 3466.79 | 3470.01 | 3466.79 | 3467.67 | 282.0 |
| 2013-07-07 18:00:00 | YM | Futures | 15316.5 | 15329.7 | 15312.4 | 15327.6 | 337.0 |
| 2013-07-07 18:30:00 | YM | Futures | 15327.6 | 15336.8 | 15327.6 | 15335.8 | 128.0 |
| 2013-07-07 19:00:00 | YM | Futures | 15334.8 | 15339.8 | 15328.7 | 15337.8 | 187.0 |
| 2013-07-07 19:30:00 | YM | Futures | 15336.8 | 15338.8 | 15332.7 | 15335.8 | 158.0 |
| 2013-07-07 20:00:00 | YM | Futures | 15334.8 | 15349.0 | 15333.7 | 15343.9 | 558.0 |
| 2013-07-07 20:30:00 | YM | Futures | 15343.9 | 15345.9 | 15339.8 | 15344.9 | 240.0 |
| 2013-07-07 21:00:00 | YM | Futures | 15344.9 | 15346.9 | 15339.8 | 15341.9 | 479.0 |
| 2013-07-07 21:30:00 | YM | Futures | 15341.9 | 15343.9 | 15319.5 | 15320.5 | 1435.0 |
| 2013-07-07 22:00:00 | YM | Futures | 15319.5 | 15326.6 | 15317.5 | 15326.6 | 499.0 |
| 2013-07-07 22:30:00 | YM | Futures | 15325.6 | 15328.7 | 15316.5 | 15326.6 | 368.0 |
| 2013-07-07 23:00:00 | YM | Futures | 15326.6 | 15328.7 | 15323.6 | 15326.6 | 179.0 |
| 2013-07-07 23:30:00 | YM | Futures | 15326.6 | 15338.8 | 15324.6 | 15326.6 | 513.0 |
| 2013-07-07 18:00:00 | CL | Futures | 162.51 | 162.77 | 161.8 | 162.43 | 2787.0 |
| 2013-07-07 18:30:00 | CL | Futures | 162.43 | 162.51 | 162.32 | 162.33 | 248.0 |
| 2013-07-07 19:00:00 | CL | Futures | 162.35 | 162.46 | 162.19 | 162.26 | 506.0 |
| 2013-07-07 19:30:00 | CL | Futures | 162.27 | 162.35 | 162.15 | 162.18 | 370.0 |
| 2013-07-07 20:00:00 | CL | Futures | 162.18 | 162.23 | 161.99 | 162.04 | 352.0 |
| 2013-07-07 20:30:00 | CL | Futures | 162.02 | 162.07 | 161.68 | 161.72 | 963.0 |
| 2013-07-07 21:00:00 | CL | Futures | 161.72 | 161.88 | 161.57 | 161.83 | 703.0 |
| 2013-07-07 21:30:00 | CL | Futures | 161.83 | 161.85 | 161.46 | 161.54 | 631.0 |
| 2013-07-07 22:00:00 | CL | Futures | 161.54 | 161.83 | 161.54 | 161.77 | 463.0 |
| 2013-07-07 22:30:00 | CL | Futures | 161.76 | 161.91 | 161.6 | 161.85 | 507.0 |
| 2013-07-07 23:00:00 | CL | Futures | 161.88 | 161.91 | 161.79 | 161.82 | 294.0 |
| 2013-07-07 23:30:00 | CL | Futures | 161.83 | 162.08 | 161.82 | 161.91 | 648.0 |
| 2013-07-07 18:00:00 | GC | Futures | 1674.7 | 1685.6 | 1674.3 | 1682.1 | 1859.0 |
| 2013-07-07 18:30:00 | GC | Futures | 1682.3 | 1683.9 | 1678.4 | 1678.7 | 533.0 |
> showing 50 of 486 rows — these rows as CSV