PREVIEW / futures_1hour / 2020-10-11
file: by_date/futures_1hour/2020/2020-10-11.parquet size: 17 KB rows: 361
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 |
|---|---|---|---|---|---|---|---|
| 2020-10-11 18:00:00 | ES | Futures | 3884.91 | 3891.35 | 3882.11 | 3888.55 | 13479.0 |
| 2020-10-11 19:00:00 | ES | Futures | 3888.55 | 3892.19 | 3883.23 | 3887.99 | 8350.0 |
| 2020-10-11 20:00:00 | ES | Futures | 3887.99 | 3889.67 | 3881.27 | 3886.31 | 14147.0 |
| 2020-10-11 21:00:00 | ES | Futures | 3886.31 | 3896.39 | 3883.51 | 3894.99 | 16567.0 |
| 2020-10-11 22:00:00 | ES | Futures | 3894.99 | 3895.55 | 3891.07 | 3894.15 | 9237.0 |
| 2020-10-11 23:00:00 | ES | Futures | 3894.43 | 3897.51 | 3892.75 | 3895.55 | 4402.0 |
| 2020-10-11 18:00:00 | NQ | Futures | 13573.48 | 13599.24 | 13532.95 | 13592.87 | 9212.0 |
| 2020-10-11 19:00:00 | NQ | Futures | 13593.16 | 13612.27 | 13574.35 | 13597.5 | 6214.0 |
| 2020-10-11 20:00:00 | NQ | Futures | 13598.08 | 13599.24 | 13567.69 | 13586.21 | 7852.0 |
| 2020-10-11 21:00:00 | NQ | Futures | 13585.92 | 13626.45 | 13574.63 | 13625.58 | 9074.0 |
| 2020-10-11 22:00:00 | NQ | Futures | 13625.87 | 13627.9 | 13613.13 | 13624.71 | 5235.0 |
| 2020-10-11 23:00:00 | NQ | Futures | 13625.29 | 13634.55 | 13616.9 | 13627.32 | 3527.0 |
| 2020-10-11 18:00:00 | YM | Futures | 31530.1 | 31530.1 | 31451.6 | 31501.3 | 2470.0 |
| 2020-10-11 19:00:00 | YM | Futures | 31503.5 | 31527.8 | 31462.6 | 31490.3 | 1762.0 |
| 2020-10-11 20:00:00 | YM | Futures | 31491.4 | 31500.2 | 31436.1 | 31473.7 | 2982.0 |
| 2020-10-11 21:00:00 | YM | Futures | 31471.5 | 31552.2 | 31452.7 | 31537.8 | 3292.0 |
| 2020-10-11 22:00:00 | YM | Futures | 31537.8 | 31542.2 | 31501.3 | 31523.4 | 1918.0 |
| 2020-10-11 23:00:00 | YM | Futures | 31524.5 | 31554.4 | 31512.4 | 31534.5 | 1120.0 |
| 2020-10-11 18:00:00 | CL | Futures | 27.85 | 27.88 | 27.74 | 27.77 | 3003.0 |
| 2020-10-11 19:00:00 | CL | Futures | 27.78 | 27.79 | 27.68 | 27.72 | 1839.0 |
| 2020-10-11 20:00:00 | CL | Futures | 27.72 | 27.73 | 27.52 | 27.65 | 4634.0 |
| 2020-10-11 21:00:00 | CL | Futures | 27.66 | 27.85 | 27.6 | 27.81 | 4783.0 |
| 2020-10-11 22:00:00 | CL | Futures | 27.8 | 27.81 | 27.73 | 27.78 | 2128.0 |
| 2020-10-11 23:00:00 | CL | Futures | 27.78 | 27.81 | 27.7 | 27.7 | 1576.0 |
| 2020-10-11 18:00:00 | GC | Futures | 2353.3 | 2355.7 | 2350.1 | 2353.5 | 3425.0 |
| 2020-10-11 19:00:00 | GC | Futures | 2353.5 | 2358.6 | 2352.4 | 2353.4 | 4340.0 |
| 2020-10-11 20:00:00 | GC | Futures | 2353.0 | 2353.0 | 2345.7 | 2347.7 | 6154.0 |
| 2020-10-11 21:00:00 | GC | Futures | 2347.7 | 2354.4 | 2343.5 | 2351.1 | 10842.0 |
| 2020-10-11 22:00:00 | GC | Futures | 2351.2 | 2351.9 | 2347.2 | 2351.2 | 4505.0 |
| 2020-10-11 23:00:00 | GC | Futures | 2351.2 | 2353.8 | 2349.0 | 2351.3 | 2828.0 |
| 2020-10-11 18:00:00 | ZN | Futures | 138.64862 | 138.711039 | 138.633015 | 138.695434 | 7745.0 |
| 2020-10-11 19:00:00 | ZN | Futures | 138.695434 | 138.726644 | 138.67983 | 138.711039 | 3491.0 |
| 2020-10-11 20:00:00 | ZN | Futures | 138.711039 | 138.726644 | 138.695434 | 138.711039 | 2710.0 |
| 2020-10-11 21:00:00 | ZN | Futures | 138.711039 | 138.711039 | 138.67983 | 138.695434 | 3508.0 |
| 2020-10-11 22:00:00 | ZN | Futures | 138.695434 | 138.711039 | 138.67983 | 138.711039 | 1567.0 |
| 2020-10-11 23:00:00 | ZN | Futures | 138.711039 | 138.711039 | 138.67983 | 138.695434 | 1758.0 |
> showing 36 of 361 rows — these rows as CSV