PREVIEW / futures_30min / 2019-05-26
file: by_date/futures_30min/2019/2019-05-26.parquet size: 20 KB rows: 557
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-26 18:00:00 | ES | Futures | 3069.96 | 3071.05 | 3068.06 | 3070.5 | 2736.0 |
| 2019-05-26 18:30:00 | ES | Futures | 3070.78 | 3072.94 | 3069.96 | 3072.13 | 1943.0 |
| 2019-05-26 19:00:00 | ES | Futures | 3071.86 | 3074.3 | 3071.59 | 3073.22 | 912.0 |
| 2019-05-26 19:30:00 | ES | Futures | 3073.49 | 3074.03 | 3069.69 | 3069.69 | 2898.0 |
| 2019-05-26 20:00:00 | ES | Futures | 3069.42 | 3069.69 | 3064.54 | 3068.88 | 6814.0 |
| 2019-05-26 20:30:00 | ES | Futures | 3068.61 | 3073.22 | 3068.61 | 3071.59 | 3867.0 |
| 2019-05-26 21:00:00 | ES | Futures | 3071.32 | 3071.59 | 3068.88 | 3070.5 | 3848.0 |
| 2019-05-26 21:30:00 | ES | Futures | 3070.5 | 3071.59 | 3067.52 | 3069.96 | 5229.0 |
| 2019-05-26 22:00:00 | ES | Futures | 3069.96 | 3072.13 | 3069.42 | 3070.78 | 3165.0 |
| 2019-05-26 22:30:00 | ES | Futures | 3070.78 | 3070.78 | 3067.79 | 3068.34 | 2444.0 |
| 2019-05-26 23:00:00 | ES | Futures | 3068.06 | 3068.88 | 3066.17 | 3068.34 | 2958.0 |
| 2019-05-26 23:30:00 | ES | Futures | 3068.34 | 3068.88 | 3067.52 | 3068.61 | 1381.0 |
| 2019-05-26 18:00:00 | NQ | Futures | 8519.81 | 8523.59 | 8511.07 | 8519.23 | 1400.0 |
| 2019-05-26 18:30:00 | NQ | Futures | 8518.64 | 8520.97 | 8515.44 | 8517.48 | 1153.0 |
| 2019-05-26 19:00:00 | NQ | Futures | 8517.77 | 8527.09 | 8516.61 | 8523.88 | 862.0 |
| 2019-05-26 19:30:00 | NQ | Futures | 8523.3 | 8525.92 | 8512.82 | 8513.4 | 1298.0 |
| 2019-05-26 20:00:00 | NQ | Futures | 8513.11 | 8513.4 | 8493.6 | 8509.33 | 3319.0 |
| 2019-05-26 20:30:00 | NQ | Futures | 8509.33 | 8522.14 | 8508.45 | 8517.77 | 1769.0 |
| 2019-05-26 21:00:00 | NQ | Futures | 8517.48 | 8517.77 | 8510.2 | 8515.44 | 1835.0 |
| 2019-05-26 21:30:00 | NQ | Futures | 8515.73 | 8519.52 | 8505.54 | 8512.24 | 2560.0 |
| 2019-05-26 22:00:00 | NQ | Futures | 8512.82 | 8521.56 | 8510.78 | 8517.77 | 1516.0 |
| 2019-05-26 22:30:00 | NQ | Futures | 8518.06 | 8518.93 | 8506.71 | 8508.16 | 1278.0 |
| 2019-05-26 23:00:00 | NQ | Futures | 8508.16 | 8510.49 | 8496.81 | 8504.96 | 2734.0 |
| 2019-05-26 23:30:00 | NQ | Futures | 8504.67 | 8506.71 | 8501.17 | 8505.25 | 822.0 |
| 2019-05-26 18:00:00 | YM | Futures | 27854.1 | 27873.6 | 27842.1 | 27871.5 | 1184.0 |
| 2019-05-26 18:30:00 | YM | Futures | 27872.6 | 27893.2 | 27869.3 | 27885.6 | 709.0 |
| 2019-05-26 19:00:00 | YM | Futures | 27886.7 | 27908.5 | 27880.2 | 27898.7 | 582.0 |
| 2019-05-26 19:30:00 | YM | Futures | 27896.5 | 27904.1 | 27870.4 | 27871.5 | 888.0 |
| 2019-05-26 20:00:00 | YM | Futures | 27869.3 | 27871.5 | 27825.8 | 27864.9 | 2712.0 |
| 2019-05-26 20:30:00 | YM | Futures | 27864.9 | 27906.3 | 27863.9 | 27886.7 | 1577.0 |
| 2019-05-26 21:00:00 | YM | Futures | 27886.7 | 27886.7 | 27861.7 | 27873.6 | 1888.0 |
| 2019-05-26 21:30:00 | YM | Futures | 27874.7 | 27884.5 | 27849.7 | 27873.6 | 2467.0 |
| 2019-05-26 22:00:00 | YM | Futures | 27873.6 | 27887.8 | 27867.1 | 27878.0 | 1105.0 |
| 2019-05-26 22:30:00 | YM | Futures | 27878.0 | 27880.2 | 27851.9 | 27856.2 | 848.0 |
| 2019-05-26 23:00:00 | YM | Futures | 27854.1 | 27864.9 | 27842.1 | 27863.9 | 1129.0 |
| 2019-05-26 23:30:00 | YM | Futures | 27863.9 | 27867.1 | 27855.2 | 27864.9 | 466.0 |
| 2019-05-26 18:00:00 | CL | Futures | 52.56 | 52.64 | 52.31 | 52.35 | 4383.0 |
| 2019-05-26 18:30:00 | CL | Futures | 52.35 | 52.51 | 52.34 | 52.46 | 1722.0 |
| 2019-05-26 19:00:00 | CL | Futures | 52.45 | 52.56 | 52.43 | 52.51 | 1405.0 |
| 2019-05-26 19:30:00 | CL | Futures | 52.52 | 52.53 | 52.39 | 52.4 | 1501.0 |
| 2019-05-26 20:00:00 | CL | Futures | 52.4 | 52.42 | 52.29 | 52.41 | 3504.0 |
| 2019-05-26 20:30:00 | CL | Futures | 52.4 | 52.5 | 52.37 | 52.39 | 2916.0 |
| 2019-05-26 21:00:00 | CL | Futures | 52.39 | 52.39 | 52.2 | 52.31 | 7348.0 |
| 2019-05-26 21:30:00 | CL | Futures | 52.31 | 52.33 | 52.19 | 52.23 | 4481.0 |
| 2019-05-26 22:00:00 | CL | Futures | 52.23 | 52.29 | 52.19 | 52.25 | 2483.0 |
| 2019-05-26 22:30:00 | CL | Futures | 52.25 | 52.26 | 52.15 | 52.19 | 2424.0 |
| 2019-05-26 23:00:00 | CL | Futures | 52.19 | 52.19 | 52.08 | 52.15 | 4082.0 |
| 2019-05-26 23:30:00 | CL | Futures | 52.15 | 52.15 | 52.07 | 52.1 | 1426.0 |
| 2019-05-26 18:00:00 | GC | Futures | 1648.1 | 1650.9 | 1648.1 | 1649.8 | 253.0 |
| 2019-05-26 18:30:00 | GC | Futures | 1649.8 | 1649.8 | 1649.0 | 1649.0 | 57.0 |
> showing 50 of 557 rows — these rows as CSV