PREVIEW / futures_1hour / 2021-12-12
file: by_date/futures_1hour/2021/2021-12-12.parquet size: 18 KB rows: 390
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-12-12 18:00:00 | ES | Futures | 5318.29 | 5329.3 | 5318.01 | 5327.89 | 6436.0 |
| 2021-12-12 19:00:00 | ES | Futures | 5327.89 | 5335.23 | 5327.04 | 5334.94 | 6282.0 |
| 2021-12-12 20:00:00 | ES | Futures | 5334.94 | 5340.59 | 5333.81 | 5339.46 | 5500.0 |
| 2021-12-12 21:00:00 | ES | Futures | 5339.74 | 5340.31 | 5335.51 | 5336.07 | 2391.0 |
| 2021-12-12 22:00:00 | ES | Futures | 5336.07 | 5338.33 | 5334.94 | 5336.92 | 1776.0 |
| 2021-12-12 23:00:00 | ES | Futures | 5336.64 | 5339.18 | 5336.64 | 5337.2 | 962.0 |
| 2021-12-12 18:00:00 | NQ | Futures | 18921.29 | 18972.3 | 18915.79 | 18967.37 | 3027.0 |
| 2021-12-12 19:00:00 | NQ | Futures | 18965.92 | 18995.2 | 18964.19 | 18994.04 | 2947.0 |
| 2021-12-12 20:00:00 | NQ | Futures | 18994.91 | 19017.22 | 18990.27 | 19013.16 | 2863.0 |
| 2021-12-12 21:00:00 | NQ | Futures | 19014.32 | 19016.64 | 18990.27 | 18999.25 | 2265.0 |
| 2021-12-12 22:00:00 | NQ | Futures | 18999.54 | 19006.21 | 18990.56 | 18999.25 | 859.0 |
| 2021-12-12 23:00:00 | NQ | Futures | 18998.38 | 19004.76 | 18995.49 | 19001.86 | 535.0 |
| 2021-12-12 18:00:00 | YM | Futures | 40329.8 | 40409.6 | 40324.2 | 40397.2 | 1999.0 |
| 2021-12-12 19:00:00 | YM | Futures | 40396.1 | 40453.4 | 40388.3 | 40447.8 | 1909.0 |
| 2021-12-12 20:00:00 | YM | Futures | 40446.7 | 40490.5 | 40441.1 | 40481.5 | 1833.0 |
| 2021-12-12 21:00:00 | YM | Futures | 40482.7 | 40483.8 | 40448.9 | 40455.7 | 720.0 |
| 2021-12-12 22:00:00 | YM | Futures | 40454.6 | 40474.8 | 40445.6 | 40456.8 | 455.0 |
| 2021-12-12 23:00:00 | YM | Futures | 40457.9 | 40474.8 | 40451.2 | 40459.1 | 394.0 |
| 2021-12-12 18:00:00 | CL | Futures | 51.04 | 51.41 | 51.02 | 51.38 | 5040.0 |
| 2021-12-12 19:00:00 | CL | Futures | 51.37 | 51.48 | 51.29 | 51.29 | 2524.0 |
| 2021-12-12 20:00:00 | CL | Futures | 51.3 | 51.57 | 51.21 | 51.5 | 6194.0 |
| 2021-12-12 21:00:00 | CL | Futures | 51.5 | 51.53 | 51.4 | 51.48 | 2804.0 |
| 2021-12-12 22:00:00 | CL | Futures | 51.48 | 51.63 | 51.41 | 51.44 | 3592.0 |
| 2021-12-12 23:00:00 | CL | Futures | 51.44 | 51.58 | 51.42 | 51.52 | 2296.0 |
| 2021-12-12 18:00:00 | GC | Futures | 2144.8 | 2146.0 | 2142.5 | 2144.3 | 1721.0 |
| 2021-12-12 19:00:00 | GC | Futures | 2144.2 | 2144.8 | 2143.4 | 2143.6 | 1710.0 |
| 2021-12-12 20:00:00 | GC | Futures | 2143.7 | 2149.0 | 2143.6 | 2148.5 | 3647.0 |
| 2021-12-12 21:00:00 | GC | Futures | 2148.5 | 2151.9 | 2146.5 | 2147.1 | 3251.0 |
| 2021-12-12 22:00:00 | GC | Futures | 2147.0 | 2148.1 | 2146.6 | 2147.5 | 1327.0 |
| 2021-12-12 23:00:00 | GC | Futures | 2147.5 | 2148.8 | 2147.0 | 2147.9 | 981.0 |
| 2021-12-12 18:00:00 | ZN | Futures | 133.898457 | 134.026805 | 133.850327 | 133.850327 | 18229.0 |
| 2021-12-12 19:00:00 | ZN | Futures | 133.850327 | 133.86637 | 133.77011 | 133.786153 | 13334.0 |
| 2021-12-12 20:00:00 | ZN | Futures | 133.786153 | 133.802197 | 133.72198 | 133.786153 | 13109.0 |
| 2021-12-12 21:00:00 | ZN | Futures | 133.77011 | 133.81824 | 133.77011 | 133.786153 | 4587.0 |
| 2021-12-12 22:00:00 | ZN | Futures | 133.802197 | 133.802197 | 133.77011 | 133.802197 | 3812.0 |
| 2021-12-12 23:00:00 | ZN | Futures | 133.802197 | 133.81824 | 133.77011 | 133.802197 | 3587.0 |
> showing 36 of 390 rows — these rows as CSV