PREVIEW / futures_1hour / 2021-10-07
file: by_date/futures_1hour/2021/2021-10-07.parquet size: 66 KB rows: 1,988
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-07 00:00:00 | ES | Futures | 4940.13 | 4941.54 | 4934.2 | 4936.18 | 6452.0 |
| 2021-10-07 01:00:00 | ES | Futures | 4936.18 | 4940.13 | 4932.51 | 4936.46 | 9253.0 |
| 2021-10-07 02:00:00 | ES | Futures | 4936.18 | 4950.01 | 4935.33 | 4943.51 | 20095.0 |
| 2021-10-07 03:00:00 | ES | Futures | 4943.51 | 4946.05 | 4935.61 | 4944.93 | 24814.0 |
| 2021-10-07 04:00:00 | ES | Futures | 4944.64 | 4948.88 | 4937.02 | 4944.93 | 20384.0 |
| 2021-10-07 05:00:00 | ES | Futures | 4944.93 | 4946.62 | 4941.26 | 4946.62 | 12148.0 |
| 2021-10-07 06:00:00 | ES | Futures | 4946.62 | 4956.21 | 4945.49 | 4955.37 | 20274.0 |
| 2021-10-07 07:00:00 | ES | Futures | 4955.37 | 4964.4 | 4954.8 | 4960.73 | 32330.0 |
| 2021-10-07 08:00:00 | ES | Futures | 4960.73 | 4965.24 | 4957.34 | 4960.73 | 34696.0 |
| 2021-10-07 09:00:00 | ES | Futures | 4960.45 | 4979.92 | 4950.57 | 4979.64 | 231457.0 |
| 2021-10-07 10:00:00 | ES | Futures | 4979.64 | 4991.21 | 4977.94 | 4987.54 | 217638.0 |
| 2021-10-07 11:00:00 | ES | Futures | 4987.82 | 4988.39 | 4977.66 | 4988.1 | 108806.0 |
| 2021-10-07 12:00:00 | ES | Futures | 4988.1 | 4990.08 | 4980.2 | 4985.28 | 82848.0 |
| 2021-10-07 13:00:00 | ES | Futures | 4985.56 | 4986.13 | 4977.66 | 4978.79 | 69781.0 |
| 2021-10-07 14:00:00 | ES | Futures | 4978.51 | 4979.36 | 4961.01 | 4962.42 | 118737.0 |
| 2021-10-07 15:00:00 | ES | Futures | 4962.42 | 4972.58 | 4951.7 | 4956.78 | 233000.0 |
| 2021-10-07 16:00:00 | ES | Futures | 4957.06 | 4961.58 | 4954.24 | 4955.93 | 61126.0 |
| 2021-10-07 18:00:00 | ES | Futures | 4956.21 | 4962.99 | 4955.65 | 4962.42 | 6323.0 |
| 2021-10-07 19:00:00 | ES | Futures | 4962.71 | 4968.35 | 4960.45 | 4967.22 | 7766.0 |
| 2021-10-07 20:00:00 | ES | Futures | 4967.22 | 4967.22 | 4952.55 | 4965.24 | 19880.0 |
| 2021-10-07 21:00:00 | ES | Futures | 4965.24 | 4970.61 | 4962.71 | 4965.53 | 12401.0 |
| 2021-10-07 22:00:00 | ES | Futures | 4965.24 | 4968.07 | 4962.99 | 4965.81 | 6073.0 |
| 2021-10-07 23:00:00 | ES | Futures | 4966.09 | 4966.66 | 4956.78 | 4958.47 | 7407.0 |
| 2021-10-07 00:00:00 | NQ | Futures | 17231.37 | 17236.88 | 17200.36 | 17208.47 | 3268.0 |
| 2021-10-07 01:00:00 | NQ | Futures | 17208.18 | 17228.47 | 17194.56 | 17217.46 | 4507.0 |
| 2021-10-07 02:00:00 | NQ | Futures | 17216.3 | 17278.9 | 17214.56 | 17258.61 | 11328.0 |
| 2021-10-07 03:00:00 | NQ | Futures | 17259.19 | 17271.07 | 17232.82 | 17268.18 | 11372.0 |
| 2021-10-07 04:00:00 | NQ | Futures | 17267.89 | 17285.27 | 17248.76 | 17272.52 | 8933.0 |
| 2021-10-07 05:00:00 | NQ | Futures | 17271.65 | 17277.74 | 17251.66 | 17260.93 | 5242.0 |
| 2021-10-07 06:00:00 | NQ | Futures | 17261.51 | 17289.91 | 17253.97 | 17286.43 | 6337.0 |
| 2021-10-07 07:00:00 | NQ | Futures | 17287.01 | 17332.23 | 17283.25 | 17318.89 | 16149.0 |
| 2021-10-07 08:00:00 | NQ | Futures | 17318.6 | 17322.95 | 17285.56 | 17288.75 | 12915.0 |
| 2021-10-07 09:00:00 | NQ | Futures | 17288.17 | 17338.02 | 17225.86 | 17336.86 | 89279.0 |
| 2021-10-07 10:00:00 | NQ | Futures | 17337.15 | 17386.42 | 17326.72 | 17367.58 | 68139.0 |
| 2021-10-07 11:00:00 | NQ | Futures | 17367.87 | 17388.74 | 17335.12 | 17387.29 | 41550.0 |
| 2021-10-07 12:00:00 | NQ | Futures | 17387.58 | 17390.48 | 17350.77 | 17373.09 | 31244.0 |
| 2021-10-07 13:00:00 | NQ | Futures | 17373.09 | 17373.38 | 17340.34 | 17345.56 | 21374.0 |
| 2021-10-07 14:00:00 | NQ | Futures | 17345.56 | 17351.35 | 17287.88 | 17304.11 | 40256.0 |
| 2021-10-07 15:00:00 | NQ | Futures | 17304.69 | 17330.2 | 17236.59 | 17257.45 | 69937.0 |
| 2021-10-07 16:00:00 | NQ | Futures | 17257.16 | 17275.13 | 17251.37 | 17262.96 | 11694.0 |
| 2021-10-07 18:00:00 | NQ | Futures | 17262.96 | 17278.61 | 17258.03 | 17274.26 | 2774.0 |
| 2021-10-07 19:00:00 | NQ | Futures | 17274.55 | 17303.24 | 17267.89 | 17301.5 | 3852.0 |
| 2021-10-07 20:00:00 | NQ | Futures | 17301.21 | 17301.21 | 17244.99 | 17295.13 | 8048.0 |
| 2021-10-07 21:00:00 | NQ | Futures | 17295.42 | 17314.26 | 17280.64 | 17293.97 | 6119.0 |
| 2021-10-07 22:00:00 | NQ | Futures | 17294.26 | 17302.66 | 17279.48 | 17293.39 | 3552.0 |
| 2021-10-07 23:00:00 | NQ | Futures | 17292.81 | 17295.42 | 17251.95 | 17257.74 | 3854.0 |
| 2021-10-07 00:00:00 | YM | Futures | 38592.8 | 38606.3 | 38553.6 | 38564.8 | 993.0 |
| 2021-10-07 01:00:00 | YM | Futures | 38564.8 | 38596.2 | 38535.7 | 38576.0 | 1730.0 |
| 2021-10-07 02:00:00 | YM | Futures | 38573.8 | 38676.9 | 38567.1 | 38605.2 | 3882.0 |
| 2021-10-07 03:00:00 | YM | Futures | 38605.2 | 38629.8 | 38548.0 | 38613.0 | 4430.0 |
> showing 50 of 1,988 rows — these rows as CSV