PREVIEW / futures_1hour / 2022-06-09
file: by_date/futures_1hour/2022/2022-06-09.parquet size: 67 KB rows: 2,008
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-09 00:00:00 | ES | Futures | 4662.02 | 4663.16 | 4660.61 | 4661.46 | 3653.0 |
| 2022-06-09 01:00:00 | ES | Futures | 4661.46 | 4666.56 | 4653.52 | 4653.52 | 10775.0 |
| 2022-06-09 02:00:00 | ES | Futures | 4653.52 | 4662.59 | 4651.54 | 4662.59 | 12365.0 |
| 2022-06-09 03:00:00 | ES | Futures | 4662.59 | 4668.83 | 4654.66 | 4665.43 | 24233.0 |
| 2022-06-09 04:00:00 | ES | Futures | 4665.43 | 4684.42 | 4657.77 | 4683.57 | 23187.0 |
| 2022-06-09 05:00:00 | ES | Futures | 4683.57 | 4684.13 | 4676.2 | 4678.75 | 19619.0 |
| 2022-06-09 06:00:00 | ES | Futures | 4678.75 | 4695.47 | 4675.06 | 4689.52 | 26063.0 |
| 2022-06-09 07:00:00 | ES | Futures | 4689.52 | 4698.59 | 4672.8 | 4676.76 | 31453.0 |
| 2022-06-09 08:00:00 | ES | Futures | 4676.76 | 4677.05 | 4645.02 | 4649.55 | 58451.0 |
| 2022-06-09 09:00:00 | ES | Futures | 4649.55 | 4668.83 | 4631.41 | 4668.54 | 226563.0 |
| 2022-06-09 10:00:00 | ES | Futures | 4668.26 | 4669.11 | 4633.96 | 4642.18 | 211562.0 |
| 2022-06-09 11:00:00 | ES | Futures | 4642.47 | 4653.52 | 4627.73 | 4643.03 | 172298.0 |
| 2022-06-09 12:00:00 | ES | Futures | 4643.32 | 4655.51 | 4630.0 | 4653.52 | 133878.0 |
| 2022-06-09 13:00:00 | ES | Futures | 4653.24 | 4660.04 | 4630.0 | 4643.32 | 115669.0 |
| 2022-06-09 14:00:00 | ES | Futures | 4643.32 | 4643.32 | 4610.44 | 4611.01 | 167419.0 |
| 2022-06-09 15:00:00 | ES | Futures | 4611.01 | 4612.14 | 4551.77 | 4552.05 | 367607.0 |
| 2022-06-09 16:00:00 | ES | Futures | 4552.33 | 4562.25 | 4551.77 | 4561.12 | 75825.0 |
| 2022-06-09 18:00:00 | ES | Futures | 4563.67 | 4564.52 | 4554.6 | 4557.15 | 6264.0 |
| 2022-06-09 19:00:00 | ES | Futures | 4557.44 | 4563.95 | 4556.58 | 4559.7 | 5912.0 |
| 2022-06-09 20:00:00 | ES | Futures | 4559.99 | 4563.1 | 4550.92 | 4554.32 | 9903.0 |
| 2022-06-09 21:00:00 | ES | Futures | 4554.32 | 4556.87 | 4551.2 | 4554.32 | 7479.0 |
| 2022-06-09 22:00:00 | ES | Futures | 4554.03 | 4560.55 | 4553.18 | 4558.57 | 5019.0 |
| 2022-06-09 23:00:00 | ES | Futures | 4558.57 | 4568.49 | 4558.57 | 4563.1 | 5682.0 |
| 2022-06-09 00:00:00 | NQ | Futures | 14615.32 | 14619.09 | 14607.2 | 14610.97 | 1711.0 |
| 2022-06-09 01:00:00 | NQ | Futures | 14610.39 | 14630.4 | 14583.42 | 14586.9 | 4548.0 |
| 2022-06-09 02:00:00 | NQ | Futures | 14585.45 | 14616.48 | 14579.08 | 14616.48 | 4232.0 |
| 2022-06-09 03:00:00 | NQ | Futures | 14615.9 | 14638.23 | 14589.51 | 14630.11 | 10086.0 |
| 2022-06-09 04:00:00 | NQ | Futures | 14629.82 | 14706.95 | 14603.72 | 14706.37 | 11887.0 |
| 2022-06-09 05:00:00 | NQ | Futures | 14705.5 | 14712.75 | 14676.8 | 14686.95 | 8260.0 |
| 2022-06-09 06:00:00 | NQ | Futures | 14685.79 | 14760.89 | 14673.32 | 14720.58 | 13555.0 |
| 2022-06-09 07:00:00 | NQ | Futures | 14721.16 | 14751.9 | 14654.76 | 14665.2 | 16522.0 |
| 2022-06-09 08:00:00 | NQ | Futures | 14665.49 | 14666.65 | 14541.96 | 14565.16 | 31426.0 |
| 2022-06-09 09:00:00 | NQ | Futures | 14565.16 | 14677.96 | 14505.71 | 14659.98 | 89560.0 |
| 2022-06-09 10:00:00 | NQ | Futures | 14660.56 | 14699.7 | 14561.68 | 14593.86 | 90675.0 |
| 2022-06-09 11:00:00 | NQ | Futures | 14594.15 | 14630.98 | 14537.32 | 14581.98 | 67207.0 |
| 2022-06-09 12:00:00 | NQ | Futures | 14583.42 | 14611.84 | 14529.78 | 14600.82 | 47816.0 |
| 2022-06-09 13:00:00 | NQ | Futures | 14600.53 | 14624.02 | 14500.78 | 14548.34 | 49427.0 |
| 2022-06-09 14:00:00 | NQ | Futures | 14548.34 | 14548.92 | 14427.13 | 14428.29 | 51587.0 |
| 2022-06-09 15:00:00 | NQ | Futures | 14428.87 | 14432.06 | 14231.98 | 14233.43 | 113646.0 |
| 2022-06-09 16:00:00 | NQ | Futures | 14232.85 | 14270.54 | 14214.87 | 14263.58 | 21742.0 |
| 2022-06-09 18:00:00 | NQ | Futures | 14268.51 | 14274.6 | 14236.61 | 14245.89 | 3378.0 |
| 2022-06-09 19:00:00 | NQ | Futures | 14246.47 | 14268.51 | 14239.51 | 14253.14 | 4066.0 |
| 2022-06-09 20:00:00 | NQ | Futures | 14253.14 | 14267.35 | 14223.28 | 14240.38 | 5723.0 |
| 2022-06-09 21:00:00 | NQ | Futures | 14239.8 | 14255.46 | 14233.43 | 14244.15 | 4131.0 |
| 2022-06-09 22:00:00 | NQ | Futures | 14244.44 | 14271.12 | 14242.41 | 14262.71 | 3042.0 |
| 2022-06-09 23:00:00 | NQ | Futures | 14262.71 | 14303.89 | 14262.71 | 14277.21 | 3706.0 |
| 2022-06-09 00:00:00 | YM | Futures | 37074.5 | 37082.4 | 37062.1 | 37070.0 | 613.0 |
| 2022-06-09 01:00:00 | YM | Futures | 37070.0 | 37105.0 | 37011.4 | 37011.4 | 1643.0 |
| 2022-06-09 02:00:00 | YM | Futures | 37010.3 | 37074.5 | 36994.5 | 37074.5 | 1712.0 |
| 2022-06-09 03:00:00 | YM | Futures | 37073.4 | 37117.4 | 37015.9 | 37084.7 | 3432.0 |
> showing 50 of 2,008 rows — these rows as CSV