PREVIEW / futures_1hour / 2022-03-13
file: by_date/futures_1hour/2022/2022-03-13.parquet size: 19 KB rows: 401
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-03-13 18:00:00 | ES | Futures | 4769.17 | 4783.6 | 4764.37 | 4780.49 | 8816.0 |
| 2022-03-13 19:00:00 | ES | Futures | 4780.49 | 4791.52 | 4774.83 | 4787.84 | 7290.0 |
| 2022-03-13 20:00:00 | ES | Futures | 4787.56 | 4796.04 | 4777.94 | 4784.45 | 8253.0 |
| 2022-03-13 21:00:00 | ES | Futures | 4785.01 | 4787.56 | 4777.38 | 4780.49 | 5736.0 |
| 2022-03-13 22:00:00 | ES | Futures | 4780.49 | 4780.49 | 4761.82 | 4769.17 | 7641.0 |
| 2022-03-13 23:00:00 | ES | Futures | 4769.17 | 4777.66 | 4764.37 | 4773.42 | 5509.0 |
| 2022-03-13 18:00:00 | NQ | Futures | 15490.15 | 15538.26 | 15460.3 | 15488.12 | 4765.0 |
| 2022-03-13 19:00:00 | NQ | Futures | 15490.15 | 15515.36 | 15467.83 | 15501.16 | 3143.0 |
| 2022-03-13 20:00:00 | NQ | Futures | 15499.71 | 15548.4 | 15470.44 | 15522.61 | 5207.0 |
| 2022-03-13 21:00:00 | NQ | Futures | 15525.79 | 15536.23 | 15479.13 | 15486.38 | 3339.0 |
| 2022-03-13 22:00:00 | NQ | Futures | 15484.93 | 15486.38 | 15411.32 | 15430.44 | 4113.0 |
| 2022-03-13 23:00:00 | NQ | Futures | 15430.44 | 15457.4 | 15405.23 | 15435.95 | 3158.0 |
| 2022-03-13 18:00:00 | YM | Futures | 37109.5 | 37204.2 | 37068.9 | 37197.4 | 2715.0 |
| 2022-03-13 19:00:00 | YM | Futures | 37197.4 | 37289.8 | 37170.3 | 37262.8 | 2031.0 |
| 2022-03-13 20:00:00 | YM | Futures | 37259.4 | 37307.9 | 37190.6 | 37223.3 | 2655.0 |
| 2022-03-13 21:00:00 | YM | Futures | 37223.3 | 37253.8 | 37186.1 | 37210.9 | 1431.0 |
| 2022-03-13 22:00:00 | YM | Futures | 37210.9 | 37210.9 | 37102.7 | 37155.7 | 1991.0 |
| 2022-03-13 23:00:00 | YM | Futures | 37154.6 | 37210.9 | 37119.6 | 37185.0 | 1459.0 |
| 2022-03-13 18:00:00 | CL | Futures | 79.47 | 79.69 | 77.36 | 78.07 | 7350.0 |
| 2022-03-13 19:00:00 | CL | Futures | 78.06 | 78.37 | 77.42 | 77.82 | 2510.0 |
| 2022-03-13 20:00:00 | CL | Futures | 77.82 | 77.89 | 77.18 | 77.7 | 2354.0 |
| 2022-03-13 21:00:00 | CL | Futures | 77.67 | 77.75 | 76.1 | 76.82 | 6954.0 |
| 2022-03-13 22:00:00 | CL | Futures | 76.83 | 77.26 | 76.79 | 76.97 | 2853.0 |
| 2022-03-13 23:00:00 | CL | Futures | 77.0 | 77.43 | 76.65 | 77.38 | 2952.0 |
| 2022-03-13 18:00:00 | GC | Futures | 2387.3 | 2394.6 | 2370.8 | 2381.9 | 4949.0 |
| 2022-03-13 19:00:00 | GC | Futures | 2381.5 | 2382.6 | 2371.8 | 2374.4 | 1971.0 |
| 2022-03-13 20:00:00 | GC | Futures | 2374.2 | 2379.8 | 2368.6 | 2377.4 | 3320.0 |
| 2022-03-13 21:00:00 | GC | Futures | 2377.3 | 2378.4 | 2370.8 | 2374.7 | 3728.0 |
| 2022-03-13 22:00:00 | GC | Futures | 2374.6 | 2376.6 | 2371.6 | 2373.0 | 1691.0 |
| 2022-03-13 23:00:00 | GC | Futures | 2373.2 | 2377.9 | 2371.7 | 2376.8 | 1915.0 |
| 2022-03-13 18:00:00 | ZN | Futures | 129.454639 | 129.486722 | 129.117768 | 129.133809 | 19269.0 |
| 2022-03-13 19:00:00 | ZN | Futures | 129.133809 | 129.181934 | 128.973395 | 129.03756 | 14018.0 |
| 2022-03-13 20:00:00 | ZN | Futures | 129.021519 | 129.053602 | 128.81298 | 128.989436 | 41260.0 |
| 2022-03-13 21:00:00 | ZN | Futures | 128.989436 | 129.069643 | 128.92527 | 128.973395 | 18864.0 |
| 2022-03-13 22:00:00 | ZN | Futures | 128.957353 | 129.021519 | 128.957353 | 128.973395 | 8962.0 |
| 2022-03-13 23:00:00 | ZN | Futures | 128.989436 | 129.005477 | 128.893187 | 128.909229 | 10146.0 |
> showing 36 of 401 rows — these rows as CSV