PREVIEW / futures_1hour / 2023-07-23
file: by_date/futures_1hour/2023/2023-07-23.parquet size: 18 KB rows: 400
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 |
|---|---|---|---|---|---|---|---|
| 2023-07-23 18:00:00 | ES | Futures | 5011.75 | 5014.5 | 5008.46 | 5008.74 | 6607.0 |
| 2023-07-23 19:00:00 | ES | Futures | 5008.74 | 5009.83 | 5007.09 | 5008.46 | 5229.0 |
| 2023-07-23 20:00:00 | ES | Futures | 5008.46 | 5013.13 | 5007.36 | 5010.66 | 6259.0 |
| 2023-07-23 21:00:00 | ES | Futures | 5010.93 | 5012.03 | 5007.09 | 5010.38 | 7153.0 |
| 2023-07-23 22:00:00 | ES | Futures | 5010.38 | 5014.23 | 5009.28 | 5012.58 | 5569.0 |
| 2023-07-23 23:00:00 | ES | Futures | 5012.58 | 5013.4 | 5010.11 | 5010.93 | 3696.0 |
| 2023-07-23 18:00:00 | NQ | Futures | 17306.43 | 17323.12 | 17292.8 | 17296.14 | 4142.0 |
| 2023-07-23 19:00:00 | NQ | Futures | 17296.14 | 17301.98 | 17288.63 | 17299.48 | 2855.0 |
| 2023-07-23 20:00:00 | NQ | Futures | 17298.64 | 17316.44 | 17288.08 | 17306.43 | 4183.0 |
| 2023-07-23 21:00:00 | NQ | Futures | 17306.43 | 17310.88 | 17280.29 | 17294.75 | 5179.0 |
| 2023-07-23 22:00:00 | NQ | Futures | 17295.03 | 17321.45 | 17291.97 | 17307.27 | 4137.0 |
| 2023-07-23 23:00:00 | NQ | Futures | 17306.99 | 17309.77 | 17292.25 | 17295.58 | 2389.0 |
| 2023-07-23 18:00:00 | YM | Futures | 38779.0 | 38780.1 | 38739.6 | 38740.7 | 1128.0 |
| 2023-07-23 19:00:00 | YM | Futures | 38740.7 | 38746.1 | 38728.6 | 38734.1 | 777.0 |
| 2023-07-23 20:00:00 | YM | Futures | 38733.0 | 38764.8 | 38729.7 | 38749.4 | 1328.0 |
| 2023-07-23 21:00:00 | YM | Futures | 38749.4 | 38759.3 | 38728.6 | 38747.2 | 1047.0 |
| 2023-07-23 22:00:00 | YM | Futures | 38747.2 | 38770.2 | 38740.7 | 38764.8 | 814.0 |
| 2023-07-23 23:00:00 | YM | Futures | 38764.8 | 38774.6 | 38750.5 | 38760.4 | 757.0 |
| 2023-07-23 18:00:00 | CL | Futures | 62.63 | 62.64 | 62.3 | 62.3 | 1606.0 |
| 2023-07-23 19:00:00 | CL | Futures | 62.3 | 62.37 | 62.27 | 62.29 | 914.0 |
| 2023-07-23 20:00:00 | CL | Futures | 62.29 | 62.39 | 62.26 | 62.39 | 1622.0 |
| 2023-07-23 21:00:00 | CL | Futures | 62.39 | 62.44 | 62.27 | 62.35 | 3494.0 |
| 2023-07-23 22:00:00 | CL | Futures | 62.35 | 62.55 | 62.31 | 62.54 | 2181.0 |
| 2023-07-23 23:00:00 | CL | Futures | 62.53 | 62.66 | 62.48 | 62.59 | 2879.0 |
| 2023-07-23 18:00:00 | GC | Futures | 2236.8 | 2238.2 | 2236.4 | 2236.9 | 861.0 |
| 2023-07-23 19:00:00 | GC | Futures | 2236.9 | 2237.2 | 2235.2 | 2236.1 | 966.0 |
| 2023-07-23 20:00:00 | GC | Futures | 2236.1 | 2236.9 | 2234.6 | 2236.7 | 1991.0 |
| 2023-07-23 21:00:00 | GC | Futures | 2236.8 | 2237.8 | 2233.7 | 2236.4 | 2841.0 |
| 2023-07-23 22:00:00 | GC | Futures | 2236.3 | 2237.0 | 2234.7 | 2235.3 | 2001.0 |
| 2023-07-23 23:00:00 | GC | Futures | 2235.2 | 2236.7 | 2234.4 | 2234.6 | 1604.0 |
| 2023-07-23 18:00:00 | ZN | Futures | 114.45911 | 114.475043 | 114.411313 | 114.427245 | 4611.0 |
| 2023-07-23 19:00:00 | ZN | Futures | 114.443178 | 114.443178 | 114.347583 | 114.363515 | 7038.0 |
| 2023-07-23 20:00:00 | ZN | Futures | 114.379448 | 114.39538 | 114.347583 | 114.347583 | 5851.0 |
| 2023-07-23 21:00:00 | ZN | Futures | 114.347583 | 114.39538 | 114.347583 | 114.347583 | 7324.0 |
| 2023-07-23 22:00:00 | ZN | Futures | 114.347583 | 114.39538 | 114.315718 | 114.379448 | 8807.0 |
| 2023-07-23 23:00:00 | ZN | Futures | 114.379448 | 114.39538 | 114.347583 | 114.379448 | 4184.0 |
> showing 36 of 400 rows — these rows as CSV