PREVIEW / futures_1hour / 2022-02-07
file: by_date/futures_1hour/2022/2022-02-07.parquet size: 67 KB rows: 2,059
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-07 00:00:00 | ES | Futures | 5084.22 | 5086.2 | 5077.99 | 5083.37 | 8170.0 |
| 2022-02-07 01:00:00 | ES | Futures | 5083.08 | 5086.76 | 5074.88 | 5085.63 | 5702.0 |
| 2022-02-07 02:00:00 | ES | Futures | 5085.63 | 5095.25 | 5081.11 | 5088.74 | 9925.0 |
| 2022-02-07 03:00:00 | ES | Futures | 5088.74 | 5091.57 | 5059.33 | 5074.04 | 25284.0 |
| 2022-02-07 04:00:00 | ES | Futures | 5074.6 | 5082.24 | 5059.9 | 5069.23 | 17623.0 |
| 2022-02-07 05:00:00 | ES | Futures | 5069.23 | 5076.58 | 5066.4 | 5067.53 | 11281.0 |
| 2022-02-07 06:00:00 | ES | Futures | 5067.53 | 5079.97 | 5063.57 | 5075.17 | 16561.0 |
| 2022-02-07 07:00:00 | ES | Futures | 5075.73 | 5092.98 | 5075.73 | 5089.02 | 15562.0 |
| 2022-02-07 08:00:00 | ES | Futures | 5089.31 | 5099.2 | 5087.04 | 5092.98 | 27012.0 |
| 2022-02-07 09:00:00 | ES | Futures | 5092.7 | 5099.77 | 5074.6 | 5094.11 | 185362.0 |
| 2022-02-07 10:00:00 | ES | Futures | 5094.4 | 5105.14 | 5077.99 | 5092.7 | 199620.0 |
| 2022-02-07 11:00:00 | ES | Futures | 5092.7 | 5096.09 | 5062.44 | 5074.6 | 175066.0 |
| 2022-02-07 12:00:00 | ES | Futures | 5074.6 | 5075.45 | 5058.48 | 5068.38 | 117600.0 |
| 2022-02-07 13:00:00 | ES | Futures | 5068.38 | 5091.0 | 5066.4 | 5089.02 | 98944.0 |
| 2022-02-07 14:00:00 | ES | Futures | 5089.02 | 5100.9 | 5082.24 | 5094.68 | 96550.0 |
| 2022-02-07 15:00:00 | ES | Futures | 5094.68 | 5106.84 | 5048.3 | 5064.14 | 290463.0 |
| 2022-02-07 16:00:00 | ES | Futures | 5063.85 | 5073.75 | 5063.29 | 5071.77 | 51865.0 |
| 2022-02-07 18:00:00 | ES | Futures | 5072.34 | 5076.01 | 5069.23 | 5075.17 | 6227.0 |
| 2022-02-07 19:00:00 | ES | Futures | 5075.17 | 5077.71 | 5068.66 | 5073.75 | 7028.0 |
| 2022-02-07 20:00:00 | ES | Futures | 5073.75 | 5073.75 | 5063.01 | 5064.99 | 9600.0 |
| 2022-02-07 21:00:00 | ES | Futures | 5064.99 | 5068.94 | 5058.76 | 5068.38 | 7213.0 |
| 2022-02-07 22:00:00 | ES | Futures | 5068.38 | 5070.64 | 5064.14 | 5065.83 | 4047.0 |
| 2022-02-07 23:00:00 | ES | Futures | 5065.83 | 5067.53 | 5064.14 | 5066.97 | 3050.0 |
| 2022-02-07 00:00:00 | NQ | Futures | 17039.51 | 17058.06 | 17020.09 | 17042.99 | 5112.0 |
| 2022-02-07 01:00:00 | NQ | Futures | 17042.99 | 17060.09 | 17009.08 | 17053.42 | 4661.0 |
| 2022-02-07 02:00:00 | NQ | Futures | 17056.03 | 17092.26 | 17042.41 | 17070.52 | 6079.0 |
| 2022-02-07 03:00:00 | NQ | Futures | 17072.84 | 17076.32 | 16944.74 | 16997.49 | 14340.0 |
| 2022-02-07 04:00:00 | NQ | Futures | 16999.23 | 17027.34 | 16953.14 | 16987.92 | 9505.0 |
| 2022-02-07 05:00:00 | NQ | Futures | 16988.21 | 17023.28 | 16977.49 | 16986.18 | 5444.0 |
| 2022-02-07 06:00:00 | NQ | Futures | 16985.89 | 17034.58 | 16975.46 | 17015.17 | 6898.0 |
| 2022-02-07 07:00:00 | NQ | Futures | 17015.45 | 17083.27 | 17015.17 | 17070.23 | 9568.0 |
| 2022-02-07 08:00:00 | NQ | Futures | 17069.94 | 17109.65 | 17051.1 | 17073.42 | 12695.0 |
| 2022-02-07 09:00:00 | NQ | Futures | 17073.42 | 17164.42 | 17006.47 | 17135.44 | 80863.0 |
| 2022-02-07 10:00:00 | NQ | Futures | 17135.44 | 17145.58 | 17025.89 | 17067.62 | 79455.0 |
| 2022-02-07 11:00:00 | NQ | Futures | 17067.33 | 17092.84 | 16888.51 | 16937.78 | 67793.0 |
| 2022-02-07 12:00:00 | NQ | Futures | 16937.2 | 16965.03 | 16873.73 | 16918.37 | 44770.0 |
| 2022-02-07 13:00:00 | NQ | Futures | 16918.37 | 17011.98 | 16908.22 | 17003.86 | 37259.0 |
| 2022-02-07 14:00:00 | NQ | Futures | 17003.86 | 17049.36 | 16962.13 | 17016.61 | 35311.0 |
| 2022-02-07 15:00:00 | NQ | Futures | 17016.03 | 17072.55 | 16822.73 | 16885.33 | 77822.0 |
| 2022-02-07 16:00:00 | NQ | Futures | 16885.33 | 16935.18 | 16883.59 | 16927.35 | 13689.0 |
| 2022-02-07 18:00:00 | NQ | Futures | 16925.32 | 16943.58 | 16909.09 | 16938.36 | 3843.0 |
| 2022-02-07 19:00:00 | NQ | Futures | 16938.94 | 16953.14 | 16910.54 | 16929.38 | 4439.0 |
| 2022-02-07 20:00:00 | NQ | Futures | 16929.09 | 16929.96 | 16883.88 | 16892.57 | 5550.0 |
| 2022-02-07 21:00:00 | NQ | Futures | 16894.89 | 16921.26 | 16875.76 | 16911.99 | 5285.0 |
| 2022-02-07 22:00:00 | NQ | Futures | 16912.86 | 16926.48 | 16894.89 | 16904.74 | 3840.0 |
| 2022-02-07 23:00:00 | NQ | Futures | 16904.74 | 16913.73 | 16892.86 | 16898.37 | 3349.0 |
| 2022-02-07 00:00:00 | YM | Futures | 39306.0 | 39311.7 | 39253.2 | 39281.3 | 1020.0 |
| 2022-02-07 01:00:00 | YM | Futures | 39281.3 | 39310.5 | 39235.2 | 39301.5 | 976.0 |
| 2022-02-07 02:00:00 | YM | Futures | 39304.9 | 39372.3 | 39267.8 | 39312.8 | 3280.0 |
| 2022-02-07 03:00:00 | YM | Futures | 39315.0 | 39342.0 | 39129.6 | 39237.5 | 7685.0 |
> showing 50 of 2,059 rows — these rows as CSV