PREVIEW / futures_1hour / 2024-05-15
file: by_date/futures_1hour/2024/2024-05-15.parquet size: 70 KB rows: 2,102
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-15 00:00:00 | ES | Futures | 5598.0 | 5598.27 | 5595.09 | 5595.09 | 2842.0 |
| 2024-05-15 01:00:00 | ES | Futures | 5595.09 | 5596.94 | 5594.03 | 5596.41 | 3072.0 |
| 2024-05-15 02:00:00 | ES | Futures | 5596.41 | 5597.47 | 5594.03 | 5594.82 | 5514.0 |
| 2024-05-15 03:00:00 | ES | Futures | 5594.56 | 5596.15 | 5590.84 | 5592.17 | 9439.0 |
| 2024-05-15 04:00:00 | ES | Futures | 5592.17 | 5595.62 | 5591.37 | 5595.09 | 8464.0 |
| 2024-05-15 05:00:00 | ES | Futures | 5595.09 | 5596.68 | 5593.49 | 5594.29 | 8215.0 |
| 2024-05-15 06:00:00 | ES | Futures | 5594.29 | 5595.35 | 5592.96 | 5593.23 | 7765.0 |
| 2024-05-15 07:00:00 | ES | Futures | 5593.49 | 5595.35 | 5592.43 | 5593.23 | 12097.0 |
| 2024-05-15 08:00:00 | ES | Futures | 5593.23 | 5627.45 | 5588.45 | 5620.02 | 113290.0 |
| 2024-05-15 09:00:00 | ES | Futures | 5620.29 | 5627.72 | 5610.21 | 5615.78 | 206056.0 |
| 2024-05-15 10:00:00 | ES | Futures | 5615.78 | 5632.76 | 5614.98 | 5631.7 | 195069.0 |
| 2024-05-15 11:00:00 | ES | Futures | 5631.7 | 5642.57 | 5631.43 | 5639.66 | 143040.0 |
| 2024-05-15 12:00:00 | ES | Futures | 5639.66 | 5647.08 | 5634.62 | 5646.55 | 90404.0 |
| 2024-05-15 13:00:00 | ES | Futures | 5646.55 | 5651.59 | 5644.43 | 5651.33 | 95688.0 |
| 2024-05-15 14:00:00 | ES | Futures | 5651.33 | 5656.37 | 5647.35 | 5651.59 | 96933.0 |
| 2024-05-15 15:00:00 | ES | Futures | 5651.59 | 5663.8 | 5648.41 | 5659.82 | 236678.0 |
| 2024-05-15 16:00:00 | ES | Futures | 5659.82 | 5660.35 | 5651.06 | 5656.37 | 71502.0 |
| 2024-05-15 18:00:00 | ES | Futures | 5657.7 | 5661.68 | 5655.31 | 5660.08 | 6429.0 |
| 2024-05-15 19:00:00 | ES | Futures | 5659.82 | 5666.19 | 5659.82 | 5664.33 | 8450.0 |
| 2024-05-15 20:00:00 | ES | Futures | 5664.33 | 5667.51 | 5663.8 | 5667.25 | 7328.0 |
| 2024-05-15 21:00:00 | ES | Futures | 5666.98 | 5668.04 | 5664.86 | 5666.19 | 5628.0 |
| 2024-05-15 22:00:00 | ES | Futures | 5666.19 | 5667.51 | 5664.33 | 5667.25 | 4323.0 |
| 2024-05-15 23:00:00 | ES | Futures | 5667.51 | 5670.17 | 5667.25 | 5669.37 | 4849.0 |
| 2024-05-15 00:00:00 | NQ | Futures | 19713.44 | 19714.78 | 19700.07 | 19700.33 | 2696.0 |
| 2024-05-15 01:00:00 | NQ | Futures | 19700.07 | 19706.22 | 19694.45 | 19703.54 | 2224.0 |
| 2024-05-15 02:00:00 | NQ | Futures | 19704.08 | 19708.36 | 19693.65 | 19702.74 | 3374.0 |
| 2024-05-15 03:00:00 | NQ | Futures | 19702.21 | 19708.36 | 19680.81 | 19691.51 | 5621.0 |
| 2024-05-15 04:00:00 | NQ | Futures | 19691.51 | 19706.75 | 19686.42 | 19705.95 | 4864.0 |
| 2024-05-15 05:00:00 | NQ | Futures | 19705.68 | 19711.03 | 19696.59 | 19701.4 | 3755.0 |
| 2024-05-15 06:00:00 | NQ | Futures | 19701.94 | 19704.88 | 19690.97 | 19693.38 | 4208.0 |
| 2024-05-15 07:00:00 | NQ | Futures | 19694.45 | 19707.82 | 19692.58 | 19699.53 | 5215.0 |
| 2024-05-15 08:00:00 | NQ | Futures | 19699.8 | 19846.39 | 19681.34 | 19805.46 | 58362.0 |
| 2024-05-15 09:00:00 | NQ | Futures | 19806.27 | 19829.54 | 19738.32 | 19777.11 | 107954.0 |
| 2024-05-15 10:00:00 | NQ | Futures | 19777.38 | 19872.87 | 19776.04 | 19871.8 | 87738.0 |
| 2024-05-15 11:00:00 | NQ | Futures | 19872.07 | 19907.65 | 19870.2 | 19895.61 | 57102.0 |
| 2024-05-15 12:00:00 | NQ | Futures | 19896.15 | 19936.54 | 19877.96 | 19934.4 | 39302.0 |
| 2024-05-15 13:00:00 | NQ | Futures | 19934.67 | 19991.91 | 19933.6 | 19990.04 | 52831.0 |
| 2024-05-15 14:00:00 | NQ | Futures | 19990.04 | 20011.44 | 19978.81 | 19993.52 | 55168.0 |
| 2024-05-15 15:00:00 | NQ | Futures | 19993.52 | 20016.79 | 19983.09 | 20001.54 | 68711.0 |
| 2024-05-15 16:00:00 | NQ | Futures | 20001.81 | 20004.75 | 19972.65 | 20003.42 | 20264.0 |
| 2024-05-15 18:00:00 | NQ | Futures | 20002.08 | 20024.01 | 19995.93 | 20012.51 | 3747.0 |
| 2024-05-15 19:00:00 | NQ | Futures | 20011.71 | 20038.99 | 20011.17 | 20031.77 | 4981.0 |
| 2024-05-15 20:00:00 | NQ | Futures | 20032.04 | 20047.02 | 20027.49 | 20038.73 | 4532.0 |
| 2024-05-15 21:00:00 | NQ | Futures | 20038.73 | 20041.94 | 20028.29 | 20033.91 | 3306.0 |
| 2024-05-15 22:00:00 | NQ | Futures | 20034.18 | 20040.87 | 20023.21 | 20040.87 | 2479.0 |
| 2024-05-15 23:00:00 | NQ | Futures | 20040.87 | 20050.76 | 20038.73 | 20044.08 | 3128.0 |
| 2024-05-15 00:00:00 | YM | Futures | 42165.5 | 42167.6 | 42139.0 | 42139.0 | 531.0 |
| 2024-05-15 01:00:00 | YM | Futures | 42139.0 | 42152.8 | 42133.7 | 42147.5 | 761.0 |
| 2024-05-15 02:00:00 | YM | Futures | 42147.5 | 42157.0 | 42126.2 | 42131.5 | 1120.0 |
| 2024-05-15 03:00:00 | YM | Futures | 42131.5 | 42144.3 | 42114.5 | 42127.3 | 1008.0 |
> showing 50 of 2,102 rows — these rows as CSV