PREVIEW / futures_1hour / 2022-12-16
file: by_date/futures_1hour/2022/2022-12-16.parquet size: 56 KB rows: 1,604
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-16 00:00:00 | ES | Futures | 4387.31 | 4393.74 | 4383.11 | 4393.46 | 9150.0 |
| 2022-12-16 01:00:00 | ES | Futures | 4393.46 | 4397.93 | 4388.15 | 4397.09 | 8636.0 |
| 2022-12-16 02:00:00 | ES | Futures | 4396.81 | 4398.21 | 4378.64 | 4379.48 | 13352.0 |
| 2022-12-16 03:00:00 | ES | Futures | 4379.76 | 4385.91 | 4345.09 | 4346.76 | 45455.0 |
| 2022-12-16 04:00:00 | ES | Futures | 4346.76 | 4350.12 | 4338.1 | 4347.04 | 29548.0 |
| 2022-12-16 05:00:00 | ES | Futures | 4346.76 | 4349.0 | 4329.71 | 4335.3 | 37978.0 |
| 2022-12-16 06:00:00 | ES | Futures | 4335.3 | 4348.16 | 4331.39 | 4343.41 | 19542.0 |
| 2022-12-16 07:00:00 | ES | Futures | 4343.13 | 4358.79 | 4339.77 | 4358.51 | 35226.0 |
| 2022-12-16 08:00:00 | ES | Futures | 4358.51 | 4358.51 | 4343.41 | 4348.72 | 45693.0 |
| 2022-12-16 09:00:00 | ES | Futures | 4348.72 | 4375.84 | 4338.65 | 4368.01 | 231979.0 |
| 2022-12-16 10:00:00 | ES | Futures | 4368.01 | 4368.01 | 4322.16 | 4335.86 | 285758.0 |
| 2022-12-16 11:00:00 | ES | Futures | 4335.86 | 4341.17 | 4316.29 | 4318.24 | 194342.0 |
| 2022-12-16 12:00:00 | ES | Futures | 4318.24 | 4333.34 | 4311.81 | 4313.77 | 139317.0 |
| 2022-12-16 13:00:00 | ES | Futures | 4313.49 | 4323.84 | 4312.37 | 4319.92 | 110346.0 |
| 2022-12-16 14:00:00 | ES | Futures | 4319.92 | 4337.26 | 4314.05 | 4333.9 | 127277.0 |
| 2022-12-16 15:00:00 | ES | Futures | 4333.9 | 4356.83 | 4327.19 | 4336.98 | 347299.0 |
| 2022-12-16 16:00:00 | ES | Futures | 4336.98 | 4338.65 | 4326.91 | 4330.55 | 100519.0 |
| 2022-12-16 00:00:00 | NQ | Futures | 13025.28 | 13042.63 | 13007.07 | 13041.78 | 4055.0 |
| 2022-12-16 01:00:00 | NQ | Futures | 13042.35 | 13058.56 | 13023.28 | 13055.43 | 3808.0 |
| 2022-12-16 02:00:00 | NQ | Futures | 13054.01 | 13057.71 | 12986.02 | 12988.86 | 6738.0 |
| 2022-12-16 03:00:00 | NQ | Futures | 12989.71 | 13015.03 | 12889.0 | 12895.55 | 19081.0 |
| 2022-12-16 04:00:00 | NQ | Futures | 12894.41 | 12920.01 | 12873.36 | 12919.16 | 12887.0 |
| 2022-12-16 05:00:00 | NQ | Futures | 12919.16 | 12930.26 | 12884.45 | 12909.49 | 11858.0 |
| 2022-12-16 06:00:00 | NQ | Futures | 12909.2 | 12955.01 | 12898.68 | 12938.79 | 9659.0 |
| 2022-12-16 07:00:00 | NQ | Futures | 12938.22 | 12997.4 | 12933.1 | 12996.83 | 12900.0 |
| 2022-12-16 08:00:00 | NQ | Futures | 12996.83 | 12996.83 | 12949.03 | 12972.36 | 16086.0 |
| 2022-12-16 09:00:00 | NQ | Futures | 12973.21 | 13077.05 | 12931.39 | 13034.95 | 87126.0 |
| 2022-12-16 10:00:00 | NQ | Futures | 13036.09 | 13036.09 | 12873.64 | 12924.0 | 105075.0 |
| 2022-12-16 11:00:00 | NQ | Futures | 12924.0 | 12929.69 | 12853.44 | 12862.55 | 78717.0 |
| 2022-12-16 12:00:00 | NQ | Futures | 12862.55 | 12919.16 | 12843.48 | 12849.74 | 56693.0 |
| 2022-12-16 13:00:00 | NQ | Futures | 12850.03 | 12876.77 | 12838.93 | 12859.42 | 45346.0 |
| 2022-12-16 14:00:00 | NQ | Futures | 12858.85 | 12906.93 | 12831.25 | 12893.27 | 50029.0 |
| 2022-12-16 15:00:00 | NQ | Futures | 12893.56 | 12967.24 | 12872.79 | 12907.21 | 96513.0 |
| 2022-12-16 16:00:00 | NQ | Futures | 12906.93 | 12913.47 | 12869.37 | 12881.89 | 18972.0 |
| 2022-12-16 00:00:00 | YM | Futures | 37213.7 | 37259.4 | 37188.0 | 37259.4 | 1261.0 |
| 2022-12-16 01:00:00 | YM | Futures | 37259.4 | 37319.5 | 37223.7 | 37306.1 | 2122.0 |
| 2022-12-16 02:00:00 | YM | Futures | 37305.0 | 37311.7 | 37166.9 | 37173.6 | 2084.0 |
| 2022-12-16 03:00:00 | YM | Futures | 37176.9 | 37218.1 | 36908.4 | 36925.1 | 6947.0 |
| 2022-12-16 04:00:00 | YM | Futures | 36926.2 | 36940.7 | 36857.1 | 36919.5 | 5702.0 |
| 2022-12-16 05:00:00 | YM | Futures | 36919.5 | 36937.4 | 36774.7 | 36807.0 | 5190.0 |
| 2022-12-16 06:00:00 | YM | Futures | 36808.1 | 36890.6 | 36780.3 | 36850.4 | 2919.0 |
| 2022-12-16 07:00:00 | YM | Futures | 36849.3 | 36955.2 | 36815.9 | 36950.7 | 3914.0 |
| 2022-12-16 08:00:00 | YM | Futures | 36954.1 | 36954.1 | 36804.8 | 36851.6 | 4575.0 |
| 2022-12-16 09:00:00 | YM | Futures | 36852.7 | 37080.0 | 36786.9 | 37057.7 | 25579.0 |
| 2022-12-16 10:00:00 | YM | Futures | 37058.8 | 37058.8 | 36726.8 | 36844.9 | 24448.0 |
| 2022-12-16 11:00:00 | YM | Futures | 36847.1 | 36899.5 | 36692.2 | 36705.6 | 16547.0 |
| 2022-12-16 12:00:00 | YM | Futures | 36705.6 | 36795.9 | 36624.3 | 36632.1 | 12768.0 |
| 2022-12-16 13:00:00 | YM | Futures | 36633.2 | 36725.7 | 36622.0 | 36705.6 | 9995.0 |
| 2022-12-16 14:00:00 | YM | Futures | 36705.6 | 36866.0 | 36676.6 | 36842.6 | 12233.0 |
| 2022-12-16 15:00:00 | YM | Futures | 36841.5 | 37013.1 | 36785.8 | 36896.1 | 25841.0 |
> showing 50 of 1,604 rows — these rows as CSV