PREVIEW / futures_1hour / 2021-03-14
file: by_date/futures_1hour/2021/2021-03-14.parquet size: 18 KB rows: 373
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 |
|---|---|---|---|---|---|---|---|
| 2021-03-14 18:00:00 | ES | Futures | 4425.27 | 4431.17 | 4418.8 | 4424.42 | 10442.0 |
| 2021-03-14 19:00:00 | ES | Futures | 4424.42 | 4432.85 | 4424.14 | 4430.04 | 9098.0 |
| 2021-03-14 20:00:00 | ES | Futures | 4430.04 | 4434.26 | 4427.51 | 4430.32 | 9642.0 |
| 2021-03-14 21:00:00 | ES | Futures | 4430.32 | 4436.51 | 4429.76 | 4434.26 | 10604.0 |
| 2021-03-14 22:00:00 | ES | Futures | 4434.26 | 4436.51 | 4426.67 | 4427.8 | 9046.0 |
| 2021-03-14 23:00:00 | ES | Futures | 4427.51 | 4429.2 | 4423.02 | 4425.55 | 6175.0 |
| 2021-03-14 18:00:00 | NQ | Futures | 14976.75 | 15013.8 | 14955.33 | 14983.12 | 3652.0 |
| 2021-03-14 19:00:00 | NQ | Futures | 14981.96 | 15015.54 | 14980.51 | 14997.3 | 3059.0 |
| 2021-03-14 20:00:00 | NQ | Futures | 14997.3 | 15016.99 | 14987.46 | 15014.09 | 3639.0 |
| 2021-03-14 21:00:00 | NQ | Futures | 15014.38 | 15052.89 | 15009.75 | 15044.2 | 5106.0 |
| 2021-03-14 22:00:00 | NQ | Futures | 15043.62 | 15050.57 | 14986.59 | 14994.99 | 4433.0 |
| 2021-03-14 23:00:00 | NQ | Futures | 14994.41 | 15002.22 | 14958.51 | 14979.35 | 4376.0 |
| 2021-03-14 18:00:00 | YM | Futures | 36439.7 | 36502.1 | 36425.2 | 36466.4 | 1764.0 |
| 2021-03-14 19:00:00 | YM | Futures | 36464.2 | 36529.9 | 36463.1 | 36511.0 | 1471.0 |
| 2021-03-14 20:00:00 | YM | Futures | 36512.1 | 36521.0 | 36464.2 | 36483.1 | 1620.0 |
| 2021-03-14 21:00:00 | YM | Futures | 36482.0 | 36522.1 | 36477.6 | 36509.9 | 1555.0 |
| 2021-03-14 22:00:00 | YM | Futures | 36507.6 | 36526.6 | 36474.2 | 36480.9 | 1268.0 |
| 2021-03-14 23:00:00 | YM | Futures | 36478.7 | 36490.9 | 36453.0 | 36462.0 | 1096.0 |
| 2021-03-14 18:00:00 | CL | Futures | 44.46 | 44.75 | 44.46 | 44.72 | 524.0 |
| 2021-03-14 19:00:00 | CL | Futures | 44.72 | 44.89 | 44.7 | 44.75 | 750.0 |
| 2021-03-14 20:00:00 | CL | Futures | 44.75 | 44.76 | 44.65 | 44.69 | 642.0 |
| 2021-03-14 21:00:00 | CL | Futures | 44.68 | 45.06 | 44.68 | 45.01 | 1975.0 |
| 2021-03-14 22:00:00 | CL | Futures | 45.01 | 45.05 | 44.91 | 44.96 | 1179.0 |
| 2021-03-14 23:00:00 | CL | Futures | 44.96 | 45.01 | 44.86 | 44.91 | 1532.0 |
| 2021-03-14 18:00:00 | GC | Futures | 2088.3 | 2092.1 | 2085.7 | 2088.1 | 2072.0 |
| 2021-03-14 19:00:00 | GC | Futures | 2088.3 | 2088.6 | 2083.6 | 2085.2 | 2367.0 |
| 2021-03-14 20:00:00 | GC | Futures | 2085.1 | 2087.9 | 2084.7 | 2087.1 | 2190.0 |
| 2021-03-14 21:00:00 | GC | Futures | 2087.3 | 2095.7 | 2085.6 | 2090.3 | 7971.0 |
| 2021-03-14 22:00:00 | GC | Futures | 2090.2 | 2092.2 | 2084.1 | 2085.4 | 4892.0 |
| 2021-03-14 23:00:00 | GC | Futures | 2085.6 | 2087.5 | 2084.7 | 2087.3 | 2228.0 |
| 2021-03-14 18:00:00 | ZN | Futures | 133.153961 | 133.185529 | 133.090825 | 133.106609 | 18723.0 |
| 2021-03-14 19:00:00 | ZN | Futures | 133.106609 | 133.122393 | 133.090825 | 133.106609 | 11993.0 |
| 2021-03-14 20:00:00 | ZN | Futures | 133.122393 | 133.248665 | 133.122393 | 133.248665 | 27198.0 |
| 2021-03-14 21:00:00 | ZN | Futures | 133.248665 | 133.359153 | 133.232881 | 133.232881 | 35790.0 |
| 2021-03-14 22:00:00 | ZN | Futures | 133.248665 | 133.248665 | 133.090825 | 133.106609 | 32776.0 |
| 2021-03-14 23:00:00 | ZN | Futures | 133.106609 | 133.122393 | 133.059257 | 133.090825 | 18591.0 |
> showing 36 of 373 rows — these rows as CSV