PREVIEW / futures_30min / 2013-05-19
file: by_date/futures_30min/2013/2013-05-19.parquet size: 20 KB rows: 506
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-19 18:00:00 | ES | Futures | 1712.94 | 1713.45 | 1711.65 | 1712.94 | 6131.0 |
| 2013-05-19 18:30:00 | ES | Futures | 1712.94 | 1714.22 | 1712.68 | 1713.97 | 1742.0 |
| 2013-05-19 19:00:00 | ES | Futures | 1713.71 | 1714.48 | 1713.71 | 1714.22 | 644.0 |
| 2013-05-19 19:30:00 | ES | Futures | 1713.97 | 1713.97 | 1712.94 | 1713.19 | 1807.0 |
| 2013-05-19 20:00:00 | ES | Futures | 1713.19 | 1713.71 | 1712.42 | 1713.19 | 2099.0 |
| 2013-05-19 20:30:00 | ES | Futures | 1713.19 | 1713.45 | 1712.68 | 1712.94 | 1618.0 |
| 2013-05-19 21:00:00 | ES | Futures | 1712.68 | 1714.22 | 1712.68 | 1713.71 | 2494.0 |
| 2013-05-19 21:30:00 | ES | Futures | 1713.71 | 1715.0 | 1713.45 | 1713.97 | 4273.0 |
| 2013-05-19 22:00:00 | ES | Futures | 1714.22 | 1714.74 | 1713.45 | 1713.97 | 2280.0 |
| 2013-05-19 22:30:00 | ES | Futures | 1713.97 | 1714.74 | 1713.97 | 1713.97 | 1224.0 |
| 2013-05-19 23:00:00 | ES | Futures | 1713.97 | 1714.74 | 1713.97 | 1713.97 | 1350.0 |
| 2013-05-19 23:30:00 | ES | Futures | 1714.22 | 1714.74 | 1711.91 | 1713.45 | 10743.0 |
| 2013-05-19 18:00:00 | NQ | Futures | 3524.81 | 3525.1 | 3521.6 | 3523.93 | 1647.0 |
| 2013-05-19 18:30:00 | NQ | Futures | 3523.93 | 3527.14 | 3523.93 | 3526.85 | 241.0 |
| 2013-05-19 19:00:00 | NQ | Futures | 3526.56 | 3527.72 | 3525.97 | 3527.14 | 114.0 |
| 2013-05-19 19:30:00 | NQ | Futures | 3526.85 | 3527.14 | 3523.64 | 3523.93 | 441.0 |
| 2013-05-19 20:00:00 | NQ | Futures | 3523.93 | 3525.1 | 3522.18 | 3524.52 | 631.0 |
| 2013-05-19 20:30:00 | NQ | Futures | 3524.52 | 3524.81 | 3523.06 | 3523.06 | 370.0 |
| 2013-05-19 21:00:00 | NQ | Futures | 3522.77 | 3526.56 | 3522.77 | 3525.97 | 325.0 |
| 2013-05-19 21:30:00 | NQ | Futures | 3525.97 | 3529.18 | 3525.39 | 3528.02 | 769.0 |
| 2013-05-19 22:00:00 | NQ | Futures | 3527.72 | 3528.02 | 3526.27 | 3526.27 | 487.0 |
| 2013-05-19 22:30:00 | NQ | Futures | 3526.85 | 3527.72 | 3526.27 | 3527.14 | 212.0 |
| 2013-05-19 23:00:00 | NQ | Futures | 3526.56 | 3528.31 | 3526.56 | 3526.56 | 86.0 |
| 2013-05-19 23:30:00 | NQ | Futures | 3526.56 | 3528.31 | 3523.06 | 3525.39 | 897.0 |
| 2013-05-19 18:00:00 | YM | Futures | 15468.5 | 15474.5 | 15459.4 | 15470.5 | 964.0 |
| 2013-05-19 18:30:00 | YM | Futures | 15471.5 | 15484.6 | 15471.5 | 15480.6 | 365.0 |
| 2013-05-19 19:00:00 | YM | Futures | 15480.6 | 15486.7 | 15480.6 | 15486.7 | 140.0 |
| 2013-05-19 19:30:00 | YM | Futures | 15485.7 | 15485.7 | 15477.6 | 15479.6 | 299.0 |
| 2013-05-19 20:00:00 | YM | Futures | 15479.6 | 15483.6 | 15473.5 | 15480.6 | 301.0 |
| 2013-05-19 20:30:00 | YM | Futures | 15481.6 | 15483.6 | 15476.6 | 15477.6 | 394.0 |
| 2013-05-19 21:00:00 | YM | Futures | 15477.6 | 15486.7 | 15476.6 | 15484.6 | 232.0 |
| 2013-05-19 21:30:00 | YM | Futures | 15484.6 | 15492.7 | 15482.6 | 15488.7 | 440.0 |
| 2013-05-19 22:00:00 | YM | Futures | 15488.7 | 15490.7 | 15483.6 | 15487.7 | 272.0 |
| 2013-05-19 22:30:00 | YM | Futures | 15486.7 | 15491.7 | 15486.7 | 15487.7 | 239.0 |
| 2013-05-19 23:00:00 | YM | Futures | 15487.7 | 15492.7 | 15487.7 | 15487.7 | 241.0 |
| 2013-05-19 23:30:00 | YM | Futures | 15487.7 | 15491.7 | 15471.5 | 15482.6 | 829.0 |
| 2013-05-19 18:00:00 | CL | Futures | 150.8 | 151.27 | 150.08 | 150.5 | 1274.0 |
| 2013-05-19 18:30:00 | CL | Futures | 150.5 | 150.58 | 150.39 | 150.52 | 382.0 |
| 2013-05-19 19:00:00 | CL | Futures | 150.52 | 150.85 | 150.46 | 150.75 | 540.0 |
| 2013-05-19 19:30:00 | CL | Futures | 150.72 | 150.75 | 150.52 | 150.63 | 238.0 |
| 2013-05-19 20:00:00 | CL | Futures | 150.63 | 150.94 | 150.58 | 150.83 | 505.0 |
| 2013-05-19 20:30:00 | CL | Futures | 150.83 | 151.04 | 150.83 | 150.91 | 395.0 |
| 2013-05-19 21:00:00 | CL | Futures | 150.91 | 151.0 | 150.69 | 150.74 | 468.0 |
| 2013-05-19 21:30:00 | CL | Futures | 150.75 | 150.82 | 150.72 | 150.78 | 258.0 |
| 2013-05-19 22:00:00 | CL | Futures | 150.78 | 150.86 | 150.77 | 150.83 | 118.0 |
| 2013-05-19 22:30:00 | CL | Futures | 150.85 | 150.85 | 150.78 | 150.82 | 78.0 |
| 2013-05-19 23:00:00 | CL | Futures | 150.8 | 150.83 | 150.61 | 150.69 | 410.0 |
| 2013-05-19 23:30:00 | CL | Futures | 150.67 | 150.86 | 150.58 | 150.82 | 376.0 |
| 2013-05-19 18:00:00 | GC | Futures | 1869.7 | 1873.4 | 1850.9 | 1854.3 | 8510.0 |
| 2013-05-19 18:30:00 | GC | Futures | 1854.0 | 1854.2 | 1836.5 | 1843.1 | 6438.0 |
> showing 50 of 506 rows — these rows as CSV