PREVIEW / futures_1hour / 2021-05-23
file: by_date/futures_1hour/2021/2021-05-23.parquet size: 17 KB rows: 365
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-23 18:00:00 | ES | Futures | 4665.78 | 4666.34 | 4655.66 | 4662.97 | 12843.0 |
| 2021-05-23 19:00:00 | ES | Futures | 4663.25 | 4670.27 | 4662.97 | 4663.53 | 9409.0 |
| 2021-05-23 20:00:00 | ES | Futures | 4663.53 | 4677.86 | 4663.53 | 4677.02 | 14893.0 |
| 2021-05-23 21:00:00 | ES | Futures | 4677.02 | 4683.76 | 4677.02 | 4682.07 | 12973.0 |
| 2021-05-23 22:00:00 | ES | Futures | 4681.79 | 4682.63 | 4672.24 | 4676.17 | 10424.0 |
| 2021-05-23 23:00:00 | ES | Futures | 4676.45 | 4681.23 | 4675.89 | 4679.26 | 5877.0 |
| 2021-05-23 18:00:00 | NQ | Futures | 15497.55 | 15508.84 | 15466.57 | 15484.52 | 5893.0 |
| 2021-05-23 19:00:00 | NQ | Futures | 15485.1 | 15513.18 | 15474.1 | 15478.44 | 4477.0 |
| 2021-05-23 20:00:00 | NQ | Futures | 15478.73 | 15534.32 | 15471.21 | 15531.13 | 5973.0 |
| 2021-05-23 21:00:00 | NQ | Futures | 15531.71 | 15571.08 | 15531.71 | 15556.61 | 5703.0 |
| 2021-05-23 22:00:00 | NQ | Futures | 15556.03 | 15559.79 | 15498.71 | 15523.03 | 5171.0 |
| 2021-05-23 23:00:00 | NQ | Futures | 15523.32 | 15550.24 | 15521.58 | 15540.69 | 2851.0 |
| 2021-05-23 18:00:00 | YM | Futures | 38036.9 | 38061.4 | 37982.3 | 38055.8 | 1992.0 |
| 2021-05-23 19:00:00 | YM | Futures | 38060.3 | 38122.7 | 38059.2 | 38074.8 | 2126.0 |
| 2021-05-23 20:00:00 | YM | Futures | 38073.7 | 38191.7 | 38071.4 | 38181.7 | 2669.0 |
| 2021-05-23 21:00:00 | YM | Futures | 38182.8 | 38216.2 | 38168.3 | 38199.5 | 2106.0 |
| 2021-05-23 22:00:00 | YM | Futures | 38198.4 | 38202.9 | 38142.7 | 38165.0 | 1408.0 |
| 2021-05-23 23:00:00 | YM | Futures | 38169.4 | 38202.9 | 38162.8 | 38191.7 | 1085.0 |
| 2021-05-23 18:00:00 | CL | Futures | 43.28 | 43.29 | 43.12 | 43.21 | 2628.0 |
| 2021-05-23 19:00:00 | CL | Futures | 43.21 | 43.23 | 43.13 | 43.13 | 993.0 |
| 2021-05-23 20:00:00 | CL | Futures | 43.13 | 43.33 | 43.13 | 43.27 | 3341.0 |
| 2021-05-23 21:00:00 | CL | Futures | 43.27 | 43.47 | 43.18 | 43.46 | 9552.0 |
| 2021-05-23 22:00:00 | CL | Futures | 43.46 | 43.51 | 43.36 | 43.47 | 4788.0 |
| 2021-05-23 23:00:00 | CL | Futures | 43.48 | 43.5 | 43.35 | 43.36 | 3071.0 |
| 2021-05-23 18:00:00 | GC | Futures | 2275.3 | 2275.3 | 2272.1 | 2273.2 | 1589.0 |
| 2021-05-23 19:00:00 | GC | Futures | 2273.0 | 2276.7 | 2272.8 | 2276.1 | 2026.0 |
| 2021-05-23 20:00:00 | GC | Futures | 2276.2 | 2277.2 | 2272.9 | 2273.0 | 3519.0 |
| 2021-05-23 21:00:00 | GC | Futures | 2273.2 | 2280.7 | 2271.6 | 2279.4 | 8734.0 |
| 2021-05-23 22:00:00 | GC | Futures | 2279.4 | 2280.4 | 2275.7 | 2276.1 | 4135.0 |
| 2021-05-23 23:00:00 | GC | Futures | 2276.1 | 2277.4 | 2275.5 | 2275.8 | 2805.0 |
| 2021-05-23 18:00:00 | ZN | Futures | 133.880026 | 133.89581 | 133.848458 | 133.848458 | 4283.0 |
| 2021-05-23 19:00:00 | ZN | Futures | 133.848458 | 133.880026 | 133.832674 | 133.864242 | 8344.0 |
| 2021-05-23 20:00:00 | ZN | Futures | 133.864242 | 133.864242 | 133.81689 | 133.81689 | 11109.0 |
| 2021-05-23 21:00:00 | ZN | Futures | 133.832674 | 133.864242 | 133.832674 | 133.832674 | 5448.0 |
| 2021-05-23 22:00:00 | ZN | Futures | 133.832674 | 133.848458 | 133.81689 | 133.81689 | 7104.0 |
| 2021-05-23 23:00:00 | ZN | Futures | 133.832674 | 133.848458 | 133.81689 | 133.832674 | 1501.0 |
> showing 36 of 365 rows — these rows as CSV