PREVIEW / futures_1hour / 2024-08-04
file: by_date/futures_1hour/2024/2024-08-04.parquet size: 21 KB rows: 447
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 |
|---|---|---|---|---|---|---|---|
| 2024-08-04 18:00:00 | ES | Futures | 5589.34 | 5605.59 | 5580.16 | 5596.94 | 30070.0 |
| 2024-08-04 19:00:00 | ES | Futures | 5596.68 | 5597.99 | 5571.51 | 5583.04 | 26340.0 |
| 2024-08-04 20:00:00 | ES | Futures | 5583.04 | 5583.57 | 5556.04 | 5562.07 | 48275.0 |
| 2024-08-04 21:00:00 | ES | Futures | 5562.07 | 5564.69 | 5544.51 | 5562.07 | 41248.0 |
| 2024-08-04 22:00:00 | ES | Futures | 5562.07 | 5573.08 | 5553.16 | 5560.76 | 25171.0 |
| 2024-08-04 23:00:00 | ES | Futures | 5561.02 | 5565.74 | 5548.96 | 5549.22 | 19749.0 |
| 2024-08-04 18:00:00 | NQ | Futures | 19418.55 | 19418.55 | 19291.05 | 19373.15 | 14881.0 |
| 2024-08-04 19:00:00 | NQ | Futures | 19373.15 | 19384.5 | 19232.18 | 19284.19 | 9790.0 |
| 2024-08-04 20:00:00 | NQ | Futures | 19284.45 | 19296.06 | 19177.54 | 19192.06 | 15560.0 |
| 2024-08-04 21:00:00 | NQ | Futures | 19191.26 | 19199.45 | 19078.54 | 19143.48 | 16235.0 |
| 2024-08-04 22:00:00 | NQ | Futures | 19145.33 | 19193.38 | 19097.02 | 19126.32 | 9691.0 |
| 2024-08-04 23:00:00 | NQ | Futures | 19126.06 | 19153.51 | 19030.5 | 19035.51 | 8521.0 |
| 2024-08-04 18:00:00 | YM | Futures | 41633.0 | 41766.4 | 41561.5 | 41718.1 | 2469.0 |
| 2024-08-04 19:00:00 | YM | Futures | 41719.1 | 41734.9 | 41595.2 | 41657.2 | 3314.0 |
| 2024-08-04 20:00:00 | YM | Futures | 41654.0 | 41663.5 | 41464.9 | 41543.7 | 5189.0 |
| 2024-08-04 21:00:00 | YM | Futures | 41541.6 | 41618.3 | 41481.7 | 41606.7 | 3746.0 |
| 2024-08-04 22:00:00 | YM | Futures | 41607.8 | 41693.9 | 41554.2 | 41630.9 | 2466.0 |
| 2024-08-04 23:00:00 | YM | Futures | 41629.8 | 41658.2 | 41597.3 | 41600.4 | 2227.0 |
| 2024-08-04 18:00:00 | CL | Futures | 64.42 | 64.64 | 63.96 | 64.14 | 6825.0 |
| 2024-08-04 19:00:00 | CL | Futures | 64.15 | 64.33 | 64.05 | 64.22 | 2376.0 |
| 2024-08-04 20:00:00 | CL | Futures | 64.22 | 64.24 | 63.3 | 63.56 | 10835.0 |
| 2024-08-04 21:00:00 | CL | Futures | 63.55 | 64.08 | 63.33 | 63.92 | 8575.0 |
| 2024-08-04 22:00:00 | CL | Futures | 63.93 | 64.25 | 63.81 | 64.16 | 3630.0 |
| 2024-08-04 23:00:00 | CL | Futures | 64.16 | 64.23 | 63.9 | 63.94 | 3012.0 |
| 2024-08-04 18:00:00 | GC | Futures | 2622.2 | 2622.3 | 2611.5 | 2615.0 | 4778.0 |
| 2024-08-04 19:00:00 | GC | Futures | 2615.1 | 2619.6 | 2612.7 | 2614.6 | 3491.0 |
| 2024-08-04 20:00:00 | GC | Futures | 2614.7 | 2614.7 | 2585.8 | 2594.8 | 14992.0 |
| 2024-08-04 21:00:00 | GC | Futures | 2594.2 | 2615.8 | 2592.5 | 2612.9 | 13310.0 |
| 2024-08-04 22:00:00 | GC | Futures | 2613.0 | 2620.3 | 2606.2 | 2616.3 | 6635.0 |
| 2024-08-04 23:00:00 | GC | Futures | 2616.3 | 2626.6 | 2616.2 | 2624.8 | 6797.0 |
| 2024-08-04 18:00:00 | ZN | Futures | 114.801152 | 114.832575 | 114.518352 | 114.596908 | 36113.0 |
| 2024-08-04 19:00:00 | ZN | Futures | 114.596908 | 114.832575 | 114.565486 | 114.801152 | 31888.0 |
| 2024-08-04 20:00:00 | ZN | Futures | 114.785441 | 115.319619 | 114.722597 | 115.099664 | 185149.0 |
| 2024-08-04 21:00:00 | ZN | Futures | 115.083953 | 115.241064 | 114.91113 | 115.005397 | 59976.0 |
| 2024-08-04 22:00:00 | ZN | Futures | 115.021108 | 115.021108 | 114.785441 | 114.863997 | 40969.0 |
| 2024-08-04 23:00:00 | ZN | Futures | 114.863997 | 114.958264 | 114.816864 | 114.879708 | 29678.0 |
> showing 36 of 447 rows — these rows as CSV