PREVIEW / futures_1hour / 2024-05-01
file: by_date/futures_1hour/2024/2024-05-01.parquet size: 61 KB rows: 1,794
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-01 00:00:00 | ES | Futures | 5374.63 | 5375.42 | 5372.77 | 5374.89 | 2314.0 |
| 2024-05-01 01:00:00 | ES | Futures | 5374.63 | 5374.63 | 5370.12 | 5370.65 | 3185.0 |
| 2024-05-01 02:00:00 | ES | Futures | 5370.65 | 5373.03 | 5362.69 | 5365.87 | 6662.0 |
| 2024-05-01 03:00:00 | ES | Futures | 5366.14 | 5368.52 | 5357.38 | 5360.03 | 10990.0 |
| 2024-05-01 04:00:00 | ES | Futures | 5360.3 | 5364.28 | 5358.71 | 5362.16 | 10525.0 |
| 2024-05-01 05:00:00 | ES | Futures | 5362.16 | 5362.16 | 5347.83 | 5352.61 | 23360.0 |
| 2024-05-01 06:00:00 | ES | Futures | 5352.61 | 5355.79 | 5345.97 | 5355.52 | 16227.0 |
| 2024-05-01 07:00:00 | ES | Futures | 5355.26 | 5359.5 | 5350.75 | 5352.34 | 14808.0 |
| 2024-05-01 08:00:00 | ES | Futures | 5352.61 | 5366.67 | 5351.28 | 5362.16 | 43825.0 |
| 2024-05-01 09:00:00 | ES | Futures | 5362.16 | 5371.97 | 5356.85 | 5361.1 | 144963.0 |
| 2024-05-01 10:00:00 | ES | Futures | 5360.83 | 5369.59 | 5353.14 | 5366.67 | 201785.0 |
| 2024-05-01 11:00:00 | ES | Futures | 5366.93 | 5368.26 | 5352.87 | 5354.99 | 117585.0 |
| 2024-05-01 12:00:00 | ES | Futures | 5355.26 | 5364.54 | 5350.75 | 5356.85 | 99299.0 |
| 2024-05-01 13:00:00 | ES | Futures | 5356.59 | 5367.2 | 5351.28 | 5362.42 | 86033.0 |
| 2024-05-01 14:00:00 | ES | Futures | 5362.95 | 5431.93 | 5360.57 | 5430.87 | 482616.0 |
| 2024-05-01 15:00:00 | ES | Futures | 5431.13 | 5440.42 | 5352.34 | 5354.73 | 514584.0 |
| 2024-05-01 16:00:00 | ES | Futures | 5354.99 | 5364.28 | 5353.67 | 5362.95 | 78733.0 |
| 2024-05-01 18:00:00 | ES | Futures | 5366.4 | 5371.71 | 5365.61 | 5369.59 | 10753.0 |
| 2024-05-01 19:00:00 | ES | Futures | 5369.59 | 5377.54 | 5368.79 | 5376.75 | 5910.0 |
| 2024-05-01 20:00:00 | ES | Futures | 5376.75 | 5382.32 | 5374.63 | 5379.93 | 8466.0 |
| 2024-05-01 21:00:00 | ES | Futures | 5380.2 | 5382.85 | 5376.48 | 5381.79 | 9593.0 |
| 2024-05-01 22:00:00 | ES | Futures | 5381.79 | 5386.56 | 5381.26 | 5384.44 | 5678.0 |
| 2024-05-01 23:00:00 | ES | Futures | 5384.18 | 5384.97 | 5380.99 | 5382.05 | 3405.0 |
| 2024-05-01 00:00:00 | NQ | Futures | 18753.9 | 18756.58 | 18746.68 | 18755.24 | 1266.0 |
| 2024-05-01 01:00:00 | NQ | Futures | 18754.44 | 18755.24 | 18731.43 | 18734.11 | 2308.0 |
| 2024-05-01 02:00:00 | NQ | Futures | 18733.31 | 18743.47 | 18688.9 | 18710.3 | 5687.0 |
| 2024-05-01 03:00:00 | NQ | Futures | 18710.3 | 18723.94 | 18676.33 | 18690.51 | 5902.0 |
| 2024-05-01 04:00:00 | NQ | Futures | 18691.04 | 18714.05 | 18681.68 | 18698.53 | 6700.0 |
| 2024-05-01 05:00:00 | NQ | Futures | 18697.73 | 18698.8 | 18636.74 | 18656.8 | 11356.0 |
| 2024-05-01 06:00:00 | NQ | Futures | 18657.07 | 18683.28 | 18631.12 | 18682.48 | 9870.0 |
| 2024-05-01 07:00:00 | NQ | Futures | 18682.21 | 18696.12 | 18658.94 | 18667.77 | 9640.0 |
| 2024-05-01 08:00:00 | NQ | Futures | 18667.77 | 18742.13 | 18661.88 | 18723.14 | 23349.0 |
| 2024-05-01 09:00:00 | NQ | Futures | 18723.14 | 18745.08 | 18677.4 | 18698.53 | 85946.0 |
| 2024-05-01 10:00:00 | NQ | Futures | 18700.94 | 18731.97 | 18645.83 | 18711.91 | 80031.0 |
| 2024-05-01 11:00:00 | NQ | Futures | 18711.64 | 18717.79 | 18631.39 | 18641.55 | 63097.0 |
| 2024-05-01 12:00:00 | NQ | Futures | 18641.55 | 18690.24 | 18617.48 | 18654.13 | 48517.0 |
| 2024-05-01 13:00:00 | NQ | Futures | 18653.32 | 18698.26 | 18632.19 | 18691.58 | 32421.0 |
| 2024-05-01 14:00:00 | NQ | Futures | 18692.38 | 18994.93 | 18679.54 | 18994.93 | 178120.0 |
| 2024-05-01 15:00:00 | NQ | Futures | 18993.86 | 19039.06 | 18645.3 | 18651.99 | 164269.0 |
| 2024-05-01 16:00:00 | NQ | Futures | 18652.52 | 18715.38 | 18651.99 | 18698.26 | 27418.0 |
| 2024-05-01 18:00:00 | NQ | Futures | 18711.37 | 18741.06 | 18711.37 | 18727.15 | 5310.0 |
| 2024-05-01 19:00:00 | NQ | Futures | 18727.15 | 18761.13 | 18720.2 | 18757.38 | 4003.0 |
| 2024-05-01 20:00:00 | NQ | Futures | 18757.65 | 18771.56 | 18743.2 | 18765.68 | 5141.0 |
| 2024-05-01 21:00:00 | NQ | Futures | 18766.48 | 18776.64 | 18752.57 | 18768.89 | 4168.0 |
| 2024-05-01 22:00:00 | NQ | Futures | 18769.69 | 18790.82 | 18765.94 | 18784.4 | 3425.0 |
| 2024-05-01 23:00:00 | NQ | Futures | 18784.4 | 18788.95 | 18772.9 | 18777.71 | 1981.0 |
| 2024-05-01 00:00:00 | YM | Futures | 40367.0 | 40371.2 | 40355.3 | 40363.8 | 844.0 |
| 2024-05-01 01:00:00 | YM | Futures | 40363.8 | 40365.9 | 40338.3 | 40342.6 | 593.0 |
| 2024-05-01 02:00:00 | YM | Futures | 40341.5 | 40354.2 | 40308.6 | 40311.8 | 1388.0 |
| 2024-05-01 03:00:00 | YM | Futures | 40311.8 | 40325.6 | 40261.9 | 40283.1 | 1273.0 |
> showing 50 of 1,794 rows — these rows as CSV