PREVIEW / futures_1hour / 2024-04-22
file: by_date/futures_1hour/2024/2024-04-22.parquet size: 67 KB rows: 2,093
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-04-22 00:00:00 | ES | Futures | 5322.36 | 5328.2 | 5322.1 | 5327.14 | 4253.0 |
| 2024-04-22 01:00:00 | ES | Futures | 5327.4 | 5330.85 | 5325.28 | 5330.59 | 5319.0 |
| 2024-04-22 02:00:00 | ES | Futures | 5330.59 | 5338.01 | 5330.32 | 5337.22 | 13675.0 |
| 2024-04-22 03:00:00 | ES | Futures | 5336.95 | 5338.81 | 5324.22 | 5326.08 | 18607.0 |
| 2024-04-22 04:00:00 | ES | Futures | 5325.81 | 5331.65 | 5322.89 | 5328.99 | 15666.0 |
| 2024-04-22 05:00:00 | ES | Futures | 5328.99 | 5341.2 | 5328.46 | 5338.01 | 17506.0 |
| 2024-04-22 06:00:00 | ES | Futures | 5338.01 | 5342.79 | 5335.63 | 5337.75 | 14503.0 |
| 2024-04-22 07:00:00 | ES | Futures | 5337.75 | 5344.65 | 5334.3 | 5340.4 | 20942.0 |
| 2024-04-22 08:00:00 | ES | Futures | 5340.4 | 5342.52 | 5327.67 | 5339.87 | 38386.0 |
| 2024-04-22 09:00:00 | ES | Futures | 5340.14 | 5343.06 | 5326.34 | 5335.36 | 175058.0 |
| 2024-04-22 10:00:00 | ES | Futures | 5335.36 | 5342.26 | 5317.85 | 5320.51 | 200384.0 |
| 2024-04-22 11:00:00 | ES | Futures | 5320.51 | 5333.24 | 5312.28 | 5333.24 | 154878.0 |
| 2024-04-22 12:00:00 | ES | Futures | 5333.24 | 5345.44 | 5331.91 | 5344.12 | 126459.0 |
| 2024-04-22 13:00:00 | ES | Futures | 5344.38 | 5382.32 | 5342.52 | 5377.28 | 179990.0 |
| 2024-04-22 14:00:00 | ES | Futures | 5377.28 | 5387.36 | 5368.26 | 5375.69 | 149407.0 |
| 2024-04-22 15:00:00 | ES | Futures | 5375.69 | 5376.22 | 5349.16 | 5357.38 | 270271.0 |
| 2024-04-22 16:00:00 | ES | Futures | 5357.65 | 5358.44 | 5349.95 | 5357.91 | 51904.0 |
| 2024-04-22 18:00:00 | ES | Futures | 5360.03 | 5363.22 | 5354.46 | 5357.12 | 5494.0 |
| 2024-04-22 19:00:00 | ES | Futures | 5357.12 | 5357.91 | 5345.97 | 5354.73 | 7241.0 |
| 2024-04-22 20:00:00 | ES | Futures | 5354.73 | 5357.91 | 5352.87 | 5356.85 | 4889.0 |
| 2024-04-22 21:00:00 | ES | Futures | 5356.85 | 5357.38 | 5347.3 | 5350.48 | 9876.0 |
| 2024-04-22 22:00:00 | ES | Futures | 5350.48 | 5355.26 | 5349.42 | 5353.67 | 9425.0 |
| 2024-04-22 23:00:00 | ES | Futures | 5353.93 | 5357.12 | 5351.01 | 5356.06 | 4080.0 |
| 2024-04-22 00:00:00 | NQ | Futures | 18446.81 | 18477.57 | 18443.33 | 18473.83 | 3113.0 |
| 2024-04-22 01:00:00 | NQ | Futures | 18474.1 | 18492.82 | 18462.06 | 18492.29 | 4261.0 |
| 2024-04-22 02:00:00 | NQ | Futures | 18491.48 | 18517.16 | 18485.33 | 18511.81 | 8084.0 |
| 2024-04-22 03:00:00 | NQ | Futures | 18511.28 | 18513.15 | 18455.1 | 18467.41 | 9578.0 |
| 2024-04-22 04:00:00 | NQ | Futures | 18466.34 | 18483.99 | 18440.12 | 18471.15 | 9904.0 |
| 2024-04-22 05:00:00 | NQ | Futures | 18470.35 | 18510.48 | 18466.61 | 18503.79 | 7502.0 |
| 2024-04-22 06:00:00 | NQ | Futures | 18503.79 | 18526.53 | 18481.59 | 18489.34 | 8670.0 |
| 2024-04-22 07:00:00 | NQ | Futures | 18489.88 | 18510.74 | 18465.27 | 18488.54 | 11434.0 |
| 2024-04-22 08:00:00 | NQ | Futures | 18488.81 | 18515.29 | 18453.77 | 18506.73 | 16438.0 |
| 2024-04-22 09:00:00 | NQ | Futures | 18507.27 | 18544.98 | 18472.76 | 18493.09 | 86114.0 |
| 2024-04-22 10:00:00 | NQ | Futures | 18493.36 | 18526.26 | 18367.09 | 18388.76 | 104624.0 |
| 2024-04-22 11:00:00 | NQ | Futures | 18389.03 | 18462.33 | 18349.17 | 18459.12 | 67868.0 |
| 2024-04-22 12:00:00 | NQ | Futures | 18459.38 | 18507.0 | 18440.93 | 18483.19 | 48792.0 |
| 2024-04-22 13:00:00 | NQ | Futures | 18483.73 | 18634.06 | 18476.24 | 18615.34 | 60627.0 |
| 2024-04-22 14:00:00 | NQ | Futures | 18615.34 | 18669.64 | 18597.95 | 18630.05 | 59548.0 |
| 2024-04-22 15:00:00 | NQ | Futures | 18629.78 | 18638.61 | 18538.03 | 18565.31 | 77257.0 |
| 2024-04-22 16:00:00 | NQ | Futures | 18565.31 | 18570.66 | 18536.69 | 18559.43 | 12452.0 |
| 2024-04-22 18:00:00 | NQ | Futures | 18567.19 | 18589.66 | 18543.11 | 18552.21 | 3760.0 |
| 2024-04-22 19:00:00 | NQ | Futures | 18551.94 | 18556.49 | 18496.57 | 18535.35 | 6426.0 |
| 2024-04-22 20:00:00 | NQ | Futures | 18535.09 | 18552.47 | 18528.4 | 18545.52 | 3695.0 |
| 2024-04-22 21:00:00 | NQ | Futures | 18544.45 | 18547.12 | 18502.18 | 18517.7 | 5350.0 |
| 2024-04-22 22:00:00 | NQ | Futures | 18516.9 | 18543.11 | 18512.88 | 18536.96 | 4014.0 |
| 2024-04-22 23:00:00 | NQ | Futures | 18538.03 | 18549.8 | 18526.79 | 18544.72 | 2624.0 |
| 2024-04-22 00:00:00 | YM | Futures | 40638.8 | 40667.4 | 40636.7 | 40661.1 | 493.0 |
| 2024-04-22 01:00:00 | YM | Futures | 40662.1 | 40677.0 | 40645.2 | 40677.0 | 737.0 |
| 2024-04-22 02:00:00 | YM | Futures | 40677.0 | 40760.9 | 40675.9 | 40754.5 | 2183.0 |
| 2024-04-22 03:00:00 | YM | Futures | 40748.1 | 40766.2 | 40643.0 | 40660.0 | 2541.0 |
> showing 50 of 2,093 rows — these rows as CSV