PREVIEW / futures_1hour / 2024-11-05
file: by_date/futures_1hour/2024/2024-11-05.parquet size: 71 KB rows: 2,151
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-05 00:00:00 | ES | Futures | 5961.77 | 5966.7 | 5961.77 | 5965.66 | 3419.0 |
| 2024-11-05 01:00:00 | ES | Futures | 5965.66 | 5970.08 | 5964.37 | 5969.3 | 3434.0 |
| 2024-11-05 02:00:00 | ES | Futures | 5969.3 | 5974.23 | 5966.7 | 5970.6 | 6054.0 |
| 2024-11-05 03:00:00 | ES | Futures | 5970.6 | 5973.19 | 5962.55 | 5973.19 | 13327.0 |
| 2024-11-05 04:00:00 | ES | Futures | 5972.93 | 5976.05 | 5970.85 | 5972.41 | 12843.0 |
| 2024-11-05 05:00:00 | ES | Futures | 5972.41 | 5973.45 | 5965.4 | 5972.15 | 9349.0 |
| 2024-11-05 06:00:00 | ES | Futures | 5972.15 | 5977.86 | 5972.15 | 5973.19 | 7248.0 |
| 2024-11-05 07:00:00 | ES | Futures | 5973.19 | 5976.82 | 5967.22 | 5971.11 | 12630.0 |
| 2024-11-05 08:00:00 | ES | Futures | 5971.37 | 5976.3 | 5968.78 | 5969.56 | 16741.0 |
| 2024-11-05 09:00:00 | ES | Futures | 5969.56 | 6007.45 | 5966.44 | 6006.41 | 155835.0 |
| 2024-11-05 10:00:00 | ES | Futures | 6006.67 | 6019.65 | 6001.22 | 6006.67 | 182421.0 |
| 2024-11-05 11:00:00 | ES | Futures | 6006.67 | 6023.8 | 6001.48 | 6021.98 | 130730.0 |
| 2024-11-05 12:00:00 | ES | Futures | 6021.98 | 6032.36 | 6018.61 | 6028.21 | 91270.0 |
| 2024-11-05 13:00:00 | ES | Futures | 6028.47 | 6032.1 | 6013.16 | 6019.9 | 113699.0 |
| 2024-11-05 14:00:00 | ES | Futures | 6019.65 | 6026.65 | 6013.68 | 6017.05 | 91215.0 |
| 2024-11-05 15:00:00 | ES | Futures | 6017.05 | 6034.96 | 6014.45 | 6034.44 | 183427.0 |
| 2024-11-05 16:00:00 | ES | Futures | 6034.44 | 6045.08 | 6033.14 | 6044.04 | 68274.0 |
| 2024-11-05 18:00:00 | ES | Futures | 6041.96 | 6046.38 | 6036.25 | 6037.55 | 10862.0 |
| 2024-11-05 19:00:00 | ES | Futures | 6037.29 | 6069.47 | 6036.77 | 6060.65 | 35954.0 |
| 2024-11-05 20:00:00 | ES | Futures | 6060.39 | 6077.52 | 6057.8 | 6067.4 | 30436.0 |
| 2024-11-05 21:00:00 | ES | Futures | 6067.14 | 6107.36 | 6063.76 | 6106.33 | 51360.0 |
| 2024-11-05 22:00:00 | ES | Futures | 6106.59 | 6119.3 | 6096.46 | 6106.33 | 58798.0 |
| 2024-11-05 23:00:00 | ES | Futures | 6106.33 | 6116.71 | 6097.76 | 6111.52 | 23851.0 |
| 2024-11-05 00:00:00 | NQ | Futures | 20961.96 | 20987.0 | 20961.43 | 20980.48 | 1954.0 |
| 2024-11-05 01:00:00 | NQ | Futures | 20979.96 | 21003.18 | 20976.31 | 20996.14 | 2038.0 |
| 2024-11-05 02:00:00 | NQ | Futures | 20996.4 | 21021.71 | 20990.14 | 21005.01 | 3698.0 |
| 2024-11-05 03:00:00 | NQ | Futures | 21005.53 | 21027.18 | 20979.18 | 21026.66 | 5587.0 |
| 2024-11-05 04:00:00 | NQ | Futures | 21025.62 | 21047.28 | 21015.7 | 21029.27 | 5483.0 |
| 2024-11-05 05:00:00 | NQ | Futures | 21029.27 | 21029.27 | 20990.66 | 21022.49 | 4665.0 |
| 2024-11-05 06:00:00 | NQ | Futures | 21022.49 | 21051.71 | 21022.49 | 21034.49 | 3779.0 |
| 2024-11-05 07:00:00 | NQ | Futures | 21033.71 | 21048.32 | 21004.22 | 21028.75 | 6234.0 |
| 2024-11-05 08:00:00 | NQ | Futures | 21028.49 | 21044.41 | 21002.4 | 21003.96 | 8258.0 |
| 2024-11-05 09:00:00 | NQ | Futures | 21003.96 | 21185.56 | 20985.18 | 21176.43 | 75529.0 |
| 2024-11-05 10:00:00 | NQ | Futures | 21177.73 | 21208.26 | 21124.51 | 21140.94 | 75124.0 |
| 2024-11-05 11:00:00 | NQ | Futures | 21141.46 | 21235.91 | 21115.63 | 21228.35 | 53201.0 |
| 2024-11-05 12:00:00 | NQ | Futures | 21228.61 | 21262.01 | 21214.78 | 21239.57 | 35307.0 |
| 2024-11-05 13:00:00 | NQ | Futures | 21239.83 | 21257.57 | 21171.99 | 21195.21 | 37897.0 |
| 2024-11-05 14:00:00 | NQ | Futures | 21194.95 | 21222.61 | 21165.73 | 21180.34 | 33243.0 |
| 2024-11-05 15:00:00 | NQ | Futures | 21179.82 | 21238.0 | 21166.77 | 21229.13 | 50594.0 |
| 2024-11-05 16:00:00 | NQ | Futures | 21229.13 | 21275.31 | 21225.22 | 21251.57 | 19909.0 |
| 2024-11-05 18:00:00 | NQ | Futures | 21249.22 | 21253.66 | 21223.39 | 21231.48 | 4163.0 |
| 2024-11-05 19:00:00 | NQ | Futures | 21230.96 | 21304.53 | 21210.61 | 21279.49 | 12594.0 |
| 2024-11-05 20:00:00 | NQ | Futures | 21277.92 | 21316.28 | 21268.01 | 21293.32 | 9744.0 |
| 2024-11-05 21:00:00 | NQ | Futures | 21291.23 | 21488.48 | 21284.44 | 21487.17 | 21575.0 |
| 2024-11-05 22:00:00 | NQ | Futures | 21487.17 | 21541.44 | 21458.73 | 21492.13 | 18718.0 |
| 2024-11-05 23:00:00 | NQ | Futures | 21492.91 | 21525.27 | 21467.34 | 21496.31 | 8236.0 |
| 2024-11-05 00:00:00 | YM | Futures | 43674.1 | 43717.8 | 43674.1 | 43711.6 | 854.0 |
| 2024-11-05 01:00:00 | YM | Futures | 43711.6 | 43729.3 | 43703.3 | 43723.0 | 402.0 |
| 2024-11-05 02:00:00 | YM | Futures | 43723.0 | 43747.0 | 43685.6 | 43721.0 | 951.0 |
| 2024-11-05 03:00:00 | YM | Futures | 43722.0 | 43735.5 | 43655.4 | 43734.5 | 1181.0 |
> showing 50 of 2,151 rows — these rows as CSV