PREVIEW / futures_30min / 2014-07-20
file: by_date/futures_30min/2014/2014-07-20.parquet size: 18 KB rows: 494
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 |
|---|---|---|---|---|---|---|---|
| 2014-07-20 18:00:00 | ES | Futures | 2053.9 | 2054.68 | 2053.64 | 2054.42 | 3775.0 |
| 2014-07-20 18:30:00 | ES | Futures | 2054.16 | 2054.94 | 2053.9 | 2054.42 | 744.0 |
| 2014-07-20 19:00:00 | ES | Futures | 2054.42 | 2054.68 | 2053.9 | 2054.16 | 725.0 |
| 2014-07-20 19:30:00 | ES | Futures | 2054.42 | 2055.2 | 2053.9 | 2055.2 | 1246.0 |
| 2014-07-20 20:00:00 | ES | Futures | 2054.94 | 2055.2 | 2054.42 | 2054.94 | 1232.0 |
| 2014-07-20 20:30:00 | ES | Futures | 2054.94 | 2055.2 | 2054.42 | 2055.2 | 854.0 |
| 2014-07-20 21:00:00 | ES | Futures | 2055.2 | 2055.2 | 2054.42 | 2054.68 | 817.0 |
| 2014-07-20 21:30:00 | ES | Futures | 2054.68 | 2055.2 | 2054.16 | 2054.42 | 1630.0 |
| 2014-07-20 22:00:00 | ES | Futures | 2054.42 | 2054.68 | 2054.16 | 2054.68 | 586.0 |
| 2014-07-20 22:30:00 | ES | Futures | 2054.68 | 2054.68 | 2054.16 | 2054.42 | 741.0 |
| 2014-07-20 23:00:00 | ES | Futures | 2054.42 | 2054.68 | 2054.16 | 2054.68 | 455.0 |
| 2014-07-20 23:30:00 | ES | Futures | 2054.68 | 2054.94 | 2053.9 | 2054.16 | 541.0 |
| 2014-07-20 18:00:00 | NQ | Futures | 4589.89 | 4590.47 | 4586.38 | 4589.59 | 862.0 |
| 2014-07-20 18:30:00 | NQ | Futures | 4589.59 | 4590.47 | 4589.01 | 4590.47 | 152.0 |
| 2014-07-20 19:00:00 | NQ | Futures | 4590.47 | 4590.47 | 4588.43 | 4588.72 | 66.0 |
| 2014-07-20 19:30:00 | NQ | Futures | 4588.72 | 4591.05 | 4588.72 | 4591.05 | 149.0 |
| 2014-07-20 20:00:00 | NQ | Futures | 4591.05 | 4591.93 | 4589.89 | 4591.93 | 103.0 |
| 2014-07-20 20:30:00 | NQ | Futures | 4591.05 | 4591.05 | 4589.59 | 4590.47 | 85.0 |
| 2014-07-20 21:00:00 | NQ | Futures | 4590.76 | 4590.76 | 4588.43 | 4588.43 | 216.0 |
| 2014-07-20 21:30:00 | NQ | Futures | 4588.43 | 4590.18 | 4587.84 | 4588.13 | 128.0 |
| 2014-07-20 22:00:00 | NQ | Futures | 4588.43 | 4589.3 | 4588.13 | 4589.01 | 95.0 |
| 2014-07-20 22:30:00 | NQ | Futures | 4588.72 | 4589.01 | 4588.43 | 4588.72 | 67.0 |
| 2014-07-20 23:00:00 | NQ | Futures | 4588.43 | 4589.3 | 4588.43 | 4589.01 | 40.0 |
| 2014-07-20 23:30:00 | NQ | Futures | 4589.01 | 4589.89 | 4587.84 | 4588.13 | 147.0 |
| 2014-07-20 18:00:00 | YM | Futures | 17608.3 | 17615.6 | 17606.3 | 17609.4 | 416.0 |
| 2014-07-20 18:30:00 | YM | Futures | 17610.4 | 17611.4 | 17609.4 | 17611.4 | 73.0 |
| 2014-07-20 19:00:00 | YM | Futures | 17611.4 | 17611.4 | 17608.3 | 17610.4 | 77.0 |
| 2014-07-20 19:30:00 | YM | Futures | 17610.4 | 17616.6 | 17606.3 | 17615.6 | 161.0 |
| 2014-07-20 20:00:00 | YM | Futures | 17615.6 | 17615.6 | 17612.5 | 17614.5 | 119.0 |
| 2014-07-20 20:30:00 | YM | Futures | 17615.6 | 17615.6 | 17610.4 | 17612.5 | 146.0 |
| 2014-07-20 21:00:00 | YM | Futures | 17612.5 | 17613.5 | 17608.3 | 17608.3 | 273.0 |
| 2014-07-20 21:30:00 | YM | Futures | 17608.3 | 17613.5 | 17607.3 | 17608.3 | 172.0 |
| 2014-07-20 22:00:00 | YM | Futures | 17608.3 | 17610.4 | 17608.3 | 17610.4 | 84.0 |
| 2014-07-20 22:30:00 | YM | Futures | 17610.4 | 17610.4 | 17607.3 | 17608.3 | 162.0 |
| 2014-07-20 23:00:00 | YM | Futures | 17609.4 | 17611.4 | 17608.3 | 17611.4 | 71.0 |
| 2014-07-20 23:30:00 | YM | Futures | 17610.4 | 17612.5 | 17605.2 | 17606.3 | 69.0 |
| 2014-07-20 18:00:00 | CL | Futures | 166.47 | 166.54 | 166.02 | 166.08 | 564.0 |
| 2014-07-20 18:30:00 | CL | Futures | 166.08 | 166.13 | 166.07 | 166.07 | 146.0 |
| 2014-07-20 19:00:00 | CL | Futures | 166.07 | 166.23 | 166.05 | 166.2 | 263.0 |
| 2014-07-20 19:30:00 | CL | Futures | 166.21 | 166.26 | 166.21 | 166.23 | 117.0 |
| 2014-07-20 20:00:00 | CL | Futures | 166.23 | 166.34 | 166.23 | 166.29 | 334.0 |
| 2014-07-20 20:30:00 | CL | Futures | 166.28 | 166.47 | 166.28 | 166.36 | 395.0 |
| 2014-07-20 21:00:00 | CL | Futures | 166.38 | 166.49 | 166.33 | 166.38 | 366.0 |
| 2014-07-20 21:30:00 | CL | Futures | 166.38 | 166.39 | 166.23 | 166.36 | 350.0 |
| 2014-07-20 22:00:00 | CL | Futures | 166.34 | 166.44 | 166.33 | 166.34 | 125.0 |
| 2014-07-20 22:30:00 | CL | Futures | 166.34 | 166.36 | 166.31 | 166.36 | 110.0 |
| 2014-07-20 23:00:00 | CL | Futures | 166.34 | 166.52 | 166.34 | 166.52 | 298.0 |
| 2014-07-20 23:30:00 | CL | Futures | 166.52 | 166.64 | 166.51 | 166.56 | 572.0 |
| 2014-07-20 18:00:00 | GC | Futures | 1796.1 | 1796.2 | 1794.8 | 1795.2 | 390.0 |
| 2014-07-20 18:30:00 | GC | Futures | 1795.2 | 1795.7 | 1794.6 | 1795.4 | 164.0 |
> showing 50 of 494 rows — these rows as CSV