PREVIEW / futures_1hour / 2023-05-03
file: by_date/futures_1hour/2023/2023-05-03.parquet size: 70 KB rows: 2,093
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 |
|---|---|---|---|---|---|---|---|
| 2023-05-03 00:00:00 | ES | Futures | 4596.3 | 4596.58 | 4594.36 | 4596.02 | 3209.0 |
| 2023-05-03 01:00:00 | ES | Futures | 4595.75 | 4599.35 | 4595.19 | 4597.96 | 6514.0 |
| 2023-05-03 02:00:00 | ES | Futures | 4597.69 | 4599.35 | 4595.47 | 4597.13 | 8758.0 |
| 2023-05-03 03:00:00 | ES | Futures | 4597.41 | 4601.57 | 4594.08 | 4594.36 | 17922.0 |
| 2023-05-03 04:00:00 | ES | Futures | 4594.91 | 4598.24 | 4592.97 | 4595.19 | 13215.0 |
| 2023-05-03 05:00:00 | ES | Futures | 4594.91 | 4597.69 | 4592.14 | 4595.47 | 7950.0 |
| 2023-05-03 06:00:00 | ES | Futures | 4595.47 | 4600.46 | 4593.53 | 4594.91 | 13583.0 |
| 2023-05-03 07:00:00 | ES | Futures | 4594.91 | 4601.85 | 4594.36 | 4598.52 | 13389.0 |
| 2023-05-03 08:00:00 | ES | Futures | 4598.24 | 4603.51 | 4592.97 | 4593.53 | 28598.0 |
| 2023-05-03 09:00:00 | ES | Futures | 4593.53 | 4609.06 | 4591.31 | 4603.79 | 143889.0 |
| 2023-05-03 10:00:00 | ES | Futures | 4603.79 | 4607.12 | 4584.93 | 4589.09 | 208124.0 |
| 2023-05-03 11:00:00 | ES | Futures | 4588.81 | 4596.58 | 4582.71 | 4596.02 | 135919.0 |
| 2023-05-03 12:00:00 | ES | Futures | 4596.02 | 4603.23 | 4591.03 | 4603.23 | 79516.0 |
| 2023-05-03 13:00:00 | ES | Futures | 4603.51 | 4608.23 | 4600.74 | 4603.51 | 75416.0 |
| 2023-05-03 14:00:00 | ES | Futures | 4604.07 | 4622.93 | 4582.99 | 4604.07 | 362334.0 |
| 2023-05-03 15:00:00 | ES | Futures | 4604.34 | 4614.05 | 4554.14 | 4556.92 | 379613.0 |
| 2023-05-03 16:00:00 | ES | Futures | 4556.92 | 4567.46 | 4543.05 | 4544.44 | 80859.0 |
| 2023-05-03 18:00:00 | ES | Futures | 4534.17 | 4538.33 | 4521.41 | 4536.95 | 27528.0 |
| 2023-05-03 19:00:00 | ES | Futures | 4536.67 | 4541.66 | 4533.34 | 4541.38 | 10168.0 |
| 2023-05-03 20:00:00 | ES | Futures | 4541.38 | 4546.93 | 4541.11 | 4544.71 | 11262.0 |
| 2023-05-03 21:00:00 | ES | Futures | 4544.71 | 4554.42 | 4543.6 | 4553.03 | 12283.0 |
| 2023-05-03 22:00:00 | ES | Futures | 4553.03 | 4563.02 | 4552.76 | 4561.63 | 12168.0 |
| 2023-05-03 23:00:00 | ES | Futures | 4561.91 | 4564.4 | 4560.8 | 4562.74 | 6300.0 |
| 2023-05-03 00:00:00 | NQ | Futures | 14852.77 | 14855.86 | 14846.01 | 14850.51 | 1354.0 |
| 2023-05-03 01:00:00 | NQ | Futures | 14851.36 | 14862.34 | 14841.5 | 14852.2 | 3532.0 |
| 2023-05-03 02:00:00 | NQ | Futures | 14852.48 | 14861.49 | 14843.76 | 14855.58 | 3174.0 |
| 2023-05-03 03:00:00 | NQ | Futures | 14856.71 | 14876.98 | 14850.23 | 14855.86 | 6567.0 |
| 2023-05-03 04:00:00 | NQ | Futures | 14856.14 | 14880.64 | 14847.98 | 14872.47 | 5947.0 |
| 2023-05-03 05:00:00 | NQ | Futures | 14872.19 | 14880.92 | 14864.03 | 14874.73 | 4078.0 |
| 2023-05-03 06:00:00 | NQ | Futures | 14874.73 | 14887.96 | 14864.87 | 14865.15 | 6888.0 |
| 2023-05-03 07:00:00 | NQ | Futures | 14865.15 | 14893.31 | 14862.62 | 14883.74 | 7348.0 |
| 2023-05-03 08:00:00 | NQ | Futures | 14882.61 | 14901.47 | 14863.47 | 14867.97 | 12377.0 |
| 2023-05-03 09:00:00 | NQ | Futures | 14867.69 | 14913.02 | 14852.2 | 14903.16 | 58512.0 |
| 2023-05-03 10:00:00 | NQ | Futures | 14902.6 | 14913.3 | 14857.83 | 14865.72 | 81153.0 |
| 2023-05-03 11:00:00 | NQ | Futures | 14865.72 | 14884.86 | 14840.38 | 14882.33 | 48981.0 |
| 2023-05-03 12:00:00 | NQ | Futures | 14882.61 | 14896.69 | 14852.48 | 14896.69 | 30176.0 |
| 2023-05-03 13:00:00 | NQ | Futures | 14896.97 | 14904.01 | 14871.07 | 14890.49 | 32114.0 |
| 2023-05-03 14:00:00 | NQ | Futures | 14892.18 | 14994.39 | 14832.21 | 14918.09 | 164682.0 |
| 2023-05-03 15:00:00 | NQ | Futures | 14918.93 | 14952.44 | 14744.93 | 14753.1 | 137255.0 |
| 2023-05-03 16:00:00 | NQ | Futures | 14753.38 | 14789.98 | 14730.85 | 14740.99 | 23845.0 |
| 2023-05-03 18:00:00 | NQ | Futures | 14712.83 | 14739.58 | 14690.59 | 14737.89 | 9014.0 |
| 2023-05-03 19:00:00 | NQ | Futures | 14737.05 | 14752.25 | 14726.91 | 14751.41 | 4957.0 |
| 2023-05-03 20:00:00 | NQ | Futures | 14751.41 | 14771.68 | 14748.31 | 14760.42 | 4529.0 |
| 2023-05-03 21:00:00 | NQ | Futures | 14760.42 | 14787.16 | 14754.79 | 14783.79 | 4814.0 |
| 2023-05-03 22:00:00 | NQ | Futures | 14784.07 | 14816.16 | 14782.94 | 14810.53 | 5879.0 |
| 2023-05-03 23:00:00 | NQ | Futures | 14811.1 | 14818.98 | 14805.47 | 14808.56 | 3327.0 |
| 2023-05-03 00:00:00 | YM | Futures | 37380.4 | 37382.6 | 37366.1 | 37377.1 | 562.0 |
| 2023-05-03 01:00:00 | YM | Futures | 37380.4 | 37404.7 | 37377.1 | 37400.3 | 1019.0 |
| 2023-05-03 02:00:00 | YM | Futures | 37398.1 | 37419.1 | 37383.7 | 37383.7 | 1999.0 |
| 2023-05-03 03:00:00 | YM | Futures | 37384.8 | 37422.4 | 37353.9 | 37371.6 | 3835.0 |
> showing 50 of 2,093 rows — these rows as CSV