PREVIEW / futures_1hour / 2021-06-06
file: by_date/futures_1hour/2021/2021-06-06.parquet size: 17 KB rows: 374
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-06-06 18:00:00 | ES | Futures | 4756.53 | 4756.81 | 4750.35 | 4752.32 | 6423.0 |
| 2021-06-06 19:00:00 | ES | Futures | 4752.6 | 4754.28 | 4751.47 | 4752.88 | 3830.0 |
| 2021-06-06 20:00:00 | ES | Futures | 4752.88 | 4753.44 | 4745.01 | 4746.7 | 12758.0 |
| 2021-06-06 21:00:00 | ES | Futures | 4746.7 | 4747.82 | 4742.76 | 4743.04 | 8381.0 |
| 2021-06-06 22:00:00 | ES | Futures | 4743.32 | 4746.7 | 4742.2 | 4744.45 | 5979.0 |
| 2021-06-06 23:00:00 | ES | Futures | 4744.17 | 4748.38 | 4743.89 | 4745.85 | 4163.0 |
| 2021-06-06 18:00:00 | NQ | Futures | 15949.16 | 15962.48 | 15943.08 | 15950.32 | 3873.0 |
| 2021-06-06 19:00:00 | NQ | Futures | 15950.32 | 15954.37 | 15940.77 | 15942.51 | 2115.0 |
| 2021-06-06 20:00:00 | NQ | Futures | 15941.64 | 15943.37 | 15912.4 | 15921.66 | 5813.0 |
| 2021-06-06 21:00:00 | NQ | Futures | 15921.95 | 15925.71 | 15902.55 | 15906.9 | 4875.0 |
| 2021-06-06 22:00:00 | NQ | Futures | 15906.61 | 15923.69 | 15903.13 | 15915.29 | 2749.0 |
| 2021-06-06 23:00:00 | NQ | Futures | 15914.71 | 15928.03 | 15912.11 | 15917.9 | 1542.0 |
| 2021-06-06 18:00:00 | YM | Futures | 38716.3 | 38727.5 | 38694.1 | 38709.6 | 1283.0 |
| 2021-06-06 19:00:00 | YM | Futures | 38708.5 | 38737.5 | 38698.5 | 38727.5 | 917.0 |
| 2021-06-06 20:00:00 | YM | Futures | 38725.2 | 38733.0 | 38658.4 | 38670.7 | 1752.0 |
| 2021-06-06 21:00:00 | YM | Futures | 38670.7 | 38679.6 | 38645.0 | 38647.3 | 1123.0 |
| 2021-06-06 22:00:00 | YM | Futures | 38646.2 | 38669.5 | 38635.0 | 38655.1 | 1098.0 |
| 2021-06-06 23:00:00 | YM | Futures | 38655.1 | 38682.9 | 38652.8 | 38668.4 | 591.0 |
| 2021-06-06 18:00:00 | CL | Futures | 47.11 | 47.19 | 47.04 | 47.15 | 2790.0 |
| 2021-06-06 19:00:00 | CL | Futures | 47.15 | 47.27 | 47.14 | 47.25 | 1714.0 |
| 2021-06-06 20:00:00 | CL | Futures | 47.25 | 47.32 | 47.22 | 47.27 | 3425.0 |
| 2021-06-06 21:00:00 | CL | Futures | 47.27 | 47.44 | 46.97 | 46.99 | 11351.0 |
| 2021-06-06 22:00:00 | CL | Futures | 46.99 | 47.11 | 46.95 | 47.05 | 5567.0 |
| 2021-06-06 23:00:00 | CL | Futures | 47.05 | 47.08 | 46.93 | 46.94 | 3294.0 |
| 2021-06-06 18:00:00 | GC | Futures | 2285.5 | 2285.9 | 2282.6 | 2283.2 | 1253.0 |
| 2021-06-06 19:00:00 | GC | Futures | 2283.2 | 2283.8 | 2281.8 | 2282.5 | 832.0 |
| 2021-06-06 20:00:00 | GC | Futures | 2282.6 | 2285.4 | 2281.9 | 2283.9 | 2882.0 |
| 2021-06-06 21:00:00 | GC | Futures | 2283.8 | 2285.0 | 2279.0 | 2279.5 | 6573.0 |
| 2021-06-06 22:00:00 | GC | Futures | 2279.4 | 2280.3 | 2276.8 | 2279.8 | 3915.0 |
| 2021-06-06 23:00:00 | GC | Futures | 2279.8 | 2282.0 | 2278.9 | 2280.2 | 2393.0 |
| 2021-06-06 18:00:00 | ZN | Futures | 134.44825 | 134.44825 | 134.44825 | 134.44825 | 60.0 |
| 2021-06-06 20:00:00 | ZN | Futures | 134.385114 | 134.416682 | 134.353546 | 134.353546 | 731.0 |
| 2021-06-06 21:00:00 | ZN | Futures | 134.400898 | 134.400898 | 134.400898 | 134.400898 | 50.0 |
| 2021-06-06 22:00:00 | ZN | Futures | 134.36933 | 134.36933 | 134.36933 | 134.36933 | 3.0 |
| 2021-06-06 23:00:00 | ZN | Futures | 134.36933 | 134.385114 | 134.36933 | 134.385114 | 22.0 |
> showing 35 of 374 rows — these rows as CSV