PREVIEW / futures_1hour / 2024-05-16
file: by_date/futures_1hour/2024/2024-05-16.parquet size: 67 KB rows: 2,099
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 |
|---|---|---|---|---|---|---|---|
| 2024-05-16 00:00:00 | ES | Futures | 5669.1 | 5669.37 | 5667.25 | 5667.25 | 2584.0 |
| 2024-05-16 01:00:00 | ES | Futures | 5667.25 | 5668.84 | 5665.66 | 5665.66 | 4771.0 |
| 2024-05-16 02:00:00 | ES | Futures | 5665.66 | 5665.92 | 5661.68 | 5663.8 | 8496.0 |
| 2024-05-16 03:00:00 | ES | Futures | 5664.06 | 5666.19 | 5662.21 | 5664.06 | 11947.0 |
| 2024-05-16 04:00:00 | ES | Futures | 5664.06 | 5664.86 | 5661.15 | 5663.0 | 8548.0 |
| 2024-05-16 05:00:00 | ES | Futures | 5663.0 | 5664.86 | 5661.94 | 5662.21 | 8145.0 |
| 2024-05-16 06:00:00 | ES | Futures | 5662.21 | 5663.27 | 5660.35 | 5661.94 | 8587.0 |
| 2024-05-16 07:00:00 | ES | Futures | 5662.21 | 5666.45 | 5661.68 | 5662.74 | 13479.0 |
| 2024-05-16 08:00:00 | ES | Futures | 5662.74 | 5669.37 | 5657.7 | 5659.55 | 34628.0 |
| 2024-05-16 09:00:00 | ES | Futures | 5659.82 | 5663.27 | 5656.1 | 5662.21 | 115656.0 |
| 2024-05-16 10:00:00 | ES | Futures | 5662.21 | 5675.74 | 5654.25 | 5674.68 | 167289.0 |
| 2024-05-16 11:00:00 | ES | Futures | 5674.41 | 5676.27 | 5665.12 | 5669.63 | 135955.0 |
| 2024-05-16 12:00:00 | ES | Futures | 5669.63 | 5669.63 | 5661.68 | 5667.25 | 97387.0 |
| 2024-05-16 13:00:00 | ES | Futures | 5667.51 | 5668.84 | 5652.39 | 5660.35 | 151895.0 |
| 2024-05-16 14:00:00 | ES | Futures | 5660.35 | 5661.15 | 5649.21 | 5660.88 | 107282.0 |
| 2024-05-16 15:00:00 | ES | Futures | 5660.88 | 5662.21 | 5644.17 | 5645.49 | 193878.0 |
| 2024-05-16 16:00:00 | ES | Futures | 5645.23 | 5647.62 | 5640.72 | 5641.51 | 56673.0 |
| 2024-05-16 18:00:00 | ES | Futures | 5643.64 | 5645.76 | 5642.04 | 5644.96 | 7586.0 |
| 2024-05-16 19:00:00 | ES | Futures | 5644.96 | 5646.82 | 5643.37 | 5645.49 | 3426.0 |
| 2024-05-16 20:00:00 | ES | Futures | 5645.49 | 5647.35 | 5643.9 | 5646.55 | 4833.0 |
| 2024-05-16 21:00:00 | ES | Futures | 5646.82 | 5648.94 | 5646.29 | 5648.15 | 4764.0 |
| 2024-05-16 22:00:00 | ES | Futures | 5648.15 | 5648.41 | 5644.17 | 5644.7 | 4777.0 |
| 2024-05-16 23:00:00 | ES | Futures | 5644.96 | 5645.49 | 5643.64 | 5643.9 | 2882.0 |
| 2024-05-16 00:00:00 | NQ | Futures | 20044.34 | 20044.34 | 20034.98 | 20035.52 | 1720.0 |
| 2024-05-16 01:00:00 | NQ | Futures | 20035.78 | 20045.68 | 20029.63 | 20034.45 | 3650.0 |
| 2024-05-16 02:00:00 | NQ | Futures | 20034.18 | 20035.25 | 20015.72 | 20025.35 | 4516.0 |
| 2024-05-16 03:00:00 | NQ | Futures | 20026.42 | 20043.27 | 20021.07 | 20037.12 | 5763.0 |
| 2024-05-16 04:00:00 | NQ | Futures | 20037.66 | 20040.33 | 20019.2 | 20030.7 | 5022.0 |
| 2024-05-16 05:00:00 | NQ | Futures | 20030.97 | 20041.4 | 20026.96 | 20031.5 | 3868.0 |
| 2024-05-16 06:00:00 | NQ | Futures | 20032.31 | 20036.85 | 20025.08 | 20029.9 | 4405.0 |
| 2024-05-16 07:00:00 | NQ | Futures | 20030.17 | 20036.59 | 20022.41 | 20025.35 | 6171.0 |
| 2024-05-16 08:00:00 | NQ | Futures | 20024.82 | 20046.75 | 19994.86 | 20003.68 | 20619.0 |
| 2024-05-16 09:00:00 | NQ | Futures | 20003.95 | 20026.96 | 19979.34 | 20018.66 | 73348.0 |
| 2024-05-16 10:00:00 | NQ | Futures | 20018.93 | 20062.53 | 19981.21 | 20060.66 | 75452.0 |
| 2024-05-16 11:00:00 | NQ | Futures | 20060.66 | 20074.3 | 20034.71 | 20052.9 | 57985.0 |
| 2024-05-16 12:00:00 | NQ | Futures | 20052.64 | 20052.64 | 20016.79 | 20045.15 | 45728.0 |
| 2024-05-16 13:00:00 | NQ | Futures | 20045.41 | 20053.17 | 19978.0 | 20020.0 | 71284.0 |
| 2024-05-16 14:00:00 | NQ | Futures | 20020.27 | 20021.07 | 19967.57 | 20004.22 | 55393.0 |
| 2024-05-16 15:00:00 | NQ | Futures | 20004.49 | 20013.05 | 19949.11 | 19956.87 | 69618.0 |
| 2024-05-16 16:00:00 | NQ | Futures | 19956.87 | 19961.69 | 19937.88 | 19943.23 | 15350.0 |
| 2024-05-16 18:00:00 | NQ | Futures | 19947.24 | 19964.09 | 19943.5 | 19957.14 | 3384.0 |
| 2024-05-16 19:00:00 | NQ | Futures | 19957.14 | 19963.02 | 19950.72 | 19956.87 | 2591.0 |
| 2024-05-16 20:00:00 | NQ | Futures | 19957.14 | 19963.02 | 19950.72 | 19960.62 | 2072.0 |
| 2024-05-16 21:00:00 | NQ | Futures | 19960.88 | 19973.99 | 19960.08 | 19971.05 | 2881.0 |
| 2024-05-16 22:00:00 | NQ | Futures | 19971.05 | 19972.65 | 19950.72 | 19956.87 | 3027.0 |
| 2024-05-16 23:00:00 | NQ | Futures | 19956.87 | 19957.94 | 19949.92 | 19955.8 | 1866.0 |
| 2024-05-16 00:00:00 | YM | Futures | 42595.5 | 42597.6 | 42580.6 | 42581.7 | 404.0 |
| 2024-05-16 01:00:00 | YM | Futures | 42582.8 | 42583.8 | 42565.8 | 42567.9 | 456.0 |
| 2024-05-16 02:00:00 | YM | Futures | 42566.8 | 42566.8 | 42538.2 | 42548.8 | 1593.0 |
| 2024-05-16 03:00:00 | YM | Futures | 42547.7 | 42557.3 | 42527.5 | 42542.4 | 1309.0 |
> showing 50 of 2,099 rows — these rows as CSV