PREVIEW / futures_1hour / 2024-05-06
file: by_date/futures_1hour/2024/2024-05-06.parquet size: 65 KB rows: 2,032
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-05-06 00:00:00 | ES | Futures | 5475.7 | 5475.7 | 5472.79 | 5473.32 | 2260.0 |
| 2024-05-06 01:00:00 | ES | Futures | 5473.05 | 5474.64 | 5471.19 | 5473.85 | 4589.0 |
| 2024-05-06 02:00:00 | ES | Futures | 5473.85 | 5478.89 | 5473.58 | 5477.83 | 6449.0 |
| 2024-05-06 03:00:00 | ES | Futures | 5477.83 | 5479.95 | 5475.17 | 5475.17 | 8379.0 |
| 2024-05-06 04:00:00 | ES | Futures | 5475.44 | 5481.81 | 5474.38 | 5480.48 | 8646.0 |
| 2024-05-06 05:00:00 | ES | Futures | 5480.48 | 5484.72 | 5479.95 | 5484.19 | 8835.0 |
| 2024-05-06 06:00:00 | ES | Futures | 5484.46 | 5491.36 | 5483.93 | 5490.03 | 12089.0 |
| 2024-05-06 07:00:00 | ES | Futures | 5489.76 | 5489.76 | 5487.11 | 5488.44 | 10121.0 |
| 2024-05-06 08:00:00 | ES | Futures | 5488.7 | 5494.54 | 5487.38 | 5491.62 | 19472.0 |
| 2024-05-06 09:00:00 | ES | Futures | 5491.89 | 5501.97 | 5489.76 | 5500.64 | 141273.0 |
| 2024-05-06 10:00:00 | ES | Futures | 5500.38 | 5505.15 | 5498.78 | 5501.17 | 126919.0 |
| 2024-05-06 11:00:00 | ES | Futures | 5501.44 | 5504.09 | 5496.66 | 5502.23 | 85286.0 |
| 2024-05-06 12:00:00 | ES | Futures | 5502.23 | 5506.21 | 5495.07 | 5505.42 | 94215.0 |
| 2024-05-06 13:00:00 | ES | Futures | 5505.15 | 5509.4 | 5500.64 | 5507.8 | 77388.0 |
| 2024-05-06 14:00:00 | ES | Futures | 5507.8 | 5517.62 | 5507.01 | 5513.38 | 92511.0 |
| 2024-05-06 15:00:00 | ES | Futures | 5513.11 | 5526.11 | 5507.54 | 5525.58 | 169479.0 |
| 2024-05-06 16:00:00 | ES | Futures | 5525.84 | 5526.37 | 5521.33 | 5523.72 | 73747.0 |
| 2024-05-06 18:00:00 | ES | Futures | 5523.19 | 5525.84 | 5520.54 | 5525.31 | 5352.0 |
| 2024-05-06 19:00:00 | ES | Futures | 5525.31 | 5526.64 | 5522.66 | 5523.99 | 4969.0 |
| 2024-05-06 20:00:00 | ES | Futures | 5523.99 | 5525.84 | 5522.66 | 5524.52 | 4518.0 |
| 2024-05-06 21:00:00 | ES | Futures | 5524.25 | 5525.31 | 5521.86 | 5525.05 | 5173.0 |
| 2024-05-06 22:00:00 | ES | Futures | 5524.78 | 5526.37 | 5523.19 | 5524.52 | 3401.0 |
| 2024-05-06 23:00:00 | ES | Futures | 5524.52 | 5527.44 | 5524.25 | 5527.44 | 3727.0 |
| 2024-05-06 00:00:00 | NQ | Futures | 19266.71 | 19267.25 | 19249.05 | 19254.94 | 1343.0 |
| 2024-05-06 01:00:00 | NQ | Futures | 19254.14 | 19260.29 | 19242.9 | 19255.74 | 2599.0 |
| 2024-05-06 02:00:00 | NQ | Futures | 19255.47 | 19284.9 | 19255.47 | 19279.82 | 3826.0 |
| 2024-05-06 03:00:00 | NQ | Futures | 19280.09 | 19291.05 | 19260.83 | 19261.09 | 6322.0 |
| 2024-05-06 04:00:00 | NQ | Futures | 19261.36 | 19299.35 | 19260.83 | 19290.52 | 5535.0 |
| 2024-05-06 05:00:00 | NQ | Futures | 19290.79 | 19309.24 | 19287.04 | 19307.1 | 4190.0 |
| 2024-05-06 06:00:00 | NQ | Futures | 19306.57 | 19324.22 | 19304.43 | 19316.2 | 6518.0 |
| 2024-05-06 07:00:00 | NQ | Futures | 19316.2 | 19316.2 | 19299.61 | 19305.77 | 6059.0 |
| 2024-05-06 08:00:00 | NQ | Futures | 19305.77 | 19338.13 | 19300.42 | 19323.69 | 10415.0 |
| 2024-05-06 09:00:00 | NQ | Futures | 19323.15 | 19377.72 | 19306.03 | 19377.72 | 68323.0 |
| 2024-05-06 10:00:00 | NQ | Futures | 19377.72 | 19385.48 | 19344.82 | 19365.42 | 56082.0 |
| 2024-05-06 11:00:00 | NQ | Futures | 19365.42 | 19390.3 | 19344.02 | 19379.33 | 35852.0 |
| 2024-05-06 12:00:00 | NQ | Futures | 19379.6 | 19387.89 | 19332.25 | 19386.02 | 38722.0 |
| 2024-05-06 13:00:00 | NQ | Futures | 19386.28 | 19401.8 | 19359.8 | 19397.79 | 30095.0 |
| 2024-05-06 14:00:00 | NQ | Futures | 19397.79 | 19425.88 | 19392.44 | 19416.24 | 30650.0 |
| 2024-05-06 15:00:00 | NQ | Futures | 19415.98 | 19472.42 | 19398.86 | 19471.35 | 49316.0 |
| 2024-05-06 16:00:00 | NQ | Futures | 19471.35 | 19475.63 | 19452.09 | 19458.78 | 16135.0 |
| 2024-05-06 18:00:00 | NQ | Futures | 19463.06 | 19466.8 | 19448.08 | 19465.73 | 2465.0 |
| 2024-05-06 19:00:00 | NQ | Futures | 19465.47 | 19470.82 | 19452.36 | 19457.44 | 2553.0 |
| 2024-05-06 20:00:00 | NQ | Futures | 19457.17 | 19461.72 | 19443.53 | 19450.49 | 2791.0 |
| 2024-05-06 21:00:00 | NQ | Futures | 19451.02 | 19456.64 | 19440.86 | 19454.5 | 2971.0 |
| 2024-05-06 22:00:00 | NQ | Futures | 19454.5 | 19459.85 | 19449.15 | 19452.36 | 1860.0 |
| 2024-05-06 23:00:00 | NQ | Futures | 19451.82 | 19461.99 | 19450.22 | 19461.72 | 1454.0 |
| 2024-05-06 00:00:00 | YM | Futures | 41269.4 | 41269.4 | 41256.7 | 41256.7 | 232.0 |
| 2024-05-06 01:00:00 | YM | Futures | 41257.8 | 41267.3 | 41247.1 | 41262.0 | 489.0 |
| 2024-05-06 02:00:00 | YM | Futures | 41260.9 | 41297.0 | 41257.8 | 41282.2 | 950.0 |
| 2024-05-06 03:00:00 | YM | Futures | 41282.2 | 41291.7 | 41267.3 | 41271.6 | 1090.0 |
> showing 50 of 2,032 rows — these rows as CSV