PREVIEW / futures_1hour / 2024-02-27
file: by_date/futures_1hour/2024/2024-02-27.parquet size: 64 KB rows: 2,038
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-02-27 00:00:00 | ES | Futures | 5455.61 | 5456.96 | 5450.24 | 5452.93 | 5303.0 |
| 2024-02-27 01:00:00 | ES | Futures | 5452.93 | 5454.27 | 5451.58 | 5452.93 | 4155.0 |
| 2024-02-27 02:00:00 | ES | Futures | 5453.19 | 5460.45 | 5452.66 | 5458.57 | 8364.0 |
| 2024-02-27 03:00:00 | ES | Futures | 5458.57 | 5460.72 | 5454.0 | 5454.54 | 11011.0 |
| 2024-02-27 04:00:00 | ES | Futures | 5454.81 | 5465.28 | 5454.54 | 5463.67 | 12746.0 |
| 2024-02-27 05:00:00 | ES | Futures | 5463.67 | 5465.01 | 5460.98 | 5464.21 | 8115.0 |
| 2024-02-27 06:00:00 | ES | Futures | 5463.94 | 5464.74 | 5460.45 | 5461.52 | 6705.0 |
| 2024-02-27 07:00:00 | ES | Futures | 5461.79 | 5468.5 | 5461.52 | 5466.62 | 13091.0 |
| 2024-02-27 08:00:00 | ES | Futures | 5466.89 | 5467.43 | 5456.96 | 5465.28 | 30509.0 |
| 2024-02-27 09:00:00 | ES | Futures | 5465.28 | 5467.43 | 5452.12 | 5458.57 | 131184.0 |
| 2024-02-27 10:00:00 | ES | Futures | 5458.57 | 5463.67 | 5452.93 | 5458.84 | 146068.0 |
| 2024-02-27 11:00:00 | ES | Futures | 5458.57 | 5459.37 | 5451.05 | 5456.15 | 87232.0 |
| 2024-02-27 12:00:00 | ES | Futures | 5456.42 | 5457.49 | 5446.21 | 5447.02 | 86512.0 |
| 2024-02-27 13:00:00 | ES | Futures | 5447.02 | 5456.15 | 5443.79 | 5455.08 | 97460.0 |
| 2024-02-27 14:00:00 | ES | Futures | 5455.08 | 5465.01 | 5454.54 | 5464.48 | 98308.0 |
| 2024-02-27 15:00:00 | ES | Futures | 5464.21 | 5470.38 | 5459.64 | 5466.89 | 152546.0 |
| 2024-02-27 16:00:00 | ES | Futures | 5467.16 | 5471.73 | 5466.36 | 5468.77 | 41636.0 |
| 2024-02-27 18:00:00 | ES | Futures | 5469.31 | 5469.85 | 5465.55 | 5465.55 | 4559.0 |
| 2024-02-27 19:00:00 | ES | Futures | 5465.82 | 5466.89 | 5465.28 | 5465.28 | 4124.0 |
| 2024-02-27 20:00:00 | ES | Futures | 5465.28 | 5467.97 | 5463.94 | 5466.89 | 5095.0 |
| 2024-02-27 21:00:00 | ES | Futures | 5466.89 | 5468.5 | 5466.09 | 5468.24 | 4269.0 |
| 2024-02-27 22:00:00 | ES | Futures | 5468.24 | 5469.58 | 5466.89 | 5469.31 | 3852.0 |
| 2024-02-27 23:00:00 | ES | Futures | 5469.58 | 5469.58 | 5465.28 | 5466.09 | 3227.0 |
| 2024-02-27 00:00:00 | NQ | Futures | 19477.17 | 19480.97 | 19448.15 | 19459.27 | 3573.0 |
| 2024-02-27 01:00:00 | NQ | Futures | 19459.82 | 19470.12 | 19453.31 | 19466.05 | 2405.0 |
| 2024-02-27 02:00:00 | NQ | Futures | 19466.05 | 19509.72 | 19464.16 | 19502.4 | 6144.0 |
| 2024-02-27 03:00:00 | NQ | Futures | 19502.67 | 19515.96 | 19475.0 | 19485.04 | 7435.0 |
| 2024-02-27 04:00:00 | NQ | Futures | 19485.85 | 19544.16 | 19484.77 | 19541.99 | 8430.0 |
| 2024-02-27 05:00:00 | NQ | Futures | 19541.72 | 19554.2 | 19527.35 | 19542.53 | 6142.0 |
| 2024-02-27 06:00:00 | NQ | Futures | 19541.99 | 19545.52 | 19525.72 | 19532.23 | 4487.0 |
| 2024-02-27 07:00:00 | NQ | Futures | 19532.23 | 19570.47 | 19530.06 | 19559.62 | 9556.0 |
| 2024-02-27 08:00:00 | NQ | Futures | 19559.62 | 19563.42 | 19512.43 | 19556.09 | 19196.0 |
| 2024-02-27 09:00:00 | NQ | Futures | 19555.55 | 19558.26 | 19462.8 | 19516.23 | 83267.0 |
| 2024-02-27 10:00:00 | NQ | Futures | 19514.87 | 19562.06 | 19502.12 | 19540.91 | 95474.0 |
| 2024-02-27 11:00:00 | NQ | Futures | 19541.18 | 19543.89 | 19488.84 | 19527.62 | 59847.0 |
| 2024-02-27 12:00:00 | NQ | Futures | 19527.62 | 19537.65 | 19441.65 | 19448.97 | 59726.0 |
| 2024-02-27 13:00:00 | NQ | Futures | 19448.97 | 19496.43 | 19427.81 | 19493.99 | 56694.0 |
| 2024-02-27 14:00:00 | NQ | Futures | 19494.53 | 19559.08 | 19493.45 | 19556.09 | 53085.0 |
| 2024-02-27 15:00:00 | NQ | Futures | 19556.09 | 19560.71 | 19528.43 | 19545.79 | 58046.0 |
| 2024-02-27 16:00:00 | NQ | Futures | 19545.79 | 19553.38 | 19533.31 | 19540.09 | 11855.0 |
| 2024-02-27 18:00:00 | NQ | Futures | 19545.79 | 19548.23 | 19530.87 | 19532.23 | 2849.0 |
| 2024-02-27 19:00:00 | NQ | Futures | 19532.5 | 19537.92 | 19528.43 | 19529.25 | 3109.0 |
| 2024-02-27 20:00:00 | NQ | Futures | 19529.52 | 19542.53 | 19519.21 | 19537.65 | 3447.0 |
| 2024-02-27 21:00:00 | NQ | Futures | 19537.92 | 19543.35 | 19533.04 | 19538.74 | 1837.0 |
| 2024-02-27 22:00:00 | NQ | Futures | 19538.47 | 19545.25 | 19532.77 | 19544.7 | 1640.0 |
| 2024-02-27 23:00:00 | NQ | Futures | 19544.16 | 19544.16 | 19524.63 | 19527.62 | 1885.0 |
| 2024-02-27 00:00:00 | YM | Futures | 41994.3 | 42009.3 | 41975.0 | 41994.3 | 816.0 |
| 2024-02-27 01:00:00 | YM | Futures | 41994.3 | 41999.7 | 41985.7 | 41986.8 | 522.0 |
| 2024-02-27 02:00:00 | YM | Futures | 41990.0 | 42031.9 | 41988.9 | 42019.0 | 1183.0 |
| 2024-02-27 03:00:00 | YM | Futures | 42020.1 | 42042.6 | 41993.2 | 41995.4 | 1561.0 |
> showing 50 of 2,038 rows — these rows as CSV