PREVIEW / futures_1hour / 2024-01-24
file: by_date/futures_1hour/2024/2024-01-24.parquet size: 69 KB rows: 2,100
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-01-24 00:00:00 | ES | Futures | 5270.28 | 5273.78 | 5269.75 | 5271.9 | 3875.0 |
| 2024-01-24 01:00:00 | ES | Futures | 5271.9 | 5275.66 | 5271.63 | 5273.78 | 8634.0 |
| 2024-01-24 02:00:00 | ES | Futures | 5273.78 | 5280.22 | 5272.97 | 5278.07 | 15179.0 |
| 2024-01-24 03:00:00 | ES | Futures | 5278.34 | 5280.49 | 5277.54 | 5279.95 | 19390.0 |
| 2024-01-24 04:00:00 | ES | Futures | 5279.69 | 5282.64 | 5278.34 | 5282.1 | 17373.0 |
| 2024-01-24 05:00:00 | ES | Futures | 5282.37 | 5283.45 | 5277.81 | 5280.76 | 12173.0 |
| 2024-01-24 06:00:00 | ES | Futures | 5280.76 | 5283.71 | 5280.49 | 5281.57 | 12517.0 |
| 2024-01-24 07:00:00 | ES | Futures | 5281.3 | 5283.71 | 5280.22 | 5282.1 | 14962.0 |
| 2024-01-24 08:00:00 | ES | Futures | 5282.1 | 5290.7 | 5282.1 | 5285.59 | 39386.0 |
| 2024-01-24 09:00:00 | ES | Futures | 5285.59 | 5289.89 | 5280.22 | 5281.83 | 162973.0 |
| 2024-01-24 10:00:00 | ES | Futures | 5281.83 | 5298.49 | 5274.05 | 5291.23 | 229547.0 |
| 2024-01-24 11:00:00 | ES | Futures | 5290.97 | 5295.8 | 5285.86 | 5294.73 | 153271.0 |
| 2024-01-24 12:00:00 | ES | Futures | 5294.73 | 5300.1 | 5289.62 | 5299.56 | 102685.0 |
| 2024-01-24 13:00:00 | ES | Futures | 5299.56 | 5299.56 | 5279.69 | 5283.98 | 166839.0 |
| 2024-01-24 14:00:00 | ES | Futures | 5283.98 | 5284.79 | 5269.48 | 5275.66 | 166498.0 |
| 2024-01-24 15:00:00 | ES | Futures | 5275.93 | 5279.69 | 5259.27 | 5263.03 | 273293.0 |
| 2024-01-24 16:00:00 | ES | Futures | 5263.03 | 5266.26 | 5252.56 | 5265.99 | 77870.0 |
| 2024-01-24 18:00:00 | ES | Futures | 5263.84 | 5265.18 | 5261.42 | 5263.84 | 6734.0 |
| 2024-01-24 19:00:00 | ES | Futures | 5263.57 | 5264.38 | 5260.08 | 5264.11 | 6215.0 |
| 2024-01-24 20:00:00 | ES | Futures | 5264.38 | 5266.52 | 5257.39 | 5261.15 | 10044.0 |
| 2024-01-24 21:00:00 | ES | Futures | 5261.15 | 5263.84 | 5257.12 | 5259.54 | 5871.0 |
| 2024-01-24 22:00:00 | ES | Futures | 5259.54 | 5260.88 | 5257.93 | 5260.35 | 3937.0 |
| 2024-01-24 23:00:00 | ES | Futures | 5260.35 | 5263.3 | 5260.08 | 5261.69 | 2997.0 |
| 2024-01-24 00:00:00 | NQ | Futures | 19087.18 | 19103.18 | 19082.57 | 19096.4 | 3428.0 |
| 2024-01-24 01:00:00 | NQ | Futures | 19096.4 | 19127.05 | 19093.69 | 19114.84 | 7170.0 |
| 2024-01-24 02:00:00 | NQ | Futures | 19114.84 | 19137.9 | 19111.32 | 19128.67 | 10667.0 |
| 2024-01-24 03:00:00 | NQ | Futures | 19128.67 | 19150.64 | 19123.25 | 19146.03 | 10974.0 |
| 2024-01-24 04:00:00 | NQ | Futures | 19146.03 | 19164.74 | 19139.52 | 19159.05 | 8901.0 |
| 2024-01-24 05:00:00 | NQ | Futures | 19159.32 | 19163.39 | 19138.71 | 19148.2 | 6526.0 |
| 2024-01-24 06:00:00 | NQ | Futures | 19148.2 | 19160.41 | 19139.25 | 19142.51 | 7064.0 |
| 2024-01-24 07:00:00 | NQ | Futures | 19141.96 | 19170.17 | 19137.62 | 19161.22 | 9254.0 |
| 2024-01-24 08:00:00 | NQ | Futures | 19161.22 | 19192.95 | 19153.08 | 19162.58 | 20949.0 |
| 2024-01-24 09:00:00 | NQ | Futures | 19162.58 | 19196.48 | 19133.56 | 19168.54 | 86674.0 |
| 2024-01-24 10:00:00 | NQ | Futures | 19168.27 | 19271.87 | 19134.1 | 19240.14 | 112909.0 |
| 2024-01-24 11:00:00 | NQ | Futures | 19240.41 | 19260.21 | 19188.61 | 19255.06 | 77688.0 |
| 2024-01-24 12:00:00 | NQ | Futures | 19255.33 | 19302.79 | 19239.33 | 19293.03 | 62373.0 |
| 2024-01-24 13:00:00 | NQ | Futures | 19293.3 | 19294.11 | 19197.56 | 19217.36 | 78172.0 |
| 2024-01-24 14:00:00 | NQ | Futures | 19217.36 | 19221.97 | 19127.59 | 19162.58 | 73575.0 |
| 2024-01-24 15:00:00 | NQ | Futures | 19162.85 | 19183.19 | 19097.21 | 19119.72 | 89057.0 |
| 2024-01-24 16:00:00 | NQ | Futures | 19120.0 | 19131.66 | 19060.06 | 19125.69 | 23096.0 |
| 2024-01-24 18:00:00 | NQ | Futures | 19108.88 | 19122.71 | 19099.38 | 19111.05 | 5706.0 |
| 2024-01-24 19:00:00 | NQ | Futures | 19110.77 | 19117.28 | 19092.88 | 19117.28 | 4540.0 |
| 2024-01-24 20:00:00 | NQ | Futures | 19117.83 | 19131.66 | 19082.57 | 19101.83 | 6453.0 |
| 2024-01-24 21:00:00 | NQ | Futures | 19101.83 | 19112.4 | 19081.21 | 19094.5 | 5131.0 |
| 2024-01-24 22:00:00 | NQ | Futures | 19094.5 | 19102.64 | 19086.1 | 19098.84 | 2942.0 |
| 2024-01-24 23:00:00 | NQ | Futures | 19099.11 | 19111.86 | 19096.4 | 19103.45 | 2159.0 |
| 2024-01-24 00:00:00 | YM | Futures | 40926.7 | 40941.7 | 40924.5 | 40932.0 | 559.0 |
| 2024-01-24 01:00:00 | YM | Futures | 40932.0 | 40946.0 | 40932.0 | 40936.3 | 1274.0 |
| 2024-01-24 02:00:00 | YM | Futures | 40936.3 | 40979.3 | 40926.7 | 40960.0 | 2436.0 |
| 2024-01-24 03:00:00 | YM | Futures | 40958.9 | 40979.3 | 40951.4 | 40961.0 | 3186.0 |
> showing 50 of 2,100 rows — these rows as CSV