PREVIEW / futures_1hour / 2023-06-28
file: by_date/futures_1hour/2023/2023-06-28.parquet size: 67 KB rows: 2,048
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-06-28 00:00:00 | ES | Futures | 4843.75 | 4844.03 | 4840.73 | 4842.11 | 3853.0 |
| 2023-06-28 01:00:00 | ES | Futures | 4842.11 | 4845.95 | 4841.28 | 4845.4 | 8232.0 |
| 2023-06-28 02:00:00 | ES | Futures | 4845.68 | 4846.22 | 4842.38 | 4844.03 | 8093.0 |
| 2023-06-28 03:00:00 | ES | Futures | 4844.03 | 4847.6 | 4840.46 | 4842.66 | 23637.0 |
| 2023-06-28 04:00:00 | ES | Futures | 4842.66 | 4846.22 | 4838.54 | 4839.64 | 15927.0 |
| 2023-06-28 05:00:00 | ES | Futures | 4839.64 | 4843.2 | 4839.09 | 4842.11 | 11433.0 |
| 2023-06-28 06:00:00 | ES | Futures | 4842.38 | 4846.77 | 4842.11 | 4845.68 | 11440.0 |
| 2023-06-28 07:00:00 | ES | Futures | 4845.68 | 4849.79 | 4842.38 | 4842.66 | 18570.0 |
| 2023-06-28 08:00:00 | ES | Futures | 4842.66 | 4845.4 | 4838.26 | 4840.46 | 26520.0 |
| 2023-06-28 09:00:00 | ES | Futures | 4840.19 | 4841.83 | 4830.58 | 4839.64 | 196994.0 |
| 2023-06-28 10:00:00 | ES | Futures | 4839.64 | 4853.91 | 4831.13 | 4847.05 | 251832.0 |
| 2023-06-28 11:00:00 | ES | Futures | 4847.05 | 4856.66 | 4841.56 | 4855.56 | 170982.0 |
| 2023-06-28 12:00:00 | ES | Futures | 4855.28 | 4864.62 | 4832.22 | 4838.81 | 237646.0 |
| 2023-06-28 13:00:00 | ES | Futures | 4838.81 | 4847.87 | 4833.6 | 4841.56 | 133945.0 |
| 2023-06-28 14:00:00 | ES | Futures | 4841.56 | 4848.97 | 4840.46 | 4843.48 | 104168.0 |
| 2023-06-28 15:00:00 | ES | Futures | 4843.48 | 4854.46 | 4833.05 | 4854.19 | 267428.0 |
| 2023-06-28 16:00:00 | ES | Futures | 4854.19 | 4859.68 | 4851.71 | 4856.38 | 87203.0 |
| 2023-06-28 18:00:00 | ES | Futures | 4857.48 | 4864.07 | 4856.38 | 4862.15 | 6285.0 |
| 2023-06-28 19:00:00 | ES | Futures | 4862.15 | 4862.69 | 4859.95 | 4860.22 | 2713.0 |
| 2023-06-28 20:00:00 | ES | Futures | 4860.22 | 4862.42 | 4859.13 | 4861.05 | 4862.0 |
| 2023-06-28 21:00:00 | ES | Futures | 4861.05 | 4863.24 | 4858.58 | 4858.58 | 5549.0 |
| 2023-06-28 22:00:00 | ES | Futures | 4858.85 | 4859.13 | 4855.28 | 4855.28 | 6132.0 |
| 2023-06-28 23:00:00 | ES | Futures | 4855.28 | 4856.11 | 4851.99 | 4853.91 | 7974.0 |
| 2023-06-28 00:00:00 | NQ | Futures | 16758.24 | 16759.63 | 16741.55 | 16749.06 | 2528.0 |
| 2023-06-28 01:00:00 | NQ | Futures | 16748.5 | 16766.58 | 16743.77 | 16766.02 | 3730.0 |
| 2023-06-28 02:00:00 | NQ | Futures | 16765.75 | 16770.47 | 16744.89 | 16752.39 | 4434.0 |
| 2023-06-28 03:00:00 | NQ | Futures | 16752.95 | 16774.09 | 16738.49 | 16757.4 | 7492.0 |
| 2023-06-28 04:00:00 | NQ | Futures | 16757.68 | 16764.91 | 16715.68 | 16725.69 | 8525.0 |
| 2023-06-28 05:00:00 | NQ | Futures | 16725.69 | 16736.26 | 16711.51 | 16734.87 | 5659.0 |
| 2023-06-28 06:00:00 | NQ | Futures | 16735.99 | 16760.46 | 16732.37 | 16758.51 | 5971.0 |
| 2023-06-28 07:00:00 | NQ | Futures | 16758.79 | 16786.61 | 16739.32 | 16741.83 | 10757.0 |
| 2023-06-28 08:00:00 | NQ | Futures | 16742.1 | 16758.79 | 16726.53 | 16737.1 | 11155.0 |
| 2023-06-28 09:00:00 | NQ | Futures | 16737.1 | 16808.02 | 16716.24 | 16789.39 | 100128.0 |
| 2023-06-28 10:00:00 | NQ | Futures | 16788.83 | 16918.44 | 16735.43 | 16885.9 | 114122.0 |
| 2023-06-28 11:00:00 | NQ | Futures | 16885.9 | 16904.81 | 16814.97 | 16892.29 | 74479.0 |
| 2023-06-28 12:00:00 | NQ | Futures | 16891.74 | 16931.51 | 16753.23 | 16784.38 | 89073.0 |
| 2023-06-28 13:00:00 | NQ | Futures | 16784.38 | 16839.73 | 16762.41 | 16804.68 | 55694.0 |
| 2023-06-28 14:00:00 | NQ | Futures | 16805.24 | 16853.08 | 16799.12 | 16824.43 | 40845.0 |
| 2023-06-28 15:00:00 | NQ | Futures | 16824.71 | 16844.73 | 16760.46 | 16843.34 | 67242.0 |
| 2023-06-28 16:00:00 | NQ | Futures | 16843.07 | 16887.57 | 16837.78 | 16861.98 | 23403.0 |
| 2023-06-28 18:00:00 | NQ | Futures | 16866.98 | 16893.13 | 16861.14 | 16891.74 | 3623.0 |
| 2023-06-28 19:00:00 | NQ | Futures | 16891.74 | 16891.74 | 16877.55 | 16879.5 | 1905.0 |
| 2023-06-28 20:00:00 | NQ | Futures | 16879.78 | 16887.57 | 16872.83 | 16883.39 | 2448.0 |
| 2023-06-28 21:00:00 | NQ | Futures | 16883.39 | 16890.07 | 16870.04 | 16871.71 | 2724.0 |
| 2023-06-28 22:00:00 | NQ | Futures | 16871.71 | 16873.1 | 16858.08 | 16860.31 | 3455.0 |
| 2023-06-28 23:00:00 | NQ | Futures | 16860.31 | 16863.37 | 16845.57 | 16851.97 | 3532.0 |
| 2023-06-28 00:00:00 | YM | Futures | 37440.3 | 37441.4 | 37421.6 | 37424.9 | 500.0 |
| 2023-06-28 01:00:00 | YM | Futures | 37423.8 | 37446.8 | 37421.6 | 37442.4 | 895.0 |
| 2023-06-28 02:00:00 | YM | Futures | 37443.5 | 37446.8 | 37428.2 | 37438.1 | 1430.0 |
| 2023-06-28 03:00:00 | YM | Futures | 37437.0 | 37466.6 | 37412.9 | 37429.3 | 3402.0 |
> showing 50 of 2,048 rows — these rows as CSV