PREVIEW / futures_1hour / 2024-08-22
file: by_date/futures_1hour/2024/2024-08-22.parquet size: 67 KB rows: 2,061
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-08-22 00:00:00 | ES | Futures | 5907.86 | 5910.75 | 5906.82 | 5910.75 | 2571.0 |
| 2024-08-22 01:00:00 | ES | Futures | 5910.49 | 5912.85 | 5910.22 | 5911.8 | 2402.0 |
| 2024-08-22 02:00:00 | ES | Futures | 5911.8 | 5917.04 | 5910.75 | 5916.52 | 3770.0 |
| 2024-08-22 03:00:00 | ES | Futures | 5916.52 | 5920.19 | 5914.68 | 5918.61 | 7281.0 |
| 2024-08-22 04:00:00 | ES | Futures | 5918.35 | 5921.76 | 5915.73 | 5920.19 | 5653.0 |
| 2024-08-22 05:00:00 | ES | Futures | 5920.19 | 5924.12 | 5918.35 | 5918.88 | 4593.0 |
| 2024-08-22 06:00:00 | ES | Futures | 5918.88 | 5925.17 | 5918.09 | 5924.91 | 5474.0 |
| 2024-08-22 07:00:00 | ES | Futures | 5924.64 | 5930.15 | 5924.12 | 5928.84 | 11538.0 |
| 2024-08-22 08:00:00 | ES | Futures | 5928.58 | 5931.46 | 5920.19 | 5930.41 | 22828.0 |
| 2024-08-22 09:00:00 | ES | Futures | 5930.41 | 5940.9 | 5923.59 | 5931.2 | 127710.0 |
| 2024-08-22 10:00:00 | ES | Futures | 5931.72 | 5933.03 | 5908.39 | 5912.32 | 173747.0 |
| 2024-08-22 11:00:00 | ES | Futures | 5912.32 | 5919.92 | 5875.88 | 5882.96 | 192889.0 |
| 2024-08-22 12:00:00 | ES | Futures | 5882.96 | 5907.6 | 5877.98 | 5881.65 | 157600.0 |
| 2024-08-22 13:00:00 | ES | Futures | 5881.65 | 5890.3 | 5856.48 | 5859.89 | 160916.0 |
| 2024-08-22 14:00:00 | ES | Futures | 5859.63 | 5878.5 | 5856.74 | 5864.61 | 120312.0 |
| 2024-08-22 15:00:00 | ES | Futures | 5864.87 | 5877.45 | 5854.38 | 5867.49 | 247556.0 |
| 2024-08-22 16:00:00 | ES | Futures | 5867.49 | 5874.83 | 5862.25 | 5870.9 | 61586.0 |
| 2024-08-22 18:00:00 | ES | Futures | 5870.11 | 5876.93 | 5870.11 | 5876.14 | 3439.0 |
| 2024-08-22 19:00:00 | ES | Futures | 5876.14 | 5877.45 | 5874.05 | 5877.19 | 2604.0 |
| 2024-08-22 20:00:00 | ES | Futures | 5877.45 | 5880.08 | 5875.36 | 5876.4 | 5611.0 |
| 2024-08-22 21:00:00 | ES | Futures | 5876.4 | 5880.34 | 5875.62 | 5877.72 | 4246.0 |
| 2024-08-22 22:00:00 | ES | Futures | 5877.98 | 5881.39 | 5876.67 | 5880.6 | 3347.0 |
| 2024-08-22 23:00:00 | ES | Futures | 5880.86 | 5885.58 | 5880.34 | 5883.22 | 3429.0 |
| 2024-08-22 00:00:00 | NQ | Futures | 20994.53 | 21015.38 | 20988.19 | 21013.27 | 2058.0 |
| 2024-08-22 01:00:00 | NQ | Futures | 21013.8 | 21021.45 | 21005.09 | 21005.62 | 2069.0 |
| 2024-08-22 02:00:00 | NQ | Futures | 21005.62 | 21033.33 | 20999.81 | 21030.43 | 2682.0 |
| 2024-08-22 03:00:00 | NQ | Futures | 21030.43 | 21044.69 | 21011.42 | 21031.49 | 4166.0 |
| 2024-08-22 04:00:00 | NQ | Futures | 21031.49 | 21038.35 | 21009.31 | 21030.69 | 3608.0 |
| 2024-08-22 05:00:00 | NQ | Futures | 21031.75 | 21051.28 | 21026.47 | 21029.9 | 3080.0 |
| 2024-08-22 06:00:00 | NQ | Futures | 21030.17 | 21074.25 | 21026.47 | 21072.14 | 4653.0 |
| 2024-08-22 07:00:00 | NQ | Futures | 21072.14 | 21105.14 | 21067.39 | 21094.05 | 8204.0 |
| 2024-08-22 08:00:00 | NQ | Futures | 21094.05 | 21112.79 | 21052.08 | 21101.97 | 15796.0 |
| 2024-08-22 09:00:00 | NQ | Futures | 21102.23 | 21145.26 | 21059.73 | 21093.26 | 70823.0 |
| 2024-08-22 10:00:00 | NQ | Futures | 21094.84 | 21103.55 | 20964.96 | 20990.04 | 96228.0 |
| 2024-08-22 11:00:00 | NQ | Futures | 20990.3 | 21029.37 | 20763.81 | 20813.44 | 95716.0 |
| 2024-08-22 12:00:00 | NQ | Futures | 20813.44 | 20940.94 | 20793.37 | 20809.21 | 75229.0 |
| 2024-08-22 13:00:00 | NQ | Futures | 20809.74 | 20842.74 | 20681.97 | 20704.68 | 68313.0 |
| 2024-08-22 14:00:00 | NQ | Futures | 20704.68 | 20775.42 | 20679.33 | 20707.05 | 52973.0 |
| 2024-08-22 15:00:00 | NQ | Futures | 20707.32 | 20765.92 | 20634.98 | 20680.92 | 83968.0 |
| 2024-08-22 16:00:00 | NQ | Futures | 20680.92 | 20727.91 | 20661.12 | 20709.16 | 17127.0 |
| 2024-08-22 18:00:00 | NQ | Futures | 20718.93 | 20735.56 | 20709.43 | 20729.75 | 3014.0 |
| 2024-08-22 19:00:00 | NQ | Futures | 20730.28 | 20738.2 | 20717.08 | 20736.62 | 2470.0 |
| 2024-08-22 20:00:00 | NQ | Futures | 20737.15 | 20758.53 | 20730.28 | 20735.83 | 3719.0 |
| 2024-08-22 21:00:00 | NQ | Futures | 20734.77 | 20758.53 | 20732.66 | 20743.48 | 2433.0 |
| 2024-08-22 22:00:00 | NQ | Futures | 20744.27 | 20756.94 | 20738.73 | 20749.02 | 2000.0 |
| 2024-08-22 23:00:00 | NQ | Futures | 20749.82 | 20780.97 | 20744.8 | 20766.45 | 3039.0 |
| 2024-08-22 00:00:00 | YM | Futures | 43050.4 | 43056.7 | 43041.0 | 43052.5 | 300.0 |
| 2024-08-22 01:00:00 | YM | Futures | 43052.5 | 43070.4 | 43048.3 | 43068.3 | 470.0 |
| 2024-08-22 02:00:00 | YM | Futures | 43068.3 | 43095.6 | 43057.8 | 43091.4 | 672.0 |
| 2024-08-22 03:00:00 | YM | Futures | 43090.3 | 43131.3 | 43087.2 | 43119.8 | 1647.0 |
> showing 50 of 2,061 rows — these rows as CSV