PREVIEW / futures_1hour / 2021-12-01
file: by_date/futures_1hour/2021/2021-12-01.parquet size: 69 KB rows: 2,063
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-12-01 00:00:00 | ES | Futures | 5200.05 | 5201.46 | 5195.81 | 5196.94 | 6279.0 |
| 2021-12-01 01:00:00 | ES | Futures | 5196.94 | 5208.51 | 5193.84 | 5202.02 | 11535.0 |
| 2021-12-01 02:00:00 | ES | Futures | 5201.74 | 5206.25 | 5197.51 | 5201.17 | 13699.0 |
| 2021-12-01 03:00:00 | ES | Futures | 5200.89 | 5204.84 | 5188.19 | 5201.74 | 28866.0 |
| 2021-12-01 04:00:00 | ES | Futures | 5201.74 | 5221.78 | 5200.61 | 5217.26 | 32969.0 |
| 2021-12-01 05:00:00 | ES | Futures | 5217.54 | 5218.95 | 5211.33 | 5216.98 | 15333.0 |
| 2021-12-01 06:00:00 | ES | Futures | 5217.26 | 5220.36 | 5209.36 | 5219.52 | 16932.0 |
| 2021-12-01 07:00:00 | ES | Futures | 5219.52 | 5225.16 | 5215.85 | 5220.65 | 32686.0 |
| 2021-12-01 08:00:00 | ES | Futures | 5220.36 | 5223.19 | 5212.75 | 5217.54 | 41388.0 |
| 2021-12-01 09:00:00 | ES | Futures | 5217.54 | 5220.93 | 5199.76 | 5213.59 | 215566.0 |
| 2021-12-01 10:00:00 | ES | Futures | 5213.59 | 5237.3 | 5210.49 | 5236.17 | 301850.0 |
| 2021-12-01 11:00:00 | ES | Futures | 5236.17 | 5250.0 | 5222.62 | 5227.42 | 247077.0 |
| 2021-12-01 12:00:00 | ES | Futures | 5227.42 | 5240.12 | 5200.05 | 5202.3 | 207389.0 |
| 2021-12-01 13:00:00 | ES | Futures | 5202.3 | 5210.49 | 5167.31 | 5186.78 | 334078.0 |
| 2021-12-01 14:00:00 | ES | Futures | 5186.78 | 5189.89 | 5161.1 | 5168.44 | 260923.0 |
| 2021-12-01 15:00:00 | ES | Futures | 5168.16 | 5172.11 | 5086.03 | 5089.42 | 568252.0 |
| 2021-12-01 16:00:00 | ES | Futures | 5089.42 | 5099.86 | 5077.28 | 5088.29 | 139820.0 |
| 2021-12-01 18:00:00 | ES | Futures | 5096.47 | 5111.71 | 5088.85 | 5110.02 | 24173.0 |
| 2021-12-01 19:00:00 | ES | Futures | 5110.02 | 5116.51 | 5099.86 | 5105.5 | 19498.0 |
| 2021-12-01 20:00:00 | ES | Futures | 5105.5 | 5120.46 | 5101.27 | 5119.05 | 22294.0 |
| 2021-12-01 21:00:00 | ES | Futures | 5118.77 | 5128.36 | 5110.58 | 5127.52 | 20590.0 |
| 2021-12-01 22:00:00 | ES | Futures | 5127.23 | 5127.52 | 5115.1 | 5120.74 | 11847.0 |
| 2021-12-01 23:00:00 | ES | Futures | 5121.03 | 5126.39 | 5116.79 | 5118.77 | 9798.0 |
| 2021-12-01 00:00:00 | NQ | Futures | 18978.68 | 18982.73 | 18960.42 | 18972.3 | 4420.0 |
| 2021-12-01 01:00:00 | NQ | Futures | 18972.3 | 19016.06 | 18962.16 | 18989.69 | 7895.0 |
| 2021-12-01 02:00:00 | NQ | Futures | 18989.69 | 19008.24 | 18968.24 | 18991.14 | 7705.0 |
| 2021-12-01 03:00:00 | NQ | Futures | 18988.82 | 18989.98 | 18897.24 | 18938.97 | 15199.0 |
| 2021-12-01 04:00:00 | NQ | Futures | 18939.26 | 18989.11 | 18932.6 | 18989.11 | 10297.0 |
| 2021-12-01 05:00:00 | NQ | Futures | 18988.24 | 18990.27 | 18963.32 | 18973.17 | 4500.0 |
| 2021-12-01 06:00:00 | NQ | Futures | 18975.49 | 18999.83 | 18956.07 | 18995.2 | 6428.0 |
| 2021-12-01 07:00:00 | NQ | Futures | 18995.2 | 19011.14 | 18983.89 | 18987.95 | 10719.0 |
| 2021-12-01 08:00:00 | NQ | Futures | 18987.66 | 18987.66 | 18939.55 | 18947.96 | 14740.0 |
| 2021-12-01 09:00:00 | NQ | Futures | 18947.38 | 18973.46 | 18861.88 | 18929.99 | 80731.0 |
| 2021-12-01 10:00:00 | NQ | Futures | 18929.7 | 18985.92 | 18867.97 | 18977.52 | 98427.0 |
| 2021-12-01 11:00:00 | NQ | Futures | 18977.81 | 19043.89 | 18924.19 | 18938.97 | 76831.0 |
| 2021-12-01 12:00:00 | NQ | Futures | 18939.55 | 18983.6 | 18818.41 | 18830.29 | 71350.0 |
| 2021-12-01 13:00:00 | NQ | Futures | 18830.29 | 18873.76 | 18707.99 | 18796.38 | 106291.0 |
| 2021-12-01 14:00:00 | NQ | Futures | 18796.96 | 18805.95 | 18676.98 | 18700.74 | 87481.0 |
| 2021-12-01 15:00:00 | NQ | Futures | 18700.16 | 18714.94 | 18384.26 | 18403.1 | 162237.0 |
| 2021-12-01 16:00:00 | NQ | Futures | 18403.97 | 18438.75 | 18345.72 | 18384.55 | 37832.0 |
| 2021-12-01 18:00:00 | NQ | Futures | 18422.81 | 18495.55 | 18394.69 | 18488.31 | 10824.0 |
| 2021-12-01 19:00:00 | NQ | Futures | 18489.18 | 18505.4 | 18438.75 | 18464.25 | 9697.0 |
| 2021-12-01 20:00:00 | NQ | Futures | 18463.38 | 18527.14 | 18446.28 | 18520.77 | 11485.0 |
| 2021-12-01 21:00:00 | NQ | Futures | 18521.06 | 18534.39 | 18474.39 | 18529.75 | 10994.0 |
| 2021-12-01 22:00:00 | NQ | Futures | 18528.88 | 18529.75 | 18469.76 | 18491.49 | 6828.0 |
| 2021-12-01 23:00:00 | NQ | Futures | 18492.07 | 18514.39 | 18478.74 | 18486.86 | 5904.0 |
| 2021-12-01 00:00:00 | YM | Futures | 38811.4 | 38817.0 | 38773.3 | 38781.2 | 1540.0 |
| 2021-12-01 01:00:00 | YM | Futures | 38783.4 | 38869.7 | 38755.4 | 38810.3 | 2689.0 |
| 2021-12-01 02:00:00 | YM | Futures | 38806.9 | 38842.8 | 38767.7 | 38795.7 | 3887.0 |
| 2021-12-01 03:00:00 | YM | Futures | 38794.6 | 38869.7 | 38756.5 | 38867.5 | 6234.0 |
> showing 50 of 2,063 rows — these rows as CSV