PREVIEW / futures_1hour / 2022-12-14
file: by_date/futures_1hour/2022/2022-12-14.parquet size: 65 KB rows: 1,989
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-12-14 00:00:00 | ES | Futures | 4549.2 | 4552.55 | 4548.36 | 4549.76 | 3292.0 |
| 2022-12-14 01:00:00 | ES | Futures | 4549.76 | 4552.83 | 4547.52 | 4549.2 | 4984.0 |
| 2022-12-14 02:00:00 | ES | Futures | 4549.2 | 4549.76 | 4538.01 | 4538.29 | 9064.0 |
| 2022-12-14 03:00:00 | ES | Futures | 4538.57 | 4543.05 | 4534.66 | 4539.97 | 17267.0 |
| 2022-12-14 04:00:00 | ES | Futures | 4539.69 | 4540.53 | 4529.63 | 4535.5 | 14178.0 |
| 2022-12-14 05:00:00 | ES | Futures | 4535.5 | 4540.53 | 4532.7 | 4535.22 | 9800.0 |
| 2022-12-14 06:00:00 | ES | Futures | 4534.94 | 4536.34 | 4524.87 | 4536.06 | 11798.0 |
| 2022-12-14 07:00:00 | ES | Futures | 4535.78 | 4544.17 | 4526.83 | 4529.91 | 22580.0 |
| 2022-12-14 08:00:00 | ES | Futures | 4529.91 | 4534.66 | 4523.47 | 4533.54 | 26237.0 |
| 2022-12-14 09:00:00 | ES | Futures | 4532.98 | 4558.71 | 4527.67 | 4557.03 | 146746.0 |
| 2022-12-14 10:00:00 | ES | Futures | 4557.03 | 4564.58 | 4552.83 | 4561.78 | 128853.0 |
| 2022-12-14 11:00:00 | ES | Futures | 4561.5 | 4570.45 | 4558.98 | 4560.1 | 111919.0 |
| 2022-12-14 12:00:00 | ES | Futures | 4560.1 | 4562.06 | 4553.11 | 4553.67 | 81602.0 |
| 2022-12-14 13:00:00 | ES | Futures | 4553.95 | 4575.2 | 4553.11 | 4567.09 | 81654.0 |
| 2022-12-14 14:00:00 | ES | Futures | 4568.77 | 4570.17 | 4470.35 | 4499.99 | 425376.0 |
| 2022-12-14 15:00:00 | ES | Futures | 4499.99 | 4553.67 | 4487.13 | 4506.42 | 387952.0 |
| 2022-12-14 16:00:00 | ES | Futures | 4506.42 | 4520.68 | 4503.9 | 4516.48 | 56173.0 |
| 2022-12-14 18:00:00 | ES | Futures | 4515.09 | 4521.52 | 4511.17 | 4515.93 | 8401.0 |
| 2022-12-14 19:00:00 | ES | Futures | 4515.93 | 4521.8 | 4513.13 | 4521.52 | 7389.0 |
| 2022-12-14 20:00:00 | ES | Futures | 4521.52 | 4521.8 | 4508.1 | 4510.05 | 16804.0 |
| 2022-12-14 21:00:00 | ES | Futures | 4510.05 | 4512.29 | 4503.9 | 4506.42 | 10352.0 |
| 2022-12-14 22:00:00 | ES | Futures | 4506.42 | 4510.89 | 4501.67 | 4508.94 | 5730.0 |
| 2022-12-14 23:00:00 | ES | Futures | 4508.94 | 4509.77 | 4505.58 | 4508.94 | 3758.0 |
| 2022-12-14 00:00:00 | NQ | Futures | 13653.44 | 13666.53 | 13650.31 | 13653.44 | 1525.0 |
| 2022-12-14 01:00:00 | NQ | Futures | 13652.87 | 13663.4 | 13640.35 | 13651.45 | 2718.0 |
| 2022-12-14 02:00:00 | NQ | Futures | 13652.02 | 13653.15 | 13613.04 | 13615.32 | 3187.0 |
| 2022-12-14 03:00:00 | NQ | Futures | 13615.6 | 13632.39 | 13605.08 | 13628.4 | 6133.0 |
| 2022-12-14 04:00:00 | NQ | Futures | 13628.97 | 13635.23 | 13582.6 | 13604.22 | 6835.0 |
| 2022-12-14 05:00:00 | NQ | Futures | 13604.79 | 13623.0 | 13590.85 | 13599.95 | 4282.0 |
| 2022-12-14 06:00:00 | NQ | Futures | 13598.82 | 13605.93 | 13564.11 | 13603.65 | 6048.0 |
| 2022-12-14 07:00:00 | NQ | Futures | 13603.65 | 13629.54 | 13580.89 | 13591.42 | 6694.0 |
| 2022-12-14 08:00:00 | NQ | Futures | 13591.99 | 13600.24 | 13567.52 | 13593.41 | 11242.0 |
| 2022-12-14 09:00:00 | NQ | Futures | 13593.13 | 13673.07 | 13566.67 | 13666.24 | 57016.0 |
| 2022-12-14 10:00:00 | NQ | Futures | 13666.53 | 13705.79 | 13654.58 | 13689.29 | 50859.0 |
| 2022-12-14 11:00:00 | NQ | Futures | 13690.14 | 13726.84 | 13672.78 | 13693.55 | 45192.0 |
| 2022-12-14 12:00:00 | NQ | Futures | 13693.84 | 13695.26 | 13646.04 | 13647.75 | 27265.0 |
| 2022-12-14 13:00:00 | NQ | Futures | 13648.32 | 13734.8 | 13641.49 | 13712.61 | 33038.0 |
| 2022-12-14 14:00:00 | NQ | Futures | 13717.45 | 13719.44 | 13347.32 | 13467.1 | 167787.0 |
| 2022-12-14 15:00:00 | NQ | Futures | 13468.52 | 13669.66 | 13429.83 | 13499.53 | 111581.0 |
| 2022-12-14 16:00:00 | NQ | Futures | 13499.53 | 13539.07 | 13487.29 | 13529.12 | 12472.0 |
| 2022-12-14 18:00:00 | NQ | Futures | 13523.99 | 13539.64 | 13509.2 | 13522.57 | 3156.0 |
| 2022-12-14 19:00:00 | NQ | Futures | 13523.14 | 13538.79 | 13511.48 | 13537.37 | 2657.0 |
| 2022-12-14 20:00:00 | NQ | Futures | 13537.65 | 13539.64 | 13493.27 | 13499.53 | 3872.0 |
| 2022-12-14 21:00:00 | NQ | Futures | 13498.96 | 13505.79 | 13473.35 | 13486.44 | 3507.0 |
| 2022-12-14 22:00:00 | NQ | Futures | 13486.16 | 13500.67 | 13469.09 | 13491.56 | 2321.0 |
| 2022-12-14 23:00:00 | NQ | Futures | 13492.42 | 13496.4 | 13480.18 | 13492.42 | 1372.0 |
| 2022-12-14 00:00:00 | YM | Futures | 38422.6 | 38443.7 | 38413.6 | 38424.8 | 459.0 |
| 2022-12-14 01:00:00 | YM | Futures | 38423.7 | 38446.0 | 38409.2 | 38421.4 | 695.0 |
| 2022-12-14 02:00:00 | YM | Futures | 38418.1 | 38424.8 | 38344.6 | 38346.8 | 1044.0 |
| 2022-12-14 03:00:00 | YM | Futures | 38349.0 | 38380.2 | 38314.5 | 38349.0 | 2123.0 |
> showing 50 of 1,989 rows — these rows as CSV