PREVIEW / futures_1hour / 2022-02-01
file: by_date/futures_1hour/2022/2022-02-01.parquet size: 68 KB rows: 2,058
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-02-01 00:00:00 | ES | Futures | 5081.39 | 5085.35 | 5079.13 | 5084.22 | 3546.0 |
| 2022-02-01 01:00:00 | ES | Futures | 5083.93 | 5088.18 | 5079.13 | 5084.78 | 4636.0 |
| 2022-02-01 02:00:00 | ES | Futures | 5084.5 | 5096.94 | 5082.24 | 5090.15 | 14269.0 |
| 2022-02-01 03:00:00 | ES | Futures | 5090.15 | 5106.84 | 5086.2 | 5100.62 | 26847.0 |
| 2022-02-01 04:00:00 | ES | Futures | 5100.9 | 5102.03 | 5070.08 | 5080.82 | 26681.0 |
| 2022-02-01 05:00:00 | ES | Futures | 5081.11 | 5089.31 | 5076.58 | 5079.69 | 16524.0 |
| 2022-02-01 06:00:00 | ES | Futures | 5079.97 | 5092.42 | 5077.99 | 5081.11 | 16863.0 |
| 2022-02-01 07:00:00 | ES | Futures | 5080.82 | 5093.83 | 5079.41 | 5090.15 | 17493.0 |
| 2022-02-01 08:00:00 | ES | Futures | 5090.15 | 5101.75 | 5088.74 | 5101.47 | 39668.0 |
| 2022-02-01 09:00:00 | ES | Futures | 5101.18 | 5106.84 | 5079.97 | 5092.98 | 239529.0 |
| 2022-02-01 10:00:00 | ES | Futures | 5092.98 | 5096.09 | 5061.03 | 5095.81 | 276292.0 |
| 2022-02-01 11:00:00 | ES | Futures | 5096.09 | 5107.41 | 5084.22 | 5103.45 | 161083.0 |
| 2022-02-01 12:00:00 | ES | Futures | 5103.73 | 5105.99 | 5084.22 | 5100.62 | 102048.0 |
| 2022-02-01 13:00:00 | ES | Futures | 5100.62 | 5103.45 | 5090.44 | 5100.62 | 80353.0 |
| 2022-02-01 14:00:00 | ES | Futures | 5100.34 | 5105.43 | 5090.44 | 5100.62 | 95894.0 |
| 2022-02-01 15:00:00 | ES | Futures | 5100.62 | 5136.82 | 5098.64 | 5128.9 | 281245.0 |
| 2022-02-01 16:00:00 | ES | Futures | 5129.18 | 5152.37 | 5128.05 | 5146.43 | 76988.0 |
| 2022-02-01 18:00:00 | ES | Futures | 5149.26 | 5149.54 | 5143.6 | 5148.41 | 9214.0 |
| 2022-02-01 19:00:00 | ES | Futures | 5148.13 | 5154.35 | 5147.56 | 5153.79 | 8581.0 |
| 2022-02-01 20:00:00 | ES | Futures | 5153.5 | 5156.05 | 5150.67 | 5153.79 | 4875.0 |
| 2022-02-01 21:00:00 | ES | Futures | 5153.5 | 5154.92 | 5150.67 | 5151.81 | 3437.0 |
| 2022-02-01 22:00:00 | ES | Futures | 5151.81 | 5154.07 | 5150.96 | 5153.5 | 1921.0 |
| 2022-02-01 23:00:00 | ES | Futures | 5153.22 | 5155.77 | 5153.22 | 5155.48 | 2007.0 |
| 2022-02-01 00:00:00 | NQ | Futures | 17238.03 | 17254.26 | 17227.89 | 17249.34 | 2662.0 |
| 2022-02-01 01:00:00 | NQ | Futures | 17248.47 | 17268.76 | 17228.18 | 17256.29 | 3332.0 |
| 2022-02-01 02:00:00 | NQ | Futures | 17255.13 | 17333.38 | 17245.57 | 17277.16 | 10282.0 |
| 2022-02-01 03:00:00 | NQ | Futures | 17277.16 | 17348.45 | 17250.79 | 17332.8 | 14346.0 |
| 2022-02-01 04:00:00 | NQ | Futures | 17333.96 | 17343.53 | 17211.37 | 17253.1 | 12664.0 |
| 2022-02-01 05:00:00 | NQ | Futures | 17254.26 | 17294.26 | 17233.11 | 17244.7 | 8017.0 |
| 2022-02-01 06:00:00 | NQ | Futures | 17245.28 | 17283.54 | 17226.73 | 17240.64 | 8529.0 |
| 2022-02-01 07:00:00 | NQ | Futures | 17240.06 | 17318.31 | 17236.3 | 17302.95 | 9759.0 |
| 2022-02-01 08:00:00 | NQ | Futures | 17304.4 | 17342.66 | 17296.58 | 17330.78 | 14046.0 |
| 2022-02-01 09:00:00 | NQ | Futures | 17330.78 | 17342.66 | 17141.53 | 17205.57 | 90951.0 |
| 2022-02-01 10:00:00 | NQ | Futures | 17205.57 | 17232.24 | 17075.16 | 17224.99 | 105776.0 |
| 2022-02-01 11:00:00 | NQ | Futures | 17224.41 | 17322.37 | 17205.86 | 17300.35 | 63854.0 |
| 2022-02-01 12:00:00 | NQ | Futures | 17301.21 | 17307.88 | 17204.13 | 17278.61 | 43497.0 |
| 2022-02-01 13:00:00 | NQ | Futures | 17276.58 | 17281.22 | 17213.98 | 17247.31 | 31326.0 |
| 2022-02-01 14:00:00 | NQ | Futures | 17247.6 | 17273.97 | 17182.1 | 17233.98 | 38188.0 |
| 2022-02-01 15:00:00 | NQ | Futures | 17234.85 | 17411.63 | 17223.83 | 17378.02 | 72069.0 |
| 2022-02-01 16:00:00 | NQ | Futures | 17379.18 | 17547.85 | 17367.87 | 17524.37 | 30264.0 |
| 2022-02-01 18:00:00 | NQ | Futures | 17538.57 | 17543.21 | 17509.88 | 17529.3 | 6001.0 |
| 2022-02-01 19:00:00 | NQ | Futures | 17529.3 | 17549.01 | 17525.24 | 17546.98 | 5195.0 |
| 2022-02-01 20:00:00 | NQ | Futures | 17546.4 | 17561.76 | 17535.1 | 17550.17 | 4187.0 |
| 2022-02-01 21:00:00 | NQ | Futures | 17549.59 | 17557.7 | 17539.73 | 17546.69 | 2136.0 |
| 2022-02-01 22:00:00 | NQ | Futures | 17546.11 | 17559.15 | 17542.34 | 17554.51 | 1694.0 |
| 2022-02-01 23:00:00 | NQ | Futures | 17553.36 | 17561.18 | 17551.04 | 17557.41 | 1251.0 |
| 2022-02-01 00:00:00 | YM | Futures | 39257.7 | 39284.7 | 39240.9 | 39277.9 | 647.0 |
| 2022-02-01 01:00:00 | YM | Futures | 39274.6 | 39298.2 | 39229.6 | 39264.5 | 1114.0 |
| 2022-02-01 02:00:00 | YM | Futures | 39265.6 | 39346.5 | 39249.8 | 39308.3 | 4510.0 |
| 2022-02-01 03:00:00 | YM | Futures | 39307.2 | 39444.3 | 39291.4 | 39389.2 | 8348.0 |
> showing 50 of 2,058 rows — these rows as CSV