PREVIEW / futures_1hour / 2024-12-30
file: by_date/futures_1hour/2024/2024-12-30.parquet size: 67 KB rows: 2,030
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-30 00:00:00 | ES | Futures | 6171.27 | 6172.29 | 6164.86 | 6166.65 | 4285.0 |
| 2024-12-30 01:00:00 | ES | Futures | 6166.91 | 6174.09 | 6165.88 | 6167.68 | 4071.0 |
| 2024-12-30 02:00:00 | ES | Futures | 6167.42 | 6167.42 | 6156.65 | 6160.24 | 8296.0 |
| 2024-12-30 03:00:00 | ES | Futures | 6159.98 | 6168.45 | 6157.42 | 6165.11 | 11049.0 |
| 2024-12-30 04:00:00 | ES | Futures | 6165.11 | 6168.7 | 6162.29 | 6165.37 | 9238.0 |
| 2024-12-30 05:00:00 | ES | Futures | 6165.11 | 6168.45 | 6164.34 | 6166.14 | 5807.0 |
| 2024-12-30 06:00:00 | ES | Futures | 6166.39 | 6169.73 | 6165.11 | 6166.14 | 6723.0 |
| 2024-12-30 07:00:00 | ES | Futures | 6166.39 | 6166.65 | 6114.86 | 6122.81 | 42009.0 |
| 2024-12-30 08:00:00 | ES | Futures | 6122.81 | 6125.89 | 6096.92 | 6101.02 | 51885.0 |
| 2024-12-30 09:00:00 | ES | Futures | 6101.02 | 6112.04 | 6077.69 | 6078.46 | 223997.0 |
| 2024-12-30 10:00:00 | ES | Futures | 6078.46 | 6100.25 | 6069.23 | 6096.92 | 288881.0 |
| 2024-12-30 11:00:00 | ES | Futures | 6096.92 | 6123.32 | 6089.99 | 6120.25 | 161597.0 |
| 2024-12-30 12:00:00 | ES | Futures | 6120.25 | 6143.06 | 6118.71 | 6139.47 | 136813.0 |
| 2024-12-30 13:00:00 | ES | Futures | 6139.73 | 6146.14 | 6127.68 | 6139.73 | 118511.0 |
| 2024-12-30 14:00:00 | ES | Futures | 6139.73 | 6141.53 | 6121.27 | 6137.17 | 105040.0 |
| 2024-12-30 15:00:00 | ES | Futures | 6136.91 | 6140.5 | 6108.2 | 6109.99 | 214981.0 |
| 2024-12-30 16:00:00 | ES | Futures | 6110.25 | 6112.04 | 6099.74 | 6106.15 | 69161.0 |
| 2024-12-30 18:00:00 | ES | Futures | 6106.91 | 6106.91 | 6095.63 | 6105.12 | 7174.0 |
| 2024-12-30 19:00:00 | ES | Futures | 6105.38 | 6106.66 | 6099.22 | 6100.25 | 3193.0 |
| 2024-12-30 20:00:00 | ES | Futures | 6100.25 | 6112.81 | 6099.99 | 6111.79 | 4885.0 |
| 2024-12-30 21:00:00 | ES | Futures | 6111.79 | 6118.45 | 6109.99 | 6111.27 | 4917.0 |
| 2024-12-30 22:00:00 | ES | Futures | 6111.27 | 6112.3 | 6104.35 | 6108.2 | 4885.0 |
| 2024-12-30 23:00:00 | ES | Futures | 6108.2 | 6108.71 | 6101.53 | 6107.43 | 3514.0 |
| 2024-12-30 00:00:00 | NQ | Futures | 22325.6 | 22328.17 | 22285.45 | 22296.26 | 2758.0 |
| 2024-12-30 01:00:00 | NQ | Futures | 22294.97 | 22326.63 | 22283.65 | 22292.91 | 3655.0 |
| 2024-12-30 02:00:00 | NQ | Futures | 22292.14 | 22293.94 | 22248.14 | 22269.24 | 5478.0 |
| 2024-12-30 03:00:00 | NQ | Futures | 22268.21 | 22310.16 | 22255.34 | 22287.77 | 7345.0 |
| 2024-12-30 04:00:00 | NQ | Futures | 22288.54 | 22297.8 | 22257.4 | 22280.56 | 6059.0 |
| 2024-12-30 05:00:00 | NQ | Futures | 22279.53 | 22301.41 | 22275.67 | 22286.48 | 3147.0 |
| 2024-12-30 06:00:00 | NQ | Futures | 22286.99 | 22304.24 | 22277.73 | 22282.62 | 2849.0 |
| 2024-12-30 07:00:00 | NQ | Futures | 22283.91 | 22289.83 | 22071.85 | 22113.54 | 20561.0 |
| 2024-12-30 08:00:00 | NQ | Futures | 22113.54 | 22127.7 | 21986.16 | 22006.23 | 26098.0 |
| 2024-12-30 09:00:00 | NQ | Futures | 22007.0 | 22055.38 | 21908.69 | 21913.58 | 81300.0 |
| 2024-12-30 10:00:00 | NQ | Futures | 21913.58 | 22031.71 | 21877.56 | 22001.08 | 90047.0 |
| 2024-12-30 11:00:00 | NQ | Futures | 21999.54 | 22100.68 | 21967.88 | 22089.09 | 49481.0 |
| 2024-12-30 12:00:00 | NQ | Futures | 22089.87 | 22200.78 | 22077.77 | 22186.11 | 47829.0 |
| 2024-12-30 13:00:00 | NQ | Futures | 22186.11 | 22204.9 | 22119.2 | 22175.56 | 40819.0 |
| 2024-12-30 14:00:00 | NQ | Futures | 22175.56 | 22182.0 | 22106.85 | 22162.18 | 33187.0 |
| 2024-12-30 15:00:00 | NQ | Futures | 22161.41 | 22177.11 | 22037.63 | 22040.71 | 57357.0 |
| 2024-12-30 16:00:00 | NQ | Futures | 22041.23 | 22049.21 | 21977.92 | 22016.78 | 19025.0 |
| 2024-12-30 18:00:00 | NQ | Futures | 22018.84 | 22021.41 | 21970.72 | 22019.87 | 3518.0 |
| 2024-12-30 19:00:00 | NQ | Futures | 22020.64 | 22031.71 | 21992.59 | 21997.48 | 2882.0 |
| 2024-12-30 20:00:00 | NQ | Futures | 21998.25 | 22052.04 | 21996.71 | 22046.38 | 3236.0 |
| 2024-12-30 21:00:00 | NQ | Futures | 22046.12 | 22086.26 | 22044.32 | 22051.52 | 3588.0 |
| 2024-12-30 22:00:00 | NQ | Futures | 22050.49 | 22058.21 | 22013.69 | 22037.37 | 3509.0 |
| 2024-12-30 23:00:00 | NQ | Futures | 22037.11 | 22042.52 | 22004.69 | 22039.43 | 2792.0 |
| 2024-12-30 00:00:00 | YM | Futures | 44528.1 | 44536.3 | 44499.3 | 44515.8 | 460.0 |
| 2024-12-30 01:00:00 | YM | Futures | 44510.6 | 44552.8 | 44504.4 | 44508.6 | 673.0 |
| 2024-12-30 02:00:00 | YM | Futures | 44507.5 | 44508.6 | 44454.0 | 44472.5 | 1225.0 |
| 2024-12-30 03:00:00 | YM | Futures | 44473.6 | 44520.9 | 44453.0 | 44508.6 | 1595.0 |
> showing 50 of 2,030 rows — these rows as CSV