PREVIEW / futures_30min / 2022-07-17
file: by_date/futures_30min/2022/2022-07-17.parquet size: 29 KB rows: 767
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-17 18:00:00 | ES | Futures | 4394.67 | 4398.07 | 4383.34 | 4384.76 | 6090.0 |
| 2022-07-17 18:30:00 | ES | Futures | 4384.76 | 4389.01 | 4383.91 | 4385.04 | 2345.0 |
| 2022-07-17 19:00:00 | ES | Futures | 4385.04 | 4390.99 | 4384.19 | 4389.58 | 2850.0 |
| 2022-07-17 19:30:00 | ES | Futures | 4389.58 | 4392.12 | 4388.44 | 4390.14 | 1590.0 |
| 2022-07-17 20:00:00 | ES | Futures | 4390.14 | 4392.12 | 4385.33 | 4388.16 | 2954.0 |
| 2022-07-17 20:30:00 | ES | Futures | 4388.16 | 4388.44 | 4380.23 | 4381.93 | 3214.0 |
| 2022-07-17 21:00:00 | ES | Futures | 4382.21 | 4391.27 | 4381.93 | 4388.73 | 3342.0 |
| 2022-07-17 21:30:00 | ES | Futures | 4389.01 | 4389.86 | 4383.91 | 4388.44 | 2864.0 |
| 2022-07-17 22:00:00 | ES | Futures | 4389.01 | 4390.14 | 4386.18 | 4386.74 | 1572.0 |
| 2022-07-17 22:30:00 | ES | Futures | 4386.74 | 4391.27 | 4385.33 | 4390.42 | 2764.0 |
| 2022-07-17 23:00:00 | ES | Futures | 4390.71 | 4399.49 | 4390.14 | 4398.07 | 4110.0 |
| 2022-07-17 23:30:00 | ES | Futures | 4398.07 | 4400.91 | 4395.81 | 4396.94 | 2879.0 |
| 2022-07-17 18:00:00 | NQ | Futures | 13933.8 | 13973.72 | 13929.75 | 13935.54 | 3418.0 |
| 2022-07-17 18:30:00 | NQ | Futures | 13935.54 | 13947.97 | 13931.49 | 13934.96 | 1577.0 |
| 2022-07-17 19:00:00 | NQ | Futures | 13935.54 | 13960.12 | 13934.09 | 13950.58 | 1707.0 |
| 2022-07-17 19:30:00 | NQ | Futures | 13949.42 | 13959.54 | 13946.24 | 13952.6 | 962.0 |
| 2022-07-17 20:00:00 | NQ | Futures | 13951.45 | 13954.34 | 13933.22 | 13942.19 | 1732.0 |
| 2022-07-17 20:30:00 | NQ | Futures | 13942.48 | 13944.5 | 13915.87 | 13926.57 | 2043.0 |
| 2022-07-17 21:00:00 | NQ | Futures | 13926.28 | 13953.47 | 13926.28 | 13945.08 | 1976.0 |
| 2022-07-17 21:30:00 | NQ | Futures | 13946.82 | 13951.16 | 13928.6 | 13943.06 | 1766.0 |
| 2022-07-17 22:00:00 | NQ | Futures | 13943.93 | 13948.26 | 13934.38 | 13935.83 | 1154.0 |
| 2022-07-17 22:30:00 | NQ | Futures | 13936.98 | 13952.6 | 13933.22 | 13950.58 | 1335.0 |
| 2022-07-17 23:00:00 | NQ | Futures | 13951.16 | 13995.41 | 13949.71 | 13991.94 | 3513.0 |
| 2022-07-17 23:30:00 | NQ | Futures | 13991.07 | 14003.51 | 13987.6 | 13998.01 | 2595.0 |
| 2022-07-17 18:00:00 | YM | Futures | 35314.9 | 35345.4 | 35255.1 | 35267.5 | 1460.0 |
| 2022-07-17 18:30:00 | YM | Futures | 35268.6 | 35299.1 | 35261.9 | 35272.0 | 750.0 |
| 2022-07-17 19:00:00 | YM | Futures | 35275.4 | 35325.1 | 35265.2 | 35317.2 | 911.0 |
| 2022-07-17 19:30:00 | YM | Futures | 35316.0 | 35331.8 | 35308.1 | 35319.4 | 584.0 |
| 2022-07-17 20:00:00 | YM | Futures | 35319.4 | 35334.1 | 35279.9 | 35296.8 | 649.0 |
| 2022-07-17 20:30:00 | YM | Futures | 35299.1 | 35302.5 | 35240.4 | 35250.6 | 628.0 |
| 2022-07-17 21:00:00 | YM | Futures | 35254.0 | 35326.2 | 35250.6 | 35304.7 | 633.0 |
| 2022-07-17 21:30:00 | YM | Futures | 35304.7 | 35316.0 | 35275.4 | 35303.6 | 574.0 |
| 2022-07-17 22:00:00 | YM | Futures | 35308.1 | 35317.2 | 35292.3 | 35294.6 | 243.0 |
| 2022-07-17 22:30:00 | YM | Futures | 35294.6 | 35328.4 | 35292.3 | 35325.1 | 404.0 |
| 2022-07-17 23:00:00 | YM | Futures | 35327.3 | 35372.4 | 35322.8 | 35364.5 | 1104.0 |
| 2022-07-17 23:30:00 | YM | Futures | 35364.5 | 35365.7 | 35337.5 | 35344.2 | 742.0 |
| 2022-07-17 18:00:00 | CL | Futures | 74.94 | 75.46 | 74.82 | 74.85 | 1649.0 |
| 2022-07-17 18:30:00 | CL | Futures | 74.87 | 75.09 | 74.86 | 75.06 | 880.0 |
| 2022-07-17 19:00:00 | CL | Futures | 75.04 | 75.1 | 74.89 | 75.03 | 550.0 |
| 2022-07-17 19:30:00 | CL | Futures | 75.03 | 75.06 | 74.84 | 74.87 | 486.0 |
| 2022-07-17 20:00:00 | CL | Futures | 74.86 | 74.86 | 74.41 | 74.52 | 1301.0 |
| 2022-07-17 20:30:00 | CL | Futures | 74.51 | 74.51 | 73.78 | 73.94 | 2818.0 |
| 2022-07-17 21:00:00 | CL | Futures | 73.94 | 74.94 | 73.83 | 74.7 | 6179.0 |
| 2022-07-17 21:30:00 | CL | Futures | 74.71 | 74.76 | 74.33 | 74.6 | 2724.0 |
| 2022-07-17 22:00:00 | CL | Futures | 74.6 | 74.85 | 74.38 | 74.63 | 1950.0 |
| 2022-07-17 22:30:00 | CL | Futures | 74.63 | 75.58 | 74.63 | 75.48 | 3715.0 |
| 2022-07-17 23:00:00 | CL | Futures | 75.47 | 75.72 | 75.33 | 75.57 | 3089.0 |
| 2022-07-17 23:30:00 | CL | Futures | 75.56 | 75.59 | 75.45 | 75.53 | 598.0 |
| 2022-07-17 18:00:00 | GC | Futures | 2036.6 | 2037.0 | 2034.2 | 2036.1 | 1468.0 |
| 2022-07-17 18:30:00 | GC | Futures | 2036.0 | 2037.4 | 2035.8 | 2037.4 | 418.0 |
> showing 50 of 767 rows — these rows as CSV