PREVIEW / futures_1hour / 2022-01-14
file: by_date/futures_1hour/2022/2022-01-14.parquet size: 57 KB rows: 1,626
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-01-14 00:00:00 | ES | Futures | 5264.64 | 5268.89 | 5261.82 | 5268.6 | 5047.0 |
| 2022-01-14 01:00:00 | ES | Futures | 5268.32 | 5275.39 | 5265.49 | 5273.13 | 8938.0 |
| 2022-01-14 02:00:00 | ES | Futures | 5273.41 | 5278.78 | 5263.51 | 5265.49 | 12096.0 |
| 2022-01-14 03:00:00 | ES | Futures | 5265.78 | 5278.22 | 5260.68 | 5265.49 | 26120.0 |
| 2022-01-14 04:00:00 | ES | Futures | 5265.78 | 5279.35 | 5264.93 | 5273.41 | 19431.0 |
| 2022-01-14 05:00:00 | ES | Futures | 5273.41 | 5274.26 | 5263.23 | 5270.02 | 12289.0 |
| 2022-01-14 06:00:00 | ES | Futures | 5270.3 | 5273.98 | 5259.84 | 5262.1 | 14701.0 |
| 2022-01-14 07:00:00 | ES | Futures | 5262.1 | 5262.95 | 5223.92 | 5224.77 | 50492.0 |
| 2022-01-14 08:00:00 | ES | Futures | 5224.77 | 5232.4 | 5211.19 | 5219.11 | 94396.0 |
| 2022-01-14 09:00:00 | ES | Futures | 5218.83 | 5262.95 | 5214.31 | 5261.25 | 299434.0 |
| 2022-01-14 10:00:00 | ES | Futures | 5260.97 | 5266.62 | 5232.12 | 5240.89 | 288787.0 |
| 2022-01-14 11:00:00 | ES | Futures | 5241.17 | 5250.22 | 5219.68 | 5244.85 | 239641.0 |
| 2022-01-14 12:00:00 | ES | Futures | 5245.13 | 5249.09 | 5217.42 | 5218.83 | 143507.0 |
| 2022-01-14 13:00:00 | ES | Futures | 5218.55 | 5236.08 | 5210.35 | 5233.82 | 175675.0 |
| 2022-01-14 14:00:00 | ES | Futures | 5233.82 | 5247.11 | 5227.88 | 5236.93 | 161225.0 |
| 2022-01-14 15:00:00 | ES | Futures | 5237.21 | 5269.73 | 5237.21 | 5264.36 | 272747.0 |
| 2022-01-14 16:00:00 | ES | Futures | 5264.64 | 5276.8 | 5264.08 | 5275.96 | 57788.0 |
| 2022-01-14 00:00:00 | NQ | Futures | 17960.55 | 17987.21 | 17948.38 | 17982.86 | 3897.0 |
| 2022-01-14 01:00:00 | NQ | Futures | 17983.44 | 18005.18 | 17964.9 | 17992.72 | 5775.0 |
| 2022-01-14 02:00:00 | NQ | Futures | 17993.01 | 18031.84 | 17956.78 | 17968.95 | 8169.0 |
| 2022-01-14 03:00:00 | NQ | Futures | 17968.95 | 18017.06 | 17936.49 | 17958.23 | 12529.0 |
| 2022-01-14 04:00:00 | NQ | Futures | 17959.68 | 18010.4 | 17949.54 | 17987.5 | 9538.0 |
| 2022-01-14 05:00:00 | NQ | Futures | 17988.37 | 17990.11 | 17926.06 | 17958.23 | 8486.0 |
| 2022-01-14 06:00:00 | NQ | Futures | 17958.23 | 17977.65 | 17916.79 | 17932.73 | 6977.0 |
| 2022-01-14 07:00:00 | NQ | Futures | 17932.15 | 17943.45 | 17761.44 | 17764.63 | 24053.0 |
| 2022-01-14 08:00:00 | NQ | Futures | 17765.21 | 17843.75 | 17751.3 | 17801.73 | 36933.0 |
| 2022-01-14 09:00:00 | NQ | Futures | 17800.57 | 18078.79 | 17783.18 | 18062.56 | 126213.0 |
| 2022-01-14 10:00:00 | NQ | Futures | 18060.54 | 18085.17 | 17918.53 | 17964.9 | 131706.0 |
| 2022-01-14 11:00:00 | NQ | Futures | 17965.19 | 18052.71 | 17873.89 | 18018.51 | 95037.0 |
| 2022-01-14 12:00:00 | NQ | Futures | 18019.38 | 18034.74 | 17891.86 | 17898.53 | 57121.0 |
| 2022-01-14 13:00:00 | NQ | Futures | 17898.24 | 18000.25 | 17857.37 | 17986.05 | 61412.0 |
| 2022-01-14 14:00:00 | NQ | Futures | 17985.76 | 18022.57 | 17934.75 | 17965.77 | 60379.0 |
| 2022-01-14 15:00:00 | NQ | Futures | 17965.19 | 18092.71 | 17965.19 | 18075.61 | 81664.0 |
| 2022-01-14 16:00:00 | NQ | Futures | 18076.48 | 18108.94 | 18066.62 | 18104.01 | 11809.0 |
| 2022-01-14 00:00:00 | YM | Futures | 40478.2 | 40498.4 | 40456.8 | 40491.6 | 972.0 |
| 2022-01-14 01:00:00 | YM | Futures | 40492.8 | 40554.6 | 40478.2 | 40533.2 | 1703.0 |
| 2022-01-14 02:00:00 | YM | Futures | 40535.5 | 40562.4 | 40473.7 | 40490.5 | 2926.0 |
| 2022-01-14 03:00:00 | YM | Futures | 40489.4 | 40573.7 | 40463.5 | 40489.4 | 6795.0 |
| 2022-01-14 04:00:00 | YM | Futures | 40490.5 | 40584.9 | 40483.8 | 40544.5 | 5396.0 |
| 2022-01-14 05:00:00 | YM | Futures | 40545.6 | 40553.5 | 40499.5 | 40543.3 | 3204.0 |
| 2022-01-14 06:00:00 | YM | Futures | 40544.5 | 40571.4 | 40460.2 | 40472.5 | 4434.0 |
| 2022-01-14 07:00:00 | YM | Futures | 40470.3 | 40470.3 | 40211.8 | 40220.8 | 12761.0 |
| 2022-01-14 08:00:00 | YM | Futures | 40221.9 | 40238.8 | 40081.5 | 40121.9 | 18046.0 |
| 2022-01-14 09:00:00 | YM | Futures | 40120.8 | 40278.1 | 39983.7 | 40275.9 | 42477.0 |
| 2022-01-14 10:00:00 | YM | Futures | 40270.3 | 40293.9 | 40094.9 | 40152.3 | 36769.0 |
| 2022-01-14 11:00:00 | YM | Futures | 40153.4 | 40198.3 | 40010.7 | 40164.6 | 26897.0 |
| 2022-01-14 12:00:00 | YM | Futures | 40166.9 | 40188.2 | 39946.6 | 39963.5 | 16197.0 |
| 2022-01-14 13:00:00 | YM | Futures | 39960.1 | 40051.1 | 39911.8 | 40034.3 | 18542.0 |
| 2022-01-14 14:00:00 | YM | Futures | 40033.1 | 40105.1 | 39993.8 | 40050.0 | 15387.0 |
| 2022-01-14 15:00:00 | YM | Futures | 40051.1 | 40254.5 | 40050.0 | 40221.9 | 24965.0 |
> showing 50 of 1,626 rows — these rows as CSV