PREVIEW / futures_1hour / 2024-07-31
file: by_date/futures_1hour/2024/2024-07-31.parquet size: 69 KB rows: 2,093
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-31 00:00:00 | ES | Futures | 5764.72 | 5767.34 | 5757.91 | 5761.31 | 11137.0 |
| 2024-07-31 01:00:00 | ES | Futures | 5761.58 | 5782.55 | 5759.74 | 5780.72 | 17198.0 |
| 2024-07-31 02:00:00 | ES | Futures | 5780.72 | 5788.06 | 5775.21 | 5785.96 | 22626.0 |
| 2024-07-31 03:00:00 | ES | Futures | 5785.7 | 5791.2 | 5779.93 | 5790.94 | 23744.0 |
| 2024-07-31 04:00:00 | ES | Futures | 5790.68 | 5797.76 | 5783.34 | 5792.51 | 30147.0 |
| 2024-07-31 05:00:00 | ES | Futures | 5792.77 | 5795.4 | 5788.58 | 5791.73 | 13526.0 |
| 2024-07-31 06:00:00 | ES | Futures | 5791.46 | 5797.49 | 5790.15 | 5796.71 | 15113.0 |
| 2024-07-31 07:00:00 | ES | Futures | 5796.97 | 5798.28 | 5791.46 | 5795.13 | 21804.0 |
| 2024-07-31 08:00:00 | ES | Futures | 5794.87 | 5813.49 | 5793.3 | 5811.13 | 49520.0 |
| 2024-07-31 09:00:00 | ES | Futures | 5810.86 | 5817.68 | 5797.76 | 5810.34 | 246815.0 |
| 2024-07-31 10:00:00 | ES | Futures | 5810.08 | 5837.6 | 5807.46 | 5829.74 | 287723.0 |
| 2024-07-31 11:00:00 | ES | Futures | 5829.74 | 5842.06 | 5826.59 | 5830.79 | 158127.0 |
| 2024-07-31 12:00:00 | ES | Futures | 5831.05 | 5835.51 | 5824.5 | 5825.28 | 105044.0 |
| 2024-07-31 13:00:00 | ES | Futures | 5825.55 | 5834.2 | 5809.03 | 5826.07 | 147406.0 |
| 2024-07-31 14:00:00 | ES | Futures | 5825.81 | 5860.41 | 5816.89 | 5855.69 | 224797.0 |
| 2024-07-31 15:00:00 | ES | Futures | 5855.69 | 5859.36 | 5815.32 | 5826.86 | 480565.0 |
| 2024-07-31 16:00:00 | ES | Futures | 5826.86 | 5854.38 | 5826.07 | 5841.27 | 108309.0 |
| 2024-07-31 18:00:00 | ES | Futures | 5845.99 | 5856.74 | 5843.9 | 5854.65 | 10260.0 |
| 2024-07-31 19:00:00 | ES | Futures | 5854.65 | 5861.99 | 5853.33 | 5859.36 | 8561.0 |
| 2024-07-31 20:00:00 | ES | Futures | 5859.63 | 5866.7 | 5852.81 | 5854.12 | 14652.0 |
| 2024-07-31 21:00:00 | ES | Futures | 5854.12 | 5858.32 | 5850.19 | 5855.17 | 12409.0 |
| 2024-07-31 22:00:00 | ES | Futures | 5855.17 | 5863.56 | 5852.29 | 5862.25 | 8737.0 |
| 2024-07-31 23:00:00 | ES | Futures | 5861.99 | 5865.39 | 5860.15 | 5864.61 | 6416.0 |
| 2024-07-31 00:00:00 | NQ | Futures | 20205.48 | 20218.95 | 20162.98 | 20174.86 | 7514.0 |
| 2024-07-31 01:00:00 | NQ | Futures | 20175.39 | 20300.52 | 20164.04 | 20291.02 | 10017.0 |
| 2024-07-31 02:00:00 | NQ | Futures | 20292.07 | 20299.73 | 20239.01 | 20287.58 | 11430.0 |
| 2024-07-31 03:00:00 | NQ | Futures | 20287.32 | 20313.45 | 20253.0 | 20296.03 | 10970.0 |
| 2024-07-31 04:00:00 | NQ | Futures | 20295.77 | 20323.48 | 20251.15 | 20288.64 | 13087.0 |
| 2024-07-31 05:00:00 | NQ | Futures | 20290.22 | 20306.59 | 20266.99 | 20273.86 | 6967.0 |
| 2024-07-31 06:00:00 | NQ | Futures | 20274.38 | 20319.79 | 20271.22 | 20318.21 | 6276.0 |
| 2024-07-31 07:00:00 | NQ | Futures | 20318.47 | 20338.0 | 20288.64 | 20329.29 | 11645.0 |
| 2024-07-31 08:00:00 | NQ | Futures | 20328.24 | 20437.26 | 20322.16 | 20429.34 | 25919.0 |
| 2024-07-31 09:00:00 | NQ | Futures | 20429.08 | 20500.35 | 20390.8 | 20475.54 | 120963.0 |
| 2024-07-31 10:00:00 | NQ | Futures | 20475.27 | 20584.3 | 20454.95 | 20539.69 | 107728.0 |
| 2024-07-31 11:00:00 | NQ | Futures | 20540.21 | 20607.53 | 20529.13 | 20560.81 | 61434.0 |
| 2024-07-31 12:00:00 | NQ | Futures | 20560.54 | 20581.13 | 20510.91 | 20515.4 | 38930.0 |
| 2024-07-31 13:00:00 | NQ | Futures | 20515.93 | 20569.25 | 20426.7 | 20513.29 | 47486.0 |
| 2024-07-31 14:00:00 | NQ | Futures | 20518.3 | 20664.81 | 20469.2 | 20648.18 | 69657.0 |
| 2024-07-31 15:00:00 | NQ | Futures | 20647.92 | 20667.98 | 20502.2 | 20586.94 | 117564.0 |
| 2024-07-31 16:00:00 | NQ | Futures | 20586.94 | 20746.91 | 20579.02 | 20676.96 | 35030.0 |
| 2024-07-31 18:00:00 | NQ | Futures | 20689.1 | 20742.95 | 20677.49 | 20731.6 | 7814.0 |
| 2024-07-31 19:00:00 | NQ | Futures | 20731.34 | 20787.3 | 20730.02 | 20774.89 | 7332.0 |
| 2024-07-31 20:00:00 | NQ | Futures | 20774.89 | 20819.77 | 20738.47 | 20744.8 | 10920.0 |
| 2024-07-31 21:00:00 | NQ | Futures | 20744.01 | 20766.45 | 20716.03 | 20736.35 | 8406.0 |
| 2024-07-31 22:00:00 | NQ | Futures | 20736.62 | 20775.95 | 20720.25 | 20767.77 | 6572.0 |
| 2024-07-31 23:00:00 | NQ | Futures | 20767.24 | 20790.47 | 20761.17 | 20785.19 | 3762.0 |
| 2024-07-31 00:00:00 | YM | Futures | 42959.0 | 42970.6 | 42930.6 | 42951.7 | 1024.0 |
| 2024-07-31 01:00:00 | YM | Futures | 42952.7 | 43063.0 | 42947.4 | 43047.3 | 1644.0 |
| 2024-07-31 02:00:00 | YM | Futures | 43048.3 | 43132.4 | 43035.7 | 43104.0 | 2439.0 |
| 2024-07-31 03:00:00 | YM | Futures | 43103.0 | 43160.7 | 43087.2 | 43160.7 | 2097.0 |
> showing 50 of 2,093 rows — these rows as CSV