PREVIEW / futures_1hour / 2022-04-12
file: by_date/futures_1hour/2022/2022-04-12.parquet size: 69 KB rows: 2,075
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-12 00:00:00 | ES | Futures | 4974.66 | 4976.08 | 4969.56 | 4970.69 | 4931.0 |
| 2022-04-12 01:00:00 | ES | Futures | 4970.41 | 4982.03 | 4968.99 | 4977.78 | 11656.0 |
| 2022-04-12 02:00:00 | ES | Futures | 4977.78 | 4986.56 | 4972.96 | 4984.01 | 11775.0 |
| 2022-04-12 03:00:00 | ES | Futures | 4983.73 | 4985.71 | 4968.42 | 4979.48 | 21008.0 |
| 2022-04-12 04:00:00 | ES | Futures | 4979.19 | 4999.6 | 4977.49 | 4995.92 | 23365.0 |
| 2022-04-12 05:00:00 | ES | Futures | 4995.92 | 5002.72 | 4990.82 | 4998.75 | 14408.0 |
| 2022-04-12 06:00:00 | ES | Futures | 4998.75 | 5004.99 | 4994.78 | 5000.45 | 15332.0 |
| 2022-04-12 07:00:00 | ES | Futures | 5000.45 | 5005.55 | 4994.22 | 5004.99 | 22811.0 |
| 2022-04-12 08:00:00 | ES | Futures | 5004.99 | 5059.69 | 5002.72 | 5053.17 | 134425.0 |
| 2022-04-12 09:00:00 | ES | Futures | 5053.17 | 5064.23 | 5025.68 | 5056.57 | 250931.0 |
| 2022-04-12 10:00:00 | ES | Futures | 5056.29 | 5059.12 | 5023.98 | 5028.51 | 215814.0 |
| 2022-04-12 11:00:00 | ES | Futures | 5028.8 | 5050.62 | 5023.98 | 5040.7 | 140925.0 |
| 2022-04-12 12:00:00 | ES | Futures | 5040.98 | 5041.55 | 5012.92 | 5021.99 | 145287.0 |
| 2022-04-12 13:00:00 | ES | Futures | 5021.71 | 5029.36 | 4991.95 | 4994.5 | 170352.0 |
| 2022-04-12 14:00:00 | ES | Futures | 4994.22 | 5002.72 | 4976.08 | 4985.43 | 184025.0 |
| 2022-04-12 15:00:00 | ES | Futures | 4985.43 | 4987.7 | 4960.77 | 4978.63 | 238539.0 |
| 2022-04-12 16:00:00 | ES | Futures | 4978.91 | 4986.28 | 4974.66 | 4982.31 | 48350.0 |
| 2022-04-12 18:00:00 | ES | Futures | 4984.86 | 4989.4 | 4980.89 | 4989.11 | 6648.0 |
| 2022-04-12 19:00:00 | ES | Futures | 4989.11 | 4995.63 | 4988.83 | 4995.63 | 6909.0 |
| 2022-04-12 20:00:00 | ES | Futures | 4995.35 | 5000.17 | 4993.08 | 4999.32 | 8087.0 |
| 2022-04-12 21:00:00 | ES | Futures | 4999.6 | 5002.72 | 4998.18 | 5000.17 | 8425.0 |
| 2022-04-12 22:00:00 | ES | Futures | 5000.45 | 5004.7 | 4999.32 | 5002.44 | 6947.0 |
| 2022-04-12 23:00:00 | ES | Futures | 5002.72 | 5007.54 | 5002.72 | 5005.84 | 4993.0 |
| 2022-04-12 00:00:00 | NQ | Futures | 16151.32 | 16157.7 | 16126.09 | 16131.6 | 2845.0 |
| 2022-04-12 01:00:00 | NQ | Futures | 16132.18 | 16194.53 | 16125.8 | 16182.93 | 6764.0 |
| 2022-04-12 02:00:00 | NQ | Futures | 16182.93 | 16222.94 | 16167.27 | 16215.98 | 6613.0 |
| 2022-04-12 03:00:00 | NQ | Futures | 16215.69 | 16221.78 | 16148.13 | 16199.17 | 12078.0 |
| 2022-04-12 04:00:00 | NQ | Futures | 16198.59 | 16264.41 | 16186.99 | 16248.75 | 12877.0 |
| 2022-04-12 05:00:00 | NQ | Futures | 16249.33 | 16291.96 | 16222.94 | 16273.69 | 10717.0 |
| 2022-04-12 06:00:00 | NQ | Futures | 16273.98 | 16289.64 | 16245.85 | 16256.29 | 7279.0 |
| 2022-04-12 07:00:00 | NQ | Futures | 16256.87 | 16279.2 | 16223.23 | 16277.17 | 10738.0 |
| 2022-04-12 08:00:00 | NQ | Futures | 16277.46 | 16568.3 | 16263.54 | 16540.76 | 55287.0 |
| 2022-04-12 09:00:00 | NQ | Futures | 16539.6 | 16550.04 | 16369.67 | 16539.02 | 109142.0 |
| 2022-04-12 10:00:00 | NQ | Futures | 16539.31 | 16560.47 | 16340.67 | 16375.18 | 97859.0 |
| 2022-04-12 11:00:00 | NQ | Futures | 16374.02 | 16472.9 | 16337.48 | 16419.84 | 64025.0 |
| 2022-04-12 12:00:00 | NQ | Futures | 16419.84 | 16421.87 | 16309.94 | 16357.49 | 57854.0 |
| 2022-04-12 13:00:00 | NQ | Futures | 16357.78 | 16393.45 | 16234.54 | 16244.11 | 61618.0 |
| 2022-04-12 14:00:00 | NQ | Futures | 16244.4 | 16276.3 | 16141.75 | 16183.8 | 67104.0 |
| 2022-04-12 15:00:00 | NQ | Futures | 16183.51 | 16212.5 | 16100.86 | 16171.04 | 74528.0 |
| 2022-04-12 16:00:00 | NQ | Futures | 16171.04 | 16195.69 | 16146.39 | 16184.67 | 13205.0 |
| 2022-04-12 18:00:00 | NQ | Futures | 16183.8 | 16201.2 | 16170.75 | 16199.75 | 3631.0 |
| 2022-04-12 19:00:00 | NQ | Futures | 16199.17 | 16235.12 | 16198.01 | 16234.83 | 3908.0 |
| 2022-04-12 20:00:00 | NQ | Futures | 16234.25 | 16256.87 | 16222.65 | 16254.84 | 4394.0 |
| 2022-04-12 21:00:00 | NQ | Futures | 16254.84 | 16261.22 | 16243.24 | 16253.68 | 3123.0 |
| 2022-04-12 22:00:00 | NQ | Futures | 16254.26 | 16278.91 | 16251.36 | 16268.18 | 3152.0 |
| 2022-04-12 23:00:00 | NQ | Futures | 16268.76 | 16296.6 | 16268.76 | 16285.0 | 3095.0 |
| 2022-04-12 00:00:00 | YM | Futures | 38423.9 | 38436.3 | 38385.6 | 38390.1 | 929.0 |
| 2022-04-12 01:00:00 | YM | Futures | 38393.5 | 38469.0 | 38381.1 | 38427.3 | 2103.0 |
| 2022-04-12 02:00:00 | YM | Futures | 38426.2 | 38472.4 | 38389.0 | 38454.4 | 2639.0 |
| 2022-04-12 03:00:00 | YM | Futures | 38453.3 | 38465.7 | 38340.5 | 38419.4 | 4903.0 |
> showing 50 of 2,075 rows — these rows as CSV