PREVIEW / futures_1hour / 2022-11-18
file: by_date/futures_1hour/2022/2022-11-18.parquet size: 56 KB rows: 1,632
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-18 00:00:00 | ES | Futures | 4459.27 | 4462.09 | 4453.92 | 4456.74 | 6297.0 |
| 2022-11-18 01:00:00 | ES | Futures | 4456.74 | 4458.99 | 4448.28 | 4455.05 | 7263.0 |
| 2022-11-18 02:00:00 | ES | Futures | 4455.33 | 4461.25 | 4453.64 | 4455.61 | 8971.0 |
| 2022-11-18 03:00:00 | ES | Futures | 4455.89 | 4463.22 | 4446.59 | 4462.94 | 20902.0 |
| 2022-11-18 04:00:00 | ES | Futures | 4462.94 | 4481.83 | 4460.68 | 4472.24 | 27062.0 |
| 2022-11-18 05:00:00 | ES | Futures | 4472.24 | 4490.28 | 4469.14 | 4488.59 | 23237.0 |
| 2022-11-18 06:00:00 | ES | Futures | 4488.87 | 4490.85 | 4483.8 | 4486.9 | 16326.0 |
| 2022-11-18 07:00:00 | ES | Futures | 4486.62 | 4497.05 | 4485.77 | 4491.13 | 24624.0 |
| 2022-11-18 08:00:00 | ES | Futures | 4490.85 | 4503.53 | 4488.87 | 4500.43 | 44018.0 |
| 2022-11-18 09:00:00 | ES | Futures | 4500.43 | 4503.53 | 4474.22 | 4477.03 | 219256.0 |
| 2022-11-18 10:00:00 | ES | Futures | 4477.03 | 4479.01 | 4459.56 | 4462.94 | 199939.0 |
| 2022-11-18 11:00:00 | ES | Futures | 4463.22 | 4479.29 | 4457.3 | 4469.42 | 159818.0 |
| 2022-11-18 12:00:00 | ES | Futures | 4469.42 | 4471.4 | 4445.46 | 4454.76 | 141171.0 |
| 2022-11-18 13:00:00 | ES | Futures | 4454.76 | 4466.32 | 4449.41 | 4455.05 | 120892.0 |
| 2022-11-18 14:00:00 | ES | Futures | 4455.05 | 4466.32 | 4454.48 | 4464.63 | 103620.0 |
| 2022-11-18 15:00:00 | ES | Futures | 4464.63 | 4490.85 | 4463.79 | 4480.13 | 248269.0 |
| 2022-11-18 16:00:00 | ES | Futures | 4479.85 | 4481.83 | 4472.52 | 4478.16 | 55099.0 |
| 2022-11-18 00:00:00 | NQ | Futures | 13475.58 | 13485.35 | 13454.32 | 13464.38 | 3076.0 |
| 2022-11-18 01:00:00 | NQ | Futures | 13464.95 | 13473.57 | 13429.61 | 13454.9 | 4907.0 |
| 2022-11-18 02:00:00 | NQ | Futures | 13454.61 | 13479.32 | 13448.0 | 13456.62 | 5900.0 |
| 2022-11-18 03:00:00 | NQ | Futures | 13456.62 | 13474.43 | 13414.96 | 13474.15 | 10430.0 |
| 2022-11-18 04:00:00 | NQ | Futures | 13473.57 | 13537.07 | 13464.67 | 13505.75 | 12711.0 |
| 2022-11-18 05:00:00 | NQ | Futures | 13505.75 | 13578.45 | 13494.55 | 13572.13 | 9906.0 |
| 2022-11-18 06:00:00 | NQ | Futures | 13572.41 | 13584.77 | 13550.58 | 13560.92 | 7951.0 |
| 2022-11-18 07:00:00 | NQ | Futures | 13560.92 | 13603.16 | 13557.76 | 13575.57 | 10322.0 |
| 2022-11-18 08:00:00 | NQ | Futures | 13575.57 | 13611.2 | 13567.53 | 13600.0 | 17285.0 |
| 2022-11-18 09:00:00 | NQ | Futures | 13599.71 | 13611.2 | 13487.65 | 13508.05 | 83067.0 |
| 2022-11-18 10:00:00 | NQ | Futures | 13508.34 | 13513.51 | 13395.99 | 13415.53 | 86142.0 |
| 2022-11-18 11:00:00 | NQ | Futures | 13415.25 | 13466.1 | 13383.64 | 13425.3 | 63564.0 |
| 2022-11-18 12:00:00 | NQ | Futures | 13425.01 | 13436.22 | 13339.97 | 13369.27 | 58514.0 |
| 2022-11-18 13:00:00 | NQ | Futures | 13370.14 | 13419.56 | 13362.09 | 13381.92 | 48081.0 |
| 2022-11-18 14:00:00 | NQ | Futures | 13381.92 | 13416.11 | 13373.87 | 13409.5 | 39354.0 |
| 2022-11-18 15:00:00 | NQ | Futures | 13410.07 | 13494.26 | 13407.2 | 13455.47 | 79819.0 |
| 2022-11-18 16:00:00 | NQ | Futures | 13455.47 | 13471.85 | 13446.28 | 13459.49 | 16074.0 |
| 2022-11-18 00:00:00 | YM | Futures | 37627.4 | 37646.5 | 37593.7 | 37618.4 | 1139.0 |
| 2022-11-18 01:00:00 | YM | Futures | 37617.3 | 37634.1 | 37560.0 | 37610.5 | 1281.0 |
| 2022-11-18 02:00:00 | YM | Futures | 37610.5 | 37655.4 | 37594.8 | 37621.8 | 2236.0 |
| 2022-11-18 03:00:00 | YM | Futures | 37622.9 | 37681.2 | 37561.2 | 37676.8 | 2897.0 |
| 2022-11-18 04:00:00 | YM | Futures | 37677.9 | 37837.2 | 37666.7 | 37745.2 | 5128.0 |
| 2022-11-18 05:00:00 | YM | Futures | 37745.2 | 37865.3 | 37723.9 | 37856.3 | 4086.0 |
| 2022-11-18 06:00:00 | YM | Futures | 37858.6 | 37869.8 | 37820.4 | 37845.1 | 2484.0 |
| 2022-11-18 07:00:00 | YM | Futures | 37845.1 | 37914.7 | 37839.5 | 37870.9 | 3407.0 |
| 2022-11-18 08:00:00 | YM | Futures | 37872.0 | 37966.3 | 37860.8 | 37949.5 | 5714.0 |
| 2022-11-18 09:00:00 | YM | Futures | 37947.2 | 37993.2 | 37776.6 | 37794.6 | 25642.0 |
| 2022-11-18 10:00:00 | YM | Futures | 37796.8 | 37866.4 | 37714.9 | 37780.0 | 21200.0 |
| 2022-11-18 11:00:00 | YM | Futures | 37781.1 | 37928.1 | 37741.8 | 37863.0 | 18429.0 |
| 2022-11-18 12:00:00 | YM | Futures | 37861.9 | 37870.9 | 37663.3 | 37734.0 | 15452.0 |
| 2022-11-18 13:00:00 | YM | Futures | 37735.1 | 37820.4 | 37684.6 | 37723.9 | 10905.0 |
| 2022-11-18 14:00:00 | YM | Futures | 37725.0 | 37803.6 | 37717.2 | 37774.4 | 9167.0 |
| 2022-11-18 15:00:00 | YM | Futures | 37776.6 | 37979.8 | 37772.1 | 37902.3 | 21684.0 |
> showing 50 of 1,632 rows — these rows as CSV