PREVIEW / futures_1hour / 2024-11-18
file: by_date/futures_1hour/2024/2024-11-18.parquet size: 69 KB rows: 2,126
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-11-18 00:00:00 | ES | Futures | 6139.29 | 6139.8 | 6135.65 | 6137.99 | 5470.0 |
| 2024-11-18 01:00:00 | ES | Futures | 6137.73 | 6141.1 | 6135.39 | 6140.58 | 5320.0 |
| 2024-11-18 02:00:00 | ES | Futures | 6140.58 | 6140.84 | 6124.23 | 6128.39 | 13840.0 |
| 2024-11-18 03:00:00 | ES | Futures | 6128.39 | 6133.84 | 6123.45 | 6130.72 | 21238.0 |
| 2024-11-18 04:00:00 | ES | Futures | 6130.98 | 6130.98 | 6119.04 | 6121.64 | 26485.0 |
| 2024-11-18 05:00:00 | ES | Futures | 6121.64 | 6129.42 | 6120.08 | 6128.65 | 14072.0 |
| 2024-11-18 06:00:00 | ES | Futures | 6128.65 | 6128.9 | 6119.82 | 6123.45 | 9793.0 |
| 2024-11-18 07:00:00 | ES | Futures | 6123.71 | 6128.9 | 6121.64 | 6125.27 | 14385.0 |
| 2024-11-18 08:00:00 | ES | Futures | 6125.27 | 6127.09 | 6110.74 | 6124.75 | 38931.0 |
| 2024-11-18 09:00:00 | ES | Futures | 6124.75 | 6130.72 | 6115.67 | 6120.08 | 158612.0 |
| 2024-11-18 10:00:00 | ES | Futures | 6120.08 | 6146.81 | 6118.0 | 6145.77 | 199308.0 |
| 2024-11-18 11:00:00 | ES | Futures | 6145.77 | 6159.01 | 6142.4 | 6146.29 | 152329.0 |
| 2024-11-18 12:00:00 | ES | Futures | 6146.29 | 6150.19 | 6140.06 | 6149.93 | 111314.0 |
| 2024-11-18 13:00:00 | ES | Futures | 6149.93 | 6150.19 | 6132.54 | 6146.55 | 103493.0 |
| 2024-11-18 14:00:00 | ES | Futures | 6146.55 | 6147.33 | 6133.32 | 6144.22 | 113759.0 |
| 2024-11-18 15:00:00 | ES | Futures | 6143.96 | 6147.33 | 6138.25 | 6145.77 | 169967.0 |
| 2024-11-18 16:00:00 | ES | Futures | 6145.77 | 6147.33 | 6141.36 | 6144.22 | 40275.0 |
| 2024-11-18 18:00:00 | ES | Futures | 6144.48 | 6145.0 | 6136.95 | 6142.14 | 6225.0 |
| 2024-11-18 19:00:00 | ES | Futures | 6142.14 | 6149.15 | 6140.32 | 6143.44 | 7997.0 |
| 2024-11-18 20:00:00 | ES | Futures | 6143.18 | 6146.81 | 6139.29 | 6146.03 | 5209.0 |
| 2024-11-18 21:00:00 | ES | Futures | 6146.29 | 6150.45 | 6143.96 | 6149.93 | 5550.0 |
| 2024-11-18 22:00:00 | ES | Futures | 6150.19 | 6157.45 | 6149.93 | 6155.38 | 7528.0 |
| 2024-11-18 23:00:00 | ES | Futures | 6155.64 | 6159.79 | 6155.12 | 6156.67 | 5401.0 |
| 2024-11-18 00:00:00 | NQ | Futures | 21550.05 | 21558.4 | 21531.79 | 21540.14 | 3545.0 |
| 2024-11-18 01:00:00 | NQ | Futures | 21540.14 | 21553.97 | 21526.31 | 21550.05 | 3085.0 |
| 2024-11-18 02:00:00 | NQ | Futures | 21550.57 | 21550.84 | 21476.48 | 21495.26 | 8114.0 |
| 2024-11-18 03:00:00 | NQ | Futures | 21495.78 | 21549.53 | 21479.35 | 21535.18 | 11534.0 |
| 2024-11-18 04:00:00 | NQ | Futures | 21536.49 | 21537.27 | 21441.77 | 21455.34 | 17369.0 |
| 2024-11-18 05:00:00 | NQ | Futures | 21455.34 | 21489.26 | 21450.12 | 21487.17 | 7246.0 |
| 2024-11-18 06:00:00 | NQ | Futures | 21486.39 | 21488.74 | 21449.86 | 21469.69 | 5895.0 |
| 2024-11-18 07:00:00 | NQ | Futures | 21470.21 | 21481.95 | 21447.25 | 21455.08 | 8728.0 |
| 2024-11-18 08:00:00 | NQ | Futures | 21455.08 | 21461.86 | 21375.5 | 21452.73 | 23624.0 |
| 2024-11-18 09:00:00 | NQ | Futures | 21451.95 | 21486.13 | 21395.85 | 21426.38 | 71478.0 |
| 2024-11-18 10:00:00 | NQ | Futures | 21427.16 | 21599.1 | 21417.51 | 21583.45 | 78488.0 |
| 2024-11-18 11:00:00 | NQ | Futures | 21583.71 | 21628.85 | 21540.14 | 21564.14 | 58738.0 |
| 2024-11-18 12:00:00 | NQ | Futures | 21564.4 | 21573.54 | 21516.66 | 21563.1 | 42428.0 |
| 2024-11-18 13:00:00 | NQ | Futures | 21563.1 | 21570.93 | 21494.74 | 21561.79 | 40799.0 |
| 2024-11-18 14:00:00 | NQ | Futures | 21561.79 | 21562.32 | 21488.22 | 21539.62 | 41237.0 |
| 2024-11-18 15:00:00 | NQ | Futures | 21539.36 | 21555.01 | 21510.66 | 21532.05 | 48852.0 |
| 2024-11-18 16:00:00 | NQ | Futures | 21531.79 | 21551.1 | 21522.66 | 21531.01 | 10932.0 |
| 2024-11-18 18:00:00 | NQ | Futures | 21533.88 | 21541.18 | 21502.83 | 21522.92 | 3622.0 |
| 2024-11-18 19:00:00 | NQ | Futures | 21523.44 | 21553.71 | 21514.83 | 21526.83 | 5017.0 |
| 2024-11-18 20:00:00 | NQ | Futures | 21526.83 | 21543.79 | 21505.96 | 21538.83 | 3865.0 |
| 2024-11-18 21:00:00 | NQ | Futures | 21538.83 | 21561.01 | 21532.31 | 21557.88 | 4246.0 |
| 2024-11-18 22:00:00 | NQ | Futures | 21558.14 | 21592.06 | 21555.27 | 21580.84 | 4606.0 |
| 2024-11-18 23:00:00 | NQ | Futures | 21581.36 | 21600.41 | 21579.28 | 21584.75 | 3267.0 |
| 2024-11-18 00:00:00 | YM | Futures | 45345.6 | 45372.6 | 45323.7 | 45352.9 | 1431.0 |
| 2024-11-18 01:00:00 | YM | Futures | 45350.8 | 45385.1 | 45338.3 | 45376.8 | 679.0 |
| 2024-11-18 02:00:00 | YM | Futures | 45377.8 | 45379.9 | 45265.4 | 45277.9 | 1927.0 |
| 2024-11-18 03:00:00 | YM | Futures | 45281.1 | 45312.3 | 45224.9 | 45248.8 | 3344.0 |
> showing 50 of 2,126 rows — these rows as CSV