PREVIEW / futures_1hour / 2024-05-28
file: by_date/futures_1hour/2024/2024-05-28.parquet size: 67 KB rows: 2,077
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-28 00:00:00 | ES | Futures | 5655.84 | 5656.9 | 5653.98 | 5653.98 | 2317.0 |
| 2024-05-28 01:00:00 | ES | Futures | 5654.25 | 5655.57 | 5652.66 | 5655.04 | 3241.0 |
| 2024-05-28 02:00:00 | ES | Futures | 5654.78 | 5657.96 | 5651.86 | 5657.17 | 6341.0 |
| 2024-05-28 03:00:00 | ES | Futures | 5657.17 | 5659.82 | 5651.86 | 5654.78 | 12402.0 |
| 2024-05-28 04:00:00 | ES | Futures | 5654.78 | 5665.66 | 5654.25 | 5664.33 | 20422.0 |
| 2024-05-28 05:00:00 | ES | Futures | 5664.33 | 5665.39 | 5662.47 | 5663.53 | 10017.0 |
| 2024-05-28 06:00:00 | ES | Futures | 5663.53 | 5663.8 | 5650.53 | 5653.19 | 18336.0 |
| 2024-05-28 07:00:00 | ES | Futures | 5653.19 | 5655.84 | 5650.8 | 5654.51 | 12954.0 |
| 2024-05-28 08:00:00 | ES | Futures | 5654.51 | 5657.96 | 5650.0 | 5655.04 | 22761.0 |
| 2024-05-28 09:00:00 | ES | Futures | 5655.04 | 5657.43 | 5642.57 | 5645.23 | 160355.0 |
| 2024-05-28 10:00:00 | ES | Futures | 5645.23 | 5653.98 | 5641.25 | 5651.06 | 158963.0 |
| 2024-05-28 11:00:00 | ES | Futures | 5651.06 | 5653.19 | 5645.23 | 5652.39 | 93177.0 |
| 2024-05-28 12:00:00 | ES | Futures | 5652.13 | 5655.31 | 5647.88 | 5649.47 | 85502.0 |
| 2024-05-28 13:00:00 | ES | Futures | 5649.47 | 5651.33 | 5635.94 | 5638.86 | 123026.0 |
| 2024-05-28 14:00:00 | ES | Futures | 5639.13 | 5645.23 | 5620.82 | 5633.82 | 194222.0 |
| 2024-05-28 15:00:00 | ES | Futures | 5633.82 | 5651.86 | 5631.43 | 5651.33 | 232312.0 |
| 2024-05-28 16:00:00 | ES | Futures | 5651.59 | 5656.9 | 5647.88 | 5649.74 | 72002.0 |
| 2024-05-28 18:00:00 | ES | Futures | 5649.47 | 5649.74 | 5644.96 | 5647.35 | 3530.0 |
| 2024-05-28 19:00:00 | ES | Futures | 5647.08 | 5647.62 | 5643.37 | 5644.17 | 2723.0 |
| 2024-05-28 20:00:00 | ES | Futures | 5644.43 | 5645.49 | 5637.8 | 5639.39 | 8506.0 |
| 2024-05-28 21:00:00 | ES | Futures | 5639.39 | 5640.72 | 5636.74 | 5639.13 | 8326.0 |
| 2024-05-28 22:00:00 | ES | Futures | 5638.86 | 5639.92 | 5634.35 | 5634.35 | 4929.0 |
| 2024-05-28 23:00:00 | ES | Futures | 5634.62 | 5634.88 | 5630.37 | 5631.96 | 6127.0 |
| 2024-05-28 00:00:00 | NQ | Futures | 20252.46 | 20257.28 | 20245.24 | 20245.77 | 2313.0 |
| 2024-05-28 01:00:00 | NQ | Futures | 20246.04 | 20250.32 | 20238.55 | 20247.65 | 2244.0 |
| 2024-05-28 02:00:00 | NQ | Futures | 20247.91 | 20265.3 | 20233.2 | 20261.56 | 4831.0 |
| 2024-05-28 03:00:00 | NQ | Futures | 20261.83 | 20269.58 | 20236.41 | 20244.17 | 6205.0 |
| 2024-05-28 04:00:00 | NQ | Futures | 20243.9 | 20308.1 | 20242.56 | 20306.23 | 12487.0 |
| 2024-05-28 05:00:00 | NQ | Futures | 20305.96 | 20309.44 | 20291.79 | 20297.14 | 5881.0 |
| 2024-05-28 06:00:00 | NQ | Futures | 20297.67 | 20299.28 | 20239.62 | 20244.7 | 10508.0 |
| 2024-05-28 07:00:00 | NQ | Futures | 20244.17 | 20259.42 | 20233.2 | 20250.86 | 8555.0 |
| 2024-05-28 08:00:00 | NQ | Futures | 20250.86 | 20258.35 | 20222.5 | 20240.96 | 12156.0 |
| 2024-05-28 09:00:00 | NQ | Futures | 20239.89 | 20262.36 | 20158.03 | 20185.05 | 81626.0 |
| 2024-05-28 10:00:00 | NQ | Futures | 20185.32 | 20255.14 | 20161.78 | 20248.45 | 74771.0 |
| 2024-05-28 11:00:00 | NQ | Futures | 20248.98 | 20265.57 | 20222.5 | 20247.38 | 42889.0 |
| 2024-05-28 12:00:00 | NQ | Futures | 20247.38 | 20270.12 | 20233.74 | 20246.31 | 46470.0 |
| 2024-05-28 13:00:00 | NQ | Futures | 20246.31 | 20270.92 | 20213.94 | 20225.71 | 52084.0 |
| 2024-05-28 14:00:00 | NQ | Futures | 20225.71 | 20253.0 | 20137.17 | 20188.53 | 75522.0 |
| 2024-05-28 15:00:00 | NQ | Futures | 20188.26 | 20271.99 | 20183.18 | 20269.32 | 80569.0 |
| 2024-05-28 16:00:00 | NQ | Futures | 20269.32 | 20295.53 | 20269.05 | 20277.34 | 20454.0 |
| 2024-05-28 18:00:00 | NQ | Futures | 20276.27 | 20276.54 | 20262.63 | 20267.98 | 2396.0 |
| 2024-05-28 19:00:00 | NQ | Futures | 20267.98 | 20274.67 | 20251.66 | 20255.41 | 2283.0 |
| 2024-05-28 20:00:00 | NQ | Futures | 20255.67 | 20260.76 | 20226.25 | 20232.67 | 4797.0 |
| 2024-05-28 21:00:00 | NQ | Futures | 20232.93 | 20242.56 | 20225.98 | 20233.74 | 3622.0 |
| 2024-05-28 22:00:00 | NQ | Futures | 20233.2 | 20237.75 | 20213.94 | 20214.48 | 2827.0 |
| 2024-05-28 23:00:00 | NQ | Futures | 20214.48 | 20216.35 | 20195.75 | 20208.86 | 4763.0 |
| 2024-05-28 00:00:00 | YM | Futures | 41606.0 | 41615.5 | 41599.6 | 41599.6 | 495.0 |
| 2024-05-28 01:00:00 | YM | Futures | 41600.7 | 41610.2 | 41592.2 | 41609.2 | 690.0 |
| 2024-05-28 02:00:00 | YM | Futures | 41608.1 | 41619.8 | 41582.6 | 41607.1 | 1420.0 |
| 2024-05-28 03:00:00 | YM | Futures | 41607.1 | 41637.8 | 41586.9 | 41599.6 | 1526.0 |
> showing 50 of 2,077 rows — these rows as CSV