PREVIEW / futures_1hour / 2024-11-12
file: by_date/futures_1hour/2024/2024-11-12.parquet size: 69 KB rows: 2,124
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-12 00:00:00 | ES | Futures | 6256.59 | 6256.59 | 6251.66 | 6252.7 | 5256.0 |
| 2024-11-12 01:00:00 | ES | Futures | 6252.7 | 6254.51 | 6251.4 | 6253.74 | 4513.0 |
| 2024-11-12 02:00:00 | ES | Futures | 6253.74 | 6256.85 | 6250.36 | 6256.07 | 10489.0 |
| 2024-11-12 03:00:00 | ES | Futures | 6256.07 | 6261.52 | 6252.7 | 6259.19 | 15407.0 |
| 2024-11-12 04:00:00 | ES | Futures | 6258.93 | 6259.44 | 6249.32 | 6249.84 | 17162.0 |
| 2024-11-12 05:00:00 | ES | Futures | 6249.84 | 6250.1 | 6241.28 | 6247.25 | 26788.0 |
| 2024-11-12 06:00:00 | ES | Futures | 6247.25 | 6253.48 | 6247.25 | 6250.62 | 16343.0 |
| 2024-11-12 07:00:00 | ES | Futures | 6250.62 | 6257.11 | 6250.36 | 6253.48 | 16732.0 |
| 2024-11-12 08:00:00 | ES | Futures | 6253.48 | 6261.0 | 6250.36 | 6260.48 | 31135.0 |
| 2024-11-12 09:00:00 | ES | Futures | 6260.48 | 6266.45 | 6255.03 | 6262.56 | 115382.0 |
| 2024-11-12 10:00:00 | ES | Futures | 6262.56 | 6263.34 | 6244.65 | 6244.91 | 169285.0 |
| 2024-11-12 11:00:00 | ES | Futures | 6244.65 | 6248.8 | 6235.31 | 6236.87 | 158124.0 |
| 2024-11-12 12:00:00 | ES | Futures | 6236.61 | 6239.72 | 6216.88 | 6218.18 | 154775.0 |
| 2024-11-12 13:00:00 | ES | Futures | 6218.44 | 6250.62 | 6214.81 | 6246.73 | 162041.0 |
| 2024-11-12 14:00:00 | ES | Futures | 6246.99 | 6257.37 | 6245.95 | 6253.48 | 108337.0 |
| 2024-11-12 15:00:00 | ES | Futures | 6253.22 | 6255.29 | 6237.64 | 6241.54 | 210866.0 |
| 2024-11-12 16:00:00 | ES | Futures | 6241.8 | 6246.21 | 6240.24 | 6241.28 | 62807.0 |
| 2024-11-12 18:00:00 | ES | Futures | 6241.28 | 6242.32 | 6232.71 | 6236.87 | 8624.0 |
| 2024-11-12 19:00:00 | ES | Futures | 6237.13 | 6237.39 | 6231.68 | 6233.49 | 5621.0 |
| 2024-11-12 20:00:00 | ES | Futures | 6233.49 | 6236.61 | 6231.16 | 6233.23 | 6429.0 |
| 2024-11-12 21:00:00 | ES | Futures | 6233.23 | 6235.57 | 6230.64 | 6235.31 | 5831.0 |
| 2024-11-12 22:00:00 | ES | Futures | 6235.31 | 6237.64 | 6232.97 | 6233.23 | 4520.0 |
| 2024-11-12 23:00:00 | ES | Futures | 6233.49 | 6234.27 | 6230.64 | 6232.19 | 5455.0 |
| 2024-11-12 00:00:00 | NQ | Futures | 22148.85 | 22150.93 | 22114.93 | 22120.41 | 3282.0 |
| 2024-11-12 01:00:00 | NQ | Futures | 22120.67 | 22137.63 | 22110.75 | 22134.5 | 3421.0 |
| 2024-11-12 02:00:00 | NQ | Futures | 22134.76 | 22154.85 | 22104.75 | 22133.71 | 7452.0 |
| 2024-11-12 03:00:00 | NQ | Futures | 22134.24 | 22167.89 | 22121.71 | 22157.46 | 6294.0 |
| 2024-11-12 04:00:00 | NQ | Futures | 22156.67 | 22158.76 | 22103.97 | 22109.45 | 8298.0 |
| 2024-11-12 05:00:00 | NQ | Futures | 22108.67 | 22109.97 | 22050.74 | 22091.97 | 14053.0 |
| 2024-11-12 06:00:00 | NQ | Futures | 22093.01 | 22119.1 | 22091.45 | 22102.93 | 7535.0 |
| 2024-11-12 07:00:00 | NQ | Futures | 22102.14 | 22138.41 | 22100.58 | 22118.32 | 9616.0 |
| 2024-11-12 08:00:00 | NQ | Futures | 22118.32 | 22159.81 | 22105.54 | 22147.8 | 12849.0 |
| 2024-11-12 09:00:00 | NQ | Futures | 22148.06 | 22179.37 | 22106.06 | 22162.15 | 64759.0 |
| 2024-11-12 10:00:00 | NQ | Futures | 22161.63 | 22168.68 | 22102.67 | 22109.19 | 74822.0 |
| 2024-11-12 11:00:00 | NQ | Futures | 22108.41 | 22131.1 | 22066.66 | 22078.14 | 59720.0 |
| 2024-11-12 12:00:00 | NQ | Futures | 22077.88 | 22094.84 | 21984.73 | 21985.78 | 51032.0 |
| 2024-11-12 13:00:00 | NQ | Futures | 21986.04 | 22123.28 | 21973.77 | 22106.58 | 59030.0 |
| 2024-11-12 14:00:00 | NQ | Futures | 22106.06 | 22136.32 | 22100.32 | 22113.36 | 34967.0 |
| 2024-11-12 15:00:00 | NQ | Futures | 22113.36 | 22132.15 | 22090.92 | 22109.97 | 51197.0 |
| 2024-11-12 16:00:00 | NQ | Futures | 22110.23 | 22125.1 | 22101.1 | 22102.4 | 11126.0 |
| 2024-11-12 18:00:00 | NQ | Futures | 22102.4 | 22108.41 | 22065.35 | 22084.4 | 4898.0 |
| 2024-11-12 19:00:00 | NQ | Futures | 22085.18 | 22086.23 | 22061.18 | 22067.18 | 3075.0 |
| 2024-11-12 20:00:00 | NQ | Futures | 22068.22 | 22080.75 | 22055.96 | 22062.75 | 3093.0 |
| 2024-11-12 21:00:00 | NQ | Futures | 22062.75 | 22076.31 | 22054.92 | 22073.44 | 2608.0 |
| 2024-11-12 22:00:00 | NQ | Futures | 22072.92 | 22084.66 | 22068.22 | 22069.53 | 2334.0 |
| 2024-11-12 23:00:00 | NQ | Futures | 22070.05 | 22071.36 | 22054.4 | 22062.75 | 2460.0 |
| 2024-11-12 00:00:00 | YM | Futures | 46195.9 | 46195.9 | 46176.1 | 46188.6 | 719.0 |
| 2024-11-12 01:00:00 | YM | Futures | 46188.6 | 46195.9 | 46179.2 | 46192.8 | 741.0 |
| 2024-11-12 02:00:00 | YM | Futures | 46193.8 | 46205.2 | 46162.6 | 46204.2 | 1637.0 |
| 2024-11-12 03:00:00 | YM | Futures | 46203.2 | 46235.4 | 46167.8 | 46222.9 | 2167.0 |
> showing 50 of 2,124 rows — these rows as CSV