PREVIEW / futures_1hour / 2022-06-03
file: by_date/futures_1hour/2022/2022-06-03.parquet size: 52 KB rows: 1,523
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-03 00:00:00 | ES | Futures | 4734.59 | 4740.54 | 4734.59 | 4735.44 | 3460.0 |
| 2022-06-03 01:00:00 | ES | Futures | 4735.15 | 4741.95 | 4734.59 | 4739.69 | 5252.0 |
| 2022-06-03 02:00:00 | ES | Futures | 4739.97 | 4742.52 | 4735.72 | 4736.0 | 7782.0 |
| 2022-06-03 03:00:00 | ES | Futures | 4736.29 | 4736.29 | 4721.55 | 4721.83 | 20301.0 |
| 2022-06-03 04:00:00 | ES | Futures | 4721.55 | 4727.5 | 4717.01 | 4721.83 | 17241.0 |
| 2022-06-03 05:00:00 | ES | Futures | 4722.11 | 4722.68 | 4712.48 | 4719.56 | 12797.0 |
| 2022-06-03 06:00:00 | ES | Futures | 4719.85 | 4720.13 | 4706.52 | 4708.51 | 13855.0 |
| 2022-06-03 07:00:00 | ES | Futures | 4708.23 | 4710.49 | 4694.05 | 4695.75 | 26390.0 |
| 2022-06-03 08:00:00 | ES | Futures | 4695.75 | 4718.43 | 4683.57 | 4690.09 | 81917.0 |
| 2022-06-03 09:00:00 | ES | Futures | 4690.09 | 4695.75 | 4665.99 | 4685.83 | 211857.0 |
| 2022-06-03 10:00:00 | ES | Futures | 4686.12 | 4696.32 | 4658.62 | 4664.86 | 236356.0 |
| 2022-06-03 11:00:00 | ES | Futures | 4664.86 | 4665.99 | 4644.73 | 4655.22 | 156916.0 |
| 2022-06-03 12:00:00 | ES | Futures | 4655.22 | 4675.91 | 4647.29 | 4674.78 | 117082.0 |
| 2022-06-03 13:00:00 | ES | Futures | 4674.78 | 4687.53 | 4654.66 | 4658.91 | 132482.0 |
| 2022-06-03 14:00:00 | ES | Futures | 4659.19 | 4674.5 | 4653.52 | 4667.98 | 108190.0 |
| 2022-06-03 15:00:00 | ES | Futures | 4668.26 | 4670.81 | 4648.42 | 4657.49 | 223631.0 |
| 2022-06-03 16:00:00 | ES | Futures | 4657.77 | 4664.01 | 4652.39 | 4659.19 | 50251.0 |
| 2022-06-03 00:00:00 | NQ | Futures | 14951.98 | 14973.15 | 14951.4 | 14952.85 | 1972.0 |
| 2022-06-03 01:00:00 | NQ | Futures | 14951.98 | 14971.99 | 14950.24 | 14964.45 | 2266.0 |
| 2022-06-03 02:00:00 | NQ | Futures | 14964.74 | 14970.25 | 14941.54 | 14947.05 | 3421.0 |
| 2022-06-03 03:00:00 | NQ | Futures | 14946.47 | 14948.5 | 14872.24 | 14878.04 | 10329.0 |
| 2022-06-03 04:00:00 | NQ | Futures | 14877.75 | 14902.4 | 14857.45 | 14891.96 | 9681.0 |
| 2022-06-03 05:00:00 | NQ | Futures | 14892.25 | 14896.6 | 14849.33 | 14879.2 | 6856.0 |
| 2022-06-03 06:00:00 | NQ | Futures | 14879.78 | 14881.52 | 14805.26 | 14814.83 | 10966.0 |
| 2022-06-03 07:00:00 | NQ | Futures | 14815.98 | 14827.87 | 14762.34 | 14768.43 | 14154.0 |
| 2022-06-03 08:00:00 | NQ | Futures | 14767.56 | 14856.87 | 14712.17 | 14748.13 | 39872.0 |
| 2022-06-03 09:00:00 | NQ | Futures | 14748.13 | 14778.87 | 14625.47 | 14723.19 | 92682.0 |
| 2022-06-03 10:00:00 | NQ | Futures | 14721.74 | 14766.98 | 14573.28 | 14576.47 | 103901.0 |
| 2022-06-03 11:00:00 | NQ | Futures | 14577.05 | 14584.87 | 14502.23 | 14554.14 | 74433.0 |
| 2022-06-03 12:00:00 | NQ | Futures | 14554.43 | 14629.82 | 14528.62 | 14621.7 | 51454.0 |
| 2022-06-03 13:00:00 | NQ | Futures | 14621.99 | 14668.39 | 14539.64 | 14557.91 | 58613.0 |
| 2022-06-03 14:00:00 | NQ | Futures | 14558.49 | 14619.09 | 14542.54 | 14588.64 | 44893.0 |
| 2022-06-03 15:00:00 | NQ | Futures | 14588.06 | 14599.37 | 14511.8 | 14561.39 | 77104.0 |
| 2022-06-03 16:00:00 | NQ | Futures | 14560.81 | 14575.02 | 14541.38 | 14556.17 | 15077.0 |
| 2022-06-03 00:00:00 | YM | Futures | 37466.8 | 37506.3 | 37465.7 | 37474.7 | 776.0 |
| 2022-06-03 01:00:00 | YM | Futures | 37474.7 | 37525.5 | 37471.3 | 37510.8 | 768.0 |
| 2022-06-03 02:00:00 | YM | Futures | 37510.8 | 37533.4 | 37483.7 | 37487.1 | 1337.0 |
| 2022-06-03 03:00:00 | YM | Futures | 37486.0 | 37490.5 | 37406.0 | 37407.1 | 3509.0 |
| 2022-06-03 04:00:00 | YM | Futures | 37407.1 | 37446.5 | 37359.7 | 37385.7 | 3630.0 |
| 2022-06-03 05:00:00 | YM | Futures | 37387.9 | 37389.1 | 37331.6 | 37377.8 | 2037.0 |
| 2022-06-03 06:00:00 | YM | Futures | 37378.9 | 37396.9 | 37318.0 | 37329.3 | 2227.0 |
| 2022-06-03 07:00:00 | YM | Futures | 37327.0 | 37338.3 | 37233.5 | 37247.0 | 4106.0 |
| 2022-06-03 08:00:00 | YM | Futures | 37245.9 | 37399.2 | 37173.7 | 37213.2 | 11368.0 |
| 2022-06-03 09:00:00 | YM | Futures | 37212.1 | 37291.0 | 37121.9 | 37256.0 | 27292.0 |
| 2022-06-03 10:00:00 | YM | Futures | 37260.5 | 37344.0 | 37097.1 | 37165.8 | 24883.0 |
| 2022-06-03 11:00:00 | YM | Futures | 37167.0 | 37169.2 | 37023.8 | 37084.7 | 14598.0 |
| 2022-06-03 12:00:00 | YM | Futures | 37084.7 | 37239.1 | 37015.9 | 37222.2 | 12319.0 |
| 2022-06-03 13:00:00 | YM | Futures | 37224.5 | 37316.9 | 37083.5 | 37118.5 | 13684.0 |
| 2022-06-03 14:00:00 | YM | Futures | 37120.7 | 37215.4 | 37076.8 | 37167.0 | 9641.0 |
| 2022-06-03 15:00:00 | YM | Futures | 37169.2 | 37182.8 | 37003.5 | 37082.4 | 19005.0 |
> showing 50 of 1,523 rows — these rows as CSV