PREVIEW / futures_30min / 2019-02-10
file: by_date/futures_30min/2019/2019-02-10.parquet size: 22 KB rows: 631
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-02-10 18:00:00 | ES | Futures | 2944.79 | 2946.96 | 2941.8 | 2943.16 | 10637.0 |
| 2019-02-10 18:30:00 | ES | Futures | 2943.43 | 2943.71 | 2939.9 | 2939.9 | 2971.0 |
| 2019-02-10 19:00:00 | ES | Futures | 2940.17 | 2940.99 | 2937.46 | 2938.0 | 3921.0 |
| 2019-02-10 19:30:00 | ES | Futures | 2938.0 | 2939.63 | 2936.37 | 2937.19 | 3152.0 |
| 2019-02-10 20:00:00 | ES | Futures | 2937.19 | 2938.27 | 2934.47 | 2935.29 | 4648.0 |
| 2019-02-10 20:30:00 | ES | Futures | 2935.29 | 2936.1 | 2933.66 | 2935.29 | 3774.0 |
| 2019-02-10 21:00:00 | ES | Futures | 2935.56 | 2936.64 | 2935.01 | 2935.56 | 1941.0 |
| 2019-02-10 21:30:00 | ES | Futures | 2935.29 | 2940.45 | 2935.01 | 2939.09 | 4541.0 |
| 2019-02-10 22:00:00 | ES | Futures | 2939.36 | 2939.9 | 2937.73 | 2938.54 | 2083.0 |
| 2019-02-10 22:30:00 | ES | Futures | 2938.54 | 2939.09 | 2938.0 | 2938.27 | 975.0 |
| 2019-02-10 23:00:00 | ES | Futures | 2938.27 | 2938.82 | 2936.64 | 2937.46 | 1219.0 |
| 2019-02-10 23:30:00 | ES | Futures | 2937.46 | 2938.27 | 2936.37 | 2938.0 | 3131.0 |
| 2019-02-10 18:00:00 | NQ | Futures | 8089.85 | 8111.18 | 8087.22 | 8091.89 | 2313.0 |
| 2019-02-10 18:30:00 | NQ | Futures | 8092.48 | 8093.35 | 8079.62 | 8080.5 | 1121.0 |
| 2019-02-10 19:00:00 | NQ | Futures | 8080.5 | 8084.0 | 8072.9 | 8075.53 | 1826.0 |
| 2019-02-10 19:30:00 | NQ | Futures | 8075.24 | 8079.91 | 8068.52 | 8071.73 | 2033.0 |
| 2019-02-10 20:00:00 | NQ | Futures | 8072.02 | 8076.99 | 8064.43 | 8066.47 | 2559.0 |
| 2019-02-10 20:30:00 | NQ | Futures | 8066.76 | 8068.52 | 8061.21 | 8064.43 | 1533.0 |
| 2019-02-10 21:00:00 | NQ | Futures | 8064.43 | 8068.81 | 8062.96 | 8064.43 | 963.0 |
| 2019-02-10 21:30:00 | NQ | Futures | 8065.01 | 8081.66 | 8063.84 | 8078.45 | 2149.0 |
| 2019-02-10 22:00:00 | NQ | Futures | 8078.74 | 8080.79 | 8070.85 | 8074.07 | 1358.0 |
| 2019-02-10 22:30:00 | NQ | Futures | 8073.78 | 8074.94 | 8071.44 | 8074.94 | 550.0 |
| 2019-02-10 23:00:00 | NQ | Futures | 8074.94 | 8075.82 | 8067.06 | 8069.1 | 664.0 |
| 2019-02-10 23:30:00 | NQ | Futures | 8069.1 | 8072.02 | 8066.47 | 8071.44 | 692.0 |
| 2019-02-10 18:00:00 | YM | Futures | 27239.3 | 27294.7 | 27239.3 | 27248.0 | 1618.0 |
| 2019-02-10 18:30:00 | YM | Futures | 27248.0 | 27249.1 | 27218.7 | 27220.8 | 745.0 |
| 2019-02-10 19:00:00 | YM | Futures | 27221.9 | 27228.4 | 27192.6 | 27205.6 | 1013.0 |
| 2019-02-10 19:30:00 | YM | Futures | 27205.6 | 27219.8 | 27188.3 | 27194.8 | 927.0 |
| 2019-02-10 20:00:00 | YM | Futures | 27194.8 | 27205.6 | 27172.0 | 27177.4 | 1434.0 |
| 2019-02-10 20:30:00 | YM | Futures | 27176.3 | 27182.8 | 27161.1 | 27179.6 | 773.0 |
| 2019-02-10 21:00:00 | YM | Futures | 27179.6 | 27191.5 | 27177.4 | 27178.5 | 506.0 |
| 2019-02-10 21:30:00 | YM | Futures | 27177.4 | 27224.1 | 27175.2 | 27210.0 | 972.0 |
| 2019-02-10 22:00:00 | YM | Futures | 27211.1 | 27213.2 | 27194.8 | 27202.4 | 504.0 |
| 2019-02-10 22:30:00 | YM | Futures | 27202.4 | 27206.7 | 27197.0 | 27200.2 | 300.0 |
| 2019-02-10 23:00:00 | YM | Futures | 27200.2 | 27202.4 | 27181.8 | 27190.4 | 407.0 |
| 2019-02-10 23:30:00 | YM | Futures | 27188.3 | 27199.1 | 27177.4 | 27197.0 | 668.0 |
| 2019-02-10 18:00:00 | CL | Futures | 47.79 | 47.9 | 47.67 | 47.69 | 1738.0 |
| 2019-02-10 18:30:00 | CL | Futures | 47.68 | 47.73 | 47.63 | 47.64 | 1507.0 |
| 2019-02-10 19:00:00 | CL | Futures | 47.64 | 47.66 | 47.52 | 47.58 | 2991.0 |
| 2019-02-10 19:30:00 | CL | Futures | 47.58 | 47.6 | 47.45 | 47.56 | 2844.0 |
| 2019-02-10 20:00:00 | CL | Futures | 47.56 | 47.56 | 47.2 | 47.24 | 12160.0 |
| 2019-02-10 20:30:00 | CL | Futures | 47.24 | 47.27 | 47.1 | 47.19 | 6220.0 |
| 2019-02-10 21:00:00 | CL | Futures | 47.19 | 47.25 | 47.13 | 47.21 | 3812.0 |
| 2019-02-10 21:30:00 | CL | Futures | 47.21 | 47.37 | 47.18 | 47.33 | 4558.0 |
| 2019-02-10 22:00:00 | CL | Futures | 47.34 | 47.36 | 47.26 | 47.3 | 2478.0 |
| 2019-02-10 22:30:00 | CL | Futures | 47.3 | 47.31 | 47.26 | 47.28 | 1088.0 |
| 2019-02-10 23:00:00 | CL | Futures | 47.27 | 47.29 | 47.16 | 47.19 | 2161.0 |
| 2019-02-10 23:30:00 | CL | Futures | 47.2 | 47.24 | 47.2 | 47.22 | 920.0 |
| 2019-02-10 18:00:00 | GC | Futures | 1699.7 | 1699.9 | 1698.5 | 1698.7 | 836.0 |
| 2019-02-10 18:30:00 | GC | Futures | 1698.7 | 1699.3 | 1698.5 | 1698.8 | 464.0 |
> showing 50 of 631 rows — these rows as CSV