PREVIEW / futures_1hour / 2024-06-25
file: by_date/futures_1hour/2024/2024-06-25.parquet size: 66 KB rows: 2,062
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-06-25 00:00:00 | ES | Futures | 5792.25 | 5793.3 | 5791.46 | 5793.04 | 2477.0 |
| 2024-06-25 01:00:00 | ES | Futures | 5793.3 | 5794.35 | 5792.51 | 5792.77 | 3766.0 |
| 2024-06-25 02:00:00 | ES | Futures | 5792.77 | 5792.77 | 5787.79 | 5789.37 | 7703.0 |
| 2024-06-25 03:00:00 | ES | Futures | 5789.37 | 5790.15 | 5780.72 | 5781.76 | 16442.0 |
| 2024-06-25 04:00:00 | ES | Futures | 5781.5 | 5791.99 | 5779.14 | 5791.73 | 19144.0 |
| 2024-06-25 05:00:00 | ES | Futures | 5791.73 | 5796.71 | 5790.68 | 5796.18 | 15074.0 |
| 2024-06-25 06:00:00 | ES | Futures | 5796.44 | 5797.23 | 5792.25 | 5795.4 | 12379.0 |
| 2024-06-25 07:00:00 | ES | Futures | 5795.4 | 5798.28 | 5790.42 | 5795.13 | 25939.0 |
| 2024-06-25 08:00:00 | ES | Futures | 5795.4 | 5798.02 | 5791.2 | 5795.13 | 25599.0 |
| 2024-06-25 09:00:00 | ES | Futures | 5795.13 | 5799.85 | 5785.96 | 5787.53 | 121696.0 |
| 2024-06-25 10:00:00 | ES | Futures | 5787.01 | 5799.33 | 5786.22 | 5792.77 | 154202.0 |
| 2024-06-25 11:00:00 | ES | Futures | 5792.77 | 5801.43 | 5791.2 | 5799.85 | 112471.0 |
| 2024-06-25 12:00:00 | ES | Futures | 5799.85 | 5800.12 | 5780.45 | 5784.91 | 116952.0 |
| 2024-06-25 13:00:00 | ES | Futures | 5784.91 | 5798.02 | 5779.93 | 5795.92 | 94511.0 |
| 2024-06-25 14:00:00 | ES | Futures | 5795.92 | 5805.62 | 5794.09 | 5800.64 | 101601.0 |
| 2024-06-25 15:00:00 | ES | Futures | 5800.64 | 5809.29 | 5797.76 | 5804.57 | 176301.0 |
| 2024-06-25 16:00:00 | ES | Futures | 5804.57 | 5805.62 | 5800.9 | 5804.31 | 41106.0 |
| 2024-06-25 18:00:00 | ES | Futures | 5804.31 | 5807.19 | 5802.74 | 5805.88 | 4390.0 |
| 2024-06-25 19:00:00 | ES | Futures | 5805.88 | 5805.88 | 5803.0 | 5803.26 | 2081.0 |
| 2024-06-25 20:00:00 | ES | Futures | 5803.52 | 5807.98 | 5802.21 | 5807.46 | 4451.0 |
| 2024-06-25 21:00:00 | ES | Futures | 5807.46 | 5810.6 | 5806.93 | 5810.08 | 5644.0 |
| 2024-06-25 22:00:00 | ES | Futures | 5810.34 | 5811.39 | 5809.03 | 5810.08 | 3356.0 |
| 2024-06-25 23:00:00 | ES | Futures | 5810.08 | 5811.65 | 5807.46 | 5809.29 | 3557.0 |
| 2024-06-25 00:00:00 | NQ | Futures | 20901.08 | 20909.53 | 20897.65 | 20908.21 | 1712.0 |
| 2024-06-25 01:00:00 | NQ | Futures | 20908.47 | 20918.5 | 20905.83 | 20912.43 | 2318.0 |
| 2024-06-25 02:00:00 | NQ | Futures | 20912.43 | 20913.22 | 20882.6 | 20888.41 | 6211.0 |
| 2024-06-25 03:00:00 | NQ | Futures | 20888.14 | 20892.1 | 20835.08 | 20843.0 | 11064.0 |
| 2024-06-25 04:00:00 | NQ | Futures | 20842.74 | 20926.42 | 20829.28 | 20925.36 | 13107.0 |
| 2024-06-25 05:00:00 | NQ | Futures | 20925.36 | 20950.97 | 20920.88 | 20948.6 | 10859.0 |
| 2024-06-25 06:00:00 | NQ | Futures | 20948.6 | 20954.4 | 20931.17 | 20944.64 | 6729.0 |
| 2024-06-25 07:00:00 | NQ | Futures | 20944.64 | 20961.27 | 20912.69 | 20928.0 | 10609.0 |
| 2024-06-25 08:00:00 | NQ | Futures | 20928.27 | 20951.76 | 20916.39 | 20940.68 | 12472.0 |
| 2024-06-25 09:00:00 | NQ | Futures | 20941.2 | 20962.85 | 20899.23 | 20941.2 | 77174.0 |
| 2024-06-25 10:00:00 | NQ | Futures | 20941.2 | 21015.12 | 20937.24 | 20977.37 | 98145.0 |
| 2024-06-25 11:00:00 | NQ | Futures | 20977.63 | 21077.15 | 20977.63 | 21075.04 | 70509.0 |
| 2024-06-25 12:00:00 | NQ | Futures | 21075.57 | 21084.81 | 20966.55 | 20985.82 | 63940.0 |
| 2024-06-25 13:00:00 | NQ | Futures | 20985.82 | 21046.53 | 20947.28 | 21038.61 | 48189.0 |
| 2024-06-25 14:00:00 | NQ | Futures | 21038.88 | 21082.43 | 21029.9 | 21065.54 | 43255.0 |
| 2024-06-25 15:00:00 | NQ | Futures | 21065.28 | 21098.8 | 21048.64 | 21083.75 | 58479.0 |
| 2024-06-25 16:00:00 | NQ | Futures | 21084.02 | 21090.62 | 21071.35 | 21087.45 | 13663.0 |
| 2024-06-25 18:00:00 | NQ | Futures | 21090.09 | 21105.67 | 21083.23 | 21094.05 | 3239.0 |
| 2024-06-25 19:00:00 | NQ | Futures | 21094.58 | 21095.11 | 21080.06 | 21082.96 | 2352.0 |
| 2024-06-25 20:00:00 | NQ | Futures | 21083.49 | 21110.42 | 21080.59 | 21107.78 | 4680.0 |
| 2024-06-25 21:00:00 | NQ | Futures | 21107.78 | 21122.3 | 21104.35 | 21118.07 | 4572.0 |
| 2024-06-25 22:00:00 | NQ | Futures | 21117.54 | 21124.94 | 21113.85 | 21116.75 | 2946.0 |
| 2024-06-25 23:00:00 | NQ | Futures | 21116.75 | 21127.58 | 21098.8 | 21108.83 | 3479.0 |
| 2024-06-25 00:00:00 | YM | Futures | 41939.8 | 41944.0 | 41927.2 | 41937.7 | 638.0 |
| 2024-06-25 01:00:00 | YM | Futures | 41939.8 | 41953.5 | 41935.6 | 41935.6 | 798.0 |
| 2024-06-25 02:00:00 | YM | Futures | 41935.6 | 41935.6 | 41899.9 | 41921.9 | 1601.0 |
| 2024-06-25 03:00:00 | YM | Futures | 41923.0 | 41935.6 | 41876.8 | 41887.3 | 2202.0 |
> showing 50 of 2,062 rows — these rows as CSV