PREVIEW / futures_1hour / 2023-12-15
file: by_date/futures_1hour/2023/2023-12-15.parquet size: 57 KB rows: 1,623
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-15 00:00:00 | ES | Futures | 5134.65 | 5135.45 | 5131.69 | 5134.65 | 6772.0 |
| 2023-12-15 01:00:00 | ES | Futures | 5134.38 | 5134.65 | 5132.5 | 5133.57 | 6476.0 |
| 2023-12-15 02:00:00 | ES | Futures | 5133.57 | 5141.09 | 5133.3 | 5140.29 | 10365.0 |
| 2023-12-15 03:00:00 | ES | Futures | 5140.02 | 5141.63 | 5137.6 | 5141.36 | 21402.0 |
| 2023-12-15 04:00:00 | ES | Futures | 5141.09 | 5143.78 | 5138.41 | 5143.24 | 16820.0 |
| 2023-12-15 05:00:00 | ES | Futures | 5142.97 | 5145.12 | 5139.75 | 5141.36 | 18991.0 |
| 2023-12-15 06:00:00 | ES | Futures | 5141.36 | 5144.05 | 5140.02 | 5141.9 | 14094.0 |
| 2023-12-15 07:00:00 | ES | Futures | 5141.63 | 5142.44 | 5135.99 | 5137.33 | 20383.0 |
| 2023-12-15 08:00:00 | ES | Futures | 5137.33 | 5140.56 | 5119.61 | 5127.66 | 94287.0 |
| 2023-12-15 09:00:00 | ES | Futures | 5127.93 | 5135.18 | 5115.58 | 5118.53 | 317824.0 |
| 2023-12-15 10:00:00 | ES | Futures | 5118.53 | 5133.84 | 5118.26 | 5131.69 | 181517.0 |
| 2023-12-15 11:00:00 | ES | Futures | 5131.69 | 5133.57 | 5125.25 | 5129.01 | 118960.0 |
| 2023-12-15 12:00:00 | ES | Futures | 5129.01 | 5132.5 | 5120.41 | 5121.49 | 103623.0 |
| 2023-12-15 13:00:00 | ES | Futures | 5121.22 | 5127.66 | 5111.01 | 5113.7 | 132929.0 |
| 2023-12-15 14:00:00 | ES | Futures | 5113.97 | 5120.95 | 5111.55 | 5117.46 | 119424.0 |
| 2023-12-15 15:00:00 | ES | Futures | 5117.46 | 5134.92 | 5115.85 | 5121.22 | 284350.0 |
| 2023-12-15 16:00:00 | ES | Futures | 5121.22 | 5127.93 | 5120.41 | 5124.17 | 114018.0 |
| 2023-12-15 00:00:00 | NQ | Futures | 18200.88 | 18204.68 | 18188.4 | 18198.98 | 3219.0 |
| 2023-12-15 01:00:00 | NQ | Futures | 18199.25 | 18199.25 | 18190.3 | 18193.83 | 2584.0 |
| 2023-12-15 02:00:00 | NQ | Futures | 18193.83 | 18227.73 | 18192.74 | 18223.93 | 5276.0 |
| 2023-12-15 03:00:00 | NQ | Futures | 18223.39 | 18227.19 | 18205.76 | 18223.12 | 8393.0 |
| 2023-12-15 04:00:00 | NQ | Futures | 18222.58 | 18235.59 | 18215.53 | 18233.97 | 7802.0 |
| 2023-12-15 05:00:00 | NQ | Futures | 18233.7 | 18239.66 | 18217.69 | 18222.03 | 7324.0 |
| 2023-12-15 06:00:00 | NQ | Futures | 18222.31 | 18239.66 | 18218.24 | 18232.07 | 6845.0 |
| 2023-12-15 07:00:00 | NQ | Futures | 18232.07 | 18238.85 | 18214.98 | 18221.49 | 8932.0 |
| 2023-12-15 08:00:00 | NQ | Futures | 18221.76 | 18237.76 | 18178.1 | 18212.0 | 30387.0 |
| 2023-12-15 09:00:00 | NQ | Futures | 18212.54 | 18273.02 | 18178.37 | 18248.61 | 113375.0 |
| 2023-12-15 10:00:00 | NQ | Futures | 18249.7 | 18308.01 | 18235.32 | 18289.02 | 77064.0 |
| 2023-12-15 11:00:00 | NQ | Futures | 18289.29 | 18319.67 | 18266.51 | 18294.17 | 62450.0 |
| 2023-12-15 12:00:00 | NQ | Futures | 18294.45 | 18301.5 | 18223.39 | 18228.0 | 56504.0 |
| 2023-12-15 13:00:00 | NQ | Futures | 18227.46 | 18270.31 | 18184.34 | 18203.32 | 77385.0 |
| 2023-12-15 14:00:00 | NQ | Futures | 18203.59 | 18256.48 | 18192.74 | 18240.2 | 47840.0 |
| 2023-12-15 15:00:00 | NQ | Futures | 18239.93 | 18298.51 | 18231.53 | 18246.44 | 84213.0 |
| 2023-12-15 16:00:00 | NQ | Futures | 18245.9 | 18261.36 | 18239.66 | 18241.29 | 19824.0 |
| 2023-12-15 00:00:00 | YM | Futures | 40485.2 | 40491.7 | 40464.8 | 40486.3 | 1113.0 |
| 2023-12-15 01:00:00 | YM | Futures | 40485.2 | 40486.3 | 40470.2 | 40476.6 | 1060.0 |
| 2023-12-15 02:00:00 | YM | Futures | 40476.6 | 40535.7 | 40474.5 | 40526.0 | 2229.0 |
| 2023-12-15 03:00:00 | YM | Futures | 40524.9 | 40548.6 | 40516.4 | 40545.4 | 3017.0 |
| 2023-12-15 04:00:00 | YM | Futures | 40543.2 | 40560.4 | 40517.4 | 40559.3 | 2521.0 |
| 2023-12-15 05:00:00 | YM | Futures | 40558.2 | 40583.0 | 40538.9 | 40549.7 | 2688.0 |
| 2023-12-15 06:00:00 | YM | Futures | 40549.7 | 40553.9 | 40529.2 | 40536.8 | 2057.0 |
| 2023-12-15 07:00:00 | YM | Futures | 40535.7 | 40547.5 | 40499.2 | 40503.5 | 3031.0 |
| 2023-12-15 08:00:00 | YM | Futures | 40503.5 | 40523.9 | 40364.9 | 40402.5 | 8903.0 |
| 2023-12-15 09:00:00 | YM | Futures | 40403.6 | 40453.0 | 40314.4 | 40320.9 | 34424.0 |
| 2023-12-15 10:00:00 | YM | Futures | 40320.9 | 40436.9 | 40303.7 | 40417.5 | 18257.0 |
| 2023-12-15 11:00:00 | YM | Futures | 40418.6 | 40465.9 | 40381.0 | 40450.8 | 9965.0 |
| 2023-12-15 12:00:00 | YM | Futures | 40450.8 | 40475.5 | 40414.3 | 40435.8 | 8357.0 |
| 2023-12-15 13:00:00 | YM | Futures | 40434.7 | 40463.7 | 40350.9 | 40363.8 | 10650.0 |
| 2023-12-15 14:00:00 | YM | Futures | 40363.8 | 40386.4 | 40316.6 | 40358.5 | 9921.0 |
| 2023-12-15 15:00:00 | YM | Futures | 40358.5 | 40527.1 | 40346.7 | 40435.8 | 17588.0 |
> showing 50 of 1,623 rows — these rows as CSV