PREVIEW / futures_1hour / 2021-05-30
file: by_date/futures_1hour/2021/2021-05-30.parquet size: 16 KB rows: 322
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 |
|---|---|---|---|---|---|---|---|
| 2021-05-30 18:00:00 | ES | Futures | 4727.59 | 4730.96 | 4725.34 | 4729.84 | 4382.0 |
| 2021-05-30 19:00:00 | ES | Futures | 4730.12 | 4731.8 | 4726.75 | 4728.71 | 4576.0 |
| 2021-05-30 20:00:00 | ES | Futures | 4728.71 | 4731.52 | 4726.19 | 4729.84 | 5804.0 |
| 2021-05-30 21:00:00 | ES | Futures | 4729.56 | 4730.68 | 4725.34 | 4728.71 | 5699.0 |
| 2021-05-30 22:00:00 | ES | Futures | 4728.71 | 4729.84 | 4727.03 | 4728.43 | 3461.0 |
| 2021-05-30 23:00:00 | ES | Futures | 4728.15 | 4728.43 | 4726.19 | 4727.87 | 2006.0 |
| 2021-05-30 18:00:00 | NQ | Futures | 15863.18 | 15883.45 | 15859.13 | 15878.53 | 2249.0 |
| 2021-05-30 19:00:00 | NQ | Futures | 15878.53 | 15886.92 | 15868.68 | 15878.82 | 2279.0 |
| 2021-05-30 20:00:00 | NQ | Futures | 15879.11 | 15885.47 | 15864.05 | 15872.45 | 3629.0 |
| 2021-05-30 21:00:00 | NQ | Futures | 15873.03 | 15878.24 | 15854.5 | 15870.13 | 3014.0 |
| 2021-05-30 22:00:00 | NQ | Futures | 15869.26 | 15875.34 | 15856.81 | 15864.92 | 2187.0 |
| 2021-05-30 23:00:00 | NQ | Futures | 15865.21 | 15866.37 | 15853.05 | 15862.03 | 1299.0 |
| 2021-05-30 18:00:00 | YM | Futures | 38504.7 | 38505.8 | 38456.8 | 38484.7 | 839.0 |
| 2021-05-30 19:00:00 | YM | Futures | 38486.9 | 38501.4 | 38467.9 | 38481.3 | 673.0 |
| 2021-05-30 20:00:00 | YM | Futures | 38480.2 | 38509.2 | 38463.5 | 38492.4 | 971.0 |
| 2021-05-30 21:00:00 | YM | Futures | 38490.2 | 38500.2 | 38454.6 | 38481.3 | 1033.0 |
| 2021-05-30 22:00:00 | YM | Futures | 38482.4 | 38491.3 | 38470.2 | 38480.2 | 532.0 |
| 2021-05-30 23:00:00 | YM | Futures | 38480.2 | 38485.8 | 38465.7 | 38474.6 | 373.0 |
| 2021-05-30 18:00:00 | CL | Futures | 45.19 | 45.23 | 45.1 | 45.12 | 1308.0 |
| 2021-05-30 19:00:00 | CL | Futures | 45.12 | 45.14 | 45.08 | 45.12 | 801.0 |
| 2021-05-30 20:00:00 | CL | Futures | 45.12 | 45.16 | 45.0 | 45.06 | 2502.0 |
| 2021-05-30 21:00:00 | CL | Futures | 45.06 | 45.29 | 45.06 | 45.13 | 5358.0 |
| 2021-05-30 22:00:00 | CL | Futures | 45.13 | 45.25 | 45.08 | 45.21 | 3404.0 |
| 2021-05-30 23:00:00 | CL | Futures | 45.21 | 45.26 | 45.17 | 45.25 | 1710.0 |
| 2021-05-30 18:00:00 | GC | Futures | 2300.6 | 2302.0 | 2299.6 | 2300.6 | 1136.0 |
| 2021-05-30 19:00:00 | GC | Futures | 2300.6 | 2301.7 | 2300.0 | 2300.5 | 898.0 |
| 2021-05-30 20:00:00 | GC | Futures | 2300.4 | 2302.8 | 2298.8 | 2301.9 | 4004.0 |
| 2021-05-30 21:00:00 | GC | Futures | 2301.8 | 2306.3 | 2301.3 | 2304.7 | 8931.0 |
| 2021-05-30 22:00:00 | GC | Futures | 2304.8 | 2308.2 | 2304.0 | 2307.7 | 4698.0 |
| 2021-05-30 23:00:00 | GC | Futures | 2307.6 | 2308.6 | 2305.8 | 2306.3 | 3497.0 |
| 2021-05-30 18:00:00 | ZN | Futures | 134.085218 | 134.116786 | 134.085218 | 134.116786 | 78.0 |
| 2021-05-30 19:00:00 | ZN | Futures | 134.116786 | 134.116786 | 134.085218 | 134.085218 | 168.0 |
| 2021-05-30 20:00:00 | ZN | Futures | 134.085218 | 134.085218 | 134.05365 | 134.069434 | 262.0 |
| 2021-05-30 21:00:00 | ZN | Futures | 134.069434 | 134.085218 | 134.069434 | 134.069434 | 111.0 |
| 2021-05-30 22:00:00 | ZN | Futures | 134.069434 | 134.085218 | 134.069434 | 134.069434 | 9.0 |
| 2021-05-30 23:00:00 | ZN | Futures | 134.069434 | 134.085218 | 134.069434 | 134.069434 | 14.0 |
> showing 36 of 322 rows — these rows as CSV