PREVIEW / futures_30min / 2024-01-17
file: by_date/futures_30min/2024/2024-01-17.parquet size: 112 KB rows: 4,022
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-17 00:00:00 | ES | Futures | 5145.66 | 5145.66 | 5141.36 | 5142.7 | 2353.0 |
| 2024-01-17 00:30:00 | ES | Futures | 5142.44 | 5143.24 | 5140.02 | 5140.02 | 3698.0 |
| 2024-01-17 01:00:00 | ES | Futures | 5140.02 | 5141.09 | 5130.08 | 5133.3 | 13987.0 |
| 2024-01-17 01:30:00 | ES | Futures | 5133.57 | 5134.11 | 5130.08 | 5131.15 | 7524.0 |
| 2024-01-17 02:00:00 | ES | Futures | 5131.15 | 5132.5 | 5125.78 | 5126.59 | 11803.0 |
| 2024-01-17 02:30:00 | ES | Futures | 5126.59 | 5132.5 | 5125.51 | 5130.89 | 9745.0 |
| 2024-01-17 03:00:00 | ES | Futures | 5130.89 | 5133.84 | 5127.39 | 5133.3 | 18574.0 |
| 2024-01-17 03:30:00 | ES | Futures | 5133.3 | 5133.84 | 5128.2 | 5128.47 | 12691.0 |
| 2024-01-17 04:00:00 | ES | Futures | 5128.47 | 5132.5 | 5123.37 | 5129.27 | 16404.0 |
| 2024-01-17 04:30:00 | ES | Futures | 5129.01 | 5133.84 | 5128.2 | 5132.77 | 8914.0 |
| 2024-01-17 05:00:00 | ES | Futures | 5133.03 | 5135.18 | 5130.89 | 5131.15 | 8726.0 |
| 2024-01-17 05:30:00 | ES | Futures | 5131.15 | 5132.23 | 5127.93 | 5131.69 | 7029.0 |
| 2024-01-17 06:00:00 | ES | Futures | 5131.96 | 5133.3 | 5127.13 | 5131.42 | 7687.0 |
| 2024-01-17 06:30:00 | ES | Futures | 5131.15 | 5136.26 | 5130.62 | 5134.65 | 8519.0 |
| 2024-01-17 07:00:00 | ES | Futures | 5134.65 | 5141.09 | 5133.57 | 5139.48 | 14732.0 |
| 2024-01-17 07:30:00 | ES | Futures | 5139.75 | 5139.75 | 5135.45 | 5136.26 | 10472.0 |
| 2024-01-17 08:00:00 | ES | Futures | 5136.53 | 5136.53 | 5130.62 | 5132.5 | 15509.0 |
| 2024-01-17 08:30:00 | ES | Futures | 5131.96 | 5133.03 | 5120.14 | 5122.56 | 59834.0 |
| 2024-01-17 09:00:00 | ES | Futures | 5122.56 | 5126.59 | 5119.07 | 5120.68 | 40910.0 |
| 2024-01-17 09:30:00 | ES | Futures | 5120.41 | 5121.75 | 5111.82 | 5115.31 | 198686.0 |
| 2024-01-17 10:00:00 | ES | Futures | 5115.04 | 5125.51 | 5112.08 | 5120.68 | 144233.0 |
| 2024-01-17 10:30:00 | ES | Futures | 5120.41 | 5126.32 | 5116.92 | 5122.56 | 105404.0 |
| 2024-01-17 11:00:00 | ES | Futures | 5122.83 | 5130.89 | 5122.29 | 5127.93 | 102682.0 |
| 2024-01-17 11:30:00 | ES | Futures | 5128.2 | 5130.89 | 5123.9 | 5124.44 | 63167.0 |
| 2024-01-17 12:00:00 | ES | Futures | 5124.44 | 5125.78 | 5116.11 | 5117.46 | 64532.0 |
| 2024-01-17 12:30:00 | ES | Futures | 5117.46 | 5122.02 | 5112.89 | 5118.8 | 60808.0 |
| 2024-01-17 13:00:00 | ES | Futures | 5118.8 | 5123.1 | 5105.64 | 5108.06 | 74949.0 |
| 2024-01-17 13:30:00 | ES | Futures | 5108.32 | 5109.4 | 5099.19 | 5107.79 | 78393.0 |
| 2024-01-17 14:00:00 | ES | Futures | 5107.79 | 5116.11 | 5106.44 | 5113.97 | 58414.0 |
| 2024-01-17 14:30:00 | ES | Futures | 5114.23 | 5119.87 | 5113.7 | 5116.65 | 59811.0 |
| 2024-01-17 15:00:00 | ES | Futures | 5116.92 | 5117.73 | 5108.06 | 5110.47 | 58639.0 |
| 2024-01-17 15:30:00 | ES | Futures | 5110.47 | 5129.27 | 5109.94 | 5125.78 | 156774.0 |
| 2024-01-17 16:00:00 | ES | Futures | 5125.51 | 5126.86 | 5123.1 | 5123.9 | 44458.0 |
| 2024-01-17 16:30:00 | ES | Futures | 5123.63 | 5124.71 | 5123.37 | 5123.9 | 6310.0 |
| 2024-01-17 18:00:00 | ES | Futures | 5122.56 | 5126.05 | 5119.34 | 5125.25 | 6100.0 |
| 2024-01-17 18:30:00 | ES | Futures | 5125.25 | 5125.51 | 5123.1 | 5124.44 | 2234.0 |
| 2024-01-17 19:00:00 | ES | Futures | 5124.44 | 5125.51 | 5121.75 | 5123.1 | 3301.0 |
| 2024-01-17 19:30:00 | ES | Futures | 5123.37 | 5126.32 | 5123.1 | 5126.05 | 3309.0 |
| 2024-01-17 20:00:00 | ES | Futures | 5126.32 | 5126.59 | 5123.9 | 5124.71 | 4302.0 |
| 2024-01-17 20:30:00 | ES | Futures | 5124.98 | 5125.25 | 5121.49 | 5124.98 | 3485.0 |
| 2024-01-17 21:00:00 | ES | Futures | 5124.71 | 5126.32 | 5124.44 | 5125.51 | 2025.0 |
| 2024-01-17 21:30:00 | ES | Futures | 5125.25 | 5125.51 | 5122.02 | 5122.83 | 1993.0 |
| 2024-01-17 22:00:00 | ES | Futures | 5123.1 | 5124.44 | 5122.02 | 5123.1 | 3121.0 |
| 2024-01-17 22:30:00 | ES | Futures | 5123.37 | 5124.98 | 5120.41 | 5120.68 | 2237.0 |
| 2024-01-17 23:00:00 | ES | Futures | 5120.68 | 5121.49 | 5119.34 | 5120.14 | 2354.0 |
| 2024-01-17 23:30:00 | ES | Futures | 5120.14 | 5121.22 | 5117.73 | 5120.14 | 2886.0 |
| 2024-01-17 00:00:00 | NQ | Futures | 18356.82 | 18357.09 | 18337.3 | 18342.72 | 2257.0 |
| 2024-01-17 00:30:00 | NQ | Futures | 18342.99 | 18342.99 | 18325.09 | 18326.18 | 2626.0 |
| 2024-01-17 01:00:00 | NQ | Futures | 18326.18 | 18326.18 | 18271.12 | 18280.61 | 7547.0 |
| 2024-01-17 01:30:00 | NQ | Futures | 18280.61 | 18285.22 | 18261.9 | 18271.94 | 4795.0 |
> showing 50 of 4,022 rows — these rows as CSV