PREVIEW / futures_30min / 2015-07-02
file: by_date/futures_30min/2015/2015-07-02.parquet size: 75 KB rows: 2,761
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-02 00:00:00 | ES | Futures | 2203.74 | 2204.27 | 2203.2 | 2203.74 | 493.0 |
| 2015-07-02 00:30:00 | ES | Futures | 2203.74 | 2204.27 | 2203.2 | 2204.0 | 690.0 |
| 2015-07-02 01:00:00 | ES | Futures | 2204.27 | 2204.54 | 2203.74 | 2204.54 | 628.0 |
| 2015-07-02 01:30:00 | ES | Futures | 2204.54 | 2204.8 | 2203.2 | 2204.0 | 1400.0 |
| 2015-07-02 02:00:00 | ES | Futures | 2204.0 | 2206.67 | 2203.74 | 2205.87 | 4750.0 |
| 2015-07-02 02:30:00 | ES | Futures | 2205.87 | 2206.93 | 2204.27 | 2206.4 | 4271.0 |
| 2015-07-02 03:00:00 | ES | Futures | 2206.4 | 2210.13 | 2205.33 | 2209.33 | 14127.0 |
| 2015-07-02 03:30:00 | ES | Futures | 2209.33 | 2210.66 | 2208.53 | 2209.06 | 7979.0 |
| 2015-07-02 04:00:00 | ES | Futures | 2209.33 | 2211.19 | 2208.53 | 2209.33 | 7269.0 |
| 2015-07-02 04:30:00 | ES | Futures | 2209.59 | 2209.86 | 2207.2 | 2208.8 | 6795.0 |
| 2015-07-02 05:00:00 | ES | Futures | 2208.53 | 2208.8 | 2205.6 | 2207.46 | 9326.0 |
| 2015-07-02 05:30:00 | ES | Futures | 2207.46 | 2209.06 | 2207.2 | 2208.53 | 4073.0 |
| 2015-07-02 06:00:00 | ES | Futures | 2208.53 | 2209.06 | 2207.73 | 2208.8 | 5126.0 |
| 2015-07-02 06:30:00 | ES | Futures | 2208.8 | 2209.86 | 2208.53 | 2209.06 | 3627.0 |
| 2015-07-02 07:00:00 | ES | Futures | 2209.06 | 2210.13 | 2207.2 | 2208.0 | 20324.0 |
| 2015-07-02 07:30:00 | ES | Futures | 2208.0 | 2210.13 | 2207.73 | 2209.06 | 10128.0 |
| 2015-07-02 08:00:00 | ES | Futures | 2209.06 | 2209.86 | 2207.73 | 2208.26 | 17296.0 |
| 2015-07-02 08:30:00 | ES | Futures | 2208.53 | 2214.12 | 2207.46 | 2211.72 | 51848.0 |
| 2015-07-02 09:00:00 | ES | Futures | 2211.72 | 2212.26 | 2206.93 | 2209.59 | 37268.0 |
| 2015-07-02 09:30:00 | ES | Futures | 2209.59 | 2211.99 | 2206.93 | 2207.73 | 153124.0 |
| 2015-07-02 10:00:00 | ES | Futures | 2207.73 | 2209.33 | 2205.6 | 2207.46 | 88223.0 |
| 2015-07-02 10:30:00 | ES | Futures | 2207.46 | 2207.73 | 2203.47 | 2205.6 | 93940.0 |
| 2015-07-02 11:00:00 | ES | Futures | 2205.6 | 2206.13 | 2200.54 | 2201.34 | 87703.0 |
| 2015-07-02 11:30:00 | ES | Futures | 2201.34 | 2203.2 | 2199.21 | 2201.07 | 49227.0 |
| 2015-07-02 12:00:00 | ES | Futures | 2200.81 | 2201.87 | 2197.08 | 2197.88 | 50953.0 |
| 2015-07-02 12:30:00 | ES | Futures | 2197.88 | 2199.48 | 2197.08 | 2198.94 | 32898.0 |
| 2015-07-02 13:00:00 | ES | Futures | 2198.94 | 2198.94 | 2196.55 | 2198.68 | 44381.0 |
| 2015-07-02 13:30:00 | ES | Futures | 2198.68 | 2200.01 | 2197.35 | 2197.61 | 42875.0 |
| 2015-07-02 14:00:00 | ES | Futures | 2197.61 | 2198.94 | 2196.28 | 2198.15 | 38624.0 |
| 2015-07-02 14:30:00 | ES | Futures | 2198.15 | 2201.34 | 2197.35 | 2200.54 | 49841.0 |
| 2015-07-02 15:00:00 | ES | Futures | 2200.54 | 2204.0 | 2198.94 | 2203.2 | 51251.0 |
| 2015-07-02 15:30:00 | ES | Futures | 2203.2 | 2205.07 | 2200.54 | 2201.34 | 150010.0 |
| 2015-07-02 16:00:00 | ES | Futures | 2201.34 | 2204.27 | 2200.54 | 2203.2 | 83698.0 |
| 2015-07-02 16:30:00 | ES | Futures | 2202.94 | 2204.0 | 2202.94 | 2203.2 | 4376.0 |
| 2015-07-02 17:00:00 | ES | Futures | 2203.47 | 2203.74 | 2202.67 | 2203.47 | 1623.0 |
| 2015-07-02 18:00:00 | ES | Futures | 2202.94 | 2204.0 | 2202.94 | 2202.94 | 953.0 |
| 2015-07-02 18:30:00 | ES | Futures | 2202.94 | 2203.2 | 2202.67 | 2202.67 | 137.0 |
| 2015-07-02 19:00:00 | ES | Futures | 2202.67 | 2202.94 | 2201.34 | 2202.14 | 637.0 |
| 2015-07-02 19:30:00 | ES | Futures | 2202.14 | 2203.47 | 2202.14 | 2202.67 | 368.0 |
| 2015-07-02 20:00:00 | ES | Futures | 2202.67 | 2202.94 | 2201.34 | 2201.61 | 1199.0 |
| 2015-07-02 20:30:00 | ES | Futures | 2201.61 | 2202.67 | 2201.34 | 2202.67 | 456.0 |
| 2015-07-02 21:00:00 | ES | Futures | 2202.41 | 2203.74 | 2202.41 | 2203.2 | 936.0 |
| 2015-07-02 21:30:00 | ES | Futures | 2203.47 | 2203.47 | 2201.61 | 2201.87 | 1222.0 |
| 2015-07-02 22:00:00 | ES | Futures | 2201.87 | 2202.94 | 2201.61 | 2202.94 | 934.0 |
| 2015-07-02 22:30:00 | ES | Futures | 2202.67 | 2203.2 | 2201.87 | 2201.87 | 879.0 |
| 2015-07-02 23:00:00 | ES | Futures | 2201.87 | 2203.74 | 2201.87 | 2203.74 | 614.0 |
| 2015-07-02 23:30:00 | ES | Futures | 2203.47 | 2204.54 | 2203.47 | 2203.74 | 780.0 |
| 2015-07-02 00:00:00 | NQ | Futures | 5227.78 | 5229.26 | 5226.01 | 5226.89 | 144.0 |
| 2015-07-02 00:30:00 | NQ | Futures | 5227.19 | 5229.85 | 5226.3 | 5228.97 | 113.0 |
| 2015-07-02 01:00:00 | NQ | Futures | 5229.26 | 5230.15 | 5228.37 | 5229.85 | 173.0 |
> showing 50 of 2,761 rows — these rows as CSV