PREVIEW / futures_30min / 2013-04-21
file: by_date/futures_30min/2013/2013-04-21.parquet size: 20 KB rows: 513
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-04-21 18:00:00 | ES | Futures | 1595.48 | 1599.08 | 1595.22 | 1597.28 | 6941.0 |
| 2013-04-21 18:30:00 | ES | Futures | 1597.02 | 1598.05 | 1597.02 | 1597.54 | 1680.0 |
| 2013-04-21 19:00:00 | ES | Futures | 1597.54 | 1598.05 | 1597.54 | 1598.05 | 1241.0 |
| 2013-04-21 19:30:00 | ES | Futures | 1597.8 | 1598.57 | 1597.02 | 1597.8 | 3192.0 |
| 2013-04-21 20:00:00 | ES | Futures | 1597.8 | 1598.31 | 1597.28 | 1597.54 | 1637.0 |
| 2013-04-21 20:30:00 | ES | Futures | 1597.54 | 1599.86 | 1597.54 | 1599.6 | 5053.0 |
| 2013-04-21 21:00:00 | ES | Futures | 1599.34 | 1601.66 | 1598.83 | 1601.4 | 6407.0 |
| 2013-04-21 21:30:00 | ES | Futures | 1601.66 | 1604.75 | 1601.14 | 1601.66 | 10411.0 |
| 2013-04-21 22:00:00 | ES | Futures | 1601.66 | 1602.17 | 1601.14 | 1601.66 | 1775.0 |
| 2013-04-21 22:30:00 | ES | Futures | 1601.66 | 1602.17 | 1600.63 | 1601.66 | 2017.0 |
| 2013-04-21 23:00:00 | ES | Futures | 1601.66 | 1602.69 | 1601.14 | 1602.43 | 1975.0 |
| 2013-04-21 23:30:00 | ES | Futures | 1602.43 | 1603.98 | 1602.43 | 1603.72 | 2463.0 |
| 2013-04-21 18:00:00 | NQ | Futures | 3234.6 | 3241.01 | 3232.56 | 3238.68 | 732.0 |
| 2013-04-21 18:30:00 | NQ | Futures | 3238.39 | 3240.72 | 3238.39 | 3239.56 | 260.0 |
| 2013-04-21 19:00:00 | NQ | Futures | 3239.26 | 3240.14 | 3238.97 | 3239.85 | 60.0 |
| 2013-04-21 19:30:00 | NQ | Futures | 3240.14 | 3240.72 | 3237.81 | 3238.68 | 181.0 |
| 2013-04-21 20:00:00 | NQ | Futures | 3238.97 | 3240.14 | 3238.1 | 3239.26 | 274.0 |
| 2013-04-21 20:30:00 | NQ | Futures | 3239.26 | 3244.22 | 3238.97 | 3243.93 | 511.0 |
| 2013-04-21 21:00:00 | NQ | Futures | 3243.93 | 3248.01 | 3242.18 | 3247.43 | 626.0 |
| 2013-04-21 21:30:00 | NQ | Futures | 3247.43 | 3251.51 | 3246.26 | 3246.56 | 922.0 |
| 2013-04-21 22:00:00 | NQ | Futures | 3246.26 | 3247.43 | 3245.68 | 3247.14 | 245.0 |
| 2013-04-21 22:30:00 | NQ | Futures | 3247.43 | 3248.6 | 3244.81 | 3246.56 | 143.0 |
| 2013-04-21 23:00:00 | NQ | Futures | 3246.85 | 3248.31 | 3245.97 | 3247.72 | 124.0 |
| 2013-04-21 23:30:00 | NQ | Futures | 3248.01 | 3250.64 | 3248.01 | 3250.06 | 141.0 |
| 2013-04-21 18:00:00 | YM | Futures | 14633.4 | 14660.7 | 14633.4 | 14647.6 | 380.0 |
| 2013-04-21 18:30:00 | YM | Futures | 14647.6 | 14656.7 | 14647.6 | 14654.7 | 96.0 |
| 2013-04-21 19:00:00 | YM | Futures | 14654.7 | 14657.7 | 14651.6 | 14656.7 | 93.0 |
| 2013-04-21 19:30:00 | YM | Futures | 14657.7 | 14660.7 | 14648.6 | 14656.7 | 138.0 |
| 2013-04-21 20:00:00 | YM | Futures | 14657.7 | 14659.7 | 14652.6 | 14652.6 | 283.0 |
| 2013-04-21 20:30:00 | YM | Futures | 14652.6 | 14672.9 | 14651.6 | 14669.8 | 522.0 |
| 2013-04-21 21:00:00 | YM | Futures | 14669.8 | 14688.0 | 14665.8 | 14688.0 | 658.0 |
| 2013-04-21 21:30:00 | YM | Futures | 14688.0 | 14709.3 | 14683.0 | 14688.0 | 1099.0 |
| 2013-04-21 22:00:00 | YM | Futures | 14687.0 | 14690.0 | 14684.0 | 14689.0 | 266.0 |
| 2013-04-21 22:30:00 | YM | Futures | 14689.0 | 14692.1 | 14680.9 | 14687.0 | 284.0 |
| 2013-04-21 23:00:00 | YM | Futures | 14686.0 | 14693.1 | 14685.0 | 14691.1 | 177.0 |
| 2013-04-21 23:30:00 | YM | Futures | 14692.1 | 14704.2 | 14692.1 | 14702.2 | 217.0 |
| 2013-04-21 18:00:00 | CL | Futures | 138.51 | 138.71 | 138.43 | 138.57 | 314.0 |
| 2013-04-21 18:30:00 | CL | Futures | 138.55 | 138.84 | 138.55 | 138.74 | 145.0 |
| 2013-04-21 19:00:00 | CL | Futures | 138.73 | 138.82 | 138.66 | 138.66 | 77.0 |
| 2013-04-21 19:30:00 | CL | Futures | 138.68 | 138.77 | 138.52 | 138.55 | 181.0 |
| 2013-04-21 20:00:00 | CL | Futures | 138.55 | 138.68 | 138.52 | 138.54 | 272.0 |
| 2013-04-21 20:30:00 | CL | Futures | 138.52 | 138.84 | 138.44 | 138.77 | 483.0 |
| 2013-04-21 21:00:00 | CL | Futures | 138.79 | 139.02 | 138.62 | 138.96 | 692.0 |
| 2013-04-21 21:30:00 | CL | Futures | 138.98 | 139.18 | 138.95 | 139.01 | 675.0 |
| 2013-04-21 22:00:00 | CL | Futures | 139.02 | 139.17 | 139.02 | 139.15 | 397.0 |
| 2013-04-21 22:30:00 | CL | Futures | 139.17 | 139.45 | 139.17 | 139.37 | 710.0 |
| 2013-04-21 23:00:00 | CL | Futures | 139.39 | 139.39 | 139.2 | 139.26 | 178.0 |
| 2013-04-21 23:30:00 | CL | Futures | 139.28 | 139.35 | 139.24 | 139.34 | 199.0 |
| 2013-04-21 18:00:00 | GC | Futures | 1934.2 | 1934.7 | 1928.3 | 1933.7 | 1915.0 |
| 2013-04-21 18:30:00 | GC | Futures | 1933.7 | 1934.8 | 1931.8 | 1932.2 | 727.0 |
> showing 50 of 513 rows — these rows as CSV