PREVIEW / futures_30min / 2013-06-16
file: by_date/futures_30min/2013/2013-06-16.parquet size: 19 KB rows: 482
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-06-16 18:00:00 | ES | Futures | 1673.75 | 1676.08 | 1672.98 | 1675.56 | 5619.0 |
| 2013-06-16 18:30:00 | ES | Futures | 1675.82 | 1676.6 | 1675.05 | 1675.3 | 1214.0 |
| 2013-06-16 19:00:00 | ES | Futures | 1675.3 | 1676.08 | 1675.3 | 1675.56 | 620.0 |
| 2013-06-16 19:30:00 | ES | Futures | 1675.56 | 1677.63 | 1675.3 | 1677.11 | 2390.0 |
| 2013-06-16 20:00:00 | ES | Futures | 1677.11 | 1679.44 | 1676.34 | 1677.63 | 6850.0 |
| 2013-06-16 20:30:00 | ES | Futures | 1677.63 | 1678.67 | 1677.63 | 1677.89 | 2840.0 |
| 2013-06-16 21:00:00 | ES | Futures | 1678.15 | 1679.7 | 1677.89 | 1679.18 | 3188.0 |
| 2013-06-16 21:30:00 | ES | Futures | 1679.18 | 1680.47 | 1678.67 | 1679.96 | 3600.0 |
| 2013-06-16 22:00:00 | ES | Futures | 1679.96 | 1680.73 | 1679.18 | 1679.7 | 1950.0 |
| 2013-06-16 22:30:00 | ES | Futures | 1679.7 | 1680.47 | 1678.92 | 1679.96 | 883.0 |
| 2013-06-16 23:00:00 | ES | Futures | 1679.96 | 1680.47 | 1679.7 | 1680.22 | 845.0 |
| 2013-06-16 23:30:00 | ES | Futures | 1680.47 | 1680.73 | 1678.41 | 1680.47 | 2660.0 |
| 2013-06-16 18:00:00 | NQ | Futures | 3432.6 | 3438.74 | 3432.31 | 3438.15 | 223.0 |
| 2013-06-16 18:30:00 | NQ | Futures | 3438.45 | 3439.03 | 3436.69 | 3437.28 | 78.0 |
| 2013-06-16 19:00:00 | NQ | Futures | 3437.86 | 3441.95 | 3437.86 | 3438.15 | 568.0 |
| 2013-06-16 19:30:00 | NQ | Futures | 3438.74 | 3441.95 | 3438.15 | 3441.37 | 125.0 |
| 2013-06-16 20:00:00 | NQ | Futures | 3441.37 | 3446.34 | 3440.2 | 3443.42 | 468.0 |
| 2013-06-16 20:30:00 | NQ | Futures | 3443.42 | 3445.17 | 3443.12 | 3444.0 | 315.0 |
| 2013-06-16 21:00:00 | NQ | Futures | 3444.0 | 3446.92 | 3443.71 | 3446.92 | 183.0 |
| 2013-06-16 21:30:00 | NQ | Futures | 3446.92 | 3448.38 | 3445.46 | 3447.51 | 273.0 |
| 2013-06-16 22:00:00 | NQ | Futures | 3447.8 | 3448.09 | 3446.05 | 3447.21 | 91.0 |
| 2013-06-16 22:30:00 | NQ | Futures | 3447.21 | 3448.09 | 3445.75 | 3447.21 | 84.0 |
| 2013-06-16 23:00:00 | NQ | Futures | 3447.21 | 3448.38 | 3447.21 | 3448.09 | 104.0 |
| 2013-06-16 23:30:00 | NQ | Futures | 3448.09 | 3448.97 | 3444.88 | 3448.09 | 230.0 |
| 2013-06-16 18:00:00 | YM | Futures | 15227.1 | 15245.4 | 15221.0 | 15240.3 | 217.0 |
| 2013-06-16 18:30:00 | YM | Futures | 15240.3 | 15245.4 | 15237.3 | 15238.3 | 169.0 |
| 2013-06-16 19:00:00 | YM | Futures | 15239.3 | 15244.4 | 15238.3 | 15238.3 | 74.0 |
| 2013-06-16 19:30:00 | YM | Futures | 15241.3 | 15255.5 | 15238.3 | 15254.5 | 160.0 |
| 2013-06-16 20:00:00 | YM | Futures | 15253.5 | 15270.8 | 15245.4 | 15260.6 | 457.0 |
| 2013-06-16 20:30:00 | YM | Futures | 15260.6 | 15266.7 | 15258.6 | 15261.6 | 295.0 |
| 2013-06-16 21:00:00 | YM | Futures | 15262.6 | 15275.8 | 15261.6 | 15274.8 | 398.0 |
| 2013-06-16 21:30:00 | YM | Futures | 15274.8 | 15284.0 | 15268.7 | 15281.9 | 469.0 |
| 2013-06-16 22:00:00 | YM | Futures | 15281.9 | 15283.0 | 15272.8 | 15278.9 | 293.0 |
| 2013-06-16 22:30:00 | YM | Futures | 15279.9 | 15281.9 | 15273.8 | 15277.9 | 114.0 |
| 2013-06-16 23:00:00 | YM | Futures | 15279.9 | 15284.0 | 15277.9 | 15281.9 | 183.0 |
| 2013-06-16 23:30:00 | YM | Futures | 15283.0 | 15286.0 | 15266.7 | 15281.9 | 318.0 |
| 2013-06-16 18:00:00 | CL | Futures | 153.47 | 153.47 | 153.14 | 153.27 | 241.0 |
| 2013-06-16 18:30:00 | CL | Futures | 153.22 | 153.25 | 153.11 | 153.17 | 57.0 |
| 2013-06-16 19:00:00 | CL | Futures | 153.14 | 153.25 | 153.0 | 153.1 | 196.0 |
| 2013-06-16 19:30:00 | CL | Futures | 153.08 | 153.11 | 152.99 | 153.06 | 60.0 |
| 2013-06-16 20:00:00 | CL | Futures | 153.1 | 153.11 | 152.88 | 152.91 | 154.0 |
| 2013-06-16 20:30:00 | CL | Futures | 152.91 | 153.02 | 152.88 | 152.99 | 126.0 |
| 2013-06-16 21:00:00 | CL | Futures | 153.0 | 153.11 | 152.97 | 153.06 | 210.0 |
| 2013-06-16 21:30:00 | CL | Futures | 153.08 | 153.17 | 152.91 | 153.1 | 147.0 |
| 2013-06-16 22:00:00 | CL | Futures | 153.08 | 153.08 | 152.83 | 152.95 | 88.0 |
| 2013-06-16 22:30:00 | CL | Futures | 152.95 | 152.95 | 152.77 | 152.86 | 110.0 |
| 2013-06-16 23:00:00 | CL | Futures | 152.86 | 152.91 | 152.8 | 152.91 | 40.0 |
| 2013-06-16 23:30:00 | CL | Futures | 152.94 | 153.02 | 152.89 | 153.0 | 51.0 |
| 2013-06-16 18:00:00 | GC | Futures | 1906.5 | 1907.7 | 1904.3 | 1905.7 | 480.0 |
| 2013-06-16 18:30:00 | GC | Futures | 1905.4 | 1906.6 | 1905.1 | 1905.1 | 119.0 |
> showing 50 of 482 rows — these rows as CSV