PREVIEW / futures_1hour / 2022-08-22
file: by_date/futures_1hour/2022/2022-08-22.parquet size: 67 KB rows: 2,016
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 |
|---|---|---|---|---|---|---|---|
| 2022-08-22 00:00:00 | ES | Futures | 4776.24 | 4776.81 | 4771.42 | 4771.42 | 3458.0 |
| 2022-08-22 01:00:00 | ES | Futures | 4771.71 | 4775.11 | 4769.73 | 4770.01 | 5488.0 |
| 2022-08-22 02:00:00 | ES | Futures | 4770.29 | 4771.42 | 4762.08 | 4767.46 | 11893.0 |
| 2022-08-22 03:00:00 | ES | Futures | 4767.46 | 4773.69 | 4743.95 | 4746.5 | 28947.0 |
| 2022-08-22 04:00:00 | ES | Futures | 4746.5 | 4747.63 | 4734.32 | 4741.68 | 30291.0 |
| 2022-08-22 05:00:00 | ES | Futures | 4741.4 | 4742.53 | 4731.2 | 4738.0 | 19657.0 |
| 2022-08-22 06:00:00 | ES | Futures | 4738.28 | 4744.51 | 4737.15 | 4741.68 | 16443.0 |
| 2022-08-22 07:00:00 | ES | Futures | 4741.96 | 4746.5 | 4737.15 | 4741.96 | 15646.0 |
| 2022-08-22 08:00:00 | ES | Futures | 4741.68 | 4741.68 | 4734.88 | 4735.17 | 29171.0 |
| 2022-08-22 09:00:00 | ES | Futures | 4735.17 | 4739.13 | 4718.17 | 4724.97 | 214280.0 |
| 2022-08-22 10:00:00 | ES | Futures | 4724.97 | 4725.54 | 4703.72 | 4703.72 | 258875.0 |
| 2022-08-22 11:00:00 | ES | Futures | 4703.72 | 4719.59 | 4703.44 | 4716.47 | 176276.0 |
| 2022-08-22 12:00:00 | ES | Futures | 4716.47 | 4719.87 | 4707.41 | 4713.07 | 135527.0 |
| 2022-08-22 13:00:00 | ES | Futures | 4712.79 | 4713.64 | 4691.26 | 4692.68 | 147454.0 |
| 2022-08-22 14:00:00 | ES | Futures | 4692.39 | 4694.94 | 4683.04 | 4686.73 | 136416.0 |
| 2022-08-22 15:00:00 | ES | Futures | 4686.73 | 4697.21 | 4681.34 | 4694.09 | 330538.0 |
| 2022-08-22 16:00:00 | ES | Futures | 4694.09 | 4699.19 | 4692.96 | 4698.34 | 57751.0 |
| 2022-08-22 18:00:00 | ES | Futures | 4698.91 | 4702.59 | 4695.22 | 4701.17 | 5862.0 |
| 2022-08-22 19:00:00 | ES | Futures | 4700.89 | 4705.99 | 4700.04 | 4704.86 | 6329.0 |
| 2022-08-22 20:00:00 | ES | Futures | 4705.14 | 4706.27 | 4695.22 | 4696.36 | 10373.0 |
| 2022-08-22 21:00:00 | ES | Futures | 4696.07 | 4702.87 | 4694.66 | 4696.64 | 10418.0 |
| 2022-08-22 22:00:00 | ES | Futures | 4696.36 | 4704.29 | 4696.36 | 4703.16 | 5241.0 |
| 2022-08-22 23:00:00 | ES | Futures | 4703.16 | 4704.29 | 4698.34 | 4698.91 | 4443.0 |
| 2022-08-22 00:00:00 | NQ | Futures | 15279.92 | 15280.5 | 15260.25 | 15260.25 | 1774.0 |
| 2022-08-22 01:00:00 | NQ | Futures | 15261.12 | 15268.64 | 15245.79 | 15255.62 | 3184.0 |
| 2022-08-22 02:00:00 | NQ | Futures | 15254.76 | 15260.83 | 15216.58 | 15233.93 | 7285.0 |
| 2022-08-22 03:00:00 | NQ | Futures | 15233.64 | 15259.1 | 15148.61 | 15165.38 | 15601.0 |
| 2022-08-22 04:00:00 | NQ | Futures | 15164.8 | 15170.59 | 15102.62 | 15122.57 | 16290.0 |
| 2022-08-22 05:00:00 | NQ | Futures | 15122.57 | 15129.81 | 15094.52 | 15118.81 | 8432.0 |
| 2022-08-22 06:00:00 | NQ | Futures | 15119.1 | 15148.61 | 15114.76 | 15126.62 | 8378.0 |
| 2022-08-22 07:00:00 | NQ | Futures | 15127.2 | 15141.95 | 15104.06 | 15124.6 | 8829.0 |
| 2022-08-22 08:00:00 | NQ | Futures | 15124.31 | 15128.36 | 15099.44 | 15115.63 | 12063.0 |
| 2022-08-22 09:00:00 | NQ | Futures | 15115.34 | 15147.16 | 15046.79 | 15072.25 | 85111.0 |
| 2022-08-22 10:00:00 | NQ | Futures | 15072.83 | 15076.59 | 14983.74 | 14984.32 | 93950.0 |
| 2022-08-22 11:00:00 | NQ | Futures | 14984.61 | 15039.85 | 14977.09 | 15029.73 | 60427.0 |
| 2022-08-22 12:00:00 | NQ | Futures | 15029.73 | 15042.17 | 14994.15 | 15014.69 | 43713.0 |
| 2022-08-22 13:00:00 | NQ | Futures | 15013.82 | 15017.58 | 14947.87 | 14952.5 | 42222.0 |
| 2022-08-22 14:00:00 | NQ | Futures | 14952.21 | 14968.12 | 14911.43 | 14929.07 | 50292.0 |
| 2022-08-22 15:00:00 | NQ | Futures | 14928.78 | 14958.0 | 14895.23 | 14943.25 | 91316.0 |
| 2022-08-22 16:00:00 | NQ | Futures | 14943.25 | 14968.41 | 14935.15 | 14963.49 | 15789.0 |
| 2022-08-22 18:00:00 | NQ | Futures | 14963.78 | 14977.09 | 14950.19 | 14971.3 | 2685.0 |
| 2022-08-22 19:00:00 | NQ | Futures | 14970.43 | 14990.1 | 14966.96 | 14988.95 | 3055.0 |
| 2022-08-22 20:00:00 | NQ | Futures | 14988.95 | 14991.26 | 14951.92 | 14957.13 | 4083.0 |
| 2022-08-22 21:00:00 | NQ | Futures | 14957.13 | 14979.11 | 14950.77 | 14952.79 | 4330.0 |
| 2022-08-22 22:00:00 | NQ | Futures | 14953.66 | 14980.85 | 14953.66 | 14975.93 | 2630.0 |
| 2022-08-22 23:00:00 | NQ | Futures | 14976.51 | 14979.11 | 14963.2 | 14964.07 | 1755.0 |
| 2022-08-22 00:00:00 | YM | Futures | 37890.9 | 37892.0 | 37860.4 | 37861.6 | 488.0 |
| 2022-08-22 01:00:00 | YM | Futures | 37861.6 | 37895.4 | 37854.8 | 37861.6 | 826.0 |
| 2022-08-22 02:00:00 | YM | Futures | 37861.6 | 37869.5 | 37813.0 | 37861.6 | 3140.0 |
| 2022-08-22 03:00:00 | YM | Futures | 37862.7 | 37899.9 | 37692.3 | 37705.9 | 7148.0 |
> showing 50 of 2,016 rows — these rows as CSV