PREVIEW / futures_1hour / 2022-07-28
file: by_date/futures_1hour/2022/2022-07-28.parquet size: 69 KB rows: 2,051
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-07-28 00:00:00 | ES | Futures | 4549.62 | 4551.32 | 4547.92 | 4550.19 | 3955.0 |
| 2022-07-28 01:00:00 | ES | Futures | 4550.19 | 4552.46 | 4547.64 | 4552.17 | 4534.0 |
| 2022-07-28 02:00:00 | ES | Futures | 4552.17 | 4557.56 | 4551.61 | 4552.74 | 11880.0 |
| 2022-07-28 03:00:00 | ES | Futures | 4552.74 | 4557.56 | 4547.64 | 4549.62 | 23484.0 |
| 2022-07-28 04:00:00 | ES | Futures | 4549.34 | 4551.61 | 4541.41 | 4542.54 | 26668.0 |
| 2022-07-28 05:00:00 | ES | Futures | 4542.54 | 4546.51 | 4536.88 | 4546.51 | 14751.0 |
| 2022-07-28 06:00:00 | ES | Futures | 4546.51 | 4549.91 | 4543.67 | 4547.36 | 10957.0 |
| 2022-07-28 07:00:00 | ES | Futures | 4547.64 | 4551.89 | 4547.07 | 4548.21 | 14473.0 |
| 2022-07-28 08:00:00 | ES | Futures | 4548.49 | 4566.34 | 4536.31 | 4556.42 | 72397.0 |
| 2022-07-28 09:00:00 | ES | Futures | 4556.14 | 4578.8 | 4528.09 | 4540.28 | 282413.0 |
| 2022-07-28 10:00:00 | ES | Futures | 4540.56 | 4565.2 | 4526.11 | 4564.64 | 322884.0 |
| 2022-07-28 11:00:00 | ES | Futures | 4564.64 | 4598.06 | 4562.94 | 4588.71 | 299400.0 |
| 2022-07-28 12:00:00 | ES | Futures | 4588.71 | 4597.78 | 4584.75 | 4593.25 | 164418.0 |
| 2022-07-28 13:00:00 | ES | Futures | 4593.53 | 4620.16 | 4588.15 | 4617.04 | 160518.0 |
| 2022-07-28 14:00:00 | ES | Futures | 4617.33 | 4619.31 | 4608.54 | 4617.61 | 132488.0 |
| 2022-07-28 15:00:00 | ES | Futures | 4617.61 | 4624.41 | 4609.68 | 4615.34 | 271653.0 |
| 2022-07-28 16:00:00 | ES | Futures | 4615.06 | 4658.12 | 4613.93 | 4651.32 | 104818.0 |
| 2022-07-28 18:00:00 | ES | Futures | 4651.32 | 4651.32 | 4636.87 | 4639.14 | 9981.0 |
| 2022-07-28 19:00:00 | ES | Futures | 4639.42 | 4642.54 | 4635.74 | 4640.84 | 5736.0 |
| 2022-07-28 20:00:00 | ES | Futures | 4640.84 | 4642.25 | 4636.02 | 4637.72 | 8937.0 |
| 2022-07-28 21:00:00 | ES | Futures | 4637.44 | 4646.5 | 4636.3 | 4646.22 | 8268.0 |
| 2022-07-28 22:00:00 | ES | Futures | 4646.22 | 4649.62 | 4644.8 | 4646.22 | 6503.0 |
| 2022-07-28 23:00:00 | ES | Futures | 4645.94 | 4647.07 | 4640.27 | 4640.55 | 6002.0 |
| 2022-07-28 00:00:00 | NQ | Futures | 14532.82 | 14542.07 | 14527.61 | 14540.05 | 1795.0 |
| 2022-07-28 01:00:00 | NQ | Futures | 14540.05 | 14542.65 | 14527.9 | 14541.49 | 1939.0 |
| 2022-07-28 02:00:00 | NQ | Futures | 14542.36 | 14557.69 | 14529.92 | 14532.82 | 4588.0 |
| 2022-07-28 03:00:00 | NQ | Futures | 14533.68 | 14548.72 | 14494.35 | 14507.65 | 11461.0 |
| 2022-07-28 04:00:00 | NQ | Futures | 14506.78 | 14514.59 | 14457.04 | 14465.42 | 11913.0 |
| 2022-07-28 05:00:00 | NQ | Futures | 14465.42 | 14495.21 | 14439.1 | 14494.06 | 9078.0 |
| 2022-07-28 06:00:00 | NQ | Futures | 14494.35 | 14513.15 | 14485.09 | 14510.54 | 6674.0 |
| 2022-07-28 07:00:00 | NQ | Futures | 14510.83 | 14525.3 | 14499.26 | 14507.36 | 6186.0 |
| 2022-07-28 08:00:00 | NQ | Futures | 14507.65 | 14608.02 | 14457.61 | 14554.22 | 35989.0 |
| 2022-07-28 09:00:00 | NQ | Futures | 14553.93 | 14640.12 | 14408.44 | 14450.38 | 100104.0 |
| 2022-07-28 10:00:00 | NQ | Futures | 14450.38 | 14551.62 | 14402.95 | 14550.17 | 96908.0 |
| 2022-07-28 11:00:00 | NQ | Futures | 14550.17 | 14687.85 | 14545.83 | 14651.69 | 89832.0 |
| 2022-07-28 12:00:00 | NQ | Futures | 14651.98 | 14669.63 | 14617.56 | 14627.98 | 43820.0 |
| 2022-07-28 13:00:00 | NQ | Futures | 14628.55 | 14737.89 | 14605.41 | 14727.18 | 51569.0 |
| 2022-07-28 14:00:00 | NQ | Futures | 14727.18 | 14741.94 | 14683.8 | 14735.57 | 39892.0 |
| 2022-07-28 15:00:00 | NQ | Futures | 14736.44 | 14767.97 | 14705.49 | 14738.18 | 59586.0 |
| 2022-07-28 16:00:00 | NQ | Futures | 14737.6 | 14980.27 | 14730.37 | 14952.79 | 49506.0 |
| 2022-07-28 18:00:00 | NQ | Futures | 14948.16 | 14948.16 | 14892.92 | 14901.6 | 5784.0 |
| 2022-07-28 19:00:00 | NQ | Futures | 14901.88 | 14918.08 | 14890.89 | 14916.64 | 3358.0 |
| 2022-07-28 20:00:00 | NQ | Futures | 14916.06 | 14917.21 | 14901.02 | 14907.09 | 3095.0 |
| 2022-07-28 21:00:00 | NQ | Futures | 14905.93 | 14935.15 | 14902.17 | 14933.99 | 4351.0 |
| 2022-07-28 22:00:00 | NQ | Futures | 14933.7 | 14951.92 | 14928.49 | 14936.59 | 4286.0 |
| 2022-07-28 23:00:00 | NQ | Futures | 14936.3 | 14939.49 | 14911.14 | 14913.17 | 3253.0 |
| 2022-07-28 00:00:00 | YM | Futures | 36243.5 | 36253.7 | 36230.0 | 36245.8 | 831.0 |
| 2022-07-28 01:00:00 | YM | Futures | 36245.8 | 36261.6 | 36227.7 | 36260.4 | 926.0 |
| 2022-07-28 02:00:00 | YM | Futures | 36258.2 | 36303.3 | 36255.9 | 36277.4 | 3043.0 |
| 2022-07-28 03:00:00 | YM | Futures | 36278.5 | 36325.9 | 36251.4 | 36284.1 | 4830.0 |
> showing 50 of 2,051 rows — these rows as CSV