PREVIEW / futures_1hour / 2021-11-07
file: by_date/futures_1hour/2021/2021-11-07.parquet size: 19 KB rows: 403
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-11-07 18:00:00 | ES | Futures | 5281.32 | 5294.02 | 5280.76 | 5288.1 | 13759.0 |
| 2021-11-07 19:00:00 | ES | Futures | 5288.1 | 5288.94 | 5282.17 | 5284.14 | 8392.0 |
| 2021-11-07 20:00:00 | ES | Futures | 5284.43 | 5288.38 | 5278.78 | 5281.32 | 9834.0 |
| 2021-11-07 21:00:00 | ES | Futures | 5281.04 | 5284.71 | 5279.91 | 5283.3 | 5726.0 |
| 2021-11-07 22:00:00 | ES | Futures | 5283.58 | 5284.43 | 5282.45 | 5283.02 | 3169.0 |
| 2021-11-07 23:00:00 | ES | Futures | 5283.02 | 5284.14 | 5281.61 | 5282.73 | 3635.0 |
| 2021-11-07 18:00:00 | NQ | Futures | 18887.96 | 18936.36 | 18845.07 | 18910.57 | 8724.0 |
| 2021-11-07 19:00:00 | NQ | Futures | 18910.57 | 18916.66 | 18881.59 | 18892.89 | 4550.0 |
| 2021-11-07 20:00:00 | NQ | Futures | 18892.89 | 18912.02 | 18869.99 | 18878.4 | 5628.0 |
| 2021-11-07 21:00:00 | NQ | Futures | 18877.82 | 18886.8 | 18863.91 | 18876.08 | 3307.0 |
| 2021-11-07 22:00:00 | NQ | Futures | 18876.37 | 18884.49 | 18872.89 | 18878.69 | 1597.0 |
| 2021-11-07 23:00:00 | NQ | Futures | 18878.69 | 18892.02 | 18875.79 | 18880.43 | 1532.0 |
| 2021-11-07 18:00:00 | YM | Futures | 40500.6 | 40639.6 | 40490.5 | 40573.5 | 2897.0 |
| 2021-11-07 19:00:00 | YM | Futures | 40575.7 | 40588.1 | 40543.2 | 40560.0 | 1494.0 |
| 2021-11-07 20:00:00 | YM | Futures | 40560.0 | 40592.5 | 40525.3 | 40547.7 | 1468.0 |
| 2021-11-07 21:00:00 | YM | Futures | 40544.3 | 40578.0 | 40543.2 | 40567.9 | 592.0 |
| 2021-11-07 22:00:00 | YM | Futures | 40569.0 | 40574.6 | 40552.2 | 40556.7 | 443.0 |
| 2021-11-07 23:00:00 | YM | Futures | 40558.9 | 40560.0 | 40541.0 | 40551.1 | 458.0 |
| 2021-11-07 18:00:00 | CL | Futures | 56.7 | 57.14 | 56.65 | 56.98 | 5254.0 |
| 2021-11-07 19:00:00 | CL | Futures | 56.98 | 57.26 | 56.95 | 57.23 | 3999.0 |
| 2021-11-07 20:00:00 | CL | Futures | 57.24 | 57.64 | 57.19 | 57.42 | 13843.0 |
| 2021-11-07 21:00:00 | CL | Futures | 57.42 | 57.6 | 57.36 | 57.52 | 5461.0 |
| 2021-11-07 22:00:00 | CL | Futures | 57.53 | 57.55 | 57.43 | 57.48 | 2918.0 |
| 2021-11-07 23:00:00 | CL | Futures | 57.48 | 57.5 | 57.39 | 57.48 | 1832.0 |
| 2021-11-07 18:00:00 | GC | Futures | 2191.6 | 2191.7 | 2187.0 | 2187.9 | 3769.0 |
| 2021-11-07 19:00:00 | GC | Futures | 2187.9 | 2188.4 | 2184.3 | 2185.1 | 2907.0 |
| 2021-11-07 20:00:00 | GC | Futures | 2185.2 | 2194.5 | 2185.0 | 2188.4 | 10631.0 |
| 2021-11-07 21:00:00 | GC | Futures | 2188.5 | 2193.2 | 2188.5 | 2192.1 | 4639.0 |
| 2021-11-07 22:00:00 | GC | Futures | 2192.0 | 2192.7 | 2189.9 | 2191.7 | 2254.0 |
| 2021-11-07 23:00:00 | GC | Futures | 2191.7 | 2193.8 | 2191.1 | 2192.9 | 2431.0 |
| 2021-11-07 18:00:00 | ZN | Futures | 134.569388 | 134.649204 | 134.521498 | 134.617277 | 26227.0 |
| 2021-11-07 19:00:00 | ZN | Futures | 134.617277 | 134.63324 | 134.489572 | 134.521498 | 26356.0 |
| 2021-11-07 20:00:00 | ZN | Futures | 134.521498 | 134.537462 | 134.441683 | 134.505535 | 22851.0 |
| 2021-11-07 21:00:00 | ZN | Futures | 134.505535 | 134.569388 | 134.457646 | 134.457646 | 22290.0 |
| 2021-11-07 22:00:00 | ZN | Futures | 134.457646 | 134.505535 | 134.441683 | 134.505535 | 12491.0 |
| 2021-11-07 23:00:00 | ZN | Futures | 134.505535 | 134.553425 | 134.489572 | 134.553425 | 8040.0 |
> showing 36 of 403 rows — these rows as CSV