PREVIEW / futures_1hour / 2024-03-06
file: by_date/futures_1hour/2024/2024-03-06.parquet size: 66 KB rows: 2,029
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-03-06 00:00:00 | ES | Futures | 5469.04 | 5470.38 | 5467.97 | 5469.04 | 3822.0 |
| 2024-03-06 01:00:00 | ES | Futures | 5469.04 | 5470.12 | 5466.89 | 5469.04 | 4854.0 |
| 2024-03-06 02:00:00 | ES | Futures | 5469.31 | 5471.73 | 5466.89 | 5470.92 | 10486.0 |
| 2024-03-06 03:00:00 | ES | Futures | 5470.65 | 5481.4 | 5470.65 | 5478.71 | 22094.0 |
| 2024-03-06 04:00:00 | ES | Futures | 5478.98 | 5485.43 | 5478.71 | 5483.81 | 21693.0 |
| 2024-03-06 05:00:00 | ES | Futures | 5483.81 | 5486.77 | 5480.86 | 5481.13 | 18316.0 |
| 2024-03-06 06:00:00 | ES | Futures | 5481.13 | 5484.62 | 5479.52 | 5481.67 | 12441.0 |
| 2024-03-06 07:00:00 | ES | Futures | 5481.67 | 5488.92 | 5480.86 | 5487.84 | 23825.0 |
| 2024-03-06 08:00:00 | ES | Futures | 5487.84 | 5497.51 | 5485.69 | 5497.51 | 68085.0 |
| 2024-03-06 09:00:00 | ES | Futures | 5497.51 | 5503.15 | 5489.99 | 5492.95 | 190551.0 |
| 2024-03-06 10:00:00 | ES | Futures | 5492.95 | 5500.2 | 5476.83 | 5498.86 | 278599.0 |
| 2024-03-06 11:00:00 | ES | Futures | 5498.86 | 5511.75 | 5498.86 | 5507.18 | 196446.0 |
| 2024-03-06 12:00:00 | ES | Futures | 5507.18 | 5516.31 | 5505.3 | 5508.52 | 151030.0 |
| 2024-03-06 13:00:00 | ES | Futures | 5508.52 | 5515.24 | 5484.62 | 5495.63 | 253742.0 |
| 2024-03-06 14:00:00 | ES | Futures | 5495.36 | 5498.59 | 5477.64 | 5485.43 | 256860.0 |
| 2024-03-06 15:00:00 | ES | Futures | 5485.69 | 5496.98 | 5478.44 | 5492.14 | 273199.0 |
| 2024-03-06 16:00:00 | ES | Futures | 5492.14 | 5496.17 | 5490.8 | 5493.48 | 49011.0 |
| 2024-03-06 18:00:00 | ES | Futures | 5494.56 | 5494.83 | 5488.65 | 5488.65 | 5101.0 |
| 2024-03-06 19:00:00 | ES | Futures | 5488.65 | 5491.07 | 5479.79 | 5482.74 | 10636.0 |
| 2024-03-06 20:00:00 | ES | Futures | 5482.74 | 5484.08 | 5473.88 | 5474.41 | 19862.0 |
| 2024-03-06 21:00:00 | ES | Futures | 5474.41 | 5476.83 | 5470.12 | 5474.15 | 12070.0 |
| 2024-03-06 22:00:00 | ES | Futures | 5474.15 | 5480.05 | 5472.8 | 5479.25 | 7669.0 |
| 2024-03-06 23:00:00 | ES | Futures | 5479.25 | 5481.13 | 5476.56 | 5480.32 | 5764.0 |
| 2024-03-06 00:00:00 | NQ | Futures | 19506.74 | 19512.43 | 19501.31 | 19507.01 | 2208.0 |
| 2024-03-06 01:00:00 | NQ | Futures | 19507.01 | 19510.53 | 19491.82 | 19507.28 | 3082.0 |
| 2024-03-06 02:00:00 | NQ | Futures | 19507.82 | 19534.13 | 19493.72 | 19530.06 | 7011.0 |
| 2024-03-06 03:00:00 | NQ | Futures | 19529.52 | 19568.57 | 19528.97 | 19548.5 | 10662.0 |
| 2024-03-06 04:00:00 | NQ | Futures | 19548.23 | 19596.78 | 19548.23 | 19588.64 | 11568.0 |
| 2024-03-06 05:00:00 | NQ | Futures | 19588.91 | 19609.25 | 19581.32 | 19582.67 | 8770.0 |
| 2024-03-06 06:00:00 | NQ | Futures | 19582.4 | 19597.32 | 19565.04 | 19572.64 | 7215.0 |
| 2024-03-06 07:00:00 | NQ | Futures | 19572.64 | 19608.71 | 19563.96 | 19600.84 | 13419.0 |
| 2024-03-06 08:00:00 | NQ | Futures | 19600.03 | 19633.66 | 19585.38 | 19633.12 | 26431.0 |
| 2024-03-06 09:00:00 | NQ | Futures | 19633.66 | 19664.03 | 19566.4 | 19577.25 | 105106.0 |
| 2024-03-06 10:00:00 | NQ | Futures | 19579.69 | 19620.91 | 19487.21 | 19610.34 | 130766.0 |
| 2024-03-06 11:00:00 | NQ | Futures | 19610.34 | 19668.64 | 19592.44 | 19659.42 | 79413.0 |
| 2024-03-06 12:00:00 | NQ | Futures | 19659.42 | 19715.83 | 19652.91 | 19670.27 | 60038.0 |
| 2024-03-06 13:00:00 | NQ | Futures | 19670.81 | 19701.46 | 19559.89 | 19610.88 | 98546.0 |
| 2024-03-06 14:00:00 | NQ | Futures | 19611.42 | 19627.42 | 19529.25 | 19557.18 | 97459.0 |
| 2024-03-06 15:00:00 | NQ | Futures | 19557.72 | 19594.88 | 19509.99 | 19575.08 | 100450.0 |
| 2024-03-06 16:00:00 | NQ | Futures | 19574.81 | 19582.94 | 19557.45 | 19570.47 | 11605.0 |
| 2024-03-06 18:00:00 | NQ | Futures | 19571.28 | 19577.79 | 19546.6 | 19546.6 | 3561.0 |
| 2024-03-06 19:00:00 | NQ | Futures | 19547.14 | 19557.45 | 19500.5 | 19521.92 | 6545.0 |
| 2024-03-06 20:00:00 | NQ | Futures | 19521.65 | 19521.92 | 19475.0 | 19482.87 | 10411.0 |
| 2024-03-06 21:00:00 | NQ | Futures | 19483.41 | 19494.26 | 19453.31 | 19469.85 | 8104.0 |
| 2024-03-06 22:00:00 | NQ | Futures | 19469.85 | 19501.31 | 19465.51 | 19496.43 | 5660.0 |
| 2024-03-06 23:00:00 | NQ | Futures | 19496.43 | 19505.65 | 19479.89 | 19497.79 | 4186.0 |
| 2024-03-06 00:00:00 | YM | Futures | 41462.6 | 41471.2 | 41459.4 | 41462.6 | 931.0 |
| 2024-03-06 01:00:00 | YM | Futures | 41462.6 | 41473.4 | 41458.3 | 41473.4 | 616.0 |
| 2024-03-06 02:00:00 | YM | Futures | 41474.4 | 41489.5 | 41463.7 | 41475.5 | 1530.0 |
| 2024-03-06 03:00:00 | YM | Futures | 41475.5 | 41550.7 | 41471.2 | 41541.0 | 2520.0 |
> showing 50 of 2,029 rows — these rows as CSV