PREVIEW / futures_1hour / 2023-02-12
file: by_date/futures_1hour/2023/2023-02-12.parquet size: 19 KB rows: 424
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 |
|---|---|---|---|---|---|---|---|
| 2023-02-12 18:00:00 | ES | Futures | 4591.14 | 4593.38 | 4571.57 | 4573.24 | 12394.0 |
| 2023-02-12 19:00:00 | ES | Futures | 4573.24 | 4575.48 | 4568.77 | 4573.52 | 6353.0 |
| 2023-02-12 20:00:00 | ES | Futures | 4573.52 | 4574.08 | 4561.78 | 4567.37 | 12400.0 |
| 2023-02-12 21:00:00 | ES | Futures | 4567.65 | 4570.45 | 4565.7 | 4569.61 | 4889.0 |
| 2023-02-12 22:00:00 | ES | Futures | 4569.33 | 4575.2 | 4564.58 | 4565.14 | 9468.0 |
| 2023-02-12 23:00:00 | ES | Futures | 4565.14 | 4567.65 | 4564.86 | 4565.98 | 3079.0 |
| 2023-02-12 18:00:00 | NQ | Futures | 14062.54 | 14073.35 | 13990.56 | 14004.79 | 5877.0 |
| 2023-02-12 19:00:00 | NQ | Futures | 14004.79 | 14016.45 | 13986.58 | 14010.19 | 3360.0 |
| 2023-02-12 20:00:00 | NQ | Futures | 14009.91 | 14012.76 | 13957.56 | 13980.04 | 6489.0 |
| 2023-02-12 21:00:00 | NQ | Futures | 13980.61 | 13989.43 | 13969.8 | 13987.44 | 2793.0 |
| 2023-02-12 22:00:00 | NQ | Futures | 13986.87 | 14014.75 | 13976.06 | 13978.33 | 4156.0 |
| 2023-02-12 23:00:00 | NQ | Futures | 13977.76 | 13989.14 | 13976.62 | 13979.75 | 1773.0 |
| 2023-02-12 18:00:00 | YM | Futures | 37776.3 | 37817.6 | 37681.6 | 37693.9 | 1736.0 |
| 2023-02-12 19:00:00 | YM | Futures | 37692.8 | 37700.6 | 37661.6 | 37690.5 | 1186.0 |
| 2023-02-12 20:00:00 | YM | Futures | 37689.4 | 37691.7 | 37613.7 | 37652.7 | 2056.0 |
| 2023-02-12 21:00:00 | YM | Futures | 37652.7 | 37674.9 | 37644.9 | 37668.3 | 661.0 |
| 2023-02-12 22:00:00 | YM | Futures | 37670.5 | 37701.7 | 37632.6 | 37634.8 | 1439.0 |
| 2023-02-12 23:00:00 | YM | Futures | 37634.8 | 37647.1 | 37629.3 | 37643.7 | 484.0 |
| 2023-02-12 18:00:00 | CL | Futures | 65.06 | 65.19 | 64.58 | 64.67 | 546.0 |
| 2023-02-12 19:00:00 | CL | Futures | 64.67 | 64.67 | 64.54 | 64.61 | 198.0 |
| 2023-02-12 20:00:00 | CL | Futures | 64.61 | 64.63 | 64.27 | 64.5 | 679.0 |
| 2023-02-12 21:00:00 | CL | Futures | 64.49 | 64.57 | 64.28 | 64.38 | 588.0 |
| 2023-02-12 22:00:00 | CL | Futures | 64.39 | 64.41 | 64.32 | 64.36 | 232.0 |
| 2023-02-12 23:00:00 | CL | Futures | 64.37 | 64.38 | 64.2 | 64.23 | 335.0 |
| 2023-02-12 18:00:00 | GC | Futures | 2179.2 | 2179.2 | 2175.4 | 2175.5 | 1373.0 |
| 2023-02-12 19:00:00 | GC | Futures | 2175.5 | 2176.4 | 2173.1 | 2176.0 | 1931.0 |
| 2023-02-12 20:00:00 | GC | Futures | 2176.0 | 2176.8 | 2170.2 | 2174.0 | 3640.0 |
| 2023-02-12 21:00:00 | GC | Futures | 2174.0 | 2175.2 | 2172.2 | 2174.2 | 2528.0 |
| 2023-02-12 22:00:00 | GC | Futures | 2174.2 | 2174.9 | 2171.0 | 2171.0 | 2661.0 |
| 2023-02-12 23:00:00 | GC | Futures | 2171.0 | 2172.2 | 2169.7 | 2169.9 | 1865.0 |
| 2023-02-12 18:00:00 | ZN | Futures | 116.03478 | 116.131355 | 115.970397 | 116.099163 | 17446.0 |
| 2023-02-12 19:00:00 | ZN | Futures | 116.099163 | 116.147451 | 116.050876 | 116.115259 | 12173.0 |
| 2023-02-12 20:00:00 | ZN | Futures | 116.131355 | 116.147451 | 116.083067 | 116.099163 | 11476.0 |
| 2023-02-12 21:00:00 | ZN | Futures | 116.099163 | 116.115259 | 116.018684 | 116.03478 | 14532.0 |
| 2023-02-12 22:00:00 | ZN | Futures | 116.018684 | 116.115259 | 116.018684 | 116.066972 | 11186.0 |
| 2023-02-12 23:00:00 | ZN | Futures | 116.066972 | 116.099163 | 116.03478 | 116.099163 | 8213.0 |
> showing 36 of 424 rows — these rows as CSV