PREVIEW / futures_1hour / 2023-04-23
file: by_date/futures_1hour/2023/2023-04-23.parquet size: 18 KB rows: 400
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-04-23 18:00:00 | ES | Futures | 4604.07 | 4605.73 | 4602.4 | 4605.18 | 5625.0 |
| 2023-04-23 19:00:00 | ES | Futures | 4605.18 | 4606.84 | 4604.34 | 4604.62 | 3297.0 |
| 2023-04-23 20:00:00 | ES | Futures | 4604.62 | 4604.62 | 4597.96 | 4601.02 | 8684.0 |
| 2023-04-23 21:00:00 | ES | Futures | 4600.74 | 4602.68 | 4599.63 | 4599.91 | 5875.0 |
| 2023-04-23 22:00:00 | ES | Futures | 4599.63 | 4601.57 | 4596.58 | 4598.52 | 5935.0 |
| 2023-04-23 23:00:00 | ES | Futures | 4598.52 | 4599.35 | 4596.86 | 4597.69 | 2736.0 |
| 2023-04-23 18:00:00 | NQ | Futures | 14719.59 | 14723.25 | 14708.89 | 14719.87 | 2623.0 |
| 2023-04-23 19:00:00 | NQ | Futures | 14720.72 | 14724.94 | 14715.65 | 14718.18 | 1661.0 |
| 2023-04-23 20:00:00 | NQ | Futures | 14717.34 | 14717.62 | 14692.84 | 14704.67 | 4641.0 |
| 2023-04-23 21:00:00 | NQ | Futures | 14704.39 | 14713.68 | 14701.29 | 14702.7 | 3255.0 |
| 2023-04-23 22:00:00 | NQ | Futures | 14701.85 | 14714.52 | 14695.94 | 14702.7 | 3299.0 |
| 2023-04-23 23:00:00 | NQ | Futures | 14702.14 | 14705.51 | 14695.94 | 14699.32 | 1519.0 |
| 2023-04-23 18:00:00 | YM | Futures | 37494.3 | 37494.3 | 37465.5 | 37476.6 | 914.0 |
| 2023-04-23 19:00:00 | YM | Futures | 37476.6 | 37487.6 | 37473.3 | 37474.4 | 600.0 |
| 2023-04-23 20:00:00 | YM | Futures | 37473.3 | 37473.3 | 37419.1 | 37439.0 | 1909.0 |
| 2023-04-23 21:00:00 | YM | Futures | 37436.8 | 37445.6 | 37420.2 | 37420.2 | 1069.0 |
| 2023-04-23 22:00:00 | YM | Futures | 37420.2 | 37429.1 | 37390.4 | 37404.7 | 1305.0 |
| 2023-04-23 23:00:00 | YM | Futures | 37404.7 | 37412.5 | 37399.2 | 37403.6 | 588.0 |
| 2023-04-23 18:00:00 | CL | Futures | 63.37 | 63.38 | 63.08 | 63.24 | 2210.0 |
| 2023-04-23 19:00:00 | CL | Futures | 63.24 | 63.24 | 63.14 | 63.16 | 578.0 |
| 2023-04-23 20:00:00 | CL | Futures | 63.17 | 63.17 | 62.86 | 62.93 | 2298.0 |
| 2023-04-23 21:00:00 | CL | Futures | 62.93 | 63.07 | 62.75 | 62.76 | 3741.0 |
| 2023-04-23 22:00:00 | CL | Futures | 62.76 | 62.84 | 62.61 | 62.64 | 2556.0 |
| 2023-04-23 23:00:00 | CL | Futures | 62.64 | 62.77 | 62.64 | 62.71 | 1591.0 |
| 2023-04-23 18:00:00 | GC | Futures | 2290.8 | 2293.7 | 2289.9 | 2293.6 | 1570.0 |
| 2023-04-23 19:00:00 | GC | Futures | 2293.7 | 2295.2 | 2293.2 | 2294.1 | 1156.0 |
| 2023-04-23 20:00:00 | GC | Futures | 2294.0 | 2294.1 | 2290.3 | 2293.2 | 2441.0 |
| 2023-04-23 21:00:00 | GC | Futures | 2293.3 | 2294.3 | 2287.8 | 2288.3 | 5240.0 |
| 2023-04-23 22:00:00 | GC | Futures | 2288.2 | 2292.4 | 2286.4 | 2288.8 | 4220.0 |
| 2023-04-23 23:00:00 | GC | Futures | 2288.8 | 2290.3 | 2288.6 | 2289.7 | 1210.0 |
| 2023-04-23 18:00:00 | ZN | Futures | 117.418902 | 117.450958 | 117.402874 | 117.450958 | 7178.0 |
| 2023-04-23 19:00:00 | ZN | Futures | 117.43493 | 117.450958 | 117.418902 | 117.418902 | 3168.0 |
| 2023-04-23 20:00:00 | ZN | Futures | 117.43493 | 117.483013 | 117.418902 | 117.466985 | 6225.0 |
| 2023-04-23 21:00:00 | ZN | Futures | 117.466985 | 117.515068 | 117.466985 | 117.515068 | 8979.0 |
| 2023-04-23 22:00:00 | ZN | Futures | 117.515068 | 117.515068 | 117.466985 | 117.483013 | 5504.0 |
| 2023-04-23 23:00:00 | ZN | Futures | 117.483013 | 117.515068 | 117.483013 | 117.499041 | 4310.0 |
> showing 36 of 400 rows — these rows as CSV