PREVIEW / futures_1hour / 2022-08-26
file: by_date/futures_1hour/2022/2022-08-26.parquet size: 57 KB rows: 1,635
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-26 00:00:00 | ES | Futures | 4756.98 | 4757.26 | 4753.01 | 4753.58 | 3603.0 |
| 2022-08-26 01:00:00 | ES | Futures | 4753.86 | 4755.0 | 4749.9 | 4751.31 | 5754.0 |
| 2022-08-26 02:00:00 | ES | Futures | 4751.31 | 4754.15 | 4748.2 | 4753.01 | 8406.0 |
| 2022-08-26 03:00:00 | ES | Futures | 4753.01 | 4757.83 | 4745.65 | 4747.91 | 17425.0 |
| 2022-08-26 04:00:00 | ES | Futures | 4747.91 | 4750.75 | 4741.4 | 4745.65 | 14724.0 |
| 2022-08-26 05:00:00 | ES | Futures | 4745.65 | 4747.35 | 4739.98 | 4742.25 | 12124.0 |
| 2022-08-26 06:00:00 | ES | Futures | 4742.25 | 4745.36 | 4738.85 | 4741.68 | 10822.0 |
| 2022-08-26 07:00:00 | ES | Futures | 4741.68 | 4749.9 | 4736.3 | 4747.91 | 17523.0 |
| 2022-08-26 08:00:00 | ES | Futures | 4747.63 | 4761.23 | 4742.53 | 4760.09 | 58807.0 |
| 2022-08-26 09:00:00 | ES | Futures | 4759.81 | 4778.51 | 4744.23 | 4756.98 | 151019.0 |
| 2022-08-26 10:00:00 | ES | Futures | 4756.98 | 4766.04 | 4674.83 | 4683.61 | 493345.0 |
| 2022-08-26 11:00:00 | ES | Futures | 4683.61 | 4685.03 | 4652.73 | 4664.63 | 289863.0 |
| 2022-08-26 12:00:00 | ES | Futures | 4664.63 | 4664.63 | 4644.8 | 4656.13 | 174094.0 |
| 2022-08-26 13:00:00 | ES | Futures | 4655.85 | 4659.82 | 4639.42 | 4641.69 | 134521.0 |
| 2022-08-26 14:00:00 | ES | Futures | 4641.69 | 4644.52 | 4621.86 | 4622.99 | 173032.0 |
| 2022-08-26 15:00:00 | ES | Futures | 4622.99 | 4628.66 | 4598.35 | 4599.2 | 429453.0 |
| 2022-08-26 16:00:00 | ES | Futures | 4599.2 | 4599.76 | 4580.78 | 4580.78 | 101441.0 |
| 2022-08-26 00:00:00 | NQ | Futures | 15215.42 | 15216.58 | 15198.64 | 15200.67 | 1743.0 |
| 2022-08-26 01:00:00 | NQ | Futures | 15201.25 | 15205.01 | 15174.35 | 15179.84 | 3485.0 |
| 2022-08-26 02:00:00 | NQ | Futures | 15179.27 | 15191.41 | 15166.83 | 15188.81 | 3716.0 |
| 2022-08-26 03:00:00 | NQ | Futures | 15188.23 | 15209.35 | 15161.91 | 15166.83 | 7493.0 |
| 2022-08-26 04:00:00 | NQ | Futures | 15167.41 | 15176.95 | 15141.09 | 15154.1 | 7949.0 |
| 2022-08-26 05:00:00 | NQ | Futures | 15153.81 | 15159.6 | 15127.78 | 15139.06 | 6982.0 |
| 2022-08-26 06:00:00 | NQ | Futures | 15139.06 | 15152.37 | 15130.67 | 15143.69 | 4505.0 |
| 2022-08-26 07:00:00 | NQ | Futures | 15143.69 | 15176.08 | 15119.68 | 15166.54 | 8763.0 |
| 2022-08-26 08:00:00 | NQ | Futures | 15166.25 | 15233.35 | 15142.24 | 15222.65 | 24839.0 |
| 2022-08-26 09:00:00 | NQ | Futures | 15222.94 | 15294.96 | 15138.48 | 15196.91 | 69884.0 |
| 2022-08-26 10:00:00 | NQ | Futures | 15198.35 | 15270.09 | 14888.58 | 14914.61 | 162954.0 |
| 2022-08-26 11:00:00 | NQ | Futures | 14914.32 | 14921.84 | 14783.3 | 14824.08 | 89233.0 |
| 2022-08-26 12:00:00 | NQ | Futures | 14824.66 | 14825.82 | 14761.6 | 14813.09 | 60801.0 |
| 2022-08-26 13:00:00 | NQ | Futures | 14813.09 | 14831.6 | 14734.13 | 14745.7 | 55781.0 |
| 2022-08-26 14:00:00 | NQ | Futures | 14745.41 | 14754.08 | 14693.34 | 14700.57 | 67200.0 |
| 2022-08-26 15:00:00 | NQ | Futures | 14700.57 | 14724.58 | 14596.45 | 14599.63 | 121584.0 |
| 2022-08-26 16:00:00 | NQ | Futures | 14599.63 | 14605.7 | 14528.48 | 14530.21 | 28468.0 |
| 2022-08-26 00:00:00 | YM | Futures | 37529.8 | 37532.1 | 37499.4 | 37501.6 | 577.0 |
| 2022-08-26 01:00:00 | YM | Futures | 37502.8 | 37508.4 | 37483.6 | 37496.0 | 842.0 |
| 2022-08-26 02:00:00 | YM | Futures | 37494.9 | 37515.2 | 37477.9 | 37505.0 | 1584.0 |
| 2022-08-26 03:00:00 | YM | Futures | 37506.1 | 37544.5 | 37459.9 | 37475.7 | 3619.0 |
| 2022-08-26 04:00:00 | YM | Futures | 37476.8 | 37494.9 | 37437.3 | 37466.6 | 3489.0 |
| 2022-08-26 05:00:00 | YM | Futures | 37467.8 | 37479.1 | 37439.6 | 37456.5 | 3098.0 |
| 2022-08-26 06:00:00 | YM | Futures | 37456.5 | 37471.2 | 37423.8 | 37446.3 | 2886.0 |
| 2022-08-26 07:00:00 | YM | Futures | 37447.5 | 37503.9 | 37409.1 | 37491.5 | 4161.0 |
| 2022-08-26 08:00:00 | YM | Futures | 37491.5 | 37606.6 | 37475.7 | 37600.9 | 11236.0 |
| 2022-08-26 09:00:00 | YM | Futures | 37600.9 | 37736.3 | 37521.9 | 37603.2 | 23166.0 |
| 2022-08-26 10:00:00 | YM | Futures | 37591.9 | 37603.2 | 37007.4 | 37058.2 | 54517.0 |
| 2022-08-26 11:00:00 | YM | Futures | 37059.3 | 37069.5 | 36877.7 | 36913.8 | 20344.0 |
| 2022-08-26 12:00:00 | YM | Futures | 36914.9 | 36914.9 | 36773.8 | 36850.6 | 12507.0 |
| 2022-08-26 13:00:00 | YM | Futures | 36846.1 | 36867.5 | 36723.1 | 36734.4 | 8273.0 |
| 2022-08-26 14:00:00 | YM | Futures | 36734.4 | 36763.7 | 36582.0 | 36582.0 | 12409.0 |
| 2022-08-26 15:00:00 | YM | Futures | 36580.9 | 36617.0 | 36390.2 | 36401.5 | 24455.0 |
> showing 50 of 1,635 rows — these rows as CSV