PREVIEW / futures_1hour / 2023-12-05
file: by_date/futures_1hour/2023/2023-12-05.parquet size: 66 KB rows: 2,043
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-05 00:00:00 | ES | Futures | 4960.29 | 4961.37 | 4959.47 | 4961.1 | 4569.0 |
| 2023-12-05 01:00:00 | ES | Futures | 4961.1 | 4961.1 | 4954.31 | 4955.4 | 8884.0 |
| 2023-12-05 02:00:00 | ES | Futures | 4955.13 | 4955.13 | 4949.42 | 4950.78 | 15623.0 |
| 2023-12-05 03:00:00 | ES | Futures | 4950.78 | 4960.01 | 4950.78 | 4959.2 | 19912.0 |
| 2023-12-05 04:00:00 | ES | Futures | 4958.93 | 4963.27 | 4958.38 | 4960.01 | 18130.0 |
| 2023-12-05 05:00:00 | ES | Futures | 4960.01 | 4960.29 | 4950.24 | 4952.68 | 18841.0 |
| 2023-12-05 06:00:00 | ES | Futures | 4952.95 | 4958.11 | 4949.15 | 4949.42 | 19688.0 |
| 2023-12-05 07:00:00 | ES | Futures | 4949.42 | 4955.4 | 4948.34 | 4952.68 | 24687.0 |
| 2023-12-05 08:00:00 | ES | Futures | 4952.41 | 4959.74 | 4951.87 | 4952.95 | 39146.0 |
| 2023-12-05 09:00:00 | ES | Futures | 4952.95 | 4961.37 | 4948.34 | 4957.57 | 190154.0 |
| 2023-12-05 10:00:00 | ES | Futures | 4957.57 | 4979.02 | 4956.48 | 4978.48 | 377208.0 |
| 2023-12-05 11:00:00 | ES | Futures | 4978.75 | 4980.92 | 4956.48 | 4964.09 | 271151.0 |
| 2023-12-05 12:00:00 | ES | Futures | 4964.09 | 4968.43 | 4955.13 | 4966.26 | 170963.0 |
| 2023-12-05 13:00:00 | ES | Futures | 4965.99 | 4970.06 | 4962.19 | 4965.72 | 137010.0 |
| 2023-12-05 14:00:00 | ES | Futures | 4965.99 | 4971.15 | 4962.46 | 4970.6 | 115964.0 |
| 2023-12-05 15:00:00 | ES | Futures | 4970.33 | 4972.23 | 4964.63 | 4970.33 | 251616.0 |
| 2023-12-05 16:00:00 | ES | Futures | 4970.33 | 4973.32 | 4966.53 | 4967.62 | 54664.0 |
| 2023-12-05 18:00:00 | ES | Futures | 4967.62 | 4973.05 | 4965.44 | 4972.78 | 7781.0 |
| 2023-12-05 19:00:00 | ES | Futures | 4972.51 | 4979.84 | 4972.51 | 4979.84 | 14966.0 |
| 2023-12-05 20:00:00 | ES | Futures | 4979.84 | 4984.18 | 4979.57 | 4982.82 | 12216.0 |
| 2023-12-05 21:00:00 | ES | Futures | 4982.82 | 4984.18 | 4981.2 | 4982.55 | 8362.0 |
| 2023-12-05 22:00:00 | ES | Futures | 4982.55 | 4986.08 | 4982.28 | 4983.64 | 8089.0 |
| 2023-12-05 23:00:00 | ES | Futures | 4983.64 | 4985.0 | 4983.37 | 4984.18 | 4828.0 |
| 2023-12-05 00:00:00 | NQ | Futures | 17389.26 | 17392.01 | 17382.67 | 17388.44 | 2911.0 |
| 2023-12-05 01:00:00 | NQ | Futures | 17388.72 | 17388.99 | 17350.26 | 17355.21 | 4752.0 |
| 2023-12-05 02:00:00 | NQ | Futures | 17354.93 | 17355.21 | 17316.2 | 17324.44 | 8511.0 |
| 2023-12-05 03:00:00 | NQ | Futures | 17324.72 | 17364.27 | 17324.72 | 17359.88 | 10739.0 |
| 2023-12-05 04:00:00 | NQ | Futures | 17359.6 | 17374.98 | 17350.26 | 17359.05 | 8858.0 |
| 2023-12-05 05:00:00 | NQ | Futures | 17358.78 | 17359.33 | 17319.5 | 17331.31 | 10271.0 |
| 2023-12-05 06:00:00 | NQ | Futures | 17331.04 | 17353.83 | 17316.75 | 17321.42 | 9410.0 |
| 2023-12-05 07:00:00 | NQ | Futures | 17321.7 | 17353.28 | 17319.23 | 17338.18 | 12532.0 |
| 2023-12-05 08:00:00 | NQ | Futures | 17337.63 | 17377.73 | 17335.43 | 17356.3 | 17838.0 |
| 2023-12-05 09:00:00 | NQ | Futures | 17356.58 | 17429.37 | 17324.72 | 17418.65 | 93699.0 |
| 2023-12-05 10:00:00 | NQ | Futures | 17418.93 | 17535.66 | 17412.06 | 17525.22 | 144345.0 |
| 2023-12-05 11:00:00 | NQ | Futures | 17525.22 | 17535.11 | 17394.48 | 17433.76 | 98566.0 |
| 2023-12-05 12:00:00 | NQ | Futures | 17433.76 | 17466.17 | 17388.99 | 17438.98 | 63621.0 |
| 2023-12-05 13:00:00 | NQ | Futures | 17438.7 | 17459.85 | 17419.48 | 17438.98 | 51768.0 |
| 2023-12-05 14:00:00 | NQ | Futures | 17439.25 | 17472.49 | 17422.5 | 17467.27 | 43652.0 |
| 2023-12-05 15:00:00 | NQ | Futures | 17467.27 | 17483.2 | 17450.24 | 17481.83 | 58814.0 |
| 2023-12-05 16:00:00 | NQ | Futures | 17481.55 | 17497.76 | 17465.35 | 17468.37 | 12640.0 |
| 2023-12-05 18:00:00 | NQ | Futures | 17465.35 | 17501.33 | 17458.75 | 17499.68 | 4278.0 |
| 2023-12-05 19:00:00 | NQ | Futures | 17499.13 | 17540.88 | 17498.58 | 17539.51 | 7663.0 |
| 2023-12-05 20:00:00 | NQ | Futures | 17539.51 | 17556.54 | 17538.13 | 17551.59 | 5888.0 |
| 2023-12-05 21:00:00 | NQ | Futures | 17551.87 | 17559.28 | 17541.43 | 17547.75 | 4206.0 |
| 2023-12-05 22:00:00 | NQ | Futures | 17547.75 | 17567.25 | 17547.2 | 17552.69 | 4167.0 |
| 2023-12-05 23:00:00 | NQ | Futures | 17552.96 | 17556.54 | 17548.84 | 17555.99 | 2240.0 |
| 2023-12-05 00:00:00 | YM | Futures | 39278.2 | 39283.6 | 39273.9 | 39282.5 | 657.0 |
| 2023-12-05 01:00:00 | YM | Futures | 39282.5 | 39283.6 | 39250.0 | 39257.6 | 1280.0 |
| 2023-12-05 02:00:00 | YM | Futures | 39256.5 | 39256.5 | 39231.6 | 39234.8 | 2366.0 |
| 2023-12-05 03:00:00 | YM | Futures | 39234.8 | 39296.6 | 39234.8 | 39289.1 | 2548.0 |
> showing 50 of 2,043 rows — these rows as CSV