PREVIEW / futures_1hour / 2024-09-01
file: by_date/futures_1hour/2024/2024-09-01.parquet size: 18 KB rows: 378
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-09-01 18:00:00 | ES | Futures | 5931.46 | 5935.92 | 5927.0 | 5928.31 | 4477.0 |
| 2024-09-01 19:00:00 | ES | Futures | 5928.31 | 5930.67 | 5927.0 | 5928.05 | 2360.0 |
| 2024-09-01 20:00:00 | ES | Futures | 5928.05 | 5933.82 | 5926.74 | 5931.46 | 3403.0 |
| 2024-09-01 21:00:00 | ES | Futures | 5931.46 | 5935.65 | 5931.2 | 5934.87 | 2947.0 |
| 2024-09-01 22:00:00 | ES | Futures | 5934.61 | 5934.61 | 5928.05 | 5929.62 | 3486.0 |
| 2024-09-01 23:00:00 | ES | Futures | 5929.62 | 5929.89 | 5924.91 | 5928.31 | 2601.0 |
| 2024-09-01 18:00:00 | NQ | Futures | 20695.17 | 20725.79 | 20663.49 | 20683.56 | 3166.0 |
| 2024-09-01 19:00:00 | NQ | Futures | 20684.35 | 20700.45 | 20678.28 | 20681.71 | 1469.0 |
| 2024-09-01 20:00:00 | NQ | Futures | 20681.71 | 20717.87 | 20678.28 | 20705.47 | 2011.0 |
| 2024-09-01 21:00:00 | NQ | Futures | 20706.26 | 20725.53 | 20705.73 | 20713.39 | 1561.0 |
| 2024-09-01 22:00:00 | NQ | Futures | 20713.65 | 20713.65 | 20685.14 | 20693.32 | 1875.0 |
| 2024-09-01 23:00:00 | NQ | Futures | 20693.06 | 20693.59 | 20669.83 | 20686.2 | 1506.0 |
| 2024-09-01 18:00:00 | YM | Futures | 43723.9 | 43756.5 | 43722.9 | 43730.2 | 490.0 |
| 2024-09-01 19:00:00 | YM | Futures | 43730.2 | 43749.2 | 43728.1 | 43736.5 | 439.0 |
| 2024-09-01 20:00:00 | YM | Futures | 43734.4 | 43747.1 | 43725.0 | 43734.4 | 426.0 |
| 2024-09-01 21:00:00 | YM | Futures | 43736.5 | 43764.9 | 43733.4 | 43757.6 | 605.0 |
| 2024-09-01 22:00:00 | YM | Futures | 43757.6 | 43757.6 | 43721.8 | 43737.6 | 435.0 |
| 2024-09-01 23:00:00 | YM | Futures | 43735.5 | 43743.9 | 43717.6 | 43731.3 | 278.0 |
| 2024-09-01 18:00:00 | CL | Futures | 65.12 | 65.23 | 64.78 | 64.83 | 2204.0 |
| 2024-09-01 19:00:00 | CL | Futures | 64.82 | 64.85 | 64.61 | 64.63 | 1176.0 |
| 2024-09-01 20:00:00 | CL | Futures | 64.63 | 64.93 | 64.63 | 64.89 | 1773.0 |
| 2024-09-01 21:00:00 | CL | Futures | 64.9 | 64.99 | 64.65 | 64.71 | 2717.0 |
| 2024-09-01 22:00:00 | CL | Futures | 64.71 | 64.71 | 64.55 | 64.65 | 1862.0 |
| 2024-09-01 23:00:00 | CL | Futures | 64.67 | 64.69 | 64.57 | 64.67 | 1161.0 |
| 2024-09-01 18:00:00 | GC | Futures | 2670.3 | 2671.2 | 2665.7 | 2669.7 | 1563.0 |
| 2024-09-01 19:00:00 | GC | Futures | 2669.7 | 2670.0 | 2668.1 | 2669.4 | 2035.0 |
| 2024-09-01 20:00:00 | GC | Futures | 2669.4 | 2671.6 | 2667.5 | 2667.8 | 1352.0 |
| 2024-09-01 21:00:00 | GC | Futures | 2667.7 | 2671.5 | 2663.1 | 2664.4 | 3860.0 |
| 2024-09-01 22:00:00 | GC | Futures | 2664.3 | 2664.7 | 2655.7 | 2657.7 | 6288.0 |
| 2024-09-01 23:00:00 | GC | Futures | 2657.5 | 2662.4 | 2657.2 | 2662.2 | 2305.0 |
| 2024-09-01 18:00:00 | ZN | Futures | 113.622818 | 113.669952 | 113.622818 | 113.654241 | 19.0 |
| 2024-09-01 20:00:00 | ZN | Futures | 113.685663 | 113.717085 | 113.685663 | 113.717085 | 12.0 |
| 2024-09-01 21:00:00 | ZN | Futures | 113.654241 | 113.685663 | 113.654241 | 113.685663 | 17.0 |
> showing 33 of 378 rows — these rows as CSV