PREVIEW / futures_1hour / 2024-12-09
file: by_date/futures_1hour/2024/2024-12-09.parquet size: 67 KB rows: 2,097
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-12-09 00:00:00 | ES | Futures | 6326.4 | 6327.96 | 6326.14 | 6327.7 | 2485.0 |
| 2024-12-09 01:00:00 | ES | Futures | 6327.44 | 6329.52 | 6327.44 | 6328.48 | 2361.0 |
| 2024-12-09 02:00:00 | ES | Futures | 6328.22 | 6337.04 | 6326.92 | 6335.74 | 9421.0 |
| 2024-12-09 03:00:00 | ES | Futures | 6335.74 | 6338.34 | 6333.41 | 6336.0 | 11188.0 |
| 2024-12-09 04:00:00 | ES | Futures | 6336.0 | 6336.26 | 6326.66 | 6328.22 | 12915.0 |
| 2024-12-09 05:00:00 | ES | Futures | 6328.22 | 6328.48 | 6324.33 | 6325.62 | 8612.0 |
| 2024-12-09 06:00:00 | ES | Futures | 6325.62 | 6327.96 | 6320.43 | 6327.18 | 18579.0 |
| 2024-12-09 07:00:00 | ES | Futures | 6326.92 | 6331.07 | 6325.36 | 6329.26 | 13158.0 |
| 2024-12-09 08:00:00 | ES | Futures | 6329.0 | 6330.29 | 6325.62 | 6328.74 | 12615.0 |
| 2024-12-09 09:00:00 | ES | Futures | 6328.74 | 6330.81 | 6322.77 | 6325.62 | 115751.0 |
| 2024-12-09 10:00:00 | ES | Futures | 6325.62 | 6326.66 | 6302.53 | 6304.08 | 239605.0 |
| 2024-12-09 11:00:00 | ES | Futures | 6304.08 | 6311.61 | 6296.04 | 6310.31 | 181423.0 |
| 2024-12-09 12:00:00 | ES | Futures | 6310.31 | 6311.09 | 6302.79 | 6303.3 | 94957.0 |
| 2024-12-09 13:00:00 | ES | Futures | 6303.3 | 6314.98 | 6300.19 | 6310.31 | 101632.0 |
| 2024-12-09 14:00:00 | ES | Futures | 6310.57 | 6310.57 | 6295.0 | 6300.19 | 116363.0 |
| 2024-12-09 15:00:00 | ES | Futures | 6300.19 | 6300.71 | 6290.85 | 6296.82 | 235387.0 |
| 2024-12-09 16:00:00 | ES | Futures | 6296.82 | 6297.08 | 6290.85 | 6294.22 | 55739.0 |
| 2024-12-09 18:00:00 | ES | Futures | 6296.3 | 6296.3 | 6291.11 | 6292.92 | 6514.0 |
| 2024-12-09 19:00:00 | ES | Futures | 6292.66 | 6294.22 | 6291.11 | 6293.7 | 6120.0 |
| 2024-12-09 20:00:00 | ES | Futures | 6293.7 | 6294.48 | 6290.33 | 6291.11 | 8205.0 |
| 2024-12-09 21:00:00 | ES | Futures | 6291.37 | 6292.4 | 6290.85 | 6291.63 | 3311.0 |
| 2024-12-09 22:00:00 | ES | Futures | 6291.63 | 6293.96 | 6291.37 | 6293.18 | 2969.0 |
| 2024-12-09 23:00:00 | ES | Futures | 6293.18 | 6293.7 | 6291.37 | 6291.89 | 1961.0 |
| 2024-12-09 00:00:00 | NQ | Futures | 22583.53 | 22593.96 | 22580.4 | 22592.92 | 1313.0 |
| 2024-12-09 01:00:00 | NQ | Futures | 22593.7 | 22601.79 | 22592.92 | 22595.01 | 1723.0 |
| 2024-12-09 02:00:00 | NQ | Futures | 22594.75 | 22650.84 | 22591.09 | 22642.75 | 6572.0 |
| 2024-12-09 03:00:00 | NQ | Futures | 22643.8 | 22653.71 | 22626.84 | 22651.1 | 6566.0 |
| 2024-12-09 04:00:00 | NQ | Futures | 22651.36 | 22652.15 | 22570.48 | 22578.05 | 10100.0 |
| 2024-12-09 05:00:00 | NQ | Futures | 22577.53 | 22581.44 | 22555.35 | 22558.22 | 7023.0 |
| 2024-12-09 06:00:00 | NQ | Futures | 22558.74 | 22571.52 | 22528.21 | 22559.52 | 12827.0 |
| 2024-12-09 07:00:00 | NQ | Futures | 22559.26 | 22574.13 | 22551.17 | 22570.48 | 6592.0 |
| 2024-12-09 08:00:00 | NQ | Futures | 22570.48 | 22575.18 | 22552.74 | 22563.44 | 7805.0 |
| 2024-12-09 09:00:00 | NQ | Futures | 22564.22 | 22593.7 | 22524.82 | 22567.09 | 66989.0 |
| 2024-12-09 10:00:00 | NQ | Futures | 22567.09 | 22575.7 | 22441.85 | 22446.55 | 94075.0 |
| 2024-12-09 11:00:00 | NQ | Futures | 22446.55 | 22467.68 | 22371.67 | 22449.16 | 81537.0 |
| 2024-12-09 12:00:00 | NQ | Futures | 22448.9 | 22464.03 | 22423.59 | 22425.67 | 35406.0 |
| 2024-12-09 13:00:00 | NQ | Futures | 22425.94 | 22490.38 | 22411.59 | 22469.51 | 34215.0 |
| 2024-12-09 14:00:00 | NQ | Futures | 22469.77 | 22470.03 | 22380.28 | 22413.67 | 40531.0 |
| 2024-12-09 15:00:00 | NQ | Futures | 22413.67 | 22429.07 | 22377.15 | 22423.59 | 58290.0 |
| 2024-12-09 16:00:00 | NQ | Futures | 22423.07 | 22425.67 | 22400.37 | 22410.54 | 14998.0 |
| 2024-12-09 18:00:00 | NQ | Futures | 22416.8 | 22419.67 | 22395.41 | 22401.93 | 4238.0 |
| 2024-12-09 19:00:00 | NQ | Futures | 22401.93 | 22417.33 | 22397.24 | 22414.46 | 3145.0 |
| 2024-12-09 20:00:00 | NQ | Futures | 22414.19 | 22422.8 | 22399.58 | 22405.06 | 3109.0 |
| 2024-12-09 21:00:00 | NQ | Futures | 22405.85 | 22411.59 | 22402.98 | 22404.8 | 1497.0 |
| 2024-12-09 22:00:00 | NQ | Futures | 22405.85 | 22414.19 | 22401.93 | 22410.28 | 1263.0 |
| 2024-12-09 23:00:00 | NQ | Futures | 22410.8 | 22413.41 | 22403.24 | 22405.58 | 951.0 |
| 2024-12-09 00:00:00 | YM | Futures | 46489.4 | 46500.8 | 46479.0 | 46488.3 | 307.0 |
| 2024-12-09 01:00:00 | YM | Futures | 46488.3 | 46496.6 | 46481.0 | 46488.3 | 376.0 |
| 2024-12-09 02:00:00 | YM | Futures | 46485.2 | 46533.1 | 46465.4 | 46523.7 | 1752.0 |
| 2024-12-09 03:00:00 | YM | Futures | 46523.7 | 46543.5 | 46482.1 | 46487.3 | 2359.0 |
> showing 50 of 2,097 rows — these rows as CSV