PREVIEW / futures_1hour / 2021-10-01
file: by_date/futures_1hour/2021/2021-10-01.parquet size: 56 KB rows: 1,631
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-01 00:00:00 | ES | Futures | 4823.01 | 4826.96 | 4820.19 | 4825.55 | 8466.0 |
| 2021-10-01 01:00:00 | ES | Futures | 4825.83 | 4832.32 | 4821.03 | 4831.76 | 11865.0 |
| 2021-10-01 02:00:00 | ES | Futures | 4831.48 | 4836.84 | 4808.9 | 4817.37 | 34740.0 |
| 2021-10-01 03:00:00 | ES | Futures | 4817.37 | 4834.58 | 4809.18 | 4826.4 | 59218.0 |
| 2021-10-01 04:00:00 | ES | Futures | 4826.4 | 4830.63 | 4815.39 | 4822.45 | 36287.0 |
| 2021-10-01 05:00:00 | ES | Futures | 4822.16 | 4830.07 | 4822.16 | 4826.4 | 25901.0 |
| 2021-10-01 06:00:00 | ES | Futures | 4826.4 | 4836.27 | 4824.99 | 4834.86 | 31890.0 |
| 2021-10-01 07:00:00 | ES | Futures | 4834.86 | 4874.37 | 4834.58 | 4866.19 | 76234.0 |
| 2021-10-01 08:00:00 | ES | Futures | 4865.91 | 4876.91 | 4859.13 | 4864.5 | 62002.0 |
| 2021-10-01 09:00:00 | ES | Futures | 4864.5 | 4878.04 | 4846.15 | 4852.64 | 262244.0 |
| 2021-10-01 10:00:00 | ES | Futures | 4852.92 | 4863.08 | 4828.09 | 4850.38 | 375573.0 |
| 2021-10-01 11:00:00 | ES | Futures | 4850.1 | 4883.4 | 4839.94 | 4876.07 | 258716.0 |
| 2021-10-01 12:00:00 | ES | Futures | 4876.07 | 4881.43 | 4867.88 | 4875.5 | 120563.0 |
| 2021-10-01 13:00:00 | ES | Futures | 4875.78 | 4903.72 | 4870.7 | 4897.23 | 157156.0 |
| 2021-10-01 14:00:00 | ES | Futures | 4897.23 | 4915.86 | 4897.23 | 4913.6 | 134468.0 |
| 2021-10-01 15:00:00 | ES | Futures | 4913.6 | 4928.28 | 4899.49 | 4907.11 | 343934.0 |
| 2021-10-01 16:00:00 | ES | Futures | 4906.83 | 4913.6 | 4905.7 | 4911.34 | 77951.0 |
| 2021-10-01 00:00:00 | NQ | Futures | 16927.64 | 16936.62 | 16907.93 | 16928.8 | 4108.0 |
| 2021-10-01 01:00:00 | NQ | Futures | 16929.38 | 16950.83 | 16909.38 | 16948.22 | 5556.0 |
| 2021-10-01 02:00:00 | NQ | Futures | 16947.93 | 16969.66 | 16869.97 | 16904.45 | 15120.0 |
| 2021-10-01 03:00:00 | NQ | Futures | 16904.17 | 16977.2 | 16874.6 | 16951.12 | 19515.0 |
| 2021-10-01 04:00:00 | NQ | Futures | 16951.7 | 16965.61 | 16901.56 | 16919.24 | 16750.0 |
| 2021-10-01 05:00:00 | NQ | Futures | 16919.24 | 16955.46 | 16919.24 | 16945.9 | 6429.0 |
| 2021-10-01 06:00:00 | NQ | Futures | 16944.45 | 16976.62 | 16939.81 | 16971.98 | 6421.0 |
| 2021-10-01 07:00:00 | NQ | Futures | 16972.56 | 17082.98 | 16972.27 | 17059.8 | 21305.0 |
| 2021-10-01 08:00:00 | NQ | Futures | 17060.38 | 17091.39 | 17017.19 | 17045.02 | 21160.0 |
| 2021-10-01 09:00:00 | NQ | Futures | 17044.44 | 17082.4 | 16933.15 | 16959.81 | 93270.0 |
| 2021-10-01 10:00:00 | NQ | Futures | 16959.81 | 16976.91 | 16852.29 | 16949.67 | 110375.0 |
| 2021-10-01 11:00:00 | NQ | Futures | 16949.38 | 17050.23 | 16906.48 | 17029.37 | 74722.0 |
| 2021-10-01 12:00:00 | NQ | Futures | 17029.37 | 17039.51 | 16978.36 | 16998.65 | 47552.0 |
| 2021-10-01 13:00:00 | NQ | Futures | 16998.65 | 17089.65 | 16980.39 | 17061.83 | 43645.0 |
| 2021-10-01 14:00:00 | NQ | Futures | 17062.12 | 17145.87 | 17059.8 | 17134.86 | 38448.0 |
| 2021-10-01 15:00:00 | NQ | Futures | 17134.86 | 17178.04 | 17103.56 | 17122.98 | 69138.0 |
| 2021-10-01 16:00:00 | NQ | Futures | 17122.98 | 17142.39 | 17113.41 | 17130.8 | 13362.0 |
| 2021-10-01 00:00:00 | YM | Futures | 37566.1 | 37593.0 | 37548.2 | 37581.8 | 1163.0 |
| 2021-10-01 01:00:00 | YM | Futures | 37587.4 | 37635.6 | 37553.8 | 37627.7 | 1658.0 |
| 2021-10-01 02:00:00 | YM | Futures | 37626.6 | 37673.7 | 37438.3 | 37501.1 | 6020.0 |
| 2021-10-01 03:00:00 | YM | Futures | 37500.0 | 37623.3 | 37419.3 | 37556.0 | 9837.0 |
| 2021-10-01 04:00:00 | YM | Futures | 37559.4 | 37591.9 | 37474.2 | 37551.5 | 5470.0 |
| 2021-10-01 05:00:00 | YM | Futures | 37553.8 | 37604.2 | 37535.8 | 37568.3 | 2955.0 |
| 2021-10-01 06:00:00 | YM | Futures | 37568.3 | 37651.3 | 37563.8 | 37644.6 | 3172.0 |
| 2021-10-01 07:00:00 | YM | Futures | 37647.9 | 38013.3 | 37642.3 | 37934.9 | 13051.0 |
| 2021-10-01 08:00:00 | YM | Futures | 37936.0 | 38026.8 | 37884.4 | 37912.5 | 9012.0 |
| 2021-10-01 09:00:00 | YM | Futures | 37912.5 | 38091.8 | 37875.5 | 37938.2 | 29616.0 |
| 2021-10-01 10:00:00 | YM | Futures | 37937.1 | 38041.4 | 37710.7 | 37883.3 | 33724.0 |
| 2021-10-01 11:00:00 | YM | Futures | 37883.3 | 38120.9 | 37807.1 | 38055.9 | 20956.0 |
| 2021-10-01 12:00:00 | YM | Futures | 38057.0 | 38137.8 | 38025.7 | 38089.6 | 10485.0 |
| 2021-10-01 13:00:00 | YM | Futures | 38089.6 | 38328.3 | 38059.3 | 38274.5 | 13474.0 |
| 2021-10-01 14:00:00 | YM | Futures | 38275.6 | 38393.3 | 38272.3 | 38384.4 | 11578.0 |
| 2021-10-01 15:00:00 | YM | Futures | 38385.5 | 38507.7 | 38276.7 | 38327.2 | 22972.0 |
> showing 50 of 1,631 rows — these rows as CSV