PREVIEW / futures_1hour / 2024-12-31
file: by_date/futures_1hour/2024/2024-12-31.parquet size: 47 KB rows: 1,315
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-12-31 00:00:00 | ES | Futures | 6107.43 | 6108.97 | 6104.09 | 6108.2 | 2629.0 |
| 2024-12-31 01:00:00 | ES | Futures | 6108.2 | 6108.2 | 6100.25 | 6103.58 | 2890.0 |
| 2024-12-31 02:00:00 | ES | Futures | 6103.33 | 6109.48 | 6102.04 | 6105.89 | 4328.0 |
| 2024-12-31 03:00:00 | ES | Futures | 6106.15 | 6108.71 | 6101.02 | 6105.12 | 6794.0 |
| 2024-12-31 04:00:00 | ES | Futures | 6105.38 | 6130.24 | 6103.84 | 6127.42 | 13661.0 |
| 2024-12-31 05:00:00 | ES | Futures | 6127.42 | 6132.3 | 6125.12 | 6129.22 | 5394.0 |
| 2024-12-31 06:00:00 | ES | Futures | 6129.48 | 6132.81 | 6125.89 | 6130.76 | 7973.0 |
| 2024-12-31 07:00:00 | ES | Futures | 6130.76 | 6135.89 | 6123.58 | 6124.6 | 15482.0 |
| 2024-12-31 08:00:00 | ES | Futures | 6124.35 | 6132.55 | 6120.25 | 6125.37 | 18778.0 |
| 2024-12-31 09:00:00 | ES | Futures | 6125.63 | 6132.55 | 6111.02 | 6126.14 | 128750.0 |
| 2024-12-31 10:00:00 | ES | Futures | 6125.89 | 6132.81 | 6106.66 | 6112.04 | 170225.0 |
| 2024-12-31 11:00:00 | ES | Futures | 6112.04 | 6113.32 | 6089.74 | 6094.86 | 145835.0 |
| 2024-12-31 12:00:00 | ES | Futures | 6094.86 | 6098.71 | 6072.82 | 6097.17 | 139548.0 |
| 2024-12-31 13:00:00 | ES | Futures | 6096.92 | 6102.04 | 6071.53 | 6077.69 | 132056.0 |
| 2024-12-31 14:00:00 | ES | Futures | 6077.94 | 6090.25 | 6068.2 | 6088.46 | 125425.0 |
| 2024-12-31 15:00:00 | ES | Futures | 6088.46 | 6100.76 | 6074.61 | 6086.4 | 261261.0 |
| 2024-12-31 16:00:00 | ES | Futures | 6086.66 | 6092.81 | 6082.05 | 6089.74 | 55269.0 |
| 2024-12-31 00:00:00 | NQ | Futures | 22039.43 | 22047.4 | 22015.49 | 22036.6 | 2699.0 |
| 2024-12-31 01:00:00 | NQ | Futures | 22036.08 | 22038.65 | 21997.99 | 22008.03 | 2375.0 |
| 2024-12-31 02:00:00 | NQ | Futures | 22008.55 | 22038.65 | 22001.08 | 22022.7 | 4011.0 |
| 2024-12-31 03:00:00 | NQ | Futures | 22023.73 | 22034.28 | 21987.19 | 22013.18 | 5317.0 |
| 2024-12-31 04:00:00 | NQ | Futures | 22014.21 | 22143.14 | 22007.26 | 22120.49 | 9295.0 |
| 2024-12-31 05:00:00 | NQ | Futures | 22119.72 | 22142.11 | 22107.11 | 22128.21 | 4128.0 |
| 2024-12-31 06:00:00 | NQ | Futures | 22129.24 | 22151.63 | 22108.14 | 22133.1 | 4765.0 |
| 2024-12-31 07:00:00 | NQ | Futures | 22133.36 | 22157.29 | 22090.9 | 22095.79 | 7097.0 |
| 2024-12-31 08:00:00 | NQ | Futures | 22096.82 | 22131.3 | 22065.93 | 22091.41 | 11550.0 |
| 2024-12-31 09:00:00 | NQ | Futures | 22092.18 | 22119.98 | 21995.94 | 22064.9 | 56222.0 |
| 2024-12-31 10:00:00 | NQ | Futures | 22063.87 | 22099.39 | 21960.42 | 22007.52 | 67552.0 |
| 2024-12-31 11:00:00 | NQ | Futures | 22007.52 | 22012.41 | 21912.56 | 21956.82 | 49703.0 |
| 2024-12-31 12:00:00 | NQ | Futures | 21956.56 | 21971.23 | 21831.23 | 21940.09 | 48647.0 |
| 2024-12-31 13:00:00 | NQ | Futures | 21939.58 | 21964.54 | 21827.63 | 21843.59 | 45387.0 |
| 2024-12-31 14:00:00 | NQ | Futures | 21844.1 | 21900.2 | 21804.47 | 21893.77 | 41488.0 |
| 2024-12-31 15:00:00 | NQ | Futures | 21893.25 | 21942.41 | 21811.68 | 21843.84 | 75479.0 |
| 2024-12-31 16:00:00 | NQ | Futures | 21844.62 | 21875.24 | 21820.17 | 21858.25 | 13860.0 |
| 2024-12-31 00:00:00 | YM | Futures | 44177.1 | 44183.3 | 44159.6 | 44182.3 | 261.0 |
| 2024-12-31 01:00:00 | YM | Futures | 44180.2 | 44180.2 | 44132.9 | 44159.6 | 520.0 |
| 2024-12-31 02:00:00 | YM | Futures | 44157.6 | 44190.5 | 44146.3 | 44159.6 | 842.0 |
| 2024-12-31 03:00:00 | YM | Futures | 44163.7 | 44187.4 | 44146.3 | 44174.0 | 809.0 |
| 2024-12-31 04:00:00 | YM | Futures | 44174.0 | 44275.9 | 44161.7 | 44269.8 | 2340.0 |
| 2024-12-31 05:00:00 | YM | Futures | 44270.8 | 44302.7 | 44254.3 | 44280.1 | 909.0 |
| 2024-12-31 06:00:00 | YM | Futures | 44282.1 | 44295.5 | 44266.7 | 44287.3 | 869.0 |
| 2024-12-31 07:00:00 | YM | Futures | 44284.2 | 44323.3 | 44253.3 | 44259.5 | 1574.0 |
| 2024-12-31 08:00:00 | YM | Futures | 44261.5 | 44308.9 | 44245.1 | 44263.6 | 2186.0 |
| 2024-12-31 09:00:00 | YM | Futures | 44261.5 | 44320.2 | 44204.9 | 44317.1 | 12848.0 |
| 2024-12-31 10:00:00 | YM | Futures | 44315.1 | 44361.4 | 44192.6 | 44207.0 | 16567.0 |
| 2024-12-31 11:00:00 | YM | Futures | 44208.0 | 44217.3 | 44058.8 | 44075.2 | 12953.0 |
| 2024-12-31 12:00:00 | YM | Futures | 44075.2 | 44149.3 | 43980.5 | 44144.2 | 7164.0 |
| 2024-12-31 13:00:00 | YM | Futures | 44142.1 | 44158.6 | 43973.3 | 44046.4 | 6626.0 |
| 2024-12-31 14:00:00 | YM | Futures | 44047.4 | 44122.6 | 43980.5 | 44092.7 | 7070.0 |
| 2024-12-31 15:00:00 | YM | Futures | 44093.8 | 44168.9 | 44027.9 | 44124.6 | 13772.0 |
> showing 50 of 1,315 rows — these rows as CSV