PREVIEW / futures_30min / 2019-02-03
file: by_date/futures_30min/2019/2019-02-03.parquet size: 23 KB rows: 653
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-03 18:00:00 | ES | Futures | 2932.3 | 2935.56 | 2930.94 | 2933.93 | 4531.0 |
| 2019-02-03 18:30:00 | ES | Futures | 2933.93 | 2937.73 | 2933.93 | 2936.37 | 2199.0 |
| 2019-02-03 19:00:00 | ES | Futures | 2936.1 | 2942.35 | 2936.1 | 2941.53 | 5503.0 |
| 2019-02-03 19:30:00 | ES | Futures | 2941.26 | 2941.8 | 2939.09 | 2941.53 | 2424.0 |
| 2019-02-03 20:00:00 | ES | Futures | 2941.8 | 2943.16 | 2939.36 | 2940.17 | 3209.0 |
| 2019-02-03 20:30:00 | ES | Futures | 2939.9 | 2941.8 | 2937.46 | 2940.99 | 4272.0 |
| 2019-02-03 21:00:00 | ES | Futures | 2940.99 | 2942.35 | 2940.17 | 2942.35 | 1935.0 |
| 2019-02-03 21:30:00 | ES | Futures | 2942.08 | 2942.62 | 2939.9 | 2940.45 | 1605.0 |
| 2019-02-03 22:00:00 | ES | Futures | 2940.45 | 2940.99 | 2939.36 | 2939.9 | 1077.0 |
| 2019-02-03 22:30:00 | ES | Futures | 2939.9 | 2940.17 | 2938.54 | 2939.63 | 1877.0 |
| 2019-02-03 23:00:00 | ES | Futures | 2939.63 | 2939.63 | 2937.73 | 2938.27 | 1826.0 |
| 2019-02-03 23:30:00 | ES | Futures | 2938.54 | 2939.9 | 2938.27 | 2938.82 | 1300.0 |
| 2019-02-03 18:00:00 | NQ | Futures | 8022.06 | 8033.16 | 8015.63 | 8027.03 | 1474.0 |
| 2019-02-03 18:30:00 | NQ | Futures | 8027.32 | 8041.93 | 8027.32 | 8038.42 | 1403.0 |
| 2019-02-03 19:00:00 | NQ | Futures | 8038.13 | 8058.58 | 8038.13 | 8055.66 | 2688.0 |
| 2019-02-03 19:30:00 | NQ | Futures | 8055.37 | 8056.24 | 8046.6 | 8055.66 | 1106.0 |
| 2019-02-03 20:00:00 | NQ | Futures | 8055.66 | 8060.92 | 8046.89 | 8049.82 | 1668.0 |
| 2019-02-03 20:30:00 | NQ | Futures | 8048.94 | 8056.54 | 8042.51 | 8053.91 | 1533.0 |
| 2019-02-03 21:00:00 | NQ | Futures | 8053.32 | 8059.46 | 8051.86 | 8058.58 | 1060.0 |
| 2019-02-03 21:30:00 | NQ | Futures | 8058.0 | 8059.75 | 8050.4 | 8053.03 | 753.0 |
| 2019-02-03 22:00:00 | NQ | Futures | 8053.03 | 8054.78 | 8049.82 | 8052.45 | 467.0 |
| 2019-02-03 22:30:00 | NQ | Futures | 8052.15 | 8052.15 | 8044.56 | 8048.06 | 976.0 |
| 2019-02-03 23:00:00 | NQ | Futures | 8048.36 | 8048.36 | 8041.93 | 8044.26 | 760.0 |
| 2019-02-03 23:30:00 | NQ | Futures | 8044.26 | 8050.11 | 8043.97 | 8046.31 | 695.0 |
| 2019-02-03 18:00:00 | YM | Futures | 27076.4 | 27122.0 | 27076.4 | 27103.6 | 976.0 |
| 2019-02-03 18:30:00 | YM | Futures | 27104.7 | 27139.4 | 27104.7 | 27125.3 | 477.0 |
| 2019-02-03 19:00:00 | YM | Futures | 27126.4 | 27180.7 | 27125.3 | 27170.9 | 1420.0 |
| 2019-02-03 19:30:00 | YM | Futures | 27169.8 | 27172.0 | 27148.1 | 27169.8 | 571.0 |
| 2019-02-03 20:00:00 | YM | Futures | 27169.8 | 27188.3 | 27151.4 | 27160.0 | 1095.0 |
| 2019-02-03 20:30:00 | YM | Futures | 27159.0 | 27176.3 | 27135.1 | 27169.8 | 1077.0 |
| 2019-02-03 21:00:00 | YM | Futures | 27170.9 | 27182.8 | 27163.3 | 27181.8 | 585.0 |
| 2019-02-03 21:30:00 | YM | Futures | 27179.6 | 27185.0 | 27159.0 | 27166.6 | 425.0 |
| 2019-02-03 22:00:00 | YM | Futures | 27166.6 | 27172.0 | 27156.8 | 27162.2 | 401.0 |
| 2019-02-03 22:30:00 | YM | Futures | 27161.1 | 27165.5 | 27150.3 | 27157.9 | 469.0 |
| 2019-02-03 23:00:00 | YM | Futures | 27156.8 | 27160.0 | 27147.0 | 27152.4 | 508.0 |
| 2019-02-03 23:30:00 | YM | Futures | 27150.3 | 27166.6 | 27149.2 | 27152.4 | 387.0 |
| 2019-02-03 18:00:00 | CL | Futures | 50.21 | 50.34 | 50.05 | 50.1 | 3930.0 |
| 2019-02-03 18:30:00 | CL | Futures | 50.1 | 50.17 | 50.04 | 50.13 | 1648.0 |
| 2019-02-03 19:00:00 | CL | Futures | 50.13 | 50.26 | 50.13 | 50.25 | 2629.0 |
| 2019-02-03 19:30:00 | CL | Futures | 50.25 | 50.25 | 50.1 | 50.12 | 1412.0 |
| 2019-02-03 20:00:00 | CL | Futures | 50.13 | 50.14 | 49.9 | 49.97 | 4681.0 |
| 2019-02-03 20:30:00 | CL | Futures | 49.97 | 50.11 | 49.95 | 50.1 | 2192.0 |
| 2019-02-03 21:00:00 | CL | Futures | 50.1 | 50.33 | 50.09 | 50.31 | 5076.0 |
| 2019-02-03 21:30:00 | CL | Futures | 50.31 | 50.32 | 50.24 | 50.25 | 2040.0 |
| 2019-02-03 22:00:00 | CL | Futures | 50.25 | 50.28 | 50.13 | 50.13 | 2441.0 |
| 2019-02-03 22:30:00 | CL | Futures | 50.14 | 50.15 | 50.01 | 50.09 | 3857.0 |
| 2019-02-03 23:00:00 | CL | Futures | 50.1 | 50.21 | 50.06 | 50.19 | 3627.0 |
| 2019-02-03 23:30:00 | CL | Futures | 50.2 | 50.2 | 50.13 | 50.14 | 1943.0 |
| 2019-02-03 18:00:00 | GC | Futures | 1705.5 | 1706.8 | 1704.1 | 1704.2 | 1231.0 |
| 2019-02-03 18:30:00 | GC | Futures | 1704.2 | 1704.8 | 1703.6 | 1704.5 | 723.0 |
> showing 50 of 653 rows — these rows as CSV