PREVIEW / futures_1hour / 2024-01-09
file: by_date/futures_1hour/2024/2024-01-09.parquet size: 67 KB rows: 2,089
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-09 00:00:00 | ES | Futures | 5152.91 | 5153.45 | 5150.76 | 5151.3 | 3123.0 |
| 2024-01-09 01:00:00 | ES | Futures | 5151.3 | 5153.99 | 5150.49 | 5152.91 | 4704.0 |
| 2024-01-09 02:00:00 | ES | Futures | 5152.91 | 5152.91 | 5149.96 | 5150.22 | 7754.0 |
| 2024-01-09 03:00:00 | ES | Futures | 5150.22 | 5150.22 | 5142.97 | 5144.85 | 21961.0 |
| 2024-01-09 04:00:00 | ES | Futures | 5144.85 | 5146.2 | 5138.68 | 5144.32 | 19078.0 |
| 2024-01-09 05:00:00 | ES | Futures | 5144.32 | 5145.39 | 5140.56 | 5142.44 | 14089.0 |
| 2024-01-09 06:00:00 | ES | Futures | 5142.17 | 5143.51 | 5132.5 | 5134.11 | 18137.0 |
| 2024-01-09 07:00:00 | ES | Futures | 5134.38 | 5141.36 | 5132.5 | 5140.29 | 21459.0 |
| 2024-01-09 08:00:00 | ES | Futures | 5140.02 | 5140.56 | 5128.47 | 5129.01 | 40110.0 |
| 2024-01-09 09:00:00 | ES | Futures | 5129.27 | 5131.42 | 5122.02 | 5130.89 | 191896.0 |
| 2024-01-09 10:00:00 | ES | Futures | 5130.62 | 5139.48 | 5124.17 | 5131.69 | 175566.0 |
| 2024-01-09 11:00:00 | ES | Futures | 5131.69 | 5153.45 | 5131.15 | 5153.45 | 125876.0 |
| 2024-01-09 12:00:00 | ES | Futures | 5153.45 | 5156.13 | 5149.15 | 5155.06 | 91879.0 |
| 2024-01-09 13:00:00 | ES | Futures | 5154.79 | 5161.24 | 5141.63 | 5154.25 | 150991.0 |
| 2024-01-09 14:00:00 | ES | Futures | 5154.25 | 5157.21 | 5144.05 | 5148.88 | 107007.0 |
| 2024-01-09 15:00:00 | ES | Futures | 5148.88 | 5153.99 | 5139.48 | 5149.42 | 235371.0 |
| 2024-01-09 16:00:00 | ES | Futures | 5149.42 | 5151.3 | 5145.93 | 5146.73 | 39710.0 |
| 2024-01-09 18:00:00 | ES | Futures | 5147.0 | 5148.88 | 5143.78 | 5148.34 | 4711.0 |
| 2024-01-09 19:00:00 | ES | Futures | 5148.61 | 5151.57 | 5147.81 | 5148.88 | 5370.0 |
| 2024-01-09 20:00:00 | ES | Futures | 5149.15 | 5149.42 | 5145.93 | 5147.27 | 6539.0 |
| 2024-01-09 21:00:00 | ES | Futures | 5147.54 | 5148.61 | 5145.66 | 5147.81 | 3781.0 |
| 2024-01-09 22:00:00 | ES | Futures | 5147.81 | 5148.34 | 5143.51 | 5144.85 | 5317.0 |
| 2024-01-09 23:00:00 | ES | Futures | 5144.85 | 5147.27 | 5144.32 | 5144.85 | 3305.0 |
| 2024-01-09 00:00:00 | NQ | Futures | 18205.22 | 18209.02 | 18195.73 | 18198.71 | 2431.0 |
| 2024-01-09 01:00:00 | NQ | Futures | 18198.44 | 18212.0 | 18195.18 | 18208.47 | 3137.0 |
| 2024-01-09 02:00:00 | NQ | Futures | 18208.47 | 18208.47 | 18187.32 | 18188.95 | 4224.0 |
| 2024-01-09 03:00:00 | NQ | Futures | 18188.95 | 18189.76 | 18156.4 | 18166.44 | 8402.0 |
| 2024-01-09 04:00:00 | NQ | Futures | 18166.71 | 18175.12 | 18137.69 | 18160.74 | 9155.0 |
| 2024-01-09 05:00:00 | NQ | Futures | 18160.47 | 18162.64 | 18140.4 | 18149.35 | 6617.0 |
| 2024-01-09 06:00:00 | NQ | Futures | 18149.35 | 18156.13 | 18098.91 | 18110.3 | 9510.0 |
| 2024-01-09 07:00:00 | NQ | Futures | 18110.57 | 18144.2 | 18104.06 | 18141.76 | 12801.0 |
| 2024-01-09 08:00:00 | NQ | Futures | 18141.49 | 18142.03 | 18070.7 | 18079.11 | 23345.0 |
| 2024-01-09 09:00:00 | NQ | Futures | 18078.84 | 18132.27 | 18073.68 | 18121.96 | 87884.0 |
| 2024-01-09 10:00:00 | NQ | Futures | 18121.96 | 18172.67 | 18098.36 | 18153.15 | 80531.0 |
| 2024-01-09 11:00:00 | NQ | Futures | 18153.15 | 18261.36 | 18152.33 | 18260.55 | 67747.0 |
| 2024-01-09 12:00:00 | NQ | Futures | 18260.0 | 18277.63 | 18240.2 | 18274.65 | 50316.0 |
| 2024-01-09 13:00:00 | NQ | Futures | 18274.65 | 18299.33 | 18223.39 | 18269.22 | 65742.0 |
| 2024-01-09 14:00:00 | NQ | Futures | 18269.22 | 18285.77 | 18231.53 | 18255.93 | 48051.0 |
| 2024-01-09 15:00:00 | NQ | Futures | 18255.66 | 18271.66 | 18199.52 | 18259.46 | 90540.0 |
| 2024-01-09 16:00:00 | NQ | Futures | 18259.46 | 18266.24 | 18253.22 | 18257.02 | 10470.0 |
| 2024-01-09 18:00:00 | NQ | Futures | 18257.02 | 18267.6 | 18242.92 | 18265.97 | 3166.0 |
| 2024-01-09 19:00:00 | NQ | Futures | 18266.24 | 18280.07 | 18260.82 | 18265.43 | 4408.0 |
| 2024-01-09 20:00:00 | NQ | Futures | 18265.97 | 18266.78 | 18250.51 | 18262.44 | 3586.0 |
| 2024-01-09 21:00:00 | NQ | Futures | 18262.71 | 18270.04 | 18255.93 | 18264.88 | 2901.0 |
| 2024-01-09 22:00:00 | NQ | Futures | 18265.16 | 18266.24 | 18249.15 | 18252.95 | 2291.0 |
| 2024-01-09 23:00:00 | NQ | Futures | 18252.95 | 18263.8 | 18251.87 | 18255.12 | 2008.0 |
| 2024-01-09 00:00:00 | YM | Futures | 40687.1 | 40690.4 | 40677.5 | 40678.5 | 330.0 |
| 2024-01-09 01:00:00 | YM | Futures | 40678.5 | 40693.6 | 40676.4 | 40686.1 | 628.0 |
| 2024-01-09 02:00:00 | YM | Futures | 40685.0 | 40685.0 | 40666.7 | 40670.0 | 1344.0 |
| 2024-01-09 03:00:00 | YM | Futures | 40671.0 | 40673.2 | 40607.7 | 40622.7 | 3209.0 |
> showing 50 of 2,089 rows — these rows as CSV