PREVIEW / futures_1hour / 2022-06-08
file: by_date/futures_1hour/2022/2022-06-08.parquet size: 66 KB rows: 2,019
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-06-08 00:00:00 | ES | Futures | 4697.45 | 4700.86 | 4693.2 | 4693.2 | 8242.0 |
| 2022-06-08 01:00:00 | ES | Futures | 4693.2 | 4704.26 | 4693.2 | 4702.27 | 13498.0 |
| 2022-06-08 02:00:00 | ES | Futures | 4702.56 | 4707.09 | 4697.45 | 4702.84 | 13594.0 |
| 2022-06-08 03:00:00 | ES | Futures | 4702.84 | 4702.84 | 4688.1 | 4694.05 | 28900.0 |
| 2022-06-08 04:00:00 | ES | Futures | 4694.05 | 4702.27 | 4689.8 | 4698.87 | 21844.0 |
| 2022-06-08 05:00:00 | ES | Futures | 4698.59 | 4700.57 | 4691.5 | 4698.02 | 10250.0 |
| 2022-06-08 06:00:00 | ES | Futures | 4698.02 | 4701.99 | 4690.09 | 4699.72 | 10578.0 |
| 2022-06-08 07:00:00 | ES | Futures | 4699.72 | 4709.08 | 4696.89 | 4700.57 | 15444.0 |
| 2022-06-08 08:00:00 | ES | Futures | 4700.86 | 4703.97 | 4687.25 | 4692.64 | 27022.0 |
| 2022-06-08 09:00:00 | ES | Futures | 4692.64 | 4716.45 | 4680.45 | 4710.21 | 171643.0 |
| 2022-06-08 10:00:00 | ES | Futures | 4710.21 | 4712.19 | 4687.53 | 4697.45 | 235930.0 |
| 2022-06-08 11:00:00 | ES | Futures | 4697.45 | 4715.03 | 4691.79 | 4704.82 | 170959.0 |
| 2022-06-08 12:00:00 | ES | Futures | 4705.11 | 4711.63 | 4667.69 | 4681.02 | 167931.0 |
| 2022-06-08 13:00:00 | ES | Futures | 4681.02 | 4681.3 | 4657.49 | 4667.41 | 160257.0 |
| 2022-06-08 14:00:00 | ES | Futures | 4667.41 | 4673.08 | 4654.66 | 4664.01 | 181180.0 |
| 2022-06-08 15:00:00 | ES | Futures | 4664.01 | 4678.46 | 4654.37 | 4664.58 | 268623.0 |
| 2022-06-08 16:00:00 | ES | Futures | 4664.86 | 4669.11 | 4661.17 | 4666.84 | 42283.0 |
| 2022-06-08 18:00:00 | ES | Futures | 4666.56 | 4670.24 | 4664.01 | 4669.68 | 3701.0 |
| 2022-06-08 19:00:00 | ES | Futures | 4669.39 | 4671.09 | 4667.41 | 4669.11 | 2408.0 |
| 2022-06-08 20:00:00 | ES | Futures | 4669.39 | 4673.08 | 4656.64 | 4658.91 | 15274.0 |
| 2022-06-08 21:00:00 | ES | Futures | 4659.19 | 4662.31 | 4650.12 | 4654.09 | 11123.0 |
| 2022-06-08 22:00:00 | ES | Futures | 4654.09 | 4659.19 | 4652.67 | 4658.34 | 5119.0 |
| 2022-06-08 23:00:00 | ES | Futures | 4658.62 | 4663.73 | 4656.07 | 4662.31 | 4026.0 |
| 2022-06-08 00:00:00 | NQ | Futures | 14681.44 | 14691.01 | 14658.53 | 14659.69 | 4043.0 |
| 2022-06-08 01:00:00 | NQ | Futures | 14659.98 | 14696.52 | 14657.95 | 14687.24 | 4935.0 |
| 2022-06-08 02:00:00 | NQ | Futures | 14688.4 | 14713.33 | 14672.16 | 14698.55 | 5515.0 |
| 2022-06-08 03:00:00 | NQ | Futures | 14699.99 | 14700.28 | 14642.87 | 14677.67 | 11840.0 |
| 2022-06-08 04:00:00 | NQ | Futures | 14677.67 | 14722.61 | 14668.97 | 14708.11 | 10051.0 |
| 2022-06-08 05:00:00 | NQ | Futures | 14707.82 | 14725.51 | 14685.79 | 14709.56 | 6669.0 |
| 2022-06-08 06:00:00 | NQ | Futures | 14709.56 | 14728.99 | 14673.9 | 14720.29 | 8473.0 |
| 2022-06-08 07:00:00 | NQ | Futures | 14720.0 | 14756.54 | 14706.08 | 14713.04 | 10671.0 |
| 2022-06-08 08:00:00 | NQ | Futures | 14713.33 | 14724.06 | 14650.99 | 14678.83 | 14983.0 |
| 2022-06-08 09:00:00 | NQ | Futures | 14678.25 | 14827.0 | 14646.64 | 14800.04 | 78644.0 |
| 2022-06-08 10:00:00 | NQ | Futures | 14800.04 | 14816.56 | 14715.65 | 14748.13 | 79283.0 |
| 2022-06-08 11:00:00 | NQ | Futures | 14748.13 | 14816.56 | 14717.68 | 14760.89 | 56634.0 |
| 2022-06-08 12:00:00 | NQ | Futures | 14760.89 | 14786.99 | 14621.7 | 14668.68 | 66283.0 |
| 2022-06-08 13:00:00 | NQ | Futures | 14668.1 | 14669.84 | 14590.67 | 14653.02 | 52634.0 |
| 2022-06-08 14:00:00 | NQ | Futures | 14653.31 | 14676.8 | 14600.24 | 14633.59 | 50817.0 |
| 2022-06-08 15:00:00 | NQ | Futures | 14633.88 | 14682.31 | 14591.83 | 14636.78 | 70328.0 |
| 2022-06-08 16:00:00 | NQ | Futures | 14636.78 | 14647.8 | 14610.68 | 14637.07 | 14109.0 |
| 2022-06-08 18:00:00 | NQ | Futures | 14643.74 | 14650.12 | 14624.89 | 14647.22 | 1776.0 |
| 2022-06-08 19:00:00 | NQ | Futures | 14647.51 | 14653.02 | 14636.2 | 14642.87 | 1888.0 |
| 2022-06-08 20:00:00 | NQ | Futures | 14643.45 | 14657.37 | 14596.47 | 14608.36 | 5280.0 |
| 2022-06-08 21:00:00 | NQ | Futures | 14608.36 | 14619.96 | 14576.18 | 14588.06 | 5066.0 |
| 2022-06-08 22:00:00 | NQ | Futures | 14587.77 | 14606.62 | 14582.85 | 14603.43 | 2901.0 |
| 2022-06-08 23:00:00 | NQ | Futures | 14604.59 | 14623.44 | 14594.15 | 14615.32 | 2481.0 |
| 2022-06-08 00:00:00 | YM | Futures | 37277.4 | 37302.2 | 37251.5 | 37253.8 | 1055.0 |
| 2022-06-08 01:00:00 | YM | Futures | 37252.6 | 37332.7 | 37252.6 | 37319.2 | 1623.0 |
| 2022-06-08 02:00:00 | YM | Futures | 37321.4 | 37345.1 | 37283.1 | 37315.8 | 1615.0 |
| 2022-06-08 03:00:00 | YM | Futures | 37313.5 | 37314.6 | 37208.7 | 37234.6 | 3867.0 |
> showing 50 of 2,019 rows — these rows as CSV