PREVIEW / futures_1hour / 2024-11-08
file: by_date/futures_1hour/2024/2024-11-08.parquet size: 58 KB rows: 1,683
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-11-08 00:00:00 | ES | Futures | 6231.68 | 6238.68 | 6231.42 | 6236.35 | 4371.0 |
| 2024-11-08 01:00:00 | ES | Futures | 6236.35 | 6237.64 | 6231.42 | 6233.75 | 4207.0 |
| 2024-11-08 02:00:00 | ES | Futures | 6234.01 | 6238.94 | 6232.45 | 6237.39 | 5434.0 |
| 2024-11-08 03:00:00 | ES | Futures | 6237.39 | 6238.94 | 6230.9 | 6234.79 | 17986.0 |
| 2024-11-08 04:00:00 | ES | Futures | 6234.79 | 6238.68 | 6233.75 | 6235.05 | 12016.0 |
| 2024-11-08 05:00:00 | ES | Futures | 6235.31 | 6235.31 | 6218.7 | 6222.33 | 24350.0 |
| 2024-11-08 06:00:00 | ES | Futures | 6222.59 | 6226.23 | 6218.44 | 6224.93 | 15720.0 |
| 2024-11-08 07:00:00 | ES | Futures | 6225.19 | 6231.42 | 6224.15 | 6230.9 | 18090.0 |
| 2024-11-08 08:00:00 | ES | Futures | 6230.64 | 6232.97 | 6226.23 | 6226.75 | 24048.0 |
| 2024-11-08 09:00:00 | ES | Futures | 6226.75 | 6244.65 | 6225.97 | 6244.13 | 128524.0 |
| 2024-11-08 10:00:00 | ES | Futures | 6243.61 | 6252.44 | 6237.39 | 6250.62 | 156661.0 |
| 2024-11-08 11:00:00 | ES | Futures | 6250.36 | 6255.03 | 6245.95 | 6252.18 | 90949.0 |
| 2024-11-08 12:00:00 | ES | Futures | 6252.44 | 6256.59 | 6246.99 | 6254.25 | 89069.0 |
| 2024-11-08 13:00:00 | ES | Futures | 6254.25 | 6265.93 | 6252.7 | 6263.86 | 76999.0 |
| 2024-11-08 14:00:00 | ES | Futures | 6263.86 | 6270.6 | 6260.48 | 6262.82 | 82750.0 |
| 2024-11-08 15:00:00 | ES | Futures | 6262.82 | 6263.6 | 6249.32 | 6256.59 | 228713.0 |
| 2024-11-08 16:00:00 | ES | Futures | 6256.85 | 6258.67 | 6252.7 | 6252.96 | 50648.0 |
| 2024-11-08 00:00:00 | NQ | Futures | 22151.2 | 22191.38 | 22149.11 | 22179.37 | 4209.0 |
| 2024-11-08 01:00:00 | NQ | Futures | 22179.11 | 22184.85 | 22150.67 | 22157.2 | 3018.0 |
| 2024-11-08 02:00:00 | NQ | Futures | 22158.76 | 22174.94 | 22147.8 | 22167.11 | 3452.0 |
| 2024-11-08 03:00:00 | NQ | Futures | 22166.85 | 22178.07 | 22137.11 | 22159.28 | 6347.0 |
| 2024-11-08 04:00:00 | NQ | Futures | 22159.28 | 22171.29 | 22151.2 | 22151.72 | 4433.0 |
| 2024-11-08 05:00:00 | NQ | Futures | 22151.72 | 22151.72 | 22052.57 | 22066.92 | 14020.0 |
| 2024-11-08 06:00:00 | NQ | Futures | 22067.18 | 22090.92 | 22043.7 | 22085.71 | 9274.0 |
| 2024-11-08 07:00:00 | NQ | Futures | 22085.97 | 22113.88 | 22081.53 | 22107.88 | 8493.0 |
| 2024-11-08 08:00:00 | NQ | Futures | 22107.36 | 22120.15 | 22080.49 | 22085.71 | 12646.0 |
| 2024-11-08 09:00:00 | NQ | Futures | 22086.23 | 22159.02 | 22079.71 | 22133.19 | 57292.0 |
| 2024-11-08 10:00:00 | NQ | Futures | 22132.67 | 22153.02 | 22084.92 | 22123.28 | 65187.0 |
| 2024-11-08 11:00:00 | NQ | Futures | 22123.02 | 22163.46 | 22094.84 | 22145.19 | 41284.0 |
| 2024-11-08 12:00:00 | NQ | Futures | 22145.72 | 22155.37 | 22121.71 | 22143.89 | 30361.0 |
| 2024-11-08 13:00:00 | NQ | Futures | 22143.89 | 22193.2 | 22140.24 | 22177.81 | 35590.0 |
| 2024-11-08 14:00:00 | NQ | Futures | 22177.81 | 22192.94 | 22160.59 | 22161.63 | 24378.0 |
| 2024-11-08 15:00:00 | NQ | Futures | 22161.11 | 22165.81 | 22133.71 | 22161.11 | 48511.0 |
| 2024-11-08 16:00:00 | NQ | Futures | 22160.59 | 22170.24 | 22150.15 | 22153.28 | 10739.0 |
| 2024-11-08 00:00:00 | YM | Futures | 45680.7 | 45722.3 | 45676.5 | 45710.9 | 605.0 |
| 2024-11-08 01:00:00 | YM | Futures | 45714.0 | 45718.2 | 45678.6 | 45691.1 | 689.0 |
| 2024-11-08 02:00:00 | YM | Futures | 45691.1 | 45737.9 | 45685.9 | 45727.5 | 1020.0 |
| 2024-11-08 03:00:00 | YM | Futures | 45726.5 | 45730.7 | 45673.4 | 45688.0 | 2052.0 |
| 2024-11-08 04:00:00 | YM | Futures | 45685.9 | 45714.0 | 45673.4 | 45678.6 | 1806.0 |
| 2024-11-08 05:00:00 | YM | Futures | 45679.7 | 45694.2 | 45641.2 | 45678.6 | 2879.0 |
| 2024-11-08 06:00:00 | YM | Futures | 45677.6 | 45711.9 | 45666.1 | 45694.2 | 2453.0 |
| 2024-11-08 07:00:00 | YM | Futures | 45694.2 | 45730.7 | 45679.7 | 45723.4 | 2037.0 |
| 2024-11-08 08:00:00 | YM | Futures | 45723.4 | 45741.1 | 45697.4 | 45719.2 | 2528.0 |
| 2024-11-08 09:00:00 | YM | Futures | 45720.2 | 45833.7 | 45665.1 | 45818.1 | 16137.0 |
| 2024-11-08 10:00:00 | YM | Futures | 45811.8 | 45970.0 | 45776.4 | 45945.1 | 18015.0 |
| 2024-11-08 11:00:00 | YM | Futures | 45946.1 | 45986.7 | 45892.0 | 45905.5 | 11363.0 |
| 2024-11-08 12:00:00 | YM | Futures | 45907.6 | 45954.4 | 45872.2 | 45936.7 | 9355.0 |
| 2024-11-08 13:00:00 | YM | Futures | 45936.7 | 45997.1 | 45895.1 | 45984.6 | 7504.0 |
| 2024-11-08 14:00:00 | YM | Futures | 45982.5 | 46105.3 | 45978.4 | 46012.7 | 9949.0 |
| 2024-11-08 15:00:00 | YM | Futures | 46012.7 | 46035.6 | 45906.5 | 45948.2 | 14892.0 |
> showing 50 of 1,683 rows — these rows as CSV