PREVIEW / futures_1hour / 2024-04-29
file: by_date/futures_1hour/2024/2024-04-29.parquet size: 67 KB rows: 2,104
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-04-29 00:00:00 | ES | Futures | 5458.19 | 5461.91 | 5457.4 | 5460.32 | 4587.0 |
| 2024-04-29 01:00:00 | ES | Futures | 5460.05 | 5461.64 | 5458.72 | 5461.64 | 5498.0 |
| 2024-04-29 02:00:00 | ES | Futures | 5461.38 | 5461.91 | 5455.01 | 5455.28 | 7364.0 |
| 2024-04-29 03:00:00 | ES | Futures | 5455.28 | 5458.99 | 5453.68 | 5458.46 | 13150.0 |
| 2024-04-29 04:00:00 | ES | Futures | 5458.46 | 5460.05 | 5453.95 | 5455.28 | 9697.0 |
| 2024-04-29 05:00:00 | ES | Futures | 5455.28 | 5456.34 | 5449.17 | 5449.7 | 18157.0 |
| 2024-04-29 06:00:00 | ES | Futures | 5449.97 | 5457.4 | 5448.64 | 5455.81 | 12401.0 |
| 2024-04-29 07:00:00 | ES | Futures | 5455.54 | 5460.58 | 5453.15 | 5458.72 | 13532.0 |
| 2024-04-29 08:00:00 | ES | Futures | 5458.72 | 5461.38 | 5455.54 | 5460.32 | 20148.0 |
| 2024-04-29 09:00:00 | ES | Futures | 5460.32 | 5469.6 | 5451.03 | 5457.13 | 169412.0 |
| 2024-04-29 10:00:00 | ES | Futures | 5456.87 | 5468.54 | 5456.6 | 5460.32 | 146900.0 |
| 2024-04-29 11:00:00 | ES | Futures | 5460.32 | 5461.11 | 5450.77 | 5458.46 | 107802.0 |
| 2024-04-29 12:00:00 | ES | Futures | 5458.46 | 5465.09 | 5456.87 | 5461.11 | 73371.0 |
| 2024-04-29 13:00:00 | ES | Futures | 5461.11 | 5467.21 | 5457.13 | 5463.77 | 74424.0 |
| 2024-04-29 14:00:00 | ES | Futures | 5463.5 | 5463.5 | 5446.26 | 5456.6 | 101698.0 |
| 2024-04-29 15:00:00 | ES | Futures | 5456.6 | 5463.77 | 5431.93 | 5462.17 | 267601.0 |
| 2024-04-29 16:00:00 | ES | Futures | 5462.17 | 5466.68 | 5460.58 | 5462.17 | 50290.0 |
| 2024-04-29 18:00:00 | ES | Futures | 5463.5 | 5463.5 | 5457.66 | 5458.99 | 4695.0 |
| 2024-04-29 19:00:00 | ES | Futures | 5458.99 | 5460.32 | 5458.19 | 5459.52 | 2631.0 |
| 2024-04-29 20:00:00 | ES | Futures | 5459.52 | 5459.52 | 5456.34 | 5456.87 | 4582.0 |
| 2024-04-29 21:00:00 | ES | Futures | 5456.87 | 5459.26 | 5456.6 | 5457.66 | 3524.0 |
| 2024-04-29 22:00:00 | ES | Futures | 5457.66 | 5458.99 | 5456.34 | 5456.34 | 2682.0 |
| 2024-04-29 23:00:00 | ES | Futures | 5456.34 | 5458.19 | 5455.81 | 5457.93 | 2900.0 |
| 2024-04-29 00:00:00 | NQ | Futures | 19154.63 | 19171.21 | 19149.81 | 19164.79 | 3189.0 |
| 2024-04-29 01:00:00 | NQ | Futures | 19163.99 | 19176.83 | 19157.03 | 19176.03 | 3640.0 |
| 2024-04-29 02:00:00 | NQ | Futures | 19176.56 | 19177.63 | 19141.25 | 19144.19 | 5339.0 |
| 2024-04-29 03:00:00 | NQ | Futures | 19143.93 | 19162.92 | 19134.3 | 19158.91 | 7077.0 |
| 2024-04-29 04:00:00 | NQ | Futures | 19158.91 | 19168.27 | 19140.98 | 19147.94 | 6098.0 |
| 2024-04-29 05:00:00 | NQ | Futures | 19147.4 | 19156.23 | 19117.44 | 19119.58 | 7141.0 |
| 2024-04-29 06:00:00 | NQ | Futures | 19119.05 | 19161.85 | 19115.84 | 19151.95 | 6255.0 |
| 2024-04-29 07:00:00 | NQ | Futures | 19151.42 | 19175.49 | 19135.37 | 19167.73 | 8607.0 |
| 2024-04-29 08:00:00 | NQ | Futures | 19167.47 | 19184.32 | 19157.84 | 19177.1 | 12673.0 |
| 2024-04-29 09:00:00 | NQ | Futures | 19176.83 | 19205.72 | 19078.39 | 19117.98 | 99322.0 |
| 2024-04-29 10:00:00 | NQ | Futures | 19117.98 | 19170.94 | 19113.97 | 19138.31 | 75208.0 |
| 2024-04-29 11:00:00 | NQ | Futures | 19138.58 | 19144.73 | 19094.17 | 19141.25 | 48938.0 |
| 2024-04-29 12:00:00 | NQ | Futures | 19140.72 | 19168.0 | 19134.3 | 19149.81 | 36273.0 |
| 2024-04-29 13:00:00 | NQ | Futures | 19149.01 | 19186.99 | 19124.93 | 19171.21 | 36213.0 |
| 2024-04-29 14:00:00 | NQ | Futures | 19170.94 | 19170.94 | 19092.57 | 19140.72 | 46366.0 |
| 2024-04-29 15:00:00 | NQ | Futures | 19140.18 | 19164.52 | 19036.92 | 19158.64 | 85819.0 |
| 2024-04-29 16:00:00 | NQ | Futures | 19158.64 | 19187.53 | 19158.1 | 19166.13 | 15205.0 |
| 2024-04-29 18:00:00 | NQ | Futures | 19173.08 | 19173.08 | 19158.37 | 19163.45 | 2140.0 |
| 2024-04-29 19:00:00 | NQ | Futures | 19162.65 | 19167.47 | 19157.84 | 19162.92 | 2143.0 |
| 2024-04-29 20:00:00 | NQ | Futures | 19162.65 | 19168.0 | 19150.35 | 19159.17 | 2827.0 |
| 2024-04-29 21:00:00 | NQ | Futures | 19158.37 | 19171.48 | 19157.84 | 19165.06 | 2154.0 |
| 2024-04-29 22:00:00 | NQ | Futures | 19164.79 | 19174.96 | 19163.45 | 19164.52 | 1997.0 |
| 2024-04-29 23:00:00 | NQ | Futures | 19164.52 | 19167.73 | 19161.05 | 19165.33 | 1351.0 |
| 2024-04-29 00:00:00 | YM | Futures | 40919.1 | 40942.4 | 40908.5 | 40932.9 | 683.0 |
| 2024-04-29 01:00:00 | YM | Futures | 40931.8 | 40935.0 | 40919.1 | 40932.9 | 689.0 |
| 2024-04-29 02:00:00 | YM | Futures | 40933.9 | 40936.1 | 40877.7 | 40879.8 | 1373.0 |
| 2024-04-29 03:00:00 | YM | Futures | 40879.8 | 40910.6 | 40874.5 | 40902.1 | 2026.0 |
> showing 50 of 2,104 rows — these rows as CSV