PREVIEW / futures_1hour / 2024-04-19
file: by_date/futures_1hour/2024/2024-04-19.parquet size: 57 KB rows: 1,665
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-19 00:00:00 | ES | Futures | 5306.98 | 5316.53 | 5306.44 | 5310.16 | 15988.0 |
| 2024-04-19 01:00:00 | ES | Futures | 5310.69 | 5316.53 | 5304.06 | 5313.61 | 14564.0 |
| 2024-04-19 02:00:00 | ES | Futures | 5313.61 | 5331.91 | 5308.3 | 5328.46 | 34421.0 |
| 2024-04-19 03:00:00 | ES | Futures | 5328.46 | 5336.95 | 5326.87 | 5334.04 | 34149.0 |
| 2024-04-19 04:00:00 | ES | Futures | 5334.04 | 5339.34 | 5325.28 | 5330.59 | 24372.0 |
| 2024-04-19 05:00:00 | ES | Futures | 5330.59 | 5343.32 | 5330.06 | 5336.16 | 20732.0 |
| 2024-04-19 06:00:00 | ES | Futures | 5336.42 | 5345.18 | 5328.99 | 5338.28 | 24135.0 |
| 2024-04-19 07:00:00 | ES | Futures | 5338.01 | 5355.79 | 5332.71 | 5352.87 | 46663.0 |
| 2024-04-19 08:00:00 | ES | Futures | 5352.61 | 5365.87 | 5345.71 | 5355.79 | 56540.0 |
| 2024-04-19 09:00:00 | ES | Futures | 5355.79 | 5367.46 | 5346.5 | 5358.18 | 245313.0 |
| 2024-04-19 10:00:00 | ES | Futures | 5358.18 | 5363.75 | 5335.89 | 5346.24 | 257298.0 |
| 2024-04-19 11:00:00 | ES | Futures | 5346.24 | 5351.01 | 5329.26 | 5330.85 | 179511.0 |
| 2024-04-19 12:00:00 | ES | Futures | 5330.59 | 5338.01 | 5308.83 | 5330.85 | 215387.0 |
| 2024-04-19 13:00:00 | ES | Futures | 5330.59 | 5345.71 | 5323.95 | 5333.24 | 182141.0 |
| 2024-04-19 14:00:00 | ES | Futures | 5333.24 | 5333.77 | 5297.96 | 5307.77 | 235825.0 |
| 2024-04-19 15:00:00 | ES | Futures | 5307.77 | 5316.26 | 5296.63 | 5309.36 | 344523.0 |
| 2024-04-19 16:00:00 | ES | Futures | 5309.36 | 5312.28 | 5305.38 | 5309.63 | 79385.0 |
| 2024-04-19 00:00:00 | NQ | Futures | 18552.47 | 18609.45 | 18550.6 | 18584.04 | 9947.0 |
| 2024-04-19 01:00:00 | NQ | Futures | 18583.24 | 18605.17 | 18561.84 | 18587.78 | 7935.0 |
| 2024-04-19 02:00:00 | NQ | Futures | 18588.59 | 18657.6 | 18565.58 | 18646.1 | 16021.0 |
| 2024-04-19 03:00:00 | NQ | Futures | 18646.64 | 18682.21 | 18632.46 | 18653.06 | 16455.0 |
| 2024-04-19 04:00:00 | NQ | Futures | 18654.39 | 18669.64 | 18606.51 | 18631.39 | 14104.0 |
| 2024-04-19 05:00:00 | NQ | Futures | 18631.92 | 18687.03 | 18628.98 | 18655.73 | 10637.0 |
| 2024-04-19 06:00:00 | NQ | Futures | 18655.46 | 18688.1 | 18627.38 | 18665.9 | 11400.0 |
| 2024-04-19 07:00:00 | NQ | Futures | 18665.63 | 18733.31 | 18650.92 | 18729.03 | 19325.0 |
| 2024-04-19 08:00:00 | NQ | Futures | 18729.83 | 18782.26 | 18705.22 | 18744.27 | 23250.0 |
| 2024-04-19 09:00:00 | NQ | Futures | 18743.47 | 18749.62 | 18648.78 | 18676.86 | 106421.0 |
| 2024-04-19 10:00:00 | NQ | Futures | 18676.6 | 18697.46 | 18555.15 | 18607.31 | 124001.0 |
| 2024-04-19 11:00:00 | NQ | Futures | 18606.78 | 18607.05 | 18498.97 | 18500.58 | 84535.0 |
| 2024-04-19 12:00:00 | NQ | Futures | 18500.58 | 18531.07 | 18408.29 | 18494.16 | 98353.0 |
| 2024-04-19 13:00:00 | NQ | Futures | 18494.16 | 18554.61 | 18463.93 | 18499.78 | 74804.0 |
| 2024-04-19 14:00:00 | NQ | Futures | 18499.78 | 18502.45 | 18331.52 | 18360.67 | 117094.0 |
| 2024-04-19 15:00:00 | NQ | Futures | 18360.94 | 18410.7 | 18311.45 | 18384.75 | 130882.0 |
| 2024-04-19 16:00:00 | NQ | Futures | 18385.02 | 18390.9 | 18359.6 | 18382.07 | 19872.0 |
| 2024-04-19 00:00:00 | YM | Futures | 40028.3 | 40082.4 | 40025.1 | 40045.3 | 1772.0 |
| 2024-04-19 01:00:00 | YM | Futures | 40044.2 | 40078.2 | 40009.2 | 40059.1 | 1251.0 |
| 2024-04-19 02:00:00 | YM | Futures | 40062.3 | 40206.7 | 40033.6 | 40158.9 | 4277.0 |
| 2024-04-19 03:00:00 | YM | Futures | 40157.8 | 40221.5 | 40148.3 | 40206.7 | 4209.0 |
| 2024-04-19 04:00:00 | YM | Futures | 40208.8 | 40243.8 | 40152.5 | 40188.6 | 3776.0 |
| 2024-04-19 05:00:00 | YM | Futures | 40189.7 | 40260.8 | 40181.2 | 40212.0 | 3685.0 |
| 2024-04-19 06:00:00 | YM | Futures | 40210.9 | 40258.7 | 40175.9 | 40242.8 | 4078.0 |
| 2024-04-19 07:00:00 | YM | Futures | 40240.6 | 40327.7 | 40237.5 | 40300.1 | 6694.0 |
| 2024-04-19 08:00:00 | YM | Futures | 40300.1 | 40390.3 | 40262.9 | 40337.3 | 5853.0 |
| 2024-04-19 09:00:00 | YM | Futures | 40336.2 | 40559.2 | 40326.6 | 40523.1 | 28143.0 |
| 2024-04-19 10:00:00 | YM | Futures | 40522.0 | 40594.2 | 40463.6 | 40531.5 | 27655.0 |
| 2024-04-19 11:00:00 | YM | Futures | 40530.5 | 40575.1 | 40480.6 | 40511.4 | 15699.0 |
| 2024-04-19 12:00:00 | YM | Futures | 40509.3 | 40569.8 | 40408.4 | 40562.3 | 20497.0 |
| 2024-04-19 13:00:00 | YM | Futures | 40560.2 | 40709.9 | 40544.3 | 40634.5 | 16413.0 |
| 2024-04-19 14:00:00 | YM | Futures | 40633.5 | 40635.6 | 40439.2 | 40507.1 | 20252.0 |
| 2024-04-19 15:00:00 | YM | Futures | 40506.1 | 40601.6 | 40471.0 | 40566.6 | 24359.0 |
> showing 50 of 1,665 rows — these rows as CSV