PREVIEW / futures_30min / 2022-07-03
file: by_date/futures_30min/2022/2022-07-03.parquet size: 27 KB rows: 701
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-03 18:00:00 | ES | Futures | 4338.02 | 4338.02 | 4329.52 | 4330.65 | 3187.0 |
| 2022-07-03 18:30:00 | ES | Futures | 4330.37 | 4331.5 | 4327.26 | 4330.94 | 2137.0 |
| 2022-07-03 19:00:00 | ES | Futures | 4330.94 | 4334.34 | 4328.95 | 4329.52 | 2110.0 |
| 2022-07-03 19:30:00 | ES | Futures | 4329.52 | 4329.52 | 4316.49 | 4319.04 | 4578.0 |
| 2022-07-03 20:00:00 | ES | Futures | 4318.76 | 4321.87 | 4313.37 | 4318.19 | 5952.0 |
| 2022-07-03 20:30:00 | ES | Futures | 4318.76 | 4321.59 | 4307.99 | 4309.98 | 4750.0 |
| 2022-07-03 21:00:00 | ES | Futures | 4309.69 | 4312.24 | 4301.19 | 4302.89 | 5303.0 |
| 2022-07-03 21:30:00 | ES | Futures | 4302.89 | 4311.11 | 4297.8 | 4309.98 | 6139.0 |
| 2022-07-03 22:00:00 | ES | Futures | 4309.98 | 4315.07 | 4304.31 | 4306.29 | 4505.0 |
| 2022-07-03 22:30:00 | ES | Futures | 4306.58 | 4308.56 | 4300.91 | 4306.86 | 3381.0 |
| 2022-07-03 23:00:00 | ES | Futures | 4306.86 | 4311.68 | 4306.29 | 4308.56 | 2370.0 |
| 2022-07-03 23:30:00 | ES | Futures | 4308.84 | 4312.53 | 4306.86 | 4311.11 | 2053.0 |
| 2022-07-03 18:00:00 | NQ | Futures | 13427.63 | 13442.38 | 13410.86 | 13418.09 | 1510.0 |
| 2022-07-03 18:30:00 | NQ | Futures | 13419.25 | 13423.01 | 13404.78 | 13419.82 | 927.0 |
| 2022-07-03 19:00:00 | NQ | Futures | 13420.11 | 13436.02 | 13415.77 | 13417.51 | 1134.0 |
| 2022-07-03 19:30:00 | NQ | Futures | 13417.8 | 13418.38 | 13374.99 | 13387.14 | 2464.0 |
| 2022-07-03 20:00:00 | NQ | Futures | 13386.27 | 13396.68 | 13361.69 | 13384.25 | 3170.0 |
| 2022-07-03 20:30:00 | NQ | Futures | 13385.12 | 13395.24 | 13335.08 | 13345.2 | 3266.0 |
| 2022-07-03 21:00:00 | NQ | Futures | 13342.89 | 13357.93 | 13318.88 | 13328.14 | 2613.0 |
| 2022-07-03 21:30:00 | NQ | Futures | 13328.42 | 13348.96 | 13305.0 | 13345.78 | 3578.0 |
| 2022-07-03 22:00:00 | NQ | Futures | 13346.07 | 13362.84 | 13324.95 | 13333.34 | 2236.0 |
| 2022-07-03 22:30:00 | NQ | Futures | 13333.63 | 13342.6 | 13314.25 | 13339.7 | 1813.0 |
| 2022-07-03 23:00:00 | NQ | Futures | 13338.84 | 13350.12 | 13330.45 | 13341.44 | 1377.0 |
| 2022-07-03 23:30:00 | NQ | Futures | 13340.57 | 13352.43 | 13331.9 | 13345.49 | 832.0 |
| 2022-07-03 18:00:00 | YM | Futures | 35036.2 | 35040.7 | 34985.4 | 34988.8 | 522.0 |
| 2022-07-03 18:30:00 | YM | Futures | 34991.1 | 34996.7 | 34965.1 | 34993.3 | 320.0 |
| 2022-07-03 19:00:00 | YM | Futures | 34992.2 | 35011.4 | 34976.4 | 34978.7 | 358.0 |
| 2022-07-03 19:30:00 | YM | Futures | 34977.5 | 34977.5 | 34881.6 | 34897.4 | 896.0 |
| 2022-07-03 20:00:00 | YM | Futures | 34894.0 | 34929.0 | 34869.2 | 34907.6 | 1113.0 |
| 2022-07-03 20:30:00 | YM | Futures | 34906.4 | 34925.6 | 34836.5 | 34852.3 | 923.0 |
| 2022-07-03 21:00:00 | YM | Futures | 34846.6 | 34865.8 | 34783.4 | 34797.0 | 776.0 |
| 2022-07-03 21:30:00 | YM | Futures | 34792.5 | 34869.2 | 34762.0 | 34856.8 | 789.0 |
| 2022-07-03 22:00:00 | YM | Futures | 34857.9 | 34890.6 | 34817.3 | 34826.3 | 644.0 |
| 2022-07-03 22:30:00 | YM | Futures | 34827.5 | 34842.1 | 34786.8 | 34829.7 | 396.0 |
| 2022-07-03 23:00:00 | YM | Futures | 34830.8 | 34871.5 | 34827.5 | 34848.9 | 342.0 |
| 2022-07-03 23:30:00 | YM | Futures | 34848.9 | 34871.5 | 34835.4 | 34865.8 | 316.0 |
| 2022-07-03 18:00:00 | CL | Futures | 84.23 | 84.31 | 83.82 | 83.88 | 970.0 |
| 2022-07-03 18:30:00 | CL | Futures | 83.89 | 83.96 | 83.75 | 83.96 | 361.0 |
| 2022-07-03 19:00:00 | CL | Futures | 83.94 | 84.06 | 83.87 | 83.99 | 375.0 |
| 2022-07-03 19:30:00 | CL | Futures | 84.01 | 84.01 | 83.71 | 83.75 | 501.0 |
| 2022-07-03 20:00:00 | CL | Futures | 83.75 | 83.88 | 83.46 | 83.63 | 1257.0 |
| 2022-07-03 20:30:00 | CL | Futures | 83.63 | 83.68 | 83.37 | 83.45 | 799.0 |
| 2022-07-03 21:00:00 | CL | Futures | 83.45 | 83.49 | 83.11 | 83.2 | 2651.0 |
| 2022-07-03 21:30:00 | CL | Futures | 83.2 | 83.74 | 83.03 | 83.69 | 2539.0 |
| 2022-07-03 22:00:00 | CL | Futures | 83.69 | 83.89 | 83.57 | 83.65 | 1629.0 |
| 2022-07-03 22:30:00 | CL | Futures | 83.65 | 83.79 | 83.59 | 83.66 | 1305.0 |
| 2022-07-03 23:00:00 | CL | Futures | 83.66 | 83.93 | 83.66 | 83.86 | 1264.0 |
| 2022-07-03 23:30:00 | CL | Futures | 83.86 | 83.88 | 83.75 | 83.77 | 515.0 |
| 2022-07-03 18:00:00 | GC | Futures | 2165.5 | 2165.5 | 2160.8 | 2161.2 | 1254.0 |
| 2022-07-03 18:30:00 | GC | Futures | 2161.2 | 2161.6 | 2160.4 | 2161.3 | 364.0 |
> showing 50 of 701 rows — these rows as CSV