PREVIEW / futures_1hour / 2024-04-26
file: by_date/futures_1hour/2024/2024-04-26.parquet size: 58 KB rows: 1,702
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-04-26 00:00:00 | ES | Futures | 5438.03 | 5439.62 | 5436.17 | 5437.5 | 2242.0 |
| 2024-04-26 01:00:00 | ES | Futures | 5437.5 | 5441.75 | 5435.64 | 5441.21 | 5121.0 |
| 2024-04-26 02:00:00 | ES | Futures | 5441.21 | 5443.6 | 5438.83 | 5439.09 | 9673.0 |
| 2024-04-26 03:00:00 | ES | Futures | 5439.09 | 5439.62 | 5432.19 | 5434.85 | 17507.0 |
| 2024-04-26 04:00:00 | ES | Futures | 5434.85 | 5436.97 | 5428.75 | 5430.34 | 12211.0 |
| 2024-04-26 05:00:00 | ES | Futures | 5430.6 | 5431.4 | 5425.03 | 5430.07 | 10788.0 |
| 2024-04-26 06:00:00 | ES | Futures | 5430.34 | 5433.52 | 5426.62 | 5429.54 | 10413.0 |
| 2024-04-26 07:00:00 | ES | Futures | 5429.54 | 5436.7 | 5429.54 | 5432.99 | 15290.0 |
| 2024-04-26 08:00:00 | ES | Futures | 5432.73 | 5454.75 | 5423.97 | 5432.46 | 102807.0 |
| 2024-04-26 09:00:00 | ES | Futures | 5432.73 | 5444.13 | 5416.81 | 5439.62 | 236232.0 |
| 2024-04-26 10:00:00 | ES | Futures | 5439.89 | 5452.62 | 5437.5 | 5449.97 | 228473.0 |
| 2024-04-26 11:00:00 | ES | Futures | 5449.97 | 5458.19 | 5438.3 | 5448.11 | 163510.0 |
| 2024-04-26 12:00:00 | ES | Futures | 5448.11 | 5457.93 | 5443.07 | 5457.93 | 98622.0 |
| 2024-04-26 13:00:00 | ES | Futures | 5457.93 | 5461.38 | 5452.89 | 5456.34 | 104121.0 |
| 2024-04-26 14:00:00 | ES | Futures | 5456.34 | 5457.13 | 5447.32 | 5455.81 | 94619.0 |
| 2024-04-26 15:00:00 | ES | Futures | 5455.81 | 5458.72 | 5442.54 | 5443.34 | 181656.0 |
| 2024-04-26 16:00:00 | ES | Futures | 5443.34 | 5446.26 | 5442.54 | 5445.72 | 49033.0 |
| 2024-04-26 00:00:00 | NQ | Futures | 19013.65 | 19019.8 | 19002.95 | 19009.37 | 1673.0 |
| 2024-04-26 01:00:00 | NQ | Futures | 19008.3 | 19019.27 | 18998.4 | 19014.72 | 3087.0 |
| 2024-04-26 02:00:00 | NQ | Futures | 19015.79 | 19039.6 | 19005.09 | 19017.4 | 5784.0 |
| 2024-04-26 03:00:00 | NQ | Futures | 19017.4 | 19018.2 | 18976.74 | 19002.95 | 9833.0 |
| 2024-04-26 04:00:00 | NQ | Futures | 19002.42 | 19009.1 | 18968.44 | 18976.47 | 7443.0 |
| 2024-04-26 05:00:00 | NQ | Futures | 18977.0 | 18979.95 | 18952.39 | 18970.32 | 7034.0 |
| 2024-04-26 06:00:00 | NQ | Futures | 18970.58 | 18990.65 | 18956.67 | 18968.71 | 6896.0 |
| 2024-04-26 07:00:00 | NQ | Futures | 18968.71 | 19008.03 | 18968.71 | 18986.9 | 10721.0 |
| 2024-04-26 08:00:00 | NQ | Futures | 18986.1 | 19066.08 | 18932.06 | 18968.71 | 48590.0 |
| 2024-04-26 09:00:00 | NQ | Futures | 18969.51 | 19049.23 | 18905.31 | 19030.5 | 119351.0 |
| 2024-04-26 10:00:00 | NQ | Futures | 19031.57 | 19110.49 | 19012.85 | 19104.6 | 109103.0 |
| 2024-04-26 11:00:00 | NQ | Futures | 19104.6 | 19138.58 | 19061.53 | 19098.45 | 72496.0 |
| 2024-04-26 12:00:00 | NQ | Futures | 19098.72 | 19134.83 | 19074.91 | 19134.56 | 38291.0 |
| 2024-04-26 13:00:00 | NQ | Futures | 19134.56 | 19154.89 | 19112.36 | 19128.95 | 41113.0 |
| 2024-04-26 14:00:00 | NQ | Futures | 19129.21 | 19132.69 | 19085.34 | 19117.98 | 39573.0 |
| 2024-04-26 15:00:00 | NQ | Futures | 19117.71 | 19142.32 | 19085.07 | 19088.28 | 61022.0 |
| 2024-04-26 16:00:00 | NQ | Futures | 19088.55 | 19097.65 | 19078.92 | 19085.61 | 11405.0 |
| 2024-04-26 00:00:00 | YM | Futures | 40703.5 | 40715.2 | 40692.9 | 40700.4 | 431.0 |
| 2024-04-26 01:00:00 | YM | Futures | 40700.4 | 40743.9 | 40695.1 | 40738.6 | 627.0 |
| 2024-04-26 02:00:00 | YM | Futures | 40739.6 | 40750.3 | 40715.2 | 40715.2 | 1679.0 |
| 2024-04-26 03:00:00 | YM | Futures | 40717.3 | 40725.8 | 40689.7 | 40708.9 | 1932.0 |
| 2024-04-26 04:00:00 | YM | Futures | 40707.8 | 40739.6 | 40684.4 | 40716.3 | 2309.0 |
| 2024-04-26 05:00:00 | YM | Futures | 40717.3 | 40722.7 | 40677.0 | 40712.0 | 1707.0 |
| 2024-04-26 06:00:00 | YM | Futures | 40715.2 | 40720.5 | 40673.8 | 40688.7 | 2798.0 |
| 2024-04-26 07:00:00 | YM | Futures | 40689.7 | 40714.2 | 40674.9 | 40695.1 | 2437.0 |
| 2024-04-26 08:00:00 | YM | Futures | 40694.0 | 40840.5 | 40650.5 | 40698.2 | 10864.0 |
| 2024-04-26 09:00:00 | YM | Futures | 40700.4 | 40824.6 | 40601.6 | 40772.6 | 22135.0 |
| 2024-04-26 10:00:00 | YM | Futures | 40777.9 | 40876.6 | 40737.5 | 40769.4 | 18552.0 |
| 2024-04-26 11:00:00 | YM | Futures | 40770.4 | 40820.3 | 40699.3 | 40807.6 | 12412.0 |
| 2024-04-26 12:00:00 | YM | Futures | 40808.7 | 40883.0 | 40783.2 | 40880.8 | 8125.0 |
| 2024-04-26 13:00:00 | YM | Futures | 40881.9 | 40912.7 | 40854.3 | 40878.7 | 7637.0 |
| 2024-04-26 14:00:00 | YM | Futures | 40879.8 | 40901.0 | 40826.7 | 40872.4 | 8281.0 |
| 2024-04-26 15:00:00 | YM | Futures | 40871.3 | 40879.8 | 40790.6 | 40799.1 | 12650.0 |
> showing 50 of 1,702 rows — these rows as CSV