PREVIEW / futures_1hour / 2023-05-07
file: by_date/futures_1hour/2023/2023-05-07.parquet size: 19 KB rows: 418
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-05-07 18:00:00 | ES | Futures | 4605.18 | 4609.06 | 4603.51 | 4605.45 | 6673.0 |
| 2023-05-07 19:00:00 | ES | Futures | 4605.45 | 4608.78 | 4599.63 | 4599.91 | 5978.0 |
| 2023-05-07 20:00:00 | ES | Futures | 4599.91 | 4602.12 | 4595.75 | 4599.35 | 9907.0 |
| 2023-05-07 21:00:00 | ES | Futures | 4599.07 | 4603.23 | 4596.58 | 4601.29 | 7823.0 |
| 2023-05-07 22:00:00 | ES | Futures | 4601.29 | 4605.18 | 4599.91 | 4604.07 | 6526.0 |
| 2023-05-07 23:00:00 | ES | Futures | 4604.34 | 4606.84 | 4599.91 | 4600.18 | 5782.0 |
| 2023-05-07 18:00:00 | NQ | Futures | 14996.64 | 15012.13 | 14990.73 | 14999.46 | 3797.0 |
| 2023-05-07 19:00:00 | NQ | Futures | 14999.46 | 15015.5 | 14980.03 | 14982.56 | 3747.0 |
| 2023-05-07 20:00:00 | NQ | Futures | 14983.41 | 14993.26 | 14972.14 | 14985.38 | 3842.0 |
| 2023-05-07 21:00:00 | NQ | Futures | 14985.38 | 14997.77 | 14975.24 | 14988.19 | 3337.0 |
| 2023-05-07 22:00:00 | NQ | Futures | 14988.47 | 15007.9 | 14984.53 | 15004.52 | 3529.0 |
| 2023-05-07 23:00:00 | NQ | Futures | 15003.96 | 15012.41 | 14992.14 | 14993.26 | 2456.0 |
| 2023-05-07 18:00:00 | YM | Futures | 37307.5 | 37332.9 | 37294.2 | 37304.2 | 746.0 |
| 2023-05-07 19:00:00 | YM | Futures | 37304.2 | 37325.2 | 37271.0 | 37275.4 | 888.0 |
| 2023-05-07 20:00:00 | YM | Futures | 37276.5 | 37285.4 | 37245.6 | 37263.3 | 1326.0 |
| 2023-05-07 21:00:00 | YM | Futures | 37262.2 | 37285.4 | 37246.7 | 37269.9 | 776.0 |
| 2023-05-07 22:00:00 | YM | Futures | 37271.0 | 37292.0 | 37256.6 | 37285.4 | 808.0 |
| 2023-05-07 23:00:00 | YM | Futures | 37285.4 | 37297.5 | 37262.2 | 37264.4 | 665.0 |
| 2023-05-07 18:00:00 | CL | Futures | 57.99 | 58.43 | 57.97 | 58.15 | 4151.0 |
| 2023-05-07 19:00:00 | CL | Futures | 58.15 | 58.23 | 58.01 | 58.04 | 1384.0 |
| 2023-05-07 20:00:00 | CL | Futures | 58.04 | 58.09 | 57.97 | 58.02 | 1823.0 |
| 2023-05-07 21:00:00 | CL | Futures | 58.03 | 58.13 | 57.73 | 57.8 | 3816.0 |
| 2023-05-07 22:00:00 | CL | Futures | 57.8 | 58.2 | 57.79 | 58.11 | 2015.0 |
| 2023-05-07 23:00:00 | CL | Futures | 58.11 | 58.15 | 58.01 | 58.06 | 997.0 |
| 2023-05-07 18:00:00 | GC | Futures | 2328.3 | 2330.4 | 2325.3 | 2325.8 | 1648.0 |
| 2023-05-07 19:00:00 | GC | Futures | 2325.9 | 2328.8 | 2325.8 | 2327.3 | 1631.0 |
| 2023-05-07 20:00:00 | GC | Futures | 2327.3 | 2330.0 | 2326.8 | 2329.3 | 1975.0 |
| 2023-05-07 21:00:00 | GC | Futures | 2329.3 | 2330.0 | 2326.0 | 2328.5 | 2763.0 |
| 2023-05-07 22:00:00 | GC | Futures | 2328.6 | 2333.2 | 2327.7 | 2331.9 | 3744.0 |
| 2023-05-07 23:00:00 | GC | Futures | 2331.9 | 2336.3 | 2331.1 | 2335.4 | 2472.0 |
| 2023-05-07 18:00:00 | ZN | Futures | 118.781256 | 118.797284 | 118.669062 | 118.68509 | 9307.0 |
| 2023-05-07 19:00:00 | ZN | Futures | 118.701118 | 118.701118 | 118.620979 | 118.68509 | 5978.0 |
| 2023-05-07 20:00:00 | ZN | Futures | 118.68509 | 118.765229 | 118.669062 | 118.749201 | 7646.0 |
| 2023-05-07 21:00:00 | ZN | Futures | 118.749201 | 118.781256 | 118.733173 | 118.765229 | 5794.0 |
| 2023-05-07 22:00:00 | ZN | Futures | 118.765229 | 118.797284 | 118.749201 | 118.781256 | 7224.0 |
| 2023-05-07 23:00:00 | ZN | Futures | 118.781256 | 118.845367 | 118.749201 | 118.813312 | 8586.0 |
> showing 36 of 418 rows — these rows as CSV