PREVIEW / futures_1hour / 2021-11-30
file: by_date/futures_1hour/2021/2021-11-30.parquet size: 70 KB rows: 2,065
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-11-30 00:00:00 | ES | Futures | 5256.49 | 5257.05 | 5200.05 | 5202.59 | 48716.0 |
| 2021-11-30 01:00:00 | ES | Futures | 5202.59 | 5211.33 | 5172.39 | 5206.25 | 40223.0 |
| 2021-11-30 02:00:00 | ES | Futures | 5206.25 | 5215.57 | 5196.38 | 5205.97 | 31275.0 |
| 2021-11-30 03:00:00 | ES | Futures | 5205.97 | 5206.54 | 5187.35 | 5197.22 | 43153.0 |
| 2021-11-30 04:00:00 | ES | Futures | 5196.94 | 5197.79 | 5179.73 | 5197.51 | 37283.0 |
| 2021-11-30 05:00:00 | ES | Futures | 5197.22 | 5201.17 | 5187.06 | 5198.92 | 26112.0 |
| 2021-11-30 06:00:00 | ES | Futures | 5198.92 | 5203.71 | 5189.89 | 5197.51 | 31061.0 |
| 2021-11-30 07:00:00 | ES | Futures | 5197.22 | 5214.72 | 5196.09 | 5204.84 | 44789.0 |
| 2021-11-30 08:00:00 | ES | Futures | 5204.84 | 5222.06 | 5196.94 | 5220.93 | 58448.0 |
| 2021-11-30 09:00:00 | ES | Futures | 5220.93 | 5230.81 | 5209.08 | 5224.32 | 268414.0 |
| 2021-11-30 10:00:00 | ES | Futures | 5224.32 | 5242.66 | 5174.08 | 5174.36 | 445787.0 |
| 2021-11-30 11:00:00 | ES | Futures | 5174.36 | 5195.53 | 5154.05 | 5166.46 | 413840.0 |
| 2021-11-30 12:00:00 | ES | Futures | 5166.18 | 5174.93 | 5149.81 | 5164.49 | 245301.0 |
| 2021-11-30 13:00:00 | ES | Futures | 5164.2 | 5184.81 | 5156.02 | 5184.24 | 174420.0 |
| 2021-11-30 14:00:00 | ES | Futures | 5184.24 | 5189.32 | 5162.23 | 5167.03 | 178863.0 |
| 2021-11-30 15:00:00 | ES | Futures | 5167.03 | 5170.7 | 5144.17 | 5150.66 | 455022.0 |
| 2021-11-30 16:00:00 | ES | Futures | 5150.66 | 5176.62 | 5150.38 | 5176.34 | 122980.0 |
| 2021-11-30 18:00:00 | ES | Futures | 5178.6 | 5187.06 | 5170.13 | 5175.21 | 19142.0 |
| 2021-11-30 19:00:00 | ES | Futures | 5175.21 | 5183.68 | 5160.54 | 5167.59 | 23268.0 |
| 2021-11-30 20:00:00 | ES | Futures | 5167.59 | 5185.94 | 5162.51 | 5183.4 | 19114.0 |
| 2021-11-30 21:00:00 | ES | Futures | 5183.68 | 5192.71 | 5182.55 | 5192.43 | 17628.0 |
| 2021-11-30 22:00:00 | ES | Futures | 5192.71 | 5192.71 | 5183.11 | 5188.47 | 12852.0 |
| 2021-11-30 23:00:00 | ES | Futures | 5188.76 | 5201.46 | 5188.76 | 5200.33 | 15338.0 |
| 2021-11-30 00:00:00 | NQ | Futures | 19015.48 | 19018.38 | 18878.69 | 18903.9 | 18449.0 |
| 2021-11-30 01:00:00 | NQ | Futures | 18904.19 | 18948.25 | 18824.78 | 18934.62 | 19126.0 |
| 2021-11-30 02:00:00 | NQ | Futures | 18934.33 | 18945.64 | 18889.41 | 18925.35 | 14181.0 |
| 2021-11-30 03:00:00 | NQ | Futures | 18926.22 | 18944.48 | 18889.99 | 18927.09 | 14206.0 |
| 2021-11-30 04:00:00 | NQ | Futures | 18927.67 | 18928.54 | 18855.79 | 18920.13 | 14412.0 |
| 2021-11-30 05:00:00 | NQ | Futures | 18919.84 | 18923.61 | 18882.75 | 18911.15 | 7201.0 |
| 2021-11-30 06:00:00 | NQ | Futures | 18912.6 | 18922.45 | 18873.18 | 18884.2 | 9658.0 |
| 2021-11-30 07:00:00 | NQ | Futures | 18883.33 | 18936.94 | 18882.46 | 18913.76 | 11288.0 |
| 2021-11-30 08:00:00 | NQ | Futures | 18912.89 | 18964.19 | 18883.33 | 18963.03 | 14723.0 |
| 2021-11-30 09:00:00 | NQ | Futures | 18962.74 | 19033.16 | 18918.1 | 19018.96 | 91836.0 |
| 2021-11-30 10:00:00 | NQ | Futures | 19020.41 | 19077.21 | 18712.91 | 18716.68 | 156018.0 |
| 2021-11-30 11:00:00 | NQ | Futures | 18715.81 | 18803.34 | 18639.59 | 18691.47 | 133913.0 |
| 2021-11-30 12:00:00 | NQ | Futures | 18690.6 | 18732.33 | 18628.0 | 18690.02 | 84910.0 |
| 2021-11-30 13:00:00 | NQ | Futures | 18689.73 | 18794.35 | 18665.67 | 18790.87 | 52364.0 |
| 2021-11-30 14:00:00 | NQ | Futures | 18790.3 | 18808.55 | 18699.87 | 18723.35 | 57295.0 |
| 2021-11-30 15:00:00 | NQ | Futures | 18723.06 | 18745.66 | 18676.11 | 18720.74 | 91979.0 |
| 2021-11-30 16:00:00 | NQ | Futures | 18721.03 | 18826.23 | 18721.03 | 18824.49 | 26584.0 |
| 2021-11-30 18:00:00 | NQ | Futures | 18825.07 | 18855.79 | 18798.41 | 18807.68 | 7398.0 |
| 2021-11-30 19:00:00 | NQ | Futures | 18807.68 | 18842.46 | 18759.86 | 18778.12 | 10113.0 |
| 2021-11-30 20:00:00 | NQ | Futures | 18778.12 | 18865.65 | 18762.47 | 18856.95 | 8790.0 |
| 2021-11-30 21:00:00 | NQ | Futures | 18857.53 | 18912.89 | 18853.77 | 18912.02 | 9281.0 |
| 2021-11-30 22:00:00 | NQ | Futures | 18912.89 | 18920.71 | 18885.36 | 18914.05 | 6067.0 |
| 2021-11-30 23:00:00 | NQ | Futures | 18914.34 | 18987.37 | 18914.34 | 18978.97 | 9170.0 |
| 2021-11-30 00:00:00 | YM | Futures | 39383.1 | 39383.1 | 38873.1 | 38875.3 | 11501.0 |
| 2021-11-30 01:00:00 | YM | Futures | 38879.8 | 38925.8 | 38615.3 | 38864.1 | 9160.0 |
| 2021-11-30 02:00:00 | YM | Futures | 38869.7 | 38987.4 | 38795.7 | 38897.7 | 8422.0 |
| 2021-11-30 03:00:00 | YM | Futures | 38897.7 | 38911.2 | 38688.1 | 38766.6 | 14318.0 |
> showing 50 of 2,065 rows — these rows as CSV