PREVIEW / futures_1hour / 2024-05-31
file: by_date/futures_1hour/2024/2024-05-31.parquet size: 57 KB rows: 1,670
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 |
|---|---|---|---|---|---|---|---|
| 2024-05-31 00:00:00 | ES | Futures | 5567.23 | 5567.23 | 5563.25 | 5564.84 | 3168.0 |
| 2024-05-31 01:00:00 | ES | Futures | 5564.84 | 5568.56 | 5561.66 | 5562.19 | 8082.0 |
| 2024-05-31 02:00:00 | ES | Futures | 5561.92 | 5566.97 | 5561.92 | 5565.11 | 9269.0 |
| 2024-05-31 03:00:00 | ES | Futures | 5565.37 | 5567.76 | 5560.07 | 5561.66 | 17153.0 |
| 2024-05-31 04:00:00 | ES | Futures | 5561.92 | 5570.94 | 5560.86 | 5564.84 | 16450.0 |
| 2024-05-31 05:00:00 | ES | Futures | 5564.84 | 5565.37 | 5560.07 | 5562.19 | 13654.0 |
| 2024-05-31 06:00:00 | ES | Futures | 5562.46 | 5564.84 | 5550.78 | 5559.8 | 20603.0 |
| 2024-05-31 07:00:00 | ES | Futures | 5560.07 | 5569.62 | 5557.68 | 5568.56 | 18971.0 |
| 2024-05-31 08:00:00 | ES | Futures | 5568.56 | 5594.82 | 5567.23 | 5590.58 | 79725.0 |
| 2024-05-31 09:00:00 | ES | Futures | 5590.58 | 5592.7 | 5572.54 | 5574.92 | 209808.0 |
| 2024-05-31 10:00:00 | ES | Futures | 5574.66 | 5575.45 | 5543.62 | 5550.52 | 366886.0 |
| 2024-05-31 11:00:00 | ES | Futures | 5550.78 | 5551.58 | 5537.25 | 5538.05 | 211992.0 |
| 2024-05-31 12:00:00 | ES | Futures | 5538.05 | 5539.37 | 5523.99 | 5536.46 | 191800.0 |
| 2024-05-31 13:00:00 | ES | Futures | 5536.19 | 5552.9 | 5536.19 | 5551.05 | 156305.0 |
| 2024-05-31 14:00:00 | ES | Futures | 5551.05 | 5561.13 | 5547.6 | 5557.41 | 145910.0 |
| 2024-05-31 15:00:00 | ES | Futures | 5557.41 | 5623.74 | 5552.9 | 5620.82 | 584916.0 |
| 2024-05-31 16:00:00 | ES | Futures | 5620.82 | 5631.7 | 5614.72 | 5623.47 | 186770.0 |
| 2024-05-31 00:00:00 | NQ | Futures | 19861.64 | 19863.24 | 19845.86 | 19853.08 | 2117.0 |
| 2024-05-31 01:00:00 | NQ | Futures | 19852.54 | 19867.26 | 19834.09 | 19835.42 | 3759.0 |
| 2024-05-31 02:00:00 | NQ | Futures | 19835.16 | 19857.36 | 19833.28 | 19848.8 | 4192.0 |
| 2024-05-31 03:00:00 | NQ | Futures | 19848.8 | 19856.56 | 19809.74 | 19820.98 | 7941.0 |
| 2024-05-31 04:00:00 | NQ | Futures | 19821.51 | 19873.14 | 19814.56 | 19842.38 | 9997.0 |
| 2024-05-31 05:00:00 | NQ | Futures | 19842.91 | 19848.26 | 19822.85 | 19838.37 | 6241.0 |
| 2024-05-31 06:00:00 | NQ | Futures | 19839.44 | 19848.53 | 19779.25 | 19818.3 | 10545.0 |
| 2024-05-31 07:00:00 | NQ | Futures | 19818.3 | 19866.19 | 19810.81 | 19861.37 | 9673.0 |
| 2024-05-31 08:00:00 | NQ | Futures | 19862.17 | 19975.33 | 19856.29 | 19952.59 | 35467.0 |
| 2024-05-31 09:00:00 | NQ | Futures | 19952.59 | 19962.76 | 19826.33 | 19842.65 | 94803.0 |
| 2024-05-31 10:00:00 | NQ | Futures | 19841.84 | 19847.46 | 19641.22 | 19674.12 | 145444.0 |
| 2024-05-31 11:00:00 | NQ | Futures | 19674.39 | 19675.72 | 19575.68 | 19582.1 | 83221.0 |
| 2024-05-31 12:00:00 | NQ | Futures | 19581.83 | 19596.28 | 19518.43 | 19573.8 | 76601.0 |
| 2024-05-31 13:00:00 | NQ | Futures | 19573.54 | 19652.99 | 19572.2 | 19625.43 | 61267.0 |
| 2024-05-31 14:00:00 | NQ | Futures | 19625.7 | 19652.45 | 19592.26 | 19637.47 | 49297.0 |
| 2024-05-31 15:00:00 | NQ | Futures | 19637.74 | 19903.37 | 19623.03 | 19900.96 | 145306.0 |
| 2024-05-31 16:00:00 | NQ | Futures | 19900.16 | 19931.46 | 19870.47 | 19871.0 | 37948.0 |
| 2024-05-31 00:00:00 | YM | Futures | 40569.8 | 40569.8 | 40547.5 | 40560.2 | 549.0 |
| 2024-05-31 01:00:00 | YM | Futures | 40559.2 | 40579.3 | 40553.8 | 40557.0 | 968.0 |
| 2024-05-31 02:00:00 | YM | Futures | 40557.0 | 40593.1 | 40556.0 | 40580.4 | 1287.0 |
| 2024-05-31 03:00:00 | YM | Futures | 40578.3 | 40604.8 | 40561.3 | 40573.0 | 2387.0 |
| 2024-05-31 04:00:00 | YM | Futures | 40574.0 | 40613.3 | 40566.6 | 40580.4 | 2804.0 |
| 2024-05-31 05:00:00 | YM | Futures | 40580.4 | 40581.4 | 40543.2 | 40549.6 | 1991.0 |
| 2024-05-31 06:00:00 | YM | Futures | 40549.6 | 40565.5 | 40492.3 | 40545.4 | 2446.0 |
| 2024-05-31 07:00:00 | YM | Futures | 40546.4 | 40573.0 | 40528.4 | 40567.6 | 1871.0 |
| 2024-05-31 08:00:00 | YM | Futures | 40565.5 | 40701.4 | 40557.0 | 40671.7 | 7942.0 |
| 2024-05-31 09:00:00 | YM | Futures | 40670.6 | 40740.7 | 40581.4 | 40598.4 | 22337.0 |
| 2024-05-31 10:00:00 | YM | Futures | 40597.4 | 40639.8 | 40536.9 | 40613.3 | 20322.0 |
| 2024-05-31 11:00:00 | YM | Futures | 40614.4 | 40648.3 | 40576.1 | 40612.2 | 10461.0 |
| 2024-05-31 12:00:00 | YM | Futures | 40611.2 | 40678.1 | 40565.5 | 40673.8 | 10577.0 |
| 2024-05-31 13:00:00 | YM | Futures | 40674.9 | 40794.9 | 40673.8 | 40792.7 | 10770.0 |
| 2024-05-31 14:00:00 | YM | Futures | 40792.7 | 40866.0 | 40787.4 | 40839.4 | 11053.0 |
| 2024-05-31 15:00:00 | YM | Futures | 40838.4 | 41206.8 | 40799.1 | 41191.9 | 31223.0 |
> showing 50 of 1,670 rows — these rows as CSV