PREVIEW / futures_1hour / 2021-12-13
file: by_date/futures_1hour/2021/2021-12-13.parquet size: 64 KB rows: 1,982
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-13 00:00:00 | ES | Futures | 5337.2 | 5337.48 | 5331.56 | 5334.38 | 2199.0 |
| 2021-12-13 01:00:00 | ES | Futures | 5334.1 | 5337.77 | 5332.69 | 5336.07 | 2315.0 |
| 2021-12-13 02:00:00 | ES | Futures | 5336.07 | 5337.77 | 5329.58 | 5331.27 | 3671.0 |
| 2021-12-13 03:00:00 | ES | Futures | 5331.27 | 5334.66 | 5324.22 | 5330.71 | 7182.0 |
| 2021-12-13 04:00:00 | ES | Futures | 5330.71 | 5338.89 | 5329.3 | 5335.51 | 5386.0 |
| 2021-12-13 05:00:00 | ES | Futures | 5335.79 | 5336.92 | 5329.58 | 5334.1 | 4280.0 |
| 2021-12-13 06:00:00 | ES | Futures | 5334.1 | 5339.18 | 5329.02 | 5333.25 | 7332.0 |
| 2021-12-13 07:00:00 | ES | Futures | 5332.69 | 5332.69 | 5326.48 | 5327.32 | 6453.0 |
| 2021-12-13 08:00:00 | ES | Futures | 5327.32 | 5331.56 | 5324.5 | 5325.63 | 9241.0 |
| 2021-12-13 09:00:00 | ES | Futures | 5325.91 | 5325.91 | 5291.76 | 5295.43 | 108960.0 |
| 2021-12-13 10:00:00 | ES | Futures | 5295.43 | 5302.77 | 5278.78 | 5284.43 | 87301.0 |
| 2021-12-13 11:00:00 | ES | Futures | 5284.43 | 5286.97 | 5273.14 | 5279.35 | 73597.0 |
| 2021-12-13 12:00:00 | ES | Futures | 5279.07 | 5288.66 | 5273.14 | 5281.61 | 41463.0 |
| 2021-12-13 13:00:00 | ES | Futures | 5281.61 | 5286.12 | 5275.68 | 5284.14 | 26681.0 |
| 2021-12-13 14:00:00 | ES | Futures | 5284.14 | 5290.64 | 5280.19 | 5289.79 | 32881.0 |
| 2021-12-13 15:00:00 | ES | Futures | 5289.51 | 5294.02 | 5268.06 | 5271.73 | 128959.0 |
| 2021-12-13 16:00:00 | ES | Futures | 5271.73 | 5277.65 | 5265.8 | 5274.83 | 19850.0 |
| 2021-12-13 18:00:00 | ES | Futures | 5273.99 | 5278.78 | 5272.29 | 5276.81 | 3148.0 |
| 2021-12-13 19:00:00 | ES | Futures | 5276.81 | 5281.89 | 5276.24 | 5281.61 | 3679.0 |
| 2021-12-13 20:00:00 | ES | Futures | 5281.61 | 5282.17 | 5276.81 | 5279.07 | 2986.0 |
| 2021-12-13 21:00:00 | ES | Futures | 5279.35 | 5280.48 | 5276.53 | 5277.09 | 2436.0 |
| 2021-12-13 22:00:00 | ES | Futures | 5277.37 | 5280.19 | 5271.73 | 5279.35 | 2214.0 |
| 2021-12-13 23:00:00 | ES | Futures | 5279.63 | 5280.76 | 5276.81 | 5278.22 | 1258.0 |
| 2021-12-13 00:00:00 | NQ | Futures | 19001.57 | 19002.73 | 18977.52 | 18981.57 | 1507.0 |
| 2021-12-13 01:00:00 | NQ | Futures | 18980.42 | 18998.67 | 18976.07 | 18989.69 | 1588.0 |
| 2021-12-13 02:00:00 | NQ | Futures | 18990.85 | 18994.33 | 18968.24 | 18973.46 | 2101.0 |
| 2021-12-13 03:00:00 | NQ | Futures | 18973.46 | 18982.73 | 18946.51 | 18967.37 | 3603.0 |
| 2021-12-13 04:00:00 | NQ | Futures | 18967.66 | 19006.79 | 18965.63 | 18999.25 | 2968.0 |
| 2021-12-13 05:00:00 | NQ | Futures | 18999.25 | 19013.74 | 18985.92 | 19003.6 | 2386.0 |
| 2021-12-13 06:00:00 | NQ | Futures | 19004.18 | 19025.05 | 18983.89 | 19005.63 | 3200.0 |
| 2021-12-13 07:00:00 | NQ | Futures | 19003.89 | 19011.14 | 18987.66 | 18998.38 | 2183.0 |
| 2021-12-13 08:00:00 | NQ | Futures | 18999.54 | 19007.37 | 18990.56 | 18992.88 | 2300.0 |
| 2021-12-13 09:00:00 | NQ | Futures | 18992.01 | 18993.17 | 18843.04 | 18865.07 | 28978.0 |
| 2021-12-13 10:00:00 | NQ | Futures | 18865.94 | 18910.28 | 18758.13 | 18788.56 | 31864.0 |
| 2021-12-13 11:00:00 | NQ | Futures | 18787.98 | 18800.73 | 18676.98 | 18706.83 | 25126.0 |
| 2021-12-13 12:00:00 | NQ | Futures | 18705.67 | 18768.27 | 18683.35 | 18735.23 | 14610.0 |
| 2021-12-13 13:00:00 | NQ | Futures | 18734.07 | 18764.5 | 18687.12 | 18732.91 | 11756.0 |
| 2021-12-13 14:00:00 | NQ | Futures | 18730.59 | 18774.07 | 18710.89 | 18772.33 | 9198.0 |
| 2021-12-13 15:00:00 | NQ | Futures | 18771.75 | 18789.43 | 18633.21 | 18650.02 | 23022.0 |
| 2021-12-13 16:00:00 | NQ | Futures | 18649.73 | 18659.88 | 18622.78 | 18656.4 | 7354.0 |
| 2021-12-13 18:00:00 | NQ | Futures | 18646.84 | 18668.57 | 18643.94 | 18654.08 | 1590.0 |
| 2021-12-13 19:00:00 | NQ | Futures | 18653.79 | 18672.92 | 18652.63 | 18671.76 | 2531.0 |
| 2021-12-13 20:00:00 | NQ | Futures | 18671.47 | 18676.98 | 18653.79 | 18664.8 | 1667.0 |
| 2021-12-13 21:00:00 | NQ | Futures | 18663.65 | 18671.76 | 18653.21 | 18656.98 | 1178.0 |
| 2021-12-13 22:00:00 | NQ | Futures | 18656.98 | 18663.93 | 18635.53 | 18663.07 | 1363.0 |
| 2021-12-13 23:00:00 | NQ | Futures | 18663.36 | 18666.54 | 18656.69 | 18664.8 | 850.0 |
| 2021-12-13 00:00:00 | YM | Futures | 40456.8 | 40457.9 | 40414.1 | 40441.1 | 855.0 |
| 2021-12-13 01:00:00 | YM | Futures | 40439.9 | 40466.9 | 40438.8 | 40451.2 | 717.0 |
| 2021-12-13 02:00:00 | YM | Futures | 40452.3 | 40463.5 | 40398.4 | 40410.7 | 1894.0 |
| 2021-12-13 03:00:00 | YM | Futures | 40410.7 | 40443.3 | 40369.2 | 40415.2 | 3119.0 |
> showing 50 of 1,982 rows — these rows as CSV