PREVIEW / futures_1hour / 2023-04-30
file: by_date/futures_1hour/2023/2023-04-30.parquet size: 17 KB rows: 373
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-30 18:00:00 | ES | Futures | 4648.44 | 4649.83 | 4640.95 | 4642.34 | 9874.0 |
| 2023-04-30 19:00:00 | ES | Futures | 4642.34 | 4644.84 | 4638.74 | 4640.12 | 6310.0 |
| 2023-04-30 20:00:00 | ES | Futures | 4639.84 | 4645.95 | 4638.46 | 4645.11 | 8419.0 |
| 2023-04-30 21:00:00 | ES | Futures | 4645.11 | 4646.5 | 4642.9 | 4644.01 | 4311.0 |
| 2023-04-30 22:00:00 | ES | Futures | 4644.01 | 4650.38 | 4643.73 | 4650.11 | 5116.0 |
| 2023-04-30 23:00:00 | ES | Futures | 4650.11 | 4651.77 | 4647.33 | 4649.83 | 3818.0 |
| 2023-04-30 18:00:00 | NQ | Futures | 14997.77 | 15009.03 | 14984.81 | 14990.16 | 3535.0 |
| 2023-04-30 19:00:00 | NQ | Futures | 14990.73 | 15001.43 | 14982.84 | 14987.07 | 2809.0 |
| 2023-04-30 20:00:00 | NQ | Futures | 14986.5 | 14998.89 | 14974.4 | 14994.67 | 3779.0 |
| 2023-04-30 21:00:00 | NQ | Futures | 14994.39 | 15001.43 | 14985.1 | 14991.01 | 3045.0 |
| 2023-04-30 22:00:00 | NQ | Futures | 14990.73 | 15028.17 | 14987.91 | 15020.57 | 4152.0 |
| 2023-04-30 23:00:00 | NQ | Futures | 15020.57 | 15022.82 | 15008.18 | 15016.91 | 2736.0 |
| 2023-04-30 18:00:00 | YM | Futures | 37819.2 | 37827.0 | 37761.8 | 37770.6 | 1676.0 |
| 2023-04-30 19:00:00 | YM | Futures | 37772.8 | 37790.5 | 37744.1 | 37754.0 | 1321.0 |
| 2023-04-30 20:00:00 | YM | Futures | 37752.9 | 37800.4 | 37748.5 | 37791.6 | 1237.0 |
| 2023-04-30 21:00:00 | YM | Futures | 37792.7 | 37799.3 | 37776.1 | 37785.0 | 824.0 |
| 2023-04-30 22:00:00 | YM | Futures | 37785.0 | 37820.3 | 37783.9 | 37820.3 | 1192.0 |
| 2023-04-30 23:00:00 | YM | Futures | 37818.1 | 37824.8 | 37798.2 | 37810.4 | 785.0 |
| 2023-04-30 18:00:00 | CL | Futures | 62.3 | 62.33 | 62.01 | 62.05 | 2287.0 |
| 2023-04-30 19:00:00 | CL | Futures | 62.05 | 62.1 | 61.81 | 61.85 | 2022.0 |
| 2023-04-30 20:00:00 | CL | Futures | 61.84 | 62.0 | 61.84 | 61.97 | 1365.0 |
| 2023-04-30 21:00:00 | CL | Futures | 61.97 | 61.97 | 61.84 | 61.87 | 1148.0 |
| 2023-04-30 22:00:00 | CL | Futures | 61.88 | 61.94 | 61.83 | 61.93 | 830.0 |
| 2023-04-30 23:00:00 | CL | Futures | 61.92 | 61.94 | 61.86 | 61.89 | 631.0 |
| 2023-04-30 18:00:00 | GC | Futures | 2300.2 | 2300.8 | 2296.8 | 2297.6 | 1751.0 |
| 2023-04-30 19:00:00 | GC | Futures | 2297.7 | 2297.8 | 2294.6 | 2294.9 | 1085.0 |
| 2023-04-30 20:00:00 | GC | Futures | 2294.9 | 2295.4 | 2291.1 | 2291.6 | 3382.0 |
| 2023-04-30 21:00:00 | GC | Futures | 2291.5 | 2292.9 | 2288.2 | 2289.2 | 2417.0 |
| 2023-04-30 22:00:00 | GC | Futures | 2289.2 | 2291.5 | 2289.0 | 2290.2 | 2420.0 |
| 2023-04-30 23:00:00 | GC | Futures | 2290.1 | 2290.9 | 2287.9 | 2290.9 | 2001.0 |
| 2023-04-30 18:00:00 | ZN | Futures | 118.396592 | 118.396592 | 118.220287 | 118.252342 | 13191.0 |
| 2023-04-30 19:00:00 | ZN | Futures | 118.26837 | 118.284398 | 118.236315 | 118.252342 | 2845.0 |
| 2023-04-30 20:00:00 | ZN | Futures | 118.252342 | 118.26837 | 118.188232 | 118.204259 | 8439.0 |
| 2023-04-30 21:00:00 | ZN | Futures | 118.204259 | 118.26837 | 118.172204 | 118.204259 | 10798.0 |
| 2023-04-30 22:00:00 | ZN | Futures | 118.220287 | 118.26837 | 118.204259 | 118.236315 | 6489.0 |
| 2023-04-30 23:00:00 | ZN | Futures | 118.236315 | 118.236315 | 118.188232 | 118.236315 | 4150.0 |
> showing 36 of 373 rows — these rows as CSV