PREVIEW / futures_30min / 2024-01-02
file: by_date/futures_30min/2024/2024-01-02.parquet size: 110 KB rows: 3,849
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-01-02 00:00:00 | ES | Futures | 5179.23 | 5182.19 | 5179.23 | 5180.84 | 3167.0 |
| 2024-01-02 00:30:00 | ES | Futures | 5180.84 | 5181.38 | 5180.31 | 5180.84 | 1395.0 |
| 2024-01-02 01:00:00 | ES | Futures | 5181.11 | 5181.11 | 5179.5 | 5179.77 | 1811.0 |
| 2024-01-02 01:30:00 | ES | Futures | 5180.04 | 5180.31 | 5178.16 | 5178.43 | 2623.0 |
| 2024-01-02 02:00:00 | ES | Futures | 5178.7 | 5182.72 | 5178.7 | 5182.19 | 3609.0 |
| 2024-01-02 02:30:00 | ES | Futures | 5182.19 | 5182.19 | 5179.77 | 5180.84 | 3392.0 |
| 2024-01-02 03:00:00 | ES | Futures | 5181.11 | 5185.14 | 5180.84 | 5185.14 | 9223.0 |
| 2024-01-02 03:30:00 | ES | Futures | 5185.14 | 5187.02 | 5184.6 | 5185.41 | 7532.0 |
| 2024-01-02 04:00:00 | ES | Futures | 5185.41 | 5185.68 | 5177.35 | 5178.7 | 8388.0 |
| 2024-01-02 04:30:00 | ES | Futures | 5178.7 | 5179.23 | 5173.05 | 5174.67 | 8297.0 |
| 2024-01-02 05:00:00 | ES | Futures | 5174.4 | 5175.2 | 5170.91 | 5171.98 | 6937.0 |
| 2024-01-02 05:30:00 | ES | Futures | 5171.98 | 5176.01 | 5170.64 | 5171.17 | 11464.0 |
| 2024-01-02 06:00:00 | ES | Futures | 5171.17 | 5171.17 | 5149.69 | 5149.96 | 27928.0 |
| 2024-01-02 06:30:00 | ES | Futures | 5150.22 | 5150.49 | 5142.17 | 5147.81 | 20510.0 |
| 2024-01-02 07:00:00 | ES | Futures | 5147.81 | 5148.08 | 5141.9 | 5143.78 | 13564.0 |
| 2024-01-02 07:30:00 | ES | Futures | 5143.78 | 5144.32 | 5133.57 | 5134.38 | 18409.0 |
| 2024-01-02 08:00:00 | ES | Futures | 5134.38 | 5137.87 | 5133.03 | 5135.18 | 20562.0 |
| 2024-01-02 08:30:00 | ES | Futures | 5135.18 | 5141.09 | 5133.3 | 5138.41 | 22491.0 |
| 2024-01-02 09:00:00 | ES | Futures | 5138.14 | 5142.97 | 5132.5 | 5139.21 | 46725.0 |
| 2024-01-02 09:30:00 | ES | Futures | 5139.21 | 5145.93 | 5129.01 | 5138.94 | 215247.0 |
| 2024-01-02 10:00:00 | ES | Futures | 5138.68 | 5143.78 | 5131.69 | 5133.3 | 121805.0 |
| 2024-01-02 10:30:00 | ES | Futures | 5133.57 | 5136.53 | 5128.2 | 5132.5 | 86750.0 |
| 2024-01-02 11:00:00 | ES | Futures | 5132.5 | 5140.82 | 5131.69 | 5139.75 | 79389.0 |
| 2024-01-02 11:30:00 | ES | Futures | 5139.75 | 5150.49 | 5138.68 | 5148.88 | 69542.0 |
| 2024-01-02 12:00:00 | ES | Futures | 5149.15 | 5151.03 | 5144.32 | 5147.0 | 64993.0 |
| 2024-01-02 12:30:00 | ES | Futures | 5147.0 | 5154.25 | 5142.44 | 5142.97 | 58860.0 |
| 2024-01-02 13:00:00 | ES | Futures | 5143.24 | 5146.73 | 5139.21 | 5143.24 | 57692.0 |
| 2024-01-02 13:30:00 | ES | Futures | 5143.24 | 5146.73 | 5136.26 | 5137.6 | 56832.0 |
| 2024-01-02 14:00:00 | ES | Futures | 5137.6 | 5138.94 | 5131.15 | 5134.92 | 59310.0 |
| 2024-01-02 14:30:00 | ES | Futures | 5134.65 | 5136.8 | 5124.44 | 5124.44 | 60966.0 |
| 2024-01-02 15:00:00 | ES | Futures | 5124.44 | 5126.32 | 5119.87 | 5124.44 | 95470.0 |
| 2024-01-02 15:30:00 | ES | Futures | 5124.71 | 5144.58 | 5122.29 | 5144.05 | 186592.0 |
| 2024-01-02 16:00:00 | ES | Futures | 5144.05 | 5145.66 | 5141.09 | 5142.97 | 45465.0 |
| 2024-01-02 16:30:00 | ES | Futures | 5142.97 | 5145.66 | 5142.7 | 5144.58 | 7720.0 |
| 2024-01-02 18:00:00 | ES | Futures | 5147.0 | 5147.0 | 5142.7 | 5143.51 | 3096.0 |
| 2024-01-02 18:30:00 | ES | Futures | 5143.24 | 5144.85 | 5143.24 | 5144.58 | 1260.0 |
| 2024-01-02 19:00:00 | ES | Futures | 5144.85 | 5145.39 | 5143.78 | 5144.58 | 1657.0 |
| 2024-01-02 19:30:00 | ES | Futures | 5144.58 | 5145.12 | 5141.63 | 5142.17 | 2053.0 |
| 2024-01-02 20:00:00 | ES | Futures | 5142.17 | 5143.51 | 5141.09 | 5142.44 | 2746.0 |
| 2024-01-02 20:30:00 | ES | Futures | 5142.44 | 5143.24 | 5141.63 | 5142.17 | 2867.0 |
| 2024-01-02 21:00:00 | ES | Futures | 5142.44 | 5142.97 | 5140.02 | 5140.82 | 2597.0 |
| 2024-01-02 21:30:00 | ES | Futures | 5140.82 | 5141.9 | 5140.02 | 5140.82 | 1765.0 |
| 2024-01-02 22:00:00 | ES | Futures | 5141.09 | 5141.9 | 5140.02 | 5140.29 | 1807.0 |
| 2024-01-02 22:30:00 | ES | Futures | 5140.29 | 5141.63 | 5140.29 | 5140.56 | 1251.0 |
| 2024-01-02 23:00:00 | ES | Futures | 5140.29 | 5140.82 | 5140.02 | 5140.02 | 1659.0 |
| 2024-01-02 23:30:00 | ES | Futures | 5140.02 | 5140.56 | 5138.94 | 5139.21 | 2035.0 |
| 2024-01-02 00:00:00 | NQ | Futures | 18450.66 | 18462.59 | 18449.3 | 18460.42 | 1471.0 |
| 2024-01-02 00:30:00 | NQ | Futures | 18459.88 | 18462.59 | 18458.8 | 18461.24 | 761.0 |
| 2024-01-02 01:00:00 | NQ | Futures | 18460.97 | 18463.14 | 18452.56 | 18455.0 | 884.0 |
| 2024-01-02 01:30:00 | NQ | Futures | 18454.73 | 18457.17 | 18445.24 | 18446.86 | 1212.0 |
> showing 50 of 3,849 rows — these rows as CSV