PREVIEW / futures_1hour / 2024-05-23
file: by_date/futures_1hour/2024/2024-05-23.parquet size: 68 KB rows: 2,082
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-23 00:00:00 | ES | Futures | 5689.0 | 5690.86 | 5687.94 | 5688.21 | 4756.0 |
| 2024-05-23 01:00:00 | ES | Futures | 5687.94 | 5688.74 | 5684.76 | 5685.29 | 6173.0 |
| 2024-05-23 02:00:00 | ES | Futures | 5685.29 | 5686.35 | 5682.1 | 5683.96 | 7494.0 |
| 2024-05-23 03:00:00 | ES | Futures | 5683.96 | 5685.29 | 5681.04 | 5681.57 | 14532.0 |
| 2024-05-23 04:00:00 | ES | Futures | 5681.84 | 5682.9 | 5677.86 | 5679.45 | 12784.0 |
| 2024-05-23 05:00:00 | ES | Futures | 5679.45 | 5683.7 | 5677.86 | 5682.63 | 9218.0 |
| 2024-05-23 06:00:00 | ES | Futures | 5682.63 | 5687.41 | 5681.57 | 5687.14 | 12596.0 |
| 2024-05-23 07:00:00 | ES | Futures | 5687.14 | 5692.18 | 5686.35 | 5691.39 | 23092.0 |
| 2024-05-23 08:00:00 | ES | Futures | 5691.12 | 5696.69 | 5690.59 | 5693.25 | 33825.0 |
| 2024-05-23 09:00:00 | ES | Futures | 5692.98 | 5693.51 | 5647.88 | 5652.39 | 301800.0 |
| 2024-05-23 10:00:00 | ES | Futures | 5652.66 | 5663.8 | 5642.31 | 5643.1 | 285304.0 |
| 2024-05-23 11:00:00 | ES | Futures | 5643.1 | 5669.1 | 5642.04 | 5664.59 | 165817.0 |
| 2024-05-23 12:00:00 | ES | Futures | 5664.59 | 5668.31 | 5648.15 | 5648.15 | 140377.0 |
| 2024-05-23 13:00:00 | ES | Futures | 5648.41 | 5651.33 | 5616.31 | 5617.9 | 244094.0 |
| 2024-05-23 14:00:00 | ES | Futures | 5617.9 | 5619.23 | 5597.74 | 5598.54 | 260517.0 |
| 2024-05-23 15:00:00 | ES | Futures | 5598.54 | 5612.86 | 5596.15 | 5609.68 | 304353.0 |
| 2024-05-23 16:00:00 | ES | Futures | 5609.68 | 5611.8 | 5604.9 | 5609.94 | 52874.0 |
| 2024-05-23 18:00:00 | ES | Futures | 5609.15 | 5612.07 | 5609.15 | 5610.74 | 4961.0 |
| 2024-05-23 19:00:00 | ES | Futures | 5611.0 | 5614.72 | 5609.94 | 5611.27 | 5247.0 |
| 2024-05-23 20:00:00 | ES | Futures | 5611.0 | 5617.11 | 5609.94 | 5616.31 | 7141.0 |
| 2024-05-23 21:00:00 | ES | Futures | 5616.31 | 5619.23 | 5615.51 | 5618.17 | 8270.0 |
| 2024-05-23 22:00:00 | ES | Futures | 5618.17 | 5620.02 | 5616.58 | 5618.96 | 5676.0 |
| 2024-05-23 23:00:00 | ES | Futures | 5618.96 | 5619.49 | 5616.04 | 5616.31 | 3267.0 |
| 2024-05-23 00:00:00 | NQ | Futures | 20290.18 | 20298.74 | 20289.11 | 20291.52 | 3189.0 |
| 2024-05-23 01:00:00 | NQ | Futures | 20290.98 | 20292.86 | 20274.4 | 20277.34 | 2937.0 |
| 2024-05-23 02:00:00 | NQ | Futures | 20276.81 | 20280.02 | 20256.21 | 20269.58 | 4656.0 |
| 2024-05-23 03:00:00 | NQ | Futures | 20269.32 | 20282.16 | 20253.8 | 20258.08 | 7796.0 |
| 2024-05-23 04:00:00 | NQ | Futures | 20257.55 | 20275.47 | 20254.07 | 20261.02 | 6418.0 |
| 2024-05-23 05:00:00 | NQ | Futures | 20262.09 | 20282.16 | 20255.14 | 20273.06 | 4817.0 |
| 2024-05-23 06:00:00 | NQ | Futures | 20273.06 | 20299.28 | 20268.78 | 20297.14 | 5737.0 |
| 2024-05-23 07:00:00 | NQ | Futures | 20296.6 | 20320.94 | 20292.59 | 20318.27 | 11220.0 |
| 2024-05-23 08:00:00 | NQ | Futures | 20317.73 | 20355.18 | 20316.4 | 20335.66 | 20139.0 |
| 2024-05-23 09:00:00 | NQ | Futures | 20336.19 | 20338.6 | 20156.96 | 20171.94 | 133553.0 |
| 2024-05-23 10:00:00 | NQ | Futures | 20171.94 | 20239.89 | 20118.44 | 20124.86 | 120820.0 |
| 2024-05-23 11:00:00 | NQ | Futures | 20125.13 | 20256.48 | 20121.65 | 20240.16 | 79056.0 |
| 2024-05-23 12:00:00 | NQ | Futures | 20239.89 | 20259.15 | 20162.58 | 20162.58 | 61061.0 |
| 2024-05-23 13:00:00 | NQ | Futures | 20162.85 | 20179.43 | 20021.34 | 20026.96 | 103368.0 |
| 2024-05-23 14:00:00 | NQ | Futures | 20026.96 | 20036.32 | 19931.99 | 19938.68 | 118077.0 |
| 2024-05-23 15:00:00 | NQ | Futures | 19938.15 | 20027.22 | 19925.31 | 20005.82 | 114055.0 |
| 2024-05-23 16:00:00 | NQ | Futures | 20006.09 | 20013.85 | 19987.37 | 19994.86 | 15345.0 |
| 2024-05-23 18:00:00 | NQ | Futures | 19992.18 | 20005.02 | 19987.9 | 20002.35 | 2804.0 |
| 2024-05-23 19:00:00 | NQ | Futures | 20002.88 | 20025.89 | 20001.54 | 20009.84 | 3062.0 |
| 2024-05-23 20:00:00 | NQ | Futures | 20009.3 | 20036.05 | 20002.88 | 20029.36 | 3333.0 |
| 2024-05-23 21:00:00 | NQ | Futures | 20029.1 | 20042.74 | 20024.82 | 20037.12 | 4101.0 |
| 2024-05-23 22:00:00 | NQ | Futures | 20037.39 | 20041.67 | 20025.89 | 20033.64 | 2728.0 |
| 2024-05-23 23:00:00 | NQ | Futures | 20033.11 | 20035.25 | 20019.73 | 20020.8 | 1632.0 |
| 2024-05-23 00:00:00 | YM | Futures | 42307.8 | 42323.7 | 42295.0 | 42296.1 | 867.0 |
| 2024-05-23 01:00:00 | YM | Futures | 42294.0 | 42297.2 | 42280.2 | 42282.3 | 764.0 |
| 2024-05-23 02:00:00 | YM | Futures | 42281.2 | 42291.9 | 42263.2 | 42266.4 | 1149.0 |
| 2024-05-23 03:00:00 | YM | Futures | 42265.3 | 42284.4 | 42255.8 | 42268.5 | 1721.0 |
> showing 50 of 2,082 rows — these rows as CSV