PREVIEW / futures_1hour / 2024-09-02
file: by_date/futures_1hour/2024/2024-09-02.parquet size: 51 KB rows: 1,642
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-09-02 00:00:00 | ES | Futures | 5928.05 | 5928.31 | 5923.33 | 5928.05 | 2665.0 |
| 2024-09-02 01:00:00 | ES | Futures | 5928.31 | 5931.98 | 5927.26 | 5928.31 | 2816.0 |
| 2024-09-02 02:00:00 | ES | Futures | 5928.58 | 5929.89 | 5923.07 | 5924.38 | 4860.0 |
| 2024-09-02 03:00:00 | ES | Futures | 5924.64 | 5925.17 | 5912.32 | 5919.4 | 11967.0 |
| 2024-09-02 04:00:00 | ES | Futures | 5919.4 | 5928.84 | 5919.4 | 5925.69 | 9271.0 |
| 2024-09-02 05:00:00 | ES | Futures | 5925.69 | 5930.15 | 5924.38 | 5928.58 | 3962.0 |
| 2024-09-02 06:00:00 | ES | Futures | 5928.58 | 5929.62 | 5926.74 | 5928.58 | 2637.0 |
| 2024-09-02 07:00:00 | ES | Futures | 5928.84 | 5930.41 | 5927.0 | 5930.41 | 2742.0 |
| 2024-09-02 08:00:00 | ES | Futures | 5930.15 | 5933.56 | 5930.15 | 5932.51 | 4395.0 |
| 2024-09-02 09:00:00 | ES | Futures | 5932.51 | 5936.7 | 5930.41 | 5932.51 | 9716.0 |
| 2024-09-02 10:00:00 | ES | Futures | 5932.77 | 5942.47 | 5927.26 | 5941.42 | 15718.0 |
| 2024-09-02 11:00:00 | ES | Futures | 5941.42 | 5942.73 | 5936.7 | 5939.85 | 9829.0 |
| 2024-09-02 12:00:00 | ES | Futures | 5939.85 | 5942.47 | 5934.61 | 5940.64 | 6587.0 |
| 2024-09-02 18:00:00 | ES | Futures | 5940.64 | 5945.62 | 5933.29 | 5936.18 | 6201.0 |
| 2024-09-02 19:00:00 | ES | Futures | 5936.44 | 5936.44 | 5924.64 | 5929.36 | 7760.0 |
| 2024-09-02 20:00:00 | ES | Futures | 5929.36 | 5933.29 | 5927.0 | 5931.46 | 4269.0 |
| 2024-09-02 21:00:00 | ES | Futures | 5931.72 | 5936.44 | 5931.46 | 5934.34 | 3813.0 |
| 2024-09-02 22:00:00 | ES | Futures | 5934.61 | 5934.87 | 5925.17 | 5926.22 | 3944.0 |
| 2024-09-02 23:00:00 | ES | Futures | 5926.22 | 5928.05 | 5919.4 | 5928.05 | 7432.0 |
| 2024-09-02 00:00:00 | NQ | Futures | 20684.88 | 20685.4 | 20659.53 | 20676.96 | 1758.0 |
| 2024-09-02 01:00:00 | NQ | Futures | 20678.81 | 20694.38 | 20674.32 | 20679.6 | 1517.0 |
| 2024-09-02 02:00:00 | NQ | Futures | 20678.81 | 20687.52 | 20647.92 | 20658.74 | 2355.0 |
| 2024-09-02 03:00:00 | NQ | Futures | 20657.16 | 20657.69 | 20602.25 | 20628.12 | 5264.0 |
| 2024-09-02 04:00:00 | NQ | Futures | 20627.86 | 20683.03 | 20627.86 | 20664.29 | 5376.0 |
| 2024-09-02 05:00:00 | NQ | Futures | 20664.29 | 20689.89 | 20659.53 | 20685.93 | 2362.0 |
| 2024-09-02 06:00:00 | NQ | Futures | 20685.93 | 20695.17 | 20675.11 | 20690.95 | 2397.0 |
| 2024-09-02 07:00:00 | NQ | Futures | 20692.27 | 20704.68 | 20679.86 | 20700.72 | 2041.0 |
| 2024-09-02 08:00:00 | NQ | Futures | 20700.45 | 20721.57 | 20698.34 | 20704.41 | 3100.0 |
| 2024-09-02 09:00:00 | NQ | Futures | 20705.47 | 20744.27 | 20705.47 | 20716.82 | 7905.0 |
| 2024-09-02 10:00:00 | NQ | Futures | 20716.82 | 20764.86 | 20683.03 | 20757.21 | 13969.0 |
| 2024-09-02 11:00:00 | NQ | Futures | 20757.21 | 20770.41 | 20740.58 | 20751.93 | 8005.0 |
| 2024-09-02 12:00:00 | NQ | Futures | 20751.93 | 20759.32 | 20726.59 | 20745.86 | 3884.0 |
| 2024-09-02 18:00:00 | NQ | Futures | 20745.33 | 20783.87 | 20712.6 | 20735.03 | 4311.0 |
| 2024-09-02 19:00:00 | NQ | Futures | 20735.03 | 20736.62 | 20637.89 | 20675.11 | 6344.0 |
| 2024-09-02 20:00:00 | NQ | Futures | 20675.9 | 20694.38 | 20661.38 | 20687.25 | 3612.0 |
| 2024-09-02 21:00:00 | NQ | Futures | 20688.04 | 20705.2 | 20682.5 | 20690.95 | 2971.0 |
| 2024-09-02 22:00:00 | NQ | Futures | 20692.27 | 20694.38 | 20640.53 | 20645.81 | 3254.0 |
| 2024-09-02 23:00:00 | NQ | Futures | 20645.54 | 20655.57 | 20605.42 | 20655.31 | 5581.0 |
| 2024-09-02 00:00:00 | YM | Futures | 43730.2 | 43737.6 | 43712.4 | 43736.5 | 344.0 |
| 2024-09-02 01:00:00 | YM | Futures | 43737.6 | 43752.3 | 43729.2 | 43734.4 | 388.0 |
| 2024-09-02 02:00:00 | YM | Futures | 43734.4 | 43740.7 | 43702.9 | 43704.0 | 851.0 |
| 2024-09-02 03:00:00 | YM | Futures | 43706.1 | 43715.5 | 43613.6 | 43673.5 | 1858.0 |
| 2024-09-02 04:00:00 | YM | Futures | 43674.6 | 43720.8 | 43652.5 | 43711.3 | 1160.0 |
| 2024-09-02 05:00:00 | YM | Futures | 43711.3 | 43731.3 | 43698.7 | 43719.7 | 421.0 |
| 2024-09-02 06:00:00 | YM | Futures | 43721.8 | 43723.9 | 43690.3 | 43692.4 | 547.0 |
| 2024-09-02 07:00:00 | YM | Futures | 43693.5 | 43718.7 | 43693.5 | 43715.5 | 451.0 |
| 2024-09-02 08:00:00 | YM | Futures | 43717.6 | 43728.1 | 43708.2 | 43723.9 | 611.0 |
| 2024-09-02 09:00:00 | YM | Futures | 43723.9 | 43732.3 | 43699.8 | 43701.9 | 2056.0 |
| 2024-09-02 10:00:00 | YM | Futures | 43702.9 | 43764.9 | 43664.0 | 43753.4 | 2812.0 |
| 2024-09-02 11:00:00 | YM | Futures | 43753.4 | 43754.4 | 43717.6 | 43730.2 | 1802.0 |
> showing 50 of 1,642 rows — these rows as CSV