PREVIEW / futures_1hour / 2022-04-10
file: by_date/futures_1hour/2022/2022-04-10.parquet size: 20 KB rows: 429
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-04-10 18:00:00 | ES | Futures | 5089.17 | 5092.0 | 5084.35 | 5086.9 | 6006.0 |
| 2022-04-10 19:00:00 | ES | Futures | 5086.9 | 5087.75 | 5074.71 | 5074.71 | 5914.0 |
| 2022-04-10 20:00:00 | ES | Futures | 5074.71 | 5077.26 | 5063.94 | 5076.41 | 13488.0 |
| 2022-04-10 21:00:00 | ES | Futures | 5076.13 | 5078.68 | 5058.84 | 5061.68 | 10720.0 |
| 2022-04-10 22:00:00 | ES | Futures | 5061.68 | 5062.81 | 5050.62 | 5053.17 | 12718.0 |
| 2022-04-10 23:00:00 | ES | Futures | 5053.17 | 5056.57 | 5045.24 | 5051.75 | 9740.0 |
| 2022-04-10 18:00:00 | NQ | Futures | 16638.77 | 16681.68 | 16633.84 | 16660.23 | 4735.0 |
| 2022-04-10 19:00:00 | NQ | Futures | 16660.81 | 16666.9 | 16602.52 | 16603.39 | 4271.0 |
| 2022-04-10 20:00:00 | NQ | Futures | 16601.65 | 16601.65 | 16535.54 | 16584.25 | 8618.0 |
| 2022-04-10 21:00:00 | NQ | Futures | 16584.54 | 16598.75 | 16507.41 | 16519.3 | 6318.0 |
| 2022-04-10 22:00:00 | NQ | Futures | 16518.72 | 16527.71 | 16466.52 | 16489.14 | 7436.0 |
| 2022-04-10 23:00:00 | NQ | Futures | 16488.85 | 16506.83 | 16469.71 | 16504.8 | 4609.0 |
| 2022-04-10 18:00:00 | YM | Futures | 39046.2 | 39082.3 | 39022.6 | 39044.0 | 1306.0 |
| 2022-04-10 19:00:00 | YM | Futures | 39044.0 | 39051.9 | 38969.6 | 38969.6 | 1352.0 |
| 2022-04-10 20:00:00 | YM | Futures | 38968.4 | 39002.3 | 38913.2 | 38997.8 | 3134.0 |
| 2022-04-10 21:00:00 | YM | Futures | 38998.9 | 39012.4 | 38889.5 | 38904.2 | 1864.0 |
| 2022-04-10 22:00:00 | YM | Futures | 38905.3 | 38915.5 | 38842.2 | 38860.2 | 2645.0 |
| 2022-04-10 23:00:00 | YM | Futures | 38858.0 | 38882.8 | 38801.6 | 38838.8 | 2121.0 |
| 2022-04-10 18:00:00 | CL | Futures | 73.4 | 73.49 | 72.61 | 73.01 | 2495.0 |
| 2022-04-10 19:00:00 | CL | Futures | 73.01 | 73.04 | 72.03 | 72.17 | 2814.0 |
| 2022-04-10 20:00:00 | CL | Futures | 72.17 | 72.44 | 71.77 | 72.01 | 4400.0 |
| 2022-04-10 21:00:00 | CL | Futures | 72.02 | 72.2 | 71.55 | 71.68 | 4916.0 |
| 2022-04-10 22:00:00 | CL | Futures | 71.7 | 71.71 | 71.02 | 71.59 | 7091.0 |
| 2022-04-10 23:00:00 | CL | Futures | 71.61 | 71.91 | 71.42 | 71.54 | 2532.0 |
| 2022-04-10 18:00:00 | GC | Futures | 2334.5 | 2340.0 | 2334.1 | 2335.8 | 2911.0 |
| 2022-04-10 19:00:00 | GC | Futures | 2335.9 | 2336.3 | 2330.7 | 2332.7 | 2034.0 |
| 2022-04-10 20:00:00 | GC | Futures | 2332.8 | 2334.5 | 2332.2 | 2333.7 | 1991.0 |
| 2022-04-10 21:00:00 | GC | Futures | 2333.7 | 2336.9 | 2329.2 | 2332.2 | 3210.0 |
| 2022-04-10 22:00:00 | GC | Futures | 2332.1 | 2332.5 | 2327.3 | 2331.0 | 4393.0 |
| 2022-04-10 23:00:00 | GC | Futures | 2331.0 | 2334.3 | 2329.7 | 2330.2 | 2402.0 |
| 2022-04-10 18:00:00 | ZN | Futures | 123.198466 | 123.230549 | 123.086176 | 123.214508 | 10059.0 |
| 2022-04-10 19:00:00 | ZN | Futures | 123.230549 | 123.246591 | 123.166384 | 123.198466 | 7903.0 |
| 2022-04-10 20:00:00 | ZN | Futures | 123.198466 | 123.294715 | 123.150342 | 123.230549 | 16412.0 |
| 2022-04-10 21:00:00 | ZN | Futures | 123.230549 | 123.294715 | 123.118259 | 123.134301 | 12523.0 |
| 2022-04-10 22:00:00 | ZN | Futures | 123.134301 | 123.134301 | 122.781388 | 122.861596 | 52902.0 |
| 2022-04-10 23:00:00 | ZN | Futures | 122.845554 | 122.877637 | 122.749305 | 122.765347 | 29750.0 |
> showing 36 of 429 rows — these rows as CSV