PREVIEW / futures_1hour / 2024-09-06
file: by_date/futures_1hour/2024/2024-09-06.parquet size: 57 KB rows: 1,640
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-06 00:00:00 | ES | Futures | 5771.8 | 5776.78 | 5770.23 | 5775.73 | 3504.0 |
| 2024-09-06 01:00:00 | ES | Futures | 5775.73 | 5775.73 | 5762.89 | 5771.54 | 6830.0 |
| 2024-09-06 02:00:00 | ES | Futures | 5771.8 | 5774.42 | 5762.36 | 5764.72 | 9994.0 |
| 2024-09-06 03:00:00 | ES | Futures | 5764.99 | 5764.99 | 5732.48 | 5745.32 | 47044.0 |
| 2024-09-06 04:00:00 | ES | Futures | 5745.59 | 5749.52 | 5736.15 | 5740.6 | 26433.0 |
| 2024-09-06 05:00:00 | ES | Futures | 5740.34 | 5747.68 | 5735.1 | 5745.85 | 18963.0 |
| 2024-09-06 06:00:00 | ES | Futures | 5745.85 | 5747.16 | 5739.29 | 5741.91 | 14092.0 |
| 2024-09-06 07:00:00 | ES | Futures | 5741.91 | 5751.35 | 5741.65 | 5750.57 | 24795.0 |
| 2024-09-06 08:00:00 | ES | Futures | 5750.57 | 5788.58 | 5736.15 | 5782.03 | 136299.0 |
| 2024-09-06 09:00:00 | ES | Futures | 5782.03 | 5801.69 | 5762.1 | 5762.89 | 264054.0 |
| 2024-09-06 10:00:00 | ES | Futures | 5763.15 | 5766.82 | 5696.04 | 5703.11 | 416213.0 |
| 2024-09-06 11:00:00 | ES | Futures | 5703.38 | 5737.72 | 5682.14 | 5685.55 | 402383.0 |
| 2024-09-06 12:00:00 | ES | Futures | 5685.55 | 5692.1 | 5675.85 | 5680.57 | 169666.0 |
| 2024-09-06 13:00:00 | ES | Futures | 5680.83 | 5700.49 | 5677.95 | 5685.81 | 140869.0 |
| 2024-09-06 14:00:00 | ES | Futures | 5686.07 | 5688.43 | 5673.49 | 5684.24 | 116725.0 |
| 2024-09-06 15:00:00 | ES | Futures | 5683.98 | 5699.18 | 5675.85 | 5684.24 | 306592.0 |
| 2024-09-06 16:00:00 | ES | Futures | 5684.5 | 5684.76 | 5656.45 | 5666.67 | 103155.0 |
| 2024-09-06 00:00:00 | NQ | Futures | 19926.46 | 19955.23 | 19917.48 | 19952.33 | 1908.0 |
| 2024-09-06 01:00:00 | NQ | Futures | 19952.59 | 19952.59 | 19883.95 | 19929.36 | 3795.0 |
| 2024-09-06 02:00:00 | NQ | Futures | 19928.04 | 19942.29 | 19880.79 | 19896.63 | 5364.0 |
| 2024-09-06 03:00:00 | NQ | Futures | 19898.47 | 19899.26 | 19754.07 | 19829.31 | 15324.0 |
| 2024-09-06 04:00:00 | NQ | Futures | 19828.78 | 19843.3 | 19756.98 | 19774.4 | 10799.0 |
| 2024-09-06 05:00:00 | NQ | Futures | 19772.29 | 19815.58 | 19749.06 | 19809.77 | 7026.0 |
| 2024-09-06 06:00:00 | NQ | Futures | 19809.25 | 19814.0 | 19769.39 | 19788.39 | 5309.0 |
| 2024-09-06 07:00:00 | NQ | Futures | 19786.81 | 19838.29 | 19786.81 | 19833.27 | 7854.0 |
| 2024-09-06 08:00:00 | NQ | Futures | 19833.8 | 20018.59 | 19767.01 | 19994.3 | 47052.0 |
| 2024-09-06 09:00:00 | NQ | Futures | 19992.19 | 20033.37 | 19789.71 | 19794.2 | 101513.0 |
| 2024-09-06 10:00:00 | NQ | Futures | 19794.2 | 19838.81 | 19539.98 | 19570.34 | 122012.0 |
| 2024-09-06 11:00:00 | NQ | Futures | 19571.13 | 19686.76 | 19477.42 | 19494.58 | 103286.0 |
| 2024-09-06 12:00:00 | NQ | Futures | 19494.05 | 19532.59 | 19461.05 | 19482.7 | 50476.0 |
| 2024-09-06 13:00:00 | NQ | Futures | 19482.7 | 19583.01 | 19470.82 | 19510.95 | 54704.0 |
| 2024-09-06 14:00:00 | NQ | Futures | 19512.0 | 19528.11 | 19463.17 | 19515.17 | 39855.0 |
| 2024-09-06 15:00:00 | NQ | Futures | 19514.38 | 19569.29 | 19467.39 | 19490.88 | 81264.0 |
| 2024-09-06 16:00:00 | NQ | Futures | 19490.88 | 19493.0 | 19365.49 | 19405.35 | 24948.0 |
| 2024-09-06 00:00:00 | YM | Futures | 42923.3 | 42939.0 | 42914.9 | 42931.7 | 434.0 |
| 2024-09-06 01:00:00 | YM | Futures | 42930.6 | 42933.8 | 42870.7 | 42915.9 | 660.0 |
| 2024-09-06 02:00:00 | YM | Futures | 42912.8 | 42931.7 | 42860.2 | 42866.5 | 1142.0 |
| 2024-09-06 03:00:00 | YM | Futures | 42863.4 | 42868.6 | 42677.4 | 42748.9 | 4974.0 |
| 2024-09-06 04:00:00 | YM | Futures | 42751.0 | 42801.4 | 42714.2 | 42743.6 | 3189.0 |
| 2024-09-06 05:00:00 | YM | Futures | 42739.4 | 42776.2 | 42708.9 | 42770.9 | 1924.0 |
| 2024-09-06 06:00:00 | YM | Futures | 42769.9 | 42780.4 | 42728.9 | 42739.4 | 1532.0 |
| 2024-09-06 07:00:00 | YM | Futures | 42738.4 | 42766.7 | 42721.5 | 42760.4 | 2130.0 |
| 2024-09-06 08:00:00 | YM | Futures | 42759.4 | 42969.5 | 42686.9 | 42896.0 | 12711.0 |
| 2024-09-06 09:00:00 | YM | Futures | 42896.0 | 43163.9 | 42872.8 | 43033.6 | 29844.0 |
| 2024-09-06 10:00:00 | YM | Futures | 43033.6 | 43046.2 | 42558.7 | 42588.1 | 35840.0 |
| 2024-09-06 11:00:00 | YM | Futures | 42588.1 | 42871.8 | 42449.4 | 42482.0 | 34461.0 |
| 2024-09-06 12:00:00 | YM | Futures | 42479.9 | 42539.8 | 42412.6 | 42471.5 | 14836.0 |
| 2024-09-06 13:00:00 | YM | Futures | 42472.5 | 42571.3 | 42432.6 | 42496.7 | 12945.0 |
| 2024-09-06 14:00:00 | YM | Futures | 42498.8 | 42514.5 | 42391.6 | 42478.8 | 9697.0 |
| 2024-09-06 15:00:00 | YM | Futures | 42475.7 | 42557.6 | 42416.8 | 42465.2 | 18064.0 |
> showing 50 of 1,640 rows — these rows as CSV