PREVIEW / futures_30min / 2022-07-31
file: by_date/futures_30min/2022/2022-07-31.parquet size: 29 KB rows: 796
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-31 18:00:00 | ES | Futures | 4688.14 | 4688.71 | 4664.35 | 4666.33 | 10140.0 |
| 2022-07-31 18:30:00 | ES | Futures | 4666.05 | 4668.31 | 4661.23 | 4663.78 | 4739.0 |
| 2022-07-31 19:00:00 | ES | Futures | 4663.78 | 4668.6 | 4661.52 | 4666.9 | 3061.0 |
| 2022-07-31 19:30:00 | ES | Futures | 4666.9 | 4671.43 | 4663.22 | 4664.91 | 3901.0 |
| 2022-07-31 20:00:00 | ES | Futures | 4664.91 | 4668.6 | 4661.8 | 4667.75 | 5090.0 |
| 2022-07-31 20:30:00 | ES | Futures | 4667.75 | 4668.31 | 4664.07 | 4665.2 | 2163.0 |
| 2022-07-31 21:00:00 | ES | Futures | 4665.48 | 4668.03 | 4662.93 | 4666.9 | 3746.0 |
| 2022-07-31 21:30:00 | ES | Futures | 4667.18 | 4670.3 | 4664.35 | 4667.75 | 6648.0 |
| 2022-07-31 22:00:00 | ES | Futures | 4667.46 | 4668.88 | 4664.63 | 4668.6 | 2683.0 |
| 2022-07-31 22:30:00 | ES | Futures | 4668.6 | 4669.73 | 4666.05 | 4668.31 | 2061.0 |
| 2022-07-31 23:00:00 | ES | Futures | 4668.6 | 4668.6 | 4660.1 | 4661.23 | 4270.0 |
| 2022-07-31 23:30:00 | ES | Futures | 4660.95 | 4662.08 | 4660.38 | 4661.52 | 1874.0 |
| 2022-07-31 18:00:00 | NQ | Futures | 15018.45 | 15038.98 | 14947.87 | 14950.48 | 5573.0 |
| 2022-07-31 18:30:00 | NQ | Futures | 14950.19 | 14962.05 | 14942.96 | 14953.66 | 2282.0 |
| 2022-07-31 19:00:00 | NQ | Futures | 14953.08 | 14967.83 | 14942.09 | 14960.6 | 1549.0 |
| 2022-07-31 19:30:00 | NQ | Futures | 14959.73 | 14969.86 | 14938.62 | 14947.87 | 2127.0 |
| 2022-07-31 20:00:00 | NQ | Futures | 14947.3 | 14952.5 | 14933.7 | 14950.48 | 2659.0 |
| 2022-07-31 20:30:00 | NQ | Futures | 14950.77 | 14951.92 | 14938.33 | 14943.54 | 1166.0 |
| 2022-07-31 21:00:00 | NQ | Futures | 14944.98 | 14955.1 | 14930.81 | 14951.34 | 2159.0 |
| 2022-07-31 21:30:00 | NQ | Futures | 14951.06 | 14961.76 | 14943.82 | 14958.87 | 2215.0 |
| 2022-07-31 22:00:00 | NQ | Futures | 14958.58 | 14965.23 | 14947.87 | 14963.78 | 1637.0 |
| 2022-07-31 22:30:00 | NQ | Futures | 14963.78 | 14967.25 | 14953.66 | 14962.91 | 1055.0 |
| 2022-07-31 23:00:00 | NQ | Futures | 14962.91 | 14964.07 | 14934.28 | 14938.04 | 1901.0 |
| 2022-07-31 23:30:00 | NQ | Futures | 14938.62 | 14946.14 | 14935.73 | 14943.54 | 1109.0 |
| 2022-07-31 18:00:00 | YM | Futures | 37040.1 | 37069.5 | 36885.6 | 36908.1 | 1981.0 |
| 2022-07-31 18:30:00 | YM | Futures | 36908.1 | 36911.5 | 36860.7 | 36876.5 | 1138.0 |
| 2022-07-31 19:00:00 | YM | Futures | 36876.5 | 36909.2 | 36866.4 | 36900.2 | 528.0 |
| 2022-07-31 19:30:00 | YM | Futures | 36900.2 | 36926.2 | 36884.4 | 36888.9 | 922.0 |
| 2022-07-31 20:00:00 | YM | Futures | 36888.9 | 36921.7 | 36867.5 | 36917.1 | 991.0 |
| 2022-07-31 20:30:00 | YM | Futures | 36920.5 | 36920.5 | 36894.6 | 36903.6 | 410.0 |
| 2022-07-31 21:00:00 | YM | Futures | 36908.1 | 36921.7 | 36888.9 | 36914.9 | 800.0 |
| 2022-07-31 21:30:00 | YM | Futures | 36913.8 | 36929.6 | 36891.2 | 36913.8 | 682.0 |
| 2022-07-31 22:00:00 | YM | Futures | 36911.5 | 36919.4 | 36892.3 | 36918.3 | 401.0 |
| 2022-07-31 22:30:00 | YM | Futures | 36918.3 | 36927.3 | 36903.6 | 36919.4 | 397.0 |
| 2022-07-31 23:00:00 | YM | Futures | 36920.5 | 36921.7 | 36863.0 | 36867.5 | 860.0 |
| 2022-07-31 23:30:00 | YM | Futures | 36868.6 | 36874.3 | 36859.6 | 36867.5 | 346.0 |
| 2022-07-31 18:00:00 | CL | Futures | 78.21 | 78.36 | 77.49 | 77.74 | 2144.0 |
| 2022-07-31 18:30:00 | CL | Futures | 77.75 | 78.02 | 77.72 | 77.86 | 1243.0 |
| 2022-07-31 19:00:00 | CL | Futures | 77.86 | 77.92 | 77.7 | 77.79 | 616.0 |
| 2022-07-31 19:30:00 | CL | Futures | 77.78 | 77.84 | 77.61 | 77.8 | 877.0 |
| 2022-07-31 20:00:00 | CL | Futures | 77.8 | 77.96 | 77.56 | 77.84 | 1512.0 |
| 2022-07-31 20:30:00 | CL | Futures | 77.84 | 77.89 | 77.63 | 77.67 | 1555.0 |
| 2022-07-31 21:00:00 | CL | Futures | 77.69 | 77.89 | 77.1 | 77.34 | 5417.0 |
| 2022-07-31 21:30:00 | CL | Futures | 77.34 | 77.73 | 77.25 | 77.46 | 2817.0 |
| 2022-07-31 22:00:00 | CL | Futures | 77.48 | 77.55 | 77.17 | 77.43 | 1884.0 |
| 2022-07-31 22:30:00 | CL | Futures | 77.42 | 77.63 | 77.3 | 77.57 | 1743.0 |
| 2022-07-31 23:00:00 | CL | Futures | 77.57 | 77.61 | 77.18 | 77.34 | 1763.0 |
| 2022-07-31 23:30:00 | CL | Futures | 77.34 | 77.38 | 77.26 | 77.26 | 643.0 |
| 2022-07-31 18:00:00 | GC | Futures | 2105.4 | 2106.3 | 2103.0 | 2103.1 | 971.0 |
| 2022-07-31 18:30:00 | GC | Futures | 2103.0 | 2103.0 | 2101.8 | 2102.2 | 511.0 |
> showing 50 of 796 rows — these rows as CSV