PREVIEW / futures_1hour / 2022-10-23
file: by_date/futures_1hour/2022/2022-10-23.parquet size: 20 KB rows: 426
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-10-23 18:00:00 | ES | Futures | 4252.08 | 4299.72 | 4251.8 | 4278.3 | 40337.0 |
| 2022-10-23 19:00:00 | ES | Futures | 4278.02 | 4286.47 | 4269.56 | 4269.56 | 23844.0 |
| 2022-10-23 20:00:00 | ES | Futures | 4269.56 | 4276.89 | 4263.92 | 4266.46 | 19699.0 |
| 2022-10-23 21:00:00 | ES | Futures | 4266.46 | 4269.28 | 4255.18 | 4261.1 | 22210.0 |
| 2022-10-23 22:00:00 | ES | Futures | 4261.1 | 4261.39 | 4253.49 | 4256.88 | 16633.0 |
| 2022-10-23 23:00:00 | ES | Futures | 4257.16 | 4258.0 | 4243.34 | 4247.01 | 16900.0 |
| 2022-10-23 18:00:00 | NQ | Futures | 13094.88 | 13251.76 | 13088.27 | 13191.42 | 16329.0 |
| 2022-10-23 19:00:00 | NQ | Futures | 13190.56 | 13215.27 | 13161.25 | 13161.54 | 9612.0 |
| 2022-10-23 20:00:00 | NQ | Futures | 13161.54 | 13188.55 | 13139.7 | 13155.22 | 9504.0 |
| 2022-10-23 21:00:00 | NQ | Futures | 13154.35 | 13158.95 | 13109.24 | 13122.17 | 9817.0 |
| 2022-10-23 22:00:00 | NQ | Futures | 13123.32 | 13124.76 | 13094.3 | 13110.39 | 7437.0 |
| 2022-10-23 23:00:00 | NQ | Futures | 13110.68 | 13119.3 | 13059.54 | 13075.63 | 6747.0 |
| 2022-10-23 18:00:00 | YM | Futures | 35002.5 | 35312.2 | 34986.8 | 35152.8 | 5583.0 |
| 2022-10-23 19:00:00 | YM | Futures | 35149.5 | 35225.8 | 35095.6 | 35095.6 | 3203.0 |
| 2022-10-23 20:00:00 | YM | Futures | 35097.9 | 35145.0 | 35039.5 | 35061.9 | 3202.0 |
| 2022-10-23 21:00:00 | YM | Futures | 35059.7 | 35088.9 | 34983.4 | 35033.9 | 2874.0 |
| 2022-10-23 22:00:00 | YM | Futures | 35033.9 | 35036.1 | 34983.4 | 35002.5 | 1423.0 |
| 2022-10-23 23:00:00 | YM | Futures | 35003.6 | 35010.3 | 34907.1 | 34930.6 | 1677.0 |
| 2022-10-23 18:00:00 | CL | Futures | 69.35 | 69.56 | 69.19 | 69.44 | 2393.0 |
| 2022-10-23 19:00:00 | CL | Futures | 69.45 | 69.66 | 69.28 | 69.44 | 1769.0 |
| 2022-10-23 20:00:00 | CL | Futures | 69.45 | 69.64 | 69.35 | 69.49 | 1716.0 |
| 2022-10-23 21:00:00 | CL | Futures | 69.48 | 69.84 | 69.39 | 69.58 | 3440.0 |
| 2022-10-23 22:00:00 | CL | Futures | 69.58 | 69.62 | 68.96 | 68.96 | 3124.0 |
| 2022-10-23 23:00:00 | CL | Futures | 68.96 | 68.98 | 68.75 | 68.85 | 1895.0 |
| 2022-10-23 18:00:00 | GC | Futures | 1964.1 | 1973.9 | 1963.4 | 1965.2 | 6305.0 |
| 2022-10-23 19:00:00 | GC | Futures | 1965.2 | 1979.0 | 1962.1 | 1967.5 | 9242.0 |
| 2022-10-23 20:00:00 | GC | Futures | 1967.5 | 1970.3 | 1962.1 | 1962.9 | 5978.0 |
| 2022-10-23 21:00:00 | GC | Futures | 1962.9 | 1963.1 | 1959.0 | 1959.0 | 4776.0 |
| 2022-10-23 22:00:00 | GC | Futures | 1959.2 | 1962.2 | 1956.7 | 1961.4 | 3486.0 |
| 2022-10-23 23:00:00 | GC | Futures | 1961.5 | 1961.8 | 1958.7 | 1959.4 | 1328.0 |
| 2022-10-23 18:00:00 | ZN | Futures | 113.243487 | 113.533607 | 113.243487 | 113.388547 | 19202.0 |
| 2022-10-23 19:00:00 | ZN | Futures | 113.388547 | 113.469136 | 113.259605 | 113.356311 | 16832.0 |
| 2022-10-23 20:00:00 | ZN | Futures | 113.356311 | 113.420783 | 113.29184 | 113.356311 | 12937.0 |
| 2022-10-23 21:00:00 | ZN | Futures | 113.356311 | 113.485254 | 113.29184 | 113.4369 | 15994.0 |
| 2022-10-23 22:00:00 | ZN | Futures | 113.4369 | 113.678667 | 113.420783 | 113.662549 | 27463.0 |
| 2022-10-23 23:00:00 | ZN | Futures | 113.662549 | 113.662549 | 113.58196 | 113.630314 | 11174.0 |
> showing 36 of 426 rows — these rows as CSV