PREVIEW / futures_1hour / 2024-11-25
file: by_date/futures_1hour/2024/2024-11-25.parquet size: 69 KB rows: 2,128
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-25 00:00:00 | ES | Futures | 6242.58 | 6243.35 | 6241.28 | 6243.09 | 3667.0 |
| 2024-11-25 01:00:00 | ES | Futures | 6243.09 | 6243.09 | 6240.5 | 6241.28 | 4387.0 |
| 2024-11-25 02:00:00 | ES | Futures | 6241.28 | 6242.06 | 6237.9 | 6240.5 | 6268.0 |
| 2024-11-25 03:00:00 | ES | Futures | 6240.76 | 6243.61 | 6239.72 | 6241.8 | 13573.0 |
| 2024-11-25 04:00:00 | ES | Futures | 6241.8 | 6246.21 | 6239.98 | 6245.17 | 11841.0 |
| 2024-11-25 05:00:00 | ES | Futures | 6245.17 | 6247.77 | 6243.61 | 6247.25 | 8124.0 |
| 2024-11-25 06:00:00 | ES | Futures | 6247.25 | 6248.54 | 6244.39 | 6246.47 | 8102.0 |
| 2024-11-25 07:00:00 | ES | Futures | 6246.21 | 6246.99 | 6240.24 | 6245.43 | 18116.0 |
| 2024-11-25 08:00:00 | ES | Futures | 6245.43 | 6262.04 | 6243.87 | 6257.37 | 42357.0 |
| 2024-11-25 09:00:00 | ES | Futures | 6257.11 | 6270.09 | 6247.25 | 6253.22 | 259458.0 |
| 2024-11-25 10:00:00 | ES | Futures | 6252.96 | 6253.48 | 6234.79 | 6239.46 | 287954.0 |
| 2024-11-25 11:00:00 | ES | Futures | 6239.46 | 6244.39 | 6230.64 | 6231.68 | 160113.0 |
| 2024-11-25 12:00:00 | ES | Futures | 6231.68 | 6235.57 | 6210.4 | 6223.63 | 185714.0 |
| 2024-11-25 13:00:00 | ES | Futures | 6223.63 | 6235.83 | 6223.11 | 6232.45 | 100679.0 |
| 2024-11-25 14:00:00 | ES | Futures | 6232.45 | 6233.75 | 6223.89 | 6230.12 | 87782.0 |
| 2024-11-25 15:00:00 | ES | Futures | 6230.38 | 6237.9 | 6225.97 | 6234.53 | 200024.0 |
| 2024-11-25 16:00:00 | ES | Futures | 6234.53 | 6244.91 | 6230.38 | 6241.8 | 86491.0 |
| 2024-11-25 18:00:00 | ES | Futures | 6242.32 | 6248.03 | 6215.33 | 6222.33 | 26404.0 |
| 2024-11-25 19:00:00 | ES | Futures | 6222.59 | 6223.11 | 6210.65 | 6212.99 | 30173.0 |
| 2024-11-25 20:00:00 | ES | Futures | 6212.99 | 6225.45 | 6203.91 | 6224.41 | 24079.0 |
| 2024-11-25 21:00:00 | ES | Futures | 6224.67 | 6233.23 | 6224.41 | 6231.16 | 11723.0 |
| 2024-11-25 22:00:00 | ES | Futures | 6231.16 | 6237.13 | 6229.6 | 6235.05 | 7271.0 |
| 2024-11-25 23:00:00 | ES | Futures | 6235.31 | 6239.98 | 6234.79 | 6237.13 | 6037.0 |
| 2024-11-25 00:00:00 | NQ | Futures | 21880.37 | 21887.41 | 21873.32 | 21886.11 | 2148.0 |
| 2024-11-25 01:00:00 | NQ | Futures | 21886.37 | 21886.37 | 21868.89 | 21873.85 | 2646.0 |
| 2024-11-25 02:00:00 | NQ | Futures | 21873.58 | 21881.93 | 21864.71 | 21869.41 | 2749.0 |
| 2024-11-25 03:00:00 | NQ | Futures | 21870.19 | 21879.06 | 21845.14 | 21873.32 | 6437.0 |
| 2024-11-25 04:00:00 | NQ | Futures | 21873.06 | 21885.85 | 21859.23 | 21882.46 | 5033.0 |
| 2024-11-25 05:00:00 | NQ | Futures | 21882.98 | 21896.54 | 21877.24 | 21894.46 | 4537.0 |
| 2024-11-25 06:00:00 | NQ | Futures | 21894.46 | 21896.02 | 21877.76 | 21879.85 | 4227.0 |
| 2024-11-25 07:00:00 | NQ | Futures | 21879.85 | 21888.46 | 21857.93 | 21869.67 | 8028.0 |
| 2024-11-25 08:00:00 | NQ | Futures | 21869.93 | 21944.81 | 21857.15 | 21915.59 | 21008.0 |
| 2024-11-25 09:00:00 | NQ | Futures | 21915.33 | 22001.17 | 21831.58 | 21858.97 | 103886.0 |
| 2024-11-25 10:00:00 | NQ | Futures | 21858.45 | 21872.02 | 21780.18 | 21808.1 | 97924.0 |
| 2024-11-25 11:00:00 | NQ | Futures | 21807.57 | 21876.45 | 21798.7 | 21817.49 | 51778.0 |
| 2024-11-25 12:00:00 | NQ | Futures | 21817.23 | 21822.97 | 21687.29 | 21761.39 | 68813.0 |
| 2024-11-25 13:00:00 | NQ | Futures | 21761.65 | 21801.83 | 21752.0 | 21761.65 | 39051.0 |
| 2024-11-25 14:00:00 | NQ | Futures | 21761.65 | 21790.88 | 21734.52 | 21772.09 | 31235.0 |
| 2024-11-25 15:00:00 | NQ | Futures | 21772.09 | 21798.18 | 21745.22 | 21789.31 | 46671.0 |
| 2024-11-25 16:00:00 | NQ | Futures | 21789.05 | 21831.06 | 21773.39 | 21811.75 | 16300.0 |
| 2024-11-25 18:00:00 | NQ | Futures | 21818.79 | 21847.23 | 21708.43 | 21742.61 | 10421.0 |
| 2024-11-25 19:00:00 | NQ | Futures | 21744.43 | 21748.87 | 21692.51 | 21704.77 | 10662.0 |
| 2024-11-25 20:00:00 | NQ | Futures | 21706.86 | 21758.52 | 21660.94 | 21753.3 | 10386.0 |
| 2024-11-25 21:00:00 | NQ | Futures | 21752.26 | 21793.48 | 21752.26 | 21782.0 | 5452.0 |
| 2024-11-25 22:00:00 | NQ | Futures | 21782.79 | 21820.36 | 21776.0 | 21806.79 | 4398.0 |
| 2024-11-25 23:00:00 | NQ | Futures | 21806.27 | 21826.62 | 21797.92 | 21813.84 | 3678.0 |
| 2024-11-25 00:00:00 | YM | Futures | 46466.5 | 46475.8 | 46459.2 | 46473.8 | 527.0 |
| 2024-11-25 01:00:00 | YM | Futures | 46472.7 | 46475.8 | 46459.2 | 46471.7 | 877.0 |
| 2024-11-25 02:00:00 | YM | Futures | 46471.7 | 46479.0 | 46432.1 | 46462.3 | 1594.0 |
| 2024-11-25 03:00:00 | YM | Futures | 46464.4 | 46493.5 | 46452.9 | 46454.0 | 2639.0 |
> showing 50 of 2,128 rows — these rows as CSV