PREVIEW / futures_1hour / 2022-04-13
file: by_date/futures_1hour/2022/2022-04-13.parquet size: 69 KB rows: 2,059
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-04-13 00:00:00 | ES | Futures | 5005.84 | 5006.4 | 4999.03 | 5003.29 | 4522.0 |
| 2022-04-13 01:00:00 | ES | Futures | 5003.29 | 5020.86 | 5002.44 | 5019.73 | 11536.0 |
| 2022-04-13 02:00:00 | ES | Futures | 5019.73 | 5020.29 | 5006.97 | 5008.67 | 11393.0 |
| 2022-04-13 03:00:00 | ES | Futures | 5008.67 | 5011.79 | 4999.03 | 5006.97 | 21441.0 |
| 2022-04-13 04:00:00 | ES | Futures | 5006.97 | 5018.03 | 5005.84 | 5014.62 | 13259.0 |
| 2022-04-13 05:00:00 | ES | Futures | 5014.34 | 5015.47 | 4993.37 | 4993.93 | 12624.0 |
| 2022-04-13 06:00:00 | ES | Futures | 4993.93 | 5008.39 | 4992.8 | 5007.54 | 15441.0 |
| 2022-04-13 07:00:00 | ES | Futures | 5007.82 | 5013.21 | 4985.15 | 4987.7 | 23485.0 |
| 2022-04-13 08:00:00 | ES | Futures | 4987.7 | 4989.96 | 4971.82 | 4975.23 | 50808.0 |
| 2022-04-13 09:00:00 | ES | Futures | 4975.51 | 5001.87 | 4970.41 | 4987.7 | 190038.0 |
| 2022-04-13 10:00:00 | ES | Futures | 4987.41 | 4997.9 | 4978.63 | 4996.48 | 163290.0 |
| 2022-04-13 11:00:00 | ES | Futures | 4996.2 | 5021.14 | 4995.92 | 5010.09 | 136338.0 |
| 2022-04-13 12:00:00 | ES | Futures | 5010.09 | 5027.95 | 5006.97 | 5021.71 | 96684.0 |
| 2022-04-13 13:00:00 | ES | Futures | 5021.71 | 5030.5 | 5015.47 | 5021.43 | 78377.0 |
| 2022-04-13 14:00:00 | ES | Futures | 5021.43 | 5032.76 | 5018.03 | 5030.21 | 94372.0 |
| 2022-04-13 15:00:00 | ES | Futures | 5030.21 | 5044.67 | 5024.54 | 5036.73 | 199235.0 |
| 2022-04-13 16:00:00 | ES | Futures | 5036.73 | 5037.58 | 5031.63 | 5031.91 | 46130.0 |
| 2022-04-13 18:00:00 | ES | Futures | 5032.2 | 5037.02 | 5031.63 | 5036.73 | 3662.0 |
| 2022-04-13 19:00:00 | ES | Futures | 5036.73 | 5037.02 | 5031.63 | 5032.48 | 4597.0 |
| 2022-04-13 20:00:00 | ES | Futures | 5032.76 | 5040.98 | 5031.91 | 5037.58 | 8577.0 |
| 2022-04-13 21:00:00 | ES | Futures | 5037.58 | 5040.42 | 5033.33 | 5039.57 | 6237.0 |
| 2022-04-13 22:00:00 | ES | Futures | 5039.85 | 5043.25 | 5038.43 | 5040.42 | 5229.0 |
| 2022-04-13 23:00:00 | ES | Futures | 5040.42 | 5043.82 | 5038.15 | 5040.42 | 4282.0 |
| 2022-04-13 00:00:00 | NQ | Futures | 16285.29 | 16287.9 | 16251.94 | 16274.56 | 2681.0 |
| 2022-04-13 01:00:00 | NQ | Futures | 16274.85 | 16353.14 | 16268.76 | 16350.82 | 6605.0 |
| 2022-04-13 02:00:00 | NQ | Futures | 16349.95 | 16353.14 | 16290.51 | 16304.14 | 6386.0 |
| 2022-04-13 03:00:00 | NQ | Futures | 16304.14 | 16318.06 | 16258.9 | 16290.22 | 10852.0 |
| 2022-04-13 04:00:00 | NQ | Futures | 16289.93 | 16329.94 | 16286.16 | 16316.9 | 8465.0 |
| 2022-04-13 05:00:00 | NQ | Futures | 16316.03 | 16327.04 | 16230.48 | 16237.44 | 8335.0 |
| 2022-04-13 06:00:00 | NQ | Futures | 16237.15 | 16295.44 | 16230.48 | 16291.38 | 8470.0 |
| 2022-04-13 07:00:00 | NQ | Futures | 16291.38 | 16314.58 | 16208.16 | 16215.98 | 11319.0 |
| 2022-04-13 08:00:00 | NQ | Futures | 16215.4 | 16228.16 | 16152.19 | 16182.06 | 26662.0 |
| 2022-04-13 09:00:00 | NQ | Futures | 16182.64 | 16321.25 | 16146.97 | 16255.13 | 86418.0 |
| 2022-04-13 10:00:00 | NQ | Futures | 16256.0 | 16375.47 | 16231.06 | 16315.74 | 80642.0 |
| 2022-04-13 11:00:00 | NQ | Futures | 16316.32 | 16441.01 | 16314.58 | 16416.36 | 54732.0 |
| 2022-04-13 12:00:00 | NQ | Futures | 16416.36 | 16472.61 | 16385.33 | 16455.79 | 40024.0 |
| 2022-04-13 13:00:00 | NQ | Futures | 16455.5 | 16479.28 | 16392.29 | 16425.64 | 40988.0 |
| 2022-04-13 14:00:00 | NQ | Futures | 16425.93 | 16485.37 | 16412.88 | 16475.51 | 34405.0 |
| 2022-04-13 15:00:00 | NQ | Futures | 16475.8 | 16547.72 | 16448.54 | 16495.81 | 63211.0 |
| 2022-04-13 16:00:00 | NQ | Futures | 16495.23 | 16501.03 | 16480.44 | 16484.79 | 11712.0 |
| 2022-04-13 18:00:00 | NQ | Futures | 16483.92 | 16517.85 | 16483.92 | 16512.34 | 2309.0 |
| 2022-04-13 19:00:00 | NQ | Futures | 16512.34 | 16513.5 | 16485.08 | 16487.98 | 2595.0 |
| 2022-04-13 20:00:00 | NQ | Futures | 16490.59 | 16532.06 | 16486.53 | 16507.99 | 4130.0 |
| 2022-04-13 21:00:00 | NQ | Futures | 16507.99 | 16521.33 | 16488.85 | 16519.88 | 3485.0 |
| 2022-04-13 22:00:00 | NQ | Futures | 16519.3 | 16536.12 | 16513.21 | 16525.1 | 3262.0 |
| 2022-04-13 23:00:00 | NQ | Futures | 16525.1 | 16553.52 | 16520.46 | 16539.31 | 3415.0 |
| 2022-04-13 00:00:00 | YM | Futures | 38664.1 | 38665.2 | 38623.5 | 38641.5 | 1011.0 |
| 2022-04-13 01:00:00 | YM | Futures | 38640.4 | 38741.8 | 38633.6 | 38737.3 | 2099.0 |
| 2022-04-13 02:00:00 | YM | Futures | 38738.5 | 38744.1 | 38647.2 | 38659.6 | 2594.0 |
| 2022-04-13 03:00:00 | YM | Futures | 38658.4 | 38690.0 | 38598.7 | 38662.9 | 5306.0 |
> showing 50 of 2,059 rows — these rows as CSV