PREVIEW / futures_1hour / 2022-10-12
file: by_date/futures_1hour/2022/2022-10-12.parquet size: 67 KB rows: 2,045
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-10-12 00:00:00 | ES | Futures | 4065.19 | 4086.33 | 4063.21 | 4078.15 | 16148.0 |
| 2022-10-12 01:00:00 | ES | Futures | 4078.15 | 4085.77 | 4070.54 | 4083.51 | 11087.0 |
| 2022-10-12 02:00:00 | ES | Futures | 4083.51 | 4099.01 | 4078.44 | 4086.89 | 24521.0 |
| 2022-10-12 03:00:00 | ES | Futures | 4086.61 | 4089.15 | 4064.91 | 4072.8 | 46505.0 |
| 2022-10-12 04:00:00 | ES | Futures | 4072.8 | 4085.77 | 4070.83 | 4080.41 | 22736.0 |
| 2022-10-12 05:00:00 | ES | Futures | 4080.13 | 4098.45 | 4076.46 | 4090.28 | 22981.0 |
| 2022-10-12 06:00:00 | ES | Futures | 4090.56 | 4095.91 | 4073.93 | 4082.95 | 26275.0 |
| 2022-10-12 07:00:00 | ES | Futures | 4082.95 | 4092.81 | 4080.41 | 4083.51 | 26726.0 |
| 2022-10-12 08:00:00 | ES | Futures | 4083.79 | 4096.2 | 4060.4 | 4068.85 | 94747.0 |
| 2022-10-12 09:00:00 | ES | Futures | 4068.57 | 4082.66 | 4042.92 | 4071.11 | 299157.0 |
| 2022-10-12 10:00:00 | ES | Futures | 4071.39 | 4078.72 | 4050.81 | 4060.4 | 296645.0 |
| 2022-10-12 11:00:00 | ES | Futures | 4060.4 | 4078.44 | 4058.99 | 4075.62 | 221127.0 |
| 2022-10-12 12:00:00 | ES | Futures | 4075.62 | 4082.38 | 4057.58 | 4068.29 | 139968.0 |
| 2022-10-12 13:00:00 | ES | Futures | 4068.29 | 4071.11 | 4054.19 | 4057.01 | 100690.0 |
| 2022-10-12 14:00:00 | ES | Futures | 4057.01 | 4077.59 | 4051.09 | 4057.86 | 214645.0 |
| 2022-10-12 15:00:00 | ES | Futures | 4058.14 | 4064.91 | 4044.89 | 4045.17 | 214941.0 |
| 2022-10-12 16:00:00 | ES | Futures | 4045.17 | 4052.5 | 4044.89 | 4051.66 | 53499.0 |
| 2022-10-12 18:00:00 | ES | Futures | 4055.04 | 4057.29 | 4051.94 | 4053.35 | 5368.0 |
| 2022-10-12 19:00:00 | ES | Futures | 4053.35 | 4058.99 | 4051.66 | 4057.29 | 4097.0 |
| 2022-10-12 20:00:00 | ES | Futures | 4057.01 | 4061.8 | 4052.78 | 4060.4 | 9451.0 |
| 2022-10-12 21:00:00 | ES | Futures | 4060.4 | 4062.09 | 4053.91 | 4055.32 | 8036.0 |
| 2022-10-12 22:00:00 | ES | Futures | 4055.04 | 4055.89 | 4048.27 | 4052.22 | 8778.0 |
| 2022-10-12 23:00:00 | ES | Futures | 4052.5 | 4054.48 | 4051.66 | 4052.22 | 4065.0 |
| 2022-10-12 00:00:00 | NQ | Futures | 12491.21 | 12561.03 | 12486.61 | 12533.44 | 8877.0 |
| 2022-10-12 01:00:00 | NQ | Futures | 12532.58 | 12570.22 | 12507.87 | 12564.76 | 7194.0 |
| 2022-10-12 02:00:00 | NQ | Futures | 12564.19 | 12615.62 | 12542.92 | 12576.83 | 16272.0 |
| 2022-10-12 03:00:00 | NQ | Futures | 12577.12 | 12583.15 | 12497.81 | 12533.16 | 23935.0 |
| 2022-10-12 04:00:00 | NQ | Futures | 12533.16 | 12569.07 | 12525.4 | 12550.11 | 14943.0 |
| 2022-10-12 05:00:00 | NQ | Futures | 12549.53 | 12612.46 | 12537.47 | 12585.45 | 14095.0 |
| 2022-10-12 06:00:00 | NQ | Futures | 12585.45 | 12604.12 | 12539.48 | 12564.76 | 12239.0 |
| 2022-10-12 07:00:00 | NQ | Futures | 12565.62 | 12596.08 | 12554.42 | 12572.81 | 12914.0 |
| 2022-10-12 08:00:00 | NQ | Futures | 12573.38 | 12605.27 | 12472.24 | 12513.62 | 41064.0 |
| 2022-10-12 09:00:00 | NQ | Futures | 12513.04 | 12579.99 | 12418.8 | 12517.06 | 107908.0 |
| 2022-10-12 10:00:00 | NQ | Futures | 12517.35 | 12536.89 | 12421.1 | 12453.57 | 102381.0 |
| 2022-10-12 11:00:00 | NQ | Futures | 12455.29 | 12552.41 | 12448.97 | 12541.78 | 71173.0 |
| 2022-10-12 12:00:00 | NQ | Futures | 12542.06 | 12556.43 | 12460.75 | 12507.3 | 55156.0 |
| 2022-10-12 13:00:00 | NQ | Futures | 12507.01 | 12521.95 | 12455.58 | 12469.37 | 38651.0 |
| 2022-10-12 14:00:00 | NQ | Futures | 12468.51 | 12549.53 | 12447.24 | 12477.7 | 82263.0 |
| 2022-10-12 15:00:00 | NQ | Futures | 12477.99 | 12510.46 | 12452.99 | 12455.29 | 65045.0 |
| 2022-10-12 16:00:00 | NQ | Futures | 12454.72 | 12474.54 | 12451.27 | 12473.39 | 14813.0 |
| 2022-10-12 18:00:00 | NQ | Futures | 12480.29 | 12487.47 | 12469.66 | 12475.98 | 2024.0 |
| 2022-10-12 19:00:00 | NQ | Futures | 12475.98 | 12496.38 | 12471.38 | 12491.78 | 2189.0 |
| 2022-10-12 20:00:00 | NQ | Futures | 12491.21 | 12500.97 | 12477.41 | 12496.09 | 3925.0 |
| 2022-10-12 21:00:00 | NQ | Futures | 12496.66 | 12502.7 | 12472.53 | 12480.0 | 4042.0 |
| 2022-10-12 22:00:00 | NQ | Futures | 12479.43 | 12481.44 | 12452.42 | 12465.92 | 4445.0 |
| 2022-10-12 23:00:00 | NQ | Futures | 12465.63 | 12475.4 | 12463.05 | 12469.94 | 2298.0 |
| 2022-10-12 00:00:00 | YM | Futures | 32893.8 | 33040.8 | 32882.6 | 32990.3 | 2367.0 |
| 2022-10-12 01:00:00 | YM | Futures | 32991.4 | 33037.4 | 32937.6 | 33013.9 | 1652.0 |
| 2022-10-12 02:00:00 | YM | Futures | 33016.1 | 33135.1 | 32981.3 | 33040.8 | 3690.0 |
| 2022-10-12 03:00:00 | YM | Futures | 33038.6 | 33058.8 | 32879.2 | 32924.1 | 5542.0 |
> showing 50 of 2,045 rows — these rows as CSV