PREVIEW / futures_1hour / 2024-07-18
file: by_date/futures_1hour/2024/2024-07-18.parquet size: 67 KB rows: 2,070
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-07-18 00:00:00 | ES | Futures | 5925.43 | 5926.48 | 5922.28 | 5924.38 | 3340.0 |
| 2024-07-18 01:00:00 | ES | Futures | 5924.64 | 5926.48 | 5923.07 | 5925.95 | 5143.0 |
| 2024-07-18 02:00:00 | ES | Futures | 5925.95 | 5939.59 | 5922.02 | 5936.96 | 22714.0 |
| 2024-07-18 03:00:00 | ES | Futures | 5937.23 | 5937.49 | 5914.42 | 5924.12 | 26956.0 |
| 2024-07-18 04:00:00 | ES | Futures | 5924.38 | 5931.46 | 5920.19 | 5931.46 | 19429.0 |
| 2024-07-18 05:00:00 | ES | Futures | 5931.72 | 5931.98 | 5919.4 | 5921.23 | 13823.0 |
| 2024-07-18 06:00:00 | ES | Futures | 5920.97 | 5922.02 | 5912.58 | 5921.23 | 16945.0 |
| 2024-07-18 07:00:00 | ES | Futures | 5921.23 | 5924.64 | 5918.35 | 5924.12 | 11847.0 |
| 2024-07-18 08:00:00 | ES | Futures | 5924.12 | 5931.2 | 5919.92 | 5929.89 | 39490.0 |
| 2024-07-18 09:00:00 | ES | Futures | 5929.89 | 5933.56 | 5917.83 | 5929.89 | 203866.0 |
| 2024-07-18 10:00:00 | ES | Futures | 5929.89 | 5937.23 | 5896.07 | 5909.44 | 435994.0 |
| 2024-07-18 11:00:00 | ES | Futures | 5909.7 | 5912.32 | 5865.66 | 5868.02 | 402869.0 |
| 2024-07-18 12:00:00 | ES | Futures | 5868.02 | 5882.17 | 5861.99 | 5881.91 | 234594.0 |
| 2024-07-18 13:00:00 | ES | Futures | 5882.17 | 5888.73 | 5873.0 | 5875.36 | 177006.0 |
| 2024-07-18 14:00:00 | ES | Futures | 5875.62 | 5876.14 | 5851.5 | 5861.72 | 224881.0 |
| 2024-07-18 15:00:00 | ES | Futures | 5861.72 | 5877.72 | 5841.27 | 5865.39 | 467212.0 |
| 2024-07-18 16:00:00 | ES | Futures | 5865.39 | 5875.09 | 5863.3 | 5872.47 | 91000.0 |
| 2024-07-18 18:00:00 | ES | Futures | 5875.09 | 5878.76 | 5872.73 | 5876.4 | 8866.0 |
| 2024-07-18 19:00:00 | ES | Futures | 5876.4 | 5877.98 | 5873.26 | 5874.31 | 2710.0 |
| 2024-07-18 20:00:00 | ES | Futures | 5874.31 | 5878.24 | 5871.69 | 5874.57 | 7474.0 |
| 2024-07-18 21:00:00 | ES | Futures | 5874.57 | 5877.98 | 5873.52 | 5875.88 | 6523.0 |
| 2024-07-18 22:00:00 | ES | Futures | 5875.88 | 5876.67 | 5873.0 | 5875.88 | 5273.0 |
| 2024-07-18 23:00:00 | ES | Futures | 5875.88 | 5876.93 | 5874.31 | 5876.14 | 3702.0 |
| 2024-07-18 00:00:00 | NQ | Futures | 21172.72 | 21179.84 | 21156.61 | 21174.56 | 2581.0 |
| 2024-07-18 01:00:00 | NQ | Futures | 21174.3 | 21201.23 | 21166.64 | 21198.32 | 3631.0 |
| 2024-07-18 02:00:00 | NQ | Futures | 21198.32 | 21290.19 | 21179.84 | 21266.69 | 17306.0 |
| 2024-07-18 03:00:00 | NQ | Futures | 21268.01 | 21270.92 | 21156.88 | 21223.14 | 18635.0 |
| 2024-07-18 04:00:00 | NQ | Futures | 21223.14 | 21251.38 | 21181.43 | 21250.86 | 12098.0 |
| 2024-07-18 05:00:00 | NQ | Futures | 21250.33 | 21254.55 | 21180.64 | 21184.33 | 10179.0 |
| 2024-07-18 06:00:00 | NQ | Futures | 21183.8 | 21203.87 | 21138.13 | 21195.42 | 12958.0 |
| 2024-07-18 07:00:00 | NQ | Futures | 21196.21 | 21215.48 | 21180.64 | 21211.52 | 8717.0 |
| 2024-07-18 08:00:00 | NQ | Futures | 21211.26 | 21274.88 | 21196.21 | 21271.71 | 19057.0 |
| 2024-07-18 09:00:00 | NQ | Futures | 21271.45 | 21290.19 | 21139.45 | 21190.14 | 111910.0 |
| 2024-07-18 10:00:00 | NQ | Futures | 21190.4 | 21231.58 | 21005.62 | 21107.78 | 162348.0 |
| 2024-07-18 11:00:00 | NQ | Futures | 21108.04 | 21123.62 | 20891.58 | 20904.25 | 130613.0 |
| 2024-07-18 12:00:00 | NQ | Futures | 20904.77 | 21028.05 | 20878.9 | 21027.26 | 84815.0 |
| 2024-07-18 13:00:00 | NQ | Futures | 21027.26 | 21061.84 | 20965.49 | 20984.76 | 76751.0 |
| 2024-07-18 14:00:00 | NQ | Futures | 20984.76 | 21004.82 | 20907.94 | 20956.78 | 84552.0 |
| 2024-07-18 15:00:00 | NQ | Futures | 20956.25 | 21077.42 | 20863.86 | 21004.03 | 140655.0 |
| 2024-07-18 16:00:00 | NQ | Futures | 21004.3 | 21069.76 | 20976.31 | 21049.7 | 27418.0 |
| 2024-07-18 18:00:00 | NQ | Futures | 21071.08 | 21094.05 | 21051.28 | 21071.35 | 8176.0 |
| 2024-07-18 19:00:00 | NQ | Futures | 21071.88 | 21081.91 | 21058.94 | 21061.32 | 2551.0 |
| 2024-07-18 20:00:00 | NQ | Futures | 21061.32 | 21081.64 | 21050.23 | 21062.9 | 4990.0 |
| 2024-07-18 21:00:00 | NQ | Futures | 21063.69 | 21079.0 | 21055.51 | 21063.16 | 4522.0 |
| 2024-07-18 22:00:00 | NQ | Futures | 21063.69 | 21075.04 | 21050.76 | 21068.71 | 3718.0 |
| 2024-07-18 23:00:00 | NQ | Futures | 21068.44 | 21075.04 | 21061.05 | 21071.88 | 1596.0 |
| 2024-07-18 00:00:00 | YM | Futures | 43706.1 | 43710.3 | 43674.6 | 43686.1 | 700.0 |
| 2024-07-18 01:00:00 | YM | Futures | 43685.1 | 43687.2 | 43661.9 | 43665.1 | 962.0 |
| 2024-07-18 02:00:00 | YM | Futures | 43664.0 | 43680.9 | 43638.8 | 43675.6 | 3341.0 |
| 2024-07-18 03:00:00 | YM | Futures | 43675.6 | 43678.8 | 43536.9 | 43580.0 | 4525.0 |
> showing 50 of 2,070 rows — these rows as CSV