PREVIEW / futures_1hour / 2024-05-07
file: by_date/futures_1hour/2024/2024-05-07.parquet size: 67 KB rows: 2,103
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-07 00:00:00 | ES | Futures | 5527.17 | 5527.97 | 5525.31 | 5525.84 | 3355.0 |
| 2024-05-07 01:00:00 | ES | Futures | 5526.11 | 5526.91 | 5524.52 | 5524.78 | 3722.0 |
| 2024-05-07 02:00:00 | ES | Futures | 5525.05 | 5527.44 | 5524.78 | 5526.91 | 6356.0 |
| 2024-05-07 03:00:00 | ES | Futures | 5526.91 | 5528.5 | 5521.33 | 5521.86 | 13764.0 |
| 2024-05-07 04:00:00 | ES | Futures | 5522.13 | 5531.68 | 5520.54 | 5531.15 | 16776.0 |
| 2024-05-07 05:00:00 | ES | Futures | 5530.88 | 5532.21 | 5525.84 | 5527.44 | 10565.0 |
| 2024-05-07 06:00:00 | ES | Futures | 5527.7 | 5529.29 | 5525.84 | 5528.76 | 9478.0 |
| 2024-05-07 07:00:00 | ES | Futures | 5528.76 | 5529.56 | 5523.46 | 5526.11 | 12925.0 |
| 2024-05-07 08:00:00 | ES | Futures | 5525.84 | 5532.21 | 5525.31 | 5531.95 | 17722.0 |
| 2024-05-07 09:00:00 | ES | Futures | 5531.68 | 5539.64 | 5531.15 | 5531.95 | 160205.0 |
| 2024-05-07 10:00:00 | ES | Futures | 5531.95 | 5543.09 | 5529.29 | 5541.76 | 147332.0 |
| 2024-05-07 11:00:00 | ES | Futures | 5542.03 | 5543.62 | 5537.25 | 5541.23 | 97035.0 |
| 2024-05-07 12:00:00 | ES | Futures | 5541.5 | 5543.62 | 5535.66 | 5539.37 | 80142.0 |
| 2024-05-07 13:00:00 | ES | Futures | 5539.11 | 5546.54 | 5527.44 | 5529.82 | 110041.0 |
| 2024-05-07 14:00:00 | ES | Futures | 5529.82 | 5534.33 | 5523.99 | 5530.09 | 121915.0 |
| 2024-05-07 15:00:00 | ES | Futures | 5529.82 | 5538.84 | 5526.11 | 5531.15 | 185674.0 |
| 2024-05-07 16:00:00 | ES | Futures | 5531.42 | 5534.86 | 5529.56 | 5530.88 | 39950.0 |
| 2024-05-07 18:00:00 | ES | Futures | 5530.62 | 5533.54 | 5526.91 | 5533.54 | 6416.0 |
| 2024-05-07 19:00:00 | ES | Futures | 5533.27 | 5534.86 | 5531.68 | 5533.01 | 4075.0 |
| 2024-05-07 20:00:00 | ES | Futures | 5533.27 | 5535.13 | 5531.95 | 5533.54 | 5474.0 |
| 2024-05-07 21:00:00 | ES | Futures | 5533.54 | 5534.6 | 5531.15 | 5531.95 | 4416.0 |
| 2024-05-07 22:00:00 | ES | Futures | 5531.95 | 5533.01 | 5529.03 | 5531.15 | 4575.0 |
| 2024-05-07 23:00:00 | ES | Futures | 5531.15 | 5533.27 | 5529.56 | 5531.68 | 3354.0 |
| 2024-05-07 00:00:00 | NQ | Futures | 19461.72 | 19463.86 | 19453.43 | 19457.44 | 1491.0 |
| 2024-05-07 01:00:00 | NQ | Futures | 19457.98 | 19461.45 | 19451.29 | 19452.63 | 1349.0 |
| 2024-05-07 02:00:00 | NQ | Futures | 19452.89 | 19462.52 | 19451.56 | 19459.58 | 2771.0 |
| 2024-05-07 03:00:00 | NQ | Futures | 19459.58 | 19470.55 | 19435.24 | 19436.04 | 6479.0 |
| 2024-05-07 04:00:00 | NQ | Futures | 19436.84 | 19469.75 | 19426.14 | 19468.68 | 7593.0 |
| 2024-05-07 05:00:00 | NQ | Futures | 19468.68 | 19473.22 | 19436.04 | 19447.01 | 5517.0 |
| 2024-05-07 06:00:00 | NQ | Futures | 19446.21 | 19456.1 | 19437.11 | 19453.96 | 4550.0 |
| 2024-05-07 07:00:00 | NQ | Futures | 19453.96 | 19458.24 | 19421.86 | 19437.11 | 8640.0 |
| 2024-05-07 08:00:00 | NQ | Futures | 19436.84 | 19470.01 | 19431.49 | 19466.0 | 10320.0 |
| 2024-05-07 09:00:00 | NQ | Futures | 19466.0 | 19512.81 | 19461.45 | 19467.07 | 73936.0 |
| 2024-05-07 10:00:00 | NQ | Futures | 19467.34 | 19529.67 | 19454.77 | 19528.06 | 78805.0 |
| 2024-05-07 11:00:00 | NQ | Futures | 19528.33 | 19542.51 | 19510.94 | 19530.47 | 48280.0 |
| 2024-05-07 12:00:00 | NQ | Futures | 19530.74 | 19542.51 | 19504.79 | 19517.09 | 37774.0 |
| 2024-05-07 13:00:00 | NQ | Futures | 19517.09 | 19545.18 | 19456.64 | 19467.61 | 46880.0 |
| 2024-05-07 14:00:00 | NQ | Futures | 19468.14 | 19489.01 | 19438.45 | 19468.14 | 50971.0 |
| 2024-05-07 15:00:00 | NQ | Futures | 19468.41 | 19496.5 | 19453.7 | 19470.82 | 54563.0 |
| 2024-05-07 16:00:00 | NQ | Futures | 19470.28 | 19490.88 | 19467.07 | 19471.89 | 10775.0 |
| 2024-05-07 18:00:00 | NQ | Futures | 19467.87 | 19478.84 | 19453.96 | 19478.04 | 3442.0 |
| 2024-05-07 19:00:00 | NQ | Futures | 19478.04 | 19483.39 | 19470.55 | 19479.11 | 1961.0 |
| 2024-05-07 20:00:00 | NQ | Futures | 19479.11 | 19487.4 | 19475.1 | 19483.39 | 2299.0 |
| 2024-05-07 21:00:00 | NQ | Futures | 19483.39 | 19490.88 | 19477.24 | 19478.57 | 2309.0 |
| 2024-05-07 22:00:00 | NQ | Futures | 19478.84 | 19483.92 | 19468.68 | 19475.9 | 2598.0 |
| 2024-05-07 23:00:00 | NQ | Futures | 19475.63 | 19477.77 | 19466.0 | 19468.41 | 1937.0 |
| 2024-05-07 00:00:00 | YM | Futures | 41425.5 | 41427.6 | 41412.8 | 41417.0 | 308.0 |
| 2024-05-07 01:00:00 | YM | Futures | 41418.1 | 41424.4 | 41405.3 | 41405.3 | 302.0 |
| 2024-05-07 02:00:00 | YM | Futures | 41406.4 | 41447.8 | 41406.4 | 41437.2 | 1207.0 |
| 2024-05-07 03:00:00 | YM | Futures | 41438.2 | 41456.3 | 41404.3 | 41410.6 | 1657.0 |
> showing 50 of 2,103 rows — these rows as CSV