PREVIEW / futures_1hour / 2021-10-11
file: by_date/futures_1hour/2021/2021-10-11.parquet size: 64 KB rows: 1,973
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-10-11 00:00:00 | ES | Futures | 4935.61 | 4942.1 | 4934.2 | 4940.13 | 4741.0 |
| 2021-10-11 01:00:00 | ES | Futures | 4940.13 | 4944.93 | 4938.43 | 4944.36 | 6513.0 |
| 2021-10-11 02:00:00 | ES | Futures | 4944.36 | 4947.75 | 4925.74 | 4932.51 | 16809.0 |
| 2021-10-11 03:00:00 | ES | Futures | 4932.23 | 4940.97 | 4924.32 | 4929.97 | 25181.0 |
| 2021-10-11 04:00:00 | ES | Futures | 4929.97 | 4935.89 | 4924.61 | 4932.51 | 17739.0 |
| 2021-10-11 05:00:00 | ES | Futures | 4932.51 | 4937.02 | 4930.25 | 4933.64 | 9291.0 |
| 2021-10-11 06:00:00 | ES | Futures | 4933.92 | 4935.33 | 4919.24 | 4922.63 | 15114.0 |
| 2021-10-11 07:00:00 | ES | Futures | 4922.63 | 4931.66 | 4920.94 | 4925.17 | 16371.0 |
| 2021-10-11 08:00:00 | ES | Futures | 4925.17 | 4938.72 | 4921.78 | 4936.18 | 28316.0 |
| 2021-10-11 09:00:00 | ES | Futures | 4936.46 | 4965.24 | 4935.33 | 4965.24 | 155862.0 |
| 2021-10-11 10:00:00 | ES | Futures | 4965.24 | 4975.4 | 4964.68 | 4968.35 | 134376.0 |
| 2021-10-11 11:00:00 | ES | Futures | 4968.35 | 4973.71 | 4962.14 | 4967.5 | 89229.0 |
| 2021-10-11 12:00:00 | ES | Futures | 4967.5 | 4968.63 | 4946.05 | 4950.01 | 108413.0 |
| 2021-10-11 13:00:00 | ES | Futures | 4950.01 | 4950.01 | 4925.74 | 4931.94 | 141373.0 |
| 2021-10-11 14:00:00 | ES | Futures | 4931.66 | 4941.54 | 4928.84 | 4935.89 | 103152.0 |
| 2021-10-11 15:00:00 | ES | Futures | 4935.61 | 4938.43 | 4910.5 | 4911.34 | 197148.0 |
| 2021-10-11 16:00:00 | ES | Futures | 4911.34 | 4911.91 | 4903.72 | 4907.39 | 56892.0 |
| 2021-10-11 18:00:00 | ES | Futures | 4907.96 | 4910.21 | 4901.18 | 4902.59 | 9411.0 |
| 2021-10-11 19:00:00 | ES | Futures | 4902.59 | 4909.08 | 4901.18 | 4908.24 | 9072.0 |
| 2021-10-11 20:00:00 | ES | Futures | 4908.24 | 4909.65 | 4885.66 | 4889.89 | 25295.0 |
| 2021-10-11 21:00:00 | ES | Futures | 4890.18 | 4891.59 | 4878.32 | 4890.46 | 25125.0 |
| 2021-10-11 22:00:00 | ES | Futures | 4890.46 | 4895.82 | 4888.77 | 4893.0 | 9625.0 |
| 2021-10-11 23:00:00 | ES | Futures | 4893.0 | 4894.97 | 4884.81 | 4885.38 | 7143.0 |
| 2021-10-11 00:00:00 | NQ | Futures | 17098.92 | 17131.38 | 17093.13 | 17122.98 | 3219.0 |
| 2021-10-11 01:00:00 | NQ | Futures | 17123.85 | 17148.48 | 17119.79 | 17145.87 | 4296.0 |
| 2021-10-11 02:00:00 | NQ | Futures | 17146.16 | 17156.6 | 17065.3 | 17097.18 | 11412.0 |
| 2021-10-11 03:00:00 | NQ | Futures | 17096.89 | 17127.61 | 17064.14 | 17088.78 | 12222.0 |
| 2021-10-11 04:00:00 | NQ | Futures | 17088.2 | 17107.04 | 17068.78 | 17101.82 | 8766.0 |
| 2021-10-11 05:00:00 | NQ | Futures | 17100.95 | 17118.34 | 17087.62 | 17098.63 | 4626.0 |
| 2021-10-11 06:00:00 | NQ | Futures | 17098.92 | 17103.85 | 17026.18 | 17041.83 | 9084.0 |
| 2021-10-11 07:00:00 | NQ | Futures | 17042.12 | 17073.71 | 17024.73 | 17035.74 | 11155.0 |
| 2021-10-11 08:00:00 | NQ | Futures | 17036.61 | 17090.81 | 17019.51 | 17078.64 | 14799.0 |
| 2021-10-11 09:00:00 | NQ | Futures | 17078.64 | 17227.6 | 17066.75 | 17225.57 | 77559.0 |
| 2021-10-11 10:00:00 | NQ | Futures | 17225.57 | 17269.91 | 17212.82 | 17231.37 | 57112.0 |
| 2021-10-11 11:00:00 | NQ | Futures | 17231.37 | 17253.97 | 17218.62 | 17229.63 | 34598.0 |
| 2021-10-11 12:00:00 | NQ | Futures | 17229.34 | 17233.11 | 17169.06 | 17197.75 | 43668.0 |
| 2021-10-11 13:00:00 | NQ | Futures | 17198.62 | 17198.62 | 17108.78 | 17136.89 | 53296.0 |
| 2021-10-11 14:00:00 | NQ | Futures | 17136.89 | 17175.72 | 17122.98 | 17152.83 | 44263.0 |
| 2021-10-11 15:00:00 | NQ | Futures | 17152.25 | 17162.39 | 17036.9 | 17040.96 | 61261.0 |
| 2021-10-11 16:00:00 | NQ | Futures | 17040.67 | 17043.86 | 17014.59 | 17023.86 | 14830.0 |
| 2021-10-11 18:00:00 | NQ | Futures | 17027.92 | 17036.32 | 16999.51 | 17004.44 | 4712.0 |
| 2021-10-11 19:00:00 | NQ | Futures | 17005.02 | 17029.08 | 17000.09 | 17023.57 | 3973.0 |
| 2021-10-11 20:00:00 | NQ | Futures | 17023.57 | 17035.16 | 16942.71 | 16958.07 | 10657.0 |
| 2021-10-11 21:00:00 | NQ | Futures | 16958.65 | 16969.08 | 16920.68 | 16962.71 | 9051.0 |
| 2021-10-11 22:00:00 | NQ | Futures | 16963.87 | 16986.18 | 16957.49 | 16978.36 | 4697.0 |
| 2021-10-11 23:00:00 | NQ | Futures | 16978.07 | 16985.31 | 16943.87 | 16948.8 | 4186.0 |
| 2021-10-11 00:00:00 | YM | Futures | 38774.4 | 38819.3 | 38758.7 | 38799.1 | 903.0 |
| 2021-10-11 01:00:00 | YM | Futures | 38803.6 | 38839.4 | 38785.6 | 38831.6 | 1522.0 |
| 2021-10-11 02:00:00 | YM | Futures | 38832.7 | 38858.5 | 38702.7 | 38745.3 | 3897.0 |
| 2021-10-11 03:00:00 | YM | Futures | 38744.2 | 38809.2 | 38688.1 | 38726.2 | 4340.0 |
> showing 50 of 1,973 rows — these rows as CSV