PREVIEW / futures_30min / 2013-08-18
file: by_date/futures_30min/2013/2013-08-18.parquet size: 20 KB rows: 490
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-08-18 18:00:00 | ES | Futures | 1707.1 | 1709.17 | 1705.55 | 1706.84 | 6585.0 |
| 2013-08-18 18:30:00 | ES | Futures | 1706.84 | 1707.88 | 1706.58 | 1706.84 | 1838.0 |
| 2013-08-18 19:00:00 | ES | Futures | 1706.84 | 1707.62 | 1706.58 | 1707.36 | 718.0 |
| 2013-08-18 19:30:00 | ES | Futures | 1707.62 | 1708.91 | 1707.1 | 1708.39 | 2481.0 |
| 2013-08-18 20:00:00 | ES | Futures | 1708.65 | 1709.17 | 1708.13 | 1708.39 | 3386.0 |
| 2013-08-18 20:30:00 | ES | Futures | 1708.65 | 1709.17 | 1707.36 | 1707.62 | 1802.0 |
| 2013-08-18 21:00:00 | ES | Futures | 1707.62 | 1708.65 | 1707.36 | 1707.88 | 2146.0 |
| 2013-08-18 21:30:00 | ES | Futures | 1707.88 | 1709.94 | 1707.62 | 1709.43 | 4133.0 |
| 2013-08-18 22:00:00 | ES | Futures | 1709.17 | 1709.68 | 1708.91 | 1709.68 | 2487.0 |
| 2013-08-18 22:30:00 | ES | Futures | 1709.68 | 1709.68 | 1707.62 | 1708.13 | 2207.0 |
| 2013-08-18 23:00:00 | ES | Futures | 1707.88 | 1709.17 | 1707.88 | 1708.65 | 1070.0 |
| 2013-08-18 23:30:00 | ES | Futures | 1708.39 | 1708.65 | 1707.1 | 1707.36 | 1853.0 |
| 2013-08-18 18:00:00 | NQ | Futures | 3586.9 | 3590.7 | 3577.26 | 3586.03 | 760.0 |
| 2013-08-18 18:30:00 | NQ | Futures | 3586.32 | 3588.36 | 3586.03 | 3586.32 | 82.0 |
| 2013-08-18 19:00:00 | NQ | Futures | 3586.32 | 3587.78 | 3586.03 | 3587.78 | 111.0 |
| 2013-08-18 19:30:00 | NQ | Futures | 3587.78 | 3590.12 | 3587.2 | 3589.24 | 178.0 |
| 2013-08-18 20:00:00 | NQ | Futures | 3589.83 | 3591.29 | 3589.24 | 3589.83 | 411.0 |
| 2013-08-18 20:30:00 | NQ | Futures | 3589.83 | 3590.99 | 3588.36 | 3588.36 | 403.0 |
| 2013-08-18 21:00:00 | NQ | Futures | 3588.07 | 3589.53 | 3587.49 | 3588.95 | 266.0 |
| 2013-08-18 21:30:00 | NQ | Futures | 3589.24 | 3593.04 | 3588.36 | 3592.16 | 360.0 |
| 2013-08-18 22:00:00 | NQ | Futures | 3591.87 | 3593.04 | 3590.99 | 3592.46 | 254.0 |
| 2013-08-18 22:30:00 | NQ | Futures | 3592.46 | 3592.75 | 3589.83 | 3590.99 | 303.0 |
| 2013-08-18 23:00:00 | NQ | Futures | 3590.99 | 3592.16 | 3590.41 | 3590.99 | 109.0 |
| 2013-08-18 23:30:00 | NQ | Futures | 3590.99 | 3591.87 | 3588.95 | 3589.53 | 227.0 |
| 2013-08-18 18:00:00 | YM | Futures | 15275.8 | 15293.1 | 15266.7 | 15273.8 | 425.0 |
| 2013-08-18 18:30:00 | YM | Futures | 15274.8 | 15283.0 | 15273.8 | 15275.8 | 254.0 |
| 2013-08-18 19:00:00 | YM | Futures | 15275.8 | 15280.9 | 15274.8 | 15280.9 | 101.0 |
| 2013-08-18 19:30:00 | YM | Futures | 15278.9 | 15289.1 | 15278.9 | 15289.1 | 320.0 |
| 2013-08-18 20:00:00 | YM | Futures | 15289.1 | 15292.1 | 15286.0 | 15286.0 | 575.0 |
| 2013-08-18 20:30:00 | YM | Futures | 15286.0 | 15290.1 | 15280.9 | 15280.9 | 272.0 |
| 2013-08-18 21:00:00 | YM | Futures | 15281.9 | 15286.0 | 15276.9 | 15283.0 | 326.0 |
| 2013-08-18 21:30:00 | YM | Futures | 15283.0 | 15297.2 | 15280.9 | 15293.1 | 567.0 |
| 2013-08-18 22:00:00 | YM | Futures | 15293.1 | 15295.1 | 15290.1 | 15294.1 | 372.0 |
| 2013-08-18 22:30:00 | YM | Futures | 15294.1 | 15294.1 | 15283.0 | 15286.0 | 259.0 |
| 2013-08-18 23:00:00 | YM | Futures | 15286.0 | 15292.1 | 15284.0 | 15287.0 | 107.0 |
| 2013-08-18 23:30:00 | YM | Futures | 15290.1 | 15290.1 | 15278.9 | 15280.9 | 264.0 |
| 2013-08-18 18:00:00 | CL | Futures | 169.82 | 169.87 | 169.02 | 169.11 | 671.0 |
| 2013-08-18 18:30:00 | CL | Futures | 169.13 | 169.24 | 168.95 | 169.05 | 331.0 |
| 2013-08-18 19:00:00 | CL | Futures | 169.03 | 169.21 | 168.81 | 169.18 | 633.0 |
| 2013-08-18 19:30:00 | CL | Futures | 169.18 | 169.4 | 169.18 | 169.25 | 331.0 |
| 2013-08-18 20:00:00 | CL | Futures | 169.29 | 169.38 | 169.13 | 169.14 | 308.0 |
| 2013-08-18 20:30:00 | CL | Futures | 169.16 | 169.38 | 169.14 | 169.35 | 308.0 |
| 2013-08-18 21:00:00 | CL | Futures | 169.33 | 169.38 | 169.16 | 169.19 | 242.0 |
| 2013-08-18 21:30:00 | CL | Futures | 169.18 | 169.52 | 169.1 | 169.4 | 594.0 |
| 2013-08-18 22:00:00 | CL | Futures | 169.38 | 169.46 | 169.33 | 169.38 | 250.0 |
| 2013-08-18 22:30:00 | CL | Futures | 169.4 | 169.43 | 169.19 | 169.25 | 660.0 |
| 2013-08-18 23:00:00 | CL | Futures | 169.24 | 169.48 | 169.18 | 169.46 | 524.0 |
| 2013-08-18 23:30:00 | CL | Futures | 169.43 | 169.51 | 169.37 | 169.38 | 276.0 |
| 2013-08-18 18:00:00 | GC | Futures | 1887.7 | 1892.8 | 1886.2 | 1888.1 | 1901.0 |
| 2013-08-18 18:30:00 | GC | Futures | 1888.0 | 1889.5 | 1885.6 | 1886.2 | 420.0 |
> showing 50 of 490 rows — these rows as CSV