PREVIEW / futures_1hour / 2021-01-28
file: by_date/futures_1hour/2021/2021-01-28.parquet size: 65 KB rows: 1,980
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-01-28 00:00:00 | ES | Futures | 4187.82 | 4198.77 | 4186.7 | 4187.54 | 8710.0 |
| 2021-01-28 01:00:00 | ES | Futures | 4187.54 | 4187.82 | 4180.25 | 4184.74 | 11559.0 |
| 2021-01-28 02:00:00 | ES | Futures | 4184.74 | 4190.91 | 4174.63 | 4185.86 | 24260.0 |
| 2021-01-28 03:00:00 | ES | Futures | 4185.58 | 4196.24 | 4163.41 | 4163.97 | 45677.0 |
| 2021-01-28 04:00:00 | ES | Futures | 4163.97 | 4179.96 | 4161.16 | 4176.6 | 43157.0 |
| 2021-01-28 05:00:00 | ES | Futures | 4176.6 | 4194.0 | 4171.83 | 4186.42 | 35854.0 |
| 2021-01-28 06:00:00 | ES | Futures | 4186.14 | 4203.54 | 4181.65 | 4194.84 | 36199.0 |
| 2021-01-28 07:00:00 | ES | Futures | 4194.56 | 4208.87 | 4191.75 | 4199.61 | 41929.0 |
| 2021-01-28 08:00:00 | ES | Futures | 4199.33 | 4229.64 | 4187.54 | 4226.27 | 92949.0 |
| 2021-01-28 09:00:00 | ES | Futures | 4226.56 | 4257.99 | 4224.03 | 4243.11 | 309842.0 |
| 2021-01-28 10:00:00 | ES | Futures | 4243.4 | 4273.15 | 4239.75 | 4268.37 | 315700.0 |
| 2021-01-28 11:00:00 | ES | Futures | 4268.37 | 4281.85 | 4265.57 | 4277.36 | 172360.0 |
| 2021-01-28 12:00:00 | ES | Futures | 4277.64 | 4291.39 | 4277.64 | 4287.46 | 128949.0 |
| 2021-01-28 13:00:00 | ES | Futures | 4287.46 | 4292.51 | 4280.72 | 4289.14 | 96548.0 |
| 2021-01-28 14:00:00 | ES | Futures | 4289.14 | 4290.55 | 4270.06 | 4277.92 | 132228.0 |
| 2021-01-28 15:00:00 | ES | Futures | 4277.92 | 4277.92 | 4239.47 | 4243.4 | 320506.0 |
| 2021-01-28 16:00:00 | ES | Futures | 4243.4 | 4252.38 | 4227.12 | 4230.2 | 106981.0 |
| 2021-01-28 18:00:00 | ES | Futures | 4232.73 | 4238.9 | 4222.63 | 4228.8 | 19544.0 |
| 2021-01-28 19:00:00 | ES | Futures | 4229.08 | 4235.26 | 4224.03 | 4225.99 | 15780.0 |
| 2021-01-28 20:00:00 | ES | Futures | 4226.27 | 4240.59 | 4213.93 | 4214.77 | 24817.0 |
| 2021-01-28 21:00:00 | ES | Futures | 4214.77 | 4221.78 | 4210.84 | 4218.42 | 17309.0 |
| 2021-01-28 22:00:00 | ES | Futures | 4218.7 | 4220.1 | 4196.8 | 4197.37 | 18613.0 |
| 2021-01-28 23:00:00 | ES | Futures | 4197.37 | 4201.01 | 4186.42 | 4194.0 | 24358.0 |
| 2021-01-28 00:00:00 | NQ | Futures | 15071.1 | 15124.94 | 15067.63 | 15086.73 | 5492.0 |
| 2021-01-28 01:00:00 | NQ | Futures | 15087.02 | 15102.36 | 15052.29 | 15075.16 | 5602.0 |
| 2021-01-28 02:00:00 | NQ | Futures | 15075.16 | 15085.0 | 15010.9 | 15054.03 | 10753.0 |
| 2021-01-28 03:00:00 | NQ | Futures | 15053.45 | 15096.28 | 14957.94 | 14977.33 | 17115.0 |
| 2021-01-28 04:00:00 | NQ | Futures | 14976.75 | 15022.77 | 14942.02 | 15009.17 | 15456.0 |
| 2021-01-28 05:00:00 | NQ | Futures | 15009.74 | 15047.66 | 14979.06 | 15005.11 | 11498.0 |
| 2021-01-28 06:00:00 | NQ | Futures | 15004.53 | 15101.49 | 14983.12 | 15056.92 | 12408.0 |
| 2021-01-28 07:00:00 | NQ | Futures | 15055.19 | 15132.17 | 15047.66 | 15076.6 | 14280.0 |
| 2021-01-28 08:00:00 | NQ | Futures | 15075.45 | 15199.03 | 15018.43 | 15188.61 | 27721.0 |
| 2021-01-28 09:00:00 | NQ | Futures | 15189.48 | 15338.54 | 15182.83 | 15269.08 | 86960.0 |
| 2021-01-28 10:00:00 | NQ | Futures | 15269.37 | 15382.25 | 15260.1 | 15370.96 | 87734.0 |
| 2021-01-28 11:00:00 | NQ | Futures | 15370.38 | 15419.58 | 15344.62 | 15406.56 | 53217.0 |
| 2021-01-28 12:00:00 | NQ | Futures | 15407.14 | 15495.7 | 15407.14 | 15476.31 | 43955.0 |
| 2021-01-28 13:00:00 | NQ | Futures | 15476.6 | 15506.7 | 15455.47 | 15486.44 | 31886.0 |
| 2021-01-28 14:00:00 | NQ | Futures | 15486.73 | 15496.57 | 15392.95 | 15433.48 | 40841.0 |
| 2021-01-28 15:00:00 | NQ | Futures | 15432.9 | 15432.9 | 15251.13 | 15265.6 | 73135.0 |
| 2021-01-28 16:00:00 | NQ | Futures | 15265.6 | 15280.36 | 15192.96 | 15226.24 | 16784.0 |
| 2021-01-28 18:00:00 | NQ | Futures | 15231.16 | 15268.21 | 15199.61 | 15207.14 | 8419.0 |
| 2021-01-28 19:00:00 | NQ | Futures | 15209.16 | 15240.71 | 15181.38 | 15197.88 | 5762.0 |
| 2021-01-28 20:00:00 | NQ | Futures | 15195.27 | 15236.66 | 15121.18 | 15128.41 | 8635.0 |
| 2021-01-28 21:00:00 | NQ | Futures | 15128.12 | 15150.99 | 15115.39 | 15132.17 | 5096.0 |
| 2021-01-28 22:00:00 | NQ | Futures | 15133.33 | 15138.83 | 15040.71 | 15047.37 | 6886.0 |
| 2021-01-28 23:00:00 | NQ | Futures | 15048.24 | 15071.68 | 15008.01 | 15062.13 | 7753.0 |
| 2021-01-28 00:00:00 | YM | Futures | 33441.1 | 33507.7 | 33427.8 | 33428.9 | 1861.0 |
| 2021-01-28 01:00:00 | YM | Futures | 33431.1 | 33432.3 | 33373.5 | 33422.3 | 3093.0 |
| 2021-01-28 02:00:00 | YM | Futures | 33423.4 | 33478.8 | 33359.0 | 33446.7 | 4796.0 |
| 2021-01-28 03:00:00 | YM | Futures | 33445.6 | 33532.1 | 33281.4 | 33284.7 | 10478.0 |
> showing 50 of 1,980 rows — these rows as CSV