PREVIEW / futures_1hour / 2021-04-15
file: by_date/futures_1hour/2021/2021-04-15.parquet size: 62 KB rows: 1,899
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-04-15 00:00:00 | ES | Futures | 4633.47 | 4636.27 | 4633.18 | 4634.87 | 2727.0 |
| 2021-04-15 01:00:00 | ES | Futures | 4634.87 | 4638.8 | 4634.31 | 4637.68 | 5708.0 |
| 2021-04-15 02:00:00 | ES | Futures | 4637.4 | 4643.3 | 4636.84 | 4643.02 | 8793.0 |
| 2021-04-15 03:00:00 | ES | Futures | 4643.02 | 4650.6 | 4641.61 | 4648.92 | 21581.0 |
| 2021-04-15 04:00:00 | ES | Futures | 4648.92 | 4651.17 | 4646.95 | 4649.76 | 11985.0 |
| 2021-04-15 05:00:00 | ES | Futures | 4649.76 | 4651.45 | 4647.79 | 4648.64 | 9516.0 |
| 2021-04-15 06:00:00 | ES | Futures | 4648.64 | 4652.29 | 4646.95 | 4652.01 | 13123.0 |
| 2021-04-15 07:00:00 | ES | Futures | 4652.01 | 4654.54 | 4647.79 | 4654.54 | 19026.0 |
| 2021-04-15 08:00:00 | ES | Futures | 4654.26 | 4659.88 | 4653.41 | 4655.38 | 36038.0 |
| 2021-04-15 09:00:00 | ES | Futures | 4655.38 | 4661.84 | 4652.01 | 4657.07 | 166405.0 |
| 2021-04-15 10:00:00 | ES | Futures | 4657.35 | 4671.12 | 4654.82 | 4668.31 | 207575.0 |
| 2021-04-15 11:00:00 | ES | Futures | 4668.31 | 4674.49 | 4663.81 | 4667.18 | 126177.0 |
| 2021-04-15 12:00:00 | ES | Futures | 4667.18 | 4677.02 | 4665.78 | 4676.45 | 80409.0 |
| 2021-04-15 13:00:00 | ES | Futures | 4676.45 | 4677.3 | 4670.27 | 4673.92 | 81072.0 |
| 2021-04-15 14:00:00 | ES | Futures | 4673.92 | 4678.14 | 4671.4 | 4673.36 | 107887.0 |
| 2021-04-15 15:00:00 | ES | Futures | 4673.36 | 4682.63 | 4668.31 | 4678.98 | 244554.0 |
| 2021-04-15 16:00:00 | ES | Futures | 4678.98 | 4679.83 | 4676.17 | 4678.14 | 55565.0 |
| 2021-04-15 18:00:00 | ES | Futures | 4678.42 | 4679.54 | 4676.17 | 4678.42 | 5166.0 |
| 2021-04-15 19:00:00 | ES | Futures | 4678.42 | 4680.11 | 4678.14 | 4678.42 | 3139.0 |
| 2021-04-15 20:00:00 | ES | Futures | 4678.42 | 4678.7 | 4670.83 | 4672.24 | 10035.0 |
| 2021-04-15 21:00:00 | ES | Futures | 4671.96 | 4673.36 | 4669.71 | 4672.24 | 9192.0 |
| 2021-04-15 22:00:00 | ES | Futures | 4671.96 | 4672.8 | 4668.87 | 4670.27 | 8139.0 |
| 2021-04-15 23:00:00 | ES | Futures | 4670.55 | 4672.52 | 4669.71 | 4670.55 | 4172.0 |
| 2021-04-15 00:00:00 | NQ | Futures | 15990.85 | 16004.17 | 15989.4 | 15995.48 | 1894.0 |
| 2021-04-15 01:00:00 | NQ | Futures | 15995.19 | 16029.35 | 15994.32 | 16018.35 | 3956.0 |
| 2021-04-15 02:00:00 | NQ | Futures | 16018.35 | 16043.83 | 16011.69 | 16043.25 | 3750.0 |
| 2021-04-15 03:00:00 | NQ | Futures | 16042.96 | 16091.31 | 16039.78 | 16071.62 | 9274.0 |
| 2021-04-15 04:00:00 | NQ | Futures | 16071.62 | 16078.57 | 16058.59 | 16076.54 | 4618.0 |
| 2021-04-15 05:00:00 | NQ | Futures | 16076.54 | 16085.52 | 16065.25 | 16065.25 | 4781.0 |
| 2021-04-15 06:00:00 | NQ | Futures | 16065.25 | 16095.07 | 16054.83 | 16093.62 | 4844.0 |
| 2021-04-15 07:00:00 | NQ | Futures | 16092.75 | 16113.02 | 16071.04 | 16113.02 | 7188.0 |
| 2021-04-15 08:00:00 | NQ | Futures | 16112.44 | 16148.05 | 16106.65 | 16137.34 | 16973.0 |
| 2021-04-15 09:00:00 | NQ | Futures | 16137.63 | 16185.97 | 16120.54 | 16160.21 | 73091.0 |
| 2021-04-15 10:00:00 | NQ | Futures | 16160.5 | 16213.76 | 16132.7 | 16190.6 | 85769.0 |
| 2021-04-15 11:00:00 | NQ | Futures | 16191.18 | 16225.92 | 16156.15 | 16166.29 | 59036.0 |
| 2021-04-15 12:00:00 | NQ | Futures | 16166.57 | 16223.89 | 16146.02 | 16221.87 | 46667.0 |
| 2021-04-15 13:00:00 | NQ | Futures | 16221.87 | 16237.79 | 16188.29 | 16227.37 | 43431.0 |
| 2021-04-15 14:00:00 | NQ | Futures | 16227.95 | 16239.82 | 16200.45 | 16213.18 | 39408.0 |
| 2021-04-15 15:00:00 | NQ | Futures | 16213.18 | 16251.4 | 16186.26 | 16230.55 | 77472.0 |
| 2021-04-15 16:00:00 | NQ | Futures | 16230.84 | 16236.92 | 16201.6 | 16210.58 | 11405.0 |
| 2021-04-15 18:00:00 | NQ | Futures | 16214.05 | 16223.32 | 16198.71 | 16217.53 | 2348.0 |
| 2021-04-15 19:00:00 | NQ | Futures | 16217.53 | 16232.58 | 16216.66 | 16223.61 | 1643.0 |
| 2021-04-15 20:00:00 | NQ | Futures | 16223.61 | 16227.08 | 16192.63 | 16196.39 | 4614.0 |
| 2021-04-15 21:00:00 | NQ | Futures | 16196.68 | 16197.84 | 16172.65 | 16183.37 | 5622.0 |
| 2021-04-15 22:00:00 | NQ | Futures | 16182.79 | 16185.97 | 16157.02 | 16170.05 | 4544.0 |
| 2021-04-15 23:00:00 | NQ | Futures | 16170.92 | 16186.26 | 16170.63 | 16178.15 | 1941.0 |
| 2021-04-15 00:00:00 | YM | Futures | 37519.0 | 37535.7 | 37515.6 | 37525.7 | 603.0 |
| 2021-04-15 01:00:00 | YM | Futures | 37523.4 | 37544.6 | 37516.7 | 37530.1 | 1214.0 |
| 2021-04-15 02:00:00 | YM | Futures | 37530.1 | 37576.9 | 37525.7 | 37576.9 | 2013.0 |
| 2021-04-15 03:00:00 | YM | Futures | 37574.7 | 37596.9 | 37560.2 | 37588.0 | 3712.0 |
> showing 50 of 1,899 rows — these rows as CSV